Importing Project Tasks from Microsoft Project

A specialized Import Assistant supports the import of project task data from Microsoft Project plans into NetSuite project records, so you can use Microsoft Project to build project plan templates or individual project plans, then load this data into NetSuite to maintain ongoing project records. NetSuite provides a predefined export map that you can use to save MPP file data into a CSV file that is properly formatted for import.

Note:

This feature supports addition of new data into NetSuite; updates currently are not supported.

For information about importing project tasks, see the following:

• Requirements for Project Tasks Imports

• Simplified Import Assistant

Requirements for Project Tasks Imports

To import project tasks from Microsoft Project into NetSuite:

• The Project Management feature must be enabled for your account.

• You must have the following permissions:

  • Import CSV File

  • Projects (at least View level)

  • Project Tasks (at least Create level)

• You must first complete the following tasks in NetSuite:

  • Create a project in NetSuite to which the project tasks can be added. Be sure to enter a value for start date, as all scheduling for project tasks is generated from this date. Also, all resources listed in Microsoft Project should be listed in the Project's Resources subtab.

    For more information, read Creating a Project Record.

  • Edit the NetSuite Employee records of project task resources, enabling the Project Resource box on the Human Resources subtab, so that the import can include assignments.

    For more information, read Identifying an Employee as a Project Resource.

Note:

Every project task record is designated as either a project task or a milestone task. If you import a project task record and don't include any estimated work, the record is saved as a milestone task. If you do include estimated work, the record is saved as a project task. For more details about the difference between project tasks and milestone tasks, see Creating Milestone Tasks.

Simplified Import Assistant

Using the Simplified Import Assistant

1. To begin a project tasks import, go to Activities > Scheduling > Project Tasks > Import.

2. Download and set up the NetSuite-provided project file containing the export map.

   1. Click the Download link and save the BlankProjectFileWithExportMap.mpp file to your local machine.

   2. Open the downloaded file in Microsoft Project.

   3. Choose Tools > Organizer and click the Maps tab.

   4. In the left box, labeled ‘BlankProjectFileWithExportMap.mpp', select the Task export for NetSuite element. Click Copy so that this element appears in the right box, labeled ‘Global.MPT'.

   5. Click the Close button.

3. Export Microsoft Project tasks data to a CSV file.

   1. Open the Microsoft Project file that contains the tasks you want to import into NetSuite.

   2. Choose File > Save As. Browse to a location, enter a file name, change Save as type to CSV, and click Save.

   3. On the Export Wizard first page, click Next. On the Map page, choose Use existing map and click Next. On the Map Selection page, choose Task export for NetSuite and click Finish.

4. Import CSV file data into NetSuite.

   1. On the first page of the Import Assistant, click the Select button, browse to the CSV file containing exported Microsoft Project tasks data, and click Next.

   2. Review and edit the mapping of CSV fields to NetSuite fields on the Field Mapping page, and click Run.

      

      Note the following:

      • NetSuite fields are listed in the right pane, with already mapped fields grayed out. CSV file fields are listed in the left pane, with already mapped fields marked with a green check. The Import Assistant provides default mappings for most fields, which you can change as needed.

      • For instructions for mapping fields, see CSV Field Mapping Tasks.

      • Required fields are marked with ( Req ). You must map these fields or provide default values for them. You need to specify a mappings for the Project field, which is the name of the project, as specified on the NetSuite project record.

      • You can add or modify a default value for a field by clicking its pencil icon. (Note that by default, a default value of Not Started is set for the Status field.)

      • You can map fields for project tasks notes, predecessors, and resources by expanding the sublist folders at the bottom of the right pane.

      • You can omit a mapping for the MS Project Service Item, which is the charge rate, or you can map a service item with a null value, meaning it has a null price attached to it.

      • There is a 500-character limit for the names of resources imported for each project task. An error will occur if the names of all resources associated with an imported project task contain more than 500 total characters. It is unlikely you will encounter this error, unless you have many resources with long names associated with a project. If you do encounter this error, you can remove one or more resources from the project task and retry the import.

      • For more information about mapping fields, see General CSV Field Mapping Tips.

Related Topics

• CSV Field Mapping Tasks
• General CSV Field Mapping Tips
• Required Fields on Records
• Select Reference Types
• Assign Default Values during Field Mapping
• Assign Null Values during Field Mapping

General Notices