{"id":3232,"date":"2020-01-22T17:23:05","date_gmt":"2020-01-22T17:23:05","guid":{"rendered":"http:\/\/support.treeplotter.com\/?post_type=ht_kb&p=3232"},"modified":"2024-11-08T20:44:16","modified_gmt":"2024-11-08T20:44:16","slug":"auto-increment","status":"publish","type":"ht_kb","link":"https:\/\/support.treeplotter.com\/knowledge-base\/auto-increment\/","title":{"rendered":"How To: Use the Auto Increment tool"},"content":{"rendered":"\n

The Auto Increment tool is available upon request for some clients including users with our BS5837 functionality. It allows you to renumber an ID field.<\/p>\n\n\n\n

Note: This tool does NOT use the Advanced Filter, so be sure to apply selection unless you want to renumber every record!<\/strong><\/em><\/p>\n\n\n\n

This tool is located under Hub -> Data Tools -> Auto Increment. <\/p>\n\n\n\n

Before starting, please use the Exporter tool to export the layer you’re about to update as a backup. It should include as a minimum the Primary ID and field to be updated for every record in TreePlotter (not just the survey you are currently looking at).<\/p>\n\n\n\n

To Update by Map:<\/h3>\n\n\n
\n
\"\"<\/figure>\n<\/div>\n\n\n
    \n
  1. Layer – select the layer containing the records that you wish to update<\/li>\n\n\n\n
  2. Field to Increment – this is the field that will be renumbered. This is usually an ID field, such as TreeID or GroupID<\/li>\n\n\n\n
  3. (Field to Compare – leave blank)<\/li>\n\n\n\n
  4. Start At – the number to start the renumbering at ie 1 <\/li>\n\n\n\n
  5. (Value to Compare – leave blank and do not tick)<\/li>\n\n\n\n
  6. No Field to Compare – tick this to increment all records<\/li>\n\n\n\n
  7. Update From Map – tick this so you can choose what to update from the map<\/li>\n\n\n\n
  8. Add – choose from polygon, point or ID but we’d recommend polygon<\/li>\n\n\n\n
  9. Click the Add button and draw a polygon around the area to select those records<\/li>\n<\/ol>\n\n\n\n
    \"\"
    NB Ensure there is a Selected box and it contains the required trees. If there are no trees shown then do not proceed as it may update more trees than you expected.<\/strong><\/figcaption><\/figure>\n\n\n\n

    8. Click the Go button to start processing and say yes to overwrite the records<\/p>\n\n\n\n

    9. Check the data looks okay, and then also check the data in a random couple of surveys. If it has gone wrong, please inform support immediately!<\/p>\n\n\n\n

    Here is a 30 second (mute) demonstration of renumbering trees. Bear in mind that that the trees are renumbered in order of their Primary ID, not their geographical order.<\/p>\n\n\n\n

    \n