Ask me anything about Microsoft SharePoint 2010
Recent Responses
-
-
What error are you getting?
-
You may also want to check out https://www.nothingbutsharepoint.com/sites/eusp/Pages/head-to-head-sharepoint-migration-tool-demo-videos.aspx for video comparison on popular SharePoint migration tools.
-
I can't say that I know of any whitepapers, but you maywant to check out http://www.sharepointreviews.com & http://www.topsharepoint.com/content-migration-tools-for-sharepoint. They have reviews on 3rd party tools include migration tools.
-
I can't say I know. There are a lot of possibilities. Are there any errors in the event log on the client machine? Is it on all machines or specific one? There may be software installed on the client machine that is causing the issue. If you can find an error message or log please send it along and I will see if I can be of more help.
-
If you would to connect oracle database to SharePoint 2010 TechNet has a really great article at http://msdn.microsoft.com/en-us/library/ff464424.aspx that explains how to setup Business Connectivity Services to bring in Oracle data. Additionally, Excel, Visio, Access, and Reporting Services are also able to use Oracle data by using the Microsoft connection wizard. For more information visit http://blog.mclaughlinsoftware.com/microsoft-excel/how-to-query-oracle-from-excel-2007/, http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/61a531b5-7fea-44db-8b75-704b5bb25c50/, http://msdn.microsoft.com/en-us/library/ms156450.aspx, http://technet.microsoft.com/en-us/library/dd220591.aspx, http://stackoverflow.com/questions/4891387/how-can-i-import-the-contents-of-an-oracle-database-into-visio-to-create-an-enti, http://msdn.microsoft.com/en-us/library/ms156450.aspx, and http://msdn.microsoft.com/en-us/library/dd220591.aspx . If none of these solutions suit your needs, you can always build a custom solution that uses the System.Data.OracleClient namespace to query the Oracle database, return the results, and then render the information in a format of your choosing. I hope this information helps and gives you some options to explore.
-
PS. You can also consolidate list information using LINQ. Check out this article as well http://msdn.microsoft.com/en-us/library/ff742311.aspx.
-
Hi Jim,
There are number of way you could do it. If you do a quick Bing search for “SharePoint 2010 list consolidation” or “SharePoint 2010 list aggregator” you will notice that there are a lot of third party products that can help you bring together your information. This is probably the simplest way to get what you need.
If you are like me and like to do it yourself here are a few more options. Andrew Connell and Todd Baginski wrote a web part called “TBAC Content Monster Web Part for SharePoint” (CMWP) that you can download at http://archive.msdn.microsoft.com/ContentMonsterSPWP that allows you to aggregate data across websites unlike the standard out-of-the-box content query web part. The CMWP was built for SharePoint 2007, but the source code is included so you can compile it against SharePoint 2010’s API.
An out-of-the-box solution you can use combine, filter, and display your data is creating a solution with Reporting Services. Reporting Services reports have the ability to bring in information through web services. As luck would have it every SharePoint list is accessible through web services with the correct security permissions. Read more about building a Reporting Services report with SharePoint list data set at http://nikspatel.wordpress.com/2010/06/11/step-by-step-consuming-sharepoint-2010-lists-data-in-the-ssrs-2008-r2-reports/ . You will have to have a dataset for each list. You can create multiple tables to display the data or to combine the information you can create multiple sub-reports that rollup the information into one larger report. Not ideal, but it will work. Excel can be used is much the same way. Check out TechNet’s Using SharePoint lists as data sources with Excel Services (SharePoint Server 2010) at http://technet.microsoft.com/en-us/library/gg576960.aspx for more information on connecting Excel to SharePoint lists.
The last solution I can think of is going with a custom solution. You can use the SharePoint API to cycle through web application and site collections to use the SPSiteDataQuery class to find your list with a site collection. For more information about using SPSiteDataQuery visit http://www.srinisistla.com/blog/Lists/Posts/Post.aspx?List=01f20192-49aa-4e73-975b-782314f02a0a&ID=75&Web=56ee3901-627b-490f-ba09-db3c0623d63b or http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spsitedataquery.aspx. You can join multiple data tables using the merge method and then attach the consolidated data table to any type of control you would like. You could use an ASP.NET DataGridView control, a Silverlight data grid control, or even a reporting services report.
There are a few ideas for you and I hope this helps answer your question. -
I also found this article by dux today that explains how to sync Excel spreadsheets and SharePoint lists together using an Excel 2007 Add-In. It is definitely worth checking out http://sp.meetdux.com/archive/2010/03/30/Sync-Excel-SharePoint-2010.aspx.
-
Well I not exactly sure what you want to do. From what I understand you shouldn’t have your documents on a file share and in SharePoint. There would be at least two set of files and linking new and delete files would be hard to maintain.
If the files are within SharePoint Foundation, then the out-of-the-box search will include the documents in the search results. If the files are on the file share, then SharePoint Foundation alone will not allow you to search file shares because it doesn’t include SharePoint 2010 Search Connector Framework. You can install Search Server Express 2010 at http://www.microsoft.com/enterprisesearch/en/us/search-server-express.aspx, which is free, to search file shares and include the results within SharePoint Foundation. See http://social.technet.microsoft.com/Forums/en/sharepoint2010setup/thread/3294d73f-b127-439e-88af-c78c70f9a9e2 for more information on installing Search Server Express 2010 with SharePoint foundation. To show the files on the file share in SharePoint you can use a page viewer webpart on SharePoint webpage and add a path to your network drive. Check out http://www.bfcnetworks.com/configure-sharepoint-2010-search-for-crawl-file-servers/ for more information.
I hope this information as helped and please feel free to write back if I did not answer your question fully. -
Well I can tell you this, if you go to TechNet and look at the minimum software requirements for Microsoft Project Server 2010 the article says the following:
“At a high-level, the key requirements for Project Server 2010 are as follows:
• The 64-bit version of Windows Server 2008 Service Pack 2 or Windows Server 2008 R2
• Microsoft SharePoint Server 2010 Enterprise version
• For a farm deployment, database servers must be the 64-bit version of Microsoft SQL Server 2008 with Service Pack 1 (SP1) and Cumulative Update 2, Microsoft SQL Server 2008 R2, or Microsoft SQL Server 2005 with Service Pack 3 (SP3)
• Microsoft Internet Explorer 7, Microsoft Internet Explorer 8, or Microsoft Internet Explorer 9 for Microsoft Project Web App user access"
To read more about Microsoft Project Server 2010’s software requirements at http://technet.microsoft.com/en-us/library/ee683978.aspx. -
Hi Liakath,
From Excel you can only import into a new SharePoint list. The only way to get around this is to open your SharePoint list in datasheet view and copy and paste the data from the spreadsheet into the datasheet view of the list. Your spreadsheet columns need to match the SharePoint list exactly to copy and paste the information in correctly. There are other third-party products you can explore as well if you need a more robust solution. -
To quote John D. Ross from this SharePoint forum response at http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/2283d53c-50fd-4571-a6aa-f6eb6e91e2c5 "You can specify another drive -- but SharePoint will still put the information in the root folder (../14) on the C drive. It doesn't take up a ton of space. What takes up the most space on a SharePoint server are the index, log, and database files all which can easily be moved to another drive." I personally always install on the C:\ drive and have the log files stored on another drive because they can grow in size, but there are no hard fast rules. All the installations of SharePoint I have seen have also been on the C:\ drive. Hope this helps.
-
If you would like to learn SharePoint 2010 without having the software you should check out my post at http://www.the14folder.com/2010/07/27/sharepoint-2010-virtual-labs/ for all the latest SharePoint 2010 virtual labs. All you need is a web browser (IE7 or higher to be exact) and you can work through the tutorials to learn about SharePoint. If you want to install SharePoint 2010 on your work or home computer you will need Windows 7, Windows Vista, or Windows Server 2008 SP2 or higher. TechNet has a really great article to help you set up your training environment at http://msdn.microsoft.com/en-us/library/ee554869.aspx. I hope this helps.
-
No problem. I am so glad it was helpful. Congrats on starting your SharePoint journey!
-
-
Hi munnaprecious,
I read your question on the Microsoft forums and answered it to the best of my abilities. I must admit that your question was hard to understand. This is what I think you are saying.
You are working for a university and you’re getting exam results in Excel, .mdf, .bak, and .txt file formats. You are combining the results into a SQL database so the data is all in one place. You had an ASP.NET website, but now you are trying to display the results in SharePoint. You created a web part in a feature and solution, but developing it is slow and uploading your new solution each time there is an error is time consuming. I think you are asking if there is a better way to develop and display the exam results in SharePoint.
To answer your questions it really depends. You said you had an ASP.NET website before. Did you create a user control to display the results in your aspx page? If you created a user control in your ASP.NET website then you can use a web part load the user control into SharePoint for you. Check out http://msdn.microsoft.com/en-us/library/ff649867.aspx#Y1596. With a user control web part you may be able to use the work you did in the ASP.NET website and alter the code a little bit to incorporate SharePoint security.
The other way you may want to consider displaying your results is with Reporting Services reports. I am assuming that you have a full version of Microsoft SQL Server. Reporting Services reports are easy to create and even easier to deploy. You can deploy your reports to a Reporting Services report server or directly into SharePoint. You restrict displaying data based on security and/or student ID, though it will take a little bit of planning. For more information about SharePoint and Reporting Service visit http://technet.microsoft.com/en-us/library/bb326358.aspx and http://msdn.microsoft.com/en-us/library/ms159170%28v=sql.100%29.aspx.
In SharePoint 2010, you can also create a connection you’re SQL Server database and allow teachers to add and modify exams results using SharePoint lists and Business Connective Services. This would give teachers a way to enter exam results without having to send you an Excel spreadsheet or text file. You will need to do some planning around security, views, backups, and tracking changes made my teacher’s in case of mistakes. For more information about Business Connective Services visit http://msdn.microsoft.com/en-us/magazine/ee819133.aspx and http://technet.microsoft.com/en-us/sharepoint/ee518675.
I hope I answered your question and gave you some things to think about. It sounds like you might need additional help. I would suggest seeking out a Microsoft partner in your region that can look at your situation specifically and give you additional advice. To find a Microsoft SharePoint Partner near you check out http://sharepoint.microsoft.com/en-us/partners/Pages/Pinpoint.aspx. -
Preventing users from deleting items in SharePoint is a common issue. The recycle bin in SharePoint 2010 helps prevent the permanent deletion of files, folders, and sites, but you still need administrative assistance sometimes to restore the item. Ideally, the user's security permissions should be configured to restrict their access so they don’t even have the option to delete. You could break the security inheritance on the folder and change the permissions so that certain users cannot delete the folder, but the files in the folder will inherit the authorization permissions. You could also break the inheritance of each file in the folder, but that would be time consuming and hard to maintain when new files are added. You could probably create a workflow to give each added file the correct permissions, but all the unique permissions would get messy to maintain in the future.
To prevent any item from being deleted in a list or a site I would use an event handler if security permissions will not due. Event handlers are a compiled module of custom managed code that responds when specific SharePoint triggering events take place. In our case, we would want attach our event handler to the list and wait until the list fires an ItemDeleting event. An ItemDeleting event will run your custom code just before it starts deleting the folder. In your code you want to stop SharePoint from executing the rest of the SharePoint deletion code by cancelling the event.
Check out my blog post at http://www.the14folder.com/2011/07/20/prevent-accidental-deletion-sharepoint/ to see instructions on how to create an event handler to stop a folder from being deleted. -
Steven Ma on the Microsoft forums gave you an awesome reply. Check out his response at http://social.technet.microsoft.com/Forums/en/sharepoint2010setup/thread/0838eedb-13b1-4a24-96f5-53750a18a20c and view the article at http://sharepointcoding.wordpress.com/2010/04/16/performancepoint-2010-dashboard-designer-an-unexpected-system-error-has-occurred-when-adding-a-data-connection/ . It sounds like your issue exactly. Make sure you followed all the steps. Let me know if you are still having an issue.
-
Unfortunately there isn't much you can do. I have experienced the same issue myself. The problem is that the virtual labs share server resources and the search indexing strains the server to the point that I think the server shut downs the image. Indexing content can take along like as well. I have seen Fast search crawl content for days. I would continue the lab and just ignore the fact that search won't return the results you are expecting. The idea is understand where functionality is located within SharePoint so that it the future you can set it up for yourself in a real environment. You can also try contacting TechNet support and see if they can help resolve this issue (http://technet.microsoft.com/en-ca/subscriptions/bb521230.aspx).
-
The short answer is yes. The SharePoint Timer Service (owstimer.exe) is a Windows service. Services in Windows must be created in a Windows Service application project or another .NET Framework–enabled project that creates an .exe file when built and inherits from the ServiceBase class. The owstimer.exe was likely compiled using managed code as an .exe assembly and as such the runtime is started automatically by mscoree.dll when the .exe is run.
For more information about Windows services visit http://msdn.microsoft.com/en-us/library/d56de412%28v=vs.80%29.aspx.
For more information about hosting the Common Language Runtime visit http://msdn.microsoft.com/en-us/library/9x0wh2z3%28v=vs.71%29.aspx.
For more information about SharePoint’s owstimer.exe visit SharePoint 2010 Architectures Overview (http://msdn.microsoft.com/en-us/library/gg552610.aspx) and Creating Custom Timer Jobs (http://msdn.microsoft.com/en-us/library/cc406686%28v=office.12%29.aspx).
Thank you for your question and please feel free to follow up with any additional questions you may have about the SharePoint Timer Service.
~The 14 folder
-
The 14 Folder’s Bio
Canada
Where everything you need to know about Microsoft SharePoint 2010 lives
