By David Wiseman (Administrator)published 09 May 2010, modified 10 May 2010
My Rating:
Vote
Rating:
(3 votes)
Views:42857

Bulk AD Users - CSV Update

Introduction

The CSV Update feature allows you to update user attributes in Active Directory from a comma-separated text file.  CSV is a common format  used for data exchange between different systems and most data sources will allow you to extract data in this universal format.  It should be easy to extract employee information from your HR database to a CSV file that can be used as the input file for the update.  It's also easy to convert Excel spreadsheets to CSV files and to construct your own CSV files using a notepad application.

Generating a valid CSV file

The first step to updating user accounts from a CSV file is to produce a valid CSV file to be used by the update.  A CSV file is simply a text file containing rows and columns of data like a spreadsheet and they can be read and written to by spreadsheet applications like Microsoft Excel.  As mentioned previously, there is normally a way to extract data from data sources into CSV text files.  It's also possible to produce a text file manually by using an application such as notepad.  See here for more information on producing CSV files.
 
As well as ensuring that you have a well formed CSV file, there are also some additional requirements to enable the CSV file to be used as the input source for the CSV update.  The CSV file must contain a header row with column names that correspond to the attributes in Active Directory that you want to update.  You should be careful to use the correct attribute names as the attribute names don't always correspond to the ones used in Active Directory Users & Computers.  For example, instead of "Last Name" you need to use "sn" and instead of city you would use "l".  You might find the Active Directory Schema Guide on this website useful for identifying the correct attribute names.
 
One of the columns in the CSV file must be used to identify the user account that you want to update in Active Directory.  The attributes "sAMAccountName" (User logon name pre-Windows 2000) and "userPrincipalName" (User logon name) are ideal candidates because they are guaranteed to be unique and enable you to unambiguously identify the user account that you want to update.  This isn't a strict requirement so you can use other attributes such as "mail" or "EmployeeID" if no other link to your data source exists.  In this case there is a possibility that a row in the CSV file will match to multiple user accounts.  If this occurs the update will fail for that row by default, but you can also configure the application to update all user accounts.  This might be useful if you know that there are certain people that have more than one user account for different purposes (e.g. system admins might have a normal account and an account with elevated privileges) and you want to update all the accounts linked to that person.  You can also exploit this feature if you have a list of departments and information that you want to update for every user in that department (e.g. fax number, manager).

Sample CSV Files

Sample 1

This CSV file was produced from Microsoft's AdventureWorks sample database and it has been converted into a format that can be used with the CSV update feature:

adventureworks_employee.csv
 
The following attribute names are included as column headings in the CSV file:
 
sAMAccountName This is the username (Pre-Windows 2000) attribute that will be used to link rows in the CSV file to user accounts in Active Directory.
EmployeeID This attribute isn't visible via the ADU&C interface, but it can be used by other LDAP directory enabled applications.  This attribute will also be visible in ADSIEdit.
Title This attribute corresponds to the "Job Title" field on the "Organization" page in ADU&C
streetAddress This attribute corresponds to the "Street" field on the "Address" page in ADU&C. 
l This attribute corresponds to the "City" field on the "Address" page in ADU&C.
postalCode This attribute corresponds to the "Zip/Postal Code" field on the "Address" page in ADU&C.
st This attribute corresponds to the "State/Province" field on the "Address" page in ADU&C
department This attribute corresponds to the "Department" field on the "Organization" page in ADU&C.
givenName This attribute corresponds to the "First Name" field on the "General" page in ADU&C.
sn This attribute corresponds to the "Last Name" field on the "General" page in ADU&C.
mail This attribute corresponds to the "E-mail" field on the "General" page in ADU&C.
telephoneNumber This attribute corresponds to the "Telephone number" field on the "General" page in ADU&C.
 
The sAMAccountName column is particularly important as it provides a link between rows in our CSV file to user accounts in Active Directory.
Note: The CSV update tool isn't limited to the list of attributes defined above and you can choose a different attribute as your link between rows in the CSV file and user accounts in Active Directory.

Sample 2

This sample CSV file demonstrates how the "Allow multiple users per CSV row" feature can be exploited to update user data for all users in each department.

department_update.csv
 
department This attribute will be used to match rows in the CSV file to every user in those departments, demonstrating an alternative use for the "Allow multiple users per CSV row" feature.
facsimileTelephoneNumber This attribute corresponds to the "Fax" field on the "Telephones" page in ADU&C.
manager This attribute corresponds to the "manager" field on the "Organization" page in ADU&C.  Please note that this attribute must be specified in distinguished name format. 
Note: Future versions of the application will provide an alternative method similar to the one available in this VBS script.

