Best Alfresco + LibreOffice DMS

Open and Centralized Document Management System with Alfresco and LibreOffice, since document creation until expiration.
5.0 (1 rating) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
21 students enrolled
$40
Take This Course
  • Lectures 30
  • Contents Video: 2 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2015 English

Course Description

Based on 5.0 Alfresco:

Alfresco is the wold most popular Electronic Document Management Software. Do not miss an opportunity to stand out automating your company document process, improving productivity, document resilience and reducing costs. How many documents in your company are lost in email attachments? The LibreOffice or other document suit integration grants a extreme boost will make your work much more efficient. As a bonus, eliminate the need for paper printing as environmental benefit. Based on Alfresco Community version.

Get introduced to the best document management practices.

  • Alfresco Deploy
  • Office Suite Integration
  • Templates Deploy
  • Document Workflow
A Powerful Skill at Your Fingertips

Companies can't stand anymore document email attachments workflow, where the files are lost when the workmates leave the corporation and there is no control over it.

What are the requirements?

  • Basic Linux
  • Text Editing

What am I going to get from this course?

  • Understand Electronic Document Management Concepts
  • Know Alfresco Architeture
  • Implement Alfresco
  • Tune Alfresco
  • Custom appearence
  • Set online Libreoffice or other office integration
  • Enable Document Digital Signing

What is the target audience?

  • Systems Administrators
  • DevOps
  • System Operators

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Theoretical Part
05:22

Be my friend at Facebook: https://www.facebook.com/heitor.faria

Remark 1: If you need professional help with Bacula or Alfresco I'm looking for a permanent job in USA or Europe. Please recommend me. =)

Remark 2: If you need in-company Bacula and Alfresco training or implementation worldwide send a email to heitor@bacula.com.br

Other contacts:

  • email: heitor@bacula.com.br
  • Gtalk: heitorfaria@gmail.com
  • Skype: neocodeheitor

My Alfresco Site: http://www.openalfresco.com/

Mailing list: https://groups.google.com/forum/?hl=pt-BR#!forum/alfresco-livre

Glossary
Preview
06:09
Architeture
05:38
Section 2: Installation
03:09

If you can't download here access: https://wiki.alfresco.com/wiki/Community_file_list_5.0.d

Run Installation
03:32
01:29

apt-get install swftools

First access and Services Restart
03:42
Section 3: Postgresql Tuning
03:10

vi /opt/alfresco-5.0.d/tomcat/shared/classes/alfresco-global.properties

Change value:

db.pool.validate.query=SELECT VERSION()

Add this line:

hibernate.jdbc.fech_size=150

02:00

vi /opt/alfresco-5.0.d/alf_data/postgresql/postgresql.conf

Uncomment:

postgresql synchronous_commit = on

Section 4: Initial Configuration
04:24

vi /opt/alfresco-5.0.d/tomcat/shared/classes/alfresco-global.properties

Add lines:

# Outbound SMTP properties

# use these properties to configure the out-bound SMTP server.

mail.host=mail.bacula.com.br

mail.port=587

mail.username=heitor@bacula.com.br

mail.password=password

mail.encoding=UTF-8

mail.from.default=heitor@bacula.com.br

mail.protocol=smtp

# Additional Java Mail properties for SMTP protocol

mail.smtp.auth=true

mail.smtp.debug=true

mail.smtp.timeout=30000

mail.smtp.starttls.enable=true

# Additional Java Mail properties for SMTPS protocol

mail.smtps.auth=true

mail.smtps.starttls.enable=true

# test mail

mail.testmessage.send=true

mail.testmessage.to=heitor@bacula.com.br

mail.testmessage.subject=Outbound SMTP

mail.testmessage.text=The Outbound SMTP email subsystem is working.

# debug

log4j.logger.org.alfresco.web.bean.TemplateMailHelperBean=debug

==============================================================

More information: http://wiki.alfresco.com/wiki/Outbound_E-mail_Configuration

03:54

MORE INFORMATION ON THIS TOPIC: http://www.ochounos.com/blog/6

Instructions:

vi /opt/alfresco-5.0.d/tomcat/shared/classes/alfresco-global.properties


Add lines:

====================================================

######################### LDAP

synchronization.import.cron=0 0 * * * ?

#

# The default authentication chain

# To configure external authentication subsystems see:

# http://wiki.alfresco.com/wiki/Alfresco_Authentication_Subsystems

#-------------

#authentication.chain=alfrescoNtlm1:alfrescoNtlm

authentication.chain=alfrescoNtlm1:alfrescoNtlm,ldap1:ldap

ldap.authentication.active=true

ldap.authentication.allowGuestLogin=true

ldap.authentication.userNameFormat=

