akinimod-direqcafe Mailing List for AKINIMOD Linux (Page 2)

Hi A.J.

Thanks a lot for the detailed road map !

I don't know yet, if I'm going to implement CVS reports. However, I'll
think about it.

I'll start with the implementation within next week.

Kind regards,
Roman

-----Ursprüngliche Nachricht-----
Von: A.J. Venter [mailto:aj...@ou...] 
Gesendet: Donnerstag, 25. Juni 2009 08:14
An: User discussion and support list.
Betreff: Re: [outkafe] WG: Development of accounting solution

I went and thought about it... actually - trust me, it won't :)
The older direqcafe didn't use a database at all, it stored it's data
in a flatfile binary data-file that was shared across machines... yes,
it was a REALLY stupid design, but there were reasons for it at the
time (the main one being that it had been meant as an LTSP only
solution, not networked) - but this does mean that the code was
completely wrong for how outkafe works.
Your system really should store these entries in a table in the
database, and use SQL to generate the data for the reports.

Here's how I would go about it:
Step one, access your postgresql server using something like PGadmin,
and create a new table with the fields you need.
It need not be too much, essentially all you need is
Timestamp (also set as your primary key)
Description (something you can use to save what kind of transaction it
was)
Amount (A floatingpoint field to store the amount, positive or
negative).

Before you now do anything else, do a sql-dump of this table, which
will give you an SQL file that people can use to create the table - we
can then add it to the schema for a next release which will include
your work- voila :)

Then you code into liboutkafe.pas - find the methods that do
transactions, there are only about 3 or 4 of them anyway, and add a
SQL call to each of them to log it (you will find enough examples of
how to create the sql calls in the library - just a line or two above)

The SQL you will want to generate will ultimately be something like this
INSERT INTO transaction_log VALUES(NOW,'Time sold','43.75');

There you go - you now have a solid log of transactions - that's your
first major milestone. The next one is to be able to report on it.
The proper way is to first define a new report class in liboutkafe
which will handle the DB stuff for you, essentially your report class
will have just methods to take input fields you want as potential
criteria (for now, lets assume we only have to worry about a date
range, so that will mean our parameters will be two TDate variables
for start and end) - and then perform the SQL steps (which you can see
examples of in the other methods) and return the data as needed.
I would suggest your report method produce a TStringList which holds
the data returned as a CSV format set.
So our entry above would come back as:
"2009-06-25 10:05:22:06","Time sold","43.75"

Voila, now you have a core reporting back end.

Add a new tab on the outkafeadmin interface for accounting, at the top
of the tab put a small panel with your filtering options, you
basically just need two TDateEdits a "save as" button and a "submit"
button, in the rest of the tab, put a TListView to display the stuff,
set your column names - and you're good to go.

The submit button creates an instance of the report class, generates a
report and then parses the CSV in the stringlist to fill the
tstringlist , as you do so, you can add up the column values to
produce a total line at the bottom. You could either put this in the
tlistview itself, or perhaps display it more prominently in a bottom
panel or something - see what works design wise.

The Save-As button should be disabled until the submit button is
pressed, when it is subsequently clicked, it should save the
TStringList to a text file (TStringList has a SaveToFile method which
makes this really easy) - so you'll need a TSaveFileDialog as well to
hook up, there should be examples of using this in the code, else
check wiki.lazarus.freepascal.org

And now your reports are save-able as CSV's, which in turn can be
imported into spreadsheets, and from there into other types of
software if needed :)
The CSV export will be really useful, and very easy to add - so I
think that will greatly increase the utility of your addon, no others
are really critical, if people want a PDF or something, they can use
their spreadsheet program to generate it and take care of things like
formatting while they are at it.

That should give you all you want, with a few touches to make it
useful to a lot of people :)  - and while this is just a set of steps,
I think you should find them simple enough to follow, and if you just
put in the time, you'll get what you want, and others will also get
the benefit - and we can release that as the next outkafe release.

As a side-benefit, it means the next set of binaries will also be
updated with libpq requirements etc. for new distro's -all in all, a
good step forward.
I will take it on myself to do a few more things once you're done and
package a release out of the work.

Ciao
A.J.

On Wed, Jun 24, 2009 at 9:53 PM, Roman Meier<rom...@gi...>
wrote:
> Hi A.J.
>
> Thanks for your input !
>
> I can't promise a perfect designed solution too :-) I just need a
> working solution. Maybe you'll find the time one day to improve upon.
>
> I perfectly agree with your propositions. Transactions where money
goes
> out will not come now. I simply don't need that at the moment.
>
> Please get the code for me. It may help.
>
> Kind regards,
> Roman
>
> -----Ursprüngliche Nachricht-----
> Von: A.J. Venter [mailto:ajv...@gm...]
> Gesendet: Mittwoch, 24. Juni 2009 17:23
> An: User discussion and support list.
> Betreff: Re: [outkafe] WG: Development of accounting solution
>
> I may if I go have a look - but it's approach was really rather badly
> designed.
> I wouldn't even touch it if I were you.
>
> What I would suggest, based on code I did for private customers (and
> thus can't share) which worked well:
> Create first of all, a logging module, that logs the transactions,
make
> sure you log everything you actually need, a timestamp of the
> transaction, the amount in etc.
>
> Ditto for transactions where money goes out.
>
> Then instead of thinking "accounting" you think "reporting" - your
> accounting is merely to pull stats from the report, like "total sales
on
> date X" - which is now all doable in pure SQL - lazarus is just the
> interface, the database already knows how to get this data, so just
tell
> it to :)
>
> Ciao
> A.J.
> On Wed, Jun 24, 2009 at 7:11 PM, Roman Meier <rom...@gi...>
> wrote:
> Hi A.J.
>
> Do you still have the code of the older direqcafe version? I can
imagine
> that its accounting part can help me a lot. Can you make it available
> for download?
>
> Kind regards,
> Roman
>
> -----Ursprüngliche Nachricht-----
> Von: Roman Meier [mailto:rom...@gi...]
> Gesendet: Mittwoch, 24. Juni 2009 09:14
> An: 'User discussion and support list.'
> Betreff: AW: [outkafe] Development of accounting solution
>
> Hi A.J.
>
> Thanks for your support !
>
> Good, I'll integrate the code into Outkafe then.
>
> Please feel free to submit your requirements.
>
> Kind regards,
> Roman
>
> -----Ursprüngliche Nachricht-----
> Von: A.J. Venter [mailto:aj...@ou...]
> Gesendet: Montag, 22. Juni 2009 09:56
> An: User discussion and support list.
> Betreff: Re: [outkafe] Development of accounting solution
>
> Hi Roman,
> I think it's a good idea, I must warn you though - I had one in the
> older direqcafe versions, it was the hardest part of the code to
> maintain, you can write it any way you want - but I think if you build
> it into outkafe as a new feature set you will be able to achieve more
> over-all, and can use the outkafe library directly rather than having
to
> rely on plugin calls.
>
> I am happy to support you in the process, but I must say that I
> basically considder outkafe a completed product and I'm only doing
> crucial maintainance on it now, my focus is on kongoni and it's using
up
> every spare moment I have.
> I would love to see outkafe continue, but I just don't have the time
> myself anymore, ideally somebody would take over the project as a
whole
> and see it into the future, with new and fresh ideas, but in the
> meantime, I'll fix critical bugs and help out people like you trying
to
> expand it.
>
>
> Ciao
> A.J.
> On Mon, Jun 22, 2009 at 11:49 AM, Roman Meier <rom...@gi...>
> wrote:
> Hi list
>
> I would like to develop a simple accounting solution for outkafe that
> can be used by anybody using outkafe.
>
> I intend to use the existing outkafe postgresql database to store the
> data. Therefore I can add another table to it. The columns may be:
>
> Id: 4319
> Staff: felix
> Time: 11:3:7
> Date: Sun Feb 1 2009
> Units: 50
> Username: nketsiah
>
> Should I develop a perl plugin for outkafe or should I integrate the
> code directly into outkafe using lazarus?
>
> I need a list with basic requirements / ideas that should be
> implemented?
>
> I need some feedback to make sure that I'm choosing the right
direction.
>
> Kind regards,
> Roman
>
>
>
------------------------------------------------------------------------
> ------
> Are you an open source citizen? Join us for the Open Source Bridge
> conference!
> Portland, OR, June 17-19. Two days of sessions, one day of
unconference:
> $250.
> Need another reason to go? 24-hour hacker lounge. Register today!
>
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebrid
> ge.org
> _______________________________________________
>
> OutKafe MailingList.
> MailingList Options:
> https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
> OutKafe Website/WIKI:
> http://outkafe.outkastsolutions.co.za
>
>
>
> --
> A.J. Venter
> Tel.: +27 21 554 5059
> Fax: +27 11 252 9197
> Outkast Solutions IT
> www.outkastsolutions.co.za
> A division of Global Pact Trading Pty Ltd.
>
> www.silentcoder.co.za - Blog
> scartoonz.silentcoder.co.za - ScarToonz webcomic
>
>
>
------------------------------------------------------------------------
> ------
> _______________________________________________
>
> OutKafe MailingList.
> MailingList Options:
> https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
> OutKafe Website/WIKI:
> http://outkafe.outkastsolutions.co.za
>
>
>
> --
> "Semper in excretum set alta variant" - My father
> A.J. Venter - http://www.silentcoder.co.za
>
>
>
------------------------------------------------------------------------
------
> _______________________________________________
>
> OutKafe MailingList.
> MailingList Options:
https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
> OutKafe Website/WIKI:
> http://outkafe.outkastsolutions.co.za
>



