?
Solved

New to Sharepoint 2010.

Posted on 2012-03-28
3
Medium Priority
?
229 Views
Last Modified: 2012-04-05
My company has decided to move into SharePoint 2010 for data warehousing and for use by many different departments. As it stands I have no experience in SharePoint and am need of some pointers. What I am trying to accomplish is to store all my lists in a single site or site collection to which I will grant the least amount of privileges to and then created other sites or site collections to which my users will actually go and work from. I need to find a way to allow users to access forms and data from the single “Lists” site(collection) and work with that data and have workflows run on that data across different lists. For instance, HR will need an Employees list where they enter employee info. When that is submitted I need it to email me in IT to create accounts and grant that user access, as well as notify Finance of the hire. When HR terms an employee or someone changes roles I need workflows to notify the responsible people to take the required actions, i.e. IT disables the employee’s accounts. Basic can anyone point me to a resource for someone new to SharePoint 2010 to connect lists to a different site or site collection?
0
Comment
Question by:CooperRiis
[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
  • 2
3 Comments
 

Author Comment

by:CooperRiis
ID: 37778878
I realized that my example above was not complete enough to explain the situation. The reason a single workflow would not work for the above example is, after IT is notified we need to publish their account information into their employee record. In other places an employee’s email address will be pulled from their employee record in the Employee list in order to give feedback based on processes happening in other departments. As well, an asset list will be present for assets assigned to employees i.e. cell phones and laptops. This needs to be readily tied to an employee’s record in the Employee list for the instance of termination where a supervisor will need a list of all the assets that will need to be returned by the Employee. This is just one example of many complicated database style interdepartmental lists that will need to be tied together on a central site that employees will not be accessing directly.
0
 
LVL 51

Accepted Solution

by:
Ted Bouskill earned 1000 total points
ID: 37804616
Well, I'm not surprised you don't have an answer.  This seems to be a simple request but it's actually complex.

First off, a single master list will create more problems that you realize and SharePoint was not designed to work optimally that way.  If you need to create a master list of employee information I'd use a SQL database that can then be bound to multiple SharePoint lists using custom content type's that are connected to the database tables.

Essentially everything you are asking for is possible with SharePoint but requires and advanced knowledge of the product and this is not the forum to teach you SharePoint.  I'd recommend you hire a consultant to help or start by installing the product in a development environment and start learning it.
0
 

Author Closing Comment

by:CooperRiis
ID: 37810794
I am taking some courses now. I appreciate the suggestion about Sql. That will most likely be the way I go.
0

Featured Post

Office 365 Training for IT Pros

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question