ldap.authentication.java.naming.factory.initial=com.sun.jndi.ldap.LdapCtxFactory

ldap.authentication.java.naming.provider.url=ldap://endereço:389

ldap.authentication.java.naming.security.authentication=simple

ldap.authentication.escapeCommasInBind=false

ldap.authentication.escapeCommasInUid=false

ldap.authentication.defaultAdministratorUserNames=

ldap.synchronization.active=true

ldap.synchronization.java.naming.security.authentication=simple

ldap.synchronization.java.naming.security.principal=uid=x,ou=y,dc=z,dc=w

ldap.synchronization.java.naming.security.credentials=user@domínio

ldap.synchronization.queryBatchSize=0

ldap.synchronization.attributeBatchSize=0

ldap.synchronization.groupQuery=(objectclass=groupofuniquenames)

ldap.synchronization.groupDifferentialQuery=(objectclass=groupofuniquenames)

ldap.synchronization.personQuery=(&(objectclass=inetorgperson)(objectclass=x)(!(ou:dn:=corp))(!(ou:dn:=Servico)))

ldap.synchronization.personDifferentialQuery=(&(objectclass=inetOrgPerson)(!(modifyTimestamp<={0})))

ldap.synchronization.groupSearchBase=ou=7720CORP,ou=ecm,ou=corp,dc=x,dc=y,dc=z

ldap.synchronization.userSearchBase=dc=x,dc=y,dc=z

ldap.synchronization.modifyTimestampAttributeName=modifyTimestamp

ldap.synchronization.timestampFormat=yyyyMMddHHmmss'Z'

ldap.synchronization.userIdAttributeName=uid

ldap.synchronization.userFirstNameAttributeName=givenName

ldap.synchronization.userLastNameAttributeName=sn

ldap.synchronization.userEmailAttributeName=mail

ldap.synchronization.userOrganizationalIdAttributeName=ou

ldap.synchronization.defaultHomeFolderProvider=zHomeFolderProvider

ldap.synchronization.groupIdAttributeName=cn

ldap.synchronization.groupDisplayNameAttributeName=cn

ldap.synchronization.groupType=groupofuniquenames

ldap.synchronization.personType=inetOrgPerson

ldap.synchronization.groupMemberAttributeName=uniqueMember

ldap.synchronization.enableProgressEstimation=true

home.folder.creation.eager=false

home.folder.creation.disabled=true

====================================================

Section 5: LibreOffice Integration
03:03

