Module or tool for web-based data import and ETL? [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 7 years ago.

Improve this question

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 con开发者_JS百科version functions typically found in ETL software.

General Flow:

1. Upload a file (CVS, Excel, etc.)
2. 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
3. Show a mapping interface to select how the source columns match to the destination
4. Process the import and validate the data
5. Provide report of data that failed import with option to download a file of just the failed rows

---

Not sure there is a single module out there, but here are some pretty cool tools to accomplish at least parts of this:

1. File Uploading
2. CSV Parsing

Other than this, phpMyAdmin offers is one of the best web-based Database managers (for MySQL databases).