304 Lotus blogs updated hourly. Who will post next? Home | Downloads | Events | Jobs | Twitter | Bookmarks | Pods | Forum | Blogs | Search | myPL | About 
 
Latest 7 Posts
How does Quickr document versioning work?
Fri, Nov 28th 2008 55
What a mess at Babylon Ltd !
Fri, Nov 28th 2008 27
FormatFactory: a free and complete media converter
Sun, Nov 23rd 2008 64
Testing Lotus Traveler inside a Windows Mobile emulator
Sat, Nov 22nd 2008 66
Some Audacity with nsfdb2 (sound improving)
Tue, Nov 18th 2008 41
What was the first picture on the Web?
Thu, Nov 13th 2008 82
Pushing (too much) my Blackberry BES server?
Tue, Nov 11th 2008 159
Top 10
How many Notes/Domino developers in IBM?
Sun, Aug 17th 2008 215
Pimp your R8 sidebar (your customers will love it)
Sat, Oct 25th 2008 209
Pushing (too much) my Blackberry BES server?
Tue, Nov 11th 2008 159
We are late, Microsoft already did it....
Mon, May 19th 2008 158
Being a R8.0.2 beta 1 tester
Sun, Jul 13th 2008 141
Iron Man deals with LotusScript too
Sun, May 11th 2008 123
Do you need to access LDAP via LotusScript? 1/2
Sun, Jul 27th 2008 116
Upgrading your mailbox template with a R8 client
Tue, Jul 8th 2008 105
Is your company organization chart like this?
Fri, Oct 31st 2008 104
A simple and useful Firefox tip
Tue, Apr 8th 2008 95


Do you need to access LDAP via LotusScript? 1/2
Jul 27, 2008 4:07p
Hits 136
Link Love http://planetlotus.org/2cee0b
Category
Keywords domino ibm ldd lotus lotusscript lsx sametime java linux password server
Author

Recently I had to deal with a LDAP server using old beloved LotusScript language.

After some search I found the following free LotusScript extension (LSX) that is really useful for my needs:

LotusScript Directory Service for Windows

From the IBM Sandbox:
LotusScript Directory Service is a small LotusScript Extension utility which is developed for testing LDAP protocol in Domino 5.0. It provides a simple and direct access to LDAP protocol using LotusScript. It facilitates four LotusScript classes to manipulate basic LDAP protocol, including search directory, add, modify and delete operation. Further operations like compare and rename will be available soon in future implementation.

