All Posts

All Posts (536)

• 

  Published on

  2021-02-24 11:34 a.m.

  Authors

  koskila

  Tags

  gutenbergmicrosoftexcelwordpress

  How to copy-paste a table from Excel to WordPress without using plug-ins?

  So, I tried to paste a table from Excel into WordPress, and I failed. Annoying - but not a big problem. I can just paste it into an existing table and it'll "sort itself out", right? Well, no. Exporting the Excel sheet as a html page and copy-pasting the table from there didn't work either. Actually, copy-pasting a table just didn't work at all. So... WordPress is unable to understand HTML tables. Is that really it? Well, no, again, it's not.

  Read more →
• 

  Published on

  2021-02-17 9:44 p.m.

  Authors

  koskila

  Tags

  sharepointlistssharepoint-online

  How to create a new SharePoint list based on a List template (.stp)?

  New Microsoft Lists are here!. They are awesome, and a great move by Microsoft to reap even more value from the old warhorse. Wait - old warhorse? Well, behind the scenes, they're actually "just" normal SharePoint lists with a bit of added sparkles and gizmos - namely, an app, a few automations to make users' lives easier, and an application page to display the lists. Great move by Microsoft, launch quite well done, and a pretty good user experience so far. But it's not all good.

  Read more →
• 

  Published on

  2021-02-08 10:24 p.m.

  Authors

  koskila

  Tags

  sharepointlistssharepoint-online

  How to enable saving a list as a template on SharePoint Online?

  Another day, another fun little task in SharePoint Online... :) This time, I needed to be able to migrate 10 or so lists with some very specific fields and plenty of content from one site to another one. What's the best way to do that now?

  Read more →
• 

  Published on

  2021-02-02 5:51 a.m.

  Authors

  koskila

  Tags

  azureazurecliazurefunctions

  How to change Azure Functions from Consumption to Premium Elastic plan?

  Sometimes, you need to change the hosting model (or tier) for your resources on Azure. Maybe you've outgrown whatever you've originally selected, maybe you've got too much cash on your hands, or maybe you're like me, and you get absolutely and completely fed up with the cold starts for your Azure Function apps on the Consumption plan and want to use the Premium Elastic plan instead. For these situations, you have the possibility of changing the hosting tier - the plan - you're on.

  Read more →
• 

  Published on

  2021-01-26 9:06 a.m.

  Authors

  koskila

  Tags

  azuredevopsdevopsnugetvisual-studio

  Azure DevOps Pipelines Caching

  Azure DevOps pipelines have a pretty handy feature called Pipeline Caching . It'll help you avoid annoyingly long NuGet package restores in your builds. And that makes sense - why would you restore packages again and again and again, if you're not updating your dependencies meanwhile?

  Read more →
• 

  Published on

  2021-01-20 9:00 a.m.

  Authors

  koskila

  Tags

  certificatespfx

  How to recover the private key of a (.pfx) certificate?

  Recently, I ran into a problem that I definitely caused myself. I had a certificate, that was created to authenticate an app against Azure AD. The encryption key for the .pfx file was, however, lost. I could just create a new certificate, configure the app service to use that, and replace the old certificate... But that's manual labor and where's the fun in that? I prefer a solution that included a bit more coding!

  Read more →
• 

  Published on

  2021-01-12 7:23 p.m.

  Authors

  koskila

  Tags

  azurefunctions

  How to fix "System.IO.FileSystem: Could not find a part of the path - - Value cannot be null. (Parameter 'provider')", when running Azure Functions locally?

  Well, that title is a mouthful. But it's the topic for today, so what can you do? That said, this article should be pretty topical, as the issue started popping up only a few days ago. Chances are it'll be patched soon enough, but in the meantime, it's always useful to document the fix! Problem When running or debugging Azure Functions locally, your runtime just blurts our this error and fails to compile your functions: [2021-01-11T10:28:11.

  Read more →
• 

  Published on

  2021-01-11 1:06 p.m.

  Authors

  koskila

  Tags

  visual-studio

  How to nuke the Identity Cache in Visual Studio?

  This article explains one easy workaround to a lot of Visual Studio authentication issues. Personally, it's helped me multiple times when Cloud Explorer has gotten into a weird authentication loop or Visual Studio stops seeing my MSDN subscription.

  Read more →
