Updating the Members Publications (Bibliometrics) Sheet

Here is the Google Sheet used to collect and store publications information of each OSC member:

To add the bibliometrics of a new member, follow these steps:

  1. Check whether the member already exists by searching the sheet for the member’s last name. A member is considered to already exist in the system if at least one of their entries has a 1 in both of the first two columns. If the member is already present, simply add any additional OpenAlex IDs if necessary. If the member is not present, continue with the next step.

  2. Find the OpenAlex Author ID on the OpenAlex website. Search for the person by name, affiliation, publications, or research field. In the search results, click the person’s name and then select Author profile. The URL of the profile page corresponds to the OpenAlex author ID.

Example:

https://openalex.org/authors/A5061123357
TipAlternative Method: Using the R Script
  1. Open 01b-Add_members.R.
  2. Modify the search string.
  3. Run the script.
  4. Inspect the results object to identify the correct OpenAlex author ID.
  1. Add the information to the OSC Author List. Add one row for each valid OpenAlex ID.

The following cells must be updated:

Column Information
A Enter 1
B Enter 1
C Enter the osc_id
E Enter the OpenAlex ID
G Enter the official display_name

Creating the osc_id

The osc_id must:

  • be unique for each OSC member;
  • remain consistent across all entries for that member.

General rule:

  • Use the member’s last name only.
  • If multiple members share the same last name, append the first initial.

Examples:

Schulz
SchulzC
SchulzE

Formatting the OpenAlex ID

Use the following format:

https://openalex.org/A5061123357

Important: The ID must:

  • contain a capital A;
  • not contain /authors/.

Example:

https://openalex.org/A5061123357

Special Cases

If the Person Already Exists

Simply add the new OpenAlex ID.

Example:

1 | 1 | lastname | lastname firstname | OpenAlex ID | firstname lastname

What happens next?

Felix renders the LRZ GitLab repository https://gitlab.lrz.de/lmu-open-science-center/OSC-bibliometrics around once or twice a year to create the website https://www.resources.osc.lmu.de/bibliography/ currently only linked in the main website through the About Page https://www.osc.lmu.de/about/#meta-research-hub.

Back to top