SYSPRO Ribbon bar > Imports > Manufacturing > Routings Import

Routings Import

You use this program to create operation records based on routing information supplied in a flat ASCII file.

Toolbar

Field Description
Import Validates the contents of the import file and import records if there are no errors.
Save Form Values This option is only enabled in Design mode (Automation Design). Your selections are saved and applied when the program is run in automated mode.

Form values and defaults are applied at operator level. They are not saved at role or group level.

Options

Data source

Field Description
Import method  
From file Select this to import data from a file.
Use data grid Select this to enter the import data directly into the grid of the Details pane

You can paste the contents of an Excel spreadsheet into the grid. A blank line is created as the first line in the grid because by default, focus is set on the first editable line for all import program grids.
File location  
Server Indicates the import file resides on the server.
Client Indicates the import file resides on the client.
File name Indicate the name of the import file (include the full path).
Review file This loads the contents of the import file into the Details pane, which lets you validate the lines on the grid prior to importing the file. The Import button is enabled only when all lines are valid.
[Note]

The import file is deleted if you enable the Delete file after use option.

Options

Field Description
Specify parent for import Indicate the parent stock code to which the routing information being imported must be assigned. Otherwise the parent stock code specified in the import file is used.
Stock code Indicate the parent stock code that must be used when importing the file. If you make an entry here then the Parent stock code field in the import file must be blank.
Specify routing for import Indicate a specific routing to use. Otherwise the routing specified in the import file is used. This field is displayed only if you indicated that alternate routings are required.
Routing Indicate the routing that must be used when importing the file. If you make an entry here then the Routing field in the import file must be blank.
Calculate capacity required Calculate the capacity required for the operation. Otherwise the capacity defined within the import file is used.
Calculate elapsed time Calculate elapsed time dynamically. Otherwise the elapsed time defined within the import file is used.

After processing completed

Field Description
Print the Details Generate a report of the contents of the Details entry grid.
Email the Details Generate an email of the contents of the Details entry grid.
Print the Import Results Generate a report of the contents of the Import Results pane.
Email the Import Results Generate an email of the contents of the Import Results pane.
Email recipients Indicate the email addresses of recipients to whom you want to email the information displayed in the output panes.
Delete file after use Indicate whether you want to delete the import file after all records are successfully imported.
[Note]

The file is also deleted if you enable this option and select the Review file function.

In a client/server environment, both the import file on the server and the temporary import file created on the client are deleted.
Close the application Exits the program once processing is complete. Do not select this if you want to be able to view the information on screen when processing is complete or you want to print or email the contents of the Details and Import Results panes.

Details

Toolbar

Field Description
Validate This verifies whether there are any errors in the grid, without actually importing records.

Exclamation marks in the Validation status column indicates that one or more fields in the line are invalid. An explanatory error message is displayed when you hover your mouse pointer over the exclamation marks.
Print Prints the contents of the import file, or changes made in the grid.
Export to Excel Outputs data from the Details pane to an Excel spreadsheet.
Search text  
Clear Clears the contents in the search text field.
Edit  
Copy Copies the lines in the Details pane.
Paste (all columns) Ensure that you have data for all the columns that can appear in the data grid before selecting this option.

When you select to Paste (all columns) the date you are pasting must be in the format CCYYMMDD. Although no validation errors are displayed, the date is not converted into your SYSPRO date format.
Paste (visible columns only) Pastes data into the columns that currently appear in the data grid, in the sequence that they appear.

When you select to Paste (visible columns only) and the date you are pasting is not in CCYYMMDD format, you are prompted for the date format. The program correctly inserts it into the grid in the SYSPRO date format.

Duplicate Copies the current row to the end of the data grid.
Find and Replace  

Import Results

Displays a summary of the results of the validation/import.

This information can be printed or emailed providing you did not select to Close the application in the After processing completed section.

File layout for 7

Internal operations

Field Start position Field length and description
Header   ;SYSPRO IMPORT - Version=001 - IMP020

Mandatory entry of this comment on the first line of the import file to distinguish it from a SYSPRO 6.1 layout file. This comment is not case-sensitive.
Line type 1 1

The first character of each line in the import file must be an R to indicate a routing file format.
Parent stock code 2 30

