Loading Profile...
CSV file export/import does not conform to the CSV file standard.
I keep running into the fact that the CSV format supported by Pivotal doesn't really match any of the standards for CSV files. Here is the common standard generally observed by all and reflected in the ISO standard. http://www.bennadel.com/blog/489-pars...
Can we get this fixed so those of us that still have to deal with people not using XML can find the CSV file useful for bulk uploads and bulk updates?
Can we get this fixed so those of us that still have to deal with people not using XML can find the CSV file useful for bulk uploads and bulk updates?
I’m frustrated
1
person has this problem
I have this problem, too!
Tell me when someone solves it.
The more people who report this problem, the more it gets noticed.
The more people who report this problem, the more it gets noticed.
The company thinks this is not a problem.
-
Inappropriate?We use FasterCSV for our CSV parsing which supposedly maintains a pretty strict definition of CSV taken directly from the RFC 4180 (http://tools.ietf.org/html/rfc4180).
If you can point a specific case that our import is not adhering to the RFC or a specific thing that we can do to make the import process smoother for you, we would happy to look into it.1 Comment
Add a comment
This solves the problem
-
In fact it does not: according to the ABNF at that page, embedded newlines inside double quotes are perfectly acceptable, and FasterCSV will not parse it.
EMPLOYEE
