Download file to SQL table

Đã hoàn thành Đã đăng vào Apr 9, 2009 Thanh toán khi bàn giao
Đã hoàn thành Thanh toán khi bàn giao

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.

typo.. I prefer VB programming with an MS SQL database for the project, not Access

Visual Basic

ID dự án: #415874

Về dự án

14 đề xuất Dự án từ xa Apr 9, 2009 đang mở

Được trao cho:

vnb400

kindly refer PMB, Thanks

$30 USD trong 3 ngày
(3 Đánh Giá)
2.7

14 freelancer chào giá trung bình$96 cho công việc này

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 trong 1 ngày
(56 Nhận xét)
6.1
netcoder

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

$77 USD trong 7 ngày
(54 Nhận xét)
5.5
schandraram

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

$125 USD trong 2 ngày
(35 Nhận xét)
5.6
ramaswamynanda

Hello, Please check PMB for details. REgards NAnda Ramaswamy

$150 USD trong 3 ngày
(4 Nhận xét)
4.2
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 Thêm

$75 USD trong 1 ngày
(3 Nhận xét)
2.6
ASHUFGIET

I HAVE FULLFILL UR REQUIREMENTS EASILY GIVE ME A CHANCE

$30 USD trong 4 ngày
(0 Nhận xét)
0.0
afsarhassan

Ready to work.

$135 USD trong 3 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
0.0
shahadatsm

Dear Sir Please check the PM

$85 USD trong 2 ngày
(0 Nhận xét)
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 Thêm

$50 USD trong 1 ngày
(0 Nhận xét)
0.0
anhinanddhn

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

$150 USD trong 0 ngày
(1 Nhận xét)
0.0