Difference between revisions of "MetaData Process Rules"

From All n One's bxp software Wixi

Jump to: navigation, search
 
(6 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.
  
−
== String Management ==
+
 
 +
 
 +
= Function List =
 +
 
 +
 
 
{| class="wikitable"
 
{| class="wikitable"
 
! style="width:25%" | Type
 
! style="width:25%" | Type
Line 10: Line 29:
 
! style="width:25%" | Link
 
! style="width:25%" | Link
 
|-
 
|-
−
| Library || String || [[MetaData_-_Processing_Rules_-_String_Management|Link]]
+
| style="color:green; background-color:#ffffcc;" | Library  
 +
| style="color:green; background-color:#ffffcc;" | String  
 +
| style="color:green; background-color:#ffffcc;" | [[MetaData_-_Processing_Rules_-_String_Management|Link]]
 
|-
 
|-
−
| String || Append || [[MetaData_-_Processing_Rules_-_String_Management#Append]]
+
| String || Append || [[MetaData_-_Processing_Rules_-_String_Management#Append|Link]]
 
|-
 
|-
−
| String || Prepend || [[MetaData_-_Processing_Rules_-_String_Management#Prepend]]
+
| String || Prepend || [[MetaData_-_Processing_Rules_-_String_Management#Prepend|Link]]
 
|-
 
|-
−
| String || Encapsulate || [[MetaData_-_Processing_Rules_-_String_Management#Encapsulate]]
+
| String || Encapsulate || [[MetaData_-_Processing_Rules_-_String_Management#Encapsulate|Link]]
 
|-
 
|-
−
| String || Remove Numbers || [[MetaData_-_Processing_Rules_-_String_Management#Remove_Numbers]]
+
| String || Remove Numbers || [[MetaData_-_Processing_Rules_-_String_Management#Remove_Numbers|Link]]
 
|-
 
|-
−
| String || Strip Tags || [[MetaData_-_Processing_Rules_-_String_Management#Strip_Tags]]
+
| String || Strip Tags || [[MetaData_-_Processing_Rules_-_String_Management#Strip_Tags|Link]]
 
|-
 
|-
−
| String || Replace || [[MetaData_-_Processing_Rules_-_String_Management#Replace]]
+
| String || Replace || [[MetaData_-_Processing_Rules_-_String_Management#Replace|Link]]
 
|-
 
|-
−
| String || Concatenation || [[MetaData_-_Processing_Rules_-_String_Management#Concatenation]]
+
| String || Concatenation || [[MetaData_-_Processing_Rules_-_String_Management#Concatenation|Link]]
 
|-
 
|-
−
| String || Read From || [[MetaData_-_Processing_Rules_-_String_Management#Read_From]]
+
| String || Read From || [[MetaData_-_Processing_Rules_-_String_Management#Read_From|Link]]
 
|-
 
|-
−
| String || Read Until || [[MetaData_-_Processing_Rules_-_String_Management#Read_Until]]
+
| String || Read Until || [[MetaData_-_Processing_Rules_-_String_Management#Read_Until|Link]]
 
|-
 
|-
−
| String || Set Value || [[MetaData_-_Processing_Rules_-_String_Management#Set_Value]]
+
| String || Set Value || [[MetaData_-_Processing_Rules_-_String_Management#Set_Value|Link]]
 
|-
 
|-
−
|}
+
| style="color:green; background-color:#ffffcc;" | Library
−
== Mathematical Functions ==
+
| style="color:green; background-color:#ffffcc;" | Mathematical
−
{| class="wikitable"
+
| style="color:green; background-color:#ffffcc;" | [[MetaData_-_Processing_Rules_-_Mathematical_Functions|Link]]
−
! Type
 
−
! Function
 
−
! Link
 
 
|-
 
|-
−
| Library || Mathematical || [[MetaData_-_Processing_Rules_-_Mathematical_Functions]]
+
| Mathematical || Addition || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Addition|Link]]
 
|-
 
|-
−
| Mathematical || Addition || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Addition]]
+
| Mathematical || Subtraction || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Subtraction|Link]]
 
|-
 
|-
−
| Mathematical || Subtraction || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Subtraction]]
+
| Mathematical || Multiplication || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Multiplication|Link]]
 
|-
 
|-
−
| Mathematical || Multiplication || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Multiplication]]
+
| Mathematical || Division || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Division|Link]]
 
|-
 
|-
−
| Mathematical || Division || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Division]]
+
| Mathematical || Modulus || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Modulus|Link]]
 
|-
 
|-
−
| Mathematical || Modulus || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Modulus]]
+
| Mathematical || Numeric || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Numeric|Link]]
 
|-
 
|-
−
| Mathematical || Numeric || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Numeric]]
+
| Mathematical || Summation || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Summation|Link]]
 
|-
 
|-
−
| Mathematical || Summation || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Summation]]
+
| Mathematical || Count || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Count|Link]]
 
|-
 
|-
−
| Mathematical || Count || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Count]]
+
| Mathematical || Is Unique || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Is_Unique|Link]]
 
|-
 
|-
−
| Mathematical || Is Unique || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Is_Unique]]
+
| Mathematical || Group Count || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Group_Count|Link]]
 
|-
 
|-
−
| Mathematical || Group Count || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Group_Count]]
+
| Mathematical || Group Sum || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Group_Sum|Link]]
 
|-
 
|-
−
| Mathematical || Group Sum || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Group_Sum]]
+
| 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 Functions ==
 
