odoo 13: install on Debian 10.5

Install PostgreSQL
# apt-get install postgresql

Install package wkhtmltopdf
# apt-get install wkhtmltopdf

Install package python3-xlwt
# apt-get install python3-xlwt

Install package python3-num2words
# apt-get install python3-num2words

Add odoo 13 repository and install
1. download repository key and install
# wget https://nightly.odoo.com/odoo.key
# apt-key add odoo.key
2. add odoo 13 to /etc/apt/sources.list
...
# odoo
deb http://nightly.odoo.com/13.0/nightly/deb/ ./
3. update your repository
# apt-get update
4. install odoo 13
# apt-get install odoo

My complete /etc/apt/sources.list
# security
deb http://security.debian.org/debian-security buster/updates main

# main
deb http://kartolo.sby.datautama.net.id/debian/ buster main

# non free
deb http://httpredir.debian.org/debian buster main contrib non-free

# backport
deb http://ftp.debian.org/debian buster-backports main

# odoo
deb http://nightly.odoo.com/13.0/nightly/deb/ ./

Note: nightly build will release everyday, If you don't need to update it daily, you may comment out odoo in /etc/apt/sources.list.

After finish, you can open your odoo using firefox http://localhost:8069/.

Reference:
https://www.odoo.com/documentation/13.0/setup/install.html

Dolibarr ERP 12: Configure your TakePOS for small retail

Start your company
Home -> Setup -> Company/Organization
Tab Company
    Name is mandatory
    Country is mandatory
    Sales Tax Management for small company choose "Sales tax is not used"
Tab Opening hours
    Monday - Sunday for example 7-12 13-16 means open from 7am, at 12pm, close at 16pm.

Enabling module Financial Modules (Accounting/Treasury) -> Banks & Cash
After enable, from Top Bar go to Banks | Cash
Create New financial account
    Ref.: cash0001
    Bank or cash label: Cash
    Account type: Cash Account
    Currency: Indonesia
    Status: Open
    Account country: Indonesia
    Initial balance: 5000000

Enabling module Customer Relationship Management (CRM) -> Third Parties
After enable, from Top Bar go to Third Parties.
Create Third-party (New Customer)
    Third-party name: "Unknown 3rd party"
    Prospect / Customer: "Customer"
Create Contacts/Addresses
    Last name / Label: "Unknown Customer"
    Third-party: "Unknown 3rd party"

Enabling module
    Product Management (PM) -> Prodcuts
    Product Management (PM) -> Stocks
    Multi-modules tools -> Tags/categories
After enable, from Top Bar go to Products.
New warehouse
    Ref.: local
    Short name location: local001
New product
    Ref.: Isamu_Lacquer_1_4kg
    Label: Isamu Lacquer 1/4kg
    Status (Sell): For sale
    Status (Purchase): For purchase
    Default warehouse: local
    Nature of product (material/finished):  Manufactured product
    Selling price: 25000
    Min. sell price: 23000
    Tag/categories: dempul besi (modify from Product -> Tags/Category)
and save.
List or Stocks -> choose Isamu_Lacquer_1_4kg -> tab Stock -> Correct Stock
    Warehouse: local
    Number of untis: 50
    Unit Purchase price: 21000
and save.

TakePOS
Enabling module Websites and other frontal application -> TakePOS
After enable, click icon setting.
In Parameters, Enabling Simple
Enable:
    Group VAT by rate in tickets|receipts
    Group same products lines
    Use payment icon on numpad
    Direct cash payment button
    Control cash box at opening pos
and Save.
in tab Terminal 1
    Default generic third party to use for sales: "Unknown 3rd Party"
    Default account to use to receive cash payments: Cash
and Save.

To start TakePOS, from Top Bar go to POS -> Start and Save

Membuat Presensi/Absensi sekolah secara sederhana

 Login ke google melalui browser.

Siapkan google drive untuk menyimpan presensi:

1. buka https://drive.google.com/drive/my-drive
2. pilih "New" -> "Folder"
3. masukan nama folder misalnya "presensi" -> "CREATE"

Membuat google form untuk presensi:

1. dari google drive, buka folder yang baru yang dibuat (folder presensi)
2. klik "New" -> "More" -> "Google Forms" -> "Blank form"
3. ganti judul "Untitle form" menjadi "Presensi/Absensi"
4. ganti "Untitle Questions" menjadi "kelas"
5. rubah "Multiple Choice" menjadi "Dropdown"
6. aktifkan "Required"
7. tambahkan question melalui icon "+" -> "Add question"
8. isi question dengan "tanggal"
9. rubah "Multiple choice" dengan "Date"
10. aktifkan "Required"
11. tambahkan question melalui icon "+" -> "Add question"
12. isi question dengan "nama"
13. rubah "Multiple choice" dengan "Short Answer"
14. aktifkan "Required"

