Chris, I do have something for you then..
What I have done on my test data exchange (so far keeping just a single user - single fixed license) is creating a Exchange Name field and mapping the value returned from the 'Rules' using the Direct SQL option available. I copied the contents of the mapping... SQL|Select 'Pubs_SQL_SDE90' to set the value 'Pubs_SQL_SDE90' to the Exchange Name field as the name of the exchange was Pubs_SQL_SDE90 This is a snippet from the logs Data obtained for RuleSet: 'SQL-SDE90-Pubs-Authors' [14:25:45,07/10/07] - Rule 1: 'address', Value: '2286 Cram Pl. #86' [14:25:45,07/10/07] - Rule 2: 'au_id', Value: '712-45-1867' [14:25:45,07/10/07] - Rule 3: 'city', Value: 'Ann Arbor' [14:25:45,07/10/07] - Rule 4: 'au_fname', Value: 'Innes' [14:25:45,07/10/07] - Rule 5: 'au_lname', Value: 'del Castillo' [14:25:45,07/10/07] - Rule 6: 'phone', Value: '615 996-8275' [14:25:45,07/10/07] - Rule 7: 'state', Value: 'MI' [14:25:45,07/10/07] - Rule 8: 'zip', Value: '48105' [14:25:45,07/10/07] - Rule 9: 'SQL|Select 'Pubs_SQL_SDE90'', Value: 'Pubs_SQL_SDE90' [14:25:45,07/10/07] - [14:25:45,07/10/07] - Setting field values for ruleset 'SQL-SDE90-Pubs-Authors' [14:25:45,07/10/07] - Field 'Address (id: 900000005)' set to '2286 Cram Pl. #86' [14:25:45,07/10/07] - Field 'Author ID (id: 900000001)' set to '712-45-1867' [14:25:45,07/10/07] - Field 'City (id: 900000006)' set to 'Ann Arbor' [14:25:45,07/10/07] - Field 'First Name (id: 900000003)' set to 'Innes' [14:25:45,07/10/07] - Field 'Last Name (id: 900000002)' set to 'del Castillo' [14:25:45,07/10/07] - Field 'Phone (id: 900000004)' set to '615 996-8275' [14:25:45,07/10/07] - Field 'State (id: 900000007)' set to 'MI' [14:25:45,07/10/07] - Field 'Zip (id: 900000008)' set to '48105' [14:25:45,07/10/07] - Field 'Exchange Name (id: 900000009)' set to 'Pubs_SQL_SDE90' Thought you might find this useful... Thanks for your inputs.. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of strauss Sent: Tuesday, July 10, 2007 1:53 PM To: [email protected] Subject: Re: Identifying user running a data exchange ** I keep using appadmin for the data exchanges because I don't have a bunch of stray fixed licenses to tie up for process users. So far each data exchange routes to a different custom feeder form - I don't have more than one source hitting a single table. To tell what the exchanges are doing, I closely monitor instance log since that seems to be the only place that errors are raised to. That said, I see what you are trying to do. Does the CMDB have a mechanism for identifying the source of the data feed, when you are pushing data to it from EIE and of course the various discovery tools? If so, that might be a clue on how to approach the problem. I have not started working on the EIE asset feed to the CMDB - that's "next" - so I don't know. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Tuesday, July 10, 2007 12:21 PM To: [email protected] Subject: EIE: Identifying user running a data exchange ** Listers, This is an idea I just had but wanted to validate the reasoning behind it, as well as invite suggestions from others who might have had to do something similar, in case you had done something better than this.. We will be given asset data that might be coming from several data sources, many of them being SQL servers, and we have to use EIE as a tool for data exchange. Our choice regarding the tool is thus limited so even though it is possible to do this directly through database links, due to the nature of their requirement, those possibilities are ruled out. I would like to know what you guys are doing to identify which of the n number of exchanges defined just ran on a table, creating records or updating some, if there is more than one exchange. For e.g. if lets say I have created a bucket in the AR System called EIE:ComputerSystems, but there are 2 exchanges that run on it, one named lets say EIE-001 and the other EIE-002 each running on DB01 and DB02 respectively to bring in 2 sets of data, I would like to know what you guys are doing for identifying one from the other. The reason I think I would need this is to define workflow that fires specifically for each of these exchanges. The idea I have was to create AR users EIE-001 and EIE-002 and so on for each of the exchange defined, so that the workflow could use the $USER$ keyword to identify the exchange.. The cost of this however would be that I would require Fixed licenses towards each of these users if I am not to deny them rights to modify at the time they run. Would there be a better way of identifying these exchanges? Maybe I'm answering my own question here (I just had this thought while thinking this through and composing this email after writing the question above!), but maybe by creating a field called Exchange Name in the bucket, and hard-coding the name of the exchange in the field mapping?? Has anyone done something similar? Your inputs would be valuable.. Joe __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.10.2/893 - Release Date: 7/9/2007 5:22 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