-- 
A.J. Venter
Tel.: +27 21 554 5059
Fax: +27 11 252 9197
Outkast Solutions IT
www.outkastsolutions.co.za
A division of Global Pact Trading Pty Ltd.

www.silentcoder.co.za - Blog
scartoonz.silentcoder.co.za - ScarToonz webcomic

------------------------------------------------------------------------
------
_______________________________________________

OutKafe MailingList. 
MailingList Options:
https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
OutKafe Website/WIKI:
http://outkafe.outkastsolutions.co.za

I went and thought about it... actually - trust me, it won't :)
The older direqcafe didn't use a database at all, it stored it's data
in a flatfile binary data-file that was shared across machines... yes,
it was a REALLY stupid design, but there were reasons for it at the
time (the main one being that it had been meant as an LTSP only
solution, not networked) - but this does mean that the code was
completely wrong for how outkafe works.
Your system really should store these entries in a table in the
database, and use SQL to generate the data for the reports.

Here's how I would go about it:
Step one, access your postgresql server using something like PGadmin,
and create a new table with the fields you need.
It need not be too much, essentially all you need is
Timestamp (also set as your primary key)
Description (something you can use to save what kind of transaction it was)
Amount (A floatingpoint field to store the amount, positive or negative).

Before you now do anything else, do a sql-dump of this table, which
will give you an SQL file that people can use to create the table - we
can then add it to the schema for a next release which will include
your work- voila :)

Then you code into liboutkafe.pas - find the methods that do
transactions, there are only about 3 or 4 of them anyway, and add a
SQL call to each of them to log it (you will find enough examples of
how to create the sql calls in the library - just a line or two above)

The SQL you will want to generate will ultimately be something like this
INSERT INTO transaction_log VALUES(NOW,'Time sold','43.75');

There you go - you now have a solid log of transactions - that's your
first major milestone. The next one is to be able to report on it.
The proper way is to first define a new report class in liboutkafe
which will handle the DB stuff for you, essentially your report class
will have just methods to take input fields you want as potential
criteria (for now, lets assume we only have to worry about a date
range, so that will mean our parameters will be two TDate variables
for start and end) - and then perform the SQL steps (which you can see
examples of in the other methods) and return the data as needed.
I would suggest your report method produce a TStringList which holds
the data returned as a CSV format set.
So our entry above would come back as:
"2009-06-25 10:05:22:06","Time sold","43.75"

Voila, now you have a core reporting back end.

Add a new tab on the outkafeadmin interface for accounting, at the top
of the tab put a small panel with your filtering options, you
basically just need two TDateEdits a "save as" button and a "submit"
button, in the rest of the tab, put a TListView to display the stuff,
set your column names - and you're good to go.

The submit button creates an instance of the report class, generates a
report and then parses the CSV in the stringlist to fill the
tstringlist , as you do so, you can add up the column values to
produce a total line at the bottom. You could either put this in the
tlistview itself, or perhaps display it more prominently in a bottom
panel or something - see what works design wise.

The Save-As button should be disabled until the submit button is
pressed, when it is subsequently clicked, it should save the
TStringList to a text file (TStringList has a SaveToFile method which
makes this really easy) - so you'll need a TSaveFileDialog as well to
hook up, there should be examples of using this in the code, else
check wiki.lazarus.freepascal.org

And now your reports are save-able as CSV's, which in turn can be
imported into spreadsheets, and from there into other types of
software if needed :)
The CSV export will be really useful, and very easy to add - so I
think that will greatly increase the utility of your addon, no others
are really critical, if people want a PDF or something, they can use
their spreadsheet program to generate it and take care of things like
formatting while they are at it.

That should give you all you want, with a few touches to make it
useful to a lot of people :)  - and while this is just a set of steps,
I think you should find them simple enough to follow, and if you just
put in the time, you'll get what you want, and others will also get
the benefit - and we can release that as the next outkafe release.

As a side-benefit, it means the next set of binaries will also be
updated with libpq requirements etc. for new distro's -all in all, a
good step forward.
I will take it on myself to do a few more things once you're done and
package a release out of the work.

Ciao
A.J.

On Wed, Jun 24, 2009 at 9:53 PM, Roman Meier<rom...@gi...> wrote:
> Hi A.J.
>
> Thanks for your input !
>
> I can't promise a perfect designed solution too :-) I just need a
> working solution. Maybe you'll find the time one day to improve upon.
>
> I perfectly agree with your propositions. Transactions where money goes
> out will not come now. I simply don't need that at the moment.
>
> Please get the code for me. It may help.
>
> Kind regards,
> Roman
>
> -----Ursprüngliche Nachricht-----
> Von: A.J. Venter [mailto:ajv...@gm...]
> Gesendet: Mittwoch, 24. Juni 2009 17:23
> An: User discussion and support list.
> Betreff: Re: [outkafe] WG: Development of accounting solution
>
> I may if I go have a look - but it's approach was really rather badly
> designed.
> I wouldn't even touch it if I were you.
>
> What I would suggest, based on code I did for private customers (and
> thus can't share) which worked well:
> Create first of all, a logging module, that logs the transactions, make
> sure you log everything you actually need, a timestamp of the
> transaction, the amount in etc.
>
> Ditto for transactions where money goes out.
>
> Then instead of thinking "accounting" you think "reporting" - your
> accounting is merely to pull stats from the report, like "total sales on
> date X" - which is now all doable in pure SQL - lazarus is just the
> interface, the database already knows how to get this data, so just tell
> it to :)
>
> Ciao
> A.J.
> On Wed, Jun 24, 2009 at 7:11 PM, Roman Meier <rom...@gi...>
> wrote:
> Hi A.J.
>
> Do you still have the code of the older direqcafe version? I can imagine
> that its accounting part can help me a lot. Can you make it available
> for download?
>
> Kind regards,
> Roman
>
> -----Ursprüngliche Nachricht-----
> Von: Roman Meier [mailto:rom...@gi...]
> Gesendet: Mittwoch, 24. Juni 2009 09:14
> An: 'User discussion and support list.'
> Betreff: AW: [outkafe] Development of accounting solution
>
> Hi A.J.
>
> Thanks for your support !
>
> Good, I'll integrate the code into Outkafe then.
>
> Please feel free to submit your requirements.
>
> Kind regards,
> Roman
>
> -----Ursprüngliche Nachricht-----
> Von: A.J. Venter [mailto:aj...@ou...]
> Gesendet: Montag, 22. Juni 2009 09:56
> An: User discussion and support list.
> Betreff: Re: [outkafe] Development of accounting solution
>
> Hi Roman,
> I think it's a good idea, I must warn you though - I had one in the
> older direqcafe versions, it was the hardest part of the code to
> maintain, you can write it any way you want - but I think if you build
> it into outkafe as a new feature set you will be able to achieve more
> over-all, and can use the outkafe library directly rather than having to
> rely on plugin calls.
>
> I am happy to support you in the process, but I must say that I
> basically considder outkafe a completed product and I'm only doing
> crucial maintainance on it now, my focus is on kongoni and it's using up
> every spare moment I have.
> I would love to see outkafe continue, but I just don't have the time
> myself anymore, ideally somebody would take over the project as a whole
> and see it into the future, with new and fresh ideas, but in the
> meantime, I'll fix critical bugs and help out people like you trying to
> expand it.
>
>
> Ciao
> A.J.
> On Mon, Jun 22, 2009 at 11:49 AM, Roman Meier <rom...@gi...>
> wrote:
> Hi list
>
> I would like to develop a simple accounting solution for outkafe that
> can be used by anybody using outkafe.
>
> I intend to use the existing outkafe postgresql database to store the
> data. Therefore I can add another table to it. The columns may be:
>
> Id: 4319
> Staff: felix
> Time: 11:3:7
> Date: Sun Feb 1 2009
> Units: 50
> Username: nketsiah
>
> Should I develop a perl plugin for outkafe or should I integrate the
> code directly into outkafe using lazarus?
>
> I need a list with basic requirements / ideas that should be
> implemented?
>
> I need some feedback to make sure that I'm choosing the right direction.
>
> Kind regards,
> Roman
>
>
> ------------------------------------------------------------------------
> ------
> Are you an open source citizen? Join us for the Open Source Bridge
> conference!
> Portland, OR, June 17-19. Two days of sessions, one day of unconference:
> $250.
> Need another reason to go? 24-hour hacker lounge. Register today!
> http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebrid
> ge.org
> _______________________________________________
>
> OutKafe MailingList.
> MailingList Options:
> https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
> OutKafe Website/WIKI:
> http://outkafe.outkastsolutions.co.za
>
>
>
> --
> A.J. Venter
> Tel.: +27 21 554 5059
> Fax: +27 11 252 9197
> Outkast Solutions IT
> www.outkastsolutions.co.za
> A division of Global Pact Trading Pty Ltd.
>
> www.silentcoder.co.za - Blog
> scartoonz.silentcoder.co.za - ScarToonz webcomic
>
>
> ------------------------------------------------------------------------
> ------
> _______________________________________________
>
> OutKafe MailingList.
> MailingList Options:
> https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
> OutKafe Website/WIKI:
> http://outkafe.outkastsolutions.co.za
>
>
>
> --
> "Semper in excretum set alta variant" - My father
> A.J. Venter - http://www.silentcoder.co.za
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
>
> OutKafe MailingList.
> MailingList Options: https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
> OutKafe Website/WIKI:
> http://outkafe.outkastsolutions.co.za
>