(Opsional) Konfigurasi form presensi/absensi:

1. 1. klik tombol settings (disamping tombol "Send")
2. 2. Collect email address
3. 3. Bila presensi/absensi akan dibuat per pertemuan dan siswa hanya bisa absen 1 kali, aktifkan opsi "Limit to 1 response"

Google form anda telah siap dan tersimpan di google driver folder "presensi" dengan nama "Presensi/Absensi" 

Untuk mengirimkan google form tersebut, buka google form presensi yang telah dibuat, lalu klik "Send" dan pilih link. Copy link yang akan dishare ke group whatsapp atau peserta lainnya.

Folder presensi tersebut dapat dishare ke guru/admin sekolah untuk dicopy (dibutuhkan akun google dari guru/admin).

Dolibarr ERP: 12.0.2 on Debian 10.5

Download stable version dolibarr-12.0.2.tgz from Source Forge -> Dolibarr ERP-CRM https://sourceforge.net/projects/dolibarr/files/. Extract dolibarr-12.0.2.tgz and move folder htdocs to your web root or subfolder.
 
Create user and mariadb database for Dolibar.

Move to your dolibarr web root. Copy configuration example conf folder and make it writeable during installation.
$ cp conf/conf.php.example conf/conf.php
$ chmod o+w conf/conf.php

Create directory documents and make it writeable.
$ mkdir documents
$ chmod o+w documents/


Install Dolibarr using your browser http://localhost/tes/dolibarr/
Ok PHP Version 7.3.19-1~deb10u1 (More information)
Ok This PHP supports variables POST and GET.
Ok This PHP supports sessions.
Ok This PHP supports GD graphical functions.
Ok This PHP supports Curl.
Ok This PHP supports calendars extensions.
Ok This PHP supports UTF8 functions.
Ok This PHP supports Intl functions.
Ok This PHP supports ZIP functions.
Ok Your PHP max session memory is set to 128M. This should be enough.
Ok Configuration file htdocs/conf/conf.php exists.
Ok Configuration file htdocs/conf/conf.php is writable.

Fill database login and password
Configuration file
Saving parameters to ../conf/conf.php    Ok
Reloading parameters from configuration file.    Ok
Server connection (User dolibarr) : localhost    Ok
Database connection (User dolibarr) : dolibarr    Ok

Your Dolibarr ready to install, wait until installation finish.

Last installation, create user admin and password.
olibarr admin login
Last step: Define here the login and password you wish to use to connect to Dolibarr. Do not lose this as it is the master account to administer all other/additional user accounts.

Dolibarr administrator login 'admin' created successfully.
This installation is complete.
Warning, for security reasons, once the install or upgrade is complete, you should add a file called install.lock into the Dolibarr document directory in order to prevent the accidental/malicious use of the install tools again.

You need to configure Dolibarr to suit your needs (appearance, features, ...).

Add file install.lock
$ touch install.lock

Conguratulation! Your Dolibar 12.0.2 is ready to configure to meet your company requirement and use.

Test on Debian 10.5 Kernel Version 4.19.0-10-amd64

Windows 10 sharing printer on private network only

 

1. Enabling Windows sharing "Manage advanced sharing setings"
   1. Private
      1. Turn on network discovery & Turn on automativ setup of network connected device
      2. Turn on file and printer sharing
   2. Guest or Public
      1. Turn off network discovery
      2. Turn off file and printer sharing
   3. All networks
      1. Turn off Public folder sharing (people logged on to this computer can still access these folders)
      2. Use 128-bit encryption to help protect file sharing connectin (recommended)
      3. Turn off password protected sharing
2. Enabling guest user, open cmd with "Run as administrator" permission
       >net user guest /active:yes
3. Share printer, "Printers & Scanners", choose printer to share, "Manage" -> "Printer properties"
   1.     Sharing
      1.         Share this printer (optional: you can change share name)
      2.         Render print-jobs on client computer
   2.     Security
      1.         Everyone: Print, Manage this printer, Manage documents
      2.         Guest: Print, Manage this printer, Manage documents (add group or user name)

 

Warning: only use on private network!!!

Caution: use with your own security risk on non private network!!!

Note:

• Some Windows 10 update, version 1903 or later, may have some problem with your printer driver and printer sharing. You need to find solution on microsoft site if reinstall and reconnect your printer does not solved your problem.
• You can not share printer if the printer is offline