Powershell scipt to conver taxt file to HTML

Question

Powershell scipt to conver taxt file to HTML

Kalaimani Thirupathi 411

Dear All,

I'm not able to convert the PowerShell report/ text file to HTML, getting the only length. can you someone help with this.

example the below one trying to convert to HTML

------------- System Capacity (MiB) -------------
Total Capacity : 937426944
Allocated : 743172096
Legacy Volumes : 0
User : 0
Snapshot : 0
CPGs (VVs) : 671330304
Shared : 69718601
Private : 570563757
Base : 559884471
Reserved : 559884471
Reserved (vSphere vVols) : 0
Snap : 10679286
Reserved : 10679286
Reserved (vSphere vVols) : 0
Free : 31047946
Unmapped : 0
System : 71841792
Internal : 2729984
Admin : 3575808
Spare : 65536000
Used : 0
Unused : 65536000
Free : 194254848
Initialized : 194254848
Uninitialized : 0
Unavailable : 0
Failed : 0
------------------ Efficiency -------------------
Compaction : 4.79
Dedup : 1.17
Compression : 1.19
Data Reduction : 1.36
Overprovisioning : 1.70

Accepted answer

3 additional answers

Your answer

Answer 1

Anonymous

Hi，

As $3parCapacity is a string array, the ConvertTo-Html cmdlet only gets the Length property and converts it to HTML. You can covert $3parCapacity to some custom objects.

$htmlfile = "C:\temp\output.html"  
$table=@()  
$3parCapacity | Where-Object{ $_ -match ":"} | ForEach-Object {   
    $field,$value = $_ -split ":"  
    $table += [pscustomobject]@{  
    'field' = $field   
    'value' = $value}  
}  
$table | ConvertTo-Html | Out-File -FilePath $htmlfile

Best Regards,
Ian Xue

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Kalaimani Thirupathi 411 Reputation points

2021-06-18T04:55:08.84+00:00

Thanks, Dear Lan.
Kalaimani Thirupathi 411 Reputation points

2021-06-18T05:57:42.157+00:00

Dear Lan, have a few more values, it possible to create more table like below
PS C:\> $ebl3parRCopylink
Target Node Address Status Options
3PHAL_0449 0:1:1 192.168.1.23 Up -
3PHAL_0449 3:1:1 192.168.4.23 Up -
receive 0:1:1 receive Up -
receive 1:1:1 receive Up -

I have tried with below but not working. if we want to add more fields how to do that, can help on this,

$table=@()
$ebl3parRCopylink | Where-Object{ $_ -match ":"} | ForEach-Object {
$field,$value = $_ -split " "
$field = $field.Trim(' ')
$value = $value.Trim(' ')
$field1 = $field1.Trim(' ')
$value1 = $value1.Trim(' ')
$table += [pscustomobject]@{
'field' = $field
'value' = $value
'field1' = $field1
'value1' = $value1}
}
$table=$table | ConvertTo-Html -Head $Header

Anonymous

Please try this if you want to write them in one html file.

$htmlfile = "C:\temp\output.html"
$table=@()
$3parCapacity | Where-Object{ $_ -match ":"} | ForEach-Object { 
    $field,$value = $_ -split ":"
    $table += [pscustomobject]@{
    'field' = $field 
    'value' = $value}
}
$table | ConvertTo-Html -Fragment | Out-File -FilePath $htmlfile
$ebl3parRCopylink[1..$ebl3parRCopylink.count] | ConvertFrom-Csv -Delimiter ' ' -Header 'Target Node', 'Address', 'Status', 'Options' | 
    ConvertTo-Html -Fragment | Out-File -FilePath $htmlfile -Append

Kalaimani Thirupathi 411 Reputation points

2021-06-18T07:31:44.82+00:00

Thanks dear.
Kalaimani Thirupathi 411 Reputation points

2021-06-18T16:40:19.007+00:00

Dear Lan, sorry to bother you. the below one working if the date and time value.

$ebl3parRCopylink[1..$ebl3parRCopylink.count] | ConvertFrom-Csv -Delimiter ' ' -Header 'Target Node', 'Address', 'Status', 'Options' |
ConvertTo-Html -Fragment | Out-File -FilePath $htmlfile -Append

and its possible to check condition Liks if the status

if (status -eq normal )
{
write-host "No error"

else
write-host " error"
}

Answer 2

Hi @Kalaimani Thirupathi ,

I am not sure what you mean with "getting the only length".

But maybe this helps to get started:

$a = @"  
------------- System Capacity (MiB) -------------  
Total Capacity : 937426944  
Allocated : 743172096  
Legacy Volumes : 0  
User : 0  
Snapshot : 0  
CPGs (VVs) : 671330304  
Shared : 69718601  
Private : 570563757  
Base : 559884471  
Reserved : 559884471  
Reserved (vSphere vVols) : 0  
Snap : 10679286  
Reserved : 10679286  
Reserved (vSphere vVols) : 0  
Free : 31047946  
Unmapped : 0  
System : 71841792  
Internal : 2729984  
Admin : 3575808  
Spare : 65536000  
Used : 0  
Unused : 65536000  
Free : 194254848  
Initialized : 194254848  
Uninitialized : 0  
Unavailable : 0  
Failed : 0  
------------------ Efficiency -------------------  
Compaction : 4.79  
Dedup : 1.17  
Compression : 1.19  
Data Reduction : 1.36  
Overprovisioning : 1.70  
"@  
  
