Versions Compared

Old Version 6

changes.mady.by.user Dominik Lindenberger

Saved on

compared with

New Version 7

changes.mady.by.user Dominik Lindenberger

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Property Type

Description

Example

Boolean

Fill in values using [TRUE, FALSE]

Qualification Required = TRUE

Choice

Slug of a choice value. Check the corresponding property in the admin panel to find out the exact slug values available.

Demand frequency = demandOneTime

Currency

Decimal values with maximum two digits after the decimal point

Current part price = 12.84

Files

Attachments cannot be imported into AMPI via CSV

Float

Decimal numbers

Min wall thickness = 0.4

Integer

Whole numbers, can also be negative

Lead time = 25

Multiple-Choice

Slugs of choice values separated by a space " "

Manufacturing method = milling turning sheetMetal

Size

Size (dimensions) is a special property type in AMPI. Next to the x,y,z dimension you need to provide a shape type s = {sphere, cylinder, cuboid}.
For type sphere you need to provide only 1 dimension, for cylinder only 2 dimensions and for cuboid 3 dimensions.

Ex. 1
....size.s = sphere
….size.x = 24.4

Ex. 2
....size.s = cylinder
….size.x = 24.4
….size.y = 10.0

Ex. 3
....size.s = cylinder
….size.x = 24.4
….size.y = 10.0
….size.z = 14.0

String

For text fields simply fill in the text as needed.

Manufacturer = "Company XYZ"

Bulk Update of Parts in AMPI through CSV Import

A combination of CSV export and CSV import can be used to bulk update parts in AMPI by following these steps:

  1. Run a CSV export to produce a CSV file of the existing parts in AMPI.

  2. Open the CSV export file in any tool capable of reading and editing CSV files.

  3. Modify the values of those parts and columns that you wish to change.

  4. Export the entire changed file to CSV format again.

  5. Run CSV import with the updated CSV file.

  6. The CSV import will match the parts from the CSV import file with existing parts in AMPI based on the ShortID column and update the changed values.