• Sign In

Search site

HIV Study Tutorial
Found 306 results
Displaying page 2 of 16

"testFile.csv" attached to message "Date error msg: "couldn’t convert date field, should be of type timestamp""

ParticipantId SequenceNum Date CD4 Lymphocytes Hemoglobin PT-101 18 2021-06-20 843 2374 13.0 PT-101 3 2020-04-26 210 553 11.0 PT-101 4 2020-05-24 223 805 13.0 PT-101 5 2020-06-21 351 941 11.0 PT-101 6 2020-07-19 298 847 14.0 PT-101 24 2021-12-05 768 2060 11.0 PT-101 23 2021-11-07 744 2334 12.0 PT-101 7 2020-08-16 404 2549 12.0 PT-101 8 2020-09-13 536 1425 15.0 PT-101 9 2020-10-11 475 1654...

"LabResults.xls" attached to message "Date error msg: "couldn’t convert date field, should be of type timestamp""

data ParticipantId VisitId Date CD4 Lymphocytes Hemoglobin PT-101 18 6/20/21 0:00 843 2374 13 PT-101 3 4/26/20 0:00 210 553 11 PT-101 4 5/24/20 0:00 223 805 13 PT-101 5 6/21/20 0:00 351 941 11 PT-101 6 7/19/20 0:00 298 847 14 PT-101 24 12/5/21 0:00 768 2060 11 PT-101 23 11/7/21 0:00 744 2334 12 PT-101 7 8/16/20 0:00 404 2549 12 PT-101 8 9/13/20 0:00 536 1425 15 PT-101 9 10/11/20 0:00 475...

"Demographics.xls" attached to page "Tutorial: Inferring Datasets from Excel and TSV Files"

Sheet1 ParticipantId VisitId Date StartDate Country PrimaryLanguage Sex TreatmentGroup StatusOfInfection PT-101 0 2020-02-02 2020-02-02 Germany German f ETR HIV Positive PT-102 0 2020-02-02 2020-02-02 USA English f DRV HIV Positive PT-103 0 2020-02-02 2020-02-02 USA English m No Treatment HIV Positive PT-104 0 2020-02-02 2020-02-02 USA French m HIV Negative HIV Negative PT-105 0 2020-02-02 2020-02-02...

"Demographics.xls" attached to page "Step 2: Import Datasets"

Sheet1 ParticipantId SequenceNum Date StartDate Country PrimaryLanguage Sex TreatmentGroup StatusOfInfection PT-101 0 2020-02-02 2020-02-02 Germany German f ETR HIV Positive PT-102 0 2020-02-02 2020-02-02 USA English f DRV HIV Positive PT-103 0 2020-02-02 2020-02-02 USA English m No Treatment HIV Positive PT-104 0 2020-02-02 2020-02-02 USA French m HIV Negative HIV Negative PT-105 0 2020-02-02...

ViralLoad_PCR.xlsx

data ParticipantID SequenceNum SpecimenId Date RNA copies Comments PT-101 1 vl-100 1/1/08 0 PT-101 2 vl-100 2/2/08 0 PT-101 3 vl-100 3/3/08 0 PT-101 4 vl-100 4/4/08 0 PT-101 5 vl-100 5/5/08 0 PT-101 6 vl-100 6/6/08 0 PT-101 7 vl-100 7/7/08 0 PT-101 8 vl-100 8/8/08 0 PT-101 9 vl-100 9/9/08 0 PT-101 10 vl-100 10/10/08 0 PT-101 11 vl-100 11/11/08 0 PT-101 12 vl-100 12/12/08 0 PT-102 1 vl-200...

Lab Results.xlsx

data ParticipantID SequenceNum Date CD4 Lymphocytes Hemoglobin Comment PT-101 1 1/1/2008 789 1290 14 CD4 PT-101 2 2/2/2008 850 1577 14 700 PT-101 3 3/3/2008 738 1518 13 900 PT-101 4 4/4/2008 825 1483 18 PT-101 5 5/5/2008 806 1542 11 Lymphocytes PT-101 6 6/6/2008 830 1360 13 1200 PT-101 7 7/7/2008 770 1651 13 1800 PT-101 8 8/8/2008 879 1718 17 PT-101 9 9/9/2008 785 1480 14 Hemo PT-101 10...

Lab Results.xlsx

