I was working on a way to figure out what's what for formulaic processing for screen scraped data, I found I had to manually turn the points Into distance for an event, not difficult... Until you need to add on ECEs, you can't rely on the E in the homologation number.
From that and previous comments about event types I suspect the legacy data being wooly about what's what is more likely to be problem if the new data structure is more explicit on combining events with their extension.
I got bored after than and went out for a bike ride and never went back to it so I'm still using my spread sheet.
Exactly, but that's if you migrate the legacy data as is, which would be foolish. Even a small amount of processing would make it much simpler to deal with.
ECEs were shoehorned into the existing system[1] rather than a little redesign and corresponding small data migration. (Very easy to say this with the benefit of hindsight.)
There are various limitations of the ECE system where the source of the limitation is the current DB schema and various constraints rather than Martin's desire to set arbitrary restrictions.
1. And to be fair to them, by the unpaid volunteer(s) and, most importantly, successfully. Plus the "system will be gone soon" was always looming on the horizon so fixing it "properly" was probably stuck on the end of the existing large TODO list that would get thrown away with the old system.
I'm thinking more along the lines of difficulty and therefore cost of migration.
I'd assume standard events would be easy to add because the basic schema can't be all that different, oh except if it holds distances then working out if a BP is 50,100, 150 or even a non BR 200 isn't possible from the current visible lists too.
So it depends on what's behind the scenes, event code and main event record which has the distance?
But anyway automating the migration of BRs should be fairly easy, the exceptions must depend on what's behind the scenes whether they can be automated or have to be done manually.
Hindsight great, if only we had it before doing stuff!
Sent from my BKL-L09 using Tapatalk