Search the web
Sign In
New User? Sign Up
yws-events · Yahoo! Events/Upcoming Dev Support Group
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want to share photos of your group with the world? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Best way to sync venue IDs   Message List  
Reply | Forward Message #167 of 342 |
Re: Best way to sync venue IDs

I'm not sure there's a magic bullet for reconciling your venues and
ours. If you find one, let us know -- you'd help us reduce duplicates
within the Upcoming database!

Anyway, have you already tried a batch process to match all venues in
your db against ours? If you haven't tried it yet, you may find that
many match well, and the remainder are a manageable number to check by
hand.


--- In yws-events@yahoogroups.com, "Allen" <madtownlounge@...> wrote:
>
> I'm curious if anyone else has run across this: my site is an
> entertainment/music website for the Midwest currently, and I have
> roughly 10,000 venues in my system. I would like to add a field to my
> tPlaces (venues) table to hold the Upcoming venue_id. That way when I
> submit new events to Upcoming, I can send the proper venue_id without
> any additional overhead.
>
> If that isn't possible or easy, how are other folks getting the
> venue_id before adding a new event? If you use the venue methods, who
> is to say you won't get more than one record returned?
>
> Just a new person to the forum with a couple questions - thanks for
> any replies.
>
> Allen
> madtownlounge.com
>





Tue Jun 5, 2007 5:25 pm

neilk_yinc
Offline Offline
Send Email Send Email

Forward
Message #167 of 342 |
Expand Messages Author Sort by Date

I'm curious if anyone else has run across this: my site is an entertainment/music website for the Midwest currently, and I have roughly 10,000 venues in my...
Allen
madtownlounge
Offline Send Email
Jun 5, 2007
2:01 pm

I'm not sure there's a magic bullet for reconciling your venues and ours. If you find one, let us know -- you'd help us reduce duplicates within the Upcoming...
neilk_yinc
Offline Send Email
Jun 5, 2007
5:28 pm

Neilk, Thanks for your reply - kinda what I figured. I certainly know how duplicate venues are undesirable - I really try to minimize (or eliminate) those as...
Allen
madtownlounge
Offline Send Email
Jun 5, 2007
6:17 pm

I think you've been a bit misinformed -- Upcoming.yahoo.com is a different site from EVDB. But, here's how you would look for that venue on Upcoming. And...
neilk_yinc
Offline Send Email
Jun 5, 2007
7:22 pm

Oops - got my wires crossed. I'm trying to integrate with both Upcoming.org and Eventful.com (has an evdb agent) - my bad. At any rate, I face the same...
Allen
madtownlounge
Offline Send Email
Jun 5, 2007
7:29 pm
Amanda McHale
silver_locust
Offline Send Email
Jun 5, 2007
8:35 pm

Here is my very quick, very dirty solution - I'm sure I could refine it a bit, but it works. It's written in classic ASP/MySQL which runs on Windows/IIS: ...
Allen
madtownlounge
Offline Send Email
Jun 5, 2007
8:21 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help