Some thoughts on programming stuff
If you are like me and usually updates manually a spreadsheet to track your progress in a daily basis related to something like diet or spenditures, you will know that your spreadsheet may become very long. That’s why I created an small script to allow me jump to current date cell on Open in Google Sheets automatically.
The script will run like a macro and after a few moments you have opened the spreadsheet, it will focus the correct cell!
Continue readingThis post will cover the step-by-step guide for you to manage account settings in Visual Studio 2019. It can be helpful to a new user who needs to reenter their credentials or check for a updated license.
As you may know, Visual Studio comes in three flavors:
Some of them require you to buy a license to make use of all its features. This post won’t cover that, but it’s valid to mention it if you don’t know it.
Continue readingIf you are like me and want to use Azure DevOps Dark Theme, say no more! Basically you can do that in your tenant or deployment (if you go On Premises) in a very easy way. Following this post you will learn how to enable Azure DevOps dark theme.
Hopefully Azure DevOps offers a set of customizable options, so you can adopt easily and use the platform like you want. I’ll cover other options someday.
The Dark theme will have a dedicated post because more and more users use this configuration in any tool they use for many reasons:
It’s important to say that I’m not an expert on health benefits of dark theme use neither on how it can help your vision against light. There are many studies about it and you can check it over your searches over Internet.
Continue readingThis blog post will talk about an idea of customization of the SharePoint breadcrumb for better navigation. The solution uses the out-of-box Delta Breadcrumb Dropdown component to provide the data required to render the breadcrumb using pure JavaScript for that.
SharePoint offers an out-of-box authentication flow that applies for most real-world scenarios. But unfortunatelly, one situation is not well designed (IMHO…) and demands a small customization. Let’s say you stumble on an Access Denied page you won’t have an easy option to sign out and try with another user. There’s no shortcut to Sign in as different user on Access Denied page.
The option to quickly sign out and sign in with another user account is great when you are testing permissions for multiple users. Also, your test context situation gets worse if you are using Integrated Authentication and your Windows user account is the same as your SharePoint user, you won’t be able to type any credentials at all because it will keep you getting authenticated everytime you open the SharePoint site.
You will keep seeing the message below:
Maybe you need to get web URL from document URL in SharePoint, or even just grab the Site Collection URL and do some awesome logic and update some data in your site. But you are aware that it can be costy and require some array splits, substrings and those kind of tricks. So here is a code snippet to save your time to enjoy a good cup of coffee with your colleagues!
The document URL usually is composed by a site collection part, the specific web part, the Library name and then the final part containing the folders and the file name. The script basically will perform a request to a SharePoint API. Our parameter is the folder or library URL (cutting the filename) that will be made automatically. Finally, the result will come with the Web and Site Collection urls for that context.
If you have to embed a Power BI report to a SharePoint Online Classic Page, then just go for the iFrame approach. Power BI offers a “Publish to web” feature that helps you on embedding reports easily. Although it’s not so interactive and have some limitations (can’t use Query string filtering), it still works well and offers some parameters like the possibility to set default page in Publish to web from Power BI.
We are going to cover the steps for embedding and setting a default page for our report!
Continue readingThis post will help you when you want to identify which W3WP belongs to which application. It comes in handy when we need to debug Visual Web Parts and Event Receivers deployed as Farm Solutions. The basic approach requires the user to open Visual Studio, attach the W3WP processes and refresh your page to start debugging.
Well, it’s pretty common in our daily life tasks (not so much since we all should move to the Client-side of the force) to have more than one W3WP available to attach. Usually we have one for your site, other for SharePoint Web Services, another for the SharePoint Central Admin and even more for any other Application Pool process being used in your Server.
But if you want to attach to just one process and make Visual Studio more performatic and responsive, how can you do that?
Just follow the steps in this post!
Continue readingThe last three months I’ve been working less with SharePoint and more with Angular 4/Node JS projects. This change forced me to use less Visual Studio and dive deep into Visual Studio Code in almost every task. I must say that I fell in love with the editor and decided to search about how to sync SharePoint files with VS Code.
While working with VSCode, I’ve been testing some Gulp tasks like SPSave and SPSync for automatizing file changes to SharePoint, just for fun. Because I just can’t accept SharePoint Designer anymore, my patience with it ran out.
Also the Windows feature to map a network drive to a SharePoint library isn’t good too, at least for me.
So basically the gulp tasks did the trick, but they aren’t that easy to be understood for some more “traditional” programmers in my company, which would end with few adopters here.
So while searching for SharePoint extensions just for curiosity, I found the SPGO Extension and it really impressed me!
Basically it’s an extension that with some basic setup you can start syncing files from your computer with SharePoint libraries.
SPGo Extension
Sometimes you can face something like an error related to Access Denied when activating feature in SharePoint. It’s pretty common to happen when we are developing an automatized routine or anything that access SharePoint administration objects. As an example it can be Timer Job that will run in a specific schedule and you creates it on feature activation.
Wiliam is from Porto Alegre, Brazil, currently working as DevOps Engineering Advisor at Dell EMC. He has been working with Microsoft technologies for almost ten years with one year gap studying abroad in Japan attending the Science without Borders program from the Brazilian government. Also he is MCSE Productivity, a SharePoint lover. Nowadays he is investing the most part of his time on exploring GitLab and Azure DevOps features and helping the company to develop a DevOps culture among its colleagues. In addition of that, he spends some time on learning Japanese, doing CrossFit and playing real-time strategy games like Age Of Empires. Read More…
© 2024 wiliammbr's blog
Theme by Anders Noren — Up ↑
Recent Comments