Simple – go to this website and type the commands to install a new powershell. Well – in Microsoft fashion – not quite that simple. First running the PowerShell commands needs one to DOWNGRADE the allowed SSL to Tls1.2 on the powershell first. Then … you can get going.

1. Open Powershell as an admin (right mouse click on it and choose Open as Administrator)
2. Then type
   [Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
3. Then follow the steps in the main article. I chose all the default options as I am using Sharepoint Online

Invoke-Expression (New-Object Net.WebClient).DownloadString('https://raw.githubusercontent.com/sharepoint/PnP-PowerShell/master/Samples/Modules.Install/Install-SharePointPnPPowerShell.ps1')

NOW we can rock out. This article mainly helps me over the hump of the proper Tls1.2. Where next? I am going to write my first SPFx Sharepoint Foundation web part – cause they took my old WebParts away for use on the Modern UI pages in Sharepoint 2016 and Online. Kindle to the rescue with the book called Mastering Sharepoint Framework: Master the SharePoint Framework Development with Easy-to-Follow Examples

I was getting individual fields from a Sharepoint List and the SOAP request (old code) needed the viewId (a GUID) and it took a long time to find it. It is quite easy to find (now that I found it once) but if you go to the classic view and click Library->ModifyView and scroll all the way to the bottom-right – you will see your viewId in url-encoded text at end of the URL. Done. Its tricky to know what GUID was being sought and it wasn’t on my blog – so it took longer. Never again 😉 You can stop reading but below is the context in which the viewId is needed.

You have to get script access added by the admin – so for one client I had to beg for it – but since jQuery is part of Sharepoint – all we do is add some code and it makes the items between <h2> tags appear and disappear. Add a little more CSS to get a + and – added to the right and we are good to go. I would use a different <hX> or make my own – but Credit goes to this guy:

https://info.summit7systems.com/blog/how-to-create-dynamic-accordions-in-sharepoint-pages

Bitly accounts have no QR ability – mental – must be a paid version or a royalty thing. Anyways – type this in to any browser and you instantly can download a QR code png. First change the last part to your own short code. Instructions are here for other options.

https://chart.googleapis.com/chart?cht=qr&chs=177×177&chld=H&choe=UFF-8&chl=https://myShortCode.com/12345

BUT – that can’t be read from an iOS device camera taking a pic or clicking on a web page. So here is a text version so you can copy it easier:

First, I couldn’t write the title until I got to a) the correct example online, then b) the proper credentials (a work-mate(s) hinted towards the answer) and c) the exact exception text “The sign-in name or password does not match one in the Microsoft account system.”

Sharepoint – as usual … SUPER FOR CONTRACTORS WHO GET PAID THE HOUR. (argggg).

So I set up 2 Raspberry PI’s in the past week as a friend of mine needed something to do DDNS. I have not completed an Arduino DDNS but I have been comfortable with the PI. I wondered why the price went up in til I realized that the new RPI 3 B+ has wireless and bluetooth now. Nice – and not sure why the name didn’t change :-). Some must have’s I have found are:

• enable SSH and/or VNC – can even do config via ssh in a console like way!
• An off switch via a paperclip – this made me laugh and I reviewed the code. Slick! So put a screw in the official package I gave back to my friend as the off switch (short last 2 pins on GPIO)
• A reboot every week (not necessary but the place I am putting this is 2 hours away – so if any memory leaks etc. occur – I want it to work – can you tell I use Windows for a living?) It is super stable but it needs a reboot still every 3 weeks or so
• turn the time-sync on – there is no battery so it can go off time

I didn’t want to lose these links so I made an article. Also how to setup no-ip ddns which is super easy – plus I found Snotty Ron’s Cupcake recipe and the Snotty Ron commercial which I must share.

Spare parts, but no spare time but i puttered away at this anyways. So there are a couple kinks to work out, but I wanted something remote for my Time Machine so it could work on the hour every hour in the background. My wireless on my Apple Extreme went but the main router is still in action. So what now? I need somewhere to plug an external USB drive into. So due to Covid19 – like many people I snapped and cleaned my office drawers and dusted off an old Rasperry PI 3 B+. Hey – I could try that cause my time machine perpetually says preparing backup and all the online help doesn’t work.

I had a spare drive (not sure why) so I cobbled the whole thing together and after > 24 hours of it backing up – I think it works. Here are links and quick tips to keep it going

You can do all of this without being an admin

List Id is easy: Go to a list, switch to classic mode, Click Library->Edit Library – your id is in the URL between %7B abd %7D (%7D is at the end of the url most likely). Those % items represent { and } respectively

Site ID: If your site is https//me.sharepoint.com/sites/MYSITE then add _api/site/id into a new tab in your browser and press enter. Your answer should be there. (Your browser will do a GET to the REST import will do a simple GET to the sharepoint get the site ID using REST)

WebID: Kinda lame once you know the site ID trick. just add _api/web/id.

This has become less exciting now that I know how. The reason I wrote this post is tehre are TONNES of resources on how to get these if your an admin or if you sharepoint powershell works – but adding the words to google “not as an administrator” got me these answers quick.

References: this guy, this chrome extension and this guy are my heros for this.