| Summary: | Cannot import csv | ||
|---|---|---|---|
| Product: | [Applications] LabPlot2 | Reporter: | Martin Tlustos <martin.tlustos> |
| Component: | general | Assignee: | Alexander Semke <alexander.semke> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | ||
| Priority: | NOR | ||
| Version: | 2.9.0 | ||
| Target Milestone: | --- | ||
| Platform: | Neon | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
| Attachments: |
sample file
UTF8 encoded file |
||
|
Description
Martin Tlustos
2023-04-06 14:25:27 UTC
(In reply to Martin Tlustos from comment #0) > SUMMARY > I cannot import my weather data into labplot. It is in csv format, with the > first line being a description. When trying to import, it tells me: no data > to be imported. I tried automatic and manual settings, but to no avail. Did you use the proper separator character? If yes and you're still not getting any data shown in the preview tab, does it help if you close the dialog and open it again? I have tried manual settings to match the csv, and I tried closing and reopening the dialog. No luck. I will upload a sample file (smaller), that also didn't work. Created attachment 158013 [details]
sample file
I tried the flatpak version (2.10.0), but it didn't work either (and it crashed when I tried to import it in xlsx format, but that's another issue...) Also, I played around with the preview a bit. If I turn on "first line are names" (or similar, I use German), then nothing is shown. If I turn this of, then only a 0 is shown in the first line (index). I tried pretty much every option in the settings. Changing date/time, generate index, convert NaN to 0, etc... Created attachment 158061 [details]
UTF8 encoded file
(In reply to Martin Tlustos from comment #5) > Also, I played around with the preview a bit. If I turn on "first line are > names" (or similar, I use German), then nothing is shown. If I turn this of, > then only a 0 is shown in the first line (index). > I tried pretty much every option in the settings. Changing date/time, > generate index, convert NaN to 0, etc... This seems to be an issue with the UTF16 encoding that we already track in https://invent.kde.org/education/labplot/-/issues/541. I attached your file in UTF8, please try with it. You need to use 'yyyy-MM-dd hh:mm:ss' for the DateTime format for your data and comma as the separator character. The preview is sometimes not properly refreshed, closing the dialog and opening it again solves this problem - this is another problem that we'll check. OK, opening the original big file in libreoffice and saving it as utf-8 solved the problem with the import. Now I just have to figure out how to use it... ;-) (I'm a noob in statistical analysis). Thanks for the help! (In reply to Martin Tlustos from comment #8) > OK, opening the original big file in libreoffice and saving it as utf-8 > solved the problem with the import. Now I just have to figure out how to use > it... ;-) (I'm a noob in statistical analysis). > Thanks for the help! Ok, thanks for the confirmation it works for you with utf8. Let me close this ticket now, we'll finalize the bug fix in https://invent.kde.org/education/labplot/-/issues/541. In case you need any further help with how to use labplot, you can also reach out to us on our Matrix room. |