Extracting Images from Spreadsheet File

Extracting Images from Spreadsheet File, Fidel

Extracting Images from Spreadsheet File

To view image reports from spreadsheet and need to display on ServiceNow UI to client its using java program on MID server and extracted images.

Problem

Some reports data is inputted into ServiceNow as Images in spreadsheet file and need to display on ServiceNow UI to client.
The problem was that data source of ServiceNow can read only textual data and ignores multimedia files data like images.

Solution

ServiceNow does not have inbuilt solution for extracting images from Spreadsheet file. So we have implemented it using java program on MID server and extracted images from the java program on MID server. Whenever email with spreadsheet containing images is received in ServiceNow inbox, it get processed and sent command to MID server to extract the images. The java program on MID server program extracts the image files from provided spreadsheet and send back to ServiceNow. We use this images in UI page to display reports.

Results

Client can see his reports in the ServiceNow when it was not possible to view image reports from spreadsheet using standard approach to import data.

If anyone facing the same issue, please reach us. We are open to support.
Reach us at salesfidel@fideltech.com