
If you use the Web Browser (Client rather than Admin Console)
Change to Generic Global
Select "Projects" ==> Catalog
And save the Output to a csv
You can use various filters as well (Names etc)
You could repeat this for Streams as well.
I would like to extract all the dimensios products and assocaited worksets in one shot from browser client (admin console). Please let me know, how to do? i have the steps to extrct from desktop client.
If you use the Web Browser (Client rather than Admin Console)
Change to Generic Global
Select "Projects" ==> Catalog
And save the Output to a csv
You can use various filters as well (Names etc)
You could repeat this for Streams as well.
I don't think the Adminconsole is the place to do this.
As per my previous answer (when you asked how to do it from the full Client) I woudl suggest knocking something up using ODBC and excel (or whatever).
The basic sql to get your data could be something like:
SELECT PCMS_WORKSET_INFO.PRODUCT_ID, PCMS_WORKSET_INFO.WORKSET_NAME, PCMS_WORKSET_INFO.STATUS
FROM YOURCODB.PCMS_WORKSET_INFO PCMS_WORKSET_INFO
ORDER BY PCMS_WORKSET_INFO.PRODUCT_ID, PCMS_WORKSET_INFO.WORKSET_NAME
The Output looks something like:
PRODUCT_ID WORKSET_NAME STATUS
$GENERIC $GLOBAL UNLOCKED
YOUR_PROD1 YOUR_WS_NAME_1 OPEN
YOUR_PROD1 YOUR_WS_NAME_2 OPEN
YOUR_PROD1 YOUR_WS_NAME_3 OPEN
YOUR_PROD2 YOUR_WS_NAME_4 OPEN
etc ........ etc ...... etc
Obviously you could limit by Product or whatever.
I don't think the Adminconsole is the place to do this.
As per my previous answer (when you asked how to do it from the full Client) I woudl suggest knocking something up using ODBC and excel (or whatever).
The basic sql to get your data could be something like:
SELECT PCMS_WORKSET_INFO.PRODUCT_ID, PCMS_WORKSET_INFO.WORKSET_NAME, PCMS_WORKSET_INFO.STATUS
FROM YOURCODB.PCMS_WORKSET_INFO PCMS_WORKSET_INFO
ORDER BY PCMS_WORKSET_INFO.PRODUCT_ID, PCMS_WORKSET_INFO.WORKSET_NAME
The Output looks something like:
PRODUCT_ID WORKSET_NAME STATUS
$GENERIC $GLOBAL UNLOCKED
YOUR_PROD1 YOUR_WS_NAME_1 OPEN
YOUR_PROD1 YOUR_WS_NAME_2 OPEN
YOUR_PROD1 YOUR_WS_NAME_3 OPEN
YOUR_PROD2 YOUR_WS_NAME_4 OPEN
etc ........ etc ...... etc
Obviously you could limit by Product or whatever.