Open a file from dashboard

Mohamed · February 9, 2023, 9:41am

Hi,
I am a beginner with powershell and PSU. I am trying to import all my scripts from PS to PSU and execute via a dashboard.
What I am trying to do is very basic, from the dashboard open & update a csv file via a button then excute the script via another button.
the script will import the updated csv file .
My issue is when clicking the button the csv file is not opening from the dashbord but works fine from powershell.
Any help would be appreciated.
Thanks

My script :

New-UDButton -Text ‘Update CSV File Before Executing the Script’ -OnClick {
Invoke-Item ‘E:\admin\hostlist.csv’

New-UDButton -Text ‘Click Here to Run The Script’ -OnClick {
Invoke-PSUScript ‘host.ps1’

}

Jori · February 10, 2023, 10:47pm

What is the full context to this? Are you trying to add a line to the end of it? Are you trying to modify data that is in the CSV?

To me, this seems like you need to import the CSV, display it in a table that allows editing, have the user edit the data, then export it. It works when you run it from PowerShell because once you do invoke-Item it will open it in notepad or excel or whatever program is the default.

Mohamed · February 13, 2023, 9:10am

Hi,
I have several scripts which imports csv files after users update the variables before executing it.
CSV file is in a local share in PSU server.
Rather than going to that local share, open csv file and update, I would like to have a button to open the csv file from the dashboard so that the user can update and save.

If there is any possibilities to display directly that csv file in the dashboard and save or
have a table in the dashboard where user can add the details which will then update the csv and imported by the script would be great as well.

Thanks for the help.

Example of my script:

#### IMPORT CSV FILE ####
$idraclist = Import-Csv "E:\Scripts\Powershell-Universal-Scripts\iDRAC\idraclist.csv"

write-host "This script will reset root password, import idrac SCP and set new time zone" 
sleep 2

# Enter existing credential
$pwd = $Secret:idracold
$newpass = $Secret:idracnew
write-host "Resetting iDRAC root password" 

foreach ($item in $idraclist) {

# idrac list imported from CSV
$idracIP = $item.idracIP
$timezone = $item.timezone
$region = $item.region

# Reset root password
racadm -r $idracIP -u root -p $pwd set iDRAC.Users.2.Password $newpass
sleep 2
}
write-host "Root password is now changed on all hosts"
sleep 2
write-host "Configuring new Timezone"

foreach ($item in $idraclist) {

# idrac list imported from CSV
$idracIP = $item.idracIP
$timezone = $item.timezone
$region = $item.region

# Change timezone
racadm -r $idracIP -u root -p $newpass set iDRAC.TIME.Timezone $timezone
sleep 2
}
write-host "New Timezone is now configured on all hosts"
sleep 2
Write-Host "Importing" $region "iDRAC Server Configuration profile."

foreach ($item in $idraclist) {

# idrac list
$idracIP = $item.idracIP
$timezone = $item.timezone
$region = $item.region

# Import Server Configuration Profile XML

if ($region -eq "AMER") {
racadm -r $idracIP -u root -p $newpass set -t xml -f E:\iDRAC\scp-idrac-no-ip-AMER.xml
}
elseif ($region -eq "EMEA") {
racadm -r $idracIP -u root -p $newpass set -t xml -f E:\iDRAC\scp-idrac-no-ip-EMEA.xml
}
elseif ($region -eq "APAC") {
racadm -r $idracIP -u root -p $newpass set -t xml -f E:\iDRAC\scp-idrac-no-ip-APAC.xml
}
else
{
 Write-Host 'Sorry, the region is not correct' }

 }
write-host $region "iDRAC Server Configuration profile is now imported on all hosts"

Mohamed · February 14, 2023, 11:05am

Adding PSU Dashbord script for a better understanding.


# Use Get-UDPage -Name 'IDRAC' to use this page in your dashboard

$AppToken = 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9uYW1lIjoiYWRtaW4iLCJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yM3IiLCJuYmYiOjE2NzYwMjI2ODMsImV4cCI6MjEzMzkzOTA2MCwiaXNzIjoiSXJvbm1hblNvZnR3YXJlIiwiYXVkIjoiUG93ZXJTaGVsbFVuaXZlcnNhbCJ9.57kslyhZSHGxEtAPldKKtKzGe_Bm1uvOLPap2dRrHY8'

New-UDButton -Text 'HOME PAGE' -Style @{ Width = "150px"; Height = "50px"} -OnClick {
        Invoke-UDRedirect -url http://psuserver:5000/scripts/Home
                }
New-UDGrid -Item -SmallSize 6 -Content {
    New-UDCard -Title 'IDRAC CONFIGURATION' -Content {
    New-UDTypography -Variant h6 "This script will configure idracs of below listed hosts (IPs). Before executing, please update the CSV file and check if the details displayed in the table are correct."
                            }
}
                    
New-UDDynamic -Content {
        $Data = Import-Csv E:\Scripts\Powershell-Universal-Scripts\iDRAC\idraclist.csv
        New-UDTable -Data $Data
    } -AutoRefresh -AutoRefreshInterval 5
    
New-UDButton -Text 'Click here to update CSV file before executing the script' -Style @{ Width = "400px"; Height = "50px"} -OnClick {
        Invoke-Item 'E:\Scripts\Powershell-Universal-Scripts\iDRAC\idraclist.csv'
                }

    New-UDButton -Text 'Click here to run the script' -Style @{ Width = "250px"; Height = "50px"} -OnClick {
        Set-UDElement -Id 'button' -Properties @{
            disabled = $true 
            text = "Running the script"
        }
        Connect-PSUServer -ComputerName http://localhost:5000 -AppToken $AppToken

        $Job = Invoke-PSUScript -Script 'iDrac-Configuration.ps1'

        while($Job.Status -ne 'Completed')
        {
            Start-Sleep 1
            $Output = (Get-PSUJobOutput -Job $Job).Data -join ([Environment]::NewLine) 
            Set-UDElement -Id 'codeEditor' -Properties @{
                code = $Output
            } 

            $Job = Get-PSUJob -Id $Job.Id
        }

        Set-UDElement -Id 'button' -Properties @{
            disabled = $false 
            text = "Click here to run the script"
        }
    } -Id 'button'

    New-UDCodeEditor -Id 'codeEditor' -ReadOnly -Height 500 -Theme 'vs-dark'

djo · February 14, 2023, 11:15am

Have you tried looking at the editor or code editor?

As mentioned in the chat, I really think this could solve your problem.

Mohamed · February 14, 2023, 11:24am

I tried few things but seems that result is not as expected.
Do you have any examples which can be very helpful ? I have also added the scripts above for a better understanding.
Thanks

adam · February 14, 2023, 4:46pm

Please see the updates below. I’m opening a modal when you click the button that has the code editor in. It also has a save button that reads the contents of the code editor and writes them to disk.

# Use Get-UDPage -Name 'IDRAC' to use this page in your dashboard

$AppToken = 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9uYW1lIjoiYWRtaW4iLCJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yM3IiLCJuYmYiOjE2NzYwMjI2ODMsImV4cCI6MjEzMzkzOTA2MCwiaXNzIjoiSXJvbm1hblNvZnR3YXJlIiwiYXVkIjoiUG93ZXJTaGVsbFVuaXZlcnNhbCJ9.57kslyhZSHGxEtAPldKKtKzGe_Bm1uvOLPap2dRrHY8'

$CSVPath = E:\Scripts\Powershell-Universal-Scripts\iDRAC\idraclist.csv

New-UDButton -Text 'HOME PAGE' -Style @{ Width = "150px"; Height = "50px"} -OnClick {
        Invoke-UDRedirect -url http://psuserver:5000/scripts/Home
                }
New-UDGrid -Item -SmallSize 6 -Content {
    New-UDCard -Title 'IDRAC CONFIGURATION' -Content {
    New-UDTypography -Variant h6 "This script will configure idracs of below listed hosts (IPs). Before executing, please update the CSV file and check if the details displayed in the table are correct."
                            }
}
                    
New-UDDynamic -Content {
        $Data = Import-Csv $CSVPath
        New-UDTable -Data $Data
    } -AutoRefresh -AutoRefreshInterval 5
    
New-UDButton -Text 'Click here to update CSV file before executing the script' -Style @{ Width = "400px"; Height = "50px"} -OnClick {

$CSV =   Get-Content $CSVPath
Show-UDModal -Content {
    New-UDCodeEditor -Id 'codeEditor' -Height 500 -Theme 'vs-dark' -Code $CSV
    New-UDButton -Text 'Save' -OnClick {
          Set-Content -Value ((Get-UDElement -Id 'codeEditor').Code) -Path $CSVPath
           Hide-UDModal
    }
}
                }

    New-UDButton -Text 'Click here to run the script' -Style @{ Width = "250px"; Height = "50px"} -OnClick {
        Set-UDElement -Id 'button' -Properties @{
            disabled = $true 
            text = "Running the script"
        }
        Connect-PSUServer -ComputerName http://localhost:5000 -AppToken $AppToken

        $Job = Invoke-PSUScript -Script 'iDrac-Configuration.ps1'

        while($Job.Status -ne 'Completed')
        {
            Start-Sleep 1
            $Output = (Get-PSUJobOutput -Job $Job).Data -join ([Environment]::NewLine) 
            Set-UDElement -Id 'codeEditor' -Properties @{
                code = $Output
            } 

            $Job = Get-PSUJob -Id $Job.Id
        }

        Set-UDElement -Id 'button' -Properties @{
            disabled = $false 
            text = "Click here to run the script"
        }
    } -Id 'button'

Mohamed · February 15, 2023, 8:33am

Hi @adam ,
Many thanks for your help. I am pretty much nearing to the result.
When I click the button, the code editor is empty (content from csv is not shown) and I have the below error.

There is no possibilities to open the csv file by clicking the button ? it will ease user to edit the file.
Thanks

adam · February 15, 2023, 2:13pm

Can you try this?

$CSV =   Get-Content $CSVPath -Raw

Mohamed · February 15, 2023, 3:53pm

It works perfectly now, many Thanks @adam.

I am reasking the question as in code editor editing is not as easier as editing in csv file directly as shown in the picture below.

No option at all to open the csv file from the local share by clicking a button or edit in editor in much better way ?

Many Thanks again, appreciate a lot your help

Jori · February 15, 2023, 5:25pm

Hi Mohamed,

First I’ll say I would recommend not leaking any Bastion/iDrac information (for the purposes of demonstration, I would create a “fake” set of IP’s, and for any API Keys just leave blank.

Second, you have tons of different options for editing the data. Here is some code for you to look at and refine .

My apologies if I missed anything obvious, I created a csv with only 3 columns on my local machine to do some testing with.

$AppToken = 'XXXXXXXXXXXXXXX'

$Page:CSVPath = "E:\Scripts\Powershell-Universal-Scripts\iDRAC\idraclist.csv"

New-UDButton -Text 'HOME PAGE' -Style @{ Width = "150px"; Height = "50px" } -OnClick {
    Invoke-UDRedirect -url http://psuserver:5000/scripts/Home
}
New-UDGrid -Item -SmallSize 6 -Content {
    New-UDCard -Title 'IDRAC CONFIGURATION' -Content {
        New-UDTypography -Variant h6 "This script will configure idracs of below listed hosts (IPs). Before executing, please update the CSV file and check if the details displayed in the table are correct."
    }
}
$Columns = @(
    New-UDTableColumn -Property 'fake' -Title 'Actions' -Render {
        New-UDButton -Icon (New-UDIcon -Icon Edit -Size lg) -OnClick {
            $Page:EditRow = $EventData
            Show-UDModal -Content {
                New-UDForm -Children {
                    $Page:EditRow | Get-Member -MemberType NoteProperty | select -ExpandProperty name | Foreach {
                        New-UDTextbox -id $_ -Label $_ -Value $Page:Editrow.$_
                    }
                } -OnSubmit {
                    $Data = Import-Csv $Page:CSVPath
                    $Row = $Data | Where-Object { $_ -match $Page:EditRow }
                    $EventData | Get-Member -MemberType NoteProperty | select -ExpandProperty name | Foreach {
                        $Row.$_ = $EventData.$_
                    }
                    $Data | Export-Csv $Page:CSVPath
                    Sync-UDElement -Id 'idracTable' -Broadcast
                    Hide-UDModal
                }
                
            }
        }
        New-UDButton -Icon (New-UDIcon -Icon TrashCan -Size lg) -color error -OnClick {
            $Page:EditRow = $EventData
            Show-UDModal -Content {
                New-UDAlert -Severity warning -Text "YOU ARE ABOUT TO REMOVE THIS ROW."
                New-UDCheckBox -Label 'CONFIRM' -OnChange {
                    If ($Body -eq $true) {
                        $Page:ConfirmDelete = $true
                        Sync-UDElement -Id 'idracConfirmDelete'
                    }
                    elseif ($Body -eq $false) {
                        $Page:ConfirmDelete = $false
                        Sync-UDElement -Id 'idracConfirmDelete'
                    }
                }
                New-UDDynamic -Id 'idracConfirmDelete' -Content {
                    If ($Page:ConfirmDelete -eq $true) {
                        New-UDButton -Icon (New-UDIcon -Icon TrashCan -Size lg) -color error -OnClick {
                            $Data = Import-Csv $Page:CSVPath
                            $Data | Where-Object { $_ -notmatch $Page:EditRow } | Export-CSV $Page:CSVPath
                            $Page:ConfirmDelete = $false
                            Sync-UDElement -Id 'idracTable' -Broadcast
                            Hide-UDModal
                        }
                    }
                    If ($Page:ConfirmDelete -ne $true) {
                        New-UDButton -Icon (New-UDIcon -Icon TrashCan -Size lg) -color error -Disabled
                    }
                }
            }
        }
    }
    New-UDTableColumn -Property 'timezone'
    New-UDTableColumn -Property 'idracIP'
    New-UDTableColumn -Property 'region'
)
New-UDButton -Text "Add" -Icon (New-UDIcon -Icon PlusSquare) -OnClick {
    Show-UDModal -Content {
        New-UDForm -Children {
            Import-Csv $Page:CSVPath | Get-Member -MemberType NoteProperty | select -ExpandProperty name | Foreach {
                New-UDTextbox -id $_ -Label $_
            }
        } -OnSubmit {
            $EventData | Export-Csv $Page:CSVPath -Append
            Sync-UDElement -Id 'idracTable' -Broadcast
            Hide-UDModal
        }

    }
}
New-UDTable -Id 'idracTable' -Columns $Columns -LoadData {
    $Data = Import-Csv $Page:CSVPath

    foreach ($Filter in $EventData.Filters) {
        $Data = $Data | Where-Object -Property $Filter.Id -Match -Value $Filter.Value
    }

    $TotalCount = $Data.Count 

    if (-not [string]::IsNullOrEmpty($EventData.OrderBy)) {
        $Descending = $EventData.OrderDirection -ne 'asc'
        $Data = $Data | Sort-Object -Property $EventData.orderBy -Descending:$Descending
    }
    
    $Data = $Data | Select-Object -First $EventData.PageSize -Skip ($EventData.Page * $EventData.PageSize)

    $Data | Out-UDTableData -Page $EventData.Page -TotalCount $TotalCount -Properties $EventData.Properties
}


New-UDButton -Text 'Click here to run the script' -Style @{ Width = "250px"; Height = "50px" } -OnClick {
    Set-UDElement -Id 'button' -Properties @{
        disabled = $true 
        text     = "Running the script"
    }
    Connect-PSUServer -ComputerName http://localhost:5000 -AppToken $AppToken

    $Job = Invoke-PSUScript -Script 'iDrac-Configuration.ps1'

    while ($Job.Status -ne 'Completed') {
        Start-Sleep 1
        $Output = (Get-PSUJobOutput -Job $Job).Data -join ([Environment]::NewLine) 
        Set-UDElement -Id 'codeEditor' -Properties @{
            code = $Output
        } 

        $Job = Get-PSUJob -Id $Job.Id
    }

    Set-UDElement -Id 'button' -Properties @{
        disabled = $false 
        text     = "Click here to run the script"
    }
} -Id 'button'

Mohamed · February 16, 2023, 10:07am

@Jori it’s really awesome and beyond my expectations and much better !!!
it’s really cool from you, I really appreciate the help received for a beginner in the world of scripting from you all and this forum.

Jori · February 16, 2023, 4:04pm

Glad to help!

Scripting with PS requires a certain mindset (to work through the flow of the script) and PSU only adds to that, with quirks of the product and dynamic elements vs non-dynamic.

Mohamed · February 20, 2023, 1:09pm

Hi @Jori,
Sorry to bother you, New-UDTableColumn is not displaying more than 5 rows, any working to display all rows ?
Thanks

Jori · February 20, 2023, 2:14pm

You’ll need to add the -ShowPagination and ‘-PageSize X’ parameter. The first will show the page controls, the other will determine how many rows per page.

Mohamed · February 20, 2023, 3:17pm

I got it now, many thanks again.

Mohamed · March 14, 2023, 1:58pm

Hi @Jori ,
I am trying to add few extra functions with this code to prefill information of few table columns
When user click on edit button, I would like to have choices for user on region and timezone so that the user don’t need to enter data manually.
I tried to use filter funtion unsuccessfully, any help would be appreciated

Many Thanks.

Mohamed · May 22, 2023, 3:25pm

Any help @Jori @adam please ?
Thanks

Jori · May 23, 2023, 5:38pm

Not sure if I’m understanding you correctly, but let me try.

Are you trying to have a button open up a modal window so they can select some settings, then have the Table use those previous selections when filtering data?

Mohamed · May 23, 2023, 5:53pm

Hi @Jori
Yes, select pre filled information rather putting it manually
I would like to collect data from either powershell universal if there is any possibilities or vcenter for example server name, network nic, datastore etc…

Topic		Replies	Views
Import-csv to table in Dashboard	5	861	January 27, 2021
Export-CSV button to allow user to save file to his desktop Universal Dashboard	1	216	August 10, 2023
Invoke-PSUScript not starting job PowerShell Universal	4	726	November 16, 2021
Newb alert, trouble getting started: Dashboard card to invoke script PowerShell Universal	0	277	November 28, 2022
Running script on click PowerShell Universal	11	3621	August 12, 2021

Open a file from dashboard

Related topics