topic Re: How to update email ids of users automatically in Alfresco Archive

How to update email ids of users automatically

samnaction — Thu, 08 May 2014 06:57:38 GMT

I am creating user using Windows Active directory. The user is able to login without any problem. However he needs to update the email buy himself. Is there any way to automatically update the users email id from a text file or xls file based on his user name?

Re: How to update email ids of users automatically

sanket — Thu, 08 May 2014 11:21:12 GMT

You can write a schedular that runs periodically (calling your java code) to update the users email id from text, csv or xls file.
http://wiki.alfresco.com/wiki/Scheduled_Actions

Re: How to update email ids of users automatically

samnaction — Fri, 09 May 2014 05:44:07 GMT

I have zero knowledge on java script

Re: How to update email ids of users automatically

samnaction — Mon, 19 May 2014 09:52:53 GMT

I was able to do for individual user using this script

var gens = search.luceneSearch("TYPE:\"{http://www.alfresco.org/model/content/1.0}person\"");
var index;
for(index=0;index<gens.length;++index)
{
   if(gens[index].properties["cm:userName"]=="nazeers")
   {
      gens[index].properties["email"]="sameer@gmail.com";
      gens[index].save();
   }
}‍‍‍‍‍‍‍‍‍‍

But how to do for all users ??

Re: How to update email ids of users automatically

lementree — Mon, 19 May 2014 10:24:31 GMT

Hi,

Upload file contains usernames and email id with some name for example: usesMailIds.csv
file contains username and mailId with comma separate in each line, example:
user1,user1@abc.com
user2,user2@abc.com
user3,user3@abc.com

Then in Javascript search for that file, then read content line by line and update the usermail as you are doing for single user.

Re: How to update email ids of users automatically

samnaction — Mon, 19 May 2014 11:10:00 GMT

var a = new XMLHttpRequest(); I am getting error that XMLHttpRequest is not defined. How to read the file in javascrupt

Re: How to update email ids of users automatically

lementree — Mon, 19 May 2014 12:44:18 GMT


 var doc = search.luceneSearch('@cm\\:name:"usersMails.csv"')[0];
 var docText = doc.content;
 var lines = docText.split("\n");
 for(var i=0; i<lines.length; i++){
  var userMailId = lines[i].split(",");
  var userName = userMailId[0];
  var mailId = userMailId[1];
  var user = people.getPerson(userName);
  user.properties["email"]=mailId;
  user.save();
 }
‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: How to update email ids of users automatically

samnaction — Mon, 19 May 2014 13:56:40 GMT

Thanks that did the work