OnlyOffice Connector Application

Last modified by Administrator on 2024/12/07 00:00

Buy extension
from 60€ Try extension
for free Contact us

Category	Application
Active Installs	20
Rating	0.0 1 2 3 4 5 0 Votes
License	GNU Lesser General Public License 2.1
Minimal XWiki version supported	XWiki 13.10
Sources	Issues

Table of contents

Usage
External Resources

The OnlyOffice Connector Application allows you to create and edit docx, xlsx, pptx, odt, ods, odp attachments using an OnlyOffice server. You can also upload doc, xls and ppt attachments, but in order to edit them you will need to convert them to docx, xlsx, pptx after clicking the Edit icon.

Several users can edit the same document in real-time.

By default, the extension is already configured to use the XWiki OnlyOffice testing server, so you can test it out easily.

Please note the app was tested with OnlyOffice document server 7.0 through 8.0.

Usage

Once the extension is active, you will see some new options at the bottom of each page, in the Attachment tab:

You will be able to perform the following actions:

Edit the existing office attachments by clicking the Edit icon to the right of the attachment name.
Create new office files, with 3 types being available: documents, spreadsheets and presentations.

Documents

Spreadsheets

Presentations

Support for Microsoft Office and Open Document formats

Creating documents

When creating a document you will be prompted to choose the format of the file.

Converting into a supported format

When opening an unsupported file for editing, you can convert it to either ODF or OXML formats.

The current conversion tables of the OnlyOffice integration are the following (the input formats can be opened with the OnlyOffice editor and converted to the output format):

output\input	docx	odt	doc	html	txt	rtf	mht
docx	-	✓	✓	✓	✓	✓	✓
odt	✓	-	✓	✓	✓	✓	✓

output\input	xlsx	ods	xls	csv
xlsx	-	✓	✓	✓
ods	✓	-	✓	✓

output\input	pptx	odp	ppt	ppsx
pptx	-	✓	✓	✓
odp	✓	-	✓	✓

Opening a file that was already converted

When opening a file that was previously converted to either ODF or OXML, the editor will prompt you to open either of the versions available.

You can read more about configuring the app in the "Documentation" tab.
If you're planning on using our app with the Only Office Integration Edition, please contact us and we'll be happy to extend our partner discount to you.

Standard configuration for the OnlyOffice server is supported. Support is not included for custom access configuration rules for XWiki and/or OnlyOffice servers (e.g.behind a firewall, reverse proxy). If you need support for a custom setup please contact us.

External Resources

How to edit Office attachments in XWiki

How to import and export content

Essential XWiki Apps for Professional Wikis

UI Administration page

In the XWiki Administration, there is an entry that allows you to configure the application:

Use the main wiki configuration (only visible from subwikis): When this option is enabled, it mirrors the main wiki's configuration.
OnlyOffice Server: Represents the URL to the OnlyOffice server to use.
Enable attachment creation: Adds the following buttons in the attachment view, at bottom of pages:

Enable realtime editing in OnlyOffice: allows users to edit the same attachment at the same time.
Conversion of ODF documents when editing: determines how should the editor handle ODF files when editing them.
- Convert to a different document: the default behavior when editing a non .docx, .xlsx, .pptx file - a copy of it is created with the corresponding format that can be edited.
- On the fly using OnlyOffice: the ODF file is converted behind the scenes to the associated Microsoft Office format (docx, pptx or xlsx) and edited as such. When the document is saved, it is converted back to the initial file extension. The conversions are made using the OnlyOffice conversion service.
- On the fly using Office Server: the process is similar to the previous one, only that the conversions are made using the configured Office Server. For more information about the Office Server, read the Installation section.
Server secret: The secret used to generate and validate the tokens used by the OnlyOffice server. Note that the JWT is activated by default from version 7.2 on the OnlyOffice document server. If no secret was configured by the user, a random string is generated and used instead. More information can be found here.

If the user selects the third method and the Office Server is not connected, a warning will be displayed:

By default, the extension is configured to use the XWiki OnlyOffice testing server.

Contents

Navigate to the Extension Manager
Install the Extension
Get a License
Install the License
Use the Extension
Installing Paid Apps on Subwikis
Dedicated OnlyOffice Server
Office Server for ODF files conversion

Installation Steps

This paid extensions requires XWiki 13.10 or above. In order to install the extension, follow the next steps inside your XWiki instance (on cloud or on premise).

Navigate to the Extension Manager

In the Applications Panel click on "More Applications..." and then "Install new applications...". Alternatively navigate directly to the Administration and select the "Extensions" section.

Install the Extension

Search for the extension you wish to install and use the Install button to install it.

Get a License

Navigate to the "Licenses" section of the Administration, fill your details, look for the extension you just installed in the live table and click the buttons to get a trial license or to buy a license.

Install the License

If you have selected a trial license then you're good and there's nothing else to do. Your trial license is automatically installed.

However if you've selected to buy a license you'll be redirected to a page to perform the payment. At the end you need to come back to the "Licenses" administration section and click on the "Check for Updates" button. This will download and apply the license you bought.

