ArcToolbox banner

Copy Directories Listed in Table

Copies the directories listed in a table.


Command line syntax

DirectoryCopyArcGISTable_GeoEco <table> <sourceDirectoryField> <destinationDirectoryField> {where} {orderBy;orderBy...} {directions;directions...} {skipExisting} {basePath}

Parameters
ExpressionExplanation
<table>

Table to query.

<sourceDirectoryField>

Field containing the paths of the directories to copy.

The directories may contain subdirectories and files. Other types of file system objects, such as symbolic links, are not allowed.

<destinationDirectoryField>

Field containing the paths of the destination directories.

{where}

SQL WHERE clause expression that specifies the subset of rows to process. If this parameter is not provided, all of the rows will be processed. If this parameter is provided but the underlying database does not support WHERE clauses, an error will be raised.

The exact syntax of this expression depends on the underlying database. ESRI recommends you reference fields using the following syntax:

  • If you're querying ArcInfo coverages, shapefiles, INFO tables or dBASE tables (.dbf files), enclose field names in double quotes in the SQL expression: "MY_FIELD".

  • If you're querying Microsoft Access tables or personal geodatabase tables, enclose field names in square brackets: [MY_FIELD].

  • If you're querying ArcSDE geodatabase tables, an ArcIMS feature class, or an ArcIMS image service sublayer, don't enclose field names: MY_FIELD.

{orderBy;orderBy...}

Fields that will be used to sort the rows (i.e., the columns specified in the ORDER BY clause of a SQL SELECT statement). If no fields are provided, the rows will be sorted in the default order determined by the underlying database. If this parameter is provided but this computer is not running ArcGIS 9.2 or later or the underlying database does not support ORDER BY clauses, an error will be raised.

In addition to specifying the ORDER BY fields, you must also specify the sort direction for each field.

{directions;directions...}

List of strings, either 'Ascending' or 'Descending', that specify the sort directions for the ORDER BY fields. If this parameter is provided but this computer is not running ArcGIS 9.2 or later or the underlying database does not support ORDER BY clauses, an error will be raised.

{skipExisting}

If True, copying will be skipped for destination directories that already exist.

{basePath}

Base path to prepend to relative paths.

If a base path is provided, it will be prepended to any relative paths that are obtained from the fields that list the inputs (and outputs, if this tool has outputs). If a base path is not provided, the workspace containing the table will be prepended instead.

Scripting syntax

DirectoryCopyArcGISTable_GeoEco (table, sourceDirectoryField, destinationDirectoryField, where, orderBy, directions, skipExisting, basePath)

Parameters
ExpressionExplanation
Table (Required)

Table to query.

Source directory field (Required)

Field containing the paths of the directories to copy.

The directories may contain subdirectories and files. Other types of file system objects, such as symbolic links, are not allowed.

Destination directory field (Required)

Field containing the paths of the destination directories.

Where clause (Optional)

SQL WHERE clause expression that specifies the subset of rows to process. If this parameter is not provided, all of the rows will be processed. If this parameter is provided but the underlying database does not support WHERE clauses, an error will be raised.

The exact syntax of this expression depends on the underlying database. ESRI recommends you reference fields using the following syntax:

  • If you're querying ArcInfo coverages, shapefiles, INFO tables or dBASE tables (.dbf files), enclose field names in double quotes in the SQL expression: "MY_FIELD".

  • If you're querying Microsoft Access tables or personal geodatabase tables, enclose field names in square brackets: [MY_FIELD].

  • If you're querying ArcSDE geodatabase tables, an ArcIMS feature class, or an ArcIMS image service sublayer, don't enclose field names: MY_FIELD.

Order By fields (Optional)

Fields that will be used to sort the rows (i.e., the columns specified in the ORDER BY clause of a SQL SELECT statement). If no fields are provided, the rows will be sorted in the default order determined by the underlying database. If this parameter is provided but this computer is not running ArcGIS 9.2 or later or the underlying database does not support ORDER BY clauses, an error will be raised.

In addition to specifying the ORDER BY fields, you must also specify the sort direction for each field.

Order By directions (Optional)

List of strings, either 'Ascending' or 'Descending', that specify the sort directions for the ORDER BY fields. If this parameter is provided but this computer is not running ArcGIS 9.2 or later or the underlying database does not support ORDER BY clauses, an error will be raised.

Skip existing outputs (Optional)

If True, copying will be skipped for destination directories that already exist.

Base path (Optional)

Base path to prepend to relative paths.

If a base path is provided, it will be prepended to any relative paths that are obtained from the fields that list the inputs (and outputs, if this tool has outputs). If a base path is not provided, the workspace containing the table will be prepended instead.