UTS Library

Keyword Search

Browse Questions

Bug-Fix: How to import Reading History (Borrowing list) to Endnote to get rid of author name in title, and melded references in many but not all of the Records

UPDATE - If this is your problem - I found my own solution which is set out in the later answers/replies Use a test library to try this  just in case.

[ORIGINAL QUESTION] I recently imported my Reading History into Endnote. For many, but not all, of the references imported, two references are combined as per the example entry below. As you can see there are two titles, two authors etc - in fact except for the author and year, it seems that there will be two entries in each field. IT also seems that the system 'chooses' the second item in the combined entry as the source of the Author field - see "Author" and then the "Title' fields for comparison, below. In fact this mismatch is what first drew my attention to the mashing-up (the issue with authors and editors also coming into the "title" field has previously been noted in another "Answers" post - it's still happening). This means a lot of careful manual  cross-checking and editing has to be done, and if users are not aware of the issue - some very bad citation errors will result.

Cohen, 2008 #1809

 

Reference Type

Book

Record Number

1809

Author

Cohen, Louis, -

Year

2008

Title

The Sage handbook of internet and online research methods / [edited by] Nigel Fielding, Raymond M. Lee, Grant

Blank

Research methods in education / Louis Cohen, Lawrence Manion and Keith Morrison

Series Editor

Series Title

City

Thousand Oaks, CA :

Abingdon, Oxon ; New York :

Publisher

Sage

Routledge

Volume

Number of Volumes

Series Volume

Number of Pages

Pages

Edition

7th ed.

Date

Type of Work

Translator

Short Title

Abbreviation

Includes bibliographical references and indexes.

Includes bibliographical references and index.

ISBN

1412922933

9781412922937 (hbk)

9780415583350 (hard cover)

0415583357 (hard cover)

9780415583367 (soft cover)

0415583365 (soft cover)

DOI

Original Title

Original Year of Publication

Access Date

 

5 answers
1566 views

Answers

Hi There,

D Litting's picture
D Litting, 1 year ago

Hi There,

This is an interesting and arcane question. I believe what you are doing is exporting from the MyLibrary service to EndNote - something I've never done before (even Patrick hasn't done it before). What seems to be happening is that the filter that translates the text file our website creates into something endnote can read isn't working properly. However, because the translation seems to work most of the time I tend to think that it could be because the cataloguing/back end data of some references just isn't keyed in correctly, which is sending the information to the wrong box, or indeed not separating two different references so that endnote thinks they are part of the one reference. 

Solutions to this problem are probably more time - costly than workarounds (though I can get SI to look at the cataloguing of these two books if you like). You could try looking them up on Google Scholar and importing them that way, or using the UTS Library search option for use within in EndNote if you haven't already. However if you are getting a lot of hassles with this let me know and I'll talk to IT about it... 

Sorry I don't have a great fix for this one,

David

 

 

 

 

Thanks, I have worked out

Student's picture
Student, 1 year ago

Thanks, I have worked out what causes the problem and I have a DIY fix that is fairly quick to do (There are several hundred books on my list).

The problem

Entries without an Author field (ie there is no %A in the txt file for an entry, 'look' for the next 'A%' and drag in the additional fields below that as well).

EG - as used in my original question:
%D 2008.
%T The Sage handbook of internet and online research methods / [edited by] Nigel Fielding, Raymond M. Lee, Grant Blank.
%C Thousand Oaks, CA :
%I Sage,
%@ 1412922933
%@ 9781412922937 (hbk)
%F
%O Includes bibliographical references and indexes.

%A Cohen, Louis, 1928-
%D c2011.
%T Research methods in education / Louis Cohen, Lawrence Manion and Keith Morrison.
%C Abingdon, Oxon ; New York :
%I Routledge,
%7 7th ed.
%@ 9780415583350 (hard cover)
%@ 0415583357 (hard cover)
%@ 9780415583367 (soft cover)
%@ 0415583365 (soft cover)
%F
%O Includes bibliographical references and index.

The fix

