When importing from a Reference Manager file in RIS format, it appears that the Journal Abbreviation (JA) field is being omitted. From what I can tell, a typical journal article record in Reference Manager (version 9 & 11, and possibly others) contains a field to store the journal title (JF) (from: Journal - Full format) as well as a field to store the journal title abbreviation (JA).

It looks like this JA field should be inserted into the biblio_alternate_title field in biblio.

To fix this, I've added a single line to the ris_parser.inc:

            case 'JA' :
              $node['biblio_alternate_title'] = $value;
              break;

I inserted it at line 173, just after SP and EP, since that is where this field appears in a typical record in my exported RIS file. But maybe it makes better sense to insert it up where the JF field appears.

When I run the import using RC2 under Drupal 6.6, I receive a long series of errors (one error for each record) like this one:
user warning: Duplicate entry '777' for key 1 query: comment_nodeapi /* pkiff : comment_nodeapi */ INSERT INTO node_comment_statistics (nid, last_comment_timestamp, last_comment_name, last_comment_uid, comment_count) VALUES (777, 1232643649, NULL, 0, 0) in /Applications/MAMP/htdocs/drupaltestbed/modules/comment/comment.module on line 607.

However, from what I can tell, these errors had no effect on the integrity of the data and the import process was actually successful.

Could this additional field import perhaps be added to the RIS import parser?

Phil.

CommentFileSizeAuthor
#4 biblio_ris_import.patch2.48 KBtrigun
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

pkiff’s picture

Link to relevant RIS field descriptions:
http://www.risinc.com/support/risformat_tags_05.asp

rjerome’s picture

Yep, I'll include those changes.

Ron.

pkiff’s picture

Great, thanks Ron.

Excellent module, by the way. Much appreciated.

Phil.

trigun’s picture

FileSize
2.48 KB

Hi,

in case both JO and JA are filled, the patch enclosed agains "6.x-2.x-dev" solves this problem by assigning ONLY the first filled value. Problem is that n RIS-fields map to only one available node-field, i.e. JO & JF > biblio_secondary_title, JA & J1 & J2 > biblio_short_title

As concatenating makes not much sense in case both fields are filled correctly, only the first value is taken, as already said. Note that this solution is not perfect.

pkiff’s picture

Hi trigun, thanks for the suggested patch...Did you see this other thread with additional possible edits to ris_parser? This addresses the same issue (among others) I think, but for 6.x-1.14 instead of the the 1.0 RC version that the current thread was based on:
RIS Import - Possible Customizations - Clean up gremlins, convert PM to PubMed URL, insert JA (abbreviated Journal title):
http://drupal.org/node/859582

Taking a quick look at your code, I'm not quite sure if these actually address the same issue or not. I'm not familiar enough with the 2.x-dev version of biblio to know if this issue arises in the same way there as it does in the current 6.x-1.15 stable version. And I am unclear in what cases it might arise that an RIS database has entries for both JF and JO (are those abbreviations just from different versions of RIS? Or are they both simultaneously present in the same RIS version? Our exports only ever contain one of those.

Note that in my edits, I use the biblio_alternate_title field for the Journal abbreviation.

Phil.

Liam Morland’s picture

Status: Active » Closed (outdated)

This version is no longer maintained. If this issue is still relevant to the Drupal 7 version, please re-open and provide details.