

TITLE:  LDIF file generator reading from Microsoft Excelsheets

README FOR:  excel2ldif.exe

NOVELL PRODUCTS and VERSIONS:
eDirectory 8.5 for Windows NT/2000 - ED85

ABSTRACT:

The generator tool reads the records from an excel sheet and generates a LDIF format
to be used later to create/modify/delete NDS objects.


DISCLAIMER
----------
     THIS UTILITY IS SUPPLIED "AS IS".  THE AUTHOR DISCLAIMS ALL WARRANTIES,
     EXPRESSED OR  IMPLIED,  INCLUDING, WITHOUT  LIMITATION, THE  WARRANTIES
     OF  MERCHANTABILITY AND OF FITNESS FOR ANY PURPOSE.  THE AUTHOR ASSUMES
     NO  LIABILITY  FOR  DAMAGES, DIRECT OR  CONSEQUENTIAL, WHICH MAY RESULT
     FROM THE USE OF THIS PRODUCT.


INTRODUCTION

Excel2LDIF is an utility targeting users who are less familiar with the generation of 
LDIF scripts to perform bulf load/modify/delete of users/groups in NDS. Normally
end users might have the user/group profile information in an Excelsheet.

With some simple configuration the utility helps a good deal in generating 
huge LDIF scripts which can be later run on NDS server to create the objects.


INSTALLATION AND RUNNING INSTRUCTIONS:

1. CREATION OF DATA SOURCE 


	A data source has to be created pointing to the actual excel sheet that 
	has the records defined.

	Go to Start -> Programs -> Administrative Tools -> Data Sources (ODBC)
	
	Select System DSN -> Add -> Select Microsoft Excel Driver -> Finish.
	
	For Data Source Name specify anything you desire.(Remember to specify the
	same name in the configuration file)
	
	Click on Select Workbook, browse and select the physical Excel file. Click OK to
	finish the data source setup.



2. EXCEL WORKSHEET

	Please refer the sample worksheet provided for reference. Please feel free to add
	any of the valid variables that might best suit your requirements.

	Any new column (attribute) added in the worksheet should have a valid configuration
	specified in the configuration file.

	The action column specifies what type of action needs to be performed for the specific
	record. It can be either of the following values Add/Change/Delete.


3. CONFIGURATION FILE

	Provided is a sample.conf file . Please make the necessary changes carefully before 
	running the utility.

4. RUNNING Excel2LDIF Utility.

	Create and extract the  zip file containing the Utility.

	Edit the sample.conf and provide the correct specification.

	Edit the run.bat file to specify the correct path to the jar file
	
	Open a command prompt window and access the folder where the run.bat is located.
	Type the command ...

	run


-----------------------------------------------------------------
Any trademarks referenced in this document are the property of their respective
owners.  
-----------------------------------------------------------------

