Closed

MS SQL 2012 to Exchange 2010 Public Calendar Add/Update/Delete

[url removed, login to view]

We use a database in our HR system for employees to request Paid Time Off (PTO). We would like to take the employee's name, pto date and description of PTO and have it populate a public folder calendar by creating, updating or deleting a calendar entry based off the SQL database.

My thoughts would be a trigger.. new record creates calendar event. Change of PTO hours requested would change PTO description. (Currently employees can request Unpaid time, 4 hours time or 8 hours time so the description of the PTO would be JANE DOE - 4 HOURS or if changed JANE DOE - 8 hours and the calendar date/time would just be an all day event). FInally if the PTO is canceled then the calendar entry it removed.

Right now to track the information is just a SSRS report.

Thanks for looking and your proposal. Will consider budget and experience, also willing to work with freelancer if project goes off track a bit. Willing to pay 20% at beginning and 80% at completion.

Skills: Database Programming, Microsoft Exchange, Microsoft SQL Server, SQL

See more: update-publicfolderhierarchy, get public folder replica, check public folder replication status exchange 2007, update public folder content, update-public folder, update public folder replica, force public folder replication exchange 2010, public folder management console, http www microfin360 com mbsk index php configledgercodes add, http www google com search client ms rim&hl en&q freelance 20reporting&ie utf 8&oe utf 8&channel browser, freelancer com أقرا علي موقع ثقف نفسك http www thaqafnafsak com 2012 10 7business from home html المصدر, freelancer com http www thaqafnafsak com 2012 10 7business from home html, access public calendar exchange 2010 php, sharepoint 2010 resource calendar web part exchange, exchange 2010 resource calendar webpart

About the Employer:
( 3 reviews ) St George, United States

Project ID: #15990787

11 freelancers are bidding on average $167 for this job

mahmoudgamal008

I have more than 5 years of professional and practical experience in .NET, SQL Server and database development. I am MCTS:SQL Server and MCP. I am one of the top 25 users on SQL and SQL Server tags on Stackoverflow( More

$150 USD in 3 days
(39 Reviews)
5.7
khannanav

We are a team of Database experts with more than 12 years of rich experience on Database management, programming, modelling, applications. FullStack: JAVA, Python, Golang, JavaScript, Java, R, Hadoop, Kafka Databa More

$222 USD in 3 days
(7 Reviews)
3.8
$155 USD in 3 days
(8 Reviews)
3.2
SergioAlfaroV

I am a MCSA SQL Server 2014 certified professional, with more than 10 years of experience in SQL related projects and tasks. My approach would be to use INSERT/UPDATE/DELETE triggers that call xp_sql2exchange Extended More

$200 USD in 3 days
(3 Reviews)
2.9
RushService

Feel fee to contact me for MS SQL 2012 to Exchange .Shoot me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the [url removed, login to view] payment only aft More

$150 USD in 3 days
(3 Reviews)
2.4
binmonis

This task could be completed by me in three days at the most. Please check my portfolio if you have any doubts on my competency. Looking further for a discussion.

$66 USD in 3 days
(4 Reviews)
1.4
sreenivas2903

I have made changes like this earlier , if we both will have discussion and freeze the requirement. I will be able to provide the results before deadline.I have bid for small amount for getting an oppurtunity . Hope d More

$133 USD in 4 days
(2 Reviews)
1.1
zhengyang19

Hi, sir. I just read your description and made full understanding. I will do my best to keep prices as low as possible and will execute your project until you are satisfied. I have sufficient knowledge and a lot of More

$155 USD in 3 days
(0 Reviews)
0.0
symaticssolution

Dear Hiring Manager! As per your job post I got your point and somehow I agree with your trigger solution but there are other options too. We can have brief discussion over it. I have seen article too I know it make More

$277 USD in 3 days
(0 Reviews)
0.0
vw7914687vw

A proposal has not yet been provided

$222 USD in 5 days
(0 Reviews)
0.0
majumdergoutam8

Day 1: Requirement understanding and coding Day 2: Fine tuning and submission. Although I am new here in freelancer. I have in depth understanding of databases and I handle data in TBs. You can give me a shot. :)

$111 USD in 2 days
(0 Reviews)
0.0