Hi,

So I am having some issues uploading historical data - I've used the 'chem column format' template before with this project but for some reason this time it's not working.  When I hit upload I get the expected 'samples' and 'results' tables.  Samples uploads fine but when I move to the results I get some confusing errors....

First I will set the import options to 'Add new' and 'Create Missing Parent Records' this returns errors for all records that the records already exist.  It gives the same error if I use 'Require Parent Records'.

If I choose 'Update Existing' / 'Require Parent Records' the error I get is the records don't exist. I get the same error if I choose 'overwrite existing'.

How is it that my records both exist and don't exist at the same time! quite the paradox.... ugh.

I've tried unhighlighting all coloring and removing all error comments; I've tried recreating my entire spreadsheet. 

Any hints/suggestions?? 

Here's one portion of my data.  I start with the 'Chem Column' sheet and then click on the import button (little blue arrow) and it produces the 'Samples' and 'Results' sheets.... as you can see from the color the samples sheet imports and then the results sheet first gives the 'already exists' message and then changes to 'doesn't exist' (as described in post above).

File Attachment(s):

historical_data.xls (1,333kb) downloaded 9 time(s).

You cannot view/download attachments. Try to login or register.

Hello,

Im having trouble opening it at the moment.  One thing to check though, have you populated all the columns with a double green column heading (the combination of w=which define a unique record - the primary key).  In particular the "Total_or_Filtered" and "Method_Name" columns in the Chemistry Results Sheet.

Alex

Thanks for getting back to me; Gives me things to watch for going forward. With the delay in response I actually did go back and deleted all added to this project and then re-uploaded.  It seems to work better now.  I will go back and make sure all the double green fields are filled in. 

 I do have a couple of annoyances to note though - when you first get this historical chem table from ESdat some of the yellow fields have the option to change the field header through a drop down menu (ie: SDG can be changed to Lab_Report_Number) however when I do this and then upload, the data from the field that was changed doesn't upload - but if I leave it as is (ie SDG) then it will upload and I then move this information to the correct field in the samples table. 

Another buggy thing is when I'm entering sample type information on the samples table I get a drop down for field_D, field_B etc... it asks me to select the parent sample and puts that information in the next field (parent sample).  However when I have literally thousands of records this is not very helpful - i skim through to find the next dup and when I find that box there is no drop down - i can type in field_D but the selector doesn't come up until I have tabbed or press enter - then the selector drops the parent sample info in the the box beside (ie not in the parent sample field or in the record below the record of interest) - it would be preferrable if the selector didn't exist or is activated without leaving the cell where I'm entering field_D.

 Obviously I've found ways to work around both of these but they are irritating when you have so much data to deal with.