Import error of phoneNumbers

[ctheuring]

I didn't understand this:

error during import
typ validation - validation error
fon/fax-number is valid
shows ... 04821 771 274
- 1527 errors with the same type of error and 28.785 numbers well imported

it is valid (you can see there is nothing else than numbers and blanks) , but it trows an error ??? ... and didn't import this data.
... and the database field is wide enough: varchar 36
... and my csv-file is UTF8
... and my csv-file is 1.6 mb
... and it needs nearly 30 minutes to import 30.343 rows with only 1 field (fax-number) (search in 40.821 data-rows)
Something going wrong ...

Christoph

[ctheuring]

I thought I've found the "bug" (with know-how in database programming and try-and-error)
There must be anywhere a validation of the length of the prefix number - found at the first space in the phoneNumber.
So I replaced all spaces with a '-' -> and no errors :-)
Somebody knows the place in the code where this validation is declaired?
Christoph
P.S.
it's possible to import office-number and fax-number in one import-run:
the csv-file must have 2 columns (here: office-number, fax-number) and each of them must be linked to the corresponding type see screenshot attached. The FIRST column is the first row in details-view - here phoneNumber (Zentrale)

[ctheuring]

Hello,
Question again:
Somebody knows the place in the code where this validation is declaired?

Christoph

[Vadym]

Hi ctheuring,

Perhaps the following threads will be helpful:

https://www.espocrm.com/tips/import-export

https://docs.espocrm.com/administration/import/#validation

https://forum.espocrm.com/forum/developer-help/developer-tutorials/88484-how-to-disable-back-end-field-validation-to-avoid-the-field-validation-error