How to attach temperature logs to specimens ?

Study Forum (Inactive)
How to attach temperature logs to specimens ? vincentR  2012-11-20 07:32
Status: Closed
 
Hi,

I am a new user of LabKey, and first of all, it is an amazing tool that you guys provide to the community. Thanks for that !

About my question, in our study we receive specimens on a daily basis, and we have a temperature logger, within the shipment, to let us know if the specimens were kept at a proper temperature.
These logs are simple CSV files.

How would you advise me to store these CSV file data into LabKey, so that it can be attached to all the specimens that belonged to the corresponding transport.

I hope it makes sense,
looking forward to learning more about LabKey,

best,

Vincent.
 
 
Matthew Bellew responded:  2012-11-20 09:00
The easiest way to add your own table to a LabKey server is to use a list.

https://www.labkey.org/wiki/home/Documentation/page.view?name=lists

However, if you need custom indexes for performance, or if you have a lot of data (maybe several hundred thousand rows) you might consider making a custom table.

https://www.labkey.org/wiki/home/Documentation/page.view?name=sqlScripts

It's not as hard as it sounds, but I'd recommend starting with the list approach anyway. Let us know how it goes.

Matt
 
vincentR responded:  2012-11-21 09:32
Many thanks for your quick response.

I might not have been very clear with the way I formulated my question.
I can easily upload my temperature logs as a labkey list, but I struggle to find a way to link these logs with the corresponding specimens that are also stored in labkey.

In the best world, I would like to have a LabKey view where, from a list of specimens, I can access a graph presenting the temperature logs.

best,

Vincent.
 
Matthew Bellew responded:  2012-11-26 09:24
This is hard to answer because there are too many answers. Here are some ideas.

First, you can define a "lookup" (foreign key from the temperature data to the specimen data. This doesn't help you generate the kind of UI you are looking for, but that makes it easy to join the specimen data to the temperature data.

To build a linked UI, of course yo first need to build a report or view that takes a parameter on the URL and generates the view you want to include. You might be able to do this using one of our built in chart types, or you could build a view in javascript or a report in R.

Then you need to hook this view up to your view of specimen data. Again there are a few choices. You could build a custom details view of your specimen data, or add a new virtual column to the built in specimens table that links to your chart. You will need to use the "edit metadata" feature of the schema designer to change LabKey's default handling of this built in table.

https://www.labkey.org/wiki/home/Documentation/page.view?name=tableSchemas

I think it's a bit too much to put a complete solution into this post response, but I'd be happy to help with this problem on the phone. Send me an email directly, and I'll try give you a bit more specific help. mailto:matthewb@labkey.com

Matt