I'm assessing the options for users to submit a significant amount of data to a web solution I'm writing.
I can write the validations and proper input of the received data, so I'm going to pass over those concepts in this question. But I am assessing the best way of users to submit a myriad of records to my system. Entering items one by one is out of the question. These records would be kept up to day either manually or by some database export on their end. That's their responsibility and I can only assume it will be done somehow.
The only two options that I can see working are CSV/Tab-Delimited Values, or an Excel spreadsheet. I am preferring the latter because it's the easiest for the user, and easy for me to parse on my end, then archive. This is done through file upload. I've considered Dropbox, but that adds a layer for those that might not know how to use Dropbox. That is a concern.
Are there other accepted or tried & true ways of users submitting records, where the data set is massive? I'm looking for more options. The two challenges I face are:
- Ease of use for the user
- Parsing large files on my end after the file is uploaded
Looking forward to your insight.
Edited && Answered:
I completed the task by providing an
XLXS template - Portable and easy to follow/enter data for noobs.
Three columns. No extra columns. I don't need that, and it will only confuse the parser as it is now.
I'm testing every row individually pre-import. Some of these files will be many many rows.
CSV is too complicated for my target market as per the expected pitfalls of more commas. A big portion of my market isn't even online so being simple is absolutely critical. A lot of people can't follow instructions, and since this is organized, an
Excel template is the best.