Follow-On Topics

Related Topics

# About Internal Memory

The Internal Memory uses an existing Repository to memorise task data, by mapping fields from the recordset against Repository fields. Features include:
|  | Using a Filter Data step, the current Repository data for a task may be compared to a new recordset produced at task run-time to filter the data passed to the output step for processing
|  | Repository data may be exported as an XML or CSV file for backup purposes, or for use in other applications
|  | Previously exported XML files may be imported into King Task Centre
|  | Previously exported or new CSV files may be imported into King Task Centre
| Click the image to view full size.

|  | A Repository may be selected for use in any task so that different columns may be populated from different data sources

|  | Repository data values may be manually edited, rows deleted, or the Repository "reset" by deleting all the data

|  | The Repository schema may be edited to change column details, or insert or delete columns as required

The dialog box is used to configure an internal Memory Definition through the following:

|  | Name — A name for the Memory Definition may be manually entered. This initially displays Internal Memory but this may then be edited as required.

|  | Repository Name — Displays the name of the Repository to be used. This initially displays a name made up of the Task folder, Task name and the output Step, for example, `Sales\Weekly Report\Send Message (SMTP)`. The name may then be edited as required. Alternatively, an existing Repository may be selected through the Select Repository button.

|  | Select Repository — Opens the Select Repository dialog box to enable a Repository to be selected.

|  | Items to Memorise — Displays a list of the columns for which data is to be memorised. The columns are dragged and dropped into the table from the Task Browser dialog box. The table displays details for each column under the following headings:

|  | Repository Column — Displays the name of the column.

|  | Value — Displays the actual column value. The following check boxes are provided for selection:
|  | Key — Enables the column to be selected as a key column in the Repository.
|  | Stored — Select if the column data is to be stored in the Repository.
|  | Display — Select if the column data is to be displayed in the Data Manager area of the Data tab in the Repository dialog box.
|  | Encrypted — Select if the column data is to be encrypted when generated.
|  | Compressed — Select if the column data is to be compressed when generated.
|  | Clear — Removes the selected column from the table.

The following memory option radio buttons are provided for selection:

Do not memorise — No data is memorised.

|  | Memorise information for each row processed — Data is memorised for each row processed.

|  | Memorise information for each row processed based on a rule — Data is memorised for each row based on a rule. A field below the option displays the selected rule. Clicking on the Edit button opens a Rule Script dialog box to create a new rule or edit an existing one.

|  | Memorise one-off summary information — A summary of the data processed is memorised.

|  | Use Transactions — Provides the following option check boxes for selection:

|  | Commit Repository Rows on Success — Copies rows that were successfully processed, based on the memory options selected, into the selected Repository.

|  | Commit Repository Rows on Failure — Copies rows that failed to be processed, based on the memory options selected, into the selected Repository.

|  | Commit Repository Rows based on a rule — Copies rows based on a rule into the selected Repository. A field below the option displays the selected rule. Clicking on the Edit button opens a Rule Script dialog box to create a new rule or edit an existing one.

Copyright © 2018 Quadrant Software B.V. All rights reserved.