Function Field Mapping: Difference between revisions
Jump to navigation
Jump to search
(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...") |
No edit summary |
||
(2 intermediate revisions by the same user not shown) | |||
Line 16: | Line 16: | ||
{| class="wikitable" | {| class="wikitable" | ||
! Option Name | ! width="175" | Option Name | ||
! Description | ! Description | ||
|- | |- | ||
| 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 Value|Scripted Values]] | ||
|- | |- | ||
| SalesLogix ID | | SalesLogix ID |
Latest revision as of 22:53, 5 November 2014
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.
2. OR click the ellipsis inside the Operation column (or double-click this field).
3. OR click the + button
Select from the following types of Function Fields, more information is provided below.
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. |