root/MGET/Branches/Jason/PythonPackage/dist/TracOnlineDocumentation/Documentation/ArcGISReference/File.CopyArcGISTable.html @ 376

Revision 376, 7.5 KB (checked in by jjr8, 4 years ago)

Fixed/implemented:

* #332: SIR file conversion tools should use WGS-72 datum for Lambert projections, and NSIDC's datum for polar stereographic projections
* Bugs in the previous revision related to pre-install scripts.

If this passes additional testing, it will be merged with the Trunk and released as MGET 0.7a12.
Line 
1<?xml version="1.0" encoding="utf-8"?>
2<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
3<html xmlns="http://www.w3.org/1999/xhtml"><head><link rel="stylesheet" type="text/css" href="81help.css?format=raw" /><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>Copy Files Listed in Table</title></head><body><table style="margin-top:-1em; margin-bottom:0; padding:0; margin-left:-1em"><tr><td style="background:white"><img width="875" height="70" alt="ArcToolbox banner" src="AHBanner_ArcToolbox.gif?format=raw" /></td></tr></table><h1>Copy Files Listed in Table</h1><p></p><p>Copies the files listed in a table.</p><br /><p><h2><img width="11" height="11" border="0" src="sm_arrow_down.gif?format=raw" /> Command line syntax</h2></p><div Class="expand" id="id103145">FileCopyArcGISTable_GeoEco &lt;table&gt; &lt;sourceFileField&gt; &lt;destinationFileField&gt; {where} {orderBy;orderBy...} {directions;directions...} {skipExisting} {basePath} <br /><br /><b>Parameters</b><br /><table width="100%" border="0" cellpadding="5"><tbody><tr><th width="40%"><b>Expression</b></th><th width="60%"><b>Explanation</b></th></tr><tr><td class="info">&lt;table&gt;</td><td class="info" align="left"><p>Table to query.</p></td></tr><tr><td class="info">&lt;sourceFileField&gt;</td><td class="info" align="left"><p>Field containing the paths of the files to copy.</p></td></tr><tr><td class="info">&lt;destinationFileField&gt;</td><td class="info" align="left"><p>Field containing the paths of the destination files.</p></td></tr><tr><td class="info">{where}</td><td class="info" align="left"><p>SQL WHERE clause expression that specifies the subset of rows to
4process. If this parameter is not provided, all of the rows will be
5processed. If this parameter is provided but the underlying database
6does not support WHERE clauses, an error will be raised.</p><p>The exact syntax of this expression depends on the underlying
7database. ESRI recommends you reference fields using the following
8syntax:</p><ul><li><p>If you're querying ArcInfo coverages, shapefiles, INFO tables or
9dBASE tables (.dbf files), enclose field names in double quotes in
10the SQL expression: "MY_FIELD".</p></li></ul><ul><li><p>If you're querying Microsoft Access tables or personal
11geodatabase tables, enclose field names in square brackets:
12[MY_FIELD].</p></li></ul><ul><li><p>If you're querying ArcSDE geodatabase tables, an ArcIMS feature
13class, or an ArcIMS image service sublayer, don't enclose field
14names: MY_FIELD.</p></li></ul></td></tr><tr><td class="info">{orderBy;orderBy...}</td><td class="info" align="left"><p>Fields that will be used to sort the rows (i.e., the columns
15specified in the ORDER BY clause of a SQL SELECT statement). If no
16fields are provided, the rows will be sorted in the default order
17determined by the underlying database. If this parameter is provided
18but this computer is not running ArcGIS 9.2 or later or the underlying
19database does not support ORDER BY clauses, an error will be raised.</p><p>In addition to specifying the ORDER BY fields, you must also specify
20the sort direction for each field.</p></td></tr><tr><td class="info">{directions;directions...}</td><td class="info" align="left"><p>List of strings, either 'Ascending' or 'Descending', that specify
21the sort directions for the ORDER BY fields. If this parameter is
22provided but this computer is not running ArcGIS 9.2 or later or the
23underlying database does not support ORDER BY clauses, an error will
24be raised.</p></td></tr><tr><td class="info">{skipExisting}</td><td class="info" align="left"><p>If True, copying will be skipped for destination files that already exist.</p></td></tr><tr><td class="info">{basePath}</td><td class="info" align="left"><p>Base path to prepend to relative paths.</p><p>If a base path is provided, it will be prepended to any relative paths
25that are obtained from the fields that list the inputs (and outputs,
26if this tool has outputs). If a base path is not provided, the
27workspace containing the table will be prepended instead.</p></td></tr></tbody></table></div><p><h2><img width="11" height="11" border="0" src="sm_arrow_down.gif?format=raw" /> Scripting syntax</h2></p><div Class="expand" id="TEST">FileCopyArcGISTable_GeoEco (table, sourceFileField, destinationFileField, where, orderBy, directions, skipExisting, basePath) <br /><br /><b>Parameters</b><br /><table width="100%" border="0" cellpadding="5"><tbody><tr><th width="40%"><b>Expression</b></th><th width="60%"><b>Explanation</b></th></tr><tr><td class="info">Table (Required) </td><td class="info" align="left"><p>Table to query.</p></td></tr><tr><td class="info">Source file field (Required) </td><td class="info" align="left"><p>Field containing the paths of the files to copy.</p></td></tr><tr><td class="info">Destination file field (Required) </td><td class="info" align="left"><p>Field containing the paths of the destination files.</p></td></tr><tr><td class="info">Where clause (Optional) </td><td class="info" align="left"><p>SQL WHERE clause expression that specifies the subset of rows to
28process. If this parameter is not provided, all of the rows will be
29processed. If this parameter is provided but the underlying database
30does not support WHERE clauses, an error will be raised.</p><p>The exact syntax of this expression depends on the underlying
31database. ESRI recommends you reference fields using the following
32syntax:</p><ul><li><p>If you're querying ArcInfo coverages, shapefiles, INFO tables or
33dBASE tables (.dbf files), enclose field names in double quotes in
34the SQL expression: "MY_FIELD".</p></li></ul><ul><li><p>If you're querying Microsoft Access tables or personal
35geodatabase tables, enclose field names in square brackets:
36[MY_FIELD].</p></li></ul><ul><li><p>If you're querying ArcSDE geodatabase tables, an ArcIMS feature
37class, or an ArcIMS image service sublayer, don't enclose field
38names: MY_FIELD.</p></li></ul></td></tr><tr><td class="info">Order By fields (Optional) </td><td class="info" align="left"><p>Fields that will be used to sort the rows (i.e., the columns
39specified in the ORDER BY clause of a SQL SELECT statement). If no
40fields are provided, the rows will be sorted in the default order
41determined by the underlying database. If this parameter is provided
42but this computer is not running ArcGIS 9.2 or later or the underlying
43database does not support ORDER BY clauses, an error will be raised.</p><p>In addition to specifying the ORDER BY fields, you must also specify
44the sort direction for each field.</p></td></tr><tr><td class="info">Order By directions (Optional) </td><td class="info" align="left"><p>List of strings, either 'Ascending' or 'Descending', that specify
45the sort directions for the ORDER BY fields. If this parameter is
46provided but this computer is not running ArcGIS 9.2 or later or the
47underlying database does not support ORDER BY clauses, an error will
48be raised.</p></td></tr><tr><td class="info">Skip existing outputs (Optional) </td><td class="info" align="left"><p>If True, copying will be skipped for destination files that already exist.</p></td></tr><tr><td class="info">Base path (Optional) </td><td class="info" align="left"><p>Base path to prepend to relative paths.</p><p>If a base path is provided, it will be prepended to any relative paths
49that are obtained from the fields that list the inputs (and outputs,
50if this tool has outputs). If a base path is not provided, the
51workspace containing the table will be prepended instead.</p></td></tr></tbody></table></div></body></html>
Note: See TracBrowser for help on using the browser.