Solved

Need to update GAL from the attributes given in excel sheet

Posted on 2011-02-17
14
606 Views
Last Modified: 2012-08-13
I need to update the records like: Mobile num,department,Address(Street,City,Postal Code) etc in GAL.

Will any one please help me to locate the best script to automate the whole process with sample of excel file with required attributes?
0
Comment
Question by:patron
  • 4
  • 2
  • 2
  • +2
14 Comments
 
LVL 41

Expert Comment

by:Amit
Comment Utility
0
 
LVL 41

Expert Comment

by:Amit
Comment Utility
0
 
LVL 1

Author Comment

by:patron
Comment Utility
Is there any tool which can be used to update multiple entries at same like concerned mobile number and address etc..
Can I take the inputs from excels sheet ..if yes what should the format for attributes..?
0
 
LVL 1

Author Comment

by:patron
Comment Utility
I tried admodify-but it can work for same entries only also tried galmod to give access to user-but not satisfied!
I also have one script (Attached), can anyone please update this script to get the attributes from excel file to update user’s mobile num/address etc..? Please share the format of excel/csv with the required update in this script
Thanks in advance!!

Also help me to understand the distinguish names/attributes used for AD which can be used in script also?
AD-Attrib-Script.txt
0
 
LVL 70

Assisted Solution

by:Chris Dent
Chris Dent earned 250 total points
Comment Utility
Hi BKBIGB,

Have you considered using PowerShell for this? If you use that along with the Quest CmdLets we can make this pretty easy:

http://www.quest.com/powershell/activeroles-server.aspx

The only catch is that you'd need to save your file as a CSV, then give us some idea of the column names.

Chris
0
Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 
LVL 70

Expert Comment

by:Chris Dent
Comment Utility

Sorry, I forgot to add, whether you go for PowerShell or not we need a sample of the input file. Then a script can be written and documented to meet your needs here.

Chris
0
 
LVL 25

Accepted Solution

by:
Ron M earned 250 total points
Comment Utility
0
 
LVL 1

Author Comment

by:patron
Comment Utility
Sample Input File is attached.. also suggest if there is any other better option for win 2k3?
Input.xls
0
 
LVL 25

Expert Comment

by:Ron M
Comment Utility
BKBIGB,

Please read the article I posted, it has an XLS sheet attached which you can use to populate information, ...then you would use the resulting command lines to bulk update.




xLS-dsquery-dsmod-example.xls
0
 
LVL 1

Author Comment

by:patron
Comment Utility
Thanks
0
 
LVL 74

Expert Comment

by:Glen Knight
Comment Utility
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

We are happy to announce a brand new addition to our line of acclaimed email signature management products – CodeTwo Email Signatures for Office 365.
In this article, we will see the basic design consideration while designing a Multi-tenant web application in a simple manner. Though, many frameworks are available in the market to develop a multi - tenant application, but do they provide data, cod…
In this video we show how to create an email address policy in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.:  First we need to log into the Exchange Admin Center. Navigate to the Mail Flow…
The video tutorial explains the basics of the Exchange server Database Availability groups. The components of this video include: 1. Automatic Failover 2. Failover Clustering 3. Active Manager

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now