data ParticipantID SequenceNum Date CD4 Lymphocytes Hemoglobin Comment PT-101 1 1/1/2008 789 1290 14 CD4 PT-101 2 2/2/2008 850 1577 14 700 PT-101 3 3/3/2008 738 1518 13 900 PT-101 4 4/4/2008 825 1483 18 PT-101 5 5/5/2008 806 1542 11 Lymphocytes PT-101 6 6/6/2008 830 1360 13 1200 PT-101 7 7/7/2008 770 1651 13 1800 PT-101 8 8/8/2008 879 1718 17 PT-101 9 9/9/2008 785 1480 14 Hemo PT-101 10...

Query Metadata: Examples

This topic provides examples of metadataSql used to change the display and behavior of fields in tables and queries. Auditing Level Conditional Formatting Include Row Selection Checkboxes Hide a Field from Users Show/Hide Columns on Insert and/or Update Use a Format String for Display Use a Text Expression for Display Set a Display Width for a Column Display Columns in Specific Order...

Hematology.xlsx

data ParticipantID SequenceNum VisitName SpecimenId Date CD4 Lymphocytes Hemoglobin Comment PT-101 1 Visit 1 vl-100 1/1/08 860 1527 14 CD4 PT-101 2 Visit 2 vl-100 2/2/08 825 1689 15 700 PT-101 3 Visit 3 vl-100 3/3/08 851 1601 14 900 PT-101 4 Visit 4 vl-100 4/4/08 767 1762 14 PT-101 5 Visit 5 vl-100 5/5/08 774 1386 12 Lymphocytes PT-101 6 Visit 6 vl-100 6/6/08 800 1467 17 1200 PT-101 7 Visit...

ImmuneScore - Assay.xlsx

data ParticipantID Date VisitId SpecimenId M1 M2 M3 InstrumentSetting OperatorEmail Comment PT-101 1/1/08 1 vl-100 28.0 31.0 90.5 3.0 john@labkey.com PT-101 2/2/08 2 vl-100 29.0 42.0 87.0 4.0 john@labkey.com PT-101 3/3/08 3 vl-100 13.5 66.0 90.0 2.0 john@labkey.com PT-101 4/4/08 4 vl-100 13.0 53.5 89.0 4.0 john@labkey.com PT-101 5/5/08 5 vl-100 35.5 69.0 80.0 2.0 john@labkey.com PT-101 6/6...

"immune-score.xlsx" attached to page "Step 2: Import Lab Data"

Sheet1 ParticipantId SpecimenId Date M1 M2 M3 pt-1 vl-100 4/4/20 1 0.8 0.12 pt-1 vl-200 6/4/20 0.9 0.6 0.22 pt-1 vl-300 8/4/20 0.8 0.7 0.32 pt-2 vl-400 4/4/20 0.77 0.4 0.33 pt-2 vl-500 6/4/20 0.99 0.5 0.44 pt-2 vl-600 8/4/20 0.98 0.55 0.41 pt-3 vl-700 4/4/20 0.94 0.3 0.32 pt-3 vl-800 6/4/20 0.8 0.77 0.21 pt-3 vl-900 8/4/20 0.88 0.88 0.22 pt-3 vl-1000 10/4/20 0.87 0.66 0.11

immune-score.xlsx

Sheet1 ParticipantId SpecimenId Date M1 M2 M3 pt-1 vl-100 4/4/20 1 0.8 0.12 pt-1 vl-200 6/4/20 0.9 0.6 0.22 pt-1 vl-300 8/4/20 0.8 0.7 0.32 pt-2 vl-400 4/4/20 0.77 0.4 0.33 pt-2 vl-500 6/4/20 0.99 0.5 0.44 pt-2 vl-600 8/4/20 0.98 0.55 0.41 pt-3 vl-700 4/4/20 0.94 0.3 0.32 pt-3 vl-800 6/4/20 0.8 0.77 0.21 pt-3 vl-900 8/4/20 0.88 0.88 0.22 pt-3 vl-1000 10/4/20 0.87 0.66 0.11

"CellCulture_005.xls" attached to page "Step 5: Collect Experimental Metadata"

Sheet1 SpecimenID ParticipantID Date CultureDay TotalCellCount Media S-001 PT-101 05/17/19 1 127 Media A S-002 PT-101 05/18/19 2 258 Media A S-003 PT-101 05/19/19 3 428 Media A S-004 PT-101 05/20/19 4 638 Media A S-005 PT-101 05/21/19 5 885 Media A S-006 PT-101 05/22/19 6 1279 Media A S-007 PT-101 05/23/19 7 2004 Media A S-008 PT-101 05/24/19 8 3158 Media A S-009 PT-101 05/25/19 9 4202 Media...

"CellCulture_001.xls" attached to page "Step 1: Assay Tutorial Setup"

