Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Learning Lotus Notes Data

 
Chloe Loh
Greenhorn
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?
Thanks.

Best Regards,
Chloe
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Chloe,
I'm not a Lotus Notes developer either, but fficial" target="_blank" >google has some good resources. You could also check IBM's website for more technical documentation.
[ May 15, 2005: Message edited by: Jeanne Boyarsky ]
 
Axel Janssen
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.

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

Overview:
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.

Axel

[ May 15, 2005: Message edited by: Axel Janssen ]
[ May 15, 2005: Message edited by: Axel Janssen ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic