I am going to add a function to a web application that allows users to import data. I don't want to reinvent the wheel, so I'm looking for any module that I could integrate to handle this.
The interface should be similar to the file import interface in Excel or Access, plus some of the more sophisticated conversion and type conversion functions commonly found in ETL software.
Total stream:
- Download the file (CVS, Excel, etc.).
- Preview data in a file - use the first row as the column names, and then show the first N records so that the user can verify that the file has been correctly analyzed.
- Show display interface to choose how source columns fit
- Process import and check data
- Provide a report on data that could not be imported, with the ability to download only damaged lines
source
share