Tuesday, December 6, 2022

How to Verify the Integrity of the Downloaded Keka the macOS file archiver

Go to https://www.keka.io/en/

Download v1.2.58
36.4 MB | Requires Mac OS X 10.10 or newer
Changelog | Legacy | Helper | iOS
MD5: 316c2614330f6a9bf8776eb312c6d54f

$ openssl dgst -md5 Keka-1.2.58.dmg
MD5(Keka-1.2.58.dmg)= 316c2614330f6a9bf8776eb312c6d54f

Is the hash match?

Source code https://github.com/aonez/Keka

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
    

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...