MetaData Process Input - Revision history

Philip Lacey at 11:57, 18 February 2018

2018-02-18T11:57:22Z

Philip Lacey at 20:36, 7 February 2017

2017-02-07T20:36:40Z

Philip Lacey at 20:34, 7 February 2017

2017-02-07T20:34:33Z

Philip Lacey at 02:00, 22 March 2014

2014-03-22T02:00:16Z

Philip Lacey: Created page with "When creating a MetaData Input rule you are creating a set of parameters to retrieve data from a file into a Business Express Campaign Database. These rules dictate the way t..."

2013-03-12T16:50:33Z

Created page with "When creating a MetaData Input rule you are creating a set of parameters to retrieve data from a file into a Business Express Campaign Database. These rules dictate the way t..."

New page

When creating a MetaData Input rule you are creating a set of parameters to retrieve data from a file into a bxp software Campaign Database.

These rules dictate the way the system will process the file.

* 0 Function - Delimited file, Excel, Structured File
* 1 Campaign_Id - intCampaign_Id
* 2 FilenamePattern - *.csv
* 3 Delimiting Character - ,
* 4 Delete When Done - True|False
* 5 Force Field Match - True|False
* 6 Field Mapping - Fields to put into
* 7 Field Length - Structured field width
* 8 Escape Characters*
* 9 Escape Delimited - \
* 10 Blind - True|False
* 11 Encoding - -1 = Unicode 0 = ASCII

← Older revision		Revision as of 11:57, 18 February 2018
Line 1:		Line 1:
		+	= 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]]
		+	\|-
		+	\|}
		+
		+
	When creating a MetaData Input rule you are creating a set of parameters to retrieve data from a file into a bxp software Campaign Database.		When creating a MetaData Input rule you are creating a set of parameters to retrieve data from a file into a bxp software Campaign Database.

@@ Line 6: / Line 6: @@
 ! Parameter
 ! Reason
-! Link
+! Options
 |-
-| 0   || Function - Delimited file, Excel, Structured File
+| 0   || Function || Delimited file, Excel, Structured File
 |-
-| 1   || Campaign_Id - intCampaign_Id
+| 1   || Campaign_Id || intCampaign_Id
 |-
-| 2   || FilenamePattern - *.csv
+| 2   || FilenamePattern || *.csv
 |-
-| 3   || Delimiting Character - ,
+| 3   || Delimiting Character || ,
 |-
-| 4   || Delete When Done - True|False
+| 4   || Delete When Done || True|False
 |-
-| 5   || Force Field Match - True|False
+| 5   || Force Field Match || True|False
 |-
-| 6   || Field Mapping - Fields to put into
+| 6   || Field Mapping || Fields to put into
 |-
-| 7   || Field Length - Structured field width
+| 7   || Field Length || Structured field width
 |-
-| 8   || Escape Characters*
+| 8   || Escape Characters || *
 |-
-| 9   || Escape Delimited - \
+| 9   || Escape Delimited || \
 |-
-| 10  || Blind - True|False
+| 10  || Blind || True|False
 |-
-| 11  || Encoding - -1 = Unicode  0 = ASCII
+| 11  || Encoding || -1 = Unicode  0 = ASCII
 |-
 |}
@@ Line 68: / Line 68: @@
 |-
 |}
 == Function: Read_Excel ==
 Reading from an Excel spreadsheet is supported for all types of Excel spreadsheet.  There are a number of options also available for Excel sheets.
-| Destination Database
-| The database into which the file will attempt to be loaded.
+{| class="wikitable"
 |-
 | Filename Pattern
@@ Line 104: / Line 110: @@
 ! Description
 |-
-| Destination Database
+| Destination Form
-| The database into which the file will attempt to be loaded.
+| The form into which the file will attempt to be loaded.
 |-
 | Filename Pattern

← Older revision		Revision as of 02:00, 22 March 2014
Line 15:		Line 15:
	* 10 Blind - True\|False		* 10 Blind - True\|False
	* 11 Encoding - -1 = Unicode 0 = ASCII		* 11 Encoding - -1 = Unicode 0 = ASCII
		+
		+
		+	[[Category:Module Specific:MetaData]]

@@ Line 3: / Line 3: @@
 These rules dictate the way the system will process the file.
-* 0   Function - Delimited file, Excel, Structured File
+{| class="wikitable"
-* 1   Campaign_Id - intCampaign_Id
+! Parameter
-* 2   FilenamePattern - *.csv
+! Reason
-* 3   Delimiting Character - ,
+! Link
-* 4   Delete When Done - True|False
+|-
-* 5   Force Field Match - True|False
+| 0   || Function - Delimited file, Excel, Structured File
-* 6   Field Mapping - Fields to put into
+|-
-* 7   Field Length - Structured field width
+| 1   || Campaign_Id - intCampaign_Id
-* 8   Escape Characters*
+|-
-* 9   Escape Delimited - \
+| 2   || FilenamePattern - *.csv
-* 10  Blind - True|False
+|-
-* 11  Encoding - -1 = Unicode  0 = ASCII
+| 3   || Delimiting Character - ,
 [[Category:Module Specific:MetaData]]