Page 1 of 1

Reading CSV with Libreoffice

Posted: Mon Feb 08, 2021 12:38 pm
by jameswhuxley
As someone who's never worked with macros before (although not a total ludite) I'm having an issue setting the macro up on Libreoffice.
Following a guide to set up a macro, and then pasting the MM macro, i get the following error:

BASIC syntax error.
Symbol Format already defined differently.

With this code highlighted

ActiveChart.SeriesCollection(1).DataLabels(datapoint).Format

Can anyone help. Please :)
J

Re: Reading CSV with Libreoffice

Posted: Mon Feb 08, 2021 2:02 pm
by James
I would encourage everyone to use the online charts rather than the excel macro. You only need to use excel if you're doing your own data processing, and even then I would recommend using MatLab rather than excel!

Re: Reading CSV with Libreoffice

Posted: Thu Feb 11, 2021 3:26 pm
by Peter Gamma
I'm regularly reading CSV data with Libreoffice. Do you really need macros for this? It is possible to just open the .csv in LibreOffice, and the importer is good.

Re: Reading CSV with Libreoffice

Posted: Thu Feb 11, 2021 3:54 pm
by James
The main thing that the Macro does is separate the Blink, Jaw Clench and optional user data markers.
They look like this in the file:

2021-02-11 11:02:07.605,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,/muse/elements/blink

If you were to directly graph the CSV without any processing, it probably wouldn't look right.

Also, the CSV data has each brainwave as separate electrodes (TP9,AF7,AF8,TP10), so when the macro runs it creates a new sheet with a single average for each brainwave, making the graph much more readable.

.. Or you can just use the online charts and it does all this for instantly ;-)

Re: Reading CSV with Libreoffice

Posted: Fri Feb 12, 2021 2:03 am
by Peter Gamma
Thank you James. I currently import only .csv files from a training tracker. But I will also import .csv files from mind monitor, to be able do analyse the physiological data with a database software.