Possible to populate a Notes View automaticly from mySQL database with DECS?

Posted on 2003-02-25
Medium Priority
Last Modified: 2013-12-18
Hi i'm using DECS on Domino R5.11 on Windows,

created ODBC to interact with mySQL database and setup the Activity.
I'm able to create new entry's in the mySQL database from within a Notes Form. So far everything seems to work...

Is it possible to populate a Notes View automaticly with new entry's from the mySQL database? The new entry's orriginate from a PHP input form.

Question by:MichielZoer
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 24

Expert Comment

ID: 8021067

Source will be MYSQL database (Create ODBC COnnection ) and refere to table in MYSQL, simlarly a notes connection and form name is required, then map the fields accordingly.


Author Comment

ID: 8023689
Well... already done, but this didn't work.

I'll explain some further:
- start from scrath in Lotus Notes DECS.
- setup ODBC connection to mySQL table (which is allready populated)
- select Notes Database / Form to interact with mySQL table (both the 'Form' & 'Table' have the same name
- Map the corresponding keys & Fields from the form I made en the mySQL database / table fields

My next step would be:
create a blank view in Lotus Notes and populate this view with te values allready in the mySQL database.


thx. mizo
LVL 63

Expert Comment

ID: 8023747
No, it is not possible.

NotesView can only work on actual NotesDatabase where the NotesView is located.
No @DbLookups on anything allowed, neither ODBC connections to anywhere.

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 63

Expert Comment

ID: 8023769
Your next step is the only one possible: synchronize in an agent the entries from external source to some items in actual NotesDatabase.

But again, your agent can not populate a blank view. Your agent can only populate document(s) items which are to be indexed by NotesView.


Author Comment

ID: 8023821

darn... You say the only posible solution is to generate all documents based on the form manually (by providing 1 or more key fields)...
That won't work, I have about 20.000 entry's in the mySQL database and need 'm all.

I need this to work somehow...

Accepted Solution

Gunsen earned 225 total points
ID: 8025352
In DECS Administrator:
- Select Activities view
- Click, Action - Initilize Keys !

You can copy the code for this agent, to make it unattended...

Author Comment

ID: 8026161

Thx Gunsen!
Must have missed this feature... kinda stupid. Anyway, it works!

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
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…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Suggested Courses

752 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