Abbreviated Journal Names

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
Sign In or Register to comment.