If you use a third-party to compile the Component Library data
Third parties such as Ciiva provide real-time pricing and availability information from a wide range of different suppliers. You then upload your wire harness or PCBA data (consisting of your approved parts list and their corresponding manufacturer and manufacturer part numbers) so that the third-party can return costing information that you then use to populate or update your aPriori Component Library.
Note: In general, you should use the documentation provided by the third-party and/or aPriori Professional Services. However, the general example below based on one third-party gives you an idea of what to expect. Further note that you will need to map third-party and aPriori terminology to each other. For example, in Ciiva a "Product" will typically map to an aPriori "part number".
1 Whenever your company adds new part numbers, log into the third-party application and create/add new components. This typically involves entering the name of your wire harness or PCBA and a version number.
2 Upload your company data. You need to prepare a ".csv" file which is based on your company-approved parts list and which at a minimum contains columns for:
Base Component Part Number Attribute (internal part number)
Manufacturer Component Name Attribute
Manufacturer Component Part Number Attribute
Depending on the third party, you may be able to do things like create a Bill of Materials on import, by adding an additional copy of the Base Component Part Number Attribute for use as the Designator Attribute. You may also specify the Quantity Attribute for each part number. You may also add an extra column to designate the Class for new component parts in the third party. aPriori uses this attribute to define the name of the customer for which the particular database is set up. If no column is added, you have the option to allow for empty class attributes and designate a default value.
Once the .csv file is prepared, upload it to the third party.
3 Map the fields from the spreadsheet to the third-party fields.
Note: aPriori terms may not be the same as third party terms. For example, in Ciiva, the "Class" attribute should be the customer name, but in aPriori wire harness terms, "Class" refers to the high-level designation of what the part is (i.e., wire, terminal, connector, etc.)
4 Complete the import.
5 Search, add, and confirm supplier parts.
Note: You will need to repeat this periodically to update costing data.
Depending on the third party and your requirements, you may need to perform other steps such as updating lifecycle status, syncing components, etc.
6 Obtain pricing Information.
7 Export and format component data for import into aPriori, typically through an Export to CSV operation. Give it a descriptive name like “aPriori Component Library WH.csv”