Question - It is my understanding that Join forms contain data that result
from a database search. I do updates via joins, but have never tried to
import new data directly into a join. If, as in the original question the
join is the product of one form and an initial join of 2 other forms, does
the import attempt to create 3 new records (1 in each form) if all of the
required fields are present?
Ron Fariss
AIG Technologies
Remedy & TelAlert Administration
Work: (713) 831-2365
Cell: (281) 782-0979
"McKenzie, James J
C-E LCMC To: [email protected]
HQISEC/L3" cc:
<[EMAIL PROTECTED] Subject: Re: Importing data
into join forms in Asset Management module
S.ARMY.MIL>
Sent by: "Action
Request System
discussion
list(ARSList)"
<[EMAIL PROTECTED]
RG>
05/10/2006 09:48
PM
Please respond to
arslist
**
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: [email protected]
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: [email protected]
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
