As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
This is rather complex (or at least it's complex to me ..) so I hope you'll bear with me while I explain.
I need to create a Bill of Lading program that will, in part, use data from a legacy system to which there is no direct access.
The developers of that system have created a routine that will dump the contents of an order into a flat file as soon as a "Pick Ticket" is generated for the warehouse.
My task is to take the contents of the flat file (OrderNumber, CustomerCode, ProductCode, ProductQty, ProductCode, ProductQty, ...), merge it with additional information from another database (product description, etc) and load the result into a DB2 database which is the back end of a Lotus Notes application.
My initial plan was to to use Maintain for all of this, and skip the Lotus Notes integration, but the boss won't spend the money to get me some assistance with Maintain (and likely will kill the Maintain portion of our licence in any case because he objects to the IBI maintenance fees).
So I'm left with MODIFY, which is OK.
Now with that out of the way, here's my issue. I need to either: a) Trigger a FEX from Notes to run on the WF server that will retrieve the flat file on demand and process it, or b) Have a ReportCaster procedure that will detect the presence of the flat file and process it as soon as it exists
It would be nice if I could use ReportCaster Alerts, but unfortunately we don't use Managed Reporting so that option isn't available. And I'm thinking that a ReportCaster schedule that runs every minute sounds like a lot of work for nothing.
So: For option a) I could issue a URL from a button in Lotus Notes. Is it possible for the URL to contain a parameter (OrderNumber) that will start a FEX to run the MODIFY in the background to populate the DB2 table? I don't particularly want the URL to trigger a visible HTML page. Maybe an RPC instead ?
One more thing... After the info is passed to the Lotus Notes front end and added to / modified, I would like a Print button that will run a different FEX to produce a PDF. The data at this point will either be stored in Notes format or in DB2.
Thanks for that. We have the WF client and server currently installed on the same VM. The Notes Domino server is on a different VM. Domino can do a lot. Virtually anything to do with inter-process communications. The trouble is that that is not my area of expertise. Do you think we can have a separate instance of the client running on the Notes Domino server?