Automatically Retrieve Dell Warranty Info and Import it into PDQ Inventory Custom Fields

Comments

12 comments

  • Ryan Bell

    Have you ever gotten the error "Unable to save. Please verify the CSV is valid"?

    Thanks,

    Ryan

    1
    Comment actions Permalink
  • Luke Nichols

    Ryan,

    No, I haven't gotten that error. Where are you seeing the error? In the PowerShell console? In the log file?

    1
    Comment actions Permalink
  • Ryan Bell

    Its showing in the PowerShell Console.

     

    1
    Comment actions Permalink
  • Luke Nichols

    Is there a "DellWarrantyData.csv" file in the same directory as the script after running it? That is where the data is written to by default. The file is overwritten on the next run of the script but it is not deleted at the end of the script run. If that file does not exist then your script may be failing to generate it due to a permissions issue or something like that.

    1
    Comment actions Permalink
  • Ryan Bell

    Yep, i'm running it locally, and manually filled in all the Variables and tried to just import the DellWarrantyData.csv file it's self and Its giving the error.  Does it need to be a specific format?

    I've removed the API Keys in the referenced Image.

    1
    Comment actions Permalink
  • Luke Nichols

    Ok. Can you provide a snippet of the CSV file? If you are worried about posting sensitive info on the forum you can censor it.

    Also can you provide a screenshot of your custom fields in PDQ Inventory?

    1
    Comment actions Permalink
  • Ryan Bell

    Using the PDQ Import Wizard in the GUI, I was able to determine the issue was caused by a value already being in one of the custom fields.  This error only happened on subsequent imports, not the initial one.  I added -AllowOverwrite to the end of the command in the script and now it's working fine. 

    1
    Comment actions Permalink
  • Luke Nichols

    Ok thanks for figuring that out. I will modify that in the version on Github.

    1
    Comment actions Permalink
  • Ryan Bell

    Thanks for the prompt responses. 
    Have a Great Day!

    1
    Comment actions Permalink
  • Fareed Taha

    I have been assigned this exact task at my organization.  I have run the KUDellWarrantyChecker.ps1 with no errors. The output DellWarrantyData.CSV does not include any data except for the Computer,Name,Purchase,Date,Warranty,End Date in row 1. I have a PDQ report setup, but it is not an auto-report. Am I missing something? Do I need to add custom fields to PDQ Inventory? Any assistance would be greatly appreciated.

    1
    Comment actions Permalink
  • Luke Nichols

    Fareed,

    Yes, you will need to add two custom fields. I have modified my original post to include a screenshot indicating what the fields should be called and what data type they should be.

    I also added this info to the readme on the github repo.

    1
    Comment actions Permalink
  • Fareed Taha

    Thanks. I posted my updates on GitHub.

    1
    Comment actions Permalink

Please sign in to leave a comment.