# Bug JIM-189 - Set work package created and updated date to timestamps of Jira issue & preserve journal timestamps

Project: Stream Jira to OpenProject data Migrator
Status: closed
URL: https://community.openproject.org/work_packages/JIM-189

## Open points

_No work packages_

## Details

| Attribute | Value |
| --- | --- |
| Date |  |
| Priority | Medium |
| Module | Integrations / Jira |
| Target versions | 17.9.0 |
| Observed in versions | 17.7.0 |
| Sprint |  |
| Backlog bucket |  |
| Bug found in version (deprecated) | 17.7.x |
| Requires doc change | No |
| Accessibility | No |
| Pull preview |  |
| List |  |
| Labels |  |

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable |  |
| Product manager |  |
| Developers | Andrej Sandorf |
| Designer |  |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Planning

| Attribute | Value |
| --- | --- |
| Relevance |  |

## Costs

| Attribute | Value |
| --- | --- |
| Votes |  |
| Work |  |
| Labor costs |  |

## Description

Steps are necessary to avoid

  - <mention class="mention" data-id="78058" data-type="work_package" data-text="##JIM-152" data-display-id="JIM-152">\#\#JIM-152</mention>

  - <mention class="mention" data-id="79711" data-type="work_package" data-text="##JIM-213" data-display-id="JIM-213">\#\#JIM-213</mention>

  - Missing creation and update timestamps for imported issues

To fix:

  - set work\_package **update\_at** to **updated** from Jira

  - set work\_package **created\_at** to **created** from Jira

  - add a new journal entry with datetime of the migration

  - suppress journal entries created by a later stage for attachment migration

  - set the date of all migrated attachments to their creation datetime from Jira

  - ensure work package creation datetime and all journal entries datetime to be
    
      -  ordered chronologically
    
      - unique (journal requirement) by adding microseconds if they are equal (not visible in UI)

<br>
