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 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] > > > _________________________________________________________________ > 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]