If you intend entering a parent stock code at run time, then you must leave this field blank in the import file.
Route 32 2

If you intend entering a route number at run time, then you must leave this field blank in the import file. If alternate routings are not required then you must leave the route number field blank.
Work center 34 20
Work center rate 54 1

If left blank, then this field defaults to 1.
What-if rate 55 1
Subcontract flag 56 1

You must enter N if this is not a subcontract operation and it must match the indicator assigned to the work center.
Set-up time 57 15
Unit run time 72 15

If the run time calculation method held against the work center is define as either block or rate, then the Unit run-time field is calculated.
Startup time 87 15
Teardown time 102 15
Wait time 117 15
Startup quantity 132 19

This cannot be zero if a non-zero value is assigned to the Startup time field.
Machine 151 30
Capacity required 181 15

The entry made here is ignored if you select the Calculate capacity required run time option.
Work operators 196 6

If left blank, then this field defaults to 1.
Productive units 202 6

If left blank, then this field defaults to 1.
Time taken 208 15

The entry made at the here is ignored if the run time calculation method held against the work center is set to unit.
Quantity 223 19
**reserved** 242 19
Milestone flag 261 1

The entry made here is ignored if the run time calculation method held against the work center is set to unit.
Elapsed time 262 10

If left blank, then this field defaults to 1.

This entry is ignored if you select the Calculate elapsed time run time option.
Movement time 272 11
Narration code 283 10
Number of pieces 293 19

If left blank, then this field defaults to 1.
Inspection flag 312 1

An entry of N (or blanks) here indicates that no inspection is required.

An entry of S indicates that sample inspection is required.

An entry of F indicates that full inspection is required.
Scrap percentage 313 5

You use this field to enter the percentage of scrap applicable to the operation.

Progressive scrap is ignored when importing operations for items defined as Notional parts.
Scrap quantity 318 19

You use this field to enter the scrap quantity applicable to this operation.

Minor set-up time 337 15

The entry made here is ignored if the minor set-up code is blank.
Minor set-up code 352 4
Toolset number 356 30
Toolset quantity 386 19
Toolset consumption 405 8
Transfer flag 413 1

An entry of P indicates percentage.

An entry of Q indicates quantity.
Transfer quantity 414 19

This is a 12.6 field dependent on the entry above.

Subcontract operations

Field Start position Field length and description
Header   ;SYSPRO IMPORT - Version=001 - IMP020

Mandatory entry of this comment on the first line of the import file to distinguish it from a SYSPRO 6.1 layout file. This comment is not case-sensitive.
Line type 1 1

The first character of each line in the import file must be an R to indicate a routing file format.
Stock code 2 30

If you intend entering a parent stock code at run time, then you must leave this field blank in the import file.
Route 32 2

If you intend entering a route number at run time, then you must leave this field blank in the import file.

If alternate routings are not required then you must leave the route number field blank.
Work center 34 20
Work center rate 54 1

If left blank, then this field defaults to 1.
What-if rate 55 1

This defaults to 1.
Subcontract flag 56 1

You must enter Y if this is a subcontract operation and it must match the indicator assigned to the work center.
Supplier 57 15

Although not validated, this field can be left blank only if the Accounts Payable module is not installed.
P/O stock code 72 30

This field is treated as a non-stocked item.
Quantity per 102 19
Unit of measure 121 10
Unit value 131 16
What-if value 147 16
Planner 163 20

If left blank, then this defaults to the entry assigned to the work center.
Buyer 183 20

If left blank, then this defaults to the entry assigned to the work center.
Lead time 203 10
Dock to stock 213 10
Off site time 223 10

If left blank, then this defaults to 1.
** filler ** 233 9

Reserved for future use.
Milestone flag 242 1
Elapsed time 243 10
Movement time 253 11
Narration code 264 10
Number of pieces 274 19

If left blank, then this field defaults to 1.
Inspection flag 293 1

An entry of N (or blanks) here indicates that no inspection is required.

An entry of S indicates that sample inspection is required

An entry of F indicates that full inspection is required.
Scrap percentage 294 5

You use this field to enter the percentage of scrap applicable to the operation.
Scrap quantity 299 19

