How to import entities with Effort | Targetprocess - Visual management software

How to import entities with Effort

It is possible to create and update work items in Targetprocess using CSV files as data source. This article describes how to import or update Effort and Role Effort values.

It’s possible to import both the total effort for multiple roles and the effort for a single role, depending on how many responsible roles you’ve got for an entity.

Let’s say, you have User Story with two responsible roles: Developer and Tester. In this case, the effort is split. For example, you want to import a User Story that has 12 hrs of effort in total, but the Developer effort is 7 hrs and the Tester effort is 5 hrs.

You should enter the effort in the following format:

(Developer) 7, (Tester) 5

The general format is:

(role) effort value, (role) effort value, (role) effort value

For a single responsible role, just enter the effort value:


Here is an example of how you can import a User Story and several Tasks. Note that User Story has two roles: Developer and QA Engineer


If there are two responsible roles for a User Story, be sure to specify effort for both the roles in the Effort column, otherwise Effort will not be imported.

See Also

Still have a question?

We're here to help! Just contact our friendly support team

Email us
The more details you can give us the better
Live chat
Prefer instant messaging? Try our live chat
Service Desk
Add tickets, comments and track status in our Helpdesk
Slack Community
Shape the future direction of Targetprocess

Find out more about our APIs, Plugins, Mashups and custom extensions. Join our community of passionate users and even discuss directly with our developers.

Start your free trial

Enter your email
By clicking "Continue", you acknowledge and agree that we will process your personal data in accordance with our Service Privacy Policy and Terms of Service.

We’ve sent you a confirmation e-mail — please, go check it.

Or get a live
product demo