Archives
Contributors
Re: Editing/Viewing attachments (mainly Word and Excel) directly on server without the need to download locally
Re: Editing/Viewing attachments (mainly Word and Excel) directly on server without the need to download locally
Re: Editing/Viewing attachments (mainly Word and Excel) directly on server without the need to download locally
Thanx for info. Will check the code of both. Will have to make an instance of 8.0 to be able to try it. Is there a reason in your opinion for this to depend on DMS (i.e. locking) or it can be done independently of it? If it can be done independently, should it be though? Best regards Radovan On nedeľa 20. septembra 2020 19:47:18 CEST Holger Brunn wrote: > > I'd be willing to try to port this to 13.0 Would you be so kind and > > provide > > some pointers and advice if needed? > > you definitely need some concept of locking, so attachment_lock will be > necessary to port, but also quite straightforward. For starting, I think you > can piggyback on dms' locking, but you'll miss a few things that > attackment_lock does. > You don't need attachment_action as this was just a container. nowadays all > of this happens much cleaner in > https://github.com/OCA/OCB/blob/13.0/addons/web/static/src/js/widgets/ > attach_document.js > which you can override directly > > > Also, is it OK to skip 4 major versions > > and port to 13.0 directly? > > absolutely > -- > Your partner for the hard Odoo problems > https://hunki-enterprises.com > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 [1] > Post to: mailto:contributors@odoo-community.org > Unsubscribe: https://odoo-community.org/groups?unsubscribe [2] > > > > [1] https://odoo-community.org/groups/contributors-15 > [2] https://odoo-community.org/groups?unsubscribe
by Radovan Skolnik - 08:01 - 20 Sep 2020
Reference
-
Editing/Viewing attachments (mainly Word and Excel) directly on server without the need to download locally
Hello,
I am investigating a possibility of allowing somehow editing and viewing of attachments without the need to download and reupload them locally. I would like for Odoo to replace any local storage and save users from need to download/upload the files. DMS module comes to mind as a good base for orgnaizing that. I can see multiple building blocks for this but I am interested if anyone has taken this idea any further. Some of the possible building blocks could be:
- WebDav support - like https://github.com/OCA/server-backend/pull/61
- integration with Google Docs / Microsoft Web Suite / LibreOffice Online
- CMIS
- SharePoint or SharePoint like services
- possibly LibreOffice ActiveX control to stay in browser (there's similar thing for Microsoft)
I was able to access demo of Odoo 14.0 Enterprise with new possibility to create "live" spreadsheets. Don't know how that is done (is it 14.0's module google_spreadsheets?) but that won't allow for opening your own Excel nor Word files :-(
Has anyone attempted anything like this succesfully? Can you give any pointers please? Thank you
Best regards
Radovan Skolnik
by Radovan Skolnik - 04:51 - 20 Sep 2020-
Re: Editing/Viewing attachments (mainly Word and Excel) directly on server without the need to download locally
Is this what they use for "live" spreadsheets in 14.0? I wonder why they didn't allow for editing other xls/xlsx/... files. This would certainly be an option for "simpler" files. I can imagine more complicated files. Also Word/Writer and PowerPoint/Impress files remains... But great point. Thank you. Radovan On pondelok 21. septembra 2020 11:12:02 CEST David Beal wrote: > Hi all, > Odoo resolve this question with an external repo > https://github.com/myliang/x-spreadsheet [1] (odoo forked it) Nothing > prevent to do the same (no copy odoo code) just using x-spreadsheet code > Regards > > David BEAL - akretion.com [2] Consultant > Odoo Intégration / Développement > Le lun. 21 sept. 2020 à 10:42, Radovan Skolnik < radovan@skolnik.info [3] > > a écrit : Will have a look. While researching this I found many mentions of > Alfresco implementing required subset of SharePoint services which I > thought could be used as a base for something like this. > Thank you. Best regards > Radovan > > On pondelok 21. septembra 2020 10:36:47 CEST Mignon, Laurent wrote: > > You can take a look at alfodoo. https://github.com/acsone/alfodoo [4] [1] > > Alfodoo is a set of addons to seamlessly integrate an external Document > > Management System (Alfresco) with Odoo. Regards, > > Laurent Mignon > > On Mon, Sep 21, 2020 at 10:21 AM Johan Van Hirtum < johan@vanhirtum.be > > [5] [2] > wrote: Dear, > > > > There is a connector module to Nextcloud / Owncloud in the app store. With > > this module, you can, use the full power of these DMS systems. Nextcloud > > is > > open source. I believe this is the best way to achieve what you want. > > > > Kind regards, > > > > Van Hirtum Johan > > > > * Van: * Radovan Skolnik [mailto: radovan@skolnik.info [6] [3] ] > > *Verzonden:* zondag 20 september 2020 16:52 > > *Aan:* Contributors > > *Onderwerp:* Editing/Viewing attachments (mainly Word and Excel) directly > > on server without the need to download locally Hello, > > I am investigating a possibility of allowing somehow editing and viewing > > of > > attachments without the need to download and reupload them locally. I > > would > > like for Odoo to replace any local storage and save users from need to > > download/upload the files. DMS module comes to mind as a good base for > > orgnaizing that. I can see multiple building blocks for this but I am > > interested if anyone has taken this idea any further. Some of the possible > > building blocks could be: WebDav support - like None [4] > > > > https://github.com/OCA/server-backend/pull/61 [7] integration with > > Google > > > > Docs / Microsoft Web Suite / None [5] LibreOffice Online None [6] CMIS > > SharePoint or SharePoint like services possibly None [7] LibreOffice > > ActiveX control to stay in browser (there's similar thing for Microsoft) I > > was able to access demo of Odoo 14.0 Enterprise with new possibility to > > create "live" spreadsheets. Don't know how that is done (is it 14.0's > > module google_spreadsheets?) but that won't allow for opening your own > > Excel nor Word files :-( Has anyone attempted anything like this > > succesfully? Can you give any pointers please? Thank you Best regards > > Radovan Skolnik > > _______________________________________________ > > Mailing-List: https://odoo-community.org/groups/contributors-15 [8] [8] > > Post to: mailto: contributors@odoo-community.org [9] [9] > > Unsubscribe: https://odoo-community.org/groups?unsubscribe [10] [10] > > _______________________________________________ > > Mailing-List: https://odoo-community.org/groups/contributors-15 [11] [11] > > Post to: mailto: contributors@odoo-community.org [12] [12] > > Unsubscribe: https://odoo-community.org/groups?unsubscribe [13] [13] > > > > > > _______________________________________________ > > Mailing-List: https://odoo-community.org/groups/contributors-15 [14] [14] > > Post to: mailto: contributors@odoo-community.org [15] > > Unsubscribe: https://odoo-community.org/groups?unsubscribe [16] [15] > > > > > > > > [1] https://github.com/acsone/alfodoo [17] > > [2] mailto: johan@vanhirtum.be [18] > > [3] mailto: radovan@skolnik.info [19] > > [4] https://github.com/OCA/server-backend/pull/61 [20] > > [5] https://libreoffice.org/download/libreoffice-online/ [21] > > [6] > > > > https://en.wikipedia.org/wiki/Content_Management_Interoperability_Service > > s [22]> > > [7] > > > > https://help.libreoffice.org/latest/en-US/text/shared/guide/activex.html? > > Db [23]> > > PAR=SHARED#bm_id3143267 [8] > > > > https://odoo-community.org/groups/contributors-15 [24] > > > > [9] mailto: contributors@odoo-community.org [25] > > [10] https://odoo-community.org/groups?unsubscribe [26] > > [11] https://odoo-community.org/groups/contributors-15 [27] > > [12] mailto: contributors@odoo-community.org [28] > > [13] https://odoo-community.org/groups?unsubscribe [29] > > [14] https://odoo-community.org/groups/contributors-15 [30] > > [15] https://odoo-community.org/groups?unsubscribe [31] > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 [32] > Post to: mailto: contributors@odoo-community.org [33] > Unsubscribe: https://odoo-community.org/groups?unsubscribe [34] > > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 [35] > Post to: mailto:contributors@odoo-community.org > Unsubscribe: https://odoo-community.org/groups?unsubscribe [36] > > > > [1] https://github.com/myliang/x-spreadsheet > [2] http://akretion.com > [3] mailto:radovan@skolnik.info > [4] https://github.com/acsone/alfodoo > [5] mailto:johan@vanhirtum.be > [6] mailto:radovan@skolnik.info > [7] https://github.com/OCA/server-backend/pull/61 > [8] https://odoo-community.org/groups/contributors-15 > [9] mailto:contributors@odoo-community.org > [10] https://odoo-community.org/groups?unsubscribe > [11] https://odoo-community.org/groups/contributors-15 > [12] mailto:contributors@odoo-community.org > [13] https://odoo-community.org/groups?unsubscribe > [14] https://odoo-community.org/groups/contributors-15 > [15] mailto:contributors@odoo-community.org > [16] https://odoo-community.org/groups?unsubscribe > [17] https://github.com/acsone/alfodoo > [18] mailto:johan@vanhirtum.be > [19] mailto:radovan@skolnik.info > [20] https://github.com/OCA/server-backend/pull/61 > [21] https://libreoffice.org/download/libreoffice-online/ > [22] > https://en.wikipedia.org/wiki/Content_Management_Interoperability_Services > [23] > https://help.libreoffice.org/latest/en-US/text/shared/guide/activex.html?Db > [24] https://odoo-community.org/groups/contributors-15 > [25] mailto:contributors@odoo-community.org > [26] https://odoo-community.org/groups?unsubscribe > [27] https://odoo-community.org/groups/contributors-15 > [28] mailto:contributors@odoo-community.org > [29] https://odoo-community.org/groups?unsubscribe > [30] https://odoo-community.org/groups/contributors-15 > [31] https://odoo-community.org/groups?unsubscribe > [32] https://odoo-community.org/groups/contributors-15 > [33] mailto:contributors@odoo-community.org > [34] https://odoo-community.org/groups?unsubscribe > [35] https://odoo-community.org/groups/contributors-15 > [36] https://odoo-community.org/groups?unsubscribe
by Radovan Skolnik - 11:21 - 21 Sep 2020 -
Re: Editing/Viewing attachments (mainly Word and Excel) directly on
server without the need to download locally
Hi all,Odoo resolve this question with an external repo https://github.com/myliang/x-spreadsheet (odoo forked it)Nothing prevent to do the same (no copy odoo code) just using x-spreadsheet codeLe lun. 21 sept. 2020 à 10:42, Radovan Skolnik <radovan@skolnik.info> a écrit :Will have a look. While researching this I found many mentions of Alfresco implementing required subset of SharePoint services which I thought could be used as a base for something like this. Thank you. Best regards Radovan On pondelok 21. septembra 2020 10:36:47 CEST Mignon, Laurent wrote: > You can take a look at alfodoo. https://github.com/acsone/alfodoo [1] > Alfodoo is a set of addons to seamlessly integrate an external Document > Management System (Alfresco) with Odoo. Regards, > Laurent Mignon > On Mon, Sep 21, 2020 at 10:21 AM Johan Van Hirtum < johan@vanhirtum.be [2] > > wrote: Dear, > > There is a connector module to Nextcloud / Owncloud in the app store. With > this module, you can, use the full power of these DMS systems. Nextcloud is > open source. I believe this is the best way to achieve what you want. > > Kind regards, > > Van Hirtum Johan > > * Van: * Radovan Skolnik [mailto: radovan@skolnik.info [3] ] > *Verzonden:* zondag 20 september 2020 16:52 > *Aan:* Contributors > *Onderwerp:* Editing/Viewing attachments (mainly Word and Excel) directly on > server without the need to download locally Hello, > I am investigating a possibility of allowing somehow editing and viewing of > attachments without the need to download and reupload them locally. I would > like for Odoo to replace any local storage and save users from need to > download/upload the files. DMS module comes to mind as a good base for > orgnaizing that. I can see multiple building blocks for this but I am > interested if anyone has taken this idea any further. Some of the possible > building blocks could be: WebDav support - like None [4] > https://github.com/OCA/server-backend/pull/61 integration with Google > Docs / Microsoft Web Suite / None [5] LibreOffice Online None [6] CMIS > SharePoint or SharePoint like services possibly None [7] LibreOffice > ActiveX control to stay in browser (there's similar thing for Microsoft) I > was able to access demo of Odoo 14.0 Enterprise with new possibility to > create "live" spreadsheets. Don't know how that is done (is it 14.0's > module google_spreadsheets?) but that won't allow for opening your own > Excel nor Word files :-( Has anyone attempted anything like this > succesfully? Can you give any pointers please? Thank you Best regards > Radovan Skolnik > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 [8] > Post to: mailto: contributors@odoo-community.org [9] > Unsubscribe: https://odoo-community.org/groups?unsubscribe [10] > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 [11] > Post to: mailto: contributors@odoo-community.org [12] > Unsubscribe: https://odoo-community.org/groups?unsubscribe [13] > > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 [14] > Post to: mailto:contributors@odoo-community.org > Unsubscribe: https://odoo-community.org/groups?unsubscribe [15] > > > > [1] https://github.com/acsone/alfodoo > [2] mailto:johan@vanhirtum.be > [3] mailto:radovan@skolnik.info > [4] https://github.com/OCA/server-backend/pull/61 > [5] https://libreoffice.org/download/libreoffice-online/ > [6] > https://en.wikipedia.org/wiki/Content_Management_Interoperability_Services > [7] > https://help.libreoffice.org/latest/en-US/text/shared/guide/activex.html?Db > PAR=SHARED#bm_id3143267 [8] > https://odoo-community.org/groups/contributors-15 > [9] mailto:contributors@odoo-community.org > [10] https://odoo-community.org/groups?unsubscribe > [11] https://odoo-community.org/groups/contributors-15 > [12] mailto:contributors@odoo-community.org > [13] https://odoo-community.org/groups?unsubscribe > [14] https://odoo-community.org/groups/contributors-15 > [15] https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by David BEAL - 11:10 - 21 Sep 2020 -
Re: Editing/Viewing attachments (mainly Word and Excel) directly on server without the need to download locally
Looking for alternatives I found these 2 articles that summarize exactly what I would need:
https://mikekaganski.wordpress.com/2016/10/29/first-blog-post/
https://mikekaganski.wordpress.com/2016/11/20/integrating-libreoffice-with-sharepoint-part-2/
So the alternatives (protocol - wise) that I can see are (talking about editing in desktop version of LibreOffice / MS Office):
- WebDAV
- CMIS
I have been looking for WebDAV already and mentioned it in initial email. Looking for CMIS I found this: https://github.com/OCA/connector-cmis
However that is for integration with external CMIS server such as Alfresco. So I would need to implement CMIS server as Odoo module to achieve what I want. Will research that.
Best regards
Radovan
On pondelok 21. septembra 2020 10:36:47 CEST Mignon, Laurent wrote:
> You can take a look at alfodoo. https://github.com/acsone/alfodoo [1]
> Alfodoo is a set of addons to seamlessly integrate an external Document
> Management System (Alfresco) with Odoo. Regards,
> Laurent Mignon
> On Mon, Sep 21, 2020 at 10:21 AM Johan Van Hirtum < johan@vanhirtum.be [2] >
> wrote: Dear,
>
> There is a connector module to Nextcloud / Owncloud in the app store. With
> this module, you can, use the full power of these DMS systems. Nextcloud is
> open source. I believe this is the best way to achieve what you want.
>
> Kind regards,
>
> Van Hirtum Johan
>
> * Van: * Radovan Skolnik [mailto: radovan@skolnik.info [3] ]
> *Verzonden:* zondag 20 september 2020 16:52
> *Aan:* Contributors
> *Onderwerp:* Editing/Viewing attachments (mainly Word and Excel) directly on
> server without the need to download locally Hello,
> I am investigating a possibility of allowing somehow editing and viewing of
> attachments without the need to download and reupload them locally. I would
> like for Odoo to replace any local storage and save users from need to
> download/upload the files. DMS module comes to mind as a good base for
> orgnaizing that. I can see multiple building blocks for this but I am
> interested if anyone has taken this idea any further. Some of the possible
> building blocks could be: WebDav support - like None [4]
> https://github.com/OCA/server-backend/pull/61 integration with Google
> Docs / Microsoft Web Suite / None [5] LibreOffice Online None [6] CMIS
> SharePoint or SharePoint like services possibly None [7] LibreOffice
> ActiveX control to stay in browser (there's similar thing for Microsoft) I
> was able to access demo of Odoo 14.0 Enterprise with new possibility to
> create "live" spreadsheets. Don't know how that is done (is it 14.0's
> module google_spreadsheets?) but that won't allow for opening your own
> Excel nor Word files :-( Has anyone attempted anything like this
> succesfully? Can you give any pointers please? Thank you Best regards
> Radovan Skolnik
> _______________________________________________
> Mailing-List: https://odoo-community.org/groups/contributors-15 [8]
> Post to: mailto: contributors@odoo-community.org [9]
> Unsubscribe: https://odoo-community.org/groups?unsubscribe [10]
> _______________________________________________
> Mailing-List: https://odoo-community.org/groups/contributors-15 [11]
> Post to: mailto: contributors@odoo-community.org [12]
> Unsubscribe: https://odoo-community.org/groups?unsubscribe [13]
>
>
> _______________________________________________
> Mailing-List: https://odoo-community.org/groups/contributors-15 [14]
> Post to: mailto:contributors@odoo-community.org
> Unsubscribe: https://odoo-community.org/groups?unsubscribe [15]
>
>
>
> [1] https://github.com/acsone/alfodoo
> [2] mailto:johan@vanhirtum.be
> [3] mailto:radovan@skolnik.info
> [4] https://github.com/OCA/server-backend/pull/61
> [5] https://libreoffice.org/download/libreoffice-online/
> [6]
> https://en.wikipedia.org/wiki/Content_Management_Interoperability_Services
> [7]
> https://help.libreoffice.org/latest/en-US/text/shared/guide/activex.html?Db
> PAR=SHARED#bm_id3143267 [8]
> https://odoo-community.org/groups/contributors-15
> [9] mailto:contributors@odoo-community.org
> [10] https://odoo-community.org/groups?unsubscribe
> [11] https://odoo-community.org/groups/contributors-15
> [12] mailto:contributors@odoo-community.org
> [13] https://odoo-community.org/groups?unsubscribe
> [14] https://odoo-community.org/groups/contributors-15
> [15] https://odoo-community.org/groups?unsubscribe
by Radovan Skolnik - 11:00 - 21 Sep 2020