Nic0la asked a question.
Update image for Catalog items
I want to update images for 100+ of my App Portal catalog items. Can I upload all the .png files to C:\Program Files (x86)\Flexera Software\App Portal\Web\Backgrounds\Packages
Then run the following SQL update:
update WD_WebPackages
set ImagePath = 'pgFileName.png'
where PackageID =123
***the packageID would be changed for each item I want to target.
Is that safe enough? I don’t want to have to do this manually and I don’t fancy using the API either as I think I need ‘icon as a Base64’ value.
Thanks in advance
Yes, if you're setting them all to the same icon, then you can do that with a single SQL statement as you've described. You could adjust it to the following...
If you are setting a different icon for each, you could do something similar using PowerShell with a loop that reads the packageID and filename for each one, or you could make sure the file names are correlated to the individual catalog items in some way (e.g. "<packageid>.png" or "<catalog title>.png" and then you could still do this in SQL by concatenating the appropriate column with ".png".