List Info

Thread: Best way to sync venue IDs




Best way to sync venue IDs
country flaguser name
United States
2007-06-05 09:00:36

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

__._,_.___
.

__,_._,___
Re: Best way to sync venue IDs
country flaguser name
United States
2007-06-05 12:25:04

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%40yahoogroups.com">yws-eventsyahoogroups.com, "Allen" <madtownlounge...> wrote:
&gt;
> 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
&gt; madtownlounge.com
>

__._,_.___
.

__,_._,___
[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )