ETL and Data Integration tools - Modern ETL software for everyone

Firstly, thank you to anyone whom takes time to read this message, I hope you can help me from spending a lot of time trying to set something up which may not be possible.

I have a series of csv files.
I have a mysql database.

Some of these files will contain items which must be inserted as new records into the database.

Some of these files will contain items which must be updated in the database, therefore we need to check if the defined key from the csv already exists in the database.

Some inserts will require not only information from one csv but possibly 2 or more.

Does this sound like something which this program can handle, or is this truely a job I must write a custom import script to handle?

Thank you again. Hoping for some quick replies as I am currently banging my head against a wall trying to even set up the simplest tests with this product.

I am currently banging my head against a wall trying to even set up the simplest tests with this product.

And we are doing exactly the same trying to figure out which product did you mean...

Peter

You can update/insert data based on key

There is an example in documentation

You may also load the data from several files using mask

Best way to start is check following flash demo's the will answer most of your questions

www.dbsoftlab.com/Documentation/A-Quick-...al-Importer-ETL.html

www.dbsoftlab.com/Documentation/A-Quick-...-and-Enterprise.html

www.dbsoftlab.com/Documentation/A-Quick-...d-ETL-Processor.html

www.dbsoftlab.com/Documentation/A-Quick-...-and-Enterprise.html

Mike

I was referring to the product visual importer professional.