Best Alfresco + LibreOffice DMS
4.5 (2 ratings)
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.
49 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Best Alfresco + LibreOffice DMS to your Wishlist.

Add to Wishlist

Best Alfresco + LibreOffice DMS

Open and Centralized Document Management System with Alfresco and LibreOffice, since document creation until expiration.
4.5 (2 ratings)
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.
49 students enrolled
Last updated 4/2017
English
Current price: $10 Original price: $40 Discount: 75% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 19 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Basic Linux
  • Text Editing
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.

Who is the target audience?
  • Systems Administrators
  • DevOps
  • System Operators
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 30 Lectures Collapse All 30 Lectures 02:06:48
+
Theoretical Part
3 Lectures 17:09

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

Preview 05:22


Architeture
05:38
+
Installation
4 Lectures 11:52

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

Download Installation Package
03:09

Run Installation
03:32

apt-get install swftools

Dependency
01:29

First access and Services Restart
03:42
+
Postgresql Tuning
2 Lectures 05: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

alfresco-global.properties
03:10

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

Uncomment:

postgresql synchronous_commit = on

postgresql.conf
02:00
+
Initial Configuration
2 Lectures 08:18

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

Email Sending
04:24

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

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

LDAP Authentication
03:54
+
LibreOffice Integration
5 Lectures 18:46

[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

Addon Deploy
03:03

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

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

Workstation Settings
04:08

Testing Online Edition
03:28

Deploying Documents Templates
04:35

Digital Document Sigining
03:32
+
Document Workflow
3 Lectures 15:35

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

Default Workflows
05:33

Folder Rules
05:31

Folder Rules Simple Workflow
04:31
+
AMPS Extensions Handling
1 Lecture 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

list, uninstall, install
05:14
+
Records Management
3 Lectures 14:37

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

Custom Metadata Introduction and Installation
05:09

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

Creating RM Site
05:05

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.

Creating Metadata and File Plan Management
04:23
+
Custom Appearance
5 Lectures 24:08

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

...

Create a new Theme
09:28

# 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

Custom Login Screen
04:17

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

Packing Theme for Later Deploy
01:56

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”);

Change Landing Page
03:46

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>

Remove Unnecessary Documents Creation
04:41
+
Alfresco Backup
1 Lecture 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.

Alfresco Backup with Bacula Configuration Sample
04:05
1 More Section
About the Instructor
Heitor Medrado De Faria
4.3 Average rating
281 Reviews
1,047 Students
10 Courses
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.