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: csv
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
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
Opening CSV files in Excel
CSV (Comma Separated Values) is a useful file format for tabular data that I often use. But every time I want to load a CSV file into Excel it does not seem to recognize the files. Usually it just loads … Continue reading