Skip to content

Geodata Tools Generate Names

TomWaterat edited this page Sep 7, 2017 · 8 revisions

This tool provides a first stage in safely renaming datasets according to a set pattern. The tool generates candidate names for geodata listed in the input table, which can then be applied using the Geodata > Rename tool.

User Inputs


  • TIP: If you want to create new names yourself, then add a new field called ‘candidate_name’ to your results table, then copy the ‘item’ values into this field so you can edit them manually before feeding into the 'Geodata > Rename' tool.

Table for Geodata: This is the input table, usually the results table generated by the Geodata > Search tool, but it can be any table with a field containing the full path to the geodata you want to load into ArcMap. If the Input Table is a DBF, or a table in an ESRI File Geodatabase, then you can select a subset of rows in ArcMap and only those rows will be processed by the tool.

Field for Geodata: Select the field from the 'Table for Geodata' that contains the full path to the geodata items you want to have processed by the tool.

Replacements (Optional): Character replacements in the form of FIND,REPLACE. e.g. '001,1' will change 'file_001' to 'file_1'. Replacements are applied in order, starting from the first rule and working top-down, and are case-sensitive. You can also do multiple replacements by separating each one by a semi-colon e.g. ‘001,1;2017,17;abc,xyz’. Remember that this tool is not applying the names so if unsatisfactory names are generated just re-run with different replacements until you are happy.

Output Workspace: This is the location for the Grid Garage results table containing the list of geodata processed by the tool as well as any data outputs. If the tool encounters any errors when processing the input geodata then a second results table will be generated, with a ‘_FAIL’ suffix, listing the input geodata that failed and any ESRI error messages.

If you have set the ArcGIS ‘Workspace' parameter in the Geoprocessing > Environment Settings then this path will be used as the default. You can use this default path or click the folder button to select a new output location which can be a folder or File Geodatabase. If you specify a folder then the Results Table will be written to a comma-delimited (CSV) text file, if you specify a File Geodatabase it will be written as a Geodatabase Table.

Result Table Name: You can choose to use the default table name or specify a different name for the Grid Garage results table. The Grid Garage results table contains the list of geodata found in the workspace(s) you have selected. If the tool encounters any errors when querying any of the geodata then a second results table will be generated, with a ‘_FAIL’ suffix, listing the input geodata that failed and any ESRI error messages. If you choose a folder for the Output Workspace then the result table will be written to a comma-delimited (CSV) text file which will not allow you to select rows for processing when using the table as input for other Grid Garage Tools.

Result Table file name: The default name will always take the form of ‘GenerateNamesGeodataTool_date_time’, where ‘date’ and ‘time’ are the date and time that the tool was run.

Output Filename Affixes


Output Filename Prefix (optional): Any text you enter in this input box will be added as a prefix (at the beginning) for all output file names.

Output Filename Suffix (optional): Any text you enter in this input box will be added as a suffix (at the end) for all output file names.

Clone this wiki locally