40% OFF EVERYTHING
Our 10th BIRTHDAY SALE
Buy Now

Unable to Upload Business Directories in Montreal Quebec

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

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

Open Support Ticket
  • Author
    Posts
  • July 21, 2016 at 9:59 pm #231595

    Utsav Sarkar
    Expired Member
    Post count: 29

    So I’ve been struggling with this for more than a day now. Please help!

    I have a CSV file full of business directories with businesses in Montreal, Quebec. And for some reason I keep getting the error below

    178 / 1257 item(s) could not be added due to blank/invalid address(city, region, country, latitude, longitude).
    1092 / 1257 item(s) could not be added due to blank title/invalid post type/invalid characters used in data.

    I thought it has something to do with the accents. So I removed all the accents from the data and still no luck. I have attached the file here.

    Please tell me what is wr0ng with my data.

    July 23, 2016 at 3:37 am #232189

    Kor
    Moderator
    Post count: 16516

    Hi Utsav Sarkar,

    Could you please share WP Temp admin login and we’ll try to upload it for you?

    Thanks!

    July 23, 2016 at 3:41 pm #232394

    Utsav Sarkar
    Expired Member
    Post count: 29
    This reply has been marked as private.
    July 23, 2016 at 3:57 pm #232399

    Utsav Sarkar
    Expired Member
    Post count: 29

    I forgot to mention the website is http://www.ratemyphysiotherapist.com

    July 25, 2016 at 2:33 am #233031

    Utsav Sarkar
    Expired Member
    Post count: 29

    Okay nevermind I finally figured out what was wrong. For some reason, excel was adding the character “Ê” after every record. Wierd! Anyways I removed all that and it works fine now!

    Thanks!

    July 25, 2016 at 4:41 am #233046

    Kor
    Moderator
    Post count: 16516

    Hi Utsav,

    Glad that you sorted it out yourself. Well, enjoy gd and let us know if you need anything further.

    July 25, 2016 at 3:39 pm #233351

    Paolo
    Site Admin
    Post count: 31206

    Just FYI, that is why we strongly suggest to only use open office or libreoffice and not excel.
    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