member badge
Spencer Vale
On the applications administration screen, a new 'Import applications' button could be added. This would lead to a screen that allowed selecting a CSV. This CSV would be read and parsed, allowing the columns in the document to be mapped to fields of an application - e.g. Application name, Expiry date, etc.
Key features:
  • Map CSV columns to application fields
  • Show how many applications were about to be imported
  • Show whether the names of any applications matched existing apps - to help avoid duplicates
  • Allow the user to deselect apps they no longer wish to import
  • An option to 'apply best match icon', which could search for the icon by application name and apply the first one that matches (which won't always be correct, but should be most of the time, and saves an extra step)
  • MAYBE even show a preview of the icon that would be applied
  • MAYBE even allow a provision to be selected to apply apps to (apply to all, or change individual apps)
  • Before submitting, we can perform a 'dry run', to identify any issues (e.g. they've selected a value for Expiration Action that doesn't exist, or an Expiration Date that's in the past).