online edit not working / small SP conn problem

[asenden]

Hi,

I hope I dont bother you with my question: I am a alfresco newbie and have installed 4.2 CE a few days ago.

Everything works perfecty fine except the "edit online" function of eg. word documents

When I click on "edit online" next to a docx document I thought the word 2010 application on my local PC should open, but nothing happens at all.

I have changed/added the 2 entries in the windows 7 registry about base authentification, I tried to open it IE as well.

I also can not see any errors in alfresco.log

Sharepoint connector also works when I try to save/open document by adding the sharepoint connector URL in the file name field of word 2010. Although folders that contain subfolders or files are empty

Here my 2 questions:

1) why is the "edit online" feature not working (not even word 2010 opens up) ? am I missing anything ?
2) why do folders that I try to open through the sharepoint connector are sometimes empty

Many thank for your help and suggestions in advance
Albrecht

[nagesh_gollapud]

Hi Team,

would any please respond and help on this
Am unable to view the word document of 2013 in Alfresco 5.0 through the LibreOffice.
I have upload the document through the Document library, when am trying to view the document it says below message. Am using windows 7 professional 64 bit operating system.

This document can't be previewed.
Click here to download it.

can anybody please suggest any solution to resolve the issue.
Thank in advance

Regards, Nagesh Gollapudi

[fvincenti]

Hi Nagesh,
you do not specify the dimension of the document which fails to open preview and if, for other documents smaller, preview works.
Anyway, I think your problem is caused by insufficient default memory.
You should check your alfresco-global.properties file and modify it.
Here I send you how I configured my alfresco-global.properties file to solve this issue:

### Inizio modifiche Major release 2.0  ##################################################
content.transformer.PdfBox.TextToPdf.maxSourceSizeKBytes=10240
content.transformer.Pdf2swf.maxSourceSizeKBytes=8192
content.transformer.complex.Text.Pdf2swf.maxSourceSizeKBytes=8192
content.transformer.complex.OpenOffice.Pdf2swf.extensions.doc.swf.maxSourceSizeKBytes=5120
content.transformer.complex.OpenOffice.Pdf2swf.extensions.docx.swf.maxSourceSizeKBytes=5120

### dal sito: https://forums.alfresco.com/forum/installation-upgrades-configuration-integration/configuration/soff...
content.transformer.OpenOffice.extensions.doc.pdf.maxSourceSizeKBytes=10240
content.transformer.OpenOffice.extensions.docx.pdf.maxSourceSizeKBytes=10240
content.transformer.OpenOffice.extensions.xls.pdf.maxSourceSizeKBytes=10240
content.transformer.OpenOffice.extensions.xlsx.pdf.maxSourceSizeKBytes=10240
content.transformer.OpenOffice.extensions.ppt.pdf.maxSourceSizeKBytes=10240
content.transformer.OpenOffice.extensions.pptx.pdf.maxSourceSizeKBytes=10240
content.transformer.OpenOffice.extensions.vsd.pdf.maxSourceSizeKBytes=10240

# Transform to PDF
# ================
content.transformer.OpenOffice.mimeTypeLimits.txt.pdf.maxSourceSizeKBytes=5120
content.transformer.OpenOffice.mimeTypeLimits.doc.pdf.maxSourceSizeKBytes=10240
content.transformer.OpenOffice.mimeTypeLimits.docx.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.docm.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.dotx.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.dotm.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.ppt.pdf.maxSourceSizeKBytes=6144
content.transformer.OpenOffice.mimeTypeLimits.pptx.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.pptm.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.ppsx.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.ppsm.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.potx.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.potm.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.ppam.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.sldx.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.sldm.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.vsd.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.xls.pdf.maxSourceSizeKBytes=10240
content.transformer.OpenOffice.mimeTypeLimits.xlsx.pdf.maxSourceSizeKBytes=1536
content.transformer.OpenOffice.mimeTypeLimits.xltx.pdf.maxSourceSizeKBytes=1536
content.transformer.OpenOffice.mimeTypeLimits.xlsm.pdf.maxSourceSizeKBytes=1536
content.transformer.OpenOffice.mimeTypeLimits.xltm.pdf.maxSourceSizeKBytes=1536
content.transformer.OpenOffice.mimeTypeLimits.xlam.pdf.maxSourceSizeKBytes=1536
content.transformer.OpenOffice.mimeTypeLimits.xlsb.pdf.maxSourceSizeKBytes=1536

# Transform to SWF
# ================
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.txt.swf.maxSourceSizeKBytes=5120
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.doc.swf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.docx.swf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.docm.swf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.dotx.swf.maxSourceSizeKBytes=256
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.dotm.swf.maxSourceSizeKBytes=256
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.ppt.swf.maxSourceSizeKBytes=6144
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.pptx.swf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.pptm.swf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.ppsx.swf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.ppsm.swf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.potx.swf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.potm.swf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.ppam.swf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.sldx.swf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.sldm.swf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.vsd.swf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.xls.swf.maxSourceSizeKBytes=1024
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.xlsx.swf.maxSourceSizeKBytes=1024
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.xltx.swf.maxSourceSizeKBytes=1024
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.xlsm.swf.maxSourceSizeKBytes=1024
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.xltm.swf.maxSourceSizeKBytes=1024
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.xlam.swf.maxSourceSizeKBytes=1024
content.transformer.OpenOffice.Pdf2swf.mimeTypeLimits.xlsb.swf.maxSourceSizeKBytes=1024

