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-
AuthorPosts
-
June 18, 2019 at 8:55 pm #493674
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.
June 18, 2019 at 10:44 pm #493688Follow 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
June 25, 2019 at 10:22 am #494691Hi 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?
June 25, 2019 at 11:05 am #494699Ah, ok, please share WP Admin and FTP credentials in a private reply so we can take a look and fix that.
June 25, 2019 at 11:36 am #494704This reply has been marked as private.June 25, 2019 at 11:38 am #494708This reply has been marked as private.June 25, 2019 at 12:03 pm #494714The 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:”June 25, 2019 at 12:35 pm #494721This reply has been marked as private.June 26, 2019 at 9:48 am #494903Hi David,
Thanks for sending details. I will explore it and get back to you with update.
Thank you
June 27, 2019 at 10:44 am #495136Hi, did you manage to take a look at this?
June 27, 2019 at 11:52 am #495154Hello 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,
KiranJune 27, 2019 at 6:20 pm #495249Yes this is now working, thank you.
June 28, 2019 at 10:09 am #495305This reply has been marked as private.June 29, 2019 at 4:23 am #495393We 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.
July 1, 2019 at 12:37 pm #495643This 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?
-
AuthorPosts
We have moved to a support ticketing system and our forums are now closed.
Open Support Ticket