sql-ledger-users

[SL] Dataset creation problems

[Yves L. <yve...@gm...>]

Hi,

I am having a few problems with the dataset creation menu, using PGSQL.

   - Upon creation, the database is owned by sql-ledger, but tables are
   owned by PGSQL default user postgres. This seems odd, because the proper
   creation method is well documented in the FAQ.
   - During creation, SQL-Ledger reports Error!, CREATE SEQUENCE id start
   10000, ERROR: relation "id" already exists.

Those are easy to prevent by using the alternate creation method documented
in the FAQ. I an just wondering if I am alone with those or if this portion
of the code is still work in progress.

Yves

Re: [SL] Dataset creation problems

[Rolf S. (tokon) <in...@to...>]

Yves Lavoie schrieb:
>    - During creation, SQL-Ledger reports Error!, CREATE SEQUENCE id start
>    10000, ERROR: relation "id" already exists.

This means the database or a part of it already exists, maybe because a 
previous creation failed. I had similar errors, when I tried to create a 
DB with a chart of accounts that was not compatible with the charset of 
the DB, pressed the "back" button in the browser and then tried to 
create the same db for a second time. If the DB creation fails, you have 
to drop the DB first before you try again.

Rolf

Re: [SL] Dataset creation problems

[Yves L. <yve...@gm...>]

Hi Rolf,

I suspected that, so I dropped the database with PgAdmin, to make sure that
it was gone for good.
Same problem.

Yves

2008/3/1, "Rolf Stöckli (tokon)" <in...@to...>:
>
> Yves Lavoie schrieb:
> >    - During creation, SQL-Ledger reports Error!, CREATE SEQUENCE id
> start
>
> >    10000, ERROR: relation "id" already exists.
>
>
> This means the database or a part of it already exists, maybe because a
> previous creation failed. I had similar errors, when I tried to create a
> DB with a chart of accounts that was not compatible with the charset of
> the DB, pressed the "back" button in the browser and then tried to
> create the same db for a second time. If the DB creation fails, you have
> to drop the DB first before you try again.
>

Re: [SL] Dataset creation problems

[Rolf S. (tokon) <in...@to...>]

