Asset Intelligence Third Party Import File with multiple PO# for Same Software Title

Author
Leon_Nick
New Member
  • Total Posts : 1
  • Scores: 0
  • Reward points: 100
  • Joined: 2014/07/31 17:51:00
  • Status: offline
2014/07/31 18:05:05 (permalink)
0

Asset Intelligence Third Party Import File with multiple PO# for Same Software Title

A customer of mine ask me if there is a way to import third-party license information to SCCM 2012 Asset Intelligence that contain multiple POs either from same or different vendors using one line per PO.  I try using the following test input file but if fails.  If I only use a single line it works.
 
Name,Publisher,Version,Language,EffectiveQuantity,PONumber,ResellerName,DateOfPurchase,SupportPurchased,SupportExpirationDate,Comments
Adobe Reader XI (11.0.07)  MUI,Adobe Systems,11,English,3,CS10087281,XYZ,2/1/2013,,,
Adobe Reader XI (11.0.07)  MUI,Adobe Systems,11,English,7,CS10087293,XYZ,6/1/2014,,,
Adobe Reader XI (11.0.07)  MUI,Adobe Systems,11,English,2,CS10087451,RTR,7/1/2014,,
 
The customer wants to track each individual PO for auditing purposes.  It appears the error in importing the file is due to the Name field having to be unique.  One approach might be to manually totaling the licenses for a given title and adding the POs info to the comment field.  Issue with this is the administrative overhead and limiting ability to track the individual PO/license info such as Reseller Name, Date of Order, ect.  I'm hoping for a workaround or is this a software limitation and they have to look at a third party solution.
 
Thank You in Advance
#1

1 Reply Related Threads

    gjones
    Expert Member
    • Total Posts : 2816
    • Scores: 146
    • Reward points: 248130
    • Joined: 2001/06/05 12:32:00
    • Location: Ottawa, Ontario, Canada
    • Status: offline
    Re:Asset Intelligence Third Party Import File with multiple PO# for Same Software Title 2014/07/31 19:35:16 (permalink)
    #2
    Jump to:
    © 2018 APG vNext Commercial Version 5.5