My favorites | Sign in
Project Home Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Project Information
Members
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.

  1. create_table_syspro.pl: Create MySQL tables from SYSPRO .MAC layout files
  2. create_template_syspro.pl: Create templates files used by Convert::Syspro from SYSPRO .MAC layout files
  3. load_data_syspro.pl: Parse an email for table names and load specified SYSPRO data into MySQL

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.

Powered by Google Project Hosting