topic Re: Google Docs integration in Alfresco Archive

Google Docs integration

ganeshthevar — Fri, 28 Jun 2013 10:29:41 GMT

Hello Everyone,1) i newbie in alfresco. i installed Alfresco 4.2.c successfully. but i upload a spreadsheet and click "edit online" menu but dos not work. i googlee but i didn't find proper solution pls help me.2) i edit with google docs but google docs want login in every user's login. can i set on

Re: Google Docs integration

jpotts — Fri, 28 Jun 2013 21:07:57 GMT

Please read this thread:
https://forums.alfresco.com/forum/installation-upgrades-configuration-integration/installation-upgrades/sharepoint-bug-edit

Regarding Google Docs integration, yes, your users will need Google accounts.

Jeff

Re: Google Docs integration

ganeshthevar — Sat, 29 Jun 2013 09:14:00 GMT

thanks jeff.. i uninstall 4.2.c and install nightly version 4.2.d it's working.

Re: Google Docs integration

ganeshthevar — Mon, 01 Jul 2013 04:43:16 GMT

Another question every time open the documents server want's login and every edit document version also change like 1.0, 1.1,1.2.
i access my alfresco server over internet (branch office)and port forwarded to my local alfresco server http://192.168.0.6:8080/share i can access in my branch office this server but problem is i click on online edit i get a message "message from webpage "you are opening follwing
file
File Name:marathon List.xlsx
From:TrinityLap:7070
the i click ok opening excel file and i get the error messangecould not open http://******************************** .xlsx

pls help me

sorry for my bad english

Re: Google Docs integration

bopolissimus — Mon, 01 Jul 2013 06:05:03 GMT

alfresco generates the URL to the file to edit online from entries in alfresco-global.properties. when you're doing port forwarding (perhaps because you're not on a VPN and don't have a direct connection to the alfresco server which may be on your intranet and isn't accessible from the internet), when you click edit online, the browser will redirect you to a hostnameort that you're not currently able to reach. that's why you're not able to correctly connect to the server and get the file.

The simplest solution would probably be to edit /etc/hosts and have an entry for the alfresco hostname that is mapped to 127.0.0.1 (or 192.168.0.6 in your case). That way, when the alfresco server redirects you to the real hostname, it'll resolve to localhost or 192.168.0.6 and the request will go through your port forward.

You may need to do two port forwards, one for the /alfresco and /share port and one for the vti/sharepoint port. and if you're going to do this /etc/hosts trick then you'll need to make sure that your sharepoint port (the one you're port forwarding) is the same on localhost as on the alfresco server.

good luck.

Re: Google Docs integration

ganeshthevar — Mon, 01 Jul 2013 12:39:48 GMT

Hi Bopolissimus,

i checked above method's but still not working i get the follwing error message Microsoft Excel canot access the file http://TrinityLap:7070/alfresco/trinity/documentlibrary/Test/System Details.xlsx. there are serveral possible reasons

I forwarded follwing Ports: 8080,7070

and also tried /etc/host/
127.0.0.1 TrinityLap, TrinityLap 127.0.0.1, 192.168.0.6 TrinityLap

i think some think wrong in my settings.

Re: Google Docs integration

ganeshthevar — Thu, 04 Jul 2013 03:54:43 GMT

Pls jeff help me..