Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




How to force the date Created, Revised, Resolved for importation from other Bugtracking

api

Hi,

I do a migration from Bugzilla, with the Gemini Java API.

All work fine(Attachment, ....) but I want to transfert the date correctly.

In Bugzilla I have the Creation date of the issue, of the comments ...
But when I put to Gemini IssueEn setDateCreated, setResolvedDate, setDateRevised
Gemini change the date with the current transaction date.

setStartDate, setDueDate are Ok, I can put my correct date.

Any idea ?

rbr
· 1
rbr
Replies (4)
helpful
0
not helpful

You will have to call another web service (PUT) to set each date.
/api/issues.ashx/issues/schemacolumn which takes in a SchemaColumnEN:

<SchemaColumnEN>
    <TableName>gemini_issues</TableName>
    <KeyColumnName>issueid</KeyColumnName>
    <KeyValue>your issue id here</KeyValue>
    <TargetColumnName>your column name to update (eg created)</TargetColumnName>
    <TargetValue>your column value (eg 2009-01-31)</TargetValue>
</SchemaColumnEN>


You must be Gemini admin to use this service.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Waooo !

Direct acces to data base table !


Ok that works !

Thank for your help.


rbr
· 1
rbr
helpful
0
not helpful

Juste one question:

How to put NULL date or "no" date in closeddate or resolveddate ?
I try "", "NULL", "null" but the result is 01/02/3800


rbr
· 1
rbr
helpful
0
not helpful

It is not possible to have NULL. You will have to do this manually.
Set the date to say 1-1-1980 and update it to NULL after.


Mark Wing
· 9108
Mark Wing