Retrieving Appointments Between Dates

I am wanting to call from my .net application Lotus Notes to retrieve a set of appointments between particular dates. I think the solution lies in creating a view but since my knowledge is very limited on the Notes side I don't know where to start.

Basically I would like to connect to Notes from .net and work completely from .net to get the information. Then within my application I could loop around all the appointments to process them.

The version is for Notes V5.
chafford100Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bill-HansonCommented:
What language are you planning to use? C#, VB?

Do you already have a framework?  Have you accessed Notes data from .Net before, or do you need help including the references?
0
Sjef BosmanGroupware ConsultantCommented:
How often do you want to extract the data? If it's very often, then you're better off with a view, otherwise a NotesDatabase.Search will do fine.

Here's an example:
http://www.vortexwd.net/lotusnotescalendaring2.asp

More for your other questions ;-)
http://www.vortexwd.net/lotusnotescalendaring1.asp
http://www.fabalou.com/VBandVBA/lotusnotesappointment_ver6.asp
0
CRAKCommented:
You could check the design in Notes (need designer client) to see if the maildatabase(s) contain(s) (a) view(s) that suits your needs. The template I use is entirely different... I can't advice.
Otherwise you could retrieve a set of documents using the (slower):

NotesDatabase.Search(SearchFormula$, nothing, 0)

The search formula would be a select formula in notes syntax. Something like:

SearchFormula$ = "Form=\"Appointment\" & StartDate>" & myStartDate & " | EndDate<" & myEnddate
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

CRAKCommented:
Sorry Sjef.... it appears cross posted. I can't help it!
0
Sjef BosmanGroupware ConsultantCommented:
LOL

By the way, are you into "seagull-management" nowadays??  ;-))
0
chafford100Author Commented:
I am planning to use vb.net and assume I have no knowledge of Lotus Notes except for the two days I have read on the topic, none of which is concerned with the COM side. So any help would be good.

Actually it is the first time I have heard of Seagull Management and actually it is quite true. I had a developer and project manager who said this was easy to do and I should not worry. This was 8 weeks ago. Now I have around 2 weeks to solve this problem.

Apologies for the number of messages and the lack of investigating for myself but I have just run out of time so I need experts on what I am hoping is a simple topic.
0
Sjef BosmanGroupware ConsultantCommented:
Did you check the first link I sent you? The Vortex-code? Then do so now!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.