[Calc] Read and import data from RS232 port to Calc
Posted: Mon May 06, 2019 7:18 pm
Hi,
I want to make the data acquisition of an RFID reader connected in RS232 / USB to Calc LibreOffice.
I wish to have the hour, minute and second in the first column (A), and the Hexadecimal text of the Tag read in the second column (B).
It's all for now
I have just recovered a fairly old macro "OpenDaqCalc.ods" that reads the data that arrive on the RS232 / USB port (via Rs232 / USB cable) to display in Calc "real time".
A user has modified this macro to perform tests -> "TestSerial.ods", it works, but only with one of my 2 devices.
This macro works, when I connect (for test) a portable GPS. The character frame is of this type @ 190509141552 ___________________
The frame fits well in Calc, and is perfectly readable.
By cons, when I connect my RFID reader, I get nothing in Calc?
The data received is in hexadecimal format, I suspect that some are interpreted or not printable.
The entire frame is E2000019490F0214201048D3
By performing tests through an arduino, I was able to collect the hexadecimal frame by adding HEX to the command in "C language" and the frame is well received and readable.
But in this macro, this trick does not work.
Does anyone have an idea who could help me?
Thank-you
I want to make the data acquisition of an RFID reader connected in RS232 / USB to Calc LibreOffice.
I wish to have the hour, minute and second in the first column (A), and the Hexadecimal text of the Tag read in the second column (B).
It's all for now
I have just recovered a fairly old macro "OpenDaqCalc.ods" that reads the data that arrive on the RS232 / USB port (via Rs232 / USB cable) to display in Calc "real time".
A user has modified this macro to perform tests -> "TestSerial.ods", it works, but only with one of my 2 devices.
This macro works, when I connect (for test) a portable GPS. The character frame is of this type @ 190509141552 ___________________
The frame fits well in Calc, and is perfectly readable.
By cons, when I connect my RFID reader, I get nothing in Calc?
The data received is in hexadecimal format, I suspect that some are interpreted or not printable.
The entire frame is E2000019490F0214201048D3
By performing tests through an arduino, I was able to collect the hexadecimal frame by adding HEX to the command in "C language" and the frame is well received and readable.
But in this macro, this trick does not work.
Does anyone have an idea who could help me?
Thank-you