Non consitent behavior, application seems to freeze
Unsaved changed code page
I am sorry to hear that you have issues, its unclear to me why the application would use 600 MB unless you have loaded very large file. The application shows with with 14.5 MB on my task manager. The .Net 7 version has s lower footprint. While the routines for reading the data do not use much memory storing the data and display in the gid is quite expensive. Still 600 MB is extrem.
Increased needed certainty for code page, otherwise UTF 8 is used
Encoding detection seems off
Encoding detection seems off
Changes are now persistent for all settings that are possibly determined by inspection. This includes Code Page, BOM, Delimiter, Skip Rows, Qualifier/Quoting, Line Comment, Header and Escape Seqence
Unsaved changed code page
The application is adjusted you can now set the defaults to be used without inspection of the files. Simply disable all inspections. This way you can speed up process of showing data. The inspection was meant to ease the process the application would check the file and make the settings for you. This indeed takes time, but for me it was much faster than trying to figure these things out myself, as I have files for all region and all flavors. If you know you will always have the same kind of files...
"Index was outside the bounds of the array
I could not reproduce the issue after copying the posted text into a file. I do seehowever that the column amount is not recognized as numeric. I will keep this ticket open until I have found a way to recognize this as numeric. This might take some time tough.
Unsaved changed code page
Every time a file is opened the application will determine the code page unless "Determine Code Pages" is unchecked. The issue is that the selected code page is not persisted and therefor not used the next time a file is opened without detecting a code page. I now realize that I have never used the application without code page detection, the code page detection is very good thanks to the nuget package UTF.Unknown and I get files with all different encodings so I never had the need to change these...
"Index was outside the bounds of the array
I will look into this
Font size
Configuration is not saved
Sorry thought about how to build this, but its not that easy. I am not a UI developer, as you possibly see by the design, my main focus was to have an intelligent parser for delimited text. There are components our there that do have a lot of functionality and that would support this, but these are usually paid component collections, these would make my life easier but are not cheap.
Checking for an updated version is now removed. Updates has to be done manually.
Malware in file
This is a strange conversation I seem to have, I think it's a false positive. Please understand that I will not react all your comments in each post and reviews Hmmm. It's not that I do not value your oppionion, but repeating it over and over its tiresome. I have done what I can to address your issue, but you cannot fight the Spanish inquisition...
Font size
Configuration is not saved
Display row number for every row
There is a setting to add the record number similar to the line number, this adds artifical columns that you can filter if needed. It's in the setting under "Behaviour and Warning" properties are "Add Column for Line Number" and "Add Column for Record Number"
Seems to swallow line
I have tested this and made a small adjustment: If not all data is loaded, the buttons with additional functionality are disabled this should make it more prominent that data is missing. Otherwise please adjust the setting and "unlimited" as Limit for processing, the data will only show once all is loaded in this case.
Thanks for the program under a free open source license!
Configuration is not saved
Flagged as malware,
I am closing the discussion on this there is nothing i can do.
does not support sep=x first line
I have added a recognition of the delimiter by looking at the first line.
Sorting by multiple columns
Sorry thought about how to build this, but its not that easy.
Settings for display style
Font Size and Font Familiy can now be choosen
Please add a graphical display of the table
This is a very special request there are so many questions to ask but it wuld be very complex to build something for that. I suggest you copy and paste the daa in excel. The quickviewer does a nice job there as what you paste are proper values.
Flagged as malware,
First I thought its caused by combining dll and executable into one executable, but that's not causing the issue... It looks like an included DLL (FastColoredTextBox.dll) is either infected or shown as infected. FastColoredTextBox is available in source code on GitHub, I will rebuilt it from scratch replace the dll in the application.
Seems to swallow line
Hello Karl, There is a setting called "Limit for processing initial open" . This has been added since opening very big files could takes ages and there is no nice way to have a peek. If you open a file after the set amount of time the viewer stops and shows what it has read so far. The display of records is blue and there is a button next to it to load the remaining records. This would explain why you see a variable number of records very time you open the file. Currently the settings in the UI does...
Date time sorting
Font size
Hello Yearling, I think i now know what is happening... Please open the file again and see the log (glasses icon) The logs for the file shows: ... 21:59:52 "Time" – 4 values found in 4 rows. Not enough sample values – Format : "Text" 21:59:52 "BootTime" – 4 values found in 4 rows. Not enough sample values – Format : "Text" 21:59:52 "UserDomain" – 4 values found in 4 rows. Not enough sample values – Format : "Text" ... 21:59:52 "RAM" – 4 values found in 4 rows. Not enough sample values – Format :...
I have made adjustments I hope the changes are now persisted properly.
Hello Yearling I did not put much thought into it. this file is simply the jason serialization of the internal class, The automated detection would be in the section "fillGuessSettings". if disabled you should have a enabled: "false" in there. Any default value will not be stored and the default is true, so you do not see a lot of these entries. I guess I have never checked the application with automated detection disabled. The detection is so fast that I did never turn it off and if i wanted to...
Hello Yearling, Settings should be persisted under %appdata%\CSVQuickViewer in Setting.json along with old versions of teh file. As the application is closed it tries to save, if that would fail, the closing process is not halted. Maybe the application does not have sufficient rights to store the data.
The issue should be fixed in the new release, the filter does show the values in local user settings but filtering must be done in english locale.
Hello Yearling, Thank you for point this out, I will look into this. When a date or number format is recognized the columns are right bound and displayed in blue, for these columns there should be special filter menu... I could reproduce behaviour you described in the latest version, this is defiantly not correct. Once I have a fix I will update the release.
Hello Yearling, the setting is only just now published and working (V1.6.27.550), I had some issue that the font change was not reflecting properly in the datagrid.
.NET 6.0 is not yet widely distributed. I have added the ability to choose font and size on the setting page this should work in any version of .NET. A side effect could be that the initial display in Tahoma 8 pt might not be optimal, but I had to choose one... Note: I do not see the latest release on sourceforge yet, it takes some time for the reases to be pushed from Github to Sourceforge.
.NET 6.0 is not yet widely distributed. I have added the ability to choose font and size on the setting page this should work in any version of .NET. A side effect could be that the initial display in Tahoma 8 pt might not be optimal, but I had to choose one...
In older versions you could dynamically change the fontsize with the mouse weel like a zoom,but that did not look good and it was not persistent.... So i removed it. I will add a setting for it in the next version. May I ask if you use the .Net 6 or .Net 4.72. High DPI support should be better in .NET 6 but honestly I did not try it as I do not have a high resolution screen.
Unchecking Has Column Headers on delimited file without headers does not refresh the UI to show generic column headers
Fixed in V1.6.4.434
I want to pay somebody to create a custom FLOSS multi-user CSV viewer with special functions
The quickviewer will still not protect the file from beeing chnaged but the application does now support saving changes, the resulting fileshould logically match but formatting could be very different, as the application does only mimic the import format.
does not support sep=x first line
Updater fails after launch "unable to connect to remote server"
Checking for an updated version is now removed. Nay update has to be done manually.
Unchecking Has Column Headers on delimited file without headers does not refresh the UI to show generic column headers
Sorry for the inconvinience it should now ask you if you want to relaod the data after some time.
The idea of the quick viewer was to determine the delimiter on its own, usually resolving the right delimiter is a relatively quick process as it only reads the first 100 lines to make a decision. The row with the information should actually be skipped. In one of the next versions I will take it into consideration how to best support this though.
The CSV Quick Viewer will not lock files, however the CSV Quick Viewer will notice that an opened file has changed and will ask you to update the display. I deliberately wanted to avoid writing files as writing back changes to the content might change the file structure and possibly add quotes or remove trailing delimiters etc. anything that had an issue being read would be lost, I do not want to take the risk.
The CSV Quick Viewer will not lock files, however the CSV Quick Viewer will notice that an opened file has changed and will ask you to update the display. I deliberately wanted to avoid writing files as writing back changes to the content might change the file structure and possibly add quotes or remove training delimiters etc. anything that had an issue being read would be lost, I do not want to take the risk.