Mass import from a PACS using a XLSX (Excel) file

A French version of this page is available here.

It is now possible to import multiple datasets at once from a PACS using a configured Excel file. In order to do this, got to Mass Import -> From PACS with Excel

Than you are able to choose the study you want to import to, and to click on the "Open" button to select your Excel file.

The uploads are automatically starting one after the other in the "Import" tab. Once the upload is FINISHED the DICOM files are deleted from the /workfolder to avoid using too much space.

The Excel file must respect the Shanoir format detailed below. You can download the .xlsx template file to have a template to fill.

Here is a listing of all the columns and their use:

• DICOM_QUERY_LEVEL : values can be "STUDY" or "PATIENT" depending on the query. Set it to "STUDY" if you want to query for a specific study with the DICOM_STUDY_DATE and/or DICOM_MODALITY columns. Some pacs do not accept a PATIENT root query with a specified DICOM_MODALITY.
• DICOM_PATIENT_NAME : Patient name as it appears in the pacs (can vary -> less reliable than IPP).
• DICOM_PATIENT_ID : The unique identifier of the patient we want to load data. If the IPP is set, NAME and SURNAME aren't necessary.
• DICOM_PATIENT_BIRTH_DATE : Patient birthdate as it appears in the pacs.
• DICOM_STUDY_DESCRIPTION : Name of the study as it appears in the pacs.
• DICOM_STUDY_DATE : Date of the study as it appears in the pacs. Beware that the value is formatted as text in the excel file to keep the pattern YYYYMMdd. You can set a time window by entering {firstDate}-{lastDate} still respecting the YYYYMMdd pattern for each date.
• DICOM_MODALITY : Modality of the DICOM study you wish to query (e.g MR, CT, XA...).
• FILTER_DICOM_STUDY_DESCRIPTION : Filter to apply at DICOM study level. The list can be separated by ";", and contain "*" (wildcard) and/or "!" (negation).
• FILTER_DICOM_STUDY_MIN_DATE : Minimum date from which the data will be selected. Can be set to 0 in order to select all. Formats accepted : yyyy, yyyy-MM-dd, yyyy-MM-dd-HH
• FILTER_DICOM_SERIES_DESCRIPTION : Filter to apply at DICOM serie level. The list can be separated by ";", and contain "*" (wildcard) and/or "!" (negation).
• VERIFICATION_PATIENT_FIRSTNAME :
• VERIFICATION_PATIENT_LASTNAME :
• VERIFICATION_PATIENT_BIRTHNAME :
• VERIFICATION_PATIENT_BIRTHDATE :
• SHANOIR_STUDY_CARD_NAME : Shanoir study card name that will be used by default if another study card with adapted equipment is not found.
• SHANOIR_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.
• SHANOIR_EXAM_COMMENT : Shanoir examination comment, can be set to null.

Filter examples

!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