You use this program to capture jobs using a flat ASCII import file.
| Field | Description |
|---|---|
| Import | Validates the contents of the import file and imports records according to your selection at the Import only if all rows are valid option. |
| 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. |
| 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]](images/note.png)
| Field | Description |
|---|---|
| Import only if all rows are valid | When enabled, the entire import file must be valid before any records
can be imported. The import aborts if any errors are encountered. When not enabled, valid records are imported and invalid records are ignored when the import is performed. |
| 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.
|
||||
| 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. | ||||
| 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. |
| 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 |
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.
The following lists the format of the import file that you must define to import jobs.
| Field | Start position | Field length and description |
|---|---|---|
| Header | ;SYSPRO IMPORT - Version=001 - WIPP06 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 a W to indicate a job creation file format. |
| Warehouse | 2 | 10 Mandatory |
| Stock code | 12 | 30 Mandatory If the stock item is a Co-product (Stock Codes) then it cannot be manufactured if it is attached to a notional part on the route selected. In addition, no co-products can be 'on hold'. If the stock item is a Notional part, then all its attached co-products must exist against the warehouse. |
| Revision | 42 | 5 |
| Release | 47 | 5 |
| Quantity to make | 52 | 19 Mandatory |
| Delivery date | 71 | 8 Optional |
| Job description | 79 | 50 Optional |
| Customer | 129 | 15 Optional |
| Name | 144 | 50 Optional |
| Tender date | 194 | 8 Optional |
| Job priority | 202 | 2 Optional |
| Job classification | 204 | 10 Optional If you indicated that the job classification is required Work in Progress Setup) then the job classification specified in the import file takes precedence. If the job classification is not specified in the import file, then the job classification assigned to the parent stock code takes precedence. If this is blank, then the job classification assigned within the job preferences function is used. If this is blank, then the default job classification assigned to the operator is used (Operators). If this is blank then you must manually enter a job classification. |
| WIP Ledger code | 214 | 35 Optional |
| Job confirmed (Y/N) | 249 | 1 Optional |
| Sequence checking (Y/N) | 250 | 1 |
| Include allocations (Y/N) | 251 | 1 Stocked lines only. Set this to Y to create the job for a stocked item with a BOM, and include all allocations against the job. This will create the job and the material/operation allocations based on the BOM. |
| Component warehouse | 252 | 10 Stocked lines only. |
| Create sub jobs from components | 262 | 1 Stocked lines only. |
| Use parent ledger code for all jobs (Y/N) | 263 | 1 Stocked lines only. |
| Check delivery date + lead time (Y/N) | 264 | 1 Stocked lines only. |
| Route number | 265 | 2 Stocked lines only. |
| Traceable (Y/N) | 267 | 1 Billing information for non-stocked lines only. |
| Selling price | 268 | 16 Billing information for non-stocked lines only. Enter the selling price of a non-stocked item. |
| Expected cost (operations) | 284 | 16 Billing information for non-stocked lines only. |
| Expected cost (materials) | 300 | 16 Billing information for non-stocked lines only. |
| Cost mark-up (operations) | 316 | 6 Billing information for non-stocked lines only. |
| Cost mark-up (material) | 322 | 6 Billing information for non-stocked lines only. |
| Profit percentage | 328 | 6 Billing information for non-stocked lines only. |
| Manual job number | 334 | 20 Billing information for non-stocked lines only. Importing manual job numbers does not cater for multi-level jobs. In addition, if you are using manual job numbering and you do not include this in the import file, then you are prompted for the job number at the time of importing the line. |
| Gross quantity | 354 | 1 This is applicable if Progressive scrap is enabled (Bill of Materials Setup). Y - indicates that the quantity to make is the gross quantity.N (or blank) - indicates that the quantity to make is a net quantity. |
| Date calculation method | 355 | 1 S - Start date to be calculated. This is the default. If any value other than S, M or D is entered, or the field is left blank, then the method defaults back to S and no error is displayed. M - Manual date. D - Delivery date to be calculated. |
| Start date | 356 | 8 The job start date. Defaults to current system date if not entered. This cannot be earlier than the Delivery date. |
| Field | Start position | Field length and description |
|---|---|---|
| Line type | 1 | 1 The first character of each line in the import file must be a W to indicate a job creation file format. |
| Warehouse | 2 | 2 |
| Stock code | 4 | 30 |
| Revision | 34 | 3 |
| Release | 37 | 3 |
| Quantity to make | 40 | 11 |
| Delivery date | 51 | 6 |
| Job description | 57 | 30 |
| Customer | 87 | 7 |
| Name | 94 | 30 |
| Tender date | 124 | 6 |
| Job priority | 130 | 2 |
| Job classification | 132 | 4 |
| WIP Ledger code | 136 | 15 |
| Job confirmed (Y/N) | 151 | 1 |
| Sequence checking (Y/N) | 152 | 1 |
| Include allocations (Y/N) | 153 | 1 |
| Component warehouse | 154 | 2 |
| Create sub jobs from components | 156 | 1 |
| Use parent ledger code for all jobs (Y/N) | 157 | 1 |
| Check delivery date + lead time (Y/N) | 158 | 1 |
| Route number | 159 | 1 |
| Traceable (Y/N) | 160 | 1 |
| Selling price | 161 | 16 |
| Expected cost (operations) | 177 | 16 |
| Expected cost (materials) | 193 | 16 |
| Cost mark-up (operations) | 209 | 6 |
| Cost mark-up (material) | 215 | 6 |
| Profit percentage | 221 | 6 |
| Manual job number | 227 | 8 |
| Gross quantity | 228 | 1 |
-
You can only import jobs for stock codes that have no allocations when the Bill of Materials module is not installed.
-
You can specify login parameters against the SYSPRO icon to import jobs automatically, with minimal operator intervention. If errors are encountered then an error file is created (i.e. XXXXXX.ERR where XXXXXX indicates the operator) and the entire import is aborted (see Command Line Parameters).
Operator intervention is typically required in certain instances:
-
If your job numbering method is set to manual (Set Key Information) then you are prompted to enter a job number.
-
If factory documentation is required on-line and the job still needs to be confirmed.
-
-
If you have a BOM with active Floor stock and you are confirming the job at the time of creation, then you cannot run this program in automation mode.
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.
-
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.
-
Right-click any form field.
You can also click the triangle menu icon that appears in the title area of a pane.
-
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.
-
Select the Close icon in the right-hand corner of the application help pane.
-
Confirm that you want to delete the pane.