Bonjour Yves,
That's really strange. In an empty DB, the relation "id" doesn't exist 
yet, so there should be no such error. If you don't use the name of an 
already existing dataset, don't click 2 times the "Continue" button and 
don't press the browser's reload button even if you think the creation 
takes too much time (and I'm sure you do neither of them), I've no idea 
why such an error occurs. - But I know, my fantasy is a bit restricted.

Rolf

Re: [SL] Dataset creation problems

[Yves L. <yve...@gm...>]

Bonjour Rolf,

I found it. I am using Ubuntu and PostgreSQL 8.3
On my setup, the created database was owned by sql-ledger, but the schema
and tables were owned by postgres, the default PGSQL user.
I sent this patch to Dieter for approval:
User.pm, line 360
  $dbh = DBI->connect($form->{dbconnect}, $form->{dbuser},
$form->{dbpasswd}) or $form->dberror;

+  if ($form->{dbdriver} eq 'Pg') {
+    $dbcreate{Pg} = " SET SESSION AUTHORIZATION \"$form->{dbuser}\"";
+    $query = qq|$dbcreate{$form->{dbdriver}}|;
+    $dbh->do($query);
+  }

  # create the tables
  my $dbdriver = ($form->{dbdriver} =~ /Pg/) ? 'Pg' : $form->{dbdriver};

It worked for me, fixed the creation errors and solved the empty database
list upon removal, because list is produced by acheck for ownership on
defaults by sql-ledger.

Yves

2008/3/2, "Rolf Stöckli (tokon)" <in...@to...>:
>
> Bonjour Yves,
> That's really strange. In an empty DB, the relation "id" doesn't exist
> yet, so there should be no such error. If you don't use the name of an
> already existing dataset, don't click 2 times the "Continue" button and
> don't press the browser's reload button even if you think the creation
> takes too much time (and I'm sure you do neither of them), I've no idea
> why such an error occurs. - But I know, my fantasy is a bit restricted.
>
>
> Rolf
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>



-- 
Yves Lavoie ing.
Président
Gestion Automatisée Yves Lavoie inc.
Tel: (450) 746-7521
email: yve...@gm...

Re: [SL] Dataset creation problems

[Rolf S. (tokon) <in...@to...>]

Yves Lavoie schrieb:
> It worked for me, fixed the creation errors and solved the empty database
> list upon removal, because list is produced by acheck for ownership on
> defaults by sql-ledger.

Thanks. So the "relation 'id' already exists" error was caused not 
because SQL-Ledger was unable to create the DB, but because the already 
existing DB didn't appear on the "existing datasets" list?

Rolf

Re: [SL] Dataset creation problems

[Yves L. <yve...@gm...>]

No, 2 separate problems.
1- DB was created, tables also but weren't accessible, relation already
exist was true, but couldn't be modified.
2- existing datasets weren't displayed because the defaults table wasn't
owned by sql-ledger, thus making it impossible to delete datasets through
the menu.

Yves

2008/3/2, "Rolf Stöckli (tokon)" <in...@to...>:
>
> Yves Lavoie schrieb:
>
> > It worked for me, fixed the creation errors and solved the empty
> database
> > list upon removal, because list is produced by acheck for ownership on
> > defaults by sql-ledger.
>
>
> Thanks. So the "relation 'id' already exists" error was caused not
> because SQL-Ledger was unable to create the DB, but because the already
> existing DB didn't appear on the "existing datasets" list?
>

Re: [SL] Dataset creation problems

[Roy W P. <arc...@mt...>]

The Error...
> CREATE SEQUENCE id start 10000, ERROR: relation "id" already exists.
can occur when you accidentally restore a Sql-ledger dataset to the template1 database.
template1 is used as a starting point every time a new database is created.
Therefore, if you accidentally create/restore a sql-ledger dataset into template1, the id table is created in the template1 database and every single database thereafter.

Hope that makes sense.

Roy

[SL] html templates

[Joseph A. M. <ja...@jo...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I made changes to the balance sheet  html template and wanted to know if
changes can be made  specifically to one company? If not what is the
best way to make changes to titles of account groupings in a financial
statement. For example, i have the books for both a non-profit and a for
profit entity and want to use "net assets" and " Partnership Capital"
respectively  to describe the equity section on the balance sheet. I
have made changes to the chart of accounts but on the balance sheet
report is says total equity etc. When I make changes to one entities it
is also made on the other.

I am a user and accountant not a programmer.

Thanks for your help.

Joe

www.joemaffia.com



Yves Lavoie wrote:
> No, 2 separate problems.
> 1- DB was created, tables also but weren't accessible, relation already
> exist was true, but couldn't be modified.
> 2- existing datasets weren't displayed because the defaults table wasn't
> owned by sql-ledger, thus making it impossible to delete datasets through
> the menu.
>
> Yves
>
> 2008/3/2, "Rolf Stöckli (tokon)" <in...@to...>:
>> Yves Lavoie schrieb:
>>
>>> It worked for me, fixed the creation errors and solved the empty
>> database
>>> list upon removal, because list is produced by acheck for ownership on
>>> defaults by sql-ledger.
>>
>> Thanks. So the "relation 'id' already exists" error was caused not
>> because SQL-Ledger was unable to create the DB, but because the already
>> existing DB didn't appear on the "existing datasets" list?
>>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4-svn0 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFHz3xk1Zo2InkR90QRAr3CAJwLSwfubZ8KwOhJAVDhzY3RysIfTACgqGRj
GdM36h6py7hK6Sh79AzkyB4=
=vI7j
-----END PGP SIGNATURE-----

Re: [SL] html templates

[Paul T. <pt...@wa...>]

Sorry, but to me equity is equity, and result previous year is result
previous year.
Weather that result is created by donations, gifts, or trade, it is a
result.

Why rename common used items thus creating unclear set of annual reports?
The naming of the ledgers themselve should be enough separation to clarify
any doubts I take it.

So the standard header Equity might show (with or without account nrs, tick
the box if wanted) Partnership Capital in one report, and Share Capital in
another report.

Just like assets may be machines in a factory environment, and cars in a
lease company.
You would not want to rename those as well i take it?


2008/3/6, Joseph A. Maffia <ja...@jo...>:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> I made changes to the balance sheet  html template and wanted to know if
> changes can be made  specifically to one company? If not what is the
> best way to make changes to titles of account groupings in a financial
> statement. For example, i have the books for both a non-profit and a for
> profit entity and want to use "net assets" and " Partnership Capital"
> respectively  to describe the equity section on the balance sheet. I
> have made changes to the chart of accounts but on the balance sheet
> report is says total equity etc. When I make changes to one entities it
> is also made on the other.
>
> I am a user and accountant not a programmer.
>
> Thanks for your help.
>
> Joe
>
> www.joemaffia.com
>
>
>
> Yves Lavoie wrote:
> > No, 2 separate problems.
> > 1- DB was created, tables also but weren't accessible, relation already
> > exist was true, but couldn't be modified.
> > 2- existing datasets weren't displayed because the defaults table wasn't
> > owned by sql-ledger, thus making it impossible to delete datasets
> through
> > the menu.
> >
> > Yves
> >
> > 2008/3/2, "Rolf Stöckli (tokon)" <in...@to...>:
> >> Yves Lavoie schrieb:
> >>
> >>> It worked for me, fixed the creation errors and solved the empty
> >> database
> >>> list upon removal, because list is produced by acheck for ownership on
> >>> defaults by sql-ledger.
> >>
> >> Thanks. So the "relation 'id' already exists" error was caused not
> >> because SQL-Ledger was unable to create the DB, but because the already
> >> existing DB didn't appear on the "existing datasets" list?
> >>
> >
> -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.4-svn0 (GNU/Linux)
> Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org
>
> iD8DBQFHz3xk1Zo2InkR90QRAr3CAJwLSwfubZ8KwOhJAVDhzY3RysIfTACgqGRj
> GdM36h6py7hK6Sh79AzkyB4=
> =vI7j
> -----END PGP SIGNATURE-----
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] html templates

[Joseph A. M. <ja...@jo...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Paul,
 In non profit world for U.S. Gaap purposes equity is called net assets
with no reference to "owners" equity. Same with partnership accounting
they have different tiles for equity accounts.
Joe

www.joemaffia.com



Paul Tammes wrote:
> Sorry, but to me equity is equity, and result previous year is result
> previous year.
> Weather that result is created by donations, gifts, or trade, it is a
> result.
>
> Why rename common used items thus creating unclear set of annual reports?
> The naming of the ledgers themselve should be enough separation to clarify
> any doubts I take it.
>
> So the standard header Equity might show (with or without account nrs, tick
> the box if wanted) Partnership Capital in one report, and Share Capital in
> another report.
>
> Just like assets may be machines in a factory environment, and cars in a
> lease company.
> You would not want to rename those as well i take it?
>
>
> 2008/3/6, Joseph A. Maffia <ja...@jo...>:
> I made changes to the balance sheet  html template and wanted to know if
> changes can be made  specifically to one company? If not what is the
> best way to make changes to titles of account groupings in a financial
> statement. For example, i have the books for both a non-profit and a for
> profit entity and want to use "net assets" and " Partnership Capital"
> respectively  to describe the equity section on the balance sheet. I
> have made changes to the chart of accounts but on the balance sheet
> report is says total equity etc. When I make changes to one entities it
> is also made on the other.
>
> I am a user and accountant not a programmer.
>
> Thanks for your help.
>
> Joe
>
> www.joemaffia.com
>
>
>
> Yves Lavoie wrote:
> >>> No, 2 separate problems.
> >>> 1- DB was created, tables also but weren't accessible, relation already
> >>> exist was true, but couldn't be modified.
> >>> 2- existing datasets weren't displayed because the defaults table
wasn't
> >>> owned by sql-ledger, thus making it impossible to delete datasets
> through
> >>> the menu.
> >>>
> >>> Yves
> >>>
> >>> 2008/3/2, "Rolf Stöckli (tokon)" <in...@to...>:
> >>>> Yves Lavoie schrieb:
> >>>>
> >>>>> It worked for me, fixed the creation errors and solved the empty
> >>>> database
> >>>>> list upon removal, because list is produced by acheck for
ownership on
> >>>>> defaults by sql-ledger.
> >>>> Thanks. So the "relation 'id' already exists" error was caused not
> >>>> because SQL-Ledger was unable to create the DB, but because the
already
> >>>> existing DB didn't appear on the "existing datasets" list?
> >>>>
> -------------------------------------------------------------------------
> >>> This SF.net email is sponsored by: Microsoft
> >>> Defy all challenges. Microsoft(R) Visual Studio 2008.
> >>> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> >>> _______________________________________________
> >>> sql-ledger-users mailing list
> >>> sql...@li...
> >>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
- -------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4-svn0 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFHz+011Zo2InkR90QRAn3MAJ9FNpn/1fEAOjp9TaJDr84IztxH2QCgk0qL
PJGcezXt6KZYYGigDrfPZ0o=
=sDnj
-----END PGP SIGNATURE-----

Re: [SL] html templates

[Rolf S. (tokon) <in...@to...>]

Joseph A. Maffia schrieb:
> I made changes to the balance sheet  html template and wanted to know if
> changes can be made  specifically to one company?

In the admin interface, you can create a different set of templates for 
each user account. They will be stored in separate subfolders of 
.../templates/

Rolf

Re: [SL] html templates

[Dieter S. <dsi...@sq...>]

On Thu, 6 Mar 2008, Joseph A. Maffia wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> I made changes to the balance sheet  html template and wanted to know if
> changes can be made  specifically to one company? If not what is the
> best way to make changes to titles of account groupings in a financial
> statement. For example, i have the books for both a non-profit and a for
> profit entity and want to use "net assets" and " Partnership Capital"
> respectively  to describe the equity section on the balance sheet. I
> have made changes to the chart of accounts but on the balance sheet
> report is says total equity etc. When I make changes to one entities it
> is also made on the other.
>
> I am a user and accountant not a programmer.

use the language interface to create different versions.

DS

[SL] Minor HTML bug?

[Michael H. <mh...@it...>]

We're running 2.8.8 and get HTML code in the item descriptions when a  
sales order is generated from a timecard.  Specifically, the line  
breaks in the tech's notes come through to the sales order as actual  
"<BR>".  Anybody know if this is fixed in newer versions?


Thanks!

Michael


On Mar 6, 2008, at 9:01 AM, Dieter Simader wrote:
> On Thu, 6 Mar 2008, Joseph A. Maffia wrote:
>
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> I made changes to the balance sheet  html template and wanted to  
>> know if
>> changes can be made  specifically to one company? If not what is the
>> best way to make changes to titles of account groupings in a  
>> financial
>> statement. For example, i have the books for both a non-profit and  
>> a for
>> profit entity and want to use "net assets" and " Partnership Capital"
>> respectively  to describe the equity section on the balance sheet. I
>> have made changes to the chart of accounts but on the balance sheet
>> report is says total equity etc. When I make changes to one  
>> entities it
>> is also made on the other.
>>
>> I am a user and accountant not a programmer.
>
> use the language interface to create different versions.
>
> DS
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users