Sedang Disiapkan

SQL Leads Database

We have a lead database of nearly 30 Million records. In order to better manage this data we require a lead management tool that allows for easy import and exporting of data.

First, we have a semi working model that can be used as a reference tool, but by no means is functional or tuned.

Please refer to: [url removed, login to view]

We require three basic functions:

1. Easily import data into the MySQL Database. All of our data is an XLS, CSV or a text file. Each file contains the same data, but some files contain more data and data headers than others. We need the tool to open a file, and request how the data /headers are mapped prior to importing the data.

Please refer to this link : [url removed, login to view]

This demonstrates how with the help of the drop down box how the import file is obtained. Second the file is selected and then forwarded to this page:

[url removed, login to view]

All files to be imported will reside in a specific folder or on the [url removed, login to view] files are fomated by MS Excel 2007, so some files contain upwards of one million records

When this page is selected, that data is imported into the table, then using the drop down menus the data is then mapped, and after the mapping process, the data is uploaded by clicking on the Insert Leads in to SQL table button.

Regardless of the data headers, a mapping process is required for each file to be imported.

Function # 2

This page demonstrates the fields/table how the data will be extracted

[url removed, login to view]

The basic function is to select minimum criteria so that leads can be searched, and the result can be exported. After the search has been completed, the results (leads) can be exported to an excel file. An export to excel SS is required.

If you select the state, and input Ca, you will find how the results are displayed

Searching leads is only possible to internal candidates, and by only the admin.

Function 3.

A static webpage will be available to website visitors (like this page : [url removed, login to view] ) with minimum access and restricted values displayed. When a visitor completes their search, a search ID will be displayed so the admin can recreate the search and export the data for transmission of data to the client via an excel SS and thu email.

We have an in house server with MySQL that is to be used for this project.

Kemahiran: Memasang Skrip, Reka Bentuk Laman Web

Lihat lebih lanjut: sql leads, sql in pl sql, request management tool, pl sql files, pl sql and, need sql help, import ms project, how to find leads, how to find a website for searching for working, for in pl sql, for all in pl sql, export house website, excel 2007 functions in excel, easy design tool, database design tool, client management tool, 100webspace import database, sql leads database model, 100webspacenet sql, SQL Server Admin, on sql, ms sql client, ms excel help, MS Excel 2007, lead box

Tentang Majikan:
( 16 ulasan ) Phoenix, United States

ID Projek: #278273