Re: Product Category Imports - 7.1 Patch 002
Hi, After you successfully import the data in PCT:ProductCatalog, then you have to import the same data into PCT:ProductCompanyAssociation. However, along with the desired fields you should add two more columns to the import file - ProductID and ProductInstanceID. Fill this column with random value - "replace" for example and make a filer, which executes on merge on PCT:ProductCompanyAssociation. The Run If qualification should be like 'ProducuID' = "replace". Make this filter to set the ProductID and ProductInstanceID with values from PCT:ProductCatalog. Don't forget to set the selections as well (Help Desk Selection, Change Management Selection...). Similar is for Operational Catalogs also. Best regards, Ismail Hadzhiahmedov Remedy Consultant, ITCE On Sep 4, 11:47 pm, Jase Brandon <[EMAIL PROTECTED]> wrote: > Hello All, > > I am trying unsuccessfully to import product categories from one server to > another. > All product categories are global. > > I am trying to import the data into PCT:ProductCompanyAssociation > and PCT:Product Catalog. > > Imports won't work, even after selecting import preference - > "Generate new ID for all records". > > Error - Record 1 : Required field (without a default) not specified -- > ProductInstanceID (ARERR 307) > > Has anyone else been able to import product/operational categories? > What do I need to do to get this to work? > > Thanks to All, > > Jase Brandon > > ___ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Fwd: Product Category Imports - 7.1 Patch 002 - RESOLVED
... or import only into the PCT:Product Catalog form and let the OTB code create the relationship to the global company (but the filter PCT:PDC:CreateDefaultGlobalCompanyAssoc_795_PPDA would need to be modified to to run on merge; OTB it only runs on submit). Cheers Peter > You could have alternatively written a merge filter to create a new guid > that is set to that field.. that would have worked too.. > > Joe > > > > - Original Message > From: Jase Brandon <[EMAIL PROTECTED]> > To: arslist@ARSLIST.ORG > Sent: Thursday, September 4, 2008 5:04:12 PM > Subject: Fwd: Product Category Imports - 7.1 Patch 002 - RESOLVED > > ** > All, Please disregard previous - all I had to do was send an email to the > List and it came to me. > > I used the Product ID as the Product Instance ID for the import. All > worked fine. > > Thanks, > > Jase > > > -- Forwarded message -- > From: Jase Brandon <[EMAIL PROTECTED]> > Date: Thu, Sep 4, 2008 at 4:47 PM > Subject: Product Category Imports - 7.1 Patch 002 > To: arslist@arslist.org > > > > Hello All, > > I am trying unsuccessfully to import product categories from one server to > another. > All product categories are global. > > I am trying to import the data into PCT:ProductCompanyAssociation > and PCT:Product Catalog. > > Imports won't work, even after selecting import preference - > "Generate new ID for all records". > > Error - Record 1 : Required field (without a default) not specified -- > ProductInstanceID (ARERR 307) > > > Has anyone else been able to import product/operational categories? > What do I need to do to get this to work? > > Thanks to All, > > > Jase Brandon > > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Fwd: Product Category Imports - 7.1 Patch 002 - RESOLVED
You could have alternatively written a merge filter to create a new guid that is set to that field.. that would have worked too.. Joe - Original Message From: Jase Brandon <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Thursday, September 4, 2008 5:04:12 PM Subject: Fwd: Product Category Imports - 7.1 Patch 002 - RESOLVED ** All, Please disregard previous - all I had to do was send an email to the List and it came to me. I used the Product ID as the Product Instance ID for the import. All worked fine. Thanks, Jase -- Forwarded message -- From: Jase Brandon <[EMAIL PROTECTED]> Date: Thu, Sep 4, 2008 at 4:47 PM Subject: Product Category Imports - 7.1 Patch 002 To: arslist@arslist.org Hello All, I am trying unsuccessfully to import product categories from one server to another. All product categories are global. I am trying to import the data into PCT:ProductCompanyAssociation and PCT:Product Catalog. Imports won't work, even after selecting import preference - "Generate new ID for all records". Error - Record 1 : Required field (without a default) not specified -- ProductInstanceID (ARERR 307) Has anyone else been able to import product/operational categories? What do I need to do to get this to work? Thanks to All, Jase Brandon ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Fwd: Product Category Imports - 7.1 Patch 002 - RESOLVED
All, Please disregard previous - all I had to do was send an email to the List and it came to me. I used the Product ID as the Product Instance ID for the import. All worked fine. Thanks, Jase -- Forwarded message -- From: Jase Brandon <[EMAIL PROTECTED]> Date: Thu, Sep 4, 2008 at 4:47 PM Subject: Product Category Imports - 7.1 Patch 002 To: arslist@arslist.org Hello All, I am trying unsuccessfully to import product categories from one server to another. All product categories are global. I am trying to import the data into PCT:ProductCompanyAssociation and PCT:Product Catalog. Imports won't work, even after selecting import preference - "Generate new ID for all records". Error - Record 1 : Required field (without a default) not specified -- ProductInstanceID (ARERR 307) Has anyone else been able to import product/operational categories? What do I need to do to get this to work? Thanks to All, Jase Brandon ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Product Category Imports - 7.1 Patch 002
Hello All, I am trying unsuccessfully to import product categories from one server to another. All product categories are global. I am trying to import the data into PCT:ProductCompanyAssociation and PCT:Product Catalog. Imports won't work, even after selecting import preference - "Generate new ID for all records". Error - Record 1 : Required field (without a default) not specified -- ProductInstanceID (ARERR 307) Has anyone else been able to import product/operational categories? What do I need to do to get this to work? Thanks to All, Jase Brandon ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"