Posts

Ugreen FineTrack G

Image
UGreen has a lot of different tracker products. This one is a new tracker from UGreen that certified to works with FindHub Android. It only works using Bluetooth and does not have UMB (to be able to precisely pinpoint where the device). This version has non replaceable battery and has USB C to re-charge the battery. It can last theoritically for up to a year before need to top it up. I found that not many guide in the internet on how to reset this device to factory settings (if it has issue etc) but found it on the manual: Double-click the button until you hear 1 short beep Press and hold about 10s until you hear 5 short beeps followed by a "beep-beep" Release: 4 shorts beeps to indicate that it has succesfully reset. Hopefully this help someone else.

Custom Office 365 Install using Office Deployment Tool (ODT)

Image
If you’re managing multiple machines (e.g. in an org), you often don’t want to install everything that comes with Office by default. You might want: Only Word, Excel, Outlook (no Access, Publisher, etc.) A specific update channel (Monthly, Semi-Annual, etc.) Language packs or proofing tools Shared computer activation or shared licensing mode Disabling certain features or telemetry config.office.com + ODT gives you control in a reproducible way. Step 1: Create your configuration via config.office.com Microsoft provides a web UI for generating the XML configuration file that the Office Deployment Tool reads. Here’s how: Go to config.office.com and click “Create” → Deployment configuration (or similar). In the UI, you’ll see options like: Product / Suite : Choose “Microsoft 365 Apps for enterprise” (or whichever SKU you need). Installation options : Choose Version/Update channel (Current, Monthly Enterprise, Semi-Annual, etc.) Choose Architectur...

Step-by-step guide to adding emojis anywhere in Microsoft Windows - including Outlook

Image
Emojis are a fun and creative way to add personality to your emails and messages. They can help you express emotions, convey tone, and make your messages more engaging. Adding emojis to your emails and messages is easy and can be done in just a few simple steps. In this guide, we will show you how to add emojis anywhere in Microsoft Windows, including Outlook messages. Whether you’re using Windows 10 or 11 Put your cursor where you want the emoji to appear. Press the Windows key and the period key (.) simultaneously to open the Windows emoji picker. Select an emoji from the picker by clicking on it. The selected emoji will be inserted at the cursor location. Easy right?

Step-by-Step Guide to Finding the Owner of a Microsoft Form Using Inspect, Refresh, and Azure AD

Image
Microsoft Forms is a powerful citizen tool for creating surveys, quizzes, and questionnaires. While it offers great functionality for collecting responses, finding the owner of a specific form might not be immediately obvious. In this blog post, we'll walk you through the process, step by step. Step 1: Inspect the Elements Open the Microsoft Form for which you want to find the owner. Right-click on the page and select "Inspect" (or use the keyboard shortcut Ctrl+Shift+I). The browser's developer tools will open, showing the HTML and CSS code for the page. Step 2: Refresh the Form Page With the developer tools still open, press the "Refresh" button in your browser or use the keyboard shortcut F5. This step ensures that you have the latest version of the page loaded, which will be necessary for finding the owner's information. Step 3: Access the Response Page Look for a network request with a URL: "responsepagestartup.ashx" in the developer tools...

Resolving Black Screen on Screen Recording

When you do a screen recording, encountering a black screen while attempting to capture the video can be frustrating. Apparently, there is a quick solution to resolve this issue. By turning off the hardware acceleration setting in Google Chrome, you can overcome the black screen hurdle and streamline your screen recording.  Step-by-Step Guide: Accessing the Chrome Menu: Open your Google Chrome browser and locate the three vertical dots positioned at the top-right corner of the window. Click on these dots to access the Chrome menu, which will provide you with various options. Navigating to Settings: In the Chrome menu, scroll down and locate the "Settings" option. Clicking on it will open a new tab dedicated to Chrome's settings, presenting you with an array of configuration choices. Exploring Advanced Settings: To unveil additional options, scroll down to the bottom of the settings page and click on the "Advanced" link. This will expand the advanced settings sec...

How to Delete Table with Join Statement

Similar to my previous post on how to update with multiple join statements , this time, I need to delete rows in a table, but with extra criteria which made me need to join the table before deleting the rows. To do this, there are several ways, however, I found this method is the easiest: DELETE A FROM TABLE1 A LEFT JOIN TABLE2 B ON A.ROWID = B.ROWID WHERE A.first_name = 'James' AND B.last_name = 'Bond'

How to UPDATE multiple tables in Microsoft SQL using JOIN query

