Load Flat files into a database

I have Flat files being delivered on a regular basis to my dropbox.

They are placed in various variable subdirectories of a single directory.

Whenever a file becomes "available" in dropbox under that main directory, I need it uploaded to my database for processing.

The data structure is always the same, and the naming convention is

[url removed, login to view]

I need the filename available with the data in the database.

With the filename in a column, all files could be loaded into a single table.

When the file is loaded, a "control table" needs to have that filename added to it so I know there is data to process, and the original flat file can be zipped and archived.

If there are any parameters required for connections, I'd like that to be kept in a parameter file.

Evner: Linux, MySQL

Se mere: process data structure, csv files processing, dropbox file directory, processing load csv, flat data, database table structure, processing csv files, data load database, load available, variable column table database, user post system database files, autocad structural detailing 2009 database files, view locked database files, extract database files ntbackup, data flat files, process csv files, dbx database files, flat database, flat file table, skype database files dbb, database files online boats, flat file database, know process task manager vbnet 2005, exporting ning database files, flat files

Om arbejdsgiveren:
( 1 bedømmelse ) Monaco, France

Projekt ID: #5992878

1 freelancer byder i gennemsnit $150 på dette job


Hired by the Employer

$150 USD in 4 dage
(81 bedømmelser)