Find Jobs
Hire Freelancers

Acces Leads import

$30-80 USD

En curso
Publicado hace alrededor de 15 años

$30-80 USD

Pagado a la entrega
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 **FIELDS:** **Leads Table Fields:** LeadID? ImportID? NAME? COMPANY? BIRTHDAY? OCCUPATION? TAX_ID? ADDRESS? CITY? ST? ZIP? NUMBER? INVESTED AMOUNT? LAST_PRINTED? NUMBER_PRINTED **Import Log Fields **ImportID? Date/time? Description? Filename? Number_Imported? Number_Duplicate? Number_Errors
ID del proyecto: 3519645

Información sobre el proyecto

3 propuestas
Proyecto remoto
Activo hace 15 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
See private message.
$68 USD en 3 días
4,9 (251 comentarios)
6,4
6,4
3 freelancers están ofertando un promedio de $62 USD por este trabajo
Avatar del usuario
See private message.
$68 USD en 3 días
5,0 (733 comentarios)
7,5
7,5
Avatar del usuario
See private message.
$51 USD en 3 días
4,8 (18 comentarios)
3,6
3,6

Sobre este cliente

Bandera de UNITED STATES
United States
5,0
34
Miembro desde may 13, 2006

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.