AHGW:File Import Wizard

From XMS Wiki
Jump to navigationJump to search


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.