−
{| class="wikitable"
 
−
! Type
 
−
! Function
 
−
! Link
 
 
|-
 
|-
−
| Library || Date Time || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management]]
+
| Date Time || Date|Time || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Date.7CTime|Link]]
 
|-
 
|-
−
| Date Time || Date || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Date]]
+
| Date Time || Date|Time Now || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Date.7CTime_Now|Link]]
 
|-
 
|-
−
| Date Time || Date|Time || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Date.7CTime]]
+
| Date Time || Report Time To Seconds || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Report_Time_To_Seconds|Link]]
 
|-
 
|-
−
| Date Time || Date|Time Now || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Date.7CTime_Now]]
+
| Date Time || Seconds To Report Time || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Seconds_To_Report_Time|Link]]
 
|-
 
|-
−
| Date Time || Report Time To Seconds || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Report_Time_To_Seconds]]
+
| Date Time || Time || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Time|Link]]
 
|-
 
|-
−
| Date Time || Seconds To Report Time || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Seconds_To_Report_Time]]
+
| Date Time || Time To Seconds || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Time_To_Seconds|Link]]
 
|-
 
|-
−
| Date Time || Time || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Time]]
+
| Date Time || ZULU || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#ZULU|Link]]
 
|-
 
|-
−
| Date Time || Time To Seconds || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Time_To_Seconds]]
+
| Date Time || Day Between || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Day_Between|Link]]
 
|-
 
|-
−
| Date Time || ZULU || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#ZULU]]
+
| Date Time || Month To number || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Month_To_number|Link]]
 
|-
 
|-
−
| Date Time || Day Between || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Day_Between]]
+
| 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]]
 
|-
 
