Materials import

This file defines how PDXpert materials — that is, chemical substances — are assigned to existing part records.

Each row in the import file represents an item record with a material name, and possible quantity and notes.

The import file creates, updates or deletes part-material relationships regardless of the parent item's iteration status (pending, released or canceled).

Rows on the Materials list are added cumulatively. That is, you can import an additional row (say, a newly-regulated substance) without affecting the current list. If you want to replace an existing materials list, clear the list using the DELETE-MATERIAL-LIST special value.

The External Data Importer tool can generate a CSV template file, which can be used to import your data. Select List: Materials from the dropdown list, click the Export button, and save the file to a convenient location.

Column name Data type Assignment if empty Description
Class string Part Part Must be assigned as Part or remain empty.
Owner Organizations home organization Identifies the organization that is primarily responsible for the parent item's specification and which issues the item Number. If not specified, then the home organization is assumed.
Type Part Types default member If not specified, then the part is matched against the default Part Type collection member.
Number string row is skipped REQUIRED: Part number. If the value is empty, the row is not imported.
MaterialName Materials row is skipped REQUIRED: If the value is empty, the row is not imported. The special value DELETE-MATERIAL-LIST deletes the current materials list from the part. Other rows in the import file can assign new materials.
MaterialValue double ≥ 0 0 Material's mass quantity or a ratio of material to the total part mass. See note 1.
MaterialUnit Units of Measure g (gram) If this value is
  • matched within the UOM category of Mass (e.g., g or lbm), then MaterialValue is treated as a mass quantity
  • matched within the UOM category of Proportion (e.g., % or ppm), then MaterialValue mass is calculated using the part's total mass (note 2)
  • empty, then the default mass unit of measure (gram) is applied
MaterialLocation string no value assigned Assigned to the material's Location value.

Notes:

  1. The part's total mass is shown on the Materials tab as Part mass (weight). If the part's total mass is less than the part's updated materials list, then the part's total mass is updated to the total of the material masses. If the part mass is greater than its updated materials list, then its total mass is not modified.
  2. If the Part mass (weight) on the Materials tab is zero, then all calculated masses are imported as zero.

1214

Learn More
Help Guide Contents [PDF]