Firstly a big thank you to
dv52 (Australia) as always for his help with car coding and giving me lots of information about the VCDS Output.
The Macro Spreadsheet (can be found
here ) allows you to take a standard formatted OBD11 History extract and turn it into a better (for importing into databases) flat file.
I am no coder so this is cobbled together but on the sample data I have looked at it works for my requirements (just to be able to import easily)
There is no formal error control but for me that is not an issue and if you are a coder please feel free to improve on the code.
How to use it.
Open the spreadsheet
After the first run Delete all on the OBD11 Data Import sheet.
Copy backup file, past text into A1 of sheet OBD11 Data Import
Run Macro OBD11_Flat_File_Extract_macro
it takes a few minutes on a full backup and eventually you will go to sheet OBD11 CSV Extract and get the data as I want it
Example
Control unit: 01 Engine-Adaptations-Engine run-in oil pressure-Engine run-in oil pressure-not active
Control unit: 01 Engine-Adaptations-Deactivate production mode----:-0
The format is
Control Unit details - this is the description as displayed in the extract file
Delimiter I am currently using | but its easy to change
Extract Type - This will be Adaptations or Advanced identification
Delimiter as above
For AdaptationsParent Description - This is the value you will see when you go to Adaptation in the control unit using OBD11
Delimiter as above
Child Description - If there are children under the parent then again this will be shown here, if there are no children then ---: is what OBD11 Put in and I have just copied it for ease at this time
Delimiter as above
Actual setting this is the value you have set on the car.
For Advanced identification
As with the Adaptations you have a parent (Description you see in the list when you look at Advanced identificaiton
Then if there are multiple options (see below for how this looks) then each line has the child and value, if there is no child value then ---: again (see example below
Multiple children
Control unit: 01 Engine|Advanced identification|Maximum number of possible update programming|Bootloader|0
Control unit: 01 Engine|Advanced identification|Maximum number of possible update programming|Application|0
Control unit: 01 Engine|Advanced identification|Maximum number of possible update programming|Application 2|0
Control unit: 01 Engine|Advanced identification|Maximum number of possible update programming|Application 3|0
Control unit: 01 Engine|Advanced identification|Maximum number of possible update programming|Data record|0
No Child
Control unit: 01 Engine|Advanced identification-VW/Audi part number|---:|5G0906259E
Please note this will not work on an extract from this forum or others if the full obd11 formatting is not followed.
Don has advised me and I have seen it the naming convention in OBD11 is not always the same as VCDS, I have raised this directly with OBD11 Support but in the mean time the extract is the same as the import. I will over time have a look and see if I can find an easy solution to this but just be aware there may be differences between this and VCDS.
Obviously the first two values on current VCDS extract not in my world so cant replicate them so have used the Control unit and Extract type.
Last point i have built this so it works on both English and Spanish extracts, if you use it on other languages then it will not display the Control Unit description.
If you find issues with it (not the coding please just issues with the output) then let me know and I will do my best to fix it.