Re: [sidcam] Automating a daily data dump into CMS Builder from a Windows PC
Hi Sid,
>how I automate the transfer of data files to my webserver from a Windows box (so you guys can work with it).
I'd either setup a web server on your windows box so the web server can request the data file via a secret URL, or setup a automated FTP process to FTP the file from the windows box to the web server.
Here's some articles on creating windows batch files to automatically upload files:
http://www.howtogeek.com/howto/windows/how-to-automate-ftp-uploads-from-the-windows-command-line/
http://support.microsoft.com/kb/96269
>The data files will be delimited but can be tab, CSV or pipe. Which works best for you (or does it matter)?
We can work with anything but I'd say CSV first, followed by tab and then pipe. However, If there's a default format that's easiest just send us that.
>Do you want the data files to have a header? (it can be either way)
If it's easy I'd say yes, as we can then add a line of error checking to not import if the header is different (good for detecting future changes that would otherwise break things)
>If so is there a way to turn the "cms_" off without disrupting the existing tables?
If we're writing a script on the web server to import from a database then we can do the field mappings there, and the table prefix doesn't need to match or be there. So not a problem if it's there or it's not.
>I can email/upload a sample once you tell me the format you want it in.
Sure, just send any details to me direct at dave@interactivetools.com and we can figure out the next steps. Thanks!
Dave Edis - Senior Developer
interactivetools.com