Project

General

Profile

Actions

Feature #2472

closed

FemCare: import patient records

Added by Alexander Watzinger 11 months ago. Updated 7 months ago.

Status:
Closed
Priority:
Normal
Category:
-
Target version:
-
Start date:
2025-02-10
Estimated time:

Description

We took a look at the patient records and thought about how to map the information:

  • Original text
    • Create a source
    • name could be e.g. "Patient record 123"
    • the text as description
  • Nr.
    • we could use and link a reference system but do we need it if the number is already in name and we won't have URLs anyway?
  • Begin, End, diagnosis
    • Create an event (activity)
    • Use begin, end as dates
    • Link to source
    • Name could be e.g. "Patient visit 123" or "Patient visit of (name)"
    • Link diagnosis as type to event
  • Name, age (optional integer), death (boolean)
    • Create a person
    • Link to event and source
    • If age available, create a time span for birth (Eva kindly suggested to add a few years time span to account for uncertainty)
    • If death
      • Add death date to person
      • Add type "outcome: death" to event
To discuss
  • Everything so far agreeable?
  • How to deal with duplicates, e.g. persons or similar spelled diagnoses
  • Do we want to enter origin (Herkunft) as places and link them as residence or birth place?
  • What should we do with "half empty" records, e.g. row 1606 to 1609
  • Maybe we should create a "case study" custom type with a sub type "Patients" or similar (can be renamed later) just to be able to separate them from other data if needed.

Related issues 1 (0 open1 closed)

Related to OpenAtlas - Feature #2486: FemCare: import sisters records ClosedAlexander Watzinger2025-02-19Actions
Actions #1

Updated by Alexander Watzinger 10 months ago

  • Description updated (diff)
Actions #2

Updated by Bernhard Koschiček-Krombholz 10 months ago

  • Status changed from Assigned to In Progress
Actions #3

Updated by Alexander Watzinger 10 months ago

  • Subject changed from Import patient records for FemCare to FemCare: import patient records
  • Description updated (diff)
Actions #4

Updated by Alexander Watzinger 10 months ago

  • Related to Feature #2486: FemCare: import sisters records added
Actions #5

Updated by Bernhard Koschiček-Krombholz 10 months ago

  • Description updated (diff)
Actions #6

Updated by Bernhard Koschiček-Krombholz 10 months ago

  • Status changed from In Progress to Resolved

Finished the import script, that covers all points mentioned above.
Next step should be a meeting with @Felix Alexander Kaufmann to discuss the questions above and show the results.

Actions #7

Updated by Alexander Watzinger 10 months ago

Thanks Bernhard. I also added here a cleanup function at begin.
Because of that it now takes longer but the advantage is that database hasn't to be re-important every time when working with it.

Actions #9

Updated by Bernhard Koschiček-Krombholz 7 months ago

We received the new file and I added the requested changes to the script. It is ready to import now.

Actions #10

Updated by Alexander Watzinger 7 months ago

  • Target version changed from 8.12.0 to 8.15.0
Actions #11

Updated by Bernhard Koschiček-Krombholz 7 months ago

  • Status changed from Resolved to Closed
  • Target version deleted (8.15.0)
Actions

Also available in: Atom PDF