Listing import not working, different number of rows detected

This topic contains 4 replies, has 3 voices, and was last updated by  Alex Rollin 4 years, 9 months ago.

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

Open Support Ticket
  • Author
    Posts
  • July 23, 2019 at 5:14 am #499037

    Andrew
    Expired Member
    Post count: 197

    Hi,

    I’m trying to import a set of listings into a new dev website however am having issues. I exported a set of listings of post_type “gd_accommodation” and cleaned up the csv file using Libre Calc. However when I try to import it to the new site, it states that there are more rows than there actually are and all (except for 1 row) fail to import. Also, when I try opening it with Excel, the rows are out of whack.

    I’ve attached the file .csv here. Note that in Libre Calc if you set the String Delimeter to ‘ and select ‘comma’ everything looks fine … not sure what’s going wrong here. Any help is appreciated.

    Thanks,
    Andrew

    July 23, 2019 at 6:47 am #499049

    Kor
    Moderator
    Post count: 16516

    Hi Andrew,

    Thanks for your post. Could you please zip your csv file and reattach it here on your next reply? Also, share your Website WP admin access here in private reply and we’ll check what’s going on.

    July 23, 2019 at 10:55 am #499086

    Andrew
    Expired Member
    Post count: 197

    We’ve actually resolved that issue, but we’ve found another. When we import the listings, we’ve found a series of random characters inserted into the text such as: ‚Äô.

    See the listing here: https://www.simplfi-mockups.com.au/accommodation/abode-hotel-narrabundah/.

    Any reason why this is happening?

    July 23, 2019 at 11:31 am #499095

    Andrew
    Expired Member
    Post count: 197

    I’ve attached a spreadsheet showing an example of two listings with the original Geodirectory data vs what it looks like once converted over. (Highlighted in red are the random characters that appear)

    Both original .CSV files also attached.

    July 23, 2019 at 7:00 pm #499198

    Alex Rollin
    Moderator
    Post count: 27815

    Bad HTML will break the export format. Once you see which listings are causing the break update the HTML and you shouldn’t have that problem.

    You can always copy/paste to a service like https://validator.w3.org/

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

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

Open Support Ticket