-- 
A.J. Venter
Tel.: +27 21 554 5059
Fax: +27 11 252 9197
Outkast Solutions IT
www.outkastsolutions.co.za
A division of Global Pact Trading Pty Ltd.

www.silentcoder.co.za - Blog
scartoonz.silentcoder.co.za - ScarToonz webcomic

Hi A.J.

Thanks for your input !

I can't promise a perfect designed solution too :-) I just need a
working solution. Maybe you'll find the time one day to improve upon.

I perfectly agree with your propositions. Transactions where money goes
out will not come now. I simply don't need that at the moment.

Please get the code for me. It may help.

Kind regards,
Roman

-----Ursprüngliche Nachricht-----
Von: A.J. Venter [mailto:ajv...@gm...] 
Gesendet: Mittwoch, 24. Juni 2009 17:23
An: User discussion and support list.
Betreff: Re: [outkafe] WG: Development of accounting solution

I may if I go have a look - but it's approach was really rather badly
designed.
I wouldn't even touch it if I were you.

What I would suggest, based on code I did for private customers (and
thus can't share) which worked well:
Create first of all, a logging module, that logs the transactions, make
sure you log everything you actually need, a timestamp of the
transaction, the amount in etc. 

Ditto for transactions where money goes out. 

Then instead of thinking "accounting" you think "reporting" - your
accounting is merely to pull stats from the report, like "total sales on
date X" - which is now all doable in pure SQL - lazarus is just the
interface, the database already knows how to get this data, so just tell
it to :)

Ciao
A.J.
On Wed, Jun 24, 2009 at 7:11 PM, Roman Meier <rom...@gi...>
wrote:
Hi A.J.

Do you still have the code of the older direqcafe version? I can imagine
that its accounting part can help me a lot. Can you make it available
for download?

Kind regards,
Roman

-----Ursprüngliche Nachricht-----
Von: Roman Meier [mailto:rom...@gi...]
Gesendet: Mittwoch, 24. Juni 2009 09:14
An: 'User discussion and support list.'
Betreff: AW: [outkafe] Development of accounting solution

Hi A.J.

Thanks for your support !

Good, I'll integrate the code into Outkafe then.

Please feel free to submit your requirements.

Kind regards,
Roman

-----Ursprüngliche Nachricht-----
Von: A.J. Venter [mailto:aj...@ou...]
Gesendet: Montag, 22. Juni 2009 09:56
An: User discussion and support list.
Betreff: Re: [outkafe] Development of accounting solution

Hi Roman,
I think it's a good idea, I must warn you though - I had one in the
older direqcafe versions, it was the hardest part of the code to
maintain, you can write it any way you want - but I think if you build
it into outkafe as a new feature set you will be able to achieve more
over-all, and can use the outkafe library directly rather than having to
rely on plugin calls.

I am happy to support you in the process, but I must say that I
basically considder outkafe a completed product and I'm only doing
crucial maintainance on it now, my focus is on kongoni and it's using up
every spare moment I have.
I would love to see outkafe continue, but I just don't have the time
myself anymore, ideally somebody would take over the project as a whole
and see it into the future, with new and fresh ideas, but in the
meantime, I'll fix critical bugs and help out people like you trying to
expand it.


Ciao
A.J.
On Mon, Jun 22, 2009 at 11:49 AM, Roman Meier <rom...@gi...>
wrote:
Hi list

I would like to develop a simple accounting solution for outkafe that
can be used by anybody using outkafe.

I intend to use the existing outkafe postgresql database to store the
data. Therefore I can add another table to it. The columns may be:

Id: 4319
Staff: felix
Time: 11:3:7
Date: Sun Feb 1 2009
Units: 50
Username: nketsiah

Should I develop a perl plugin for outkafe or should I integrate the
code directly into outkafe using lazarus?

I need a list with basic requirements / ideas that should be
implemented?

I need some feedback to make sure that I'm choosing the right direction.

Kind regards,
Roman


------------------------------------------------------------------------
------
Are you an open source citizen? Join us for the Open Source Bridge
conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference:
$250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebrid
ge.org
_______________________________________________

OutKafe MailingList.
MailingList Options:
https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
OutKafe Website/WIKI:
http://outkafe.outkastsolutions.co.za



--
A.J. Venter
Tel.: +27 21 554 5059
Fax: +27 11 252 9197
Outkast Solutions IT
www.outkastsolutions.co.za
A division of Global Pact Trading Pty Ltd.

www.silentcoder.co.za - Blog
scartoonz.silentcoder.co.za - ScarToonz webcomic


------------------------------------------------------------------------
------
_______________________________________________

OutKafe MailingList.
MailingList Options:
https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
OutKafe Website/WIKI:
http://outkafe.outkastsolutions.co.za



-- 
"Semper in excretum set alta variant" - My father
A.J. Venter - http://www.silentcoder.co.za

I may if I go have a look - but it's approach was really rather badly
designed.
I wouldn't even touch it if I were you.

What I would suggest, based on code I did for private customers (and thus
can't share) which worked well:
Create first of all, a logging module, that logs the transactions, make sure
you log everything you actually need, a timestamp of the transaction, the
amount in etc.

Ditto for transactions where money goes out.

Then instead of thinking "accounting" you think "reporting" - your
accounting is merely to pull stats from the report, like "total sales on
date X" - which is now all doable in pure SQL - lazarus is just the
interface, the database already knows how to get this data, so just tell it
to :)

Ciao
A.J.

On Wed, Jun 24, 2009 at 7:11 PM, Roman Meier <rom...@gi...> wrote:

> Hi A.J.
>
> Do you still have the code of the older direqcafe version? I can imagine
> that its accounting part can help me a lot. Can you make it available
> for download?
>
> Kind regards,
> Roman
>
> -----Ursprüngliche Nachricht-----
> Von: Roman Meier [mailto:rom...@gi...]
> Gesendet: Mittwoch, 24. Juni 2009 09:14
> An: 'User discussion and support list.'
> Betreff: AW: [outkafe] Development of accounting solution
>
> Hi A.J.
>
> Thanks for your support !
>
> Good, I'll integrate the code into Outkafe then.
>
> Please feel free to submit your requirements.
>
> Kind regards,
> Roman
>
> -----Ursprüngliche Nachricht-----
> Von: A.J. Venter [mailto:aj...@ou...]
> Gesendet: Montag, 22. Juni 2009 09:56
> An: User discussion and support list.
> Betreff: Re: [outkafe] Development of accounting solution
>
> Hi Roman,
> I think it's a good idea, I must warn you though - I had one in the
> older direqcafe versions, it was the hardest part of the code to
> maintain, you can write it any way you want - but I think if you build
> it into outkafe as a new feature set you will be able to achieve more
> over-all, and can use the outkafe library directly rather than having to
> rely on plugin calls.
>
> I am happy to support you in the process, but I must say that I
> basically considder outkafe a completed product and I'm only doing
> crucial maintainance on it now, my focus is on kongoni and it's using up
> every spare moment I have.
> I would love to see outkafe continue, but I just don't have the time
> myself anymore, ideally somebody would take over the project as a whole
> and see it into the future, with new and fresh ideas, but in the
> meantime, I'll fix critical bugs and help out people like you trying to
> expand it.
>
>
> Ciao
> A.J.
> On Mon, Jun 22, 2009 at 11:49 AM, Roman Meier <rom...@gi...>
> wrote:
> Hi list
>
> I would like to develop a simple accounting solution for outkafe that
> can be used by anybody using outkafe.
>
> I intend to use the existing outkafe postgresql database to store the
> data. Therefore I can add another table to it. The columns may be:
>
> Id: 4319
> Staff: felix
> Time: 11:3:7
> Date: Sun Feb 1 2009
> Units: 50
> Username: nketsiah
>
> Should I develop a perl plugin for outkafe or should I integrate the
> code directly into outkafe using lazarus?
>
> I need a list with basic requirements / ideas that should be
> implemented?
>
> I need some feedback to make sure that I'm choosing the right direction.
>
> Kind regards,
> Roman
>
>
> ------------------------------------------------------------------------
> ------
> Are you an open source citizen? Join us for the Open Source Bridge
> conference!
> Portland, OR, June 17-19. Two days of sessions, one day of unconference:
> $250.
> Need another reason to go? 24-hour hacker lounge. Register today!
> http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebrid
> ge.org<" rel="nofollow">http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebrid%0Age.org>
> _______________________________________________
>
> OutKafe MailingList.
> MailingList Options:
> https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
> OutKafe Website/WIKI:
> http://outkafe.outkastsolutions.co.za
>
>
>
> --
> A.J. Venter
> Tel.: +27 21 554 5059
> Fax: +27 11 252 9197
> Outkast Solutions IT
> www.outkastsolutions.co.za
> A division of Global Pact Trading Pty Ltd.
>
> www.silentcoder.co.za - Blog
> scartoonz.silentcoder.co.za - ScarToonz webcomic
>
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
>
> OutKafe MailingList.
> MailingList Options:
> https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
> OutKafe Website/WIKI:
> http://outkafe.outkastsolutions.co.za
>



