René's URL Explorer Experiment


Title: Feature Request: Add OutputType parameter to Import-Csv · Issue #8862 · PowerShell/PowerShell · GitHub

Open Graph Title: Feature Request: Add OutputType parameter to Import-Csv · Issue #8862 · PowerShell/PowerShell

X Title: Feature Request: Add OutputType parameter to Import-Csv · Issue #8862 · PowerShell/PowerShell

Description: Summary of the new feature/enhancement By using a concrete type, instead of PSObject, both import speed and memory usage can be improved. As it is today, Import-Csv is almost useless for larger datasets, since the overhead of our NotePro...

Open Graph Description: Summary of the new feature/enhancement By using a concrete type, instead of PSObject, both import speed and memory usage can be improved. As it is today, Import-Csv is almost useless for larger dat...

X Description: Summary of the new feature/enhancement By using a concrete type, instead of PSObject, both import speed and memory usage can be improved. As it is today, Import-Csv is almost useless for larger dat...

Opengraph URL: https://github.com/PowerShell/PowerShell/issues/8862

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Feature Request: Add OutputType parameter to Import-Csv ","articleBody":"# Summary of the new feature/enhancement\r\n\r\nBy using a concrete type, instead of `PSObject`, both import speed and memory usage can be improved. \r\n\r\nAs it is today, Import-Csv is almost useless for larger datasets, since the overhead of our NoteProperties is 48 bytes, not counting the name and the value. When the imported values are integers, that is a blowup-factor of ~20.\r\n\r\nThese numbers are from my prototype:\r\n\r\n| Destination | Time | Memory used |\r\n| ----- | :-----: | :------: |\r\n| PSObject | 01:34 | 19Gb |\r\n| class with int props | 01:02 | 490Mb |\r\n| class with string props | 00:10 | 4.2Gb |\r\n\r\nBy keeping it as strings, the import speed is vastly improved. By converting to integers, the speed is still improved, and the memory requirements are vastly improved.\r\n\r\n# Proposed technical implementation details (optional)\r\n\r\nSee https://github.com/PowerShell/PowerShell/pull/8860.\r\n\r\nThe gist is to generate expression trees, that sets the properties or call the constructor, on an instance of the provided type.\r\n\r\nThe use of the constructor allows for custom type conversion, where there are no language conversions from string to the property type.\r\n\r\nThe type needs to have members that match the names of the columns in the CSV. \r\nMaybe we should provide a way of providing alternate headers to map to existing objects?\r\n\r\nData.csv\r\n```csv\r\nText, Integer,Date\r\nHi,42,2016-12-24\r\nBye,4711,2016-12-25\r\n```\r\n\r\n```powershell\r\nclass MyCsv {\r\n   [string] $Text\r\n   [int] $Integer\r\n   [DateTime] $Date\r\n}\r\n$d = Import-Csv -OutputType ([MyCsv]) -Path .\\data.csv\r\n```\r\nI also implemented ctor calls, that takes precedence.\r\n\r\n```powershell\r\nclass MyCsv2 {\r\n   MyCsv2([string] $text, [int] $integer, $date){\r\n       $this.Name = $this.text\r\n       $this.Number = $integer * 100\r\n       $this.When = $dateTime\r\n   }\r\n   [string] $Name\r\n   [long] $Number\r\n   [DateTime] $When\r\n}\r\n$e = Import-Csv -OutputType ([MyCsv2]) -Path .\\data.csv\r\n```\r\n\r\nI would like to see a discussion about the feature set, error handling, names for parameters etc.","author":{"url":"https://github.com/powercode","@type":"Person","name":"powercode"},"datePublished":"2019-02-10T23:19:13Z","url":"https://github.com/PowerShell/PowerShell/issues/8862"}

