topic Re: export users from Alfresco??urgent in Alfresco Archive

export users from Alfresco??urgent

sumit057 — Tue, 08 Sep 2009 12:35:14 GMT

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

Re: export users from Alfresco??urgent

derek — Tue, 08 Sep 2009 12:43:47 GMT

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

Re: export users from Alfresco??urgent

sumit057 — Tue, 08 Sep 2009 13:09:54 GMT

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

Re: export users from Alfresco??urgent

sumit057 — Wed, 09 Sep 2009 09:09:58 GMT

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

Re: export users from Alfresco??urgent

norgan — Wed, 09 Sep 2009 16:35:44 GMT

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

Norgan

Re: export users from Alfresco??urgent

sumit057 — Fri, 11 Sep 2009 05:11:44 GMT

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

Re: export users from Alfresco??urgent

norgan — Mon, 14 Sep 2009 07:57:26 GMT

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

Re: export users from Alfresco??urgent

serverok — Mon, 30 Nov 2009 14:15:36 GMT

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.

Re: export users from Alfresco??urgent

mathias_lin — Fri, 16 Apr 2010 06:49:00 GMT

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/syseople -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/syseople -verbose -overwrite SpacesStore-people

Re: export users from Alfresco??urgent

joe_l3 — Tue, 18 May 2010 15:28:36 GMT

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

Re: export users from Alfresco??urgent

mathias_lin — Tue, 18 May 2010 15:41:00 GMT

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.

Re: export users from Alfresco??urgent

savic_prvoslav — Wed, 19 May 2010 12:38:38 GMT

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.

Re: export users from Alfresco??urgent

mathias_lin — Thu, 20 May 2010 11:30:00 GMT

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.

Re: export users from Alfresco??urgent

savic_prvoslav — Thu, 20 May 2010 13:19:03 GMT

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 .

Re: export users from Alfresco??urgent

mathias_lin — Thu, 20 May 2010 13:31:00 GMT

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.

Re: export users from Alfresco??urgent

savic_prvoslav — Thu, 20 May 2010 13:37:08 GMT

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.

Re: export users from Alfresco??urgent

yaziderman — Wed, 19 Oct 2011 08:30:30 GMT

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

Re: export users from Alfresco??urgent

mrogers — Wed, 19 Oct 2011 09:31:55 GMT

Or use transfer…

Re: export users from Alfresco??urgent

mathias_lin — Tue, 05 Mar 2013 10:11:00 GMT

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>

Re: export users from Alfresco??urgent

hr61369256 — Thu, 07 Mar 2013 22:18:28 GMT

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 …