4 ms·
One of the commenters on the article suggested sending the customer an "import template," with all of the column headers predefined. The customer simply needs t
by dceddia 12y ago
One of the commenters on the article suggested sending the customer an "import template," with all of the column headers predefined. The customer simply needs to copy-paste their data into your CSV import template, and upload it.
Never tried it myself, but it sounds like a decent solution to the problem of wacky formatting.
- DennisP 12y agoI tried it. Customers pretty frequently made their own spreadsheets that looked mostly like the template, but not quite. I was constantly fixing their uploads. I built a system to validate their uploads and let them fix their errors on a website, and all that hassle went away. (I still gave them the template so they'd know what it was supposed to look like, I just didn't rely on that alone.)