Function Field Mapping - Revision history

Admin at 22:53, 5 November 2014

2014-11-05T22:53:08Z

← Older revision		Revision as of 22:53, 5 November 2014
Line 29:		Line 29:
	\|-		\|-
	\| Scripted Value		\| Scripted Value
	\| Allows the user to write a VBScript function to perform custom operations for each field. The VBScript function provides a skeleton function called “ScriptedField”. The value that will be used is whatever is returned out of this function. More on [[Scripted Values]]		\| Allows the user to write a VBScript function to perform custom operations for each field. The VBScript function provides a skeleton function called “ScriptedField”. The value that will be used is whatever is returned out of this function. More on [[Scripted Value\|Scripted Values]]
	\|-		\|-
	\| SalesLogix ID		\| SalesLogix ID

Admin at 22:51, 5 November 2014

2014-11-05T22:51:00Z

← Older revision		Revision as of 22:51, 5 November 2014
Line 20:		Line 20:
	\|-		\|-
	\| SQL Lookup		\| SQL Lookup
	\| Performs a database lookup on the Destination database. Supply a SQL SELECT statement, will return the first column from the first row. More on Server-Side Lookups		\| Performs a database lookup on the Destination database. Supply a SQL SELECT statement, will return the first column from the first row. More on [[SQL Lookups\|Server-Side Lookups]]
	\|-		\|-
	\| Smart Lookup		\| Smart Lookup
Line 29:		Line 29:
	\|-		\|-
	\| Scripted Value		\| Scripted Value
	\| Allows the user to write a VBScript function to perform custom operations for each field. The VBScript function provides a skeleton function called “ScriptedField”. The value that will be used is whatever is returned out of this function. More on Scripted Values		\| Allows the user to write a VBScript function to perform custom operations for each field. The VBScript function provides a skeleton function called “ScriptedField”. The value that will be used is whatever is returned out of this function. More on [[Scripted Values]]
	\|-		\|-
	\| SalesLogix ID		\| SalesLogix ID

Admin at 19:55, 5 November 2014

2014-11-05T19:55:56Z

← Older revision		Revision as of 19:55, 5 November 2014
Line 16:		Line 16:

	{\| class="wikitable"		{\| class="wikitable"
	! Option Name		! width="175" \| Option Name
	! Description		! Description
	\|-		\|-

Admin: Created page with "To begin creating a Function Field, you can do this 3 ways. 1. Select “Function Field” from the Origin Fields drop-down.To begin creating a Function Field, select “Fun..."

2014-11-05T19:54:23Z

Created page with "To begin creating a Function Field, you can do this 3 ways. 1. Select “Function Field” from the Origin Fields drop-down.To begin creating a Function Field, select “Fun..."

New page

To begin creating a Function Field, you can do this 3 ways.

1. Select “Function Field” from the Origin Fields drop-down.To begin creating a Function Field, select “Function Field” from the Origin Fields drop-down.

[[file:functionfieldmapping.png]]

2. OR click the ellipsis inside the Operation column (or double-click this field).

[[file:functionfield2.png]]

3. OR click the + button

[[file:functionfield3.png]]

Select from the following types of Function Fields, more information is provided below.

{| class="wikitable"
! Option Name
! Description
|-
| SQL Lookup
| Performs a database lookup on the Destination database. Supply a SQL SELECT statement, will return the first column from the first row. More on Server-Side Lookups
|-
| Smart Lookup
| Performs a lookup on the destination, returning a single field’s value. Allows caching of results so the multiple runs of the same lookup don’t have to make round-trips to the destination. This cache is stored in memory, so it’s a good idea to only use it when there is a high chance of the same queries, otherwise an out of memory exception could occur when caching large amounts of data.
|-
| Hardcoded Value
| Allows the user to specify a static value, although you can also insert aVariable here as well. It is not necessary to include quotes for text/string values.
|-
| Scripted Value
| Allows the user to write a VBScript function to perform custom operations for each field. The VBScript function provides a skeleton function called “ScriptedField”. The value that will be used is whatever is returned out of this function. More on Scripted Values
|-
| SalesLogix ID
| For OLE DB destinations using the SalesLogix OLE DB adapter, this function will be available. Automatically generated a new Saleslogix ID for this field, based on the Stage’s destination table.
|-
| Format Conversion
| Convert source data to another format. Options are:Rich Text (RTF) -to- Plain TextHTML -to- Plain TextBase64 -to- BinaryBinary -to- Base64File -to- Base64
|-
| Current Date/Time
| Inserts the current Date/Time at the server. Formats include Date/Time, Date Only, Time Only.
|}