Upgrade StorageAccess to some help documentation
Hi
I am trying to get some info on the database structure etc.
From this page: https://www.zotero.org/support/dev/client_coding/direct_sqlite_database_access
I am trying to access either system.sql or Zotero.properties but get a screen telling me to login and my normal Zotero login does not work. I am not even sure these are links to info pages.
Where can I find a description of the schema and which fields I should change to force a sync?
I have an issue where I think I need to change data directly in the database. We have about 40000 items in our group library and I can not just delete the 6000 odd damaged items and reupload because I have no idea which of the current items are in use. When we originally imported the items, there were a bunch (thousands) of abreviations that did not have a period after the abbreviation. I need to search for and fix these. Seems to me this should be fairly simple in sql. Similarly we have a lot of URLs where prior to import all the underscores were replaced with spaces. Again an easy fix in sql. I just need to have a better understanding of the system before I start to meddle with it.
Please point me in the right direction.
Thank you
I am trying to get some info on the database structure etc.
From this page: https://www.zotero.org/support/dev/client_coding/direct_sqlite_database_access
I am trying to access either system.sql or Zotero.properties but get a screen telling me to login and my normal Zotero login does not work. I am not even sure these are links to info pages.
Where can I find a description of the schema and which fields I should change to force a sync?
I have an issue where I think I need to change data directly in the database. We have about 40000 items in our group library and I can not just delete the 6000 odd damaged items and reupload because I have no idea which of the current items are in use. When we originally imported the items, there were a bunch (thousands) of abreviations that did not have a period after the abbreviation. I need to search for and fix these. Seems to me this should be fairly simple in sql. Similarly we have a lot of URLs where prior to import all the underscores were replaced with spaces. Again an easy fix in sql. I just need to have a better understanding of the system before I start to meddle with it.
Please point me in the right direction.
Thank you
The one thing that is still accurate is that directly modifying the sqlite is a terrible, terrible idea. The chances that you'll break sync (and more) are very high and at that point no one is going to be able to help you with that database and you'll be on your own with essentially all issues that are remotely database related going forward. It's unfortunate that there's currently no decent way to access the javascript API anymore (it still exists, you just can't get to it outside of a Zotero add-on), so the only API way to do this is to use the server API. Most people would use pyzotero for that, but you can also do this directly (the API documentation is up to date).
Since you asked, system.sql is here:
https://github.com/zotero/zotero/blob/master/resource/schema/system.sql
and zotero.properties is here (for US English, it exists for every locale):
https://github.com/zotero/zotero/blob/master/chrome/locale/en-US/zotero/zotero.properties
but again, you really don't want to go that route.