CSV not showing correctly in field definitions

Hi Martin

First of all thank you for your terrific support via email.
I have another problem I cannot seem to figure out.

I have imported the CSV file to the feed folder but when i try to define fields in wordpress it shows up as if it is not seperated by semicolons?

I have attached an image so you can see it better.

Attachment not found.

I have had the csv file opened in excel and it looks correct, also tried saving it as both csv dos and csv semicolon seperated.

thanks ;)
Dennis

Posts

  • edited September 2010
    Hi Dennis,

    I seem to be having some problem opening the attachement, but will look at that first thing tomorrow for you.

    At a guess - is your feed perhaps quoted text? ie. "field1";"field2";etc.... ?

    Also - at stage 1 on the feed import, you can manually override the plugins guess at what type it is, if its not a completely standard feed this is often a good idea. We inbuilt some decent logic into that step, but I have seen it not work on some feeds.

    cheers,

    MOGmartin
  • edited September 2010
    Hi Martin

    my feed is not quoted. it only has the semicolon..
    name;productURL;imageURl;.... etc

    i have attached a new image. I am also experiencing some issues with the forum so sorry for posting two of the same yesterday. I have just noticed it.

    Attachment not found.

    cheers
  • edited September 2010
    aha, this is freak... brilliant!
    For everybody else, that has this issue. if your feed is separted by other symbols than Martin has in his tutorial video. Martin has made it so that you manually can define a new format.

    mine was: Quoted Text - Header Row - Semicolon Separated. instead of comma seperated.

    Thanks again Martin for this great plugin and support.
  • edited September 2010
    Hi again Martin

    Now i have managed to import the feeds, and also set it to automatically update via html. but I have just noticed that there are no products in the feeds, and when I went in to one of the feeds I got a bunch of wingdings symbols? Also when I try to update something in the plugin I get thrown off the backpanel all the time and experience difficulties with the login after that.

    I am not sure what I am doing wrong here, but everything seems to be working and then not. Could it be the html auto update that messes the feeds up.?

    Also this is properly a dumb question. But how do you assign products to a menu or category so iit shows up in the frontend?

    thanks again
    Dennis
  • edited September 2010
    augustSix wrote: »
    Hi again Martin

    Now i have managed to import the feeds, and also set it to automatically update via html. but I have just noticed that there are no products in the feeds, and when I went in to one of the feeds I got a bunch of wingdings symbols? Also when I try to update something in the plugin I get thrown off the backpanel all the time and experience difficulties with the login after that.

    I am not sure what I am doing wrong here, but everything seems to be working and then not. Could it be the html auto update that messes the feeds up.?

    Also this is properly a dumb question. But how do you assign products to a menu or category so iit shows up in the frontend?

    thanks again
    Dennis

    hmmm - something that I havent ran into before, both the html and ftp updates have always worked fine for me with no bugs.

    can you post the address of your http feed here so that I can check it out? There may be some encoding or characterset issue that I hadnt thought about in the past (Ive only ever used english language feeds myself, and I think that may be the problem if you are using a scandinavian characterset).

    cheers
    MOGmartin
  • edited September 2010
    Hi Martin

    Do you want me to post the URl for the CSV i have uploaded to the FTP.?
  • edited September 2010
    augustSix wrote: »
    Hi Martin

    Do you want me to post the URl for the CSV i have uploaded to the FTP.?

    hang on, you say:
    and also set it to automatically update via html
    Im assuming therefore that you have an http:// address that the feed is available from, for instance, I can pick up my feed for "3 Mobile"
    here:
    http://feeds.perfb.com/index.php/download?OEMAIL=admin@myticketmarket.net&PX=209b71b8c976e5e457ac1bc49854ef61&DISPLAYFORMAT=CSV&REVERSEMAPXML=yes&PRODUCTDB_ID=258

    which as you can see, is a straight http:// feed, NOT an ftp feed (that you would have to log in to collect).

    is that the kind of feed you are having problems with?

    cheers
    MOGmartin
  • edited September 2010
    Now i am bit confused so lets clear some things up... ;)

    first. when i make this feed in tradedoubler i have some possibllities. I can zip it and also decide table dividers and so on. What is the correct way to export this feed. Should I just not zip it, choose comma as table divider. Also the file CSV file I get, can I rename this or should I keep the name it gives. (it does not give logical names, only numbers.)

    secondly. when i export feed it opens up in the browser, and not in excel:
    heh. cant post a link since i do not have 20 post counts. so i have PMed you the link.

    thirdly. following your tut videos, I see that your feed is nicely placed in excel with headers, etc. but my export is on one line divided by what ever symbol i choose to seperate the lines. I can then sort them in tables in excel later?

    hope you are able to understand all my blabberinghere. ;)

    cheers
    Dennis
  • edited September 2010
    no probs mate, lets take these one at a time:
    augustSix wrote: »
    when i make this feed in tradedoubler i have some possibllities. I can zip it and also decide table dividers and so on. What is the correct way to export this feed. Should I just not zip it, choose comma as table divider. Also the file CSV file I get, can I rename this or should I keep the name it gives)

    in Tradedoubler, I use the following settings (and you can save them as a template for future use)
    Format: CSV
    Concatenate Files: No
    Compression: None (the plugin does NOT handle zip files, so do not use compression, it will break the import)
    Encoding: ISO-8859-1
    Column Seperator: |
    Text Qualifier: "
    Field Separator: ;
    Sub Field Seperator: :
    Headers: (Yes) <
    Headers are VERY important, without those wpPC will not know where to map the fields...
    augustSix wrote: »
    secondly. when i export feed it opens up in the browser, and not in excel:
    heh. cant post a link since i do not have 20 post counts. so i have PMed you the link.

    Just right click and Save-As, that should do it (and make sure your using firefox, not IE
    augustSix wrote: »
    thirdly. following your tut videos, I see that your feed is nicely placed in excel with headers, etc. but my export is on one line divided by what ever symbol i choose to seperate the lines. I can then sort them in tables in excel later?

    Sure, if you have the latest version of excel you can just import from text, and they should appear in the same way as they do on my instructional videos.....

    ..... which leads me to the point, that Im sure youve noticed.....

    In this release the whole backend is updated, I have consolidated some functionality and improved a lot of the handling, so those videos are now deprecated... but not to worry - Im planning on re-filming them tomorrow!

    cheers

    MOGmartin
Sign In or Register to comment.