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
[Calc] Read and import data from RS232 port to Calc
-
- Posts: 2
- Joined: Mon May 06, 2019 7:16 pm
[Calc] Read and import data from RS232 port to Calc
- Attachments
-
- OpenDaqCalc20190506.zip
- (26.89 KiB) Downloaded 527 times
Last edited by MrProgrammer on Wed Feb 28, 2024 7:59 pm, edited 1 time in total.
Reason: Edited topic's subject
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)
Libre Office 5.1.6.2
Windows 10
Libre Office 6.0.3.2 (x64)
-
- Posts: 2
- Joined: Mon May 06, 2019 7:16 pm
Re: [Calc] Reading and importing data from the RS232 port to
Here is the test file TestSerial.ods.
Regards
Regards
- Attachments
-
- TestSerial.ods
- (15.07 KiB) Downloaded 815 times
Ubuntu 16.04.06 LTS
Libre Office 5.1.6.2
Windows 10
Libre Office 6.0.3.2 (x64)
Libre Office 5.1.6.2
Windows 10
Libre Office 6.0.3.2 (x64)
-
- Posts: 5
- Joined: Fri Oct 03, 2014 1:29 am
Re: [Calc] Reading and importing data from the RS232 port to Cal
Hi
Was there a successful result for this post. That is a working macro.
Thankyou
Charles
Was there a successful result for this post. That is a working macro.
Thankyou
Charles
Open Office 4.2.4.2
Linux Mint Cinammon
Linux Mint Cinammon