I’m trying to import the attached csv file for testing purposes. I was hoping that Backendless will:
- Create the data table for me
- Insert the objects inside that table
So far, the best result I got is backendless creating the table with the default columns ( Object_ID, Created, Updated…etc) but none of the columns included in the csv file are there in the newly created table. I have tried:
- Removing the quotations from the headers.
- Removing the column types
- Adding the length with the type in the headers
- change the table name by removing the underscore
and nothing worked. I have been trying for two full days and the same result, in addition I had to wait between 1-1.5 hours after each import in order to try again. All that without any notification/feedback from Backendless on what is wrong. I have checked both, my email and the import folder in my account and nothing regarding the the import taking a place. I have searched the documentation, and I believe I followed the instruction without any luck. Could someone modify the attached csv file the correct way to get it to work, I hope I’m not asking much. also, if I’m in need to create 100 tables, for example, would I just zip all csv files in a single file and upload the single file, or do I have to upload each file individually? I understand that the documentation says yes I can, but even that did not work.
_NPI01.csv (346B)
Hi Ayman,
I just tried the file you attached and it is working just fine for me (took 1 second). Here’s the data table I got after the import:
![]()
http://support.backendless.com/public/attachments/1a22627c627f74cb3478eedf46f3540b.png</img>
You can also see the status of the import in the /Import folder in the file storage. There is going to be IMPORT_DATA.log file:
![]()
http://support.backendless.com/public/attachments/c6be9737372ab0d49fd2e9ec254d387b.png</img>
Here’s what’s in the file:
![]()
http://support.backendless.com/public/attachments/9ca6c9dd6a5c9f6ec2dd34aeb1e0e38c.png</img>
Thanks so much for the quick reply.
I have just tried again without luck. Since it is working for you then most likely I’m doing something wrong. I took screen shots to the steps I followed so you may advise me of the wrong step. FYI, I’m using Google Chrome (Version 48.0.2564.116 m (64-bit))
This is how I initiated my import process, I could not take a snap shot of the finalizing the import screen.
![]()
http://support.backendless.com/public/attachments/970d94c02315cc3465c179e84dd031b7.PNG</img>
The table is successfully created, but no custom columns added
![]()
http://support.backendless.com/public/attachments/5413ff48b653a0e71e6335bf8d32cc70.PNG</img>
The file name as shown in the import folder
![]()
http://support.backendless.com/public/attachments/a8fa59505ed3edfbae1347998389c37c.PNG</img>
The imported file content
![]()
http://support.backendless.com/public/attachments/15e135b8fe17733a0e2bf3bd519a0547.PNG</img>
It is now 42 minutes since my last attempt to import.
- Everything still the same as my last post.
- If I try to import again, I get the attached image message after selecting the csv file and click the Import button.
I’m using an evaluation backendless account, feel free to access it, and if needed, I will be glad to submit a ticket if it is hard to diagnose the issue based on the current posts.
![]()
http://support.backendless.com/public/attachments/929f6c9a40d95f5001bd8e71b9947681.PNG</img>
Try creating a new app and import there. Make sure to check the Import directory after you import. Let me know how it goes.
Well, I guess we think alike. The original issue I was having was with my employer’s Backendless account. So I created this account two days ago so I may test with it separately and to avoid any issues with the employer’s account. I will however follow your advise just to be sure that the issue is not related to the importing to the default app.
Is it possible the CSV file has changed since you posted it in the very first posting?
The only thing I can think about is if there is any other settings/permissions I should have modified in my backendless account before using the import, as I did nothing after registration and creating my app as far as setting up my account. Could it be one of the FREE account limitations that I can not perform import? I’m going to try a different browser as soon as I’m allowed to import again and I will let you know of the results.
no, the file I attached in my posting is the same as the file I attached in my imports. I will also try with a file with the header line only to see if the table would be created.
Ayman,
I was able to reproduce the problem. I am assigning a ticket to a developer to research this issue. We will be in touch with you shortly.
Regards,
Mark
Thanks Mark, I can rest now 
Do you have any new for this issue while I get the same. I’m not able to import a CSV file with the same result as described by @AymanHamdan above.
Thanks for your help
If you run into a problem with import, please email the file you’re importing to support@backendless.com and cross-reference the support topic in the email.
I just emailed the file as suggested. Thanks for your advice
Hi François,
Could you please resend the file?
Regards,
Mark
Hi Mark,
My issue has been solved by Artur Dzidzoiev on March 23. Do you want nevertheless I resend the file?
BRgds
François
François,
No, it is not needed right now, but we will ask for it if the problem happens again.
Regards,
Mark
