MS SQL 2012 to Exchange 2010 Public Calendar Add/Update/Delete
$30-250 USD
Πληρώθηκε κατά την παράδοση
[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.
Ταυτότητα Εργασίας: #15990787
Σχετικά με την εργασία
9 freelancers κάνουν προσφορές κατά μέσο όρο $180 για αυτή τη δουλειά
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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. :)