![]() ![]() Verify new parts are not created for existing items in the database.īOM part numbers must exactly match those in the database for correct import. įigure 49 Import Configuration Save ButtonĬarefully review the data for accuracy and completeness. To save the configuration, press the “save” button and assign a unique name to the import configuration. The project name will need to be reassigned on new imports (previous steps), but other fields should be configured correctly. If desired, save the import configuration for future use. Select the “Errors” tab and review for any error conditions. Select the name of the project associated with the BOM import. IMPORTANT! This field must be set each time and set to the name of the project associated with the import. Under “Project” configure to “Always set to” and depress “Select entity”. This is the location where all new parts will be initially stored.Ĭreating a unique location, such as “TO-ORDER” is suggested.Īfter selecting, press “Select entity”. Under “storageLocation” configure to “Always set to” and depress “Select entity”. Note: the fields in Figure 43 corresponds to table PartUnit Most applications will use “Pieces” as the unit value.Īfter selecting, press “select entity”. When the “Select entity” window opens, double-click “name” to populate the “results”. To fix it you just need to correctly set the "Measurement Unit" (PartUnit) of the part. Note: here you can see the error in action, parts created without counting unit If partUnit is not configured, due to the error the new parts will not be visible in the BOM after import. Under “partUnit” configure to “Always set to” and depress “Select Entity”. Selecting “Root” is a viable option as most likely new parts will be created across multiple categories.Īfter selection of the appropriate category, press “select entity” at the bottom left corner of the screen. ![]() The category can be updated through the Parts Manager later. This is the category that will be assigned to any new parts imported through the BOM. The specific category selected isn’t important. The results will be displayed on the left. Select “Name” from the available fields list (double-click). Select “Category” Set to “Always set to” and depress “Select Entity”. Then you can check carefully the information of each one before moving it to the appropriate category. This way, later you can go to Parts view and by selecting that category you will have grouped the automatically created parts in one place. It is wise to create a category beforehand with a name like "new parts" or "created by import" and select this category (in the step mentioned below) for assign to the new parts that could be automatically created by the importation. If not configuring for new part imports, you may proceed to Project Assignment Figure 46. The next steps demonstrate configuration for import of new components. The import can be configured to import new parts and create entries for these parts in the database. Configure to “copy contents from” and select the header “Man#”. Note: the fields in Figure 36 corresponds to table Part Select the parameter “name” in the pop-up window. Under “Match import data -> Match Field” select “Add”. If configuring to also import new parts, select “Create new entity if behavior doesn’t exist” if not, select “Stop import”. Set the “Part” class to “Match Import Data”. Select “Copy Contents From” and associate “Remarks” with the Table column “References”. Select “Copy Contents From” and associate “Quantity” with the Table column “Quantity per PCB”. ![]() Select “Select CSV file for import…” See Figure 31. ![]() csv format with the headers as shown in Table 1.Īdditionally, this example assumes the manufacturer part number is used as the assigned part number in the parts database. This import example is based on output from KiCad, using the KiBOM plugin.īOM data is generated in a. the fields in Figure 30 corresponds to the table ProjectPart Note: to understand the import functionality, You can find information on the tables and fields used by PartKeepr at MySQL Partkeepr tables.Į.g. If “Project” is not listed in the fields on the left hand column (see Figure 30) then close out PartKeepr (System –> disconnect) and reopen. To upload a BOM, select the “Import” function. Under “Project Name” enter a new project name and save the project. To create a new project, click the green + at the upper left corner. Under the system menu, “Edit”, select Projects price and estimates will be generated in the project reports.attach relative files for the projects like data sheet, images etc.add parts needed for projects that include quantity, if additional parts needs to be purchased, that in overage, Part name from database, remarks, and allotment number.User can assign parts for projects and estimate the expenses. Projects option is to plan and keep track of assets for projects. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |