I gang

Monitor folder, load file contents into MSSQL

I need a little "black box" .NET application that monitors a specified folder for a new file to be added (these will be xml files added via FTP). When a new file is added, the contents of the file should be inserted into a MSSQL database (field datatype is xml). Upon completion, a notification should be sent via email; In the event of an error, the error message should be sent via email. The application should continue monitoring the folder and loading files until it is manually terminated.

There should be a config file for specifying:

1. which folder should be monitored

2. the pattern of the insert statement with {0} or similar to be replaced by file contents

3. the email address to send notifications to

4. the subject line of the success email

5. the contents of the success email with {0} or similar to be replaced by the name of the file

6. the subject line of the fail email

7. the contents of the fail email with {0} or similar to be replaced by the name of the file and {1} to be replaced by the error message

If anything is unclear, please ask.

I need this done quickly -- please only reply if you can deliver quickly.

Added to the config file:

8. the connection string for connecting to the MSSQL

Another piece of information for the config:

9. SMTP server IP and port

Also, I expect to receive the source code as well as compiled app.

Færdigheder: .NET, SQL

Se mere: contents of a will, net mssql xml, notification monitor, application mssql, sql insert net, little sql, net notification, datatype, email message file, monitor ftp, monitor folder, insert folder, email monitor, net application ftp, ftp monitor, monitoring ftp, monitor application, net email monitor, application send notifications, monitor email, address field xml, mssql database, mssql xml, ftp monitoring, notification message net

Om arbejdsgiveren:
( 7 bedømmelser ) New York, United States

Projekt-ID: #6048318

Tildelt til:

DARKGuy

I've done similar apps before. Can deliver in about a day (12-24 hr) if the specifications on the insert statements (pattern and such) and SMTP server are provided (.NET can't send emails by itself, it only uses a SMTP Mere

$100 USD på 1 dag
(1 bedømmelse)
1.6

14 freelancere byder i gennemsnit $166 for dette job

LearningNew

Database will be Sql Server or MySql ? The destination folder where the files will be stored is fixed ? Database is ready ?

$105 USD in 3 dage
(52 bedømmelser)
6.3
customizedata

I will make a .net based exe that will reside itself to system tray . The configuration window will be appeared when right click on system tray icon. The exe will constantly try to look for any new file added to the fo Mere

$150 USD in 2 dage
(101 bedømmelser)
6.2
murtaza1981

Hi, An ASP.NET,c#,vb ,SqlServer,JQuery,Javascript expert here. Please feel free to discuss the project with me so that i can wrap it up in a timely manner as per your requirements. I would like to have a detailed d Mere

$450 USD in 10 dage
(8 bedømmelser)
4.3
mosiddiqui

Hi there, I CAN START WORKING TODAY. I can develop this web page for you. Do you have CRON Job on your web hosting server? We can use that to run and look for the new files in specified directory. Lets dicuss Mere

$222 USD in 3 dage
(6 bedømmelser)
4.2
acronymsolutions

A proposal has not yet been provided

$250 USD in 7 dage
(11 bedømmelser)
4.0
specialist77

Hello, I will need some connection string to the database, the table and field to update, the email parameters and for the rest will be a Folder Watcher to react on file changes. Where do you need the settings. Mere

$100 USD på 1 dag
(3 bedømmelser)
3.7
shallufreelancer

A proposal has not yet been provided

$105 USD in 3 dage
(5 bedømmelser)
3.5
shanalalkasim

Sir, My name is shanalal kasim. I am a freelancer with 7yr experience in software development. I can develop your software without any issue you can check my previous reviews. My proposed software work like below. Mere

$155 USD in 3 dage
(1 bedømmelse)
1.7
quickapp100

Hi we are a software development company from india in past 8 years me & my Team developed approx 950 projects for global market , we try to satisfy clients needs . we developed lots of projects for several industr Mere

$156 USD in 3 dage
(2 bedømmelser)
0.8
anuyadav1

A proposal has not yet been provided

$250 USD in 3 dage
(1 bedømmelse)
0.6
san2m

Hi_, I can build a windows service for your required task. I am sure i can help you with this.I am senior software engineer. Thanks , Samee

$77 USD på 1 dag
(0 bedømmelser)
0.0
ahmednayl12345

hi my name is ahmed i have my team to do this work we have time and experience to to this project can easily fulfill your needs within the time and budget if you need to know any info or details message me on pr Mere

$100 USD in 5 dage
(0 bedømmelser)
0.0
bal291

Hi I have developed an application similar to the one you are asking on another project which was a windows service that monitored a particular folder and when a CSV. file was dropped into the folder the contents wer Mere

$98 USD på 1 dag
(0 bedømmelser)
0.0