#INFOSEWER

ODBC Dialog box in InfoSewer


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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s