Solved

Capture Serial Data in Lotus Notes Database

Posted on 2014-04-29
8
264 Views
Last Modified: 2014-10-15
I'm looking for a way that my lotus notes form can capture data from some serial scales directly into a field.

I have some weighing scales connected via a standard serial cable to the client PC. I need my lotus notes Database to capture this data.

So far I've only been able to get close by using third party software which reads the serial device and outputs the value as a keyboard input into my field.

This isn't a great setup as there's a lot of room for error and isn't stable enough for our production environment.

Does anybody know of some code in Notes that will directly interrogate a specific COM port for the data?
0
Comment
Question by:Unifrax
  • 5
  • 2
8 Comments
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 40030985
First some questions, then a suggestion:
- is there no special protocol on the comms connection?
- why directly in Notes?

Suggestion(s):
- use Linux, for easier access to comms
- develop a simple, external application that receives the comms data and sends it to your database, using mail, i.e. make the database a mail-in database.
0
 

Author Comment

by:Unifrax
ID: 40031398
If the weight is wrong they will have to remove some of the product and weigh again.
I don't want the user to have as little input as possible. Ideally it would automatically capture the data (and refresh every time the value change or alternatively they press a button each time they wish to capture.

We only use Windows PCs within the business (Company Policy).
If I just wished the capture all data the scales receives I think the mail-in database would work I think it would be a bit too slow sending the data via mail and then pulling it into the form. It needs to be instant for the production environment.

We are hoping to make this database web-based if it makes any difference.

I'm open to third party applications, but as all the ones I have seen so far convert the reading to Keyboard strokes, which can be a bit unreliable
- Correct field must be selected.
- User has to delete previously entered text to then capture data again
- Hotkey (F1 for example) has to be used to capture the data unless set to continuous or using a physical button on the scale.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 40031607
What amazes me is that the scales supplier doesn't have the appropriate DLL or other library. I'd expect a higher level interface, and not just COM... I'd also expect some comms protocol, to get data reliably over the line.

The Notes environment is far from ideal for this purpose. A web-based interface to the database seems better already, but... browsers are not allowed to do anything locally. Which means that access to COM-ports is not going to work... unless the scales supplier has an ActiveX module that can be integrated into the application, and you don't object to use only Internet Explorer as a browser (because the others don't support ActiveX modules). Or ask for an applet.

As for Company Policies, read my EE profiles (the monkey story).
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

Author Comment

by:Unifrax
ID: 40039249
I think the only way I'm going to achieve what I want is by using software like wwinwedge which will capture the serial data and input it into my web form as a keyboard entry

This though, presents another dilemma. The software has to be setup using a hot key. For example you hit F1 it then outputs the keyboard entry. As the PCs are in entirely sealed units because of the production environment conditions they can't use a keyboard or mouse (just a barcode scanner and weighing scales).

Is it possible to emulate hitting keyboard button by pressing a button in a notes web based form?
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 40039684
I suppose it can be done, using  an ActiveX control that runs inside your web page in IE. I have no clue how to do that though, so maybe you have to ask a new EE-question.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 40041545
If you want to send a trigger to another application, a solution might be to create your own URI Scheme, i.e. your own URL protocol, like in this URI:
myapp://do_this/do_that

More info here:
- http://msdn.microsoft.com/en-us/library/ie/aa767914%28v=vs.85%29.aspx
- https://www.iana.org/assignments/uri-schemes/uri-schemes.xhtml 
- http://java.sun.com/j2se/1.5.0/docs/api/java/net/URI.html
0
 
LVL 1

Accepted Solution

by:
FKoutchouk earned 500 total points
ID: 40163665
1- In the Notes form create a button
2- That button calls an agent or script library that fetches the data from the scale
3- The stores it in the appropriate field in the form

2 can be written in Java (supported in Notes) using COM libraries.   Or in LotusScript calling the Windows API.  Either way not trivial, but not so hard.

Lower tech would be an embedded OLE object that displays the scale value in real time within the Notes form.  User then types the value in the form.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 40383306
How did you solve your problem? Just my curiosity...
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

773 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