Edits with external tool not syncing

I’ve been editing my my library with an external tool (zotero.sqlite on DBeaver 5.3.2) rather successfully for my needs (bulk update of values and tags mostly).
However the changes I make by this process are not syncing. Syncing is working fine for all changes on Zotero Desktop but the ones I made with SQL scripts on Dbeaver aren’t reflected on the web library and other synced computers.
Is this an expected behavior? Is there a workaround?
I looked this forum for a possible solution but I was unable to find anything similar. Thanks!
  • Manually editing the sqlite is strongly discouraged and failure to sync is one of the expected problems it causes, yes. You're pretty much on your own with that.

    Zotero offers a local javascript API and a server API (for which there is a complete implementation via a python library) -- that's what Zotero itself uses to modify items and it's what you should use if you want to prevent corrupting your database.
  • Ok thanks! I'll try the API...
Sign In or Register to comment.