Full List of Issuers? [solved]

Numista's current formatting for exporting one's coins and looking at the list of countries makes figuring out some way of representing all the potential issuers in an excel spreadsheet rather difficult. Has anyone figured out some way to do that? I'd like to see a full list of every possible issuer of coins in some way that would make it copiable into Excel, if that's even possible.

See this thread: https://en.numista.com/forum/topic61913.html

Quote: "Houseofham"​See this thread: https://en.numista.com/forum/topic61913.html
​

​That is sort of what I wanted, but I was also talking more about each individual German state, etc. Things like that, which the coins end up being stored as in numista. For example, I have a coin from the Bishopric of Olmutz in the Kingdom of Bohemia, and I wanted an entry for that as opposed to just the kingdom of Bohemia.

The country/issuer re-org is far from done. It looks like they've only covered A-H for German states. I'm sure there will be more added. Just give them some time. Or maybe even help?

Quote: "Houseofham"​The country/issuer re-org is far from done. It looks like they've only covered A-H for German states. I'm sure there will be more added. Just give them some time. Or maybe even help?

​Any idea of how I could help? I mean, I have no idea as far as how many states there could be or how to get a list of those or anything like that.

No worries, we're on it
This just take some time to complete everything (move coins, clear currencies, link database, etc.) along with dealing with other splits/improvements/requests but we'll get to it asap.

Contact Jarcek, he can tell you where help is needed.

If you want a list of all issuers, including sub-sections, try this command:

var z=new Array(); $('ul.liste_pays a').each(function() { var t = $(this).text(); if (t.indexOf('sub-section') === -1) { z.push(t); } }); for (i = 0; i < z.length;i++) { console.log(z[i]); }

Quote: "pejounet"​No worries, we're on it
​This just take some time to complete everything (move coins, clear currencies, link database, etc.) along with dealing with other splits/improvements/requests but we'll get to it asap.

​Sounds good! I can't wait to see the final product. If you need more manpower, I'm always available.

Quote: "Houseofham"​Contact Jarcek, he can tell you where help is needed.
​
​If you want a list of all issuers, including sub-sections, try this command:
​
​var z=new Array(); $('ul.liste_pays a').each(function() { var t = $(this).text(); if (t.indexOf('sub-section') === -1) { z.push(t); } }); for (i = 0; i < z.length;i++) { console.log(z[i]); }

​I don't know a thing about this, so forgive me. Where do you input this command?

Quote: "nthn"​

Quote: "Houseofham"​Contact Jarcek, he can tell you where help is needed.
​​
​​If you want a list of all issuers, including sub-sections, try this command:
​​
​​var z=new Array(); $('ul.liste_pays a').each(function() { var t = $(this).text(); if (t.indexOf('sub-section') === -1) { z.push(t); } }); for (i = 0; i < z.length;i++) { console.log(z[i]); }

​​I don't know a thing about this, so forgive me. Where do you input this command?

Go to ​Catalogue > Country List, open the Developer Tools (Ctrl-Shift-K in Firefox, Ctrl-Shift-I in Chrome, F12 in IE) and switch to the Console tab. At the > prompt (or >>, depending on the browser), paste that javascript code and hit Enter. It will list out all the 792 issuers as plain text. You can then copy it into Excel and sort any way you like.

Quote: "Houseofham"​​var z=new Array(); $('ul.liste_pays a').each(function() { var t = $(this).text(); if (t.indexOf('sub-section') === -1) { z.push(t); } }); for (i = 0; i < z.length;i++) { console.log(z[i]); }

​I've tried this (using Firefox) and I got a SyntaxError message: "There is a semicolon (;) missing somewhere."
So I've put an extra semicolon after your quote and then it was all right and I got a list there of all the countries/issuers. Then I right-clicked on "select all" and again right-clicked on "copy". Then you can paste it in Excel.

Quote: "Essor Prof"​

Quote: "Houseofham"​​var z=new Array(); $('ul.liste_pays a').each(function() { var t = $(this).text(); if (t.indexOf('sub-section') === -1) { z.push(t); } }); for (i = 0; i < z.length;i++) { console.log(z[i]); }
​
​

​​I've tried this (using Firefox) and I got a SyntaxError message: "There is a semicolon (;) missing somewhere."
​So I've put an extra semicolon after your quote and then it was all right and I got a list there of all the countries/issuers. Then I right-clicked on "select all" and again right-clicked on "copy". Then you can paste it in Excel.

The most likely reason is that you copy-pasted not just the command, but also the newline character after it and made the browser think you were trying to enter multiple lines/commands. Doesn't matter, a blank line with just a semicolon on it is just syntactic sugar - it doesn't do anything.