Latest version
Download the latest release [ Version 3.2.0 ]

Installation instruction are in the README file.

To see what changed click here.

Older versions may be downloaded by specifying the filename. i.e http://www.sql-ledger.com/source/sql-ledger-2.6.27.tar.gz

the last minor versions for prior versions are 3.0.8, 2,8.37, 2.6.27, 2.4.16, 2.2.7

Installation of older versions is just as simple as with the newer ones. Download the tar.gz file and pass the filename to setup.pl and follow the prompts.

setup.pl
setup and download script for SQL-Ledger.
Save setup.pl in a directory where you want to install SQL-Ledger (i.e. /usr/local/sql-ledger, /opt/sql-ledger) and run from the command line (perl setup.pl) as root or as ordinary user who belongs to the same group as your web server. This utility will download the latest code, check your system, set the proper permissions, create configuration files and reload your webserver.

The script was written a long time ago and things change. If for some reason things don't work as expected download the tarball and pass it to setup.pl on the command line. You can also do a manual install, simply follow the steps in the README file.

Other platforms
MAC OS X:

installation instructions


WINDOWS

installation instructions

Upgrading from any version > 1.2.7 to the latest version
Upgrading is easy. Load setup.pl from the sql-ledger root directory and select Upgrade. The script will lock out everyone and install the new code over top. The only thing left to do is to log in to upgrade a dataset.

To upgrade manually load admin.pl and Lock the system. Download the new code and untar over top and fix the permissions according to the UPGRADE file in the doc directory. Most of the time there is nothing else to be done. Load admin.pl and Unlock the system. When a user logs in the Dataset is upgraded automatically, you do not have to do anything. If other steps are required, i.e template modifications, they will be listed in the UPGRADE file.
You DO NOT have to install intermediate versions to upgrade to the latest version! Intermediate upgrades are done for you.

Packaging
Packaging information to build a package for various platforms.
Language Support
The following languages are supported.

Percentage indicates how much is translated. If you would like to translate the remainder or improve on it feel free to send us an update.

Language Translation Translators (past and present)
English
British English
Canadian English
100% -
Arabic (Egypt UTF8) 62% Omar BaheyEldin
Rania Tayel
Bahasa Indonesia 55% Akhmad Daniel Sembiring
Brazilian Portuguese 88% Andre Felipe Machado
Miguel Koren O'Brien de Lacy
Marco A B Souza
Bulgarian 88% Rosen Vladimirov
Catalan 40% Jaume Teixi
Czech 41% Tomas Fencl
Danish 100% Jonas Smedegaard
Keld Jřrn Simonsen
Dutch 100% AJ Hettema
Oscar Buijten
Bert Tijhuis
Paul Tammes
Arno Peters
Dutch (Belgium) 71% -
Estonian
UTF8
89% Martin Lillepuu
Lauri Jesmin
Tanel Kurvits
Peeter Pärtel
Andrei Kolu
Finnish
UTF8
72% Petri Leppänen
Jukka Aho
Paul Saris
French 90% Sčbastien Brassard
Oscar Buijten
Wolfgang Sourdeau
Aguibou KONE
Jens-Ingo Brodesser
Mathieu Chappuis
Daniel Adron
French (Belgium) 88% Sčbastien Brassard
Oscar Buijten
Wolfgang Sourdeau
Aguibou KONE
Jens-Ingo Brodesser
Mathieu Chappuis
Olivier Cornet
French (Canada) 76% Mathieu Chappuis
Olivier Cornet
German
UTF8
87% Thomas Bayen
Gunter Ohrner
Jens Koerner
Doris Messmer
Wolfgang Foerster
Michael Strecker
Swiss German
UTF8
100% Alain Haymoz
Fabian Schiltknecht
Martin Elmer
Greek 42% Dimitris Andavoglou
Hungarian 89% Kabai József
Icelandic 55% Margeir Reynisson
Italian 54% Paolo Bizzarri
Luca Venturini
Alessandro Pasotti
Daniele Giacomini
Latvian 71% Kaspars Melkis
Lithuanian 55% -
Norwegian Bokmĺl 75% Keld Jřrn Simonsen
Morten Pedersen
Finn-Arne Johansen
Petter Reinholdtsen
Erik Inge Bolsř
Polish 75% Peter Dabrowski
Aleksander Opoczynski
Portuguese 54% Paulo Rodrigues
Russian
UTF8
87% Alexey Cherepanov
Khaimin Vladimir
Simplified Chinese (UTF8) 79% Carfield Yim
Edmund Lian
Slovak 97% Peter Mészáros
Spanish
UTF8
76% Federico Montesino Pouzols
Tomás Pereira
Spanish (Colombia)
UTF8
88% Dirk Enrique Seiffert
Lourdes Mejía Martinez
Silfredo Godoy Chavez
Spanish (El Salvador) 57% Carlos López Linares
Spanish (Ecuador) 76% Technical
Spanish (Mexico)
UTF8
100% Alberto Ladron
Hernán García Botello
Spanish (Panama) 76% Maria Gabriela Fong
Spanish (Paraguay) 76% Mario L. Epp
Spanish (Venezuela) 86% John Stoddart
Swedish 100% Jonny Larsson
Daniel Andersson
Johan Hambraeus
Traditional Chinese (BIG5)
UTF8
86% Carfield Yim
Edmund Lian
Kent Tong
Turkish 37% Mufit Eribol
Ukrainian
UTF8
81% Ivan Petrouchtchak

