Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 410
  • Last Modified:

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

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.

1 Solution

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.

MichielZoerAuthor Commented:
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
ZvonkoSystems architectCommented:
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!

ZvonkoSystems architectCommented:
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.

MichielZoerAuthor Commented:

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...
In DECS Administrator:
- Select Activities view
- Click, Action - Initilize Keys !

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

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

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now