Alternative Data Analysis - AEMData

160 And 8192 Baud Aldl
User avatar
Posts: 4991
Joined: Sun Mar 01, 2009 2:54 pm
Location: Perth, WA

Alternative Data Analysis - AEMData

Postby VL400 » Wed Jun 03, 2015 12:55 pm

It was mentioned a few weeks back that AEMdata could import CSV files (viewtopic.php?f=16&t=92&start=190#p53948). Had a look and overall AEMData looked like it could be very useful, heaps of features just playing around with the demo project files.

Well it turns out that the feature is no longer working in the current release 4.1.1, but there is still a workaround to get TunerPro logs imported :thumbup: You need to download and install two programs...
AEMData Download - http://www.aemelectronics.com/?q=produc ... s-software
Dlog99 Download - http://www.gems.co.uk/?content=pages&id ... -downloads (down the bottom of this page, Version: 1.92.03)


Open TunerPro, along with your ADX and XDL. and export the log...
ExportTP.png
ExportTP.png (18.01 KiB) Viewed 6233 times


This will give you the option of what to export, choose what you want or export all items. The exported file is a CSV file, but its not the correct format for Dlog99. Use this excel macro I threw together (let me know of any issues and will fix them)...
ConvertToDlog99 V102.xlsm
(22.84 KiB) Downloaded 331 times


Click the big button to open a file dialog and choose the file you just exported from TunerPro, when its finished you will have a modified CSV for Dlog99 importing. Excel is odd and has all sorts of popups asking to keep the format etc. Its easier to just close excel and when it asks to save the file say yes.

Now open Dlog99. Under the file menu select import...
Import CSV 1.png
Import CSV 1.png (26.39 KiB) Viewed 6233 times


Select the modified CSV to import and this screen pops up, select float import and click import...
Import CSV 2.png
Import CSV 2.png (18.69 KiB) Viewed 6233 times



It will then ask to save a .stf file (this is the file for AEMData) so do that. DLog99 is also a data analysis program so it will prompt you to draw some plots, click draw and then close the program (we only want to use the Dlog99 program to get an stf file).

Now open AEMData and choose 'Open log file in new project', then empty project. It will open a file explorer, select the stf file you previously saved.

And that should be it, can get all the channels in AEMData. Happy playing :D

AEMData.png


Old versions of the conversion macro..
ConvertToDlog99 V100.xlsm
(23.38 KiB) Downloaded 245 times

ConvertToDlog99 V101.xlsm
(22.77 KiB) Downloaded 263 times

User avatar
Posts: 10075
Joined: Sat Feb 28, 2009 9:05 pm
Location: Tenambit, NSW

Re: Alternative Data Analysis - AEMData

Postby Holden202T » Wed Jun 03, 2015 12:58 pm

nice!

Posts: 1183
Joined: Sun Mar 15, 2009 10:20 am
Location: Geelong, VIC

Re: Alternative Data Analysis - AEMData

Postby yoda69 » Wed Jun 03, 2015 3:09 pm

Will have to have a look, data analysis is something I'm fairly familiar with.
I use IMC FAMOS as I use it at work, Reader version is free but Standard and above need a licence although can get a 30 day trial.
Can read many file formats and can also setup custom imports.
I've used the licensed version for plotting gps coordinates and then linking back to a data in the same file can show where a particular issue actually happened, at what point things were hot etc.
Licensed version can also be used to create new data by applying formulas to existing data if required.
http://www.imc-berlin.com/products/meas ... mos/#c8597

Overall not bad to use but like most of this type of software can be initially difficult to work out how things work and a lot of time is spent in the help file which are fairly comprehensive.

User avatar
Posts: 4991
Joined: Sun Mar 01, 2009 2:54 pm
Location: Perth, WA

Re: Alternative Data Analysis - AEMData

Postby VL400 » Wed Jun 03, 2015 4:37 pm

The GPS and math functions were why I liked the AEM software, with GPS and distance it will do lap timing and overlays.

It also applies selective analysis (either just selecting parts of the log or by filters), so you can ignore parts of the data when plotting histograms or other plots.

The IMC software looks REALLY full on. Will certainly take some learning.

Posts: 414
Joined: Wed Mar 04, 2009 8:52 pm

Re: Alternative Data Analysis - AEMData

Postby ejukated » Wed Jun 03, 2015 8:57 pm

VL400 wrote:The GPS and math functions were why I liked the AEM software, with GPS and distance it will do lap timing and overlays.

It also applies selective analysis (either just selecting parts of the log or by filters), so you can ignore parts of the data when plotting histograms or other plots.

The IMC software looks REALLY full on. Will certainly take some learning.


Did you get the Maths functions to work with the Dlog imported file? I couldn't get it to work previously, I think it had to be in the newer file format which Dlog doesn't support, didn't have time to see if I could work out the new data format.

User avatar
Posts: 4991
Joined: Sun Mar 01, 2009 2:54 pm
Location: Perth, WA

Re: Alternative Data Analysis - AEMData

Postby VL400 » Wed Jun 03, 2015 10:05 pm

Correct, math does not really work with this free option when working with STF files.

The solution is Gems Data Analysis Pro (it wasnt mentioned in the original post as it costs $$), it allows CSV import and math functions. You will find this software looks very similar to the AEMdata software.

Edit: What does work in the free AEMdata is math applied to one data log, you cant have a math function for an entire project.
AEMEdit.png
AEMEdit.png (54.89 KiB) Viewed 6153 times


AEMEdit1.png
AEMEdit1.png (53.19 KiB) Viewed 6153 times


AEMScreen.png

User avatar
Posts: 4991
Joined: Sun Mar 01, 2009 2:54 pm
Location: Perth, WA

Re: Alternative Data Analysis - AEMData

Postby VL400 » Thu Jun 04, 2015 8:17 pm

Updated the macro to now handle flags, it slows it down a bit so have left previous versions. I dont know how to import flags from CSV with ASCII names to Dlog99/AEMLog (might not even be possible?) so it replaces the flag state text with a 1 or 0 (there is a lookup table of names that you can add to).

All flags can be shown in the trace view which is handy, shown here is TCC lockup...
Flags.png

Posts: 1183
Joined: Sun Mar 15, 2009 10:20 am
Location: Geelong, VIC

Re: Alternative Data Analysis - AEMData

Postby yoda69 » Fri Jun 05, 2015 5:10 am

Very nice.
Might have to have a look at this software on the weekend, particularly like the track feature built in.

Posts: 2
Joined: Wed Aug 08, 2018 2:02 am

Re: Alternative Data Analysis - AEMData

Postby crispy » Wed Aug 08, 2018 2:03 am

Hi guys, older thread, I know.

It seems that GEMS no longer has the dlog99 software on its downloads page. Can anyone help me out?

Thanks very much!

User avatar
Posts: 10075
Joined: Sat Feb 28, 2009 9:05 pm
Location: Tenambit, NSW

Re: Alternative Data Analysis - AEMData

Postby Holden202T » Wed Aug 08, 2018 3:28 pm

dlog99setup.zip
(1.43 MiB) Downloaded 292 times

Next

Return to ALDL, OBDII Logging and Scanning

Who is online

Users browsing this forum: No registered users and 2 guests