search

fhosking / cml-database

0 stars 0 forks source link

Baseline: Missing data import #5

Closed fhosking closed 6 months ago

fhosking commented 6 months ago

<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">

Frontend label | Access Variable Label | Access Variable Name | REDCap variable name | Issue | AK comments -- | -- | -- | -- | -- | -- Haematological data / BaselineData |   |   Haematological data available | Haematological data available | HaematologicalDataAvailable | hae_haematologicaldataavailable |   |   Date Of Lab Analysis | DateOfLabAnalysis | DateOfLabAnalysis | hae_dateoflabanalysis |   | No data transfer in REDCap Haemoglobin (g/dl) | Haemoglobin | Haemoglobin | hae_haemoglobin |   | No data transfer in REDCap % Haematocrit | Haematocrit | Haematocrit | hae_haematocrit |   | No data transfer in REDCap WBC | WBC | WBC | hae_wbc |   | No data transfer in REDCap Platelets | Platelets | Platelets | hae_platelets |   | No data transfer in REDCap MCV | MCV | MCV | hae_mcv |   | No data transfer in REDCap RDW | RDW | RDW | hae_rdw |   | No data transfer in REDCap MPV | MPV | MPV | hae_mpv |   | No data transfer in REDCap Neutrophils | Neutrophils | Neutrophils | hae_neutrophils |   | No data transfer in REDCap % Neutrophils | % Neutrophils | % Neutrophils | hae_perc_neutrophils |   | No data transfer in REDCap Lymphocytes | Lymphocytes | Lymphocytes | hae_lymphocytes |   | No data transfer in REDCap % Lymphocytes | % Lymphocytes | % Lymphocytes | hae_perc_lymphocytes |   | No data transfer in REDCap Monocytes | Monocytes | Monocytes | hae_monocytes |   | No data transfer in REDCap % Monocytes | % Monocytes | % Monocytes | hae_perc_monocytes |   | No data transfer in REDCap Blast | Blast Abs | Blast | hae_blast_abs | Correct? Switched | No data transfer in REDCap. Blast Abs % PB Blasts | BlastsInPeripheralBlood | % PB Blasts | hae_blastsinperipheralblood | Correct? Switched | No data transfer in REDCap Basophils | % Basophils | Basophils | hae_basophils |   | No data transfer in REDCap % Basophils | % Basophils | % Basophils | hae_percbasophils |   | No data transfer in REDCap. There are three % Basophils columns in baseline accdb and this is the 2nd column nexyt to Basophils Abs column. Not sure what the 1st column is for. Eosinophils | Eosinophils | Eosinophils | hae_eosinophils |   | No data transfer in REDCap % Eosinophils | Eosinophils Abs | % Eosinophils | hae_eosinophils_abs |   | No data transfer in REDCap Promyelocytes | Promyelocytes | Promyelocytes | hae_promyelocytes |   | No data transfer in REDCap % Promyelocytes | % Promyelocytes | % Promyelocytes | hae_perc_promyelocytes |   | No data transfer in REDCap Metamyelocytes | Metamyelocytes | Metamyelocytes | hae_metamyelocytes |   | No data transfer in REDCap % Metamyelocytes | % Metamyelocytes | % Metamyelocytes | hae_perc_metamyelocytes |   | No data transfer in REDCap Myelocytes | Myelocytes | Myelocytes | hae_myelocytes |   | No data transfer in REDCap % Myelocytes | % Myelocytes | % Myelocytes | hae_perc_myelocytes |   | No data transfer in REDCap Phase of disease at diagnosis | PhaseOfDiseaseAtDiagnosis | PhaseOfDiseaseAtDiagnosis | hae_phaseofdiseaseatdiagnosis |   | No data transfer in REDCap Sokal Score | SokalScore | SokalScore | hae_sokalscore |   | No data transfer in REDCap Sokal score manual | SokalScoreManualID | SokalScoreManualID | hae_sokalscoremanualid |   | No data transfer in REDCap Euro Score | EuroScore | EuroScore | hae_euroscore |   | No data transfer in REDCap Diagnosis availability | Diagnosis availability | Diagnosis availability | hae_diagnosis_availability |   | No data transfer in REDCap. Three options missing (Available, Data not available-diagnosis elsewhere, old diagnosis) Diagnosis query | DiagnosisQuery | DiagnosisQuery | hae_diagnosisquery |   | No data transfer in REDCap Sokal query | SokalQuery | SokalQuery | hae_sokalquery |   | No data transfer in REDCap

No data transfer in REDCap

fhosking commented 6 months ago
image

The data import was prepared but the test import never completed. The data has now been uploaded.