ATS/SQL/Azure -- 2

Closed Posted Oct 30, 2015 Paid on delivery
Closed Paid on delivery

Project must be completed in two weeks

1) Setup AZURE to host our new (WordPress) website (from Tranquil Blue)

2) Setup AZURE for a SQL database to receive data from an outside source

(CostPoint Cloud SaaS).

Currently:

An email with an attached report is processed and data from report

Is loaded into a database table for reporting. Based on what I heard

I believe the CTALS application is processing the data and importing into tables for reporting

3) Modify the webrequest email code (attached C#) to work from AZURE or

Office 365 to send out emails.

Move database to SQL server..

Hook up new UI.

Setup .Net project for csharp code:

Includes sending a response email to the person making the request,

Creating data for the inquiry, saving any attachments,

and generating an email to send to proper person in company based on the page the web request was made from

4) Modify the CTALS email code (attached VBA) to work from AZURE or

Office 365 to send out emails.

Move database to SQL server.

Change Access application to point use ODBC DSN to migrated database.

Email is generated when user clicks send in Access UI, this portion includes:

reading template and database information to generate email to send off to the customer who made the inquiry

5) Test connections

They wrote the original VBA CTALS code and highlighted the section that needs code change. This uses CDO MS schemas to configure and communicate with EXCHANGE.

They wrote the C# webrequest code similar to mine. I also highlighted that code section that would need modification.

Both work very similar in that they search and replace text within a template and use other database information for the address and text data. The code is fairly simple to read and figure out how that is done. Note: Both the CTALS and Webserver are currently onsite and communicate locally with EXCHANGE.

Anyway, if you need more details for a quote, let me know.

Azure MySQL Software Architecture Software Testing SQL

Project ID: #8800780

About the project

7 proposals Remote project Active Dec 6, 2015

7 freelancers are bidding on average $778 for this job

cdstechnology

Предложение еще не подано

$888 USD in 30 days
(4 Reviews)
3.9
pnjadhav

A proposal has not yet been provided

$1111 USD in 15 days
(1 Review)
3.0
YigitMercan

We have two successfull companies operating in Istanbul. Anova Danismanlık and Retailcake. You can references.

$750 USD in 3 days
(0 Reviews)
0.0
Bathma

A proposal has not yet been provided

$555 USD in 10 days
(0 Reviews)
0.0
rachid99

A proposal has not yet been provided

$555 USD in 10 days
(0 Reviews)
0.0
johnl424

I have been ms access application with ms access forms and backend in ms access / sql server since 2007 If required can show you the same through teamviewer or AMMYY.

$555 USD in 5 days
(0 Reviews)
0.0