Use the Extension

Start using the Extension! Refer to the extension's documentation to know how to use it.

Installing Paid Apps on Subwikis

If you want to install an application on the whole farm (main wiki + subwikis), you can do so directly from the main wiki’s Extension Manager, as seen below:

Extensions can also be installed only on a particular subwiki by global admins. Subwiki admins will not be able to install these extensions due to their limited rights.

Dedicated OnlyOffice Server

First of all you will need an OnlyOffice document server and the current recommended version is 7.0.0. The recommendation is to set up your own OnlyOffice server for production wikis, while you can use the default one provided by XWiki SAS for testing purposes.

If you use the test OnlyOffice server, please be aware that it should be used for testing only and that XWiki SAS doesn't provide any warranties regarding this server. The pricing of this application doesn't include a production-ready OnlyOffice server and users are expected to install their own server. Please make a reasonable usage of this default server and XWiki SAS reserves the right to prevent access to it in case of abuse.

You can find how to install a server in the OnlyOffice Help Center.

In order to use this connector, the OnlyOffice server must be setup using CORS (cross-origin-resource-sharing). You can enable this by putting a proxy in front of OnlyOffice or you can change the OnlyOffice nginx configuration file /etc/nginx/includes/onlyoffice-documentserver-docservice.conf using this content.

Office Server for ODF files conversion

OnlyOffice works best with Open XML formats (docx, xlsx, pptx). This means that when you edit a .odt file, OnlyOffice will convert it to the corresponding .docx format before actually enabling the user to modify it. When the user is done editing the document, it will be converted back to the original format. These conversions are not always perfect and can lead to data loss. This is why we, at XWiki, added one more option for the user: to make the back and forth conversions using Libre Office, or whatever office server the user desires. LibreOffice is a veteran in it's domain and the conversions between the documents are often better that what OnlyOffice can offer. Don't let this put a stain on your opinion about OnlyOffice. Their conversion service is also good and you should give it a try.

If you want to edit ODF documents without converting them to a different file and don't want to use the OnlyOffice conversion service, you will need have an office server properly configured. Here you can find instructions on how to configure XWiki to use a Libre Office server.

After configuring the Office Server, there is one more thing left to do.

You will need to download the file located at the following URL, where "XWIKIVERSION" will be replaced with your XWiki version.
https:raw.githubusercontent.com/xwiki/xwiki-platform/xwiki-platform-XWIKIVERSION/xwiki-platform-core/xwiki-platform-office/xwiki-platform-office-importer/src/main/resources/document-formats.js

Now we need to edit the .js file (that is actually a JSON) and add one more property to each OXML format:

Search the document for "Microsoft Word 2007" and you will find the object associated to the docx extension. Add to it the following property: "storeProperties": {"TEXT": {"FilterName": "MS Word 2007 XML"}}
Search the document for "Microsoft Excel 2007" and you will find the object associated to the xlsx extension. Add to it the following property: "storeProperties": {"SPREADSHEET": {"FilterName": "Calc MS Excel 2007 XML"}}
Search the document for "Microsoft PowerPoint 2007" and you will find the object associated to the pptx extension. Add to it the following property: "storeProperties": {"PRESENTATION": {"FilterName": "Impress MS PowerPoint 2007 XML"}}

For example, let's say my XWiki version is 14.4.3. The link for the file I need is: https://raw.githubusercontent.com/xwiki/xwiki-platform/xwiki-platform-14.4.3/xwiki-platform-core/xwiki-platform-office/xwiki-platform-office-importer/src/main/resources/document-formats.js.

Searching for "Microsoft Word 2007" will get me at this section of the document:

.
.
.
  {
    "name": "Microsoft Word 2007 XML",
    "extensions": ["docx"],
    "mediaType": "application/vnd.openxmlformats-officedocument.wordprocessingml.document",
    "inputFamily": "TEXT"
  },
.
.
.

Now, I need to modify it like so:

After modifying the document in all three places and saving it, you need to copy it to WEB-INF/classes, relative to your XWiki instance installation folder. Make sure not to modify the name of the file (document-formats.js).

This step is needed for the conversion docx → odt to be possible. More details about this issue can be found here.

Options

The price is per year and varies depending on the support level and the number of users.

Support / Users	10	25	50	100	250	500	1000	2500	5000	10000	20000
Silver	60	115	175	290	410	580	870	1150	1740	2300	2900

OnlyOffice Connector Application is part of the XWiki Pro package. Purchasing this package you will benefit from more extensions at a better price. Check the full offer in XWiki Pro! The OnlyOffice Connector Application can be purchased individually only via online order (credit card payment), following the “How to Buy” procedure described below. The application is part of the XWiki Pro package, which can be purchased through manual order (bank transfer payment) by contacting sales@xwiki.com.

Benefits

What do you get when you purchase an XWiki extension?

1 year license

By purchasing an XWiki extension license, you'll benefit from it during one year.

Free updates

You benefit from all the extension updates during one year. You are always up to date.

Support included

