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