1. Using the Data Source Type drop-down, select the type of database connection to be used for this import.
   • Choose either Access, ODBC, OLE, Oracle, or SQL Server.
2. Click the ... button next to the Data Source field. The following pop-up appears:

   

3. Complete all available fields; or, if a field you need isn't editable, change the DBMS Type.
4. Click Test to check if the program can connect to the database.
5. Click Ok to accept the settings and close the pop-up.
6. In the Data Select Sql field, enter a SQL statement to select a set of records. Only the records that are part of the SELECT statement will be considered for import.

   Example: SELECT * FROM dbo.Hydrants WHERE Imported = 0

1. In the Data Source Type drop-down menu, select Text.
2. Click the ... button next to the Data Source field. Browse to the location of the source file and select it.
3. In the Data Delimiter field, enter the type of character used to break up the data.
   • If the data is SPACE- or TAB-delimited, use the drown-down to select that option.
4. Mark the First Row Contains Header Information check box if necessary.

1. In the Data Source Type drop-down menu, select XML.
2. Click the ... button next to the Data Source field. Browse to the location of the .xml file and select it.

   Note: When configuring this it is suggested that you select an .xml file that contains all of the types of data that you will ever need to import using this template. Doing so ensures that the schema takes into account all the possible fields you will need to import even if any given xml file might not include all of those fields.

3. Click the Retrieve Schema button. This loads and locks the schema that the import will used.
4. The Fixed Width Schema grid will be filled out with all the fields found within the selected .xml file.

   Note: If the XML file is complicated you may see Root items duplicated to display child collections. If this is the case it is suggested to not use the Check For Duplicates function on the General Tab.

1. In the Data Source Type drop-down menu, select Web Service.
2. Paste a web request into the Raw Web Request field

   OR

3. Click the Build button to the right of the Raw Web Request field. The following pop-up will appear:

   

   1. Select the Method your request will use.
   2. Enter the URI to connect to.
   3. Select the Protocol to use.
   4. Enter the Header and Body to your request.

      Note: The values in these fields will vary depending on the web service you are accessing.

   5. Click Ok.

      Note: When configuring this it is suggested that you select a web service that contains all of the types of data that you will ever need to import using this template. Doing so ensures that the schema takes into account all the possible fields you will need to import even if any given service call might not return all of those fields.

4. Click the Retrieve Schema button. This loads and locks the schema that the import will used.
5. The Web Service Schema grid will be filled out with all the fields found within the selected .xml file.

   Note: If the web service supports it request the data in XML format. This is done by including something like Accept: application/xml in the Header.

   Note: JSON is supported If the web service does not support XML format. However if the returned object does not indicate it is JSON the Import and Update will assume it is XML. In this case include something like Accept: application/json in the Header. ESRI services are an example of this.

Note: The specific syntax used here only works for Excel 2003 or earlier.

Note: For simplicity it is suggested that you save your excel document as a .CSV file and import that file.

1. In the Data Source Type drop-down menu, select OLE.
2. Click the ... button next to the Data Source field.
3. Click the ... button next to the OLE field.
4. On the Provider tab select Microsoft Jet 4.0 OLE DB Provider from the list.
5. On the Connection tab use the first box to enter or browse to the path for the Excel file.
6. On the All tab select Extended Properties and click Edit Value.
   • In the Property Value field enter Excel 8.0;HDR=Yes;IMEX=2
7. Click OK.

1. In the Data Source Type drop-down, select Text.
2. Click the ... button next to the Data Source field. Browse to the location of the source file and select it.
3. Click in the the Fixed Width Schema grid and enter the number of characters that make up the first column of data.
4. Press Enter.
5. Repeat Steps 3 and 4 for all other columns.

   

6. The program will then break up the data into columns based on the values entered in the grid.