PDXpert PLM Software
Application Note
Replacing item attributes using the Batch Importer tool
Use the Batch Importer tool to assign a new Trustee, custom attribute value, or other item-level attrubute to a set of parts or documents.
The primary purpose of the Batch Importer tool is to import parts, documents, BOMs, files and other starting values into your new PDXpert system.
However, even after your PDXpert system has been initialized, the Batch Importer tool is useful when you need to replace an item-level value on a set of documents and parts. Item-level attributes are those that are shared across all revisions of an item. They can be identified on the ItemMaster import template as columns that show Updateable as Yes.
Don't try to update revision-level attributes on released items.
For information about importing the Item Files and Materials lists, see the related Batch Importer help topics.
To update an item-level attribute, such as the Trustee, use this general procedure:
-
As an administrator, open the PDXpert client's
menu command. -
Select the Import Type as Item Masters, then click the button, to export all existing parts and documents.
-
Open the saved ItemMaster.csv in a CSV plain text editor (or possibly Excel, if you're sure it won't automatically change your item data).
-
Delete all columns except the four item unique identity columns – that is, Class, Owner, Type, Number – and the attribute that you want to update; for example, the Trustee column.
-
Sort, filter or otherwise find all rows that you want to change. Delete all rows that you don't want to change.
-
Replace the previous value with a new value. You can assign each row a different value.
In our example, the new Trustee value must exactly match an existing member of the Persons collection.
Save the file.
-
-
Import the saved ItemMaster.csv file.
Some attributes accept empty values, while others assign a default value when the import value is empty. Do not include any empty cells in the Item Master import file unless (a) you actually want an empty item attribute value and (b) you've tested that the attribute accepts empty values.
This application note was relevant to the PDXpert software release that was current at time of publication. Product changes since that time may affect its utility. We'd be happy to assist you in assessing the applicability of this note to your situation.
Learn More
- PDXpert Home
- Pricing & Discounts
- System Requirements
- Download PDXpert Software
- Web Tutorials
- Help Guide
- Install Guide
- Sales & Support Policies
- Application Notes
- PLM Good Practices
Application Notes
Working within PDXpert
- Designing an engineering change process and workflow
- Server: Fast file content searches using IFilters
- Server: Scheduled backup for the database and library
- Server: Running several PDXpert Application Servers on the same network
- Batch Import: Preparing file attachments for import
- Batch Import: Converting a PDX package for PDXpert
- Batch Import: Creating release sets for imported data
- Batch Import: Bulk replacing item attributes
- PDX package: Compare all product data, not just the BOM
- PDX package: IPC-2570 package implementation
- Adding a custom SQL Server report to PDXpert 12.0 and later
- Adding a custom SQL Server report to PDXpert 8.0 to 11.2
- Designing email notice templates
- Including labor time and cost in assemblies
- Materials management for regulatory compliance
- Switching an existing item to a different type
- What's the difference between Item Revision State and Item Lifecycle Phase?
Working with other software applications
- Using Altium Designer EDA software with the PDXpert client
- Using Altium Designer EDA software with the PDXpert server
- Using Cadence OrCAD Capture CIS with the PDXpert client
- Using Cadence OrCAD Capture CIS with the PDXpert server
- Using Pulsonix EDA software with the PDXpert server
- Importing a CAD bill of materials into PDXpert PLM software
- MRP/ERP data transfer options with PDXpert PLM software
- Exporting PDXpert PLM parts, BOM & sources to MRP/ERP
- Importing Trilogy Design Parts&Vendors data into PDXpert
- Exporting a bill of materials from PDXpert to Visio