Personal tools

Log in

Changes

From All n One's bxp software Wixi

Jump to: navigation, search

MetaData - Processing Rules - Data Conversion

3,271 bytes added, 22:36, 7 February 2017
Created page with "= Overview = For more information on {| class="wikitable" ! Area ! Link |- | MetaData please refer here || MetaData_-_Start_Here |- | Processing rules please refer here..."
= Overview =

For more information on

{| class="wikitable"
! Area
! Link
|-
| MetaData please refer here || [[MetaData_-_Start_Here]]
|-
| Processing rules please refer here || [[MetaData_Process_Rules]]
|-
| Parameter construction please refer here || [[MetaData_Program_and_Outcomes]]
|-
|}

= Reference =

This wixi article is meant to serve as a reference guide to a subset of MetaData Processing Rules.


= Rules =


== Convert Data field ==


There may be CampaignList or CampaignSearch type fields with the databases where cross campaign field translation would be required to link a parent record with a child record.


Required fields to execute rule:
# Rule Name
# Form id (the same as the current sequence)
# Destination field
# Form Id contains the search values
# Fields that contain the search values
# Form Id to search in
# Fields to search in
# Form Id to get return values
# Return value fields


Example:
<syntaxhighlight lang="xml">
Rule Name[[-SEP-]]Form Id[[-SEP-]]Destination Fields[[-SEP-]]Form Id values[[-SEP]]Fields containing values[[-SEP-]]Form Id To Search[[-SEP-]]Fields containing values[[-SEP-]]Form Id return values[[-SEP-]]Fields with Return values[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
</syntaxhighlight>



== Convert Form Id ==


The convert form Id rule allows for the conversion of a form Id to be converted to any piece of information in the campaign table


Required fields to execute rule:
# Rule Name
# Field in the campaign table to return
# Destination field
# Field with the search value
# Form id (the same as the current sequence)


Example:
<syntaxhighlight lang="xml">
Convert_FormId_FormField[[-SEP-]]Field to return[[-SEP-]]Destination field[[-SEP-]]Search value[[-SEP-]]form id[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
</syntaxhighlight>


Example (with replacement values):
<syntaxhighlight lang="xml">
Convert_FormId_FormField[[-SEP-]]strCampaign_Name[[-SEP-]]strCDA_1_field_0_1[[-SEP-]]strCDA_1_field_0_2[[-SEP-]]1[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]] 
</syntaxhighlight>



== Convert Client Id ==


The convert client Id rule allows for the conversion of a clients Id to be converted to any piece of information in the client table

Required fields to execute rule:
# Rule Name
# Field in the campaign table to return
# Destination field
# Field with the search value
# Form id (the same as the current sequence)


Example:
<syntaxhighlight lang="xml">
Convert_FormId_FormField[[-SEP-]]Field to return[[-SEP-]]Destination field[[-SEP-]]Search value[[-SEP-]]form id[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
</syntaxhighlight>


Example (with replacement values):
<syntaxhighlight lang="xml">
Convert_ClientId_ClientField[[-SEP-]]strClient_CompanyStaffIdNumber[[-SEP-]]strCDA_1_field_0_1[[-SEP-]]strCDA_1_field_0_2[[-SEP-]]1[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]] 
</syntaxhighlight>



[[Category:Topic:MetaData]]
[[Category:Module Specific:MetaData]]
7,528
edits