Record ID
As others have pointed out before, I need a way to get an automatic and unique ID for my references to match electronic records and paper copies. I have noted that zotero creates and ID when export my library to RIS format. I am also aware of an itemID in the database. How can I display any of these IDs in my zotero window? If there is not a chance to do that, is there any easy way to display it using a sqlite gui?
There is certainly no way to view it in the UI. And even if there were, you should note that it's local to a particular Zotero install. If you ever have to resync from the server or re-import from RDF, you'd loose it. In other words, it's not really designed to be stable over time, so probably isn't great for that purpose. (And unfortunately for you there isn't anything else that is, though there continues to be discussion about adding a place for local identifiers like BibTeX keys and index numbers.)
Some things you might try:
1. Find an unused field and fill it manually ("Loc in archive", "Extra" "ISBN/ISSN"). Risky, and there might not be a good upgrade path if local ID's are introduced. Still, it may work if you want something now.
2. Make a record ID you can compute, like people do with BibTeX keys SMITH98TITLEWORD. In fact you might even make use of Zotero's inbuilt BibTeX keys for such a purpose. You can customize them to some extent by editing a variable in the BibTeX.js file in your translators directory. Someone even hacked that file so that he could use Quick Copy to copy out just the BibTeX key. (here on the forums somewhere, but it seems not to work any longer. I'll have a try at getting it to work again). That, it seems, could be handy, though it may not be completely foolproof either. And it's hackable if you know or can get to know JavaScript. You could do some fairly sophisticated key generation, which would be reasonably portable, since you could always compute it again in another setting. (Still, if Bruce D reads this, he'll rightly point out that even this is fragile, I think.).
3. Wait and participate in the discussion about these things. But I don't think the developers are close to any solution yet. One hope is to engineer something that works together with global identifiers and collection sharing, which is a hard problem.
4. Could you use the DOI? It ain't pretty, but it's universal, and will presumably have uses both in and out of Zotero. I don't know the situation intimately, but to me DOIs show no sign of going away any time soon.
You may have some in your data already. If only there were some way to semi-automatically populate the rest of your data with them. And of course, you'd have to invent something for those (older and less public) resources without a DOI. Still, it has some potential, if only for its pretty solid universality.
I had the same problem as you, eniklits. I need a local ID to match my zotero documents to local paper versions of the documents,..
My workaround now is to use "special notes" to give every zotero document a extra "field" starting with a "field label". It works only manual. An example note: [Signature] Meier:2008.
With this workaround you can define a lot of additional fields, using notes. Using the search function of zotero you easily search for the contents of such extra fields.
Not a solution but a simple workaround.
https://www.zotero.org/trac/ticket/763
This is exactly the kind of useful-for-research but not-quite-bibliographic data that the Extra field is good for.
Now, I'm not sure where this is going to end up - if, e.g. itemID might be a good way to go after all - but this is where the discussion is right now. There is general agreement to do this, but no one is sure exactly how.
As for priority - everyone tends to think that her or his concern should be a priority. In every other feature thread we have someone declaring that some particular function is a deal-breaker.
a) I think the Extra field should be sorteable in general - this has come up before in other contexts
b) specifically - in order to find out quickly what the last number you used was while you're in front of your computer and not the file cabinet.