Hi All, Related to the Product Company Association I have an issue. By following the second option I have imported the data.
It seems that the Product categorizations are not populating as expected. The Reason I found out was SHR:SHR:UpdateGroupList-CompanyReinitialize-G_565 which is shared workflow has got the RUN IF qualification as ( 'z1D Action' = "UPDATEGROUPLIST" ) AND (NOT (( 'Company' = "- Global -" ) AND (($SCHEMA$ = "CFG:Broadcast" ) OR ($SCHEMA$ = "CFG:ProductCompanyAssociation" ) OR ($SCHEMA$ = "CFG:Service Catalog Assoc" ) OR ($SCHEMA$ = "CHG:CFG Calendar Qualification" ) OR ($SCHEMA$ = "CFG:GenericCompanyModuleAssoc" ) OR ($SCHEMA$ = "CFG:Decision Tree" ) OR ($SCHEMA$ = "CFG:Decision Tree-Branch" ) OR ($SCHEMA$ = "SLM:CFG-SurveyTemplate" )))) But if you look closely there is no form called CFG:ProductCompanyAssociation" . So I have changed it to PCT:.ProductCompanyAssociation. My Problem is since I have not changed this Run if qualification before my import these work flow have fired in MERGE and Made the Assignee group field to NULL What will be the best option to put this Assignee Group to yes in the already existing record? I have tried deleting the records and try to import it again. This doesn't help as the server crashes during the delete activity..... Please advise a way forward ...... ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Leonard Neely - FOJ Sent: Thursday, April 03, 2008 3:00 AM To: arslist@ARSLIST.ORG Subject: Re: Product Catalog Data importing and relating to Company You haven't mentioned your app version, but I assume it is ITSM 7. Here are two options: 1. If all your Product Categories will be associated with a single company. * Import the same source file into the "PCT-ProductCompanyAssoc" form, mapping only the following fields: * Product Categorization Tier 1 * Product Categorization Tier 2 * Product Categorization Tier 3 * CI Type * Company (Map with a static value representing your single company name) * Status (Map with a static value of Enabled if this value does not exist in your source file) 2. If your Product Categories will be associated with multiple companies. a. Use your original source file (Spreadsheet), and add a "Company" column. b. Populate the new company column with the appropriate values. c. Import the modified source file into the "PCT-ProductCompanyAssoc" form, mapping only the following fields: * Product Categorization Tier 1 * Product Categorization Tier 2 * Product Categorization Tier 3 * CI Type * Company * Status (Map with a static value of Enabled if this value does not exist in your source file) Note: If all of your Product Categorization was to be associated with ALL of your companies, you could have simply set the "Map to Global" field to "Yes" on your original import, which would have automatically created global associations. HTH ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Alan West Sent: Wednesday, April 02, 2008 12:40 PM To: arslist@ARSLIST.ORG Subject: Re: Product Catalog Data importing and relating to Company Have you tried the data load console? I found that using the console wasn't always successful but using the forms that are associated with it and utilising the workflow helps a lot. Kind Regards Alan D West ________________________________ > Date: Wed, 2 Apr 2008 12:12:49 -0700 > From: [EMAIL PROTECTED] > Subject: Product Catalog Data importing and relating to Company > To: arslist@ARSLIST.ORG > > I just imported product catalog data to the PCT:Product Catalog form. > > Now the only way I see to get this associated to the company is to > manually associate them through the Product Catalog setup form. > But that means I'll have to do this for 400 entries. > > Is there an easier way to import this data with the company already > associated to it? > > I'm sure there can be workflow created, but I'm looking for something > I don't have to spend weeks trying to figure out. > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ________________________________ A prize an hour, 24 hours a day. Try Big Snap now! <http://www.bigsnapsearch.com%0d%0a%20%0d%0a> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ --------------------------------------------------------------------------------------------- This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"