diff options
-rw-r--r-- | README.sql-ledger (renamed from doc/README.sql-ledger) | 2 | ||||
-rwxr-xr-x | doc/LICENSE (renamed from doc/COPYING) | 0 | ||||
-rwxr-xr-x | doc/UPGRADE-1.6-1.8 | 61 | ||||
-rwxr-xr-x | doc/UPGRADE-1.8-1.8.3 | 23 | ||||
-rwxr-xr-x | doc/UPGRADE-1.8.3-1.8.4 | 10 | ||||
-rwxr-xr-x | doc/UPGRADE-1.8.4-1.8.5 | 18 | ||||
-rwxr-xr-x | doc/UPGRADE-1.8.5-1.8.7 | 6 | ||||
-rwxr-xr-x | doc/UPGRADE-1.8.7-2.0.0 | 20 | ||||
-rwxr-xr-x | doc/UPGRADE-2.0-2.0.8 | 8 | ||||
-rwxr-xr-x | doc/UPGRADE-2.0.8-2.0.9 | 6 | ||||
-rwxr-xr-x | doc/UPGRADE-2.0.9-2.2.0 | 12 | ||||
-rwxr-xr-x | doc/UPGRADE-2.2.0-2.2.7 | 11 | ||||
-rwxr-xr-x | doc/UPGRADE-2.2.7-2.4.0 | 84 | ||||
-rwxr-xr-x | doc/UPGRADE-2.4.0-2.4.2 | 12 | ||||
-rwxr-xr-x | doc/UPGRADE-2.4.16-2.6.0 | 19 | ||||
-rwxr-xr-x | doc/UPGRADE-2.4.2-2.4.3 | 22 | ||||
-rwxr-xr-x | doc/UPGRADE-2.4.3-2.4.16 | 12 | ||||
-rwxr-xr-x | doc/UPGRADE-2.6.0-2.6.17 | 14 |
18 files changed, 2 insertions, 338 deletions
diff --git a/doc/README.sql-ledger b/README.sql-ledger index 5d6f33c4..c29d8410 100644 --- a/doc/README.sql-ledger +++ b/README.sql-ledger @@ -11,3 +11,5 @@ This script will rename some files, delete others, and pretty soon you will have a working LedgerSMB installation. The database will be updated on first login. + +You will also want to migrate your configuration by running the SL2LS.pl script included in this directory. diff --git a/doc/COPYING b/doc/LICENSE index 083bb415..083bb415 100755 --- a/doc/COPYING +++ b/doc/LICENSE diff --git a/doc/UPGRADE-1.6-1.8 b/doc/UPGRADE-1.6-1.8 deleted file mode 100755 index cc965849..00000000 --- a/doc/UPGRADE-1.6-1.8 +++ /dev/null @@ -1,61 +0,0 @@ -Upgrading from version 1.6 to 1.8 - -1. make a backup copy of your databases and SQL-Ledger, just in case! - $ cd /usr/local/www/sql-ledger - $ pg_dump database > db.out - $ tar cvf ~/sql-ledger.tar . - -2. install LedgerSMB over top of your old installation - $ cd /usr/local/www - $ tar zxvf sql-ledger-1.8.0.tar.gz - -3. change the tables to the new layout - $ cd sql-ledger/sql - $ psql database < upgrade-1.6-1.8.sql - -4. copy the new master templates to your template directory - $ cd ../templates - - $ cp Default-email_purchase_order.html your_template_dir/email_purchase_order.html - $ cp Default-purchase_order.html your_template_dir/purchase_order.html - $ cp Default-email_sales_order.html your_template_dir/email_sales_order.html - $ cp Default-sales_order.html your_template_dir/sales_order.html - -5. Two new accounts were hopefully added to your chart of accounts - One account for Foreign Exchange Gains and one for - Foreign Exchange Losses - edit and change to suit your COA. You can safely change - the account number too. - -6. Edit your preferences - - In field 'Stylesheet' enter -> sql-ledger.css - Stylesheet is in the css directory - - Add your foreign currencies in the Currencies field - The first currency in the list is your default - i.e CDN:USD:EUR:YEN - If you used a nativecurr than it should be listed in the - new currencies field. - -7. <%nativecurr%> has changed to <%currency%> - edit all your templates and change nativecurr to currency - -8. I also added four more variables which can be used in your templates. - <%contact%>, <%shiptocontact%>, <%shiptophone%>, <%shiptofax%> - -9. Nameing convention for templates has changed from an - underscore to a minus sign. If you designed your own - master templates rename the templates from - industry_invoice.html to industry-invoice.html, - industry_packing_list.html to industry-packing_list.html, etc. - The minus sign is used to separate the name and list them in - the setup screen. - - This change only applies to the master templates in the - templates root directory NOT the individual templates which - are used by users. - -It looks more than it really is. Steps 1 to 4 are important, -the rest is for fine tuning and info. - diff --git a/doc/UPGRADE-1.8-1.8.3 b/doc/UPGRADE-1.8-1.8.3 deleted file mode 100755 index 10522d14..00000000 --- a/doc/UPGRADE-1.8-1.8.3 +++ /dev/null @@ -1,23 +0,0 @@ -Upgrading from version 1.8.(0-2) to 1.8.3 - -1. install LedgerSMB over top of your old installation - $ cd /usr/local - $ tar zxvf sql-ledger-1.8.3.tar.gz - -2. copy ledger-smb.conf.default to ledger-smb.conf - $ cp ledger-smb.conf.default ledger-smb.conf - - if you modified ledger-smb.conf merge the changes from the - .default file rather than copying over top. - -3. copy the new master templates to your template directory - $ cd ../templates - - $ cp Default-invoice.tex your_template_dir/invoice.tex - $ cp Default-packing_list.tex your_template_dir/packing_list.tex - $ cp Default-purchase_order.tex your_template_dir/purchase_order.tex - $ cp Default-sales_order.tex your_template_dir/sales_order.tex - -4. edit ledger-smb.conf - instructions are in the file - diff --git a/doc/UPGRADE-1.8.3-1.8.4 b/doc/UPGRADE-1.8.3-1.8.4 deleted file mode 100755 index c4e9beaf..00000000 --- a/doc/UPGRADE-1.8.3-1.8.4 +++ /dev/null @@ -1,10 +0,0 @@ -Upgrading from version 1.8.3 to 1.8.4 - -1. install LedgerSMB over top of your old installation - $ cd /usr/local - $ tar zxvf sql-ledger-1.8.4.tar.gz - -2. update the tables with the admin script - - You will not be able to log in until you upgraded the tables. - diff --git a/doc/UPGRADE-1.8.4-1.8.5 b/doc/UPGRADE-1.8.4-1.8.5 deleted file mode 100755 index 68e1fbc6..00000000 --- a/doc/UPGRADE-1.8.4-1.8.5 +++ /dev/null @@ -1,18 +0,0 @@ -Upgrading from version 1.8.4 to 1.8.5 - -1. install LedgerSMB over top of your old installation - $ cd /usr/local - $ tar zxvf sql-ledger-1.8.5.tar.gz - -2. update the tables with the admin script - - You will not be able to log in until you upgraded the tables. - - -There are two new variables (<%customernumber%> and <%vendornumber%>) -which can be used in the forms. These may be used instead of the -internally generated customer_id and vendor_id. - -Typically these numbers are used to retrieve a customer, vendor -by some ID. In most counter operations the phone number is used. - diff --git a/doc/UPGRADE-1.8.5-1.8.7 b/doc/UPGRADE-1.8.5-1.8.7 deleted file mode 100755 index 2c328609..00000000 --- a/doc/UPGRADE-1.8.5-1.8.7 +++ /dev/null @@ -1,6 +0,0 @@ -Upgrading from version 1.8.5 to 1.8.7 - -1. install LedgerSMB over top of your old installation - $ cd /usr/local - $ tar zxvf sql-ledger-1.8.7.tar.gz - diff --git a/doc/UPGRADE-1.8.7-2.0.0 b/doc/UPGRADE-1.8.7-2.0.0 deleted file mode 100755 index 184f2605..00000000 --- a/doc/UPGRADE-1.8.7-2.0.0 +++ /dev/null @@ -1,20 +0,0 @@ -Upgrading to Version 2.0.0 - -1. install LedgerSMB over top of your old installation - $ cd /usr/local - $ tar zxvf sql-ledger-2.0.0.tar.gz - -2. load admin.pl and update the tables - - You will not be able to log in until the tables are up to date. - -3. copy the new templates to your personal template directory - - $ cd templates - $ cp Default-check.tex dir/check.tex - $ cp Default-receipt.tex dir/receipt.tex - $ cp Default-statement.html dir/statement.html - $ cp Default-statement.tex dir/statement.tex - - replace 'dir' with your directory name - diff --git a/doc/UPGRADE-2.0-2.0.8 b/doc/UPGRADE-2.0-2.0.8 deleted file mode 100755 index ae592d8a..00000000 --- a/doc/UPGRADE-2.0-2.0.8 +++ /dev/null @@ -1,8 +0,0 @@ -Upgrading from version 2.0.[0-7] to 2.0.8 - -1. install LedgerSMB over top of your old installation - $ cd /usr/local - $ tar zxvf sql-ledger-2.0.8.tar.gz - -2. update your datasets with the admin script - diff --git a/doc/UPGRADE-2.0.8-2.0.9 b/doc/UPGRADE-2.0.8-2.0.9 deleted file mode 100755 index a18f1038..00000000 --- a/doc/UPGRADE-2.0.8-2.0.9 +++ /dev/null @@ -1,6 +0,0 @@ -Upgrading from version 2.0.8 to 2.0.9 - -1. install LedgerSMB over top of your old installation - $ cd /usr/local - $ tar zxvf sql-ledger-2.0.9.tar.gz - diff --git a/doc/UPGRADE-2.0.9-2.2.0 b/doc/UPGRADE-2.0.9-2.2.0 deleted file mode 100755 index f7386a74..00000000 --- a/doc/UPGRADE-2.0.9-2.2.0 +++ /dev/null @@ -1,12 +0,0 @@ -Upgrading from version 2.0.9 to 2.2.0 - -1. backup your datasets. Always a good idea! - -2. install LedgerSMB over top of your old installation - $ cd /usr/local - $ tar zxvf sql-ledger-2.2.0.tar.gz - -3. copy Default-pos_invoice.txt to - templates/your_private_directory/pos_invoice.txt - and edit to suit. - diff --git a/doc/UPGRADE-2.2.0-2.2.7 b/doc/UPGRADE-2.2.0-2.2.7 deleted file mode 100755 index ae4ba8b1..00000000 --- a/doc/UPGRADE-2.2.0-2.2.7 +++ /dev/null @@ -1,11 +0,0 @@ -Upgrading to version 2.2.7 - -1. install LedgerSMB over top - # cd /usr/local - # tar zxvf sql-ledger-2.2.7.tar.gz - -2. fix permissions - # chown -R nobody:nogroup * - # chmod 711 templates users - -Note: replace nobody:nogroup with your web server user and group diff --git a/doc/UPGRADE-2.2.7-2.4.0 b/doc/UPGRADE-2.2.7-2.4.0 deleted file mode 100755 index b5c317b2..00000000 --- a/doc/UPGRADE-2.2.7-2.4.0 +++ /dev/null @@ -1,84 +0,0 @@ -Upgrading to version 2.4.0 - -1. install LedgerSMB over top - # cd /usr/local - # tar zxvf sql-ledger-2.4.0.tar.gz - -2. fix permissions - # chown -hR nobody:nogroup * - # chmod 711 templates users spool - -replace nobody:nogroup with your web server user and group - -3. install the plpgsql language compiler for PostgreSQL - # createlang plpgsql <dataset> - -4. install plpgsql in template1 - # createlang plpgsql template1 - -5. Edit your templates! The old address fields are obsolete. - -The new fields are: - address1 - address2 - city - state - zipcode - country - -The same applies to the "shipto" addresses. - -Before you log in edit Pg-upgrade-2.3.4-2.3.5.sql and change the -way addresses are rewritten if you don't want US style addresses. - -North-american addresses are usually in the form of - -Five Star Stables -123 Horsehoe Blvd. -Sweetgrass, MT 19867 -U.S.A - -addr1 --> address1 -addr2 --> city -addr3 --> country -addr4 --> state - -addr4 was put into the state field to bring the field forward -to the new layout. To check if there is something in the field run -a report and sort by the "State" field. - -Either edit the records or run the SQL queries below to take them apart. - -If you have anything in the "state" field change the records to match -the others before you run the following queries. - -dbname=# update customer set state = substr(city,strpos(city,' ')+1); -dbname=# update customer set zipcode = substr(state,strpos(state,' ')+1); -dbname=# update customer set state = substr(state,1,strpos(state,' ')-1); -dbname=# update customer set city = substr(city,1,strpos(city,',')-1); - -do the same with the vendor and shipto table. - -6. create a new set of templates - - * load admin.pl and edit one of the user's - * in the "New Templates" field enter "new" and save the user - * go back in your browser so you have the same screen again - as before - * change the template directory back to what it was before - the change and save the user - - * drop into a shell window - * cd to sql-ledger/templates/new - * copy the additional templates to your private template directory - -7. Printers - -printer setup has changed to multiple printers which allow -users to choose a printer. Printers can be defined in ledger-smb.conf - - -Oracle and DB2: -=============== -There is no upgrade available for Oracle and DB2 yet. - diff --git a/doc/UPGRADE-2.4.0-2.4.2 b/doc/UPGRADE-2.4.0-2.4.2 deleted file mode 100755 index 9172849e..00000000 --- a/doc/UPGRADE-2.4.0-2.4.2 +++ /dev/null @@ -1,12 +0,0 @@ -Upgrading from version 2.4.(0-1) to 2.4.2 - -1. install LedgerSMB over top - # cd /usr/local - # tar zxvf sql-ledger-2.4.x.tar.gz - -2. fix permissions - # chown -hR nobody:nogroup * - # chmod 711 templates users css spool - -Note: replace nobody:nogroup with your web server user and group - diff --git a/doc/UPGRADE-2.4.16-2.6.0 b/doc/UPGRADE-2.4.16-2.6.0 deleted file mode 100755 index 86c9baff..00000000 --- a/doc/UPGRADE-2.4.16-2.6.0 +++ /dev/null @@ -1,19 +0,0 @@ -Upgrading from version 2.4 to 2.6 - -1. install LedgerSMB over top - # cd /usr/local - # tar zxvf sql-ledger-2.6.x.tar.gz - -2. fix permissions - # chown -hR nobody:nogroup * - # chmod 711 templates users css spool - -Note: replace nobody:nogroup with your web server user and group - -3. Copy the new templates to your private template directory - - $ cp Default-timecard.html your_template_dir/timecard.html - $ cp Default-timecard.tex your_template_dir/timecard.tex - -4. log in - diff --git a/doc/UPGRADE-2.4.2-2.4.3 b/doc/UPGRADE-2.4.2-2.4.3 deleted file mode 100755 index 70a096d0..00000000 --- a/doc/UPGRADE-2.4.2-2.4.3 +++ /dev/null @@ -1,22 +0,0 @@ -Upgrading from version 2.4.2 to 2.4.3 - -1. install LedgerSMB over top of your old installation - $ cd /usr/local - $ tar zxvf sql-ledger-2.4.3.tar.gz - -2. fix permissions - # chown -hR nobody:nogroup * - # chmod 711 templates users css spool - - Note: replace nobody:nogroup with your web server user and group - -3. copy the following templates to your template directory - $ cd templates - - $ cp Default-ar_transaction.html your_template_dir/ar_transaction.html - $ cp Default-ar_transaction.tex your_template_dir/ar_transaction.tex - $ cp Default-ap_transaction.html your_template_dir/ap_transaction.html - $ cp Default-ap_transaction.tex your_template_dir/ap_transaction.tex - -4. log in - diff --git a/doc/UPGRADE-2.4.3-2.4.16 b/doc/UPGRADE-2.4.3-2.4.16 deleted file mode 100755 index a0e24f4b..00000000 --- a/doc/UPGRADE-2.4.3-2.4.16 +++ /dev/null @@ -1,12 +0,0 @@ -Upgrading from version 2.4.(3-15) to 2.4.16 - -1. install LedgerSMB over top - # cd /usr/local - # tar zxvf sql-ledger-2.4.x.tar.gz - -2. fix permissions - # chown -hR nobody:nogroup * - # chmod 711 templates users css spool - -Note: replace nobody:nogroup with your web server user and group - diff --git a/doc/UPGRADE-2.6.0-2.6.17 b/doc/UPGRADE-2.6.0-2.6.17 deleted file mode 100755 index 3965bb00..00000000 --- a/doc/UPGRADE-2.6.0-2.6.17 +++ /dev/null @@ -1,14 +0,0 @@ -Upgrading from version 2.6.(0-16) to 2.6.17 - -1. install LedgerSMB over top - # cd /usr/local - # tar zxvf sql-ledger-2.6.17.tar.gz - -2. fix permissions - # chown -hR nobody:nogroup * - # chmod 711 templates users css spool - -Note: replace nobody:nogroup with your web server user and group - -3. log in - |