Templates
User contributed foreign language templates .

The templates were provided by users.
To install unzip the file in the templates folder. Some templates may not be translated. Templates can be edited with the built-in editor or with an external text editor. If you would like to share your templates so others benefit from them too feel free to submit them to us.

Chart of Accounts
The Default Chart of Accounts are samples only! You can modify and add your own chart of accounts. Just copy one of the .sql files in the sql directory. Nameing convention is Description-chart.sql (-chart.sql must be part of the filename)

GIFI (if it exists) is named Description-gifi.sql It provides a linking mechanism to an official chart of accounts issued by your Government to generate financial reports.

Note:
Default - the English sample COA translated into another language
General - a general COA for the country
Standard - the COA is in accordance to the country's standards

  1. English, Default
  2. Australia_General_0000
  3. Australia_General_00000
  4. Austria, Standard (Kontenplan)
  5. Bahasa-Indonesia, Default
  6. Belgium, Standard & GIFI
  7. Brazil, General
  8. English-Canadian, General & GIFI
  9. French-Canadian, General & GIFI
  10. Colombia-PUC
  11. Czech Republic, Standard
  12. Danish, Default
  13. Dutch, Default
  14. The Netherlands, Standard
  15. Egypt, General
  16. France, Standard
  17. Germany, SKR03, DATEV
  18. Hungarian, Default
  19. Italy, Standard, cc2424
  20. Latvia, Standard
  21. Norwegian, Default
  22. Paraguay, Standard
  23. Poland, Standard
  24. Simplified Chinese, Default
  25. Spanish, Default
  26. Swedish, Default
  27. Swiss-German, Default
  28. Traditional Chinese, Default
  29. UK, General
  30. US, General
  31. US, Manufacturing
  32. US, Service Company
  33. Venezuela, Default

Adding a new language
  • Add a country code in locale
  • create the file LANGUAGE and enter the longform of the language i.e German
  • create a symlink to ../de/locales.pl
  • run perl locales.pl -a
  • edit the file all
  • rerun perl locales.pl

    If you would like to make changes to the translations, or submit new templates or chart of accounts contact us.

  • REQUIREMENTS
    1. Web server (Apache, thttpd 2.22+, boa, AOL server, ....)
    2. Perl 5+
    3. SQL Server ( PostgreSQL 7.1+, )
    4. Database Independant Interface DBI
    5. Database Driver for SQL server DBD ( DBD-Pg, )
    6. LaTeX (optional)
    The required software packages are available in packaged format on most modern distribution.