Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
sthompson  
#1 Posted : Tuesday, July 27, 2010 1:37:44 PM(UTC)
sthompson
Rank: Newbie

Reputation:

Groups: Registered
Posts: 0
Location: Whitehorse

Whenever I import data into ESdat it all apears to import properly.  All the lines highlight in green after uploading, but when I try and find pH within Water Chemistry, I can't.  It's not uploading properly.  Help!  I have no idea why this is happening?
Warwick Wood  
#2 Posted : Tuesday, July 27, 2010 6:17:03 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

Hello,

I expect that the issue in in the unit conversion.  All results go through the unit conversion process, even pH, where this isn't typically relevant. 

If you click "Check Units" in the main screen you should see pH listed, and you can add a conversion of 1 from the unit you gave during import (ie "-" or "pH Unit" etc...) and the unit specified for output.

Regards,

Warwick 

 

sthompson  
#3 Posted : Tuesday, July 27, 2010 7:59:35 PM(UTC)
sthompson
Rank: Newbie

Reputation:

Groups: Registered
Posts: 0
Location: Whitehorse

Thank you, it's fixed!
sandras  
#4 Posted : Saturday, September 11, 2010 12:23:11 AM(UTC)
sandras
Rank: Newbie

Reputation:

Groups: Registered
Posts: 0
Location: Adelaide

Hi Warwick,

I've got the same problem with importing pH data. It works fine for a laboratory report from the secondary lab, but not for the primary lab. I have checked csv files from both labs and pH is included in the lab reports. I can also import the data without problems. pH just does not apppear in the result tables (primary lab) and I can also not find it in the ESdat data base. I checked the units but cannot convert. The error message: "230 The INSERT permission was denied on the object 'zRef_ConvertUnits', database 'ESdat_HG', schema 'dbo'." appears.

Do you know where the problem is and how I can solve it?

Thanks,

Sandra

 

 

 

Warwick Wood wrote:

Hello,

I expect that the issue in in the unit conversion.  All results go through the unit conversion process, even pH, where this isn't typically relevant. 

If you click "Check Units" in the main screen you should see pH listed, and you can add a conversion of 1 from the unit you gave during import (ie "-" or "pH Unit" etc...) and the unit specified for output.

Regards,

Warwick 

 

Support  
#5 Posted : Saturday, September 11, 2010 1:09:17 AM(UTC)
Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 259
Location: Ballina

Was thanked: 8 time(s) in 8 post(s)

Hello Sandra,

It looks like you are using the SQL Server version, and an older version of ESdat? 

In the SQL Server version only Power Users can add conversions.  You will need to get a power user to add the conversion you need.  This prevents erroneous conversions being entered.

Alex

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.