Hi what’s the best way to do a csv import and to get Backendless to recognize the relationship as a Many to Many between “Companies” and “Categories”?
When I import a 3rd Join csv table will Backendless still import this 3rd join table or will it merge the many to many relations into both Companies and Categories tables with child object relations pointing to each other?
I’ve been using this article as a reference for the right csv file notation… Thanks
When you import a table with a relations, it is necessary that all tables with which there are relations are also imported. This can be done by importing tables using an archive with csv files. If only 1 table is imported, then its relations will not be imported.
Thanks but this wasn’t the answer I was looking for. Let me rephrase the question. I’m using MS Access to create 3 CSV files “company”, “category” & “company_category” for the many to many (MM) join.
However Backendless doesn’t need to use a 3rd join table between “company” and “category” to create a MM between them.
Do I just import all 3 tables and then manually add the following Object Relationship fields in “company” and “category” so they point to each other… and then somehow do an update query to copy the relationship data from the company_category MM table into these Object Relationship fields?
Or do I leave the 3rd MM table that I imported into Backendless?
Please explain what is the Best way to import tables into a MM relationship structure. Thanks.