GD Import CSV issues

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

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

Open Support Ticket

Tagged: 

  • Author
    Posts
  • October 26, 2016 at 4:16 pm #292276

    Alistair Williamson
    Full Member
    Post count: 415

    Hi,

    I read this forum discussion with interest.

    https://wpgeodirectory.com/support/topic/wp-all-import-addon-maybe-soon/

    A lot of times I find forum discussions are closed without a firm conclusion, so please forgive me, I am writing about the previous discussion again.

    I have been experiencing problems importing data; thus far I have only been importing c. 100 records at a time but it isn’t straightforward and shortly I plan to import 80,000 records, so I am anxious to get this right.

    Thus far I have experienced:

    – GD changing imported addresses and geocodes – please see
    https://wpgeodirectory.com/support/topic/map-marker-2-brands-same-location/

    – duplication of records – my fault but very easily done – the fix not so easy – I had to delete my import and start again 🙁 OK with 100 listings but not 1000’s
    – importing anbd then exporting and adjusting in OpenOffice -I don’t like OpenOffice at all btw – is very time consuming – is there a better way? Did the other 3rd party plug in mentioned ever become compatible with GD?
    – Please, please, please could the listing ID be shown in the backend to enable identification of duplicates etc. Could the ID be sortable and searchable. At the moment it is very difficult or impossible to match a CSV in Openoffice with the backend listing. I think the ID would help enormously
    – I have been trying to add the same photo and company logo to the 100 listings being imported. I have been importing the CSV, the copying the file path to the other listings in Openoffice to speed replication of photos in all listings and then reimporting the CSV. I get an error message and duplication of the photos in the media area even though the filename is the same? What am I doing wrong please?

    Very concerned about the 80,000 records I plan to import. I have calculated it will take 24 hours to import and I would like to definitely avoid the above problems. Is there a faster way to import the data?

    Appreciate your help and advice as always.

    Bests

    Al

    October 26, 2016 at 10:02 pm #292472

    Guust
    Moderator
    Post count: 29970

    1.Sometimes users end up fixing the problem based on the advice, but never come back to let us know. The topic then gets auto-closed after a while.

    2. If you just want to change the marker position and nothing else in the backend, make a note of the address, drag the marker, correct any address bits that changed and save the listing.

    3. If you actually import duplicates, use the data column to sort them by the latest. That will make it easy to delete them again. Or make a backup of your database before you do a big import, which is best practice anyway.

    4. A duplicate listing does not have the same ID, so sorting by ID would not assist. Please see #3.
    Also review https://wpgeodirectory.com/docs/core-export/#import about post_IDs

    5. You can just use the same image file name in the IMAGE column, for example van.jpg.
    Then uploading that image to the current month upload folder will add that same image to all listings.
    https://wpgeodirectory.com/docs/core-export/#images

    6. Import speed is governed by the server, that is basically the only variable in the process.

    October 27, 2016 at 4:40 am #292646

    Alistair Williamson
    Full Member
    Post count: 415

    Hi Guust,

    Thanks for this.

    2. I wasn’t aware you could drag the map marker in the backend – this is really helpful.

    3. I understand your point about duplicates. If this does happen and there are 1,000,s of dupes it would be very time consuming to delete them 20 at a time from the backend. Is there a way of speeding this up?

    4. I proposed showing the ID in the backend so that it is easy to compare any listing in GD with a corresponding exported CSV file in OpenOffice.

    Thanks for your help.

    Al

    October 27, 2016 at 11:28 am #292741

    Guust
    Moderator
    Post count: 29970

    3. Up the top of the Places screen in the backend, click on “screen options” and change from 20 to 200 or 500. That will make it a lot faster.

    4. You can sort all Places in the backend and the CSV by Title alphabetically? Then you can compare?

    October 27, 2016 at 4:28 pm #292992

    Alistair Williamson
    Full Member
    Post count: 415

    Hi Guust,

    3. Thanks for this – hadn’t spotted this one -still learning 🙂

    3/4. The challenge is that I have many ‘dealer CPT listings’ but with a different brand being represented with virtually the same business name and it is then difficult to pick the right listing. I still feel the display of the post ID would be helpful when comparing exported listings in OpenOffice with backend data – over 2 monitors. Could it be user optional to display the post ID like the other ‘screen options? – please see attached’

    Bests

    Al

    October 27, 2016 at 4:41 pm #292999

    Paolo
    Site Admin
    Post count: 31211

    Hi,

    I’m sorry, but adding the ID there isn’t really a quick thing to do.

    You can get the id of each listing by just hovering the listing title and check the ID in the corresponding link: see image attached

    Thanks

    October 27, 2016 at 5:11 pm #293017

    Alistair Williamson
    Full Member
    Post count: 415

    Hi Paolo,

    No worries.

    Thanks for pointing that out.

    I can work round it now.

    Much appreciated.

    Al

    October 27, 2016 at 5:16 pm #293018

    Paolo
    Site Admin
    Post count: 31211

    You are welcome 🙂

  • 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