Zoho integration

Home Forums Developers Contributed Plugins Zoho integration

Tagged: , ,

This topic contains 22 replies, has 7 voices, and was last updated by Avatar of jmruas jmruas 2 years, 6 months ago.

Viewing 15 posts - 1 through 15 (of 23 total)
  • Author
    Posts
  • #41750
    Avatar of pwlw
    pwlw
    Member

    I developed a plugin that allows to edit text documents (MS Word, OpenOffice.org) using Zoho Remote API. Currently it doesn’t have many features, it supports DOC, ODT and SXW files, but it is possible to to add some functionality in order to use it to view and edit spreadsheets and presentations.

    Installation isn’t straightforward, since it is necessary to obtain Zoho API Key, and insert it into the source code manually. I described the installation process here: http://innodevel.net/head-over-clouds/2011/03/ajaxplorer-zoho-plugin/ .

    Other limitation I am aware of: plugin has locale set to “en”. I will change it if there are users interested in this plugin. The source code is attached to this post.

    Pawel


    #52634
    Avatar of charles
    charles
    Keymaster

    Hi @pwlw
    Nice shot, it’s been a while I’m looking at zoho but just don’t have time to implement it… I’ll have a look at your plugin and add it to the Plugins section. I may make some changes here and there if I find it useful. I’ll keep you in touch, thanks for getting this back to the community.
    Charles


    Charles, Pydio author - doing my best to help !
    If you like the software or want to say thanks, pay by a tweet, mention #pydio or follow us

    #52644
    Avatar of charles
    charles
    Keymaster

    Pawel,
    Just registered to Zoho and add my API key generated, everything works fine, except I can’t save documents : Zoho goes “save in progress”, and then “document format not supported”. I’ve tries Odt and Doc, same result, is it normal?


    Charles, Pydio author - doing my best to help !
    If you like the software or want to say thanks, pay by a tweet, mention #pydio or follow us

    #52645
    Avatar of charles
    charles
    Keymaster

    ok forget about my previous message, it is indeed normal as I’m working locally and don’t have a valid URL to which zoho can post… Not very fan of the save_zoho.php, it’s just a huge security hole in the application, don’t you think??


    Charles, Pydio author - doing my best to help !
    If you like the software or want to say thanks, pay by a tweet, mention #pydio or follow us

    #52646
    Avatar of pwlw
    pwlw
    Member

    Hi, thanks for taking a look at that piece of code. Plugin definitely needs some polishing — in fact it is only editor.pixlr with some changes in PHP code that sends file to Zoho servers.

    Editor.pixlr also saves files in more elegant way. I used save_zoho.php, because Zoho sends back files using post method instead of get, and this was the quickest way to do it. Do you think that documents should be saved using class.*.js file, like editor.pixlr does it?

    Pawel


    #52647
    Avatar of charles
    charles
    Keymaster

    i just spent some time on Zoho website and unfortunately it does not seem straightforward to find another solution and I guess we’re stuck on the POST mechanism here… There is maybe a way to implement what they call a “Remote Agent” (which is in fact exactly the kind of behaviour I implemented for pixlr), but they nowhere specify how this should work, to what URL it is connected, etc… And i’m not sure if it’s necessary a Java thing or it can be implemented in another language….
    On the POST side, we should at least implement some security check mechanism, like a secret function that in a way or another checks that the POSTed file is a known file and has the right to go in the target directory…


    Charles, Pydio author - doing my best to help !
    If you like the software or want to say thanks, pay by a tweet, mention #pydio or follow us

    #52648
    Avatar of pwlw
    pwlw
    Member

    I haven’t tested a Remote Agent, just because this method isn’t well documented and Zoho didn’t answer the questions posted on their forum. You probably are right and it would be better to if I try to think about some security check in that php file that saves documents that Zoho sends back. I will also take a closer look at editor.pixlr.


    #52916
    Avatar of coespino
    coespino
    Member

    hi pwlw

    i tried your plugin and it works i can now view .doc it doesnt matter if i cant edit it anyway can you tell me if is possible to open .xls in your plugin zoho as well?

    thanks


    #52921

    its available to .pdf and .ppt too?
    it would be amazing too.. thanks!


    #52924
    Avatar of charles
    charles
    Keymaster

    PDF is suppported by Image Magick plugin, if you have the opportunity to install it on your server


    Charles, Pydio author - doing my best to help !
    If you like the software or want to say thanks, pay by a tweet, mention #pydio or follow us

    #53159
    Avatar of chenchijin
    chenchijin
    Member

    I have tried to edit this plugin,but still can’t open other type of office documents except “word”.
    I think zoho’s remote API can support “.xls” and “.ppt”,but I don’t know how to embed in ajaxplorer.
    who can help me!!


    #53573

    Any news about of support to xls, ppt, and pdf files?
    Thanks!!


    #54511
    Avatar of MDE
    MDE
    Member

    Having this error when opening doc file…does anyone know how to solve this?

    RESULT=FALSE
    ERROR_CODE=1841
    WARNING=Unable to import content

    Okay solved the above issue. BUT…now i can get zoho to load but its not loading any of the files I try to open. Any options?


    #55511
    Avatar of charles
    charles
    Keymaster

    Hi all,
    FYI, I reworked the Zoho plugin and it’s included in the 3.3.5. It supports word, presentation and spreadsheets, and can be activated even with a local installation behind a firewall, by installing a small script somewhere on an accessible server. Please test it!
    Charles


    Charles, Pydio author - doing my best to help !
    If you like the software or want to say thanks, pay by a tweet, mention #pydio or follow us

    #55530
    Avatar of jmruas
    jmruas
    Participant

    The Zoho plugin works fine. We can use the API key for 3 months free. After that I presume they bill us.
    Thanks Charles.


Viewing 15 posts - 1 through 15 (of 23 total)

You must be logged in to reply to this topic.