topic Re: Searching im-Command to export all objects of a project as .csv or xlsx in Systems/Software Engineering

Searching im-Command to export all objects of a project as .csv or xlsx

sklemm — Mon, 05 Oct 2015 14:56:04 GMT

Hi, I'm searching an im-command to export all objects (concerns, documents, etc. ) of an Integrity-Project from Workflow&Documents.Any comments ?BR Stephan

Re: Searching im-Command to export all objects of a project as .csv or xlsx

KaelLizak — Mon, 30 Nov 2015 15:58:49 GMT

Hi Stephan Klemm,

Sorry for the late response. I was hoping I could find something better than what I'm about to suggest:

Create a query to return item types, returning only the types you care about (or no type filter if you really want everything). Alternatively, you can supply a query definition in the following step instead of a named query, but I'll work on the assumption you're using a named query, and the next step can be modified appropriately for supplying a query definition.
From the command line, you can run the command im issues --filedFilter="Project=/<projectName> --query=[<userName>:]<queryName>, and redirect that to a temporary file with a list of item IDs. Values between '<>' are place holders, '[]' indicates an optional argument.
Use the output of 2. as the selection file for the command im viewissue -F <selectionFile>, and redirect that output to another file, which will have the information you are looking for. You may want to pass additional arguments to im viewissue, such as --[no]showRelationships, --[no]showWorkflow, --[no]showHistory, and other such options, to control the exact output for each item type.

I hope that helps.

Regards,
Kael

Re: Searching im-Command to export all objects of a project as .csv or xlsx

tketz — Tue, 01 Dec 2015 09:56:30 GMT

Hi Stephan,

i think you can do the 3 steps from Kael Lizak in only one (for batch or custom command):

im exportissues --fieldFilter="Project=/<projectName>" --queryDefinition=...

there are also options for the outputfile, substitute parameters, displayed fields, ...

Hope it helps

Best Regards,

Tobias

Re: Searching im-Command to export all objects of a project as .csv or xlsx

KaelLizak — Tue, 01 Dec 2015 14:23:28 GMT

Hi Tobias Ketz‌,

If history, workflow (state transitions), and other similar information aren't necessary for the export, then you're right, im exportissues is much cleaner and more efficient! Thanks for bringing this up, I'd forgotten about it.

Regards,
Kael

Re: Searching im-Command to export all objects of a project as .csv or xlsx

AA_10068941 — Wed, 06 Oct 2021 09:00:30 GMT

Could you please help me, how to export work products into excel using project name and document id?

I didnt get the im issues --filedFilter="Project=/<projectName> --query=[<userName>:]<queryName>, the query part.

Thanks in advance

Re: Searching im-Command to export all objects of a project as .csv or xlsx

AA_10068941 — Wed, 06 Oct 2021 09:02:10 GMT

Could you please help me how query definition means?

Re: Searching im-Command to export all objects of a project as .csv or xlsx

AA_10068941 — Mon, 11 Oct 2021 12:02:07 GMT

Could someone help me to export without using query, ie im exportissues --fields=Text,ID,Category,State Item ID?

When I tried, I only get single row of cotent.

Thanks in advance