Campbell-scientific LNDB LoggerNet Database Software Manual do Utilizador

LNDBRevision: 7/10Copyright © 2010Campbell Scientific, Inc.

LNDB You can then press the Close button to close the LNDB Engine Service Manager. Once LNDB is installed as a service, you can open the LNDB Engine

LNDB The User Name and Password fields are required only if your server administrator has set up security on your system. Each time you start the cli

LNDB SQL Server Compact is an embedded database that just requires the selection of a filename. The default location of the database will be <worki

LNDB 2.3.3 MySQL The MySQL connection is an ODBC connection. You must use the Windows ODBC Data Source Administrator to configure the database conne

LNDB 3. Selecting Datalogger Tables The first tab on the main screen is Setup. From this screen, you select the datalogger tables for which you woul

LNDB 3.1 Station Setup When a station is highlighted in the left tree, the Station Setup screen is shown. On the Station Setup screen, tables can be

LNDB 3.2 Table Setup When a table is highlighted in the left tree, the right side contains the Table Setup screen. Clicking the Store in database che

LNDB 4. Options The Tools | Options menu item can be used to set the options for LNDB. The following options are available: When Tables Change This t

LNDB 5. Resolving a Conflict A conflict exists for a table when datalogger columns do not match database columns. If in "Stop Storing Data"

LNDB 5.1 Archive Database Table If Archive Database Table is selected, the database table name is shown with the action stating that the table will

LNDB 5.2 Modify Database Table If Modify Database Table is selected, each column that has a conflict is shown with the proper action displayed. Each

LNDB 6. Checking Status and Reviewing Data The function of the Setup Tab of LNDB’s main screen is described in Section 3. The other tabs on the main

LNDB Stopped - Conflict: The table has a conflict and storage has stopped. Blank - Not storing data for this table. Last Error - The last database er

LNDB 6.2.1 Deleting or Archiving Tables All database tables except the meta tables (LNDBStationMeta, LNDBTableMeta, and LNDBColumnMeta) can be remove

LNDB The Significant Events tab shows significant messages. The messages can be paused by clicking the Pause Messages button. Up to 400 messages are d

LNDB 6.5 Log Files LNDB creates three log file types that are stored at <working directory>\logs. For each log file type, there can be up to te

LNDB LN Connection Status Label - Shows the LoggerNet host and port (if not the default port 6789) and whether the connection is not connected, connec

LNDB 7.2 Import From The Filename field is used to indicate the file from which data is to be imported. Only table-based data files are supported and

LNDB 8. Exporting Data The DBExport utility, launched from LNDB's Tools | Export Data menu item, can be used to export data from a database tabl

LNDB 8.1 Database Selection When launched for the first time, DBExport launches the database selection dialog which allows you to select the database

License for Use This software is protected by United States copyright law and international copyright treaty provisions. The installation and use of t

LNDB 8.3 Export Into Filename The Filename field is used to indicate the file to which data should be exported. Press the browse button (…) to browse

LNDB 8.4 Check for Missing Records Select an option from this list box to determine whether DBExport checks for missing records. No Checking DBExpor

LNDB 8.5 Export Once the database table, data file, and other options are set, press the Export button to begin the export. While exporting is in pr

LNDB 8.6 Select Columns When the Select Columns button is pressed, the Select Columns dialog box appears. The Available Columns field will list all

LNDB 8.7 Array Compatible CSV Options When File Format is set to Custom_CSV, the browse button next to the field can be pressed to open the Array Com

LNDB 8.8 Representation of NULL values When the database table being exported contains NULL values, they will be represented as described in the tabl

LNDB Source Name Designates the name that will be used for the database in QuickReports. Type The type of database. Choose a type from the drop-down

LNDB SQL Server To select a SQL Server database source you must select a SQL Server instance. The list of published SQL Server instances is shown in

LNDB MySQL The MySQL connection is an ODBC connection. You must use the Windows ODBC Data Source Administrator to configure the database connection.

LNDB This window allows you to designate a title for your report, select the data table that will be used for the report, select the columns of data t

Limited Warranty The following warranties are in effect for ninety (90) days from the date of shipment of the original purchase. These warranties are

LNDB By default, the Data Grid can display a maximum of 5000 records. If your selected date range exceeds 5000 records, you will only see 5000 record

LNDB 9.4 Generating Your Report Once you have set up your report and customized the components, you save and generate the report by selecting File |

LNDB 36 10. Troubleshooting Database already opened by a different user The "Database already opened by a different user" error can occur i

Appendix A. Data Type Mapping Datalogger data types are mapped into database data types differently depending on the type of database as described be

Appendix A. Data Type Mapping A-2 MySQL Datalogger Data Type MySQL Data Type Notes IEEE4 FLOAT MySQL FLOAT data type only stores 6 digits of

Appendix B. SQL Commands LNDB requires you to have rights to the following commands based on the database type: SQL Server Compact No security availa

Appendix B. SQL Commands B-2

Campbell Scientific Companies Campbell Scientific, Inc. (CSI) 815 West 1800 North Logan, Utah 84321 UNITED STATES www.campbellsci.com • info@campbel

LNDB Table of Contents PDF viewers note: These page numbers refer to the printed version of this document. Use the Adobe Acrobat® bookmarks tab for

LNDB Table of Contents ii 8. Exporting Data ...22 8.1 Database Selection ...

LNDB 1. Introduction LNDB moves data from one LoggerNet server into a single database. The two main components of LNDB are LNDB Manager and LNDB Eng

LNDB 2. Getting Started 2.1 Installing and Starting the LNDB Service The first time you open LNDB, the following error message will occur indicating

LNDB You can choose to install the service under the Local System account or under a User account. Note that a User account is most likely necessary