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: ‘[url removed, login to view]’ “ (“[url removed, login to view]” 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: ‘[url removed, login to view]’ “ 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!
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 Daha Fazla
Bu iş için 43 freelancer ortalamada $144 teklif veriyor
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 mul Daha Fazla
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 ema Daha Fazla
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
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 a Daha Fazla
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.
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
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
Hello How would you like to do this? It is possible like this: 1. manually import xls into a table of database and then use Stored procedure 2. create a .net program which will parse xls and do the rest rega Daha Fazla
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 Daha Fazla
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 !
Dear Sir, I will create a a c# GUI to do this task, I can finish it in less 3 days, Really interested to do the project I am a Professional Programmer since 2008, I have many programs developed and successfully Daha Fazla
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 menti Daha Fazla
Hello. More 20 years programming experience. I suggest small .net application. Regards. ------------------------------------------------------------------------------------------------------------------------------- Daha Fazla
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 Daha Fazla
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 assu Daha Fazla
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 c Daha Fazla
Hi, here is half done: [login to view URL] I presume that you have .net 3.5 installed, so you can test it. Of course this will replace one single email adress. Atm you give me the textfil Daha Fazla