Building test data for ForceField
1. Building test products, please use datagenerators.zip (attached).
2. For building test orders, please use trepco_build_orders.zip.
Note:
a. order_build.sql
- generated SQL file that has 300 orders (1001-1300) with 10 identical line items each
- it deletes all records in ORDHEAD and ORDITEM first
b. order_template.sql - template SQL file used to build above file (replacing order number only)
c. gen_orders.php
- script that builds order_build.sql from order_template.sql
- you can modify template/build pathnames and number of orders in variable definitions
- for your possible future use (run from cmd line or ".bat" file)
d jsi_functions.php - include file used by gen_orders.php
2. For building test orders, please use trepco_build_orders.zip.
Note:
a. order_build.sql
- generated SQL file that has 300 orders (1001-1300) with 10 identical line items each
- it deletes all records in ORDHEAD and ORDITEM first
b. order_template.sql - template SQL file used to build above file (replacing order number only)
c. gen_orders.php
- script that builds order_build.sql from order_template.sql
- you can modify template/build pathnames and number of orders in variable definitions
- for your possible future use (run from cmd line or ".bat" file)
d jsi_functions.php - include file used by gen_orders.php