Oops. Forgot this. ARS 7.0.1 patch 6 Remedy Link for SQL Server 7.0.1 patch 5 Windows 2003 SP2 SQL Server 2000 SP4 (separate hardware)
Mike On Jan 10, 12:32 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > 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 atwww.arslist.org > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
