Giter Club home page Giter Club logo

onlyoffice / onlyoffice-sharepoint Goto Github PK

View Code? Open in Web Editor NEW
16.0 20.0 14.0 3.38 MB

The solution which enables the users to edit office documents from SharePoint using ONLYOFFICE Document Server, allows multiple users to collaborate in real time and to save back those changes to SharePoint

License: GNU Affero General Public License v3.0

Gherkin 1.15% C# 87.97% CSS 2.30% PowerShell 2.54% Batchfile 0.21% ASP.NET 5.83%
onlyoffice integration sharepoint

onlyoffice-sharepoint's Introduction

SharePoint ONLYOFFICE integration solution

This app enables users to edit office documents from SharePoint using ONLYOFFICE Docs packaged as Document Server - Community or Enterprise Edition.

Features

The app allows to:

  • Edit text documents, spreadsheets, and presentations.
  • Co-edit documents in real-time: use two co-editing modes (Fast and Strict), Track Changes, comments, and built-in chat.

Supported formats:

  • For viewing and editing: DOCX, XLSX, PPTX.
  • For viewing only: PDF, DJVU, TXT, CSV, ODT, ODS, ODP, DOC, XLS, PPT, PPS, EPUB, RTF, HTML, HTM, MHT, XPS.

Installing ONLYOFFICE Docs

You will need an instance of ONLYOFFICE Docs (Document Server) that is resolvable and connectable both from SharePoint and any end clients. ONLYOFFICE Document Server must also be able to POST to SharePoint directly.

You can install free Community version of ONLYOFFICE Docs or scalable Enterprise Edition with pro features.

To install free Community version, use Docker (recommended) or follow these instructions for Debian, Ubuntu, or derivatives.

To install Enterprise Edition, follow instructions here.

Community Edition vs Enterprise Edition comparison can be found here.

Installing SharePoint ONLYOFFICE integration solution

  1. Click Start, point to All Programs, point to Administrative Tools, and then click Services, and make sure that SharePoint Administration service is started.
  2. Click Start, click SharePoint Management Shell, go to the directory with the .wsp file.
  3. Run the Install.ps1 script:
    PS> .\Install.ps1
    
  4. Enter your SharePoint site:
    https://<yoursharepointsite>
    

    Alternatively to steps 3 and 4 you can type the following command:

    Add-SPSolution -LiteralPath <SolutionPath>/onlyoffice.wsp
    

    On the SharePoint Central Administration Home page, click System Settings > Farm Management > Manage farm solutions. On the Solution Management page, click the "onlyoffice.wsp", then click "Deploy Solution".

  5. On the SharePoint Central Administration home page, under Application Management, click Manage web applications.
  6. Make sure you select your site and click the Authentication Providers icon.
  7. In the Authentication Providers pop-up window click Default zone.
  8. Under Edit Authentication, check Enable anonymous access and click Save.
  9. Going back to Web Application Management click on the Anonymous Policy icon.
  10. Under Anonymous Access Restrictions select your Zone and set the Permissions to None – No policy and click Save.

Configuring SharePoint ONLYOFFICE integration solution

In SharePoint open the /_layouts/15/Onlyoffice/Settings.aspx page with administrative settings. Enter the following address to connect ONLYOFFICE Document Server:

https://<documentserver>/

Where the documentserver is the name of the server with the ONLYOFFICE Document Server installed. The address must be accessible for the user browser and from the SharePoint server. The SharePoint server address must also be accessible from ONLYOFFICE Document Server for correct work.

Please note, that if you have subsites set up with SharePoint, you will need to additionally configure ONLYOFFICE Document Server connection with each of them, in order for it to work properly. Go to each subsite settings and enter the Document Server address to the proper field.

Starting from version 7.2, JWT is enabled by default and the secret key is generated automatically to restrict the access to ONLYOFFICE Docs and for security reasons and data integrity. Specify your own Secret key in the SharePoint administrative settings. In the ONLYOFFICE Docs config file, specify the same secret key and enable the validation.

If JWT protection is enabled, it is necessary to specify a custom header name since the SharePoint security policy blocks external 'Authorization' Headers. This header should be specified in the ONLYOFFICE Docs signature settings as well (further information can be found here).