react-profiling0
react-import-mapreact,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322
route-pattern/_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format)
route-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:c86bdf4c-5c5f-92a0-1915-204a0766cd26
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idA12E:126CB9:27E56AE:379E012:6AFD51DF
html-safe-nonce0fb885fd7d2643fb028a452904f07a9c57f4e03a31d4647ba42261ad39569a90
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBMTJFOjEyNkNCOToyN0U1NkFFOjM3OUUwMTI6NkFGRDUxREYiLCJ2aXNpdG9yX2lkIjoiNTc3MjgzODczNTE2MjcyNDgzMSIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac22a752f90f8c827d29fece68ba617399772f893bfea905fa70594645acee63ca
hovercard-subject-tagissue:408595733
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/PowerShell/PowerShell/8862/issue_layout
twitter:imagehttps://opengraph.githubassets.com/198cce626f34251b26850b432108cbb4ba06e07eeadfa029c3e04db3a9e8eed3/PowerShell/PowerShell/issues/8862
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/198cce626f34251b26850b432108cbb4ba06e07eeadfa029c3e04db3a9e8eed3/PowerShell/PowerShell/issues/8862
og:image:altSummary of the new feature/enhancement By using a concrete type, instead of PSObject, both import speed and memory usage can be improved. As it is today, Import-Csv is almost useless for larger dat...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamepowercode
hostnamegithub.com
expected-hostnamegithub.com
None66653c2e55a6fff2930be1bdf07ee4f8aa137e3956d056c822563be6f878755e
turbo-cache-controlno-preview
go-importgithub.com/PowerShell/PowerShell git https://github.com/PowerShell/PowerShell.git
octolytics-dimension-user_id11524380
octolytics-dimension-user_loginPowerShell
octolytics-dimension-repository_id49609581
octolytics-dimension-repository_nwoPowerShell/PowerShell
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id49609581
octolytics-dimension-repository_network_root_nwoPowerShell/PowerShell
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
releaseb6f01f7cb9f35f8c09949773241a3d49dd04b340
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/PowerShell/PowerShell/issues/8862#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FPowerShell%2FPowerShell%2Fissues%2F8862
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FPowerShell%2FPowerShell%2Fissues%2F8862
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=PowerShell%2FPowerShell
Reloadhttps://github.com/PowerShell/PowerShell/issues/8862
Reloadhttps://github.com/PowerShell/PowerShell/issues/8862
Reloadhttps://github.com/PowerShell/PowerShell/issues/8862
PowerShellhttps://github.com/PowerShell
PowerShellhttps://github.com/PowerShell/PowerShell
Codehttps://github.com/PowerShell/PowerShell
Issues1.3k (1.3k)https://github.com/PowerShell/PowerShell/issues
Pull requests365 (365)https://github.com/PowerShell/PowerShell/pulls
Discussionshttps://github.com/PowerShell/PowerShell/discussions
Actionshttps://github.com/PowerShell/PowerShell/actions
Projectshttps://github.com/PowerShell/PowerShell/projects
Security and quality3 (3)https://github.com/PowerShell/PowerShell/security
Insightshttps://github.com/PowerShell/PowerShell/insights
https://github.com/PowerShell/PowerShell
New issuehttps://github.com/login?return_to=https://github.com/PowerShell/PowerShell/issues/8862
New issuehttps://github.com/login?return_to=https://github.com/PowerShell/PowerShell/issues/8862
Feature Request: Add OutputType parameter to Import-Csv https://github.com/PowerShell/PowerShell/issues/8862#top
Issue-Enhancementthe issue is more of a feature request than a bughttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Issue-Enhancement%22
Resolution-No ActivityIssue has had no activity for 6 months or morehttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Resolution-No%20Activity%22
https://github.com/powercode
Staffan Gustafsson (powercode)https://github.com/powercode
on Feb 10, 2019https://github.com/PowerShell/PowerShell/issues/8862#issue-408595733
#8860https://github.com/PowerShell/PowerShell/pull/8860
Staffan Gustafsson (powercode)https://github.com/powercode
Issue-Enhancementthe issue is more of a feature request than a bughttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Issue-Enhancement%22
on Feb 10, 2019https://github.com/PowerShell/PowerShell/issues/8862#event-2129484490
https://github.com/powercode
Staffan Gustafsson (powercode)https://github.com/powercode
on Mar 13, 2019https://github.com/PowerShell/PowerShell/issues/8862#issuecomment-472638663
https://github.com/mklement0
Michael Klement (mklement0)https://github.com/mklement0
on Nov 9, 2019https://github.com/PowerShell/PowerShell/issues/8862#issuecomment-552116940
https://github.com/mklement0
Michael Klement (mklement0)https://github.com/mklement0
on Nov 9, 2019https://github.com/PowerShell/PowerShell/issues/8862#issuecomment-552121936
https://stackoverflow.com/q/58660818/45375https://stackoverflow.com/q/58660818/45375
https://camo.githubusercontent.com/86d1bf2ec867a4f1fbc5c508a0756272ccf974c86e423ec78fdc281d39061307/68747470733a2f2f63646e2e737374617469632e6e65742f53697465732f737461636b6f766572666c6f772f696d672f6170706c652d746f7563682d69636f6e40322e706e673f763d373364373961383962646564
Memory exception while filtering large CSV fileshttps://stackoverflow.com/questions/58660818/memory-exception-while-filtering-large-csv-files
https://github.com/mklement0
Michael Klement (mklement0)https://github.com/mklement0
on Feb 22, 2020https://github.com/PowerShell/PowerShell/issues/8862#issuecomment-589992430
https://stackoverflow.com/a/60356120/45375https://stackoverflow.com/a/60356120/45375
https://camo.githubusercontent.com/86d1bf2ec867a4f1fbc5c508a0756272ccf974c86e423ec78fdc281d39061307/68747470733a2f2f63646e2e737374617469632e6e65742f53697465732f737461636b6f766572666c6f772f696d672f6170706c652d746f7563682d69636f6e40322e706e673f763d373364373961383962646564
PowerShell: Importing 16MB CSV Into PowerShell Variable Creates >600MB's of PowerShell Memory Usagehttps://stackoverflow.com/questions/60353691/powershell-importing-16mb-csv-into-powershell-variable-creates-600mbs-of-powe
https://github.com/iRon7
iRon7https://github.com/iRon7
on Feb 23, 2020https://github.com/PowerShell/PowerShell/issues/8862#issuecomment-590051704
https://github.com/iRon7
iRon7https://github.com/iRon7
on Feb 23, 2020https://github.com/PowerShell/PowerShell/issues/8862#issuecomment-590070348
https://github.com/mklement0
Michael Klement (mklement0)https://github.com/mklement0
on Feb 23, 2020https://github.com/PowerShell/PowerShell/issues/8862#issuecomment-590099364
iRon7https://github.com/iRon7
Ilya (@iSazonov)https://github.com/iSazonov
Integrate IDataView  #8855https://github.com/PowerShell/PowerShell/issues/8855
Make ConvertFrom-Csv and Import-Csv support outputting (ordered) hashtables as an alternative to custom objects #11027https://github.com/PowerShell/PowerShell/issues/11027
#8860https://github.com/PowerShell/PowerShell/pull/8860
Christoph Bergmeister (@bergmeister)https://github.com/bergmeister
suggested beforehttps://github.com/PowerShell/PowerShell/pull/8860#issuecomment-462191253
https://github.com/iRon7
iRon7https://github.com/iRon7
on Jan 9, 2023https://github.com/PowerShell/PowerShell/issues/8862#issuecomment-1375847597
#11941https://github.com/PowerShell/PowerShell/issues/11941
https://github.com/apps/microsoft-github-policy-service
microsoft-github-policy-servicehttps://github.com/apps/microsoft-github-policy-service
on Nov 16, 2023https://github.com/PowerShell/PowerShell/issues/8862#issuecomment-1813848952
Microsoft GitHub Policy Servicehttps://aka.ms/1es-gitops
https://github.com/apps/microsoft-github-policy-service
microsoft-github-policy-servicehttps://github.com/apps/microsoft-github-policy-service
on Nov 16, 2023https://github.com/PowerShell/PowerShell/issues/8862#issuecomment-1813848956
Microsoft GitHub Policy Servicehttps://aka.ms/1es-gitops
https://github.com/apps/microsoft-github-policy-service
microsoft-github-policy-servicehttps://github.com/apps/microsoft-github-policy-service
on Nov 16, 2023https://github.com/PowerShell/PowerShell/issues/8862#issuecomment-1813848957
Microsoft GitHub Policy Servicehttps://aka.ms/1es-gitops
microsoft-github-policy-servicehttps://github.com/apps/microsoft-github-policy-service
Resolution-No ActivityIssue has had no activity for 6 months or morehttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Resolution-No%20Activity%22
on Nov 16, 2023https://github.com/PowerShell/PowerShell/issues/8862#event-10976177799
https://github.com/apps/microsoft-github-policy-service
microsoft-github-policy-servicehttps://github.com/apps/microsoft-github-policy-service
on Nov 23, 2023https://github.com/PowerShell/PowerShell/issues/8862#issuecomment-1824375817
Microsoft GitHub Policy Servicehttps://aka.ms/1es-gitops
microsoft-github-policy-servicehttps://github.com/apps/microsoft-github-policy-service
completedhttps://github.com/PowerShell/PowerShell/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Nov 23, 2023https://github.com/PowerShell/PowerShell/issues/8862#event-11047323588
Sign up for freehttps://github.com/signup?return_to=https://github.com/PowerShell/PowerShell/issues/8862
Sign in to commenthttps://github.com/login?return_to=https://github.com/PowerShell/PowerShell/issues/8862
Issue-Enhancementthe issue is more of a feature request than a bughttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Issue-Enhancement%22
Resolution-No ActivityIssue has had no activity for 6 months or morehttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Resolution-No%20Activity%22
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.