Sunday, May 8, 2022

Open Source Applications to Find Duplicates Files

https://github.com/antikmozib/Dupe-Clear
C#
A duplicate file cleaner for Windows.
mozib.io/dupeclear
License GPL-3.0 license
25 stars
2 watching
4 forks
Releases 2
Dupe Clear v2.0 Latest
on May 8, 2021

https://github.com/arsenetar/dupeguru
dupeGuru is a cross-platform (Linux, OS X, Windows) GUI tool to find duplicate files in a system. It is written mostly in Python 3 and uses qt for the UI.
dupeguru.voltaicideas.net
python deduplication
GPL-3.0 license
2.7k stars
86 watching
298 forks
Releases 6
4.2.1 Latest
on Mar 26
+ 5 releases

Monday, May 2, 2022

Power BI Resources

Power BI on Microsoft Learn | Microsoft Docs
https://docs.microsoft.com/en-us/learn/powerplatform/power-bi

Online Professional Training from Microsoft Store
https://www.microsoft.com/en-us/store/workshops-training-and-events/professionals#topic=413870014

Create and use analytics reports with Power BI - Learn | Microsoft Docs
https://docs.microsoft.com/en-us/learn/paths/create-use-analytics-reports-power-bi/

Sign up for Power Apps Developer Plan - Power Apps | Microsoft Docs
https://docs.microsoft.com/en-us/powerapps/maker/developer-plan

The Power Apps Developer Plan gives you a free development environment to build and test with Power Apps, Power Automate, and Microsoft Dataverse.

In May 2021, we extended the capabilities of the Power Apps Community Plan to meet the needs of developers and rebranded it as the Power Apps Developer Plan.

Anyone with a work or school email address backed by Azure Active Directory can sign up for the Power Apps Developer Plan.

Get started with Power BI Desktop - Power BI | Microsoft Docs
https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-getting-started

Tutorial: From Excel workbook to stunning report in Power BI Desktop - Power BI | Microsoft Docs
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-excel-stunning-report

Saturday, March 26, 2022

How to push a local Git repository to a new remote repository in Azure DevOps from Visual Studio Code?