Sometimes the update query needs to target a complex query and therefore you will need to use this. SQL Syntax: UPDATE      t1 SET      t1.field = value    FROM      t1     [INNER | LEFT] JOIN t2 ON join_predicate    .. WHERE      where_predicate; And MySQL Syntax: UPDATE t1 [INNER | LEFT JOIN] JOIN t2 ON join_predicate SET T1.field = value WHERE condition

Sunrose USB Fingerprint Reader Driver

Image
Also known as the ELAN Smart-id Fingerprint. Steps to resolve: Download the driver  (Tested on Windows 10 and Windows 11) Extract the Zip file Run dpinst.ext. It should register everything and you should be able to now start to use your device. Alternatively Go to device management, find ELAN Fingerprint, right-click and select update driver Locate the driver inside the extracted files Let me know in the comment below if you still have any issue(s)

How to get size of each table using SQL Management Studio

Image
Sometimes your DB storage bloated so much, without knowing what caused it. Fortunately, there is an easy way to check using SQL Management Studio (SMSS). In this scenario, I am using SQL Management Studio 18. Open SQL Management Studio and connect to your DB Click View -> Object Explorer (F7) -> Databases From the list of databases, navigate to the DB you want to investigate Right-click on the header of the table list, choose Data Space Used (KB) Click on the Data Space header to sort based on the biggest to lowest data usage. Not surprising, usually the culprit is the log that does not have an auto-delete function.

Direct link to access phpMyAdmin when cPanel is not working

Image
This happened to me today. It looks like the license of my cPanel has run out and I need to access the database in urgent. Luckily the FTP access still working so I can install phpMyAdmin manually that way. However, being a lazy person, I found a quicker and less labour intensive. To open phpMyAdmin without cPanel, you will just need to open this link: http://www.yourdomain.com:2083/3rdparty/phpMyAdmin/index.php Obviously, you need to change yourdomain.com to your correct domain and if your cPanel is on a different port, you need to change the port number as well, but other than that, the link should work.

Enable PHP opcache extension on Windows XAMPP

If your XAMPP comes with PHP 5.5+ by default, opcache already included in the bundle, you will just need to enable it. To enable the extension: Open php.ini (by default it should be located here: C:\xampp\php\php.ini). Add this line at the end of the file: zend_extension = "C:\xampp\php\ext\php_opcache.dll" You will need to adjust the path if you installed XAMPP in non default location. Restart Apache server.

MySQL using Command Line on PC with XAMPP installed

Image
With XAMPP when you have to import a very big mysql table, even though you have increase the script time in php.ini but sometimes it still does not cut the mustard. I found out another way to do this by going through the command line interface. For this example, I am going to use ms-dos in Microsoft Windows, however you can do similar thing with SSH. Navigate to your MySQL folder (by default it should be C:\xampp\mysql\bin) Run mysql.exe with this command: mysql -u yourusername -p yourpassword. Once you are in MySQL interface, then type use dataBaseName . If the dataBase is not set yet, run this command: create database databaseName; After the new database created, type use databaseName; To import, type: source pathToSQLData.  In PC, it will be something like source C:\xampp\htdocs\backup.sql It should start importing your data now. Extra tip: In the command line, you can do all sort of other things that you usually type in phpmyadmin sql section, it will be just fas...

Avoid Microsoft Excel deletes leading 0 in CSV files

Image
When  you open CSV document using Microsoft Excel,  if you have a column with numeric data and leading 0, Excel will automatically delete the 0 and convert it the field type to number. To avoid Excel doing this automatically,  there are several ways. For me,  the easiest way is by importing the CSV file instead of opening it straight in Excel. To do that, follow the steps below Open a blank Microsoft Excel document. Navigate to data tab on your toolbar. Click import data from text. Find your csv file and click import. Leave the default choices - file type as delimited, start import at row 1, and file origin: MS-DOS and press Next. On the next screen, tick comma under delimiter options. You can untick or leave tab as it is. Press next. On the last screen, change the column with leading zero numeric data format as text. To do this, simply click on the column and change the column data format as Text. Click finish.It will ask where do you want to put the data...

Dragonvale dragon track winning guide

