Thursday, July 29, 2021

Converting a file with .json format to a file with .csv format using PowrShell

  The easiest way to do this is to use Windows Powershell as described here. It is enough if you convert .json to .csv. File format .cssv can be opened with EXCEL and saved.

This is the .json file:



   "Name": "James Bond",

   "Age": "35",

   "Profession": "Professional Killer",

   "Location": "London, UK"



This file, JamesBond.json  is saved on my desktop.

Let us say that is the code you need to convert to from .json to .csv format

Create the above text in Notepad and save it with the extension .json (default is .txt for Notepad)

Open the Windows PowerShell ISE

Type in the following code (try to see what else you can convert from and convert to in the above images):

Get-Content C:\Users\TestUser\Desktop\JamesBond.json | ConvertFrom-Json|ConvertTo-Csv

Run the code in the Windows PowerShell ISE

You will see this result:



"James Bond","35","Professional Killer","London, UK"


You get the answer as shown. 

This is in CSV format and this can be opened with EXCEL.

This can be saved as .xlsx or various other formats.

Sunday, July 25, 2021

Thursday, July 22, 2021

Start playing games on ZOOM

 A new game for the videoconferencing app ZOOM

Now you can not only collaborate but you can also play games. Of course, collaboratively I hope. More and more people jumping on to Games (I heard Netflix is going the games way). Is it healthy? 

How do we find time to play games? It does not bode well for corporate culture with so many games around. Anyway, it is game time, and if you have Zoom on your device try it out.

These are the steps to play games on ZOOM quoted from the above site:

1. Log in to Zoom. 

2. Search for Live Game Poker Night or Heads Up in the Zoom App Marketplace. Install the game. 

3. Start a Zoom meeting as normal.

4. Click the Zoom Apps tab at the bottom of the meeting window to launch the game. 

5. Once the host has configured any game options and set up the game, players will be taken to the poker room to play. Protection Status