nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

export users from Alfresco??urgent

sumit057

is it possible to export the system users (created users) in Alfresco to export?

Find more posts tagged with

Comments

derek

Hi,
A full repository export will export the users store. You can export that store using the APIs as well.
Regards
Derek

sumit057

but how can i do full repository export.i am using Alfresco version 3.2?

sumit057

I guess anyone here doesn't know anything about it..

norgan

How to do a complete backup/restore is described in the wiki under backup / migration / upgrade.

Norgan

sumit057

can you please provide me the link of the wiki which u are mentioning

norgan

As a wellknow line from an US politician goes : "read my lips … " … or in this case .. my footer

or here…

serverok

Hi All,

Can you help me with the same issue but in the "Community Edition" - this version do not contain Export/Import tools (org.alfresco.tools.Export, org.alfresco.tools.Import). So how to export all system users from Alf 2.9b (or 3.0) and Import them into Alf 3.2 (both are "Community Edition")?

Big thanks.

mathias_lin

I found that the wiki is incomplete / not up to date.

Here's how I run the export for users and user groups on v3.2rc2:

user groups:
===========
java -classpath classes/alfresco/module;../../../shared/classes;classes;lib/acegi-security-0.8.2_patched.jar;lib/activation.jar;lib/addressing-1.0.jar;lib/alfresco-core-3.2r2.jar;lib/alfresco-deployment-3.2r2.jar;lib/alfresco-linkvalidation.jar;lib/alfresco-mbeans-3.2r2.jar;lib/alfresco-remote-api-3.2r2.jar;lib/alfresco-repository-3.2r2.jar;lib/alfresco-web-client-3.2r2.jar;lib/ant.jar;lib/antlr-2.7.5H3.jar;lib/aopalliance.jar;lib/avalon-framework-4.2.0.jar;lib/bcel.jar;lib/bcprov-jdk15-137.jar;lib/bsf-2.4.0.jar;lib/bsh-1.3.0.jar;../../../lib/catalina.jar;lib/cglib-nodep-2.2_beta1.jar;lib/chiba-1.3.0-patched.jar;lib/commons-beanutils-1.7.0.jar;lib/commons-codec-1.3.jar;lib/commons-collections-3.1.jar;lib/commons-dbcp-1.2.2.jar;lib/commons-digester-1.6.jar;lib/commons-discovery-0.2.jar;lib/commons-el.jar;lib/commons-fileupload-1.1.1.jar;lib/commons-httpclient-3.1.jar;lib/commons-io-1.1.jar;lib/commons-jxpath-1.2.jar;lib/commons-lang-2.1.jar;lib/commons-logging-1.1.jar;lib/commons-modeler.jar;lib/commons-pool-1.4.jar;lib/commons-validator.jar;lib/cpool.jar;../../../lib/cryptix-jce-provider.jar;lib/dom4j-1.6.1.jar;lib/ehcache-1.4.1-patched.jar;lib/fontbox-0.8.0-incubating.jar;lib/fop-0.94.jar;lib/freemarker-2.3.13.jar;lib/guessencoding-1.0.jar;lib/hibernate-3.2.6-patched.jar;lib/hrtlib.jar;lib/hsqldb.jar;lib/htmlparser-1.6.jar;lib/icu4j_3_6_1.jar;lib/jakarta-oro-2.0.8.jar;lib/jaxen-1.1-beta-8.jar;lib/jaxrpc.jar;lib/jbpm-identity-3.3.1.jar;lib/jbpm-jpdl-3.3.1.jar;lib/jcr-1.0.jar;lib/jgroups-2.8.0-b2.jar;lib/jibx-bind.jar;lib/jibx-run.jar;lib/jid3lib-0.5.jar;lib/JMagick.jar;lib/joda-time-1.2.1.jar;lib/jooconverter-2.1.0.jar;lib/json.jar;lib/jstl-1.1.0.jar;lib/jta.jar;lib/jug-lgpl-2.0.0.jar;lib/jut.jar;lib/log4j-1.2.15.jar;lib/lucene-analyzers-2.4.1.jar;lib/lucene-core-2.4.1.jar;lib/lucene-snowball-2.4.1.jar;lib/mail.jar;lib/myfaces-api-1.1.5.jar;lib/myfaces-impl-1.1.5.jar;lib/naming-factory.jar;lib/naming-resources.jar;lib/odf_utils.jar;lib/odmg-3.0.jar;lib/openoffice-juh-2.0.3.jar;lib/openoffice-jurt-2.0.3.jar;lib/openoffice-ridl-2.0.3.jar;lib/openoffice-sandbox-2.0.3.jar;lib/openoffice-unoil-2.0.3.jar;lib/opensaml-1.0.1.jar;lib/pdfbox-0.8.0-incubating.jar;lib/poi-3.5-FINAL-20090928.jar;lib/portlet-api-lib.jar;lib/quartz-1.6.0.jar;lib/resolver.jar;lib/rhino-js-1.6R7.jar;lib/saaj.jar;lib/saxpath.jar;lib/spring-2.0.8.jar;lib/springmodules-jbpm31.jar;lib/standard.jar;../../../lib/tlc124.jar;lib/tm-extractors-1.0-patched.jar;../../../lib/tomcat-coyote.jar;../../../lib/tomcat-util.jar;lib/truezip.jar;../../../lib/truelicense-1_29.jar;../../../lib/truexml-1_29-patched.jar;lib/wsdl4j-1.6.2.jar;lib/wss4j.jar;lib/xercesImpl-2.8.0.jar;lib/xml-apis.jar;lib/xmlgraphics-commons-1.2.jar;lib/xmlsec-1.4.1.jar;lib/xpp3-1.1.3_8.jar;lib/xstream-1.2.2.jar;../../../lib/mysql-connector-java-5.1.7-bin.jar;../../../endorsed/serializer.jar;../../../endorsed/xalan.jar;lib/axis-1.4.jar;../../../lib/servlet-api.jar;lib/ibatis-2.3.4.726-patched.jar;../../share/WEB-INF/lib/alfresco-jlan-embed-3.2r2.jar;lib/subetha-smtp.jar;lib/xmlrpc.jar;lib/jsr107cache-1.0.jar;lib/alfresco-webscript-framework-3.2r2.jar;lib/abdera-client-0.4.0-incubating.jar;lib/abdera-core-0.4.0-incubating.jar;lib/abdera-extensions-json-0.4.0-incubating.jar;lib/abdera-i18n-0.4.0-incubating.jar;lib/abdera-parser-0.4.0-incubating.jar;lib/axiom-api-1.2.5.jar;lib/axiom-impl-1.2.5.jar;lib/greenmail-1.3-patched.jar;lib/alfresco-vti-3.2r2.jar;lib/jetty-util-6.1.14.jar;lib/jetty-6.1.14.jar org.alfresco.tools.Export -user admin -pwd admin -s workspace://SpacesStore -path /sys:system/sys:authorities -verbose -overwrite spacesStore-authorities

