Difference between revisions of "MetaData Process Rules"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) |
|||
| (3 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
= Overview = | = Overview = | ||
| + | |||
| + | {| class="wikitable" style="width:100%;" | ||
| + | ! style="width:20%;" | Overview | ||
| + | ! style="width:20%;" | Retrieve | ||
| + | ! style="width:20%;" | Input | ||
| + | ! style="width:20%;" | Process | ||
| + | ! style="width:20%;" | Output | ||
| + | |- | ||
| + | | style="text-align:center;" | [[MetaData_-_Start_Here|Link]] | ||
| + | | style="text-align:center;" | [[MetaData_-_Retrieve|Link]] | ||
| + | | style="text-align:center;" | [[MetaData_Process_Input|Link]] | ||
| + | | style="text-align:center;" | [[MetaData_Process_Rules|Link]] | ||
| + | | style="text-align:center;" | [[MetaData_Process_Output|Link]] | ||
| + | |- | ||
| + | |} | ||
MetaData Process rules are rules that allow for the processing of raw data. There are quite a number of rules and parameters used for each rule. Below is a list of the rules and how each one is set up. There is also a link off to the reference document for that function. | MetaData Process rules are rules that allow for the processing of raw data. There are quite a number of rules and parameters used for each rule. Below is a list of the rules and how each one is set up. There is also a link off to the reference document for that function. | ||
| − | == | + | |
| + | |||
| + | = Function List = | ||
| + | |||
| + | |||
{| class="wikitable" | {| class="wikitable" | ||
! style="width:25%" | Type | ! style="width:25%" | Type | ||
| Line 34: | Line 53: | ||
| String || Set Value || [[MetaData_-_Processing_Rules_-_String_Management#Set_Value|Link]] | | String || Set Value || [[MetaData_-_Processing_Rules_-_String_Management#Set_Value|Link]] | ||
|- | |- | ||
| − | | style="color:green; background-color:#ffffcc;" | Library || Mathematical || [[MetaData_-_Processing_Rules_-_Mathematical_Functions|Link]] | + | | style="color:green; background-color:#ffffcc;" | Library |
| + | | style="color:green; background-color:#ffffcc;" | Mathematical | ||
| + | | style="color:green; background-color:#ffffcc;" | [[MetaData_-_Processing_Rules_-_Mathematical_Functions|Link]] | ||
|- | |- | ||
| Mathematical || Addition || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Addition|Link]] | | Mathematical || Addition || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Addition|Link]] | ||
| Line 58: | Line 79: | ||
| Mathematical || Group Sum || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Group_Sum|Link]] | | Mathematical || Group Sum || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Group_Sum|Link]] | ||
|- | |- | ||
| − | | style="color:green; background-color:#ffffcc;" | Library || Date Time || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management|Link]] | + | | style="color:green; background-color:#ffffcc;" | Library |
| + | | style="color:green; background-color:#ffffcc;" | Date Time | ||
| + | | style="color:green; background-color:#ffffcc;" | [[MetaData_-_Processing_Rules_-_Date_and_Time_Management|Link]] | ||
|- | |- | ||
| Date Time || Date || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Date|Link]] | | Date Time || Date || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Date|Link]] | ||
| Line 80: | Line 103: | ||
| Date Time || Month To number || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Month_To_number|Link]] | | Date Time || Month To number || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Month_To_number|Link]] | ||
|- | |- | ||
| − | | style="color:green; background-color:#ffffcc;" | Library || Data || [[MetaData_-_Processing_Rules_-_Data_Management|Link]] | + | | style="color:green; background-color:#ffffcc;" | Library |
| + | | style="color:green; background-color:#ffffcc;" | Data | ||
| + | | style="color:green; background-color:#ffffcc;" | [[MetaData_-_Processing_Rules_-_Data_Management|Link]] | ||
|- | |- | ||
| Data || Deletion || [[MetaData_-_Processing_Rules_-_Data_Management#Deletion|Link]] | | Data || Deletion || [[MetaData_-_Processing_Rules_-_Data_Management#Deletion|Link]] | ||
| Line 88: | Line 113: | ||
| Data || Flag Duplicate Records || [[MetaData_-_Processing_Rules_-_Data_Management#Flag_Duplicate_Records|Link]] | | Data || Flag Duplicate Records || [[MetaData_-_Processing_Rules_-_Data_Management#Flag_Duplicate_Records|Link]] | ||
|- | |- | ||
| − | | style="color:green; background-color:#ffffcc;" | Library || Conversion || [[MetaData_-_Processing_Rules_-_Data_Conversion|Link]] | + | | style="color:green; background-color:#ffffcc;" | Library |
| + | | style="color:green; background-color:#ffffcc;" | Conversion | ||
| + | | style="color:green; background-color:#ffffcc;" | [[MetaData_-_Processing_Rules_-_Data_Conversion|Link]] | ||
|- | |- | ||
| Conversion || Convert Data field || [[MetaData_-_Processing_Rules_-_Data_Conversion#Convert_Data_field|Link]] | | Conversion || Convert Data field || [[MetaData_-_Processing_Rules_-_Data_Conversion#Convert_Data_field|Link]] | ||
| Line 96: | Line 123: | ||
| Conversion || Convert Client Id || [[MetaData_-_Processing_Rules_-_Data_Conversion#Convert_Client_Id|Link]] | | Conversion || Convert Client Id || [[MetaData_-_Processing_Rules_-_Data_Conversion#Convert_Client_Id|Link]] | ||
|- | |- | ||
| − | | style="color:green; background-color:#ffffcc;" | Library || Cross Form || [[MetaData_-_Processing_Rules_-_Cross_Form|Link]] | + | | style="color:green; background-color:#ffffcc;" | Library |
| + | | style="color:green; background-color:#ffffcc;" | Cross Form | ||
| + | | style="color:green; background-color:#ffffcc;" | [[MetaData_-_Processing_Rules_-_Cross_Form|Link]] | ||
|- | |- | ||
| Cross Form || Copy To Destination || [[MetaData_-_Processing_Rules_-_Cross_Form#Copy_To_Destination|Link]] | | Cross Form || Copy To Destination || [[MetaData_-_Processing_Rules_-_Cross_Form#Copy_To_Destination|Link]] | ||
| Line 108: | Line 137: | ||
| Cross Form || Cross Form Update Smart || [[MetaData_-_Processing_Rules_-_Cross_Form#Cross_Form_Update_Smart|Link]] | | Cross Form || Cross Form Update Smart || [[MetaData_-_Processing_Rules_-_Cross_Form#Cross_Form_Update_Smart|Link]] | ||
|- | |- | ||
| − | | style="color:green; background-color:#ffffcc;" | Library || CCL Specific || [[MetaData_-_Processing_Rules_-_CCL_Specific|Link]] | + | | style="color:green; background-color:#ffffcc;" | Library |
| + | | style="color:green; background-color:#ffffcc;" | CCL Specific | ||
| + | | style="color:green; background-color:#ffffcc;" | [[MetaData_-_Processing_Rules_-_CCL_Specific|Link]] | ||
|- | |- | ||
| CCL Specific || Insert Into CCL Simple || [[MetaData_-_Processing_Rules_-_CCL_Specific#Insert_Into_CCL_Simple|Link]] | | CCL Specific || Insert Into CCL Simple || [[MetaData_-_Processing_Rules_-_CCL_Specific#Insert_Into_CCL_Simple|Link]] | ||
| Line 114: | Line 145: | ||
| CCL Specific || Insert From CCL Custom || [[MetaData_-_Processing_Rules_-_CCL_Specific#Insert_From_CCL_Custom|Link]] | | CCL Specific || Insert From CCL Custom || [[MetaData_-_Processing_Rules_-_CCL_Specific#Insert_From_CCL_Custom|Link]] | ||
|- | |- | ||
| − | | style="color:green; background-color:#ffffcc;" | Library || QA || [[MetaData_-_Processing_Rules_-_QA_Specific|Link]] | + | | style="color:green; background-color:#ffffcc;" | Library |
| + | | style="color:green; background-color:#ffffcc;" | QA | ||
| + | | style="color:green; background-color:#ffffcc;" | [[MetaData_-_Processing_Rules_-_QA_Specific|Link]] | ||
|- | |- | ||
| QA || Cross Database QA Fail All Check || [[MetaData_-_Processing_Rules_-_QA_Specific#Cross_Database_QA_Fail_All_Check|Link]] | | QA || Cross Database QA Fail All Check || [[MetaData_-_Processing_Rules_-_QA_Specific#Cross_Database_QA_Fail_All_Check|Link]] | ||
| + | |- | ||
| + | | style="color:green; background-color:#ffffcc;" | Library | ||
| + | | style="color:green; background-color:#ffffcc;" | Comms | ||
| + | | style="color:green; background-color:#ffffcc;" | [[MetaData_-_Processing_Rules_-_Comms|Link]] | ||
| + | |- | ||
| + | | Comms || Email Comms || [[MetaData_-_Processing_Rules_-_Comms#EmailComms|Link]] | ||
| + | |- | ||
| + | | Comms || SMS Comms || [[MetaData_-_Processing_Rules_-_Comms#SMSComms|Link]] | ||
|- | |- | ||
|} | |} | ||
Latest revision as of 10:48, 23 February 2018
1 Overview
| Overview | Retrieve | Input | Process | Output |
|---|---|---|---|---|
| Link | Link | Link | Link | Link |
MetaData Process rules are rules that allow for the processing of raw data. There are quite a number of rules and parameters used for each rule. Below is a list of the rules and how each one is set up. There is also a link off to the reference document for that function.
2 Function List
| Type | Function | Link |
|---|---|---|
| Library | String | Link |
| String | Append | Link |
| String | Prepend | Link |
| String | Encapsulate | Link |
| String | Remove Numbers | Link |
| String | Strip Tags | Link |
| String | Replace | Link |
| String | Concatenation | Link |
| String | Read From | Link |
| String | Read Until | Link |
| String | Set Value | Link |
| Library | Mathematical | Link |
| Mathematical | Addition | Link |
| Mathematical | Subtraction | Link |
| Mathematical | Multiplication | Link |
| Mathematical | Division | Link |
| Mathematical | Modulus | Link |
| Mathematical | Numeric | Link |
| Mathematical | Summation | Link |
| Mathematical | Count | Link |
| Mathematical | Is Unique | Link |
| Mathematical | Group Count | Link |
| Mathematical | Group Sum | Link |
| Library | Date Time | Link |
| Date Time | Date | Link |
| Date Time | Time | Link |
| Date Time | Time Now | Link |
| Date Time | Report Time To Seconds | Link |
| Date Time | Seconds To Report Time | Link |
| Date Time | Time | Link |
| Date Time | Time To Seconds | Link |
| Date Time | ZULU | Link |
| Date Time | Day Between | Link |
| Date Time | Month To number | Link |
| Library | Data | Link |
| Data | Deletion | Link |
| Data | Remove Duplicate Records | Link |
| Data | Flag Duplicate Records | Link |
| Library | Conversion | Link |
| Conversion | Convert Data field | Link |
| Conversion | Convert Form Id | Link |
| Conversion | Convert Client Id | Link |
| Library | Cross Form | Link |
| Cross Form | Copy To Destination | Link |
| Cross Form | Cross Form Update | Link |
| Cross Form | Cross Form Insert | Link |
| Cross Form | Cross Form Update Simple/Custom | Link |
| Cross Form | Cross Form Update Smart | Link |
| Library | CCL Specific | Link |
| CCL Specific | Insert Into CCL Simple | Link |
| CCL Specific | Insert From CCL Custom | Link |
| Library | QA | Link |
| QA | Cross Database QA Fail All Check | Link |
| Library | Comms | Link |
| Comms | Email Comms | Link |
| Comms | SMS Comms | Link |