[opensuse] OT: spreadsheet format
I have some 'spreadsheet' files that I want to read on Leap. They are produced by a logging device (a Rotronic CL11) plugged into the manufacturer's app on Win10 and have names that end in .XLS but they are text files in a kind of mixed ini-file and TSV (tab-separated values) format. They start off with ini file sections describing each of the columns of data (humidity, CO2, temp) and then there's a section with a TSV list of all the logged data values. Does anybody recognize this format and/or have any ideas of applications that can read or import it? I tried feeding it to libreoffice calc but it opened them as text files. Failing any suitable app, I guess I'll write a program to convert it to pure CSV or something. Cheers, Dave -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
Dave Howorth wrote:
I have some 'spreadsheet' files that I want to read on Leap. They are produced by a logging device (a Rotronic CL11) plugged into the manufacturer's app on Win10 and have names that end in .XLS but they are text files in a kind of mixed ini-file and TSV (tab-separated values) format. They start off with ini file sections describing each of the columns of data (humidity, CO2, temp) and then there's a section with a TSV list of all the logged data values.
Does anybody recognize this format and/or have any ideas of applications that can read or import it? I tried feeding it to libreoffice calc but it opened them as text files.
I don't recognise the format, but according to the instruction manual, Excel should be able to open it. It also mentions export to other formats, but doesn't list which ones. -- Per Jessen, Zürich (20.4°C) http://www.dns24.ch/ - your free DNS host, made in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On Wed, May 11, 2016 at 10:13 AM, Dave Howorth
I have some 'spreadsheet' files that I want to read on Leap. They are produced by a logging device (a Rotronic CL11) plugged into the manufacturer's app on Win10 and have names that end in .XLS but they are text files in a kind of mixed ini-file and TSV (tab-separated values) format. They start off with ini file sections describing each of the columns of data (humidity, CO2, temp) and then there's a section with a TSV list of all the logged data values.
Does anybody recognize this format and/or have any ideas of applications that can read or import it? I tried feeding it to libreoffice calc but it opened them as text files.
Failing any suitable app, I guess I'll write a program to convert it to pure CSV or something.
You could probably write an AWK script in 5 minutes to strip off the header. If you want to get more exotic, python-xlswriter is in OBS and factory (not Leap 42.1): https://build.opensuse.org/package/show/devel:languages:python/python-xlsxwr... I think there is a perl equivalent as well. Greg -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 05/11/2016 07:13 AM, Dave Howorth wrote:
I have some 'spreadsheet' files that I want to read on Leap. They are produced by a logging device (a Rotronic CL11) plugged into the manufacturer's app on Win10 and have names that end in .XLS but they are text files in a kind of mixed ini-file and TSV (tab-separated values) format. They start off with ini file sections describing each of the columns of data (humidity, CO2, temp) and then there's a section with a TSV list of all the logged data values.
Does anybody recognize this format and/or have any ideas of applications that can read or import it? I tried feeding it to libreoffice calc but it opened them as text files.
Failing any suitable app, I guess I'll write a program to convert it to pure CSV or something.
Cheers, Dave
I have similar non-standard CSV files where the producer used TABS instead of Commas. I routinely open them with LibreOffice Calc. (Start in CALC, not from the linux file manager). It asks what characters should be used as separators, and shows a spread sheet sample reprsentation so that you can check it out. There are command line ways to tell it this ahead of time if you need that. -- After all is said and done, more is said than done. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 2016-05-12 18:59, John Andersen wrote:
I have similar non-standard CSV files where the producer used TABS instead of Commas. I routinely open them with LibreOffice Calc. (Start in CALC, not from the linux file manager). It asks what characters should be used as separators, and shows a spread sheet sample reprsentation so that you can check it out.
It works even if there is a header. You simply have to remove the rows later. -- Cheers / Saludos, Carlos E. R. (from 13.1 x86_64 "Bottle" at Telcontar)
On 2016-05-12 19:39, Carlos E. R. wrote:
On 2016-05-12 18:59, John Andersen wrote:
I have similar non-standard CSV files where the producer used TABS instead of Commas. I routinely open them with LibreOffice Calc. (Start in CALC, not from the linux file manager). It asks what characters should be used as separators, and shows a spread sheet sample reprsentation so that you can check it out.
It works even if there is a header. You simply have to remove the rows later.
Unfortunately, it doesn't work with these files. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 2016-05-13 11:53, Dave Howorth wrote:
On 2016-05-12 19:39, Carlos E. R. wrote:
On 2016-05-12 18:59, John Andersen wrote:
Unfortunately, it doesn't work with these files.
Perhaps you can upload a sample file somewhere and we can try. -- Cheers / Saludos, Carlos E. R. (from 13.1 x86_64 "Bottle" at Telcontar)
On Fri, 2016-05-13 at 13:12 +0200, Carlos E. R. wrote:
On 2016-05-13 11:53, Dave Howorth wrote:
Unfortunately, it doesn't work with these files.
Perhaps you can upload a sample file somewhere and we can try.
I just tried to upload a file to susepaste.org The first time it succeeded at http://susepaste.org/4686563 but the file is empty when I download it. I did that attempt by browsing for a file. The second time it failed 404 at http://susepaste.org/8268491 ?! I did that by pasting the text into the susepaste box. What am I doing wrong? Cheers, Dave PS Sorry it's taken so long! -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 2016-05-17 01:17, Dave Howorth wrote:
On Fri, 2016-05-13 at 13:12 +0200, Carlos E. R. wrote:
On 2016-05-13 11:53, Dave Howorth wrote:
Unfortunately, it doesn't work with these files.
Perhaps you can upload a sample file somewhere and we can try.
I just tried to upload a file to susepaste.org
The first time it succeeded at http://susepaste.org/4686563 but the file is empty when I download it. I did that attempt by browsing for a file.
The second time it failed 404 at http://susepaste.org/8268491 ?! I did that by pasting the text into the susepaste box.
What am I doing wrong?
I don't know... Perhaps susepaste did not like the content, thought it was spam or something, and deleted the paste. As there is no registration, it can happen. An alternative is google drive :-?
Cheers, Dave
PS Sorry it's taken so long!
No, don't worry. With mail lists I assume that people answer when they can, not immediately. A week or more is not a problem unless one has to study previous emails to know what it is about. And it is not the case :-) -- Cheers / Saludos, Carlos E. R. (from 13.1 x86_64 "Bottle" at Telcontar)
On 2016-05-17 02:01, Carlos E. R. wrote:
On 2016-05-17 01:17, Dave Howorth wrote:
On Fri, 2016-05-13 at 13:12 +0200, Carlos E. R. wrote:
On 2016-05-13 11:53, Dave Howorth wrote:
Unfortunately, it doesn't work with these files.
Perhaps you can upload a sample file somewhere and we can try.
I just tried to upload a file to susepaste.org
The first time it succeeded at http://susepaste.org/4686563 but the file is empty when I download it. I did that attempt by browsing for a file.
The second time it failed 404 at http://susepaste.org/8268491 ?! I did that by pasting the text into the susepaste box.
What am I doing wrong?
I don't know... Perhaps susepaste did not like the content, thought it was spam or something, and deleted the paste. As there is no registration, it can happen.
An alternative is google drive :-?
That would require me to create an account with a firm that may be fined 3 bn euro and that makes its money by trying to track me! susepaste just failed again in exactly the same ways with a completely different version of firefox on a different machine. So here's the start of one of the files. It has all of the structure but just a few rows of data. Hopefully you can cut and paste: [#I]Device description 81412002 [#S]Device Info Version = 88299V1.0 Serial number = CL11 File name = ensuite-co2.XLS Interval = 00:00:30 [#1] Humidity = %rh Alarm low = -.- Alarm high = -.- [#2] Temperature = °C Alarm low = -.- Alarm high = -.- [#3] CO2 = PPM Alarm low = -.- Alarm high = -.- [#4] Temp (Ext) = °C Alarm low = -.- Alarm high = -.- [#H] Date Time Humidity Temperature CO2 Temp (Ext) [#D] 05/05/2016 18:51:00 36.80 25.39 580 --.- 05/05/2016 18:51:30 37.90 25.33 682 --.- 05/05/2016 18:52:00 36.70 25.22 731 --.- 05/05/2016 18:52:30 36.40 25.11 726 --.- 05/05/2016 18:53:00 36.20 25.00 700 --.- 05/05/2016 18:53:30 36.10 24.94 656 --.- 05/05/2016 18:54:00 35.80 24.89 616 --.- 05/05/2016 18:54:30 35.60 24.83 587 --.- 05/05/2016 18:55:00 35.70 24.78 569 --.- 05/05/2016 18:55:30 35.60 24.72 554 --.- 05/05/2016 18:56:00 35.80 24.67 546 --.- 05/05/2016 18:56:30 35.70 24.67 539 --.- 05/05/2016 18:57:00 35.70 24.61 535 --.- 05/05/2016 18:57:30 35.80 24.61 528 --.- 05/05/2016 18:58:00 35.80 24.61 525 --.- 05/05/2016 18:58:30 35.80 24.56 520 --.- 05/05/2016 18:59:00 35.80 24.56 520 --.- 05/05/2016 18:59:30 35.80 24.56 518 --.- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
Dave Howorth composed on 2016-05-17 09:45 (UTC+0100):
I just tried to upload a file to susepaste.org
The first time it succeeded at http://susepaste.org/4686563 but the file is empty when I download it. I did that attempt by browsing for a file.
The second time it failed 404 at http://susepaste.org/8268491 ?! I did that by pasting the text into the susepaste box.
What am I doing wrong? ... susepaste just failed again in exactly the same ways with a completely different version of firefox on a different machine.
There are other places to paste:
http://paste.debian.net/
http://pastebin.com/
http://pastebin.ubuntu.com/
https://paste.fedoraproject.org/
http://pastebin.com/u/Gentoo
On 2016-05-17 10:45, Dave Howorth wrote:
On 2016-05-17 02:01, Carlos E. R. wrote:
An alternative is google drive :-?
That would require me to create an account with a firm that may be fined 3 bn euro and that makes its money by trying to track me!
Who cares? :-) Just use it occasionally. You do not need to use it everytime. Hint: they are tracking you already without an account.
susepaste just failed again in exactly the same ways with a completely different version of firefox on a different machine. So here's the start of one of the files. It has all of the structure but just a few rows of data. Hopefully you can cut and paste:
You could email a sample directly to those people asking, like me. No promises, but I want to have a look. Just compress with gz and attach - without compressing sometimes some files are handled as text and corrupted. If you want, I can then upload it to g-drive. -- Cheers / Saludos, Carlos E. R. (from 13.1 x86_64 "Bottle" at Telcontar)
Dave Howorth wrote:
So here's the start of one of the files. It has all of the structure but just a few rows of data. Hopefully you can cut and paste:
This looks very much like a ini-file followed by your TSV data. I am not aware of any file-format to combines the two, but stripping off the ini data should be easy - egrep '^[0-9][0-9]/' <file> -- Per Jessen, Zürich (13.0°C) http://www.hostsuisse.com/ - dedicated server rental in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 2016-05-17 10:53, Per Jessen wrote:
Dave Howorth wrote:
So here's the start of one of the files. It has all of the structure but just a few rows of data. Hopefully you can cut and paste:
This looks very much like a ini-file followed by your TSV data. I am not aware of any file-format to combines the two, but stripping off the ini data should be easy -
egrep '^[0-9][0-9]/' <file>
I'm part way through writing a program to convert it to something usable so thanks for the (admittedly negative) confirmation that I'm not wasting my time. BTW, the original file has CRLF line endings that got translated to two line endings when I posted the extract into Thunderbird, so the file itself isn't double-spaced. Cheers, Dave -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
participants (7)
-
Carlos E. R. -
Dave Howorth -
Dave Howorth -
Felix Miata -
Greg Freemyer -
John Andersen -
Per Jessen