You probably mean the Instance ID field. Since this is field ID 179 it is automatically generated by the system as long as you don't map it in the Import tool.
Regards, Michiel On 5/11/06, McKenzie, James J C-E LCMC HQISEC/L3 <[EMAIL PROTECTED]> wrote:
** Roger and all: I forgot about that one. Also, the item id (I forget which field this is but it is the field directly above the data set id and is quite a few characters in length) must be unique. If there is not workflow to set this, I would create such so that it functions on Merge and gives the asset a different set of ids than that set by the 'other' workflow. Also, I would like to state that I was very successful in RE-IMPORTING data back into the AST:Computer System form, but if you are trying to import NEW data, you have to use the BMC: forms (I don't know why, but this is the only way that I was able to do so.) I would set the dataset ID to BMC.ASSET or your items will not appear. James McKenzie L-3 GSI -----Original Message----- From: Action Request System discussion list(ARSList) To: arslist@ARSLIST.ORG Sent: 5/10/2006 1:22 PM Subject: Re: Importing data into join forms in Asset Management module ** On import the field datasetid must be set to BMC.ASSET -----Original Message----- From: Dwayne Martin <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Wed, 10 May 2006 15:34:49 -0400 Subject: Importing data into join forms in Asset Management module Hello everyone, We are trying to import data into the Asset module AST:Computer system form. This is a self-join of BMC:BMC_ComputerSystem on InstanceId. BMC:BMC_ComputerSystem in turn is a join of BMC:BMC_ComputerSystem_ and BMC:BMC_AssetBase, again based on InstanceId. The data imports and BMC:BMC_ComputerSystem_, BMC:BMC_AssetBase, BMC:BMC_ComputerSystem each have thousands of records. Most importantly, they all have matching InstanceId values. But when we query the AST:Computer system form it has no records. BMC:BMC_ComputerSystem has thousands of records, with values in InstanceId. So how can you join it to itself based on InstanceId and not get any records? What are we missing? ARS 6.3, HPUX 11 server, Oracle 9.2 db Dwayne Martin Computing Support James Madison University ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org <http://www.wwrug.org> __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org