Here's a sample code from Robein Shi (IBM) written in 1999!

   1: Uselsx "lsxldap"


   2: Option Explicit


   3:  


   4:  


   5: Sub Initialize


   6:     


   7: '---------------------------------------------------------------- 


   8: ' Variable definition


   9: '


  10:     Dim session As LDAPSession


  11:     Dim search As  LDAPSearch


  12:     Dim result As  LDAPResultSet


  13:     Dim entry  As LDAPEntry


  14:     


  15:     Dim status As  Variant


  16:     Dim num As  Long


  17: '---------------------------------------------------------------


  18: ' Object instances


  19: '


  20:     Set session = New LDAPSession


  21:     Set search =  New LDAPSearch


  22:     Set result =  New LDAPResultSet


  23:     


  24: '--------------------------------------------------------------


  25: ' Connect to LDAP server


  26: ' 


  27:     session.dn = "cn=Cristian D'Aloisio,o=MyOrg,c=It"


  28:     session.password = "xxxx"


  29:     


  30:  'using anonymouse here


  31:     session.Host = "172.30.10.25"


  32:     Print "Connecting to..." , session.Host


  33:     


  34:     status = session.Connect


  35:     


  36:     If  status  Then


  37:         Print "Connected to ", session.Host


  38:     Else


  39:         Print "Can't connect to", session.Host


  40:         Exit Sub


  41:     End If


  42:     


  43:     


  44:     


  45: '------------------------------------------------------------


  46: ' Object instances


  47: '


  48:     Set search.Session = session


  49:     Set search.ResultSet = result


  50:     


  51: '-------------------------------------------------------------


  52: ' Perform a search - search specified entry


  53: '


  54:     search.filter = "(objectclass=*)"


  55:     search.base  = "cn=Cristian D'Aloisio,o=MyOrg,c=It"


  56:     search.scope  = LDAP_SCOPE_BASE


  57:     


  58:     status = search.Execute


  59:     Print "Search.Execute",   status


  60:     


  61:     num = result.count


  62:     Print "Result.count",  num


  63:     


  64: '-------------------------------------------------------------


  65: 'Iterate search result using LDAPResultSet.GetNextEntry


  66: '


  67:     ' Dim entry   As LDAPEntry


  68:     Dim attr_name  As String


  69:     Dim valuestr   As String


  70:     Dim avalue  As Variant


  71:     


  72:     


  73:     Set entry = result.GetFirstEntry()


  74:     


  75:     While Not (entry Is Nothing)


  76:   'print "DN=", entry.DN


  77:         


  78: '-------------------------------------------------------------


  79: 'Iterate all attributes of this entry using GetNextAttr


  80: '


  81:         attr_name = entry.getFirstAttr()


  82:         While Not (attr_name = "")


  83:             


  84: '-------------------------------------------------------------   


  85: 'Get an array of values from LDAPEntry.GetValue


  86: '


  87:             Dim i As Integer


  88:             


  89:             Print "Attribute: ", attr_name


  90:             avalue = entry.getValue(attr_name)


  91:             For i=Lbound(avalue) To Ubound(avalue) 


  92:                 Print ,, avalue(i)


  93:             Next


  94:             


  95:             attr_name = entry.getNextAttr()


  96:         Wend


  97:         


  98:         Set entry = result.GetNextEntry(entry)


  99:     Wend


 100:     


 101: '--------------------------------------------------------------


 102: 'Disconnect the session


 103:     


 104:     session.disconnect


 105:     


 106:     


 107: End Sub




 



Things I'm worried about that utility are:




  • it is a LSX written for the Windows OS, so I cannot use it on Linux;


  • it's a little bit old code, published in year 2000;


  • some users in the Sandox complain about some bugs (memory leaks, http crashes)




So what?

I wrote a small Java class, taking advantage of JNDI classes, to:


- connect to any LDAP server, using authentication ;


- get one specific (text) attribute (eg "cn") for a Distinguished Name (DN)





The Java class will be available in LotusScript via LS2J, I guess...





I know, that's really too little for a utility, but it's just the beginning ;-)





What I would like to add later to the Java class:

- reading any LDAP attribute, text or binary type, for a specific DN;





- writing some binary attribute, e.g. uploading images to a Domino LDAP server for Sametime contacts photos.. ( see previous Italian post )



Stay tuned...


Cristian D'Aloisio
Blog Title DominoBaloney
Blog Description IBM, Lotus Notes and Domino, Sametime, Quickplace/Quickr and more...
Blog URL http://dominobaloney.blogspot.com/
RSS Feed http://feeds.feedburner.com/Dominobaloney?format=xml
Validate Feed feedvalidator.org or validator.w3.org
Feed Last Checked Dec 01, 2008 11:52:52 PM EST. Realtime Update:
Twitter URLhttp://www.twitter.com/dominobaloney
Landed Here Dec 19, 2007
Location Bologna, ITALY
Posts: # / 1st / Latest 193 - Nov 03, 2007 - Nov 28, 2008
Total Hits 8,694. myPL RSS Selections: 34

Cristian D'Aloisio's Planet Lotus Keyword Cloud

