Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Download format for "All Results" in search #710

Open
wrenaria opened this issue Jan 27, 2025 · 2 comments
Open

Download format for "All Results" in search #710

wrenaria opened this issue Jan 27, 2025 · 2 comments
Assignees

Comments

@wrenaria
Copy link

From speaking with users, it seems like exporting one content type at a time is sufficient for most needs rather than a combined view of results in one file. For the "All Results" view of search, I think we ought to download the mixed results as separate CSV files rather than try to combine the data into one CSV.

For example, if someone performs a search that has a mix of people, grants, and publications in the results selected for download, we would provide them with a zip file containing an experts.csv, grants.csv, and works.csv.

They receive all the required data in an understandable format and it simplifies our management of the data we provide.

@UcDust
Copy link
Collaborator

UcDust commented Jan 29, 2025

@Vensberg
Do you know what the final format will be (ie columns) for each of the download types (experts / grants / works)?

@Vensberg
Copy link
Collaborator

@UcDust , for grants, let's have most of the elements of the profile CSV
Title | Funding Agency | Grant id {the one given by the agency, not ours} | Start date | End date | Type of Grant | List of PIs and coPIs {separate contributors by ";"} | Other Known Contributors {separate contributors by ";"} |

Note that in this case the Researcher role is taken out, and Other Known Contributors is added. The Other Known Contributors will be non-PI and non-CoPI personnel from older grants or personnel who added themselves manually though Elements.

For works,
Type of Work | Title | Authors {separate contributors by ";"; if more than 10 contributors, use et.a;.)| Year | Journal OR Book | Volume | Issue | Pages | DOI or URL | Abstract

this should map to the RIS file datafields as follows:

TY | TI | AU | DA | T2 or C3 | VL | IS | SP | DO | AB

Which reminds me -- we don't bring in URLs when they are not DOIs. We should revisit that.

@qjhart qjhart removed their assignment Jan 30, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants