{"id":40,"date":"2018-10-18T12:19:44","date_gmt":"2018-10-18T11:19:44","guid":{"rendered":"https:\/\/blogs.ncl.ac.uk\/miscellany\/?p=40"},"modified":"2018-10-18T15:47:30","modified_gmt":"2018-10-18T14:47:30","slug":"importing-references-in-xml-format-from-rehabdata-into-endnote","status":"publish","type":"post","link":"https:\/\/blogs.ncl.ac.uk\/miscellany\/2018\/10\/importing-references-in-xml-format-from-rehabdata-into-endnote\/","title":{"rendered":"Importing references in XML format from REHABDATA into EndNote"},"content":{"rendered":"

REHABDATA by NARIC<\/a> is perhaps not top of the databases you’d\u00a0consider essential\u00a0to use for a literature search for most topics, but if you are using it (or indeed any other database that only exports in XML), how can you get your results into EndNote?<\/p>\n

The following process I’ve come up with is based primarily on\u00a0this helpful\u00a0video’s\u00a0process for converting XML files into an EndNote-friendly tab-delimited format<\/a>.<\/p>\n

Save your results from REHABDATA\u00a0in XML format<\/strong>.<\/p>\n

Open the file\u00a0in Excel<\/strong>.<\/p>\n

Edit the column headings<\/strong> to exactly match the EndNote fields you want the data\u00a0to go into, and\u00a0delete all unnecessary columns<\/strong>. So, for example, I’d suggest ending up with: Author, Title, Journal, Year, Volume, Issue, Pages, Abstract, Keywords, ISSN<\/strong> for journal articles.<\/p>\n

If you’ve got book results, you’d probably want to cut and paste these out\u00a0into a new Excel sheet, change the column headings to ones relevant to\u00a0‘Book’ reference type and repeat the process with a separate file.<\/p>\n

Save<\/strong> the tidied up table as a Text (tab delimited) (*.txt) <\/strong>document.<\/p>\n

Open this in Word<\/strong>.<\/p>\n

Put the cursor at the start of the document, press return to get a blank line, and type:<\/p>\n

*Journal article<\/strong><\/p>\n

(including the asterisk at the start)<\/em><\/p>\n

Run a Find and Replace<\/strong> (Ctrl-H), for:<\/p>\n

Find: |<\/strong> (vertical line – usually shift \\ on UK keyboards)<\/em><\/p>\n

Replace with: \/\/<\/strong> (two forward-slashes)<\/em><\/p>\n

Replace all<\/strong><\/p>\n

Find: “<\/strong> (double-quote-mark symbol – usually shift 2 on UK keyboards)<\/em><\/p>\n

Replace with: (nothing! leave blank)<\/em><\/p>\n

Replace all<\/strong><\/p>\n

Save<\/strong> (as text file)<\/p>\n

In EndNote<\/strong>, go to File > Import > File<\/strong><\/p>\n

Choose the edited text file.<\/p>\n

Select Tab Delimited <\/strong>as the Import Option.<\/p>\n

Go!<\/p>\n

Success!<\/p>\n

If you get an error saying you’ve got the wrong field names, this will be because one or more of your headings you were editing in Excel are not the correct exact wording of\u00a0a corresponding field name in EndNote. Try again!<\/p>\n

You\u00a0may find some older results appear with all the journal details crammed in the title field. Unfortunately, that’s just how the data comes out of REHABDATA. Obviously you could do some cunning find\/replaces (in Excel or Word or EndNote), but that’s not really part of the import process; I’ll leave that to you to work out if you have sufficient results of that format to warrant it!<\/p>\n","protected":false},"excerpt":{"rendered":"

REHABDATA by NARIC is perhaps not top of the databases you’d\u00a0consider essential\u00a0to use for a literature search for most topics, but if you are using it (or indeed any other database that only exports in XML), how can you get your results into EndNote? The following process I’ve come up with is based primarily on\u00a0this … Continue reading “Importing references in XML format from REHABDATA into EndNote”<\/span><\/a><\/p>\n","protected":false},"author":1915,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,3],"tags":[4,21,19,20],"class_list":["post-40","post","type-post","status-publish","format-standard","hentry","category-databases-literature-searching","category-endnote","tag-endnote","tag-import","tag-rehabdata","tag-xml"],"_links":{"self":[{"href":"https:\/\/blogs.ncl.ac.uk\/miscellany\/wp-json\/wp\/v2\/posts\/40","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.ncl.ac.uk\/miscellany\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.ncl.ac.uk\/miscellany\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/miscellany\/wp-json\/wp\/v2\/users\/1915"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/miscellany\/wp-json\/wp\/v2\/comments?post=40"}],"version-history":[{"count":3,"href":"https:\/\/blogs.ncl.ac.uk\/miscellany\/wp-json\/wp\/v2\/posts\/40\/revisions"}],"predecessor-version":[{"id":43,"href":"https:\/\/blogs.ncl.ac.uk\/miscellany\/wp-json\/wp\/v2\/posts\/40\/revisions\/43"}],"wp:attachment":[{"href":"https:\/\/blogs.ncl.ac.uk\/miscellany\/wp-json\/wp\/v2\/media?parent=40"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/miscellany\/wp-json\/wp\/v2\/categories?post=40"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/miscellany\/wp-json\/wp\/v2\/tags?post=40"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}