Compiling SharePoint ONLYOFFICE integration solution

There are two ways to compile ONLYOFFICE SharePoint integration solution:

a. Using MS Visual Studio:

  1. Enter the SharePoint server and open this project in Visual Studio.
  2. In Solution Explorer, open the shortcut menu for the project and then choose Publish.
  3. In the Publish dialog box, choose the Publish to File System option button.
  4. Click the Publish button. When the publishing process is finished, the solution .wsp file will be created.
  5. Copy the resulting file to the folder with the Install.ps1 file (BuildAndInstall folder by default).

b. With the help of the build.bat file provided:

  1. Go to the BuildAndInstall folder.
  2. Run the build.bat file.
  3. The resulting solution .wsp file will be created and placed to the BuildAndInstall folder.

How it works

  • User navigates to a document within SharePoint and selects the Edit in ONLYOFFICE action on context menu or ribbon.

  • SharePoint ONLYOFFICE solution makes a request to the editor page (URL of the form: /_layouts/15/Onlyoffice/editorPage.aspx?SPListItemId={ItemId}&SPListURLDir={ListUrlDir}&action=track).

  • SharePoint ONLYOFFICE solution prepares a JSON object with the following properties:

    • url - the URL that ONLYOFFICE Document Server uses to download the document;
    • callbackUrl - the URL that ONLYOFFICE Document Server informs about status of the document editing;
    • DocumentSeverHost - the URL that the client needs to reply to ONLYOFFICE Document Server (can be set at the settings page);
    • Key - the file identificator from SharePoint;
    • FileName - the document Title (name);
    • CurrentUserId - the identification of the user;
    • CurrentUserName - the name of the user.
  • SharePoint ONLYOFFICE solution constructs a page, filling in all of those values so that the client browser can load up the editor.

  • The client browser makes a request for the javascript library from ONLYOFFICE Document Server and sends ONLYOFFICE Document Server the DocEditor configuration with the above properties.

  • Then ONLYOFFICE Document Server downloads the document from SharePoint and the user begins editing.

  • When all users and client browsers are done with editing, they close the editing window.

  • After 10 seconds of inactivity, ONLYOFFICE Document Server sends a POST to the callback URL letting SharePoint ONLYOFFICE solution know that the clients have finished editing the document and closed it.

  • SharePoint ONLYOFFICE solution downloads the new version of the document, replacing the old one.

ONLYOFFICE Docs editions

ONLYOFFICE offers different versions of its online document editors that can be deployed on your own servers.

  • Community Edition (onlyoffice-documentserver package)
  • Enterprise Edition (onlyoffice-documentserver-ee package)

The table below will help you make the right choice.

Pricing and licensing Community Edition Enterprise Edition
Get it now Start Free Trial
Cost FREE Go to the pricing page
Simultaneous connections up to 20 maximum As in chosen pricing plan
Number of users up to 20 recommended As in chosen pricing plan
License GNU AGPL v.3 Proprietary
Support Community Edition Enterprise Edition
Documentation Help Center Help Center
Standard support GitHub or paid One year support included
Premium support Contact us Contact us
Services Community Edition Enterprise Edition
Conversion Service + +
Document Builder Service + +
Interface Community Edition Enterprise Edition
Tabbed interface + +
Dark theme + +
125%, 150%, 175%, 200% scaling + +
White Label - -
Integrated test example (node.js) + +
Mobile web editors - +*
Plugins & Macros Community Edition Enterprise Edition
Plugins + +
Macros + +
Collaborative capabilities Community Edition Enterprise Edition
Two co-editing modes + +
Comments + +
Built-in chat + +
Review and tracking changes + +
Display modes of tracking changes + +
Version history + +
Document Editor features Community Edition Enterprise Edition
Font and paragraph formatting + +
Object insertion + +
Adding Content control + +
Editing Content control + +
Layout tools + +
Table of contents + +
Navigation panel + +
Mail Merge + +
Comparing Documents + +
Spreadsheet Editor features Community Edition Enterprise Edition
Font and paragraph formatting + +
Object insertion + +
Functions, formulas, equations + +
Table templates + +
Pivot tables + +
Data validation + +
Conditional formatting + +
Sparklines + +
Sheet Views + +
Presentation Editor features Community Edition Enterprise Edition
Font and paragraph formatting + +
Object insertion + +
Transitions + +
Presenter mode + +
Notes + +
Form creator features Community Edition Enterprise Edition
Adding form fields + +
Form preview + +
Saving as PDF + +
Get it now Start Free Trial

