40% OFF EVERYTHING
Our 10th BIRTHDAY SALE
Buy Now

Category post's

This topic contains 20 replies, has 3 voices, and was last updated by  Dotty Directory 7 years, 11 months ago.

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

Open Support Ticket
  • Author
    Posts
  • May 24, 2016 at 11:45 am #197125

    Dotty Directory
    Full Member
    Post count: 254

    When importing no categories are being included, i have tried cat_name. cat_slug and cat_id.

    Any idea why?

    I’ve applied these to both default_category and post_category

    May 24, 2016 at 12:18 pm #197133

    Guust
    Moderator
    Post count: 29970

    Are the categories already existing?

    The correct column name is post_category. Export your listings to see the correct format for the file.

    https://wpgeodirectory.com/docs/core-export/#mandatory

    May 24, 2016 at 12:44 pm #197172

    Dotty Directory
    Full Member
    Post count: 254

    Yes the categories already exist

    May 24, 2016 at 1:09 pm #197181

    Guust
    Moderator
    Post count: 29970

    Can you post URL, WP admin details and CSV file in a private message if you need us to investigate.

    May 24, 2016 at 2:10 pm #197233

    Dotty Directory
    Full Member
    Post count: 254
    This reply has been marked as private.
    May 24, 2016 at 2:13 pm #197235

    Dotty Directory
    Full Member
    Post count: 254
    This reply has been marked as private.
    May 24, 2016 at 2:19 pm #197237

    Dotty Directory
    Full Member
    Post count: 254
    This reply has been marked as private.
    May 24, 2016 at 2:26 pm #197239

    Guust
    Moderator
    Post count: 29970

    Is that sample CSV exported?
    It has no categories, the addresses are in the wrong columns, the order of the columns does not seem right, no lat or lng.

    Add a few listings from the frontend, then export, and use that as a basis.

    May 24, 2016 at 2:31 pm #197240

    Dotty Directory
    Full Member
    Post count: 254

    no its part of what i used to upload, it completed 1200 approx, 100 are down to the locations not known, and the last lot were the error above

    May 24, 2016 at 2:41 pm #197242

    Dotty Directory
    Full Member
    Post count: 254
    This reply has been marked as private.
    May 24, 2016 at 3:43 pm #197271

    Dotty Directory
    Full Member
    Post count: 254

    I have tried searching for hidden characters but cant find any. Any idea what could be in the contents of the first record

    May 24, 2016 at 6:38 pm #197352

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    the CSV file is totally unformatted. Columns have been moved around and there are columns that the system will not recognize:

    original number for trade
    Address2
    Address3

    Please use the sample file as provided and do not move headings around.

    If you add custom fields, make sure to add the new columns at the end and to use the right heading.

    geodir_html_variable (where html variable is the unique variable you assigned to each custom fields).

    Hope this helps.

    Let us know,

    Thanks

    May 25, 2016 at 8:25 am #197688

    Dotty Directory
    Full Member
    Post count: 254

    Ive had a look using notepad++ is CR, LF supported ?

    Turns out there are hidden characters in a few places

    May 25, 2016 at 10:59 am #197768

    Dotty Directory
    Full Member
    Post count: 254
    This reply has been marked as private.
    May 25, 2016 at 11:58 am #197816

    Guust
    Moderator
    Post count: 29970

    1. missing columns: Add a few listings from the frontend, then export, and use that as a base CSV file.

    2. Read this: https://wpgeodirectory.com/docs/core-export/#important
    Do not change the order or the names of the columns of the CSV files.
    Do not delete any columns.

    3. You still have invalid characters, Electrical�is a local etc

    4. Do you use OpenOffice or LibreOffice as required?
    https://wpgeodirectory.com/docs/core-export/#important

    5. You have regions that do not match the Google Map API.
    See https://wpgeodirectory.com/docs/definitions/#location
    For example Preston should be United Kingdom, Lancashire, Preston [country, region, city].

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

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

Open Support Ticket