Excel LDAP Search

Description

ELS can be used to add LDAP data to existing data in an Excel document on a row-by-row basis (see Figure 1), or populate a blank sheet based on a custom query.Limitations: ELS was designed for a fairly basic LDAP environment. Some features that are (currently) not supported are SSL, certificate authentication, and referral following.I put together a couple of flash demo movies that show typical ELS usage for a running a query to fill in a blank Excel sheet and for adding new row data to existing Excel entries:RequirementsI've tested querying OpenLDAP and Active Directory with the following: * Windows XP o Excel 2003 o Excel 2007 * Windows 2000 o Excel 2000 * Windows Vista o untestedIt uses the Mozilla LDAP SDK so it should work with any LDAP-v3 compliant directory server, and Excel 2000 (97?) to 2007. If ELS doesn't work with your directory server, please click here to submit a bug report online. It takes all of 30 seconds, and you can help out the next person who'd encounter the same problem as you.Installation InstructionsMake sure all instances of Excel are closed.Run the excelldapsearchinstall_x_y.exe file. This will copy the necessary files, and register everything with the system. It also opens up the config file where you can specify your connection parameters.If you have multiple versions of Excel installed, only the latest will have the Tools menu item registered. To manually enable it in an older version, use that version to open the "ldapquery_addin.xla" document in the directory where Excel LDAP Search was installed. Press ALT-F11 to enter the macro editor and select the "ldapquery_addin.xla" project from the project explorer (if the project explorer isn't displayed, look under the "View" menu). Expand the "Modules" item and doubleclick "ldapQueryFormMacro". Look for the "Sub AddToolsMenuItem()" line, click anywhere on it with the mouse, then from the menu bar select "Run->Run Sub/User Form" or click the toolbar button with the play icon.Known IssuesOn some systems, the error message "Compile error: Can't find project or library" will be displayed. This indicates Excel is referencing a module that doesn't exist. The solution is to start the macro editor by pressing ALT-F11, then open the "Tools" menu and select "References...". If the "References..." item is greyed out, reset the project first by click the stop icon on the toolbar, or under the "Run" menu there's a "reset" item. Look for any checked items in the list that start with "MISSING:" and uncheck them. Click the "OK" button and close the macro editor. This process is also described in Microsoft KB208218.Uninstall InstructionsMake sure all instances of Excel are closedRemove via Control Panel->Add/Remove Programs.If you manually added the Tools "Run LDAP Search" menu item to more than one version of Excel, you can remove it by clicking "Tools->Customize...", then opening the Tools menu again and dragging the menu item off.UsageAfter install, fire up Excel and take a peek under the "Tools" menu. There should be a "Run LDAP Search" menu item now. Click that to bring up the search GUI.Excel 2007 users - since there is no "Tools" menu in 2007, this ends up showing up in the "Add Ins" ribbon bar thingy, but seems to work just fine. * Adding LDAP Data to Existing Excel DataThe default option is to "Add LDAP data to existing rows" which requires a column of data where each row has an item that uniquely identfies a user (ex., a column of user IDs or e-mail addresses). If you want to get more information (ex., a mailing address or the user's full name) for each row from your directory server, set the column as the "data range" in step 1). Excel LDAP Search Version 0.56 README. Excel LDAP Search is an Excel add-in that allows LDAP data to be imported to Excel spreadsheets

Import - Search - Excel - Spreadsheet - Ldap - Directory Server

Published By:Paul Brinkmann

License Type:Freeware

Date Added:16 May, 2011

Version:0.56

Price:Free

Downloads:41

Size:716.8 KB

Platform: Win Vista/2000/2003/XP

What people say
- required fields
     
Related Downloads

1st Subscription Manager - is a simplest, way to extract business emails from your regular POP 3 mailbox.

DateSep 25, 2014

AuthorEmailarms

Size:624.0 KB

LicenseFreeware

Price:Free

PlatformWin98, WinME, WinNT 3.x, WinNT 4.x

CategoryE-Mail List Management

1st Subscription Manager

AceMoney makes it easy to manage a checkbook, create and manage budgets, juggle finances in multiple currencies, track spending habits, record expenses, transfer among accounts, and even do on-line banking.

DateSep 25, 2014

AuthorMechCAD Software

Size:2.5 MB

LicenseFreeware

Price:Free

PlatformWin95, Win98, WinME, WinNT 4.x

CategoryPersonal Finance

AceMoney makes it easy to manage multiple accounts of different types, create and manage budgets, juggle finances in multiple currencies, track spending habits, record expenses, transfer among accounts, and do on-line banking.

DateSep 25, 2014

AuthorMechCAD Software

Size:2.5 MB

LicenseShareware

Price:$30.00

PlatformWin95, Win98, WinME, WinNT 4.x

CategoryPersonal Finance

AceMoney

Advanced Emailer is intended for sending electronic mail utilizing mailing lists. It is a great tool for anyone who needs to send information/notifications to a large number of recipients.

DateSep 25, 2014

AuthorEmailarms

Size:2.0 MB

LicenseShareware

Price:$69.00

PlatformWin98, WinME, WinNT 3.x, WinNT 4.x

CategoryE-Mail Clients

Advanced Emailer

Plan things to do in a calendar.. Sobolsoft. Batch shareware applications for Windows.

DateSep 25, 2014

AuthorSobolsoft

Size:757.0 KB

LicenseShareware

Price:$19.99

PlatformWin2000, Win95, Win98, WinME

CategoryMisc Applications

Appointment Calendar Software