If you are facing an issue, you can reach the XWiki support. Our team is always available to help.

How to Buy

To buy, install this extension from inside your XWiki instance and follow the instructions.

Release notes

v2.3.1

Bugs fixed:

#45 Can't edit documents in realtime after upgrade to 2.3.0 without superadmin rights

v2.3.0

Improvements:

#22 Use the real-time support provided by XWiki platform (13.9+)

v2.2.0

Improvement:

#23 Secure connection to OnlyOffice using a JSON Web Token (JWT)
#40 Error with OnlyOffice 8.0

v2.1.2

Upgrades:

#39 Upgrade Licensor dependency to version 1.25

v2.1.1

Upgrades:

#37 Upgrade Licensor dependency to version 1.24.3

v2.1

Tasks done:

#35 Upgrade parent to 13.10-3

Upgraded licensing version to 1.24.1.

v2.0

Bugs fixed:
#24 Documents do not save with onlyoffice-documentserver 7.0.0
#27 Edit with OnlyOffice buttons are missing.
#30 Sometimes after editing a file and clicking Save & View a "Leave site?" message box appears

Improvements:
#25 OnlyOffice connector should allow to create and edit OpenDocument formats without conversion
#32 Users should only be allowed to access the .doc, .xls and .ppt documents in view mode

Update licensor version to 1.22.1.

v1.6

Upgrade the Netflux Backend and the WebSocket Integration dependencies in order to fix loading issues when XWiki runs behind a reverse proxy.

v1.5.1

Update the licensor version to 1.20.

v1.5

Update parent version to 11.10.
Update licensor version to 1.16.1.

v1.4.1

Bugs fixed:
#10 Users appear as "anonymous" when editing document.
#11 Default document language is Français.
#12 Creation buttons from Attachments tab are not translated.
#14 Translations missing.

French

v1.4

Bugs fixed:
#8 Users are no longer able to click on the save buttons.

Improvements:
#4 Enable translation of OnlyOffice application.

Update the Licensing dependency to version 1.15.

v1.3.12

Update the Licensing dependency to version 1.14.4.

v1.3.11

Update the Licensing dependency to version 1.14.3.

v1.3.10

Bugs fixed:
#7 11.3: can't download JS...

Update the Licensing dependency to version 1.14.1.

v1.3.9

Update for compatibility to XWiki 11.

v1.3.8

Update the Licensing dependency to version 1.13.8.

v1.3.7

Update the Licensing dependency to version 1.13.4.

v1.3.6

Update the Licensing dependency to version 1.13.3.
Update the xwiki-netflux dependency to version 1.5.

v1.3.5

Update the Licensing dependency to version 1.13.2.

v1.3.4

Update the Licensing dependency to version 1.13.

v1.3.3

Update the Licensing dependency to version 1.12.2.

v1.3.2

Update the Licensing dependency to version 1.12.1.

v1.3.1

Update the Licensing dependency to version 1.11.
Bug fixed: OnlyOffice buttons do not appear on XWiki 9.8.1.

v1.3

Improve the way the message about no valid license is displayed.

v1.2

Update the Licensing dependency to version 1.7.

v1.1

Update the Licensing dependency to version 1.6.

v1.0.7

Update the Licensing dependency to version 1.5.4.
Update the parent version to 8.5.
Bug fixed: Unable to open Office files using OnlyOffice on IE11.

v1.0.6

Bug fixed: Change the way the edit button is registered in the attachment view.

v1.0.5

Update the Licensing dependency to version 1.4.4.

v1.0.4

Update the Licensing dependency to version 1.4.3.

v1.0.3

Update the Licensing dependency to version 1.4.2.

v1.0.2

Update the Licensing dependency to version 1.4.1.

v1.0.1

Update the Licensing dependency to version 1.4.

v1.0

Initial paid version.

Extension details

This information is only displayed to Administrators. Your users can't see this tab.

License

GNU Lesser General Public License 2.1

Sources

https://github.com/xwikisas/application-onlyoffice-connector/tree/master/application-onlyoffice-connector-ui

Issues

GitHub

Type

Developed by

XWiki SAS

Compatibility

Requires XWiki 13.10 or above.

Installable with the Extension Manager

Dependencies

com.xwiki.onlyoffice-connector:application-onlyoffice-connector-api 2.3.1
org.xwiki.platform:xwiki-platform-office-ui 13.10
com.xwiki.licensing:application-licensing-licensor-api 1.25
com.xwiki.onlyoffice-connector:application-onlyoffice-connector-webjar 2.3.1
org.xwiki.platform:xwiki-platform-netflux-rest 13.10
org.xwiki.contrib:netflux-websocket-webjar 1.1.0
org.xwiki.commons:xwiki-commons-netflux 13.10
org.xwiki.platform:xwiki-platform-rendering-macro-include 13.10
org.xwiki.platform:xwiki-platform-rendering-macro-velocity 13.10
org.xwiki.rendering:xwiki-rendering-macro-html 13.10
org.xwiki.rendering:xwiki-rendering-macro-message 13.10