|
|
Latest version
|
Download the latest release
[ Version 3.2.12 ]
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 first make backups of your database and sql-ledger directory. 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 first make a backup of your database and your sql-ledger directory.
Next 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.
If you run into issues revert to your backup, and attempt a slotted install.
Advanced users may also do a slotted intall, that is running a new version alongside an old version.
It is important to keep backups of the database prior to the upgrade.
|
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.
|
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
- English, Default
- Australia_General_0000
- Australia_General_00000
- Austria, Standard (Kontenplan)
- Bahasa-Indonesia, Default
- Belgium, Standard & GIFI
- Brazil, General
- English-Canadian, General & GIFI
- French-Canadian, General & GIFI
- Colombia-PUC
- Czech Republic, Standard
- Danish, Default
- Dutch, Default
- The Netherlands, Standard
- Egypt, General
- France, Standard
- Germany, SKR03, DATEV
- Hungarian, Default
- Italy, Standard, cc2424
- Latvia, Standard
- Norwegian, Default
- Paraguay, Standard
- Poland, Standard
- Simplified Chinese, Default
- Spanish, Default
- Swedish, Default
- Swiss-German, Default
- Traditional Chinese, Default
- UK, General
- US, General
- US, Manufacturing
- US, Service Company
- 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
|
- Web server (Apache,
thttpd 2.22+,
boa, AOL server, ....)
- Perl 5+
- SQL Server (
PostgreSQL 7.1+,
)
- Database Independant Interface
DBI
- Database Driver for SQL server
DBD
(
DBD-Pg,
)
- LaTeX (optional)
- pdftk (optional)
|
|
|
|