1 Upgrading from version 1.6 to 1.8
3 1. make a backup copy of your databases and SQL-Ledger, just in case!
4 $ cd /usr/local/www/sql-ledger
5 $ pg_dump database > db.out
6 $ tar cvf ~/sql-ledger.tar .
8 2. install SQL-Ledger over top of your old installation
10 $ tar zxvf sql-ledger-1.8.0.tar.gz
12 3. change the tables to the new layout
14 $ psql database < upgrade-1.6-1.8.sql
16 4. copy the new master templates to your template directory
19 $ cp Default-email_purchase_order.html your_template_dir/email_purchase_order.html
20 $ cp Default-purchase_order.html your_template_dir/purchase_order.html
21 $ cp Default-email_sales_order.html your_template_dir/email_sales_order.html
22 $ cp Default-sales_order.html your_template_dir/sales_order.html
24 5. Two new accounts were hopefully added to your chart of accounts
25 One account for Foreign Exchange Gains and one for
26 Foreign Exchange Losses
27 edit and change to suit your COA. You can safely change
28 the account number too.
30 6. Edit your preferences
32 In field 'Stylesheet' enter -> sql-ledger.css
33 Stylesheet is in the css directory
35 Add your foreign currencies in the Currencies field
36 The first currency in the list is your default
38 If you used a nativecurr than it should be listed in the
41 7. <%nativecurr%> has changed to <%currency%>
42 edit all your templates and change nativecurr to currency
44 8. I also added four more variables which can be used in your templates.
45 <%contact%>, <%shiptocontact%>, <%shiptophone%>, <%shiptofax%>
47 9. Nameing convention for templates has changed from an
48 underscore to a minus sign. If you designed your own
49 master templates rename the templates from
50 industry_invoice.html to industry-invoice.html,
51 industry_packing_list.html to industry-packing_list.html, etc.
52 The minus sign is used to separate the name and list them in
55 This change only applies to the master templates in the
56 templates root directory NOT the individual templates which
59 It looks more than it really is. Steps 1 to 4 are important,
60 the rest is for fine tuning and info.