Author Topic: Transferring logged ECU data .CSV files  (Read 934 times)

hefy_jefy

  • Newbie
  • *
  • Posts: 27
  • Karma: +1/-0
Transferring logged ECU data .CSV files
« on: March 19, 2022, 11:37:09 PM »
I apologize if I have asked this question before but its come up again.  I use an iPad in the garage to communicate with the GS-911.  After each service on my R1200RTLC I reset the service counter and log about 10 mins of ECU data to my GS-911.  So I now have a number of .CSV files on my GS-911 that I would like to download and import into Excel on my PC.
Is there a simple way to do this?  I can connect via my PC to the GS-911 either wirelessly or via USB but I see no option to download the files.
I did mange to get the most recent file by sending it via email from my iPad, not even sure how that worked, the email did not have a file attached but a link to (I think) the GS-911, I had to copy/paste the email into a .txt file then rename it to a .CSV - there has to be an easier way?
Geoff

karlh

  • Newbie
  • *
  • Posts: 22
  • Karma: +0/-0
Re: Transferring logged ECU data .CSV files
« Reply #1 on: March 20, 2022, 02:22:34 PM »
Here's a quote from the Hex Code web site (https://www.hexcode.co.za/products/gs-911/support/faq/how-do-i-view-my-logged-data):

"How do I view my logged data?

In 2009 we added the ability to log real-time data.  As the GS-911 Interface itself does not have any flash memory to save logged data, the real-time data is saved on the host device (PC or mobile device). As a result, the capacity is dependent on how much free space there is on your host device (especially keep this in mind with older phones and mobile devices!).

The PC version logs the data to a .CSV file (semicolon ";" separated) - see the "How-do-i-import-and-view-the-csv-realtime-data" FAQ on how to view the .CSV data.

The Mobile versions have the ability to upload the logged data to our server.  This functionality is still in testing, hence there is no direct link to logbook application... Once you have uploaded the data from your mobile device, it will show you the URL to the logbook application: https://www.hexlogbook.com/logbook/

Any feedback would be appreciated!"

The logbook site is not yet up and running, so I'm not sure where your data is.
Karl
2007 R1200ST

WayneC

  • Beta testers
  • Hero Member
  • *
  • Posts: 1297
  • Karma: +27/-1
Re: Transferring logged ECU data .CSV files
« Reply #2 on: March 21, 2022, 01:15:59 AM »
Here's a quote from the Hex Code web site (https://www.hexcode.co.za/products/gs-911/support/faq/how-do-i-view-my-logged-data):

"How do I view my logged data?

In 2009 we added the ability to log real-time data.  As the GS-911 Interface itself does not have any flash memory to save logged data, the real-time data is saved on the host device (PC or mobile device). As a result, the capacity is dependent on how much free space there is on your host device (especially keep this in mind with older phones and mobile devices!).

The PC version logs the data to a .CSV file (semicolon ";" separated) - see the "How-do-i-import-and-view-the-csv-realtime-data" FAQ on how to view the .CSV data.

The Mobile versions have the ability to upload the logged data to our server.  This functionality is still in testing, hence there is no direct link to logbook application... Once you have uploaded the data from your mobile device, it will show you the URL to the logbook application: https://www.hexlogbook.com/logbook/

Any feedback would be appreciated!"

The logbook site is not yet up and running, so I'm not sure where your data is.

The info refers to the old yellow GS911 which does not have internal storage, it does not apply to the red GS911 WiFi which has internal storage

WayneC

  • Beta testers
  • Hero Member
  • *
  • Posts: 1297
  • Karma: +27/-1
Re: Transferring logged ECU data .CSV files
« Reply #3 on: March 21, 2022, 01:30:59 AM »
I apologize if I have asked this question before but its come up again.  I use an iPad in the garage to communicate with the GS-911.  After each service on my R1200RTLC I reset the service counter and log about 10 mins of ECU data to my GS-911.  So I now have a number of .CSV files on my GS-911 that I would like to download and import into Excel on my PC.
Is there a simple way to do this?  I can connect via my PC to the GS-911 either wirelessly or via USB but I see no option to download the files.
I did mange to get the most recent file by sending it via email from my iPad, not even sure how that worked, the email did not have a file attached but a link to (I think) the GS-911, I had to copy/paste the email into a .txt file then rename it to a .CSV - there has to be an easier way?
Geoff

I assume you have a red GS911 WiFi & are using a browser on the iPAD to communicate to the GS911, I also assume you have ticked save to SD card when doing the logging as you say you have multiple csv files showing as stored on the GS911

When you connect the GS911 to PC with USB you can log into the GS911 via browser & save the files to the PC assuming you have the GS911 & PC set up on your home WiFi network


