Moving all shapefiles (SHP) in MXD to new File Geodatabase (*. gdb) using ArcGIS Desktop?

Question

What I need to do is to move all the shapefiles in an mxd into a newly created gdb, checking prj, and update mxd reference.

I have ArcGIS 10 SP4, license ArcView.

I studied a bit of Python and get familiar with basic, then I copied some written code and pasted all together, attached is the code.

With some help from ESRI forum I ended up with the following script where I get an error in the arpy.SpatialReference line.

# Import system modules
import arcpy
from arcpy import env
import os
import traceback
# Load required toolboxes...
arcpy.AddToolbox("C:\\Program Files (x86)\\ArcGIS\\Desktop10.0\\ArcToolbox\\Toolboxes\\Data Management Tools.tbx")


# Set environment settings
env.workspace = "C:\\Users\\a391665\\Documents\\AAAAPERSONALE\\rugareto\\GIS\\test"
print("env.workspace completed successfully")

#check GDB exist
if os.path.exists("c:\\park\\test4.gdb"):
    arcpy.Delete_management("c:\\park\\test4.gdb")

# Execute CreateFileGDB
arcpy.CreateFileGDB_management("C:\\park", "test4")
print("CreateFileGDB completed successfully")

# Set local variables
outWorkspace = "c:\\park\\test4.gdb"
print("outWorkspace completed successfully")

# Iterate
def fcs_in_workspace(workspace):
    arcpy.env.workspace = workspace
    for fc in arcpy.ListFeatureClasses():
            dsc = arcpy.Describe(fc)
            if dsc.spatialReference.name == "WGS_1984_UTM_Zone_32N":               
                print os.path.join(workspace, fc, "prj: WGS_1984_UTM_Zone_32N")
                arcpy.FeatureClassToGeodatabase_conversion(fc, "c:\\park\\test4.gdb")
                print os.path.join(workspace, fc, "importaed in GDB")
            elif dsc.spatialReference.name == "Unknown":
                print os.path.join(workspace, fc, "UNKNOWN")
                #HERE I'D LIKE TO IMPORT THE SHP IN GDB ADDING "_UNKN" TO THE FEATURE NAME                
            else:
                print os.path.join(workspace, fc, "DIFFERENT PRJ!")
                # Determine the new output feature class path and name
                outfc = os.path.join(outWorkspace, fc)
                # Set output coordinate system
                print "PRJ CREATED!"
                # Create a spatial reference object using a projection file
                outCS = arcpy.SpatialReference('WGS_1984_UTM_Zone_32N')
                print "outCS CREATED!"
                arcpy.Project_management(fc, outfc, outCS)
                print "PROJECTED!"
    for ws in arcpy.ListWorkspaces():
        fcs_in_workspace(os.path.join(workspace, ws))

fcs_in_workspace("C:\\Users\\a391665\\Documents\\AAAAPERSONALE\\rugareto\\GIS\\test")

Answer 1

I re-wrote your script to add the bit where you convert your shapefiles with unknown spatial reference into feature classes in your geodatabase. Set the variable outCS to the path of the projection file you want. Try this out:

# Import system modules
import arcpy
import os
import traceback
# Load required toolboxes...
arcpy.AddToolbox(r'C:\Program Files (x86)\ArcGIS\Desktop10.0\ArcToolbox\Toolboxes\Data Management Tools.tbx')


# Set environment settings
ws = r'C:\Users\a391665\Documents\AAAAPERSONALE\rugareto\GIS\test'
arcpy.env.workspace = ws
print("env.workspace completed successfully")

#check GDB exist
gdb_dir = r'c:\park'
gdb_nam = 'test4.gdb'
gdb_full_path = os.path.join(gdb_dir,gdb_nam)
if os.path.exists(gdb_full_path):
    arcpy.Delete_management(gdb_full_path)

# Execute CreateFileGDB
arcpy.CreateFileGDB_management(gdb_dir, gdb_nam)
print("CreateFileGDB completed successfully")

# Iterate
def fcs_in_workspace(workspace,outWorkspace):
    arcpy.env.workspace = workspace
    for fc in arcpy.ListFeatureClasses():
            dsc = arcpy.Describe(fc)
            if dsc.spatialReference.name == "WGS_1984_UTM_Zone_32N":
                print '%s %s %s' % (workspace, fc, "prj: WGS_1984_UTM_Zone_32N")
                arcpy.FeatureClassToGeodatabase_conversion(fc, outWorkspace)
                print '%s %s %s' % (workspace, fc, "imported in GDB")

            elif dsc.spatialReference.name == "Unknown":
                #HERE I'D LIKE TO IMPORT THE SHP IN GDB ADDING "_UNKN" TO THE FEATURE NAME
                print os.path.join(workspace, fc, "UNKNOWN")
                fc_unkn = fc+'_unkn'
                arcpy.FeatureClassToGeodatabase_conversion(fc_unkn, outWorkspace)
                print '%s %s %s' % (workspace, fc_unkn, "imported in GDB")

            else:
                print os.path.join(workspace, fc, "DIFFERENT PRJ!")
                # Determine the new output feature class path and name
                outfc = os.path.join(outWorkspace, fc)
                # Set output coordinate system
                print "PRJ CREATED!"
                # Create a spatial reference object using a projection file
                outCS = r'C:\Program Files (x86)\ArcGIS\Desktop10.0\Coordinate Systems\Projected Coordinate Systems\UTM\WGS 1984\Northern Hemisphere\WGS_1984_UTM_Zone_32N.prj'
                arcpy.Project_management(fc, outfc, outCS)
                print "PROJECTED!"
##     for ws in arcpy.ListWorkspaces():
##         fcs_in_workspace(os.path.join(workspace, ws))

fcs_in_workspace(ws,gdb_full_path)

Answer 2

I think it may be possible to accomplish your aim of copying all shapefiles referenced as layers in an MXD into a file geodatabase in a single step using the Package Map (Data Management) tool:

Packages a map document and all referenced data sources to create a single compressed .mpk file.

The tool has I think been available since ArcGIS Desktop 10.0 and has a Convert data to file geodatabase option.

The *.mpk file will then contain a zipped up file geodatabase that can be unpacked by dragging it onto a map, or various other methods.

The tool can be used within a Python script:

arcpy.PackageMap_management(in_map, output_file, {convert_data}, {convert_arcsde_data}, {extent}, {apply_extent_to_arcsde}, {arcgisruntime}, {reference_all_data}, {version}, {additional_files}, {summary}, {tags})