Instructions

Bulk AD Users - CSV Update dialog

  • Create your CSV update file as described in the "Generating a valid CSV file" section.
  • Open Bulk AD Users and select "CSV Update" from the "Update" menu.  (You can also click the button on the toolbar)
  • In section 1, click the folder icon to browse the file system for your CSV file.
  • In section 2, select the attribute that you want to use to identify the user accounts that you want to update.  As mentioned previously, sAMAccountName (Logon name pre-Windows 2000) and userPrincipalName (Logon name) are both good candidates as they are guaranteed to be unique. 
  • In section 3, review the list of attributes and uncheck any attributes that you do not wish to update.
  • In section 4, you can specify a separator character for multi-valued attributes, allowing you to assign more than 1 value to an attribute.  You can also check the option to allow a single row in the CSV file to update more than 1 user account.

 Known Issues

  • Data might be incorrectly converted to a number by the Microsoft.Jet provider, resulting in data loss.  e.g. The value 01234 is converted to 1234.  This can be prevented by using quotation marks in your CSV file to surround the value.  e.g. "01234" instead of 01234.  It's also possible to fix this problem using a schema.ini file.
    Note: You might also experience a similar problem where a value gets converted to a date and the data appears in a different format in Active Directory.  e.g. 01/01/2010 would get converted to a date and appear as "01/01/2010 00:00:00".  This is part of the same issue and the workaround above will also apply.
  • CSV files with delimiters other then the comma "," character are not supported.  (Using a semi-colon character ";" as a delimiter is also a popular file format)

These issues will be resolved in future versions of the application.




  Post Comment
Order By:  
User Comments
      
coribergen
Posted On: 5/16/2017 9:59:36 AM

I'm having an issue with leading zeros. Importing data into extensionAttribute and some of it has leading zeros. I have saved columns as text and upon import the process drops the zero. I have added quotations and the field is imported with the quotations marks. Sigh. I guess I'll try the schema. Any other suggestions?

xiaoou
Posted On: 10/4/2018 6:00:20 AM

