Free SQL-Ledger User Guide

Today International SQL-Ledger Network Association releases free user guide for Ledger123. (the enhanced SQL-Ledger) This user guide has been written by Sebastian Weitmann and me over the past one and half year. A lot of discussion happened on email and skype while we planned and wrote this book. Finally we met in Cologne, Germany last […]

Visiting Zurich and Cologne

I visited Zurich (Switzerland) and Cologne (Germany) this month (Dec. 2014) to see Thomas Brandle and Sebastian Weitmann. Purpose of this visit was to discuss and plan the future development of SQL-Ledger for next few years. SQL-Ledger is a 16 years old open source software written in Perl. Now is the time to take it […]

Website upgraded

We have upgraded ledger123.com for easy of use and clarity. The simplicity on this website is intentional. Users who are new to SQL-Ledger can view the overview video on the home page to get an idea how SQL-Ledger looks like. SQL-Ledger mailing list is also being revived. It went down last year (along with our […]

SQL-Ledger Virtual Box Appliance

We have created a new sql-ledger virtual appliance using virtual box. Here are the details: Built using: Sun’s virtual box RAM: 256MB Hard disk: 10 GB Guest operating system: FreeBSD 8.2 Packages: Enhanced SQL-Ledger, Postgresql 8.4.7, Perl 5.10.1, git 1.7.3, phpPgAdmin 5.0.2, Lighttpd 1.4.28, Postfix 2.8 Root password: none Postgresql super user: pgsql, password: none […]

VirtualBox SQL-Ledger Appliance

This virtual appliance comes pre-configured with our enhanced SQL-Ledger as well as LedgerSMB. Follow these instructions to get up and running: Summary This virtual appliance has been built using FreeBSD 7.3. You do not need to know or install FreeBSD to use it. Download and uncompress this virtual appliance (url is in your order confirmation […]

Generic CSV Import

It is easy to import CSV data into sql-ledger which is not support by ‘Import’ menu. Export your data from spreadsheet or software in a suitable CSV format. Assume it is named “/tmp/cities.csv”. Create a suitable table if it does not already exist. CREATE TABLE customertmp (id INTEGER, city TEXT); Add following lines at the […]

LedgerSMB Virtual Appliance

LedgerSMB is particularly difficult to install and configure for newbies due to its dependence on few CPAN Perl modules, fixes required and creation/configuration of a central database to store users. Our sql-ledger vmware virtual appliance now comes with LedgerSMB 1.2.21. (with our enhancements.) It is fully configured with a blank dataset and one user. You […]

Vmware Virtual Appliance

This virtual appliance comes pre-configured with our enhanced SQL-Ledger. Follow these instructions to get up and running: Summary This virtual appliance has been built using FreeBSD 6.4. You do not need to know or install FreeBSD to use it. Root password: none IP Address: Login to appliance from console using root (without password) and issue […]

CSV Export

You can export data from your sql-ledger tables using following command in ‘psql’. COPY (SELECT id, partnumber, description FROM parts ORDER BY partnumber) TO ‘/tmp/parts.csv’ CSV HEADER;

Usage Guidelines

SQL-Ledger is a browser-based application. Anybody familiar with internet browsing should feel at home using sql-ledger. All Sql-Ledger user-interface elements (menu, forms, reports) are displayed using standard HTML. You can use any modern browser to run the application. Firefox is recommended. Main menu Sql-ledger menu is displayed in left frame. Menu items can be collapsed […]