Quick question since the EIE admin guide isn't any help. What's the syntax for using EIE functions in data mappings? I have the Last Modified By field on SHARE:Contact mapped to a field in my external vendor database and the column in my vendor database is limited to 20 characters, so I want to use the LEFT() function to truncate the value coming from Remedy.
I inserted the left function using the rules dialog on the EIE:DataMapping form, which resulted in a mapping of function|left(Last Modified By, 20) However, EIE doesn't like this. Here's from the data exchange debug log: [10:33:42,01/10/08] - SqlServer.Initialize: Verifying configuration parameters [10:33:42,01/10/08] - Scheduled Only mode [10:33:42,01/10/08] - CONNECT eFO, USER scc_super_reader (Native Database) [10:33:42,01/10/08] - SET CONCAT_NULL_YIELDS_NULL OFF [10:33:42,01/10/08] - StartDataHandlers: Connection established to both AR/CMDB and vendor application. [10:33:42,01/10/08] - >>>AR System Rules: [10:33:55,01/10/08] - Rules in RuleSet: 'eFO Person Update' [10:33:55,01/10/08] - Rule 1: <Street (id: 400001300)> Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 2: <Street 2 (id: 400001400)> Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 3: <Alert (id: 900007027)> Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 4: <Modified Date (id: 6)> Set to data type: 7 (Date/Time) [10:33:55,01/10/08] - Rule 5: <City (id: 400001100)> Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 6: <Comments (id: 900007030)> Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 7: <Country (id: 400000200)> Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 8: <Primary Email (id: 400004000)> Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 9: <First Name (id: 400007300)> Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 10: <System Status (id: 300317500)> Set to data type: 6 (Enum) [10:33:55,01/10/08] - Rule 11: <Reference Contact? (id: 536870932)> Set to data type: 6 (Enum) [10:33:55,01/10/08] - Rule 12: <Job Level (id: 900007040)> Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 13: <No Mailings? (id: 900007036)> Set to data type: 6 (Enum) [10:33:55,01/10/08] - Rule 14: <Reports To (id: 900007037)> Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 15: <Skill Level (id: 536870931)> Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 16: <State/Province Code (id: 400000800)> Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 17: <Job Title (id: 400022600)> Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 18: <Postal Code (id: 400001200)> Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 19: <constant|0> Set to data type: 2 (Integer) [10:33:55,01/10/08] - Rule 20: <Last Name (id: 400007500)> Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 21: <Pager Number (id: 400097400)> Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 22: <EFO Org_ID (id: 536870929)> Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 23: <Primary Phone (id: 400084400)> Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 24: <function|left(Last Modified By, 20)> Set to data type: 4 (Character) [10:33:55,01/10/08] - *** Field Mapping error for Rule 24 *** [10:33:55,01/10/08] - --> ValidateParmType: 2 required parameters not supplied for function LEFT(). [10:33:55,01/10/08] - *** Field Mapping Error for function|left(Last Modified By, 20) *** [10:33:55,01/10/08] - --> ValidateParmType: 2 required parameters not supplied for function LEFT(). [10:33:55,01/10/08] - Key Rule 1: <EFO Per_ID (id: 600000085)> Set to data type: 4 (Character) [10:33:55,01/10/08] - Delete Rule 1: <constant|-3> Set to data type: 2 (Integer) [10:33:55,01/10/08] - >>>AR System Keys: [10:33:56,01/10/08] - Key field: 'EFO Per_ID (id: 600000085)' [10:33:56,01/10/08] - >>>AR System Query: [10:33:56,01/10/08] - No query defined. All entries will be processed. [10:33:56,01/10/08] - >>>Vendor Rules: What's wrong with the syntax I have above? Should I be putting $ around the AR field name? Thanks. Mike _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
