UI Data Export Guide

Background

The purpose of this document is to provide an overview of where end users may perform a data export (as a .csv file that is stored on the requesting user’s local machine) in SORMAS.  The focus is exclusively on the front-end/user interface of the application and does not include exports that may be conducted through an Application Programming Interface (API) or external application that accesses the database directly.  The necessary user rights to perform the associated export are also listed at the respective section.

Dashboard

To access the exports on the Dashboard:

  1. Dashboard > Surveillance > Epidemiological Curve >

Print Chart, Download PNG image, Download JPEG image, Download PDF document, Download SVG Vector Image, Download CSV, Download XLS

  1. Dashboard > Contacts > Follow-up Status Chart >

Print Chart, Download PNG image, Download JPEG image, Download PDF document, Download SVG Vector Image, Download CSV, Download XLS

  1. Dashboard > Samples > Final Laboratory Results Chart >

Print Chart, Download PNG image, Download JPEG image, Download PDF document, Download SVG Vector Image, Download CSV, Download XLS

No personal data is included in these exports – only aggregated graph data is exported in the provided formats.

Use rights needed:
Dashboard | Access the surveillance supervisor dashboard, Access the contact supervisor dashboard, Access the samples dashboard.

 


Tasks

To access the exports on the Tasks directory:

Tasks > Export > Basic Export, Detailed Export, Custom Export

Data available for export (full access):

image-20240618-075542.png

User rights needed:

Tasks | View existing tasks, Export tasks from SORMAS

 


Persons

To access the exports on the Persons directory:

Persons > Export > Basic Export, Detailed Export, Custom Export

Data available for export (full access):

image-20240618-075609.png

User rights needed:

Persons | View existing persons, Export persons

 


Cases

To access the exports on the Cases directory:

Cases > Export > Basic Export, Detailed Export, Case Management Export, Sample Export, Custom Case Export

Data available for export (full access):

User rights needed:

Case Surveillance | View Existing Cases, View Existing Persons, Export cases from SORMAS.

 


Contacts

To access the exports on the Contacts directory:

Contacts > Export > Basic Export, Detailed Export, Follow.up Export, Custom Contacts Export

Data available for export (full access):

 

User rights needed:

Contact Surveillance | View Existing Cases, View Existing Contacts, View Existing Persons, Export contacts from SORMAS.

 


Events

To access the exports on the Events directory:

Events > Export > Basic Export, Detailed Export

Data available for export (full access):

·        Uuid

·        ExternalId

·        EventStatus

·        EventManagementStatus

·        EventIdentificationSource

·        RiskLevel

·        SpecificRisk

·        EventInvestigationStatus

·        EventInvestigationStartDate

·        EventInvestigationEndDate

·        Disease

·        DiseaseDetails

·        DiseaseVariant

·        DiseaseVariantDetails

·        StartDate

·        EndDate

·        EvolutionDate

·        EvolutionComment

·        EventTitle

·        EventDesc

·        latestEventGroup

·        EventGroupCount

·        DiseaseTransmissionMode

·        Nosocomial

·        TransregionalOutbreak

·        MeansOfTransport

·        EventLocation.region

·        EventLocation.district

·        EventLocation.community

·        EventLocation.city

·        EventLocation.street

·        EventLocation.houseNumber

·        EventLocation.additionalInformation

·        srcType

·        srcInstitutionalPartnerType

·        srcFirstName

·        srcLastName

·        srcTelNo

·        srcEmail

·        SrcMediaWebsite

·        srcMediaName

·        srcMediaDetails

·        ReportDateTime

·        ReportingUse

·        ResponsibleUse

·        ParticipantCount

·        CaseCount

·        DeathCount

·        ContactCount

·        ContactCountSourceInEvent

·        ExternalToken

·        internalToken

User rights needed:

Events | Export events from SORMAS, View existing users.

 


Samples

To access the exports on the Samples directory:

Samples > Export > Basic Export, Detailed Export

Data available for export (full access):

·        Id

·        Uuid

·        LabSampleID

·        EpidNumber

·        FirstName

·        LastName

·        Disease

·        CaseResponsibleRegion

·        CaseResponsibleDistrict

·        CaseResponsibleCommunity

·        SampleDateTime

·        SampleMaterialString

·        SamplePurpose

·        SampleSource

·        SamplingReason

·        SamplingReasonDetails

·        Lab

·        PathogenTestResult

·        PathogenTestingRequested

·        RequestedPathogenTests

·        RequestedOtherPathogenTests

·        AdditionalTestingRequested

·        RequestedAdditionalTests

·        RequestedOtherAdditionalTests

·        Shipped

·        ShipmentDate

·        ShipmentDetails

·        Received

·        ReceivedDate

·        SpecimenCondition

·        NoTestPossibleReason

·        Comment

·        ReferredToUuid

·        PersonAddressCaption

·        PersonAge

·        PersonSex

·        CaseUuid

·        CaseReportDate

·        CaseClassification

·        CaseOutcome

·        CaseRegion

·        CaseDistrict

·        CaseCommunity

·        CaseFacility

·        ContactUuid

·        ContactReportDate

·        LastContactDate

·        ContactClassification

·        ContactStatus

·        ContactRegion

·        ContactDistrict

·        ContactCommunity

·        pathogenTestType1     pathogenTestDisease1 pathogenTestDateTime1               pathogenTestLab1        pathogenTestResult1   pathogenTestVerified1

·        pathogenTestType2     pathogenTestDisease2 pathogenTestDateTime2               pathogenTestLab2        pathogenTestResult2   pathogenTestVerified2

·        pathogenTestType3     pathogenTestDisease3 pathogenTestDateTime3               pathogenTestLab3        pathogenTestResult3   pathogenTestVerified3

·        OtherPathogenTestsDetails

·        additionalTest.testDateTime

·        AdditionalTest.haemoglobinuria

·        AdditionalTest.proteinuria

·        AdditionalTest.hematuria

·        AdditionalTest.arterialVenousGasPH

·        AdditionalTest.arterialVenousGasPco2

·        AdditionalTest.arterialVenousGasPao2

·        AdditionalTest.arterialVenousGasHco3

·        AdditionalTest.gasOxygenTherapy

·        AdditionalTest.altSgpt

·        AdditionalTest.astSgot

·        AdditionalTest.creatinine

·        AdditionalTest.potassium

·        AdditionalTest.urea

·        AdditionalTest.haemoglobin

·        AdditionalTest.totalBilirubin

·        AdditionalTest.conjBilirubin

·        AdditionalTest.wbcCount

·        AdditionalTest.platelets

·        AdditionalTest.prothrombinTime

·        AdditionalTest.otherTestResults

·        OtherAdditionalTestsDetails

·        sampleReportDate

User rights needed:

Samples | Export samples from SORMAS, View existing samples.

 


Statistics

To access the exports on the Statistics page:

Statistics > Database Export

Data available for export (full access):

User rights needed:

Statistics | Export detailed statistics from SORMAS, Access statistics.
Export | Export the whole database, Export data protection data.

 


Users

To access the exports on the Users directory:

Users > User Roles > Export User Roles

 

Data available for export (full access):

User role, Jurisdiction level, Description, Uuid

 

User rights needed:

Users | View existing users, View existing user roles.