20181004 xiaoou
stussy hoodie
tory burch outlet online
reebok shoes
ugg boots clearance
coach outlet online
longchamp outlet store
polo ralph lauren
swarovski outlet store
reebok shoes
football shirts
coach outlet online
swarovski jewellery
canada goose outlet
puma shoes
mulberry uk
michael kors outlet
mlb jerseys
moncler jackets
canada goose outlet store
kobe shoes
cheap ray ban sunglasses
longchamp handbags
true religion outlet uk
christian louboutin shoes
tods outlet online
pandora charms sale clearance
burberry outlet sale
true religion jeans
ugg boots clearance
canada goose jackets
uggs outlet
canada goose jackets
polo ralph lauren
polo ralph lauren
burberry canada
cheap ray ban sunglasses
canada goose jackets
coach outlet online
mlb jerseys
ugg boots clearance
kate spade outlet online
michael kors outlet online
adidas yeezy boost
barbour women jackets
canada goose jackets sale
van cleef arpels jewelry
cheap nhl jerseys
michael kors outlet online
cheap football shirts
ray ban sunglasses outlet
coach outlet online
longchamp outlet online
mizuno shoes
asics running shoes
ralph lauren polo
ugg canada
ferragamo shoes
polo outlet factory store
mont blanc outlet
jordan 12
kd shoes
bvlgari outlet
canada goose coats
nike air huarache
cheap ugg boots
ferragamo shoes
canada goose outlet
cheap jordan shoes
coach factory outlet
coach outlet
nike outlet online
nfl jerseys
polo ralph lauren outlet
true religion jeans
ugg outlet
uggs outlet
uggs outlet
supreme t shirts
ralph lauren shirts
cheap jordan shoes
christian louboutin shoes
true religion jeans sale
kobe 9 elite
coach outlet online
coach outlet store
pandora outlet
nike outlet store
coach outlet
jordan 4
michael kors outlet online
converse shoes sale
cheap jordan shoes
nfl jersey wholesale
tory burch outlet online
uggs outlet
ugg boots clearance
michael kors outlet
christian louboutin shoes
adidas nmd runner
moncler coats
coach outlet store online
michael kors outlet clearance
canada goose jackets
nike shoes outlet
christian louboutin shoes
supreme t shirts
ugg outlet
michael kors outlet online
air max 90
moncler jackets
michael kors outlet clearance
oakley sunglasses wholesale
balenciaga shoes
ugg boots clearance
nike air max 1
ralph lauren uk
denver broncos jersey
ralph lauren polo
coach outlet
prada sunglasses for women
coach factory outlet
ugg outlet stores
cheap ugg boots
michael kors outlet
swarovski outlet store
cheap oakley sunglasses
jordan shoes
montblanc pens outlet
nike air max
soccer jerseys wholesale
michael kors wallets for women
ugg outlet
michael kors bags
nike roshe run
chrome hearts online store
ralph lauren polo
michael kors outlet online
ugg outlet
canada goose outlet
giuseppe zanotti shoes
chrome hearts outlet store
soccer cleats
swarovski jewelry
cheap oakley sunglasses
canada goose outlet store
fitflops shoes
pandora jewelry
hermes outlet store
michael kors outlet online
polo ralph lauren shirts
canada goose coats
ralph lauren outlet
gucci outlet online
coach outlet online
cheap oakley sunglasses
michael kors uk
malone souliers
moncler jackets
cheap jordan shoes
off-white clothing
air jordan shoes
polo ralph lauren shirts
tory burch outlet online
pandora charms sale clearance
ralph lauren shirts
tory burch outlet stores
uggs outlet
canada goose jackets outlet
nike air huarache
ugg outlet
polo ralph lauren outlet
michael kors outlet clearance
ysl outlet online
swarovski uk
christian louboutin shoes
suicoke sandals
nike air max 90
adidas wings shoes
coach factory outlet
kate spade sale
cheap soccer jerseys
supreme t shirts
michael kors canada
coach outlet
canada goose outlet store
coach handbags outlet
wellensteyn outlet
canada goose outlet store
longchamp handbags sale
polo ralph lauren outlet
red bottoms
mbt
christian louboutin shoes
michael kors outlet
ralph lauren polo
mulberry bags
michael kors outlet online
ferragamo shoes
air jordan shoes
cheap jordan shoes
cheap ray ban sunglasses
cazal outlet
michael kors outlet online
kate spade handbags
adidas shoes
coach outlet store online
louboutin shoes
ugg boots on sale
canada goose outlet store
pandora charms sale clearance
adidas store
christian louboutin shoes
coach outlet
ferragamo outlet
canada goose outlet store
nike revolution
air max 2015
los angeles lakers jerseys
cheap oakley sunglasses
nhl jerseys
coach outlet
tory burch outlet online
mulberry handbags
air jordan shoes
christian louboutin outlet
christian louboutin outlet
moncler outlet online
ugg outlet
uggs outlet
cheap jordan shoes
michael kors outlet clearance
michael?kors?outlet?online
uggs outlet
moncler outlet store
north face outlet
air force 1 shoes
cheap ray ban sunglasses
hermes birkin bag
coach outlet online
fred perry polo
canada goose outlet store
james harden shoes
kate spade sale
coach outlet online
gucci bags
fila sneakers
michael kors outlet online
adidas y3 shoes
cheap ugg boots
ed hardy outlet
ugg outlet
coach outlet
michael kors outlet online
ralph lauren outlet
coach outlet online
michael kors outlet
lacoste shirts
ugg boots clearance
kate spade
air jordan shoes
ferragamo shoes
nike shoes outlet
coach outlet
michael kors outlet online
michael kors outlet online
fitflops
kate spade handbags
michael kors outlet online
michael kors outlet clearance
ugg boots
ugg outlet
north face denail jacket clearance
cheap jerseys wholesale
oakley sunglasses wholesale
oakley sunglasses wholesale
mulberry outlet,mulberry handbags outlet
fitflops
tory burch handbags
coach outlet online
cheap jerseys wholesale
cheap jordans
yeezy boost
uggs outlet
pandora charms sale clearance
herve leger dresses
foamposite shoes
ravens jerseys
49ers jersey
canada goose jackets outlet
canada goose outlet
coach outlet online
polo ralph lauren outlet
jordan 3
jordan shoes
uggs outlet
michael kors outlet clearance
michael kors factory outlet
canada goose jackets
manolo blahnik outlet
moncler outlet online
christian louboutin shoes
birkenstock shoes
adidas crazy
mulberry handbags sale
true religion outlet
canada goose outlet online
broncos jerseys
cheap nba jerseys
lebron shoes
pandora charms sale clearance
louboutin outlet
burberry outlet store
uggs outlet
uggs outlet
jordan 4
jordan shoes
nike air force 1
kate spade handbags
salomon outlet
christian louboutin shoes
swarovski outlet store
nike uk store
nobis jackets
coach outlet
burberry outlet online
jordan retro
cheap ray ban sunglasses
fitflops sale clearance
ugg boots clearance
pandora outlet
michael kors outlet clearance
coach factory outlet
michael kors handbags outlet
air jordan retro
christian louboutin shoes
nike shoes outlet
canada goose jackets
true religion uk
toms outlet
uggs clearance
hermes outlet store
light up shoes
christian louboutin shoes
true religion jeans
coach outlet online
michael kors outlet online
canada goose outlet
pandora charms sale clearance
longchamp pas cher
michael kors outlet online
mulberry handbags
nike shoes outlet
prada outlet online
cheap nba jerseys
uggs outlet
christian louboutin shoes
canada goose jackets
new balance outlet
coach outlet online
canada goose outlet store
cheap jordans
kate spade sale
michael kors outlet
uggs outlet
canada goose outlet store
nfl jerseys
mbt
gucci outlet store
undefeated shoes
mcm backpacks
texans jerseys
canada goose outlet
supreme clothing uk
michael kors outlet online
true religion outlet
kobe bryants shoes
christian louboutin shoes
canada goose jackets
uggs outlet
cheap jordans free shipping
true religion outlet
ray ban sunglasses outlet
canada goose jackets outlet
tory burch outlet online
air jordan shoes
canada goose outlet store
christian louboutin pas cher
toms outlet
coach factory store
uggs outlet
uggs outlet
ray ban sunglasses outlet
cheap jordans for sale
air jordan shoes
longchamp pliage
longchamp pliage
cheap ugg boots
birkenstock shoes
fitflops sale clearance
marc jacobs sale
canada goose outlet
bottega veneta outlet online
michael kors outlet online
jordan shoes
canada goose jackets
pandora outlet
coach outlet online
coach outlet clearance
chrome hearts online store
christian louboutin shoes
mishka snapbacks
mulberry handbags
adidas outlet online
under armour outlet
blackhawks jerseys
pandora outlet
moncler coats
ralph lauren outlet
coach outlet online
true religion jeans
pandora charms
adidas nmd r1
coach factory outlet
coach outlet
canada goose jackets
cheap nhl jerseys
coach outlet online
moncler outlet online
pandora charms
michael kors outlet online
hermes belts
pandora jewelry
polo ralph lauren
christian louboutin shoes
mbt outlet
cartier bracelet
san antonio spurs
tory burch outlet online
louboutin shoes
fitflops shoes
vans sneakers
nike factory store
jimmy choo shoes
coach factory outlet
fitflops
ralph lauren outlet
ray ban sunglasses
mulberry uk
cheap basketball shoes
cheap ray ban sunglasses
true religion outlet
coach factory outlet
ugg outlet
cheap oakley sunglasses
coach handbags on sale
2018 world cup jerseys
michael kors
canada goose
canada goose jackets
givenchy handbags
golden state warriors
off white clothing
cleveland cavaliers jerseys
true religion outlet
coach outlet
longchamp outlet
pandora jewelry
camisetas futbol baratas
cheap jordan shoes
ugg boots clearance
longchamp bags
ugg outlet
coach outlet
canada goose outlet store
kate spade sale
christian louboutin shoes
ugg boots
tory burch outlet online
cheap ray ban sunglasses
longchamp handbags
polo ralph lauren outlet
michael kors outlet online
nike shoes outlet
fitflops sale clearance
ray ban sunglasses outlet
true religion outlet
coach canada
ugg outlet
supra shoes sale
lacoste polo
cheap jordans
canada goose outlet store
ralph lauren outlet
nike blazer pas cher
michael kors uk
adidas yeezy boost
kate spade sale
fitflops sale clearance
pandora outlet
kate spade handbags
new york knicks
links of london jewellery
pandora charms sale clearance
michael kors outlet clearance
yeezy boost 350
nike air max 2017
michael kors handbags
tory burch outlet online
ferragamo shoes sale
ralph lauren outlet
pandora charms sale clearance
ecco outlet
gucci outlet online
christian louboutin shoes
ralph lauren femme
coach outlet online
north face outlet
true religion outlet store
kate spade outlet online
polo outlet online
snapbacks wholesale
miu miu shoes
prada shoes for men
moncler outlet store
toms outlet
canada goose outlet store
christian louboutin shoes
true religion outlet
ferragamo shoes
ralph lauren polo
canada goose jackets outlet
adidas outlet online
canada goose jackets
nike air max 97
colts jerseys
canada goose jackets
pandora charms sale clearance
cheap nba jerseys
jordan shoes
michael kors outlet online
oakley sunglasses wholesale
jordan retro
canada goose jackets
michael kors outlet clearance
ugg boots
gucci outlet online
true religion outlet
mbt
coach outlet online
mont blanc pens
nike air max 90
coach outlet store
cheap jerseys wholesale
mulberry bags
uggs outlet
valentino shoes
michael kors outlet online
20181004

