Excel Connector Mod

(imported topic written by rianjj91)

Is there any way that you could reverse engineer the query wizard associated with the excel connector? Meaning, if I can query the database with the query wizard and am satisifed with my results . . . can you make it so I can then click on the Session Relevance Editor and it would automatically populate the session relevance that it utilized in the query wizard? Maybe it DOES do that, but I haven’t found it.

(imported comment written by Lee Wei)

rianjj,

Good idea for an enhancement.

For now, you do have access to the Session Relevance saved in a hidden spreadsheet (BigFixExcelConnector).

Excel 2003: Menu -> Format -> Sheets -> Unhide

Excel 2007: Menu -> Home -> Format -> Hide & Unhide -> Unhide Sheet

(Easier way is to right-click Sheet1 on the bottom-left of the workbook)

Cell A1 is the generated Session Relevance.

Delimiters are added in front of the statement for easier processing. You can get rid of them.

For example, remove

(item 0 of it  & 
"$x$" & item 1 of it  & 
"$x$" & item 2 of it ) of

Lee Wei

(imported comment written by rianjj91)

Awesome. Thanks for the tip.