Loading
Does SNOW have the ability to upload licence prices into existing licence entries? When we started out on SNOW, our partner uploaded a large amount of Licence purchases - unfortunately no costings were added. Can this be done via a bulk upload ?

  • The SLM Import is capable of upgrading existing licenses.

     

    To do so, it requires the License ID that you usually won't see in the WebUI, exxcept in reports.

    As an alternative, Snow allows to use the field "External ID" during import as well, but this is a field you would have to fill yourself.

     

    So what I usually do is:

    • use the standard report "All licenses"
    • make sure "License ID" and "Purchase Price" are in the report
    • export all licenses to Excel
    • add your purchase prices in the Excel sheet
    • you will have to add a column "Purchase Currency" with EUR, GBP, USD or whatever currency you use in SLM
    • re-import the licenses

     

     

    Expand Post
    Selected as Best
  • The SLM Import is capable of upgrading existing licenses.

     

    To do so, it requires the License ID that you usually won't see in the WebUI, exxcept in reports.

    As an alternative, Snow allows to use the field "External ID" during import as well, but this is a field you would have to fill yourself.

     

    So what I usually do is:

    • use the standard report "All licenses"
    • make sure "License ID" and "Purchase Price" are in the report
    • export all licenses to Excel
    • add your purchase prices in the Excel sheet
    • you will have to add a column "Purchase Currency" with EUR, GBP, USD or whatever currency you use in SLM
    • re-import the licenses

     

     

    Expand Post
    Selected as Best
  • Hi Axel, thanks for this, appreciated.

     

    I have followed this process but unfortunately SNOW is unable to map one of the mandatory values for the licence import to a row in the destination database... I will refer this to our SNOW provider.

     

    Thanks again for the speedy response !

    Expand Post
    • Hi Andrew,

       

      can you share the column / value that is not matching?

      Is it the ID or another field?

       

      Regards, Axel

      Expand Post
  • Hi Axel, thanks for this - it is the Legal Organisation field within the Licence import Template - a mandatory field

     

    The error message is as follows:

     

    Unable to map value "NUTH" to a row in the destination database

     

    This is the same Legal Organisation value as our licences.

     

    Andrew

    Expand Post
    • Hi Andrew,

       

      ah ok, there is one little thing you need to know about Organisation:

      The highest node has to be named ROOT regardless what you see in the user interface.

       

      If you want to add it to another node, the value would be like "ROOT,Europe,Italy,IT", so the entire path separated with comma.

      Expand Post
      • Hi Axel, thanks again, I have logged a support call with our SNOW provider for this as I assume they will have the full view of the infrastructure.

         

        Appreciate your assistance here,

         

        Andrew

        Expand Post
      • Hi Axel, managed to get this working now, thanks for your advise. Really appreciated.

         

        Have a great weekend, Andrew

Related  Product Forums


                     → Flexera One



                      → Snow Atlas



                      → FlexNet Manager



                      → Snow License Manager



                       → App Broker


       Need help finding an answer?


        Ask a Question →


Loading
Does SNOW have the ability to upload licence prices into existing licence entries? When we started out on SNOW, our partner uploaded a large amount of Licence purchases - unfortunately no costings were added. Can this be done via a bulk upload ?