1. Video

You can check the following videos for a walkthrough of importing a MPP file to the Focus HQ Project Schedule.


2. Import Project Schedule from Microsoft Project


1. Open the Microsoft Project application. In Microsoft Project, set the columns to be similar to the fields in Focus HQ.


Please see table below for the Focus HQ Schedule columns to be included, along with its Data Format.

Asterisks (*) indicate required fields.


Focus HQ Schedule Columns

Data Format/ Accepted Values

ID*

Numeric value

Must be unique

WBS*

Numeric value (Ex. 1)
Numeric List value (if Child Task) (Ex. 1.1)

Must be unique

Title*

500 characters max

Actual to Date*                                     

Percentage value

Start Date*

Data Format: dd/mm/yyyy

Date should be within Project Start Date and Project End Date.

End Date* 

Data Format: dd/mm/yyyy

Date should be within Project Start Date and Project End Date.

Predecessors

x:n (line ID : dependency code)

Must be an ID within the file

Participants

Username added in the Project.

Mark as Project Milestone

Yes or No

Mark as Portfolio Milestone

Yes or No

Mark as Activity

Yes or No

Mark as Deliverable

Yes or No

Project Phase

Project Phases outlined within Project Settings (only if marked as deliverable)

Effort

Integer value

Effort Unit

d (for days)
h (for hours)
w (for weeks)

Actual Effort

Integer value

Manually Scheduled

Yes or No



2. Once done with creating the Project Schedule, you can save the file as MPP.

Go to File > Save As, and select the location of where you want to save the MPP file. Then, name the MPP file.

Or you can click CTRL + S, and a popup is displayed where you can name the MPP file and where you want to save it.

 


3. Export the updated Project Schedule from MPP as a CSV file.

To export the updated Project Schedule, click File > Save As.

In the location to save the file, click the select the Type to save as  ‘CSV (Comma Delimited) (*.csv)’

Leave the file name as its default value, then click the Save button. 



For versions of Microsoft Project that need Legacy Formats to be configured, please check this link.


4. After successfully exporting the updated CSV file, upload it to the Focus HQ tool.

To import the updated Schedule, please check this link.