Update Data Loading Workspace Schema

Summary

This tool creates a copy of a Data Loading Workspace and updates all mapping and domain workbooks.

Usage

  • A copy of the Data Loading Workspace folder will be created and updated. There is no need to back up the existing Data Loading Workspace, as it will be untouched.

Syntax

arcpy.NOALIAS.UpdateDataLoadingWorkspace(mapper_workbook)
NameExplanationData Type
mapper_workbook

The path to the Data Reference Workbook defining the data source, target, and mapping workbook paths.

File
Source to Target Mapping

The path to the Data Reference Workbook defining the data source, target, and mapping workbook paths.

File
UpdateDataLoadingWorkspace (stand-alone script)

The following stand-alone script demonstrates how to use the UpdateDataLoadingWorkspace tool:

# Name: UpdateDataLoadingWorkspace.py
# Description: Updates the workbooks in the Data Loading Workspace defined in DataReference.xlsx

# Import required modules
import arcpy

# Local Variables
workbook = "D:/data/DataLoadingWorkspace/DataReference.xlsx"

arcpy.dlt.UpdateDataLoadingWorkspace.py(mapper_workbook=workbook)

Environments

This tool does not use any geoprocessing environments.

Licensing information

  • Basic: Yes
  • Standard: Yes
  • Advanced: Yes
Top