Export sessions to csv in cadence vmanager tool

Hi Rahul.

Full documentation of the command is available at this link:  https://support.cadence.com/apex/techpubDocViewerPage?xmlName=vmanager_ug.xml&title=Cadence%20vManager%20User%20Guide%20--%20Invocation%20and%20Command-Line%20Interface%20-%20%20csv_export%20&hash=InvocationandCommand-LineInterface-70298csv_export&c_version=19.03&path=vManager_ug/vManager_ug19.03__/Invocation_and_Command-Line_Interface.html#InvocationandCommand-LineInterface-70298csv_export

 but basically, the -sessions switch is listed as being used to export ALL session so it's not really what you wanted anyway. You got the error because you didn't wrap the Tcl command in quotes (but your command isn't right either).

Note that the -filter option is a sub-option for the -view option; the idea is that you specify a pre-defined view (as visible in the GUI) and then apply a filter to it. So in your case, pick a sessions view name that defines the attributes (columns) that you want to export, and use the filter to select just the session that you want to export (your existing filter is probably OK).

So in summary, something like:

vmanager -execcmd 'csv_export -view All_Sessions -filter "start_time:=6/17/19 10:49 PM" -out regr.csv'

Hi Stephen.

I am still getting the same error even after using the command you have put above. Also have you missed typing  '-sessions' option in your command or is it not required?

If I use the exact command you have put i.e.

vmanager -execcmd 'csv_export -view All_Sessions -filter "start_time:=6/17/19 10:49 PM" -out regr.csv',

I am getting the error "E,CMDERR: Command line error: Unrecognized option: -view"

Maybe you missed my comment about -sessions?

I'm not sure why you still get the error, maybe a sensible debug step would be to run vmanager in batch interactive mode, and try the csv_export command there first, get the command working then try to transpose it to a batch non-interactive setup?

linux> vmanager -batch

vmanager> csv_export -view All_Sessions -filter "start_time:=6/17/19 10:49 PM" -out regr.csv

Hi Stephen..

Actually the command worked when ' -sessions' option was added to the command,but what I did was I saved the command 'csv_export -sessions -view All_Sessions -filter "start_time:> 6/17/19 10:49 PM" -out regr.csv'(please note the equal to sign is changed to greater than sign in the filter)  in a file named 'cmd' and and I used the command 'vmanager  -exec cmd' in the terminal and I got the expected csv file.

But when I tried to do the same in another PC, I got this error "Error:Project Environment Selection is required by the server,and must be set on this mode" . Can you please let me know how to resolve this?

Hi Stephen,

Is it possible to save the views of sessions using batch-mode commands?