#17 "Index was outside the bounds of the array

[cafa]

Not working for me. My bank's (more than 7) CSV files are coming up with an error: "Index was outside the bounds of the array." I have no issues with other CSV readers. This sourceforge reader/viewer is quite slow too.

Format of csv is:
Posting Date,Trans Date,Type,Category,Merchant Name,Merchant City,Merchant State,Description,Transaction Type,Amount,
,,,,,,,,,,
10/28/2022,10/27/2022,Credit,Payments and Fees,PAYMENT - THANK YOU , , ,Financial Institutions - Banks Savings,Payment,($0.31),
10/07/2022,10/05/2022,Debit,Groceries,SAVE ON FOODS ,XXXX,xx,Grocery Stores Supermarkets,Purchase,$0.31,
04/28/2022,04/27/2022,Credit,Payments and Fees,PAYMENT - THANK YOU , , ,Financial Institutions - Banks Savings,Payment,($61.94),
04/08/2022,04/07/2022,Debit,Household,COSTCO WHSE N/A ,xx,XX,Wholesale Clubs,Purchase,$15.71,
04/08/2022,04/07/2022,Debit,Household,COSTCO WHSE N/A ,XX,WA ,Wholesale Clubs,Purchase,$46.25,
01/16/2022,01/16/2022,Credit,Payments and Fees,SCORECARD CASHBACK REWARD, , ,Financial Institutions - Banks Savings,Misc Credits,($0.02),
11/01/2021,10/29/2021,Credit,Payments and Fees,PAYMENT - THANK YOU , , ,Financial Institutions - Banks Savings,Payment,($1.37),
10/15/2021,10/14/2021,Debit,Health & Medical,DRUGSTORE,XX,AA ,Drug Stores Pharmacies,Purchase,$1.37,

[Raphael Noeldner]

I will look into this

[Raphael Noeldner]

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.

[Raphael Noeldner]

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 and not much change this is not properly supported.
Please go to the setting with having opened a file, and set the Delimiter, Code page etc, then uncheck all "Inspect xxx" and head over to Detection and Select Disable inspection there as well.

[cafa]

Thanks for your efforts.

However, I'm completely lost with your instructions. I don't understand anything past open the application. I just open up my .csv file in a CSV application and others work fine without any additional user intervention, I really wouldn't know what to do much else as it's beyond me.

Also, your latest portable version just hangs with almost 600 MB running in the background as checked by my Task Manager, perhaps that explains so few downloads of it? Your application my PC and I had to do a manual force shutdown. I was frightened for a moment thinking I was infected with malware after running it, but fortunately nothing was detected.

I tried again and your application hanged the second time. I have given up.

[Raphael Noeldner]

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.