users:
===========
java -classpath classes/alfresco/module;../../../shared/classes;classes;lib/acegi-security-0.8.2_patched.jar;lib/activation.jar;lib/addressing-1.0.jar;lib/alfresco-core-3.2r2.jar;lib/alfresco-deployment-3.2r2.jar;lib/alfresco-linkvalidation.jar;lib/alfresco-mbeans-3.2r2.jar;lib/alfresco-remote-api-3.2r2.jar;lib/alfresco-repository-3.2r2.jar;lib/alfresco-web-client-3.2r2.jar;lib/ant.jar;lib/antlr-2.7.5H3.jar;lib/aopalliance.jar;lib/avalon-framework-4.2.0.jar;lib/bcel.jar;lib/bcprov-jdk15-137.jar;lib/bsf-2.4.0.jar;lib/bsh-1.3.0.jar;../../../lib/catalina.jar;lib/cglib-nodep-2.2_beta1.jar;lib/chiba-1.3.0-patched.jar;lib/commons-beanutils-1.7.0.jar;lib/commons-codec-1.3.jar;lib/commons-collections-3.1.jar;lib/commons-dbcp-1.2.2.jar;lib/commons-digester-1.6.jar;lib/commons-discovery-0.2.jar;lib/commons-el.jar;lib/commons-fileupload-1.1.1.jar;lib/commons-httpclient-3.1.jar;lib/commons-io-1.1.jar;lib/commons-jxpath-1.2.jar;lib/commons-lang-2.1.jar;lib/commons-logging-1.1.jar;lib/commons-modeler.jar;lib/commons-pool-1.4.jar;lib/commons-validator.jar;lib/cpool.jar;../../../lib/cryptix-jce-provider.jar;lib/dom4j-1.6.1.jar;lib/ehcache-1.4.1-patched.jar;lib/fontbox-0.8.0-incubating.jar;lib/fop-0.94.jar;lib/freemarker-2.3.13.jar;lib/guessencoding-1.0.jar;lib/hibernate-3.2.6-patched.jar;lib/hrtlib.jar;lib/hsqldb.jar;lib/htmlparser-1.6.jar;lib/icu4j_3_6_1.jar;lib/jakarta-oro-2.0.8.jar;lib/jaxen-1.1-beta-8.jar;lib/jaxrpc.jar;lib/jbpm-identity-3.3.1.jar;lib/jbpm-jpdl-3.3.1.jar;lib/jcr-1.0.jar;lib/jgroups-2.8.0-b2.jar;lib/jibx-bind.jar;lib/jibx-run.jar;lib/jid3lib-0.5.jar;lib/JMagick.jar;lib/joda-time-1.2.1.jar;lib/jooconverter-2.1.0.jar;lib/json.jar;lib/jstl-1.1.0.jar;lib/jta.jar;lib/jug-lgpl-2.0.0.jar;lib/jut.jar;lib/log4j-1.2.15.jar;lib/lucene-analyzers-2.4.1.jar;lib/lucene-core-2.4.1.jar;lib/lucene-snowball-2.4.1.jar;lib/mail.jar;lib/myfaces-api-1.1.5.jar;lib/myfaces-impl-1.1.5.jar;lib/naming-factory.jar;lib/naming-resources.jar;lib/odf_utils.jar;lib/odmg-3.0.jar;lib/openoffice-juh-2.0.3.jar;lib/openoffice-jurt-2.0.3.jar;lib/openoffice-ridl-2.0.3.jar;lib/openoffice-sandbox-2.0.3.jar;lib/openoffice-unoil-2.0.3.jar;lib/opensaml-1.0.1.jar;lib/pdfbox-0.8.0-incubating.jar;lib/poi-3.5-FINAL-20090928.jar;lib/portlet-api-lib.jar;lib/quartz-1.6.0.jar;lib/resolver.jar;lib/rhino-js-1.6R7.jar;lib/saaj.jar;lib/saxpath.jar;lib/spring-2.0.8.jar;lib/springmodules-jbpm31.jar;lib/standard.jar;../../../lib/tlc124.jar;lib/tm-extractors-1.0-patched.jar;../../../lib/tomcat-coyote.jar;../../../lib/tomcat-util.jar;lib/truezip.jar;../../../lib/truelicense-1_29.jar;../../../lib/truexml-1_29-patched.jar;lib/wsdl4j-1.6.2.jar;lib/wss4j.jar;lib/xercesImpl-2.8.0.jar;lib/xml-apis.jar;lib/xmlgraphics-commons-1.2.jar;lib/xmlsec-1.4.1.jar;lib/xpp3-1.1.3_8.jar;lib/xstream-1.2.2.jar;../../../lib/mysql-connector-java-5.1.7-bin.jar;../../../endorsed/serializer.jar;../../../endorsed/xalan.jar;lib/axis-1.4.jar;../../../lib/servlet-api.jar;lib/ibatis-2.3.4.726-patched.jar;../../share/WEB-INF/lib/alfresco-jlan-embed-3.2r2.jar;lib/subetha-smtp.jar;lib/xmlrpc.jar;lib/jsr107cache-1.0.jar;lib/alfresco-webscript-framework-3.2r2.jar;lib/abdera-client-0.4.0-incubating.jar;lib/abdera-core-0.4.0-incubating.jar;lib/abdera-extensions-json-0.4.0-incubating.jar;lib/abdera-i18n-0.4.0-incubating.jar;lib/abdera-parser-0.4.0-incubating.jar;lib/axiom-api-1.2.5.jar;lib/axiom-impl-1.2.5.jar;lib/greenmail-1.3-patched.jar;lib/alfresco-vti-3.2r2.jar;lib/jetty-util-6.1.14.jar;lib/jetty-6.1.14.jar org.alfresco.tools.Export -user admin -pwd admin -s user://alfrescoUserStore -path /sys:system/sys

