| Summary: | Kexi crashes on importing CSV files with Mac line endings | ||
|---|---|---|---|
| Product: | [Applications] KEXI | Reporter: | mc <mateolan> |
| Component: | Migration/Import/Export | Assignee: | Jarosław Staniek <staniek> |
| Status: | CLOSED FIXED | ||
| Severity: | crash | CC: | adam, jackslife1049, mateolan |
| Priority: | NOR | ||
| Version: | 2.4.0 | ||
| Target Milestone: | 2.5 | ||
| Platform: | Ubuntu | ||
| OS: | Linux | ||
| Latest Commit: | http://commits.kde.org/calligra/560ee6e7db8cb68c39c2ca4182899ab0792b0566 | Version Fixed In: | 2.5.1 |
| Sentry Crash Report: | |||
| Bug Depends on: | |||
| Bug Blocks: | 304405 | ||
| Attachments: |
New crash information added by DrKonqi
This is the data set that I was trying to import |
||
|
Description
mc
2012-07-31 12:56:56 UTC
Created attachment 72850 [details]
New crash information added by DrKonqi
kexi (2.4.0 (Calligra 2.4.0)) on KDE Platform 4.8.4 (4.8.4) using Qt 4.8.1
- What I was doing when the application crashed: Importing tab delimited data--and another note, I am using a postgres backend.
-- Backtrace (Reduced):
#6 isEmpty (this=0x9b5959592a000000) at /usr/include/qt4/QtCore/qlist.h:99
#7 isEmpty (this=0x9b5959592a000000) at /usr/include/qt4/QtCore/qlist.h:152
#8 KexiCSVImportDialog::detectTypeAndUniqueness (this=0xfea510, row=<optimized out>, col=1024, text=...) at /build/buildd/calligra-2.4.0/kexi/plugins/importexport/csv/kexicsvimportdialog.cpp:1054
#9 0x00007fa5198f754e in KexiCSVImportDialog::setText (this=0xfea510, row=2, col=1025, text=..., inGUI=<optimized out>) at /build/buildd/calligra-2.4.0/kexi/plugins/importexport/csv/kexicsvimportdialog.cpp:1253
#10 0x00007fa5198f8b69 in KexiCSVImportDialog::loadRows (this=0xfea510, field=..., row=@0x7fffae614660: 1, column=@0x7fffae614664: 1025, maxColumn=@0x7fffae614668: 0, inGUI=true) at /build/buildd/calligra-2.4.0/kexi/plugins/importexport/csv/kexicsvimportdialog.cpp:854
Created attachment 72851 [details]
This is the data set that I was trying to import
Thank you for the test data. It should speed up the fix :) I guess it shouldnt crash, but the data is tab delimited, and the importer is for CSV data. Confirmed the crash. @Adam CSV supports any well defined delimiter, tab is typical one Well, it gives a choice for csv or txt in the file chooser, and the delimiter is not clearly stated. In the table importer, changing the file extension to tsv crashes Kexi as well, and yet it is listed as 'supported'. On Tue, Jul 31, 2012 at 2:03 PM, Adam Pigg <adam@piggz.co.uk> wrote: > https://bugs.kde.org/show_bug.cgi?id=304329 > > Adam Pigg <adam@piggz.co.uk> changed: > > What |Removed |Added > > ---------------------------------------------------------------------------- > CC| |adam@piggz.co.uk > > --- Comment #4 from Adam Pigg <adam@piggz.co.uk> --- > I guess it shouldnt crash, but the data is tab delimited, and the importer > is > for CSV data. > > -- > You are receiving this mail because: > You are on the CC list for the bug. > You reported the bug. > @jaroslaw Ah, ok, i thought it was CSV only.... @Adam: CSV isn't the CSV you have in mind :) More strictly, please look: ""CSV" is not a single, well-defined format (although see RFC 4180 for one definition that is commonly used)" http://en.wikipedia.org/wiki/Comma-separated_values @mc: Changed the summary to "Kexi crashes on importing CSV files with Mac line endings". Yes this is real reason.
Current workaround before this bug gets fixed:
OPTION 1: using Kate:
open the file in Kate, select Tools->End of Line->UNIX, save the file.
OPTION 2: using command line:
recode macintosh/CR..UTF-8 {filename}
*** Bug 258343 has been marked as a duplicate of this bug. *** Git commit 79d3d721fcdf74df70450c4930ade8885410c057 by Jaroslaw Staniek. Committed on 03/08/2012 at 00:49. Pushed by staniek into branch 'calligra/2.5'. Fix crash on importing CSV files with Mac line endings REVIEW:105843 FIXED-IN:2.5.1 M +20 -11 kexi/plugins/importexport/csv/kexicsvimportdialog.cpp http://commits.kde.org/calligra/79d3d721fcdf74df70450c4930ade8885410c057 Git commit 560ee6e7db8cb68c39c2ca4182899ab0792b0566 by Jaroslaw Staniek. Committed on 03/08/2012 at 00:49. Pushed by staniek into branch 'master'. Fix crash on importing CSV files with Mac line endings REVIEW:105843 M +20 -11 kexi/plugins/importexport/csv/kexicsvimportdialog.cpp http://commits.kde.org/calligra/560ee6e7db8cb68c39c2ca4182899ab0792b0566 |