1. Engineer to Order Implementation Guide
  2. Importing ETO Project Information from Microsoft Project

Importing ETO Project Information from Microsoft Project

Select MS Project Integration (G31P13), Import from MS-Project.

To be able to re-import the Microsoft Project file back to the Project Workbench program, you must correctly map the files as defined in the table in the previous section. JD Edwards EnterpriseOne Engineer to Order provides a Microsoft Project template that includes a standard mapping.

After you set up the project in Microsoft Project, you can make changes as needed and communicate the information to others. When you save the file, you save it as a .csv file and select the same mapping that you used for importing the flat file into Microsoft Project. The resulting .csv file contains all of the fields that are listed in the mapping specification.

Note: The inbound import capability is limited.

When working with the project in Microsoft Project, you must apply these rules to be able to import the project file back to the Project Workbench program successfully:

  • You cannot add tasks to or delete tasks from the WBS.

    The system enables you to import records that you originally exported back to the Project Workbench program.

  • You cannot change some fields.

    For example, you can update the Quantity Completed field in the F4801 table only by running the Work Order Inventory Completions program (P31114).

  • You must express the lag time for dependencies in days.

After you make changes, you can import the .csv file back to the Project Workbench program. You use a processing option for the Import from MS-Project program to specify the location of the flat file that you are importing.

Note: When you export project information to a flat file to be read by Microsoft Project, you must specify the location of the flat file. Depending on the operating system and server, you can specify the location of a file in various ways. For example, in a UNIX environment, the flat file is a binary file, and the directory structure is different from the folder structure in a Microsoft Windows environment.