Create Work Packages from Excel Import

  1. On the Work plans/packages page, click on the Export icon, and select to export With Data and open the export file.

    Excel templates without data are used for creating new components from scratch, usually during project setup.

    Excel templates with data are typically used to update existing work plans/packages.

  2. Open the export file.

    • This opens up the Excel template to use for the import. It also contains the data from the current work packages on the Work plans page

    • You may need to select Enable editing at the top of the spreadsheet prior to entering data

  3. Input information into your template to be uploaded. At the bottom of the list, add information for the following categories:

    • Name

    • Package Type

    • Description

    • Assign the proper CWP to your work package in the CWP ID field

      Drop-down lists show for fields that are validated in the import templates for line items.

  4. Delete all the work packages that came with the template.

    When you import a template to Work packing with a blank value in a field, the previous value is not deleted. If want to delete a value when importing, you must type null in the field.

  5. Save this Excel file to your desktop.

  6. In InEight Plan, on the Work plans/packaging page, click the Import icon.

    • An Import data from template window appears

  7. Click Browse to find your saved template.

  8. 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 name of your work package is not the same as an existing work package.

  9. Click Close.