Third Party Information Customer/Vendor Information Dolibarr – llx_societe SBT – arcust01, apvend01 Customer Invoice (make sure the invoice module is turned
Unicode choice for MYSQL database
A very good post on stackoverflow. My’s sticking with utf8mb4_general_ci for general tables (better performance) : https://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci Note: DOLIBARR uses utf8mb4_unicode_ci. Since
Dolibarr Inital Data Constants
Dolibarr loaded the following default data after installation. These data values can be referenced by other tables as foreign keys.
MYSQL Cheat Sheet
To dump all data in a database mysqldump –host=”hostname” –user=”username” –password=”password” databasename > backup_name.sql To reset auto-increment field in a
Dolibarr Module development
Module tutorial https://wiki.dolibarr.org/index.php/Module_development Dolibarr development https://wiki.dolibarr.org/index.php/Developer_documentation Using Module Builder In Dolibarr 8.0 to Generate a Test Module Change paths in htdocs/conf/conf.php
Dolibarr Notes
Open source ERP comparison chart in wikipedia. https://en.wikipedia.org/wiki/Comparison_of_accounting_software Dolibarr installation after downloading source code (not the installer!) Run http://localhost/dolibarr-8.0.0/htdocs/install/index.php Dolibarr wiki
PSQL tips on Windows
To resolve charset conflict error between utf8 and WIN1252, do the following before any further command are issued in PSQL:
Postgresql Related Notes
If you’ve installed postgresql using the installer, it typically sets the service to start automatically when Windows is started. To
PHP with Postgresql
If PHP is installed as part of XAMPP, it will work with MySQL/MariaDB with no additional change. However, to work
Use Psql to test database connection after install
Note: command case sensitive. Issued from shell at <install directory>/bin psql -d mydb -U myuser To change database: \c databasename