Event management software related

List of Open Source Conference Management Systems
Conference Management systems are web applications designed to make the lives of conference organisers easier. They usually include features such as registration, payment, paper submission and review, scheduling and publishing of announcements.

App to log vehicle maintenance

15 Best Free Car maintenance apps for Android to help you on your way

Car Report

AUTOSist
Sayangnya, aplikasi AUTOsist hanya bisa dipakai untuk memonitor satu kendaraan saja. Jika kamu memiliki lebih dari satu kendaraan, kamu harus membayar biaya mulai dari US$9,99

Kodi related

Nonton pakai add-on legal

VPN diperlukan utk atasi geo-restriction

Nonton pakai add-on ILlegal

Bisa nebak kan knapa butuh vpn

Karena add-on ILlegal kurang reliable, butuh layanan "abu-abu" yg berbayar spt Real Debrid

Dari reddit :

the crew, scrubs v2, work without RD. they will work, but got to take the good with bad, good one day, play nothing next day. (which just leads to you getting pissed off)

If you goal is to watch movies and TV shows without scrounging for workable links you will want to invest in real debrid.

If you don't care that links will sometimes not work or that you get SD quality then the free addons others recommend for you should be fine.

How To Fix The Video.Me Stream Authorization

Kodi Krypton Tutorial

Memaksimalkan Kodi (playlist untuk siaran TV lokal *tidak lengkap*)
Jika SuperRepo gagal, playlist loader juga bisa diinstall dengan ikuti petunjuk ini:
Playlist Loader Addon Guide

OpenSubtitles ask for username and password :
OpenSubtitles KODI (XBMC) Add-on – Login fix
read "Install new OpenSubtitles KODI add-on from OpenSubtitles.org" section

Agar bisa add subtitle :
Menikmati fitur Smart TV tanpa Smart TV

Agar bisa add subtitle selain English :
How To Add Subtitles To Kodi
Step 8:  Return to home screen of Kodi and click Gear icon toward top of page to enter settings.  Click Player Settings icon.
Step 9:  Within player settings, change the download language for subtitles if you need different language.  You must enable advanced settings toggle at bottom of settings menu within this area.

Remote controlling Kodi on Windows from Android phone :
How to set up a Windows 10 Kodi Remote Control

How to Stop Kodi Buffering

How to Watch Documentaries on Kodi

How to Install the Ares Wizard on Kodi 
related: installer

How to install Kodi Steam addon on your HTPC

Determine which application uses specific keyboard shortcut or hotkey

Find out what program is using a hotkey (2015-11-11)

Sorry I can't suggest an alternative to Hotkey Explorer for Windows 8 or 10. It's a godsend on Windows 7.

I can only offer you the most primitive way of handling this problem. First, close all your running programs (including stuff in the system tray), one by one. Make notice of what you close and every time (or every once in a while) test if your program (is it Greenshot?) can now use that hotkey.

How can I determine which process owns a hotkey in Windows?
Hot Key Explorer (but NOT for Windows 8 or later)

Related
---------
Disable Ctrl+Alt+F1 for Intel Graphics application :
I kill the igfxHK.exe process with Task Manager
source: Cannot catch Ctrl+Alt+F1 in WinForms MDI. Is it special?

Data collection / survey software related

LimeSurvey
+ local install
+ free
+ support "other option - specify"
* android app OfflineSurveys can only be used with Previous button DISABLED

* How to Remove "No Answer (survey's Presentation & Navigation setting)
* Allow multiple responses for one token AND EDIT ANY OF THOSE RESPONSES ?
...NO SOLUTION so far (Can Token-based Participants modify their specific submitted suvey?)

SurveyMonkey
Response Editing Options: Multiple Responses - Off :
If you allow one response per computer, you can allow editing even after the survey is submitted
Response Editing Options: Multiple Responses - On :
If you allow multiple responses per computer, you can allow editing during the survey, but not after the survey is submitted

GoogleForms
- NO SUPPORT for multiple checkboxes/radiobuttons with comment

OpenDataKit
+ local install
+ free
? support "other option - specify"

KoBoToolbox
Support for installing with Docker on Mac and Windows is only experimental at this point. For Mac and Windows users please consider installing the old Virtualbox-Vagrant option
+ local install
+ free
? support "other option - specify"

