Ideas please: Loading of CSV files attached to emails
Andrew RMay 22 2008 — edited May 22 2008Hi,
I'm building an application that will automatically import csv data into tables and be presented to the user in the form of reports and charts. The finished application will be hosted on the internet using an Apex hosting provider.
I'm looking for ideas and suggestions on how best to implement the following requirements.
1. The csv files will be attached to an email, so the attachments need to be detached from the email.
2. Each csv file needs to be stored in the database so the user can view the original source files.
3. Load csv data into tables.
My initials thoughts are:
- Use Outlook to read incoming emails, detach the files and place in a web directory on the Apex host.
- Read the web directory from PLSQL and "download" the csv file into a blob column in the database (using utl_http, utl_file)
- Use utl_file to read the BLOB contents and load into tables.
Any further suggestions would be appreciated.
Thanks,
Andrew.