This forum has been archived. All content is frozen. Please use KDE Discuss instead.

Strange CSV Import Behavior

Tags: None
(comma "," separated)
roadkill
Registered Member
Posts
1
Karma
0

Strange CSV Import Behavior

Thu Nov 02, 2017 7:50 pm
I'm using Tellico 3.1 on openSUSE Leap 42.3 with KDE Plasma 5. Importing a CSV file for my custom collection causes every colon character (:) to become doubled (::). If, for example, I have a string for a time value in the CSV as 4:12, in Tellico it will become 4::12. URLs beginning with http:// become http:://.

I am using a colon as the column delimiter for tables and the tables import correctly. It is simple text and URL fields that are affected. It looks like a bug unless there is some way to escape it in the import file.

I will try it with a different character in the tables, but please suggest a better workaround if there is one.
robbystephenson
KDE Developer
Posts
384
Karma
1
OS

Re: Strange CSV Import Behavior

Fri Nov 03, 2017 12:46 am
roadkill wrote:I'm using Tellico 3.1 on openSUSE Leap 42.3 with KDE Plasma 5. Importing a CSV file for my custom collection causes every colon character (:) to become doubled (::). If, for example, I have a string for a time value in the CSV as 4:12, in Tellico it will become 4::12. URLs beginning with http:// become http:://.

I am using a colon as the column delimiter for tables and the tables import correctly. It is simple text and URL fields that are affected. It looks like a bug unless there is some way to escape it in the import file.

I will try it with a different character in the tables, but please suggest a better workaround if there is one.

It's a straight-up bug, I'll get a fix in for the next release. Internally, the double-colon is sometimes used as a column delimiter for tables, which is why it was getting duplicated. I'll track this as Bug 386483.

If you're able to create the CSV file with a different column delimiter, that should work in the meantime.


Bookmarks



Who is online

Registered users: bartoloni, Bing [Bot], Google [Bot], Sogou [Bot], Yahoo [Bot]