cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

how to export the table contents(ie object list) to excel

SOLVED
bmarimuthu
Newbie

how to export the table contents(ie object list) to excel

I want to excel the windchill table so that i can find the list of parts and drawings and their state.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: how to export the table contents(ie object list) to excel

Ok it's the workspaces content.

But it already has the 'export to file' action ! ( sorry, picture below in French 🙂 )

Sélection_161.png

View solution in original post

9 REPLIES 9

Re: how to export the table contents(ie object list) to excel

Hi,

Do you want to export an existing table content to XL, or create a new table and be able to export its content to XL ?

Re: how to export the table contents(ie object list) to excel

I want to export an exixting table content.

Re: how to export the table contents(ie object list) to excel

Ok, so there are 2 cases :

The easiest one, your table already has a menu, like the parts references documents

Sélection_158.png

If you add &jcaDebug=1 in the page URL, ie : Windchill/app/#ptc1/tcomp/infoPage?oid=VR%3Awt.part.WTPart%3A149827&u8=1&jcaDebug=1

You can find the action model used by the table :

in my example relatedDocumentReferencesToolBar in the definition file: /config/actions/PartDocument-actionmodels.xml

Sélection_159.png

And you just need to add the actionModel in codebase/config/actions/custom-actionModels.xml

and insert the action folderbrowser_toolbar_exportlisttofile_submenu  like this.

  <model name="relatedDocumentReferencesToolBar">

      <action name="related_add_references"                    type="part" shortcut="true"/>        <!-- Add References Document -->

      <action name="related_doc_create_wizard_part_references" type="document" shortcut="true"/>    <!-- Create and associate a references document -->

      <action name="related_delete_references"                 type="part" shortcut="true"/>        <!-- Remove References Document -->

      <action name="related_copy_references"                   type="part" shortcut="true"/>        <!-- Copy to Clipboard -->

      <action name="separator"                                 type="separator" shortcut="true"/>   <!-- ===================================== -->

      <action name="related_paste_references"                  type="part" shortcut="true"/>        <!-- Paste References Document from Clipboard -->

      <action name="related_paste_select_references"           type="part" shortcut="true"/>      <!-- Paste Select References Document from Clipboard -->

        <submodel name="folderbrowser_toolbar_exportlisttofile_submenu"/> 

   </model>

After reloading the actions, or a server restart , you can export to XL and even more 🙂 :

Sélection_160.png

If your table has no menu/action bar, it's a little bit more complexe, as you'll need to extend its controller to add a menu...

Re: how to export the table contents(ie object list) to excel

Thank you olivierfresse.......... ok as you said i didnt find the menu/action bar .

Re: how to export the table contents(ie object list) to excel

Which table is it ?

Re: how to export the table contents(ie object list) to excel

issu.PNGthis table which list the parts

Re: how to export the table contents(ie object list) to excel

I want this list in excel is there any way of getting these data in excel

Re: how to export the table contents(ie object list) to excel

Ok it's the workspaces content.

But it already has the 'export to file' action ! ( sorry, picture below in French 🙂 )

Sélection_161.png

View solution in original post

Re: how to export the table contents(ie object list) to excel

thankyou olivierfresse i got it.

Announcements