• Sign In
  1. Messages

Importing Datasets (Studies) without Dates

LabKey Support Forum (Inactive)

View Message

view list print
Importing Datasets (Studies) without Dates diego  2016-05-04 08:31
Status: Closed
 
Had a meeting with the researchers of my group and it turns out that some of the older studies do not have any date or start date fields. CSV files are referenced via a Participant_ID. Is there a way of importing that sort of CSV files and would I be able to join tables solely on Participant_ID? Have attached a diagram.

Thanks in advance!

Diego
 
 
jeckels responded:  2016-05-04 09:18
Hi Diego,

You can mark a dataset as being demographic data, which does not require a date and allows you to connect based on the participant ids. Note that these types of datasets only allow one row per participant, but I think will match well with your diagram.

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

Thanks,
Josh
 
diego responded:  2016-05-04 10:29
Josh,

Can I define the CSV file to be uploaded as a demographic data file before the initial import? Have attached two screenshots of the issue I am encountering.

Thanks,
Diego
 
Jon (LabKey DevOps) responded:  2016-05-04 10:37
Hi Diego,

No, unfortunately you will need to edit that dataset to set the demographics option after you do the upload as per our documentation here:

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

Otherwise, you will need to create the dataset first with all your fields, enable the demographics option, then upload your data into the table.

Regards,

Jon
 
diego responded:  2016-05-04 13:49
Jon,

Have clicked on "edit definition" and added the fields that correspond to the CSV files, but noticed that "ParticipantID" and "date" are required... Is there anyway of disabling the requirements for both of the former fields?
Attached are two screenshots.

Thanks,
Diego
 
Jon (LabKey DevOps) responded:  2016-05-04 13:53
Hi Diego,

No, they're required for the dataset to work.

Have you considered just adding a generic date field using today's date to satisfy the dataset requirements?

Regards,

Jon
 
diego responded:  2016-05-04 13:55
Jon,

We actually were talking about that in the meeting, will try it out and get back to you!

Thanks,
Diego