$title = 'My HTML page'  
$html = @"  
<html>  
<head><title>$title</title></head>  
<body>  
<pre>$a</pre>  
</body>  
</html>  
"@  
  
$html | Out-File C:\Temp\b.html

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Kalaimani Thirupathi 411 Reputation points

2021-06-18T02:36:49.183+00:00

Dear,

I'm going to explain my issue clearly here

PS C:\Users\k001a> Get-3parSystem -SystemCapacity -SANConnection $EBL #Able to get the result here

------------- System Capacity (MiB) -------------
Total Capacity : 937426944
Allocated : 743024640

------------------ Efficiency -------------------
Compaction : 4.13
Dedup : 1.17
Compression : 1.19

PS C:\Users\k001a> $3parCapacity =Get-3parSystem -SystemCapacity -SANConnection $EBL | ConvertTo-Html -Head $Header # Coverting the result to HTML
PS C:\Users\k001a> $3parCapacity # but its not converted due to the some reason
<head>
<style>
</style>
</head><body>
<table>

</table>
</body></html>

removed the complete result due to character restrictions in ms

Answer 3

This isn't the most efficient (and certainly not the prettiest) way to handle this, but it does produce HTML tables:

$t = @"
------------- System Capacity (MiB) -------------
Total Capacity : 937426944
Allocated : 743172096
Legacy Volumes : 0
User : 0
Snapshot : 0
CPGs (VVs) : 671330304
Shared : 69718601
Private : 570563757
Base : 559884471
Reserved : 559884471
Reserved (vSphere vVols) : 0
Snap : 10679286
Reserved : 10679286
Reserved (vSphere vVols) : 0
Free : 31047946
Unmapped : 0
System : 71841792
Internal : 2729984
Admin : 3575808
Spare : 65536000
Used : 0
Unused : 65536000
Free : 194254848
Initialized : 194254848
Uninitialized : 0
Unavailable : 0
Failed : 0
------------------ Efficiency -------------------
Compaction : 4.79
Dedup : 1.17
Compression : 1.19
Data Reduction : 1.36
Overprovisioning : 1.70
"@

$ta = $t -split "\r\n"  # convert the string to an array of strings
                        # this should only be necessary for this example
$th = [ordered]@{}      # used to create a row of table data
$f = ''                 # hold the HTML fragments
$tables = ''            # hold the array of HTML to create the tables
$rows = @()             # hold each table row as a PSCustomObject
$ta | 
    ForEach-Object{
        if ($_ -match "^-+ (.+) -+$"){
            $nexttablename = $matches[1]    # keep the table name
            if ($rows.count){               # produce table with caption if the last table hasn't been converted to HTML
                $f = $rows | ConvertTo-Html -Fragment
                if ($f[0] -match "^(\<table.*?\>)$"){   # add a caption for the table (this clobbers the last table name)
                    $f[0] = "{0} <caption>{1}</caption>" -f $f[0],$tablename    # uses the table name from one under construction

                }
                $tables += $f               # add the HTML fragment to the string
            }
            # start new table
            $tablename = $nexttablename     # use the saved table name
            $rows = @()
        }
        else{
            # process each row
            $p = $_ -split ":"
            $th['Thing'] = $p[0].trim()     # adjust the column name as appropriate
            $th['Quantity'] = $p[1].trim()  # ditto
            $rows += [PSCustomObject]$th
        }
    }
    # handle the last table in the input data
    if ($rows.count){        # produce table with caption
        $f = $rows | ConvertTo-Html -Fragment
        if ($f[0] -match "^(\<table.*?\>)$"){
            $f[0] = "{0} <caption>{1}</caption>" -f $f[0],$tablename
        }
        $tables += $f
    }
$title = 'Report in HTML format'
$report = @"
<html>
  <head>
    <title>$title</title>
  </head>
  <body>
    $tables
  </body>
</html>
"@
$report | out-file c:\junk\report.html

Kalaimani Thirupathi 411 Reputation points

2021-06-18T02:43:05.993+00:00

Dear,

I'm going to explain my issue clearly here

PS C:\Users\k001a> Get-3parSystem -SystemCapacity -SANConnection $EBL #Able to get the result here

------------- System Capacity (MiB) -------------
Total Capacity : 937426944
Allocated : 743024640

------------------ Efficiency -------------------
Compaction : 4.13
Dedup : 1.17
Compression : 1.19

PS C:\Users\k001a> $3parCapacity =Get-3parSystem -SystemCapacity -SANConnection $EBL | ConvertTo-Html -Head $Header # Coverting the result to HTML
PS C:\Users\k001a> $3parCapacity # but its not converted due to the some reason
<head>
<style>
</style>
</head><body>
<table>

</table>
</body></html>

removed the complete result due to character restrictions in ms

Answer 4

Kalaimani Thirupathi 411

Anonymous

2021-06-18T03:40:02.56+00:00

Is $3parCapacity a string or a string array? You can run $3parCapacity.GetType() and $3parCapacity | Get-Member -MemberType Properties to get the type.
Kalaimani Thirupathi 411 Reputation points

2021-06-18T03:47:50.337+00:00

Dear,

There is no proper member-type

PS C:\> $3parCapacity.GetType()

IsPublic IsSerial Name BaseType

True True Object[] System.Array

PS C:\> $3parCapacity | Get-Member -MemberType Properties

TypeName: System.String

Name MemberType Definition

Length Property int Length {get;}

PS C:\>

Share via

Powershell scipt to conver taxt file to HTML

I have tried with below but not working. if we want to add more fields how to do that, can help on this,

3 additional answers

Your answer