Excel Importing is not working

This topic contains 9 replies, has 3 voices, and was last updated by  Paolo 8 years, 5 months ago.

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

Open Support Ticket
  • Author
    Posts
  • November 15, 2015 at 2:43 pm #60251

    Abhishek Modi
    Buyer
    Post count: 205

    Hi, On importing listing using excel sheet, it says following things:

    Total 1 item(s) found.
    1 / 1 item(s) ignored due to already exists.

    The Listings I’m tring to upload have totally new ids or id, even i have export the live excel sheet. So it won’t disturb other “Ids”. I have also checked the PhpMy Admin Table as no “id” exist. I tried using new “Id” number but still getting the following error.

    If i go for “Update listing if post with post_id already exists.” As i don’t want to take risk as its a live site and may results in malfunctioning.

    Thanks

    November 15, 2015 at 2:56 pm #60253

    Guust
    Moderator
    Post count: 29970

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

    If you are using Excel then that will be most likely the problem.

    November 15, 2015 at 5:07 pm #60262

    Abhishek Modi
    Buyer
    Post count: 205

    Hi Guust, I have checked these Docs long before But Unable to get the solution that i’m looking for. Just tried with Difference in ids and its working but issue is how we know for which “ids” it will work or not. Suppose if i have imported with Id 1809, then 1810 is ignored due to same id. This is really a pain to check which are published and which are ignored.

    Thanks

    November 16, 2015 at 4:08 am #60289

    Guust
    Moderator
    Post count: 29970

    Right, now I see the problem I think. You cannot import new listings with an ID, IDs can only be used if you want to overwrite an existing one. WP needs to be able to assign its own IDs.

    Let us know if that is the problem.

    November 16, 2015 at 9:38 am #60298

    Abhishek Modi
    Buyer
    Post count: 205

    Yes Guust You are right. My Mistake Lack of Concentration :).

    Just last thing In excel when we upload image to folder, Its not creating other image variants compared to when we upload image from web. At the moment Featured image is missing, So the only solution left is open each post and click update then only its generating featured image & other image sizes.

    Thanks

    November 16, 2015 at 2:42 pm #60339

    Guust
    Moderator
    Post count: 29970

    GD does not create other image sizes, other than the size uploaded, to save server space.
    The first image for the listing is automatically the featured listing (or should be anyway).

    November 16, 2015 at 4:53 pm #60377

    Abhishek Modi
    Buyer
    Post count: 205
    This reply has been marked as private.
    November 16, 2015 at 11:03 pm #60494

    Guust
    Moderator
    Post count: 29970

    How do you get that image in the sidebar?
    Can you post the URL of that page?

    November 17, 2015 at 8:03 am #60528

    Abhishek Modi
    Buyer
    Post count: 205
    This reply has been marked as private.
    November 17, 2015 at 9:50 pm #60639

    Paolo
    Site Admin
    Post count: 31206

    Ok, I was able to recreate this. You shouldn’t be using a thumbnail for the featured image, but always the full size format and make sure that it is resized with CSS.

    The system cannot creates the thumbnails while imported (it would take too long), so it creates them only when saving each listings.

    The problem is in the functions used to show that image in the sidebar.

    Thanks

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

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

Open Support Ticket