Acces Leads import

In Progress

A small? call center wants a program to import leads files into one access? database.? The procedure needs to be simple so that leads can be imported using txt csv and excel.? Fieldname mapping is done on-the-fly.? Duplicate leads need to be reported.? A report needs to be created which allows a manager to print them out with filters.

## Deliverables

If you know about a solution similar thats already created, I will consider purchasing that also.

I need a program that allows an operator to import lists of names, addresses? from different sources (at least TXT, CSV and excel).? The data may need to be cleaned.? These all go into one table.? The leads are marked with the date of import and the description given by the operator.

**Logic during import**

* phone numbers and zip codes are scrubbed of non numericals

* results are logged in a second table (leads imported, duplicates not imported, time and description)

* The operator can preview the import data

**Logic during print**

* The operator selects from filters (state, income, description)

* The operator selects print and the lead is marked with date of print

* number of times printed is incremented

The program will work like this.? 1.? The user has a choice of either printing leads or importing leads.? 2.? The user selects import leads and will be walked through matching fields to be imported.? 3.? The user selects print leads and is asked how many to print.? The report will be filtered based on a few simple criteria.? When the report is printed, information is saved in the database to indicate the lead is printed and when.

Other features:

* The user can undo the import

* The program is built in two parts.? ? File 1 is the data tables, File 2 is the programming and reports.

* The import requires the user to give a description of the import and the date and description are recorded in the access db.

* Errors upon import are ignored and the import continues

This is only the first part and depending on how it goes, can be a much bigger project.

Extra information


**Leads Table Fields:**


**Import Log Fields

**ImportID? Date/time? Description? Filename? Number_Imported? Number_Duplicate? Number_Errors

Skills: Engineering, Microsoft, Microsoft Access, MySQL, PHP, Project Management, Software Architecture, Software Testing, Visual Basic for Apps, Windows Desktop

See more: sources lead, project manager occupation, programming operator, printed names, operator phone number, matching logic, leads 2.0, c programming operator, company leads data, codes sources, call center number, call center name, call center address, leads by phone, numericals, import two, i need a small call center, call center part time, call center leads, call center database project, import access database php, database call center, need leads call center, access import txt, php excel database report

Project ID: #3519645

Awarded to:


See private message.

$68 USD in 3 days
(251 Reviews)

3 freelancers are bidding on average $62 for this job


See private message.

$68 USD in 3 days
(733 Reviews)

See private message.

$51 USD in 3 days
(18 Reviews)