ESdat Forums
»
Forums
»
ESdat
»
Index or Primary Key error
 Rank: Newbie
Groups: Registered
Posts: 0
Location: Whitehorse
|
Hello, I’m trying to import historical data, and I keep getting the same error: “Index of primary key cannot contain a Null value.” Could you please take a look at the attached spread sheet, and let me know how you think I could resolve it? Thanks, Sarah File Attachment(s):  Index or Primary Key.xls (30kb) downloaded 2 time(s).You cannot view/download attachments. Try to login or register.
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators
Posts: 259
Location: Ballina
Was thanked: 8 time(s) in 8 post(s)
|
Hello, The issue is that some of your Primary Key values are blank. These generally need to be populated, unless a default is indicated. Primary Keys are indicated in a double green colouring. For more information see http://ESdat.net/ESdathe...?importingdata.htm Alex
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Posts: 0
Location: Whitehorse
|
I am having another problem with importing historical data.All my results are being successfully imported into Chemistry Tracking under ChemQA_Samples_with_Raw_Results, but none of my historical results are under the tab Water Chemistry LChem1_Chemistry Why would this happen? I need the results under Water Chemistry. Thanks, Sarah
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Posts: 0
Location: Whitehorse
|
Never mind I figured it out.
|
|
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
Index or Primary Key error
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.