Duplicate Entries found in Exported Data

File Service
1

App id: 637EAF50-C824-4368-FF6E-9C88F79A4600

I ran a full export of a table and downloaded the resulting file FBMOrders.csv

The resulting .csv file does in fact have 11 records that appear to be duplicates. Here is an error log from a down stream process showing the records that arrive duplicated in the export file:

Duplicate amazonOrderId detected in FBMOrders export — each order ID must appear exactly once.
Affected (11): 111-1462776-5478621, 112-1863588-4065017, 111-6224069-8114602, 114-8271076-8179435, 112-2643185-8617845, 113-6252145-0925845, 111-3373082-3526650, 111-0666612-1983421, 113-5003602-4644234, 113-1006100-8132218 … and 1 more
This indicates a corrupt export or a bug in the upstream dump. Re-export and try again.

–

When I directly query the database for items with those IDs, only a single record is returned. It seem that the export process is actually adding duplicate rows in the exported file.

2

Hi @Luke_Jasudavicius,

Sorry for delay with response.

This situation is expected when you simultaneously export tables between each 1:N relation is present. In this case, in child table file duplicate entries will be present for each of 1:N relations. Note, if you import parent and child files back to Backendless app it will be imported without duplicates.

If you want to export FBMOrders table for usage outside of Backendless and want to avoid duplicate entries then you need to export only this table without selecting parent table.

I have tried to export/import files for tables between 1:N relation is established in test app and everything went smoothly.

Do you know how your file was exported from the app?

Regards, Andriy