Solved

Outlook 2000 data to Lotus Notes

Posted on 2002-04-07
14
252 Views
Last Modified: 2013-12-18
I need to export data from a Custom Outlook form to Lotus Notes. The data is to be a new Notes document. Currently exporting data to Access which is then exporting to an Ascii file which is manually imported into Notes. I want to automate process from the Outlook/VBA/VBScript side. Using Access currently as data is added to Outlook data from an Oracle based Helpdesk system.

I don't have Notes and have never used notes, so any help would be very much appreciated.
0
Comment
Question by:vbmds
  • 8
  • 5
14 Comments
 
LVL 10

Expert Comment

by:zvonko
ID: 6924707
Hello vbmds,

from this your question and from your answered Outlook question is not completely clear what basis you now have and which direction you want to go, sorry.

Can you please explain in more details what your starting situation is.
Also important is which way you like to go, because there are always several roads to Rome :-)

From your two questions and from your EE member name I read that you do not plan to dive deep into Notes :-)
I suppose you prefer to do it from anywhere in Visual Basic and use Lotus Notes COM. This is possible.
But to make things less complicated for you and for experts involving in this question give please this answers:
1.) Where is the process initiated for this Outlook form (on Outlook or anywhere else)?
2.) Does this Outlook form lookup anywhere data while user is filling up its fields?
3.) Why do you have to switch from Access repository for Outlook form data to Notes?
4.) Has Access to be used parallel when Notes is form data repository?
5.) Do you in any case have to lookup or deposit data to Oracle?
6.) Can you send parts of your code to experts by email? My address is zp@arcor.de :-)

Waiting for your answers.

So long,
zvonko
0
 
LVL 10

Expert Comment

by:zvonko
ID: 6924714
One very important additional info.

You can not send data to Notes server without locally installed Notes client. Every workstation sending data to Notes server has to have an user.id

Of course you can do it simple and send it as mail Carbon Copy from Outlook to a Notes MailIn database. This would be the easiest and best path for all involved parties. At receiving time in Notes mail in database, you can start further processing in any direction or simply store received documents :-)

0
 

Author Comment

by:vbmds
ID: 6924730
Thanks zvonko for your posts. I'll try and answer your questions to me.

Firstly, the 2 questions I have asked are unrelated.
Secondly, I am a remote contract programmer for the company causing me ask these questions. No-one within the company has a clue which is why I'm asking the questions.

Choice of products: The company uses MS Exchange/Outlook for its Email system. Lotus Notes is used as a Document Store for the Help Desk. Oracle is the Helpdesk application platform.

Currently my custom OL2K form is sent to external customers who fill it in and send it back. Currently the company open the reply, cut and paste into Excel and then import into Notes. They want to automate the import process. Reports are then generated. The Notes guru of the company knows nothing about MS Office Automation, and I about Notes.

I have brought Access into the picture to provide a Proof of Concept. That is; that we can get data out of a custom Outlook form.

So, basically, I want to replace Access with Notes, and ideally would like to do this using ADO...but can it be done.

The solution will be run on Workstations with Notes and Outlook installed. However, the company can not provide me with Notes to play with.

Hope this helps.
0
 
LVL 10

Expert Comment

by:zvonko
ID: 6924790
Ok, very well.

Now is the picture complete for me :-)

Please send me your adapter between this Outlook form and the Access database. I can rewrite it to do the same to Notes database.
We can refine it later where this database has to be; locally or on Notes server. This is not a big difference for Notes.
Can you send me your code you used for concept proves?
I will paste afterwards all relevant information for other experts.

Send your zip with the Outlook form I can apply to my Outlook and the scripts (not the executables :-) for interchange between Outlook and access.
Send it to: zp@arcor.de

So long,
Zvonko
0
 
LVL 10

Expert Comment

by:zvonko
ID: 6924913
Thanks for the Outlook form.
The investigation of it will take some time.

So long,
zvonko

0
 
LVL 10

Expert Comment

