Suoritettu

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

Taidot: Visual Basic

Näytä lisää: 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, update file sql, parse text file sql, open file pmb, sql add file table, using semicolons sql tables

Tietoa työnantajasta:
( 14 arvostelua ) 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 %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% 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 [login to view URL] 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 [login to view URL]) 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