topic Re: Alfresco 3.4.d + Office 2010 in Alfresco Archive

Alfresco 3.4.d + Office 2010

latre — Mon, 11 Jul 2011 17:23:44 GMT

I have my alfresco 3.4.d in linux and i can access to my AD in 2008, i can see http://MyIP:8080/alfresco and http://MyIP:8080/share no problems, i can work with 2003 and 2007(sharepoint protocol).But now i need work with 2010, and when i want open a document with http://MyIP:7070/alfresco/ ask for a

Re: Alfresco 3.4.d + Office 2010

mikeh — Mon, 11 Jul 2011 20:15:15 GMT

Microsoft have removed the ability to create document workspaces from Office 2010, effectively breaking the Sharepoint connector. As far as I'm aware there's no workaround or simple fix for this fundamental change.

Thanks,
Mike

Re: Alfresco 3.4.d + Office 2010

latre — Fri, 15 Jul 2011 13:03:54 GMT

So, Office2010 can not work with Alfresco?

Re: Alfresco 3.4.d + Office 2010

fap99 — Fri, 15 Jul 2011 21:01:28 GMT

Sorry to use the same Topic but i have a "problem" with Alfresco 3.4.d + Office 2010

I have tried to follow the instructions in here (http://docs.alfresco.com/3.4/index.jsp?topic=%2Fcom.alfresco.Enterprise_3_4_0.doc%2Fconcepts%2FSharePoint-onlineedit.html) to install the SharePoint Protocol in order to "Edit Online" MS Office 2010 documents (word, excel,…) , without success.

In alfresco-enterprise-spp-3.4.2.zip file, the vti-module.amp file doesnt exist.

I'm using Alfresco on Windows 7 64bits.
I'm new at this, could anyone help me please?

Thanks

Re: Alfresco 3.4.d + Office 2010

sasquatch58 — Sat, 16 Jul 2011 04:34:52 GMT

alfresco-enterprise-spp-3.4.2.zip file,

- this is the correct file, just that the documentation hasn't kept up with the later amp modules.
If you install it into alfresco.war and then run:

java -jar alfresco-mmt.jar list [path to war file]/alfresco.war
‍‍

You should get a result like this - file paths are from my community installation:

Module 'org_alfresco_module_wcmquickstart' installed in '../web-server/webapps/alfresco.war'
   -    Title:        WCM Quick Start
   -    Version:      1.0
   -    Install Date: Sat Jul 02 18:47:45 NZST 2011
   -    Desription:   WCM Quick Start
Module 'org_alfresco_module_dod5015' installed in '../web-server/webapps/alfresco.war'
   -    Title:        DOD 5015 Records Management
   -    Version:      1.0
   -    Install Date: Sun Jun 26 23:43:02 NZST 2011
   -    Desription:   Alfresco DOD 5015 Record Management Extension
Module 'org.alfresco.module.vti' installed in '../web-server/webapps/alfresco.war'
   -    Title:        Vti
   -    Version:      1.2
   -    Install Date: Sun Jun 26 17:19:12 NZST 2011
   -    Desription:   Alfresco Vti Extension

The last module listed is the vti module - sharepoint support
Don't forget to add the necessary stuff to alfresco-global.properties

#
# Sharepoint
#————-
vti.server.port=7070
vti.alfresco.deployment.context=/alfresco
vti.alfresco.alfresoHostWithPort=http://[servername]:8080
vti.share.shareHostWithPort=http://[servername]:8080‍‍‍‍‍‍‍

Cheers, Sasquatch

Re: Alfresco 3.4.d + Office 2010

fap99 — Sat, 16 Jul 2011 16:31:35 GMT

Many thanks, for your help.

Re: Alfresco 3.4.d + Office 2010

sashah — Mon, 18 Jul 2011 12:55:45 GMT

Hi,

Just to be clear, if I install this module will Office 2010 integration work?

Also how can I get the alfresco-enterprise-spp-3.4.2.zip as I am using the Community edition.

Thanks

Re: Alfresco 3.4.d + Office 2010

heiko_robert — Mon, 18 Jul 2011 14:45:00 GMT

if you need the community version you should use the SSP amp for that version:
alfresco-community-spp-3.4.d.zip
The procedure to install ist the same.
It works for us to open or save docs in Office 2010 but functionality is very limted.

Re: Alfresco 3.4.d + Office 2010

sashah — Mon, 18 Jul 2011 20:11:27 GMT

Hi

The file alfresco-community-spp-3.4.d.amp is already in my amps dir.

I have added the following to my alfresco-global.properties file (see code below) and restarted server but I still have the same issue that when I open the doc 'edit online' I get a windows authentication box that wont accept any credentials

Note I can login to alfresco share using AD credentials so the passthru is working. Also I noticed in:

HKCU\Software\Microsoft\Office\14.0\Common\Internet: BasicAuthLevel=2.
I have UseRWHLinkNavigation has been added with my alfresco server URL.

Also in Office 2007 running Win xp it works but I always have to enter credentials ie. is ntlm supposed to pass on windows credentials automatically??


### Authentication LDAP ###
authentication.chain=passthru1:passthru,ldap-ad1:ldap-ad,alfrescoNtlm1:alfrescoNtlm
ntlm.authentication.sso.enabled=true

### Sharepoint VTI ###
vti.server.port=7070
vti.server.external.host=${localname}
vti.server.external.port=${vti.server.port}
vti.share.siteInBrowser=/page/site/…/dashboard
vti.share.siteSettings=/page/site/…/customise-site
vti.share.siteGroupMembership=/page/site/…/site-members
vti.share.userInformation=/page/user/…/profile
vti.share.documentLibrary=/page/site/…/documentlibrary
vti.share.documentDetails=/page/site/…/document-details
vti.share.calendar=/page/site/…/calendar‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Alfresco 3.4.d + Office 2010

craig_michael_n — Wed, 27 Jul 2011 17:38:41 GMT

So to revisit office 2010 with alfresco. So is there anyway to use the Sharepoint workspace manager with alfresco?

Re: Alfresco 3.4.d + Office 2010

sashah — Mon, 01 Aug 2011 15:53:06 GMT

I'm at my wits end with this:

Windows XP: Works perfectly with all versions of Office. I get a login prompt, enter my credentials and it works fine.

Windows 7: Does not work with any version of office. I always get a login prompt, it doesn't matter what credentials I use, the login is not accepted.

The issue is definitely Win7 specific but all the guides I follow make no difference. Is there anyone out there prepared to access my DM from a Win7 machine and let me know if they have any success?? PM me and I will create a site login for you.

Note this isn't an Office 2010 issue but a Win7 issue

Re: Alfresco 3.4.d + Office 2010

pneumatic — Wed, 03 Aug 2011 15:00:32 GMT

I can use Office 2007 on Win7 to access the Sharepoint interface just fine. When I attempt Office 2010 from Win7, I get the popup when I open the document, then Word starts up but only to a blank document.

Does anyone have Office 2010 working with Alfresco 3.4d from Win7?

Anyone?

Re: Alfresco 3.4.d + Office 2010

fap99 — Thu, 04 Aug 2011 08:58:08 GMT

Hi,

I have Office 2010 working with Alfresco 3.4d in Win7.

Did you add the key to your registry?

Re: Alfresco 3.4.d + Office 2010

sashah — Thu, 04 Aug 2011 16:18:18 GMT

Hi,

I did. Is that what made it work for you??

Would you be willing to log into my DM from your Win7 machine and try 'edit online'? At least that would confirm absolutely that it is my Win7 clients and not some security issue with Win7 and my alfresco-sharepoint module setup.

Re: Alfresco 3.4.d + Office 2010

pneumatic — Fri, 12 Aug 2011 19:18:09 GMT

Office 2010 started working for me after I started to configure NTLM and SSO. Notably, when I added this to alfresco-global.properties:

authentication.chain=alfrescoNtlm1:alfrescoNtlm,passthru1:passthru,ldap1:ldap-ad
ntlm.authentication.sso.enabled=true
ntlm.authentication.mapUnknownUserToGuest=false
passthru.authentication.domain=MYDOMAIN
passthru.authentication.servers=MYDOMAIN\\mydc1.mydomain.local
passthru.authentication.authenticateCIFS=true
passthru.authentication.authenticateFTP=true
passthru.authentication.guestAccess=true
passthru.authentication.defaultAdministratorUserNames=admin
‍‍‍‍‍‍‍‍‍‍

Restart alfresco and try again.

Re: Alfresco 3.4.d + Office 2010

deas0815 — Wed, 17 Aug 2011 08:20:42 GMT

Hallo everbody,

been trying out alfresco spp for a few days using windows 7 + office 2007 with alfresco community 3.4.c and 4.0.a-070811, following docs.alfresco.com and http://wiki.alfresco.com/wiki/SharePoint_Protocol .

I'm using NTLM/SSO (alfrescoNtlm - not passthrough at this stage), and even although credentials are the same on both system (windows and alfresco), windows shows me the login prompt and requires me to fill in the password (which is accepted). This is the only remaining issue I can see so far. Maybe that is why the wiki tells to use HEAD with windows 7 (Have not tried NTLM SSO so far with 4.0.a).

We would also like to use alfresco (no matter what version - HEAD is fine if nothing else works) with office 2010. Heiko mentions "functionality is very limted".

Is the alfresco spp + office 2010 combo usable at all ?

Anybody here using alfresco community spp in production (any version of ms office) ?

Any hints where to expect trouble are appreciated.

cheers
Andreas

Re: Alfresco 3.4.d + Office 2010

latre — Wed, 17 Aug 2011 17:55:52 GMT

Still not work with changes in alfresco-global.properties and regedit in Win7.

Pneumatic …can you post your alfresco-global.properties complete??

You made any changes in win7 or office2010?

Re: Alfresco 3.4.d + Office 2010

deas0815 — Thu, 18 Aug 2011 12:41:42 GMT

we had a whole lot of problems (with Office 2007 and any Alfresco version) until we (just as pneumatic mentioned before) had NTLM set up "properly". It was essential for us to get it working with no authentication dialog showing up (Alfresco Server in "Intranet" Zone").

cheers
Andreas

Re: Alfresco 3.4.d + Office 2010

mikeh — Thu, 18 Aug 2011 16:59:35 GMT

Have you guys tried the following registry key (I'm not sure if this affects NTLM or not)

HKCU\Software\Microsoft\Office\14.0\Common\Internet: BasicAuthLevel=2‍

Additionally for Windows 7 you might have to play with the security settings mainly in Options - Trust Center - Trust Center setting (especially "Protected view", "File block settings" and "Privacy options".

Thanks,
Mike

Re: Alfresco 3.4.d + Office 2010

sashah — Tue, 18 Oct 2011 20:51:01 GMT

Hi,

I still have the same issue. I even set alfresco up on a new domain and that didnt help.

XP - I always get the password box but it works and opens the docs

7 - Password box keeps coming back up, ie password is not being accepted

- How can I stop the password box coming up in XP and make 7 work? (Note I have tried all the aforementioned reg mods, Office settings etc.

- Does Alfresco 4.0a do the authentication, sharepoint module stuff any differently ie. is it worth me trying it?

- See below my alfresco-global-properties file, anything I need to add?


###############################
## Common Alfresco Properties #
###############################

dir.root=C:/Alfresco/alf_data

web.application.context.url=http://127.0.0.1:8080/alfresco

### database connection properties ###
db.driver=org.gjt.mm.mysql.Driver
db.username=alfresco
db.password=n3tg3ar2011
db.name=alfresco
db.url=jdbc:mysql://localhost:3306/${db.name}?useUnicode=yes&characterEncoding=UTF-8

### FTP Server Configuration ###
ftp.enabled=true
ftp.port=21
ftp.ipv6.enabled=false

### RMI service ports ###
alfresco.rmi.services.port=50500
avm.rmi.service.port=0
avmsync.rmi.service.port=0
attribute.rmi.service.port=0
authentication.rmi.service.port=0
repo.rmi.service.port=0
action.rmi.service.port=0
deployment.rmi.service.port=0

### External executable locations ###
ooo.exe=C:/Alfresco/openoffice/App/openoffice/program/soffice.exe
ooo.enabled=true
img.root=C:/Alfresco/imagemagick
img.dyn=${img.root}/lib
img.exe=${img.root}/convert
swf.exe=C:/Alfresco/swftools/pdf2swf.exe
jodconverter.enabled=true 
jodconverter.officeHome=C:/Alfresco/openoffice/App/openoffice 
jodconverter.portNumbers=8101 

### Initial admin password ###
alfresco_user_store.adminpassword=202cb962ac59075b964b07152d234b70

### Authentication LDAP ###
authentication.chain=passthru1:passthru,ldap-ad1:ldap-ad,alfrescoNtlm1:alfrescoNtlm
ntlm.authentication.sso.enabled=true
passthru.authentication.domain=impero
passthru.authentication.servers=impero\\impero-dc1.impero.local
passthru.authentication.authenticateCIFS=true
passthru.authentication.authenticateFTP=true
passthru.authentication.guestAccess=true
passthru.authentication.defaultAdministratorUserNames=admin

### Sharepoint VTI ###
vti.server.port=7070
###vti.server.external.host=${localname}
vti.server.external.host=dm.imperosoftware.com
vti.server.external.port=${vti.server.port}
vti.share.siteInBrowser=/page/site/…/dashboard
vti.share.siteSettings=/page/site/…/customise-site
vti.share.siteGroupMembership=/page/site/…/site-members
vti.share.userInformation=/page/user/…/profile
vti.share.documentLibrary=/page/site/…/documentlibrary
vti.share.documentDetails=/page/site/…/document-details
vti.share.calendar=/page/site/…/calendar


‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