PDA

View Full Version : Searching Database Info



VictorZ
06-28-2005, 09:35 PM
:cry:
I am trying to develop a website for a Building Consultancy Society.

Is it possible for Zoom to search an Access (*.mdb) databse file where members details have been provided (created) to provide search results by - say PostCode, or Member Expertise and the like?

If so I would appreciate some advice.

Thanks in advance.

Ray
06-29-2005, 02:06 AM
Only if you have a website front-end which serves the data in the form of webpages (eg. using a server-side scripting language such as PHP, ASP, CFM, ASPX, ... etc.). See this FAQ for more information:
http://www.wrensoft.com/zoom/support/faq_howto.html#sql

Zoom can not however, directly index content from a .mdb file.

VictorZ
06-29-2005, 05:29 AM
:D

Thanks for the response.

If I were to create an XLS (*.csv) file would the same apply?

Or could the Zoom search the *.csv file using the plugin??

Ray
06-29-2005, 05:37 AM
CSV is actually a text file format, which Zoom can index without any special plugin. All you have to do is add ".csv" in the Scan Options -> Extensions list of the Configuration window.

Note that the results would simply point to the contents of the CSV file. So there would be no special formatting of the results that appear in the context descriptions. You can try this out for yourself with the Free Edition and see if it suits your requirements.

The Excel plugin is used to index .xls and .xlt files only.

VictorZ
06-29-2005, 06:40 AM
:D
Thanks - this is great result.

Cheers