Tommy, Thanks for the reply. I am trying to update Base Element and that is the reason for the email because I am not having any luck. What I have right now is about 20k CI's among a number of classes, I think there is about 18 different classes I have pushed to total. I was just giving another spreadsheet that had extra data about all those assets. The only thing that this new spreadsheet has that will match the CI's currently in the system is Asset ID. So in my primary Key I have it matching Asset ID to Asset ID. Then in my data mappings I have three fields I am pushing over, these three fields are all custom attributes I added to Base Element. In my Mapping options I am only modifying records not creating and I have it restricted to my dataset, and I am pushing to BMC_BaseElement
When I run this it looks via the logs that is cannot find the records I have in the CMDB based on the Asset ID because it tries to create records every time and the AR System form count is 0. I built the exact same mapping and put it against the BMC_ComputerSystem class and it worked fine. I know that I can do this via a staging form but I wanted to keep it all in the mappings if possible. I have never mapped to Base Element before so I did not know if there was some rule I am missing, like you can only create, or you have to have another attribute mapped etc... On Tue, Jun 7, 2011 at 10:04 PM, Tommy Morris <[email protected]>wrote: > ** > > If you are just updating and do not wish the OOB filters to kick off the > Base Element is safe enough to import to from AIE. I recently imported > around 400k assets from a 5.5 system into CMDB 7.6p1 and the only way that I > could pull it off in a timely manner was to run them into BE. I imported > them into the BMC.SANDBOX dataset and let the OOB reconciliation jobs pull > them into BMC.ASSET. Worked great.**** > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Roger Justice > *Sent:* Tuesday, June 07, 2011 5:35 PM > *To:* [email protected] > > *Subject:* Re: AIE Mapping Against Base Element**** > > ** ** > > ** The question is how do you not know what class it is in. Also you can > do a staging form for this that will do a query against the Base Element to > get the class id and then do the push to the right class.**** > > ** ** > > -----Original Message----- > From: Kevin Begosh <[email protected]> > To: arslist <[email protected]> > Sent: Tue, Jun 7, 2011 6:27 pm > Subject: Re: AIE Mapping Against Base Element**** > > ** **** > > What if you do not know what class the data is in. For instance if you > where given a file of financial data for something like that with Asset ID's > and that is it. How would you update the classes then, have a staging form > that queries and brings in the class and then have workflow that pushes to > that class?**** > > > **** > > On Tue, Jun 7, 2011 at 6:23 PM, Roger Justice <[email protected]> wrote:** > ** > > ** Best Practice is to only use the Join forms, so no do not do a mapping > against Base Element.**** > > ** ** > > -----Original Message----- > From: Kevin Begosh <[email protected]> > To: arslist <[email protected]>**** > > Sent: Tue, Jun 7, 2011 6:16 pm > Subject: Re: AIE Mapping Against Base Element**** > > ** **** > > So you are saying we should never create a AIE mapping against base > element?**** > > > **** > > On Tue, Jun 7, 2011 at 6:11 PM, Roger Justice <[email protected]> wrote:** > ** > > ** All of the workflow to properly create CMDB entries are on the join > forms so you should never try to either create or modify the base element > form. **** > > ** ** > > -----Original Message----- > From: Kevin Begosh <[email protected]> > To: arslist <[email protected]> > Sent: Tue, Jun 7, 2011 5:46 pm > Subject: AIE Mapping Against Base Element**** > > ** **** > > List,**** > > Has anyone built a AIE mapping against BMC_BaseElement. I have a mapping > built against Computer System and I want to use it for a number of other > classes. Instead of building it a bunch of times I was thinking lean and > trying to create it once against base element.**** > > **** > > I have a Primary Key of Lets say Asset ID and two data mapping fields and > that is it. I am not creating records only updating. When I look at the > logs it looks as if AIE cannot find the file and it tries to create it. The > ARSystem count is 0 when it should be 1. This same mapping runs against the > computer system class and works fine.**** > > **** > > Any ideas, is there a step with Base Element I am missing. I have built > workflow against Base Element that modified and created records and had no > problems. I can also build a staging form that can handle this but I wanted > to have it handled in AIE mapping since I am only updated a field or two and > that is it.**** > > **** > > CMDB 7.6**** > > ARS 7.5 > > -- > Kevin Begosh**** > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ **** > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_**** > > > > > -- > Kevin Begosh > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ **** > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_**** > > > > > -- > Kevin Begosh > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ **** > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_**** > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > -- Kevin Begosh _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
