HI Ronald The process and timelines are explained here https://labs.ripe.net/author/stefania_fokaeos/our-plan-to-fix-country-codes/ cheers denis co-chair DB-WG On Wed, 12 May 2021 at 22:21, Ronald F. Guilmette via db-wg <db-wg@ripe.net> wrote:
It is my understanding that it was decided that country: fields would be added into any & all org objects that did not already contain them.
I would just like to inquire about the current status and expected timeline for this project. Is there an expected completion date? Is RIPE NCC doing all of the work? Or is RIPE NCC instead just trying to cajole & browbeat the organizations themselves into adding the country fields themselves? (If the latter, than I have every faith & confidence that the project will be completed no later than Spring of 2173.)
Because I have a tool that tries to summarize the name & country of each org that has IP allocations, and because many org records in the RIPE data base still do not have the country information, I find that I still am needing to implement exceptions/workarounds in my code.
In any/most/all of these cases, inferring the proper country based on the snail-mail address of the org is what we here on this side of the pond would call a "no brainer". Here are a few examples of that:
'ORG-AA193-RIPE' => [ 'FR', 'GIE AUCHAN INTERNATIONAL TECHNOLOGY' ], 'ORG-LUC7-RIPE' => [ 'DE', 'ZF Active Safety GmbH' ], 'ORG-NNS5-RIPE' => [ 'CH', 'Nestle Nespresso S.A.' ], 'ORG-RSS4-RIPE' => [ 'ES', 'REALE SEGUROS GENERALES, S.A' ], 'ORG-SS244-RIPE' => [ 'FR', 'SOPRA HR Software SA' ], 'ORG-XISG1-RIPE' => [ 'DE', 'Atos IT Services GmbH' ],
A quick look at the WHOIS record for any of the above orgs shows that there is no real mystery about which country each one is in. (If there is any doubt, then simply googling the mailing address in the WHOIS clears that right up.)
The apparent fact that the country codes for the orgs listed above are altogether easy to reliably infer is only really relevant in the case where RIPE NCC itself (rather than the orgs) is doing the work to add the country fields into the org records that don't already have them.
Obviously, doing this on a large scale will be REALLY tedious work, but from a technical perspective, at least, it doesn't seem to be either a particularly hard task or a task which is particularly fraught with difficult-to-resolve ambiguities. (So I guess that's the "good news" part of the story. If RIPE NCC is doing the work, then they just have to find someone to sit and do this, 8 hours a day, until it is either finished or until that person goes blind or commits suicide due to the excessive tedium of the task.)
Regards, rfg