Simple way (but requires computer, mobile won't do)
Get Data from Microsoft Word Forms into Excel Using VBA

Hunt for Recipe Management software

Requirements:
R1: Auto complete when entering ingredients
R2: Ingredient names auto complete when typing Procedure/Instruction

Living Cookbook 2015
- R1: Incorrect ingredients shown
- R2: not supported

KRecipes
+ A VERY COOL part of entering the recipe instructions is the Auto Completion feature! This is a real-time and effort saver if your instructions refer to many of the ingredients in your ingredient list, and/or if your ingredient names are lengthy. This is how it works —
In the “Apple Crisp” recipe shown in the screenshot, we have the ingredient “brown sugar”. As you begin typing “brown sugar” in your recipe instructions, Krecipes will match typed characters with ingredients in your recipe ingredient list and automatically complete the remaining characters.
- for Linux

Install MacOS on Windows/VM

Tested and worked on Windows 8.1 Pro with VMware Player 7.1:
Run Mac OS X on PC, Free and Easy with VMware Player 3
* Install VMware Tools 7.1.1 from VMware tools download: install success but mouse still laggy and can't full screen

Comparison between VMware Workstation, Player, Fusion vs Hyper-V and Hackintosh

How to install OS X Mountain Lion on your PC with iAtkos

Download Distro Macosx dan Iatkos

Related
--------
Disable the New Window Animation in Mac OS X

Disk clone related

MBR VS GPT (Focus on Difference and How to Convert Safely)
In conclusion, in our opinion, GPT is better.
MiniTool Partition Wizard Free Edition [can] convert the disk style between MBR and GPT.

How to Clone MBR Disk to GPT Disk/SSD
your old hard drive is an MBR partitioned boot disk and your new HDD or SSD is GPT partitioned disk, in this case, you will be required to clone MBR disk to GPT disk or SSD. It is a little bit difficult to manage the job as a bootable issue will happen in high chances if you simply clone MBR HDD to HDD or SSD with GPT partition table. Do remember to convert the GPT to MBR first and start the cloning process.

HDD Raw Copy Tool
Examples of possible uses:
Data recovery: make a copy of the damaged drive to attempt recovery on the copy
Data recovery: copy a damaged hard drive and skip bad sectors
Migration: completely migrate from one hard drive to another
Ultimate backup: Make an exact copy of the hard drive for future use
Backup: create an image of a USB flash stick and copy/restore at any moment
Software QA engineers: restore your OS hard drives at any moment from a compressed image
Duplicate/Clone/Save full image of any type of media!

ORICO: Two same capacity drives, but can not start Clone (see FAQ)

If two driver are some capacity but different brands, the clone may can not start to process.
Different manufacturer may use different capacity caculation method,  so maybe they actually not equal with each other.

Related
---------
SSD partitioning- is reserve space necessary
Bottom line, you should be able to go for a partition size that uses all "available" space presented to your system.

SSD: keep unallocated space? (2017)

most SSDs are overprovisioned internally. Your 256GB SSD likely has something like 256+16GB of actual space in it. The SSD controller hides this from the OS, but it will internally use that extra room when needed.

Bad Sector Repair in Windows 10 (3 Ways Included)
Self experience: chkdsk gives more comprehensive result than GUI tool

4 Portable Tools to Make a Full Image Backup of USB Drives
Q: Can we mount resulted image file ?
A:

FOG is a Linux-based, free and open source computer imaging solution for various versions of Windows (XP, Vista, 7, 8/8.1, 10), Linux and Mac OS X. It ties together a few open source tools with a PHP-based web interface. FOG doesn't use any boot disks, or CDs; everything is done via TFTP and PXE. Your PCs boot via PXE and automatically downloads a small linux client doing all the hard work of imaging your machine

Windows Essentials related

Movie Maker, Live Mail etc

Download Offline/Standalone Installer Windows Essentials 2012

Monitor printer usage

CZ Print Job Tracker 9.0
- paid

Print Censor
- paid

Related
--------
Print Audit Secure

Print to 2 printer by default [set PDF creator as 2nd printer for review purpose]

Java development

ERROR NetBeans : diamond operator is not supported in -source 1.5 (use -source 7 or higher to enable diamond operator)

Using the equals() method with String and Object in Java
equals() for String compares the content, not the object itself.

10 Examples of using ArrayList in Java - Tutorial
ArrayList represents an automatic re-sizeable array and used in place of array. Since we can not modify size of an array after creating it, we prefer to use ArrayList in Java which re-size itself automatically once it gets full

How to loop ArrayList in Java - List Itrator Traversal Code Example

Which Java (32 or 64 bit) should be selected when installing Netbeans?
NetBeans 64bit Edition
the download for 64 and 32 bit versions of the IDE is the same, the difference lies in which Java Runtime Environment the install is pointed to. You have to point it to the 64 bit JRE to have it work in 64 bit

from Eclipse message saying List cannot be resolved to a type
You can press SHIFT+CTRL+O for auto importing [packages containing classes needed]
---

from Eclipse IDE - Tutorial
Java can be downloaded in two flavors: a JRE (Java Runtime Environment) and a JDK (Java Development Kit) version.
The Eclipse IDE contains its own Java compiler hence a JRE is sufficient for most tasks with Eclipse.
The JDK version of Java is required if you compile Java source code on the command line and for advanced development scenarios, for example, if you use automatic builds or if you develop Java web applications.

You can define in Eclipse that a project is dependent on another project. To do this select your project, right-click on it and select Properties.
Select Java Build Path and the Projects tab.
If you add a project to the build path of another project, you can use its classes in Eclipse

Manual installation of plug-ins (dropins folder):
You should not modify the content of the Eclipse plugins directory directly. If you want to install plug-ins, put them into the dropins folder. If you want to remove it, delete the JAR from this folder

---

Office 365 related

How to export all outlook contacts from 365 to file?
Do you mean OWA(Outlook Web Access) by saying Microsoft Office 365 Outlook? If I am correct, OWA doesn’t support export contacts into an individual file.

Set up email in Outlook 2010 or Outlook 2013 for Office 365 or Exchange-based accounts

From Office 365 Outlook OWA I can see some Contacts. Will it be visible from desktop client as well ?
Probably NO
Use POP or IMAP to connect to Office 365 for business or Microsoft Exchange accounts says:
Connecting to your Office 365 for business or other Microsoft Exchange email account using POP3 or IMAP4 only lets you send and receive email. You can’t connect to your contacts, tasks, or calendar when you connect to your account using POP3 or IMAP4.
BUT from personal experience, by setting desktop Outlook 2013 as described by ChrisChin_qc on Exporting Office 365 Contacts to either a CSV file or Outlook desk copy (only type your e-mail and password, no need to specify POP/IMAP) you can see e-mails AND Contacts from your 365 account so then you can export them
IF that FAILS and your 365 subscription comes with Office click-to-run(?) software, you can try Install Office using Office 365 for business

Software untuk anak-anak

Aplikasi Edukasi Anak SD-SMA Belajar Pemrograman Gratis

Forum Microsoft lokal

Pusat Komunitas IT Lokal Indonesia

Postgres related

Forgotten PostgreSQL Windows password

[database vs] schema

Log changes made by users:
Audit trigger 91plus
Note to self:
From experience with idempiere database on Postgres 9.4, the code need to be changed:
from "quote_ident(target_table::text)" to "target_table"
Related to that matter:
Define table and column names as arguments in a plpgsql function?
SQL injection in Postgres functions vs prepared queries
Unexpected behavior of dynamic SQL using regclass

Function to activate audit trigger on several tables at one (related to Audit trigger 91plus):
--- code start ---
CREATE OR REPLACE FUNCTION audit.mass_on(
    _schema_ character varying,
    _table_regexp_ character varying)
  RETURNS SETOF character varying AS
$BODY$
DECLARE
    result  VARCHAR := '';
BEGIN
    FOR result IN SELECT table_name FROM information_schema.tables
        WHERE table_schema = $1 AND table_name ~* $2 and table_type = 'BASE TABLE' ORDER BY table_name
    LOOP
perform audit.audit_table($1 || '.' || result);
        RETURN NEXT result;
    END LOOP;
    RETURN;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100
  ROWS 1000;
ALTER FUNCTION audit.mass_on(character varying, character varying)
  OWNER TO postgres;

--- code finish ---

Sample usage:

select audit.mass_on('adempiere','_');

Function to de-activate audit trigger on several tables at one (related to Audit trigger 91plus):
--- code start ---
CREATE OR REPLACE FUNCTION audit.mass_off(
    _schema_ character varying,
    _table_regexp_ character varying)
  RETURNS SETOF character varying AS
$BODY$
DECLARE
    result  VARCHAR := '';
BEGIN
    FOR result IN SELECT table_name FROM information_schema.tables
        WHERE table_schema = $1 AND table_name ~* $2 and table_type = 'BASE TABLE' ORDER BY table_name
    LOOP
EXECUTE 'DROP TRIGGER IF EXISTS audit_trigger_row ON ' || $1 || '.' || result;
EXECUTE 'DROP TRIGGER IF EXISTS audit_trigger_stm ON ' || $1 || '.' || result;
        RETURN NEXT result;
    END LOOP;
    RETURN;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100
  ROWS 1000;
ALTER FUNCTION audit.mass_off(character varying, character varying)
  OWNER TO postgres;

--- code finish ---

Sample usage:

select audit.mass_off('adempiere','pa_');

Function to search schema for specified table name (partial name supported, related to Audit trigger 91plus):
--- code start ---
CREATE OR REPLACE FUNCTION audit.list_tables(
    _schema_ character varying,
    _table_regexp_ character varying)
  RETURNS SETOF character varying AS
$BODY$
DECLARE
    result  VARCHAR := '';
BEGIN
    FOR result IN SELECT table_name FROM information_schema.tables
        WHERE table_schema = $1 AND table_name ~* $2 ORDER BY table_name
    LOOP
        RETURN NEXT result;
    END LOOP;
    RETURN;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100
  ROWS 1000;
ALTER FUNCTION audit.list_tables(character varying, character varying)
  OWNER TO postgres;

--- code finsh ---

Sample usage:

select audit.list_tables('adempiere','ad_');

Debug PostgreSQL function using pgAdmin
picture

Re-add database from files on disk:
Recover postgreSQL databases from raw physical files

Physical location of database files:
Where does PostgreSQL store the database?

Database backup using SQL Dump
An important advantage of pg_dump over the other backup methods described later is that pg_dump's output can generally be re-loaded into newer versions of PostgreSQL, whereas file-level backups and continuous archiving are both extremely server-version-specific. pg_dump is also the only method that will work when transferring a database to a different machine architecture, such as going from a 32-bit to a 64-bit server

How do I specify a password to psql non-interactively?
Set the PGPASSWORD environment variable ... before calling psql

Eclipse related

Use existing workspace with newer version of Eclipse?
In theory, new versions of Eclipse should update your workspace and project files just fine. In practice, they can become corrupted. My new rule is to create a new workspace for every major version upgrade of Eclipse (maybe more often if you’re cautious). Then I copy those projects and import the copy. This ensures I have a backup plan should something go awry. You may need to reimport your project(s) if there’s a problem that won’t go away after an upgrade.
(from ECLIPSE “CANNOT BE RESOLVED TO A TYPE” ERROR)

How to find out if an installed Eclipse is 32 or 64 bit version?

Hit Ctrl+Alt+Del to open the Windows Task manager and switch to the processes tab, OR
Open eclipse.ini in the installation directory, and observe the 4th line

32-bit programs should be marked with *32

Running 32 bit applicayion on 64 bit Eclipse
Using a 32-bit JRE with a 64-bit eclipse:
Just include the 32bit JRE as an additional Java runtime in the configuration and use it for your project.
How?
...

Obtain individual .DLL file from DirectX installer

How To Restore a Missing DirectX DLL File

Java (JRE) related

Q: Firefox/Mozilla keep saying that Java is out of date although you've followed download link
A:
The Firefox link send you to the wrong Java version (outdated) and you have to find the correct Oracle webpage that now has Java version 8 (actually v.1.8.0 plug in 11.0.2.132) and download and install THAT.

You can find the latest Java version on the Oracle website.
See Java Platform \ Java SE 8 (JRE 8 Download)
also: version 7
---

Q: On 64bit Windows, which Java to download? 32bit or 64bit?
A:
Note that because some web content may not work properly in a 64-bit browser, we recommend using the default 32-bit browser and downloading 32-bit Java.
source: Which Java download should I choose for my 64-bit Windows operating system?

MySQL related

Backup then restore to another db
How to Import and Export a MySQL database using HeidiSQL
- using version 9 of portable app, "Load SQL file" is located under File menu

How to Reset the Root Password

Moving an InnoDB Database to Another Machine
You can move an InnoDB database simply by copying all the relevant files listed in Section 14.2.6, “Backing Up and Recovering an InnoDB Database”

What is the exact location of Mysql database tables in XAMPP folder?
I think the matter is your tables engine. I guess you are using InnoDB for your table. So you can not copy files easily to make a copy.
Take a look at these links:
...

Attaching an existing database with MySQL
simply copy the folder into the data folder for MySQL and restart the service the database will show up

TOAD: Error "Physical Memory is low (Paging)" when exporting [to Excel file]
Use Tools \ Export \ Export Wizard instead
On "Select Output Format" step, UNCHECK "Check system resources" option

Visually build query (table drag-and-drop): Toad for MySQL
Note to self:
For query containing datetime column, use "Export data to an Excel file"
"Export data to an Excel instance" seems buggy (datetime column exported as mysterious big number)

How to remove 1000-row limit in MySQL Workbench queries?

To enable access from remote computer
MySQL Workbench \ Management \ Users and Privilages \ Add Account
...note: "Limit Connectivity to Hosts Matching" can accept hostname

How install and configure mysql 5.6.16 in windows 7

Connect [Excel 2010] to a MySQL database
Download Microsoft Power Query for Excel
On Excel:
Power Query \ From Database \ From MySQL Database \ type at least servername ("localhost" will do) and  one of the schema exists then click OK

Things to configure on fresh Windows installation

Change Computer Name
Add standard user
System Properties \ Advanced \ Performance Settings: Adjust for best performance
System Properties \ System Protection
gpedit.msc to configure Windows Update (if not join domain)

Softwares to install
-----------------------
PassDlg
Drivers
Note regarding Intel and NVidia:
...

Archiver (7zip)
Teamviewer
...How to hide the notifications of the Teamviewer (silent use)
FoxIt Reader
Realpopup
Antivirus (No need if there's Windows Defender already?)
Office
Firefox/Chrome
Download Manager

Printer

ffmpeg
freeSSHd