Reply
mysql import & cron jobs...
Old 04-29-2004, 05:23 PM mysql import & cron jobs...
milomedia's Avatar
Super Talker

Posts: 133
Location: durango, colorado
Heya,

I've got a site which is tied into the client's point of sale system in their retail garden center. Every 20 mins or so the point of sale system places a .csv on the webserver, and when i use mysql import to import the file, everything works lovely. Here's the problem: the client wants the inventory on the site current every time the csv is uploaded. My server admin won't allow me to run more than one CRON job a day, so I'm kinda stuck. Any ideas how I can get this inventory automatically updated every 20 minutes?

thanks,
-e
__________________
_______________________________
Feeling down? listen to AFTERGRASS - Free Music Downloads
milomedia is offline
Reply With Quote
View Public Profile Visit milomedia's homepage!
 
When You Register, These Ads Go Away!
     
Old 04-29-2004, 05:46 PM
Skilled Talker

Posts: 53
I know this isn't the answer you're looking for but I had to say something... Your server admin won't allow more than 1 cron-job per day? Find a new server admin!

You might find a PERL solution that works from the system clock but most PHP solutions are going to require a page/script hit which leaves you dependant on someone or something.

Jim Webster
http://www.idevdirect.com/
iDevDirect.com is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to mysql import & cron jobs...
 

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 


Page generated in 0.12267 seconds with 13 queries