I currently already have data in a mysql database that is pulled into random listings. Now i want to add a zip code search but i dont want to have to replicate the data into two databases - mine and this one? Is there a way to use the existing database to pull data back?

Mike D

Hello,

No, it is not really possible as each record for our locator has specific fields that must be accounted for. An example would be that our Locator is looking for the Pref, Hits and Hide fields and play an important role in how our locator works.

And I doubt your existing database table has these fields in there already. Plus they must be in a specific order.

Also does the database data come with zip code and longitude and latitute data already?

Yes, you get the full listing of USA zip codes with Lat/Long coordinates.

I have a dating service. Will I be able to use my current MSQL database or will I have to create a new database and if so, will the program allow me to switch between the two?

Hello htscpl,

I don't recommend using a different database table for your location records for UL. Our software is looking for a table named 'locations' and it must have 23 fields in a specific order to function. I doubt your existing table has these fields in it.

Sorry, there is no way to switch between databases.

OK... is it possible to create a table for 'UL' in my current database?

I am looking for an easy way to intergrate your software with my site. If I have to create a whole new database which is not connected to my site I don't see much use... perhaps I'm missing something?

My current database has zipcodes we just don't have a locater engin or fields. I know it is possible to do this and I am hoping 'UL' can fill the need.

H

*** BUMP ***

Yes, you can use an existing database.

UL install will create the needed tables in any database you choose. There are about 7 tables that need to be created for use with UL.

Let me also be clear, you can not use your existing table of data for your locator data. UL will use it's own table named 'locations' that will hold all your location records. You will have to populate this 'locations' table, either by typing them in or importing a file.

Also, sorry for the delay.