While combing through addresses on a data hygiene quest, I’ve run across a few interesting city names.... These were all records created via the Constituent Import Utility, and the city name came through the process as "Bra #..." (see screenshot). It’s happened on different records, from different imports run by different users.
When I checked back in the txt files with the data for these imports, the city names listed there are more mundane.
Any theories as to what these bras are and how they got in my database?
Thanks!
What product do you all license, out of curiosity? Based on this recommendation, I'm looking to implement this for Arsht.
DGomez
Unknown said:What product do you all license, out of curiosity?
https://www.zip-codes.com/
U.S. ZIP Code Database (5 Digit)
Thank you, Chris!
Hello folks,
This is interesting - I've never seen/noticed this table before. It doesn't show up in my System Tables (I'm a system admin) nor in the documentation.
I'm just curious to see if I can make it work for us here in Australia - does anyone have any notes/docs they'd share about this?
Martin
Hi Martin,
TR_CITYSTATE is just for the US, and isn't included in System Tables because there are too many rows in it to load efficiently. However, for other countries you can get the same functionality in the TR_PCLOOKUP table; here's the help link to that table: https://www.tessituranetwork.com/Help_System_v150/Content/System_Tables/TR_PCLOOKUP.htm
-Kevin Sheehan
Hi Kevin,
I already use TR_PCLOOKUP table but was hoping TR_CITYSTATE might offer something more.
Thanks for the info though.