It's not reliable. It's a free text field in SAP. They want me to use a LIKE statement to query the Remedy product catalog to determine the product type. I'm thinking the product type needs to be in the SAP view.
Also they think it's 1 simple job in AI that will automatically populate the proper classes. I think I need to create each job for each class separately. On Jan 27, 5:26 am, Peter Romain <p.romain.arsl...@parsolutions.co.uk> wrote: > If the description encodes the product type is a way that can easily and > reliably be automatically extracted then you should be able to add extra > steps in the AI job to do what you want. > > > > > > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > > [mailto:arsl...@arslist.org] On Behalf Of remedy lee > Sent: 26 January 2012 20:41 > To: arsl...@arslist.org > Subject: Atrium Integrator questions > > Hi, > > I'm familiar with AIE but not with AI. > > I have a client that has a database (Oracle) with all their purchase > records. > They created a view to gather the columns I need to push to the CMDB. > This view does not have a Product Type or something to identify what the > item is other than Description. > > Can I build a job in Integrator to take that big list of items and push to > the appropriate CI Class depending on the Description(which kind of matches > up to the Product Catalog)? > > Or do I have to build some filter/query to only import Computer Systems into > BMC_ComputerSystem and Printers into BMC_Printer? > > I'm trying to tell the client that I need a product type in their view to > easily import the record. > But they were told that Integrator can do this and sort out the CI Class in > the Integrator tool. > > I hope that makes sense. > > Any guidance would help. > > ___________________________________________________________________________ _ > ___ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgattend > wwrug12www.wwrug12.comARSList: "Where the Answers Are" > > ___________________________________________________________________________ > ____ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > attend wwrug12www.wwrug12.comARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"