Data Import issue

Data Service
1

Hello. After some back and forth with Mark on slack I am opening a support topic to deal with an issue I am having with Importing data from a CSV.

I need to upload data into a table that uses the auto-increment feature for the addressId. I added the notation “addressId({”“type”“:”“AUTO_INCREMENT”“})” for the column header but I am receiving the two below errors.

Please let me know what I can do to fix this. I attached the two error messages. As well as an example of the csv file I am trying to upload/

Errors:

AddressId 1
AddressId 1802×611 29.8 KB

AddressId error 2

CSV File example
addresses example.csv (267 Bytes)

Application ID where I am attempting upload = 9A13BF3D-3E41-C30E-FF1B-94129ABED000

Thanks,
Will York

2

When I open the CSV file in a plain text editor and I see the following:

TestTableImport.csv 2023-01-12 12-52-21
TestTableImport.csv 2023-01-12 12-52-211051×170 37.9 KB

I believe the number of double quotes messes up the processing of the file during the import.

Regards,
Mark

3

I removed the double quotes and am still receiving the same error

Screenshot 2023-01-12 at 2.12.23 PM
Screenshot 2023-01-12 at 2.12.23 PM753×101 10.3 KB

4

The outside double quotes were not needed –

correct format below

addressId({“type”:“AUTO_INCREMENT”})

5

The outside should be single quotes as shown here:

But if it works without the quotes too, that’s great!