Problem importing

This topic contains 7 replies, has 2 voices, and was last updated by  Guust 7 years, 7 months ago.

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

Open Support Ticket
  • Author
    Posts
  • August 23, 2017 at 7:07 pm #392585

    Elaine Benjamin
    Expired Member
    Post count: 29

    Hi, When I try importing the attached CSV file out of over 100 entries only 3 import (lines, 99,121/122 and 159) even though they are identical to the other entries in layout.

    Can you assist at all?
    Thanks

    August 23, 2017 at 7:56 pm #392593

    Elaine Benjamin
    Expired Member
    Post count: 29
    This reply has been marked as private.
    August 24, 2017 at 6:43 am #392620

    Elaine Benjamin
    Expired Member
    Post count: 29
    This reply has been marked as private.
    August 24, 2017 at 12:36 pm #392694

    Guust
    Moderator
    Post count: 29970

    Is that file compiled with Open Office? Or Excel?
    https://wpgeodirectory.com/docs/core-export/#important

    There are quite a few entries in wrong columns, see image.
    It seems some of the entries are comma delimited and others are not.

    Thanks

    August 24, 2017 at 1:09 pm #392699

    Elaine Benjamin
    Expired Member
    Post count: 29

    Hi,

    Thanks for the reply, the file was originally in excel I have downloaded open office and recreated the file as attached it is still not importing. I am obviously doing something else wrong but have no idea what! Can you please assist? Thank you

    August 24, 2017 at 1:11 pm #392701

    Elaine Benjamin
    Expired Member
    Post count: 29

    post_id post_title post_author post_content post_category default_category post_tags post_type post_status is_featured post_date post_address post_city post_region post_country post_zip post_latitude post_longitude geodir_timing geodir_contact geodir_email geodir_website geodir_twitter geodir_facebook geodir_video geodir_special_offers geodir_price geodir_property_status geodir_property_furnishing geodir_property_type geodir_property_bedrooms geodir_property_bathrooms geodir_property_area geodir_property_features IMAGE IMAGE IMAGE IMAGE IMAGE IMAGE IMAGE IMAGE IMAGE IMAGE IMAGE
    786 Law Associates 1 Immigration solicitors in Barking – specializing in most types of immigration to the UK, deals with entry clearance applications from outside the UK, and applications to the Home Office. Immigration Immigration Immigration gd_place publish # 786 Law Associates Essex London United Kingdom IG11 8BB 51.537286 0.069943 020 3137 7866 http://786-law.co.uk http://www.comparelawyers2u.co.uk/wp-content/uploads/2015/12/add-logo-220.jpg
    A & A Solicitors LLP 1 Criminal defence solicitors in Edgware also specialising in immigration law, employment law, civil litigation, wills, probate, divorce and family, matrimonial and dispute resolution. Criminal Criminal Criminal gd_place publish # A & A Solicitors LLP NW London London United Kingdom HA8 7BJ 51.612057 -0.27714 020 3441 3359 http://www.aasolicitors-llp.com/ http://www.comparelawyers2u.co.uk/wp-content/uploads/2015/12/add-logo-220.jpg

    August 24, 2017 at 1:12 pm #392702

    Elaine Benjamin
    Expired Member
    Post count: 29

    File was saved as an open office csv file

    August 24, 2017 at 1:13 pm #392703

    Guust
    Moderator
    Post count: 29970

    If you copied and pasted from the excel file, that will be your problem, it will have brought some errors with it most likely.
    You should create a CSV file starting in OpenOffice, without copying from Excel.

  • Author
    Posts
Viewing 8 posts - 1 through 8 (of 8 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