Export Items

Released items can be exported to:

Item properties, bills of materials (BOM), and the Autodesk Inventor global BOM data are supported. Only Released and Obsolete items can be exported.

When exporting a BOM, the latest released BOM is exported.

When exporting to .csv or .tdl files, you can define which Vault Professional attributes to export and then save this configuration as a mapping scheme. You can then apply the mapping scheme each time you export data.

Files are exported encoded in Unicode (UTF-8). When importing this data into another application, it may be necessary to specify the file is encoded in Unicode (UTF-8) so that all characters are accurately imported. For more information on importing Unicode (UTF-8) into another application, see the documentation for that specific application.

Exporting items in the .dwf format exports both the manually attached files as well as the auto-generated .dwf files, if they exist.

Note: When exporting items, a master DWF package is created with sub-DWFs of the files. You can disable the creation of sub-DWFs by setting export includeAttachments to False in the web.config file.

Export Items

Only ERP Managers and Administrators can perform ERP tasks.

Items in the following states can be exported to an ERP system:

Note: Files are exported encoded in Unicode (UTF-8). When importing this data into another application, it may be necessary to specify the file is encoded in Unicode (UTF-8) so that all characters are accurately imported. For more information on importing Unicode (UTF-8) into another application, see the documentation for that specific application.
  1. In the Navigation pane, select Item Master.
  2. In the item master, select the released or obsolete items to export. If you select an item that has children, the item and all children are selected.
  3. From the File menu, select Export Items or right-click a selected item and then select Export Items.
  4. The selected item and any children are listed with their respective revision IDs in the Export Wizard.
    Note: Only items that are in a non-WIP state can be exported (in review, released, or obsolete).

    Items that are checked are exported. If you do not want to export an item that is checked, turn off the check box next to that item.

  5. Click Next.

Export using MSMQ DWF to a configured target ERP system

  1. In the Specify Target screen, select MSMQ DWF.
  2. Click Export.
  3. The View Results displays the result, including those items that were successfully exported and those that were not.
    • Click Print to print the results.
    • Click Send to send the summary information by e-mail.
  4. Click Finish.

Export a .csv file or a .tdl file

  1. In the Specify Target screen, select Other as the target.
  2. Click Next.
  3. In the Specify File screen, select either CSV (Comma Separated Values) or TDL (Tab Delimited List).
  4. Choose how the BOM levels are indicated in the exported file:
    • Choose Level Numbers to organize items using outline numbering:

      Level

      Item Number

      Title

      1

      000011

      Main Assembly

      1.1

      000012

      Part

      1.2

      000013

      Subassembly1

      1.2.1

      000014

      Subassembly2

      1.2.1.1

      000015

      Part1

    • Choose Parent Item to organize items by parents:

      Parent

      Item Number

      Title

      <top>

      000011

      Main Assembly

      000011

      000012

      Part

      000011

      000013

      Subassembly1

      000013

      000014

      Subassembly2

      000014

      000015

      Part1

  5. Enter a path and file name for the exported file or click Browse and specify the location and file name.
  6. Click Next.
  7. In the Specify Attributes screen, drag attributes from the Vault Professional Attributes list and drop them on the Export File attributes list. Click Previous and Next to scroll through the values for the Vault Professional attributes.
    • To remove an export file attribute from the list, drag it back to the Vault Professional Attributes list.
    • To rename an attribute, double-click the attribute field in the Export file list and enter a new name.
    Note: The Level or Parent attributes, depending on which BOM indicator you selected, and the Item Number attribute must be mapped.
    • Once you specify the mapping, it can be saved and used each time you export files. Click Save Map. In the Save Mapping Attributes dialog box, browse to a location and enter a file name. Maps are saved as .xml files. Click Save.
    • To load a mapping file, click Load Map. In the Load Attributes Mapping dialog box, browse to the location where the mapping file (.xml) is saved and then click Open. The Export file attributes list is changed to match the mapping specified in this file.
    • To reset the mapped fields, click Clear Mapping.
  8. Click Export.
  9. The View Results displays the result, including those items that were successfully exported and those that were not.
    • Click Print to print the results.
    • Click Send to send the summary information by e-mail.
  10. Click Finish.

Export a .dwf or .xml file

  1. In the Specify Target screen, select Other as the target.
  2. Click Next.
  3. In the Specify File screen, select either Design Web Format (DWF) or XML.
  4. Enter a path and file name for the exported file or click Browse and specify the location and file name.
  5. If you have defined item attributes in Vault Professional, you can map the attributes before exporting. In the Specify Attributes screen, drag attributes from the Vault Professional Attributes list and drop them on the Export File attributes list. Click Previous and Next to scroll through the values for the Vault Professional attributes.
    • To remove an export file attribute from the list, drag it back to the Vault Professional Attributes list.
    • To rename an attribute, double-click the attribute field in the Export file list and enter a new name.
    Note: The Level or Parent attributes, depending on which BOM indicator you selected, and the Item Number attribute must be mapped.
    • Once you specify the mapping, it can be saved and used each time you export files. Click Save Map. In the Save Mapping Attributes dialog box, browse to a location and enter a file name. Maps are saved as .xml files. Click Save.
    • To load a mapping file, click Load Map. In the Load Attributes Mapping dialog box, browse to the location where the mapping file (.xml) is saved and then click Open. The Export file attributes list is changed to match the mapping specified in this file.
    • To reset the mapped fields, click Clear Mapping.
  6. Click Export.
  7. The View Results displays the result, including those items that were successfully exported and those that were not.
    • Click Print to print the results.
    • Click Send to send the summary information by e-mail.
  8. Click Finish.

Disabling DWF Creation when Exporting Items

When exporting items, a master DWF package is created with sub-DWFs of the files. You can disable the creation of sub-DWFs by setting to False in the web.config file.export includeAttachments

  1. On the computer hosting the Autodesk vault server, locate the Web.config file. By default, this file is installed in Program Files\Autodesk\ADMS Professional [version]\Server\Web\Services.
  2. Using a text editor such as Notepad, open the Web.config file.
  3. Search for the string:

    export includeAttachments

  4. By default, the value of the export includeAttachments setting is True. Change the value to False.
  5. Save the Web.config file and exit the editor.
Parent topic: Items Administration