It's all about the answers!

Ask a question

Importing Query in workitem


kaushambi Singh (561611) | asked Mar 05 '09, 2:01 a.m.
How can we import query in work item? We get the option of exporting query but don't find any option for importing the query? Please let me know.

7 answers



permanent link
Ralph Schoon (61.1k33643) | answered Mar 05 '09, 2:01 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hello singh_kaushambi,

as far as I can see today import of WI's is only possible using the bugzilla
import feature. If you need to import from some other source you can try
to get that content into a bugzilla format and use this or create a client
extension that does this for you.

If you think there should be a wizard e.g. to import CSV files check is such
a workitem already exists and if not, I'd suggest to create one.

Ralph

How can we import query in work item? We get the option of exporting
query but don't find any option for importing the query? Please let me
know.

permanent link
kaushambi Singh (561611) | answered Mar 06 '09, 2:18 a.m.
Hi Ralph,

I saw what you spoke about.But it is about importing the bugzilla report.My question is bit different.Suppose I had created a query,export it somewhere at the local drive.Now I want to import it,but Idon't get the option of importing the query. Would be glad if you help me with an answer.Mu name is Kaushambi.

permanent link
Ralph Schoon (61.1k33643) | answered Mar 06 '09, 4:51 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hello singh_kaushambi,

Hi Kaushambi,

as I think i said, there is only export to CSV. There is no import available
from CSV at this time being. There is only the bugzilla import available
at this time.
This would be a work item you should generate if you like to see such an
import option.

Having said that - I had a customer situation recently where I needed to
import Workitems and potentially update existing ones. So I wrote an importer
that imports CSV and updates the workitem in case it exists. Based upon the
code shipping with the plain java API snippets it was no big deal.

I see two possible ways if you need to import CSV. Create a bugzilla conform
zip from the CSV or create an importer.

BTW, I would like to but I can't send the importer I built because there
is a customer name in the package code. Refactoring would take a while. Also
the importer is lacking a lot of UI code. I basically would have to write
the wizardpages to set a project, team area and some other information. I
will eventually do that but lack the time right now.

Ralph

Hi Ralph,

I saw what you spoke about.But it is about importing the bugzilla
report.My question is bit different.Suppose I had created a
query,export it somewhere at the local drive.Now I want to import
it,but Idon't get the option of importing the query. Would be glad if
you help me with an answer.Mu name is Kaushambi.

permanent link
Patrick Streule (4.9k21) | answered Mar 13 '09, 4:41 a.m.
JAZZ DEVELOPER
If you think there should be a wizard e.g. to import CSV files check is
such a workitem already exists and if not, I'd suggest to create one.

Please subscribe to
https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/63545
to track progress on this topic.

--
Regards,
Patrick
Jazz Work Item Team

permanent link
kaushambi Singh (561611) | answered Mar 17 '09, 5:36 a.m.
Can we have an example on how do we import query which is stored in CSV form after being exported.The URL in point no.1 doesn't actually clearly explain on how to import.I tried using the steps given in URL but couldn't actually succeed.I tried mapping the fields against what I have declared in my project area but everytime it takes the default mapping from 'eclipse_bugs_10000_10020.zip' mentioned in the URL. It basically tells about the bugzilla report.Would be great if this could be explained with an example.Also,I completely agree with point no.3 that if we are exporting using CSV or HTML format, why don't we have ready format for import as well.Please answer this question.

permanent link
kaushambi Singh (561611) | answered Mar 17 '09, 5:38 a.m.
Can we have an example on how do we import query which is stored in CSV form after being exported.I tried using the steps given in URL but couldn't actually succeed.with reference to the URL,I tried mapping the fields against what I have declared in my project area but everytime it takes the default mapping from 'eclipse_bugs_10000_10020.zip' mentioned in the URL. It basically tells about the bugzilla report.Would be great if this could be explained with an example.Also,one question that if we are exporting using CSV or HTML format, why don't we have ready format for import as well.Please answer this question.

permanent link
kaushambi Singh (561611) | answered Jul 28 '09, 4:24 a.m.
Is the import and export of a query supported in 2.0.Can we export the query(in .qry format) from one project area and import in the same format in another project area? This was not supported in 1.0.1.1v and as far as I can see in 2.0, it is still not supported. Please confirm.

Your answer


Register or to post your answer.