eople -verbose -overwrite AlfrescoUserStore-people

java -classpath classes/alfresco/module;../../../shared/classes;classes;lib/acegi-security-0.8.2_patched.jar;lib/activation.jar;lib/addressing-1.0.jar;lib/alfresco-core-3.2r2.jar;lib/alfresco-deployment-3.2r2.jar;lib/alfresco-linkvalidation.jar;lib/alfresco-mbeans-3.2r2.jar;lib/alfresco-remote-api-3.2r2.jar;lib/alfresco-repository-3.2r2.jar;lib/alfresco-web-client-3.2r2.jar;lib/ant.jar;lib/antlr-2.7.5H3.jar;lib/aopalliance.jar;lib/avalon-framework-4.2.0.jar;lib/bcel.jar;lib/bcprov-jdk15-137.jar;lib/bsf-2.4.0.jar;lib/bsh-1.3.0.jar;../../../lib/catalina.jar;lib/cglib-nodep-2.2_beta1.jar;lib/chiba-1.3.0-patched.jar;lib/commons-beanutils-1.7.0.jar;lib/commons-codec-1.3.jar;lib/commons-collections-3.1.jar;lib/commons-dbcp-1.2.2.jar;lib/commons-digester-1.6.jar;lib/commons-discovery-0.2.jar;lib/commons-el.jar;lib/commons-fileupload-1.1.1.jar;lib/commons-httpclient-3.1.jar;lib/commons-io-1.1.jar;lib/commons-jxpath-1.2.jar;lib/commons-lang-2.1.jar;lib/commons-logging-1.1.jar;lib/commons-modeler.jar;lib/commons-pool-1.4.jar;lib/commons-validator.jar;lib/cpool.jar;../../../lib/cryptix-jce-provider.jar;lib/dom4j-1.6.1.jar;lib/ehcache-1.4.1-patched.jar;lib/fontbox-0.8.0-incubating.jar;lib/fop-0.94.jar;lib/freemarker-2.3.13.jar;lib/guessencoding-1.0.jar;lib/hibernate-3.2.6-patched.jar;lib/hrtlib.jar;lib/hsqldb.jar;lib/htmlparser-1.6.jar;lib/icu4j_3_6_1.jar;lib/jakarta-oro-2.0.8.jar;lib/jaxen-1.1-beta-8.jar;lib/jaxrpc.jar;lib/jbpm-identity-3.3.1.jar;lib/jbpm-jpdl-3.3.1.jar;lib/jcr-1.0.jar;lib/jgroups-2.8.0-b2.jar;lib/jibx-bind.jar;lib/jibx-run.jar;lib/jid3lib-0.5.jar;lib/JMagick.jar;lib/joda-time-1.2.1.jar;lib/jooconverter-2.1.0.jar;lib/json.jar;lib/jstl-1.1.0.jar;lib/jta.jar;lib/jug-lgpl-2.0.0.jar;lib/jut.jar;lib/log4j-1.2.15.jar;lib/lucene-analyzers-2.4.1.jar;lib/lucene-core-2.4.1.jar;lib/lucene-snowball-2.4.1.jar;lib/mail.jar;lib/myfaces-api-1.1.5.jar;lib/myfaces-impl-1.1.5.jar;lib/naming-factory.jar;lib/naming-resources.jar;lib/odf_utils.jar;lib/odmg-3.0.jar;lib/openoffice-juh-2.0.3.jar;lib/openoffice-jurt-2.0.3.jar;lib/openoffice-ridl-2.0.3.jar;lib/openoffice-sandbox-2.0.3.jar;lib/openoffice-unoil-2.0.3.jar;lib/opensaml-1.0.1.jar;lib/pdfbox-0.8.0-incubating.jar;lib/poi-3.5-FINAL-20090928.jar;lib/portlet-api-lib.jar;lib/quartz-1.6.0.jar;lib/resolver.jar;lib/rhino-js-1.6R7.jar;lib/saaj.jar;lib/saxpath.jar;lib/spring-2.0.8.jar;lib/springmodules-jbpm31.jar;lib/standard.jar;../../../lib/tlc124.jar;lib/tm-extractors-1.0-patched.jar;../../../lib/tomcat-coyote.jar;../../../lib/tomcat-util.jar;lib/truezip.jar;../../../lib/truelicense-1_29.jar;../../../lib/truexml-1_29-patched.jar;lib/wsdl4j-1.6.2.jar;lib/wss4j.jar;lib/xercesImpl-2.8.0.jar;lib/xml-apis.jar;lib/xmlgraphics-commons-1.2.jar;lib/xmlsec-1.4.1.jar;lib/xpp3-1.1.3_8.jar;lib/xstream-1.2.2.jar;../../../lib/mysql-connector-java-5.1.7-bin.jar;../../../endorsed/serializer.jar;../../../endorsed/xalan.jar;lib/axis-1.4.jar;../../../lib/servlet-api.jar;lib/ibatis-2.3.4.726-patched.jar;../../share/WEB-INF/lib/alfresco-jlan-embed-3.2r2.jar;lib/subetha-smtp.jar;lib/xmlrpc.jar;lib/jsr107cache-1.0.jar;lib/alfresco-webscript-framework-3.2r2.jar;lib/abdera-client-0.4.0-incubating.jar;lib/abdera-core-0.4.0-incubating.jar;lib/abdera-extensions-json-0.4.0-incubating.jar;lib/abdera-i18n-0.4.0-incubating.jar;lib/abdera-parser-0.4.0-incubating.jar;lib/axiom-api-1.2.5.jar;lib/axiom-impl-1.2.5.jar;lib/greenmail-1.3-patched.jar;lib/alfresco-vti-3.2r2.jar;lib/jetty-util-6.1.14.jar;lib/jetty-6.1.14.jar org.alfresco.tools.Export -user admin -pwd admin -s workspace://SpacesStore -p /sys:system/sys

