I currently have approximately six hundred old .mxds, and all the data source links are broken due to an upgrade in the GIS computer.
In the past, all the spatial data was stored as shapefiles in nested folders ie 2009/2009-040-01/BurialSites.shp or 2005/J2005-022/J2005-022aoi.shp. The data was organized by year, and to some extent, by the associated project.
What I would like to do is import all the old data into a geodatabase and use a python script to repair all the broken data sources in an efficient manner.
The issue with the shapefiles organized in this manner is that certain projects from 2009 will reference past projects, which makes manually repairing the data sources a frustrating and time consuming process.
Ideally, I would like to do is organize the old shapefiles into a geodatabase so it is not quite so messy, and fix the map documents using this geodatabase.
The main issue I have is that there are multiple shapefiles with the same name (Export_Output.shp), and when these are brought into the geodatabase a number is attached as a suffix (Export_Output_1, Export_Output_2 etc). In many instances the data with the same name but in a different folder is completely unrelated, but in other cases it is the same feature, but with an additional field in the attribute table.
It appears as though there are three options -
1) Import the shapefiles into a geodatabase and attempt to repair the broken data links
2) Keep the shapefiles in the current folders and repair the broken data sources
3) Repair the data sources in each map document on an 'as-needed' basis
Does anyone have advice on importing shapefiles into a geodatabase and repairing the data links before I spend lots of time on it? How big of an issue is it that file names have had a number tagged on the end?
This is not a priority job, but it is something that I would like to eventually finish.