List Archives

This forum is an archive of all posts to our mailing list over the past few years. The forum is set read only therefore to contribute you will need to join our list community. See more info about this here.

When subscribed to the list you should use your standard email client to send your posts to ActiveDir@mail.activedir.org.

List Archives

Unanswered Active Topics

Forums Search

Forums >ActiveDir Mail List Archive >List Archives

Subject: RE: [ActiveDir] export to csv

Prev Next

You are not authorized to post a reply.

Author

Messages

listmail

Posts:824

08/23/2005 2:12 AM
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. -----Original Message----- From: ActiveDir-owner@xxxxxxxxxxxxxxxxxx [mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of Tom Kern Sent: Monday, August 22, 2005 8:29 PM To: ActiveDir@xxxxxxxxxxxxxxxxxx Subject: Re: [ActiveDir] export to csv 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 On 8/22/05, Tom Kern wrote: > 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/ 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/

You are not authorized to post a reply.

Forums >ActiveDir Mail List Archive >List Archives > RE: [ActiveDir] export to csv

ActiveForums 3.7

Syndicate

Friends

List Archives

List Archives

Friends

Members

Articles

Related Links

Ads