Import Parts

From Aligni Wiki

Jump to: navigation, search

You may import parts from a pre-existing parts database into Aligni using the Import CSV feature from the Part Index. If you already have parts in another database, you may be able to export them to CSV to facilitate a migration to Aligni. You may also occasionally want to create parts from a 'batch' that has been entered into a spreadsheet.

Aligni can import the following data from the CSV file you provide. These fields correspond to the fields available when you create a new part.

  • Manufacturer - Required
  • Manufacturer Part Number - Required
  • Part Type - Required
  • Use-As Unit
  • Description
  • Comment
  • Value - Value can include SI Unit Prefixes


Note: The part import feature in Aligni is limited to 25 parts per "run". If you need to import more parts, you can break your CSV file into multiple chunks. If you have a lot of parts to import with more information than the above list, please refer to our API to automate the process.


Contents

[edit]

Step 1: Upload a CSV File

To begin, we'll upload a CSV file containing the parts we want to create. A copy of the CSV file used for this example is shown below.

Step 1: Upload a CSV File
Step 1: Upload a CSV File


[edit]

Step 2: Identify Columns

Next, columns are associated with the data they contain. To help with this task, the selection boxes include the text in the first line of the CSV file.

This CSV file does not specify a unit for each of the parts, so we'll choose each as the default use-as unit which will be associated with all of the newly-created parts.

At this point you should also select the rows of the file you wish to import.

Step 2: Identify Columns
Step 2: Identify Columns


[edit]

Step 3: Create New Part Types, Manufacturers, and Units

In some cases, your CSV file may specify a manufacturer, part type, or unit that is not currently in your Aligni database. The part importer can create these for you and will notify you before doing so by indicating which entities were not matched.

Note: This step is only performed when necessary.

Step 3: Create New Part Types, Manufacturers, and Units
Step 3: Create New Part Types, Manufacturers, and Units
[edit]

Step 4: List of New Parts

If the parts were created successfully, a list of the new parts is shown. Note that the links to the new parts are all displayed as red. This indicates that the part is uncommitted. The new parts should be reviewed and committed when found acceptable.

If any part types, units, or manufacturers were created, this would be a good time to enter additional information for them.

Step 4: List of New Parts
Step 4: List of New Parts


[edit]

CSV File Used in Example 

"Manufacturer P/N","Manufacturer","Description","Comment","Value","Type"
"M25P32-VMF6P","Numonyx","Flash memory","Serial, 32Mb, SO16 (300-mil)","","IC"
"CRCW060312K0FKEA","Vishay","Thick-film resistor","SM-0603, 1%, 1/10W","12.0 k","Resistor"
"ATUM-3/1-0-STK","Tyco Raychem","3mm x 4', dual-wall","Black","","Heatshrink Tubing"
Retrieved from "http://wiki.aligni.com/Import_Parts"
Views
Personal tools