This page allows you to provide information about how to import a file that you have previously uploaded. You can specify how each field in your CSV will be mapped to fields in the OnlineMooring database, how to handle coded values, and provide information about how your data is formatted.
It is likely that your data will not import cleanly the first time. All situations that prevent data from being loaded into OnlineMooring will be displayed after the import finishes processing.
This page will show all of the OnlineMooring database fields that can be imported:
Database Table - This is the OnlineMooring table name / screen name where the data will be stored and displayed.
Database Field - This is the name of the OnlineMooring entry field, as it appears on the screen.
Import Field - This is the name of a column in your CSV file, based on the column headers that appear in the first row of your CSV file.
Validation - Each field in OnlineMooring can have a "valid value list" associated with it. If there is a valid value list defined (as specified on the List Maintenance screen), then a drop-down list appears on data entry forms instead of a free-form entry field. The Validation field on this form allows you to control how the valid value list will be used and/or updated during the import process. Here are the options:
Import all - If you choose this option, then the valid value list for this field will be ignored during the import process. All data will be loaded "as is".
Import all, add new values to valid value list - If you choose this option, then all data will be loaded "as is", and any values in your CSV file that are not currently in the valid value list will be automatically added to the valid value list, so that users can choose from these values in the future.
Import items that are in the valid value list - If you choose this option, then the import process will only import values that are already in the valid value list. If you have an invalid value, the import routine will display a warning message but will leave the OnlineMooring field blank.
Format - this allows you to specify how your data are formatted in your CSV file. If you find that your data are not formatted in accordance with any of available formats, then you need to update your CSV file so that it does match one of the available formats.
Each format lists the way that the data can appear in the file. Data listed inside square brackets ("[data]") is optional.
Dates - dates can be formatted as [[d[d]/]m[m]/]yy[yy]. This means that your field could just have a year specified (i.e., "2009") or a month/year combination ("12/2009") or a month/day/year combination ("12/31/2009"). If your date doesn't contain a month, we will assume that the month is January. If your date doesn't contain a day, we will assume that it is the first day of the month specified.
Linear Distances - distances can be specified in one of two ways:
Distance - can be formatted as uu[.uuu]. This allows you to specify distances in your desired set of units, whether they be feet or meters. If you wanted to specify a distance of 24' 6", this would be formatted as 24.5
Feet Inches - can be formatted as ff]['[ ]ii][". This allows you to specify distances in a combination of feet and or inches. For example, you could just specify feet (24 or 24'), or you could just specify inches (6"), or you could specify both (24' 6"). Distances are stored in OnlineMooring as decimal units, so the distance in this example would be displayed in OnlineMooring as 24.5.
Coordinate Values - for latitude or longitude fields, the following formats are available:
Degrees - This format allows you to specify the coordinate in decimal degrees. This means that a coordinate of 72 degrees 30 minutes would be represented as 72.5. The format is ddd[.dddddd]
Degrees Minutes - This format allows you to specify the degrees and minutes, but not the seconds. This means that a coordinate of 72 degrees, 30 minutes, 30 seconds would be represented as 72 30.5. The format is ddd mm[.mmmmmm]
Degrees Minutes Seconds - This format allows you to specify the degrees, minutes and seconds separately. This means that a coordinate of 72 degrees, 30 minutes, 30.5 seconds would be represented as 72 30' 30.5"
Stop after errors - This allows you to specify whether to continue processing your import file if any errors are encountered. Whether you decide to continue, a listing of all errors will be shown after processing has completed. If you continue, some of the data in your import file will not be loaded into our database. Depending on the nature of the error, this may mean that a single field will be left blank, or that entire records will be missing.
Delete imported data after errors - If you encounter errors during the processing of this import file, this allows to specify what should be done with the data that had been inserted into the database prior to the error. You can choose to remove all of this new data by choosing the "Delete" option, or you can choose to retain this information in the database by choosing the "Keep" option.