Forum | Appery.io

Appery cannot input standard csv files to create database collections, and provides a rather mysterious error feedback "cannot input file".

It seems to expect quote-delimited fields, rather than comma-delimited fields, and no major spreadsheet-based csv file editor on the market - Microsoft, Apple, or Google - provide any tools to create or edit quote-delimited CSV files.

It would probably be useful to either remove the option of 'create from CSV' files, since you can't, or fix the parser to read normal comma-delimited CSV files.

Joseph,

Please post error screen shot.

hi Joseph,

"A general standard for the CSV file format does not exist, but RFC 4180 provides a de facto standard for some aspects of it." So "standard csv files" don't exist in that literal sense of the word

An example of csv that Appery "doesn't have problem with" goes like this:
"_id:string","name:string"
"518a9be8e4b0446b3349e9f0","Charley"
"518a9bf1e4b0446b3349e9f1","Francisco"
"518a9c4ce4b0446b3349e9f3","Max"

So if there is some more information to shed some more light, perhaps someone can provide some insights

And ya I have seen Google provide with some mysterious error feedback too, and all I was trying to do was to export my contacts from one gmail account, to another - in csv formt , with all the mapping remaining unchanged / default.

The error was "An error has occurred"....

...guess that is less vague