topic Get mapx Data Source Properties In Python in ArcGIS Enterprise Questions

Get mapx Data Source Properties In Python

StevenCross — Tue, 11 May 2021 21:19:24 GMT

I am trying to write a python script that will crawl through the arcgisinput folder/subfolders for all the MXD, and .mapx documents that have been published to ArcGIS Enterprise. I would like to get all the Data Source properties (MapDocument Name, Feature Class, Database, Owner etc). I have a working script for MXD's but cannot incorporate the .mapx file.

Any help with this would be greatly appreciated.

Re: Get mapx Data Source Properties In Python

Brian_Wilson — Tue, 11 May 2021 23:26:19 GMT

I've not used mapx files yet. I just created one and looked at it.

A mapx file is just a text file containing JSON data and they are not even minified so you can just list them out. Looks like all the information you want is in the section "layerDefinitions".

Generally I load JSON files into Python objects and then examine them in the Visual Studio Code debugger and pull them apart with Python until I find the bits that I need.

Does that make sense to you or do you want a snippet of Python?

Maybe there is some cool Python API thing, I'm going to look because I want the rich Esri learning experience but generally I'd just hack the JSON personally.

Re: Get mapx Data Source Properties In Python

Brian_Wilson — Wed, 12 May 2021 15:54:33 GMT

I did a brief search of arcgis py but did not see anything helpful, so I wrote a few lines of plain old Python (no Esri modules). Here is the code,

""" Open a mapx file and find the Data Source properties """ import json file = "k:/e911/e911 map.mapx" with open(file, 'r') as fp: mapx = json.load(fp) map_name = mapx['mapDefinition']['name'] layers = mapx['layerDefinitions'] for layer in layers: print("-"*72) print("type: %s name: \"%s\"" % (layer['type'], layer['name'])) try: data = layer['featureTable']['dataConnection'] print("dataset: %s" % data['dataset']) print("%s\t%s" % (data['workspaceFactory'], data['workspaceConnectionString'])) except: # Uncomment this line for debugging, so you can see what did not # look like a data source. For example, group layers show up here. print(json.dumps(layer, indent=2)) pass print()