R5 R6 R7 R8 acl admin administration adminp agent aix ajax apple application applications archive archiving bes blackberry bleedyellow blogSphere blogger bug collaboration community connect connections consulting database db2 dblookup designer desktop development document dojo domino dwa dxl eclipse email enterprise firefox forms formula foundations google ibm ideajam ideajam.net ilug inotes integration interface iphone java javascript laptop ldd linux lotus lotusdomino lotusnotes lotusphere lotusscript lsx mac microsoft mobile mysql network networking notes notes client nsd nsfdb2 ntf odbc ods office openoffice oracle outlook password pearl php planetlotus planetlotus.org podcast policies profile properties python quickplace quickr rich text richtext rim roaming sametime sap script library security server skype snmp sntt sql symphony system i template traveler ubuntu vista web 2.0 websphere widget widgets wiki wireless workspace xml


Total: 750 Average per Post: 3.8860

Blog Posts
55


How does Quickr document versioning work?
Fri, Nov 28th 2008 7:52p   Cristian D'Aloisio
I seldom used versioning for documents saved in my old "beloved" Quickplace. With Quickr 8.1 I tried to use document versioning but I was a little bit worried because I could not find any menu action to do that (I was trying to version a Quickr Page). Not evenany Quickr server setting or Place setting :-( After some search I find out the following IBM technote that explains the whole subject in Quickr 8.x: Document Versioning in Lotus Quickr 8.1 services for Domino P.S. About Quickr connecto [read] Keywords: document domino ibm lotus quickplace quickr server
27


What a mess at Babylon Ltd !
Fri, Nov 28th 2008 7:52p   Cristian D'Aloisio
Some years ago I bought Babylon, the translator utility for my Windows laptop. I WAS a happy user, until recently I just started to see pop-up messages telling me that I cannot use Babylon in more than one computer: I only use it on my Toshiba computer! Ok, s*t happens, but the problem is with the Babylon Help Desk: I took me a lot of time to temporarily fix the problem. Many mail messages back and forth between me and the Help Desk. Maybe I was unlucky, but it seemed that the Helpdesk guy was [read] Keywords: laptop
64


FormatFactory: a free and complete media converter
Sun, Nov 23rd 2008 6:55p   Cristian D'Aloisio
A really nice freeware media converter: video, images, audio, portable devices, etc. Take a look to it, it's worth of it! FormatFactory website [read] Keywords:
66


Testing Lotus Traveler inside a Windows Mobile emulator
Sat, Nov 22nd 2008 7:55p   Cristian D'Aloisio
Everybody is waiting to download Lotus Traveler compatible with Symbian phone. I read some docs about Lotus Traveler but never had the chance to test it: I use one Blackberry device but have no other device compatible with Windows Mobile :-( But I googled the web and found out that's available a Windows Mobile emulator/simulator used by programmers. So why not test the Lotus Traveler inside the Windows Mobile emulator? Here's what I did on my Windows XP Pro SP2 pc: I downloaded and installed [read] Keywords: document domino lotus lotusdomino traveler application blackberry microsoft mobile network server
41


Some Audacity with nsfdb2 (sound improving)
Tue, Nov 18th 2008 3:55a   Cristian D'Aloisio
With some Audacity and a little VirtualDub, I had fun trying to improve the sound quality of my & Vincenzo session at the DominoPoint Day 2 (nsfdb2 plus AS/400 federation) ;-) [read] Keywords: nsfdb2 application
82


What was the first picture on the Web?
Thu, Nov 13th 2008 7:55p   Cristian D'Aloisio
I was stumbling upon the web and I found the website "Photos that Changed the World". Really impressive pictures. You can see many moving classic pictures, but also the first picture that was published on the Web by Tim Berners-Lee: surprise, girls! ;-) [read] Keywords:
159


Pushing (too much) my Blackberry BES server?
Tue, Nov 11th 2008 3:53a   Cristian D'Aloisio
Some months ago, reading some Blackberry docs, I found out that a Blackberry BES server can send messages (push) to specific BES users, I mean people with Blackberry devices managed by the BES server. What kind of messages? You can send a URL address that will show on the users BB device with a custom read/unread icon: you can see the message inside the Inbox OR on the BB device desktop (it depends on the push message type). When the user clicks on the icon, the browser will load the "pushed" [read] Keywords: lotus notes notes client application applications bes blackberry desktop java server
19


