Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies. Only from Platform Scholar.
Course Of The Month
10 days, 16 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Sharepoint Calendar
Posted on 2013-02-01
I have a table with dates and event details for those days..
I would like to create a Calendar that creates events on the calendar based on the sql table
I have attached a pic of what the calendar look like. I now need to have it pickup event dates from a table and display the event details from the table.
What do I need do to this?
And What level of access do I need to to this I was given Site admin but I was not able to create a calendar?
I know security in Sharepoint is complex but what level do I need to create a calendar as well..
I would like to create a Calendar that creates events on the calendar based on the sql table
I have attached a pic of what the calendar look like. I now need to have it pickup event dates from a table and display the event details from the table.
What do I need do to this?
And What level of access do I need to to this I was given Site admin but I was not able to create a calendar?
I know security in Sharepoint is complex but what level do I need to create a calendar as well..
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
4
3
7 Comments
Active today
A calendar is just a list. You should be able to create that as Site Admin. Any specific messages or anything seem unusual?
Creating events based on a SQL Table. This is likely to be based on a Business Connectivity Services (BCS) connection that surfaces the SQL Table, then a process such as a SharePoint Designer based workflow to move that information into the List.
Alternatively an External Content Type (also created with SharePoint Designer) being populated from the table and being made to present a Calendar View of the information.
None of this is really straightforward and the BCS stuff needs something beyond the free licensing.
What version of SharePoint do you have?
Do you have access to SharePoint Designer?
Any possibility of a coded solution?
If there is very limited experience of SharePoint at your organisation then the requirement you want to meet is going to seem a little complex.
There's a similar thread here, I notice suggesting similar remedies;
http://sharepoint.stackexchange.com/questions/6576/how-do-i-populate-a-sharepoint-list-from-a-sql-table
http://www.linkedin.com/groups/Copy-records-from-MS-SQL-43166.S.97684314
http://social.msdn.microsoft.com/Forums/en/sharepointdevelopment/thread/8dd925d9-1a46-451e-a3ba-9a97f399fb1b
Creating events based on a SQL Table. This is likely to be based on a Business Connectivity Services (BCS) connection that surfaces the SQL Table, then a process such as a SharePoint Designer based workflow to move that information into the List.
Alternatively an External Content Type (also created with SharePoint Designer) being populated from the table and being made to present a Calendar View of the information.
None of this is really straightforward and the BCS stuff needs something beyond the free licensing.
What version of SharePoint do you have?
Do you have access to SharePoint Designer?
Any possibility of a coded solution?
If there is very limited experience of SharePoint at your organisation then the requirement you want to meet is going to seem a little complex.
There's a similar thread here, I notice suggesting similar remedies;
http://sharepoint.stackexchange.com/questions/6576/how-do-i-populate-a-sharepoint-list-from-a-sql-table
http://www.linkedin.com/groups/Copy-records-from-MS-SQL-43166.S.97684314
http://social.msdn.microsoft.com/Forums/en/sharepointdevelopment/thread/8dd925d9-1a46-451e-a3ba-9a97f399fb1b
Active today
OK, yes i did install SPdesigner..
i saw this site
http://go4answers.webhost4life.com/Example/sync-sql-server-table-sharepoint-list-48833.aspx
but non are really clear on how to create this External Content Type..
I am trying to get the date out of the view in sql still into Share point
Any other pointers or easy to follow sites have this info?
i saw this site
http://go4answers.webhost4life.com/Example/sync-sql-server-table-sharepoint-list-48833.aspx
but non are really clear on how to create this External Content Type..
I am trying to get the date out of the view in sql still into Share point
Any other pointers or easy to follow sites have this info?
Active today
When you get the data into your list, there is a type of View you can create called a Calendar View. It's straightforward that you map your columns that signify start date, end date etc to the View. The information will then be displayed just like an Outlook Calendar, or as a List if you prefer (or both!).
The difficult bit is the External Content Type. You have SPD so you can do it, but the guides online are better than any guidance I can give you here.
The difficult bit is the External Content Type. You have SPD so you can do it, but the guides online are better than any guidance I can give you here.
Active today
Thought occurs. Not sure if its an option but Bamboo do a web part called Calendar Plus. It can obtain information from SharePoint Lists but also external sources such as SQL.
That may be a lot easier than trying to do it yourself. Sometimes such purchases are cheaper than the time spent trying to self implement.
http://store.bamboosolutions.com/sharepoint-calendar-plus-web-part.aspx
That may be a lot easier than trying to do it yourself. Sometimes such purchases are cheaper than the time spent trying to self implement.
http://store.bamboosolutions.com/sharepoint-calendar-plus-web-part.aspx
Active today
Yikes!
Dont know yet if we can justify the investment yet.. I am trying to create an account with enough access to get to Database from Sharepoint..
I have done this before in 2007 but i had sql sa account and was the control of entire site..
here i dont have as much rights.. So i trying to see what account setting i need to optain this list from SQL
Dont know yet if we can justify the investment yet.. I am trying to create an account with enough access to get to Database from Sharepoint..
I have done this before in 2007 but i had sql sa account and was the control of entire site..
here i dont have as much rights.. So i trying to see what account setting i need to optain this list from SQL
Featured Post
Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article explains how to reset the password of the sa account on a Microsoft SQL Server. The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL).
Depending on business requirements, a single Stored Procedure can return differe…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month10 days, 16 hours left to enroll
631 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.