You can import project data, hours and expenses in PSOhub. In order to do so you will need to use specific templates (see below) and follow important guidelines. In this article, you will learn how to import Project Data.

Understanding Import Project Data

The functionality of Import Project Data will allow you to create projects with their related data (i.e. contact(s), company, contract template, amount, budget, project manager and project team members with their respective role and rate.

In order to import project data you need to use a specific template (see below) which comes with example data to illustrate how to populate the columns.

Important guidelines regarding the Import Project template:

  • When you have multiple contract lines for a project, make sure you copy all project related data for each contract lines; i.e. all the columns before the column “Contractlinecount”.

  • If you have multiple project members, you can enter them next to any contract lines within the project (for example Project Z in the template). If you have more project members than contract lines, make sure you copy all project related data for each project member line.

  • The column“ContractLineCountID” must have a unique number for each line containing data in the column ContractLineName.

  • The column “ProjectMemberID” must have a unique number for each line containing data in the column “UserEmail”.

  • The "ContactCountID" must have a unique number for each contact; if you have multiple contract lines and had to repeat the project related data lines, then the same contact should have the same number (see project Z in the template).

  • Columns with InternalProject and FixedFeeExpense always need a true or false in it, regardless if the line has something to do with Expense, this is an import limitation

  • The order and the names of the columns should not be modified , doing so can cause issues with importing the data

Learn how to import project data:

The functionality is located in the Settings of PSOhub under Historic Data. When you click on the dropdown arrow of the More button, you can choose between the following three options: Import projects, Import hours, Import expenses.

Import Projects:

Guidelines before you import :

  • Your PSOhub contract templates, users, roles and rates must already be created in PSOhub prior to importing the data. The roles must also be assigned to the users.

When selecting Import Projects, you will find the following screen:

Once you upload the file, PSOhub will display all the details of your data allowing you to make a final validation of the data and delete, should you need to, one or more records.

To process the imported data, click the corresponding button:

The following message will appear:

IMPORTANT NOTE: The option Update existing projects is only used if you need to update the field Project Manager of your existing projects.

Click Create new projects if you are importing new projects.
The following message will follow:

Click Proceed. The following message will be displayed.

Click Proceed. Once the data is processed, the following message will be displayed:

When you click OK, and if there was no error in the file, will be brought back to the Historic Data page. If there was an error, PSOhub will then indicate what information is incorrect or missing.

Once you have imported your project data, you will be able to import hours and expenses, should you need to.

Did this answer your question?