Removing Auto Report .csv Headers

Follow

Mark Guest

• September 20, 2016 15:43

Hi guys,

Love PDQ Inventory! Awesome program!

I'd like to know if there is any way you can remove the report headers from a csv auto-report though?

If you schedule an auto-report to save as .csv then the first two lines are time-stamped with the report name and the date/time it was run, then the actual column headers are on the third line:

Is there any way to omit these first two lines? Otherwise we are required to manually edit the file and delete them before importing the .csv into any other programs? (Not a big problem but we're looking to fully automate our systems as much as possible!)

 

Many Thanks

 

Mark

0

• 

  Wess Frederick

  • June 26, 2017 12:59

  Did you ever get the headers removed?  We also need the headers and footers removed.

  0

  Comment actions Permalink
• 

  Stephen Valdinger

  • June 26, 2017 13:01

  If you are using a scheduled auto report, you could probably have a scheduled task run a powershell step right after to Import-CSV the CSV file, remove the data you need omitted, and then Export-CSV afterwards.

  0

  Comment actions Permalink
• 

  Wess Frederick

  • June 27, 2017 17:25

  Yes that's what we figured out, mostly the vendor I am working with as PS is not my strong suite lol.

  Thanks for replying.

  0

  Comment actions Permalink
• 

  GrantG

  • June 27, 2017 19:04

  More +n originalfilename.csv > outputfilename.csv

  In this case, n=2

  0

  Comment actions Permalink
• 

  Mark Guest

  • June 28, 2017 08:14

  Yeah we also had to run powershell scripts to automate removal of the header lines.

  It's not a major problem but it would be a nice feature if PDQ could remove them as it's just another step in the process that could be removed to simplify the procedure.

  0

  Comment actions Permalink
• 

  Colby Bouma

  • June 29, 2017 15:25

  We have a feature planned that will probably fix this. I have no ETA on when it could be implemented. I talked to our developers and they said this probably can't be fixed until the feature is done.

  0

  Comment actions Permalink

Please sign in to leave a comment.