Devam Ediyor

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ün: write mail, sql database program, incorrect address, cost microsoft sql server, on sql, write note get, get mail address, sql microsoft, software program, need write program, 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, sql microsoft project, net excel update, net txt csv, write time tracking program

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

Proje NO: #6511682

Seçilen:

kimhyunho

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 fazlası

2 gün içinde 77$ USD
(0 Değerlendirme)
0.0

43 freelancer bu iş için ortalamada 144$ teklif veriyor

CodeAmbassador

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 fazlası

in 5 gün içinde263$ USD
(93 Değerlendirme)
7.6
ambar

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 fazlası

in 10 gün içinde526$ USD
(28 Değerlendirme)
7.0
rinsadsl

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 3 gün içinde136$ USD
(127 Değerlendirme)
6.8
feninsoftech

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 fazlası

in 20 gün içinde222$ USD
(29 Değerlendirme)
6.1
CredibilityVN

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 3 gün içinde90$ USD
(17 Değerlendirme)
5.1
ibbuzz

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 3 gün içinde105$ USD
(39 Değerlendirme)
4.9
Ajz

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 3 gün içinde90$ USD
(8 Değerlendirme)
4.8
yuriyvsl

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 fazlası

in 3 gün içinde111$ USD
(17 Değerlendirme)
4.3
haovo

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 fazlası

in 3 gün içinde88$ USD
(7 Değerlendirme)
4.2
expertatwork

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 3 gün içinde78$ USD
(17 Değerlendirme)
4.0
johnbenz

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 fazlası

in 3 gün içinde150$ USD
(4 Değerlendirme)
3.8
romanprof

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 fazlası

in 7 gün içinde225$ USD
(1 Değerlendirme)
3.6
zkutch

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

in 3 gün içinde100$ USD
(3 Değerlendirme)
3.0
umbrellasofts

A proposal has not yet been provided

in 7 gün içinde250$ USD
(6 Değerlendirme)
3.0
mpalgeo

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 fazlası

in 3 gün içinde88$ USD
(3 Değerlendirme)
2.5
dipakmoliya

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 fazlası

in 3 gün içinde88$ USD
(1 Değerlendirme)
1.9
Excellentlancer

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

in 4 gün içinde80$ USD
(2 Değerlendirme)
1.4
jluke906

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 fazlası

in 5 gün içinde250$ USD
(1 Değerlendirme)
0.6
sensiesl

A proposal has not yet been provided

in 3 gün içinde155$ USD
(1 Değerlendirme)
0.5
istvanvarro

Hi, here is half done: http://mobra.erpos.ro/Samples/MSSqltest.exe 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 fazlası

in 2 gün içinde80$ USD
(3 Değerlendirme)
0.4