Export ALL author names from a folder

pbragge

Hello, I need to do a search of publications by all authors in a set of about 40 references in a folder. Is there a way I can export JUST the author names for this small document collection?

I thought about exporting as a bibliography but I see two issues with this. First, most output styles truncate the author lis to 'et al.' after the first 3 - 5 authors; second, I literally only want the author names as I'm plugging them straight into a search by author so a bibliography will export way too much redundant data.

poettli

If folder = collection/sub-collection, then I guess it is answered here: https://forums.zotero.org/discussion/50983/list-of-authors-for-all-items-in-a-collection

tim820

Run the following code under Tools\Developer\Run JavaScript to get an alphabetical list of all authors in the current collection, along with a count of how often they appear.

var CurrentCollection = Zotero.getActiveZoteroPane().getSelectedCollection();
var sql = "SELECT TRIM(lastName || ', ' || firstName) AS author, COUNT(*) AS num FROM items JOIN itemCreators USING (itemID) JOIN creators USING (creatorID) JOIN collectionItems USING (itemID) JOIN collections USING (collectionID) WHERE collectionName=? GROUP BY author ORDER BY author ASC";
var rows = await Zotero.DB.queryAsync(sql,CurrentCollection.name);
var lines = [];
for (let row of rows) {
lines.push(row.author + '\t' + row.num);
}
return lines.join('\n');

If you don't want the count, omit "+ '\t' + row.num".

pbragge

I tried it and it seems to work but it's doing the entire folder, not the subcollection. How do I just export a subcollection without all the parent folders?

pbragge

tim820 thanks that worked a treat!