BrightWork Collaborative Project Management Framework Overview By Joel Oleson Executive Overview I have the privilege of seeing so many great projects and solutions. BrightWork Collaborative Project Management Framework and software are no exception. I first was introduced by BrightWork by Éamonn McGuinness, who has the vision of making successful project and portfolio management possible [&hellip
by Joel Oleson via CollabShow
Tuesday, March 28, 2017
Exam Prep: Optimization and Monitoring
Stop using Access-based apps in SharePoint Online
Microsoft announced today that Access Services in SharePoint are slowly going away in favor of Microsoft PowerApps! Starting in two months (June 2017), you will no longer be able to create Access-based apps in SharePoint Online, and you have until April 2018 to convert your existing Access apps to PowerApps or any other tool that fits your business needs.
To make the transitioning process smoother, Microsoft has added a feature in Office 365 allowing you to export your data from the Access app, to a SharePoint list from where you can take advantage of both PowerApps and Flow to build modern and mobile-ready business applications. You can find more information about the process here.
As for everyone who is running SharePoint On-Premises, not only will Access Services and Access Web Apps be supported for the remainder of your current SharePoint support timeline, but they will also be included in the next version of SharePoint Server!
For all those of you who think that SharePoint 2016 is the last version of SharePoint On-Premises, this blog post is another proof that there will be another version of SharePoint Server . An important note is that this does not affect the Desktop version of access, but simply Access Services in SharePoint!
I am wondering, how many of you use Access Services in SharePoint Online currently? If you use it simply type something in the comments! You can find the Original Announcement on the Microsoft Tech Community!
Follow me on Social Media and Share this article with your friends!
|
| Leave a comment and don’t forget to like the Absolute SharePoint Blog Page on Facebook and to follow me on Twitter here for the latest news and technical articles on SharePoint. I am also a Pluralsight author, and you can view all the courses I created on my author page. |
The post Stop using Access-based apps in SharePoint Online appeared first on Absolute SharePoint Blog by Vlad Catrinescu.
by Vlad Catrinescu via Absolute SharePoint Blog by Vlad Catrinescu
Monday, March 27, 2017
Decomission That Old Server (Move Extranet Service)
So you have an old Web Front End server. It has been a good ‘un (as we say in the south) a real work horse, but for numerous different reasons, it is time to “decommission” the ole gal and get a new work horse in place. You are going to keep the old WFE in place while you build up a new one and get them to look identical before taking the old one offline. One problem, you notice you are running this extranet service and you cannot get it installed on the new server. What is a horse farmer, I mean server admin to do?
First, Add the new server to the farm. Provision all necessary services except those that can only run on one server (like UPS and probably Search topology and of course the Extranet Service). For the rest of these steps, I will only focus on the ExCMExtranetService, additional services will need to be deployed as needed in your environment.
Next, stop the ExCM Service.
Once stopped, delete the ExCM service application (if there is one). Now you are ready to remove the extranet service using the Remove-ExCMExtranetService.
Now you are ready to remove the server from the farm.
With the old server out of the farm, you will want to retract and redeploy the ExCM solution. Now, you will need to start the service on the new farm. The way the service gets started is when you activate certain features of ExCM; features like Extranet Account Managers, Authentication Provider Mapping, user automation, etc. Chances are you have already activated these features, which is why you see the service in your farm to begin with. If you do not need to activate one of these features, then you can also start the service by running the “New-ExCMExtranetService”
As you can see from the below screenshot, I now have the service running on the new server.
Lastly, browse out to your extranet site and ensure that you can log in. Enjoy!
by noreply@blogger.com (Johnathan Horton) via SharePoint Solutions Blog
Status update on the latest DFFS BETA
I have spent a lot of time last week and in the weekend trying to sort out some problems with “on-change rules” that surfaced in the last BETA version. Due to the changes in the “debug output”, it became clear that there were some issues that needed attention. The problem is related to using multiple rules on the same trigger – for example a multi choice field.
This means I’ll have to do some changes to how the “on-change rules” are handled, and release a new BETA – hopefully later this week or next weekend.
Alexander
by Alexander Bautz via SharePoint JavaScripts
Deleting a Very Large SharePoint List
I’ve complained about the 5000 item list threshold limit so many times, I’ve lost count. If you don’t believe me, you could read my posts here and here and here and here.
Today’s difficulty was caused by needing to delete a Very Large List. This isn’t just a Large List – it’s Very Large. The number of items is way over 5000 at almost 300000. This list is part of a well-used application I built for a client about 3 years ago in SharePoint 2007. It’s been ticking away just fine, as there was no list threshold in 2007.
I’m migrating the application to SharePoint Online, so I’m totally rewriting it for several reasons. I copied across the list “shell” with Sharegate and brought along a few hundred items in the big list just for testing and building purposes.
But now I need to test “at volume”, so I brought across all 300k items. Unfortunately, I forgot to add an index to one of the columns where I need it to make some queries work. I figured “no big deal”. I’d just delete the list and start again.
Not so fast! When I tried to delete the list, I got this error:
I’m trying to DELETE the list, so what gives? Well, I found a post from Mike Smith (@TechTrainNotes) entitled SharePoint 2016: List View Threshold Limit to Delete a List is 99,993 Items??? which pretty much told me why this wasn’t working. It’s crazy, but you can’t delete a list or library which has more than 100k objects in it. (Read Mike’s post to see where he ran into a few wrinkles on this.) One would think that deleting a list would have nothing to do with any thresholds, but one would be wrong.
I tried a number of things – deleting the list in SharePoint Designer, writing some code to delete items one by one, etc. – but either my attempts didn’t work or they were taking forever.
Luckily, I have no pride and I complained on Twitter. Kelvin Hoyle (@kelvin_hoyle) came to the rescue!
@sympmarc I had this happen once, and used Access to pull in the list and deleted all the records. Worked very well..
— Kelvin Hoyle (@kelvin_hoyle) March 27, 2017
By connecting to the list with Microsoft Access, I was able to select all the items and hit delete. Yes, this is taking a while as well, but it’s clearly faster.
The steps to do this are:
- Open Access – I’m using Access 2016 – and create a blank database.
- In the ribbon, go to External Data and in the Import & Link section, click on the More dropdown.
- Choose SharePoint List
- Provide the URL to the SharePoint site which houses the list
- Be sure to leave the default radio button selected, creating a link between Access and the SharePoint list.
- Click Next, and choose the list you want to work with.
- Click OK.
Access will set up a new table which is linked to your list. You can open it like any other table in Access. Open the table and – voila – you can select any items you’d like to edit or delete.
Yet another workaround for something which I think shouldn’t be a limitation in the modern age. Sigh.
by Marc D Anderson via Marc D Anderson's Blog
Saturday, March 25, 2017
Rencore Tech Talks - Episode 005 - Microsoft Teams with Maarten Eekels
Note. This episode was recorded 2016-12-08.
I’m catching up with Maarten Eekels on Microsoft Teams. As of this post, Microsoft Teams has been released in General Availability. As of the recording, it was still in a preview.
Episode Guest, Maarten Eekels
Maarten Eekels (@maarteneekels is Microsoft MVP and CTO of Portiva, one of the larger SharePoint and Office 365 implementation partners in the Netherlands. In that role he is responsible for all knowledge and technology related matters.
Maarten is an experienced Office 365 and SharePoint specialist and already since version 2003 he is involved in implementing SharePoint and (later) Office 365.
Also, Maarten is a regular speaker on both national and international events, like conferences, SharePoint Saturdays, and user group meetings. In September 2015 he started a video blog series called Maarten’s Cloud Journaal, specifically targeted at Dutch speaking Office 365 users.
Some of the topics we brush on are:
- Microsoft Teams, where does it fit in?
- Teams Desktop Applications vs Browser
- Threaded conversations, giphys etc.
- Enabling Teams in my Tenant
- Bots and Connectors for extensibility
- and more...
Listen now:
All the best,
Tobias Zimmergren
by Tobias Zimmergren via Zimmergren's thoughts on tech
Subscribe to:
Posts (Atom)