Ditutup

upgrade search function

PROJECT SUMMARY

Objective: Upgrade search functionality on 2 websites.

This project involves the following steps:

1. Write an API program that allows our search server (running Microsoft Search Server 2008) to retrieve data from our database server.

2. Write an API program that allows our web server to retrieve search results from our search server.

3. Modify the ASP code on our 2 websites to allow search results to be displayed in the same format as our current search results are displayed.

This project requires a programmer who knows ASP, API programs, SQL databases and Microsoft Sharepoint Services.

All of our server run Windows Server 2003 operating systems. The 3 servers involved in this project include:

1. everest – runs our Everest software which uses Microsoft SQL Server 2005 database. Everest software runs our entire business including our website ([url removed, login to view])

2. search – runs Microsoft Search Server 2008

3. web02 – runs Microsoft Internet Information Server 6 and Everest Shop Administrator

We have 2 websites each with its own unique design but both are pulling from the same back end SQL database, which runs on our Everest server. We have [url removed, login to view] and [url removed, login to view] We have over 13,000 items in our database. Both websites need a better search function.

We have already installed a new server running Microsoft Search Server 2008. This server uses an SQL database and queries our everest SQL database server every 15 minutes for updates. The search server needs an API program to be able to pull the needed data from the everest server.

The search function and search results from the search server need to be integrated into the javascript asp content pages of our 2 websites to replace the current search function. We need help modifying at least 2 files on each site which are used by most of our pages, called [url removed, login to view] and [url removed, login to view], so it will display the search results in the same format that our current search results are displayed, with images, descriptions and pricing information.

I think the only pages that have to be modified are [url removed, login to view] and [url removed, login to view] but that might not be correct. The other asp pages have to work with [url removed, login to view] so they also might have to be modified slightly.

Our websites run with dynamic content pulling from the everest SQL database server. Both websites were developed by Everest Software Inc. You can visit their website at [url removed, login to view]

We upgrade our Everest software at least once each year so we will have new projects to update these settings each time we upgrade.

The search results coming from the Microsoft Search Server should look the same as the search results currently displayed on our 2 sites at [url removed, login to view] and www.homeschooldiscount.com. Each site has its own unique design so the page layouts will be different.

Search results should display the following for each result found:

1. item title (40 characters)

2. image (100 pixels x 100 pixels)

3. brief description (initial 300 characters from the web description)

4. Retail price - our system refers to this as the fixed price or level 1 price

5. Our Price - our system refers to this as the level 2 price

6. Link to item description page if it is an item ([url removed, login to view])

7. Link to kit description page if it is a kit ([url removed, login to view])

8. Add to Cart button

9. Our current search results do not include category pages but we would like to include them if possible ([url removed, login to view]). It would be great to list the categories where search results were found and display the number of search results found in each category with a number in parenthesis.

We would also like to be able to integrate the search function into our static .htm pages so we need the code to paste the search tool onto those pages.

Our pages are in .asp format using Javascript (or Java or Jscript?). I can send page files for you to review.

All of our data comes from SQL Server 2005. Our internal users access the database through an interface program called Everest, from Everest Software Inc.

For this job, you would need to speak with Jason, our network IT guy who configured the Microsoft Search Server. The search data will have to come from that server, but that server is getting the data from the SQL Server.

We have a test web server so you can do all testing there. We can publish to the live web server after everything works. The coder will get everything working successfully on the test web server. Jason or I will then publish the code to the live web server.

This is a new search function for us so we will likely need to make adjustments to how the searches are performed to achieve the most relevant search results. We will need to specify which data fields are searched and the priority given to each one. At this time, I do not know whether that has any impact on this project but it might.

Beyond that, we are open to enhancing the way the search results are displayed, especially with including category pages in the search results. Category pages could be displayed in the left column or at the top of the search results. They should include counts on search results found within each category and could possibly include image files too.

SEARCH FUNCTION PRIORITIES

The following provides the list of fields we want to include in the search results. These are listed in order of priority. These tables and fields are located in our SQL database, which is located on our Everest server.

Our search server, which is running Microsoft Search Server 2008, also has it’s own SQL Server. However, that server requires an API script to be able to pull data from the Everest server.

Our web server requires an API script to pull the search results from the search server.

Search function should be set to search ‘All Words’ and ‘Exact Words’ included in the search field. The search results should not include searches from ‘Any Words’ included in the search field.

The fields that need to be searched are listed below for each of our websites.

Search field priorities for [url removed, login to view]

TABLE FIELD FUNCTION

Items CUSTCHAR3 Brand Description

Items CUSTMEMO4 Page Title

Items DESCRIPT Item Description

Category DESCRIPT Category Description

Category WEBDESC Category Web Description

Category WEBDESC_SUMMARY Category Web Summary Description

Category PARENTCAT Parent Category Description

Items CUSTMEMO3 Item Meta Description

Items WEBDESC_SUMMARY Item Web Summary Description

Items WEBDESC Item Web Description

Items MODEL Model Number

Items CUSTCHAR2 ISBN Number

Items ITEMNO Item Code

Item_Eq EQ_CODE Item Alias Code

