Subscribe rss
Blog categories
All | Backendless features
Feature 71: Assigning column types during data import
March 20, 2015 by markpiller

Previously I described a feature where you can import data to Backendless using CSV files. In that post I used CSV files which already had the data type defined for each column. For example:
location-csv-contentsWith that approach the import process is completely automated since Backendless knows what the data type for each value is. However, what would happen if the imported CSV file(s) do not provide that information? Backendless handles that scenario rather gracefully – it provides a very easy-to-use interface where you can assign the proper data types. Consider the following data file:
[table “” not found /]

As you can see the header row has no information about the column types. When importing the file to Backendless using console (you can download the file from here), the file is uploaded and the user is then presented with the following interface:
import-step2 As you can see, for every user-defined column (columns objectId, created and updated are the system-level columns), console prompts the user to specify the data type. If you were to import multiple CSVs, there would be a similar interface for each file without the data types. The interface is also aware of columns representing relations and provides a way to specify those. Once the types are set, click the Finalize Import button to finish the import.

Share this post
Tweet about this on TwitterShare on FacebookGoogle+