* If supported by DMS.

onlyoffice-sharepoint's People

Contributors

antipkin-a avatar eloncase avatar hellonadya avatar kseniafedoruk avatar linneys avatar nikolayrechkin avatar svetlana81 avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

onlyoffice-sharepoint's Issues

Error "Download Failed" when open files in folder with name in russian

SharePoint 2016 on Windows server 2016
onlyoffice/documentserver-ee:6.1.0.83 in docker on other linux server

  1. Create a folder in the sharepoint library with the name "Документы для тестирования длинно"
  2. load any document (docx, pptx, xlsx) in folder
  3. try open document
  4. error

ONLYOFFICE Docs log /var/log/onlyoffice/documentserver/docservice/out.log

SharePoint log C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\LOGS EC2AMAZ-UDBGRNI-20201221-1514.log

PS if create a folder in the sharepoint library with the name "Документы для тестирования длинне" -> load any document (docx, pptx, xlsx) here -> open documet, no errors

Missing text for actions

Hello, after installation, it works but I have some missing texts for the actions :

On the Onlyoffice/Settings.aspx page, in front of the server url input field, I have "$Resources:Resource,DocumentServer;"
and the button bellow have "$Resources:Resource,Save;"

Same on a document menu, the edit function
image

And also on the top of the library
image

I guess all the texts from the application are missing
Modern or classic experience, it's the same.

Could-you help me to fix this?
Thanks

Error impossible to access file - Sharepoint Foundation 2013

Hello, we install a fresh Sharepoint Foundation 2013 and we want to implement OnlyOffice docs.

We install it on docker and we make installation on Sharepoint Install.ps1 has an error with Enable-SPFeature, so we do with command in powershell.

And after we enable it in Sharepoint Administration Center.

Capture d’écran 2020-11-19 à 07 53 42

But after enable it, we don't have OnlyOffice Settings like in this video :
https://www.youtube.com/watch?v=5rN7CksWE-w

Can you help us ?

Have a nice day.

Open with Onlyoffice on personal documents library (OneDrive)

Hello,

I have SharePoint 2019 on-premise, document server and your app, all up-to-date

Running well on sites collections, i can't get it to work on the personnal sites with url https://[sharepoint]/my/personal/[username]/...
So the OneDrive part of SharePoint, with a document library in modern view.

I can set the document server url on the page https://[sharepoint]/my/personal/[username]/_layouts/15/Onlyoffice/Settings.aspx and save it, but when I select a document I don't have the option to open with onlyoffice like in the other sites collections

Do-you have any idea how to correct that?
Thank you

Edition permission and document save

v2.0 and sharepoint 2019 (fr)

I have some strange things happening :

  • A site collection where your application is active, has system account and another AD account with all permissions on it
  • If I edit a document, with system account, it's writable, it saves modifications, but only if I open it with onlyoffice
  • I can't see modifications if I open with ms office, and the date and time of the document is not modified in sharepoint library
  • If I close and open again with onlyoffice, I see my modifications so it seems saved as a temp doc in onlyoffice server only
  • With the other account, I can only view documents, no write permissions. But this account has all the rights and with ms office modifications are possible

Thanks for your help

Other site collections

v2.0 sharepoint 2019

Hello,

For my root sites collection (https://mydomain.name/), I have the possibility to open onlyoffice with the issues I've already mentionned.

I have other sites collections, (https://mydomain.name/sites/[name]) - I can go to the config page in each ".../_layouts/15/Onlyoffice/Settings.aspx" and save the document server url, but after that I don't have the edit menu in documents library.

Is there anything else to do?

Thanks for your help

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.