eople -verbose -overwrite SpacesStore-people

joe_l3

Hi all.
I did a test on my system, everything works fine! Well done mathias.lin ! However I post an important note:
The classpath separator character is:

 ";"   (Windows)
":"   (Linux) ‍‍

joe.l3

mathias_lin

Yes, command line import/export works fine, but I'm still looking for a convenient way to export and import i.e. a single resource or a folder from one Alfresco workplace to another easily but without doing it manually. It's quite a drawback that you need to shutdown the entire Alfresco server before running the command line im/export.

What I'd like is to have a option in Alfresco workplace 'replicate' which replicates to another remote server (of course requiring some kind of destination configuration somwhere).

I wonder if there are any samples of anybody out there who did that i.e. via the Web Services API or the Sharepoint API somehow. Unfortunately all the available Alfresco eBooks don't cover much about this topic at all. They don't go into depth very much.

savic_prvoslav

You can create extension and export users to xml and import them letter.

PS: what do you need to export only users or their home spaces and else, is so you can create export users action and export zip , with their homespaces, not so hard to implement.

mathias_lin

Hi Savic,
on my last post I meant 'content' export, actually didn't mean user export. For example I simply want to export/import one file or maybe one subfolder from server1 to server2.
I have two ebooks on Alfresco 3 but they don't say much about extension development and/or on this particular issue regarding import/export. Any resources/links on that which you know about?
Thanks, M.

