Back | Forward

The values in the cells on an Excel spreadsheet created from an import file template have special significance in batch processing.

• Cell A1: File paths of the LOG and ERR (Error) output files. The path names are separated by a semicolon.

• Cell A2: Screen ID (2134 in the illustration) – Screen on which the batch job will be executed.  

• Cell A3: Type of batch file (I in the illustration) – File processing type (Insert, Modify, or Delete). The I in the illustration indicates this is an import file. Modify files have an M; delete files have a D.

• Cell B3: Number of restrictions entered in the filter (0 in the illustration) – Insert files should have zero restrictions in the filter; modify and delete files may have one or more filter restrictions.

• Cell C3: Number of data items included in the transaction (3 in the illustration) – For insert files, the number of values that will be entered. For modify files, the number of values that will be modified. For delete files, the number of values that will be deleted.

• Cell D3: Window ID (532 in the illustration) – Screen tab on which the batch job will be executed.

• Cell E3: Control ID (2 in the illustration) – Screen field on which the batch job will be executed.

• Tip: To obtain a list of field information for a screen, use the Queries/Reports -> Query/Report Generator screen to execute the PR:UI-WINDOWS_CTRLS report, restricted to the screen you are working with. To learn a specific screen's ID, access the screen and display its properties (screen, window, and control IDs; table and column name).