1,126
edits
ImportCumulusFile: Difference between revisions
→Further automation
No edit summary |
|||
| Line 68: | Line 68: | ||
Using the above script, in combination with the [[Toolbox]] you could set an automated FTP rule to upload the dayfile.txt from Cumulus each day at 00:15 and then run an HTTP remote command (this script) to import it into the SQL database | Using the above script, in combination with the [[Toolbox]] you could set an automated FTP rule to upload the dayfile.txt from Cumulus each day at 00:15 and then run an HTTP remote command (this script) to import it into the SQL database | ||
Version 2.0 of the script can also be invoked from a command line. So for example importing the realtime file from the command line would look like this: | |||
php importcumulusfilev2-0.php file=realtime.txt table=Realtime type=realtime key=secretKey retainVal=7 retainUnit=day | |||
This allows you to run the script as cron job on a Linux server, or as a scheduled task on a Windows server. | |||
= Version Control = | = Version Control = | ||