Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

New to Sharepoint 2010.

Posted on 2012-03-28
3
Medium Priority
?
230 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

618 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