Using Routing Import
Navigation: Tools >> Utilities >> Manufacturing >> Routing Import
Import Map ID: select the Map ID to use for the import.
Rt Seq Length: the import will pad the Sequence Number from the import file to the desired length. For example, “10” would be padded with leading zeros to “010” or “00010”. Choose a length of 3, 4 or 5. NOTE: WilloWare has seen erratic behavior in the Manufacturing Routing Sequence Entry window when using a Routing Sequence Number with 2-characters or less. While the Routing Sequence Entry window will allow entering a Routing Sequence Number with only two characters (i.e. “10” instead of “010”), the window has a routine to automatically pad the Routing Sequence Number with leading zeros. WilloWare has observed erratic behavior in the routine with Routing Sequences of 2-characters or less where it will pad some of the sequences, with the result being “10”, “020”, “030”, “40”, “50”, etc. To ensure consistent, predictable results, the import utility requires padding the Routing Sequence Number to no less than 3-characters.
Source File: select the source file. The import file must be an Excel spreadsheet, and the first sheet in the workbook must contain the data to import, and the first row must contain column headers. Routing Import always starts with Row 2.
Import: Click the Import button to begin the import. The import process will:
- Validate Data. See the Routing Import Field Map for the validations performed on each field. All errors will be reported.
- No changes are made/nothing is imported if ANY validation fails.
If any errors are found the entire import will stop. Nothing will be imported if there are any errors, and no changes will be made in GP. An Error Log Report will print specifying the error and the Excel Row of the data containing the error.