You have to have Product name and Manufacturer in order for the Prod Cat to be valid. At least you do from the App Admin console.
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of John Atherly Sent: Wednesday, April 28, 2010 1:53 PM To: [email protected] Subject: Re: Data Management tool error Invalid Product Catalog ** I was empty until I added in the information in different columns CI Type, Product, Categorization Tier 1, Product Categorization Tier 2, Product Categorization Tier 3, Suite Definition, Map to Global, Status Column's that are blank Product Name, Manufacturer, DataTags ________________________________________________________________________ _____________ John Atherly | APC by Schneider Electric | Information, Process & Organization (IPO) | Remedy Administrator / Developer Phone: +401-7899-5735 ext. 2120 | Fax: +401-789-3710 | Email: [email protected] <mailto:%[email protected]> | Site: www.apc.com/ <http://www.apc.com/> | Address: 132 Fairgrounds Road, West Kingston, RI 02892 USA *** Please consider the environment before printing this e-mail "Wilhelm, Chad E" <[email protected]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 04/28/2010 02:26 PM Please respond to [email protected] To [email protected] cc Subject Re: Data Management tool error Invalid Product Catalog ** John, In the foundation spreadsheets there is a sheet called ProductCatalog, I would make sure it is empty. A clean sheet is 82 KB. Thank You, Chad Wilhelm From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of John Atherly Sent: Tuesday, April 27, 2010 3:16 PM To: [email protected] Subject: Data Management tool error Invalid Product Catalog ** I've been trying to use the Data Management Tool in 7.5 to load my Foundation data from the work sheets provided by BMC. Remedy converts then into csv file format and then loads the data into Remedy. Once the data is load I run the Validate. After Validation is done all records are mark with an error Invalid Product Catalog The work sheets do not contain a column called Product Catalog. I've run logs on the client and the server and can't even see when the error feild is being populated. 7.5.00 Patch 003 Windows Server 2003 ________________________________________________________________________ _____________ John Atherly | APC by Schneider Electric | Information, Process & Organization (IPO) | Remedy Administrator / Developer Phone: +401-7899-5735 ext. 2120 | Fax: +401-789-3710 | Email: [email protected] <mailto:%[email protected]> | Site: www.apc.com/ <http://www.apc.com/> | Address: 132 Fairgrounds Road, West Kingston, RI 02892 USA *** Please consider the environment before printing this e-mail _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
