•Data Management Configuration
Summary
Script Name |
Update Miscellaneous Item Option Availability |
Minimum Supported Version |
7.28.0 |
Source Type |
Single Source |
Script Definitions |
Update Miscellaneous Item Option Availability |
Use Case
The Update Miscellaneous Item Option Availability script is used to update the availability of a miscellaneous item's option by using the miscellaneous item's name and option name or using the value of a miscellaneous item’s option’s 'Data 1' field.
Source File Format
This script is run using a single .CSV or BI (saved as a text/csv 'Extract Tempate') source file. and is designed to work with two varaitions.
The following image illustrates the columns for the first variation of the miscellaneousItems_source_file:
The following image illustrates the columns for the second variation of the miscellaneousItems_source_file:
The following table outlines the field mapping:
Column |
Required? |
Source Column Header |
Field Name |
UI Field Location |
1 |
Yes |
miscellaneous item |
N/A - the value is used to uniquely identify the miscellaneous item to update |
N/A |
How the Script Works
The following table outlines the actions and expected results of the script:
Condition |
Action |
Expected Results |
A value is supplied through the source file to identify a miscellaneous item.
This can either by the miscellaneous item's 'Name' or the value of the 'Data 1' on the Miscellaneous Item|Options page. |
The script loads the miscellaneous item using the supplied value from the source file and the value of the 'Miscellaneous Item Identifier' execution field from the script job. |
The miscellaneous item record is loaded. If the miscellaneous item cannot be identified using the value from the source file and the specified identifier, the script fails. |
The miscellaneous item is loaded successfully. |
The script matches the miscellaneous item using the supplied 'Option Name' or 'Data 1' values. |
The status of the option is updated based on the specified value. If none of the options on the miscellaneous item matches the one supplied, the script fails. |
The miscellaneous item could not be found. |
The script does nothing. |
The script fails. |
Data Management Configuration
The following outlines the data management job configuration:
•Data Management Job Name: Update Miscellaneous Item Option Availability
•Script Definition: Update Miscellaneous Item Option Availability
Job Criteria Section |
|
Field |
Field Value |
Miscellaneous Item Identifier |
Any value from the miscellaneous item identifiers list can be used, based on the values in the source file to identify a miscellaneous item uniquely. The default value is set to Miscellaneous Item Name. |
The following image is an example of the Data Management|Schedule page when creating a job using all of the available source files:
