After importing endnote 9.0 xml file, most text fields come out OK but unicode characters (specifically č ć š đ) which display OK in endnote just break the abstract, i.e. the abstract just stops at the character before the special char.
Errors: I am getting errors for http://www.promente.org/en/biblio/rss.xml like these in the drupal logs:
Invalid argument supplied for foreach() in /home/.../modules/taxonomy/taxonomy.module on line 1428.

and

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM drupalnode n INNER JOIN drupalusers u ON u.uid = n.uid INNER JOIN drupalnode_revisions r ON r.vid = n.vid WHERE in /home/....//promente.net/includes/database.mysql.inc on line 172.

and

implode() [function.implode]: Bad arguments. in /home/.../promente.net/modules/node/node.module on line 508.

Any ideas?

CommentFileSizeAuthor
#6 endnote7-biblio290307.txt16.75 KBPoznii
#2 test_3.txt268.65 KBstevepowell

Comments

rjerome’s picture

The special characters issue doesn't entirely surprise me, if you could post an xml file with such an entry in it, I will see what I can do about it.

With regard to the errors related to taxonomy, did you have keyword->taxonomy integration turned on? Did you select a specific taxonomy vocabulary to import the entires into?

I have a feeling all the other error may be related to i18n, see my previous comments on this http://drupal.org/node/129107

Ron.

stevepowell’s picture

StatusFileSize
new268.65 KB

thanks for quick response! Here is the xml, renamed as a .txt file. Yes, I selected just one tag from an existing vocabulary to be assigned to all the new entries.

rjerome’s picture

Status: Active » Fixed

Ok, I found and fixed the problem. Look for the fix in the -dev release dated today or later.

Ron.

stevepowell’s picture

fantastic, yes it works now. thanks.

rjerome’s picture

Good stuff, fyi, it wasn't the unicode characters that were the problem but the EndNote styling changes within the abstracts.

Ron

Poznii’s picture

Version: 5.x-1.x-dev » 4.7.x-2.x-dev
Status: Fixed » Closed (won't fix)
StatusFileSize
new16.75 KB

Hi, Ron!

(4.7:) The problem with xml-export/import (utf8 encoding of the Abstract-field) go on for me. Look please attach (there a xml renamed to txt).

Many Thanks for your work, Ron!