* Make a new empty repository without add a README in Azure DevOps.
* Copy the Url https://dev.azure.com/myADO/Project/_git/myGitSample from the Push an existing repository from the command line (Omit git remote add origin)
* Go to VSCode to add a new remote with Url above and named it myAzureDevOps for example (similar as git remote add origin [https://...)]https://...)
* After add remote successful, then push to remote (myAzureDevOps) (git push -u origin --all)
* Check Azure DevOps using browser

Saturday, February 19, 2022

How to show emoticon on MacBookPro

With text box on focus, press three keys together ⌃-⌘-Space Bar (Control-Command-Space Bar)

Sunday, October 3, 2021

How to Validate the Integrity of the Downloaded KeePassXC File on Mac

Download from https://keepassxc.org/download/ the birnary, signature and hash files.
KeePassXC-2.6.6-x86_64.dmg
KeePassXC-2.6.6-x86_64.dmg.sig
Value from KeePassXC-2.6.6-x86_64.dmg.DIGEST
ab96033c16459de5a95e1f9e5864a5bd8cc47b4f3dee2c68ede6199dd44286ec  KeePassXC-2.6.6-x86_64.dmg

At the terminal:
$ openssl dgst -sha256 KeePassXC-2.6.6-x86_64.dmg
SHA256(KeePassXC-2.6.6-x86_64.dmg)= ab96033c16459de5a95e1f9e5864a5bd8cc47b4f3dee2c68ede6199dd44286ec

Use the search function in any text editor to seach and compare the hash value before install.

$ gpg --verify KeePassXC-2.6.6-x86_64.dmg.sig
gpg: assuming signed data in 'KeePassXC-2.6.6-x86_64.dmg'
gpg: Signature made Sat Jun 12 10:52:46 2021 PDT
gpg:                using RSA key C1E4CBA3AD78D3AFD894F9E0B7A66F03B59076A8
gpg: Can't check signature: No public key

$ gpg --keyserver pgp.mit.edu --recv C1E4CBA3AD78D3AFD894F9E0B7A66F03B59076A8
gpg: key CFB4C2166397D0D2: 1 duplicate signature removed
gpg: key CFB4C2166397D0D2: public key "KeePassXC Release <release@keepassxc.org>" imported
gpg: Total number processed: 1
gpg:               imported: 1

$ gpg --verify KeePassXC-2.6.6-x86_64.dmg.sig KeePassXC-2.6.6-x86_64.dmg
gpg: Signature made Sat Jun 12 10:52:46 2021 PDT
gpg:                using RSA key C1E4CBA3AD78D3AFD894F9E0B7A66F03B59076A8
gpg: Good signature from "KeePassXC Release <release@keepassxc.org>" [unknown]
gpg: WARNING: This key is not certified with a trusted signature!
gpg:          There is no indication that the signature belongs to the owner.
Primary key fingerprint: BF5A 669F 2272 CF43 24C1  FDA8 CFB4 C216 6397 D0D2
     Subkey fingerprint: C1E4 CBA3 AD78 D3AF D894  F9E0 B7A6 6F03 B590 76A8
    

Validate integrity of LibreOffice downloaded files on Mac

On this page https://www.libreoffice.org/download/download/, click info
https://download.documentfoundation.org/libreoffice/stable/7.2.1/mac/x86_64/LibreOffice_7.2.1_MacOS_x86-64.dmg.mirrorlist

Mirrors for LibreOffice_7.2.1_MacOS_x86-64.dmg
File information

Filename: LibreOffice_7.2.1_MacOS_x86-64.dmg
Path: /libreoffice/stable/7.2.1/mac/x86_64/LibreOffice_7.2.1_MacOS_x86-64.dmg
Size: 267M (279867887 bytes)
Last modified: Fri, 10 Sep 2021 09:43:36 GMT (Unix time: 1631267016)
SHA-256 Hash: b83e841360fa6ee9e42bfc1579ce9ae135972d6e7a01e79d1b975c2b855ff152
SHA-1 Hash: ad46a513f7c2047f632d8a3929a23b74aaebcc3d
MD5 Hash: 741cd9f35e133d0b2cc1944dc362cb0f
BitTorrent Information Hash: bcb717c49259229b9108c0967679dc2f53c9aba9
PGP signature available

At the terminal:
$ openssl dgst -sha256 LibreOffice_7.2.1_MacOS_x86-64.dmg
SHA256(LibreOffice_7.2.1_MacOS_x86-64.dmg)= b83e841360fa6ee9e42bfc1579ce9ae135972d6e7a01e79d1b975c2b855ff152

Search and compare the hash sum for matching before install

Monday, September 7, 2020

Validate integrity of VirtualBox downloaded files on Mac

$ openssl dgst -sha256 VirtualBox-6.1.14-140239-OSX.dmg 
SHA256(VirtualBox-6.1.14-140239-OSX.dmg)= 3abeee4822707db2f949431391dba27827840aa5390a9ec4e1bafdc5c8c3aaaa

$ openssl dgst -sha256 Oracle_VM_VirtualBox_Extension_Pack-6.1.14.vbox-extpack
SHA256(Oracle_VM_VirtualBox_Extension_Pack-6.1.14.vbox-extpack)= b224e796e886b19bce69f0aaedf6ca82bad0ca29c61fb0ed86166efb84356942

3abeee4822707db2f949431391dba27827840aa5390a9ec4e1bafdc5c8c3aaaa *VirtualBox-6.1.14-140239-OSX.dmg
b224e796e886b19bce69f0aaedf6ca82bad0ca29c61fb0ed86166efb84356942 *Oracle_VM_VirtualBox_Extension_Pack-6.1.14.vbox-extpack

Reference:

How to Install Keka on macOS

Download latest version from https://www.keka.io/en/ Copy the MD5 hash value from Keka website to compare later (MD5: 8729f9d08d10293fa1ee65...