Can't import .csv

This topic contains 15 replies, has 4 voices, and was last updated by  Kiran 7 years, 11 months ago.

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

Open Support Ticket
  • Author
    Posts
  • #397339

    John Clark
    Free User
    Post count: 10

    Hey all,

    I know I’m not the only one who’s had trouble with this, but I’ve looked at the other threads and tested a couple of fixes offered in them to no avail. I have a ~1000 entry database in .csv format that I’ve been trying to import, and they just won’t work. None of them successfully import. I’m at a loss.

    I really love this plugin, though, and am excited to populate my site and take it live. Here’s hoping someone here can help me do that. Thanks.

    #397397

    Kor
    Moderator
    Post count: 16516

    Hi John,

    Please share WP temp admin access to your site and also a copy of the CSV file and we’ll try to import it for you. You can post the details here using the private reply option below.

    Thanks!

    #397476

    John Clark
    Free User
    Post count: 10
    This reply has been marked as private.
    #397504

    Paolo
    Site Admin
    Post count: 31211

    You have the following errors:

    1) post_id should be empty (you added the listing title there)

    2) All listings should have a title. (few of yours don’t)

    3) must put author ID in post_author column

    4) all listings must be within the default locaiton unless you install the location manager add-on

    5) all default columns must be there even if empty. You removed some from the sample CSV file.

    Thanks

    #397509

    John Clark
    Free User
    Post count: 10
    This reply has been marked as private.
    #397511

    Paolo
    Site Admin
    Post count: 31211

    to fix the missing column I suggest to open a new sample file and copy + paste each column from your file to the sample file.

    the author id of the admin is normally 1 http://guides.slidervilla.com/2014/04/find-user-id-author-wordpress/

    the free plugin allow 1 city only. It doesn’t matter if they are adjoining or not, if you want to add listing to a place with a different name you must have the location manager installed.

    post_id must be blank to add new listings.

    Thanks

    #397533

    John Clark
    Free User
    Post count: 10
    This reply has been marked as private.
    #397536

    Paolo
    Site Admin
    Post count: 31211

    If you provide a link to your website too, we will follow up.

    Let us know

    #397539

    John Clark
    Free User
    Post count: 10
    This reply has been marked as private.
    #397601

    Kor
    Moderator
    Post count: 16516

    Hi John,

    Could you try removing the city, region and zip from the “post_address” column and see if it works?

    Thanks!

    #397728

    John Clark
    Free User
    Post count: 10

    I tried this with a small sample of my listings just to see, and they still failed. :/

    #397736

    Paolo
    Site Admin
    Post count: 31211

    Hi John,

    the developers have been alerted and they’ll debug this asap.

    They’ll alert you once they are done.

    Thanks for your patience,

    #397737

    John Clark
    Free User
    Post count: 10

    Thank you all SO much for your help and patience, too!

    #397805

    Kiran
    Moderator
    Post count: 7069
    This reply has been marked as private.
    #397895

    John Clark
    Free User
    Post count: 10

    Okay, I will try what you suggested today and hopefully that will take care of everything. Thanks again for all your help, everyone.

Viewing 15 posts - 1 through 15 (of 16 total)

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

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount