About RLV Blog
My name is Dan and this is where I share tips and thoughts on computers and development. I've been a computer enthusiast for 20+ years, working as a computer/network technician as well as a games, software & web developer. Currently I work at Nexer Worklife specialized in SharePoint, Office 365 and Azure development. In my spare time I also make PC utilities that can be downloaded from RL Vision. You can read more about me here.-
Recent Posts
- Using emojis for easier JavaScript debugging
- Attaching a context menu to DetailsList column headers in Fluent UI
- Better cache management in ASP.Net Core (LazyCache/FusionCache)
- Modifying SharePoint list permissions with PnP Core
- Show React dialogs fluently with hooks and promises
- A faster way to get effective permissions with PnP Core
- Searching with Microsoft Graph Client Library for .NET
- Finding out what service created a SharePoint site
- Starter project for AzureAD authenticated communication with ASP.Net Core 6 API, React SPA and console app
- Read & Write MS Office custom properties with PowerShell
Categories
- Articles (6)
- Development (38)
- Games (3)
- Opinion & Thoughts (8)
- Software (4)
- Tips (27)
- Tutorials (16)
- Uncategorized (1)
Tags
- apps
- azure ad
- backup
- c#
- critical perspective
- csom
- css
- csv
- data
- development
- education
- excel
- games
- interface
- internet
- internet explorer
- javascript
- metro
- microsoft
- microsoft graph
- microsoft office
- microsoft word
- modern sites
- mouse
- nintendo
- office 365
- open source
- pnp
- portable software
- powershell
- privacy
- programming
- react
- security
- sharepoint
- sharepoint online
- software
- sound cards
- storage
- sweden
- utilities
- windows
- windows 8.1
- winforms
Popular Posts
- If Snipping Tool freezes and blocks your screen…
- Stopping Software Center from restarting your computer
- Moving web parts in SharePoint (without going insane)
- How to enable (or improve) two finger scrolling on…
- Method for determining candidate keys and highest…
- How long do writable CD/DVD last? 400 discs put to the test!
- How to quickly get the Group ID for an Office 365 Group
- A drag-and-drop GUI made with PowerShell
- What is a portable application, and why should you use them?
- Method for normalizing a relation to BCNF based on…
- How to backup and restore tables in Azure storage
- Try a new PDF reader and you’ll never go back…
Archives
- October 2024 (1)
- September 2024 (1)
- June 2024 (1)
- May 2024 (1)
- May 2023 (1)
- March 2023 (1)
- January 2023 (2)
- October 2022 (1)
- June 2022 (1)
- May 2022 (1)
- February 2022 (1)
- January 2022 (1)
- December 2021 (1)
- September 2021 (2)
- August 2021 (2)
- December 2020 (1)
- April 2020 (1)
- February 2020 (1)
- January 2020 (1)
- November 2019 (3)
- January 2019 (1)
- August 2018 (2)
- December 2017 (1)
- October 2017 (1)
- August 2017 (1)
- July 2017 (1)
- June 2017 (1)
- April 2017 (1)
- February 2017 (1)
- October 2016 (1)
- September 2016 (2)
- February 2016 (3)
- November 2015 (1)
- October 2015 (3)
- August 2015 (1)
- July 2015 (2)
- June 2015 (1)
- March 2015 (1)
- December 2014 (2)
- November 2014 (2)
- September 2014 (1)
- August 2014 (2)
- July 2014 (2)
- June 2014 (1)
- December 2013 (1)
- November 2013 (1)
- October 2013 (2)
- September 2013 (2)
- July 2013 (1)
- June 2013 (1)
- January 2013 (1)
- November 2012 (1)
- October 2012 (1)
- August 2012 (1)
- June 2012 (2)
- April 2012 (2)
- March 2012 (5)
Meta
-
Tag Archives: powershell
Finding out what service created a SharePoint site
SharePoint is the underpinning data storage for many Microsoft 365 services. Sites are are therefore created under the hood by many services. Sometimes it it useful to know from where a site was created. We can actually find this in … Continue reading
Posted in Development
Tagged microsoft 365, office 365, pnp, powershell, sharepoint online
Leave a comment
Read & Write MS Office custom properties with PowerShell
While working on automating Microsoft Word I needed to read and write custom properties in documents. I found several resources out there. Reading worked fine, but when writing custom properties they all crashed. I finally managed to fix it though, … Continue reading
Posted in Development, Tutorials
Tagged cmdlets, COM, microsoft excel, microsoft office, microsoft powerpoint, microsoft word, powershell
2 Comments
If Word randomly crashes when opening SharePoint documents
I’ve been working on a PowerShell script that automates Microsoft Word to open all files in a SharePoint library, modify the header and other properties and then save it again. I ran the script against 4000 documents and everything went … Continue reading
Posted in Development, Tips
Tagged automation, cache, COM, docx, microsoft office, microsoft word, powershell, scripting, sharepoint online
Leave a comment
Hacking DocX files to fix Quick Parts in Word Online
Microsoft Word documents can have Quick Parts connected to SharePoint fields, so that the value of the field is displayed inside the document. But Word Online (still) does not fully support this. It will display Quick Parts with a a … Continue reading
Posted in Development, Tips
Tagged microsoft word, powershell, quick parts, sharepoint online, word online, xml, zip
Leave a comment
Migrating data from Access to SQL Server
Suppose that you have a simple Microsoft Access database that you need to migrate to another database such as MS SQL Server. You model the tables and relationships in the new database, and now you need to export the actual … Continue reading
Posted in Development, Tutorials
Tagged access, csv, data migration, database, ms sql server, powershell, sql
1 Comment
How to backup and restore tables in Azure storage
There is currently no built in solution for backing up tables in Azure Storage, but we can easily do it with the help of a tool called AzCopy which is provided by Microsoft. Below is a PowerShell script I built … Continue reading
Posted in Development, Tutorials
Tagged azcopy, azure, azure storage, backup, csv, powershell
1 Comment
Solution to Azure AD App not able to use given permissions
A client I’m working with had trouble adding permissions to their Azure Active Directory Application (AAD App). We added application permissions to allow the app to read all users’ full profiles, read directory data and read O365 unified groups, but … Continue reading
Downloading OneDrive documents as PDF
As part of automating a build process I needed a way to download the product documentation from OneDrive and save as PDF files for shipping with product. The result is this PowerShell script with two cmdlets, one that takes an … Continue reading
Posted in Development, Tutorials
Tagged docx, microsoft word, onedrive, pdf, powershell, sharepoint online
Leave a comment
A drag-and-drop GUI made with PowerShell
The script below shows how to create a simple WinForms GUI in PowerShell, where you can drag and drop files and folders and then process these with PowerShell commands when you click the button. I’ve pieced this together using various … Continue reading
Converting a CSV file to RegX with PowerShell
If you need to convert a CSV file with terms to a RegX file for use in your .Net project, you can use this simple PowerShell script:
|
1 2 3 4 5 6 |
$items = Import-Csv "C:\strings.csv" -Delimiter ',' -Encoding Default [System.Resources.ResXResourceWriter]$resxWriter = New-Object System.Resources.ResXResourceWriter("c:\strings.resx") $items | ForEach-Object { $resxWriter.AddResource($_.Name, $_.Value); } $resxWriter.Close() |
The script assumes your CSV file contains two columns, “Name” and “Value”, … Continue reading