ODBC Dialog box in InfoSewer

The Open Database Connectivity (ODBC) module of InfoSewer allows the user to actively link to any external database and import that data into the current InfoSewerH20Map Sewersession. Likewise, the user can also update an external database with InfoSewerH20Map Sewer data.

To initiate the ODBC Exchange, from the InfoSewerH20Map SewerControl Center -> InfoSewerH20Map Sewer button -> Exchange menu, select ODBC Exchange and the following dialog box appears. To learn more about the ODBC Exchange procedure click here.

InfoSewerH20Map Sewer Data Fields Mapping

This is where a direct "one-to-one" link is established between the external database fields and the internal IInfoSewerH20Map Sewer database fields. For example, the external database file may have a field named "Diam" that represents pipe diameter. To accurately map the "Diam" field to the internal InfoSewer diameter database field, select the "Diam" field under the ODBC Data Fields box, select the Diameter field under the InfoSewerH20Map Sewer data fields and then click on the map button [>].

InfoSewerH20Map Sewer Data Fields Mapping

This is where a direct "one-to-one" link is established between the external database fields and the internal InfoSewer database fields. For example, the external database file may have a field named "Diam" that represents pipe diameter. To accurately map the "Diam" field to the internal InfoSewer diameter database field, select the "Diam" field under the ODBC Data Fields box, select the Diameter field under the InfoSewerH20Map Sewer data fields and then click on the map button [>].

Close

Close and exit the ODBC Exchange Manager

Mapping Options

The display buttons allow the user to map, remove and reset fields as well as save and open an import template.

Map Single Field - To use this icon, select one record from the left hand window, click the Remove icon and the field is no longer mapped to the specified InfoSewerH20Map Sewer field.

Remove Single Field - To use this icon, select one record from the InfoSewerH20Map Sewer Data fields box, click the Remove Single Field icon and the field is now "unmapped".

Reset - This icon will remove all mapped fields.

Load - This icon will open a previously saved field collection table. This is a time saving feature that allows the user to quickly map a known external table with the internal InfoSewerH20Map Sewer database.

Save - By using the save feature, the user can store an ODBC template to a field collection folder. With a saved folder, a mapping template file can be recalled during any ODBC procedure.

ODBC Data Fields

These are all the fields that will be added to the ODBC

ODBC ID Mapping Field

The unique field in the external database that accurately represents a "one-to-one" link between the external database and the selected InfoSewerH20Map Sewer database (theInfoSewerH20Map Sewer ID field).

ODBC Data Source

Use this to launch the ODBC Data Source dialog box. Click here to learn more about the ODBC exchange process.

ODBC Table

Select from one of the tables present in the ODBC directory as specified from the DSN under the ODBC Data Source. Click here to learn more about the ODBC Data Source.

Options

Select to either insert new records or update new records. When importing to a New InfoSewer project choose to Insert New Records. When importing to an existing project choose either to add New Records or to Update Existing Records or both.

Purge ODBC

This option only applies to ODBC links from InfoSewerH20Map Sewer to an external database file. If this box is checked, the entire external file will be purged prior to the ODBC export.

Update Direction

Select which direction the ODBC linkage is occurring. If you are exporting data from InfoSewerH20Map Sewer to the external database, select Internal (InfoSewerH20Map Sewer) --> ODBC. Likewise, if data is being imported intoInfoSewerH20Map Sewer, select ODBC --> Internal (InfoSewerH20Map Sewer).

ODBC Variables

Manholes

ID

DESCRIPT

TYPE

ELEVATION

YR_INST

YR_RETIRE

ZONE

PHASE

DIAMETER

RIM_ELEV

HEADLOSS

LOAD1

TYPE1

PATTERN1

COVERAGE1

LOAD2

TYPE2

PATTERN2

COVERAGE2

LOAD3

TYPE3

PATTERN3

COVERAGE3

LOAD4

TYPE4

PATTERN4

COVERAGE4

LOAD5

TYPE5

PATTERN5

COVERAGE5

LOAD6

