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 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.