Export the contents of the List view - SmartPlant Foundation - IM Update 48 - Help - Hexagon

You can export the contents of the List view various templates, to Excel, and to a text file.

Export to the default template

1. Click the list view that contains the items you want to export to make it the active view.

2. Click File > Export (Default Template).

   The items you have selected open in Microsoft Excel.

You must have Microsoft Excel installed on the client computer to use this command.

Export to a specific template

1. Click the list view that contains the items you want to export to make it the active view.

2. Click File > Export (Select Template).

3. In the Define Excel Template dialog box, select a template from the list. For more information on creating a new template, see Configure export template.

4. Click OK.

You must have Microsoft Excel installed on the client computer to use this command.

Export to Excel

1. Click the list view that contains the items you want to export to make it the active view.

2. Click File > Extract List To Excel.

   The items you have selected open in Microsoft Excel.

• You must have Microsoft Excel installed on the client computer to use this command.

• You must set your Internet security level to Low to use this command. Click Tools > Internet Options > Security > Local Intranet > Custom Level in Internet Explorer and then set Initialize and script ActiveX controls not marked as safe to Enable or Prompt.

Export to a text file

1. Click the list view that contains the items you want to export to make it the active view.

2. Click File > Extract List to Text File.

3. In the Save As dialog box, browse to the location where you want to store the text file, and select an existing text file or type a name for the file in the File name box.

4. Click Save.

The text file contains the same information as the list view window you selected, separated by the delimiter specified in argument 1 of the ExtractToText method. For example, the following text file contains document names, descriptions, revisions, versions, and so on, separated by commas.

Name,Description,Revision,Version,Class,Workflow Name,Workflow Status,Creation Date,Last Updated,Owning Group,Owner

Doc001,Document 1,B01,3,Dimensional Data Documents,,,14/10/2009 10:04:15,14/10/2009 10:04:15,,

Doc001,Document 1,C01,3,Dimensional Data Documents,,,14/10/2009 10:04:15,14/10/2009 10:04:15,,

Doc002,,A01,2,Dimensional Data Documents,,,14/10/2009 10:04:15,14/10/2009 10:04:15,,

Doc002,,B01,1,Dimensional Data Documents,,,14/10/2009 10:04:15,14/10/2009 10:04:15,,