Project

General

Profile

Fonctionnalité #10001

édition en ligne Microsoft Office 365 dans un nouvel onglet via SharePoint

Added by Laurent GIOVANNONI over 3 years ago. Updated about 1 year ago.

Status:
Développé / Analysé (S)
Priority:
0-Bloquant
Target version:
Start date:
03/20/2019
Due date:
05/27/2021
Tags Courrier:
21.03.4
ROADMAP:
version stable (tag)

Description

Nous avons validé la possibilité de brancher onlyOffice à MaarchCourrier.
Il faut également étudier la possibilité de brancher Office365 ou LibreOffice Online.

L'idée étant de pouvoir proposer à nos utilisateurs le choix d'éditer leurs documents avec l'une ou l'autre des solutions.

Vue word sur office 365.png (22.8 KB) Vue word sur office 365.png Word en navigateur Emmanuel DILLARD, 02/22/2021 07:57 PM
Proto édition Sharepoint.pdf (206 KB) Proto édition Sharepoint.pdf Proto édition en onglet avec bouton de synchro Emmanuel DILLARD, 04/14/2021 10:27 AM
7439

Related issues

Copied to Backlog Courrier - Fonctionnalité #17026: ANALYSE - édition "embedded" via SharePoint sur Office 365Développé / Analysé (S)2019-03-202021-08-03

History

#1 Updated by Emmanuel DILLARD over 3 years ago

  • Status changed from A traiter to Prêt à embarquer

#2 Updated by Emmanuel DILLARD over 3 years ago

  • Priority changed from 2-Sérieux to 1-Majeur

#3 Updated by Laurent GIOVANNONI over 3 years ago

  • Subject changed from [edition en ligne] étudier la possibilité de pouvoir brancher onlyOffice et office365 to [edition en ligne] étudier la possibilité de pouvoir brancher onlyOffice, office365 ou LibreOffice Online
  • Description updated (diff)

#4 Updated by Laurent GIOVANNONI over 3 years ago

  • Status changed from Prêt à embarquer to En attente financement

#5 Updated by Emmanuel DILLARD over 3 years ago

  • Target version changed from 133 to 20.03 (Support restreint)

#7 Updated by Emmanuel DILLARD over 3 years ago

  • Status changed from En attente financement to 17

#9 Updated by Emmanuel DILLARD over 3 years ago

  • Status changed from 17 to A étudier

#11 Updated by Laurent GIOVANNONI over 3 years ago

Pour OnlyOffice, pour éviter d'avoir à installer un serveur, il faudrait voir si on ne peut pas télécharger dans le local storage du navitateur officeJs :

https://text.app.officejs.com/
choisir automatiquement localstorage

il faudrait convertir le doc bureautique au format docy avant de l'envoyer dans officejs

#12 Updated by Emmanuel DILLARD over 3 years ago

#13 Updated by Emmanuel DILLARD over 3 years ago

  • Subject changed from [edition en ligne] étudier la possibilité de pouvoir brancher onlyOffice, office365 ou LibreOffice Online to EPIC] [edition en ligne] étudier la possibilité de pouvoir brancher onlyOffice, office365 ou LibreOffice Online

#16 Updated by Laurent GIOVANNONI about 3 years ago

Compléments d'informations pour Office365 :

If you want to be able to edit excel and word document in the browser, you will have to go with Office Online Server or Office 365.

To be able to manage your files you need to implement a WOPI server to be able to send and receive those files either to Office Online. (This is how all major cloud storage companies does it).

This is an medium/hard implementation and takes some knowledge reading and time.

https://www.microsoft.com/en-us/microsoft-365/blog/2016/05/04/office-online-server-now-available/

https://wopi.readthedocs.io/en/latest/

https://www.youtube.com/watch?v=9lGonu0eoGA

#17 Updated by Emmanuel DILLARD about 3 years ago

  • Cible de départ : OnlyOffice

Attente des US sur la page d'indexation pour démarrer.

Office365 dans un second temps. (Payant....)

#19 Updated by Emmanuel DILLARD almost 3 years ago

  • Status changed from A étudier to En cours d'écriture PO

#24 Updated by Emmanuel DILLARD almost 3 years ago

  • Subject changed from EPIC] [edition en ligne] étudier la possibilité de pouvoir brancher onlyOffice, office365 ou LibreOffice Online to [edition en ligne] étudier la possibilité de pouvoir brancher Office365
  • Status changed from En cours d'écriture PO to A étudier
  • Assignee set to EDI PO
  • Priority changed from 1-Majeur to 2-Sérieux
  • Target version changed from 20.03 (Support restreint) to Inscription Backlog Courrier

