1,120
edits
m (version 1.1 -- added delimter option) |
m (1.1a added date delimiter) |
||
Line 1: | Line 1: | ||
{{AddOnBanner|name=ImportCumulusFile|type=PHP|author=David A Jamieson|contact='DAJ' via the forum|updated=4 Feb 2010|version=1. | {{AddOnBanner|name=ImportCumulusFile|type=PHP|author=David A Jamieson|contact='DAJ' via the forum|updated=4 Feb 2010|version=1.1a}} | ||
This is a PHP script designed to run on your webserver and import Cumulus log files into a MySQL database on your server. | This is a PHP script designed to run on your webserver and import Cumulus log files into a MySQL database on your server. | ||
Line 15: | Line 15: | ||
:servername, username, password, database and security key | :servername, username, password, database and security key | ||
:these are documented in the file at the top. | :these are documented in the file at the top. | ||
:There is a sixth entry which may require editing. Look at the text file you are importing. How is each field separated/delimited? In the UK | :There is a sixth and seventh entry which may require editing. Look at the text file you are importing. How is each field separated/delimited? How is the date delimited? In the UK there is nothing else needs changed. If for example your delimiter is a semi-colon and a dash then change the lines $field_delimiter and $date_delimiter accordingly | ||
*save the file as ImportCumulusFile.<b>php</b> or whatever name you prefer and upload it to your webserver. | *save the file as ImportCumulusFile.<b>php</b> or whatever name you prefer and upload it to your webserver. | ||
Line 62: | Line 62: | ||
=Version Control= | =Version Control= | ||
*1.1 Added the facility to identify the delimiter used on the import file | *1.1a Added date delimiter | ||
*1.0 First Release | *1.1 Added the facility to identify the delimiter used on the import file | ||
*1.0 First Release | |||
[[Category:WebTools]] | [[Category:WebTools]] |
edits