TYPE6

PATTERN6

COVERAGE6

LOAD7

TYPE7

PATTERN7

COVERAGE7

LOAD8

TYPE8

PATTERN8

COVERAGE8

LOAD9

TYPE9

PATTERN9

COVERAGE9

LOAD10

TYPE10

PATTERN10

COVERAGE10

SWS_AREA

SWS_RUNOFF

SWS_SLOPE

SWS_LEN

HYETOGRAPH

HYDROGRAPH

SWS_PERIMP

SWS_PERV

SWS_IMPERV

SWS_INFIL1

SWS_INFIL2

SWS_DECAYSWS_REGENSWS_TOCSELECTEDSYMBOLSYMSIZEHANDLEANNOHNDLXYZINACTIVEDOMAINQRYSETCOLOR

Wet Wells

ID

DESCRIPT

YR_INST

YR_RETIRE

ZONE

PHASE

COST_ID

TYPE

BTM_ELEV

HEADLOSS

MIN_LEVEL

MAX_LEVEL

INIT_LEVEL

DIAMETER

CURVE

SELECTED

SYMBOL

SYMSIZE

HANDLE

ANNOHNDL

X

Y

Z

INACTIVE

DOMAIN

QRYSET

COLOR

Pipes

ID

DESCRIPT

TYPE

YR_INST

YR_RETIRE

ZONE

PHASE

MATERIAL

LINING

COST_ID

FROM_INV

TO_INV

LENGTH

DIAMETER

COEFF

PARALLEL

FROM

TO

CAL_LENGTH

SELECTED

SYMBOL

SYMSIZE

HANDLE

SYMHANDLE

ANNOHNDL

INACTIVE

DOMAIN

QRYSET

COLOR

Pumps

ID

DESCRIPT

YR_INST

YR_RETIRE

ZONE

PHASE

RATED_PWR

COST_ID

TYPE

PARALLEL

CAPACITY

SHUT_HEAD

DSGN_HEAD

DSGN_FLOW

HIGH_HEAD

HIGH_FLOW

FROM

TO

CAL_LENGTH

SELECTED

SYMBOL

SYMSIZE

HANDLE

SYMHANDLE

ANNOHNDL

INACTIVE

DOMAIN

QRYSET

COLOR

ODBC Methodology

The Open Database Connectivity (ODBC) module of InfoSewerH20Map Sewer allows the user to actively link to any external database (Such as dBASE, Excel, ForPro, MQUIS (SQL server), MS Acess etc) and import that data into the current InfoSewerH20Map Sewer session. Likewise, the user can also update an external database with the InfoSewer data.

Methodology

Use the following procedure to use the InfoSewerH20Map Sewer ODBC data exchange platform.

• Launch the ODBC Exchange dialog box from the InfoSewer Control Center -> InfoSewer button -> Exchange menu.
• Choose the InfoSewerH20Map Sewer Data Source. These data sources correspond with the different InfoSewerH20Map Sewer tables.
• Choose the appropriate Update direction. In order to import data choose ODBC->InfoSewer and to export data out of the InfoSewer project choose InfoSewer ->ODBC.
• Click on the ODBC Data Source to specify the external data base that you want to link to. The ODBC data source is required in order for InfoSewer to use the correct driver when linking to the desired external data file. The data source also supplies InfoSewer with the directory path to the external files so that a link can be established. Click here to learn more about ODBC Data Sources.
• Once the Data Source has been established, choose the ODBC table and the ID mapping field (when importing into InfoSewerH20Map Sewerr)
• All the available fields (during the import process) will be listed under the ODBC Data fields section of the ODBC dialog box. Click on the appropriate field under the ODBC fields section and then select the corresponding InfoSewerH20Map Sewer field by clicking on it and then click on the mapping arrow > to map the two fields. Continue this process till all the desired ODBC fields have been successfully associated with the InfoSewerH20Map Sewer fields.
• Finally when all the fields have been mapped, choose the Options button to specify your Import or Export options and then click on Exchange to start the exchange process.