hefy_jefy

  • Newbie
  • *
  • Posts: 27
  • Karma: +1/-0
Re: Transferring logged ECU data .CSV files
« Reply #4 on: March 21, 2022, 06:39:30 PM »
Thank you, yes I do have the red version.  However if I just connect it to my PC I don't see anywhere that I can download or view the the .CSV files. I can "View Debug Logs" (.log files) but they are not what I need.
If I connect the GS-911 to the bike I can connect via wireless and then I can view the .CSV files.  But there is no way to download them.  I got around the problem by opening the file, selecting all the text then copy/paste to a .TXT file on the PC.
I am sure in past versions it was much easier?
Geoff
 

WayneC

  • Beta testers
  • Hero Member
  • *
  • Posts: 1297
  • Karma: +27/-1
Re: Transferring logged ECU data .CSV files
« Reply #5 on: March 22, 2022, 01:52:22 AM »
Thank you, yes I do have the red version.  However if I just connect it to my PC I don't see anywhere that I can download or view the the .CSV files. I can "View Debug Logs" (.log files) but they are not what I need.
If I connect the GS-911 to the bike I can connect via wireless and then I can view the .CSV files.  But there is no way to download them.  I got around the problem by opening the file, selecting all the text then copy/paste to a .TXT file on the PC.
I am sure in past versions it was much easier?
Geoff

When the GS911 is plugged into US it will also log into your home WiFi if yoiu configure it to do so, then you can use the browser GUI to download the real time logs, it does not sound like you have the logging set to store logs to SD card though

hefy_jefy

  • Newbie
  • *
  • Posts: 27
  • Karma: +1/-0
Re: Transferring logged ECU data .CSV files
« Reply #6 on: March 22, 2022, 06:16:12 AM »
Thank you.  However nowhere in either the GS-911 Diagnostic app or the GS-911 wifi utility do I see a reference to log to an SD card.  Also I am logging to the device itself not an SD card.
Geoff

WayneC

  • Beta testers
  • Hero Member
  • *
  • Posts: 1297
  • Karma: +27/-1
Re: Transferring logged ECU data .CSV files
« Reply #7 on: March 22, 2022, 09:59:35 AM »
Thank you.  However nowhere in either the GS-911 Diagnostic app or the GS-911 wifi utility do I see a reference to log to an SD card.  Also I am logging to the device itself not an SD card.
Geoff

The SD card is internal to the GS911, I also indicated using the Web Browser to download the log files to PC not the WiFi utility od PC App

Have you set up the GS911 to log into your WiFi network ?, you can set that up with the WiFi Utility
« Last Edit: March 22, 2022, 10:04:09 AM by WayneC »

hefy_jefy

  • Newbie
  • *
  • Posts: 27
  • Karma: +1/-0
Re: Transferring logged ECU data .CSV files
« Reply #8 on: March 22, 2022, 09:30:18 PM »
I am clearly missing something here...
I plug the GS-911 which has the .CSV files stored on it into a USB port my PC, after a short time it beeps.
I run the GS-911 Diagnostics app, two devices appear, one via USB the other via wireless.
I can go to the Options page for either device but nowhere do I see a "log to SD" option, or any means of displaying the logged CSV files that are stored on the device.
I tried to a attached a screen shot of the options page, but for some reason that doesn't work "Internal Server Error".
 >:(
Geoff

Ruan

  • Administrator
  • Jr. Member
  • *****
  • Posts: 91
  • Karma: +2/-0
Re: Transferring logged ECU data .CSV files
« Reply #9 on: March 24, 2022, 03:10:32 PM »
Hi Geoff

Thank you for the details provided. Just so that this information is available for searches:
  • The GS-911 WiFi's SD card is used to store real time values that are logged while working on your motorcycle.
  • The logs that are available under the Options menu is what we call Debug logs, these are used in the event that something isn't working as expected, and our developers review it.

To access the real time values logged previously, you can navigate to any controller and select Real-Time values. Once here, it will display all the different values that can be viewed. From here please scroll all the way to bottom of the page, you'll see 3 options (1 greyed out initially), Display Values; Display Graph (greyed out); View Log History.

Select View log history and you'll see all the existing saved files from your device's SD card.

If you click on it and it doesn't download, but rather opens a new webpage with the text plainly pasted on the browser, right click anywhere and select "Save Page as..." - this will then open a standard dialog box that allows you to select a location for the .csv file to be stored.

Once saved, navigate to the location you saved it and open it with excel (or another spreadsheet application), and you will be good to go.

Feel free to let me know if you have any troubles.

Kind regards and safe travels
Ruan