justingonder
commented
2 weeks ago TSV file upload not allowed. Located in Trello: https://trello.com/c/wgX3s8st
Open justingonder opened 2 weeks ago
justingonder
commented
2 weeks ago TSV file upload not allowed. Located in Trello: https://trello.com/c/wgX3s8st
AICRJ have provided us a massive data dump from their previous reviewer database and would like us to import this into Janeway.
I tried a test using the Reviewer Import plugin, but failed.
Esther Verreau Aug 15, 2024, 1:48 PM The problem with interests is a bug in the plugin. LMK if they want it, we’ll have to fix it.
Reply • Delete Esther Verreau Aug 15, 2024, 1:43 PM @justingonder Another issue: the expertise column sometimes truncates in the middle of a word. If they want to use it they should clean that up.
Reply • Delete Esther Verreau Aug 15, 2024, 12:56 PM @justingonder I did a test import with 2 users to dev. I turned the “expertise” column to interests (not sure if that’s what they want). That looks all munged up. If they want that we may need to reformat that column.
https://journalpub-dev.escholarship.org/aicrj/manager/user/26808/edit/
Reply • Add link as attachment • Delete Esther Verreau Aug 15, 2024, 12:33 PM I got it. I imported to google docs and got a tsv. There are some problems with this document. 1. Some of these don’t have email addresses. I don’t think we can create an account without one.
Countries are expressed incorrectly (should be country codes: https://journalpub-dev.escholarship.org/admin/core/country/) It should follow the format in the docs. (Reviewer Import — Janeway Imports 1.5 documentation ) Unfortunately this code uses column indexes and not names. Reply • Add link as attachment • Delete Justin Gonder Aug 15, 2024, 12:04 PM @estherverreau4 weird - TSV is gone from my Excel too. Apple’s Numbers app was able to do it though.
Edit • Delete Esther Verreau Aug 15, 2024, 9:28 AM @justingonder can you save this file as tsv? sorry, my excel won’t let me do it.
Reply • Delete Justin Gonder Aug 14, 2024, 5:04 PM @estherverreau4 i think this is another one we’ll probably have to look at the command line for. there is also extraneous data in this export that i’m not sure we can map or not. this isn’t a fire, but we have been having a rough time with AICRJ lately, so they’ll no doubt be pinging us in the weeks ahead. we can grab some time to discuss when it’s convenient.