Comments

• Thank you, thank you, and thank you. Your java script worked on the first try, far superior to the pointlessly risky sqlite querying. I hope one day your script becomes the basis of adding a search and replace feature to Zotero.

  in Find and replace on multiple items Comment by abel.roasa January 8, 2012
• Okay, but that kind of leaves me with no options and a database that I cannot change because of a still mysterious reason.

  in Find and replace on multiple items Comment by abel.roasa January 8, 2012
• This time I logged out, logged back in, and went right to sqlitebrowser then ran UPDATE itemDataValues SET value = 'Foundation for Economic Education' WHERE value = 'The Foundation for Economic Education' to get all the publisher data to be uniform …

  in Find and replace on multiple items Comment by abel.roasa January 8, 2012
• Thank you, that makes perfect sense. I closed Firefox, backed up zotero.sqlite, opened zotero.sqlite in sqlitebrowser, ran the UPDATE query, saved, then ran a SELECT query to see if the UPDATE query worked and see that nothing has changed even thoug…

  in Find and replace on multiple items Comment by abel.roasa January 8, 2012
• The sqlitebrowser (open source, download at http://sourceforge.net/projects/sqlitebrowser/ or use 'sudo apt-get install -my sqlitebrowser' for Debian based systems like Ubuntu) found and replaced entries when the SQL string UPDATE itemDataValues SET…

  in Find and replace on multiple items Comment by abel.roasa January 7, 2012