@xabhax : Hi - I'm with
@Cuzoe, sounds like a torturous way to align the channel database settings in the new BCM!!
I have developed a BCM compare macro using MS Access and MX excel for swapping modules based on VCDS admaps - it produces a spreadsheet identifying the adaptation channels in the new BCM that need attention.
If you want to look at an example - download the spreadsheet
HERE (this is a real life case from the Ross-Tech forum). I suggest that you download the excel file and view it on a local PC because Dropbox doesn't handle my formatting well.
So, the columns in my spreadsheet are self explanatory (I hope) - but the target channels for attention are identified in the column headed "Same setting?" - which means for each of the channels listed, is the setting the same for both the "old" BCM and the "new" BCM? If the answer is NO - then the channel needs attention. As you can see, I've listed the NO entries first.
There are 3 x cases where the answer to "Same settings?" will be NO:
- The channel appears both in the old BCM and in the new BCM and the settings have different values
- The channel appears only in the new BCM
- The channel appears only in the old BCM
There are two workbooks in the spreadsheet : the first workbook lists ALL the channels in the new BCM and those channels in the old BCM that have the identical channel name (and their settings). The channels in case #2 above are also listed in the first workbook
The second workbook contains those channels in the old BCM that are not in the new BCM - so case #3 above.
If you provide admaps for the old and new BCMs - I can provide a BCM compare spreadsheet (it will save lots of time!!).
I've used these spreadsheets on lots of occasions - I simply print-off the tables with the "NO answer", then I sit in the car and start from the beginning of the list (making notes on the printed page for each channel). It's still not a quick process, but it's fairly easy (just lots of repetition!!)
Don