Import relations question

If the data is in backendless, objectId will be present.

but my reference doesn’t know backendless objectid
so when i import tableA data. backendless will auto create objectid data for tableA
but my reference in tableB is referring to other column in tableA.

how can i work with that.

You need to include objectId into the CSV and reference that value in the relations. The value of objectId can be your own (must be unique). This is what we show in the documentation as well. That’s the only way Backendless will understand that the objects are related.

1 Like

Thats it.
Now all is clear.
Thanks @mark-piller

one more question
how can i reference a table when i import geo points?

objectid,lat,lon,categories,meta <= how to reference a data table here.

@mohammad_altoiher, please see the instructions below:

  1. Create a CSV file called `GeoPoint.csv’. The file must have the following “columns”:
  1. The file should contain all your geopoints. The first column is the ID of each geopoint - a unique string which identifies it in the system. For example:
"02DCD56A-39FD-8BBD-FF63-3ED73BB15300",37.31917,-122.27417,"geoservice_sample","city=LA HONDA" 
  1. Suppose your geopoint references an object from table Address and the name of the metadata property is address. In this case, in your Address.csv you need to declare the following column:
  1. The value for that column should be id of the corresponding geopoint.

Hope this helps.


1 Like

this did not work on the import for the address table. ONE_TO_ONE work.

I didn’t quite understand what you wrote. However, the best way to learn how to format the data is to enter the data using Backendless console, create all the relationships and then run export to see how Backendless itself creates those CSVs. Then if you structure your CSVs the same way and import, it will work.

i did that and the geo point meta is empty


and this how it look in the console

You are looking in the wrong place. When you export data, the relation will be declared in the store CSV.

so in store.csv if i declare the column


i will see the metadata as in this picture for the geo point above?

If you also include GeoPoint.csv which has the referenced geopoint, then yes, you should.

i tried a lot of times with no luck there is no metadata in geo point.
here is the test files. tell me what is wrong.
store1.csv (77 Bytes)
location.csv (40 Bytes)

Where is Geopoint.csv ?

its the location.csv

The file with all the geopoints must be called GeoPoint.csv.

it does import even if the file not named GeoPoint.csv
however i did try after renaming and its the same.

Put all the files together into a zip and upload here so we can check. (400 Bytes)

Your GeoPoint.csv is invalid. See item #1 in there instructions here: Import relations question