kur4o wrote:The mandatory fields are: Vehicle make,type, platform, engine type[displacement], trans and driveline. Not any of this can be found in the bin, Only by decoding the vin and the rpo codes. Or you can define each cal part number. For example p/n xxxxxxxxx- engine cal for 2003 5.3l lm3 used with OS yyyyyyyy.
Thanks.
Yes, I figured VIN decoding would be part of it and I have done so for the ones I have processed so far. Unfortunately RPO codes would be difficult to pull unless a free online vin->rpo source could be found. Once the structure is defined more an automated process against the Repo could be generated for processing cals and other such info.
I will start building out a rough XML structure for now, although moving forward I will need to figure out a tool that can process these automatically or semi-automatically.
Hello,
I don't know excel very well. When I save csv and open in excel all of it is a mess garbled together. I'm sure it's something simple stupid I need to do to the format if someone wants to point me to a readme on it.
Thanks
Gampy,
I did make some progress, a couple of the hex id's are trying to become a formula so I'll keep messing with it but huge gains from where it started.
Thanks
Hex and excel don't get along so well, it's a conversion nightmare, yea it's doable, butt ugly!
Best to convert pre import.
If you want, PM me your csv (or an example of the troublesome area) and I'll tell ya how to sort it out. Excel and I have had a long term relationship.
Intelligence is in the details!
It is easier not to learn bad habits, then it is to break them!
If I was here to win a popularity contest, their would be no point, so I wouldn't be here!
PM and file sent,
Using Universal Patcher if you open a .bin then go to the File Info tab there is a button for "Save CSV" that I am trying to use. You can try with any file.
Thanks
Gampy wrote:It would be best if we can get joukoy to convert the hex values to decimal on export and do a little cleaning.
-Enjoy
Version 0.12.38 have new button: "Export to CSV(Dec)"
It is done "wrong way", converting from hex values to decimal while exporting, but I think it works ok.
"Right way" is storing values as decimal when reading from binary, but this requires too much work.
Can you do two more things please ...
1. Clean up the eeprom_data row so it's valid csv. (add fields)
2. Change the format of the Address field on the OS row, it is currently,