Quick Column Scripting


Occasionally, I get requests for new features that are very simple, and might take longer to deploy in the code base than it would take to make them available through AppleScript. In many of these cases, over the years, I've gone ahead and written and distributed AppleScript to meet these needs.

A couple of days ago, a user reached out needing st set a specific column in new rows to a particular value. The general case of this requires providing a way to choose the column to be set, the value to be set, and which rows to set it in.

However, if you know the value and column names will remain constant, the only information you need is a list of rows, and that's simple to provide by selecting them.

Here's the final script

-- This script sets the SURVEYOR column to the name specified in columnValue

tell application "Cartographica"
	-- set my variables here
	set targetColumnName to "SURVEYOR"
	set columnValue to "Somebody"
	
	-- Get Map information
	set mapWindow to the first map window
	set thedoc to the document of mapWindow
	set theViewer to the map viewer of mapWindow
	
	-- Get selected layer
	set selectedLayers to the selected layers of theViewer
	set originalLayer to the first item in selectedLayers
	
	-- get selected features
	set selectedFeatures to selected features of theViewer
	
	-- set the value of specific coluumn in data
	repeat with aFeature in selectedFeatures
		set theFieldData to aFeature's field data targetColumnName
		set value of theFieldData to columnValue
	end repeat
	
end tell

Walking though this, the code is pretty straightforward:

  • specify column and value
  • connect to Cartographica and get the selected layer and features
  • loop over the features, setting the column value to the prescribed value

This looks a little animated when it runs because each set triggers an update to the map and data grid. For very large selections, it can be better to uncheck the layer's visibility box before running the script, since that will only update the data view.

Also note that you need to use the name of the column, not the title. These are frequently the same, but if you're uncertain, show the Layer Info Window and check the Show Field Names box and use the value in the Field Name column as opposed to the Display Name column if they differ.


Cartographica 1.5.3 available →
More in Automation
Saving Time by Using AppleScript →