Reply to topic

Strange CSV Import Behavior

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
268
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.

 
Reply to topic

Bookmarks



Who is online

Registered users: alfredod, Baidu [Spider], Bing [Bot], boudewijn, Capitain_Jack, capslock, Exabot [Bot], formyfriday, gerdeg, Google [Bot], gui-m, La Ninje, Majestic-12 [Bot], Sogou [Bot], TheraHedwig, Tromzy, vpinon, Yahoo [Bot], zhanxw