Import listings as 'uncategorized'

This topic contains 10 replies, has 3 voices, and was last updated by  Nico Prinsloo 5 years ago.

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

Open Support Ticket
  • Author
    Posts
  • March 18, 2020 at 1:44 pm #535613

    Nico Prinsloo
    Free User
    Post count: 6

    Hi,
    Still trying to get GD ‘under the knee’.
    I downloaded the sample csv, made my csv file the same heading.
    Populated the csv file
    Empty cells were marked “N”
    When I import the listings, it makes all listings “uncategorized”.
    It seems I keep missing something, so I need help, please.
    Screenshot and file attached

    March 18, 2020 at 2:24 pm #535618

    Kor
    Moderator
    Post count: 16516

    Hi Nico,

    Thanks for your post. If you refer to this section of the documentation https://wpgeodirectory.com/docs-v2/geodirectory/settings/import-export/ , are you using the correct software to edit the CSV file and the method as explained?

    March 18, 2020 at 3:19 pm #535626

    Nico Prinsloo
    Free User
    Post count: 6

    Thanks for the reply.
    Yes, I used the most recent Libre Office and even re-saved as utf8.
    Anything else I need to do?

    March 18, 2020 at 4:55 pm #535636

    Alex Rollin
    Moderator
    Post count: 27815

    Hello,

    instead of matching the sample CSV, try this:

    1. Add a listing and fill in all fields
    2. Export the listings in that CPT
    3. Merge your data into that CSV (theone that is exported)

    The sample is just that, a sample. The column structure for the live data is different because it includes all your fields etc.

    https://wpgeodirectory.com/docs-v2/geodirectory/settings/import-export/#recommended

    March 18, 2020 at 5:23 pm #535644

    Nico Prinsloo
    Free User
    Post count: 6

    Yes that is how I understood it as I came across that info in an answer you provided elsewhere.
    Did my own csv before but because it had the same problem I used the example columns with my own info, which is the one I attached.

    March 18, 2020 at 5:59 pm #535647

    Alex Rollin
    Moderator
    Post count: 27815

    So you are saying you exported a listing and used that CSV?

    March 18, 2020 at 6:15 pm #535652

    Nico Prinsloo
    Free User
    Post count: 6

    Yes.
    The process was:
    exported the default example and expanded nr of columns to include my own column headings.
    imported that into GD on the site.
    when that gave me the “uncategorized” problem again, I exported the example and used it as is, with my own info (three entries).
    still put all three entries into “uncategorized”

    I am fairly sure that I have read most (if not all) the posts about the problem but none solved my problem, which is why I am convinced that I am doing something wrong on my side and will repeat that because I am in tunnel-vision now.

    Thanks for the help

    March 18, 2020 at 6:51 pm #535656

    Alex Rollin
    Moderator
    Post count: 27815

    That will not work.

    It sounds like you just downloaded the sample instead of adding a listing and then exporting.

    What do you mean by ‘example’? The same CSV?

    If you export, it should have columns to match every field, you should not need to add any columns to it.

    If you are indeed missing columns, add the fields first:
    https://wpgeodirectory.com/docs-v2/places/custom/

    March 18, 2020 at 7:05 pm #535658

    Nico Prinsloo
    Free User
    Post count: 6

    Sorry, “example” is “sample csv”
    I have all the fields correctly as I need it in my business directory.
    What I see at this stage is that the sample csv has a column “post_author” which my csv and custom fields settings do not have, but I will redo everything tomorrow my time (CAT) from the start again and come back to you.

    March 18, 2020 at 7:39 pm #535663

    Kor
    Moderator
    Post count: 16516

    Hi Nico Prinsloo,

    Thanks for your reply. If it’s still doesn’t work. Kindly share your CSV file along with your Website WP admin access here in private reply and we’ll check this out for you.

    Thanks!

    March 19, 2020 at 9:39 am #535699

    Nico Prinsloo
    Free User
    Post count: 6
    This reply has been marked as private.
  • Author
    Posts
Viewing 11 posts - 1 through 11 (of 11 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