Find Jobs
Hire Freelancers

C#, text file parsing to import into SQL Table

$30-5000 USD

En curso
Publicado hace más de 16 años

$30-5000 USD

Pagado a la entrega
This project is to develop a Windows Service to parse text files and insert data into a SQL Server table. This is how I envision it working, There will be a folder on my server. Your service will check for files in that folder every 10 minutes or so. If a file is found, you will run the routine to parse it and place the data in the table and then move the file to another folder. The file will be a tab delimited flat file. There will be 2 tables in the database. One table is the main table - each line in the flat file corresponds to one record in the db table. There is a primary ID number, if the ID is not already in the table, insert the record. If the ID is already in the table, compare the date updated fields and you may need to Update the record. If for some reason, SQL rejects the insert or update, it will most likely be for a data type mismatch. The second table in the db is a temp table with the same fields but every field is varchar(max). Put that record in the second table and in one of the fields put the sql error or field that was rejected. At the end of the parsing of a text file, send an email to confirm and also note if anything was rejected and placed in the temp file. In that email have a link to the following webpage... Create a simple webpage usnig asp.net. You can use the standard controls for data grid and edit into the temp table. I will be able to go through and edit the field that was in error, then on save it will try to insert/update that record to the main table and if it is rejected again it will put it back in the temp table with the reason. ## Deliverables 1) Complete and fully-functional working program(s) 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 Windows 2003 Server Sql Server 2005 DB ASP.NET using C# 2.0 Windows Service using C# 2.0
ID del proyecto: 3487216

Información sobre el proyecto

9 propuestas
Proyecto remoto
Activo hace 16 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.
$85 USD en 6 días
5,0 (63 comentarios)
5,0
5,0
9 freelancers están ofertando un promedio de $132 USD por este trabajo
Avatar del usuario
See private message.
$51 USD en 6 días
4,1 (90 comentarios)
6,4
6,4
Avatar del usuario
See private message.
$293,25 USD en 6 días
5,0 (73 comentarios)
5,4
5,4
Avatar del usuario
See private message.
$72,25 USD en 6 días
5,0 (2 comentarios)
4,8
4,8
Avatar del usuario
See private message.
$127,50 USD en 6 días
5,0 (17 comentarios)
4,4
4,4
Avatar del usuario
See private message.
$84,15 USD en 6 días
4,6 (26 comentarios)
4,2
4,2
Avatar del usuario
See private message.
$127,50 USD en 6 días
5,0 (3 comentarios)
2,8
2,8
Avatar del usuario
See private message.
$306 USD en 6 días
4,5 (1 comentario)
2,7
2,7
Avatar del usuario
See private message.
$42,50 USD en 6 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
United States
5,0
42
Forma de pago verificada
Miembro desde nov 22, 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.