Find Jobs
Hire Freelancers

SQL Database - Write Software/Program

$30-250 USD

Completed
Posted over 9 years ago

$30-250 USD

Paid on delivery
Our Applicant Tracking System (ATS) is based on SQL (Microsoft SQL server). At times, we send out a high number of e-mails. Often, e-mail addresses are incorrect or outdated and we get lots of 'undeliverable' messages. We need these records to be updated in our ATS and we need a program/macro to be written that allows us to update records on our own at any given time. The basis for the undeliverable e-mails will be either an Excel, csv or txt file which only contains incorrect e-mail addresses. We will provide this file (which will be created by pulling the addresses from Outlook’s undeliverable messages). Here are the steps and what needs to be achieved: 1. Take one e-mail address at a time from the provided file. 2. Look for the matching e-mail address in our ATS. 3. Replace the existing e-mail with a note in that same (e-mail address) field, e.g. “_e-mail incorrect: ‘[login to view URL]’ “ (“[login to view URL]” is an example for an incorrect e-mail address). Note: We should be able to edit the “_e-mail incorrect:” part (e.g. to “_e-mail to be researched: ‘[login to view URL]’ “ or something similar). 4. Take the next e-mail address and repeat the above steps. If you're interested, please let us know how quickly you think such project can be done and what the total cost would be. We look forward to hearing from you!
Project ID: 6511682

About the project

