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?
| Comment | File | Size | Author |
|---|---|---|---|
| #6 | endnote7-biblio290307.txt | 16.75 KB | Poznii |
| #2 | test_3.txt | 268.65 KB | stevepowell |
Comments
Comment #1
rjerome commentedThe 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.
Comment #2
stevepowell commentedthanks 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.
Comment #3
rjerome commentedOk, I found and fixed the problem. Look for the fix in the -dev release dated today or later.
Ron.
Comment #4
stevepowell commentedfantastic, yes it works now. thanks.
Comment #5
rjerome commentedGood stuff, fyi, it wasn't the unicode characters that were the problem but the EndNote styling changes within the abstracts.
Ron
Comment #6
Poznii commentedHi, 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!