Support Portal
Support Portal
Getting Started
Getting started with ESdat
Licencee and User Management
Projects, Sites and Locations
Lab Reports
Data Views and Filtering
Bulk Import, Edit and Export
Environmental Standards
Fieldwork - Monitoring Events
Fieldwork - Bore Logging
Logger and Sensor Data
OData Feeds and the API
Settings
Notifications
ESdat Server Administration
Previous Versions
FAQ
How can I change the field analytes or their reporting units in the field app? How can I connect to the OData endpoint connection?Can I pick which analytes to display, and change the grouping, order, and units?How can I upload and display groundwater level data that is collected in the field in ESdat?  How Can I Get Field and Lab Results to Show on the Same Line in a Chemistry Table Export?How can I upload my own environmental standard into my ESdat?What Should I Do If the Data for a Location is Shown as Separate Lines in the Graphs View?What information should I include when I create a Location Code? Why Can’t I See Some of the Analytes in Chem Tables?Why Is My Data Missing from the Piper Plots?I have received some csv/excel files exported from EQuIS, how do I import them into ESdat?Results are being exported as text, how can I export them as numbers?
Notifications
Mapping

Results are being exported as text, how can I export them as numbers?

If you’re encountering this issue it is likely you are using the formatted Chemistry Exceedance Table report as a data export to obtain the data for further analysis.   The Chemistry Exceedance Table report is designed for reporting, not as a data export, so is not the best way to export data if you need results as numbers to do further analysis.

There are alternative options available in ESdat, depending on how you need the data to be arranged:

  • The ProUCL export (available in Data Migration Manager – Export), has analytes across the top, and sample information down the table - similar to the Chem Table export.  It also exports a detect or non-detect flag for each result, but in an adjacent column to the actual result which is exported as a number.
     
  • The “Chemistry List” view exports the result in it’s own column as a numeric format.    Data Explorer also has an export similar to the Chemistry List, however it can be set up to retain a live data link in the export so that as more data is added to ESdat the data in Excel can be updated without having to re-export.

 

Powered by Product Fruits