Domino nsfdb2 & AS/400 federation: the Italian video from DominoPoint Day 2008
Tue, Nov 11th 2008 1:53a   Cristian D'Aloisio
[read] Keywords: domino nsfdb2 application
60


Notes 8.5 beta 2 Standard on USB (nomad)? Yes, No, maybe...
Thu, Nov 6th 2008 7:52p   Cristian D'Aloisio
I installed the Standard client of Lotus Notes 8.5 beta 2 on an external USB hard-disk ("Nomad" or "Notes on a stick"), on my Windows XP Pro (I read somewhere that it was possible with Beta 1). After the successful installation (via command line), I tried to run the Lotus Notes client but I received an error message that prevent me to use it. Later I found this old post from Ed and Anthony and I also read the COMMENTS: if I'm not wrong, Notes 8.5 beta 2 Standard client does NOT seem to be inst [read] Keywords: lotus lotusnotes notes notes client roaming
89


SnTT: How to remove encryption to a local databases
Thu, Nov 6th 2008 7:52p   Cristian D'Aloisio
You made a local replica of a Notes database (application) but forgot to disable encryption? No problem, you just delete the local db and make a new replica choosing to disable the encryption setting. Right? Wrong! There's another way to get rid of the local db encryption, without deleting it. How? - show the properties window of the local db - click the "Encryption Settings" button of the first window tab - choose "Do not locally encrypt this database" - compact the local db (from the Compa [read] Keywords: notes sntt application database properties
29


Quickr needs a recycle bin!
Mon, Nov 3rd 2008 7:52p   Cristian D'Aloisio
Today I've had a bad user experience using Quickr Connector via the Windows (file) Explorer (latest version, compatible with Notes 8.0.2) and I'm starting "loosing my faith" about the Quickr Connector reliability... I unintentional deleted some files as a side-effects of a simple Quickr Connector operation: my first irrational reaction, since I was using the Connector ;-) , was to browse the Recycle Bin to undo my delete... I was too optimistic! Then I also have taken a look to the Quickr web [read] Keywords: notes quickr ideajam ideajam.net interface
104


Is your company organization chart like this?
Fri, Oct 31st 2008 8:52p   Cristian D'Aloisio
via Bedkey corner [read] Keywords: blogSphere
68


How to disable the Sametime plugin inside Notes R8 Standard
Wed, Oct 29th 2008 8:52p   Cristian D'Aloisio
Are you tired about dealing with both the Notes R8 Sametime plugin AND Sametime Connect client installed on the same pc? Take a look to IBM Technote 1289437 to know how to disable the Sametime plugin from the Notes R8 client: "Is it possible to install Sametime plugin for Notes 8 client (Standard Configuration), but not have it enabled or displayed in UI?" [read] Keywords: ibm notes R8 sametime
209


Pimp your R8 sidebar (your customers will love it)
Sat, Oct 25th 2008 7:58p   Cristian D'Aloisio
I was thrilled when I first saw the R8 Sidebar: I honestly expected to use it a lot, especially the Widgets panel, but lately I was a bit disappointed ... I tried to add some Notes db views on the client Sidebar, but I could not do it, I always had to deal with frameset containing it, etc. Many Notes friends had my same feeling until.... I saw a post by Mary Beth AND a comment (#2) written by Brian Leonard about a nice trick! Here is the story. When I specify the Notes view to add on the Side [read] Keywords: document domino ibm notes R8 application widgets
64


SnTT: when LS cannot retrieve all SQL data via ODBC...
Thu, Oct 23rd 2008 5:52a   Cristian D'Aloisio
This SnTT post may not be new for some people, but believe me, it will be useful to many programmers you will soon deal with this issue ;-) Every now and then I develop a LotusScript agent to retrieve data from any data source via ODBC and SQL statement: usually I use LS:DO classes to do the job, easy and straightforward way. Problem is when reading a large recordset, via a standard code like this: ' result as ODBCResultSet Do result.NextRow 'Process each row Loop Until result.IsEndOfData [read] Keywords: agent designer lotusscript sntt odbc sql
17


