-
-
Notifications
You must be signed in to change notification settings - Fork 2.2k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
CSV Import bug - final row being missed #193
Comments
Hi! Can you provide such a CSV file? Maybe as real download, pasting it somewhere might ruin the linebreaks. |
Ok. Here is the CSV file with 10 records, and only the first 9 is imported. CSV file is generated using Apple's Numbers app on OS X. https://www.dropbox.com/s/e8pad14efeki5e7/ZWATCHACTIVITY.csv?dl=0 |
Thanks, I think I got it, looks like a stupid mistaken variable. |
should be fixed: 8d55fd5 |
Thanks for the fix! |
@harysutanto Sounds like this was just a simple mistaken variable bug, so should be fixed now. However, just to be 100% sure, would you be ok to test with the latest nightly and confirm back if it's ok or not? 😄 |
Oh yeah, I already tested using the Feb 06, 2015 nightlies, and the problem is fixed but forgot to post here. Silly me! Anyway, Thanks again for the fix! |
Awesome. 😀 |
Did want to create the same issue, but it is already here. Looks like it is needed to be reopen. The problemFinal row is missed when importing csv file. How to reproduce
Additional infoIf add new empty line to the file, e.g
then import works. The csv standard says the last record may or may not have an ending line break. Tech infoWIndows 8.1, DB4S nightly Version 3.11.99 (Oct 3 2019) |
Thanks @T1mL3arn. Sounds like an unintended regression. @MKleusberg Any interest in taking a look? |
Thanks for pointing this out, @T1mL3arn! Can you check again with tomorrow's nightly build and see if it's working for your CSV file? 😄 |
Tested. Didn't see the issue anymore. |
Awesome. Thanks for verifying things @T1mL3arn! Well done @MKleusberg. 😄 |
Cool, thanks for testing! I'm closing this issue again then 😄 |
OS : OS X Yosemite 10.10.2
SQLiteBrowser Ver : 3.5.0
There's a bug when importing CSV files to database that the last record is not imported. Say that I have 10 records, then only 9 of them is imported, 20 records and only 19 imported. I use another SQLite browser app and the import works fine. Maybe you can work this bug out, I really love using your app for simplicity and easy to use.
This case is not always btw. I also have another CSV file that has 5 records in it, but all of them is imported. Maybe the bug occurs when the total records number exceeds certain number.
Also one more, when let's say I have 60 records in CSV file, when I click import there's a preview (when I was asked to name the table that is imported) of the records that's inside the CSV. But the preview only shows 19 of them, not all, even though the preview is in a scroll view. Maybe you can work this too so that it shows all of the records in the preview. Obviously when I import, only 59 of the records imported.
Thanks for your work on this app! Keep up the good work, and have a nice day!
The text was updated successfully, but these errors were encountered: