We need to have perfect drag and drop file uploading
We need to be able to take a CSV file, create a data structure for it and generate a user interface to edit it
CSV files with column headings just make the structure as per column headings
csv with column headings and records import the data
the workflow is as follows
There is a drop zone for the file
You drag csv file onto zone
It generates a preview of the records in an editable data grid
submit button pressed and structure sent to server and the associated records are created
this workflow will be repeated in different sections of apps
for example, in our education application
this is how someone takes an existing excel spreadsheet gradebook
and imports it
for now we don't have to worry about calculations
but in the future we will have to deal with calculations, but not from excel
we will have the user add calculations after the data is imported