by:zvonko
ID: 6925239
I have sent you the firts release of the StoreNotesDoc procedure.
Tell me how it works for you so I can publish it here on EE...

So long,
zvonko

0
 
LVL 9

Expert Comment

by:Arunkumar
ID: 6925248
At the end of this you will beg for 300 pts right ?

;-)
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:vbmds
ID: 6926502
Thankyou Zvonko. I am demoing the process next week and so will post the outcome here. It looks good, so we can but hope.

Point taken Arunkumar, I was also thinking in the same vain.
0
 

Author Comment

by:vbmds
ID: 6985721
Cheers Zvonko for the help. Your code seems to whats needed.
0
 
LVL 10

Expert Comment

by:zvonko
ID: 6985733
Thanks for the feedback :-)
0
 
LVL 10

Accepted Solution

by:
zvonko earned 200 total points
ID: 6985739
Oh, still no code here...
Could you please post a customized version for the EE community, please :-)
0
 

Author Comment

by:vbmds
ID: 6985826
Here is the final version of the code. This code is contained in the VBScript of the custom Outlook form.

Sub StoreNotesDoc()
'VB Script code for Export form
'Exports Outlook data to a Notes document, using VB Script
'Written by Zvonko Paunoski 8/04/2002
'Last modified 23/04/2002 by Mark Sollitt
'The data used by this sub is contained in the variables starting with 'db'
'The Notes database path has been left incomplete due to commerically sensitive nature
'of the real path to the company this sub is being used by.

  Dim domNotesSession
  Dim domNotesDatabase
  Dim domNotesDocument
  Dim domNotesItem

    Set domNotesSession = CreateObject("Lotus.NotesSession")
    Call domNotesSession.Initialize("lotusnotes") '// let empty string to allow user to enter password
    If Not (domNotesSession Is Nothing) Then
        Set domNotesDatabase = domNotesSession.GetDatabase("", "<path to database>/Survey.nsf")
        If Not (domNotesDatabase Is Nothing) Then
            Set domNotesDocument = domNotesDatabase.CreateDocument
            If Not (domNotesDatabase Is Nothing) Then
                Set domNotesItem = domNotesDocument.AppendItemValue("Form", "Survey")
                Set domNotesItem = domNotesDocument.AppendItemValue("jobID", CStr(dbJobID))
                Set domNotesItem = domNotesDocument.AppendItemValue("answer1", CStr(dbQ1))
                Set domNotesItem = domNotesDocument.AppendItemValue("answer2", CStr(dbQ2))
                Set domNotesItem = domNotesDocument.AppendItemValue("answer3", CStr(dbQ3))
                Set domNotesItem = domNotesDocument.AppendItemValue("answer4", CStr(dbQ4))
                Set domNotesItem = domNotesDocument.AppendItemValue("remoteuser", CStr(dbNTUser))
                Set domNotesItem = domNotesDocument.AppendItemValue("username", CStr(dbSDUser))
                Set domNotesItem = domNotesDocument.AppendItemValue("comments", CStr(dbComments))
                Set domNotesItem = domNotesDocument.AppendItemValue("org", CStr(dbCompany))
                Call domNotesDocument.Save(True, False)
            End If
        End If
    End If
    Exit Sub
End Sub
0
 
LVL 10

Expert Comment

by:zvonko
ID: 6985852
Thank you Mark, now everyone knows my full name :-)

It is no problem for me, but until now only my buddies here knew my name :-)

Thank you also for the points and grading :-)

Until next time.

See you,
zvonko

0
 

Author Comment

by:vbmds
ID: 6987588
Sorry Zvonko, did not think. I was suprised that you asked me to make the code paste as I thought you were going to take care of it, and so did it in rush. Now that you mention it, my full name is in there as well.

You are welcome and I think certainly earned the points and Grade with all the work I had you doing to get it just right.

Ceya,
vbmds (Mark)
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
This video discusses moving either the default database or any database to a new volume.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now