I am wanting import a CSV file to backendless and have it go in to an existing table. I have had a look through the support documents and for someone who is not a coder it is quite confusing. Are there any videos or other resources to help me understand what is needed? This an import aspect of my app, so I need to make sure I understand and can implement it.
I have used other services that allow you to allocate the relationship when importing through a dialogue box so there is no need to code anything. Any help would be appreicated
Thank you for your reply, but I don’t want to import data as a table as that seems to be pretty straight forward. I want to import data into an existing table. Every time I import data it creates its own table, which means multiple tables of the same data type. I would like to import data into an existing table to update the data that is already there.
So for example, say I have a table that lists car parts and their prices, and every couple of months we update the prices of all the car parts. I want to be able to create a CSV file in excel containing all the car parts and their new prices and import that into Backendless to update the table of carparts that already exists.
How do I achieve this in a codeless way?
You could name file same as table where you want to import.
As for the question about codeless, you could create a page, that accepts csv file. Process it to the list of records using CSV/Excel Plugin. And using Bulk Upsert Operation save them into an existing table
Pay attention to objectId. You must save records with it.
Thank you, I have got that to work. Now I am unsure how to up date a table that has some data that is relational to another table. Using the example above that would mean that I have two tables, one named Carparts which has all the details about the car parts (descriptions etc) and one named PartPrices (which has the price for each part) So in the PartPrices table there will be a Name column that will be relational 1:1 to the name in the carparts table. I believe I need to set up the CSV column header of the CSV file I want to import into the PartPrices table to reference the relationship, but I am unsure how to do this.
Hopefully this is clear and someone can explain the process to me.
I created a simple example with tables “Person” and “City”, with a relation from “Person” to “City”.
Then I exported the “Person” table. There you can see a format with relations.
In csv of “Person” table, I changed the relation column to table “City” to another “objectId” from table “City”. Import the “Person” table csv with the “override checkbox”. The update to another city in the “Person” table was a success.
Thank you for your reply. That is great, unfortunately I don’t currently have a paid account so am unable to export the tables to see how the column titles should be setup. I was trying to see if I could find something that would show me in layman’s terms how to do it so I can try a few things out before committing to a paid account.