-- 
"Semper in excretum set alta variant" - My father
A.J. Venter - http://www.silentcoder.co.za

Hi A.J.

Do you still have the code of the older direqcafe version? I can imagine
that its accounting part can help me a lot. Can you make it available
for download?

Kind regards,
Roman

-----Ursprüngliche Nachricht-----
Von: Roman Meier [mailto:rom...@gi...] 
Gesendet: Mittwoch, 24. Juni 2009 09:14
An: 'User discussion and support list.'
Betreff: AW: [outkafe] Development of accounting solution

Hi A.J.

Thanks for your support !

Good, I'll integrate the code into Outkafe then.

Please feel free to submit your requirements.

Kind regards,
Roman

-----Ursprüngliche Nachricht-----
Von: A.J. Venter [mailto:aj...@ou...] 
Gesendet: Montag, 22. Juni 2009 09:56
An: User discussion and support list.
Betreff: Re: [outkafe] Development of accounting solution

Hi Roman,
I think it's a good idea, I must warn you though - I had one in the
older direqcafe versions, it was the hardest part of the code to
maintain, you can write it any way you want - but I think if you build
it into outkafe as a new feature set you will be able to achieve more
over-all, and can use the outkafe library directly rather than having to
rely on plugin calls.

I am happy to support you in the process, but I must say that I
basically considder outkafe a completed product and I'm only doing
crucial maintainance on it now, my focus is on kongoni and it's using up
every spare moment I have. 
I would love to see outkafe continue, but I just don't have the time
myself anymore, ideally somebody would take over the project as a whole
and see it into the future, with new and fresh ideas, but in the
meantime, I'll fix critical bugs and help out people like you trying to
expand it.


Ciao
A.J.
On Mon, Jun 22, 2009 at 11:49 AM, Roman Meier <rom...@gi...>
wrote:
Hi list

I would like to develop a simple accounting solution for outkafe that
can be used by anybody using outkafe.

I intend to use the existing outkafe postgresql database to store the
data. Therefore I can add another table to it. The columns may be:

Id: 4319
Staff: felix
Time: 11:3:7
Date: Sun Feb 1 2009
Units: 50
Username: nketsiah

Should I develop a perl plugin for outkafe or should I integrate the
code directly into outkafe using lazarus?

I need a list with basic requirements / ideas that should be
implemented?

I need some feedback to make sure that I'm choosing the right direction.

Kind regards,
Roman


------------------------------------------------------------------------
------
Are you an open source citizen? Join us for the Open Source Bridge
conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference:
$250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebrid
ge.org
_______________________________________________

OutKafe MailingList.
MailingList Options:
https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
OutKafe Website/WIKI:
http://outkafe.outkastsolutions.co.za



-- 
A.J. Venter
Tel.: +27 21 554 5059
Fax: +27 11 252 9197
Outkast Solutions IT
www.outkastsolutions.co.za
A division of Global Pact Trading Pty Ltd.

www.silentcoder.co.za - Blog
scartoonz.silentcoder.co.za - ScarToonz webcomic

Hi A.J.

Thanks for your support !

Good, I'll integrate the code into Outkafe then.

Please feel free to submit your requirements.

Kind regards,
Roman

-----Ursprüngliche Nachricht-----
Von: A.J. Venter [mailto:aj...@ou...] 
Gesendet: Montag, 22. Juni 2009 09:56
An: User discussion and support list.
Betreff: Re: [outkafe] Development of accounting solution

Hi Roman,
I think it's a good idea, I must warn you though - I had one in the
older direqcafe versions, it was the hardest part of the code to
maintain, you can write it any way you want - but I think if you build
it into outkafe as a new feature set you will be able to achieve more
over-all, and can use the outkafe library directly rather than having to
rely on plugin calls.

I am happy to support you in the process, but I must say that I
basically considder outkafe a completed product and I'm only doing
crucial maintainance on it now, my focus is on kongoni and it's using up
every spare moment I have. 
I would love to see outkafe continue, but I just don't have the time
myself anymore, ideally somebody would take over the project as a whole
and see it into the future, with new and fresh ideas, but in the
meantime, I'll fix critical bugs and help out people like you trying to
expand it.


Ciao
A.J.
On Mon, Jun 22, 2009 at 11:49 AM, Roman Meier <rom...@gi...>
wrote:
Hi list

I would like to develop a simple accounting solution for outkafe that
can be used by anybody using outkafe.

I intend to use the existing outkafe postgresql database to store the
data. Therefore I can add another table to it. The columns may be:

Id: 4319
Staff: felix
Time: 11:3:7
Date: Sun Feb 1 2009
Units: 50
Username: nketsiah

Should I develop a perl plugin for outkafe or should I integrate the
code directly into outkafe using lazarus?

I need a list with basic requirements / ideas that should be
implemented?

I need some feedback to make sure that I'm choosing the right direction.

Kind regards,
Roman


------------------------------------------------------------------------
------
Are you an open source citizen? Join us for the Open Source Bridge
conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference:
$250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebrid
ge.org
_______________________________________________

OutKafe MailingList.
MailingList Options:
https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
OutKafe Website/WIKI:
http://outkafe.outkastsolutions.co.za



-- 
A.J. Venter
Tel.: +27 21 554 5059
Fax: +27 11 252 9197
Outkast Solutions IT
www.outkastsolutions.co.za
A division of Global Pact Trading Pty Ltd.

www.silentcoder.co.za - Blog
scartoonz.silentcoder.co.za - ScarToonz webcomic

Hi Roman,
I think it's a good idea, I must warn you though - I had one in the older
direqcafe versions, it was the hardest part of the code to maintain, you can
write it any way you want - but I think if you build it into outkafe as a
new feature set you will be able to achieve more over-all, and can use the
outkafe library directly rather than having to rely on plugin calls.

I am happy to support you in the process, but I must say that I basically
considder outkafe a completed product and I'm only doing crucial
maintainance on it now, my focus is on kongoni and it's using up every spare
moment I have.
I would love to see outkafe continue, but I just don't have the time myself
anymore, ideally somebody would take over the project as a whole and see it
into the future, with new and fresh ideas, but in the meantime, I'll fix
critical bugs and help out people like you trying to expand it.


Ciao
A.J.

On Mon, Jun 22, 2009 at 11:49 AM, Roman Meier <rom...@gi...> wrote:

> Hi list
>
> I would like to develop a simple accounting solution for outkafe that
> can be used by anybody using outkafe.
>
> I intend to use the existing outkafe postgresql database to store the
> data. Therefore I can add another table to it. The columns may be:
>
> Id: 4319
> Staff: felix
> Time: 11:3:7
> Date: Sun Feb 1 2009
> Units: 50
> Username: nketsiah
>
> Should I develop a perl plugin for outkafe or should I integrate the
> code directly into outkafe using lazarus?
>
> I need a list with basic requirements / ideas that should be
> implemented?
>
> I need some feedback to make sure that I'm choosing the right direction.
>
> Kind regards,
> Roman
>
>
>
> ------------------------------------------------------------------------------
> Are you an open source citizen? Join us for the Open Source Bridge
> conference!
> Portland, OR, June 17-19. Two days of sessions, one day of unconference:
> $250.
> Need another reason to go? 24-hour hacker lounge. Register today!
>
> http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
> _______________________________________________
>
> OutKafe MailingList.
> MailingList Options:
> https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
> OutKafe Website/WIKI:
> http://outkafe.outkastsolutions.co.za
>



-- 
A.J. Venter
Tel.: +27 21 554 5059
Fax: +27 11 252 9197
Outkast Solutions IT
www.outkastsolutions.co.za
A division of Global Pact Trading Pty Ltd.

