Завершено

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.

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

Квалификация: Visual Basic

Показать больше download file sql, download file sql database, download file sql table, update sql table file, sql table, sql database programmer, sql database program, programming sql, programming in sql, programmer sql, programmer out source, payment handling, ms access programmer, i need a ms access programmer, files will not download, download c++ program, database programming sql, c++ programmer download, download file sql table using, download files sql table

О работодателе:
( 14 отзыв(-а, -ов) ) Markham, Canada

ID проекта: #415874

Поручен:

vnb400

kindly refer PMB, Thanks

$30 USD за 3 дней(-я)
(3 отзывов(-а))
2.7

15 фрилансеров(-а) в среднем готовы выполнить эту работу за $91

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 день
(56 отзывов(-а))
6.1
schandraram

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

$125 USD за 2 дней(-я)
(55 отзывов(-а))
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 дней(-я)
(97 отзывов(-а))
5.7
netcoder

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

$77 USD за 7 дней(-я)
(49 отзывов(-а))
5.4
ramaswamynanda

Hello, Please check PMB for details. REgards NAnda Ramaswamy

$150 USD за 3 дней(-я)
(4 отзывов(-а))
4.2
crajeshbe

Hi Good day, DBA Expert Bid. Ready to start right now. Regards [login to view URL] B.E

$100 USD за 2 дней(-я)
(8 отзывов(-а))
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 Больше

$75 USD за 1 день
(3 отзывов(-а))
2.6
ASHUFGIET

I HAVE FULLFILL UR REQUIREMENTS EASILY GIVE ME A CHANCE

$30 USD за 4 дней(-я)
(0 отзывов(-а))
0.0
afsarhassan

Ready to work.

$135 USD за 3 дней(-я)
(0 отзывов(-а))
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 дней(-я)
(0 отзывов(-а))
0.0
shahadatsm

Dear Sir Please check the PM

$85 USD за 2 дней(-я)
(0 отзывов(-а))
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 [login to view URL]) thank you very much.

$100 USD за 1 день
(0 отзывов(-а))
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 Больше

$50 USD за 1 день
(0 отзывов(-а))
0.0
anhinanddhn

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

$150 USD за 0 дней(-я)
(1 отзыв)
0.0