Search field priorities for [url removed, login to view]

TABLE FIELD FUNCTION

Items CUSTCHAR3 Brand Description

Items CUSTMEMO1 Page Title

Items DESCRIPT Item Description

Category DESCRIPT Category Description

Category WEBDESC Category Web Description

Category WEBDESC_SUMMARY Category Web Summary Description

Category PARENTCAT Parent Category Description

Items CUSTMEMO2 Item Meta Description

Items WEBDESC_SUMMARY Item Web Summary Description

Items WEBDESC Item Web Description

Items MODEL Model Number

Items CUSTCHAR2 ISBN Number

Items ITEMNO Item Code

Item_Eq EQ_CODE Item Alias Code

Please configure the search server to search in this order of priority.

Please provide us with your bid price for completing this project. Our servers are ready and waiting. We are very eager to implement this project as soon as possible. Thanks!

Kemahiran: ASP, Javascript

Lihat lebih lanjut: search server javascript api, asp search function, work search, software developed microsoft, get job coder, web sites developed java, website getting software developed, web search tool, web search images, web searches database, web programmer get job, want windows back, unique page layouts, top search categories, top job search websites, top job search sites, top java websites, top 2005 programmer, thanks great year, systems administrator job description, systems administrator job, system administrator job description, static interface, sql server price list, software testing websites

Tentang Majikan:
( 0 ulasan ) Cumming, United States

ID Projek: #301534

18 pekerja bebas membida secara purata $2177 untuk pekerjaan ini

Maestros

Plz Chk PMB

$2950 USD dalam 30 hari
(32 Ulasan)
7.4
shmai

have a glance at PM. Regards,

$2786 USD dalam 12 hari
(178 Ulasan)
6.9
consultingpalace

price and time frame negotiable.

$3000 USD dalam 45 hari
(15 Ulasan)
6.8
BestWeb4U

Dear Sir/Madam I am very happy if you choose me as a freelancer who work for you. I can do this project,expertized, professional with an experience of 7 years in making website designs, graphic designs, logo designs, Lagi

$2200 USD dalam 15 hari
(42 Ulasan)
6.0
teckit

Check PM for details

$3000 USD dalam 45 hari
(10 Ulasan)
5.8
rshyethmusthafa

I can do this

$2000 USD dalam 25 hari
(19 Ulasan)
4.4
philom007

Hello, I have checked your all information carefully, and i think it is no problem to do it, so pls feel free to pm me your ideas, then let us start to work on it, and i will provide you the best quality and the de Lagi

$1800 USD dalam 15 hari
(7 Ulasan)
4.3
ThetaPi

The bid delivery time is tentative, please see Project Clarification Board. UPDATE: After some test coding, I believe initial work could be completed in 15 days (I originally bid 30). However, if you could provide s Lagi

$1600 USD dalam 15 hari
(7 Ulasan)
3.8
crvenk

Hello, Please do check your PMB. Regards, Saravanan.K

$2500 USD dalam 30 hari
(3 Ulasan)
3.3
taylantech

Hi, We are Atlanta based web development firm. We can assist you professionally. Please see your PM for our credentials. Kind Regards

$2500 USD dalam 20 hari
(0 Ulasan)
0.0
Pennentsoft

Hi , We,Pennentsoft an Indian based company committed in doing all sort of IT services and supports which includes : * E Commerce * Intranet * Internet based application * Database Maintenance * Products Lagi

$2000 USD dalam 20 hari
(0 Ulasan)
0.0
mrawls1954

Our company has a GREAT idea to fix some of your problems by using RSS- and our script that will do what your doing in about 1/2 the time Plus transfer that regenerated information with-in an portal that will manage th Lagi

$2850 USD dalam 22 hari
(0 Ulasan)
0.0
bonerich

Hi, We are ready to get start with your project with our excellent team of 290+programmers, designers & Project Managers. Please check your PMB for more details. Your requirement would be fulfilled as we assure 100% qu Lagi

$1500 USD dalam 15 hari
(0 Ulasan)
0.0
dinfocom

Dear Sir, We are London and India base web development company. Our technical team is very strong on .NET and PHP technology using MS SQL and MY SQL server, AJAX, XML, FLASH, JAVA SCRIPT. We have already analyzed Lagi

$1500 USD dalam 30 hari
(0 Ulasan)
0.0
xpedient

we have done these kind of work so we can provide you this solutions much faster

$1500 USD dalam 20 hari
(0 Ulasan)
0.0
Technoscore

Check the PM

$2400 USD dalam 30 hari
(0 Ulasan)
0.0
semosoft123

We have gone through the information that you have provided and understand your requirements very well. We have excellent expertise in PHP5, MYSQL, DRUPAL, JOOMLA, HTML, CSS, AJAX, JAVA, J2ME, JSP, SEO, SEM, ASP.NET, V Lagi

$1600 USD dalam 15 hari
(0 Ulasan)
0.0
titonmoy

Hi, Your job posting sparks my attention, I may fit for this job. With more than 6 years experience in software development I have works in various cutting age technologies of Microsoft. I have worked as software ar Lagi

$1500 USD dalam 20 hari
(0 Ulasan)
0.0