Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X
Hi,
I need to run the commands "si viewproject" and "si viewprojecthistory" to gather information about checkpoints, labels and members (associated to a specific checkpoint/version of a project) for reporting.
The documentation states for both commands: <<Under the CLI the fields are separated with a space.>>
This is only partly correct, since "viewprojecthistory" uses <tab> as separator while "viewproject" uses <space> (optional multiple depending on indent).
My question: Is there any (CLI-) option available to customize the column/field sparator for the output of these commands? The preferred separator character for me would be <tab>.
Integrity-Version (si about):
Integrity 11
Build: 11.0.0.506
API Version: 4.16.506
Hotfixes:
Copyright (c) 2016 PTC Inc. and/or Its Subsidiary Companies. All Rights Reserved.
thanx
Markus
Solved! Go to Solution.
Using the --format option for si print, you can control exactly what you get, including field separators.
You also have to use -r:member to display only the member revision info, as I found that si print shows all revisions by default.
For example:
si print --recurse -r:member --noHeaderFormat --noTrailerFormat --format="{projectname}\t{membername}\t{memberrev}\t{date}\t{cpid}\r\n"
Will display the project/subproject, member, member revision, date, and change package for each member on a separate line, with the fields separated by tabs. Since there's no indent or subprojects displayed with si print, I added the projectname field so you know which subproject the members belong to.
The list of fields is found in the si rlog man page.
My alternative for si viewproject would be
c:\MySandbox>si print --recurse --revision=:member --fields=membername,memberrev,archivename
where the fields are separated by tabs (at least for my integrity version).
For more control about format you should read in the reference guide how to use
the --format option.
Note that "si print" is using "si rlog" internally.
(I guess: si rlog --NoHeaderFormat --NotrailerFormat --revision=:member --fields=membername,memberrev,archivename)
Regards Juergen
Using the --format option for si print, you can control exactly what you get, including field separators.
You also have to use -r:member to display only the member revision info, as I found that si print shows all revisions by default.
For example:
si print --recurse -r:member --noHeaderFormat --noTrailerFormat --format="{projectname}\t{membername}\t{memberrev}\t{date}\t{cpid}\r\n"
Will display the project/subproject, member, member revision, date, and change package for each member on a separate line, with the fields separated by tabs. Since there's no indent or subprojects displayed with si print, I added the projectname field so you know which subproject the members belong to.
The list of fields is found in the si rlog man page.
thanx to all,
now I get the report in a format I like it