Bulk upload of data using Excel or CSV in DataManagement

Data Service
1

I am creating a test environment and an online search and I want to create some sample data. It would be nice to have some option on data management to upload data using Excel or CSV or something like that to create lots of data quickly.

Now I’m creating an script to do it by code, but it would be nice if we could use something like Excel data we already have for testing purposes.

Thanks!

2

This option is already there. Simply go to Manage > Import. You can import a CSV file with your data and backendless will automatically create a table and import your data.

3

[reply user_id=1][h4]Mark Piller wrote:[/h4]This option is already there. Simply go to Manage > Import. You can import a CSV file with your data and backendless will automatically create a table and import your data.[/reply]Thank you! I didn’t see it! I will test it tomorrow

4

Please let us know if you run into any problems.

5

Yes, I’m having some trouble.

I’m trying to upload a .csv with more than a thousand rows and I could upload more or less 200 rows. I had inserted 144 rows before that import using as3 code and then I tried to upload more using the .csv. But it doesn’t allow me to upload more than 317 rows, when I try to reupload my .csv file it keeps sending me this error:

1 10:13:01 IMPORT_DATA Importing Started.
2 10:13:01 IMPORT_DATA Start import table: ObjetoCategorizado
3 10:13:01 IMPORT_DATA Import table ObjetoCategorizado failed: java.lang.IndexOutOfBoundsException: Index: 6, Size: 6
4 10:13:02 IMPORT_DATA Importing Finished.I’ve checked my columns and I don’t see anything that is not normal. What could had happened?Thank you very much in advance. I attach my csv file.

ObjetoCategorizado.zip (23kB)

6

I finally made it work. I don’t know what happened. It seem that the server kept saved the last csv and when I uploaded a new one it was importing the last one. Now is working.

Thank you anyway.