How to upload multiple images in Image type field

Vichitra Garg
Mega Expert

Hi All,

 

I have a image type of field in a table.In this table I have around 600 Records. My requirement is to upload images against each record. Is there any way to automate this step?

I have a excel sheet with the data for records that needs to be uploaded along with the links to sharepoint location for images against each record.

6 REPLIES 6

Pratiksha Kalam
Kilo Sage

Hi Vichitra,

  1. To upload one image at a time, complete the following steps:
    1. Navigate to System UI > Images to see the list of images stored in the database.
    2. Click New to add a new image.
    3. Complete the form.
      Images form
      FieldInput
      NameEnter the file name by which to reference the image in HTML.
      ActiveSelect the check box to allow the image to be referenced in HTML.
      CategorySelect a category in which to organize the image file.
      ImageSelect Click to add... to upload an image. If an image is already uploaded, click [Update] to upload a new version of the image or [Delete] to remove the image.
      FormatSize bytesHeight, and WidthView current image metadata. This information is automatically populated when the image is uploaded.
      Upload image
  2. To upload multiple images at once, complete the following steps:
    1. Create a .zip file that contains only acceptable image file types.
      Note: The system does not support uploading zip files that contain .bmp images.
    2. Navigate to System UI > Image Zip Upload.
    3. Click Choose File then select the file.
    4. Click Upload.
      Zip upload
    A message indicates that the files are uploaded to the database, and the images list is sorted by updated date in descending order (the uploaded images appear first).
     
     if you have any problem please refer below link,
     
     
    If my reply helps you at all, I’d really appreciate it if you click the Helpful button and if my reply is the answer you were looking for, it would be awesome if you could click both the Helpful and Accepted Solution buttons! 
     
    Regards,
    Pratiksha

Vichitra Garg
Mega Expert

Hi Pratiksha,

My requirement is not to upload the images in the DB image table.

Please refer to the below screenshots

STEP 1 : I have a image type of field. When I click on it, Step 2 image opensfind_real_file.png

 

STEP 2 : Below image opens

find_real_file.png

 

STEP 3 : After clicking on Choose File below page opens

 

find_real_file.png

 

So only option we have is to select the image from the system.

 

Please suggest if there is any way out.

Hi

Do you need to add a different picture to each record, or are all records getting the same file?

 

BR

Dirk

 

Hi

How ever you go, here are some information for you, that may help you on the way:

Pictures are stored as Attachments in the system, and the picture field that you mention, will hold the sysID of the Attachment of the table [sys_attachment].

So, for bulk allocations, you first need to upload all the needed attachments, and the update the given records with the needed SysID of the attachment in the "Image" field.

 

It is a bit complicated, I think, but it may become possible. I think it depends on the number of images that you need to allocate, for investigating, how to bulk upload images.

If you just need to allocate the same picture to a high number of records, this may become a quite simple loop, where you just need to update your records with the existing sysids of the Attachment records.

 

Also start your journey here, to get more details:

https://community.servicenow.com/community?id=community_question&sys_id=b4e14ba9db98dbc01dcaf3231f96...

 

 

Let me know, if that answered your question and mark my answer as correct and helpful, please.

BR

Dirk