Find Jobs
Hire Freelancers

Datafile enrichment application

$100-500 USD

Cerrado
Publicado hace más de 19 años

$100-500 USD

Pagado a la entrega
Data enrichment php application that enriches a datafile with information from a mysql database linking the zipcode in the file with the zipcode in the database. The application has to do the folowwing actions: - user uploads source file (this file can be in different data formats like delimited (csv, tab, etc), fixed value text files, MS Excel, MS Access, dBase, etc. the files uploaded cab be Zipped (.zip) - user determines which column in the source file contains the zip-code - application will build a file with the enriched data in the same format as the source file or in Excel text format. 2 files can be build and outputed here: one with all the data from the source file enriched (all) and one with only the records that matches a zipcode in the database enriched (clean) All records that doesn't match with a zipcode in the database will be outputed in a error-file/log the user can select if he likes to download the results as they are or in compressed ZIP-format. --- for now the zip-code database only has two columns: zip code and companyCode. I also need an upload funcion to update/replace the database with my Excel file with the data in it. The data file has over 12000 records.. (i've added a smaller example in the zip file) the source file can have over 50000 records in it. the zip code in the source code can have a different format than the zipcode in the database. zip codes in the source code can be: 1234AB, 1234 AB, AB1234, AB 1234, 1234, 1234ABROTTERDAM, 1234AB ROTTERDAM while the zipcode in the database is 1234AB --- ## Deliverables - The application and database must have the parts as described above in it. - The application have to be able to handle big source and output files (70000 records, over 10MB) - 100% payment after work is completed and tested by us - functionality can be added during the project for which buyer and seller have to agree about the price. AND 1) Complete and fully-functional working application in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables): a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Apache/1.3.33 (Unix) PHP/4.3.9 MySQL 4.0.18-standard
ID del proyecto: 3472280

Información sobre el proyecto

5 propuestas
Proyecto remoto
Activo hace 19 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
5 freelancers están ofertando un promedio de $255 USD por este trabajo
Avatar del usuario
See private message.
$425 USD en 20 días
3,5 (191 comentarios)
8,1
8,1
Avatar del usuario
See private message.
$255 USD en 20 días
4,4 (17 comentarios)
5,1
5,1
Avatar del usuario
See private message.
$170 USD en 20 días
5,0 (5 comentarios)
4,0
4,0
Avatar del usuario
See private message.
$340 USD en 20 días
4,5 (7 comentarios)
2,9
2,9
Avatar del usuario
See private message.
$85 USD en 20 días
4,9 (4 comentarios)
1,5
1,5

Sobre este cliente

Bandera de NETHERLANDS
Mijnsheerenland, Netherlands
5,0
10
Miembro desde mar 18, 2004

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.