• 

  Published on

  2021-01-06 4:53 a.m.

  Authors

  koskila

  Tags

  aspnetcorenetcore3nuget

  Fixing unexpected Microsoft.AspNetCore package errors after a dependency update

  This was a fun one! Suddenly, while running or debugging my ASP.NET Core 3.1 application, I started getting errors about missing assemblies, along the lines of "FileNotFoundException: Could not load file or assembly Microsoft.AspNetCore.Components.Forms". These DLL files were not required a minute earlier - nor did requiring them really make much sense in my mind - but there was a nonsensical, easy fix, so in the end, it was all good! But let's go through this thing in order.

  Read more →
• 

  Published on

  2020-12-31 2:27 a.m.

  Authors

  koskila

  Tags

  yearreview

  2020 - Year Review

  Like is almost customary at this point in the year, I decided to take a look at 2020 - which goals I had set for myself if I hit them, and what happened on koskila.net during the year. And like last year, I thought I'd set myself a few new goals! In my last year review post, I commented on 2019: 2019 was borderline tumultuous – in 2020, I hope it’ll be slightly smoother sailing. Me, in my 2019 review Oof. Overall, 2020 was definitely not "smoother sailing".

  Read more →
• 

  Published on

  2020-12-29 10:03 p.m.

  Authors

  koskila

  Tags

  graph-apigraphexplorer

  Graph API throws "$count is not currently supported." when you KNOW it's supported?

  Hey, another funny case. "Funny" as in "the error message is misleading and googling didn't really help", but also as in "a colleague knew the answer right off the bat because he already fixed it in another project". This time the documentation was in fact there , it just wasn't there to be found . Anyway - what have I broken this time? Problem When you're calling Graph API with both $filter and $count, for example: https://graph.microsoft.com/v1.0/users/$count?

  Read more →
• 

  Published on

  2020-12-08 4:21 a.m.

  Authors

  koskila

  Tags

  ef-coreentityframeworkcore

  "An assembly specified in the application dependencies manifest was not found" when running Add-Migration in Entity Framework Core?

  Another quick one - I'm sure this doesn't apply to all cases, but I'm still logging it in case someone (like myself) stumbles upon the issue and finds help here.

  Read more →
• 

  Published on

  2020-12-01 2:08 p.m.

  Authors

  koskila

  Tags

  aadazure-ad

  How to fix Visual Studio Cloud Explorer being unable to access your subscriptions

  This article will describe a number of fixes to a situation, where your Visual Studio Cloud Explorer fails to show you the Azure Subscriptions you (should) have access to. Problem Your Cloud explorer might load for a long while, and finally, fail to display anything meaningful. Instead, you might see an error like the below: "Subscriptions could not be loaded. Please try reentering "Subscriptions could not be loaded.

  Read more →
• 

  Published on

  2020-11-24 1:21 p.m.

  Authors

  koskila

  Tags

  azuredevopspulumi

  Pulumi task on Azure DevOps fails with error "azureblob.OpenBucket: accountName is required"

  This article explains how to fix one of the many issues you might face when configuring Pulumi deployments for your Azure DevOps Pipelines! The particular error you may run into was "azureblob.OpenBucket: accountName is required" - what a descriptive one, when there's no accountName to be specified anywhere! But first - let's get through the basics. Namely... " Pulumi ?", you ask - " What's that? " Well, let me give you a 1-line response to that. What is Pulumi?

  Read more →
