5,838
edits
Standard log files: Difference between revisions
m
→Cumulus 1: transferring the contents of the monthly log file into a database table
| Line 110: | Line 110: | ||
You can also use <currentlogfile> as part of the remote file path, as explained in the Cumulus '''Help'''. You will also need to specify a path in the remote column for MX or the 'ExtraRemote[0 to 99]=...' for Cumulus 1. You might of course want to specify a local path, and leave the FTP column unticked (or set to 0 for Cumulus 1). You can then use a separate FTP process to upload this copy. It is not recommended that you do not try to FTP the actual log file (only a copy) because the FTP process is relatively slow, particularly as the file size increases as the month progresses, so there is an increasing chance of conflict with logging - see [https://cumulus.hosiene.co.uk/viewtopic.php?f=4&t=12721&p=99793#p9979 support forum here] for more information. An alternative approach is to upload the monthly file just once a day, at a quiet period such as an odd number of seconds after quarter-past midnight using a process scheduled outside Cumulus. | You can also use <currentlogfile> as part of the remote file path, as explained in the Cumulus '''Help'''. You will also need to specify a path in the remote column for MX or the 'ExtraRemote[0 to 99]=...' for Cumulus 1. You might of course want to specify a local path, and leave the FTP column unticked (or set to 0 for Cumulus 1). You can then use a separate FTP process to upload this copy. It is not recommended that you do not try to FTP the actual log file (only a copy) because the FTP process is relatively slow, particularly as the file size increases as the month progresses, so there is an increasing chance of conflict with logging - see [https://cumulus.hosiene.co.uk/viewtopic.php?f=4&t=12721&p=99793#p9979 support forum here] for more information. An alternative approach is to upload the monthly file just once a day, at a quiet period such as an odd number of seconds after quarter-past midnight using a process scheduled outside Cumulus. | ||
=== Cumulus 1: transferring the contents of the | === Cumulus 1: transferring the contents of the standard log file into a database table === | ||
A script can be used to read the your copy of the monthly log file into either a database table (see [[ImportCumulusFile]]), or into an array, for further processing. It is, as advised above, best not to work with the file that Cumulus is actually updating, because there can be a conflict of the locks, Cumulus needs to have exclusive use when it does its normal update. But this script can safely be used with older monthly log files, or a copy of the latest monthly log file. | A script can be used to read the your copy of the monthly log file into either a database table (see [[ImportCumulusFile]]), or into an array, for further processing. It is, as advised above, best not to work with the file that Cumulus is actually updating, because there can be a conflict of the locks, Cumulus needs to have exclusive use when it does its normal update. But this script can safely be used with older monthly log files, or a copy of the latest monthly log file. | ||
=== Cumulus MX: transferring the contents of the standard log file into a database table === | |||
Although the '''ImportCumulusFile''' script can be used with MX too, MX provides 2 other ways to transfer the contents of a monthly log file into a database table. | |||
#The first, uploads ALL past data, using '''ExportMySQL.exe''' found in the top level folder where ''CumulusMX.exe'' is found. It can be run using the same way as you run the main program, but you need to specify "monthly" as the first parameter. | |||
#The second, which only uploads the line most recently added to the standard log file is found in the '''My SQL''' settings section of the admin interface. Find more information at [[Cumulus_MX#MySQL_settings|MySQL settings]]. | |||
===After you have edited (or created any missing) Standard log files, you can:=== | ===After you have edited (or created any missing) Standard log files, you can:=== | ||