www.silentcoder.co.za - Blog
scartoonz.silentcoder.co.za - ScarToonz webcomic

Hi list

I would like to develop a simple accounting solution for outkafe that
can be used by anybody using outkafe.

I intend to use the existing outkafe postgresql database to store the
data. Therefore I can add another table to it. The columns may be:

Id: 4319
Staff: felix
Time: 11:3:7
Date: Sun Feb 1 2009
Units: 50
Username: nketsiah

Should I develop a perl plugin for outkafe or should I integrate the
code directly into outkafe using lazarus? 

I need a list with basic requirements / ideas that should be
implemented?

I need some feedback to make sure that I'm choosing the right direction.

Kind regards,
Roman

Hi A.J.

I'm not really convinced that writing out sales to a file is the right
approach. It's a simple solution, but not a good one.

Imho, using a database is a better approach and since we have a working
database (postgresql) we can make good use of it.

Can't we develop a postgresql-based solution?

However, I like to share my code. It may be of use to somebody:

Perlscript:
***********

#!/usr/bin/perl

#**********************************
#launch plugin
#perl /home/outkafe/ok-account.pl %PARAMETER2% %PARAMETER1%
#**********************************

#use warnings;
#use strict;

#declaration variables
	my $username;
	my $numunits;
	my $logfile;
	my $time;
	my $staff;
#end declaration variables

#read parameters
	$numunits=$ARGV[0];
	$username=$ARGV[1];
#end read parameters

#
#extraction of actual time
#
sub ext_time {
	@months = qw(Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec);
	@weekDays = qw(Sun Mon Tue Wed Thu Fri Sat Sun);
	($second, $minute, $hour, $dayOfMonth, $month, $yearOffset,
$dayOfWeek, $dayOfYear, $daylightSavings) = localtime();
	$year = 1900 + $yearOffset;
	$time = "$hour:$minute:$second, $weekDays[$dayOfWeek]
$months[$month] $dayOfMonth, $year";	
}

#
#count lines
#
sub count {
	open(OK, "< $logfile") or die "can't open $logfile: $!";
	$anz_zeilen = 0;
	while (<OK>) {
		$anz_zeilen++
	}
	#print $anz_zeilen;
	close(OK) or die "can't close $logfile: $!";
}

#
#write ok-log.txt
#
$logfile = "/home/log/ok-log.txt";
&count;		#count rows
&ext_time;	#extract time
#$staff = getlogin();
$staff = (getpwuid($<))[0];
open (HT, ">>$logfile") or die "Cannot open $logfile: $!";	
	print HT $anz_zeilen . ", " . $staff . ", " . $time . ", " .
$numunits . " units, " . $username . "\n";
close(HT);


Extract of ok-log.txt:
**********************

4319, felix, 11:3:7, Sun Feb 1, 2009, 50 units, nketsiah
4320, felix, 11:24:37, Sun Feb 1, 2009, 30 units, bigbone
4321, felix, 11:27:2, Sun Feb 1, 2009, 20 units, alfred
4322, felix, 11:42:2, Sun Feb 1, 2009, 20 units, tandoh
4323, felix, 11:49:20, Sun Feb 1, 2009, 50 units, nketsiah
4324, felix, 11:49:29, Sun Feb 1, 2009, 10 units, unknown


Kind regards,
Roman

-----Ursprüngliche Nachricht-----
Von: A.J. Venter [mailto:aj...@ou...] 
Gesendet: Freitag, 19. Juni 2009 11:19
An: User discussion and support list.
Betreff: Re: [outkafe] Accounting Plugin

Hi Roman,
I'm not aware of others that are public, but if you send me a few random
lines from your file, I can write you a script to automate the tallying
- depending on the format and layout I should add.

Ciao
A.J.

On Fri, Jun 19, 2009 at 1:12 PM, Roman Meier <rom...@gi...>
wrote:
Hi list

I wrote a short perl script that does nothing else than to write every
sale made to a file. At the end of the day I calculate the total of the
sales based on all entries in the file. That's how we do the accounts.

I'm not very happy with this solution, mainly because of the human
factor involved (mistakes in calculating the sum). I'm looking for a
more convenient and save solution to calculate daily sales.

Is there a plugin out there which can help us improving our accounting
solution?

Kind regards,
Roman


------------------------------------------------------------------------
------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________

OutKafe MailingList.
MailingList Options:
https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
OutKafe Website/WIKI:
http://outkafe.outkastsolutions.co.za



-- 
A.J. Venter
Tel.: +27 21 554 5059
Fax: +27 11 252 9197
Outkast Solutions IT
www.outkastsolutions.co.za
A division of Global Pact Trading Pty Ltd.

www.silentcoder.co.za - Blog
scartoonz.silentcoder.co.za - ScarToonz webcomic

Hi Roman,I'm not aware of others that are public, but if you send me a few
random lines from your file, I can write you a script to automate the
tallying - depending on the format and layout I should add.

Ciao
A.J.

On Fri, Jun 19, 2009 at 1:12 PM, Roman Meier <rom...@gi...> wrote:

> Hi list
>
> I wrote a short perl script that does nothing else than to write every
> sale made to a file. At the end of the day I calculate the total of the
> sales based on all entries in the file. That's how we do the accounts.
>
> I'm not very happy with this solution, mainly because of the human
> factor involved (mistakes in calculating the sum). I'm looking for a
> more convenient and save solution to calculate daily sales.
>
> Is there a plugin out there which can help us improving our accounting
> solution?
>
> Kind regards,
> Roman
>
>
>
> ------------------------------------------------------------------------------
> Crystal Reports - New Free Runtime and 30 Day Trial
> Check out the new simplified licensing option that enables unlimited
> royalty-free distribution of the report engine for externally facing
> server and web deployment.
> http://p.sf.net/sfu/businessobjects
> _______________________________________________
>
> OutKafe MailingList.
> MailingList Options:
> https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
> OutKafe Website/WIKI:
> http://outkafe.outkastsolutions.co.za
>



-- 
A.J. Venter
Tel.: +27 21 554 5059
Fax: +27 11 252 9197
Outkast Solutions IT
www.outkastsolutions.co.za
A division of Global Pact Trading Pty Ltd.

www.silentcoder.co.za - Blog
scartoonz.silentcoder.co.za - ScarToonz webcomic

Hi list

I wrote a short perl script that does nothing else than to write every
sale made to a file. At the end of the day I calculate the total of the
sales based on all entries in the file. That's how we do the accounts.

I'm not very happy with this solution, mainly because of the human
factor involved (mistakes in calculating the sum). I'm looking for a
more convenient and save solution to calculate daily sales.

Is there a plugin out there which can help us improving our accounting
solution?

Kind regards,
Roman

Hi

I was very sure I tried that. Works perfectly!

Thanks A.J.

-----Ursprüngliche Nachricht-----
Von: A.J. Venter [mailto:ajv...@gm...] 
Gesendet: Sonntag, 14. Juni 2009 07:47
An: User discussion and support list.
Betreff: Re: [outkafe] Launch plugin without xterm pop up?

Sure - you should be able to just leave the xterm -e out, I merely use
that as an example in the docs, there is no reason you HAVE to use a
terminal - unless your plugin itself depends on it.

You won't be able to see it running, but you should be able to see
that it did from the changes to the file.

Ciao
A.J.

On Sat, Jun 13, 2009 at 7:35 PM, Roman Meier<rom...@gi...>
wrote:
> Hi list
>
>
>
> I use the following plugin command anytime a sale is made: xterm –e
perl
> sale.pl %par...
>
> The perl script does nothing else than to write a sale to a file.
>
>
>
> I’m not really happy with this solution, because my xterm-command
always
> opens a terminal window for a short time and closes it again. Is there
a way
> to launch the plugin in the background, so that no terminal window
pops up?
>
>
>
> Kind regards,
>
> Roman
>
>
>
>
>
>
------------------------------------------------------------------------
------
> Crystal Reports - New Free Runtime and 30 Day Trial
> Check out the new simplified licensing option that enables unlimited
> royalty-free distribution of the report engine for externally facing
> server and web deployment.
> http://p.sf.net/sfu/businessobjects
> _______________________________________________
>
> OutKafe MailingList.
> MailingList Options:
> https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
> OutKafe Website/WIKI:
> http://outkafe.outkastsolutions.co.za
>



-- 
"Semper in excretum set alta variant" - My father
A.J. Venter - http://www.silentcoder.co.za

------------------------------------------------------------------------
------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________

OutKafe MailingList. 
MailingList Options:
https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
OutKafe Website/WIKI:
http://outkafe.outkastsolutions.co.za

Sure - you should be able to just leave the xterm -e out, I merely use
that as an example in the docs, there is no reason you HAVE to use a
terminal - unless your plugin itself depends on it.

You won't be able to see it running, but you should be able to see
that it did from the changes to the file.

Ciao
A.J.

