
Adding Project Sync to a Task List Outside of BrightWork Project Structured
Sometimes you may want to use Microsoft Project Professional with a template other than the BrightWork Structured Template. This can be done, by following the steps below.
- Open the site or template you want to add task sync to
- Click on Task Update
- In the SharePoint ribbon, click List -> List Settings
- Create a single line of text column called MilestoneSync
- Click on MilestoneSync and rename it to Milestone (Sync)
- Click on the Milestone column and select Delete
- Create a new Milestone column with the following details
- Column Name: Milestone
- Column Type: Calculated Column
- Column Calculation: =IF([Milestone (Sync)]=”Yes”,TRUE,FALSE)
- Return: Yes/No
- Obtain a copy of the .mpp file (note: you must be running BrightWork 15.3)
- If you have not done so already since installing or upgrading, create a Project Structured site.
- On the Structured Template site, navigate to Site Contents ->Site Assets
- Download a copy of the BrightWork – Project Structured Sync item.
- Upload the .mpp file to the Site Assets folder on the Standard site or template you wish to add Project Sync to
- On the Standard site, navigate to Site Contents ->Site Assets
- From the ribbon, select Files -> Upload Document
- Click Browse and find the .mpp you just downloaded to the site.
- Open the .mpp file in the Site Assets by selecting the three dots -> Edit
- When prompted, enable macros (you may also be asked to re-enter your credentials.
- Click File -> Save As
- Click Sync with SharePoint
- Ensure the Site Address is correct and click Verify Site
- Ensure the Task List window has selected the correct Task list and click Save
- Allow the Project to sync
- Once synced, Click File
- Under the Save button, click Map Fields
- Beside the Milestone (Sync) column, select Milestone (SharePoint Sync)
- Follow the on-screen prompt and click Okay when done.
It should be noted that while this method will add Sync to a list, it does not update any other workflows or metrics that may be dependant on other sources for data.
This method only works for users using the BrightWork 15.3 .mpp file.
If you are not on 15.3 and would like to take advantage of syncing with non-structured projects, please email support@brightwork.com, linking this article.