Hello, I tried to upload 183 objects in csv file, but I had only 96 files in database, what may be the problem,
I also noticed that I have to delete all objects from the table first, so that the info in the columns would be updated, why?
Please, provide more clear information (step by step), so that i can to reproduce your problem.
What are you doing and what you expect as result ?
- added zip files to the maps table. (115.png)
made export of my current data base.
got derictory listing of png files, copied all "publicUrl"
opened csv images, added publicUrl to first line and added object id of the zip file to the row "image__maps__bcklsFK__ONE_TO_MANY" (116.png)
saved everything, uploaded, but didn't notice any changes in the images table.
error log on email
Backendless finished import your data successfully for application: maps.
The Import log located in File Service’s “import” directory.
See Import log bellow:
[spoiler=“log”]1 14:15:29 IMPORT_DATA Importing Started.
2 14:15:29 IMPORT_DATA Start import table: images
3 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
4 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
5 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
6 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
7 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
8 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
9 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
10 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
11 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
12 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
13 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
14 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
15 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
16 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
17 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
18 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
19 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
20 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
21 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
22 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
23 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
24 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
25 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
26 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
27 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
28 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
29 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
30 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
31 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
32 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
33 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
34 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
35 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
36 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
37 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
38 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
39 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
40 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
41 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
42 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
43 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
44 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
45 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
46 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
47 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
48 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
49 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
50 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
51 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
52 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
53 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
54 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
55 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
56 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
57 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
58 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
59 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
60 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
61 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
62 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
63 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
64 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
65 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
66 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
67 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
68 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
69 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
70 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
71 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
72 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
73 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
74 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
75 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
76 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
77 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
78 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
79 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
80 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
81 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
82 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
83 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
84 14:15:29 IMPORT_DATA Error inserting row to table images java.lang.NumberFormatException: empty String
85 14:15:29 IMPORT_DATA Table ‘images’ was imported at 0 seconds
86 14:15:29 IMPORT_DATA Finish import table: images
87 14:15:29 IMPORT_DATA Start import pointers for table: images
88 14:15:29 IMPORT_DATA Finished import of table: images
89 14:15:29 IMPORT_DATA Importing Finished.
[/spoiler]
What is you aim ?
If you want to add relation between two tables, you have chosen wrong way.
Use Backendless Console or one of our SDKs to write code which create relation on your circumstances.
My aim is to:
to trasfer pngs and zips from “Files” to “Data”, using REST console
to create records with zip files in “maps” App Table and records with png files in “images” App Table
I hope that there is way to do it in bulk without using php, swift, android, java and use only REST, JSON, terminal.
Hi Kirill,
A few questions to better understand your problem.
How did you upload a csv to a data table? Did you use Import? If yes, please provide that csv so that we could try to import it too and check whether result will be the same.
Where from did you get that csv?
By the way, I think it may be useful to suggest you our Single Incident Support for $100, with which we would transfer that files to the data service for you. I suppose it would save a lot of your time.
I added some files into the maps, images first, made relations for maps with images , that way I got the required template for my database, made export. Using that sample started adding new lines into the file 
Added new lings, tried to upload again on the server, sometimes it worked, sometimes it did not. (What I did: I was adding long url path for my images, that I got from directory listing command, after that imported to my database csv file and it worked. BUT it din’t work for creating realtions (I was adding id of the maps.zip files to the images) Actuall, sometimes it worked and sometimes it didn’t, that’s why I asked you for help and explaining what may be the reason for that).
What about “Single Incident Support for $100” I can not afford that because I’m enthusiast startupper. The second reasone is that I would require way way way more files for upload/update in future, so making one time upload doesn’t really makes a lot of sense for me.
Thanks for your help and comments!
export_2016_10_09_11_39_25.zip (99.59kB)
Hi Kirill,
We’ve tried to export your example zip and haven’t had any errors.
Please provide us the example for reproducing the error.
Regards, Ilya
I didn’t have any errors, when I tried to import this file, except for: there is smth like 183 objects in csv file and there are imported only less than 100 to the backendless, this is the main problem.
I also ran into such problem as: it’s ok to import files into empty table or empty project, but when you try to update the info, let’s say add more lines to csv file, then those new lines are not added to backendless. After that I tried to purge the database on backendless, made import again and all the data was imported correctly. So it would be nice if I wouldn’t have to purge my database every single time I want to make updates (btw the import of the csv file with 183 objects didn’t work even after purging, there were still around 100 objects).
Let me know if I explained the problem clear.
After export from your zip I have 217 rows in the ‘map’ table and 800 rows in the ‘images’ table. About which of them are you talking?
Regards, Ilya