René's URL Explorer Experiment


Title: Import Table from CSV is Not Preserving Quoted Values as Text · Issue #1382 · sqlitebrowser/sqlitebrowser · GitHub

Open Graph Title: Import Table from CSV is Not Preserving Quoted Values as Text · Issue #1382 · sqlitebrowser/sqlitebrowser

X Title: Import Table from CSV is Not Preserving Quoted Values as Text · Issue #1382 · sqlitebrowser/sqlitebrowser

Description: Details for the issue Problem: Import Table from CSV is not preserving quoted values as text. Using Import - Table from CSV File, I am trying to import this csv file into an empty database. Values are double quoted to indicate that they ...

Open Graph Description: Details for the issue Problem: Import Table from CSV is not preserving quoted values as text. Using Import - Table from CSV File, I am trying to import this csv file into an empty database. Values ...

X Description: Details for the issue Problem: Import Table from CSV is not preserving quoted values as text. Using Import - Table from CSV File, I am trying to import this csv file into an empty database. Values ...

Opengraph URL: https://github.com/sqlitebrowser/sqlitebrowser/issues/1382

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Import Table from CSV is Not Preserving Quoted Values as Text","articleBody":"### Details for the issue\r\n\r\nProblem: Import Table from CSV is not preserving quoted values as text.\r\n\r\nUsing Import - Table from CSV File, I am trying to import [this csv file](https://github.com/frankpd/storage/blob/master/ruralurbancodes2013.csv) into an empty database. Values are double quoted to indicate that they should be preserved as text - for example, the FIPS column contains values that are five digit numbers with leading zeros, and these values are all double quoted.\r\n\r\nWhen I import CSV, I leave the default quote character choice as double quotes, and the FIPS values I see in the preview look fine. But when I hit OK, it does the import and saves this column as an Integer, ignoring the double quotes. As a result the leading zeros from the values are dropped and the codes are no longer correct.\r\n\r\nI tried all of the following, with no effect: leaving the trim option off, going under View - Preferences - Database and changing the default field type from Integer to Text, adding an integer id column in the CSV before the FIPS column (in case the first column is reserved as an integer key column), using single instead of double quotes to preserve text.\r\n\r\nI'm using Version 3.10.99 SQLite Version 3.11.0. I'm running 64-bit Linux Mint 18.2 and am using the linuxgndu sqlitebrowser for ubuntu xenial.\r\n\r\n![import_csv](https://user-images.githubusercontent.com/25231294/39825280-b8f7d22e-53b1-11e8-8ce3-156b3741df07.png)\r\n![import_integers](https://user-images.githubusercontent.com/25231294/39825285-bd005648-53b1-11e8-9442-d740589ef060.png)\r\n![zeros_dropped](https://user-images.githubusercontent.com/25231294/39825453-161e626a-53b2-11e8-8025-efd62b40d3b4.png)\r\n\r\n### Useful extra information\r\n\r\n\u003c!-- The info below often helps, please fill it out if you're able to. :) -->\r\n\r\n#### I'm opening this issue because:\r\n\r\n- [ ] DB4S is crashing\r\n- [ x] DB4S has a bug\r\n- [ ] DB4S needs a feature\r\n- [ ] DB4S has another problem\r\n\r\n#### I'm using DB4S on:\r\n\r\n- [ ] Windows: ( _version:_ ___ )\r\n- [x ] Linux: ( _distro:_ ubuntu xenial___ )\r\n- [ ] Mac OS: ( _version:_ ___ )\r\n- [ ] Other: ___\r\n\r\n#### I'm using DB4S version:\r\n\r\n- [ ] 3.10.1\r\n- [ ] 3.10.0\r\n- [ ] 3.9.1\r\n- [ x] Other: _3.10.99__\r\n\r\n#### I have also:\r\n\r\n- [ ] Tried out the latest nightly version: https://github.com/sqlitebrowser/sqlitebrowser#nightly-builds\r\n- [x ] Searched for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20\r\n","author":{"url":"https://github.com/frankpd","@type":"Person","name":"frankpd"},"datePublished":"2018-05-09T16:06:48Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/1382"}

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:53fb97c9-d571-ca84-0f02-22baffb5ed4d
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idB2DC:13288B:18A291:20AB02:6AFD1103
html-safe-noncee49fc437ac3f50fddb3f7102111265b30ed79e4187fb5841bae18779529dfde3
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCMkRDOjEzMjg4QjoxOEEyOTE6MjBBQjAyOjZBRkQxMTAzIiwidmlzaXRvcl9pZCI6IjMyOTY1NjQ5NzY4OTc4MjI5NzkiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmace8bbd824f078dca4beb4f10a074f3a247cab776fe184a8a54e5def52428aa1e6
hovercard-subject-tagissue:321632687
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/sqlitebrowser/sqlitebrowser/1382/issue_layout
twitter:imagehttps://opengraph.githubassets.com/25b2f6b654094665a1484e01ae6330c474fcc83d3fa8e160d24de31a89cf8744/sqlitebrowser/sqlitebrowser/issues/1382
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/25b2f6b654094665a1484e01ae6330c474fcc83d3fa8e160d24de31a89cf8744/sqlitebrowser/sqlitebrowser/issues/1382
og:image:altDetails for the issue Problem: Import Table from CSV is not preserving quoted values as text. Using Import - Table from CSV File, I am trying to import this csv file into an empty database. Values ...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamefrankpd
hostnamegithub.com
expected-hostnamegithub.com
None7c34e25df4e46e972c8f0225e63410231bdeb9ea5634597c712796bbcdb2e627
turbo-cache-controlno-preview
go-importgithub.com/sqlitebrowser/sqlitebrowser git https://github.com/sqlitebrowser/sqlitebrowser.git
octolytics-dimension-user_id7454271
octolytics-dimension-user_loginsqlitebrowser
octolytics-dimension-repository_id19416551
octolytics-dimension-repository_nwosqlitebrowser/sqlitebrowser
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id19416551
octolytics-dimension-repository_network_root_nwosqlitebrowser/sqlitebrowser
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
release8fa571ebaa95e4e6bf872197c0e84b7dc48e6785
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlitebrowser/sqlitebrowser/issues/1382#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F1382
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%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F1382
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=sqlitebrowser%2Fsqlitebrowser
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1382
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1382
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1382
sqlitebrowserhttps://github.com/sqlitebrowser
sqlitebrowserhttps://github.com/sqlitebrowser/sqlitebrowser
Codehttps://github.com/sqlitebrowser/sqlitebrowser
Issues786 (786)https://github.com/sqlitebrowser/sqlitebrowser/issues
Pull requests30 (30)https://github.com/sqlitebrowser/sqlitebrowser/pulls
Discussionshttps://github.com/sqlitebrowser/sqlitebrowser/discussions
Actionshttps://github.com/sqlitebrowser/sqlitebrowser/actions
Projectshttps://github.com/sqlitebrowser/sqlitebrowser/projects
Wikihttps://github.com/sqlitebrowser/sqlitebrowser/wiki
Security and qualityhttps://github.com/sqlitebrowser/sqlitebrowser/security
Insightshttps://github.com/sqlitebrowser/sqlitebrowser/insights
https://github.com/sqlitebrowser/sqlitebrowser
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1382
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1382
#4246https://github.com/sqlitebrowser/sqlitebrowser/pull/4246
Import Table from CSV is Not Preserving Quoted Values as Texthttps://github.com/sqlitebrowser/sqlitebrowser/issues/1382#top
#4246https://github.com/sqlitebrowser/sqlitebrowser/pull/4246
bugConfirmed bugs or reports that are very likely to be bugs.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22bug%22
https://github.com/frankpd
frankpdhttps://github.com/frankpd
on May 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issue-321632687
this csv filehttps://github.com/frankpd/storage/blob/master/ruralurbancodes2013.csv
https://user-images.githubusercontent.com/25231294/39825280-b8f7d22e-53b1-11e8-8ce3-156b3741df07.png
https://user-images.githubusercontent.com/25231294/39825285-bd005648-53b1-11e8-9442-d740589ef060.png
https://user-images.githubusercontent.com/25231294/39825453-161e626a-53b2-11e8-8025-efd62b40d3b4.png
https://github.com/sqlitebrowser/sqlitebrowser#nightly-buildshttps://github.com/sqlitebrowser/sqlitebrowser#nightly-builds
https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20
https://github.com/chrisjlocke
chrisjlockehttps://github.com/chrisjlocke
on May 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-387801756
https://github.com/chrisjlocke
chrisjlockehttps://github.com/chrisjlocke
on May 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-387803576
https://user-images.githubusercontent.com/7872218/39827959-5ccd8188-53b1-11e8-8774-4f324fadd531.png
https://github.com/frankpd
frankpdhttps://github.com/frankpd
on May 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-387812724
https://github.com/karim
karimhttps://github.com/karim
on May 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-387821968
https://github.com/frankpd
frankpdhttps://github.com/frankpd
on May 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-387835081
@karimhttps://github.com/karim
https://github.com/karim
karimhttps://github.com/karim
on May 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-387839307
https://user-images.githubusercontent.com/8761081/39833370-24ebce64-53ca-11e8-9ecc-eefaf9e64e4d.jpg
https://user-images.githubusercontent.com/8761081/39833384-2d49965e-53ca-11e8-9a52-b17e50194aeb.jpg
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on May 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-387846666
@MKleusberghttps://github.com/MKleusberg
@frankpdhttps://github.com/frankpd
justinclifthttps://github.com/justinclift
bugConfirmed bugs or reports that are very likely to be bugs.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22bug%22
on May 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#event-1618383509
https://github.com/sky5walk
sky5walkhttps://github.com/sky5walk
on May 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-387854416
https://github.com/frankpd
frankpdhttps://github.com/frankpd
on May 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-387855005
@justinclifthttps://github.com/justinclift
https://launchpad.net/~linuxgndu/+archive/ubuntu/sqlitebrowserhttps://launchpad.net/~linuxgndu/+archive/ubuntu/sqlitebrowser
https://github.com/karim
karimhttps://github.com/karim
on May 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-387859854
@justinclifthttps://github.com/justinclift
questionhttps://www.sqlite.org/faq.html#q3
https://github.com/karim
karimhttps://github.com/karim
on May 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-387862014
@frankpdhttps://github.com/frankpd
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on May 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-387864560
@sky5walkhttps://github.com/sky5walk
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on May 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-387865002
@frankpdhttps://github.com/frankpd
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on May 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-387865778
@karimhttps://github.com/karim
https://data.gov.uk/dataset/7ec10db7-c8f4-4a40-8d82-8921935b4865/national-statistics-postcode-lookup-ukhttps://data.gov.uk/dataset/7ec10db7-c8f4-4a40-8d82-8921935b4865/national-statistics-postcode-lookup-uk
https://github.com/karim
karimhttps://github.com/karim
on May 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-387871979
@justinclifthttps://github.com/justinclift
@frankpdhttps://github.com/frankpd
https://github.com/frankpd
frankpdhttps://github.com/frankpd
on May 10, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-388166553
@karimhttps://github.com/karim
https://github.com/karim
karimhttps://github.com/karim
on May 10, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-388185995
@frankpdhttps://github.com/frankpd
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on May 25, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-392165789
@justinclifthttps://github.com/justinclift
#1395https://github.com/sqlitebrowser/sqlitebrowser/issues/1395
MKleusberghttps://github.com/MKleusberg
on May 25, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#event-1647404445
Add option to disable automatic type detection in CSV importhttps://github.com/sqlitebrowser/sqlitebrowser/commit/3995ad2442a22029bcf75e618d42c9d716ff1d98
3995ad2https://github.com/sqlitebrowser/sqlitebrowser/commit/3995ad2442a22029bcf75e618d42c9d716ff1d98
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on May 25, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-392167869
herehttps://github.com/sqlitebrowser/sqlitebrowser/issues/1395#issuecomment-392154933
@frankpdhttps://github.com/frankpd
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on May 26, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-392254309
https://data.gov.uk/dataset/7ec10db7-c8f4-4a40-8d82-8921935b4865/national-statistics-postcode-lookup-ukhttps://data.gov.uk/dataset/7ec10db7-c8f4-4a40-8d82-8921935b4865/national-statistics-postcode-lookup-uk
https://github.com/sky5walk
sky5walkhttps://github.com/sky5walk
on May 26, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-392262163
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on May 26, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-392266558
https://www.backblaze.com/b2/hard-drive-test-data.htmlhttps://www.backblaze.com/b2/hard-drive-test-data.html
https://github.com/frankpd
frankpdhttps://github.com/frankpd
on May 29, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-392801848
@MKleusberghttps://github.com/MKleusberg
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on May 29, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-392820454
https://github.com/sky5walk
sky5walkhttps://github.com/sky5walk
on May 29, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#issuecomment-392851361
MKleusberghttps://github.com/MKleusberg
on Jun 7, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1382#event-1669037199
Add option to disable automatic type detection in CSV importhttps://github.com/sqlitebrowser/sqlitebrowser/commit/108bcc30a2720496e256bbce7c2f9ecf12d8d84a
108bcc3https://github.com/sqlitebrowser/sqlitebrowser/commit/108bcc30a2720496e256bbce7c2f9ecf12d8d84a
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1382
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1382
bugConfirmed bugs or reports that are very likely to be bugs.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22bug%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.