Abbreviated Journal Names

jfr

Hi,
for Mendeley I already scripted a tool that looks up the abbreviated Journal names in Pubmed - How may I accomplish this in zotero?
The database structure is a bit confusing for me. Is there someone who may help me with the WHERE and UPDATE statements? the Rest will be possible for me.

Thanks!

My Idea:
SELECT xyz : select all entries that are Journal Articles where the abbreviated journal name is not set.
foreach:
http://www.ncbi.nlm.nih.gov/nlmcatalog?term="Journal of Neural Engineering"[Title]&report=xml
Grep abbreviated journal name from XML
UPDATE xyz : fill the field "abbreviated journal name" with the abbreviated journal name that was just retrieved.
endforeach

and be happy...

P.S.: here is my midnight-script for mendeley:
http://www.vollkornpapier.de/computer-elektronik/abbreviated-journal-names-with-mendeley.html

dstillman

Don't do this in SQL. Only Zotero should write to its database.

You can do it in JavaScript using MozRepl (or your own Zotero plugin) or with the server API.

Gracile

Have a look on Frank Bennett's "Abbreviations Gadget": http://citationstylist.org/tools/