3.Connecting machines
Machine connection
There are three ways DreamLab uses to connect with machine, here some options from the most obsolete to the newest, Dreamprog is working in the way to optimize the connection to work with every machine.
1) Tcpwedge
TcpWedge uses microsoft Access macro to catch the data that are sent to TCP, this is the most obsolete and is used in only Beira and DsChang.
To work needs Access to be active all the time and the data are being catched by tcpWedge program installed in the PC, this comunicate with the macro in Access that will parse and insert the data.
This program is going to be replaced by TCPlistener.
2) TCPlistener
This program is developed by Dreamprog team, by his configuration file: TCPlistener.config is possible to set the door, IP and other settings, once received the data automatically insert into access file.
3) Advanced TCP/IP Data Logger
This program is developed by Aggsoft, can catch any data received from the server and from any machine
Here the procedure to configure with sqlServer database
Here the SQL insert he uses :
INSERT INTO DAT_tcpip_bridge (TIMESTAMP,DATE_TIME_STAMP,DATA_SOURCE_NAME,DEVICE_ID,PATIENT_SEQ_NUM,PATIENT_ID,PATIENT_NAME,PATIENT_NAME_LAST,PATIENT_NAME_MIDDLE,PATINT_NAME_FIRST,PATIENT_NAME_SEX,PATIENT_ADDRESS,PATIENT_PHONE,PATIENT_RACE,RESULT_SEQ_NUM,RESULT_TEST_ID,RESULT_TEST_ID1,RESULT_TEST_ID2,RESLT_TEST_ID3,RESULT_TEST_ID4,RESULT_VALUE,RESULT_UNIT,RESULT_ABNORMAL,RESULT_STATUS,RESULT_OPERATOR_ID,PATIENT_ID_LAB,ORDER_SEQ_NUM,PATIENTID_OPT,FULL_DATA_PACKET,PROCESSING_ID,SAMPLE_ID,TEST_ID,TEST_ITEM_NO,TEST_ITEM_ID)
values
(:TIMESTAMP,:DATE_TIME_STAMP,:DATA_SOURCE_NAME,:DEVICE_ID,:PATIENT_SEQ_NUM,:PATIENT_ID,:PATIENT_NAME,:PATIENT_NAME_LAST,:PATIENT_NAME_MIDDLE,:PATIENT_NAME_FIRST,:PATIENT_NAME_SEX,:PATIENT_ADDRESS,:PATIENT_PHONE,:PATIENT_RACE,:RESULT_SEQ_NUM,:RESULT_TEST_ID,:RESULT_TEST_ID1,:RESULT_TS_ID2,:RESULT_TEST_ID3,:RESULT_TEST_ID4,:RESULT_VALUE,:RESULT_UNIT,:RESULT_ABNORMAL,:RESULT_STATUS,:RESULT_OPERATOR_ID,:PATIENT_ID_LAB,:ORDER_SE_NUM,:PATIENT_ID_OPT,:FULL_DATA_PACKET,:PROCESSING_ID,:SAMPLE_ID,:TEST_ID,:TEST_ITEM_NO,:TEST_ITEM_ID)
Configuration of connection via ODBC on the server PC
