July 31, 2003 at 12:39 pm
I have an online application that allows users to sign up to recieve updates to agency periodicals (newsletters, bulletins, etc.) in their email box. The application retreives the user's email address (and other voluntary info)into a SQL database. From the back end, the email addresses are then DTS'd to a flat file where they are then imported into a Lotus Notes address book using the Lotus Notes import utility. The individual in charge of retrieving the email addresses then reviews each file to see which agency periodicals the individuals have signed up to recieve and places their email address in separate Lotus Notes folders according to what the user signed up to receive. When the periodicals are updated, the internal person sends everyone in the applicable folder an email letting them know that the periodical they signed up to receive is available on the web for viewing.
I have been assigned the task of automating this process. I tried to create a DTS package sending the information directly into Lotus Notes but SQL will not allow you to DTS to a .nsf file, which is the file extention for a Lotus Notes database table. There is no set schedule when these periodicals are updated, nor are they ever all updated at the same time, so someone must be available to send the emails.
Any suggestions?
August 11, 2003 at 2:19 am
I don't know whether this helps, but Lotus produce an ODBC driver for Notes, which can be downloaded free from their website. This enables you to create an ODBC DSN for your Notes database and treat it as though it were a relational DB - i.e. you can use it as a datasource in DTS and read/update it as with any other database.
The driver isn't perfect, but it does work. I've used it.
August 11, 2003 at 6:19 am
If the ODBC driver doesn't do the job, you could export to a csv and do the import from an agent in Notes that you've scheduled.
August 12, 2003 at 7:59 am
I did get the SQLNotes driver from the lotus website and found that it does work. Thanks for the suggestions and ideas.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply