MS SQL 2012 to Exchange 2010 Public Calendar Add/Update/Delete
$30-250 USD
Paid on delivery
[login to view URL]
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.
Project ID: #15990787
About the project
9 freelancers are bidding on average $180 for this job
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
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
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
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. :)
