fixtures: update ROR affiliations data as of `2024-05-02`

:heart: Thank you for your contribution!

Description

Updated ROR data as of 2024-05-02 (last updated 3 years ago)
Source: https://github.com/ror-community/ror-data/blob/main/v1.46-2024-05-02-ror-data.zip
Converted "v1.46-2024-05-02-ror-data.json" with allow_unicode=False
Included additional title languages, where available
Included acronyms only where they exist

Here is the code used to convert the data for easier review:

import json
import yaml

def convert_json_to_yaml(json_filepath, yaml_filepath):
    with open(json_filepath, 'r', encoding='utf-8') as json_file, open(yaml_filepath, 'w', encoding='utf-8') as yaml_file:
        data = json.load(json_file)

        yaml_data = []
        for item in data:
            identifier_entry = {
                'identifier': item['id'].split('/')[-1],
                'scheme': 'ror'
            }

            # Prepare the title structure with translations if available
            title = {'en': item['name']}  # default to English title
            for label in item.get('labels', []):
                if label.get('iso639') and label.get('label'):
                    title[label['iso639']] = label['label']

            # Prepare the basic YAML entry structure
            yaml_entry = {
                'id': item['id'].split('/')[-1],
                'name': item['name'],
                'title': title,
                'identifiers': [identifier_entry]
            }

            # Check if acronyms is not empty and add if it's not
            if item['acronyms'] and item['acronyms'][0] != "":
                yaml_entry['acronym'] = item['acronyms'][0]

            yaml_data.append(yaml_entry)

        yaml.safe_dump(yaml_data, yaml_file, allow_unicode=False, default_flow_style=False)

json_input = "v1.46-2024-05-02-ror-data.json"
yaml_output = "affiliations_ror.yaml"

convert_json_to_yaml(json_input, yaml_output)

Checklist

Ticks in all boxes and 🟢 on all GitHub actions status checks are required to merge:

[ ] I'm aware of the code of conduct.
[ ] I've created logical separate commits and followed the commit message format.
[ ] I've added relevant test cases.
[ ] I've added relevant documentation.
[ ] I've marked translation strings.
[ ] I've identified the copyright holder(s) and updated copyright headers for touched files (>15 lines contributions).
[ ] I've NOT included third-party code (copy/pasted source code or new dependencies).
- If you have added third-party code (copy/pasted or new dependencies), please reach out to an architect.

Frontend

[ ] I've followed the CSS/JS and React guidelines.
[ ] I've followed the web accessibility guidelines.
[ ] I've followed the user interface guidelines.

Reminder

By using GitHub, you have already agreed to the GitHub’s Terms of Service including that:

You license your contribution under the same terms as the current repository’s license.
You agree that you have the right to license your contribution under the current repository’s license.

inveniosoftware / cookiecutter-invenio-rdm

fixtures: update ROR affiliations data as of `2024-05-02` #281

Description

Checklist