Routing Import Setup

HelpID: 704822029

Navigation: Tools >> Setup >> Manufacturing >> Routing Import Map

An Import Map is required. The Map provides instructions for Routing Import on how to create the Routing, what source fields to use from the Excel spreadsheet, and how to provide default values.

Map ID: Create an ID for the Map. You can create an unlimited number of Maps to support different file layouts.

Description: Enter a description for the Map.

Import Source: Select Excel or SQL Table.

Table Name: If importing from a SQL Table provide the physical name of the integration table. Please see SQL Routing Import for more information.

Field Mapping: The Routing Field Map section for details on each field that you can import, whether or not it is required (meaning it must be in the import file or have a Constant), and what the default value is. If you map to a Source Field, put the Column Letter in the Source column. For example, if the Item Number is in Column A, put A into the Source field. If the Routing Name is in Column B, put B into the Source field. The Import Mapping tool cannot validate this information until you attempt to run the import, so careful setup is important.