Data Extraction via manual download
The data extraction feature in project management software enables users to retrieve and export project-related data for further analysis and reporting purposes. This feature provides a convenient and efficient way to extract project information, without having to wait around. Users can extract data in csv format, ensuring maximum compatibility with a broad range of reporting, analysis and BI tools.
File format
The file comes in a csv format. It is delimited with a semi-colon.
Separate data
The separate data export contains 3 datasets. They are downloaded combined as a zip package.
Projects
Every row represents a project.
Tasks
Every row represents a task.
Actors
Every row represents an actor assignment to a task.
Data
Below is a table that shows the columns for every dataset. The color coding of the cell backgrounds in this table shows the connection between the datasets.
projects | tasks | actors |
|---|---|---|
id | project_id | name |
title | identifier | status |
status | id | task_id |
start_date | title | |
due_date | status | |
finish_date | task_type | |
project_manager | start_date | |
due_date | ||
finish_date | ||
cycles | ||
approved | ||
rejected |
Combined data
Combines data from all 3 separate datasets.
raw data |
|---|
project_id |
project_title |
project_status |
project_start_date |
project_due_date |
project_finish_date |
project_manager |
task_id |
task_identifier |
task_title |
task_title_clean |
task_iteration |
task_status |
task_type |
task_start_date |
task_due_date |
task_finish_date |
actor_type |
actor_name |
actor_email |
actor_status |
Export
Performing an export is quite straightforward. Click one of the two datasets to start extraction. A pop-up will appear indicating that extraction is in progress. This will prevent any other user from starting a second extract in parallel. This means that only 1 export of a dataset can run at a time in a given environment.
The process of extraction is taken care of in the back-end of DOQMIND. This means that you don’t need to sit around in the interface waiting for the extraction process to be finished. After clicking, you can carry on with other activities in DOQMIND. As soon as this process is finished, you will receive an email from DOQMIND with a download-link. This link will remain valid for 14 days and for 1 download.
The data extraction feature takes a snapshot of the system at the moment extraction is started. The snapshot includes all data in the database, up to the moment where the extract was started.