Mike, Yes you are missing the $ signs..
I'd also like to warn you that the link to SQL keeps open SQL connections as many times as the number of times you have the schedules run so do not be surprised to find a number of open SQL connections used by EIE open in the SQL process list... As a workaround, recycle the EIE service that runs that EIE mapping to the given SQL server.. Do this using a batch file and using net start <service name> in a batch file thats scheduled to run just before the start of the schedule, and net stop <service name> in another batch file that is scheduled to run a while after you anticipate the schedule to have completed its run time.. Cheers Joe ----- Original Message ---- From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, January 10, 2008 12:34:31 PM Subject: Re: Remedy Link for SQL Server (EIE) Function Syntax 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 ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
