CONTACT US

568-3-53 (3rd Floor) Kompleks Mutiara 3 1/2 Mile, Jalan Ipoh 51200 Kuala Lumpur, Malaysia 6012-9714904 support@yohz.com https://www.yohz.com https://www.dicomsearch.com https://yohzapps.yohz.com
Copyright © 2005 - 2020 Yohz Software, a division of Yohz Ventures Sdn Bhd. ALL RIGHTS RESERVED. All trademarks or registered trademarks are property of their respective owners

4.0 Exporting

We’ve indexed our images, perform searches on them and displayed the search results. In this section, we will see how we can export our search results. What exactly can we export in DICOM Search?

4.1

Images from the search results

When DICOM Search has returned your search results, you can copy the source images to another folder for later use. For e.g. you have a collection of 10000 DICOM images. You then search for MR knee images for female patients aged between 50 and 55. Say DICOM Search returns 50 rows. You can then choose to copy those 50 images from your collection to another folder, so that you can analyze these 50 images of interest using your DICOM viewer. To copy the search results images, click on the Copy images button on the Data set page. This brings up the Copy Images window. Enter the folder to copy the images to, and click on the Start button. DICOM Search will then copy the images to the folder you selected, using the options you entered.

4.2

Exporting tabular results to Excel

You can export the results returned in tabular format to Excel spreadsheets, which looks something like this: The Excel spreadheet will contain the columns as the tabular layout, and also links to the source image files. In Excel, you can click on these links to open the image file in your DICOM viewer. To start off, let’s run this search query: modality = 'MR' You should see 24 rows listed in the results. Click on the Export all data button, then select the Export to Excel option. This opens the Export to Excel Workbook window. You can use most of the default values, and we will only discuss the more important options. On the Excel Workbook Properties page, enter the name of the Excel file we want to create. The rest of the settings determine how the worksheet is formatted. The Image and File Options page lets you choose how you want to display and copy your images. There are 3 options as to how you can display the images: displaying the images in the spreadsheet only displaying the images as a link in the spreadsheet displaying the images in the spreadsheet and as a link For the last 2 options, the DICOM image files will be copied into an images subfolder. Clicking on the link will then open the copied image in your registered DICOM viewer. In this way, if you wanted to share the spreadsheet, you can just copy the Excel file together with the images subfolder. Your peers can then still open the DICOM images easily.

4.3

Exporting image thumbnails and tags to Excel

The search results will be displayed in tabular form this way in Excel: Each row represents a different DICOM tag, and each column represents a different image from your search results. To start the export process, click on either of the 2 export buttons when in the patient/study/series format. If you click on the export button in the File browser, all the images will be exported. If you click on the export button in the Tag viewer, then only the images that are currently displayed will be exported. The Export to Excel window contains the various options you can customize. The option to display file links determine if this row is displayed in your Excel worksheet. If you choose to display the links, you can then choose what type of link to display. If we choose the source image files option, then the links will link to the source images. If we choose the copied image files option, DICOM Search will copy the image files to a subfolder beneath the folder where our Excel file is stored, and the links will link to those copied files. Let’s try this. Click on the Export tags to Excel button on the File browser toolbar. In the options, enter a name for our Excel file, and choose the source image files option. In this example, we will be create an Excel file named tags.xlsx in the f:\export\ folder, and our images will be stored in the images subfolder. Proceed with the export. Once completed, we can see our Excel file in the folder, with the created images subfolder. We will also find the copies imags in the images subfolder. In our Excel file, the links link to the copied image files, and not to the source image files. Thus, if you wanted to share your Excel file with your images, you just have to copy the Excel file together with the images subfolder.

CONTACT US

568-3-53 (3rd Floor) Kompleks Mutiara 3 1/2 Mile, Jalan Ipoh 51200 Kuala Lumpur, Malaysia 6012-9714904 support@yohz.com https://www.yohz.com https://www.dicomsearch.com https://yohzapps.yohz.com
Copyright © 2005 - 2020 Yohz Software, a division of Yohz Ventures Sdn Bhd. ALL RIGHTS RESERVED. All trademarks or registered trademarks are property of their respective owners

4.0 Exporting

We’ve indexed our images, perform searches on them and displayed the search results. In this section, we will see how we can export our search results. What exactly can we export in DICOM Search?

4.1

Images from the search results

When DICOM Search has returned your search results, you can copy the source images to another folder for later use. For e.g. you have a collection of 10000 DICOM images. You then search for MR knee images for female patients aged between 50 and 55. Say DICOM Search returns 50 rows. You can then choose to copy those 50 images from your collection to another folder, so that you can analyze these 50 images of interest using your DICOM viewer. To copy the search results images, click on the Copy images button on the Data set page. This brings up the Copy Images window. Enter the folder to copy the images to, and click on the Start button. DICOM Search will then copy the images to the folder you selected, using the options you entered.

4.2

Exporting tabular results to Excel

You can export the results returned in tabular format to Excel spreadsheets, which looks something like this: The Excel spreadheet will contain the columns as the tabular layout, and also links to the source image files. In Excel, you can click on these links to open the image file in your DICOM viewer. To start off, let’s run this search query: modality = 'MR' You should see 24 rows listed in the results. Click on the Export all data button, then select the Export to Excel option. This opens the Export to Excel Workbook window. You can use most of the default values, and we will only discuss the more important options. On the Excel Workbook Properties page, enter the name of the Excel file we want to create. The rest of the settings determine how the worksheet is formatted. The Image and File Options page lets you choose how you want to display and copy your images. There are 3 options as to how you can display the images: displaying the images in the spreadsheet only displaying the images as a link in the spreadsheet displaying the images in the spreadsheet and as a link For the last 2 options, the DICOM image files will be copied into an images subfolder. Clicking on the link will then open the copied image in your registered DICOM viewer. In this way, if you wanted to share the spreadsheet, you can just copy the Excel file together with the images subfolder. Your peers can then still open the DICOM images easily.

4.3

Exporting image thumbnails and tags

to Excel

The search results will be displayed in tabular form this way in Excel: Each row represents a different DICOM tag, and each column represents a different image from your search results. To start the export process, click on either of the 2 export buttons when in the patient/study/series format. If you click on the export button in the File browser, all the images will be exported. If you click on the export button in the Tag viewer, then only the images that are currently displayed will be exported. The Export to Excel window contains the various options you can customize. The option to display file links determine if this row is displayed in your Excel worksheet. If you choose to display the links, you can then choose what type of link to display. If we choose the source image files option, then the links will link to the source images. If we choose the copied image files option, DICOM Search will copy the image files to a subfolder beneath the folder where our Excel file is stored, and the links will link to those copied files. Let’s try this. Click on the Export tags to Excel button on the File browser toolbar. In the options, enter a name for our Excel file, and choose the source image files option. In this example, we will be create an Excel file named tags.xlsx in the f:\export\ folder, and our images will be stored in the images subfolder. Proceed with the export. Once completed, we can see our Excel file in the folder, with the created images subfolder. We will also find the copies imags in the images subfolder. In our Excel file, the links link to the copied image files, and not to the source image files. Thus, if you wanted to share your Excel file with your images, you just have to copy the Excel file together with the images subfolder.