Hello!
Has someone already taken the time to clean up the incredibly out-dated countries in TR_COUNTRY that would be willing to run this query for me so I can avoid googling all the countries I'm unsure about...?
SELECT * FROM TR_COUNTRY WHERE inactive = 'Y'
Best,
Amanda
This is a long-running conversation.
Here is an example of a thread.
https://community.tessituranetwork.com/tessitura_software_forums/f/tessitura_technical-9/7061/tr_country/32348
Please consider putting in an enhancement request through the Support ticket.
Thanks, Tom. Not too worried about the formatting on each one, just looking for a quick list of former countries I can definitely inactivate for a little light housekeeping. Some are easy to spot, like USSR, but I'm sure there are many more if I google each one.
You may find this list to be of help.
https://en.wikipedia.org/wiki/List_of_ISO_3166_country_codes
You can buy the standard data from the ISO. Looks like 300 EURO.
There are Python Libraries pip install pycountry
This has been the first year where we had any addresses outside of the US, Canada, Mexico and the UK, and where we were interested in our foreign sales. I'm pretty sure we didn't actually get an order from Upper Volta, however. And I know two things: 1) my high school was assigned Burkina Faso for Model UN and 2) Tessitura didn't exist when I was in high school, so an update to TR_COUNTRY is at least 30 years overdue.
I found a CSV at: https://gist.github.com/radcliff/f09c0f88344a7fcef373. Doesn't have most of the TR_COUNTRY details (phone masks, etc.) but interestingly, TR_COUNTRY is missing more than it has superfluous: 30 countries not found in the ISO list, while the ISO list has an additional 54 countries (really obscure places like...Ukraine? Cambodia?). I do think an updated Country list needs to be a Tessitura feature.