• 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 ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Bear Bibeault
  • Junilu Lacar
  • Martin Vashko
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Scott Selikoff
  • salvin francis
  • Piet Souris

Learning Lotus Notes Data

 
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
 
author & internet detective
Posts: 39659
785
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Chloe,
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.

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 ]
 
You've gotta fight it! Don't give in! Read this tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!