[Project site: https://code.google.com/p/alfresco-share-online-edition-addon/]

/opt/alfresco-5.0.d/alfresco.sh stop

cd ./tomcat/shared/lib

wget https://alfresco-share-online-edition-addon.googlecode.com/files/zk-online-edition-0.2.jar

/opt/alfresco-5.0.d/alfresco.sh start

04:08

=====================================================

LINUX DESKTOPS

vi /usr/share/applications/libreoffice-alf.desktop


Add the following:

================================

[Desktop Entry]

Encoding=UTF-8

Version=1.0

Name=LibreOffice for Alfresco

GenericName=LibreOffice for Alfresco

Comment=Online Editing in Alfresco via webdav

Icon=libreoffice-writer

TryExec=libreoffice

Exec=libreoffice %U

Terminal=false

Type=Application

Categories=Office;

MimeType=x-scheme-handler/davs;x-scheme-handler/dav

===============================

vi /usr/share/applications/mimeinfo.cache


Add those lines:

x-scheme-handler/davs=libreoffice-alf.desktop;

x-scheme-handler/dav=libreoffice-alf.desktop;

=====================================================

WINDOWS DESKTOPS

Create and run a .reg file (or download it from: https://code.google.com/p/alfresco-share-online-edition-addon/downloads/list).

===========================================================

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\davs]

@="URL:loffice Protocol"

"URL Protocol"=""

[HKEY_CLASSES_ROOT\davs\DefaultIcon]

@="soffice.exe,1"

[HKEY_CLASSES_ROOT\davs\shell]

[HKEY_CLASSES_ROOT\davs\shell\open]

[HKEY_CLASSES_ROOT\davs\shell\open\command]

@="\"C:\\Program Files\\OpenOffice.org 3\\program\\soffice.exe\" \"%1\""

[HKEY_CLASSES_ROOT\dav]

@=”URL:loffice Protocol”

“URL Protocol”=””

[HKEY_CLASSES_ROOT\dav\DefaultIcon]

@=”soffice.exe,1″

[HKEY_CLASSES_ROOT\dav\shell]

[HKEY_CLASSES_ROOT\dav\shell\open]

[HKEY_CLASSES_ROOT\dav\shell\open\command]

@=”\”C:\\Program Files\\OpenOffice.org 3\\program\\soffice.exe\” \”%1\””

================================================

May be needed: Software Update for Web Folders (KB907306) (for Win XP, Win Vista and Win 7):

http://www.microsoft.com/es-es/download/details.aspx?id=15123


Allow webdav autho for Windows 7:

=====================================================

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Webclient\Parameters\BasicAuthLevel --> Type: DWORD Value: 2

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Common\Internet\BasicAuthLevel --> DWORD y Valor: 2

MS Office 20XX setup (in Windows registry)

===================================================

http://support.microsoft.com/kb/870853

Testing Online Edition
03:28
Deploying Documents Templates
04:35
Digital Document Sigining
03:32
Section 6: Document Workflow
05:33

Hint: you can use the approval & review workflows not only for this purpose, but also to documents signing, ask user to add content etc.

Folder Rules
05:31
Folder Rules Simple Workflow
04:31
Section 7: AMPS Extensions Handling
05:14

Commands example:

java -jar bin/alfresco-mmt.jar list ./tomcat/webapps/share.war

java -jar bin/alfresco-mmt.jar uninstall org.alfresco.integrations.share.google.docs ./tomcat/webapps/share.war

java -jar bin/alfresco-mmt.jar install ./amps_share/alfresco-googledocs-share-3.0.0.amp ./tomcat/webapps/share.war

Section 8: Records Management
05:09

I end up with problems using the RM (a) version. Please use the most recent, in this case (c). Download site: https://wiki.alfresco.com/wiki/Community_file_list_5.0.d

================================================================================

RM Installation:

cd /opt/alfresco-5.0.d

wget http://dl.alfresco.com/release/community/5.0.d-build-00002/alfresco-rm-2.3.c.zip

unzip alfresco-rm-2.3.c.zip

cp alfresco-rm-share-2.3.c.amp amps_share

cp alfresco-rm-server-2.3.c.amp amps

java -jar bin/alfresco-mmt.jar install ./amps_share/alfresco-rm-share-2.3.c.amp ./tomcat/webapps/share.war -force

java -jar bin/alfresco-mmt.jar install ./amps/alfresco-rm-server-2.3.c.amp ./tomcat/webapps/alfresco.war -force

./alfresco.sh restart

05:05

More information: http://docs.alfresco.com/4.1/tasks/rm-add-dashlet.html

04:23

More information: http://docs.alfresco.com/4.1/tasks/rm-custmeta-create.html

Tip: according to documentation you can creating a selection list if selecting text metadata.

Section 9: Custom Appearance
09:28

Source: http://fcorti.com/2012/12/31/alfresco-share-custom-theme/

cd /opt/alfresco-5.0.d/tomcat/webapps/share/themes

cp -R greenTheme customTheme

cd /opt/alfresco-5.0.d/tomcat/webapps/share/WEB-INF/classes/alfresco/site-data/themes/

cp default.xml customTheme.xml

vi customTheme.xml

Replace content:

<?xml version='1.0' encoding='UTF-8'?>

<theme>

<title>Custom Theme</title>

<title-id>theme.customTheme</title-id>

</theme>

Procede:

cd /opt/alfresco-5.0.d/tomcat/webapps/share/themes/customTheme

sed -i s/.yui-skin-greenTheme/.yui-skin-customTheme/g ./presentation.css

sed -i s/.yui-skin-greenTheme/.yui-skin-customTheme/g ./yui/assets/skin.css

You may also want to change colors for the .css theme.

I personally like to put all borders to none (from 1 px to 0 px), to make dasboard cleaner.

You may want also to change dashlet menu images with another colors:

cd /opt/alfresco/tomcat/webapps/share/themes/customTheme

cp ../default/images/dashlet-title-bg.png images/dashlet-title-bg.png

cp ../default/images/title-button-bg.png images/title-button-bg.png

But let's finish the new theme configuration:

vi /opt/alfresco-5.0.d/tomcat/webapps/share/WEB-INF/classes/alfresco/messages/slingshot.properties

Add the following line toguether with other themes:

...

## Themes

theme.customTheme=Custom Theme

...

Do the same for the slingshot.properties of your language. E.g.:

vi /opt/alfresco-5.0.d/tomcat/webapps/share/WEB-INF/classes/alfresco/messages/slingshot_pt_BR.properties

...

## Themes

theme.customTheme=Custom Theme

...

04:17

# Login Page Logo

Format: PNG

Size: 200×58 pixels.

Background: transparent.

cp your_logo.png /opt/alfresco-5.0.d/tomcat/webapps/share/themes/customTheme/images/logo.png

*You need to replace customTheme for the theme path you acctually use.

# Background

Format: JPG

Size: 1920×1100 pixels.

cp image.jpg /opt/alfresco-5.0.d/tomcat/webapps/share/components/images/login-bg.jpg

vi /opt/alfresco-5.0.d/tomcat/webapps/share/components/guest/login.css

Add the following:

body {

background: url(../images/login-bg.jpg) no-repeat center center fixed;

-webkit-background-size: cover;

-moz-background-size:: cover;

-o-background-size:: cover;

background-size:: cover;

}

You may also in the same file want to change the login button color.

/opt/alfresco-5.0.d/alfresco.sh restart

01:56

Important! You must create pack your theme because some Alfreco amp extensions installation or removal may delete some of those files.

========================================================

Pack your theme:

cd /opt/alfresco-5.0.d/

tar zcvf customTheme.tgz tomcat/webapps/share/WEB-INF/classes/alfresco/messages/slingshot.properties tomcat/webapps/share/WEB-INF/classes/alfresco/messages/slingshot_pt_BR.properties tomcat/webapps/share/WEB-INF/classes/alfresco/site-data/themes/customTheme.xml tomcat/webapps/share/themes/customTheme /tomcat/webapps/share/components/images/login-bg.jpg ./tomcat/webapps/share/components/guest/login.css

Deploy custom theme on other installations:

Copy 'customTheme.tgz' to /opt/alfresco-5.0.d/

alfresco.sh stop

tar zxvf customTheme.tgz

alfresco.sh start

03:46

vi /opt/alfresco-5.0.d/tomcat/webapps/share/site-index.jsp

Change lines:

response.sendRedirect(request.getContextPath() + “/page/site/TestSiteExample1/documentlibrary”);

response.sendRedirect(request.getContextPath() + “/page/site/” + URLEncoder.encode(siteName) + “/dashboard”);

04:41

vi ./tomcat/webapps/share/WEB-INF/classes/alfresco/share-documentlibrary-config.xml

E.g.: delete the bold lines:

<create-content>

<content id="plain-text" label="create-content.text" type="pagelink" index="10" icon="text">

<param name="page">create-content?destination={nodeRef}&amp;itemId=cm:content&amp;mimeType=text/plain</param>

</content>

<content id="html" label="create-content.html" type="pagelink" index="20">

<param name="page">create-content?destination={nodeRef}&amp;itemId=cm:content&amp;mimeType=text/html</param>

</content>

<content id="xml" label="create-content.xml" type="pagelink" index="30">

<param name="page">create-content?destination={nodeRef}&amp;itemId=cm:content&amp;mimeType=text/xml</param>

</content>

<content id="folder" label="create-content.folder" icon="folder" index="5" type="javascript">

<param name="function">onNewFolder</param>

</content>

</create-content>

Section 10: Alfresco Backup
04:05

Backup Alfresco with Bacula

Edit pg_hba.conf to allow trust local authentication - dump purposes.

vi /opt/alfresco-5.0.d/alf_data/postgresql/pg_hba.conf

E.g.:

local all postgres trust

local all all trust

host all all ::1/128 trust

Restart Alfresco to apply changes:

/opt/alfresco-5.0.d/alfresco.sh restart

Create script that will backup Alfresco database:

touch /etc/bacula/dump_pgsql.sh

Give execution permission:

chmod o+rx /etc/bacula/dump_pgsql.sh

Insert on the script this backup command:

#!/bin/bash

/opt/alfresco-5.0.d/postgresql/bin/pg_dump alfresco > /var/alfresco.sql

Configure bacula to run script before job and the following fileset:

Job {

Name = "BackupAlfresco"

JobDefs = "DefaultJob"

FileSet = alfresco

Client = alfresco-fd

ClientRunBeforeJob = /etc/bacula/dump_pgsql.sh

}

FileSet {

Name = "alfresco"

Include {

Options {

signature = MD5

}

File = /opt/alfresco-5.0.d

File = /var/alfresco.sql

}

Exclude {

File = /opt/alfresco-5.0.d/alf_data/postgresql/base # we are already copying database dump.

}

}

Test backup and restore.

Section 11: The End
See you soon!
01:54

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Heitor Medrado De Faria, Bacula Backup Software Book Author and Teacher

"Bacula: Open Source Backup Tool" and "Open Licenses & Fundamental Rights" books author (both in portuguese). Bacula Training instructor at Udemy. Law Graduated. IT Service Manager and Project Management extension degrees. Works on a brazilian governmental company called SERPRO and for Neocode Software (Canada). Bacula brazilian community founder. Has plenty of experience as a server / backup systems administrator (Windows, Linux, Netware, directory services) and as IT / Project manager. ITIL-F, TOEIC (Golden Certificate) and LPIC-III certificated professional.

Ready to start learning?
Take This Course