Dealing with your diet
Sun, Oct 19th 2008 8:52p   Cristian D'Aloisio
[read] Keywords: application



You can rent this space for 30 days. Interested?

87


nsfdb2 is back: English slides!
Wed, Oct 15th 2008 8:52p   Cristian D'Aloisio
Roland, a friend from Canada, asked me about the presentation I did with Vincenzo at DominoPoint Day 2008: he liked it and he also asked me to translate it to English. I've also included some useful Flash video to show how to install DB2 server, DB2 Access for Domino and enabling Federation to access AS/400 (System i or any name you like...). Have fun ;-) [read] Keywords: domino nsfdb2 application db2 server system i
30


Moving old Thunderbird e-mail messages to Gmail
Sun, Oct 12th 2008 8:53p   Cristian D'Aloisio
During the past 10 years I collected several private e-mail accounts, all POP3 ones. Each time I had to use a brand-new computer I also had to move all mailboxes saved locally :-( After using Microsoft Outlook Express for a while, I started using Thunderbird client. Later I started using a Gmail account (could you believe it, a friend had to invite me!) and set it up to collect all other accounts mailboxes and label messages according to the account name. This afternoon I realized I still had [read] Keywords: notes R7 email google microsoft outlook
36


A successful conference
Fri, Oct 10th 2008 10:51p   Cristian D'Aloisio
DominoPointDay 2 is the Italian Lotus User Group conference that was held in Milan (Italy) the 10th of October (yesterday). It was a successful event: more than 500 people registered to attend the event interesting topics: Portal server, nsfdb2, Dojo, Symphony, NSD log decoding, performance tuning, Quickr, Sametime, gmail-like Notes mail and morea guest star: Jamie Magee from MartinScottgenerous event sponsors: IBM, BlackBerry, TeamStudio, etc.I and Vincenzo spoke about R8 nsfdb2 feature (on Wi [read] Keywords: ibm lotus notes nsd nsfdb2 quickr R8 sametime symphony blackberry blogger dojo google server
78


jodconverter: a free document format converter
Sun, Oct 5th 2008 8:55p   Cristian D'Aloisio
At UKLUG2008 I attended the session held by Mark Myers about developing good Domino solution with free software (I mean Mark, NOT Mike Myers, the naughty shaggy guy... ;-) ) That was the first time I heard about the jodconverter! It allows you to programmatically convert documents between different office formats (MS Office & OpenOffice), PDF and other formats too. From the official website: ODConverter can be used in many different ways As a Java library, embedded in your own Java applica [read] Keywords: agent connections document domino lotusscript notes R7 application java office openoffice php python server wiki
71


Reading many PDF documents?
Sun, Oct 5th 2008 8:55p   Cristian D'Aloisio
As many people, I have many PDF (Portable Document Format) documents, especially technical ones. I like reading, highlight text and annotate printed documents, but many times I simply don't want to waste hundreds of paper sheets! What a waste of paper, especially for new manuals for each software release... So I decided to buy the popular handy software: FoxIt Reader. The reader-only version is fast and also free, but I decided to buy the Reader Pro Pack version ($39) that let me insert/modif [read] Keywords: document
24


Sntt Quickr: "The place name you entered is already taken" error message
Thu, Oct 2nd 2008 4:51a   Cristian D'Aloisio
I was trying to create a new Quickr place, say "myplace". But I could not! (the problem I found was for that place name only...) I got the error message: "The place name you entered is already taken" ( in Italian "Il nome di area immesso è già utilizzato" ). I made some investigation: no place name such that in the PlaceCatalogno "myplace" Quickr databases inside the Domino data directory So why Quickr continued warning me about an place name already taken? Solution: I found a mail-in defi [read] Keywords: document domino quickr sntt
12


Anna & Matilde, one year later!
Sun, Sep 28th 2008 8:52p   Cristian D'Aloisio
Yesterday it was an important day for me and my family: we celebrated the 1st birthway of my baby twin nieces, Anna & Matilde, and they were baptized in a Catholic church. We had a little party with many people: doctors, nurses, relatives, friends and many children, some of them were preterm babies. My nieces are preterm babies who were born at the 24th week of gesture, with the weight less than 600 grams (21 ounces): they survived and they are completely healthy. [read] Keywords: blogger google
37


A poor devil job
Wed, Sep 24th 2008 8:52p   Cristian D'Aloisio
Every now and then I'm amazed by what can be accomplished using Adobe Flash. Browsing the web I found the nice Pixton online service: you can design your own comics, share then with other people, get feedbacks, remix other authors work, embed strips into your web pages. Simply great! I wanted to make a simple test and designed my first comic strip. Have a look to my strip and make your own Lotus-related comic! ;-) [read] Keywords: lotus
58


UKLUG2008 : some random pictures
Sat, Sep 20th 2008 8:56p   Cristian D'Aloisio
Link to Picasa album [read] Keywords: application google
54


UKLUG2008 : guess what?
Fri, Sep 19th 2008 9:49p   Cristian D'Aloisio
Time to go back to Bologna, Italy...Later I will try to arrange my thoughts about my own UKLUG experience.See you October 10th at Milan, DominoPoint Day, the Italian Lotus User Group. [read] Keywords: lotus mobile
58


UKLUG2008 : starting day 2 with...
Fri, Sep 19th 2008 4:49a   Cristian D'Aloisio
... Paul Money & Matt White session: Domino 8.5 ! [read] Keywords: domino mobile
42


UKLUG2008 : Jamie Magee
Fri, Sep 19th 2008 4:49a   Cristian D'Aloisio
Yesterday afternoon I met Jamie Magee from MartinScott.He talked about fixing domino applications performance problems: nice talk, simple and effective.Btw, if you will attend DominoPoint Day in Milan, 10th October, you can meet him there, he will present the same session. [read] Keywords: domino applications
69


UKLUG2008 : not only notes/domino!
Thu, Sep 18th 2008 8:49p   Cristian D'Aloisio
I decided to attend my first musical show in my life: Billy Elliot. (Victoria Palace Theatre, London).Wow, that's really astonishing, funny and moving show.Great show, great storyboard and superb music score from Elton John.Don't miss it if you are in London!PS I did not see the Billy Elliot movie ;-) [read] Keywords: domino notes
72


