Closed

ATS/SQL/Azure -- 2

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.

Skills: Azure, MySQL, Software Architecture, Software Testing, SQL

See more: web azure, web application azure, ui reporting, test exchange email, quote response template, Office 365 Exchange, csharp test, csharp or, cloud based exchange, application website template wordpress, access vba.net, highlight page user clicks menu item, lotus notes user agent forward email, php sql register user, draw line user clicks mouse vbnet, use sql server 2005 send mass email, program replicates user clicks, provide feature construct sql query user visual 2005, php user clicks, sql database user authorization read

About the Employer:
( 0 reviews ) United States

Project ID: #8800780

7 freelancers are bidding on average $778 for this job

seekdeveloper

Hi, I have read your post and understood your requirement. I have great experience in handling /Azure/PHP/MySQL/HTML5/jQuery/Wordpress/Magento/Joomla/Drupal/AngularJS/node.js/CSS3/Java/Python/Django/Javascript/iO More

$1030 USD in 10 days
(37 Reviews)
7.7
cdstechnology

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

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

Respected sir > , VI World is Indian base company. You can see our work at [login to view URL] or in portfolio section. We provide best solution in low cost . So we want to discuss about your requirement. If you shor More

$445 USD in 10 days
(91 Reviews)
3.6
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