WEBSITE

PowerShell for SharePoint 2013 : Word Automation Services - Configure Supported Document Formats for Conversion, Modify Database Information

10/18/2013 7:11:59 PM

1. Configure Supported Document Formats for Conversion


Scenario/Problem: You need to modify the supported document formats for Word Services.


Solution: Use the AddSupportedFormats and RemoveSupportedFormats parameters with the Set-SPWordConversionServiceApplication cmdlet.

By default, all available document file formats are supported within Word Services. You can use the AddSupportedFormats or RemoveSupportedFormats parameters with the Set-SPWordConversionServiceApplication cmdlet to modify which set of formats is supported.

Both of these parameters take a comma-separated list of valid document formats. The recognized values are as follows:

docx: Open XML document. This essentially is any Word 2010 or Word 2007 document and includes .docx, .docm, .dotx, and .dotm documents.

doc: Word 97–2003 documents. Provides support for older Word documents with .doc and .dot extensions.

rtf: Rich Text Format. Supports only .rtf files.

mht: Web page. Any HTML-based web page, including .htm, .html, .mht, and .mhtml documents.

xml: Word 2003 XML document. Any Word 2003 document saved as an .xml file.

As an example of how these parameters operate, removing doc also removes support it for .dot documents. The supported formats are grouped together and cannot be broken apart. These groups correspond to the available options available through Central Administration, as shown in Figure 1. Listing 1 shows sample command lines.

Listing 1. Modifying the Supported File Formats


Set-SPWordConversionServiceApplication
-Identity "Word Automation Services" -RemoveSupportedFormats rtf,mht
Set-SPWordConversionServiceApplication
-Identity "Word Automation Services" -AddSupportedFormats docx,doc


Image

Figure 1. Supported document options for Word Services.

You can use quotation marks around a single file format; however, when you are providing a comma-separated list of formats, you cannot use quotation marks. No errors are presented, although the operation cannot modify the settings.


Tip

When scripting out supported file format operations, use the ClearSupportedFormats parameter first to start with a clean slate; then just add the supported types. This ensures that any unsupported types do not remain active.

2. Modify Database Information


Scenario/Problem: You need to modify the database that Word Services should use.


Solution: Use the database parameters with the Set-SPWordConversionServiceApplication cmdlet.

Three database parameters can be used to configure the database settings for Word Services: DatabaseServer, DatabaseName, and DatabaseCredential. The DatabaseCredential parameter is used only if the authorization is performed through SQL authentication. Even though all these parameters are optional overall, if the DatabaseCredential parameter is used, then DatabaseServer and DatabaseName become required. Listing 2 shows a sample modification of the database settings.

Listing 2. Changing the Database Configuration for Word Services


Set-SPWordConversionServiceApplication
-Identity "Word Automation Services" -DatabaseServer SP2010
-DatabaseName WordServices -DatabaseCredential (Get-Credential)



Tip

Use inline credentials instead of (Get-Credential)


If the database described within the DatabaseName parameter does not exist, it is created automatically.


Tip

Use the database parameters to create a new database without the GUID. Delete the old WordAutomationServices_GUID database afterward.


Other  
  •  PowerShell for SharePoint 2013 : Word Automation Services - Configure the Conversion Processes, Configure Conversion Throughput
  •  ASP.NET 4 : Error Handling, Logging, and Tracing - Throwing Your Own Exceptions
  •  ASP.NET 4 : Error Handling, Logging, and Tracing - Handling Exceptions
  •  ASP.NET 4 : Error Handling, Logging, and Tracing - Exception Handling
  •  ASP.NET 4 : Error Handling, Logging, and Tracing - Common Errors
  •  Sharepoint 2010 : Designing a Workflow Using Visio 2010 (part 3) - Using Visio Services to Visualize Workflow State
  •  Sharepoint 2010 : Designing a Workflow Using Visio 2010 (part 2) - Implementing a Visio Workflow Using SharePoint Designer
  •  Sharepoint 2010 : Designing a Workflow Using Visio 2010 (part 1) - Using the Microsoft SharePoint Workflow Template
  •  Sharepoint 2010 : Workflow - Demonstration Scenario
  •  Sharepoint 2010 : Workflow Foundation Fundamentals
  •  
    Top 10
    Review : Sigma 24mm f/1.4 DG HSM Art
    Review : Canon EF11-24mm f/4L USM
    Review : Creative Sound Blaster Roar 2
    Review : Philips Fidelio M2L
    Review : Alienware 17 - Dell's Alienware laptops
    Review Smartwatch : Wellograph
    Review : Xiaomi Redmi 2
    Extending LINQ to Objects : Writing a Single Element Operator (part 2) - Building the RandomElement Operator
    Extending LINQ to Objects : Writing a Single Element Operator (part 1) - Building Our Own Last Operator
    3 Tips for Maintaining Your Cell Phone Battery (part 2) - Discharge Smart, Use Smart
    REVIEW
    - First look: Apple Watch

    - 3 Tips for Maintaining Your Cell Phone Battery (part 1)

    - 3 Tips for Maintaining Your Cell Phone Battery (part 2)
    VIDEO TUTORIAL
    - How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 1)

    - How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 2)

    - How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 3)
    Popular Tags
    Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 Adobe Indesign Adobe Flash Professional Dreamweaver Adobe Illustrator Adobe After Effects Adobe Photoshop Adobe Fireworks Adobe Flash Catalyst Corel Painter X CorelDRAW X5 CorelDraw 10 QuarkXPress 8 windows Phone 7 windows Phone 8