#25 Updated by Emmanuel DILLARD almost 3 years ago

#28 Updated by Emmanuel DILLARD over 2 years ago

  • Priority changed from 2-Sérieux to 3-Mineur

#29 Updated by Emmanuel DILLARD over 2 years ago

  • Priority changed from 3-Mineur to 1-Majeur

#31 Updated by Emmanuel DILLARD over 2 years ago

  • Priority changed from 1-Majeur to 2-Sérieux

#34 Updated by Emmanuel DILLARD about 2 years ago

  • Status changed from A étudier to En attente financement
  • Priority changed from 2-Sérieux to 1-Majeur

#36 Updated by Emmanuel DILLARD almost 2 years ago

  • Project changed from Backlog to CURRENT SPRINT
  • Subject changed from [edition en ligne] étudier la possibilité de pouvoir brancher Office365 to [ANALYSE] étudier la possibilité de pouvoir brancher Office365
  • Status changed from En attente financement to En cours de dev (S)

#41 Updated by Florian AZIZIAN almost 2 years ago

  • Assignee deleted (EDI PO)

#42 Updated by Emmanuel DILLARD almost 2 years ago

  • Priority changed from 1-Majeur to 0-Bloquant

#44 Updated by Henri QUENEAU almost 2 years ago

il faut que la conversion en pdf des documents se fasse par office365 afin de respecter la charte graphique

#45 Updated by Emmanuel DILLARD almost 2 years ago

  • Due date set to 12/15/2020

#46 Updated by Emmanuel DILLARD almost 2 years ago

  • Target version changed from Inscription Backlog Courrier to Courrier 20.10.xx

#48 Updated by Florian AZIZIAN almost 2 years ago

Office365 utilise bien le protocole wopi, que nous avons intégré pour faire l'édition avec collaboraOnline.

Il y a cependant quelques spécificités à Office365.

Documentation pour "Office for the web" : https://wopi.readthedocs.io/en/latest/index.html

