Display CSV-File as Table

PowerShell Universal Universal Automation
1

Dear Community,
I´m pretty new to UDDashobards but already amazed byi it´s possibilities.

The Task I want to do at the end of the day is to simply output a CSV-File with several columns on a webpage, so several People can see the content of it. The file is getting generated every 5-15 minutes through a powershell-Script, so it needs to be refreshed within that timeframe without blocking the CSV-File… otherwise the Powershell-CMDLet throws up an error.

Till now I got Universal Dasboard installed according to the Get-Started Documentation and I´m running on Version 2.0.0. I created a new Dashboard but now I´m already stuck with the code…because this is an overwhelming amount of possibilities…

Thanks for you help in Advance!

Please note: I already saw the post Easy way to display auto-refreshing grid based on input CSV file, but couldn´t get much out of it.

1 Like
2

You can place the call to Import-CSV and New-UDTable within an auto-refreshing UDDynamic and this should do what you’re looking for.

New-UDDynamic -Content {
        $Data = Import-Csv C:\Users\adamr\Desktop\services.csv
        New-UDTable -Data $Data
    } -AutoRefresh -AutoRefreshInterval 5
2 Likes
3

hello @psfiddler and welcome to the community. I got a blog here UDFLIX a Blogtastic Site which mainly contains custom components…but I have developed a few custom tables myself for instance React Flexy Table | Powershell Blog which I give an example of using CSV to the table, I also built a google table which has a demo here GitHub - psDevUK/New-GoogleTable: A Google Table for UniversalDashboard based on https://www.npmjs.com/package/react-google-charts there are many custom components on https://marketplace.universaldashboard.io/ I know @adam was kind enough to provide a solution, but as this software is so awesome there are so many ways you can do something, and display it :smile:

2 Likes