You use this field to enter the scrap quantity applicable to the operation.
Minor set-up time 318 15
Minor set-up code 333 4
Toolset number 337 30
Toolset quantity 367 19
Toolset consumption 386 8
Transfer flag 394 1

An entry of P indicates percentage.

An entry of Q indicates quantity.
Transfer quantity 395 19

This is a 12.6 field dependent on the entry above.

File layout for 6.1

Internal operations

Field Start position Field length and description
Line type 1 1

The first character of each line in the import file must be an R to indicate a routing file format.
Parent stock code 2 30
Route 32 1
Work center 33 6
Work center rate 39 1
What-if rate 40 1
Subcontract flag 41 1
Set-up time 42 10
Unit run time 52 10
Startup time 62 10
Teardown time 72 10
Wait time 82 10
Startup quantity 92 11
Machine 103 6
Capacity required 109 11
Work operators 120 6
Productive units 126 6
Time taken 132 10
Quantity 142 11
**reserved** 153 19
Milestone flag 172 1
Elapsed time 173 3
Movement time 176 4
Narration code 180 4
Number of pieces 184 5
Inspection flag 189 1
Scrap percentage 190 5
Scrap quantity 195 8
Minor set-up time 203 10
Minor set-up code 213 4
Toolset number 217 15
Toolset quantity 232 11
Toolset consumption 243 8

Subcontract operations

Field Start position Field length and description
Line type 1 1

The first character of each line in the import file must be an R to indicate a routing file format.
Stock code 2 30
Route 32 1
Work center 33 6
Work center rate 39 1
What-if rate 40 1
Subcontract flag 41 1
Supplier 42 7
P/O stock code 49 30
Quantity per 79 13
Unit of measure 92 3
Unit value 95 11
What-if value 106 11
Planner 117 3
Buyer 120 3
Lead time 123 3
Dock to stock 126 3
Off site time 129 3
** filler ** 132 40
Milestone flag 172 1
Elapsed time 173 3
Movement time 176 4
Narration code 180 4
Number of pieces 184 5
Inspection flag 189 1
Scrap percentage 190 5
Scrap quantity 195 8
Minor set-up time 203 10
Minor set-up code 213 4
Toolset number 217 15
Toolset quantity 232 11
Toolset consumption 243 8

Notes and warnings

Restrictions and limits

  • You cannot import routings for items with a Part category defined as: Phantom part, Kit part or Planning bill.

  • You cannot attach routings to an item defined as a Co-product if that co-product is attached to a Notional part on the route selected.

  • You cannot import operations for Bills of Materials with existing routes/operations (i.e. operations on existing routes cannot be replaced with new operations for those routes). The error message Ops exist for parent/route is displayed.

Activity considerations

Operator access to the following activities within this program can be restricted. You configure this using the Operators program.

Activity Description
Listview/Forms - Export or print data Controls whether an operator can print the contents of a listview and/or output the contents of a listview to an HTML page, XML document or Excel spreadsheet.
Maintain data in import programs Controls whether an operator can maintain import data in a data grid within any SYSPRO import program before the import is performed.
Allowed to import from client Controls whether an operator can use a SYSPRO import program to import data from a client machine (in a client/server environment).
File Browse on server (C/S system) Controls whether an operator use the browse function to load the Browse on Files and Folders program to locate files on the server in a client/server environment. Operators can still navigate to a file or folder on the server by typing in the full path name in the entry field.

Inserting Application Help

You would typically follow this procedure to display help for the current program in a customized pane that can be pinned to the program window.

Information includes step-by-step instructions for the various functions available within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program.

  1. Open the program for which you want to insert application help into a customized pane.

    This functionality is only available for a program that has panes.

  2. Right-click any form field.

    You can also click the triangle menu icon that appears in the title area of a pane.

  3. Select Insert Application Help from the context-sensitive menu.

    The application help appears in a pane within your program. You can reposition the pane using the docking stickers or pin it to the program window.

Removing the Application Help pane

If you no longer want to display application help in a pane for your current program, you can simply remove it.

  1. Select the Close icon in the right-hand corner of the application help pane.

  2. Confirm that you want to delete the pane.