SQL Scripts (Server or Client Side)

**nicholasbw** · 02-26-2007, 05:42 AM

Hi,

I have about 5 manufactures that send me updated product csv files with pricing, quantities and related data...

I was wondering if anyone developed Scripts for MYSQL to update product information in products and key tables. I'm aware of Easy Populate but I was looking for a more automated methodology to address day to day task without importing 7 300 item sets.

As apposed to re inventing the wheel any help would be appreciated...

Nicholas

**michael_s** · 02-28-2007, 11:14 PM

I am not aware of any. You could set up easypopulate to run on a cron, then all you would need to do is upload the ep text files to the specified directory daily and let the cron run.

**nicholasbw** · 03-01-2007, 02:35 AM

Thanks...

EP imports and exports only, ideally I would like a certain amount of DTS on each cvs file after it's imported.

I downloaded Toad for MYSql...Are you aware of a way to run "Stored Procedures", "triggers" or any other programmable task to process data with MYSql?

Just to recap a series of data transformation steps needs to be performed on each one to be compatible or in ep's file layout or directly updating tables...

**michael_s** · 03-01-2007, 06:52 AM

You could write a shell script or php script that you also run on a cron with the mysql processing that you require. That would be how I would go about it.