SQL Database - Write Software/Program

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!

Beceriler: Veritabanı Programlama, Microsoft SQL Server, Yazılım Mimarisi, SQL, Windows API

Daha fazlasını gör: write an e mail, sql database program, incorrect from address, cost of microsoft sql server, what is an applicant tracking system, on sql, write a note on get, how to get e mail address, write software, sql microsoft, software-program, software program, need to write a program for, excel with sql server, database microsoft sql, excel update net, edit macro, sql created, update sql file, write macro, excel macro txt, update existing macro excel, microsoft software macro, excel macro csv, sql update txt file

İşveren Hakkında:
( 8 değerlendirme ) San Francisco, United States

Proje NO: #6511682



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

%selectedBids___i_period_sub_7% gün içinde 77%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(0 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde263%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(93 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde526%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(28 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde136%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(127 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(29 Değerlendirme)

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.

in %bids___i_period_sub_35% gün içinde90%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(17 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde105%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(39 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde90%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(17 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde88%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)

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 !

in %bids___i_period_sub_35% gün içinde78%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(17 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde225%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

Hello. More 20 years programming experience. I suggest small .net application. Regards. ------------------------------------------------------------------------------------------------------------------------------- Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde88%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde88%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

Đề xuất vẫn chưa được gửi

in %bids___i_period_sub_35% gün içinde80%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

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

in %bids___i_period_sub_35% gün içinde80%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)