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 <http://www.bigsnapsearch.com%0d%0a%20%0d%0a> now! __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
