[Calc] Read and import data from RS232 port to Calc

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
dddominique
Posts: 2
Joined: Mon May 06, 2019 7:16 pm

[Calc] Read and import data from RS232 port to Calc

Post by dddominique »

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 464 times
Last edited by MrProgrammer on Wed Feb 28, 2024 7:59 pm, edited 1 time in total.
Reason: Edited topic's subject
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

Post by dddominique »

Here is the test file TestSerial.ods.

Regards
Attachments
TestSerial.ods
(15.07 KiB) Downloaded 740 times
Ubuntu 16.04.06 LTS
Libre Office 5.1.6.2
Windows 10
Libre Office 6.0.3.2 (x64)
sswcharlie
Posts: 5
Joined: Fri Oct 03, 2014 1:29 am

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

Post by sswcharlie »

Hi

Was there a successful result for this post. That is a working macro.

Thankyou

Charles
Open Office 4.2.4.2
Linux Mint Cinammon
Post Reply