Win a copy of JDBC Workbook this week in the JDBC and Relational Databases forum
or A Day in Code in the A Day in Code forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
  • Piet Souris
  • salvin francis
  • fred rosenberger

Learning Lotus Notes Data

Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi guys,
I need to migrate some data from Lotus Notes to Ms SQL Server. However, I'm not Lotus Notes developer. C
an anyone suggest some reading resources that I can learn some basic of Lotus Notes so I know how to export data from it to Ms SQL?

Best Regards,
author & internet detective
Posts: 39986
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm not a Lotus Notes developer either, but google has some good resources. You could also check IBM's website for more technical documentation.
[ May 15, 2005: Message edited by: Jeanne Boyarsky ]
Ranch Hand
Posts: 2166
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In my pov theres no need to learn a whole proprietary programming platform to do a 1 time export of data.
I offer my help. Its not that difficult. If you don't understand me, ask question.

You might need a notes designer client for the task.
Do you have that? It might be important.

Most general way for the task is in my opinion to write a so called notes agent. But it may be that its going to be a bit simpler.
In that agent you:
1. establish a connection to MS-SQL
2. select which notes-data you are going to export.
3. read data from notes
4. write data to MS-SQL
5. close connection to MS-SQL as allways.

You start with point 2.
Data in Notes is stored in units called documents.
Those documents are in other elements called views.
You must first tell me, if you know the view of the notes app which contain the documents holding the data you are going to export.
And if you know the field-names of the data in the documents.
I hope you are just going to export simple tables and there are no 1-n relationships of the data to export.
If you don't know the view, I can tell you how to find the correct one. Or build new one.

If you have the view you may even create a csv file which you might import into MS-SQL. But only if data structures in Notes are simple (no 1-n rel.).
There is also a programatic way writing so called notes agent, which you can write in Java or LotusScript last one similar to visual basic. But I should be able to provide you the necesary syntax and with Java in Notes you have more administrative hassle and no simple debugger.


[ May 15, 2005: Message edited by: Axel Janssen ]
[ May 15, 2005: Message edited by: Axel Janssen ]
You don't like waffles? Well, do you like this tiny ad?
Devious Experiments for a Truly Passive Greenhouse!
    Bookmark Topic Watch Topic
  • New Topic