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

Notification

Icon
Error
Importing Historical Data
Options
Go to last post Go to first unread
Previous Topic Next Topic
Unknown  
#1 Posted : Tuesday, November 17, 2009 5:35:49 AM(UTC)
Unknown
Rank: Advanced Member

Reputation:

Groups: Registered
Posts: 78

Thanks: 1 times
  We are about (early next week) to receive a large amount (2002,2003,2004 and 2008 monitoring rounds for 50-100 wells) of historical groundwater data . It will be in an access database format. Are there any issues receiving data in this format as far as importing into ESdat is concerned ?   The fields in the access database are likely to be as follows 
Bore ID -SampleIDSample DateGroupAnalyteUnitsConcND Aquifer
  

The previous consultants on site have generated their own Sample ID’s  which are a composite of the bore id, the date, and in some cases a prefix which I think refers to the grid (site is divided up in a grid pattern) the monitoring well is located in. I thought it might be a good idea to keep this ID rather than adopting the auto naming convention in ESdat in case we have to cross reference back to the original data.   

 

To disable the function in the historical chemistry import template for auto generating a samplecode is it just a matter of deleting the formula in cell A6 before pasting any dat in ??
Back to top

Wanna join the discussion?! Login to your ESdat Forums forum accountor Register a new forum account.
Back to top  
Warwick Wood  
#2 Posted : Tuesday, November 17, 2009 5:40:15 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)

Those fields look straightforward.  You would use the Historical / Other Chemistry import template.  The second of the two sheets / formats (columnar format) will be the best for this data.

If the samples have unique Sample IDs already I would recommend keeping them rather than generating a seperate set using the formulae provided.  It is there to provide assistance if needed, but you don’t have to use it.  The only requirement of the SampleCode is that it is unique for each sample.  It can even be sequential numbers (1,2,23,4,etc..) if that were appropriate.
Back to top
WWW
Similar Topics
Importing Historical Data - no sample data (ESdat)
by T.List 3/9/2018 12:57:30 PM(UTC)
Importing Historical Data (ESdat)
by Jufar 3/8/2016 4:55:22 PM(UTC)
Importing historical data using historical/other blank import table (ESdat)
by JBanning 3/13/2013 8:00:10 PM(UTC)
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.

Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET