A set of shell scripts designed for use with Accuplus®. This collection of scripts will export information from your Accuplus® data files into tab separated text files. From there, you can use this command data format to import into just about any system you'd like. Excel spreadsheets, MySQL/Access/MS SQL databases, XML, HTML are all possibilities.

Order Control

1. The first step is to run the dump_soh.sh script to extract the shipped order headers. Extracts based on customer number, order number, and ship date specified in the customer_list, order_no.min, and ship_date.min files respectively.

2. Next run the dump_cons.sh script to extract consignees. Consignees are extracted based on order number range specified in the order_no.min and order_no.max files.

3. Run dump_sod.sh to extract the shipped order details. These again are extracted based on the order number range in the order_no.min and order_no.max files.

4. The last step is to copy the order_no.max to order_no.min and ship_date.max to ship_date.min so that when the process is run again you're only getting new orders.

Script Specifics

All the Accuplus® Data Extraction Scripts are standard shell scripts. Each will extract specific information from your Accuplus® data files. Mouseover the name of the script to for a description of the script and a list of fields it extracts.

dump_cons.sh

dump_cust.sh

dump_prod.sh

dump_inqty.sh

dump_wh.sh

dump_sod.sh

dump_soh.sh

dump_carrier.sh

© 1995 - 2004 Base 2 Companies, Inc.. This document and its content are the property of Base 2 Companies, Inc.. base2co software, EDI Wizard, autoEDI, base2co-lpd, base2co are trademarks of Base 2 Companies, Inc. Accuplus® is a registered trademark of LDS, Inc.