• 

  Published on

  2020-11-17 7:23 a.m.

  Authors

  koskila

  Tags

  githubhacktoberfest

  Hacktoberfest 2020

  Another year, another Hacktoberfest, another haphazard participation, and - as usual - another blog post a little bit late. Still, better late than never! And the event has become such a phenomenon that I am happy that I did finish the challenge (or like DigitalOcean calls it - the celebration)! The event has a special place in my heart, as it did (in 2017, I think?

  Read more →
• 

  Published on

  2020-11-11 11:09 a.m.

  Authors

  koskila

  Tags

  sharepointappcatalogsharepoint-app-partsharepoint-online

  How to access the site collection app catalog in SharePoint

  This article explains how to access the Site Collection App Catalog in SharePoint Online. I mean - yeah, I had to google it after getting back to SPFx dev stuff after a while and realized the first few results were useless. Of course. So how did you do this now... Turned out to be pretty easy, and borderline obvious! Still, yet another thing to document. Solution So, back to basics - how do you access the Site Collection App Catalog on a SharePoint Online Site (or Site Collection)?

  Read more →
• 

  Published on

  2020-11-04 6:23 a.m.

  Authors

  koskila

  Tags

  worxlandroid

  Frequently Asked Robot Lawn Mower Questions

  This article is my attempt at documenting my experiences with Worx Landroid L2000. It's a phenomenal little helper in your garden, but it will run into issues - and it will make your work a bit in order to get it to run efficiently! This article contains all of the gotchas I've run into so far, wrapped in a handy FAQ format for your convenience (and mine, to be fair - I'll be back to consult my notes later)!

  Read more →
• 

  Published on

  2020-10-29 9:01 a.m.

  Authors

  koskila

  Tags

  azureazurefunctions

  How to inject EF Core DbContext in an Azure Function

  Ah, one more on the related topics of different configurations for your Azure Function apps. In this article, I will describe how you can configure the Entity Framework Core database context to be injected into your Azure Functions App. In my experience, this is a very typical and often-needed model to structure your Azure Functions. Therefore, while tooling and templates aren't quite there, it's worthwhile to document how to do this somewhere - well, here.

  Read more →
• 

  Published on

  2020-10-27 7:48 p.m.

  Authors

  koskila

  Tags

  entityframeworkentityframeworkcorems-sql-server

  "Conversion overflow" when reading numeric data from MS SQL database using Entity Framework

  This article explains how to fix a weird situation where your .NET application utilizing EF ( Entity Framework or Entity Framework Core ) simply crashes without any way to recover or catch the Exception. You only get errors somewhere along the lines of "conversion overflow". Ah - what a fun little issue! No way to recover, no fallbacks, unusable callstacks. Oh, speaking of which - what was the error, exactly?

  Read more →
• 

  Published on

  2020-10-21 10:48 a.m.

  Authors

  koskila

  Tags

  azurefunctions

  How to configure Azure Function's startup

  Azure Functions use dependency injection, and that allows us to define all kinds of prebuilt or custom-built services as being available for our functions really easily. This is a really easy way to initialize scoped resources to be used in your different functions... But how do you actually configure them in an Azure Functions App? Problem Okay, a step back - there's a bit of a problem that we need to resolve before we can proceed with the configuration.

  Read more →
• 

  Published on

  2020-10-14 8:25 a.m.

  Authors

  koskila

  Tags

  git

  How to list your git stashes

  Long story short, yes, I really did have to google this, and since top results seemed to give pretty unclear (or even wrong) answers, I decided to document it for myself. Maybe it'll be helpful to someone else too! And just to state the obvious: I'm using GitHub Desktop for most of my mandatory Git stuff, but whenever I have to run any git commands, I run Windows PowerShell (git exe is added to PATH variable). Solution Well, it's actually very, VERY simple.

  Read more →
• 

  Published on

  2020-10-05 12:31 p.m.

  Authors

  koskila

  Tags

  pnppowershellpowershell

  How to fix "System.InvalidOperationException: PowerShell Gallery is currently unavailable."

  This article explains how to fix an issue when updating a module in PowerShell. The error is something along the lines of: " System.InvalidOperationException: PowerShell Gallery is currently unavailable. Please try again later." The whole error looks something like the one below, although you can probably get it for many different commandlets. Failed updating module 'SharePointPnPPowerShellOnline' version 3.19.2003.0. Update the module and then try again.

  Read more →
• 

  Published on

  2020-09-29 10:26 a.m.

  Authors

  koskila

  Tags

  microsoft365microsoftlists

  How to change Microsoft Lists language?

  I recently started playing around with Microsoft Lists. What a fun and friendly tool - makes SharePoint lists far more approachable offering a great editing experience, easy sharing, and hopefully in just a bit, awesome integrations and great mobile app (I mean, there's iOS... But who has an iPhone in this day and age? 😉 However, as is usual in my tech endeavors, I immediately ran into an issue.

  Read more →
• 

  Published on

  2020-09-21 6:50 p.m.

  Authors

  koskila

  Tags

  pnppowershellsharepointsharepoint-online

  App authentication woes on SharePoint (Token request failed. The remote server returned an error: (401) Unauthorized.)

  This article explains how to get rid of sudden and unexplainable 401 Access Denied errors when trying to authenticate against a fairly fresh Microsoft 365 / SharePoint Online tenant. This issue seems to be caused by a long-ish project to finally retire ACS - Azure Access Control service) on SharePoint ( it's retired everywhere else already! ) Note : This might still be an updating story, as the situation with ACS is definitely... Developing. Yeah, let's call it that. It's a developing situation.

  Read more →
• 

  Published on

  2020-09-16 1:55 p.m.

  Authors

  koskila

  Tags

  azure-advisual-studio

  How to leave an Azure AD tenant?

  This article explains how to fix your account, whenever it gets completely FUBAR due to your account being added as a guest in another AAD organization. And this might happen in multiple different situations - my most typical woe is Visual Studio's Cloud Explorer, which stops showing me my subscriptions due to authentication against the other organizations failing.

  Read more →