It's all about the answers!

Ask a question

CQ Connector date transformation from date string


Brian Gillan (3215330) | asked Oct 30 '08, 4:12 p.m.
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

4 answers



permanent link
Ralph Schoon (63.5k33646) | answered Oct 31 '08, 5:49 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
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

permanent link
John Vasta (2.6k15) | answered Oct 31 '08, 9:00 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
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

permanent link
Brian Gillan (3215330) | answered Oct 31 '08, 9:45 a.m.
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

permanent link
John Vasta (2.6k15) | answered Oct 31 '08, 3:57 p.m.
FORUM MODERATOR / JAZZ DEVELOPER

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

Your answer


Register or 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.