This Streamlit app helps identify and semi-automatically bulk relate publications to projects in Elsevier's Pure using project identifiers and DOIs.
It supports a wide range of identifier types, such as External Project ID, Contract ID, and Horizon ID — based on your local Pure configuration.

• Looks up the project using the provided ProjectID (or just the Pure Project UUID).
• Searches for the publication in Pure based on the DOI.
• Validates matches to ensure accuracy and prevent incorrect links.
• Flags existing relations and determines which are ready to be linked.
• Displays the matched identifier type and warns about ambiguous project matches.
• Includes a dry run mode for safe pre-inspection of potential changes.

This tool is especially useful if you have a list of projects and related publications from systems like OpenAlex, CORDIS, or other external sources.
With this assistant, you can semi-automatically set these relations inside Pure, if the identifiers and DOIs are available.

1. Upload a CSV with two columns: ProjectID and DOI
   (Both comma , and semicolon ; separators are supported.)
2. Run the tool in Dry run mode to preview matches and issues.
3. Filter the result to remove ambiguous or unmatched rows.
4. Re-upload the cleaned file and run again with Dry run disabled to apply the changes. (Cleaning the file speeds up the writeback process)

• Skips over ambiguous matches (or warns about them).
• Ensures no existing publication links are overwritten — it appends only.
• Option to download the result and edit outside Streamlit.
• Logs all changes made during writeback.

ProjectID,DOI
101137074,10.1080/17459737.2017.1406012
H2020-ICT-2018-2,10.1016/j.patter.2020.100150

Created by:
Søren Vidmar
🔗 ORCID
🏫 Aalborg University
📧 sv@aub.aau.dk
📦 GitHub

This tool is designed to help reduce manual work and improve the data quality and completeness of research project-publication relations in Pure.