Problem with the Sharepoint functionality

[moe]

Hello,

first of all, I`m pretty new to Alfresco as I`ve installed the software just yesterday.
So please don`t mind if I`m asking a beginner`s question.

I`d like to know how to get the Sharepoint support for Alfresco to work.

I`ve downloaded 'Alfresco-Labs-'3c-Mini-Setup.exe' which contains the Sharepoint functionality.
After that, the installation and configuration of Alfresco Labs went fine. I`m able to log on to Alfresco Explorer and Share.

Then, I´ve tried to use the Sharepoint functionality.
I`ve opened a Word document and set the Document Workspace to 'SPP'.
In the 'Location for new workspace' field, I set the value to 'http://10.2.181.79:7070/alfresco' and clicked on 'Create'.
Unfortunately, I received the following error message (translated from german ;-)):

'The action could not be finished. Please ask your web site administrator for further information or try again later.'

Does it really have to be port 7070?
I tried to do this with 8080, sure I had no luck, but the error message wasn`t displayed 😉

This is a log entry directly after the server start (alf_start.bat).

16:50:46,171 INFO  [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]
16:50:57,656 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.DerbyDialect.
16:50:57,656 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Alfresco is using the Apache Derby default database. Please only use this while evaluating Alfresco, it is NOT recommended for production or deployment!
16:51:00,609 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] No changes were made to the schema.
16:51:05,453 INFO  [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: C:\AlfrescoLabs3\alf_data
16:51:05,578 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] Checking for patches to apply …
16:51:05,734 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] No patches were required.
16:51:05,750 INFO  [org.alfresco.repo.module.ModuleServiceImpl] Found 2 module(s).
16:51:06,125 INFO  [org.alfresco.repo.module.ModuleServiceImpl] Starting module 'org.alfresco.module.RecordsManagement' version 1.3.
16:51:06,546 INFO  [org.alfresco.repo.module.ModuleServiceImpl] Starting module 'org.alfresco.module.vti' version 1.0.
16:51:08,437 WARN  [org.alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.
16:51:08,562 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco JVM - v1.6.0_07-b06; maximum heap size 506,313MB
16:51:08,562 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco started (Labs): Current version 3.0.0 (c 1342) schema 1000 - Installed version 3.0.0 (c 1342) schema 1000
16:51:09,546 WARN  [org.alfresco.linkvalidation.LinkValidationServiceImpl] LinkValidationService Update is not running (virtualization server not registered or started)
16:51:24,734 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 21 Web Scripts (+0 failed), 23 URLs
16:51:24,750 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised Presentation Web Script Container (in 111.88629ms)
16:51:25,296 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 134 Web Scripts (+0 failed), 136 URLs
16:51:25,328 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised WebFramework Web Script Container (in 574.9116ms)
16:51:25,406 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
16:51:59,312 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I`ve also double-clicked on 'apply_amps.bat', as I`ve  read in another post that it might be helpful to run this file.

Does anybody know what I am doing wrong?
As there are only a few threads regarding Sharepoint functionality, it doesn`t seem to be that difficult…

Thanks in advance,
moe

[mrogers]

I think you need to install a separate sharepoint vti module on 3c.    You will find details on this forum.

However I think you will be much better off installing 3d / stable instead since there was major rework to the sharepoint implementation.

[moe]

I think you need to install a separate sharepoint vti module on 3c.    You will find details on this forum.

However I think you will be much better off installing 3d / stable instead since there was major rework to the sharepoint implementation.

Where do I get 3d / stable?
Is this the right thing?
http://wiki.alfresco.com/wiki/Labs_3_Final_download_files

I`m a little bit confused as there is no '3d' mentioned.

Best regards,
moe

[moe]

I think you need to install a separate sharepoint vti module on 3c.    You will find details on this forum.

I`ve downloaded 'Alfresco-Labs-3-Stable' and after exceuting the file 'apply-amps.bat', Port 7070 is available.
Unfortunately, the error message which I mentioned above, is still being displayed.

I just want to be sure about the following two things:

1) Do I have to use 'vti-module.amp' from here: http://wiki.alfresco.com/wiki/Labs_3_Final_download_files?
2) Do I have to use the file 'alfresco-labs-word2003-addin-3Stable.zip' from http://wiki.alfresco.com/wiki/Labs_3_Final_download_files?
In the documentation, it is not mentioned whether to an addin or not (at least, it is not mentioned in 'Getting Started with SharePoint Protocol Support.pdf')?

Best regards,
moe

[mikeh]

Yes, you need the vti-module AMP, but not the Office add-in. The add-ins were developed to provide a direct interface from Word, Excel & PowerPoint to Alfresco before Microsoft were made to open up the Sharepoint protocol.

Thanks,
Mike

[moe]

Yes, you need the vti-module AMP, but not the Office add-in. The add-ins were developed to provide a direct interface from Word, Excel & PowerPoint to Alfresco before Microsoft were made to open up the Sharepoint protocol.

Thanks,
Mike

Hello Mike,

thank you for your quick response.
According to you, I need the file 'vti-module.amp'.
This is already contained in 'Alfresco-Labs-3-FINAL', which I`m currently using.
As I mentioned in my first post, I ran the file 'apply_amps.bat'.
That *should* enable the Sharepoint functionality, right?

I found another document http://wiki.alfresco.com/w/images/a/a1/Install_Configure_Alfresco_Labs3Final.pdf.
It is mentioned that you have to copy the files 'custom-vt-properties.sample' and 'custom-vti-context.xml.sample' from 'webapps\alfresco\WEB-INF\classes\alfresco\module\org.alfresco.module.vti\context' to 'webapps\alfresco\WEB-INF\classes\alfresco\extension'.
In this directory, I deleted '.sample' of the file names.

Then, I configured 'custom-vi-properties' (in 'extension') with the following values:

vti.server.port=7070
vti.alfresco.deployment.context=http://10.2.181.79:7070/alfresco
vti.share.shareHostWithPort=http://10.2.181.79:8080‍‍‍‍

Anything wrong with this configuration?

Do I also have to change value(s) in the file 'vi.properties' in 'webapps\alfresco\WEB-INF\classes\alfresco\module\org.alfresco.module.vi\context'?
Actually, I don`t think so.


Best regards,
moe

[mikeh]

They should be more like:

vti.server.port=7070
vti.alfresco.deployment.context=/alfresco
vti.share.shareHostWithPort=http://10.2.181.79:8080‍‍‍

Thanks,
Mike

[moe]

They should be more like:

vti.server.port=7070
vti.alfresco.deployment.context=/alfresco
vti.share.shareHostWithPort=http://10.2.181.79:8080‍‍‍

Thanks,
Mike

Hello Mike,

I`ve applied your suggested change, deleted the 'work'- and 'temp'-directory of Tomcat, restarted the Alfresco server…it just doesn`t want to work 😞
I`m still getting the error message when trying to connect from Word to Alfresco.
In Word, I`m using the URL http://10.2.181.79:7070/alfresco, which doesn`t seem wrong to me.

I had another look on http://wiki.alfresco.com/w/images/a/a1/Install_Configure_Alfresco_Lab3Final.pdf and
especially on the part 'Installing the SharePoint Protcol Support AMP':

4. Install the vti-module.amp file into the alfresco.war file using the Module Management Tool
   (MMT).
    The vti-module.amp file holds the functionality for the SharePoint connector.
    Note: For Tomcat, alternatively, run the apply_amps.bat command, which is in the root Alfresco
    directory, to install the vti-module.amp. This batch file applies all the amps that are located in the
    amps directory.

Well, I did not use 'Module Management Tool', but according to the 'Note' above, it doesn`t seem to be necessary when using Tomcat.

Any suggestions?

Best regards,
moe

[moe]

Hello,

I`ve had a closer look on the Alfresco server`s startup.
There is one entry that caught my attention:

'2009-04-06  08:56:32.921::INFO:    Started SocketConnector@0.0.0.0:7070'

'0.0.0.0:7070' seems wrong to me. I think that it should be more like '127.0.0.1:7070' or '10.2.181.79:7070'.
Am I right with my assumption?
If yes, where do I have to configure the IP?

Best regards,
moe

[moe]

Hello,

I`m still having trouble enabling the Sharepoint functionality.
I followed the steps in 'http://wiki.alfresco.com/w/images/b/b3/Getting_Started_with_SPP_Support_for_Labs_3_Stable.pdf', but didn`t succeed.

If I am getting it right, it should be like this:
After creating a document workspace from within MS-Word with 'http://<servername>:7070/alfresco' and logging with specific user, i.e. 'User A',
a new site should have been created in Alfresco Share for 'User A'.
The name of the site should be equal to the name that was used for the document workspace of Word (in the tutorial above, it would be 'SPP').
That site should finally contain the Word document itself.

What does work:
I can save a Word document (with 'Save as') with URL 'http://<servername>:8080/alfresco'.
After that, I`m able to choose where to store the document in Alfresco.
But I don`t think that this covers the SharePoint-functionality (rather WebDAV) of Alfresco.

Hope that someone may help me with the problem.

Best regards,
moe