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.
2 answers
@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.
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