Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

PDQ Inventory Reports to CSV

Since I upgraded to Inventory 13.  Reports sent to a CSV file are wrapping.  Rows show up on multiple lines in Excel and Notepad.

Example (* are the CRLF):

PDQ NA Machine Specs,,,,,,,*
,,,,,7/3/2017 9:12:28 AM,,*
Computer,Domain,,Processor,Count,Cores,,Speed (MHz)*
Computer Memory,Computer O/S Name,,Computer O/S Architecture,Computer IP Address,Computer BIOS Manufacturer,,Computer Current User*
Computer Serial Number,Computer IE Version,,Logical Disk Device,Logical Disk Size GB,Logical Disk Free Space GB,,Logical Disk Free %*
Computer Chassis,,Computer Model,,Computer AD Description,,Computer Description,*
L5119,pdq.com,,Intel Core i5-5300U CPU @ 2.30GHz,1,4,,2301*
4 GB,Microsoft Windows 7 Professional,,64-bit,10.244.84.26,,,HappyPlace\JustJack*
,11.0.9600.18697,,C:,454,393,,86*
Unknown,,,,Jack Johnson,,,*

 

0

Comments

3 comments
Date Votes
  • These are Auto reports, scheduled to run weekly.  If I run the report and click "Save Data to File" it saves properly.

     

    0
  • Nice catch! I will submit a bug ticket for this.

    0
  • This has been fixed in the next release of Inventory.

    0