Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How to import "Creation Date" and "Create By" using WCL?

Using WCL, I am importing the data in .csv and having a mapping file. 

The WI is created successfully with the following warning.

Ignored: Attribute is calculated and can not be set: creator mapped to: creator 'Created By'
Ignored: Attribute is calculated and can not be set: creationDate mapped to: creationDate 'Creation Date'

The "Creation Date" is set as current date and "Created By" is set as current user.
Can you help me to import the Creation Date and Created By from import csv?

Is it possible to set the Creation date with WCL? oe please suggest any other solution.

0 votes



2 answers

Permanent link
No, it is not and I am not aware of any API that would allow to.

As the error indicates, the available APIs do not allow to set these attributes. They are automatically calculated and that value can not be overwritten.

0 votes


Permanent link
@Ralph - the Eclipse based importer will correctly import Created By and Creation Date and will set them in the newly created work items. I use this to migrate my clients from Jira to EWM and it did a great job of setting all the creation type attributes.

This makes me wonder if there isn't some way to set this programmatically as Eclipse is based on the Plain Java libraries - although having said that, the importer does seem to be using XML as the upload format.

The only ones it won't do are Modified By and Modification Date on attribute changes, which is a shame because then we would be able to do a complete history import.

It will correctly import comments with the author and date, but I guess this is still a creation type operation.

0 votes

Comments

@Davyd, I am aware that some integrations have that capability. I did not know the built in import does it. It might be possible to trace what the rich client code does to get around the plain Java API limitations to make this possible. However, it will likely not be  supported API.


To develop the WCL, I had exactly as much access to the Jazz development team as anyone else on the forum has. So I did not have any support for what could be done with EMF and how to circumvent API limitations. If someone knows how to do this, I am happy to look if I can add a flag or something to WCL to allow this. Otherwise use the WCL to bring in the data and set the creator and creation date in a second rum with the built in importer.

I think you might have to set the creation data in the first run, then do updates with the WCL. I have only ever set it during initial import - never later as a second step.

Would be worth a try though!

1 vote

Good thought, Davyd! 

 Thank you Davyd. I will try the solution and let know in the forum here

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 6,121

Question asked: Aug 14 '21, 1:16 p.m.

Question was seen: 1,166 times

Last updated: Aug 16 '21, 4:14 a.m.

Confirmation Cancel Confirm