Which data does each map use?
Before moving a project, archiving a server or migrating to QGIS, you need to know what data the map documents depend on. ArcMap shows it one layer at a time; with dozens of documents that is a day of clicking. Upload the documents (or a ZIP of the folder) with "Only the data source report" and you get one list of every layer in every document.
The Excel workbook has three sheets:
- Data sources: one row per layer with the document, data frame, group, layer name and type, whether it is switched on, the source type (shapefile, file or personal geodatabase, enterprise geodatabase, raster, CAD, coverage, text file, web service and so on), the workspace, feature dataset and dataset, the full stored path, whether the path is relative or absolute, the server and database, the definition query, joins and relates, and the geometry.
- Folders to find: every distinct folder and geodatabase the documents point to, with the number of layers that use it, so you can see at once which drives and shares are involved.
- Documents: each document with its ArcGIS version, title, author, where and when it was last saved, whether it stores relative paths, and how many data frames and layers it has.
The same list comes as CSV for scripts and databases.
Broken links
A red exclamation mark in ArcMap means the path stored in the document no longer leads to the data. The report shows those paths exactly as stored, including UNC paths and drive letters. Upload the documents together with the data in a ZIP and the "Found in upload" column tells you which layers have their data and which do not; data that was exported out of an enterprise geodatabase into a shapefile of the same name is matched too.
Databases and services
For enterprise geodatabases the report gives the server, instance, database, version and user of the connection, never the password. Web services are listed with their address.
More about what this tool reads and writes: ArcMap MXD to QGIS Converter.