View Single Post
Old 01-25-2005, 05:38 PM   #4 (permalink)
sde
Moderator
 
sde's Avatar
 
Join Date: May 2002
Location: us.ca
Posts: 4,505
sde is on a distinguished road
ok, for manual execution would be very easy to just make a web page that uploads the csv file which would then execute the logic to read it into your datbase. it would just be a web form with a browse button and submit. if you needed help with the upload script, let me know.

however, i don't think that is what you're looking for. you probably are better off calling a php web page remotely from the command line.

i dont' know how to do this in windows other than calling internet explorer to load the php page that has the logic to parse the csv, i don't know. in the command line, it would look something like this:
Code:
"C:\Program Files\Internet Explorer\iexplore.exe" http://mydomain.com/csv_parser.php
the only problem with this is that it will launch your browser. there may be another way to read a web page from a windows shell, but i don't know.

I asked about the shell access only because you could setup a cron job to run once a day to parse the csv file. this won't work for you if you want the website updated as soon as the csv is uploaded though.
__________________
Mike
sde is online now   Reply With Quote