👍

Prerequisite for Importing Work Plan with Subphases

Ensure you have Subphases enabled in your Mosaic account. For more information on Subphases, see this Help Doc.

📘

Legacy Work Plan (without Subphases) Import

Documentation for the Legacy Work Plan (without Subphases) Importer can be found here.

While Mosaic can be used to create Work Plan, Work Plan can also be uploaded from tools to Mosaic for complete overviews on your team's current, past, or upcoming work

Part 1: Complete the File

To upload Work Plan via spreadsheets:

1. Confirm either Mosaic Support or your Customer Success Manager have enabled the Work Plan upload tool on your account. To request this tool be added to your account, reach out to our team via [email protected]

2. Next, download the Work Plan template here and fill out all the fields. You can find details regarding the fields and requirements below.

📘

It is recommended to use pre-existing projects and phases in Mosaic

It is possible to create and import new projects for your imported Work Plan during the import process. However, to help prevent any mistakes when importing, it is recommended to import/update Work Plan details into a project that already exists on Mosaic.

If importing into a pre-existing project then the names and numbers must match exactly as is on Mosaic. If they do not match exactly you may get error fields during the import process, indicating where the names do not match, or unintentionally create new projects.

Here is an overview of the details needed for each column:

📘

Every Line Denotes a New Entry

For each individual in the Work Plan, create a separate line. If a person is assigned to multiple phases or work categories, each assignment should also have its own line. For example, if you're adding two people to a project with two phases, but only one person is working on both phases, the spreadsheet should display three data lines.

📘

Work Plan Hours Limit

Work Plans must have a minimum value of 0.0001 Hrs/Day, or 1 hour for every 10000 workdays. Work Plans imported from CSV Import or from integrations are excluded from this limit.

Part 2: Upload the File

1. Navigate to the Planner page from the sidebar menu on the left, and select the 3 dot menu beside the "sort" button under Work Plan, as shown below:

2. Make sure the Data to Import field is Work Plan.

3. Select the max levels of Phases you have and to include Work Category or not. The default max level is 10; the default is to not show Work Categories. Click on the Upload button.
   Note: If Include Work Categories is not selected, the column will not show in the uploader.

4. Select the file you would like to import using the file selector or drag and drop the file here. After filling in the first row, the other rows should auto-populate.

5. For each of the columns, the software will try to auto-map the information that we need. You can also change the mapped columns by clicking the dropdown from your columns. It may take some time for the information to auto-populate in our field columns.

📘

Column Mapping Filters:

To streamline the mapping process, you can filter fields by a variety of factors. These include mapped vs. unmapped, required vs. optional, field errors, warnings, skipped rows, fields with formulas, SmartFill or QuickFixes. In addition, you can filter by field type, specific fields themselves or simply search for fields.

Select which columns to show

Select the column types

Select required/optional fields or specific columns by name

❗️

Red Highlighted Rows

Any boxes that appear in red indicate there is no matching value on Mosaic or there is a typo for this cell. Please confirm if there is a typo, or if the value does not exist on Mosaic.

If this is a typo, you can update the value in the uploader in the "Our Column" section.

📘

Quick Fixes using Value Mapping:

Value Mapping allows you to associate the value with the correct option. You can choose from a list of approved options, which are set up in advance, and make these associations quickly and easily through a tool called the Value Mapping QuickFix.

6. After you've confirmed the sheet is filled in correctly, click Continue. You may see a message like this:

7. When the data is successfully uploaded, you will see see a message like this:

Part 3: Complete the Import

1. Click done to close the modal. Under the Draft Import section, click on the Import button for the file that was just uploaded to review the import.

2. New employees on the file will show on here. You can change their role by clicking on the dropdown.

3. Change to All Members Imported View to see members linked with the existing members in Mosaic.

If you want to modify the member linked with existing, click on the member name and click select Alternate. Then select the member that you want to link or Import as New.

Once you are finished reviewing your Employees, click Continue.

4. On this page, Projects, Phases, Subphases and Work Categories can either be linked with existing or imported as new.

5. To link a project with existing, click the plus icon on the right side and select an existing project to link. Click Save.

6. To link a phase with existing, click three dot on the mosaic phase, click link with existing phase. Click the lightning bolt icon on the top to automatically map all Phases.

Select the phase on the left side to link, click save.

7. All linked projects will show in linked section. Once you finish reviewing, click Confirm Import on the top.

📘

New Project Confirmation

A confirmation modal will appear, displaying the total number of newly imported projects. If the number seems incorrect, click cancel and verify that all projects are mapped properly.

8. Thats it! Once the file processing is completed, it will show in the Completed section. Please allow up to 24 hours for all Work Plan to finish populating on Mosaic.

Time Off Work Plan

The process is the same as normal Work Plan, but since Time Off project is a default project that is created by Mosaic, so you won't be able to find it in your projects or portfolios.

Here is the information you need:

• Portfolio Name: default name is your company name
• Project Name: default name is Time Off
• Project ID: no project ID on the Time Off project by default, but you can manually set an ID for it
• Project Phase: Time Off project has one default phase, but if your Time Off project have multiple phases, make sure to specify which phase the work plan should be in.

Where to find this information?

1. Go to Home > timesheet

2. Click "Add Time Entry"

3. Search for Time Off project in the menu.

• Project Name: Time Off
• Portfolio Name: The folder on top of the project name, should be your organization name.
• Project ID: The number on top of the project (if any)
• Phase Name: Under the project you can see 4 phases, these will be the phase names to put on the Work Plan.

"Vacation/Sick" is the default description of the project, this is not necessary when importing Work Plan.

What if I didn't see a project ID or I want to change the project name?

If you didn't see a project ID on top of your Time Off project, this means it doesn't have one yet. But you can add a project ID to this project.

1. Click on the project and select a phase (if any). This will create a time entry like below.

2. Click the three dot and select view project info.

3. You will see a modal like below. From here, you can add an ID to your project or change the project name if needed and just simply press save when you are done.

4. You should see your project ID (and new name) appear on the top of the project now.

📘

Creating duplicates

If the email, project name/number, phase name/number, work category, start/end dates, and description match a previously existing Work Plan, then the existing Work Plan will be updated with the new Work Plan hours.

If the optional fields (eg. description, phase number) are omitted in both the original and new, this will count as matching.

Legacy Work Plan Import (without Subphases)

Overview

If you do not have Subphases enabled in your account, you can still use the Legacy Work Plan Import (without Subphases).

Mosaic currently provides imports for the following:

• Work Plan

For other data types please see the guides for uploading into Mosaic, or get in touch with your Customer Success Manager for help.

Links to download import template:

• Work Plan (without Subphases) csv template

Please review this carefully before uploading a data import file

📘

It is recommended to use pre-existing projects and phases in Mosaic

It is possible to create and import new projects for your imported Work Plan during the import process. However, to help prevent any mistakes when importing, it is recommended to import/update Work Plan details into a project that already exists on Mosaic.

If importing into a pre-existing project then the names and numbers must match exactly as is on Mosaic. If they do not match exactly you may get error fields during the import process, indicating where the names do not match, or unintentionally create new projects.

Here is an overview of the details needed for each column:

🚧

Every Line Denotes a New Entry

For each individual in the Work Plan, create a separate line. If a person is assigned to multiple phases or work categories, each assignment should also have its own line. For example, if you're adding two people to a project with two phases, but only one person is working on both phases, the spreadsheet should display three data lines.