Thread: [GUI Plugin] Import List
View Single Post
Old 01-16-2020, 06:52 PM   #393
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by ChrisMillward View Post
I am trying to import a columns from CLZ Book Collector using the Import List plugin.
One particular item of data (the cover price of a book) seems to give a problem.
All the data is in the form of comma separated strings, in this case "£4.50".
For some reason the £ sign is not liked and results in the entry �4.50.
'short text, like a title' or 'Plain text' both fail
There doesn't seem to be a simple Column type of 'text'

Any suggestions or Solutions would be gratefully received
Where are you seeing this? During the import or afterward? I would have expected this to be handled properly, but, it will depend on exactly what character is used. And it could just be the font used to display the data. Again, that will depend on exactly what character is used..

Can you post or send me a sample to look at? I can check if it is the plugin or something else.

And for the record, I would be stripping the character and loading the value into a numeric column. Then putting formatting on the display of the column to show it as a price. That will work if you only have one currency.
davidfor is offline   Reply With Quote