Unable to import after creating entries with FB import

This topic contains 6 replies, has 3 voices, and was last updated by  Bkbai 8 years, 7 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: ,

  • Author
    Posts
  • October 1, 2015 at 5:48 pm #55390

    Bkbai
    Buyer
    Post count: 56

    Hi I started my project some months ago and I did test the import process and it was working fine.

    Then I start creating my listings with FB Importer and edit them with open office as I read in the doc

    So my main problem is that I’m totally unable to import my csv

    Can someone check it out? it look fine to me when I open it but I got this errors when importing, plugin say that all my addresses are missing

    Last time I manage to solve it using

    https://stackoverflow.com/questions/10905588/exporting-csv-properly-open-office-save-numbers-as-text

    Please help, I’m out of ideas 🙁
    Thanks

    October 1, 2015 at 5:50 pm #55391

    Bkbai
    Buyer
    Post count: 56
    This reply has been marked as private.
    October 1, 2015 at 6:48 pm #55405

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hello,

    Your GPS date is seperated with a | rather than a comma: 48010,43.260986|-2.941881

    Thanks,

    Stiofan

    October 1, 2015 at 7:32 pm #55418

    Paolo
    Site Admin
    Post count: 31206

    Just open your CSV with notepad and do a find and replace to find | and replace it with ,

    Thanks

    October 1, 2015 at 8:53 pm #55436

    Bkbai
    Buyer
    Post count: 56

    First of all great image profile Stiofan 😉 força catalunya!!!
    And of course thanks both for helping me

    I did what paolo said (it seams to be a bug in the split formula for open office 🙁

    Same results, I’m opening the file in a text editor now to check it, there is no | and still getting the error

    Tomorrow I will redo the process with a fresh start, let me come back if I’m unable to fix it

    100 Thanks!

    October 2, 2015 at 8:33 am #55461

    Bkbai
    Buyer
    Post count: 56

    I manage to import fresh data but I just can’t update existing data I end up with duplicated posts.

    I’m also loosing every special character in my text (º ó ñ) and so on

    Importing is not working for me, any tip about how to Update Content and Avoid Loosing Special Characters in Text

    Thanks for your time

    October 2, 2015 at 10:03 am #55462

    Bkbai
    Buyer
    Post count: 56

    UPDATE

    Duplicated content solved!

    Please help me with encoding, I’m using UTF8 when saving in open office
    I also tried to open it in Sublime and save with encoding (UTF8) but when updating my listings I loose special characters

    Thanks

  • Author
    Posts
Viewing 7 posts - 1 through 7 (of 7 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket