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.
To upload one image at a time, complete the following steps:
Navigate to System UI > Images to see the list of images stored in the database.
Click New to add a new image.
Complete the form.
Images form
Field
Input
Name
Enter the file name by which to reference the image in HTML.
Active
Select the check box to allow the image to be referenced in HTML.
Category
Select a category in which to organize the image file.
Image
Select 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.
Format, Size bytes, Height, and Width
View current image metadata. This information is automatically populated when the image is uploaded.
Upload image
To upload multiple images at once, complete the following steps:
Note: The system does not support uploading zip files that contain .bmp images.
Navigate to System UI > Image Zip Upload.
Click Choose File then select the file.
Click 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 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!
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: