topic Re: can i import all user details to excell sheet in Alfresco Archive

can i import all user details to excell sheet

bisana — Sun, 02 Jun 2013 13:17:51 GMT

Hi i am looking for an option to export alfresco users details to excel sheet. Is this possibleThanks

Re: can i import all user details to excell sheet

afaust — Sun, 02 Jun 2013 16:01:00 GMT

Hello,

you could simply write out a CSV file (importable into Excel) as a piece of content in the Repository with JavaScript, i.e. using the JavaScript Console. I don't know of a specific, existing tool that already does this…

Regards
Axel

Re: can i import all user details to excell sheet

ddraper — Mon, 03 Jun 2013 09:05:32 GMT

This assumes of course that all your users are managed by Alfresco directly and not from an LDAP (or other user management) server.

Re: can i import all user details to excell sheet

afaust — Wed, 05 Jun 2013 15:12:18 GMT

When using LDAP or another external directory, this depends on what your synchronization settings are. You can always write out all the users with user ID, first and last name (if set in / retrieved from the directory), since Alfresco synchronizes with the directory or lazily-creates the user upon first login. Additional detail information is configuration specific.