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:
Dashboard > Surveillance > Epidemiological Curve >
Print Chart, Download PNG image, Download JPEG image, Download PDF document, Download SVG Vector Image, Download CSV, Download XLS
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
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):
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):
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.
Â