# OpenOffice transforms to TXT
# ============================
content.transformer.OpenOffice.PdfBox.mimeTypeLimits.xlsb.txt.maxSourceSizeKBytes=1024
content.transformer.OpenOffice.PdfBox.mimeTypeLimits.potm.txt.maxSourceSizeKBytes=1024
### Fine modifiche Major release 2.0    ##################################################

After these modifies you have to restart Alfresco.

Greetings
Frank

[nagesh_gollapud]

Hi Frank, Whoo..!! Whoo..!!

Many Many Thanks..!! Preview is working now in Alfresco 5.0

I have done the changes what you have mentioned it is working fine now
I need one more favour when am try to modify the word document content which I have uploaded through the Document library in Alfresco 5.0  when I click on Edit Online option it says the below message

Could not start MS Office

I have followed some forums which is mentioned in the Alfresco community but it didn't worked for me.

Am using Windows 7 Professional Operating System, with 64 bit Processor

Would you please help me on this, awaiting for your reply

Thanks in advance

Regards, Nagesh Gollapudi

[fvincenti]

Hi Nagesh
I am glad my suggestions worked and helped you!
About your issue with edit online, I have had the same identical one, which I solved according the solution I posted in this forum at the following URL:
http://forums.alfresco.com/forum/installation-upgrades-configuration-integration/configuration/Alfre... problems with SharePoint interface.

Look at this and let me know if it worked for you too and if you solved the issue with "Save as" functionality.

Greetings
Frank

[nagesh_gollapud]

Hi Frank,

Once again a big thank you for helping in all the means..!!

I have applied you suggestions below I have copied changes in alfresco-global.properties file

vti.server.port=7070
vti.alfresco.alfresoHostWithPort=http://127.0.0.1:8080
vti.share.shareHostWithPort=http://127.0.0.1:8080
vti.share.deployment.context=/share
vti.server.external.host=127.0.0.1
vti.server.external.port=7070
vti.alfresco.deployment.context=/alfresco
vti.server.external.contextPath=/alfresco

I can resolve the error Could not start MS Office message when I click on Edit online in Alfresco 5.0.c , it is trying to open the word document and I get this below message

Access to the webserver is disabled by the default because it is controlled by basic authentication and does not use SSL.Do you want to search the microsoft online support centre to view possible solutions. I can see same message in IE and Mozilla as well.

I have followed some suggestions which is given by linuxyeti in the below link but I couldn't successed.

https://forums.alfresco.com/forum/installation-upgrades-configuration-integration/installation-upgra...

As per his suggestions I have added the below content and modify the password accordingly and created the xml file in D:\Alfresco\tomcat\shared\classes\alfresco\extension

vti.server.port=7070
vti.server.protocol=https
vti.server.ssl.keystore=/appserver/alfresco-5.0.c/alf_data/keystore/ssl.keystore
vti.server.ssl.password=mp6yc0UD9e
vti.server.url.path.prefix=/alfresco
vti.server.external.host=127.0.0.1
vti.server.external.port=7070
vti.server.external.protocol=https
vti.server.external.contextPath=/alfresco

I can see the below details once I click on Edit online in both IE and Mozilla

Downloading https://127.0.0.1:7070/alfresco/nagtest/documentlibrary/..(0%)

I can see the pop from the Windows Security, Connect to 127.0.0.1 it asking Username and password I have tried giving both Alfresco credentials, system credentials it was not accepting it.

could not open https://127.0.0.1:7070/alfresco/nagtest/documentlibrary/XYZ.doc

would you please give me any other suggestions to resolve the issue
Am using Microsoft office 2010 with Windows 7 Operating system with 64 bit processor
Awaiting for your reply
Thanks in advance..

Regards, Nagesh Gollapudi

[fvincenti]

Hi Nagesh,
did you modify your MS Windows registry configuration?
I remind you that you have to modify/insert the following registry keys:
-   HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\WebClient\Parameters\BasicAuthLevel (type REG_DWORD)
-   HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Common\Internet\BasicAuthLevel (type REG_DWORD)
Both keys have to have the value 2.
Regarding the file .xml you have created under …\shared\classes\alfresco\extension in my case it wasn't necessary.
If your registry keys weren't already modified when you got the error, I suggest you to make test with your initial configuration, without the new .xml file you have created.

Regards
Frank

[nagesh_gollapud]

Hi Frank,

Apologies for the late response

Thanks once again..I have applied what you have said it is resolved now.
But is there any change without changing the Windows Registry will that work because
am giving an example suppose I want to use this application with in the organisation for sharing the documents and editing the documents which can be used by the team members, it would be tedious and a tough job for editing Registry key for each team members system..

Is there any other solution with out changing the registry values, can you please suggest any other solution..

Thank you

[fvincenti]

Hi Nagesh
the changes you made to your MS Windows client registry keys have the aim to enable both authentication SSL and OTHER methods. If you do not want to make these changes I think you should configure your Alfresco to authenticate using SSL method, but I never tryed this way and I do not know how help you.

Regards
Frank