export to csv

  • 2.4K Views
  • Last Post 23 August 2005
yandi.harjadi posted this 22 August 2005

You can do it from active directory snap in, right click on the OU
folder, and export list. If you need additional columns to be exported,
just select from View menu, add/remove columns. Mine is W2K3 AD ...

show

Order By: Standard | Newest | Votes
listmail posted this 23 August 2005

When you want to convert to a CSV with adcsv you don't want to use -nodn and
-nolabel with adfind or else it can't figure out what is in the file, it is
just a bunch of text. I didn't notice that he had specified those options in
his post when I responded.

show

tkern posted this 23 August 2005

On 8/19/05, joe wrote:
> After you export to a file, then you can use adcsv.pl (also in the zip) to
> convert the file to a delimited single liner per object file. Version 2.0.0,
> if I ever get to work on it, will have native delimited output capability.
>
> joe
>
>
> -----Original Message-----
> From: ActiveDir-owner@xxxxxxxxxxxxxxxxxx
> [mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of Charlie Kaiser
> Sent: Friday, August 19, 2005 3:51 PM
> To: ActiveDir@xxxxxxxxxxxxxxxxxx
> Subject: RE: [ActiveDir] export to csv
>
> Yes.
>
> adfind -default -f displayname="Username" cn streetaddress st co -noctl
> -nodn -nolabel > outputfile.txt (or csv)
>
> You may have to play with the order in the output file to get what you want.
>
> ******
> Charlie Kaiser
> W2K3 MCSA/MCSE/Security, CCNA
> Systems Engineer
> Essex Credit / Brickwalk
> 510 595 5083
> ******
>
>
> > -----Original Message-----
> > From: ActiveDir-owner@xxxxxxxxxxxxxxxxxx
> > [mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of Tom Kern
> > Sent: Friday, August 19, 2005 11:42 AM
> > To: activedirectory
> > Subject: [ActiveDir] export to csv
> >
> > Whats the best utility to export only user object and attribs like
> > st,streetAddress,c,email addy,etc.
> > Just the "human" stuff a manager would be interested in?
> > could adfind do this?
> > thanks
> > List info : http://www.activedir.org/List.aspx
> > List FAQ : http://www.activedir.org/ListFAQ.aspx
> > List archive:
> > http://www.mail-archive.com/activedir%40mail.activedir.org/
> >
> List info : http://www.activedir.org/List.aspx
> List FAQ : http://www.activedir.org/ListFAQ.aspx
> List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
>
> List info : http://www.activedir.org/List.aspx
> List FAQ : http://www.activedir.org/ListFAQ.aspx
> List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
>
List info : http://www.activedir.org/List.aspx
List FAQ : http://www.activedir.org/ListFAQ.aspx
List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/

tkern posted this 23 August 2005

I ran adfind with simillar parameters to what Charlie suggested.
Now, I think i got stoopid because i'm having issues with adcsv.pl.
When i use the output of adfind as the inputfile for adcsv.pl, i just
get a DN; and thats it.
Using the switch for csv, doesn't seem to do anything. If my
outputfile is called "test.txt.", adcsv.pl, just makes a
"test.txt.txt" file with only the 1 entry- DN;
This happens no matter what arguments I use or don't use.

What am i doing wrong?
Am i this dense?

Thanks

show

Close