Skip to main content
Question

Fixing iOS icons in Self Service

  • September 29, 2015
  • 3 replies
  • 32 views
G
Forum|alt.badge.img+7

If anyone had issues recently where icons didn't make it into your app catalog when you added them from VPP, here's a MySQL query that will fix all the broken icon images in Self Service:

UPDATE `mobile_device_apps`
INNER JOIN `vpp_mobile_device_app_license_app` ON `mobile_device_apps`.`itunes_id` = `vpp_mobile_device_app_license_app`.`adam_id`
SET `mobile_device_apps`.`icon_attachment_id` = `vpp_mobile_device_app_license_app`.`icon_id`
WHERE `mobile_device_apps`.`icon_attachment_id` = -1;

    3 replies

    E
    Forum|alt.badge.img+21
    • Emmert
    • Valued Contributor
    • September 29, 2015

    You double posted, but thank you, this is fantastic!

    J
    Forum|alt.badge.img+1
    • jss5215
    • New Contributor
    • March 27, 2018

    Hi,

    I was just wondering if this process needs to be done after the icon was manually uploaded, or if this process should fetch the icons from iTunes?

    We tested one that we manually uploaded, and this seemed to refresh it on Self Service and the icon is there now. However we have far too many apps with no icons to manually upload each.

    Thanks.

    G
    Forum|alt.badge.img+7
    • GSSRyan
    • Author
    • Contributor
    • March 28, 2018

    @jss5215 This was actually to remedy an issue when the auto-VPP-to-catalog feature was first added to JSS. What you’re looking for wouldn’t be difficult using the iTunes api, however. I can help you out once I’m at my computer.

    Terms & ConditionsCookie settingsAccessibility statement