logo
    Helping YOU do what YOU want with YOUR data.
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Joe Ferring  
#1 Posted : Thursday, September 14, 2017 12:15:42 PM(UTC)
Joe Ferring
Rank: Newbie

Reputation:

Groups: Registered
Posts: 1
Location: Sydney, NSW, Aus

Hi guys, 

Following import of lab data for new sampling locations, the new location codes are not appearing in the Locations tab or within the Location data table; however the Chem Tracking tab does show the new loc codes. We are able to create new loc codes with the same IDs as the ones we just created as part of the lab data import (but that weren't appearing).

Have you seen this before? Any thoughts?

cheers

Warwick Wood  
#2 Posted : Sunday, September 17, 2017 5:00:11 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

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

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

Hi Joe,

Normally there is a foreign key in the database that prevents a Location Code being assigned to a Chemistry Sample unless it is in the Locations table.

We have seen once before that that Foreign Key wasn't present (the reason why wasn't clear) and it was possible to assign a Location to a Chemistry Sample even though that Location isn't in the Locations table.

It sounds like you have the same situation.  Unless that is intentional I'd suggest export the data into a fresh database (using the EDIF).  If your fresh database also has that issue your new database template may be the problem, and that may need to be replaced.

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.