Blog entries related to Microsoft SharePoint and Office 365 solutions such as Power BI, Microsoft Flow, Power Apps and Microsoft Teams
As a company that provides customer relationship management (CRM) services, we’re big advocates of using your CRM system to track and approve sales commissions. But sometimes it can be impractical to do this. This is particularly true in complex organizations, small organizations or fast-growing organizations where you need the flexibility to quickly adapt your commission model to a changing situation in the marketplace. Long-term, everyone should aim to handle commissions in their CRM system, but what do these organizations do in the short-term?
The good news is that SharePoint is an excellent tool for giving you all of the flexibility you need, while still having an efficient process for setting, tracking and distributing commissions. Here’s how it can work for you.
Read the rest of entry »
I was working with PowerShell to update a managed metadata field that accepted multiple values in a publishing page library today and it was more difficult than it seemed like it should have been, so I’m posting here what actually worked for me. It turned out to be much simpler than I was trying to make it.
On a recent project, I hit an issue with databases that was interesting. We were restoring a lot of databases over to a development environment from production, as well as the managed metadata database. I had gone through the whole deal, backed up the database in the old server, restored it to the development SQL server, etc. There was an issue with the Managed Metadata service that required to have service application re-created. This lead to a situation where the service application database was unprovisioned, but not deleted.
If you ever move a calendar from one place to another, either as part of a site move or a list move, you will be greeted by the fact that your calendar overlays no longer work because the URLs to the overlaying calendars are hardcoded into the list view. I am trying to set up an automated restore from production to development, so having lots of broken calendars isn’t great. Fortunately, all you have to do is run a few lines of PowerShell to fix this.
I don’t believe Microsoft Expression ever had a huge following from web developers and graphics designers, but it served a purpose. Whether you liked it, hated or loved it, Microsoft has done what it does best again.
In case you haven’t visited their website lately, you will notice some major changes with Expression. Basically, they are rolling the Expression products into Visual Studio 2012 and beyond, forgoing the standalone tools. For the time being, they made Expression Web 4, Expression Design 4 and Expression Encoder 4 free for download. That may not be a big deal to some, but I think it could prove useful to some.
Microsoft Excel is an amazing tool both in terms of the diversity of functions that it can provide and in the depth of data analytics and business intelligence that it makes available to people at every level of an organization. But too often businesses find that they are using it to solve problems that are much more complex that Excel was intended to solve - and paying a price in terms of employee productivity and costly decisions made using bad data.
So how do you know you've taken your Excel application too far? And what do you do about it?
So you’re going about your business in SharePoint, say when you want to publish an article page. You open the page and click on Publish, and the Schedule option isn’t there! Ack! Oh the humanity! If you’re uploading a document, the schedule items appear on the edit properties (editform.aspx) dialog.
You may be asking, what scheduling option? Well, it’s the option for being able to publish pages at a future date and time and is activated at the document library level. If you have a publishing site, this feature should already be activated on the Pages library. But it can be enabled on any site/library under the right conditions. This is very likely a simple fix. Let’s review the items to check.
Calendar Overlays was definitely a welcome new feature when SharePoint 2010 was released. They provide decent basic functionality for being to have a nice view of multiple calendars at once (up to 10 calendars). Suppose you are in a situation where you want to do some calendar overlays, but you only want to show a filtered set of calendar entries on the calendar overlay view? This turns out to be much easier than it might sound. Now you could write a simple workflow that runs on the child list and copies the list item on the child calendar to the parent calendar, but that’s not really an overlay is it?
As I said, this is actually extremely easy to configure. It feels like it should be illegal to be this easy, so enjoy the moment! So what do we need to do? Here are the overview steps:
Last week, C5 Insight attended the annual SharePoint Conference in Las Vegas. It was a very full and eventful week, which was the primary reason I did not blog each evening on the daily events as I have in the past. My goal for this blog post is to summarize the overall conference highlights and some of the features that we see as very promising in SharePoint 2013.
While the contacts list is usually filled out for contacts that are outside the company, there are times when you would use a contacts list to store internal and external resources. Wouldn’t it be nice if you didn’t have to re-type your internal contacts’ information that are already in the system? Now you can with a little InfoPath customization on the contacts list.
Several days ago I wrote a post in response to the successful South Carolina cyber-attack (that earlier post can be found here). Although the security benefits alone are enough to justify starting the move to the cloud, there are numerous other cost-saving and productivity improving reasons for state and local governments to consider making the move.
As I work with various clients with different skill levels with SharePoint, I have on more than one occasion needed to compile a list of training resources. Microsoft (and others) provide a good number of resources so I thought I would try and compile a list in one place. These resources can be a mix of delivery methods including blogs, whitepapers, online videos, tutorials or courses. Let’s start with resources for end users, then move to the IT Pros, then to the developers. I started writing this for the purpose of training, but the lists quickly grew to include other resources, so I hope you find it a useful resource.
For the sake of this post, all resources will be for SharePoint 2010. But with the very soon to release SharePoint 2013, I will provide some information in another post. Stay tuned!
Earlier this week it was announced than an international hacker had successfully made off with over 3 million social security numbers and almost 400,000 credit and debit card numbers from the state of South Carolina. State and local governments have collectively spent billions of dollars trying to secure their data systems. In spite of this investment, a hacker was able to identify and exploit a weak spot in their armor. As public sector budgets are continuing to shrink, there is pressure to add more software applications to automate tasks and lower costs; increasing pressure to cut costs on security for these applications; and increasing pressure to extend the life of less secure and aging legacy computer applications. The result is that our government agencies are at increasing risk of successful cyber-terrorism through a greater number of applications, lower security standards, and aging applications that should be replaced.
How could South Carolina and other state and local governments cost-effectively protect vital citizen, business and government records? The answer comes from an emerging private-sector technology: cloud computing.
By now, most of you reading this have likely heard a little about SharePoint 2013, Microsoft's next version of its best-selling collaboration platform. In this short blog, we wanted to highlight some of our favorite features that will be in the next version of SharePoint.
If you're unsure what ULS logs are or what they're used for, please see my previous post where I cover the basics. On a recent project, I was adding a new server to a SharePoint 2010 farm. After the join was completed, I went to go review the ULS logs to ensure all looked well and no serious errors or other issues came up. To my surprise, it was empty! It turned out to be a simple fix, but here are some things to check when this happens:
While you shouldn’t have to, it might be necessary to either perform an IISRESET on the problem server, or even reboot to ensure new credentials take affect.
I recently had a client that wanted to change the default text that appears in all search boxes. By default it shows “Search this site…” and the client wanted it to be a little more customized to their environment. It turns out this is very simple to accomplish, and no code! We just need to edit 2 XML files.
Awhile back I ran into an issue where I had some site collection backups that failed to complete. No big deal, but this caused the locks on the site collection to remain in place, as I curiously found my administrator account with deny permissions on all sites in the site collection. This begs the question “What other site collections could be locked?” That becomes a real problem if you have a large number of site collections. Who wants to check each one in Central Administration one by one? Being the non-developer type, I turn to my trusty friend PowerShell.
First, what are we talking about specifically? In Central Administration, click Application Management, then under Site Collections, click Configure quotas and locks. Choose your web application/site collection, and view it’s status:
If you’re like me, at some point in your life you have set out to search the internet for SharePoint for one reason or another. After you found what you were looking for, you take a few extra minutes to look at what other posts the site has and you realize, this is pretty useful, I want to grab the RSS feed. Or you are just building a list of your favorite SharePoint MVPs. Or maybe you’re new to SharePoint, and don’t know all the cool kids’ blogs. Well after a while, those really start to stack up in your RSS reader. Wouldn’t it be nice if you could combine all those useful SharePoint RSS feeds into one single feed?
Crawled properties are metadata properties that are exposed or derived from documents, lists, libraries and anything else that can be indexed. When you search in SharePoint, these crawled properties have to be mapped to managed properties, which will be displayed in search results and refinements. While you may already know this, consider the impact on your organization, or your client’s for that matter, if something goes awry with a key SharePoint component that boasts robust capabilities: Enterprise Search.
Updates are everyone’s favorite topic, and I just wanted to throw out a few good resources on how to keep up to date on the updates that Microsoft released for SharePoint 2010 and WSS 3.0 / MOSS 2007.
First and foremost, to keep up to date on SharePoint updates, you need to subscribe to the updates RSS feed! These posts provide links to the KB articles and downloads for the various configurations (Microsoft Office, SharePoint Foundation, Server, Server with Project Server, Office Web Apps, FAST Search, etc.). Notice that this feed includes all Office products, not JUST SharePoint. Unfortunately Microsoft doesn’t publish an update feed just for SharePoint that I know of. Also, Stefan Gobner, a Senior Escalation Engineer with Microsoft support, does a bang up job also posting SharePoint CU releases on his blog, as well as when issues come up. Links:
I wanted to share this quick tip with PowerShell. Many times, we need to have an easy way to find the configuration database, and like a good SharePoint administrator, you want to try and use PowerShell. I have come across other blogs here and others that mention finding this with the registry, so this is just another way to do it.
The more I learn and get to know PowerShell, the more I love it. I am able to perform what used to be time-consuming tasks (many hours or days) in seconds (after you write the script of course). While writing a script recently to perform some tasks on numerous SharePoint sites (webs to be precise), I was constructing URLs for the sites and using as variables and I needed only part of the URL (the managed path). After a little poking around, I found a nice easy way to do it.
This is my third blog in a series concerning data integration. In my first two blog entries we overviewed some of the data integration hurdles as well as some of the common methods used to discover the net-change data that will need to be translated. Here in my third blog I’ll discuss some of the benefits of not integrating in real-time, but creating a batch job to perform the integration. We’ll also look at the Business Rules that may need to be applied within the integration process.
In my previous blog focusing on the hurdles of real-time, two-way data integration, I highlighted the hurdle of how to discover the data you need translated. In most cases, discovering the net-change data is all you want to translate on a real-time basis. Remember, a two-way integration means net-change data going in two directions or more (depending on the number of systems you’re integrating) at a rate determined by how many end-users there are on each of the systems being integrated. Business systems with a significant amount of end-users can create substantial volumes of net-change data.
After concluding the first day at the Microsoft Convergence 2012 event here in Houston, TX, I can summarize my feelings in one sentence, “It is a great time to be alive and working on collaboration!” Why do I say that? Here are a few brief insights:
The complementary paper includes over 12 years of research, recent survey results, and CRM turnaround success stories.
This 60-second assessment is designed to evaluate your organization's collaboration readiness.
Learn how you rank compared to organizations typically in years 1 to 5 of implementation - and which areas to focus on to improve.
This is a sandbox solution which can be activated per site collection to allow you to easily collect feedback from users into a custom Feedback list.
Whether you are upgrading to SharePoint Online, 2010, 2013 or the latest 2016, this checklist contains everything you need to know for a successful transition.