- Import and Export Data
- Export Team Workflow States to Tabular Reports
- How to import entities from a CSV file
- Entities and fields supported for import from CSV files
- Import User Accounts from CSV file
- Importing data into Targetprocess
- Import Requesters from CSV file
- Create New Entities with an Imported CSV File
If youāre moving data to Targetprocess from any other project management system, here are a couple of tricks that can make your life easier.
You donāt have to add all the data manually. Instead, we recommend exporting the data from your project management toolĀ to files, then importing the files into Targetprocess. The preferred method of export is CSV or plain text files.
After importing your data to Targetprocess, your systems won't be connected by default. Changes made in your old system won't be reflected in Targetprocess and vice versa. Should you require continuous synchronization of data betweenĀ both your existing system and Targetprocess, consider setting up a data connector such as Tasktop Sync,Ā Zapier,Ā or another custom integration instead of a one-time export and import action.
Data model mapping
Most likely, data models in your existing tool and in Targetprocess are different. When data is exported, the next step is to choose what object typeĀ in your existing system will be represented by what entity, field, or relation in the Targetprocess Data Model.Ā At the same moment, you should choose what objects entities, fields and relations are "must have"Ā for migration and which ones can be omitted or added later manually.
Use our helpful Glossary when needed. Discuss your decisionsĀ with your dedicated Product Specialist or Solutions Architect from theĀ Targetprocess team.
Available methods
Batch import of data to Targetprocess can be performedĀ with the help of multipleĀ methods or combinations of them:
Method | Level | Supported entity types, fields | Notes and recommendations |
Quick Add Several Work Items mashup | Basic | Only most common types of entities,
Name field only |
Import a plain list of tasks. Create a list of users.Ā Stable workĀ with up to 100 entities per single file. |
CSV import | Intermediate | Common types of entities,
multiple fields |
Import hierarchical backlog, test cases. Stable workĀ with up to 1000 entities per single file. |
Batch actions | Intermediate | Common types of entities,
multiple fields |
You cannot create new entities with Batch actions, but they are extremely helpful when you haveĀ to apply a similar modification toĀ multiple entitiesĀ at once. |
REST API | Advanced | Almost any type of entity,
almost anyĀ field |
Import hierarchical backlogs, sprints and releases, time sheets, test plans, relations, comments, projects, teams and users. Stable workĀ with up to 500 entities per singleĀ API call. During the import of large backlogs, make splitĀ API calls with throttling. |
Assistance of Targetprocess developers | Proficient | Any type of entity,
any field |
Import whole dataset, including attachments (uploaded files).
Negotiate terms of such assistance with our Sales department. |
Choosing between these options is a matter of personal preferences, supported capabilities, priorities, skills, available time, and budget.
Preserve numeric IDs
During creation, new numeric IDs are assigned to all your entities in Targetprocess, and there is no wayĀ to preserve the numbering system from your existing third-party tool. If you still need to useĀ the old IDs, we recommend you store them in text or numericĀ Custom Fields.
Import origin Creation Dates
Creation Date field in Targetprocess entities is important for history tracking. It also helps to display data properly on Roadmaps and in charts. It is not possible to modify the creation date for existing entities. However, you can set custom creation dates for your new entities at the moment when you import them.
More information:Ā How to set Creation Date during import
Still have a question?
We're here to help! Just contact our friendly support team
Or contact
a sales representative
Get a live
product demo
Let one of our product specialists create your account
and shape Targetprocess for your
company needs.