Sheet1 SpecimenID ParticipantID Date CultureDay TotalCellCount Media S-001 PT-101 05/17/19 1 127 Media A S-002 PT-101 05/18/19 2 258 Media A S-003 PT-101 05/19/19 3 428 Media A S-004 PT-101 05/20/19 4 638 Media A S-005 PT-101 05/21/19 5 885 Media A S-006 PT-101 05/22/19 6 1279 Media A S-007 PT-101 05/23/19 7 2004 Media A S-008 PT-101 05/24/19 8 3158 Media A S-009 PT-101 05/25/19 9 4202 Media...

"CellCulture_baddata.xls" attached to page "Tutorial: Assay Data Validation"

Sheet1 SpecimenID ParticipantID Date CultureDay TotalCellCount Media S-011 PT-101 05/17/19 -2 93 Media B S-012 PT-101 05/18/19 2 198 Media B S-013 PT-101 05/19/19 3 332 Media B S-014 PT-101 05/20/19 4 484 Media B S-015 PT-101 05/21/19 5 693 Media B S-016 PT-101 05/22/19 6 904 Media B S-017 PT-101 05/23/19 7 1527 Media B S-018 PT-101 05/24/19 8 2330 Media B S-019 PT-101 05/25/19 9 2815 Media...

"CellCulture_006.xls" attached to page "Step 5: Collect Experimental Metadata"

Sheet1 SpecimenID ParticipantID Date CultureDay TotalCellCount Media S-011 PT-101 05/17/19 1 93 Media B S-012 PT-101 05/18/19 2 198 Media B S-013 PT-101 05/19/19 3 332 Media B S-014 PT-101 05/20/19 4 484 Media B S-015 PT-101 05/21/19 5 693 Media B S-016 PT-101 05/22/19 6 904 Media B S-017 PT-101 05/23/19 7 1527 Media B S-018 PT-101 05/24/19 8 2330 Media B S-019 PT-101 05/25/19 9 2815 Media...

"CellCulture_002.xls" attached to page "Step 1: Assay Tutorial Setup"

Sheet1 SpecimenID ParticipantID Date CultureDay TotalCellCount Media S-011 PT-101 05/17/19 1 93 Media B S-012 PT-101 05/18/19 2 198 Media B S-013 PT-101 05/19/19 3 332 Media B S-014 PT-101 05/20/19 4 484 Media B S-015 PT-101 05/21/19 5 693 Media B S-016 PT-101 05/22/19 6 904 Media B S-017 PT-101 05/23/19 7 1527 Media B S-018 PT-101 05/24/19 8 2330 Media B S-019 PT-101 05/25/19 9 2815 Media...

"CellCulture_004.xls" attached to page "Step 1: Assay Tutorial Setup"

Sheet1 SpecimenID ParticipantID Date CultureDay TotalCellCount Media S-031 PT-102 05/17/19 1 99 Media B S-032 PT-102 05/18/19 2 198 Media B S-033 PT-102 05/19/19 3 345 Media B S-034 PT-102 05/20/19 4 485 Media B S-035 PT-102 05/21/19 5 664 Media B S-036 PT-102 05/22/19 6 982 Media B S-037 PT-102 05/23/19 7 1548 Media B S-038 PT-102 05/24/19 8 2393 Media B S-039 PT-102 05/25/19 9 2821 Media...

"CellCulture_003.xls" attached to page "Step 1: Assay Tutorial Setup"

Sheet1 SpecimenID ParticipantID Date CultureDay TotalCellCount Media S-021 PT-102 05/17/19 1 99 Media B S-022 PT-102 05/18/19 2 198 Media B S-023 PT-102 05/19/19 3 345 Media B S-024 PT-102 05/20/19 4 485 Media B S-025 PT-102 05/21/19 5 664 Media B S-026 PT-102 05/22/19 6 982 Media B S-027 PT-102 05/23/19 7 1548 Media B S-028 PT-102 05/24/19 8 2393 Media B S-029 PT-102 05/25/19 9 2821 Media...

"PepcPipeline.log" attached to message "Runtime error when queueing pipelinejob"

12 Sep 2008 10:06:27,512 ERROR: Failed to set status to 'WAITING' for 'PepcPipeline.status'. com.thoughtworks.xstream.converters.reflection.ObjectAccessException: Could not get field class java.lang.reflect.Field.name : Can not set java.lang.String field org.apache.commons.logging.impl.Log4JLogger.name to org.apache.commons.logging.impl.Log4JLogger at com.thoughtworks.xstream.converters.reflection.PureJavaReflectionProvider.visitSerializableFields(PureJavaReflectionProvider.java:111)...