You are currently reviewing an older revision of this page.
Electrical design projects are frequently started from a preliminary list of materials. These may come from an existing, similar project or from a material list used to cost estimate a project. This list can be imported directly into promis-e and used in any of the report functions available in promis-e such as Job Costing or Purchase orders. This functionality is available by selecting the "Import spreadsheets into BOM link" in the BOM Explorer. The software will require selection of an XLS file name to import from. A mapping dialog allows the user to map the excel field names into the promis-e Device ID and symbol text attributes.
Part numbers should be assigned to all of the imported devices. Assignment can be made in the Excel file or after the import in the BOM explorer. If the part numbers exist in the parts database with valid symbols assigned the place by Device ID function can be used to place the devices onto drawings.
The Import Spreadsheet function is for a simple one time import of parts. The LT API of promis-e allows for creating more sophisticated imports thru custom programming. Functionality allows the user to define flags to the imported record allowing them to be deleted and re-imported based on specific rules.