Première possibilité : Avoir un office dans le cloud (https://developer.microsoft.com/fr-fr/office/cloud-storage-partner-program)
- Prendre en compte l'abonnement business : https://wopi.readthedocs.io/en/latest/scenarios/business.html
- Contrôle de clé de sécurité : https://wopi.readthedocs.io/en/latest/scenarios/proofkeys.html
- Il y a une url de test, mais il faut enregistrer un domain, ce qui peut prendre plusieurs semaines (https://wopi.readthedocs.io/en/latest/build_test_ship/environments.html)

Deuxième possibilités : Installer On-Premise Office Online Server (https://docs.microsoft.com/fr-fr/OfficeOnlineServer/office-online-server)
- Pas de docker pour tester.

#49 Updated by Florian AZIZIAN almost 2 years ago

  • Status changed from En cours de dev (S) to Complément d'Informations
  • Assignee set to Florian AZIZIAN

#51 Updated by Emmanuel DILLARD almost 2 years ago

  • Assignee changed from Florian AZIZIAN to Henri QUENEAU

#53 Updated by Emmanuel DILLARD almost 2 years ago

  • Status changed from Complément d'Informations to 17

#54 Updated by Emmanuel DILLARD almost 2 years ago

  • Assignee changed from Henri QUENEAU to Florian AZIZIAN

#56 Updated by Florian AZIZIAN almost 2 years ago

D'après la documentation, il faut bien avoir un compte Office 365 - Cloud Storage Partner Program

https://wopi.readthedocs.io/en/latest/index.html

Voici le 1er pré-requis indiqué :

Be a member of the Office 365 - Cloud Storage Partner Program. Currently integration with the Office for the web cloud service is available to cloud storage partners. 
You can learn more about the program, as well as how to apply, at https://developer.microsoft.com/office/cloud-storage-partner-program.

Important

The Office 365 - Cloud Storage Partner Program is intended for independent software vendors whose business is cloud storage. It is not open to Office 365 customers directly.

#57 Updated by Florian AZIZIAN almost 2 years ago

  • Assignee changed from Florian AZIZIAN to EDI PO

#59 Updated by Emmanuel DILLARD almost 2 years ago

  • Due date changed from 12/15/2020 to 03/31/2021

#60 Updated by Emmanuel DILLARD almost 2 years ago

  • Due date changed from 03/31/2021 to 12/15/2020

#63 Updated by Emmanuel DILLARD almost 2 years ago

  • Project changed from CURRENT SPRINT to Backlog

#66 Updated by Emmanuel DILLARD almost 2 years ago

  • Due date deleted (12/15/2020)

#70 Updated by Emmanuel DILLARD almost 2 years ago

  • Status changed from 17 to Complément d'Informations

#73 Updated by Emmanuel DILLARD almost 2 years ago

  • Status changed from Complément d'Informations to Prêt à embarquer

#77 Updated by Emmanuel DILLARD almost 2 years ago

  • Project changed from Backlog to CURRENT SPRINT
  • Subject changed from [ANALYSE] étudier la possibilité de pouvoir brancher Office365 to édition avec l'API Office365 (Azure)
  • Status changed from Prêt à embarquer to En cours de dev (S)

#78 Updated by Florian AZIZIAN almost 2 years ago

  • Assignee deleted (EDI PO)

#79 Updated by Emmanuel DILLARD almost 2 years ago

  • Due date set to 03/09/2021

#81 Updated by Guillaume HEURTIER over 1 year ago

  • Assignee set to Guillaume HEURTIER

#82 Updated by Florian AZIZIAN over 1 year ago

  • Status changed from En cours de dev (S) to A retravailler (S)

#83 Updated by Emmanuel DILLARD over 1 year ago

  • Status changed from A retravailler (S) to En cours de dev (S)

#84 Updated by Emmanuel DILLARD over 1 year ago

  • Due date changed from 03/09/2021 to 03/23/2021

#86 Updated by Florian AZIZIAN over 1 year ago

  • Status changed from En cours de dev (S) to Complément d'Informations

Attente RDV prestataire

#87 Updated by Florian AZIZIAN over 1 year ago

  • Status changed from Complément d'Informations to En cours de dev (S)

#88 Updated by Florian AZIZIAN over 1 year ago

  • Status changed from En cours de dev (S) to Complément d'Informations

#92 Updated by Emmanuel DILLARD over 1 year ago

  • Due date deleted (03/23/2021)

#93 Updated by Emmanuel DILLARD over 1 year ago

  • Due date set to 04/06/2021

#94 Updated by Florian AZIZIAN over 1 year ago

Pas de réponse. Relance faite aujourd'hui.

#95 Updated by Florian AZIZIAN over 1 year ago

  • Status changed from Complément d'Informations to En cours de dev (S)

#98 Updated by Florian AZIZIAN over 1 year ago

  • Status changed from En cours de dev (S) to Complément d'Informations

#101 Updated by Emmanuel DILLARD over 1 year ago

  • Due date changed from 04/06/2021 to 04/20/2021

#104 Updated by Emmanuel DILLARD over 1 year ago

  • Project changed from CURRENT SPRINT to Backlog
  • Assignee changed from Guillaume HEURTIER to Henri QUENEAU

#107 Updated by Emmanuel DILLARD over 1 year ago

  • Subject changed from édition avec l'API Office365 (Azure) to édition en ligne avec Office Word 365
  • Due date deleted (04/20/2021)

#109 Updated by Emmanuel DILLARD over 1 year ago

  • Target version changed from Courrier 20.10.xx to 20.10 (Support actif)

#111 Updated by Emmanuel DILLARD over 1 year ago

  • Status changed from Complément d'Informations to Prêt à embarquer
  • Assignee changed from Henri QUENEAU to Guillaume HEURTIER
  • Target version changed from 20.10 (Support actif) to 21.03 (stable)

#112 Updated by Emmanuel DILLARD over 1 year ago

  • Subject changed from édition en ligne avec Office Word 365 to édition en ligne Microsoft Office 365 via SharePoint
  • Target version changed from 21.03 (stable) to Courrier 21.03 (stable)

#117 Updated by Henri QUENEAU over 1 year ago

  • Assignee changed from Henri QUENEAU to Guillaume HEURTIER

#119 Updated by Emmanuel DILLARD over 1 year ago

  • Status changed from Complément d'Informations to Prêt à embarquer

#121 Updated by Emmanuel DILLARD over 1 year ago

  • Assignee changed from Henri QUENEAU to EDI PO

#122 Updated by Emmanuel DILLARD over 1 year ago

  • Project changed from Backlog to CURRENT SPRINT
  • Subject changed from édition en ligne Microsoft Office 365 via SharePoint to édition en ligne Microsoft Office 365 dans un nouvel onglet via SharePoint
  • Status changed from Prêt à embarquer to En cours de dev (S)
  • Target version changed from Courrier 21.03 (stable) to Courrier Develop
  • Tags Parapheur 21.03.4 added

#123 Updated by Florian AZIZIAN over 1 year ago

  • Assignee deleted (EDI PO)

#125 Updated by Emmanuel DILLARD over 1 year ago

  • Due date set to 05/18/2021

#126 Updated by Florian AZIZIAN over 1 year ago

  • Assignee set to Guillaume HEURTIER

#127 Updated by Emmanuel DILLARD over 1 year ago

#128 Updated by Emmanuel DILLARD over 1 year ago

  • Priority changed from 0-Bloquant to 1-Majeur

#129 Updated by Emmanuel DILLARD over 1 year ago

  • Priority changed from 1-Majeur to 0-Bloquant

#130 Updated by Florian AZIZIAN over 1 year ago

  • Tags Courrier 21.03.4 added
  • Tags Parapheur deleted (21.03.4)

#131 Updated by GIT LAB over 1 year ago

Commit ajouté sur la branche develop de MaarchCourrier
FEAT #10001 TIME 17:00 editing document with office 365 via Sharepoint Online
https://labs.maarch.org/maarch/MaarchCourrier/commit/82cefec29d016253eaa4e95d786dc1431c79e0b0

#132 Updated by Guillaume HEURTIER over 1 year ago

  • Status changed from En cours de dev (S) to A tester (S)

#133 Updated by Damien BUREL over 1 year ago

  • Status changed from A tester (S) to Développé / Analysé (S)

#134 Updated by Emmanuel DILLARD over 1 year ago

  • Due date changed from 05/18/2021 to 05/27/2021
  • Status changed from Développé / Analysé (S) to Prêt à embarquer

RAF :

Wording "récupérer" : "Valider l'édition"
Message d'erreur quand on ne peut pas supprimer le document -> log sans affichage
? Nettoyer les résidus du drive Sharepoint -> nouvelle édition, supprimer les docs avec son identifiant (voir si pas consommateur de trop de temps / ressources)

#135 Updated by Emmanuel DILLARD over 1 year ago

  • Status changed from Prêt à embarquer to En cours de dev (S)

#136 Updated by Emmanuel DILLARD over 1 year ago

  • Due date changed from 05/27/2021 to 06/01/2021

#138 Updated by Emmanuel DILLARD over 1 year ago

  • Due date changed from 06/01/2021 to 05/27/2021

#139 Updated by GIT LAB over 1 year ago

Commit ajouté sur la branche develop de MaarchCourrier
FEAT #10001 TIME 3:25 delete old temporary files when sending document to sharepoint + log delete error
https://labs.maarch.org/maarch/MaarchCourrier/commit/b8b1337dcb895e74758d3c279e834029bb063547

#140 Updated by Guillaume HEURTIER over 1 year ago

  • Status changed from En cours de dev (S) to A tester (S)

#141 Updated by Damien BUREL over 1 year ago

  • Status changed from A tester (S) to Développé / Analysé (S)

#142 Updated by GIT LAB over 1 year ago

Commit ajouté sur la branche 21.03 de MaarchCourrier
FIX #10001 TIME 0:40 set option in creation/modification
https://labs.maarch.org/maarch/MaarchCourrier/commit/6d3c83018a36bd2b176386e0e579a52e58f467d6

#143 Updated by GIT LAB over 1 year ago

Commit ajouté sur la branche 20.10 de MaarchCourrier
FIX #10001 TIME 0:10 set option in creation/modification
https://labs.maarch.org/maarch/MaarchCourrier/commit/e1318a6cc4798995ea6e0ce36fe4a83a6e283155

#144 Updated by Emmanuel DILLARD over 1 year ago

  • Project changed from CURRENT SPRINT to Backlog

#145 Updated by Emmanuel DILLARD over 1 year ago

  • Project changed from Backlog to Backlog Courrier
  • Target version changed from Courrier Develop to Develop

#147 Updated by Emmanuel DILLARD over 1 year ago

  • Target version changed from Develop to 21.03

#148 Updated by Emmanuel DILLARD about 1 year ago

  • ROADMAP set to version stable (tag)

Also available in: Atom PDF