Not able to import a new collection csv file

[Anil Sagar]

Hi, I am trying to create a new collection in my DB by importing a CSV file. Format seems to be correct but still not able to import. Import functionality showing an error -

"This wasn't supposed to happen but an error occurred. Please try again. If the error persists please let us know on the [url=http://appery_io/forum]http://appery_io/forum[/url] or email us: support@appery_io "

first 2 rows from the csv file are:

MSISDN:number Balance:number Active:boolean Days_grace:number Expiry_date:date Voice:number Data:number Data_limit:number SMS:number VAS:number Pack:array Offer:array
1111111111 12 TRUE 0 00:00.0 22 123 512 11 0 [ "offer1" , "offer2" , "offer3"] [ "offer1" , "offer2" , "offer3"]

[Evgene Karachevtsev]

Hello,

Please export database and take a look at the exported collection. The file format (quoted, comma as the field delimiter) - everything is important

[Anil Sagar]

Yes, I did the same thing. Exported the DB. Imported it back without any changes - everything imported fine.

But as soon as I deleted a column and saved again as comma delimited csv file, it failed to import.

What is going wrong?

[Anil Sagar]

The exported file is comma delimited csv. When I delete a column and save it back on the pc, it says saving as comma delimited csv file will make the workbook lose some features. Why should this be the case when what I am opening is already comma delimited csv?

[Anil Sagar]

I am currently using excel to open the exported db files. Hope I dont have to use any particular editor for making changes to csv files. Excel is the easiest to make changes.

[Evgene Karachevtsev]

Anilsagar ,

Could you please open it not in Excel but in Notepad to see if everything is saved as it should (commas, quote, etc.)

[Anil Sagar]

Excel is ripping off the quotes and every row is a separate row now. Unlike in the exported file - which had everything in a single row but no comma to separate 2 rows.

[Anil Sagar]

How to correct this?

[Anil Sagar]

Any solution to this? Are not others facing the same problem? How are they managing?

[Evgene Karachevtsev]

Hello,

Sorry for delay. You should try some special program for editing csv files (You may google, there are many free of them)