crazymichael
Posted On: 11/7/2018 11:46:30 AM

The most annoying thing New Balance Outlet about going to school is that it rains without an Nike Air Vapormax umbrella. I want to go to Cheap North Face Jacket the toilet to get some rain. In order to prevent a terrible Cheap Stone Island cold from coming to me, I quickly wiped the water on my hair with toilet paper after I Michael Kors Handbagsreturned to the classroom.
"Haha, telling you not to bring an umbrella, it’s Cheap Michael Kors Handbags a chicken soup! Haha, it’s so funny..." My naughty table was schadenfreaked, and my teeth were revealed. Nike Outlet Store He was called a classmate around me. It’s really irritating to watch my wolf jokes Air Max Tn Plus together.
Looking at his hateful face, UGG Australia I didn't beat a fight. Suddenly, I said to him, "Yes, Xiaoyu, I just met Wu on the way back to the toilet. UGG Slippers He asked me to bring words. For you, let you hurry to go to the office to find him, it seems that there is something urgent." Cheap UGG Boots As soon as I finished talking, my smile was solidified in Xiaoyu's face, Coach Outlet but I began to secretly laugh in my heart. Teacher Wu is our Cheap Kate Spade Handbag math teacher and is particularly fierce. Xiaoyu’s Cheap Nike Air Max 2018 mathematics performance has not been good, so he is particularly afraid of Wu, Nike Air Max and now he is more afraid of hearing Cheap Nike Shoes him to go to the office. But he quickly pretended to calmly pull the jacket Victoria Secret Clothing zipper out of the classroom. As soon as he got out of Adidas Superstar the classroom, he ran quickly in the direction of the office. Victoria Secret Outlet I also quickly followed.
The office building is not the same as our teaching building, Adidas Originals Superstar so Xiaoyu wants to find Teacher Wu and I have to rain like me. Nike Air Max Tn I looked at the shadow of Xiaoyu flying downstairs and didn't mention how Kate Spade Outlet Store happy I was. Xiaoyu probably ran too fast, his footsteps did not stabilize, Balenciaga Sneakers and suddenly fell, and the jacket was soaked Coach Factory with a lot of water. When he just got up, he met Wu, Coach Factory Outlet Store who was going to class. My heart suddenly stunned. I just revenged but I didn’t Kate Spade Outlet expect that if Wu did not find Xiaoyu, and Xiaoyu sold me, Kate Spade Outlet then Am I not terrible? What happened behind meCoach Outlet Online, I dare not look at it, and my legs were soft and I went back Coach Factory Outlet to the classroom to sit down, waiting for Xiaoyu to bring me Wu to come Fila Sandals to me.
After class, Xiaoyu walked in and sat down, Coach Outlet Store Online looked at me and said nothing. Coach Outlet Online Teacher Wu did not follow up. Now is a language class. Teacher Wang Adidas Backpack is very energetic on the stage. But Xiaoyu and I can’t listen. Xiaoyu is because the wet coat is a little cold, and I Nike Shirts can’t help but squeeze the water on my coat. My Eyes have also been staring at Xiaoyu's movements, Stussy Outlet and the mood has not been revengeful, but it is deeply embarrassing. Nike Air Max Black I want to apologize to Xiaoyu, but I can't open my mouth. I found out Fila Outlet that only two sheets of toilet paper left in The North Face Outlet the drawer were handed to Xiaoyu, indicating that he would wipe the clothes. Balenciaga Shoes Xiaoyu took the toilet paper and smiled at me. Stone Island Hoodie My heart is even more mixed!
I finally got off the class, and I also had the courage toNike Outlet say "I'm sorry" to Xiaoyu! Xiaoyu’s still wet jacket said with a smile: “It’s okay. I know you lied to me because Wu said that he didn’t Victoria Secret Outlet even look for me, but I also know why you lied to me, because I just laughed at you at first. So this time, Michael Kors Outlet Online the trick is even, and no one owes anyone."
I didn't expect Michael Kors Outlet the same table that I always hated to be such a generous person. UGG Outlet Store He not only forgave me, but also told Wu to tell me about it. UGG Outlet I realized that I was careful, and then I borrowed a lot of toilet paper from my classmates. Victoria Secret Pink I spread the sheets to help Xiaoyu absorb the water stains on his jacket.
A soaked coat made UGG Boots Sale me see the generosity of Xiaoyu at the same table, and made us a very good friend. Now we are still good friends, Coach Outlet Sale he still wears the jacket.