UKLUG2008 : wild bill not wild anymore ;-)
Thu, Sep 18th 2008 8:49p   Cristian D'Aloisio
Bill changed his look since ilug2007 ! No beer, no green t-shirt!Ps My bb battery is running out... Sorry! [read] Keywords: mobile
55


Uklug2008 : really handy
Thu, Sep 18th 2008 8:49p   Cristian D'Aloisio
Finally someone had the cool idea! [read] Keywords: mobile
24


Uklug2008: symantec and data growth
Thu, Sep 18th 2008 8:49p   Cristian D'Aloisio
Ron is talking about e-mail growth and info retrieval becoming difficult...Some figures from market analyses: - like it or not, 75% of company info is nowadays found on e-mail messages: e-mail is used as personal repository, for attachments too. - 60% of mail is spam - 80% of viruses are coming from mail messagesAnd then the speech continued about Symatec products for Notes/Domino about archiving and retrieval. Interesting...BTW Any real feedback about Symatec products for archiving? Are them be [read] Keywords: domino ibm notes archiving mobile
37


Uklug2008: blackberry speech just ended
Thu, Sep 18th 2008 8:49p   Cristian D'Aloisio
My perception about RIM and Blackberry is getting better and better. Great company, great product.The speech was interesting. I was glad that RIM is developing an interface (web?) to access Quickr pages and attachments.BTW I lost my London map but I could reach the conference center just using my BB and Google maps with GPS support! [read] Keywords: quickr blackberry google interface rim
76