Lotus Notes

Any wild chance someone has written a REBOL scheme for querying Lotus Notes .nsf databases? Ryan C. Christiansen Web Developer Intellisol International 4733 Amber Valley Parkway Fargo, ND 58104 701-235-3390 ext. 6671 FAX: 701-235-9940 http://www.intellisol.com Global Leader in People Performance Software _____________________________________ Confidentiality Notice This message may contain privileged and confidential information. If you think, for any reason, that this message may have been addressed to you in error, you must not disseminate, copy or take any action in reliance on it, and we would ask you to notify us immediately by return email to [ryan--christiansen--intellisol--com]

Ryan, just run a search on Google for NotesSQL - it's an ODBC driver for Lotus Notes - or cruise on over to Notes.net via this link: http://www.notes.net/notesua.nsf/0b345eb9d127270b8525665d006bc355/94e14b09320416c7852569df005a97c9?OpenDocument&Highlight=0,NotesSQL You can download and install it from that link. Basically if you've got Rebol/Command then you should be able to leverage ODBC fairly easily. Otherwise you'll have a tougher time. The only real work-around that comes to mind is to Web-enable your Notes database, and build a few forms and views that you can hit via http with your Rebol script. - Porter Woodward On Tue, 8 May 2001 [ryan--christiansen--intellisol--com] wrote:

> Any wild chance someone has written a REBOL scheme for querying Lotus Notes > .nsf databases? > [rebol-request--rebol--com] with "unsubscribe" in the > subject, without the quotes.

Thanks for the link, Porter. Using REBOL/Command to communicate to NotesSQL via an ODBC connection looks very promising (if REBOL/Command runs on Cobalt Linux?) Now they HAVE to buy me REBOL/Command, right? :) -Ryan Porter Woodward <[woodward--shore] To: <[rebol-list--rebol--com]> .net> cc: Sent by: Porter Subject: [REBOL] Re: Lotus Notes Woodward <[woodward--primu] shost.com> 05/08/2001 02:37 PM Please respond to rebol-list Ryan, just run a search on Google for NotesSQL - it's an ODBC driver for Lotus Notes - or cruise on over to Notes.net via this link: http://www.notes.net/notesua.nsf/0b345eb9d127270b8525665d006bc355/94e14b09320416c7852569df005a97c9?OpenDocument&Highlight=0,NotesSQL You can download and install it from that link. Basically if you've got Rebol/Command then you should be able to leverage ODBC fairly easily. Otherwise you'll have a tougher time. The only real work-around that comes to mind is to Web-enable your Notes database, and build a few forms and views that you can hit via http with your Rebol script. - Porter Woodward On Tue, 8 May 2001 [ryan--christiansen--intellisol--com] wrote:

> Any wild chance someone has written a REBOL scheme for querying Lotus

> .nsf databases? > Ryan C. Christiansen > This message may contain privileged and confidential information. If you > think, for any reason, that this message may have been addressed to you

> error, you must not disseminate, copy or take any action in reliance on

> and we would ask you to notify us immediately by return email to > [ryan--christiansen--intellisol--com] > > -- > To unsubscribe from this list, please send an email to > [rebol-request--rebol--com] with "unsubscribe" in the > subject, without the quotes. >

Last I heard Command does not do ODBC on Linux, most unfortuneately. However not all is lost. Some folks called Team FXML, have created an ODBC Proxy that sits on an NT box, interfacing ODBC with XML ;o) I whipped up a protocol to interface to it should be somewhere at: http://www.sonic.net/~gaia/odbcss/ My protocol probably needs some finishing work, for I have'nt had a chance to actually use it yet. --Ryan [ryan--christiansen--intellisol--com] wrote:

> Thanks for the link, Porter. Using REBOL/Command to communicate to NotesSQL > via an ODBC connection looks very promising (if REBOL/Command runs on > [rebol-request--rebol--com] with "unsubscribe" in the > subject, without the quotes.

That would be way cool. All my saved email from this list is in Lotus Notes and I'd really like to get them out and into a more portable format (flat text would be fine). BTW Is there still a project underway for a REBOL email client? I've written a simple read-only script in /Core which separates attachments and builds a small web site of the emails but I'd really like something more robust (like read AND write, folders, filters etc). Once we get the REBOL email client I'd like to see converters to grab email from Outlook, Lotus Notes and import it into the REBOL-email-client format. That is, I want a portable email client with a net-based repository, not Outlook here, Lotus Notes there, on this-computer or that-computer. I want REBOL mail! - Michael Jelinek [ryan--christiansen--intellisol--com]@rebol.com on 05/08/2001 02:16:59 PM From: [ryan--christiansen--intellisol--com]@rebol.com on 05/08/2001 02:16 PM Please respond to [rebol-list--rebol--com] Sent by: [rebol-bounce--rebol--com] To: [rebol-list--rebol--com] cc: Subject: [REBOL] Lotus Notes Any wild chance someone has written a REBOL scheme for querying Lotus Notes .nsf databases? Ryan C. Christiansen Web Developer Intellisol International 4733 Amber Valley Parkway Fargo, ND 58104 701-235-3390 ext. 6671 FAX: 701-235-9940 http://www.intellisol.com Global Leader in People Performance Software _____________________________________ Confidentiality Notice This message may contain privileged and confidential information. If you think, for any reason, that this message may have been addressed to you in error, you must not disseminate, copy or take any action in reliance on it, and we would ask you to notify us immediately by return email to [ryan--christiansen--intellisol--com]

A trick I use to get messages out of Outlook Express (which does not export very well) is to select a whole bunch of emails and then click on the Forward button. The result is all the selected emails become attachments (type message/rfc822) of a multipart mime message - which I then save using Outlook Express' message save option. This then is a text file which can be processed using a Rebol/View MIME handling script I made. A program I wrote recently is layered on top of this for a nice interface - it will write out all the messages as seperate files into a directory. Goto: http://www.codeconscious.com/rebsite/emails.r or Rebol/View/Desktop/Sites/Code C./Emails Might be worth seeing if you can do something similar with Notes prior to someone writing a "proper" interface. Brett.

Michael, You can export all of the documents in a view to a text file using the export option in the Notes file menu. This code then be split using parse I guess. Header from the exported file - $AdditionalHeaders: SMTPOriginator: From: Subject: PostedDate: SendTo: ReplyTo: $UpdatedBy: RouteServers: RouteTimes: $Orig: $MessageID: Categories: $Revisions: $MsgTrackFlags: DeliveredDate: ....messgae body... Have fun, john