Käynnissä

Download file to SQL table

I need quick delivery of a VB application to download files from a flatfile (text) and with records in database on SQL server.

There are 2 set of files with the same name.

- One set of files are flat text file (.CSV) with a delimiter (semi-colon or comma) for each field. For example,

(Field1);(Field2);(Field3), etc.

- The other set of files locates on the SQL server with matching fields.

I need the program to do the following, for each file

1. Check to see if the text file contains any record.

2. Connect to SQL Database.

3. Read record from the text files. And parse out the file using semi-colon (;)

4. If the (Action) is Add, Add the record to the SQL database, regardless whether the record already exist on the SQL database.

4. If the (Action) is U, Checks to see if the same record existing on the SQL database

- If the record exist, it updates the existing record with the new record.

- If the record does not exist, it adds a new row to the SQL database

4. Repeat the process until End-of-File

5. Close connection. Wait until next cycle

This program should check every 15 minutes for new incoming records. Note that the parameter cycle should be easy to change (eg. on the .ini file)

I prefer VB programming with an MS access database for the project. A possible interface of the program once installed may simply look like the attached picture (or better than that).

The program/source code should not include any details of the programmer and it will be my property once the payment made. I can pay by paypal. Please contact me if you need more details.

*************

Also, I need to be able to update the following parameters easily (config file similar to below)

(SQL server) = Name of the SQL server

(SQL UserId) = UserID to logon to SQL server

(SQL Password) = Password

(File1)

(FileName) = Name of File 1 (note that the name of the flatfile will be the same as SQL database.

(Action) = (A for Add Or U for Add/Update)

(Field1) = Column name of the SQL table (If Action is Update, Field1 is primary key)

(Field2)

(Field3)

(CycleTime) = Wait time to check for incoming record. This value should be able to handle from 15 minutes, daily.

(/File1)

(File2)

(FileName) = Name of File 1 (note that the name of the flatfile will be the same as SQL database.

(Action) = (A for Add Or U for Add/Update)

(Field1)

(Field2)

(CycleTime) = Wait time to check for incoming record. This value should be able to handle from 15 minutes, daily.

(/File2)

*****************

Also, I need appropriate error handling with meaningful message such as, cannot log-on to Database. Cannot update Database, etc. Note that these files are relatively large.

The program/source code should not include any details of the programmer and it will be my property once the payment made. I can pay by paypal. Please contact me if you need more details.

Taidot: Visual Basic

Näytä lisää: download file sql database, download file sql table, update sql table file, sql table, sql database programmer, sql database program, programming sql, programmer sql, programmer source, payment handling, database programming sql, download files sql table, update file sql, sql add file table, using semicolons sql tables, download file sql using, end file check sql, download sql table, sql file download, sql update database file, count record sql table, update sql text file, sql download, add file sql, wireless key crack

About the Employer:
( 14 reviews ) Markham, Canada

Projektin tunnus: #415874

Myönnetty käyttäjälle:

vnb400

kindly refer PMB, Thanks

30 $ USD 3 päivässä
(3 arvostelua)
2.7

15 freelanceria on tarjonnut keskimäärin 91 $ tähän työhön

rajtuhin1

Database expert here. Select me and you will get it done ASAP. I have done these type of project several times, that's why bidding at minimum price. Before selecting my bid, please discuss in pmb. Regards :TUHIN

30 $ USD 1 päivässä
(56 arvostelua)
6.1
schandraram

Hello - Please see PMB for details of my bid. Thank you. Chandra Ram

125 $ USD 2 päivässä
(55 arvostelua)
5.9
weng0000

Good day! I can do this and I am ready to start the project. Thank you very much. Weng

30 $ USD 2 päivässä
(97 arvostelua)
5.7
netcoder

Hi, I think I can do it:-)! Best regards, netcoder:-)

77 $ USD 7 päivässä
(49 arvostelua)
5.4
ramaswamynanda

Hello, Please check PMB for details. REgards NAnda Ramaswamy

150 $ USD 3 päivässä
(4 arvostelua)
4.2
crajeshbe

Hi Good day, DBA Expert Bid. Ready to start right now. Regards C.Rajesh B.E

100 $ USD 2 päivässä
(8 arvostelua)
4.1
tamrakar81

hi, I can do this for you in single day but i can do this in vb.net or c#.net . is it okay for you ??? if yes . I am ready for demo . and open to negtiate in term of cost / time line / functioanlity . thank Lisää

75 $ USD 1 päivässä
(3 arvostelua)
2.6
ASHUFGIET

I HAVE FULLFILL UR REQUIREMENTS EASILY GIVE ME A CHANCE

30 $ USD 4 päivässä
(0 arvostelua)
0.0
afsarhassan

Ready to work.

135 $ USD 3 päivässä
(0 arvostelua)
0.0
fortiustechsol

Hello, We have 5 experienced programmers capable to work on this project. We mainly work on .net. Please see PM Arpit

200 $ USD 7 päivässä
(0 arvostelua)
0.0
shahadatsm

Dear Sir Please check the PM

85 $ USD 2 päivässä
(0 arvostelua)
0.0
weelos

hi i can do your project in one day using vb and sql server for 100$ i don't have paypal account so you can pay me using moneybookers or pay to GAF (get a freelancers.com) thank you very much.

100 $ USD 1 päivässä
(0 arvostelua)
0.0
Ntronixs

Just select us a provider, we'll show our magic with fast high end quality delivery, do contact for speedup and quality delivery, Well, I’m Expert on PHP, JAVA & Microsoft Technologies. Check “Ntronixs” Won Assignments Lisää

50 $ USD 1 päivässä
(0 arvostelua)
0.0
anhinanddhn

Need few more details I will do it for u in few hours...

150 $ USD 0 päivässä
(1 arvostelu)
0.0