Support Topics Documentation Slack YouTube Blog

Update data from imported CSV file

Hey there!
I need to update manually about 150 records in my table. So I’ll try to figure out how can make it faster than by hand.
Maybe I can export the data, change the records with Excel and than import the same file.
So I’ve imported the new CSV file with only two column, the objectId one e the column with the updated data.

Now I’ve check the table in Backendless and nothing happened. Can you help me please?
The CSV file is attached and here below can you see the import log file.
Thanks in advance,
Mario

23:16:30 IMPORT_DATA Importing Started.
23:16:30 IMPORT_DATA Preparing files to import
23:16:30 IMPORT_DATA Copying of Deals.csv, size: 0.008 MiB.
23:16:30 IMPORT_DATA Creating temporary tables
23:16:30 IMPORT_DATA Creating user’s tables
23:16:30 IMPORT_DATA Preparing Deals table: initializing columns.
23:16:31 IMPORT_DATA Preparing Deals table: updating column related IDs.
23:16:31 IMPORT_DATA Preparing Deals table: initializing relations.
23:16:31 IMPORT_DATA Checking denied and duplicate columns.
23:16:31 IMPORT_DATA Resolving related table.
23:16:31 IMPORT_DATA Getting meta-info about insetable tables.
23:16:31 IMPORT_DATA Start import table: Deals
23:16:31 IMPORT_DATA Cannot complete insert batch for table ‘Deals’. Duplicate entry ‘F97046A0-BCF3-04E0-FF64-4F7A725B9700’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [6.08, [B@5caf77d8, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘5604E562-9712-D10A-FF4C-86D18122EF00’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [4.5, [B@5890e895, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘28C77F9F-BA8B-BE42-FFE0-F74C254AD300’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [4.4, [B@1d927de3, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘9271E6C3-DA5F-6939-FF6A-91C9059E7B00’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [5.4, [B@bf3b21f, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘70DE2027-6B06-5B09-FFCC-A826A69E0700’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [5.5, [B@2c45050e, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘CFF7EA19-9439-3F9D-FF29-8FB63FAE6200’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [14.95, [B@73ce9453, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘EA6DDF46-CAF9-0D2C-FF89-B48DD07AFE00’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [5.13, [B@7dbd82ac, 2020-01-21 23:16:31.0, null]
… the file is too long …
Duplicate entry ‘A072D691-814D-800C-FF8A-4AA4E880B500’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [2.07, [B@30c7c5c6, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘A23868A5-C7CD-EAAF-FF95-A91188987D00’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [6.19, [B@ebf1b1b, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘A4B59D59-9B23-0885-FF04-A4CEDD5D7500’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [56765.0, [B@644274a6, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘A5D04954-CB03-9B1A-FF76-67682C3F3D00’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [12.39, [B@47b642fc, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘A6193C6B-ED4A-C52B-FF63-F857795E3300’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [777.0, [B@49515639, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘A94D9E68-DFC4-C9A1-FFBE-8649EEDA2B00’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [656565.0, [B@3fc0fbcb, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘A9B868AA-32E7-4A76-FF82-93C198885E00’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [111.0, [B@48d04fd1, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘B2D50C19-145B-B80E-FFD2-D1085F685900’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [4.59, [B@3d844595, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘B34BB5AF-44A7-A169-FFA1-B8EBC83F8300’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [7.39, [B@7ea72c82, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘B7E63A2F-05DE-AAEC-FFFF-98B93F02ED00’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [1.0, [B@46019e3e, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘BE2363BC-629B-AE69-FF9E-2E4070CF8D00’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [777.0, [B@c65efe8, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘BFC83DAC-D379-1BCD-FF7D-1270C35CDA00’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [888.0, [B@1352ab1c, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘C213C9D3-BE81-8E78-FF41-AA8BCB4DA500’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [5.19, [B@54d646c8, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘C39FCEEE-2781-3528-FFCD-2B6BE7FCD800’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [9.9, [B@1eecc202, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘C58D987F-57C3-A672-FF30-46D78683A300’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [3.0, [B@3dd57498, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘CA4A5FB6-91B1-05EA-FF1E-EF7E3597A600’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [7.9, [B@3bd93275, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘CD5F25B1-0B07-DD0E-FF80-94C81B1FCE00’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [15.9, [B@5d5fd3c0, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘CE9965ED-C41D-DB30-FF9A-A17539B72D00’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [5.49, [B@25dbf6bb, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘CFDCAE09-A620-CE52-FF5C-93A598143D00’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [11.0, [B@333c372c, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘D125B976-1D66-49C4-FF14-B69BC039B100’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [666.0, [B@4184f1a4, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘D63B01E3-6725-3D87-FF84-85C6D95D5200’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [7.19, [B@62e6eb87, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘D68C138F-B220-1BB7-FFA6-37708D4B9C00’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [58656.0, [B@1872b74e, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘D699133D-AE00-4ABE-FF63-18491FCC3D00’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [865675.0, [B@4aa5663b, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘D7054996-666A-BBCB-FF80-C0462A6DB600’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [5.14, [B@2ccab71a, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘D9A12DB3-59F2-7383-FF46-BC3A41D32300’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [22.0, [B@79a5dbd7, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘DC2FD577-672A-BB5D-FF5F-4CB3AAE35A00’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [12.15, [B@74e0cb6a, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘DDB61159-B4F5-89F9-FF85-C44321C3F400’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [13.39, [B@1515ef73, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘E228F635-8888-E8D6-FFCF-92347F865800’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [5.39, [B@6c1ef8ac, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘EC9A40CC-BF18-183F-FFE2-C86D1AA76700’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [7987698.0, [B@3bb2ed9b, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘EF6EAF5F-0409-8C71-FFFF-C0B1468D1D00’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [17.49, [B@497bda1c, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘F0A6DEF9-A59F-7A9D-FFFE-F5BA180B9000’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [11.29, [B@73afda37, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘F1CA42F3-8009-19C8-FFC4-F12903633F00’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Cannot complete insert row for table ‘Deals’, values [3.09, [B@68ef9776, 2020-01-21 23:16:31.0, null].
Duplicate entry ‘F97046A0-BCF3-04E0-FF64-4F7A725B9700’ for key ‘PRIMARY’
23:16:31 IMPORT_DATA Table ‘Deals’ was imported at 0 seconds. Saved 0 records.
23:16:31 IMPORT_DATA Finish import table: Deals
23:16:32 IMPORT_DATA Started restoring relations.
23:16:32 IMPORT_DATA Clearing user data table cache.
23:16:32 IMPORT_DATA Deleting temporary tables.
23:16:32 IMPORT_DATA Finishing pointers export.
23:16:32 IMPORT_DATA Restoring expiration tasks for DeviceRegistrations.
23:16:32 IMPORT_DATA Importing Finished.Deals.csv (8.6 KB) Deals-exported-file.csv (72.3 KB)

Hi @Mario_Canevarollo,

Backendless import at the present moment cannot update existing records, it can do only insertion. To make it work, you can export everything, make the changes in the CSV, then delete the records in the database and import the CSV.

We’re working on a change where you’ll have an option to update existing data with the one from the CSV, but it is not available yet.

Regards,
Mark

1 Like