Import Holidays from a Spreadsheet

This procedure explains how to import holidays into the Project Center project timeline from a Microsoft Excel spreadsheet or a file of type .ICSICS is a standard calendar file format that Project Center uses to import/export calendar information in the Project Timeline activity center. There are many applications (including Microsoft Outlook) that can import or export this file format, so users can use the applications to create calendars, export the .ICS file, then import it as a holiday file in the Project Center Administration activity center. The .ICS file also stores current and future project calendar information.. Importing holidays saves time, as you do not have to enter the data manually.

You must be a Project Center administrator to import holidays.

Example

A sample holiday file is stored in the templates directory in C:\Program Files\Newforma\Twelfth Edition\Project Center\Templates\Sample_Holiday_File.xlsx.

To import holidays from a file

If you are not already there, open the Project Center Administration activity center (shown below) by clicking Project Center Administration from the Tasks panel of the My Project Center activity center, or from the Activities list.

Click the Servers tab and select the Project Center Server containing the projects to apply the holidays to.

The Type column lists the server types. Make sure the type is Project Center.

From the General tab, click the button next to the Holiday File field to open the Choose Holiday File dialog box, as shown here. Locate and open the holiday file you want to import.

The holidays in this file will apply to all projects on the selected Project Center Server. However, users can still edit the list of holidays in each project’s Project Timeline activity center in the same way they would edit regular holidays.

Each project can still have its own holiday file, so that any project can have a different schedule than the other projects on the same server. You can apply a different holiday file to a project in the Timeline tab of the Edit Project Settings dialog box.