OVID export
I want to cry!
I'm trying to get a reference list of ~3000 references off OVID (having done my beautiful systematic literature search) and into Zotero.
I have tried every format I can, but RIS insists upon importing every item as a webpage, which is meaningless.
Is there ANY way that this can be fixed? Should I go to the RIS file and change every TY - ELEC to TY - JOUR? But what about the references that aren't actually journal articles and are, instead, book chapters, or clinical trial information?
Are there any workarounds which won't involve me selecting all items on this page (using the URL bar translator)? Ovid only allows you to 'see' 100 at a time, so I'd have to do that 30 times. I CAN do it, I'd just really really REALLY rather not.
Many thanks!
I'm trying to get a reference list of ~3000 references off OVID (having done my beautiful systematic literature search) and into Zotero.
I have tried every format I can, but RIS insists upon importing every item as a webpage, which is meaningless.
Is there ANY way that this can be fixed? Should I go to the RIS file and change every TY - ELEC to TY - JOUR? But what about the references that aren't actually journal articles and are, instead, book chapters, or clinical trial information?
Are there any workarounds which won't involve me selecting all items on this page (using the URL bar translator)? Ovid only allows you to 'see' 100 at a time, so I'd have to do that 30 times. I CAN do it, I'd just really really REALLY rather not.
Many thanks!
We may eventually look at an import specifically for OVID's own data format, but it's a dumb format and I don't get why they don't just export something standard.
Quick question because I seem unable to find the long list. Is there a list anywhere of the pt/TY's*?
I had a look at SQLlite and can see that itemtypeid=4 for typeName=journalArticle.
Can I therefore edit my ris files to say TY=4 instead of TY=JOUR?
Many thanks for your support. I understand the frustration with Ovid (oh. so. well.)
*I have things like conference proceedings/protocols/manuscripts etc. it's all very mixed up.
Here's a list of RIS tags and what they mean. They don't all have clear Zotero equivalents, but most are pretty clear.
https://github.com/aurimasv/translators/wiki/RIS-Tag-Map-(narrow)
Alas, it's seriously a mess, with abstracts from conference proceedings that have tags that don't match anything sensible (i.e. N2 instead of T2, JA instead of C3), mixed in with protocols from clinicaltrials.gov.
I know endnote and refman have both had filters written for them - to import these tagged ris files from those (particular) sources.
Is Zotero primarily used by 'other than' medical/biological science? Just wondering how many people out there are also wishing there was an easier way to import from Ovid. Or what other workarounds there are - if any. Because I've cost my client nearly 2 days already and still aren't really getting to what I want (i.e. a complete database of all work conducted in a narrow field).
Also, the URL bar import is relatively good (also not perfect), so for anyone who doesn't do systematic reviews that's not really a problem.
Ovid MEDLINE(R) In-Process & Other Non-Indexed Citations and Ovid MEDLINE(R) 1946 to Present
Econlit 1886 to December 2013
EBM Reviews - Cochrane Central Register of Controlled Trials December 2013
EBM Reviews - Cochrane Database of Systematic Reviews 2005 to December 2013
EBM Reviews - Database of Abstracts of Reviews of Effects 4th Quarter 2013
EBM Reviews - Health Technology Assessment 4th Quarter 2013
EBM Reviews - NHS Economic Evaluation Database 4th Quarter 2013
I should mention that my search is "yr=2000-current" - so I'm not anticipating tags from 1886! :)
I'm wondering whether to now (well, when the licenses become available again) go back and export by publication type by datasource so that there's hopefully a LITTLE bit more systematised tagging.
The URL bar translator also has significant differences in importation capability. When you bring it in from OVID, you have the fields
Type
Title
Author (also includes institution, incorrectly)
Publication
Library catalog
Date added/modified
but when you click on the article link in Ovid and get taken to Pubmed, you bring in
Type
Title
Authors (correctly)
Abstract
Publication
Date (MM-dd,yyyy)
Journal Abbr,
Language
DOI
ISSN
Short title
Library catalog
Extra
Date added/modified
Any idea why there might be such a vast difference?
Don't suppose you know of another means by which to systematically search those dbases without Ovid's involvement at all, then, do you?
I'd be far happier to rewrite my search syntax than retag 2803 outputs. :)
(this is bringing on trichotillomania; i swear! Apologies if I seem inept...I feel it!)
Okay, thanks. I'm back to the drawing board.
Thanks for all your comments, I really appreciate that my messages aren't simply falling into the ether.
(and THANK YOU for getting it to mostly work!!)
Export from Ovid as RIS document
Change the extension from .ris to .txt and open in notepad
Find and replace all “TY – ELEC” with “TY – JOUR”
Change extension back from .txt to .ris
Import into RefMan (using RIS (add periods).cap import filter)
Export as RIS
Import into Zotero
if you fail to do this, the sirnames will all have the first initials together, i.e. Smith J Et al, instead of the more appropriate Smith et al. Quelle DISASTER!