You use this program to import new master data into SYSPRO using any of the SYSPRO Setup business objects (i.e. it cannot be used to update existing data).
The program imports data that is manually entered or copied into the Import Details grid. Amendment journals are generated, according to the requirements defined against the various setup programs.
| Field | Description |
|---|---|
| Validate |
Checks the validity of the data you have entered into the Import Details grid, prior to importing. |
| Import | Imports the data in the Import
Details grid, provided that your data has been
validated. When notes are imported, an RTF document containing the text is created in the ...Work/notes folder and ADMNOT is updated. This option is disabled as soon as any changes are made in the Import Details pane. Changes must be validated before the Import function is re-enabled. |
| Ignore warning | Ignores any warning messages displayed during the import process. |
| Apply if entire document valid | Imports data only if all the rows in the
Import Details grid are valid (i.e. all
rows in the grid are treated as a batch and the import fails
if any row is invalid). If you don't select this option, then valid rows are imported and invalid rows are ignored. |
| Column | Description |
|---|---|
| Data | Displays a list of SYSPRO business objects that are available for importing master data. The list resides in the IMPDTO.IMP file of the PROGRAMS folder. |
| No of existing records | Indicates the number of records that currently exist for the selected item (e.g. an entry of 4 against Currencies indicates that four currencies are currently defined for the company). |
| Program | The 6-character program name associated with the business object. To display this column you need to drag it from the Field Chooser window (activated by right-clicking the header of the pane). |
| Sequence column file path | Displays the path of the customized sequence column settings file. If it has not been customized then the word Default is displayed. This column is accessed from the Field Chooser. |
This editable list view grid enables you to paste the required data from an Excel spreadsheet, or to manually enter the data for the selected business object. When copying from an Excel spreadsheet, ensure that the first column of the spreadsheet is blank to accommodate the Validation status column (i.e. the first column) in the list view.
The list view columns correspond to the Schema information defined for the business object.
An asterisk (*) in a column heading denotes a key column.
The last column in the list view is titled Error description, and displays the first error encountered during the validation process.
To save data that was entered manually, you must use the Export to Excel option.
| Field | Description |
|---|---|
| Sequence Columns | Enables you to change the column sequence as well as
exclude or include columns. Any change to the sequence is stored in the IMPSEQ_Operator_Program file of the \Base\Settings folder (e.g. IMPSEQ_Admin_ARSSCS). An asterisk (*) against a Column name denotes a key column. Delete this file to restore the default sequence. |
| Prints the contents of the pane. | |
| Export to Excel | Exports the grid to Excel together with any data
entered. You can export a blank grid to Excel and use this as the template to create your import data in the Excel spreadsheet. |
| Search text | Filters the rows displayed in the grid. |
| Clear | Clears the search text field. |
| Edit | |
| Copy | Copies the currently selected row to the clipboard. |
| Paste (all columns) | Copies an entire entry from the clipboard. |
| Paste (visible columns only) | |
| Duplicate | Copies the currently selected row. |
| Find and Replace | |
| Validation flag | A tick in the first column indicates that the row is valid and can be imported. |
You need to enable the Import Master Data and Import Master Data Column Sequence eSignatures to access this program.
You can run the program from the Ribbon bar, or using the Run a program function together with the Setup Business Object parameter (e.g. ->-> opens the program and loads the AR Customer Setup business object).
This program does not support your regional settings.
As this is a generic program, columns are not defined as alpha, numeric or date because the fields can change depending on the setup program. Each column is therefore defined as an alpha field and whatever value is supplied to this program is merely passed to the business object that is called.
The input provided in the grid of this program must be in the same format as the input you would supply to a business object.
Therefore:
All date fields must be in the format: CCYY-MM-DD regardless of your regional settings.
All numeric fields must be in the format: ZZZZZ.99 regardless of your regional settings (i.e. using a decimal point). For example, 44,55 (using a decimal comma) is taken to mean 4455.000.
This program performs no validation, which means that it does not prevent you from entering too many characters for a field. For example, if you supply a branch code, the program will allow you to supply more than 15 characters.
Validation is only performed by the business object which is called.
The program identifies key elements, so duplicate key entries are not allowed.
This program is typically a take on program and is not intended for daily use by operators. As it is essentially a only a ‘take on’ program, it simply adds data and does not provide for ‘updates’ or ‘deletes’.
Electronic Signatures provide security access, transaction logging and event triggering. This enables you to increase control over your system changes.
Access to the following eSignature transactions within this program can be restricted at Operator, Group, Role or Company level. You configure this using the Electronic Signatures program.
| eSignature Transaction | Description |
|---|---|
| Import Master Data |
Controls access to the Import function of the Import Master Data program. |
| Import Master Data Column Sequence |
Controls access to the Sequence Columns function of the Import Master Data program. |
Errors created by a missing required element in the grid are output in the last column of the grid, providing the error is the last one in the row. If there are multiple errors, then only the last error is written to the last column.
Operator access to the following activities within this program can be restricted. You configure this using the Operator Maintenance program.
| Activity | Description |
|---|---|
| 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). |