RadonWiki - New pages [en-gb]

Ticktock:AndroidApp

2022-12-27T02:24:46Z

Matt.carter:

The '''Ticktock Timeclock''' is available to download from Google Play
[https://play.google.com/store/apps/details?id=nz.ticktock.clock]
But requires the old Menu button to configure, and this Menu button is no longer available in the latest version of Andriod

There is an app called '''Menu Button''' [https://play.google.com/store/apps/details?id=jettoast.menubutton]
That can be used to enable the menu button to configure '''Ticktock Timeclock''' and then can be turned off

But '''Menu Button''' requires the '''Overlay''' feature and this is disabled in '''Adroid Go''' (which is used on some lower end tablets)

The '''Overlay''' feature can however be enabled for '''Menu Button''' by using '''ADB''' (Android SDK Tools installed on a computer)

Steps to enable '''Menu Button''' App
# Install '''Menu Button''' App
# Turn on '''Developer Options''' on device by going to '''Settings''', then '''About tablet''', then tap on '''Build number''' 7 timese
# Connect Tablet to Computer via USB cable
# Enable USB Debugging under Developer Options
# Run the ADB command below from the computer
# Start '''Menu Button''' App and ensure working
# Can then turn off '''Developer Options'''
Location: C:\Users\mattc\AppData\Local\Android\Sdk\platform-tools
<source lang="sh">
adb shell pm grant jettoast.menubutton android.permission.SYSTEM_ALERT_WINDOW
</source>

Steps to configure '''Ticktock Timeclock''' App
# Install '''Ticktock Timeclock''' App
# Start '''Menu Button''' App (to display Menu button overlay)
# Start '''Ticktock Timeclock''' App and configure settings
# Can then Stop ''Menu Button''' App

[[Category:Ticktock]]
[[Category:RestrictedContent]]

Desktop:X1 Nano

2022-01-09T02:59:12Z

Matt.carter:

Windows 11 New Computer Setup December 2021/January 2022

Fresh Installs
Chrome - Version 96.0.4664.110 (Official Build) (64-bit)
KeePass 2.49
Eset NOD32 Antivirus 15.0.21.0
Microsoft 365 Apps for business (Word, Excel, Outlook etc. - installed via MCAS)
Google Workspace Sync for Microsoft Outlook (4.3.49.0)
Greenshot (Greenshot-RELEASE-1.2.10.6)
Notepad++ 64-bit 8.2
PuTTY - 64 Bit version 0.76
GIT - 2.34.1 (Accepted all defaults)
Wampserver32 3.5.3 (Use tool https://wampserver.aviatechno.net/files/tools/check_vcredist.exe to check pre-requisites)
MySQL Workbench 8.0.27 (Installed Client Tools Only, as WAMP Server installs MariaDB Server)

Restore Files
Map Network Drives to NAS (M:=\\radonnas\Multimedia, H:=\\radonnas\homes\Matt) - User:Admin
KeePass Database and Key (MCARTER.bkdx MCARTER.key)

Restore MYOB EXO Employee Services
Copy to directory C:\CLIENTS\_COMACC
Run File '''network'''
Setup - Special Options - Import - File Location C:\CLIENTS\_COMACC\
Setup - Backup Path - C:\CLIENTS\_BACKUP\MYOB_PAYROLL\

Install Quickbooks 2008/09 SP3

Apply Registry Fix - regfix_QB_Win10.reg
Restart Computer

Mount Image QB0809_SP3.iso
Run autorun.exe
...License Key: 85301-26735-37644-220162
...Install Quickbooks with the Company File Server
...Installs .NET 1.1

Run QuickBooks
...Select General Business
...Open an Existing Company File
...Activate Customer ID: 1247912

Can no longer activate license (as this version has been retired), but created script QB_Hack.ps1 to reset access
<source lang='powershell'>
#Changes qbmode to the value as per installation, so can access QB 6 more times before activation
$file = Get-Content C:\Users\Public\Documents\Intuit\qbw.ini
($file).Replace($file.Get(1),'Qbmode=000063c07b28') | Out-File C:\Users\Public\Documents\Intuit\qbw.ini
</source>

== Configure DEV Environment (GIT/WAMP/MariaDB/NetBeans) ==
Configure GIT
SSH Public/Private Key added to GIT Server
ssh-keygen –t rsa –C "matt.carter@radon.nz"
Accept default name, and enter your own pass phrase
This creates two files in folder ~/.ssh/
id_rsa (private Key)
id_rsa.pub (public key)
id_rsa.pub copied to the gitolite-admin respository on the server as keydir/<username>.pub
But copied files (id_rsa and id_rsa.pub) from old computer (to retain existing credentials)

Create file ~/.ssh/config with the following
Host git.radon.nz
Hostname git.radon.nz
Port 22
User gitolite3
UserKnownHostsFile ~/.ssh/known_hosts

Clone Ticktock Repository
mkdir /c/GIT
cd /c/GIT
git clone git.radon.nz:ticktock

Configure WAMP
Edit '''hosts''' file (C:\Windows\System32\drivers\etc\hosts) and add line "127.0.0.1 ticktock"
Run WAMP and change PHP to version 5.6
Edit '''httpd-vhosts.conf''' file (within wampserver) and add the following Virtual Hosts
<source lang='apacheconf'>
<VirtualHost ticktock:80>
ServerName ticktock
ServerAlias ticktock
DocumentRoot "C:/GIT/ticktock/app/webroot"
<Directory "C:/GIT/ticktock/app/webroot">
Options +Indexes +Includes +FollowSymLinks +MultiViews
AllowOverride All
Require local
</Directory>
</VirtualHost>
</source>

Configure MariaDB
Add MariaDB Bin path to PATH environmental (i.e. C:\wamp\bin\mariadb\mariadb10.4.13\bin\)
Create database users for ticktock
<source lang='mysql'>
mysql -uroot
create user 'ticktock'@'localhost' identified by 'ticktock';
create user 'ticktock_dev'@'localhost' identified by 'ticktock_dev';
create user 'ticktock_demo'@'localhost' identified by 'ticktock_demo';
grant all privileges on ticktock.* to 'ticktock'@'localhost';
grant all privileges on ticktock_dev.* to 'ticktock_dev'@'localhost';
grant all privileges on ticktock_demo.* to 'ticktock_demo'@'localhost';
grant select on ticktock.* to 'ticktock_dev'@'localhost';
grant select on ticktock.* to 'ticktock_demo'@'localhost';
</source>

Configure Ticktock and Test
Edit '''hosts''' file (C:\Windows\System32\drivers\etc\hosts) and add line "127.0.0.1 ticktock"
Create/Edit and run '''~\_db\replication\replicate.bat''' (note need to run bin\plink.exe manually once to accept new remote host)
Create/Edit '''~\app\Config\database.php''' (Note: WAMP MariaDB rund on port 3307)
Test http://ticktock/ and ensure working

Configure NetBeans
Clone GIT Respository, and then open Ticktock Project
Configure Browser to Chrome
Configure Project URL (http://ticktock)
Configure PHP Debugging (XDebug)
Chrome - Enable Debug Extension
WAMP - PHP.INI - Configure XDebug Extension
NetBeans - ensure Web Root set in Project Properties to '''app/webroot'''

[[File:Netbeans_GIT.png]]

[[Category:Desktop]]

Desktop:GooglePhotos

2020-11-21T07:56:54Z

Matt.carter:

Google Backup and Sync doesn't upload photos that already exist and keeps displaying these as "Skipped Items"
The message is "these photos and videos are already in google photos"

The reprocess these, found and article on how to change the database setting to change "copy_duplicate_photos"

first you need to go get DB Browser for SQLite. SQLite is the database the photos client uses. After getting that tool you can use it to open the settings database. Generally the database can be found here C:\Users\YourUserNameHere\AppData\Local\Google\Drive\user_default\sync_config.db though your system may vary. Use the browse data tab to view the data contained in the data table. Finally, scroll down until you find the setting copy_duplicate_photos. You can edit its value from a 0 to a 1. Restart the backup and sync client and away it goes. Just to be clear, there may be ramifications that are unknown from doing that. I set the option back to 0 once my files were synced

[[File:GooglePhotos_CopyDuplicatePhotos.png]]

[[Category:Desktop]]