SO instead of opening the exported txt file right away, I copied and pasted the contents into word, then used 'FIND ^p^p%D AND REPLACE with ^p^p%A^p%D to create a blank A% line.

Then I copied it back into Notepad (to strip out formatting). AS the original export had automatically saved itself in UTF-8, I checked this as a save option. (I have no idea if other options such as ANSI etc would work or not, or even if the wrong automatic default was used in the filter export, but this may be relevant, when /if you refer this to IT).

I then opened it using Endnote. Not only was everything de-doubled but it also meant that 30 or so 'missing' entries were restored as well. It is possible that the A% field is not the only one that causes this problem - but it looks ok so far. Of course there is still the issue with '/authors' in the title.

Possibly some of these issues might be easily resolved by a few tweaks in the export algorithm, or somewhere else in the database fields. And possibly not. Anyway, it seems satisfactory enough. I would also recommend that, if people have more than a couple of items on their list, that they create a new "test"endnote library for these manipulations, and if they are satisfied with what comes out then copy or cut and paste from that into their 'real' library.

Also, you can correct the

Student's picture
Student, 1 year ago

Also, you can correct the problem of the exported Title having an unwanted forward slash followed by the author(s) name(s) using word. If anyone wants to test this on their export,  this summarises how I fixed my reading history export to get a relatively clean import. It only takes a minute or two to do:

Steps

  1. Create yourself a “testing” endnote library to save yourself woe if it doesn’t work
  2. Export your Reading history from the UTS library – it is a TXT file
  3. Open the exported file, Copy all and paste into a Word document

To deal with the duplication problem as previously described above

In FIND enter

^p^p%D

In REPLACE enter

^p^p%A^p%D

Then find and replace all

To remove Author Names from the Title Field use Find and Replace as follows. You need to check the “Use wildcards” box (click on the “More” button if you can’t see this).

In FIND enter

/*^13

In REPLACE enter

^p

This removes the slash and string of whatever follows (however long) and replaces the removed paragraph mark (represented by ^13)

(you may wish to do this item by item if you are concerned about slashes that are actually part of a title, I just did it globally – and as forward slashes are relatively uncommon in titles, it is not likely to take very much time to manually re-enter the missing parts of those titles)

To import into Test endnote library

  1. Copy all and paste into Notepad and save as UTF-8 option (I do not know if other options work)
  2. Use the Import file option (from  the endnote library File menu) and select"Endnote Import" as the import option in the dialog box from the dropdown menu.
  3. Check for any issues then copy and paste or import into your “real” library

UPDATE 23/4/2018 - As noted below - the standard export (BEFORE you find and replace anything) looks like it might only take the name of the first author, not multiple authors of an item into the Author field. In which case, you may prefer to manually cut the authors from after the title and repaste it into the "Author" field.

Wow, what a lot of great work

D Litting's picture
D Litting, 1 year ago

Wow, what a lot of great work you've put in here. Thanks very much for going the extra mile on this. I'll definitely aim to play around with your workaround and see if I can replicate the results here at some point. In terms of changing the way the expert algorithm works I can't guarantee anything because you're the only person I know who has been using this method of harvesting references from the catalogue, but we'll see..

Have a great weekend.

David

I think the main issue with

Student's picture
Student, 1 year ago

I think the main issue with database reports is usually whether or not the correct data is in the correct fields in the first place, because one can't extract what isn't there, but there is usually a lot that can be done with the processing of what comes out in the report.

And I also just noticed that currently,  in the entries where the Author field is already populated, it looks like the system is only dragging in the first author. So if people do strip out the  authors' names from the title field they may still need to re -enter some additional names in the author field at some point. This problem with missing multiple authors can be seen in my original question example. So at present, you would have to choose whether or not it would be more convenient to take out the authors from the Title field using find and replace, or just do it on an entry by entry basis.

And, not that I am going to do this myself, but I believe it would also be possible to automate a script (and/or think of a way  to use Word's inbuilt features) that looks for what comes after the forward slash, cuts it out and pastes it into the Author field.

Answer question