|-
−
| Date Time || Month To number || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Month_To_number]]
+
| Data || Deletion || [[MetaData_-_Processing_Rules_-_Data_Management#Deletion|Link]]
 
|-
 
|-
−
|}
+
| Data || Remove Duplicate Records || [[MetaData_-_Processing_Rules_-_Data_Management#Remove_Duplicate_Records|Link]]
−
== Data Functions ==
 
−
{| class="wikitable"
 
−
! Type
 
−
! Function
 
−
! Link
 
 
|-
 
|-
−
| Library || Data || [[MetaData_-_Processing_Rules_-_Data_Management]]
+
| Data || Flag Duplicate Records || [[MetaData_-_Processing_Rules_-_Data_Management#Flag_Duplicate_Records|Link]]
 
|-
 
|-
−
| Data || Deletion || [[MetaData_-_Processing_Rules_-_Data_Management#Deletion]]
+
| 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]]
 
|-
 
|-
−
| Data || Remove Duplicate Records || [[MetaData_-_Processing_Rules_-_Data_Management#Remove_Duplicate_Records]]
+
| Conversion || Convert Data field || [[MetaData_-_Processing_Rules_-_Data_Conversion#Convert_Data_field|Link]]
 
|-
 
|-
−
| Data || Flag Duplicate Records || [[MetaData_-_Processing_Rules_-_Data_Management#Flag_Duplicate_Records]]
+
| Conversion || Convert Form Id || [[MetaData_-_Processing_Rules_-_Data_Conversion#Convert_Form_Id|Link]]
 
|-
 
|-
−
|}
+
| Conversion || Convert Client Id || [[MetaData_-_Processing_Rules_-_Data_Conversion#Convert_Client_Id|Link]]
−
== Conversion Functions ==
 
−
{| class="wikitable"
 
−
! Type
 
−
! Function
 
−
! Link
 
−
|-
 
−
| Library || Conversion || [[MetaData_-_Processing_Rules_-_Data_Conversion]]
 
−
|-
 
−
| Conversion || Convert Data field || [[MetaData_-_Processing_Rules_-_Data_Conversion#Convert_Data_field]]
 
−
|-
 
−
| Conversion || Convert Form Id || [[MetaData_-_Processing_Rules_-_Data_Conversion#Convert_Form_Id]]
 
−
|-
 
−
| Conversion || Convert Client Id || [[MetaData_-_Processing_Rules_-_Data_Conversion#Convert_Client_Id]]
 
 
|-
 
|-
−
|}
+
| style="color:green; background-color:#ffffcc;" | Library
−
== Cross Form Functions ==
+
| style="color:green; background-color:#ffffcc;" | Cross Form  
−
{| class="wikitable"
+
| style="color:green; background-color:#ffffcc;" | [[MetaData_-_Processing_Rules_-_Cross_Form|Link]]
−
! Type
 
−
! Function
 
−
! Link
 
 
|-
 
|-
−
| Library || Cross Form || [[MetaData_-_Processing_Rules_-_Cross_Form]]
+
| 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]]
+
| Cross Form || Cross Form Update || [[MetaData_-_Processing_Rules_-_Cross_Form#Cross_Form_Update|Link]]
 
|-
 
|-
−
| Cross Form || Cross Form Update || [[MetaData_-_Processing_Rules_-_Cross_Form#Cross_Form_Update]]
+
| Cross Form || Cross Form Insert || [[MetaData_-_Processing_Rules_-_Cross_Form#Cross_Form_Insert|Link]]
 
|-
 
|-
−
| Cross Form || Cross Form Insert || [[MetaData_-_Processing_Rules_-_Cross_Form#Cross_Form_Insert]]
+
| Cross Form || Cross Form Update Simple/Custom || [[MetaData_-_Processing_Rules_-_Cross_Form#Cross_Form_Update_Simple.2FCustom|Link]]
 
|-
 
|-
−
| Cross Form || Cross Form Update Simple/Custom || [[MetaData_-_Processing_Rules_-_Cross_Form#Cross_Form_Update_Simple.2FCustom]]
+
| 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]]
+
| 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 Functions ==
 
−
{| class="wikitable"
 
−
! Type
 
−
! Function
 
−
! Link
 
 
|-
 
|-
−
| Library || CCL Specific || [[MetaData_-_Processing_Rules_-_CCL_Specific]]
+
| CCL Specific || Insert From CCL Custom || [[MetaData_-_Processing_Rules_-_CCL_Specific#Insert_From_CCL_Custom|Link]]
 
|-
 
|-
−
| CCL Specific || Insert Into CCL Simple || [[MetaData_-_Processing_Rules_-_CCL_Specific#Insert_Into_CCL_Simple]]
+
| 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]]
 
|-
 
|-
−
| CCL Specific || Insert From CCL Custom || [[MetaData_-_Processing_Rules_-_CCL_Specific#Insert_From_CCL_Custom]]
+
| 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
−
== QA Specific Functions ==
+
| style="color:green; background-color:#ffffcc;" | Comms
−
{| class="wikitable"
+
| style="color:green; background-color:#ffffcc;" | [[MetaData_-_Processing_Rules_-_Comms|Link]]
−
! Type
 
−
! Function
 
−
! Link
 
 
|-
 
|-
−
| Library || QA || [[MetaData_-_Processing_Rules_-_QA_Specific]]
+
| Comms || Email Comms || [[MetaData_-_Processing_Rules_-_Comms#EmailComms|Link]]
 
|-
 
|-
−
| QA || Cross Database QA Fail All Check || [[MetaData_-_Processing_Rules_-_QA_Specific#Cross_Database_QA_Fail_All_Check
+
| Comms || SMS Comms || [[MetaData_-_Processing_Rules_-_Comms#SMSComms|Link]]
 
|-
 
|-
 
|}
 
|}
  
  
−
[[Category:Module Specific:MetaData]]
+
[[Category:Module Specific:MetaData|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
Retrieved from ‘https://www.bxpsoftware.com/wixi/index.php?title=MetaData_Process_Rules&oldid=8288’