I have two already existing tables. The parent has a 1-to-1 relationship column pointing to the child table. I am trying to import data into the parent which contains a column with valid existing objectIds in the child. Every attempt at defining the column in the parent import csv that I have tried fails with an error similar to:
|7||17:35:48 IMPORT_DATA Import of tables failed: Column type mismatch in table ‘routes’. Database column type ‘RELATION’. Column type in file ‘STRING’.|
|8||17:35:48 IMPORT_DATA Importing failed. Exception:java.lang.RuntimeException: Column type mismatch in table ‘routes’. Database column type ‘RELATION’. Column type in file ‘STRING’.|
I have tried strings, STRING_IDs, and have also tried letting the server guess at the column values since it has the name of the column and knows it is a data relation. All fail.
I found a support topic from 2015 that says to include both tables in a zip. Is this still true? I really don’t see how I could do this. The child table is pointed to other table relations as well. I am trying to recreate a database from another system a little bit at a time - I can’t recreate the entire thing in one zip file. How do you import parent records with pointers to child records, please?