ID: 1594

Setup Office Previews

Zoom does not by default provide previews of Microsoft Office documents like Word, Excel, PowerPoint etc. But with the custom format mechanism available in Zoom 5.2 or greater, there is a way to resolve this gap nicely. This post covers the steps needed to accomplish this exercise.

Linux Preview Server

Follow the steps below, if preview server is running on linux operating system(like, Centos 6.x, Fedora, RedHat etc).

  1. Download 64bit(or x64,x86_64) rpm for LibreOffice v4.3.x or greater from http://www.libreoffice.org/download.  If OS already has installed LibreOffice of version 4.3.x or greater, then skip downloading and goto step 3. To check version on command line try: soffice –version, it will print version of installed LibreOffice like:

    LibreOffice 4.3.1.2 410(Build:2)
    If command soffice –version doesn’t print LibreOffice of version 4.3 or greater, then download it and install.

  2. Install the LibreOffice in Preview server operating system.
    1. untar the downloaded libre office tar file.

      e.g tar -xvf LibreOffice_4.3.3_Linux_x86-64_rpm.tar.gz

    2.  Make a directory named LibreOfficeInstallation. We are going to use this directory for installation.
      e.g mkdir LibreOfficeInstallation

    3. Goto extracted LibreOffice directory.
      e.g cd LibreOffice_4.3.4.1_Linux_x86-64_rpm
    4. Run install script, and it will display help. To install the LibreOffice in the above created directory, run the following command:

      ./install -a RPMS <path to LibreOfficeInstallation directory, which we created above in step 2>

    5. Now Libre office is installed in directory which we created in step 2 above. Run the following command to verify the version:

      /program/soffice –version  (#Note: Two dashes before version – -version)

    6. Great Work!. Now LibreOffice is installed.
  3. Follow the below given steps to enable MS Office file types preview in Zoom Asset Browser.
    1. Go to Preview server installation directory or Zoom server installation directory, if both are running on same machine.
    2. Goto bin directory inside that>
    3. Open and edit soffice.pl
    4. Search for text “soffice” in this file. Replace text soffice with path:
      <Path of LibreOffice InstallationDirectory>/opt/libreoffice4.3/program/soffice
      Save the file. And check for execute permission on it. If execute permission is missing, then set execute permission on soffice.pl.
      To set execute permission user chmod command.
      Note: Another option is to append the /opt/libreoffice4.3/program” on PATH environment variable of preview server user.
      Note: If Multiple Preview servers are deployed, then all the above steps have to performed on all Preview servers. Zoom server won’t install LibreOffice automatically on any of the Preview Servers.
    5. Now open Zoom server web console at http://<zoom-server>:8443. Go to Custom formats and set default custom format for MS Office File types. See: Set Default Custom Format Section. See the images below for more details.
      Set Office Default Custom Format
      Set Office Default Custom Format

      Office Default Custom Formats
      Office Default Custom Formats
    6. Go to Zoom server installation directory, note, this time we have to go to Zoom server installation directory (If Preview and Zoom server are on same machine, then it is the same directory). In the zoom server installation directory, goto conf directory.
    7. Edit multipagetype.properties, in conf directory, add Ms Office file types in it. Like DOC,DOCX,PPT,PPTX,XLS,XLSX. In the multiplage.properties add the file which are on multi page type. Like PDF, INDD etc.. Save the file after adding these filetypes. All filetypes are in capital letters without dot in them.
    8. Edit thumbfiletypes.properties and add the file formats which you have added in the above step. Save this file.
    9. Note: In case of Zoom HADR deployment, repeat above steps 7 and 8 on all Zoom server installations.
    10. Now Zoom and Preview servers are ready to display Ms Office file types preview. Enjoy :-)
    11. Restart Asset Browser to see previews of MS Office file types.

This is all for enabling Ms Office Previews in Zoom Asset Browser.

 

Windows Preview Server

Please Follow the steps below on your windows server where your preview server is configured to run.

Install Strawberry perl on windows:

Install LibreOffice on windows:

Follow the below given steps to enable MS Office file types preview in Zoom

NOTE: The following steps involve editing or replacing configuration and properties files.  Please, ensure you back up the current files that you will be required to modify or replace

 

  1. Go to http://help.evolphin.com/download/MSofficePrev/soffice.zip and download the soffice.zip file.
  2. Unzip the soffice.zip file and extract the contents to file to a directory of your preference.  The file should contain the following files:
    1. soffice.pl
    2. soffice1.bat
  3. Go to Zoom installation directory (<ZoomInstallDir>\DAM\bin), on the machine that is running your preview server.
  4. Copy/Replace soffice.pl and soffice1.bat file.
  5. Now open Zoom server web console at http://<zoom-server>:8443. Goto Manage Formats and then click on Add Format to add the Zoom Office Document Converter Format.
    NOTE: For Zoom version 5.5 + higher “Manage Formats”  has been replaced by “Media Converters” menu in the web admin. The Zoom office document converter has been provided out of the box, and does not need to be created. You will only need to edit the executable path to the soffice script, as described in step #2 below.
    1. Set the “Format Name field” to “Zoom Office Document Converter”Set the “Description” field to “Zoom documents converter for previewing MS doc, excel, power point previews.”
    2. Set the Executable Path text to the location of the soffice1.bat script that was used in step 4.  In our example, it is “C:\Program Files (x86)\Evolphin\DAM\bin\soffice1.bat”
    3. Set the Input Formats field to “XLSX, XLS, DOCX, DOC, XLT, PPT, PPTX”
    4. Set the Output Formats field to “JPEG”
    5. Check Can Generate Multiple Output Files
    6. Click Add arguments and input the following arguments one by one:
      • InputArg: Editable by user box remains unchecked, Label: InputArg, Tooltip field remains empty, Parameters: -i
      • InputFile: Editable by user box remains unchecked, Label: InputFile, Tooltip field remains empty, Parameters: <%InputFile%>

      • OutputArg: Editable by user box remains unchecked, Label: OutputArg, Tooltip field remains empty, Parameters: -o
      • OutputFile: Editable by user box remains unchecked, Label: OutputFile, Tooltip field remains empty, Parameters: <%OutputFile%>

      • DPI: Editable by user box remains unchecked, Label: DPI, Tooltip field remains empty, Parameters: –dpi 200
      • PrintSize: Editable by user box remains unchecked, Label: PrintSize, Tooltip field remains empty, Parameters: –printSize 2100
    7. Save and close the “Zoom Office Document Converter” format page. In the Manage formats page you should now see the newly creates “Zoom Office Document Converter” custom format and you can verify the above configuration by expanding the format by clicking on the “+” icon.

  6. Go to Custom Formats (default converters for zoom version 5.5 and higher) and set default custom formats for each MS Office File Types one by one. See the image below for more details:

     Screen Shot 2016-01-05 at 2.58.50 PM

  7. Go to Zoom server installation directory. In the zoom server installation directory, go to the conf directory (<ZoomInstallDir>\DAM\conf).
  8. Edit multipagetype.properties, in conf directory, add Ms Office file types in it..  In the multipage.properties, add the MS Office file types like DOC,DOCX,PPT,PPTX,XLS,XLSX .
    NOTE: One file type per line

    Save the file after adding these file types. All file types are in capital letters without dot in them.

  9. Edit thumbfiletypes.properties and add the file formats
    NOTE: One file type per line

     which you added in the above step. Save this file.

  10. Now Zoom and Preview servers are ready to display MS Office file types preview.
  11. Restart Asset Browser to see previews of MS Office file types.