Users can upload their own logos or icons for a relation (company or person) within the software.
We’ve tried to visualize these social media icons and logos in the maps component HTML pop-up template. The icons are retrieved in an underlying view based on the data in the table ‘relation’ and added as an url to the HTML body of the pop-up.
Unfortunately uploaded icons are not shown via the Windows GUI with Indicium. Also because the icons are uploaded to a fileshare where only the application pool user has read/write rights.
It would be nice if uploaded logos/icons could be viewed within the Maps HTML pop-up template.
Hi K.Bakkenes,
Would it be an option to store the images in the database, so you can include the Base64 image data in the HTML?
For example by using an expression column as the HTML Popup Column of the maps component, with a SQL expression like this:
Hi Jasper,
thank you for your suggestion. I tested it and everything seems to work fine. The logo is shown in the HTML pop-up template of the Maps component and is also visible in a form.|
Hi Jasper,
we've already applied the solution to an image upload domain but we also like to change multiple existing filesystem uploads to database storage.
Does the SF automatically convert filesystem files to a database storage varbinary field?
If not, is there an easy way to do this? I’m assuming that Thinkwise (PI) also applied a method to convert every SF image to database storage in the transition to SF 2020.2.
Hi K.,
For the SF and IAM we have added (dynamically generated) process flows to upload files into the database, using recursive Read file connectors.
The process flow looks like this:
The file content is saved to the database using the process flow procedure of the Read file actions and looks like this:
This code recursively retrieves the first row from the specified table (tab) that contains a full path (backslash) in the icon name, reads the file and the saves the data into the icons data field.
I have also attached the dynamic model code to generate the Read file actions and the control procedure + template to generate the process flow procedures. You’ll have to create the process flow and add the other steps and required process variables by hand first.
Hi Jasper,
I've recreated the process flow in my branch. With a few tweaks the process flow (and procedure) worked like a charm.
Thanks for the help!
Kevin