PowerShellUniversal.Component.Pivot

Author(s)

• eizedev

Tags

PowerShellUniversal UniversalDashboard PSU Pivot PivotTable Report Dashboard Excel Visualization

Functions

New-UDPivotReport New-UDPivotReportPlaceholder ConvertFrom-UDPivotView ConvertFrom-UDPivotViewFile ConvertTo-UDPivotViewFile New-UDPivotFileTemplateStore New-UDPivotTemplateStore Invoke-UDPivotTemplateRequest Get-UDPivotSqlColumnDescription

Dependencies

This module has no dependencies.

Release Notes

### Added

- `-AllowImport`: readers load a CSV, TSV, JSON or Excel file (`.xlsx`) of their own into the report,
 read in the browser and never uploaded: a Data menu, a file dropped onto the report and a preview
 with a type per column and the sheet of a workbook; Back to original data and Undo go back to the
 app's data ([pivotkit#44](https://github.com/eizedev/pivotkit/issues/44)). The Excel reader
 (pivotkit-xlsx) is part of the bundle and runs only when the first workbook is read; CSV and JSON
 files are read in a worker the module ships next to its bundle (`import-worker.<hash>.js`, about
 26 KB), or on the page where a Content-Security-Policy keeps the worker from starting. `-Data` may
 be empty: the report then asks for a file. The bundle grows from 1.27 MB (391 KB gzip) to 1.41 MB
 (434 KB gzip): 69 KB (19 KB gzip) are the Excel reader, the rest pivotkit's import UI and menus.
- While a reader's file is shown, its view stays out of the address bar, `sessionStorage`,
 `Get-UDElement` and `-OnViewChange`, `-OnCellClick` does not run (its rows would carry the file's),
 and views the reader saves go to the browser's store per file, never to `-TemplateStore` or
 `-OnSaveTemplate`; the reader's own server views of the app's data leave "My views" meanwhile.
 Back to original data shows the app's last view, also after more loads than Undo keeps. PSU's
 light/dark switch and `Sync-UDElement` keep the file shown with its view (pivotkit keeps it per
 report in the page's memory; `-OnDataLoad` hears `restore`).
- `-OnDataLoad`: runs on the server when the data shown changes (a file loaded, the app's data again,
 Undo, Redo) with the cause, the file's name, size and type, the sheet, rows, columns (the first 200
 names and types) and the codes of the readers' notes; never a value of the file.
- Docs: the page [Readers' own files](https://powershell-universal-components.eize.dev/pivot/import/);
 the showcase app has a page "Your file" with the tickets, a file next to them and the events.

### Changed

- pivotkit 0.4.0 ([pivotkit-react release](https://github.com/eizedev/pivotkit/releases/tag/pivotkit-react%400.4.0))
 and the new pivotkit-xlsx 0.1.0: the Start over menu (Reset and New, empty report) after
 Undo and Redo, the Views menu regrouped (This view, Shared views, My views, Share this view), menu
 groups and a More menu only for buttons that do not fit.
- The help of `-SourceId` and the docs (Templates, view files and roles) say when to set it: a report
 whose data changes per call under the same `-Id` (an uploaded file, a parameter) sets `-SourceId` per
 data source, else the views saved for all of its data show together
 ([pivotkit#116](https://github.com/eizedev/pivotkit/issues/116)). The default stays `-Id`, so views
 readers saved keep showing.

### Fixed

- A shared view of `-TemplateStore` with the name of a `-TemplatePath` file takes the file's place in the
 Views menu. The menu listed the read-only file next to it, so an admin's Publish or Save over a
 shipped view looked lost; deleting the shared view offers the file again
 ([#73](https://github.com/eizedev/powershell-universal-components/issues/73)).