Hi,
I’m trying to import my data by using a .csv file. Works fine for 10 columns but 2 columns remain empty. Both have a one-to-one relationship with another table.
Although I have multiple columns which have a one-to-one relationship and no problem with them.
I checked everything, column name, object ID’s,… but nothing seems to work…
Care to take a look?
Thanks
data.csv (202.7kB)
Hi Birger,
Could you attach all the CSVs which would create a complete closure? I assume you import more than one file, don’t you?
Mark
I inserted the other data manually since it wasn’t that much.
But here are both exports of the related tables.
Period.csv (473B)
I believe when importing a file, it cannot reference other (already existing) data in the tables. There should be a full closure with relations in the files you upload for the import.
But how come other columns who also reference other tables import without any problems?
I’d say it is an unexpected outcome. Proper import must include a full closure of references - meaning all files must be provided at once.
I removed all the data in my database and imported it using seperate .csv files, still the same 2 columns remain empty.
Hi Birger,
Have you formed the csv manually or was it created via Backendless Export?
Manually, I have all my data in the database now. Will try an export and import on a other database to see if the problem persists.