Parts information may be imported in bulk from a spreadsheet file.
Parts should be imported before attempting to import the associated inventory.
- Browse to the Parts listing by clicking Parts from the left side menu.
- Click Import Parts
- Follow the instructions on the Import Parts screen.
Sourcing information may be included in the bulk import, which will allow you to set a default price for the imported parts.
Data Fields
The following fields may appear in the spreadsheet in any order.
| field | description |
|---|---|
| Part Number | the part number (required), e.g. CH48103-1 |
| Title | the part title (required), e.g. Oil Filter |
| Description | a paragraph description of the part |
| Manufacturer | the part manufacturer |
| Store | the name of the vendor where the part may be purchased |
| URL | a URL that shows more information about the part (usually on a store web site) |
| Weight | the part weight (lbs) |
| List Price | the part's default purchase price |
| List Price Currency | the currency denomination for the list price, e.g. USD, CAD, AUD, GBP |
| Alternates | alternate part numbers |
| BOM | not used |
| Categories | category tag for the part, usually aircraft system based e.g. airframe, engine, etc. |
| Events | event tag for the part, usually maintenance event based e.g. 100hr, annual, oil change, etc. |
| Notes | custom notes for the part |
the following fields are related to the store (vendor) field and are accepted only during the creation of parts |
|
| Phone | a phone number for the store specified by the store field |
| Street | a street address associated with the store |
| City | address associated with the store |
| State | address associated with the store |
| Zip | address associated with the store |
| Poc | point of contact associated with the store |
| Vendor Part Number | the store/vendor's specific part number |
Viewing the Import Results
When an import job is active, browsing to the Import/Export page will automatically redirect to the Import Results view. Review the import results line by line to quality check the import.
The import results remain in storage until they are manually cleared.
Resetting the Import Results
No further data may be imported until the import results are cleared, enabling a new import. If you are not already viewing the Import Results screen, browse to the Import Results page by clicking Inventory, Import/Export
Click the option Clear Results and Enable Another Import link to reset the import results and enable another import or export of the data.
CAUTION: Using the Delete Imported Data and Enable Another Import option will delete the data objects that were imported during the import job. This is a handy feature when you need to retry a failed import. Do not select this option if you would like to retain the imported data but clear the import results history from the database.