The Import Data module is a flexible tool used for importing data into an Hydro GeoAnalyst project. When starting a new project, it will likely be necessary to enter data from other sources into the Hydro GeoAnalyst database. While you can enter data manually on the Station List Tab, Sample List tab, and/or the Non Station Data Tab, it is more efficient to import your data.
You can launch the Import Data module by selecting Modules > Import or by selecting the Import Data icon from the toolbar. The module will launch and give you several options for importing depending on what kind of data you wish to import.
You need to select the option you want and then select the Next button to launch the appropriate module to import your data:
•The General option should be used when you are importing general tabular data. The general option is particularly recommended when you are importing stations as it will perform coordinate transformations. Additionally, you may convert data units during your import using the General option.
•The EDD option lets you import the files that have been validated within our Quick Checker program.
•The Mobile EDD option lets you import data that has been submitted through a Mobile EDD form.
•The Diver option is available to import pressure transducer data Diver dataloggers.
•The LAS is available to import Log ASCII Standard (LAS) files, a standard format introduced by the Canadian Well Logging Society in 1989.
•The Images option is available to import pictures of stations.
Please Note: When formatting your Excel source file for importing using the Samples or General import options, it is important to organize your station names so they will be recognized by the import routine. If left unspecified, Excel will assume the data type format based on the first 8 rows of each column; therefore, if you have some station names that are completely numeric at the top of the file to be imported, the import options may have difficulty recognizing them as names (Data Type String). To avoid this, you will need to ensure that you manually assign the data type within Excel as Text. To do this:
oright-click on the cells (or their column) and select Format Cells...
oSelecting the Text option in the Number tab dialog that appears.
You will notice that your numeric station names are now left justified in the Excel column. Similarly, if you have completely numeric Sample ID's you will need to do the same for this column. In fact any field in the Hydro GeoAnalyst database that is set to have a data type "String" you will need to do this in order to be able to import completely numeric values.