text/microsoft-resx 2.0 System.Resources.ResXResourceReader, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Resources.ResXResourceWriter, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 This program creates a text file called SQLfile with SQL commands to update the TNG Places Table with Latitude, Longitude and Place and Zoom levels. It will not update if longitude has a value. Place and zoom levels are determined by the number of commas before the place name: 0 commas=City; 1=County; 2=State/Province; 3=Country. If you do not follow this convention then it is still possible to export latitude and longitude but you may wish to edit SQLfile with Search and Replace to modify it to your needs. 1. Backup TNG Tables from TNG Admin! 2. Copy this program to your working directory 3. In Legacy, Customize>Data Format>Location Format: Check "Assure a space after each comma" 4. In Legacy, export a gedcom file in Legacy format (to include latitude and longitude) to your working directory 5. Run this program to create the text file(s) "SQLfile" in your working directory 6. Review the file "SQLfile" with a text editor 7. In phpMyAdmin -select TNG database -choose "Import" -set character set to "Latin 1" (seems to handle accents) -browse to SQLfile created in 5. -select "GO"