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

CQ Connector date transformation from date string

It looks as though the CQ Connector only provides date transformation
from the internal CQ DATETIME format, is that correct? I have dates
represented in a string form such as MM/DD/YY, is there any way to
transform these with the provided transformers, or do I need to create a
new transformer?

If the later, has someone already done this?

Thanks, Brian

0 votes



4 answers

Permanent link
Hello Brian,

we ran into the same situation, but didn't have to proceed. About solving
it our thoughts where a hidden field in CQ with a hook to convert the data
for RTC. I don't think you can do something elaborate in the sync rules.

Ralph

jrvasta wrote:

There is no transformer provided with the CQ Connector that will
handle that format. I've created an enhancement request for more
flexible date/time transformations, but cannot say at this point when
it would be scheduled.

https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkIte
m/63705

John
Jazz ClearQuest Connector Team
bgillanwrote:

It looks as though the CQ Connector only provides date transformation

from the internal CQ DATETIME format, is that correct? I have dates

represented in a string form such as MM/DD/YY, is there any way to
transform these with the provided transformers, or do I need to

create a

new transformer?

If the later, has someone already done this?

Thanks, Brian

Thanks John.

Is there any easy way to intervene and modify the data before it gets
processed by the synch rule?

Brian

0 votes


Permanent link
There is no transformer provided with the CQ Connector that will handle that format. I've created an enhancement request for more flexible date/time transformations, but cannot say at this point when it would be scheduled.

https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/63705

John
Jazz ClearQuest Connector Team

It looks as though the CQ Connector only provides date transformation
from the internal CQ DATETIME format, is that correct? I have dates
represented in a string form such as MM/DD/YY, is there any way to
transform these with the provided transformers, or do I need to create a
new transformer?

If the later, has someone already done this?

Thanks, Brian

0 votes


Permanent link
jrvasta wrote:
There is no transformer provided with the CQ Connector that will
handle that format. I've created an enhancement request for more
flexible date/time transformations, but cannot say at this point when
it would be scheduled.

https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/63705

John
Jazz ClearQuest Connector Team

bgillanwrote:
It looks as though the CQ Connector only provides date transformation

from the internal CQ DATETIME format, is that correct? I have dates

represented in a string form such as MM/DD/YY, is there any way to
transform these with the provided transformers, or do I need to
create a
new transformer?

If the later, has someone already done this?

Thanks, Brian

Thanks John.


Is there any easy way to intervene and modify the data before it gets
processed by the synch rule?

Brian

0 votes


Permanent link

Is there any easy way to intervene and modify the data before it gets processed by the synch rule?

Brian


Assuming you're willing to write Java code, then yes - create a value transformer :-)

John

0 votes

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

Question asked: Oct 30 '08, 4:12 p.m.

Question was seen: 4,233 times

Last updated: Oct 30 '08, 4:12 p.m.

Confirmation Cancel Confirm