ldap with excel Code
Status: Beta
Brought to you by:
jeonwoosung
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 |
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