[Calc] Reading and importing data from the RS232 port to Cal

Creating a macro - Writing a Script - Using the API

[Calc] Reading and importing data from the RS232 port to Cal

Postby dddominique » 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
Attachments
OpenDaqCalc20190506.zip
(26.89 KiB) Downloaded 37 times
Ubuntu 16.04.06 LTS
Libre Office 5.1.6.2
Windows 10
Libre Office 6.0.3.2 (x64)
dddominique
 
Posts: 2
Joined: Mon May 06, 2019 7:16 pm

Re: [Calc] Reading and importing data from the RS232 port to

Postby dddominique » Mon May 06, 2019 7:27 pm

Here is the test file TestSerial.ods.

Regards
Attachments
TestSerial.ods
(15.07 KiB) Downloaded 46 times
Ubuntu 16.04.06 LTS
Libre Office 5.1.6.2
Windows 10
Libre Office 6.0.3.2 (x64)
dddominique
 
Posts: 2
Joined: Mon May 06, 2019 7:16 pm


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 8 guests