savic_prvoslav

I really do not understand you. if you want to have same data from one server to another, just backup database and copy files to other server .

mathias_lin

Well, as said, I do not want to backup the whole database and alf_data directory (60 GB), I only want to export/import one single resource for example. And I want the end-user (not me) to be able to do that via the Alfresco workplace. These users are non-technical people, I just want them to click on an icon (i.e. in the context menu of a file) in the Alfresco workplace which allows them to replicate this file to another remote server with the same folder structure.
Obviously this would be some kind of extension and using the web services API; what I'm looking for is some kind of documentation/sample for this approach.
Copying the database and alf_data only works for the entire repository.

savic_prvoslav

Well, in my company we have extension where you can export folder to zip file ( works same as in windows), maybe that is the best solution for you.

yaziderman

Hi mathias.lin

But don't you know the import/export feature already available in Alfresco?
go to the administrator control panel, you have there two options, Export and Import, use them to backup any content you like.

Follow the link for more information:
http://wiki.alfresco.com/wiki/Export_and_Import

mrogers

Or use transfer…

mathias_lin

Yes, command line import/export worked fine, but I was looking for a convenient way to export and import i.e. <strong>a single resource or a folder</strong> from one Alfresco workplace to another easily but without doing it manually. <strong>It's quite a drawback that you need to shutdown the entire Alfresco server before running the command line im/export.</strong>

