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

Article Details

Article ID:
56
Category:
Date added:
2011-02-04 21:17:50
Views:
534
Rating (Votes):
(573)