Create Components from Excel Import

  1. From an open project, go to the Quantity Tracking module.

  2. In Standard View, select the Column Chooser on the far right of the column header row.

  3. From the Column Chooser dialog box, select columns from the Available columns list, and then use the right arrow to move them into the Selected columns list. Save your columns.

  4. Click the Export icon on the toolbar.

  5. Select Template.

    • A Microsoft Excel spreadsheet automatically opens or is shown at the bottom of your screen to download

  6. Click the drop-down arrow for the file, and then select Open.

    • The resulting spreadsheet is now your Import Template and contains all required columns and only the optional columns that were shown in Plan at the time of exporting

  7. In the Name column, enter your component name.

  8. Enter the component Name data.

  9. Save the file to your desktop, so you can easily find it.

  10. Return to Plan, and then click the Import button on the right toolbar.

    • An Import data dialog box is shown

  11. Select Browse.

  12. From the resulting Open window, locate and select your file, and then select Open.

  13. Select Add new items only.

    By selecting Add new items only, the system will flag an error if you’ve accidentally created a component with the same ID as a previously created component. If you select Add new items and update existing, instead of flagging an error for a component ID that already exists, the system overwrites the data for that component.

  14. Click the check box for Email me upon completion.

    • This alerts you to the completion of the upload

  15. Click Import.

    • The import file is added to the import queue

    • To see all your import files and their statuses, click View file import queue

      You can continue working in the application while your imports are processed. A notification tells you if your file is imported successfully or not.

      If you have an error, check that the ID of your component is not the same as an existing component.

  16. Click Close.