Hello - I am trying to import a csv file that is generated by some database administrators and then I have to export the csv as an html email.
I have the email working and the import is OK, but the display is not good. There are a couple issues and I’m hoping someone can help me make this a “nicer” report.
- The csv has the 1st row as an empty row, not sure why as I don’t generate it, that’s done by some old batch files or vb scripts.
- The 2nd row has an entry in the 1st column titled “#Name?” and it appears the csv file believes that’s a formula
- The format of the html email is “ok” but the columns are very tight meaning that the dates in the columns consume all the space and it just isn’t nicely displayed.
Here’s a sample portion of the csv file and then a portion of the html email.
hostname SQLInstance Database_Name Status Start_Time End_Time Backup _Size
Server1 reports sysdba Yes 12/09/2013 23:09 12/09/2013 23:16 3730.31
server2 messedup Yes 12/09/2013 23:16 12/09/2013 23:16 2.08
server3 working powershell Yes 12/09/2013 23:16 12/09/2013 23:18 1091.11