Importing Bookings

To import a list of bookings from a spreadsheet or PDF file into Projectal, follow these steps:

1. For importing staff bookings, go to the Staff Planner screen by clicking Staff Planner on the left sidebar. For importing resource bookings, go to the Resource Planner screen by clicking Resource Planner on the left sidebar.
   
2. Click the Import button on the Staff Planner or Resource Planner screen toolbar to display the Choose Import Type screen and select Bookings.

3. Use the File tab and click the Browse button to select a file to import from your computer.  Or, use the URL tab and enter the URL for the file from a website, such as Google Sheets or Office 365.  

Tip: Supported file types for importing are XLS, XLSX, CSV, ODS and PDF.

Tip: When importing from a URL from websites like Google Sheets or Office 365, make sure that the sharing permissions of the URL are publicly accessible.  Otherwise, Projectal may not be able to read the contents of the URL.

Tip: When importing dates from your spreadsheets, make sure your dates are formatted as "YYYY-MM-DD" to ensure the year, month and day is interpreted correctly.

4. Once your file has been imported, you will see the Import Document screen.  This lets you choose the columns from the spreadsheet that you wish to import and assign the fields that the columns of data represent.

5. After you have selected the columns and assigned the field to these columns, then click the Preview button.  This lets you view the data prior to importing into Projectal.

6. On the Preview screen, you can select items and click the Delete button if you wish to remove certain data prior to importing.  You can also click the Option menus in the column header to display the Filter icon.  Clicking the Filter icon displays a popup menu that filters the list of data.

For example, if you have errors or blank entries listed in Import screen, you can use the Filter popup menu items to just list all the data with errors or blank entries and then select all these rows of data and delete them by clicking Delete. 

7. Once you are happy with the data, then click the Import button and Projectal will import all the displayed data as new bookings into Projectal and display them in the Staff Planner screen or Resource Planner screen.

Tip: If you are unsure of the columns of data you should put into your Excel XLS file so that it can be imported successfully, then we suggest you export the current list of items in Projectal into an Excel XLS file and you can view the columns that Projectal has exported.  They will provide a guide of what fields will be imported.