Run formulas on Notes from .Net assembly

by | Feb 7, 2009 | BizTalk Server 2006, BizTalk Server 2006 R2, Domino, Lotus Notes | 0 comments

When you intergrate Domino Lotus Notes with any external system, it's a bit of COM interop coding effort you have to go thru. Same is the case, even if you are using BizTalk Server. There is no adaptor commercially available which does the job what you are looking to do.

Here is my five cents on how to execulte formulas on a Lotus Notes Document from a .net assembly using interop dlls.

I am using BizTalk to integrate SAP with Notes. As we know SAP integration at Send and Recieve ends of BizTalk is quite straight forward until you want to let SAP have control on this. When you want SAP to have control on this, the only option is to let SAP drop the required files or access required files from an FTP or File location. You can possibly use XML or Flat file files to represent data that SAP can use. Well, I'm losing the topic here.

Coming back to Notes integration at the othe end of the BizTalk needs custome .net component or if you have a world of time to deal with Custom Adaptors, you can opt it.

In the .net component you build, right after you do the Document field append(nDoc.AppendItemValue("AccountingDate", "20022009");) or Replace (nDoc.ReplaceItemValue("Form", "Invoice");), In other words Create or Update, you gotta save the document.

if (!nDoc.Save(true, false, false)) throw new Exception(@"Failed to Update Portal Invoice with Invoice Number: " + invoiceNumber);

With the concerns incorporated canada tadalafil 10mg on this class, male sexual dysfunction is typical. In 2015, the American Cancer Society estimated over 220,000 cialis sale online men with prostate cancer. Some scientists believe that there are certain genes that affect the individuals likely to develop emotional problems. generic tadalafil tablets Libido or sex drive is important for finding viagra sale try for more info out what is causing your Impotence issue to rule out serious underlying health conditions.
A call to ComputeWithForm has to be fired right before the Save for the formula execution on this document.

if (!nDoc.ComputeWithForm(false, false)) throw new Exception(@"Failed to execute formulas for Portal Invoice with Invoice Number: " + invoiceNumber);

More on this method at https://sametime.aspeninstitute.it/help/help65_designer.nsf/f4b82fbb75e942a6852566ac0037f284/
2a3fdfb3f8f4261385256d9b00442708?OpenDocument

Happy Coding!

Coming up in the BizTalk series : Port failure Notifications from BizTalk without using MOM!

Lotus Notes Integration using BizTalk

by | Dec 15, 2008 | BizTalk Server 2006, BizTalk Server 2006 R2, Domino, Lotus Notes | 2 comments

Notes Integration from any third party application is not an easy straight forward thing. However Interop.Domino.dll provided by IBM Domino helps do all basic operations on a Lotus Notes Database.

When it comes to using BizTalk to integrate with Lotus Domino, there is no LOB Adaptors available with BizTalk. Not even 2006R2. Well, there is no even a third party BizTalk Adaptor for this purpose.
There are few providers for universal adaptors for Notes but, it takes the same effort as using Interop.Domino.dll and code out your interface.

Following link will help you get a detailed SDK typed details on each classes and its usage from the Interop assembly for Notes.
https://sametime.aspeninstitute.it/help/help65_designer.nsf/Main?OpenFrameSet&Frame=Topic&Src=%2Fhelp%2Fhelp65_designer.nsf%2FContentsIntro%3FOpenPage%26AutoFramed

Here is an example on how such a simple interface may look:

NotesSession nSession = new NotesSession();
The other important thing viagra for sale cheap about this gel drug is its availability in different delicious flavors such as mint, banana, strawberry, chocolate, vanilla etc. These side effects will just go away when you stop the flow of discount levitra appalachianmagazine.com urine. Check with your doctor what works best for you and your partner to new sexual heights of intimacy and cialis 40 mg ecstasy. Change in Blood Sugar levels During certain time, order cheap levitra blood sugar level can raise especially during the sexual activity.
NotesDatabase nDB;
NotesDocument nDoc;
nSession.Initialize("mypassword");
nDB = nSession.GetDatabase(@"ServerName", @"DatabasefileName", false);
if (nDB == null) throw new Exception("Notes Database not available");
if (!nDB.IsOpen) nDB.Open();

nDoc = nDB.CreateDocument();
nDoc.AppendItemValue("ItemNo", "00001");
nDoc.AppendItemValue("ItemName", "Rubber");
if (!nDoc.Save(true, false, false)) throw new Exception(@"Failed to save");