Menu

Tree [r1] /
 History

HTTPS access


File Date Author Commit
 .settings 2009-03-08 jeonwoosung [r1] #1 first import after create project
 bin 2009-03-08 jeonwoosung [r1] #1 first import after create project
 lib 2009-03-08 jeonwoosung [r1] #1 first import after create project
 src 2009-03-08 jeonwoosung [r1] #1 first import after create project
 .classpath 2009-03-08 jeonwoosung [r1] #1 first import after create project
 .project 2009-03-08 jeonwoosung [r1] #1 first import after create project
 exp.bat 2009-03-08 jeonwoosung [r1] #1 first import after create project
 imp.bat 2009-03-08 jeonwoosung [r1] #1 first import after create project
 readme.txt 2009-03-08 jeonwoosung [r1] #1 first import after create project
 사용법.txt 2009-03-08 jeonwoosung [r1] #1 first import after create project

Read Me

finally I made a progrom which can import by excel file(.xls)

There are two programs
one of them is export tool
the other is import tool 

1. configure a program 
	I'm gonna describe how use this program 
	
	edit bin/ldap.properties 
	I think it's really easy to edit so you can without any explaining
	(HINT. you don't need to edit filter and INITCTX) 
	
	If you can't, send me a mail.(jeonwoosung@gmail.com)

2. export from ldap 
	execute exp.bat [filename] 
	If you don't specify filename, it will make "worksheet.xls"
	If there's object attribute, it filled as <object>
	
3. import from xls
	execute imp.bat [filename]
	If you don't specify filename, it will read from "c:\worksheet.xls"
	If there are any problem while processing it will be recorded in _status column   
	
4. about excelfile
	When you export excelfile from ldap, there are some columns 
	some of columns are attribute of entry 
	but the others is made for import.
	
	now there are two columns for import '_operation' and '_status'
	
	If you want any operate with any entry. you have to put in "_operation" field.
	'modify','add','delete'
	
	If you want to add entry, put 'add' in '_operation' field and fill the other fields  
	If you fill most field correctly, It will be added 
	¡Ø please fill must fields
	
	If you want to delete entry put 'delete' in '_operation' and just put dn

	lastly If you want to modify, export first and put 'modify' in '_operation' and modify value of attribute 
        If you want to delete attribute in a entry, you can put '<delete>' at that attribute