Unable to import after creating entries with FB import

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

Open Support Ticket

Tagged: CSV, import

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