Releases: dathere/qsv-pro-releases
v0.5.0
qsv pro (preview) v0.5.0
✨ What's new in v0.5.0? Click here to find out! 🔍
This update has many changes. Here are a few highlights (see below for more details):
- Upgraded qsv to v0.128.0
- New search feature - search records for matches using regex
- SQL query feature updates
- Save search matches output and SQL query output to a file with multiple available file formats (CSV, TSV, TAB, JSON, JSONL, Parquet, Arrow, Avro, etc.)
- Configurator update - copy a full command to clipboard with a simple Copy command button
New search feature
- Search your entire spreadsheet for matches (powered by
qsv search
) - Search by all columns or a specific column
- Toggle case sensitivity
- Matched rows are highlighted and occasionally matched text within rows are also highlighted
- Skip forward and backward to pages that have matches
- Save matches to a file with multiple available file formats (CSV, TSV, TAB, JSON, JSONL, Parquet, Arrow, Avro, etc.) with error handling
- Cancel an ongoing search with the Cancel button
- Experimental Autosearch feature (enable in settings) with customizable delay time
Data table interactive cell expansion/truncation & vertical borders
- Click on a truncated cell to expand its contents and click again to truncate again. You can also perform this action on the frequency headers.
- Added a switch to toggle vertical column borders for all data tables.
SQL query export to file & cancel button
- Save output to a file with multiple available file formats (CSV, TSV, TAB, JSON, JSONL, Parquet, Arrow, Avro, etc.) with error handling
- Cancel an ongoing SQL query with the Cancel button
Configurator copy to clipboard & updates
- Automatically display qsv subcommand, arguments, and options as part of a command
- Copy full command to clipboard with a simple "Copy command" button (e.g., paste it into your terminal to use it with qsv directly if you have qsv already installed)
- Display estimated elapsed time for command run
Other changes
- Workflow header hidden when a file is imported
- Data table card hidden when a file is imported, moved Choose file button beside CKAN upload button
- Add step to generate index file after screening and before pre-analysis
- Clarify durations and timestamps may be estimates for action logs.
- Estimated total processing time displayed beside file path
- Updated action logs, including additional logs when a search or SQL query is performed
- Displaying informational toast about how to scroll a data table horizontally by holding shift while scrolling
- Added note for
qsv sniff
potentially displaying incorrect output - Fix
--limit
option forqsv frequency
in Configurator - Modify stroke size for theme switch icon
- Update width for data table pagination arrows
- Mention frequency and decimal values may be estimations regardless of wrap rows toggle status
- Attempt to display "Purchase license key" in context menu only when user is on a trial
- Fix Configurator output by removing empty new lines
- Metadata subtabs switch to Basic when
qsv sniff
metadata is not available
👋 About qsv pro
Based on the qsv CLI toolkit, qsv pro is a data wrangling desktop app to interact between qsv and your spreadsheet files.
Want to learn about what qsv pro has to offer? Check out our promo website at qsvpro.dathere.com!
⬇ Download qsv pro (preview) v0.5.0 ⬇
Important note for Windows users (click here)
If you get a message about Windows protecting your PC like above, then you'll need to click More info then Run anyway as we currently don't have a certificate assigned to our Windows binaries.
- Windows
- macOS
- Linux
The .msi
, .exe
, .app
, and .AppImage
files are set up for automatically receiving the latest release's updates when you start up qsv pro.
By using qsv pro you agree to datHere's Terms and Conditions and Privacy Policy.
v0.4.3
qsv pro (preview) v0.4.3
✨ What's new in v0.4.3? Click here to find out! 🔍
This update has many changes. Here's a summary:
- Upgraded qsv to v0.127.0
- Show column frequency percentages on main data table and can be toggled with a switch
- Add a Wrap Text switch for all data tables (long data may be truncated with ellipsis by default)
- Add success toast and error toasts when running recipes
- Add
LIMIT 1000
to default SQL query due to potential issue when query output is too large. - Fix and add logos and reduce Workflow and Configurator header sizes
👋 About qsv pro
Based on the qsv CLI toolkit, qsv pro is a data wrangling desktop app to interact between qsv and your spreadsheet files.
Want to learn about what qsv pro has to offer? Check out our promo website at qsvpro.dathere.com!
⬇ Download qsv pro (preview) v0.4.3 ⬇
Important note for Windows users (click here)
If you get a message about Windows protecting your PC like above, then you'll need to click More info then Run anyway as we currently don't have a certificate assigned to our Windows binaries.
- Windows
- macOS
- Linux
The .msi
, .exe
, .app
, and .AppImage
files are set up for automatically receiving the latest release's updates when you start up qsv pro.
By using qsv pro you agree to datHere's Terms and Conditions and Privacy Policy.
v0.4.2
qsv pro (preview) v0.4.2
✨ What's new in v0.4.2? Click here to find out! 🔍
This update has several bugfixes, updates the qsv pro logo, and has several improvements for the CKAN upload workflow.
Bug fixes
- Fixed bug where CKAN upload workflow toasts showed
[object Object]
instead of relevant data - Fixed bug where files with empty headers were not immediately rejected
New qsv pro logo and animations
![logo datHere qsvpro primary dark bg@2x](https://private-user-images.githubusercontent.com/30333942/321078137-0715a02a-f7e0-439e-81b3-ce4258fbeb71.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjAzNTY5NTAsIm5iZiI6MTcyMDM1NjY1MCwicGF0aCI6Ii8zMDMzMzk0Mi8zMjEwNzgxMzctMDcxNWEwMmEtZjdlMC00MzllLTgxYjMtY2U0MjU4ZmJlYjcxLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA3MDclMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNzA3VDEyNTA1MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTFjMWE5Mzc3NzdmNDA1NjIzNWU1MjlmOTY3MGNmNTg3OTdjYjhiM2JkZGUxMjI0M2Y2MTVlNmQwNmMxM2Y3YzAmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.G95mgU9oBiPslYMbu-bJZoOUTFnxEprO7kQGHT88lbA)
![logo datHere qsvpro@2x](https://private-user-images.githubusercontent.com/30333942/321078139-7c55c728-9027-41b9-b677-9f42a20d1916.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjAzNTY5NTAsIm5iZiI6MTcyMDM1NjY1MCwicGF0aCI6Ii8zMDMzMzk0Mi8zMjEwNzgxMzktN2M1NWM3MjgtOTAyNy00MWI5LWI2NzctOWY0MmEyMGQxOTE2LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA3MDclMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNzA3VDEyNTA1MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTQwOGExMzJlZTk2NjY4MDNjNjc0ZWNjYmRkY2VmOGYzZjk4ZGZjMTYyNDZiYzQ0ZmVhNDE3YzNmZWJhOGIxNzkmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.-VRyCS1iPJLafMTERMK58WueWjyGIdoY51_tzVMs_1U)
- Update qsv pro logos and animations
- Add qsv pro logo to info modal
CKAN upload workflow
- Disable autocomplete for most CKAN upload workflow input text boxes
- Set extra details width to full for card containing instance/organization/dataset details
👋 About qsv pro
Based on the qsv CLI toolkit, qsv pro is a data wrangling desktop app to interact between qsv and your spreadsheet files.
Want to learn about what qsv pro has to offer? Check out our promo website at qsvpro.dathere.com!
⬇ Download qsv pro (preview) v0.4.2 ⬇
Important note for Windows users (click here)
If you get a message about Windows protecting your PC like above, then you'll need to click More info then Run anyway as we currently don't have a certificate assigned to our Windows binaries.
- Windows
- macOS
- Linux
The .msi
, .exe
, .app
, and .AppImage
files are set up for automatically receiving the latest release's updates when you start up qsv pro.
By using qsv pro you agree to datHere's Terms and Conditions and Privacy Policy.
v0.4.1
qsv pro (preview) v0.4.1
✨ What's new in v0.4.1? Click here to find out! 🔍
This update fixes an issue where the data table after running a SQL query may not change its headers to the appropriate names and row values (for example when using the AS
keyword or using aggregations like COUNT
). Headers should now display correctly.
👋 About qsv pro
Based on the qsv CLI toolkit, qsv pro is a data wrangling desktop app to interact between qsv and your spreadsheet files.
Want to learn about what qsv pro has to offer? Check out our promo website at qsvpro.dathere.com!
⬇ Download qsv pro (preview) v0.4.1 ⬇
Important note for Windows users (click here)
If you get a message about Windows protecting your PC like above, then you'll need to click More info then Run anyway as we currently don't have a certificate assigned to our Windows binaries.
- Windows
- macOS
- Linux
The .msi
, .exe
, .app
, and .AppImage
files are set up for automatically receiving the latest release's updates when you start up qsv pro.
By using qsv pro you agree to datHere's Terms and Conditions and Privacy Policy.
v0.4.0
qsv pro (preview) v0.4.0
✨ What's new in v0.4.0? Click here to find out! 🔍
Overview
This update's primary changes include:
- A SQL query interface for running Polars SQL queries on your CSV data using
qsv sqlp
, including syntax highlighting and a data table for query results - Updating qsv v0.123.0 to v0.125.0
- Removing flickering when paginating data tables
SQL Query Interface
SQL users may find this an awaited feature that's now available!
After your spreadsheet data is loaded, you may click on the "SQL Query" tab to run a Polars SQL query on your data (which uses qsv sqlp
). Make sure you refer to your spreadsheet as a table named _t_1
when running queries.
Seamless pagination
Previous versions of qsv pro may have shown flickering when paginating the main data table for viewing your spreadsheet data. This flickering should now no longer exist!
👋 About qsv pro
Based on the qsv CLI toolkit, qsv pro is a data wrangling desktop app to interact between qsv and your spreadsheet files.
Want to learn about what qsv pro has to offer? Check out our promo website at qsvpro.dathere.com!
⬇ Download qsv pro (preview) v0.4.0 ⬇
Important note for Windows users (click here)
If you get a message about Windows protecting your PC like above, then you'll need to click More info then Run anyway as we currently don't have a certificate assigned to our Windows binaries.
- Windows
- macOS
- Linux
The .msi
, .exe
, .app
, and .AppImage
files are set up for automatically receiving the latest release's updates when you start up qsv pro.
By using qsv pro you agree to datHere's Terms and Conditions and Privacy Policy.
v0.3.1
qsv pro (preview) v0.3.1
✨ What's new in v0.3.1? Click here to find out! 🔍
Overview
- Fixed issue where when creating a new dataset, the auto-generated name is not allowed without modifying it.
- Fixed issue where when creating a new dataset, an error occurs when leaving the description blank.
- Attempted to fix modal height to prevent clipping.
👋 About qsv pro
Based on the qsv CLI toolkit, qsv pro is a data wrangling desktop app to interact between qsv and your spreadsheet files.
Want to learn about what qsv pro has to offer? Check out our promo website at qsvpro.dathere.com!
⬇ Download qsv pro (preview) v0.3.1 ⬇
Important note for Windows users (click here)
If you get a message about Windows protecting your PC like above, then you'll need to click More info then Run anyway as we currently don't have a certificate assigned to our Windows binaries.
- Windows
- macOS
- Linux
The .msi
, .exe
, .app
, and .AppImage
files are set up for automatically receiving the latest release's updates when you start up qsv pro.
By using qsv pro you agree to datHere's Terms and Conditions and Privacy Policy.
v0.3.0
qsv pro (preview) v0.3.0
✨ What's new in v0.3.0? Click here to find out! 🔍
Overview
This update includes new major features:
- 🚀 Updating from qsv 0.122.0 to qsv 0.123.0
- 🌟 New CKAN upload workflow
- 🍞 New toasts
- 🌪 New load up animations (different animations for light theme and dark theme)
- 📎 New context menu icons and copy to clipboard button
New CKAN upload workflow ☁
Once you've dropped a file into qsv pro's Workflow feature, upload your spreadsheet to CKAN by clicking the "Upload to CKAN" button.
Now check out the new workflow's features:
- Add a new remote instance to your local instance list and search & select from them
- Search & select an organization that you have access to create a dataset in, along with viewing various organization details
- Create a new dataset along with its title, name, description, and whether to make it private or public
- Search & select a dataset you have access to along with viewing various dataset details
- Create a new resource along with specifying its name and description
- Replace an existing resource by searching & selecting from them, along with viewing various resource details
Want to see what all these features look like? Try out qsv pro today!
New toasts
Toasts have been updated and last longer (the demo GIF shown below is cut short intentionally).
New loadup animations
When you launch qsv pro, you should now see an animation and a fade into the next screen. Animations are available for both light and dark mode.
Context menu icons & copy to clipboard
When you right-click in qsv pro, a context menu appears but now with new icons.
Not only are icons available, but when you're able to select text then open the context menu, there should be a Copy button to copy the selected text to your clipboard.
Other notes
Various other bug fixes and improvements have been made.
👋 About qsv pro
Based on the qsv CLI toolkit, qsv pro is a data wrangling desktop app to interact between qsv and your spreadsheet files.
Want to learn about what qsv pro has to offer? Check out our promo website at qsvpro.dathere.com!
⬇ Download qsv pro (preview) v0.3.0 ⬇
Important note for Windows users (click here)
If you get a message about Windows protecting your PC like above, then you'll need to click More info then Run anyway as we currently don't have a certificate assigned to our Windows binaries.
- Windows
- macOS
- Linux
The .msi
, .exe
, .app
, and .AppImage
files are set up for automatically receiving the latest release's updates when you start up qsv pro.
By using qsv pro you agree to datHere's Terms and Conditions and Privacy Policy.
v0.2.5
qsv pro (preview) v0.2.5
What's new in v0.2.5? Click here to find out!
Overview
This update primarily fixes the main data table page count, moves metadata into a new tab with its own data tables, shows qsv --version
output in the new info modal, and updates qsv to v0.122.0.
New metadata tab
File metadata has been moved to a new tab with two data tables, including basic information and qsv sniff
output data when output is available. The file name and path is now available where file metadata was located in previous versions of qsv pro.
New info modal
Clicking the info icon on the top right now opens a modal with an FAQ section and the qsv --version
output.
👋 About qsv pro
Based on the qsv CLI toolkit, qsv pro is a data wrangling desktop app to interact between qsv and your spreadsheet files.
Want to learn about what qsv pro has to offer? Check out our new promo website at qsvpro.dathere.com!
⬇ Download qsv pro (preview) v0.2.5 ⬇
Important note for Windows users (click here)
If you get a message about Windows protecting your PC like above, then you'll need to click More info then Run anyway as we currently don't have a certificate assigned to our Windows binaries.
- Windows
- macOS
- Linux
The .msi
, .exe
, .app
, and .AppImage
files are set up for automatically receiving the latest release's updates when you start up qsv pro.
By using qsv pro you agree to datHere's Terms and Conditions and Privacy Policy.
v0.2.4
qsv pro (preview) v0.2.4
What's new in v0.2.4? Click here to find out!
Overview
This update includes a bug fix regarding stats and frequency tabs occasionally being unviewable. The qsv pro binary size may also be reduced.
👋 About qsv pro
Based on the qsv CLI toolkit, qsv pro is a data wrangling desktop app to interact between qsv and your spreadsheet files.
Want to learn about what qsv pro has to offer? Check out our new promo website at qsvpro.dathere.com!
⬇ Download qsv pro (preview) v0.2.4 ⬇
Important note for Windows users (click here)
If you get a message about Windows protecting your PC like above, then you'll need to click More info then Run anyway as we currently don't have a certificate assigned to our Windows binaries.
- Windows
- macOS
- Linux
The .msi
, .exe
, .app
, and .AppImage
files are set up for automatically receiving the latest release's updates when you start up qsv pro.
By using qsv pro you agree to datHere's Terms and Conditions and Privacy Policy.
v0.2.3
qsv pro (preview) v0.2.3
What's new in v0.2.3? Click here to find out!
Overview
This update includes a bug fix regarding commas within cells being considered column separators when they should not.
👋 About qsv pro
Based on the qsv CLI toolkit, qsv pro is a data wrangling desktop app to interact between qsv and your spreadsheet files.
Want to learn about what qsv pro has to offer? Check out our new promo website at qsvpro.dathere.com!
⬇ Download qsv pro (preview) v0.2.3 ⬇
Important note for Windows users (click here)
If you get a message about Windows protecting your PC like above, then you'll need to click More info then Run anyway as we currently don't have a certificate assigned to our Windows binaries.
- Windows
- macOS
- Linux
The .msi
, .exe
, .app
, and .AppImage
files are set up for automatically receiving the latest release's updates when you start up qsv pro.
By using qsv pro you agree to datHere's Terms and Conditions and Privacy Policy.