[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference chefs::ms-exchange

Title:Microsoft Exchange Server
Notice:
Moderator:FLASK2::SYSTEM
Created:Fri Feb 17 1995
Last Modified:Thu Jun 05 1997
Last Successful Update:Thu Jun 05 1997
Number of topics:1099
Total number of notes:5174

999.0. "Exchange Import, Modify, Remove Value Problem" by GOBUCS::COOLEY (Megan and Michelle's Daddy) Fri Apr 11 1997 20:02

I'm having trouble w/ the Exchange IMPORT utility to Modify directory entries.

It seems that to remove a value for a field that was previously added, 
the value for the field must be " " (as opposed to no value).

This works fine, I guess, for most fields.  (I consider it a bug)
However, for the Secondary-Proxy-Addresses field, I cannot figure out 
how to modify the value in this field to remove these values.  

Anyone know who to do it or is this a Microsoft Bug?  
I using V5 but I also reproduced the problem on V4.

Here's my command line:

	D:\exchsrvr\bin\admin /i import_site.dat /n /o import_site_opt.txt

Here's my option file: (import_site_opt.txt)

	[Import]
	Container="Recipients"
	ColumnSeparator=09
	InformationalLevel=Full

Here's my import file: (import_site.dat - <CR>'s inserted for readability)

Obj-class	Mode	Obj-Container	Alias Name
	First Name	Initials	Last Name	Display Name	Title
	Directory Name	Primary Windows NT Account	Home-Server	
	E-mail Addresses
	Secondary-Proxy-Addresses
Mailbox	Modify	Recipients	cooley
	Warren	J	Cooley	Cooley, Warren J	mytitle
	cooley	NTDOMAIN\NTACCT	SERVER-NAME	
	MS:LMCO/SITE/cooley%SMTP:[email protected]%X400:C=us; A=attmail; P=lmco; G=Warren; i=J; S=Cooley
	MIGRATE:CCMAIL:Cooley, Warren J at CCMAIL-PO

So, If I want to modify the entry to remove the mytitle, I have to do:

Mailbox	Modify	Recipients	cooley
	Warren	J	Cooley	Cooley, Warren J	" "
	cooley	NTDOMAIN\NTACCT	SERVER-NAME	
	MS:LMCO/SITE/cooley%SMTP:[email protected]%X400:C=us; A=attmail; P=lmco; G=Warren; i=J; S=Cooley
	MIGRATE:CCMAIL:Cooley, Warren J at CCMAIL-PO

But, When I want to remove the Secondary-Proxy-Addresses, I can't seem to
figure out what to do???  This doesn't work:

Mailbox	Modify	Recipients	cooley
	Warren	J	Cooley	Cooley, Warren J	" "
	cooley	NTDOMAIN\NTACCT	SERVER-NAME	
	MS:LMCO/SITE/cooley%SMTP:[email protected]%X400:C=us; A=attmail; P=lmco; G=Warren; i=J; S=Cooley
	" "
T.RTitleUserPersonal
Name		DateLines
999.1~DELGOBUCS::COOLEYMegan and Michelle&#039;s DaddyFri Apr 11 1997 20:5643
    FOUND IT!  A  ~DEL  needs to be specified to remove a value from a field.
    Why didn't I think of that? :-)
    
    I got this under http://www.microsoft.com/kb/articles/Q152/8/54.htm
    
                   XADM: Using Bulk Import to Remove Data

                   Article ID: Q152854
                   Creation Date: 25-JUN-1996
                   Revision Date: 24-OCT-1996

                   The information in this article applies to:

                      * Microsoft Exchange Server, version 4.0

                   SUMMARY

                   This article explains how to use the Bulk Import
                   functionality of the Microsoft Exchange Administrator
                   program to remove data from specific fields of the user
                   properties.

                   MORE INFORMATION

                   To remove data from specific fields, use ~DEL as the
                   value of that field in the import file (.CSV file).
                   When the Import is performed, the data in the fields
                   with ~DEL as the value will be removed.

                   For example, say the Office field for each user needed
                   to be cleared out. The following import file shows how
                   this can be done.

                   Obj-Class, Directory Name, Office 
    		   Mailbox, Admin, ~DEL
                   Mailbox, User1, ~DEL
    		   Mailbox, User2, ~DEL

        ------------------------------------------------------------
                            KBCategory: kbusage
                            KBSubcategory: XADM
                      Additional reference words: 4.00
999.2OGOPW1::tunsrv2-tunnel.imc.das.dec.com::michaelw[email protected]Sun Apr 13 1997 07:4513
the only thing I can think of is APPEND vs OVERWRITE.

If you are in appending, it would never kill off the existing
value.

If you're overwriting, it takes what you have provided as the 
sum total of data for that field.

[email protected]

Tal.
999.3Another non-obvious (to me anyway) optionGOBUCS::COOLEYMegan and Michelle&#039;s DaddyWed Apr 16 1997 21:539
    You are right. In addition to using ~DEL, a continual process which
    imports all the information for a directory entry to exchange should
    have:
    
    OverwriteProperties=Yes
    
    in the options file.  The default is No.
    
    Warren