Tuesday, May 23, 2017

design patterns - Best Web UI for Large Amounts of Data Input


I'm looking for a good solution when users need to enter large amounts of data into a web application.


Example



  • A store owner wants to enter 30-40 new products into the system every month. The store owner has a spreadsheet of all the products, their quanities, prices, manufactures, contact information, serial codes, etc (probably about 10 different fields).


Right now I'm thinking some sort of grid view that allows the user to copy and paste data from say Excel or whatever spreadsheet applicaton they use.


What is the best web solution to allow the user to enter this much data (without having to enter each item individually)?



Answer




How about a UI to upload the spreadsheet file to be automatically processed by a database importing routine?


No comments:

Post a Comment

technique - How credible is wikipedia?

I understand that this question relates more to wikipedia than it does writing but... If I was going to use wikipedia for a source for a res...