Shopping Cart Software
SQL Scripts (Server or Client Side)
This is a discussion on SQL Scripts (Server or Client Side) within the osCommerce 2.2 Discussion forums, part of the osCommerce 2.2 Forums category; Hi, I have about 5 manufactures that send me updated product csv files with pricing, quantities and related data... I ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
02-26-2007, 05:42 AM
| ||||
| ||||
 SQL Scripts (Server or Client Side) 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     |
|
#2
02-28-2007, 11:14 PM
| ||||
| ||||
| Re: SQL Scripts (Server or Client Side) 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.
__________________ Michael Sasek osCMax Developer osCMax Templates - Hundreds of premium quality templates. New designs every month! xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host. |
|
#3
03-01-2007, 02:35 AM
| ||||
| ||||
| Re: SQL Scripts (Server or Client Side) 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... |
|
#4
03-01-2007, 06:52 AM
| ||||
| ||||
| Re: SQL Scripts (Server or Client Side) 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.
__________________ Michael Sasek osCMax Developer osCMax Templates - Hundreds of premium quality templates. New designs every month! xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host. |
| The Following User Says Thank You to michael_s For This Useful Post: | ||
nicholasbw (03-01-2007) | ||
 |
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Loading scripts to mysql | FSUddin | osCommerce 2.2 Modification Help | 1 | 12-13-2004 02:19 AM |
| Upload File Option for the Client | aliharis2004 | osCMax v1.7 Discussion | 0 | 01-17-2004 01:26 PM |
| how can you list product options side by side | Anonymous | osCMax v1.7 Discussion | 0 | 09-20-2003 07:16 PM |
| cvs file for client.. | Anonymous | osCommerce 2.2 Modification Help | 2 | 12-07-2002 08:28 PM |
| Allow client to control hyperlinked text in new column box | Anonymous | osCommerce 2.2 Modification Help | 1 | 10-17-2002 08:20 PM |
All times are GMT -8. The time now is 11:02 PM.
