Converting E-DAS DataThis is a featured page

If you will be using existing historical data from E-DAS Ambient systems, the AirVision ImportUtility can convert it to AirVision data with sites and parameters configured. The Import utility can be found in the "Utilities" section of the AirVision menu.

Converting E-DAS Data - AirVision

Select:
Data Type(s) to be converted
Date Range

Options
are:
Use Site Long name if they exist (provides more descriptive name, now that we have more than 8 characters to use)
Append Logger ID to front of site name (also helpful)
Append Channel Number to front of Parameter name (sorts parameters by logger channel order, rather than alphabetically by SO2, NOX, etc).

The import utility can be run repeatedly over time, so it is recommended that you first just convert configuration and one day of hourly data as an initial test of your E-DAS files. After this, you can convert hourly data (generally 1-3 hours to import a year), and then do minute data (1-3 months at a time) as an overnight process.

Logbook Import
Because the Logbook was stored in MS Access, and MS Access report tools operate in peculiar environment, we were not able to integrate Logbook import as part of the Import tool. The Logbook will need to be imported via command line task, from the \Program Files\Agilaire\AirVision\Server directory:

E.g. (assumes LogBook.mdb)
Edasimporter /D LogBook /P C:\test

E.g. (alternate filename specified)
Edasimporter /D LogBook /P C:\test /F MyOtherFile.mdb



Once the data is converted, a minumum "quick start" checklist of configuration items would be:




sdrevik
sdrevik
Latest page update: made by sdrevik , Oct 6 2011, 6:36 PM EDT (about this update About This Update sdrevik Edited by sdrevik

29 words added
1 image added

view changes

- complete history)
Keyword tags: None
More Info: links to this page
Started By Thread Subject Replies Last Post
jberschling AirVision Conversion Utility Version 2 Feb 25 2010, 8:33 PM EST by sdrevik
Thread started: Feb 24 2010, 9:39 AM EST  Watch
Is it important to use the newest version of the Conversion utility? I am having trouble uninstalling the version installed with the beta software (ver 1.0.1) but would like to use the version 9.0.21022.8 (?) supplied with the AirVision 1.0.2 software.
Do you find this valuable?    
Keyword tags: E-DAS conversion version
Show Last Reply
jberschling conversion Errors 2 Feb 25 2010, 8:32 PM EST by sdrevik
Thread started: Feb 25 2010, 9:26 AM EST  Watch
what do these errors mean?

AirVisionConversion.ConvertConfiguration: Invalid column name 'OverwriteMathConstantBase'.
Invalid column name 'OverwriteMathConstantExt1'.
Invalid column name 'OverwriteMathConstantExt2'.
Invalid column name 'ModbusIP'.
Invalid column name 'ModbusPort'.
Invalid column name 'ModbusCode'.
Invalid column name 'ModbusRegister'.
Do you find this valuable?    
Keyword tags: None
Show Last Reply
jberschling Computer reboot during EDAS conversion 1 Feb 25 2010, 8:28 PM EST by sdrevik
Thread started: Feb 24 2010, 9:41 AM EST  Watch
I left the computer running the conversion process, and returned to find there had been a power outage. How do I find out if the process completed before the power outage?
Do you find this valuable?    
Keyword tags: E-DAS conversion reboot
Show Last Reply
Showing 3 of 3 threads for this page