Export question regarding venues

[William]

A programmer friend of mine has volunteered to assist with a task I’ve seen other posters struggle with — readying a calendar export for print. There’s one aspect I’m not sure about though. My plan is get a .csv file with Date-TimeStart-TimeEnd-Title-Desc-Location-Cost-Website-Email-Phone, or something to that effect. From there we can tweak the way dates and times are displayed and create line-breaks, whatever’s needed. But with the address and city in a different file, I’m not sure how we’d connect the two. I was guessing there would be a Venue_ID that would appear on both exports and they could be linked that way, but that doesn’t seem to be the case. Any thoughts on how we might be able to include the address? Thanks!

[Josh]

Hey William,

Thanks for reaching out to us!

How will you be exporting the information? If you’re grabbing the events and the associated meta, you can grab the “_EventVenueID” for the event to get the associated venue. You could then use the id to grab the venue information that you would like to use for the events.

Let me know if this helps.

Thanks!

[William]

Thanks as always for your prompt response! I was able to figure it out. I was looking for a venueID field in the venue export, but I should have been looking at the plain old postID. postID in the venue export = venueID in the event export.

[Josh]

Hey William,

No problem, happy to help!

I’ll go ahead and close this thread for now. If you have any further questions, please don’t hesitate to open a new one.

Thanks!

[Author]

Posts