GetACoder.com

 
 

Home | My Account | Post Job | Browse Jobs | RSS Feeds | Careers New!

 

Perl And Csv File Manipulation

 
 
Download the Free Step-by-Step Guide
     
Job Summary:
 
Job Type: Project
Budget: $ 250-500
Required Skills: Microsoft Windows, Perl
Attached Files: (None)
 
Status: Work Performed (selected user bscmartins)
 
Buyer Summary:
 
Username:
tnelson  
Feedback Score: 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10 1 reviews
Award Reliability: 2 posted 2 paid
 
Location: Epping, United Kingdom
Member Since: June 16, 2011
 
Invited Users: There are no invited users


Description
I engaged a developer through Get A Coder a year or so ago and he developed my app just fine. But he’s no longer available so I need someone to take it over and develop it a little further. It’s written in Perl and I have the source code.

In summary this Windows app does the following:
• via FTP logs in to a remote site on a regular basis and scans a folder there for zip or csv files added since its last visit which match certain filename criteria; it then downloads this(these) new file(s). The files in question contain telephone call detail records.
• if no new file is detected it “sleeps” until it’s time to check again. The check cycle can be varied from 30 seconds to any number of minutes.
• The downloaded file(s) is(are) unzipped if necessary, combined if there is more than one, and one column of data is deleted
• The app filters the resulting file against another supplied text file retaining only those rows in which it finds matching entries (ie it identifies call records relating to specific phone numbers and deletes the rest of the file)
• The resulting file is then merged with (appended to) a similar file created earlier (if one exists). This is the “output file”.
• The app then checks the time of day against a “time to send” variable. If that time has been reached, the output file is (optionally zipped and optionally renamed with a timestamp element and) sent via email (or via FTP to a different password protected remote site); once this has been done various housekeeping is done. In particular the output file is emptied of all data ready for a new period (typically day but could be 4 hours) and the next “time to send” is calculated and stored
• if the “time to send” has not been reached, no action is taken and the app sleeps again until its next check cycle.

The app is flexible in that a number of parameters can be varied via the use of a setup file (contains info including the remote FTP folder address and login credentials, how often to scan it, the filename matching required, which column to delete, whether the file is zip or csv, and SMTP details) and a customer file (contains info including the email address or FTP details of where to send the extracted data, what is the “time to send” period, and the list of phone numbers to use in the filtering part of the process). The file that is sent to the customer can be zipped or not and its filename can contain a timestamp element or not.

I need the app to be tweaked as follows. The final bullet point above says “if the time to send has not been reached, no action is taken and the app sleeps again”. I need another option to be added here based on a new parameter accumulate (y or n). If Accumulate = y then every time a new file(or files) is (are) downloaded from the source site, and after any new filtered records have been extracted and appended to the acculumating output file, I want the output file to be sent even if “time to send” hasn’t been reached. However after the file is sent it isn’t to be emptied (unless “time to send” has been reached).

My old developer started this development but did not fully complete the work so it\'s got a few bugs.

if you can convince me that you have the skills to do this work at an acceptable price then I will send the source code for you to evaluate and will demonstrate the current app via skype after job is awarded. You need to speak good english. I will only engage with someone who is willing to communicate occasionally via skype as well as regularly by email.




Reminder
You may not start working in this and any request before your bid is accepted. Users who violate this policy may have their accounts permanently suspended.



Place Bid | Post Similar Job | Send Request | Contact tnelson

Order by:

 

 tnelson has chosen to keep all bids for this request hidden

 

Remember that contacting the other party outside the site (by email, phone, etc.) on all business jobs (before the request is awarded) is a violation of our terms of use. We supervise all site activity for such infringements and can immediately expel transgressors on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thank you for your help.
 

 
 


 
Get the Free Step-by-Step Guide on How to Use GetACoder
The act of outsourcing jobs has become easy in the past few years thanks to GetACoder. However, our team aims at making the whole process even easier. So, it has now come the time to provide you with a step-by-step guidance on how to use this service and succeed in the outsourcing world totally for FREE.

It doesn't matter if you are a more experienced user or a novice; using GetACoder will become even simpler with the help of this E-book. There are two major sections: a Buyers section and a Coders section.

Buyers will learn:
  • How to outsource safely
  • How to pick the best freelancers
  • How to manage time and money

Coders will learn:

  • How to get the best jobs
  • How to secure their payments
  • How to build a long-lasting relationship with buyers

    ...and MUCH MORE
Clear examples and pictures illustrating key situations, great tips and real testimonies of some of our best users... all in this Outsourcing Guide.  So don't loose the outstanding opportunity to download GetACoder FREE E-book.
The Outsourcing Revolution: Why It Makes Sense and How to Do It Right
The Outsourcing Revolution: Why It Makes Sense and How to Do It Right
What is GetACoder?

GetACoder.comGetACoder is a leading Global Services Marketplace doing business in more than 200 countries. Our unique system accelerates your time to market and provides your business with key competitive advantages. When you use GetACoder you are stretching your budget and saving as much as 60% over traditional outsourcing. GetACoder is changing business, now it's no longer about what you own or build but which resources and talent you can access. With GetACoder you reduce expenses, increase efficiencies, aggressively grow your business, and create a sustainable competitive advantage. GetACoder makes outsourcing to any part of the world an easy task! With GetACoder it's simple to outsource any business request, gain access to global talent and manage jobs online.

One of the main advantages of GetACoder is the low labor cost. The typically rates are about seven times lower than the ones in the US or Europe. Posting a request at GetACoder allows the right professional or company to find you and to bid for your work. We are building a reputation for exceeding our customers' expectations and for becoming an extremely cost effective way to outsource work. Use GetACoder when you want to save money, increase efficiency or accelerate the development of your request. With GetACoder you focus on growing your business and let others do the tedious work. Post your request on GetACoder for free. Find out why people outsource jobs with us day after day.

Thousands of Satisfied Customers - Submit/View Quotes


-I have found this website quite better than others for SME'S. Thanks GAC team - vivek3
-Getacoder helps find work easily.They are doing great job for companies as well as freelancers. Keep up the good work! - RmaGroup
-There are more serious and professional buyers here compared to other outsourcing sites. It's simply the best. - pixsys
Report Violation    Privacy Policy     Affiliate Program    Terms of Use    Contact Us    Help      GetACoder.com on Facebook      Follow GetACoder on Twitter      GetACoder.com Latest Requests RSS Feed
© 2004-2012 GetACoder. All rights reserved.