PowerShellUniversal.Component.Pivot.psd1
|
# # Module manifest for module 'PowerShellUniversal.Component.Pivot' # # Generated by: eizedev # # Generated on: 11/11/2026 # @{ # Script module or binary module file associated with this manifest. RootModule = 'PowerShellUniversal.Component.Pivot.psm1' # Version number of this module. ModuleVersion = '0.4.0' # Supported PSEditions # CompatiblePSEditions = @() # ID used to uniquely identify this module GUID = 'e59f7ff0-a6dc-4402-9729-98af8be5c83b' # Author of this module Author = 'eizedev' # Company or vendor of this module CompanyName = 'eizedev' # Copyright statement for this module Copyright = '(c) 2026 eizedev. MIT License.' # Description of the functionality provided by this module Description = 'Pivot report builder for PowerShell Universal apps: readers drag fields into rows, columns, values and filters and get a table or a chart, with date grouping, drill-down to the source rows, templates, undo, Excel, CSV and PNG export and the reader''s own CSV, JSON and Excel files read in the browser; light and dark theme, English and German, fed straight from SQL DataTables, REST results and PowerShell objects.' # Minimum version of the PowerShell engine required by this module PowerShellVersion = '7.4' # Name of the PowerShell host required by this module # PowerShellHostName = '' # Minimum version of the PowerShell host required by this module # PowerShellHostVersion = '' # Minimum version of Microsoft .NET Framework required by this module. This prerequisite is valid for the PowerShell Desktop edition only. # DotNetFrameworkVersion = '' # Minimum version of the common language runtime (CLR) required by this module. This prerequisite is valid for the PowerShell Desktop edition only. # ClrVersion = '' # Processor architecture (None, X86, Amd64) required by this module # ProcessorArchitecture = '' # Modules that must be imported into the global environment prior to importing this module # RequiredModules = @() # Assemblies that must be loaded prior to importing this module # RequiredAssemblies = @() # Script files (.ps1) that are run in the caller's environment prior to importing this module. # ScriptsToProcess = @() # Type files (.ps1xml) to be loaded when importing this module # TypesToProcess = @() # Format files (.ps1xml) to be loaded when importing this module # FormatsToProcess = @() # Modules to import as nested modules of the module specified in RootModule/ModuleToProcess # NestedModules = @() # Functions to export from this module, for best performance, do not use wildcards and do not delete the entry, use an empty array if there are no functions to export. FunctionsToExport = 'New-UDPivotReport', 'New-UDPivotReportPlaceholder', 'ConvertFrom-UDPivotView', 'ConvertFrom-UDPivotViewFile', 'ConvertTo-UDPivotViewFile', 'New-UDPivotFileTemplateStore', 'New-UDPivotTemplateStore', 'Invoke-UDPivotTemplateRequest', 'Get-UDPivotSqlColumnDescription' # Cmdlets to export from this module, for best performance, do not use wildcards and do not delete the entry, use an empty array if there are no cmdlets to export. CmdletsToExport = @() # Variables to export from this module # VariablesToExport = @() # Aliases to export from this module, for best performance, do not use wildcards and do not delete the entry, use an empty array if there are no aliases to export. AliasesToExport = @() # DSC resources to export from this module # DscResourcesToExport = @() # List of all modules packaged with this module # ModuleList = @() # List of all files packaged with this module # FileList = @() # Private data to pass to the module specified in RootModule/ModuleToProcess. This may also contain a PSData hashtable with additional module metadata used by PowerShell. PrivateData = @{ PSData = @{ # Tags applied to this module. These help with module discovery in online galleries. Tags = 'PowerShellUniversal','UniversalDashboard','PSU','Pivot','PivotTable','Report','Dashboard','Excel','Visualization' # A URL to the license for this module. LicenseUri = 'https://github.com/eizedev/powershell-universal-components/blob/main/LICENSE' # A URL to the main website for this project. ProjectUri = 'https://github.com/eizedev/powershell-universal-components' # A URL to an icon representing this module. # IconUri = '' # ReleaseNotes of this module ReleaseNotes = '### 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)).' # Prerelease string of this module # Prerelease = '' # Flag to indicate whether the module requires explicit user acceptance for install/update/save # RequireLicenseAcceptance = $false # External dependent modules of this module # ExternalModuleDependencies = @() } # End of PSData hashtable } # End of PrivateData hashtable # HelpInfo URI of this module # HelpInfoURI = '' # Default prefix for commands exported from this module. Override the default prefix using Import-Module -Prefix. # DefaultCommandPrefix = '' } |