Upgrade StorageExporting articles location in the database
Hi,
I exported my complete library to a csv file wich I imported in Excel. Works great and almost every field is exported, except the articles location in the "database."
So my library looks like:
"library name"
"collection a"
"sub collection 1"
"sub collection 2"
"collection b"
"sub collection 100"
So title, author for example are correctly exported to CSV, but I can't see the exact location within the library.....in the csv file.
Oh and exporting collections and subcollections seperately doesn't solve the problem. And answers like " you shouldn't use it this way...." don't help ;-)
Does anyone have a solution for that?
Kind regards.
I exported my complete library to a csv file wich I imported in Excel. Works great and almost every field is exported, except the articles location in the "database."
So my library looks like:
"library name"
"collection a"
"sub collection 1"
"sub collection 2"
"collection b"
"sub collection 100"
So title, author for example are correctly exported to CSV, but I can't see the exact location within the library.....in the csv file.
Oh and exporting collections and subcollections seperately doesn't solve the problem. And answers like " you shouldn't use it this way...." don't help ;-)
Does anyone have a solution for that?
Kind regards.
It should be possible to retain collection information when exporting to a csv. That should be a functionlity out of the box.
A stumbled accross the "Export list of references while keeping folder information." Kind of exact the same question......
Is there any other way to import the whole database in another program in which we can see the whole database, its content and its structure? Zotero is to limited when it comes to reporting. We can't use the potential.
Kind regards.
https://gist.github.com/KalebNyquist/2ca3ac322751578b6d791cd90b4df15b
That code could be altered to format the output in any other way you want. Or the code's existing output format could be parsed and re-listed in your preferred format with a custom Word or Excel macro.
Or as you imply, you could inspect and query a copy of Zotero's sqlite database directly with any sqlite reader (eg DB Browser).
The only thing I want is a CSV file with all the names of articles in my library (one article per line) followed by the name of the collection and subcollection per article behind the name of the article. Hope you can help. So one line with name of the article, collection name, subcollection. Nothing more nothing less.
Kind regards.