Import database

dmitriy-vladimirovich-vasilev · January 31, 2016, 6:44pm

Great Day!
I can not import a database format csv
How to solve the problem?

takeaway_widget_id_2320917_1454263018.csv.zip (360.19kB)

mark-piller · January 31, 2016, 6:51pm

Hello,

It looks like the CSV file uses the semicolon ( as a delimiter between the fields. Backendless expects the delimiter to be a comma (,):
https://backendless.com/documentation/manage/mgmt_import.htm

Regards,
Mark

dmitriy-vladimirovich-vasilev · January 31, 2016, 7:19pm

How to successfully replace ; on , ?
http://support.backendless.com/public/attachments/f70701b2e2e67bc130a76e94930a9fa4.png</img>

mark-piller · January 31, 2016, 7:20pm

Did you get that CSV in the first place? Perhaps the tool you used to get the CSV can generate it with commas?

dmitriy-vladimirovich-vasilev · January 31, 2016, 7:24pm

Sorry you do not understand.
How do I import my database?

takeaway_widget_id_2320917_1454263018.csv.zip (359.94kB)

mark-piller · January 31, 2016, 7:35pm

Maximum number of characters in an object property can be 2000. The very first row contains 3300 characters in the “description” column. As a result, it fails on the import.

Can you share where this data is coming from?

dmitriy-vladimirovich-vasilev · January 31, 2016, 7:36pm

http://clevercon.ru

dmitriy-vladimirovich-vasilev · January 31, 2016, 7:39pm

You can not reduce the commodity?

mark-piller · January 31, 2016, 7:42pm

That link does not help… some extra text providing an explanation would go long way.

mark-piller · January 31, 2016, 7:51pm

Here’s what you should do:

Import the individual CSV file. When importing, make sure to set the data type for the description and category_description columns as "text" as shown in this image: https://monosnap.com/file/WWNWfFB5XYX5pE6yq6203S6t24QEQ5 Once imported, you will get a confirmation email. Here's what the data looks like in my table: https://monosnap.com/file/JYxSHctHDvtKrzQEDfDJK968BbsapZ

Regards,
Mark

mark-piller · January 31, 2016, 7:55pm

Here’s the file we used to test it: https://api.backendless.com/402FE6E7-17AB-394E-FF75-74D919C04100/v1/files/takeaway5.csv

dmitriy-vladimirovich-vasilev · January 31, 2016, 8:26pm

How do I get such a link to the database?
https://api.backendless.com/402FE6E7-17AB-394E-FF75-74D919C04100/v1/files/takeaway5.csv

mark-piller · January 31, 2016, 8:27pm

It is a link to the file we created for you to make it easier to import data.