Image
To make sure you win ever time you race on dragon track, follow the guide below: * Pay attention on the track name . For example on the picture below, the track name is Rime or Reason. * Select dragon based on this guide below: Blast Furnace - Fire, metal (Forge Dragon, Brass Dragon, Sulfur Dragon) Cherry Road - Fire, plant, earth (Cotton Dragon, Sakura Dragon, Carnival Dragon, Paper Dragon) Dramoria - Cold, metal (Mine Dragon, Steel Dragon, Bearded Dragon) Electric skies - Lightning, air (Sonic Dragon, Thunder Dragon, Butterfly Dragon, Liberty Dragon) Marsh Land - Plant, water, earth (Seaweed Dragon, Swamp Dragon, Bouquet Dragon) Shimmering Fault Line - Lightning, earth (Crystal Dragon, Quake Dragon, Cotton Dragon) Rime or Reason - Air, cold (Blizzard Dragon, Snow Dragon) Ulster Meadow - Earth, plant (Moss Dragon, Tree Dragon, Forest Dragon, Clover Dragon, Cotton Dragon, Mistletoe Dragon, Paper Dragon, Sakura Dragon, Carnival Dragon, Arbor Dra...

Delete a file that was uploaded via text editor in Moodle 2

Image
Start from Moodle 2.0, it changed how it is handling the file inside the system. For security reason, the file is not saved as it is anymore (not like 1.9). It will be encrypted and stored into chunks of files. When you uploaded a file (mostly media resources like audio, video or image) via text editor, if you decided not to use the file anymore, there is no way for the administrator to delete the file using FTP and there was no way for the teacher / content manager to delete the unused file via the text editor itself. If you uploaded a big file (like video) this will become a problem when you try to backup your course because the file will be included in the backup file which will bloat the size of the course backup file. This in my experience will slow down the backup process and also you will likely get the maximum execution time error if your server has low capacity. I searched Moodle.org to find the way to solve this. One of the post that I found is this: https://moodle.org/...

How to get responsive design in Moodle 2.6 clean install

Update: Moodle 2.7 is now using  Clean  theme by default, therefore this is not applicable anymore. Moodle in their release page, mentions one of their new updated main feature is the responsive design. I am getting excited, because with this new responsive design, user experience will be enhanced as the site will be responding to the device screen resolution size. But when I tried to install into my local development by downloading their latest stable release, the resolution is not changing based on the page size! Tried to access it using my mobile, and it still showing the same non responsive design. Then I tried to look the setting, under appearance, to see whether I need to enable responsive design setting first, but no luck. I can not find this setting anywhere. And then I tried to Google it. As this is a new release, so I still unable to find anyone that has the same problem as me (Or maybe it's just me being unlucky?) After trying for some times, finally I re...

Canon 550D with 17-55mm Tamron F2.8

Image
Here are the picture that I took after the 550D LCD cracked (which means I did not see the result until after I open it in my computer. Please click on the image to see the larger version of the picture.

Fix MYOB Required Administrator Account in Server 2008

Image
If your company use MYOB as their accounting system and you work in multi user Windows Server environment, probably you have this problem where MYOB always ask for administrator account to run whereas the accountant only given access as a normal user. In this case, I use MYOB version 19 and Microsoft Windows 2008. To solve this problem, you just need to do some little tweak: Make sure that the user have access to the folder where you install MYOB, to do that, go to the installed folder, right click, properties, go to security tab and add the user Open the folder where you installed your MYOB, find myob.manifest and then right click, choose open with notepad Change requestedExecutionLevel from: Highest Available to asInvoker as shown below. Save it, and re run MYOB. It should shut the UAC up :) This also a fix for someone that use several user account under Microsoft Windows 7/Vista.

Black screen on Chrome Browser when using Google Maps

Image
It happened when I tried to enable openGL (beta) when opening Google maps in Google Chrome from my work laptop.  I was using this openGL new feature from Google since last month in Firefox and Chrome from my home laptop and they were running pretty well. But for some reason, when I tried to enable it in my work laptop, the Google Chrome just showed a dark black page. There is nothing I can do because the screen is black. Tried to reset cookies and reset all settings back to default in Chrome with no avail. Solution 1 (If you still want to use OpenGL)  I then realized this laptop like some of new laptops have a hybrid display setting (my laptop is Dell Vostro 3550 with ATI Radeon Graphic Card) . Because I use  Google Chrome pretty often, that's why I set it to use the ATI Radeon instead of power saving Intel Graphic Card. So I turned the graphic option back to Intel (power saving), restart the browser and viola.. The maps show itself well. Interesting fact that ...

How to get Sun and Rainbow dragon

Image
I can say I was lucky, I got these rare dragons with twice trial only :D I got the sun by breed Level 10 Blue Ice dragon with Level 10 Crystal dragon . The first attempt was failed, using Level 10 Blue Ice dragon with Level 9 Crystal dragon. Sun Dragon Sun Dragon Zoomed I got  the rainbow by breed Level 9 Blazing dragon with Level 10 Crystal dragon . The first attempt was failed, using level 10 Fire dragon with Level 10 Storm dragon. Rainbow Dragon Rainbow Dragon Zoomed Now only moon dragon left :D