Mapping Events to Places during Import

This topic contains 19 replies, has 5 voices, and was last updated by  Dave 5 years, 4 months ago.

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

Open Support Ticket
  • Author
    Posts
  • #493674

    Dave
    Full Member
    Post count: 205

    We have a CSV file that contains data for both events and venues (places). I’m going to import this once to create all the places, then run it again to import all the events (obviously copying the required columns to the correct import templates).

    Question is, how do I map the events to the places previously created?

    Each line of the CSV contains all data for the event and the place associated with it, including unique place IDs, lat/long and zip codes, but I can’t see any way to perform any kind of function or mapping using GD’s import tool?

    I looked at using WP All Import but because GD saves data for the custom post types to its own tables instead of the post_meta table it doesn’t find the custom fields. That said, it does allow you to run functions so could conceivably run a function to map all the data but it would be slow.

    37,000 lines in total, I think I’ll test with just the first 5.

    #493688

    Alex Rollin
    Moderator
    Post count: 27815

    Follow our recommended procedure which says, in short, add a listing with all the representative data first and export it. In your case, add a place, then add and event and link it, then export to see how it works. Next merge your data into those csf files.

    https://wpgeodirectory.com/docs-v2/geodirectory/settings/import-export/#recommended

    #494691

    Dave
    Full Member
    Post count: 205

    Hi Alex,

    I have edited an event and mapped it to a place in the “Where is the event taking place?” field but when I save it and the page refreshes that field is empty again.

    I’m assuming this is the correct procedure – map an event to a place, export all events and use the template to see how they are mapped so I can replicate this when importing our other events?

    If I update other info for the event this is saved, but not the location. Also, if I have selected a place that the event is taking place at, why would the event have address fields that are required, when these should be pulled from the place you have linked it to?

    #494699

    Alex Rollin
    Moderator
    Post count: 27815

    Ah, ok, please share WP Admin and FTP credentials in a private reply so we can take a look and fix that.

    #494704

    Dave
    Full Member
    Post count: 205
    This reply has been marked as private.
    #494708

    Dave
    Full Member
    Post count: 205
    This reply has been marked as private.
    #494714

    Alex Rollin
    Moderator
    Post count: 27815

    The developers cannot apply a fix without FTP.

    “WordPress Credentials
    WP Admin Login URL:
    WP Admin Username:
    WP Admin Password:

    FTP Credentials
    FTP Host:
    FTP Port:
    FTP User:
    FTP Password:”

    #494721

    Dave
    Full Member
    Post count: 205
    This reply has been marked as private.
    #494903

    Naveen Giri
    Moderator
    Post count: 1559

    Hi David,

    Thanks for sending details. I will explore it and get back to you with update.

    Thank you

    #495136

    Dave
    Full Member
    Post count: 205

    Hi, did you manage to take a look at this?

    #495154

    Kiran
    Moderator
    Post count: 7069

    Hello David,

    It seemed to work, but once saved the field was empty again.

    We have recently updated post linking and now we allowed admin to link posts from any users. In links_posts field there is option to enable/disable linking from different users. If that option is disable then UserA can’t link his post to UserB’s post.

    But now we allowed admin to link posts from any users, it does not matter option is enabled or disabled.

    I have applied patch on your site. Please check and let us know.

    Regards,
    Kiran

    #495249

    Dave
    Full Member
    Post count: 205

    Yes this is now working, thank you.

    #495305

    Dave
    Full Member
    Post count: 205
    This reply has been marked as private.
    #495393

    Alex Rollin
    Moderator
    Post count: 27815

    We are considering how to auto-populate based on linked posts but it has not yet been implemented and we do not yet have a timeline.

    I have added your topic to the task and we will place an update here when available.

    #495643

    Dave
    Full Member
    Post count: 205

    This poses a fundamental problem to the way the search works – these events need to be found based on the location of the place they are linked to, not based on any address details that might be entered for the place listing.

    How do we resolve this?

Viewing 15 posts - 1 through 15 (of 20 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