|
Project Information
Links
|
This is a set of tools to manage large amounts of Syspro data. The project is made of a core Perl module called Convert::Syspro and a few command-line tools to manage data import.
Typically, you would use create_table_syspro.pl to read a set of Syspro .MAC files and create the MySQL database. Then parse the same Syspro .MAC files with create_template_syspro.pl to create the template files. Then you would create an email address to pipe into load_data_syspro.pl so whenever an email is received with the right subject, the command looks for which Syspro .DAT files to load into MySQL. The email is a trigger mechanism. Typically, a daemon running on the Syspro application server would sync the data on the MySQL database server, and upon completion, send the email to inform which files have been changed. |