On Sat, Jun 13, 2009 at 7:35 PM, Roman Meier<rom...@gi...> wrote:
> Hi list
>
>
>
> I use the following plugin command anytime a sale is made: xterm –e perl
> sale.pl %par...
>
> The perl script does nothing else than to write a sale to a file.
>
>
>
> I’m not really happy with this solution, because my xterm-command always
> opens a terminal window for a short time and closes it again. Is there a way
> to launch the plugin in the background, so that no terminal window pops up?
>
>
>
> Kind regards,
>
> Roman
>
>
>
>
>
> ------------------------------------------------------------------------------
> Crystal Reports - New Free Runtime and 30 Day Trial
> Check out the new simplified licensing option that enables unlimited
> royalty-free distribution of the report engine for externally facing
> server and web deployment.
> http://p.sf.net/sfu/businessobjects
> _______________________________________________
>
> OutKafe MailingList.
> MailingList Options:
> https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
> OutKafe Website/WIKI:
> http://outkafe.outkastsolutions.co.za
>



-- 
"Semper in excretum set alta variant" - My father
A.J. Venter - http://www.silentcoder.co.za

Hi list
 
I use the following plugin command anytime a sale is made: xterm -e perl
sale.pl %par...
The perl script does nothing else than to write a sale to a file.
 
I'm not really happy with this solution, because my xterm-command always
opens a terminal window for a short time and closes it again. Is there a
way to launch the plugin in the background, so that no terminal window
pops up?
 
Kind regards,
Roman
 
 

Since this user is only used in postgresql, as long as you keep his
password secure, it's a very low security risk. The outkafe users are
database entries, they have no editing rights.

Ciao
A.J.

On Wed, May 6, 2009 at 8:32 PM, Antonio Cardenes
<ant...@gm...> wrote:
> Ok, sorry for the previous long "looking for help" message. I found where
> was the problem, the user outkafe-user that owns the outkafe database did
> not have enough privileges in postgreSQL, I used pgadminIII to add all the
> privileges to that user. Now the question is: will that be a security
> problem? Could i give that user less privileges and still work?
>
> On Wed, May 6, 2009 at 6:21 PM, Antonio Cardenes
> <ant...@gm...> wrote:
>>
>> Hi, i'm trying to install outkafe in a test server (Kubuntu 9.04) with
>> postgresql 8.3.7.1 and i'm running into an error when i try to start the
>> outkafe admin console.I followed all steps and configured postgresql as
>> instructed in this webpage:
>> http://organicdesign.co.nz/Set_up_an_internet_cafe
>>
>> Thanks
>>
>>
>
>
> ------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK
> i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
>
> OutKafe MailingList.
> MailingList Options:
> https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
> OutKafe Website/WIKI:
> http://outkafe.outkastsolutions.co.za
>



-- 
A.J. Venter
Tel.: +27 21 554 5059
Fax: +27 11 252 9197
Outkast Solutions IT
www.outkastsolutions.co.za
A division of Global Pact Trading Pty Ltd.

www.silentcoder.co.za - Blog
scartoonz.silentcoder.co.za - ScarToonz webcomic

Ok, sorry for the previous long "looking for help" message. I found where
was the problem, the user outkafe-user that owns the outkafe database did
not have enough privileges in postgreSQL, I used pgadminIII to add all the
privileges to that user. Now the question is: will that be a security
problem? Could i give that user less privileges and still work?

On Wed, May 6, 2009 at 6:21 PM, Antonio Cardenes <ant...@gm...
> wrote:

> Hi, i'm trying to install outkafe in a test server (Kubuntu 9.04) with
> postgresql 8.3.7.1 and i'm running into an error when i try to start the
> outkafe admin console.I followed all steps and configured postgresql as
> instructed in this webpage:
> http://organicdesign.co.nz/Set_up_an_internet_cafe
>
> Thanks
>
>
>

The problem here is that your tables are not accessible by the user
you are logging in as.
The sollution is to log in with a postgresql client and grant the
right permissions.
GRANT ALL ON settings TO username;
Repeat for all tables.

Ciao
A.J.