39 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Best solution would be to create such a function directly in the ATS. If the option above is not possible. A small desktop application could be created connected via ODBC to the SQL-Server of ATS (need to be checked, if direct access to SQL-Server is possible) with a file picker for incorrect email addresses and a textbox in which the variable note can be entered.
$77 USD in 2 days
5.0 (1 review)
2.2
2.2
39 freelancers are bidding on average $143 USD for this job
User Avatar
Hi Good Day I can develop this system in 3 days. Your requirements are very clear for me. I have a good track record here. Looking forward to hear from you. Thanks Rinsad
$136 USD in 3 days
4.9 (753 reviews)
9.3
9.3
User Avatar
Hello, I'd like to help you on this! I understand the issue is you need a way to bulk-flag incorrect (bounced) addresses so that they can later be checked by staff and corrected/removed. I can implement this in multiple ways, either by adding a bit flag next to the email address - in your database - which would be the technically preferred way or if - as I think - this may possibly adversely affect your application, we may also use the original way you suggested, i.e. prepend the address with a predefined text that indicates incorrectness/need to check. I will: write a .net application that allows you to configure this above message and paste a list of email addresses (as a text file, one address per line or separated by a semicolon) and it will look at and amend any matches as described in the project bid request. Prior to getting down to developing anything I would like to quickly discuss the specifics with you in order to make sure we grasp every aspect and pick the most optimal solution. You will receive complete IP rights, a Visual Studio 2013 solution with the app developed using .net framework 4.5 and C# as programming language as well as robust, tested, working and commented code. In addition, I will be available later for any enhancements you may require. I look forward to working with you. If you have any questions just PM me via the site! regards, Janos
$263 USD in 5 days
5.0 (95 reviews)
8.1
8.1
User Avatar
Please do not award before discussion For your business purpose you are sending some mail to your applicant and due to your described reasons you are receiving Undelivered Message. Now, your aim is to track this email Id and update this email ID into your ATS. I understand the urgency of your requirement and I will be feeling happy if you will get me a chance to help you and from my previous experience I know that I will be able to help you. Please see the below section: We will Develop a Add-In for Outlook which will help you to extract the Undelivered Email.: 1. We will search every E-Mail in the Inbox analyzing its Subject to determine if it was Undeliverable. In my Code example the Search Text Delivery Status Notification (Failure) worked. 2. For each Undeliverable, extract the E-Mail Address from the Body of the E-Mail. From what I have seen it will be enclosed within the first occurrence of '<' and a closing '>'. 3. Now, you will change the email in the file and we will check from the file and will update your database. It will be better if you will use CSV File with two column old email ID and Current Email ID then we will find Old email ID from the CSV and will update it in your Database. We have already developed this kind of application so we are confident that we will be able to success your thought and if you want then we can give you demo of our work as well where we have done this kind of section. Can you please specify that how you will collect the corr
$526 USD in 10 days
4.9 (41 reviews)
7.4
7.4
User Avatar
Hi, This can be achieved by designing a C# win-forms application. Application will have facility to import CSV/Text file. Once imported, all data will be shown in grid. Then your business logic will be implemented and result will be displayed on grid. I have 9 years experience in C#, Win-Forms, ASP.NET/ MVC with Jquery/Ajax and for services using WCF/Rest WCF/Rest Web ApI and SQL Server 2008/R2/2012 for back-end. I have delivered highly successful projects in ASP.NET, C# Win-Forms with complex logic in SQL Server Stored Procedures. Thanks
$222 USD in 20 days
4.9 (57 reviews)
6.9
6.9
User Avatar
Hi my proposal is this. I will create an ssis package which will import the wrong emails in the database , make all the necessary updates and export an excel file with the wrong addresses. You can take the excel file and make all the corrections. After the corrections you will run another ssis package to import the excel into your DB which will make the updates to the emails. Detailed setps : export from outlook -> import to sql , updates , export error -> corrections -> import to sql , correct addresses. All the packages will run from sql server agent. For all this i will need 3 days. I have availability on this Weekend and i can deliver max on Monday the 29th. I will need the DB table and the export from your email. There is a slight difference from my previous proposal because i did not understand the need for the recurrence of the job. Best Regards Mpalgeo.
$88 USD in 3 days
5.0 (78 reviews)
6.4
6.4
User Avatar
I have been in this industry for 6 years and such jobs are my daily practice. This is my first time on this site and hence you can see that I have only 8 ratings/feedback to show you. I can assure you that if you work with me once, you will always work with me for these kind of projects. I have been read your Project description throughout and able to do all the things you described. You can see my profile for more details . Let's discuss for even more details. Thank you in anticipation. Have a nice day...
$88 USD in 3 days
5.0 (35 reviews)
6.3
6.3
User Avatar
Hi . Let me do this project for you I'm a programmers and I have experience on this issue I look forward to working with you, thank you ! Please discuss with me, give me this chance.
$90 USD in 3 days
4.9 (42 reviews)
6.1
6.1
User Avatar
It's Hao Vo. I have bidded on your previous project and you have contacted me to bid on new project. I can do this project according to the current requirement with the current my price. I also create an application to automated access your outlook to get undeliverable emails address then update your database system. Please contact me to discuss about your expectation in more detail.
$88 USD in 3 days
4.9 (33 reviews)
6.1
6.1
User Avatar
Do you need a windows application or web page for this. I recommend using windows application. I can develop this in no time. Do let me know the Excel format as sample. Thanks
$105 USD in 3 days
5.0 (44 reviews)
5.1
5.1
User Avatar
hey there, please share the ms sql server details and also which table the update needs to be done. Please share the sample excel / csv/ text file which has invalid email addresses. Thank you !
$78 USD in 3 days
4.9 (71 reviews)
5.4
5.4
User Avatar
Hi there, Yes I am interested and I will you a an executable file which can be either in a GUI mode or silent mode to do this update. Let me know if you would like to me do this for you. Ajz
$90 USD in 3 days
5.0 (9 reviews)
4.8
4.8
User Avatar
Hello, I'm new freelancer, but definitely not new in Information Techology. Since I have no reviews, . I consider the given task as an easy job. These are the steps needed for project to be done. - Take source data from user's given location - Take note (e.g. "_email incorrect") from user - Connect to MS SQL Database. - Send single query (update query) to update only one field (E-mail) in a given table. - Response, e.g. (Successfully replaced 145 E-mails...") I can provide this application as an Web application or dekstop application (for specified platorm). Project can be done in a single day. Contact me for more info. Borna Grgurić Master of applied computer engineering
$100 USD in 1 day
5.0 (4 reviews)
5.0
5.0
User Avatar
Hello. More 20 years programming experience. I suggest small .net application. Regards. -----------------------------------------------------------------------------------------------------------------------------------------------
$100 USD in 3 days
4.9 (16 reviews)
4.7
4.7
User Avatar
hi, I read your requirement and I can do it. It's a windows service auto read file or it's can be a windows application for choose file manual. that tool connects to your database by file config. thanks
$111 USD in 3 days
5.0 (1 review)
3.9
3.9
User Avatar
Hello, My name is Roman Dubyk. I’m programmer with big experience in C, C++ and C#. Moreover, I have experience in SQL Server and email API to access messages directly on mail servers. Solution to cover all mentioned requirements can be implemented as desktop application with one simple screen where will be possible: 1. Configure connection to ATS SQL Server. 2. Select Excel (or CSV on your choice) file with list of broken email addresses. 3. Indicate text which should be concatenated with wrong email addresses. 4. And click button to start process of replacing record by record. It looks like not complicated application. But here are several questions: 1. Do you have/know credentials to connect to ATS database with enough access level to modify needed fields? I’m asking this because sometimes third-party software producers restrict access to databases they are working with. 2. Do you know table/field where email addresses have to be modified? Project duration: 1 week. Project budget: USD225. Hope to work with you, Roman. P.S. I have idea for automating your workflow - please contact me if it is interesting for you - there is not enough free space to describe the solution. Thank you very much.
$225 USD in 7 days
5.0 (4 reviews)
4.0
4.0
User Avatar
Đề xuất vẫn chưa được gửi
$80 USD in 4 days
4.2 (4 reviews)
2.3
2.3
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
5.0 (1 review)
0.5
0.5
User Avatar
Hello Sir, We are very solid in development we are proving high quality work with 100% satisfaction and success to our clients. Waiting for your opportunity to prove our self as a successful provider. If you chat with me, I can explain things in complete details; let me know any further update from your side
$250 USD in 5 days
5.0 (1 review)
0.6
0.6
User Avatar
I can write a java app which will ask you to provide the .csv file with faulty email addresses. It will then automatically updates your ATS database. Requirement: A sample of the ATS databse. A sample of the .csv file with faulty email addresses. I can get a prototype working in 3 days and get it tested and perfected in 9. Thanks.
$222 USD in 9 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$222 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
San Francisco, United States
4.8
21
Payment method verified
Member since Sep 12, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.