Skip to content

[Shanoir uploader] Massive import from PACS using a CSV

Laurent Paul Vallet edited this page Jun 5, 2024 · 2 revisions

Mass import from a PACS using a CSV file

It is now possible to import multiple datasets at once from a PACS using a configured CSV file. In order to do this, got to import -> from a CSV File

image

Then select a CSV file, respecting this format:

  • IPP : The unique identifier of the patient we want to load data. If the IPP is set, NAME and SURNAME aren't necessary
  • Patient name : Patient name as it appears in the pacs (can vary -> less reliable than IPP)
  • Patient surname : Patient surname as it appears in the pacs (can vary -> less reliable than IPP)
  • Study ID : Study ID in Shanoir
  • Studycard Name : Shanoir study card name that will be used by default if another study card with adapted equipment is not found.
  • Subject name : The name of the subject that will be created in Shanoir. it must be unique, and it is pertinent to add the study name.
  • Study filter : Filter to apply at DICOM study level. The list can be separated by ";", and contain "*" (wildcard) and/or "!" (negation).
  • Acquisition filter : Filter to apply at DICOM acquisition level. The list can be separated by ";", and contain "*" (wildcard) and/or "!" (negation).
  • Minimum date : Minimum date from which the data will be selected. Can be set to 0 in order to select all. Format : yyyy-MM-dd
  • Exam comment : Shanoir examination comment, can be set to null.

CSV example:

without IPP :

,,NOM,PRENOM,202,SC_CT_OPTIMA_CT,Test04,!*inj*,Crane sans IV,2017-01-01,comment

With IPP :

123456789,,, ,202,SC_CT_OPTIMA_CT,Test04,!*inj*,Crane sans IV,2017-01-01,commentaire2IPP

Filter example

!Crane => We exclude exactly "Crane"

!*Crane* => We exclude all values containing "Crane"

*Crane;!*Injection* => We include all values finishing by "Crane" and not containing "Injection"

NB : It's not case sensitive

";" means AND

";;" means OR

Clone this wiki locally