Started to implement this script this morning and had a few problems - some from the script itself, others possibly from the combination I use..
First - the script contains an example that obviously threw nitrix. The example given to call the script is shown thus:
// htp://www.myserver.com/ImportCumulusFil ... ayfile.txt
Note the htp instead of http - not a big problem but can obviously catch some people out.
Second - my setup is a Windows 2008 R2 server running IIS 7. I had all sorts of problems even getting the script to run but after a bit of messing around, finally got it to run - sort of.
First - I had to create the tables manually. I am running MySQL 5.0.51 and it doesn't like the COMMENT at the end of the CREATE statements! Took me a while to figure this out (I naturally assumed the statements were all OK). Once I removed this, it created them BUT, once the tables were created, everytime the script was run I ended up with a server 500 error - only by commenting out the CREATE lines could I get the script to successfully run onm this combination (W2008R2, MySQL 5.0.51, PHP 5.2.13).
Now the other quesiton - and possibly a really silly one - using the monthly file is straight forward (although the script doesn't really tell you which one to use, neither does the Wiki article).
What is the name of the day file you process with it? I know this sounds stupid but given the script and examples all use the name 'data/dayfile.txt' and that this file 'doesn't exist (or isn't generated),I had to ask - maybe I am missing something obvious, but there doesn't appear to be a file being generated with the layout required for the daily input (or have I missed a configuration setup somewhere?)
Punctuation is the difference between 'Let's eat, grandma' and 'Let's eat grandma'