Importing data from an ERP system, other system, …

1 Importing data from an ERP system , other system , or database . (Note: If your ERP system is SAP and you would like to hire a consultant to set up data exchange between SAP and CargoWiz, contact us at While we provide a method Easy Import From Excel for quickly bringing in cargo data on a one-time basis, there can be situations where more frequent Importing with an ERP link is desirable. Once set up, it can present the user with only the cargo currently intended for shipment rather than a pool of cargo items from which to select.)

2 With the Excel method the user typically has many more cargo items displayed than are required for the shipment. He must wade through them (or use Find) to locate and set the shipment Quantity. Some CargoWiz users do not have a stable pool of cargo, rather it will usually be new, as in the case of logistics provider with a great many customers who have a variety of cargo. Some manufacturers have thousands of products, it is just much more convenient to bring in only the items on a particular shipment. For the ERP programmer: You program the ERP system to create a tab delimited.

3 Txt file with cargo data of certain types and in cer-tain tab positions. User action to initiate import File , Import from ERP system or other data source User browses to the location where the .txt file is to be found. User opens the file. The incoming data is given a validation check by CargoWiz. If invalid data is found a log file is created on the user s desktop with details of the errors. Invalid data triggers restoration of the previous grid data. A message advises of the failure. If the data is valid the cargo grid is filled with it and it becomes the active shipment ready for loading.

4 A message appears announcing success, and the message closes automatically in a few seconds. Import File Format:: Note: Two files are provided in case you wish to see or do test runs with them. One is ERP Import test with Errors and the other is ERP Import test without Errors . They are in the user s Application Da-ta\CargoWiz\ERP folder. Here is an example of a small Import txt file displayed in Notepad: The data must be as follows: Top Row It must have the column headers spelled exactly as shown here. In some cases they are short versions of column heads in the program.

5 ShortID and Description, which might have lengthy contents, have been moved to the right end to help keep columns aligned to the extent possible. Line Your routine will need code to increment the line count, and place these numbers as shown. Qty Must be an integer, or empty. If empty CargoWiz will set it to 0. Length, Width, Height Must be numeric and not empty. Many places after a decimal may be used. Orients This is Orientations Allowed and refers to restrictions on how the cargo may be turned. There are 4 acceptable values, 1,2,4 and 6.

6 1 means it cannot be turned 2 means it can be turned horizontally 4 means it can be turned any which way, but not tipped up on either end. For instance a box of fishing rods might be unstable on end. 6 means it can be turned any which way. Max Stack Must be either empty or a nonzero integer. Empty is the most common value, which allows the algorithms to stack without restriction if there is space. Refers to Max Can Stack . A value of 1 indicates one identical cargo of the same type can be stacked above the bottom Bottom Must be empty or 1 or 0.

7 Usually empty. The value 1 interprets to true, empty and 0 to false. Re-fers to the Boolean value of Bottom Only If bottom = true the algorithms will only load the cargo on the truck bed, not on other cargo. Group Must be empty or an integer. Usually empty. If set, other cargo with the same number become part of that numeric group. Group 1 is loaded first. Refers to Loading Priority or Group column. Useful for deliveries. Weight Must be numeric or empty. Many places after a decimal may be used. Units Must be empty or an integer.

8 Usually empty. Short for the Units Inside column. It is a convenience col-umn for users who need to deal with Total Units as a business quantity. For example, a customer might order a thousand pair of shoes, in reality 12 shoe boxes are placed in a carton. CargoWiz cares only about the cartons that it must load, but if 12 were placed in the Units Inside column it will display 12 x the Quantity in the Total Units column. ShortID Can be empty or any string, including strings with numbers and characters. Usually it is a Part Num-ber or SKU.

9 If empty CargoWiz will assign a number to, which can help in understanding the load layout. Description (Same requirements as ShortID) Can be empty or any string, including strings with numbers and characters. Usually it is a Part Number or SKU. If empty CargoWiz will assign a number to it, which can help in understanding the load layout. Taboo OnTop Usually empty. To prevent some cargo types from being placed on the cargo, create a comma delimited string of the Record IDs of cargo types that are to be Taboo On Top. To obtain the Record ID for a Cargo, select it in the cargo grid, then hover the mouse on the color box until the record ID Tool Tip appears.

10 Of the row. An example string might be 47,23, 5 . _____ Preferred location for the import file: The File Open Dialog defaults to open to c:\Documents and Settings\<User>\Application Data\CargoWiz\Shipments folder (Path may be different depending on OS) but will remember the last folder visited, helpful if you want locate the import files elsewhere. Return of Loading Results for the ERP system Any time a truck or container is loaded the Export Loading Report to ERPs selection becomes enabled under File on the menu. The exported file is given the same name as the imported file, but prefixed with EXPORT OF so that the re-trieving ERP can recognize it as a results file.