On Wed, May 6, 2009 at 7:21 PM, Antonio Cardenes
<ant...@gm...> wrote:
> Hi, i'm trying to install outkafe in a test server (Kubuntu 9.04) with
> postgresql 8.3.7.1 and i'm running into an error when i try to start the
> outkafe admin console.I followed all steps and configured postgresql as
> instructed in this webpage:
> http://organicdesign.co.nz/Set_up_an_internet_cafe
>
> Thanks
>
> Here the error output:
>
> master@kserver:~$
> outkafe
> [WARNING] Out of OEM specific VK codes, changing to
> unassigned
> [WARNING] Out of unassigned VK codes, assigning
> $FF
> SELECT * FROM
> settings;
> ERROR:  permission denied for relation
> settings
>
> PGRES_FATAL_ERROR
> You have no stored site-settings.
> Setting all to defaults
> INSERT INTO settings VALUES("$","1","1,''");
> INSERT INTO settings VALUES("$","1","1,''");
> ERROR:  column "$" does not exist at character 29
>
> PGRES_FATAL_ERROR
> SELECT command FROM serverplugins WHERE trigger = 'oninitsettings';
> ERROR:  permission denied for relation serverplugins
>
> PGRES_FATAL_ERROR
> SELECT command FROM serverplugins WHERE trigger = 'onloadsettings';
> ERROR:  permission denied for relation serverplugins
>
> PGRES_FATAL_ERROR
> UPDATE settings SET currencysymbol = '$',unitlength = '1',priceperunit =
> '1';
> ERROR:  permission denied for relation settings
>
> PGRES_FATAL_ERROR
> SELECT command FROM serverplugins WHERE trigger = 'onsavesettings';
> ERROR:  permission denied for relation serverplugins
>
> PGRES_FATAL_ERROR
> SELECT name FROM serverplugins;
> ERROR:  permission denied for relation serverplugins
>
> PGRES_FATAL_ERROR
> SELECT description FROM offers;
> ERROR:  permission denied for relation offers
>
> PGRES_FATAL_ERROR
> SELECT username,status,machine,units FROM login WHERE status = 'Logged in'
> ORDER BY username
> ASC;
> ERROR:  permission denied for relation
> login
>
> PGRES_FATAL_ERROR
> SetViewStyle
>  Gtk2_ItemSelectionChanged  ItemChache=nil ListView1
>  Gtk2_ItemSelectionChanged  ItemChache=nil ListView1
>  Gtk2_ItemSelectionChanged  ItemChache=nil ListView1
>  Gtk2_ItemSelectionChanged  ItemChache=nil ListView1
>
> (outkafe:6845): GLib-GObject-WARNING **:
> /build/buildd/glib2.0-2.20.1/gobject/gsignal.c:2270: signal `enter' is
> invalid for instance `0x8ef2de8'
>
> (outkafe:6845): GLib-GObject-WARNING **:
> /build/buildd/glib2.0-2.20.1/gobject/gsignal.c:2270: signal `leave' is
> invalid for instance `0x8ef2de8'
>
> (outkafe:6845): GLib-GObject-WARNING **:
> /build/buildd/glib2.0-2.20.1/gobject/gsignal.c:2270: signal `enter' is
> invalid for instance `0x8ef2ea8'
>
> (outkafe:6845): GLib-GObject-WARNING **:
> /build/buildd/glib2.0-2.20.1/gobject/gsignal.c:2270: signal `leave' is
> invalid for instance `0x8ef2ea8'
> SELECT * FROM
> settings;
> ERROR:  permission denied for relation
> settings
>
> PGRES_FATAL_ERROR
> You have no stored site-settings.
> Setting all to defaults
> INSERT INTO settings VALUES("$","1","1,''");
> INSERT INTO settings VALUES("$","1","1,''");
> ERROR:  column "$" does not exist at character 29
>
> PGRES_FATAL_ERROR
> SELECT command FROM serverplugins WHERE trigger = 'oninitsettings';
> ERROR:  permission denied for relation serverplugins
>
> PGRES_FATAL_ERROR
> SELECT command FROM serverplugins WHERE trigger = 'onloadsettings';
> ERROR:  permission denied for relation serverplugins
>
> PGRES_FATAL_ERROR
> SELECT adminpw FROM settings;
> ERROR:  permission denied for relation settings
>
> PGRES_FATAL_ERROR
> row number 0 is out of range 0..-1
> UPDATE settings SET adminpw = '90ba96424533fbe8a7401a71fa785c64';
> ERROR:  permission denied for relation settings
>
> PGRES_FATAL_ERROR
> SELECT command FROM serverplugins WHERE trigger = 'onsetadminpassword';
> ERROR:  permission denied for relation serverplugins
>
> PGRES_FATAL_ERROR
> SELECT * FROM settings;
> ERROR:  permission denied for relation settings
>
> PGRES_FATAL_ERROR
> You have no stored site-settings.
> Setting all to defaults
> INSERT INTO settings VALUES("$","1","1,''");
> INSERT INTO settings VALUES("$","1","1,''");
> ERROR:  column "$" does not exist at character 29
>
> PGRES_FATAL_ERROR
> SELECT command FROM serverplugins WHERE trigger = 'oninitsettings';
> ERROR:  permission denied for relation serverplugins
>
> PGRES_FATAL_ERROR
> SELECT command FROM serverplugins WHERE trigger = 'onloadsettings';
> ERROR:  permission denied for relation serverplugins
>
> PGRES_FATAL_ERROR
> SELECT adminpw FROM settings;
> ERROR:  permission denied for relation settings
>
> PGRES_FATAL_ERROR
> row number 0 is out of range 0..-1
> TIpFileDataProvider.CanHandle(file:///usr/share/outkafe/about.html)
> TIpCustomHtmlDataProvider.BuildURL Old=""
> new="file:///usr/share/outkafe/about.html"
> TIpFileDataProvider.CanHandle FN="/usr/share/outkafe/about.html"
> IpUtils.GetLocalContent File:/usr/share/outkafe/about.html Result:text/html
> TIpCustomHtmlDataProvider.BuildURL Old=""
> new="file:///usr/share/outkafe/about.html"
> IpUtils.GetLocalContent File:/usr/share/outkafe/about.html Result:text/html
> TApplication.HandleException Access violation
>   Stack trace:
>   $B6EAD4AB
>   $B6EB196A
>   $B7CA6ECE
>   $0820526D
>   $0815FEB0
>   $0815F809
>   $08145404
>   $080678B9
>   $0813D578
>   $08134BB7
>   $0813497B
>   $08137B02
>   $080678B9
>   $081357C9
>   $081ECE45
>   $081F6D73
>   $081F7510
> exception at B6EAD4AB:
> Access violation.
>
>
> ------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK
> i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
>
> OutKafe MailingList.
> MailingList Options:
> https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
> OutKafe Website/WIKI:
> http://outkafe.outkastsolutions.co.za
>



-- 
A.J. Venter
Tel.: +27 21 554 5059
Fax: +27 11 252 9197
Outkast Solutions IT
www.outkastsolutions.co.za
A division of Global Pact Trading Pty Ltd.

www.silentcoder.co.za - Blog
scartoonz.silentcoder.co.za - ScarToonz webcomic

Hi, i'm trying to install outkafe in a test server (Kubuntu 9.04) with
postgresql 8.3.7.1 and i'm running into an error when i try to start the
outkafe admin console.I followed all steps and configured postgresql as
instructed in this webpage:
http://organicdesign.co.nz/Set_up_an_internet_cafe

Thanks

Here the error output:

master@kserver:~$
outkafe
[WARNING] Out of OEM specific VK codes, changing to
unassigned
[WARNING] Out of unassigned VK codes, assigning
$FF
SELECT * FROM
settings;
ERROR:  permission denied for relation
settings

PGRES_FATAL_ERROR
You have no stored site-settings.
Setting all to defaults
INSERT INTO settings VALUES("$","1","1,''");
INSERT INTO settings VALUES("$","1","1,''");
ERROR:  column "$" does not exist at character 29

PGRES_FATAL_ERROR
SELECT command FROM serverplugins WHERE trigger = 'oninitsettings';
ERROR:  permission denied for relation serverplugins

PGRES_FATAL_ERROR
SELECT command FROM serverplugins WHERE trigger = 'onloadsettings';
ERROR:  permission denied for relation serverplugins

PGRES_FATAL_ERROR
UPDATE settings SET currencysymbol = '$',unitlength = '1',priceperunit =
'1';
ERROR:  permission denied for relation settings


PGRES_FATAL_ERROR
SELECT command FROM serverplugins WHERE trigger = 'onsavesettings';
ERROR:  permission denied for relation serverplugins

PGRES_FATAL_ERROR
SELECT name FROM serverplugins;
ERROR:  permission denied for relation serverplugins

PGRES_FATAL_ERROR
SELECT description FROM offers;
ERROR:  permission denied for relation offers

PGRES_FATAL_ERROR
SELECT username,status,machine,units FROM login WHERE status = 'Logged in'
ORDER BY username
ASC;
ERROR:  permission denied for relation
login

PGRES_FATAL_ERROR
SetViewStyle
 Gtk2_ItemSelectionChanged  ItemChache=nil ListView1
 Gtk2_ItemSelectionChanged  ItemChache=nil ListView1
 Gtk2_ItemSelectionChanged  ItemChache=nil ListView1
 Gtk2_ItemSelectionChanged  ItemChache=nil ListView1

(outkafe:6845): GLib-GObject-WARNING **:
/build/buildd/glib2.0-2.20.1/gobject/gsignal.c:2270: signal `enter' is
invalid for instance `0x8ef2de8'

(outkafe:6845): GLib-GObject-WARNING **:
/build/buildd/glib2.0-2.20.1/gobject/gsignal.c:2270: signal `leave' is
invalid for instance `0x8ef2de8'

(outkafe:6845): GLib-GObject-WARNING **:
/build/buildd/glib2.0-2.20.1/gobject/gsignal.c:2270: signal `enter' is
invalid for instance `0x8ef2ea8'

(outkafe:6845): GLib-GObject-WARNING **:
/build/buildd/glib2.0-2.20.1/gobject/gsignal.c:2270: signal `leave' is
invalid for instance `0x8ef2ea8'
SELECT * FROM
settings;
ERROR:  permission denied for relation
settings

PGRES_FATAL_ERROR
You have no stored site-settings.
Setting all to defaults
INSERT INTO settings VALUES("$","1","1,''");
INSERT INTO settings VALUES("$","1","1,''");
ERROR:  column "$" does not exist at character 29

PGRES_FATAL_ERROR
SELECT command FROM serverplugins WHERE trigger = 'oninitsettings';
ERROR:  permission denied for relation serverplugins

PGRES_FATAL_ERROR
SELECT command FROM serverplugins WHERE trigger = 'onloadsettings';
ERROR:  permission denied for relation serverplugins

PGRES_FATAL_ERROR
SELECT adminpw FROM settings;
ERROR:  permission denied for relation settings

PGRES_FATAL_ERROR
row number 0 is out of range 0..-1
UPDATE settings SET adminpw = '90ba96424533fbe8a7401a71fa785c64';
ERROR:  permission denied for relation settings

PGRES_FATAL_ERROR
SELECT command FROM serverplugins WHERE trigger = 'onsetadminpassword';
ERROR:  permission denied for relation serverplugins

PGRES_FATAL_ERROR
SELECT * FROM settings;
ERROR:  permission denied for relation settings

PGRES_FATAL_ERROR
You have no stored site-settings.
Setting all to defaults
INSERT INTO settings VALUES("$","1","1,''");
INSERT INTO settings VALUES("$","1","1,''");
ERROR:  column "$" does not exist at character 29

PGRES_FATAL_ERROR
SELECT command FROM serverplugins WHERE trigger = 'oninitsettings';
ERROR:  permission denied for relation serverplugins

PGRES_FATAL_ERROR
SELECT command FROM serverplugins WHERE trigger = 'onloadsettings';
ERROR:  permission denied for relation serverplugins

PGRES_FATAL_ERROR
SELECT adminpw FROM settings;
ERROR:  permission denied for relation settings

PGRES_FATAL_ERROR
row number 0 is out of range 0..-1
TIpFileDataProvider.CanHandle(file:///usr/share/outkafe/about.html)
TIpCustomHtmlDataProvider.BuildURL Old=""
new="file:///usr/share/outkafe/about.html"
TIpFileDataProvider.CanHandle FN="/usr/share/outkafe/about.html"
IpUtils.GetLocalContent File:/usr/share/outkafe/about.html Result:text/html
TIpCustomHtmlDataProvider.BuildURL Old=""
new="file:///usr/share/outkafe/about.html"
IpUtils.GetLocalContent File:/usr/share/outkafe/about.html Result:text/html
TApplication.HandleException Access violation
  Stack trace:
  $B6EAD4AB
  $B6EB196A
  $B7CA6ECE
  $0820526D
  $0815FEB0
  $0815F809
  $08145404
  $080678B9
  $0813D578
  $08134BB7
  $0813497B
  $08137B02
  $080678B9
  $081357C9
  $081ECE45
  $081F6D73
  $081F7510
exception at B6EAD4AB:
Access violation.

Hi list

I’m running an internetcafé using outkafe and linux ubuntu 7.10 which is
using gnome as desktop interface.

I experienced problems with customers who are using keyboard shortcuts
to bypass the outkafe interface. There are some measures you can take to
avoid misuse of that kind. I would like to share some of the measures
with the list.

I recommend the installation of a window manager like devilspie. You
will find more information about it in this forum and on the website of
devilspie.

I recommend to deactivate all keyboard shortcuts in the user profile.
Popular keyboard shortcuts for bypassing outkafe are f. e. ctrl-alt-esc
or alt-f9. You can deactivate many keyboard shortcuts under system ->
preferences -> keyboard shortcuts. Some keyboard shortcuts remain
active! You can verify the settings with gconf-editor. You can launch it
using a terminal. Go to /apps/metacity and remove remaining keyboard
shortcuts.

User keyboard shortcuts are stored in ~/.gconf/apps/metacity. If you
copy this folder on every client you can save some time.

I also changed access rights to the app which is allowing changes of
keyboard shortcuts. “chmod 754 /user/bin/gnome-keybinding-properities”
will do in most cases I guess.

I hope, these measures are helping some of the users of outkafe!
Outkafe is cool!

Kind regards,
Roman

Hi A.J.

If not pclos, which linux distribution can you recommend now?

Kind regards,
Roman

-----Ursprüngliche Nachricht-----
Von: A.J. Venter [mailto:ajv...@gm...] 
Gesendet: Dienstag, 10. März 2009 08:57
An: User discussion and support list.
Betreff: Re: [outkafe] Pclinuxos 2007

> Hi A.J.
>
> Thanks for your feedback.
>
> How is your experience using kongoni with outkafe?
>
> Kind regards
> Roman

Haven't tried it yet, in fact I haven't tried outkafe under KDE4 yet.

Ciao
A.J.

-- 
"Semper in excretum set alta variant" - My father
A.J. Venter - http://www.silentcoder.co.za

------------------------------------------------------------------------
------
_______________________________________________

OutKafe MailingList. 
MailingList Options:
https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
OutKafe Website/WIKI:
http://outkafe.outkastsolutions.co.za

Hi list

This topic is quite important for anybody running an internet café.

Is there nobody who can share experience?

Kind regards,
Roman

-----Ursprüngliche Nachricht-----
Von: Roman Meier [mailto:rom...@gi...] 
Gesendet: Montag, 9. März 2009 12:35
An: aki...@li...
Betreff: [outkafe] Outkafe and accounting

Hi list

Outkafe itself doesn't provide any accounting functionalities. That's
why I wrote a small script which writes some basic data to a logfile
always when time is sold to a customer. This can easily be done using
the plugin functionalities of outkafe. Based on that logfile, the staff
is calculating the daily sales.

I'm not really happy with that "home made" solution. I'm looking for
something more professional. I'm not aware of any accounting solution
that can easily work together with outkafe.

What do you suggest?

Kind regards,
Roman


------------------------------------------------------------------------
------
Open Source Business Conference (OSBC), March 24-25, 2009, San
Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the
Enterprise
-Strategies to boost innovation and cut costs with open source
participation
-Receive a $600 discount off the registration fee with the source code:
SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________

OutKafe MailingList. 
MailingList Options:
https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
OutKafe Website/WIKI:
http://outkafe.outkastsolutions.co.za

> Hi A.J.
>
> Thanks for your feedback.
>
> How is your experience using kongoni with outkafe?
>
> Kind regards
> Roman

Haven't tried it yet, in fact I haven't tried outkafe under KDE4 yet.

Ciao
A.J.

-- 
"Semper in excretum set alta variant" - My father
A.J. Venter - http://www.silentcoder.co.za

Hi A.J.

Thanks for your feedback.

How is your experience using kongoni with outkafe?

Kind regards
Roman

-----Ursprüngliche Nachricht-----
Von: A.J. Venter [mailto:ajv...@gm...] 
Gesendet: Montag, 9. März 2009 22:30
An: User discussion and support list.
Betreff: Re: [outkafe] Pclinuxos 2007

Hi,
Well I made that reccomendation early in 2008 when PCLOS2007 was new.
At this stage, the 2007 repo's are in dissarray because 2009 is in
it's final beta and will be replacing it soon.

I'm no longer using it myself, I'm using kongoni.

Ciao
A.J.


On Mon, Mar 9, 2009 at 11:47 PM, Roman Meier <rom...@gi...>
wrote:
> Hi list
>
> I hear so many good things about pclinuxos 2007, being the best to use
> with oukafe and so...
>
> I can't confirm that at all!!! I think that the pclinuxos people
really
> messed things up with poor maintenance of their repository.
>
> A good example is the script that A.J. is providing for the
installation
> of quasar accounting. Pclinuxos is supposed to update (if necessairy)
> all related libraries. However, pclinuxos is definitely updating many
> libraries (maybe 100 of them). By doing so, it creates a real mess and
> kde is not starting again after rebooting. I also noticed missing
> dependencies.
>
> The installation of quasar is just one example. Here some more:
>
> - Pidgin: Wont start after installation because of missing
dependencies
> - Update of gtk: Synaptic an many more applications won't start again
> - Cheese: Wont start after installation because of missing
dependencies
>
> What is this mess? I admit that I'm a pclinuxos greenhorn, but I'm
quite
> used to work with repositories. To use repositories is simply very
> convenient. I do it very often on Ubuntu 7.10.
>
> However, I wish to get some feedback from you on pclinuxos 2007. Is
> there something basic I missunderstood? Can someone confirm my
> experience?
>
> Kind regards,
> Roman
>
>
>
------------------------------------------------------------------------
------
> Open Source Business Conference (OSBC), March 24-25, 2009, San
Francisco, CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the
Enterprise
> -Strategies to boost innovation and cut costs with open source
participation
> -Receive a $600 discount off the registration fee with the source
code: SFAD
> http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
>
> OutKafe MailingList.
> MailingList Options:
https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
> OutKafe Website/WIKI:
> http://outkafe.outkastsolutions.co.za
>



-- 
"Semper in excretum set alta variant" - My father
A.J. Venter - http://www.silentcoder.co.za

------------------------------------------------------------------------
------
Open Source Business Conference (OSBC), March 24-25, 2009, San
Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the
Enterprise
-Strategies to boost innovation and cut costs with open source
participation
-Receive a $600 discount off the registration fee with the source code:
SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________

OutKafe MailingList. 
MailingList Options:
https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
OutKafe Website/WIKI:
http://outkafe.outkastsolutions.co.za

Hi,
Well I made that reccomendation early in 2008 when PCLOS2007 was new.
At this stage, the 2007 repo's are in dissarray because 2009 is in
it's final beta and will be replacing it soon.

I'm no longer using it myself, I'm using kongoni.

Ciao
A.J.


On Mon, Mar 9, 2009 at 11:47 PM, Roman Meier <rom...@gi...> wrote:
> Hi list
>
> I hear so many good things about pclinuxos 2007, being the best to use
> with oukafe and so...
>
> I can't confirm that at all!!! I think that the pclinuxos people really
> messed things up with poor maintenance of their repository.
>
> A good example is the script that A.J. is providing for the installation
> of quasar accounting. Pclinuxos is supposed to update (if necessairy)
> all related libraries. However, pclinuxos is definitely updating many
> libraries (maybe 100 of them). By doing so, it creates a real mess and
> kde is not starting again after rebooting. I also noticed missing
> dependencies.
>
> The installation of quasar is just one example. Here some more:
>
> - Pidgin: Wont start after installation because of missing dependencies
> - Update of gtk: Synaptic an many more applications won't start again
> - Cheese: Wont start after installation because of missing dependencies
>
> What is this mess? I admit that I'm a pclinuxos greenhorn, but I'm quite
> used to work with repositories. To use repositories is simply very
> convenient. I do it very often on Ubuntu 7.10.
>
> However, I wish to get some feedback from you on pclinuxos 2007. Is
> there something basic I missunderstood? Can someone confirm my
> experience?
>
> Kind regards,
> Roman
>
>
> ------------------------------------------------------------------------------
> Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
> -Strategies to boost innovation and cut costs with open source participation
> -Receive a $600 discount off the registration fee with the source code: SFAD
> http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
>
> OutKafe MailingList.
> MailingList Options: https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe
> OutKafe Website/WIKI:
> http://outkafe.outkastsolutions.co.za
>



-- 
"Semper in excretum set alta variant" - My father
A.J. Venter - http://www.silentcoder.co.za

Hi list

I hear so many good things about pclinuxos 2007, being the best to use
with oukafe and so...

I can't confirm that at all!!! I think that the pclinuxos people really
messed things up with poor maintenance of their repository.

A good example is the script that A.J. is providing for the installation
of quasar accounting. Pclinuxos is supposed to update (if necessairy)
all related libraries. However, pclinuxos is definitely updating many
libraries (maybe 100 of them). By doing so, it creates a real mess and
kde is not starting again after rebooting. I also noticed missing
dependencies.

The installation of quasar is just one example. Here some more:

- Pidgin: Wont start after installation because of missing dependencies
- Update of gtk: Synaptic an many more applications won't start again
- Cheese: Wont start after installation because of missing dependencies

What is this mess? I admit that I'm a pclinuxos greenhorn, but I'm quite
used to work with repositories. To use repositories is simply very
convenient. I do it very often on Ubuntu 7.10.

However, I wish to get some feedback from you on pclinuxos 2007. Is
there something basic I missunderstood? Can someone confirm my
experience?

Kind regards,
Roman