Re: Directory Export - SMTP address
The simplest way to do this, IIRC, is to add email addresses as a column when you're viewing the Recipients container (or the GAL) from Admin. You can do a File | Save Window Contents As... (or something like that - I don't have Admin here) and dump that to a csv. Missy - Original Message - From: "Hatley, Ken" <[EMAIL PROTECTED]> To: "Exchange Discussions" <[EMAIL PROTECTED]> Sent: Thursday, February 06, 2003 2:39 PM Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: Directory Export - SMTP address
Not necessarily. Ed Crowley MCSE+Internet MVP kcCC+I Tech Consultant hp Services Protecting the world from PSTs and Bricked Backups! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Listserver, Exchange MSER:EX Sent: Friday, February 07, 2003 2:52 PM To: Exchange Discussions Subject: RE: Directory Export - SMTP address If the SMTP address is the default address for the mailbox, then you could use LDIFDE or CSVDE from a Windows 2000 box and export the LDAP "mail" attribute. Steve Smith Common IT Services Ministry of Management Services Province of British Columbia email: [EMAIL PROTECTED] Phone: (250) 387-8698 -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: February 6, 2003 11:39 AM To: Exchange Discussions Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: Directory Export - SMTP address
If the SMTP address is the default address for the mailbox, then you could use LDIFDE or CSVDE from a Windows 2000 box and export the LDAP "mail" attribute. Steve Smith Common IT Services Ministry of Management Services Province of British Columbia email: [EMAIL PROTECTED] Phone: (250) 387-8698 -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: February 6, 2003 11:39 AM To: Exchange Discussions Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: Directory Export - SMTP address
You cannot export just the SMTP address. You can export all the addresses and then parse out the SMTP addresses by exporting the E-Mail Addresses and Secondary-Proxy-Addresses fields, and, for custom recipients, the E-Mail Address field. Ed Crowley MCSE+Internet MVP kcCC+I Tech Consultant hp Services Protecting the world from PSTs and Bricked Backups! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hatley, Ken Sent: Thursday, February 06, 2003 11:39 AM To: Exchange Discussions Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: Directory Export - SMTP address
No, need it with several other fields...I just did a text to columns in excel and got what I needed. Thanks all. -Original Message- From: Schuessler, Bob (Efdsouth) [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:13 PM To: Exchange Discussions Subject:RE: Directory Export - SMTP address Without knowing what the "end result" of the export is, would adding the e-mail address (Internet) column to the view of the admin tool and then save window contents get you what you need?? Bob -Original Message- From: Mellott, Bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 3:07 PM To: Exchange Discussions Subject: RE: Directory Export - SMTP address RE: detail of your original Q: I do not think you can...your going to get the whole 'E-mail Addresses' field you could then chop it up with you favorite admin tools to extract just the SMTP: Im with steve I mess it up good in excel True I find mainly 'E-mail Addresses' which has everything I tend to screw up myself. now there's a 'Secondary-Proxy-Addresses' field with small 'smtp' But I do think if you want to modify someones stuff you have to use the smtp under 'E-mail Addresses' which in capitalized SMTP: I believe what ever follows the SMTP: in that field will update the entries SMTP Note the captial SMTP is key for their default smtp address...at least thats what my memory is telling me right now... bill -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:52 PM To: Exchange Discussions Subject: RE: Directory Export - SMTP address It is for 55, but the only header I see is 'E-mail Addresses' and that gives the full DN, is there a header to just grab the SMTP address? -Original Message- From: Mellott, Bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 1:43 PM To: Exchange Discussions Subject:RE: Directory Export - SMTP address in 55 you needed HEADER.EXE at least thats the way I did it, Im sure there are other ways bill -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:39 PM To: Exchange Discussions Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: Directory Export - SMTP address
Without knowing what the "end result" of the export is, would adding the e-mail address (Internet) column to the view of the admin tool and then save window contents get you what you need?? Bob -Original Message- From: Mellott, Bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 3:07 PM To: Exchange Discussions Subject: RE: Directory Export - SMTP address RE: detail of your original Q: I do not think you can...your going to get the whole 'E-mail Addresses' field you could then chop it up with you favorite admin tools to extract just the SMTP: Im with steve I mess it up good in excel True I find mainly 'E-mail Addresses' which has everything I tend to screw up myself. now there's a 'Secondary-Proxy-Addresses' field with small 'smtp' But I do think if you want to modify someones stuff you have to use the smtp under 'E-mail Addresses' which in capitalized SMTP: I believe what ever follows the SMTP: in that field will update the entries SMTP Note the captial SMTP is key for their default smtp address...at least thats what my memory is telling me right now... bill -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:52 PM To: Exchange Discussions Subject: RE: Directory Export - SMTP address It is for 55, but the only header I see is 'E-mail Addresses' and that gives the full DN, is there a header to just grab the SMTP address? -Original Message- From: Mellott, Bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 1:43 PM To: Exchange Discussions Subject:RE: Directory Export - SMTP address in 55 you needed HEADER.EXE at least thats the way I did it, Im sure there are other ways bill -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:39 PM To: Exchange Discussions Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: Directory Export - SMTP address
RE: detail of your original Q: I do not think you can...your going to get the whole 'E-mail Addresses' field you could then chop it up with you favorite admin tools to extract just the SMTP: Im with steve I mess it up good in excel True I find mainly 'E-mail Addresses' which has everything I tend to screw up myself. now there's a 'Secondary-Proxy-Addresses' field with small 'smtp' But I do think if you want to modify someones stuff you have to use the smtp under 'E-mail Addresses' which in capitalized SMTP: I believe what ever follows the SMTP: in that field will update the entries SMTP Note the captial SMTP is key for their default smtp address...at least thats what my memory is telling me right now... bill -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:52 PM To: Exchange Discussions Subject: RE: Directory Export - SMTP address It is for 55, but the only header I see is 'E-mail Addresses' and that gives the full DN, is there a header to just grab the SMTP address? -Original Message- From: Mellott, Bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 1:43 PM To: Exchange Discussions Subject:RE: Directory Export - SMTP address in 55 you needed HEADER.EXE at least thats the way I did it, Im sure there are other ways bill -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:39 PM To: Exchange Discussions Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: Directory Export - SMTP address
I usually import the csv into excel and manipulate from there. Dave Stevens -IT Network Support- email: [EMAIL PROTECTED] 865-576-8898 -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:39 PM To: Exchange Discussions Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: Directory Export - SMTP address
It is for 55, but the only header I see is 'E-mail Addresses' and that gives the full DN, is there a header to just grab the SMTP address? -Original Message- From: Mellott, Bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 1:43 PM To: Exchange Discussions Subject: RE: Directory Export - SMTP address in 55 you needed HEADER.EXE at least thats the way I did it, Im sure there are other ways bill -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:39 PM To: Exchange Discussions Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: Directory Export - SMTP address
Are these utils on the E2K cd? __ John Bowles Exchange Administrator Messaging Team Celera Genomics [EMAIL PROTECTED] -Original Message- From: Mellott, Bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:43 PM To: Exchange Discussions Subject: RE: Directory Export - SMTP address in 55 you needed HEADER.EXE at least thats the way I did it, Im sure there are other ways bill -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:39 PM To: Exchange Discussions Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: Directory Export - SMTP address
in 55 you needed HEADER.EXE at least thats the way I did it, Im sure there are other ways bill -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:39 PM To: Exchange Discussions Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: Directory Export
So use Notepad. If you insist on using Excel, write a cell function to make the field the way you want it. Ed Crowley MCSE+Internet MVP kcCC+I Tech Consultant Compaq Computer Corporation Protecting the world from PSTs and Bricked Backups! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Blunt, James H (Jim) Sent: Monday, February 25, 2002 10:18 AM To: Exchange Discussions Subject: RE: Directory Export Correct...which as stated below, was Excel 2002. Friggin MS! ;o) -Original Message- From: Roger Seielstad [mailto:[EMAIL PROTECTED]] Sent: Monday, February 25, 2002 9:56 AM To: Exchange Discussions Subject: RE: Directory Export Which means whatever you're reading the export file with is eating the zeros by changing it from string to numeric. -- Roger D. Seielstad - MCSE Sr. Systems Administrator Peregrine Systems Atlanta, GA > -Original Message- > From: Blunt, James H (Jim) [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 25, 2002 12:34 PM > To: Exchange Discussions > Subject: RE: Directory Export > > > Ed, > > Good question...that's what I would have thought as well. > However, I know this field has leading zeroes in Exchange for > three reasons: 1) If you do a Shift-Enter on a recipient and > bring up the object attributes, there is a field called > Employee-Number, so it's not one of the ten Custom Attribute > fields; 2) I enter this field manually, every time I create a > new record; 3) I took Kenneth Walden's suggestion below and > opened it up in Notepad, and sure enough, there were all the > zeroes, just like they were supposed to be. > > Jim Blunt > > -Original Message- > From: Ed Crowley [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 5:43 PM > To: Exchange Discussions > Subject: RE: Directory Export > > > Are you sure the attributes were entered properly with > leading zeroes? Just about all Exchange attributes are > strings, so it doesn't know or care that there are leading > zeroes. Look at the mailboxes' Custom Attributes (I'm > assuming that's where you have this attribute stored) and see > if they're stored in Exchange with leading zeroes. > > Ed Crowley MCSE+Internet MVP kcCC+I > Tech Consultant > Compaq Computer Corporation > Protecting the world from PSTs and Bricked Backups! > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of > Blunt, James H > (Jim) > Sent: Friday, February 22, 2002 3:30 PM > To: Exchange Discussions > Subject: RE: Directory Export > > > Bingo! > > So...now I have a different question. Can I grep the file > and have it spit out the records for me, where the > Employee-Number field has anything other than 7 digits in it? > I.E., if it has <=6 digits or 8=> digits, it pipes that > record to an error file? > > Jim > > -Original Message- > From: Kenneth Walden [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 3:02 PM > To: Exchange Discussions > Subject: RE: Directory Export > > > Did you open the csv file with notepad _after_ you'd opened > it with excel? If so, excel probably stripped (not just > suppressed) the leading zeroes, so that's why they weren't > there in notepad. Try re-exporting and opening with notepad first. > > -Original Message- > From: Blunt, James H (Jim) [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 4:54 PM > To: Exchange Discussions > Subject: RE: Directory Export > > > It's not Excel doing it...I opened it in Notepad and the > leading zeroes are still missing. > > -Original Message- > From: Daniel Chenault [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 2:50 PM > To: Exchange Discussions > Subject: Re: Directory Export > > > Yes, Excel has a tendency to do that to leading 0's. Open it > with notepad or your favorite text editor/viewer - something > that just reads the raw datastream without trying to interpret it. > > - Original Message - > From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> > To: "Exchange Discussions" <[EMAIL PROTECTED]> > Sent: Friday, February 22, 2002 4:46 PM > Subject: RE: Directory Export > > > > Daniel, > > > > 100% sure? No... > > > > I'm using Excel 2002, SP1 > > > > -Original Message- > > From: Daniel Chenault [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 22, 2002 2:42 PM > > To: Exchange Discussions > > Subject: Re: Directory
RE: Directory Export
Correct...which as stated below, was Excel 2002. Friggin MS! ;o) -Original Message- From: Roger Seielstad [mailto:[EMAIL PROTECTED]] Sent: Monday, February 25, 2002 9:56 AM To: Exchange Discussions Subject: RE: Directory Export Which means whatever you're reading the export file with is eating the zeros by changing it from string to numeric. -- Roger D. Seielstad - MCSE Sr. Systems Administrator Peregrine Systems Atlanta, GA > -Original Message- > From: Blunt, James H (Jim) [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 25, 2002 12:34 PM > To: Exchange Discussions > Subject: RE: Directory Export > > > Ed, > > Good question...that's what I would have thought as well. > However, I know this field has leading zeroes in Exchange for > three reasons: 1) If you do a Shift-Enter on a recipient and > bring up the object attributes, there is a field called > Employee-Number, so it's not one of the ten Custom Attribute > fields; 2) I enter this field manually, every time I create a > new record; 3) I took Kenneth Walden's suggestion below and > opened it up in Notepad, and sure enough, there were all the > zeroes, just like they were supposed to be. > > Jim Blunt > > -Original Message- > From: Ed Crowley [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 5:43 PM > To: Exchange Discussions > Subject: RE: Directory Export > > > Are you sure the attributes were entered properly with > leading zeroes? Just about all Exchange attributes are > strings, so it doesn't know or care that there are leading > zeroes. Look at the mailboxes' Custom Attributes (I'm > assuming that's where you have this attribute stored) and see > if they're stored in Exchange with leading zeroes. > > Ed Crowley MCSE+Internet MVP kcCC+I > Tech Consultant > Compaq Computer Corporation > Protecting the world from PSTs and Bricked Backups! > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of > Blunt, James H > (Jim) > Sent: Friday, February 22, 2002 3:30 PM > To: Exchange Discussions > Subject: RE: Directory Export > > > Bingo! > > So...now I have a different question. Can I grep the file > and have it spit out the records for me, where the > Employee-Number field has anything other than 7 digits in it? > I.E., if it has <=6 digits or 8=> digits, it pipes that > record to an error file? > > Jim > > -Original Message- > From: Kenneth Walden [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 3:02 PM > To: Exchange Discussions > Subject: RE: Directory Export > > > Did you open the csv file with notepad _after_ you'd opened > it with excel? If so, excel probably stripped (not just > suppressed) the leading zeroes, so that's why they weren't > there in notepad. Try re-exporting and opening with notepad first. > > -Original Message- > From: Blunt, James H (Jim) [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 4:54 PM > To: Exchange Discussions > Subject: RE: Directory Export > > > It's not Excel doing it...I opened it in Notepad and the > leading zeroes are still missing. > > -Original Message- > From: Daniel Chenault [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 2:50 PM > To: Exchange Discussions > Subject: Re: Directory Export > > > Yes, Excel has a tendency to do that to leading 0's. Open it > with notepad or your favorite text editor/viewer - something > that just reads the raw datastream without trying to interpret it. > > - Original Message - > From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> > To: "Exchange Discussions" <[EMAIL PROTECTED]> > Sent: Friday, February 22, 2002 4:46 PM > Subject: RE: Directory Export > > > > Daniel, > > > > 100% sure? No... > > > > I'm using Excel 2002, SP1 > > > > -Original Message- > > From: Daniel Chenault [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 22, 2002 2:42 PM > > To: Exchange Discussions > > Subject: Re: Directory Export > > > > > > Are you sure it's export dropping the leading zeros? What are you > > using to view the data? > > > > - Original Message - > > From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> > > To: "Exchange Discussions" <[EMAIL PROTECTED]> > > Sent: Friday, February 22, 2002 3:18 PM > > Subject: Directory Export > >
RE: Directory Export
Which means whatever you're reading the export file with is eating the zeros by changing it from string to numeric. -- Roger D. Seielstad - MCSE Sr. Systems Administrator Peregrine Systems Atlanta, GA > -Original Message- > From: Blunt, James H (Jim) [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 25, 2002 12:34 PM > To: Exchange Discussions > Subject: RE: Directory Export > > > Ed, > > Good question...that's what I would have thought as well. > However, I know this field has leading zeroes in Exchange for > three reasons: 1) If you do a Shift-Enter on a recipient and > bring up the object attributes, there is a field called > Employee-Number, so it's not one of the ten Custom Attribute > fields; 2) I enter this field manually, every time I create a > new record; 3) I took Kenneth Walden's suggestion below and > opened it up in Notepad, and sure enough, there were all the > zeroes, just like they were supposed to be. > > Jim Blunt > > -Original Message- > From: Ed Crowley [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 5:43 PM > To: Exchange Discussions > Subject: RE: Directory Export > > > Are you sure the attributes were entered properly with > leading zeroes? Just about all Exchange attributes are > strings, so it doesn't know or care that there are leading > zeroes. Look at the mailboxes' Custom Attributes (I'm > assuming that's where you have this attribute stored) and see > if they're stored in Exchange with leading zeroes. > > Ed Crowley MCSE+Internet MVP kcCC+I > Tech Consultant > Compaq Computer Corporation > Protecting the world from PSTs and Bricked Backups! > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of > Blunt, James H > (Jim) > Sent: Friday, February 22, 2002 3:30 PM > To: Exchange Discussions > Subject: RE: Directory Export > > > Bingo! > > So...now I have a different question. Can I grep the file > and have it spit out the records for me, where the > Employee-Number field has anything other than 7 digits in it? > I.E., if it has <=6 digits or 8=> digits, it pipes that > record to an error file? > > Jim > > -Original Message- > From: Kenneth Walden [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 3:02 PM > To: Exchange Discussions > Subject: RE: Directory Export > > > Did you open the csv file with notepad _after_ you'd opened > it with excel? If so, excel probably stripped (not just > suppressed) the leading zeroes, so that's why they weren't > there in notepad. Try re-exporting and opening with notepad first. > > -Original Message- > From: Blunt, James H (Jim) [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 4:54 PM > To: Exchange Discussions > Subject: RE: Directory Export > > > It's not Excel doing it...I opened it in Notepad and the > leading zeroes are still missing. > > -Original Message- > From: Daniel Chenault [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 2:50 PM > To: Exchange Discussions > Subject: Re: Directory Export > > > Yes, Excel has a tendency to do that to leading 0's. Open it > with notepad or your favorite text editor/viewer - something > that just reads the raw datastream without trying to interpret it. > > - Original Message - > From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> > To: "Exchange Discussions" <[EMAIL PROTECTED]> > Sent: Friday, February 22, 2002 4:46 PM > Subject: RE: Directory Export > > > > Daniel, > > > > 100% sure? No... > > > > I'm using Excel 2002, SP1 > > > > -Original Message- > > From: Daniel Chenault [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 22, 2002 2:42 PM > > To: Exchange Discussions > > Subject: Re: Directory Export > > > > > > Are you sure it's export dropping the leading zeros? What are you > > using to view the data? > > > > - Original Message - > > From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> > > To: "Exchange Discussions" <[EMAIL PROTECTED]> > > Sent: Friday, February 22, 2002 3:18 PM > > Subject: Directory Export > > > > > > > Exchange 5.5, SP4 + hotfixes. > > > > > > When doing a directory export, we have a field titled > > > Employee-Number > (not > > > sure if this i
RE: Directory Export
Ed, Good question...that's what I would have thought as well. However, I know this field has leading zeroes in Exchange for three reasons: 1) If you do a Shift-Enter on a recipient and bring up the object attributes, there is a field called Employee-Number, so it's not one of the ten Custom Attribute fields; 2) I enter this field manually, every time I create a new record; 3) I took Kenneth Walden's suggestion below and opened it up in Notepad, and sure enough, there were all the zeroes, just like they were supposed to be. Jim Blunt -Original Message- From: Ed Crowley [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 5:43 PM To: Exchange Discussions Subject: RE: Directory Export Are you sure the attributes were entered properly with leading zeroes? Just about all Exchange attributes are strings, so it doesn't know or care that there are leading zeroes. Look at the mailboxes' Custom Attributes (I'm assuming that's where you have this attribute stored) and see if they're stored in Exchange with leading zeroes. Ed Crowley MCSE+Internet MVP kcCC+I Tech Consultant Compaq Computer Corporation Protecting the world from PSTs and Bricked Backups! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Blunt, James H (Jim) Sent: Friday, February 22, 2002 3:30 PM To: Exchange Discussions Subject: RE: Directory Export Bingo! So...now I have a different question. Can I grep the file and have it spit out the records for me, where the Employee-Number field has anything other than 7 digits in it? I.E., if it has <=6 digits or 8=> digits, it pipes that record to an error file? Jim -Original Message- From: Kenneth Walden [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 3:02 PM To: Exchange Discussions Subject: RE: Directory Export Did you open the csv file with notepad _after_ you'd opened it with excel? If so, excel probably stripped (not just suppressed) the leading zeroes, so that's why they weren't there in notepad. Try re-exporting and opening with notepad first. -Original Message- From: Blunt, James H (Jim) [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 4:54 PM To: Exchange Discussions Subject: RE: Directory Export It's not Excel doing it...I opened it in Notepad and the leading zeroes are still missing. -Original Message- From: Daniel Chenault [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:50 PM To: Exchange Discussions Subject: Re: Directory Export Yes, Excel has a tendency to do that to leading 0's. Open it with notepad or your favorite text editor/viewer - something that just reads the raw datastream without trying to interpret it. - Original Message - From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> To: "Exchange Discussions" <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 4:46 PM Subject: RE: Directory Export > Daniel, > > 100% sure? No... > > I'm using Excel 2002, SP1 > > -Original Message- > From: Daniel Chenault [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 2:42 PM > To: Exchange Discussions > Subject: Re: Directory Export > > > Are you sure it's export dropping the leading zeros? What are you > using to view the data? > > - Original Message - > From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> > To: "Exchange Discussions" <[EMAIL PROTECTED]> > Sent: Friday, February 22, 2002 3:18 PM > Subject: Directory Export > > > > Exchange 5.5, SP4 + hotfixes. > > > > When doing a directory export, we have a field titled > > Employee-Number (not > > sure if this is a standard field or a custom one). This field is bounced > > against the HR database to ensure no dupes and to update location > > data. Some people's location data is not updating. Since this field > > is required > > for this function, I exported the data to a .csv file and was > > checking it. > > However, what I noticed is that I have anywhere from 3-digit numbers > > to 7-digit numbers, because the export is dropping the leading > > zeroes. Is there any way to force the export to export all 7 > > digits, even if they are > > leading zeroes? > > > > Thanks, > > > > Jim Blunt > > > > _ > > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > > Archives: http://www.swynk.com/sitesearch/search.asp > > To unsubscribe: mailto:[EMAIL PROTECTED] > > Exchange List admin:[EMAIL PROTECTED] > > > > _ > List posting FAQ
RE: Directory Export
Are you sure the attributes were entered properly with leading zeroes? Just about all Exchange attributes are strings, so it doesn't know or care that there are leading zeroes. Look at the mailboxes' Custom Attributes (I'm assuming that's where you have this attribute stored) and see if they're stored in Exchange with leading zeroes. Ed Crowley MCSE+Internet MVP kcCC+I Tech Consultant Compaq Computer Corporation Protecting the world from PSTs and Bricked Backups! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Blunt, James H (Jim) Sent: Friday, February 22, 2002 3:30 PM To: Exchange Discussions Subject: RE: Directory Export Bingo! So...now I have a different question. Can I grep the file and have it spit out the records for me, where the Employee-Number field has anything other than 7 digits in it? I.E., if it has <=6 digits or 8=> digits, it pipes that record to an error file? Jim -Original Message- From: Kenneth Walden [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 3:02 PM To: Exchange Discussions Subject: RE: Directory Export Did you open the csv file with notepad _after_ you'd opened it with excel? If so, excel probably stripped (not just suppressed) the leading zeroes, so that's why they weren't there in notepad. Try re-exporting and opening with notepad first. -Original Message- From: Blunt, James H (Jim) [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 4:54 PM To: Exchange Discussions Subject: RE: Directory Export It's not Excel doing it...I opened it in Notepad and the leading zeroes are still missing. -Original Message- From: Daniel Chenault [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:50 PM To: Exchange Discussions Subject: Re: Directory Export Yes, Excel has a tendency to do that to leading 0's. Open it with notepad or your favorite text editor/viewer - something that just reads the raw datastream without trying to interpret it. - Original Message - From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> To: "Exchange Discussions" <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 4:46 PM Subject: RE: Directory Export > Daniel, > > 100% sure? No... > > I'm using Excel 2002, SP1 > > -Original Message- > From: Daniel Chenault [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 2:42 PM > To: Exchange Discussions > Subject: Re: Directory Export > > > Are you sure it's export dropping the leading zeros? What are you > using to view the data? > > - Original Message - > From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> > To: "Exchange Discussions" <[EMAIL PROTECTED]> > Sent: Friday, February 22, 2002 3:18 PM > Subject: Directory Export > > > > Exchange 5.5, SP4 + hotfixes. > > > > When doing a directory export, we have a field titled > > Employee-Number (not > > sure if this is a standard field or a custom one). This field is bounced > > against the HR database to ensure no dupes and to update location > > data. Some people's location data is not updating. Since this field > > is required > > for this function, I exported the data to a .csv file and was > > checking it. > > However, what I noticed is that I have anywhere from 3-digit numbers > > to 7-digit numbers, because the export is dropping the leading > > zeroes. Is there any way to force the export to export all 7 > > digits, even if they are > > leading zeroes? > > > > Thanks, > > > > Jim Blunt > > > > _ > > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > > Archives: http://www.swynk.com/sitesearch/search.asp > > To unsubscribe: mailto:[EMAIL PROTECTED] > > Exchange List admin:[EMAIL PROTECTED] > > > > _ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe: mailto:[EMAIL PROTECTED] > Exchange List admin:[EMAIL PROTECTED] > > _ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe: mailto:[EMAIL PROTECTED] > Exchange List admin:[EMAIL PROTECTED] > _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/site
RE: Directory Export
Suck the file into Excel, highlight the column, then select Format -> Cells Choose Custom, then specify the template as 000, Excel should put the leading zeroes back in for you. Steve Smith Common IT Services Ministry of Management Services Province of British Columbia email: [EMAIL PROTECTED] Phone: (250) 387-8698 -Original Message- From: Blunt, James H (Jim) [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 3:30 PM To: Exchange Discussions Subject: RE: Directory Export Bingo! So...now I have a different question. Can I grep the file and have it spit out the records for me, where the Employee-Number field has anything other than 7 digits in it? I.E., if it has <=6 digits or 8=> digits, it pipes that record to an error file? Jim -Original Message- From: Kenneth Walden [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 3:02 PM To: Exchange Discussions Subject: RE: Directory Export Did you open the csv file with notepad _after_ you'd opened it with excel? If so, excel probably stripped (not just suppressed) the leading zeroes, so that's why they weren't there in notepad. Try re-exporting and opening with notepad first. -Original Message- From: Blunt, James H (Jim) [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 4:54 PM To: Exchange Discussions Subject: RE: Directory Export It's not Excel doing it...I opened it in Notepad and the leading zeroes are still missing. -Original Message- From: Daniel Chenault [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:50 PM To: Exchange Discussions Subject: Re: Directory Export Yes, Excel has a tendency to do that to leading 0's. Open it with notepad or your favorite text editor/viewer - something that just reads the raw datastream without trying to interpret it. - Original Message - From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> To: "Exchange Discussions" <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 4:46 PM Subject: RE: Directory Export > Daniel, > > 100% sure? No... > > I'm using Excel 2002, SP1 > > -Original Message- > From: Daniel Chenault [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 2:42 PM > To: Exchange Discussions > Subject: Re: Directory Export > > > Are you sure it's export dropping the leading zeros? What are you > using to view the data? > > - Original Message - > From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> > To: "Exchange Discussions" <[EMAIL PROTECTED]> > Sent: Friday, February 22, 2002 3:18 PM > Subject: Directory Export > > > > Exchange 5.5, SP4 + hotfixes. > > > > When doing a directory export, we have a field titled > > Employee-Number (not > > sure if this is a standard field or a custom one). This field is bounced > > against the HR database to ensure no dupes and to update location > > data. Some people's location data is not updating. Since this field > > is required > > for this function, I exported the data to a .csv file and was > > checking it. > > However, what I noticed is that I have anywhere from 3-digit numbers > > to 7-digit numbers, because the export is dropping the leading > > zeroes. Is there any way to force the export to export all 7 > > digits, even if they are > > leading zeroes? > > > > Thanks, > > > > Jim Blunt > > > > _ > > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > > Archives: http://www.swynk.com/sitesearch/search.asp > > To unsubscribe: mailto:[EMAIL PROTECTED] > > Exchange List admin:[EMAIL PROTECTED] > > > > _ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe: mailto:[EMAIL PROTECTED] > Exchange List admin:[EMAIL PROTECTED] > > _ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe: mailto:[EMAIL PROTECTED] > Exchange List admin:[EMAIL PROTECTED] > _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posti
RE: Directory Export
Bingo! So...now I have a different question. Can I grep the file and have it spit out the records for me, where the Employee-Number field has anything other than 7 digits in it? I.E., if it has <=6 digits or 8=> digits, it pipes that record to an error file? Jim -Original Message- From: Kenneth Walden [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 3:02 PM To: Exchange Discussions Subject: RE: Directory Export Did you open the csv file with notepad _after_ you'd opened it with excel? If so, excel probably stripped (not just suppressed) the leading zeroes, so that's why they weren't there in notepad. Try re-exporting and opening with notepad first. -Original Message- From: Blunt, James H (Jim) [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 4:54 PM To: Exchange Discussions Subject: RE: Directory Export It's not Excel doing it...I opened it in Notepad and the leading zeroes are still missing. -Original Message- From: Daniel Chenault [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:50 PM To: Exchange Discussions Subject: Re: Directory Export Yes, Excel has a tendency to do that to leading 0's. Open it with notepad or your favorite text editor/viewer - something that just reads the raw datastream without trying to interpret it. - Original Message - From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> To: "Exchange Discussions" <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 4:46 PM Subject: RE: Directory Export > Daniel, > > 100% sure? No... > > I'm using Excel 2002, SP1 > > -Original Message- > From: Daniel Chenault [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 2:42 PM > To: Exchange Discussions > Subject: Re: Directory Export > > > Are you sure it's export dropping the leading zeros? What are you using to > view the data? > > - Original Message - > From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> > To: "Exchange Discussions" <[EMAIL PROTECTED]> > Sent: Friday, February 22, 2002 3:18 PM > Subject: Directory Export > > > > Exchange 5.5, SP4 + hotfixes. > > > > When doing a directory export, we have a field titled Employee-Number (not > > sure if this is a standard field or a custom one). This field is bounced > > against the HR database to ensure no dupes and to update location data. > > Some people's location data is not updating. Since this field is required > > for this function, I exported the data to a .csv file and was checking it. > > However, what I noticed is that I have anywhere from 3-digit numbers to > > 7-digit numbers, because the export is dropping the leading zeroes. Is > > there any way to force the export to export all 7 digits, even if they are > > leading zeroes? > > > > Thanks, > > > > Jim Blunt > > > > _ > > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > > Archives: http://www.swynk.com/sitesearch/search.asp > > To unsubscribe: mailto:[EMAIL PROTECTED] > > Exchange List admin:[EMAIL PROTECTED] > > > > _ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe: mailto:[EMAIL PROTECTED] > Exchange List admin:[EMAIL PROTECTED] > > _ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe: mailto:[EMAIL PROTECTED] > Exchange List admin:[EMAIL PROTECTED] > _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
Re: Directory Export
Well, then, I guess it IS Exchange doing it. You'll have to contact MS about it then. - Original Message - From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> To: "Exchange Discussions" <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 4:54 PM Subject: RE: Directory Export > It's not Excel doing it...I opened it in Notepad and the leading zeroes are > still missing. > > -Original Message- > From: Daniel Chenault [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 2:50 PM > To: Exchange Discussions > Subject: Re: Directory Export > > > Yes, Excel has a tendency to do that to leading 0's. Open it with notepad or > your favorite text editor/viewer - something that just reads the raw > datastream without trying to interpret it. > > - Original Message - > From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> > To: "Exchange Discussions" <[EMAIL PROTECTED]> > Sent: Friday, February 22, 2002 4:46 PM > Subject: RE: Directory Export > > > > Daniel, > > > > 100% sure? No... > > > > I'm using Excel 2002, SP1 > > > > -Original Message- > > From: Daniel Chenault [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 22, 2002 2:42 PM > > To: Exchange Discussions > > Subject: Re: Directory Export > > > > > > Are you sure it's export dropping the leading zeros? What are you using to > > view the data? > > > > - Original Message - > > From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> > > To: "Exchange Discussions" <[EMAIL PROTECTED]> > > Sent: Friday, February 22, 2002 3:18 PM > > Subject: Directory Export > > > > > > > Exchange 5.5, SP4 + hotfixes. > > > > > > When doing a directory export, we have a field titled Employee-Number > (not > > > sure if this is a standard field or a custom one). This field is > bounced > > > against the HR database to ensure no dupes and to update location data. > > > Some people's location data is not updating. Since this field is > required > > > for this function, I exported the data to a .csv file and was checking > it. > > > However, what I noticed is that I have anywhere from 3-digit numbers to > > > 7-digit numbers, because the export is dropping the leading zeroes. Is > > > there any way to force the export to export all 7 digits, even if they > are > > > leading zeroes? > > > > > > Thanks, > > > > > > Jim Blunt > > > > > > _ > > > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > > > Archives: http://www.swynk.com/sitesearch/search.asp > > > To unsubscribe: mailto:[EMAIL PROTECTED] > > > Exchange List admin:[EMAIL PROTECTED] > > > > > > > _ > > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > > Archives: http://www.swynk.com/sitesearch/search.asp > > To unsubscribe: mailto:[EMAIL PROTECTED] > > Exchange List admin:[EMAIL PROTECTED] > > > > _ > > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > > Archives: http://www.swynk.com/sitesearch/search.asp > > To unsubscribe: mailto:[EMAIL PROTECTED] > > Exchange List admin:[EMAIL PROTECTED] > > > > _ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe: mailto:[EMAIL PROTECTED] > Exchange List admin:[EMAIL PROTECTED] > > _ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe: mailto:[EMAIL PROTECTED] > Exchange List admin:[EMAIL PROTECTED] > _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: Directory Export
Did you open the csv file with notepad _after_ you'd opened it with excel? If so, excel probably stripped (not just suppressed) the leading zeroes, so that's why they weren't there in notepad. Try re-exporting and opening with notepad first. -Original Message- From: Blunt, James H (Jim) [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 4:54 PM To: Exchange Discussions Subject: RE: Directory Export It's not Excel doing it...I opened it in Notepad and the leading zeroes are still missing. -Original Message- From: Daniel Chenault [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:50 PM To: Exchange Discussions Subject: Re: Directory Export Yes, Excel has a tendency to do that to leading 0's. Open it with notepad or your favorite text editor/viewer - something that just reads the raw datastream without trying to interpret it. - Original Message - From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> To: "Exchange Discussions" <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 4:46 PM Subject: RE: Directory Export > Daniel, > > 100% sure? No... > > I'm using Excel 2002, SP1 > > -Original Message- > From: Daniel Chenault [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 2:42 PM > To: Exchange Discussions > Subject: Re: Directory Export > > > Are you sure it's export dropping the leading zeros? What are you using to > view the data? > > - Original Message - > From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> > To: "Exchange Discussions" <[EMAIL PROTECTED]> > Sent: Friday, February 22, 2002 3:18 PM > Subject: Directory Export > > > > Exchange 5.5, SP4 + hotfixes. > > > > When doing a directory export, we have a field titled Employee-Number (not > > sure if this is a standard field or a custom one). This field is bounced > > against the HR database to ensure no dupes and to update location data. > > Some people's location data is not updating. Since this field is required > > for this function, I exported the data to a .csv file and was checking it. > > However, what I noticed is that I have anywhere from 3-digit numbers to > > 7-digit numbers, because the export is dropping the leading zeroes. Is > > there any way to force the export to export all 7 digits, even if they are > > leading zeroes? > > > > Thanks, > > > > Jim Blunt > > > > _ > > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > > Archives: http://www.swynk.com/sitesearch/search.asp > > To unsubscribe: mailto:[EMAIL PROTECTED] > > Exchange List admin:[EMAIL PROTECTED] > > > > _ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe: mailto:[EMAIL PROTECTED] > Exchange List admin:[EMAIL PROTECTED] > > _ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe: mailto:[EMAIL PROTECTED] > Exchange List admin:[EMAIL PROTECTED] > _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
Re: Directory Export
Maybe if you turn up the contrast you can see them. Sorry couldn't resist. What happens if you were to import just one of the records back. Do the zeros reappear? - Original Message - From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> To: "Exchange Discussions" <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 5:54 PM Subject: RE: Directory Export > It's not Excel doing it...I opened it in Notepad and the leading zeroes are > still missing. > > -Original Message- > From: Daniel Chenault [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 2:50 PM > To: Exchange Discussions > Subject: Re: Directory Export > > > Yes, Excel has a tendency to do that to leading 0's. Open it with notepad or > your favorite text editor/viewer - something that just reads the raw > datastream without trying to interpret it. > > - Original Message - > From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> > To: "Exchange Discussions" <[EMAIL PROTECTED]> > Sent: Friday, February 22, 2002 4:46 PM > Subject: RE: Directory Export > > > > Daniel, > > > > 100% sure? No... > > > > I'm using Excel 2002, SP1 > > > > -Original Message- > > From: Daniel Chenault [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 22, 2002 2:42 PM > > To: Exchange Discussions > > Subject: Re: Directory Export > > > > > > Are you sure it's export dropping the leading zeros? What are you using to > > view the data? > > > > - Original Message - > > From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> > > To: "Exchange Discussions" <[EMAIL PROTECTED]> > > Sent: Friday, February 22, 2002 3:18 PM > > Subject: Directory Export > > > > > > > Exchange 5.5, SP4 + hotfixes. > > > > > > When doing a directory export, we have a field titled Employee-Number > (not > > > sure if this is a standard field or a custom one). This field is > bounced > > > against the HR database to ensure no dupes and to update location data. > > > Some people's location data is not updating. Since this field is > required > > > for this function, I exported the data to a .csv file and was checking > it. > > > However, what I noticed is that I have anywhere from 3-digit numbers to > > > 7-digit numbers, because the export is dropping the leading zeroes. Is > > > there any way to force the export to export all 7 digits, even if they > are > > > leading zeroes? > > > > > > Thanks, > > > > > > Jim Blunt > > > > > > _ > > > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > > > Archives: http://www.swynk.com/sitesearch/search.asp > > > To unsubscribe: mailto:[EMAIL PROTECTED] > > > Exchange List admin:[EMAIL PROTECTED] > > > > > > > _ > > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > > Archives: http://www.swynk.com/sitesearch/search.asp > > To unsubscribe: mailto:[EMAIL PROTECTED] > > Exchange List admin:[EMAIL PROTECTED] > > > > _ > > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > > Archives: http://www.swynk.com/sitesearch/search.asp > > To unsubscribe: mailto:[EMAIL PROTECTED] > > Exchange List admin:[EMAIL PROTECTED] > > > > _ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe: mailto:[EMAIL PROTECTED] > Exchange List admin:[EMAIL PROTECTED] > > _ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe: mailto:[EMAIL PROTECTED] > Exchange List admin:[EMAIL PROTECTED] > _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: Directory Export
It's not Excel doing it...I opened it in Notepad and the leading zeroes are still missing. -Original Message- From: Daniel Chenault [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:50 PM To: Exchange Discussions Subject: Re: Directory Export Yes, Excel has a tendency to do that to leading 0's. Open it with notepad or your favorite text editor/viewer - something that just reads the raw datastream without trying to interpret it. - Original Message - From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> To: "Exchange Discussions" <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 4:46 PM Subject: RE: Directory Export > Daniel, > > 100% sure? No... > > I'm using Excel 2002, SP1 > > -Original Message- > From: Daniel Chenault [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 2:42 PM > To: Exchange Discussions > Subject: Re: Directory Export > > > Are you sure it's export dropping the leading zeros? What are you using to > view the data? > > - Original Message - > From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> > To: "Exchange Discussions" <[EMAIL PROTECTED]> > Sent: Friday, February 22, 2002 3:18 PM > Subject: Directory Export > > > > Exchange 5.5, SP4 + hotfixes. > > > > When doing a directory export, we have a field titled Employee-Number (not > > sure if this is a standard field or a custom one). This field is bounced > > against the HR database to ensure no dupes and to update location data. > > Some people's location data is not updating. Since this field is required > > for this function, I exported the data to a .csv file and was checking it. > > However, what I noticed is that I have anywhere from 3-digit numbers to > > 7-digit numbers, because the export is dropping the leading zeroes. Is > > there any way to force the export to export all 7 digits, even if they are > > leading zeroes? > > > > Thanks, > > > > Jim Blunt > > > > _ > > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > > Archives: http://www.swynk.com/sitesearch/search.asp > > To unsubscribe: mailto:[EMAIL PROTECTED] > > Exchange List admin:[EMAIL PROTECTED] > > > > _ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe: mailto:[EMAIL PROTECTED] > Exchange List admin:[EMAIL PROTECTED] > > _ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe: mailto:[EMAIL PROTECTED] > Exchange List admin:[EMAIL PROTECTED] > _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
Re: Directory Export
Yes, Excel has a tendency to do that to leading 0's. Open it with notepad or your favorite text editor/viewer - something that just reads the raw datastream without trying to interpret it. - Original Message - From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> To: "Exchange Discussions" <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 4:46 PM Subject: RE: Directory Export > Daniel, > > 100% sure? No... > > I'm using Excel 2002, SP1 > > -Original Message- > From: Daniel Chenault [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 2:42 PM > To: Exchange Discussions > Subject: Re: Directory Export > > > Are you sure it's export dropping the leading zeros? What are you using to > view the data? > > - Original Message - > From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> > To: "Exchange Discussions" <[EMAIL PROTECTED]> > Sent: Friday, February 22, 2002 3:18 PM > Subject: Directory Export > > > > Exchange 5.5, SP4 + hotfixes. > > > > When doing a directory export, we have a field titled Employee-Number (not > > sure if this is a standard field or a custom one). This field is bounced > > against the HR database to ensure no dupes and to update location data. > > Some people's location data is not updating. Since this field is required > > for this function, I exported the data to a .csv file and was checking it. > > However, what I noticed is that I have anywhere from 3-digit numbers to > > 7-digit numbers, because the export is dropping the leading zeroes. Is > > there any way to force the export to export all 7 digits, even if they are > > leading zeroes? > > > > Thanks, > > > > Jim Blunt > > > > _ > > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > > Archives: http://www.swynk.com/sitesearch/search.asp > > To unsubscribe: mailto:[EMAIL PROTECTED] > > Exchange List admin:[EMAIL PROTECTED] > > > > _ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe: mailto:[EMAIL PROTECTED] > Exchange List admin:[EMAIL PROTECTED] > > _ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe: mailto:[EMAIL PROTECTED] > Exchange List admin:[EMAIL PROTECTED] > _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: Directory Export
Daniel, 100% sure? No... I'm using Excel 2002, SP1 -Original Message- From: Daniel Chenault [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:42 PM To: Exchange Discussions Subject: Re: Directory Export Are you sure it's export dropping the leading zeros? What are you using to view the data? - Original Message - From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> To: "Exchange Discussions" <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 3:18 PM Subject: Directory Export > Exchange 5.5, SP4 + hotfixes. > > When doing a directory export, we have a field titled Employee-Number (not > sure if this is a standard field or a custom one). This field is bounced > against the HR database to ensure no dupes and to update location data. > Some people's location data is not updating. Since this field is required > for this function, I exported the data to a .csv file and was checking it. > However, what I noticed is that I have anywhere from 3-digit numbers to > 7-digit numbers, because the export is dropping the leading zeroes. Is > there any way to force the export to export all 7 digits, even if they are > leading zeroes? > > Thanks, > > Jim Blunt > > _ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe: mailto:[EMAIL PROTECTED] > Exchange List admin:[EMAIL PROTECTED] > _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
Re: Directory Export
Are you sure it's export dropping the leading zeros? What are you using to view the data? - Original Message - From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> To: "Exchange Discussions" <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 3:18 PM Subject: Directory Export > Exchange 5.5, SP4 + hotfixes. > > When doing a directory export, we have a field titled Employee-Number (not > sure if this is a standard field or a custom one). This field is bounced > against the HR database to ensure no dupes and to update location data. > Some people's location data is not updating. Since this field is required > for this function, I exported the data to a .csv file and was checking it. > However, what I noticed is that I have anywhere from 3-digit numbers to > 7-digit numbers, because the export is dropping the leading zeroes. Is > there any way to force the export to export all 7 digits, even if they are > leading zeroes? > > Thanks, > > Jim Blunt > > _ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe: mailto:[EMAIL PROTECTED] > Exchange List admin:[EMAIL PROTECTED] > _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: directory export and import
Sure, add in a column to the header.csv named "Owner" without the quotes.
Then run the export to the header.csv file.
This will extract the required information if it exists.
Kind Regards,
Allan.
Allan Drummy
Exchange Infrastructure Architect
Email: [EMAIL PROTECTED]
-Original Message-
From: Green, Jacky {IT~Welwyn} [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2002 12:04
To: Drummy, Allan
Subject: RE: directory export and import
Hi Allan,
many thanks, although I still can't export the owner of a distribution
list... Do you know how I could do this?
best regards,
Jacky
[EMAIL PROTECTED]
-Original Message-
From: Drummy, Allan [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2002 11:55
To: '[EMAIL PROTECTED]'
Subject: directory export and import
Hi,
This should help.
Kind Regards,
Allan.
Allan Drummy
Exchange Infrastructure Architect
Email: [EMAIL PROTECTED]
-Original Message-
From: Green, Jacky {IT~Welwyn} [ mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> ]
Sent: 28 January 2002 16:12
To: Exchange Discussions
Subject: directory export and import
Hello,
Can anyone tell me where I can find a definitive list of headers for
creating a CSV export file for Exchange? Or even where I might download
some examples, or header.exe (which should be on the resource kit, but I
cannot locate a copy anywhere).
Many thanks in advance for your help.
Jacky Green
[EMAIL PROTECTED]
_
List posting FAQ: http://www.swinc.com/resource/exch_faq.htm
Archives: http://www.swynk.com/sitesearch/search.asp
To unsubscribe: mailto:[EMAIL PROTECTED]
Exchange List admin:[EMAIL PROTECTED]
RE: directory export and import
I can send you the header.csv file if you like. It's the one generated by
header.exe.
Kind Regards,
Allan.
Allan Drummy
Exchange Infrastructure Architect
Email: [EMAIL PROTECTED]
-Original Message-
From: Mark Harford [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2002 10:22
To: Exchange Discussions
Subject: RE: directory export and import
Exchange Admin in raw mode?
-Original Message-
From: Green, Jacky {IT~Welwyn} [mailto:[EMAIL PROTECTED]]
Sent: 28 January 2002 16:12
To: Exchange Discussions
Subject: directory export and import
Hello,
Can anyone tell me where I can find a definitive list of headers for
creating a CSV export file for Exchange? Or even where I might download
some examples, or header.exe (which should be on the resource kit, but I
cannot locate a copy anywhere).
Many thanks in advance for your help.
Jacky Green
[EMAIL PROTECTED]
_
List posting FAQ: http://www.swinc.com/resource/exch_faq.htm
Archives: http://www.swynk.com/sitesearch/search.asp
To unsubscribe: mailto:[EMAIL PROTECTED]
Exchange List admin:[EMAIL PROTECTED]
This e-mail (and any attachments) is confidential and may contain personal
views which are not the views of the BBC unless specifically stated.
If you have received it in error, please delete it from your system, do not
use,
copy or disclose the information in any way nor act in reliance on it and
notify
the sender immediately. Please note that the BBC monitors e-mails sent
or received. Further communication will signify your consent to this.
_
List posting FAQ: http://www.swinc.com/resource/exch_faq.htm
Archives: http://www.swynk.com/sitesearch/search.asp
To unsubscribe: mailto:[EMAIL PROTECTED]
Exchange List admin:[EMAIL PROTECTED]
_
List posting FAQ: http://www.swinc.com/resource/exch_faq.htm
Archives: http://www.swynk.com/sitesearch/search.asp
To unsubscribe: mailto:[EMAIL PROTECTED]
Exchange List admin:[EMAIL PROTECTED]
RE: directory export and import
Exchange Admin in raw mode?
-Original Message-
From: Green, Jacky {IT~Welwyn} [mailto:[EMAIL PROTECTED]]
Sent: 28 January 2002 16:12
To: Exchange Discussions
Subject: directory export and import
Hello,
Can anyone tell me where I can find a definitive list of headers for
creating a CSV export file for Exchange? Or even where I might download
some examples, or header.exe (which should be on the resource kit, but I
cannot locate a copy anywhere).
Many thanks in advance for your help.
Jacky Green
[EMAIL PROTECTED]
_
List posting FAQ: http://www.swinc.com/resource/exch_faq.htm
Archives: http://www.swynk.com/sitesearch/search.asp
To unsubscribe: mailto:[EMAIL PROTECTED]
Exchange List admin:[EMAIL PROTECTED]
This e-mail (and any attachments) is confidential and may contain personal
views which are not the views of the BBC unless specifically stated.
If you have received it in error, please delete it from your system, do not use,
copy or disclose the information in any way nor act in reliance on it and notify
the sender immediately. Please note that the BBC monitors e-mails sent
or received. Further communication will signify your consent to this.
_
List posting FAQ: http://www.swinc.com/resource/exch_faq.htm
Archives: http://www.swynk.com/sitesearch/search.asp
To unsubscribe: mailto:[EMAIL PROTECTED]
Exchange List admin:[EMAIL PROTECTED]
RE: directory export and import
I believe header.exe is on the Exchange 5.5 Server CD, at least it is on
mine. If this is E2K, that's a whole other kettle of fish.
-Original Message-
From: Green, Jacky {IT~Welwyn}
To: Exchange Discussions
Sent: 1/28/2002 10:12 AM
Subject: directory export and import
Hello,
Can anyone tell me where I can find a definitive list of headers for
creating a CSV export file for Exchange? Or even where I might download
some examples, or header.exe (which should be on the resource kit, but I
cannot locate a copy anywhere).
Many thanks in advance for your help.
_
List posting FAQ: http://www.swinc.com/resource/exch_faq.htm
Archives: http://www.swynk.com/sitesearch/search.asp
To unsubscribe: mailto:[EMAIL PROTECTED]
Exchange List admin:[EMAIL PROTECTED]
RE: directory export and import
So locate or buy a copy of the Back Office Resource Kit. If you have
TechNet or MSDN, it comes with that too.
Ed Crowley MCSE+I MVP
Tech Consultant
Compaq Computer
"There are seldom good technological solutions to behavioral problems."
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Green, Jacky
{IT~Welwyn}
Sent: Monday, January 28, 2002 8:12 AM
To: Exchange Discussions
Subject: directory export and import
Hello,
Can anyone tell me where I can find a definitive list of headers for
creating a CSV export file for Exchange? Or even where I might download
some examples, or header.exe (which should be on the resource kit, but I
cannot locate a copy anywhere).
Many thanks in advance for your help.
Jacky Green
[EMAIL PROTECTED]
_
List posting FAQ: http://www.swinc.com/resource/exch_faq.htm
Archives: http://www.swynk.com/sitesearch/search.asp
To unsubscribe: mailto:[EMAIL PROTECTED]
Exchange List admin:[EMAIL PROTECTED]
_
List posting FAQ: http://www.swinc.com/resource/exch_faq.htm
Archives: http://www.swynk.com/sitesearch/search.asp
To unsubscribe: mailto:[EMAIL PROTECTED]
Exchange List admin:[EMAIL PROTECTED]
RE: Directory Export Options File
You can schedule a batch a job to perform an "admin /e" if that's what you're asking. Ed Crowley MCSE+Internet MVP Tech Consultant Compaq Computer Corporation (soon to be HP) All your base are belong to us. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Badstuber Roman Sent: Monday, November 19, 2001 5:37 AM To: Exchange Discussions Subject: Directory Export Options File Hi! It is possible to export from the global Addresslist if I use the nice Exporttool from the Exchangeadmin. How can I perform this Action automatically with an Directory Export Options File - if yes what is the RDN from the Global Address List. Thanx for helping Roman _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
