Results 1 to 3 of 3

Thread: csv files and special characters

  1. #1
    Join Date
    Aug 2012
    Posts
    111

    Default csv files and special characters

    I've had to get a new tablet and we are now having problems with csv uploads/downloads messing up anything with accented characters in it (eg; etc).

    I used to use a Windows tablet running Openoffice Calc and everything worked perfectly. Now using a Samsung Galaxy Tab and I've tried Excel and Google Docs as well as a couple of supposed alternatives to Openoffice which were both rubbish and every special character is converted to what I think is the ASCII code, ie: "" appears as "ü". I don't know if its an Android problem, a software problem or something wrong at the BP end... anyone else come across this or know a fix for it?

    Tim
    www.plantpref.co.uk

    The Plantsman's Preference - specialist plant nursery

  2. #2
    Join Date
    Jul 2010
    Location
    Suffolk, UK
    Posts
    44

    Default

    Hello Tim

    I have experienced this problem using CSV exports/imports on my Mac. The only work around I found to be successful was to encode all accented characters to XML (ie. >
    Code:
    ü
    ) when writing / importing. They then export correctly without being incorrectly decoded.

    Lots of options available to encode but I use:

    http://coderstoolbox.net/string/#!encoding=xml&action=encode&charset=us_ascii


    I appreciate this is not an ideal solution, but hope it helps.

    Best wishes
    Tom

  3. #3
    Join Date
    Aug 2012
    Posts
    111

    Default

    Thanks for that, I'll give it a go for some and see how it works. It won't be any worse than what I have now anyway...

    Do you happen to know if the code is &# followed by ; for everything like that? I already use the numbers to enter the character via the numerical keypad so know most off by heart!
    www.plantpref.co.uk

    The Plantsman's Preference - specialist plant nursery

Similar Threads

  1. refering search strange characters
    By niche in forum Bluepark Technical Discussion
    Replies: 0
    Last Post: 30-11-2012, 10:55
  2. Importing CSV files onto Sage
    By weetbix in forum Bluepark Technical Discussion
    Replies: 0
    Last Post: 10-11-2012, 17:55
  3. Text Files
    By chubster in forum Bluepark Technical Discussion
    Replies: 3
    Last Post: 19-03-2011, 15:34
  4. Problems uploading CSV files
    By twa96 in forum Bluepark Technical Discussion
    Replies: 8
    Last Post: 17-02-2011, 19:44
  5. Files
    By stripey in forum General Discussion: Any Other Business
    Replies: 1
    Last Post: 13-04-2009, 23:37

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us

Bluepark's ecommerce software is developed, hosted and supported exclusively by ourselves, here in the UK, and has been so since the company was initially formed in 2004. Your brand new online shop will be hosted securely on our fast and reliable server network, using a domain name of your choice, providing the ability to build and maintain your ecommerce website, and manage your orders, from any location via your own secure online Administration Console.

A Bluepark ecommerce site is the perfect tool for selling online, whether you're selling physical products, digital downloads or services. You'll be in good company with over 1,000 UK customers who also form a friendly and helpful online community, further strengthening our highly acclaimed support network.

Find us on...