How to buildvolume test orders and items

code to generate test order headers and order items:

1. 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

2. order_template.sql - template SQL file used to build above file (replacing order number only)

3. 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)

4. jsi_functions.php - include file used by gen_orders.php

Article Details

Article ID:
26
Date added:
2011-01-07 17:14:34
Views:
592
Rating (Votes):
(555)