Trying to create my first Nintex workflow. Can somebody explain to me or point me to some resources how to use the Convert document action to convert Word documents in one library to PDF files in another. I might be failing on the Output URL - how to create a correct Output URL in this case?
Solved! Go to Solution.
Thank you for your response. Will this work for multiple documents? How can I keep the original name of the Word file?
The workflow generates an error but the file is successfully converted to PDF. Here are my settings:
The only problem I have now is to install missing fonts on the server as the converted file has some substituted fonts.
When using the Convert Document Nintex action - which is based on Word Automation Services - you have to use encoded URLs and encoded Filenames. The Name field for items is not encoded - meaning it doesn't substitute spaces " " with "%20" - which you would see if you hovered over a documents link or icon in a list. Unless there is a hidden encoded name field I'm not aware of, you can use the Encoded Absolute URL for the item. It includes the full URL path, filename, and extension: http://my.domain.com/Shared%20Documents/my%20document.docx
You then use the Regular Expression action to Split the full URL at the forward slash "/" and save the results to a collection. The last item in the collection will be the encoded name.extension
If the domain/document portion of the URL doesn't change inside the workflow, you can also use the Regular Expression and the Replace Text method to replace the http://my.domain.com/Shared%20Documents/ with nothing (an empty Replacement text field), and get the same results.
One additional regular expression/split is needed to remove the file extension from the name, using the period "." as pattern. Be sure to enclose the period in brackets or it won't be recognized properly: [.] Again the results will go into a collection. The last item in the collection is the extension and the remaining item is the encoded name.
Hope this helps.
Hi, can I use the convert document action to convert to other office file types like Excel and PowerPoint and not only for Word documents? What should I configure from the SharePoint side as part of the pre-requisites like Word automation services? any recomendation or guideline from Nintex for this like best practices?. Do I have to configure or do something else from the SharePoint side for Excel and Powerpoint files? thank you for your help.
The action in Nintex supports the SharePoint Word Automation Services. This SharePoint service only support Word documents. See the following: Word Automation Services Overview
If you or someone you know can do a little development, there is a reasonable solution here: Converting Office Documents to PDF with the Office Interop Assemblies
As a final alternative, there are third-party tools that provide the conversion capability for all three.