hr61369256

Hi mathias.lin, … the very short post of mrogers ("Or use transfer…") is a real possibilty. I assume he's proposing FTP, which is a built-in feature of Alfresco. I'm using this for mass upload through php api. All program languages have api's for FTP. I think it should be possible to extend the java-programmed workplace with functionality for single files or whole folders using ftp in the background (not manually). For example as an additional entry in the context menu of a content item (for beeing user-friendly). Just some ideas …

thomasg

Can't guarantee it will work with your environment but you can try this script to import or export using the API
http://tgoirand.wordpress.com/2010/09/10/alfresco-export-import-users-and-groups-script-shell/

savic_prvoslav

You can create the script that will create code for generation users on the other server. It is version independent and allows you to manipulate the export.

http://alfrescoblog.com/2014/09/04/alfresco-export-users-from-one-server-to-the-other/

gluck113

Hope this helps somebody (None of the previous solutions worked on a 4.1 installation).

There is a githubproject that does exactly that through webscript call:

GitHub - telefonosuci/alfresco-user-export: A custom and really simple webscript to export Alfresco users as a csv redy …

cesarista

Hi Simon:

You can also curl people webscript and parse it with jq or jshon (it may be somehow complicated but it is no needed an additional webscript). This should work in Alfresco 4.

$ curl -s -u userassword http://alfrescoserver/alfresco/service/api/people | jq '.people' | jq '.[] | "\(.userName),\(.firstName),\(.lastName),\(.email)"'

Alfresco Shell Tools addon had a similar aprox with a script called alfListUsers.sh

alfresco-shell-tools/alfListUsers.sh at master · ecm4u/alfresco-shell-tools · GitHub

Regards.

--C.