Loading
CSV License Import - Problem with Organization and Purchase Price
Hi @ll, We are in the process of automating our license ordering process using the Snow Automation Platform. To cut a long story short: Someone makes a request about a certain number of license entitlement, then this request goes through the corresponding approval steps and at the end a CSV should be generated and imported into the SLM. No rocket science Up to the creation of the CSV everything works fine, only when importing into the SLM I have my problems. The csv looks like this: "ApplicationName","AssignmentType","LegalOrganisation","ApplicationMetric","PurchaseCurrency","PurchaseDate","PurchasePrice","Quantity","ProductDescription"   "WinZip 15.0","Organisation","ROOT,DE","Installations","EUR","2019-03-10","30.00","5","Re-Nr - 12345 - Projektbeistellung TE"   ‍‍‍ ‍ ‍ The first problem I have is the assignment of the organizational units. Based on "SLM9_UG_DataImportFieldDescription.pdf", I used "Comma" as delimiter and tried to import the data Our org structure in SMACC But the WebUI importer doens't recognize the delimiter Chaging the org delimiter to "," in my user settings also doens't help. Changing the delimiter to any other char, still the same error The second problem I have is a differenc price based on SLM language settings   CSV purchase price valie is : "30.00" - default powershell output from Snow AP Snow SLM language user setting ENG/US (currency USD) - price value is 30.00 Snow SLM language user setting GER/DE (currency EUR) - price value is 3000 thanks for your support and helpful replies Best, Dennis

  • Hi @ll, Question solved: the organisational unit must be checked as "is legal" to be available for the license import. Best, Dennis
  • Hello Dennis, When importing purchase price i had issues especially dealing with imports with more than one currency, the solution is in the Purchase price column of the csv to be imported (or any reference to amount) i had to enter it as "1000 GBP" or "100000.00 USD"   Hope you get data imported  Regards Ben
  • Community Manager (Flexera Software)

    Hi Dennis, I would recommend double checking the organisation name against what is displayed in the "organisational overview" report available inside the Snow License Manager web interface. That report contains your organisation structure as well as a column called "Organisation ID" which you can bring in from the column selector.  Validate that the organization you are trying to import the purchase against is the same as the value displayed in the "Organisation ID" column in that report. Hope this helps! Regards, Erik
    Expand Post
    • Hi ‌ still same value I already used. Should I open a ticket or is there any other option to fix it Best, Dennis

Loading
CSV License Import - Problem with Organization and Purchase Price