parse csv file/monitor it for specified criteria/email attach an audio file if matches

Closed Posted Dec 19, 2013 Paid on delivery
Closed Paid on delivery

I have a software program that logs data to a csv file and makes .wav files of audio recordings. It is consistently adding new data to the csv file and creating more .wav files.

I'm looking for someone to code this...

I want a program to "parse" or monitor the csv file for particular "matches". If there is a match, I want to be e-mailed with a copy of the wav file for that particular match. I want the subject of the e-mail to contain a custom header based on the "match". The program I want coded would continue to monitor the constantly updating csv file and continue to do the above actions if & when there are criteria matches based on my criteria list...

Detailed example:

Here is a concept of the data in the csv file:

Date,Time,Reading 1,Reading 2,Wav File

10-17-2013,12:22:11 PM,DIGI,754,D:\Users\[login to view URL]

10-17-2013,12:22:36 PM,DIGI,759,

10-17-2013,12:55:29 PM,DIGI,753,D:\Users\[login to view URL]

10-17-2013,12:55:57 PM,DIGI,749,

10-17-2013,12:58:41 PM,DIGI,*55,D:\Users\[login to view URL]

10-17-2013,1:20:12 PM,DIGI,754,D:\Users\[login to view URL]

10-17-2013,2:45:24 PM,DIGI,7754,D:\Users\[login to view URL]

10-17-2013,2:58:35 PM,DIGI,757,D:\Users\[login to view URL]

10-17-2013,2:58:47 PM,DIGI,758,

10-17-2013,2:59:19 PM,DIGI,728,

10-17-2013,3:06:04 PM,DIGI,*55,D:\Users\[login to view URL]

The Reading 1 and Reading 2 columns specify the type of output, you will notice above that some lines do not have a wav file associated.. that is because the audio output from that line is contained in the .wav file above that (most recent).. example DIGI,728 at 2:59:19pm has an audio file produced at 2:58:35pm ([login to view URL]).... in essence, if there is a line in the csv file that doesnt show the location of the .wav file - i need to get emailed a copy of the .wav file that was most recently created & logged...

Example situation of how i want the program to work...

I want to be emailed a wav file if a 'DIGI 749' is logged.. I want the subject of the e-mail to be "Unit 749!", the attachment of the e-mail would be: [login to view URL] because that is the corresponding audio file in the csv example above..

I also want to be able to match criteria with a wildcard.. so I can create a criteria match for "75*" and it will find DIGI 759 and DIGI 758... and e-mail each of their respective audio files..

I don't really care how this is coded..i just want to run this in Windows 7.. I also have one other concern.. I noticed I can't open the csv file in certain applications while my existing program is running.. So whatever you use to code this request, it must just "check" the csv file every 15 seconds (or so) but my original program must still be able to write data to the csv file...

PHP Software Architecture Visual Basic

Project ID: #5242534

About the project

17 proposals Remote project Active Jan 25, 2014

17 freelancers are bidding on average $178 for this job

rajeshsonisl

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 !!)... you can never go wrong choosing me :) I look forward to your reply. More

$360 USD in 2 days
(920 Reviews)
8.6
wildlily980

hello I can try this in php ....................................................................................................................... Best Bill

$200 USD in 3 days
(60 Reviews)
6.9
kalpesh2804

Hello, I have experience in CSV Parsing. my program will continue monitor your CSV File. i want to discuss with you this project. thanks Kalpesh

$147 USD in 3 days
(76 Reviews)
6.6
rsoftsl

My bid is for a Windows desktop application that does what you described. It includes the program's source code (written in C# or Delphi, whichever you like best) and 2 years of free tech support and debugging. If y More

$100 USD in 3 days
(70 Reviews)
6.1
skctechno

Your project suits my expertise very well. Lets discuss further through inbox/messages. I having 9 years of Software development experience & completed 53 projects in Freelancer.com in last 1.5 years, all the client More

$98 USD in 4 days
(41 Reviews)
5.8
finecodervw

Few quick queries: 1) What is the approx. size of the wav files. 2) As per the current understanding , the wav. file to be emailed when ever a missing entry is found for wav file. Is this auto running option or the e More

$210 USD in 8 days
(157 Reviews)
6.2
anuyadav1

i am expert in making bots in python. i can write this software as you have described below, exactly the same.

$155 USD in 3 days
(46 Reviews)
5.7
FrozenMem

Hello. This is an easy project. I can finish it within 1 day. You can run program in win7/win8 without having to install any additional package. Please contact me so we can discuss more about it. I'm looking forwar More

$155 USD in 3 days
(24 Reviews)
5.3
murtaza1981

Hi, An ASP.NET,c#,vb and SqlServer 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 highlight following qualities of m More

$400 USD in 10 days
(9 Reviews)
4.5
diegofpr

Hello, I think I can achieve this project easily. Working with .net you can check if a file is modified, open a file in read mode (allowing other programs to access the file) and also read the full file and releasin More

$120 USD in 5 days
(15 Reviews)
4.0
JavaPSFTConstnt

Hi, I read through your proposal. I would suggest you to build this tool in Java so that it can run on any OS not just windows. Also there are lot of reliable APIs available to achieve this project.i dont want to wa More

$235 USD in 10 days
(1 Review)
2.9
EasierSolutions

azlightning, I'm underbidding this job because I'm new to freelancer and I would like to work for the review more than for the money. This issue, as I see it, can be easily solved with a simple Python scr More

$30 USD in 3 days
(6 Reviews)
2.7
vladislavzalesak

Good day, I have experience with software like this, even on larger scale. I can have a prototype for you to try out (only basic funcionality) within 48h. Implemented in C#, with GUI for basic configuration. The More

$110 USD in 5 days
(3 Reviews)
2.4
johnord

Dear Sir, I am a Professional Programmer since 2008, I have many programs developed and successfully finished in my past employer, I am expert in IT Industry both Hardware and Software Programming, I will give you t More

$200 USD in 3 days
(5 Reviews)
3.7