Results 1 to 6 of 6
  1. #1
    Newbie
    Join Date
    February 9th, 2010
    Posts
    2
    cj.com export character encoding problem
    Hello,

    I am trying to import cj.com datafeed to Pinnacle Shopping Cart via it`s bulk import option, but i am having difficulty with catalogs containing non-us characters (French, Spanish, ...) After import, those characters are distorted and read something like ???. I`ve tried to use Standard CSV and Quoted CSV on both CJ`s ftp and my own ftp but resault is the same. I`ve tried to analise datafeed csv files I am getting and it turns out that the files are already distorted.

    Is there any way to fix this problem, make cj export utf-8 encoded files, or any other way?

  2. #2
    I like traffic lights
    Join Date
    January 18th, 2005
    Location
    Southern hemisphere - away from Fukushima
    Posts
    2,936
    >make cj export utf-8 encoded files

    That would be the ideal target.

  3. #3
    Full Member iolaire's Avatar
    Join Date
    October 3rd, 2006
    Location
    Arlington, VA
    Posts
    229
    Quote Originally Posted by skara
    After import, those characters are distorted and read something like ???.
    When you look at those characters pre import in modern software that reads with UTF-8 do you see the same issues?

    i.e. is this a CJ export encoding issue, or is it in your import process? If it is in the import process it could be something as simple as the encoding on your database, or maybe the scripts need an update.

  4. #4
    Full Member iolaire's Avatar
    Join Date
    October 3rd, 2006
    Location
    Arlington, VA
    Posts
    229
    FYI: just to test I glanced at the Overstock_com-Euro_Product_Catalog. That one it looks like they have encoded many caracters in HTML code, i.e. "King of Memphis" rather than "King of Memphis".

    The file it self was ISO-8859-1 which Wikipedia appears to indicate should cover most European character sets: http://en.wikipedia.org/wiki/ISO/IEC_8859-1

    Anyway if you have not check the raw file it would be good to do so.

  5. #5
    Newbie
    Join Date
    February 9th, 2010
    Posts
    2
    Thanks for the replies,

    Html encoded chars appear as you suggested but that is not a problem. I re-checked raw datafeed files using Ultra Edit, and it turns out that files are utf-8 encoded and initially contain character distorsion.

  6. #6
    Full Member iolaire's Avatar
    Join Date
    October 3rd, 2006
    Location
    Arlington, VA
    Posts
    229
    It might be on the publisher end (or CJ). Initially I recommend reaching out the the publisher (if it is only one or two) and seeing if they think they can help.

  7. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. special character reading problem.
    By snjha123 in forum Rakuten LinkShare - LS
    Replies: 2
    Last Post: October 12th, 2010, 08:25 AM
  2. Replies: 0
    Last Post: January 16th, 2008, 02:35 PM
  3. XHTML and Encoding Character Entities in Links
    By blizzard in forum Programming / Datafeeds / Tools
    Replies: 2
    Last Post: February 12th, 2006, 11:09 AM
  4. encoding url's?
    By cjk in forum Programming / Datafeeds / Tools
    Replies: 1
    Last Post: May 12th, 2004, 09:35 AM

Posting Permissions

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