Derrick Posted December 18, 2018 Report Share Posted December 18, 2018 I'd like to search places by assigned place level. I'm working to including one of the more place level mods, and to do this I'm trying to figure out how many places I've assigned to a current place level (almost 3,000 places), and which places I've assigned to which place level, so that I can see what to change. A "find-and-replace" for place level would be even more of a help. An easy way might be to click on the column header to choose to sort by that column. I manipulate all of my places off line in Reunion, whose find-and-replace works fine for the locations themselves, but this is a TNG-specific identification system. Now, I see that I can export my places table as .csv, open it in Numbers, sort it by place level. I can make changes here. If I save this as a .csv file, can I import this back into the table with all changes changed? Quote Link to comment Share on other sites More sharing options...
stores Posted December 18, 2018 Report Share Posted December 18, 2018 have you tried... Maintenance - Places - Zoom & Place Levels https://tng.lythgoes.net/wiki/index.php?title=Maintenance_-_Places_-_Zoom_%26_Place_Levels Quote Link to comment Share on other sites More sharing options...
Derrick Posted December 18, 2018 Author Report Share Posted December 18, 2018 I did, but that tells me all places with no zoom or place levels and the IDs they are attached to. I'd like to see (and maybe alter) places that have been assigned levels. I tried this one as well, but it doesn't show place levels: https://tng.lythgoes.net/wiki/index.php?title=Report:_all_occuring_places,_including_place_levels Quote Link to comment Share on other sites More sharing options...
stores Posted December 18, 2018 Report Share Posted December 18, 2018 Did you try changing the place level in the code to a 1,2,3 etc... for the other place levels? Quote Link to comment Share on other sites More sharing options...
Derrick Posted December 18, 2018 Author Report Share Posted December 18, 2018 I'm confused--those don't show place levels at all. Where can I change it to add in place level results? Quote Link to comment Share on other sites More sharing options...
stores Posted December 18, 2018 Report Share Posted December 18, 2018 Try this one... https://tng.lythgoes.net/wiki/index.php?title=Maintenance_-_Place_Level_%3D_2 change the place level to 3 or what ever place level you want? Quote Link to comment Share on other sites More sharing options...
Derrick Posted December 18, 2018 Author Report Share Posted December 18, 2018 I see: that's a start! That gives me a list of names that use a place level, and the number of times each place uses it. Thank you. That's a big help to start. I wonder about manipulating the place table. I've not played with them directly before. I think I might create a test tree and try it out on that first, unless you or anyone has any warnings first. . . . Quote Link to comment Share on other sites More sharing options...
theKiwi Posted December 18, 2018 Report Share Posted December 18, 2018 If you are wanting to split up your current place levels into even more divisions, then there is no easy way to do this except on a case by case basis. You could use this Mod https://tng.lythgoes.net/wiki/index.php?title=Google_Maps_-_Update_Place_Levels_Mod to change some of them in bulk - e.g. all current levels 6 to level 9, but it won't split a current level into more than 1 level. You can edit these directly in the tng_places table using phpMyAdmin which might save a few clicks over doing it in the TNG Admin interface, but you will have to decide about each one on a case by case basis and change them one at a time. Roger Quote Link to comment Share on other sites More sharing options...
Derrick Posted December 18, 2018 Author Report Share Posted December 18, 2018 I've tried downloading the table using PhpMyAdmin, and altering the .csv file on my dummy/test site, and it actually works quite well. You do have to replace them one at a time, but the search and replace works pretty quickly in Excel (better search than Numbers, it seems). I think I might try a combination of both. Thanks for the help you all-- Quote Link to comment Share on other sites More sharing options...
stores Posted December 19, 2018 Report Share Posted December 19, 2018 Great... You are welcome... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.