AHGW:File Import Wizard: Difference between revisions

From XMS Wiki
Jump to navigationJump to search
(Created page with "This tool helps users to import data from their existing text files into a geodatabase using Arc Hydro Groundwater in ArcGIS. The tool works similarly to the...")
 
Tag: Removed redirect
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
This tool helps users to import data from their existing text files into a geodatabase using [[AHGW:AHGW|Arc Hydro Groundwater]] in [[ArcGIS]]. The tool works similarly to the Text Import Wizard in Microsoft Excel.  
{{TOC right}}
The ''File Import Wizard'' dialog'' helps users to import data from their existing text files into a geodatabase. The tool works similarly to the Text Import Wizard in Microsoft Excel. There are two pages (or "steps") in this dialog:


Using the ''File Import Wizard'' to import this data produces a dialog like this:
===Step 1 of 2===
[[File:AHGW File Import Wizard dialog - step 1.png|thumb|500px|right|''File Import Wizard'' dialog, step 1]]
This page has the following sections and options:
*''File import options'' section
**''Delimited'' – Select if the text is delimited with something other than fixed widths or spacing.
**''Fixed Width'' – Select if the text uses fixed widths to delimit the contents.
**''Set the column delimiters'' – Select one or more options for how the text is delimited:
***''Space''
***''Comma''
***''Tab''
***''Semicolon''
***''Other'' – If using a different delimiter character (such as a | (pipe)), turn on this option and enter a single instance of the character in the provided text field.
***''Text qualifier''' – Select from the drop-down the qualifier used to denote text (such as labels). The options are a single quote, a double quote, or "none". The selected qualifier must appear at the beginning and ending of any such text.
***''Treat consecutive delimiters as one'' – Turn on to treat two delimiters in a row as a single delimiter. Turn off to treat them as separate delimiters.
***''Skip leading delimiters'' – Turn on to ignore any delimiters appearing at the beginning of a line.
*''Start import at row'' – Enter the desired start row.
*''Heading row'' – Turn on if there is a heading row (a row indicating the contents of each column).
*''File preview'' section – This section previews how the data will be handled. When changing the above options, this section displays a preview of how the data will be interpreted on import.
*'''Next''' – Switch to the [[#Step 2 of 2|Step 2 of 2]] page of the ''File Import Wizard'' dialog.
*'''Cancel''' – Discard any changes and close the ''File Import Wizard'' dialog.


[[File:AHGW File Import Wizard dialog - step 1.png|thumb|500px|none|''File Import Wizard'' dialog, step 1.]]
===Step 2 of 2===
 
[[File:AHGW File Import Wizard dialog - step 2.png|thumb|500px|right|''File Import Wizard'' dialog, step 2]]
After selecting the delimiting options and clicking '''Next''', step 2 of the dialog appears. The drop-down box at the top allows selecting the desired table or point layer into which to import the data.
This page has the following sections and options:
 
*''Create Features/Rows in'' – Select the desired feature class from the drop-down.
[[File:AHGW File Import Wizard dialog - step 2.png|thumb|500px|none|''File Import Wizard'' dialog, step 2.]]
*''No data flag'' – Turn on to enable the no data flag to be set. Enter the flag in the provided text field. The default no data flag is "-999.0".
*''Automatically assign HydroID'' – Turn on to automatically assign a HydroID to the table or features after the text file is imported. Requires the Arc Hydro (surface water) toolbox to be loaded.
*''File preview'' section &ndash; Displays the data that will be imported. On the ''Type'' row, double-click on the "<Not Mapped>" field for the desired column to activate a drop-down of possible fields to which to map the data in the column.
*'''Back''' &ndash; Switch to the [[#Step 1 of 2|Step 1 of 2]] page of the ''File Import Wizard'' dialog.
*'''Finish''' &ndash; Save any changes and close the ''File Import Wizard'' dialog.
*'''Cancel''' &ndash; Discard any changes and close the ''File Import Wizard'' dialog.




{{Navbox AHGW}}
{{Navbox AHGW}}
[[Category:AHGW Groundwater Analyst]]
[[Category:AHGW General Information|Toolbars]]

Latest revision as of 23:39, 12 November 2019


The File Import Wizard dialog helps users to import data from their existing text files into a geodatabase. The tool works similarly to the Text Import Wizard in Microsoft Excel. There are two pages (or "steps") in this dialog:

Step 1 of 2

File Import Wizard dialog, step 1

This page has the following sections and options:

  • File import options section
    • Delimited – Select if the text is delimited with something other than fixed widths or spacing.
    • Fixed Width – Select if the text uses fixed widths to delimit the contents.
    • Set the column delimiters – Select one or more options for how the text is delimited:
      • Space
      • Comma
      • Tab
      • Semicolon
      • Other – If using a different delimiter character (such as a | (pipe)), turn on this option and enter a single instance of the character in the provided text field.
      • Text qualifier' – Select from the drop-down the qualifier used to denote text (such as labels). The options are a single quote, a double quote, or "none". The selected qualifier must appear at the beginning and ending of any such text.
      • Treat consecutive delimiters as one – Turn on to treat two delimiters in a row as a single delimiter. Turn off to treat them as separate delimiters.
      • Skip leading delimiters – Turn on to ignore any delimiters appearing at the beginning of a line.
  • Start import at row – Enter the desired start row.
  • Heading row – Turn on if there is a heading row (a row indicating the contents of each column).
  • File preview section – This section previews how the data will be handled. When changing the above options, this section displays a preview of how the data will be interpreted on import.
  • Next – Switch to the Step 2 of 2 page of the File Import Wizard dialog.
  • Cancel – Discard any changes and close the File Import Wizard dialog.

Step 2 of 2

File Import Wizard dialog, step 2

This page has the following sections and options:

  • Create Features/Rows in – Select the desired feature class from the drop-down.
  • No data flag – Turn on to enable the no data flag to be set. Enter the flag in the provided text field. The default no data flag is "-999.0".
  • Automatically assign HydroID – Turn on to automatically assign a HydroID to the table or features after the text file is imported. Requires the Arc Hydro (surface water) toolbox to be loaded.
  • File preview section – Displays the data that will be imported. On the Type row, double-click on the "<Not Mapped>" field for the desired column to activate a drop-down of possible fields to which to map the data in the column.
  • Back – Switch to the Step 1 of 2 page of the File Import Wizard dialog.
  • Finish – Save any changes and close the File Import Wizard dialog.
  • Cancel – Discard any changes and close the File Import Wizard dialog.