Google
Web base2co.com

Accuplus® Data Extraction Scripts

A set of shell scripts designed for use with Accuplus&reg. 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


base2co • Buffalo NY •

Copyright ® 2011-2021 Joseph T. Buscaglia

Last Modified 07/23/17

Valid XHTML 1.0 Strict