I'm going to be adding a feature to a web application that allows users to import data. I don't want to reinvent wheel, so I am looking for any module I could integrate that would handle this.
The interface should be similar to that of importing a file into Excel or Access plus some more complex mapping and type conversion functions typically found in ETL software.
General Flow:
- Upload a file (CVS, Excel, etc.)
- Preview the data in the file -- use the first row as column names and then show the first N records so the user can verify the file was parsed properly
- Show a mapping interface to select how the source columns match to the destination
- Process the import and validate the data
- Provide report of data that failed import with option to download a file of just the failed rows