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

Notification

Icon
Error

Options
Go to last post Go to first unread
Katrina  
#1 Posted : Tuesday, June 7, 2011 5:13:42 PM(UTC)
Katrina
Rank: Newbie

Reputation:

Groups: Registered
Posts: 0
Location: Calgary, AB

I'm currently trying to import both dissolved metals data and total metals data into my database.  Is there any way to differentiate between these two when you are importing? i.e. a column where you can input T of F.

 

Support  
#2 Posted : Tuesday, June 7, 2011 5:37:11 PM(UTC)
Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 259
Location: Ballina

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

Hello,

You are probably importing using the "Crosstab" or "Tabular" method that is easiest for historical data.

This comes from the "Importing Historical Chemistry" section of the help file as applies to importing cross-tabbed data: 

 If a result is Field Filtered the word "Filtered", "Dissolved" or "Soluble" (case insensitve) needs to be included in the compound name. If this is the case the results will automatically be given a "Total_or_Filtered" value of "F". Result prefixes can be included with the result.

I hope this helps,

Alex

 

bcoates  
#3 Posted : Tuesday, May 21, 2013 3:03:04 AM(UTC)
bcoates
Rank: Newbie

Reputation:

Groups: Registered
Posts: 1
Location: CH2M HILL

I am also trying to enter dissolved and total metals into my database. I have tried your recommendation and entered 'Total' or 'Filtered' into the compound name of each but it is coming up as 'Record already exists' for the Total metals data.

Can you see where I went wrong? Is there any other way to do this?

Warwick Wood  
#4 Posted : Tuesday, May 21, 2013 4:17:03 AM(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,

 

Please have a read of http://www.ESdat.net/ESd...istorical_chemistry.htm, and if that doesn't resolve it, check if the data is actually already in the database.

You may like to Check Units in ESdat (to make sure there are no unit conversion issues), then produce a Chemistry Output table, to confirm what has already been imported.

Regards,

Warwick

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.