Import not working from export

This topic contains 9 replies, has 4 voices, and was last updated by  Garth Lategan 8 years, 9 months ago.

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

Open Support Ticket
  • Author
    Posts
  • #270339

    Garth Lategan
    Free User
    Post count: 4

    I’ve tried everything to import my data

    So I exported my data as I have two listing in there.

    I then just imported the same I just exported and I still get the error
    Total 2 item(s) found.
    2 / 2 item(s) could not be added due to blank title/invalid post type/invalid characters used in data.

    I have also opened the fill on open office calc and then save it but that did not work either.

    I have attached the file that I exported and then tried to import

    I have also attached the file that I am trying to import

    #270691

    Paolo
    Site Admin
    Post count: 31211

    Hi,

    the 1st file (export) looks correct, the second file has post_type and post_status filled only for the 1st row.

    If you provide a link and admin credentials in a private reply (only our staff can read them), we will have a better look.

    Let us know,

    Thanks

    #270994

    Garth Lategan
    Free User
    Post count: 4
    This reply has been marked as private.
    #271309

    Paolo
    Site Admin
    Post count: 31211

    Hi,

    I believe the problem are addresses. Google Maps treats Australian suburbs as cities.

    For example, the 1st address on your CSV file: “325 Johnston Street Abbotsford”

    Is returned to be an address in City of Yarra, not Melbourne. You will need the location manager add-on to be able to import these listings successfully.

    However I can’t find out why the export file cannot be re-imported to update existing listings.

    I asked to a developer to have a look and let us know.

    Thanks for your patience,

    #271314

    Garth Lategan
    Free User
    Post count: 4

    On that’s annoying so the free plugin is no good in Australia without purchasing the product.

    I hesitant to purchase the product as it has not been easy to use and just the basic features are not working.

    Thanks for your help IM keep me posted I’m keen to role this platform out

    #271827

    Kiran
    Moderator
    Post count: 7069

    Hi Garth,

    I have done some test by importing csv file version-2.csv that you attached, and it successfully imported without any error.
    Please check attachment import-version-2.csv.png

    I have tested re-import by exporting file and importing same file, it also worked fine.

    When tried to import file gd_place_2109161058.csv that you attached after import seen some messages. Please check attachment import-gd_place_2109161058.csv.png.
    1 item successfully imported because that row has all data correct.
    17 items have invalid characters in address field.
    135 items have empty post_type field. You must fill post_type field for all items.

    You can also debug import process if site has debug log enabled (https://codex.wordpress.org/Debugging_in_WordPress#WP_DEBUG_LOG).
    If debug enabled on site then the import process will log the items which has problem in import. So you can easily find which row has the problem and what is the problem.

    All 136 items successfully imported when removed invalid characters from 17 rows and adding post_type for all rows. Check attached file working-gd_place_2109161058.csv which is modified and working fine.

    Let us know.

    Thanks,
    Kiran

    #271885

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hmm, i replied here yesterday but it seems to have not went through, i had mentioned that Google api splits the outskirts of Melbourne into different cities, and only the center will return as actual Melbourne.

    Stiofan

    #271887

    Garth Lategan
    Free User
    Post count: 4

    I guess What I need from your team.

    What is it going to cost me to get this plugin working.

    What add on do I need to purchase and what support can you give me to get this upload to work correctly with the right postcodes.

    #271888

    Stiofan O’Connor
    Site Admin
    Post count: 22956
    This reply has been marked as private.
    #271889

    Garth Lategan
    Free User
    Post count: 4

    skype is **REMOVED**

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
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount