Import CSV to data table does not work with my file

Data Service
1

Some help needed. :slightly_smiling_face:

I have seen some posts regarding to this topic and tried already everything that comes to my mind.
I want to import a file with many relations to existing databases. My import file contains the objectIds of the related fields already available in the Database. I received different errors and changed my file accordingly. At the end of the process it is now the message “Invalid file”. Now I don’t understand it anymore.

2

Hi @Jorg_Beyer

could you please provide your appId?

3

AppID A2090C1B-936C-A876-FF32-277A55A60700
I uploaded the file into import folder - and some of my date fields seem not to be correct, but the same format was applied

4

according to the log file IMPORT_DATA2022_06_28_08_22_19.log I do not see any errors

5

I can see some errors in that file with a date field.
08:22:20 IMPORT_DATA Ignores rows with values [WAHR, 30.12.2021, null, , 30.12.2021, Kontaktperson, Kontaktperson 0a417LastName, 0a417LastName, 0a417de0-69a4-11ec-be78-73ec2aa50e74, 846E4C50-07E9-4F9A-98AD-114B30074590, null, , , 3D06B909-DAE6-43B7-9A2E-80D833316673, D1227A7A-04E7-4A31-8635-23215610B3BA, 9D876514-63ED-4E16-8A50-6FE6C48658CB, 64FF6C8A-8CBD-4CBE-A802-BF0FAB2073DD]. Invalid date format

You cannot see any import errors because the actual file was never imported as indicated by the error: invalid file.

6

We just found there are empty columns ,, in the header, that’s why the server refuses the file, could you please remove them try to import it again

7

Thank you for the help. This is a strange Excel behaviour saving a file as CSV. But, now it is working.

8

I cannot get my head around this error in my import file. It says invalid date format. But all 1350 records look the same to me. Why are 544 records imported and not the remaining records.

08:49:50 IMPORT_DATA Ignores rows with values [WAHR, 30.12.2021, null, , 30.12.2021, Kontaktperson, Kontaktperson 0a417LastName, 0a417LastName, 0a417de0-69a4-11ec-be78-73ec2aa50e74, 789840DD-2E4B-42B2-BB42-0E3B50727E62, null, , , 3D06B909-DAE6-43B7-9A2E-80D833316673, D1227A7A-04E7-4A31-8635-23215610B3BA, 9D876514-63ED-4E16-8A50-6FE6C48658CB, 64FF6C8A-8CBD-4CBE-A802-BF0FAB2073DD, ]. Invalid date format

9

Could you please narrow it down to one sample row that’s not imported and create a sample CSV file to share with us?

10

ContactNewKommaExcerpt.csv (2.2 KB)

This should be the first ignored record.

11

I see there are several relation columns. Do the referenced objects in the related tables exist?

12

Yes, completely checked

13

What is the name of the table which you import this data to?

14

Same as file name for testing purposes

15

Looks like the date format in the import is expected to follow the US standard:

mm.dd.yyyy

I changed the dates to 12.30.2021 and the import went through.

Regards,
Mark

16

That sounds strange - all the dates of the 1350 records have the same format dd.mm.yyyy. 544 records went through though. I will give it a try with the complete set of records and let you know the result…

17

I suspect the 544 records that went through fit the US format where the first two digits are between 1 and 12

18

Yeah, I guess so, too.