Accuplus® Data Extraction Scripts
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
