Anonymous, bureaucrat, administrator
7,528
edits
Changes
From All n One's bxp software Wixi
no edit summary
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.
= Data Cleanup Functions==============================Function: * DeleteFunction: * DeDupe
= Maths functions==============================
* Add
* Subtract
* Numeric - Forces the value to be numeric. Defaults to 0 if string or unrecognised
* Boolean - Forces the value to be Boolean. Defaults to false if unrecognised.
= String Functions =
* Prepend - Add to the start of the string
* DateTime - Format the time in Universal Date Time format yyyy-mm-dd hh:mm:ss
* Date - yyyy-mm-dd only
* Percentage - Divide 1 by 2, output formatted number * 100, limit to 2 decimal places
* Sum
* Count
* IsUnique
* Convert_Title
* Convert_County
* Convert_DataField
= Data Transfer==============================Function: * CrossDatabase_UpdateFunction: * CrossDatabase_Insert
