akinimod-direqcafe Mailing List for AKINIMOD Linux
Status: Alpha
Brought to you by:
datadictator
Menu
▾
▴
akinimod-direqcafe — DireqCafe Discussion and Support
You can subscribe to this list here.
| 2004 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(6) |
Jun
(16) |
Jul
|
Aug
(22) |
Sep
|
Oct
(41) |
Nov
(16) |
Dec
(13) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2005 |
Jan
(7) |
Feb
|
Mar
(6) |
Apr
(3) |
May
(10) |
Jun
(13) |
Jul
(7) |
Aug
|
Sep
(4) |
Oct
(19) |
Nov
(13) |
Dec
(1) |
| 2006 |
Jan
(4) |
Feb
|
Mar
(5) |
Apr
(7) |
May
(1) |
Jun
(7) |
Jul
|
Aug
(3) |
Sep
(2) |
Oct
(6) |
Nov
(4) |
Dec
|
| 2007 |
Jan
|
Feb
(1) |
Mar
(4) |
Apr
(12) |
May
(27) |
Jun
(22) |
Jul
(9) |
Aug
(23) |
Sep
(10) |
Oct
(20) |
Nov
(6) |
Dec
(5) |
| 2008 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
(2) |
Jun
|
Jul
|
Aug
(3) |
Sep
|
Oct
|
Nov
(5) |
Dec
|
| 2009 |
Jan
(2) |
Feb
(9) |
Mar
(12) |
Apr
|
May
(4) |
Jun
(22) |
Jul
(14) |
Aug
|
Sep
|
Oct
(2) |
Nov
|
Dec
|
| 2010 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Anton <an...@sn...> - 2010-05-12 10:36:53
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head><title></title>
<META http-equiv=Content-Type content="text/html; charset=windows-1251">
<meta http-equiv="Content-Style-Type" content="text/css">
<style type="text/css"><!--
body {
margin: 5px 5px 5px 5px;
background-color: #ffffff;
}
/* ---------- Text Styles ---------- */
hr { color: #000000}
body, table /* Normal text */
{
font-size: 9pt;
font-family: 'Courier New';
font-style: normal;
font-weight: normal;
color: #000000;
text-decoration: none;
}
span.rvts1 /* Heading */
{
font-size: 10pt;
font-family: 'Arial';
font-weight: bold;
color: #0000ff;
}
span.rvts2 /* Subheading */
{
font-size: 10pt;
font-family: 'Arial';
font-weight: bold;
color: #000080;
}
span.rvts3 /* Keywords */
{
font-size: 10pt;
font-family: 'Arial';
font-style: italic;
color: #800000;
}
a.rvts4, span.rvts4 /* Jump 1 */
{
font-size: 10pt;
font-family: 'Arial';
color: #008000;
text-decoration: underline;
}
a.rvts5, span.rvts5 /* Jump 2 */
{
font-size: 10pt;
font-family: 'Arial';
color: #008000;
text-decoration: underline;
}
span.rvts6
{
font-size: 8pt;
font-family: 'arial';
font-style: italic;
color: #c0c0c0;
}
a.rvts7, span.rvts7
{
font-size: 8pt;
font-family: 'arial';
color: #0000ff;
text-decoration: underline;
}
/* ---------- Para Styles ---------- */
p,ul,ol /* Paragraph Style */
{
text-align: left;
text-indent: 0px;
padding: 0px 0px 0px 0px;
margin: 0px 0px 0px 0px;
}
.rvps1 /* Centered */
{
text-align: center;
}
--></style>
</head>
<body>
<p>Hello akinimod-direqcafe,</p>
<p><br></p>
<p> I have managed to install and configure postrgre, outkafe admin, outkafe daemon. But now I've encountered the problem - I could not figure out how to make in work :-(, like others Internet-cafe management software (i.e. customer pay in advance and got an unlocked system, all-time customers with personal balance and personal login/password, customers, paying after they end their session, wi-fi customers).</p>
<p>Could someone give me some hints, or a complete howto, PLEASE</p>
<p><br></p>
<p>-- </p>
<p><span class=rvts6>-- </span></p>
<p><span class=rvts6>Best regards,</span></p>
<p><span class=rvts6> Anton </span><a class=rvts7 href="mailto:an...@sn...">mailto:an...@sn...</a></p>
<p><span class=rvts6> Administrator</span></p>
<p><br></p>
<p><span class=rvts6>Feel free to contact me </span></p>
<p><span class=rvts6>via ICQ 363780596</span></p>
<p><span class=rvts6>via Skype dobryak47</span></p>
<p><span class=rvts6>via phone +375 29 3320987</span></p>
</body></html>
|
|
From: A.J. V. <aj...@ou...> - 2009-10-11 09:34:14
|
Just symlink the files, the parts the outkafe uses are entirely compatible between them. A.J. On Sat, Oct 10, 2009 at 5:12 PM, Peter Roots <pet...@go...> wrote: > Hi > I have just been trying to help someone install outkafe on Kubuntu8.04 > Everything was fine apart from being unable to get libpq.so.4 - The last few > versions of Kubuntu all install libpq5 by default but have had libpq4 > available but now I can not find this library or anything else in the > repositories that contains libpq.so.4 > Later versions (well 9.04 at least) also no longer have libpq4 available. > We tried to edit the setup script file to ignore missing dependencies so we > could complete the install (found this suggestion on a google search) but the > cafe client fails to run due to libpq.so.4 not being found. > Any idea where I can get this in a form installable on a currently supported > version of Kubuntu? > Thanks > Peter > > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > _______________________________________________ > > OutKafe MailingList. > MailingList Options: https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe > OutKafe Website/WIKI: > http://outkafe.outkastsolutions.co.za > -- A.J. Venter Founder and lead developer, Kongoni GNU/Linux www.kongoni.co.za www.silentcoder.co.za - Blog |
|
From: Peter R. <pet...@go...> - 2009-10-10 15:16:45
|
Hi I have just been trying to help someone install outkafe on Kubuntu8.04 Everything was fine apart from being unable to get libpq.so.4 - The last few versions of Kubuntu all install libpq5 by default but have had libpq4 available but now I can not find this library or anything else in the repositories that contains libpq.so.4 Later versions (well 9.04 at least) also no longer have libpq4 available. We tried to edit the setup script file to ignore missing dependencies so we could complete the install (found this suggestion on a google search) but the cafe client fails to run due to libpq.so.4 not being found. Any idea where I can get this in a form installable on a currently supported version of Kubuntu? Thanks Peter |
|
From: Ben M. <bwm...@gm...> - 2009-07-22 10:44:10
|
Hi AJ, 2009/7/22 A.J. Venter <aj...@ou...> > Hi Ben, > Our windows userbase is fairly small so we don't really know the full > scale of potential issues -it's good to get this kind of feedback, I > don't use windows heavily myself but I believe my answers are not too > far off, I'd appreciate if somebody can give better details :) > > On Wed, Jul 22, 2009 at 12:11 PM, Ben Metcalfe<bwm...@gm...> > wrote: > > Hi all, > > > > Outkafe has been running perfectly happily for several months now, but an > > extremely honest cafe user told me the other day that if he's playing a > > streaming video, the windows (XP Pro, SP3) log-off process doesn't happen > - > > until the video's finished. > > > > I could script something to kill all real-player / media-player / vlc > > processes etc. as the outkafe client tries to log off the guest user, but > > I'm wondering if there's something elegant and simple that I'm missing > here? > I think that's about the only way - clearly these processes are > somehow overriding the outkafe client's system-calls to lock the > screen, and windows is allowing them to do so. > You could for an experiment see what happens if the video player > window is minimized, if that works - then you can probably rather > script it to just minimize all windows before executing the log-out ? Thanks for the idea. It sounds more elegant than the option I'd envisaged. I'll test it later today and let you know. > > > > > Thoughts / experiences welcome. > > > > By the way, I've also found it necessary to remove the "users" group > > entirely from the ACLS of taskmgr, tasklist, taskkill and of course > regedit > > etc. to prevent people "accidentally" hitting ctrl-alt-del and killing > the > > outkafe client with taskmanager. Again, if there's something conceptually > > wrong about running outkafe under the guest user account, please let me > > know. > This is actually pretty standard procedure I think, outkafe doesn't > itself know how to prevent users from doing that, it's up to the > administrator to protect it. > Good to know I'm on the right track. Thanks, Ben. > > > -- > 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 > |
|
From: A.J. V. <aj...@ou...> - 2009-07-22 10:37:53
|
Hi Ben, Our windows userbase is fairly small so we don't really know the full scale of potential issues -it's good to get this kind of feedback, I don't use windows heavily myself but I believe my answers are not too far off, I'd appreciate if somebody can give better details :) On Wed, Jul 22, 2009 at 12:11 PM, Ben Metcalfe<bwm...@gm...> wrote: > Hi all, > > Outkafe has been running perfectly happily for several months now, but an > extremely honest cafe user told me the other day that if he's playing a > streaming video, the windows (XP Pro, SP3) log-off process doesn't happen - > until the video's finished. > > I could script something to kill all real-player / media-player / vlc > processes etc. as the outkafe client tries to log off the guest user, but > I'm wondering if there's something elegant and simple that I'm missing here? I think that's about the only way - clearly these processes are somehow overriding the outkafe client's system-calls to lock the screen, and windows is allowing them to do so. You could for an experiment see what happens if the video player window is minimized, if that works - then you can probably rather script it to just minimize all windows before executing the log-out ? > > Thoughts / experiences welcome. > > By the way, I've also found it necessary to remove the "users" group > entirely from the ACLS of taskmgr, tasklist, taskkill and of course regedit > etc. to prevent people "accidentally" hitting ctrl-alt-del and killing the > outkafe client with taskmanager. Again, if there's something conceptually > wrong about running outkafe under the guest user account, please let me > know. This is actually pretty standard procedure I think, outkafe doesn't itself know how to prevent users from doing that, it's up to the administrator to protect it. -- 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 |
|
From: Tristan R. S. <pg...@ya...> - 2009-07-22 10:16:01
|
yeah sure, i'll wait for that. thanks for the great help! Tristan --- On Wed, 7/22/09, A.J. Venter <aj...@ou...> wrote: From: A.J. Venter <aj...@ou...> Subject: Re: [outkafe] How does one open the client To: "User discussion and support list." <aki...@li...> Date: Wednesday, 22 July, 2009, 2:27 PM This could be related to the version change- it's the first time I hear of it though, but a new libpq5 based one is on it's way - I'm just a bit swamped so I haven't had time to finish putting it together. Ciao A.J. On Wed, Jul 22, 2009 at 5:52 AM, Tristan Rex Santiago<pg...@ya...> wrote: > yeah, thanks. the daemon is installed but i forgot to run it after > installation or did not restart the pc. sorry for that dumb question > > another thing, is outkafe programmed fully compatible for libpq4? because > now, i'm using ubuntu jaunty, libpq5 is installed. i just linked libpq.so.4 > to libpq.so.5 for outkafe to run. > > the problem i encountered is, randomly, clients hangs when it requires for a > password during the first user login. a user with password already set never > encountered a hang. > > another is the pause timer button always causes the client computer to hang. > > i remember i never encountered this problem in ubuntu hardy, where libpq4 is > installed. > > many thanks! > > tristan > > --- On Tue, 7/21/09, A.J. Venter <ajv...@gm...> wrote: > > From: A.J. Venter <ajv...@gm...> > Subject: Re: [outkafe] How does one open the client > To: "User discussion and support list." > <aki...@li...> > Date: Tuesday, 21 July, 2009, 1:26 PM > > You must have forgotten to install the daemon / and or making sure it > runs on bootup. > > Ciao > A.J. > > On Tue, Jul 21, 2009 at 6:01 AM, Tristan Rex Santiago<pg...@ya...> > wrote: >> hi A.J. >> >> i managed to install and run both outkafe server and client. i can login >> from the client but the problem is the user time/units is not deducting >> from >> the server >> >> this is my setting: >> >> - i did in the command line >> #sudo -u postgres psql template1 >> #ALTER USER postgres with password 'postgres'; >> - listen_addresses='*' in postgresql.conf >> - host all all 192.168.0.0/24 password in pg_hba.conf >> >> what could i be missing? actually, i already made this to work perfectly >> last time, but i can't do it this time >> >> i'm using ubuntu jaunty. >> >> thanks for your help >> >> --- On Fri, 6/26/09, A.J. Venter <ajv...@gm...> wrote: >> >> From: A.J. Venter <ajv...@gm...> >> Subject: Re: [outkafe] How does one open the client >> To: "User discussion and support list." >> <aki...@li...> >> Date: Friday, 26 June, 2009, 10:12 PM >> >> The timer should be installed on the SERVER and ought to install >> itself I believe. >> >> The client will try to set itself up in the autostart system, but you >> may need to move it for ubuntu-gnome, any gnome users want to comment >> ? >> >> A.J. >> >> On Fri, Jun 26, 2009 at 3:38 PM, Clinton Wright<csw...@gm...> >> wrote: >>> Hi all, >>> >>> I have installed OutKafe Admin and have it setup on the server and I now >>> have setup the OutKast client on a terminal pc but I was wondering how do >>> you initiate the client and the daemon timer. >>> >>> Thanks, >>> >>> Clinton >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> >>> _______________________________________________ >>> >>> 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 >> >> ________________________________ >> Bring your friends to the fun. >> Invite your friends from Hotmail, Gmail to Yahoo! Mail today! >> >> ------------------------------------------------------------------------------ >> Enter the BlackBerry Developer Challenge >> This is your chance to win up to $100,000 in prizes! For a limited time, >> vendors submitting new applications to BlackBerry App World(TM) will have >> the opportunity to enter the BlackBerry Developer Challenge. See full >> prize >> details at: http://p.sf.net/sfu/Challenge >> _______________________________________________ >> >> 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 > > ------------------------------------------------------------------------------ > Enter the BlackBerry Developer Challenge > This is your chance to win up to $100,000 in prizes! For a limited time, > vendors submitting new applications to BlackBerry App World(TM) will have > the opportunity to enter the BlackBerry Developer Challenge. See full prize > details at: http://p.sf.net/sfu/Challenge > _______________________________________________ > > OutKafe MailingList. > MailingList Options: > https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe > OutKafe Website/WIKI: > http://outkafe.outkastsolutions.co.za > > ________________________________ > Bring your friends to the fun. > Invite your friends from Hotmail, Gmail to Yahoo! Mail today! > ------------------------------------------------------------------------------ > > _______________________________________________ > > 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 |
|
From: Ben M. <bwm...@gm...> - 2009-07-22 10:12:29
|
Hi all, Outkafe has been running perfectly happily for several months now, but an extremely honest cafe user told me the other day that if he's playing a streaming video, the windows (XP Pro, SP3) log-off process doesn't happen - until the video's finished. I could script something to kill all real-player / media-player / vlc processes etc. as the outkafe client tries to log off the guest user, but I'm wondering if there's something elegant and simple that I'm missing here? Thoughts / experiences welcome. By the way, I've also found it necessary to remove the "users" group entirely from the ACLS of taskmgr, tasklist, taskkill and of course regedit etc. to prevent people "accidentally" hitting ctrl-alt-del and killing the outkafe client with taskmanager. Again, if there's something conceptually wrong about running outkafe under the guest user account, please let me know. All the best, Ben. |
|
From: A.J. V. <aj...@ou...> - 2009-07-22 06:27:50
|
This could be related to the version change- it's the first time I hear of it though, but a new libpq5 based one is on it's way - I'm just a bit swamped so I haven't had time to finish putting it together. Ciao A.J. On Wed, Jul 22, 2009 at 5:52 AM, Tristan Rex Santiago<pg...@ya...> wrote: > yeah, thanks. the daemon is installed but i forgot to run it after > installation or did not restart the pc. sorry for that dumb question > > another thing, is outkafe programmed fully compatible for libpq4? because > now, i'm using ubuntu jaunty, libpq5 is installed. i just linked libpq.so.4 > to libpq.so.5 for outkafe to run. > > the problem i encountered is, randomly, clients hangs when it requires for a > password during the first user login. a user with password already set never > encountered a hang. > > another is the pause timer button always causes the client computer to hang. > > i remember i never encountered this problem in ubuntu hardy, where libpq4 is > installed. > > many thanks! > > tristan > > --- On Tue, 7/21/09, A.J. Venter <ajv...@gm...> wrote: > > From: A.J. Venter <ajv...@gm...> > Subject: Re: [outkafe] How does one open the client > To: "User discussion and support list." > <aki...@li...> > Date: Tuesday, 21 July, 2009, 1:26 PM > > You must have forgotten to install the daemon / and or making sure it > runs on bootup. > > Ciao > A.J. > > On Tue, Jul 21, 2009 at 6:01 AM, Tristan Rex Santiago<pg...@ya...> > wrote: >> hi A.J. >> >> i managed to install and run both outkafe server and client. i can login >> from the client but the problem is the user time/units is not deducting >> from >> the server >> >> this is my setting: >> >> - i did in the command line >> #sudo -u postgres psql template1 >> #ALTER USER postgres with password 'postgres'; >> - listen_addresses='*' in postgresql.conf >> - host all all 192.168.0.0/24 password in pg_hba.conf >> >> what could i be missing? actually, i already made this to work perfectly >> last time, but i can't do it this time >> >> i'm using ubuntu jaunty. >> >> thanks for your help >> >> --- On Fri, 6/26/09, A.J. Venter <ajv...@gm...> wrote: >> >> From: A.J. Venter <ajv...@gm...> >> Subject: Re: [outkafe] How does one open the client >> To: "User discussion and support list." >> <aki...@li...> >> Date: Friday, 26 June, 2009, 10:12 PM >> >> The timer should be installed on the SERVER and ought to install >> itself I believe. >> >> The client will try to set itself up in the autostart system, but you >> may need to move it for ubuntu-gnome, any gnome users want to comment >> ? >> >> A.J. >> >> On Fri, Jun 26, 2009 at 3:38 PM, Clinton Wright<csw...@gm...> >> wrote: >>> Hi all, >>> >>> I have installed OutKafe Admin and have it setup on the server and I now >>> have setup the OutKast client on a terminal pc but I was wondering how do >>> you initiate the client and the daemon timer. >>> >>> Thanks, >>> >>> Clinton >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> >>> _______________________________________________ >>> >>> 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 >> >> ________________________________ >> Bring your friends to the fun. >> Invite your friends from Hotmail, Gmail to Yahoo! Mail today! >> >> ------------------------------------------------------------------------------ >> Enter the BlackBerry Developer Challenge >> This is your chance to win up to $100,000 in prizes! For a limited time, >> vendors submitting new applications to BlackBerry App World(TM) will have >> the opportunity to enter the BlackBerry Developer Challenge. See full >> prize >> details at: http://p.sf.net/sfu/Challenge >> _______________________________________________ >> >> 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 > > ------------------------------------------------------------------------------ > Enter the BlackBerry Developer Challenge > This is your chance to win up to $100,000 in prizes! For a limited time, > vendors submitting new applications to BlackBerry App World(TM) will have > the opportunity to enter the BlackBerry Developer Challenge. See full prize > details at: http://p.sf.net/sfu/Challenge > _______________________________________________ > > OutKafe MailingList. > MailingList Options: > https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe > OutKafe Website/WIKI: > http://outkafe.outkastsolutions.co.za > > ________________________________ > Bring your friends to the fun. > Invite your friends from Hotmail, Gmail to Yahoo! Mail today! > ------------------------------------------------------------------------------ > > _______________________________________________ > > 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 |
|
From: Tristan R. S. <pg...@ya...> - 2009-07-22 03:52:37
|
yeah, thanks. the daemon is installed but i forgot to run it after installation or did not restart the pc. sorry for that dumb question another thing, is outkafe programmed fully compatible for libpq4? because now, i'm using ubuntu jaunty, libpq5 is installed. i just linked libpq.so.4 to libpq.so.5 for outkafe to run. the problem i encountered is, randomly, clients hangs when it requires for a password during the first user login. a user with password already set never encountered a hang. another is the pause timer button always causes the client computer to hang. i remember i never encountered this problem in ubuntu hardy, where libpq4 is installed. many thanks! tristan --- On Tue, 7/21/09, A.J. Venter <ajv...@gm...> wrote: From: A.J. Venter <ajv...@gm...> Subject: Re: [outkafe] How does one open the client To: "User discussion and support list." <aki...@li...> Date: Tuesday, 21 July, 2009, 1:26 PM You must have forgotten to install the daemon / and or making sure it runs on bootup. Ciao A.J. On Tue, Jul 21, 2009 at 6:01 AM, Tristan Rex Santiago<pg...@ya...> wrote: > hi A.J. > > i managed to install and run both outkafe server and client. i can login > from the client but the problem is the user time/units is not deducting from > the server > > this is my setting: > > - i did in the command line > #sudo -u postgres psql template1 > #ALTER USER postgres with password 'postgres'; > - listen_addresses='*' in postgresql.conf > - host all all 192.168.0.0/24 password in pg_hba.conf > > what could i be missing? actually, i already made this to work perfectly > last time, but i can't do it this time > > i'm using ubuntu jaunty. > > thanks for your help > > --- On Fri, 6/26/09, A.J. Venter <ajv...@gm...> wrote: > > From: A.J. Venter <ajv...@gm...> > Subject: Re: [outkafe] How does one open the client > To: "User discussion and support list." > <aki...@li...> > Date: Friday, 26 June, 2009, 10:12 PM > > The timer should be installed on the SERVER and ought to install > itself I believe. > > The client will try to set itself up in the autostart system, but you > may need to move it for ubuntu-gnome, any gnome users want to comment > ? > > A.J. > > On Fri, Jun 26, 2009 at 3:38 PM, Clinton Wright<csw...@gm...> wrote: >> Hi all, >> >> I have installed OutKafe Admin and have it setup on the server and I now >> have setup the OutKast client on a terminal pc but I was wondering how do >> you initiate the client and the daemon timer. >> >> Thanks, >> >> Clinton >> >> >> ------------------------------------------------------------------------------ >> >> _______________________________________________ >> >> 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 > > ________________________________ > Bring your friends to the fun. > Invite your friends from Hotmail, Gmail to Yahoo! Mail today! > ------------------------------------------------------------------------------ > Enter the BlackBerry Developer Challenge > This is your chance to win up to $100,000 in prizes! For a limited time, > vendors submitting new applications to BlackBerry App World(TM) will have > the opportunity to enter the BlackBerry Developer Challenge. See full prize > details at: http://p.sf.net/sfu/Challenge > _______________________________________________ > > 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 ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ OutKafe MailingList. MailingList Options: https://lists.sourceforge.net/lists/listinfo/akinimod-direqcafe OutKafe Website/WIKI: http://outkafe.outkastsolutions.co.za How many ways can you cook Adobo? Find out all of them on Yahoo! Answers. http://ph.answers.yahoo.com/ |
|
From: A.J. V. <ajv...@gm...> - 2009-07-21 05:27:05
|
You must have forgotten to install the daemon / and or making sure it runs on bootup. Ciao A.J. On Tue, Jul 21, 2009 at 6:01 AM, Tristan Rex Santiago<pg...@ya...> wrote: > hi A.J. > > i managed to install and run both outkafe server and client. i can login > from the client but the problem is the user time/units is not deducting from > the server > > this is my setting: > > - i did in the command line > #sudo -u postgres psql template1 > #ALTER USER postgres with password 'postgres'; > - listen_addresses='*' in postgresql.conf > - host all all 192.168.0.0/24 password in pg_hba.conf > > what could i be missing? actually, i already made this to work perfectly > last time, but i can't do it this time > > i'm using ubuntu jaunty. > > thanks for your help > > --- On Fri, 6/26/09, A.J. Venter <ajv...@gm...> wrote: > > From: A.J. Venter <ajv...@gm...> > Subject: Re: [outkafe] How does one open the client > To: "User discussion and support list." > <aki...@li...> > Date: Friday, 26 June, 2009, 10:12 PM > > The timer should be installed on the SERVER and ought to install > itself I believe. > > The client will try to set itself up in the autostart system, but you > may need to move it for ubuntu-gnome, any gnome users want to comment > ? > > A.J. > > On Fri, Jun 26, 2009 at 3:38 PM, Clinton Wright<csw...@gm...> wrote: >> Hi all, >> >> I have installed OutKafe Admin and have it setup on the server and I now >> have setup the OutKast client on a terminal pc but I was wondering how do >> you initiate the client and the daemon timer. >> >> Thanks, >> >> Clinton >> >> >> ------------------------------------------------------------------------------ >> >> _______________________________________________ >> >> 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 > > ________________________________ > Bring your friends to the fun. > Invite your friends from Hotmail, Gmail to Yahoo! Mail today! > ------------------------------------------------------------------------------ > Enter the BlackBerry Developer Challenge > This is your chance to win up to $100,000 in prizes! For a limited time, > vendors submitting new applications to BlackBerry App World(TM) will have > the opportunity to enter the BlackBerry Developer Challenge. See full prize > details at: http://p.sf.net/sfu/Challenge > _______________________________________________ > > 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 |
|
From: Tristan R. S. <pg...@ya...> - 2009-07-21 04:02:02
|
hi A.J. i managed to install and run both outkafe server and client. i can login from the client but the problem is the user time/units is not deducting from the server this is my setting: - i did in the command line #sudo -u postgres psql template1 #ALTER USER postgres with password 'postgres'; - listen_addresses='*' in postgresql.conf - host all all 192.168.0.0/24 password in pg_hba.conf what could i be missing? actually, i already made this to work perfectly last time, but i can't do it this time i'm using ubuntu jaunty. thanks for your help --- On Fri, 6/26/09, A.J. Venter <ajv...@gm...> wrote: From: A.J. Venter <ajv...@gm...> Subject: Re: [outkafe] How does one open the client To: "User discussion and support list." <aki...@li...> Date: Friday, 26 June, 2009, 10:12 PM The timer should be installed on the SERVER and ought to install itself I believe. The client will try to set itself up in the autostart system, but you may need to move it for ubuntu-gnome, any gnome users want to comment ? A.J. On Fri, Jun 26, 2009 at 3:38 PM, Clinton Wright<csw...@gm...> wrote: > Hi all, > > I have installed OutKafe Admin and have it setup on the server and I now > have setup the OutKast client on a terminal pc but I was wondering how do > you initiate the client and the daemon timer. > > Thanks, > > Clinton > > ------------------------------------------------------------------------------ > > _______________________________________________ > > 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 Try the new Yahoo! Messenger 9.0. It is finally here! http://ph.messenger.yahoo.com |
|
From: A.J. V. <aj...@ou...> - 2009-07-10 07:51:55
|
Yep, this sounds like a typical pg_hba.conf issue. According to the mailing list server, you are already subscribed so I am forwarding this to the list, and hopefully somebody can provide you a sample of this file for your distro (ubuntu jaunty if I remember right). Ciao A.J. On Thu, Jul 9, 2009 at 7:16 PM, Clinton Wright<csw...@gm...> wrote: > Dear A.J, > > I have installed and got the outkafe Admin and database setup with schema > installed but now I have a problem with the client. I install the client and > set all the settings for the database, the ip: 192.168.2.181, db username > and password and database name. I have checked over the settings and they > are correct. I think the problem has to do with the pg_hba.conf file. I am > having trouble editing this file, I may be editing this file incorrectly, I > may be inputting the incorrect format of code to enable all users on the > network to access the database from the server. I have instructions to > change this file to allow all users access but when I edit it my postgresql > server gives me an error. When I open the client once I have installed it > and configured the settings, it gives a FATAL ERROR telling me that it > cannot connect to the server. > > Also A.J, I have tried to subscribe to the mailing list but when I send a > request with my code to activate my account on the mailing list the > verification code sent to me that I send back keeps coming back with a > failure, so thats why I have finally just decided to email you as my last > resort for help. > > Your assistance would be kindly appreciated, > > Thank you kindly, > > Clinton Wright > IT PROS > > -- 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 |
|
From: Roman M. <rom...@gi...> - 2009-07-06 13:02:40
|
Hi A.J.
I thought I downloaded a package. So I used subversion then - my
mistake!
I checked my files. It also contains a .svn directory.
Here is the content of the sql dump:
************
CREATE TABLE transaction_log
(
"timestamp" timestamp NOT NULL DEFAULT now(),
description text,
amount float8,
username varchar(100),
loginname varchar(100),
CONSTRAINT "timestamp" PRIMARY KEY ("timestamp")
)
WITHOUT OIDS;
ALTER TABLE transaction_log OWNER TO "outkafe-user";
************
As you can see, the table also contains "loginname". Every member of the
staff is having his linux user account to login to the server.
Transaction_log is supposed to log also the name of the member of the
staff, so we know who sold the units to the customer. Unfortunately I
wasn't able to find a pascal function to retrieve the linux user name.
So for now "loginname" is unused. Maybe you can add this?
Kind regards,
Roman
-----Ursprüngliche Nachricht-----
Von: A.J. Venter [mailto:aj...@ou...]
Gesendet: Montag, 6. Juli 2009 10:52
An: User discussion and support list.
Betreff: Re: [outkafe] WG: WG: Development of accounting solution
That sounds... impossible - unless somebody else put it up there.
I have never released the source code as a package, and it's not
hosted on sourceforge, the only role sourceforge plays is in hosting
the mailing list, none of the code or distribution happens there.
The contributors guide on the wiki does explain how to get the code,
but that is based on subversion being used... it seems highly unlikely
that this is not svn based.
Before you try anything else, just check for me if there is a .svn
directory in your source tree please ?
Also - I almost forgot - I need the sql dump with the database schema
for the new table as well. You can just mail that to me directly.
Ciao
A.J.
On Mon, Jul 6, 2009 at 12:42 PM, Roman Meier<rom...@gi...>
wrote:
> Hi A.J.
>
> I don't think I did a subversion checkout. I rather downloaded the
code
> as a package from sourceforge. Sorry, it's been a few months back and
I
> don't remember very well.
>
> Beside, I also did some minor changes to the code based on the
feedback
> of my staff. They have nothing to do with the accounting part. You can
> ignore these changes.
>
> As far as I know, the relevant changes are in the folders "liboukafe"
> and "outkafeadmin" only. I can archive and send these folders to you.
>
> Sorry for the inconvenience. Let me know, how you like to go about it.
>
> Kind regards,
> Roman
>
> -----Ursprüngliche Nachricht-----
> Von: A.J. Venter [mailto:aj...@ou...]
> Gesendet: Montag, 6. Juli 2009 07:31
> An: User discussion and support list.
> Betreff: Re: [outkafe] WG: WG: Development of accounting solution
>
> I take it you did a subversion checkout from the repository ?
>
> In that case, the easiest way to get the code to me is to do the
> following,
> cd into the directory where you worked on the code and then run
>
> svn diff > accounting.patch
>
> bzip2 the accounting.patch file and mail it to me. This file will
> include all your changes, I can then apply it to my working directory
> to get those changes, commit them, work on them and will ultimately
> release a new version with this feature included.
>
> Ciao
> A.J.
>
> On Sun, Jul 5, 2009 at 4:09 PM, Roman Meier<rom...@gi...>
> wrote:
>> Hi A.J.
>>
>> I finished the accounting part a few days ago. Since then my boys are
>> beta testing it. It works fine and the feedback is positive so far.
> I'm
>> ready to submit it to you.
>>
>> Finally I didn't include the cvs part. I wasn't able to fit it into
> the
>> design or I simply didn't understand it. Sorry for that. Please feel
>> free to add it yourself.
>>
>> How can I submit the code to you?
>>
>> Kind regards,
>> Roman
>>
>> -----Ursprüngliche Nachricht-----
>> Von: Roman Meier [mailto:rom...@gi...]
>> Gesendet: Donnerstag, 25. Juni 2009 12:21
>> An: 'User discussion and support list.'
>> Betreff: AW: [outkafe] WG: Development of accounting solution
>>
>> Hi A.J.
>>
>> Thanks for the cvs report code ! I'll give cvs a chance then :-)
>>
>> Kind regards,
>> Roman
>>
>> -----Ursprüngliche Nachricht-----
>> Von: A.J. Venter [mailto:ajv...@gm...]
>> Gesendet: Donnerstag, 25. Juni 2009 09:37
>> An: User discussion and support list.
>> Betreff: Re: [outkafe] WG: Development of accounting solution
>>
>> Hi Roman,
>> Since you need to extract the data from the database to present a
> report
>> you have basically two approaches you can take.
>> The one is to have your read method export a set of VAR parameters
and
>> feed them back as variables, this is doable and you can put the
>> conversions in the lib then, - but you have a stack of them so you
> will
>> need to use arrays or something... it gets really complex.
>> The other is to use a tstringlist and set up a function method -which
>> means the compiler does almost all the work for you, in that case
>> though, you need to differentiate the columns in some way that will
> make
>> it easy to tell them apart on the other end, CVS is by far the
easiest
>> format to parse, heck - here's the code:
>>
>> Var TmpStr,Time, Description,AmountStr : String;
>> Amount,Total : Real;
>> ...
>> Total := 0;
>> for I in 0 to Stringlist.Count -1 do
>> Begin
>> TmpStr := StringList[I];
>> Time := Copy(TmpStr,1,pos(',',TmpStr)-1);
>> Delete(TmpStr,1,pos(',',Tmpstr));
>> Delete (Time,1,1);
>> Time := Copy(Time,1,pos('"',Time);
>> //Repeat exactly as above for Description and amountStr
>> Ammount := StrToFloat(AmountStr);
>> Total := Total+Amount;
>> //Add all three to listview, look in the main tab at the userlist
>> code for an example
>> End;
>> //Add the total to the view
>>
>> Voila - there's the code to display the report, and you already HAVE
> the
>> CSV, so adding a button to save the file is now really easy,
> basically,
>> I would say if you implement what you want in the easiest possible
way
> -
>> you'll get the CSV export feature for free :)
>>
>> Ciao
>> A.J.
>> On Thu, Jun 25, 2009 at 11:25 AM, Roman Meier <rom...@gi...>
>> wrote:
>> 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
>>
>>
>
------------------------------------------------------------------------
>> ------
>> _______________________________________________
>>
>> 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
>
>
>
------------------------------------------------------------------------
------
> _______________________________________________
>
> 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
|
|
From: A.J. V. <aj...@ou...> - 2009-07-06 10:52:10
|
That sounds... impossible - unless somebody else put it up there.
I have never released the source code as a package, and it's not
hosted on sourceforge, the only role sourceforge plays is in hosting
the mailing list, none of the code or distribution happens there.
The contributors guide on the wiki does explain how to get the code,
but that is based on subversion being used... it seems highly unlikely
that this is not svn based.
Before you try anything else, just check for me if there is a .svn
directory in your source tree please ?
Also - I almost forgot - I need the sql dump with the database schema
for the new table as well. You can just mail that to me directly.
Ciao
A.J.
On Mon, Jul 6, 2009 at 12:42 PM, Roman Meier<rom...@gi...> wrote:
> Hi A.J.
>
> I don't think I did a subversion checkout. I rather downloaded the code
> as a package from sourceforge. Sorry, it's been a few months back and I
> don't remember very well.
>
> Beside, I also did some minor changes to the code based on the feedback
> of my staff. They have nothing to do with the accounting part. You can
> ignore these changes.
>
> As far as I know, the relevant changes are in the folders "liboukafe"
> and "outkafeadmin" only. I can archive and send these folders to you.
>
> Sorry for the inconvenience. Let me know, how you like to go about it.
>
> Kind regards,
> Roman
>
> -----Ursprüngliche Nachricht-----
> Von: A.J. Venter [mailto:aj...@ou...]
> Gesendet: Montag, 6. Juli 2009 07:31
> An: User discussion and support list.
> Betreff: Re: [outkafe] WG: WG: Development of accounting solution
>
> I take it you did a subversion checkout from the repository ?
>
> In that case, the easiest way to get the code to me is to do the
> following,
> cd into the directory where you worked on the code and then run
>
> svn diff > accounting.patch
>
> bzip2 the accounting.patch file and mail it to me. This file will
> include all your changes, I can then apply it to my working directory
> to get those changes, commit them, work on them and will ultimately
> release a new version with this feature included.
>
> Ciao
> A.J.
>
> On Sun, Jul 5, 2009 at 4:09 PM, Roman Meier<rom...@gi...>
> wrote:
>> Hi A.J.
>>
>> I finished the accounting part a few days ago. Since then my boys are
>> beta testing it. It works fine and the feedback is positive so far.
> I'm
>> ready to submit it to you.
>>
>> Finally I didn't include the cvs part. I wasn't able to fit it into
> the
>> design or I simply didn't understand it. Sorry for that. Please feel
>> free to add it yourself.
>>
>> How can I submit the code to you?
>>
>> Kind regards,
>> Roman
>>
>> -----Ursprüngliche Nachricht-----
>> Von: Roman Meier [mailto:rom...@gi...]
>> Gesendet: Donnerstag, 25. Juni 2009 12:21
>> An: 'User discussion and support list.'
>> Betreff: AW: [outkafe] WG: Development of accounting solution
>>
>> Hi A.J.
>>
>> Thanks for the cvs report code ! I'll give cvs a chance then :-)
>>
>> Kind regards,
>> Roman
>>
>> -----Ursprüngliche Nachricht-----
>> Von: A.J. Venter [mailto:ajv...@gm...]
>> Gesendet: Donnerstag, 25. Juni 2009 09:37
>> An: User discussion and support list.
>> Betreff: Re: [outkafe] WG: Development of accounting solution
>>
>> Hi Roman,
>> Since you need to extract the data from the database to present a
> report
>> you have basically two approaches you can take.
>> The one is to have your read method export a set of VAR parameters and
>> feed them back as variables, this is doable and you can put the
>> conversions in the lib then, - but you have a stack of them so you
> will
>> need to use arrays or something... it gets really complex.
>> The other is to use a tstringlist and set up a function method -which
>> means the compiler does almost all the work for you, in that case
>> though, you need to differentiate the columns in some way that will
> make
>> it easy to tell them apart on the other end, CVS is by far the easiest
>> format to parse, heck - here's the code:
>>
>> Var TmpStr,Time, Description,AmountStr : String;
>> Amount,Total : Real;
>> ...
>> Total := 0;
>> for I in 0 to Stringlist.Count -1 do
>> Begin
>> TmpStr := StringList[I];
>> Time := Copy(TmpStr,1,pos(',',TmpStr)-1);
>> Delete(TmpStr,1,pos(',',Tmpstr));
>> Delete (Time,1,1);
>> Time := Copy(Time,1,pos('"',Time);
>> //Repeat exactly as above for Description and amountStr
>> Ammount := StrToFloat(AmountStr);
>> Total := Total+Amount;
>> //Add all three to listview, look in the main tab at the userlist
>> code for an example
>> End;
>> //Add the total to the view
>>
>> Voila - there's the code to display the report, and you already HAVE
> the
>> CSV, so adding a button to save the file is now really easy,
> basically,
>> I would say if you implement what you want in the easiest possible way
> -
>> you'll get the CSV export feature for free :)
>>
>> Ciao
>> A.J.
>> On Thu, Jun 25, 2009 at 11:25 AM, Roman Meier <rom...@gi...>
>> wrote:
>> 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
>>
>>
> ------------------------------------------------------------------------
>> ------
>> _______________________________________________
>>
>> 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
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
>
> 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
|
|
From: Roman M. <rom...@gi...> - 2009-07-06 10:43:23
|
Hi A.J.
I don't think I did a subversion checkout. I rather downloaded the code
as a package from sourceforge. Sorry, it's been a few months back and I
don't remember very well.
Beside, I also did some minor changes to the code based on the feedback
of my staff. They have nothing to do with the accounting part. You can
ignore these changes.
As far as I know, the relevant changes are in the folders "liboukafe"
and "outkafeadmin" only. I can archive and send these folders to you.
Sorry for the inconvenience. Let me know, how you like to go about it.
Kind regards,
Roman
-----Ursprüngliche Nachricht-----
Von: A.J. Venter [mailto:aj...@ou...]
Gesendet: Montag, 6. Juli 2009 07:31
An: User discussion and support list.
Betreff: Re: [outkafe] WG: WG: Development of accounting solution
I take it you did a subversion checkout from the repository ?
In that case, the easiest way to get the code to me is to do the
following,
cd into the directory where you worked on the code and then run
svn diff > accounting.patch
bzip2 the accounting.patch file and mail it to me. This file will
include all your changes, I can then apply it to my working directory
to get those changes, commit them, work on them and will ultimately
release a new version with this feature included.
Ciao
A.J.
On Sun, Jul 5, 2009 at 4:09 PM, Roman Meier<rom...@gi...>
wrote:
> Hi A.J.
>
> I finished the accounting part a few days ago. Since then my boys are
> beta testing it. It works fine and the feedback is positive so far.
I'm
> ready to submit it to you.
>
> Finally I didn't include the cvs part. I wasn't able to fit it into
the
> design or I simply didn't understand it. Sorry for that. Please feel
> free to add it yourself.
>
> How can I submit the code to you?
>
> Kind regards,
> Roman
>
> -----Ursprüngliche Nachricht-----
> Von: Roman Meier [mailto:rom...@gi...]
> Gesendet: Donnerstag, 25. Juni 2009 12:21
> An: 'User discussion and support list.'
> Betreff: AW: [outkafe] WG: Development of accounting solution
>
> Hi A.J.
>
> Thanks for the cvs report code ! I'll give cvs a chance then :-)
>
> Kind regards,
> Roman
>
> -----Ursprüngliche Nachricht-----
> Von: A.J. Venter [mailto:ajv...@gm...]
> Gesendet: Donnerstag, 25. Juni 2009 09:37
> An: User discussion and support list.
> Betreff: Re: [outkafe] WG: Development of accounting solution
>
> Hi Roman,
> Since you need to extract the data from the database to present a
report
> you have basically two approaches you can take.
> The one is to have your read method export a set of VAR parameters and
> feed them back as variables, this is doable and you can put the
> conversions in the lib then, - but you have a stack of them so you
will
> need to use arrays or something... it gets really complex.
> The other is to use a tstringlist and set up a function method -which
> means the compiler does almost all the work for you, in that case
> though, you need to differentiate the columns in some way that will
make
> it easy to tell them apart on the other end, CVS is by far the easiest
> format to parse, heck - here's the code:
>
> Var TmpStr,Time, Description,AmountStr : String;
> Amount,Total : Real;
> ...
> Total := 0;
> for I in 0 to Stringlist.Count -1 do
> Begin
> TmpStr := StringList[I];
> Time := Copy(TmpStr,1,pos(',',TmpStr)-1);
> Delete(TmpStr,1,pos(',',Tmpstr));
> Delete (Time,1,1);
> Time := Copy(Time,1,pos('"',Time);
> //Repeat exactly as above for Description and amountStr
> Ammount := StrToFloat(AmountStr);
> Total := Total+Amount;
> //Add all three to listview, look in the main tab at the userlist
> code for an example
> End;
> //Add the total to the view
>
> Voila - there's the code to display the report, and you already HAVE
the
> CSV, so adding a button to save the file is now really easy,
basically,
> I would say if you implement what you want in the easiest possible way
-
> you'll get the CSV export feature for free :)
>
> Ciao
> A.J.
> On Thu, Jun 25, 2009 at 11:25 AM, Roman Meier <rom...@gi...>
> wrote:
> 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
>
>
------------------------------------------------------------------------
> ------
> _______________________________________________
>
> 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
|
|
From: A.J. V. <aj...@ou...> - 2009-07-06 07:58:26
|
I take it you did a subversion checkout from the repository ?
In that case, the easiest way to get the code to me is to do the following,
cd into the directory where you worked on the code and then run
svn diff > accounting.patch
bzip2 the accounting.patch file and mail it to me. This file will
include all your changes, I can then apply it to my working directory
to get those changes, commit them, work on them and will ultimately
release a new version with this feature included.
Ciao
A.J.
On Sun, Jul 5, 2009 at 4:09 PM, Roman Meier<rom...@gi...> wrote:
> Hi A.J.
>
> I finished the accounting part a few days ago. Since then my boys are
> beta testing it. It works fine and the feedback is positive so far. I'm
> ready to submit it to you.
>
> Finally I didn't include the cvs part. I wasn't able to fit it into the
> design or I simply didn't understand it. Sorry for that. Please feel
> free to add it yourself.
>
> How can I submit the code to you?
>
> Kind regards,
> Roman
>
> -----Ursprüngliche Nachricht-----
> Von: Roman Meier [mailto:rom...@gi...]
> Gesendet: Donnerstag, 25. Juni 2009 12:21
> An: 'User discussion and support list.'
> Betreff: AW: [outkafe] WG: Development of accounting solution
>
> Hi A.J.
>
> Thanks for the cvs report code ! I'll give cvs a chance then :-)
>
> Kind regards,
> Roman
>
> -----Ursprüngliche Nachricht-----
> Von: A.J. Venter [mailto:ajv...@gm...]
> Gesendet: Donnerstag, 25. Juni 2009 09:37
> An: User discussion and support list.
> Betreff: Re: [outkafe] WG: Development of accounting solution
>
> Hi Roman,
> Since you need to extract the data from the database to present a report
> you have basically two approaches you can take.
> The one is to have your read method export a set of VAR parameters and
> feed them back as variables, this is doable and you can put the
> conversions in the lib then, - but you have a stack of them so you will
> need to use arrays or something... it gets really complex.
> The other is to use a tstringlist and set up a function method -which
> means the compiler does almost all the work for you, in that case
> though, you need to differentiate the columns in some way that will make
> it easy to tell them apart on the other end, CVS is by far the easiest
> format to parse, heck - here's the code:
>
> Var TmpStr,Time, Description,AmountStr : String;
> Amount,Total : Real;
> ...
> Total := 0;
> for I in 0 to Stringlist.Count -1 do
> Begin
> TmpStr := StringList[I];
> Time := Copy(TmpStr,1,pos(',',TmpStr)-1);
> Delete(TmpStr,1,pos(',',Tmpstr));
> Delete (Time,1,1);
> Time := Copy(Time,1,pos('"',Time);
> //Repeat exactly as above for Description and amountStr
> Ammount := StrToFloat(AmountStr);
> Total := Total+Amount;
> //Add all three to listview, look in the main tab at the userlist
> code for an example
> End;
> //Add the total to the view
>
> Voila - there's the code to display the report, and you already HAVE the
> CSV, so adding a button to save the file is now really easy, basically,
> I would say if you implement what you want in the easiest possible way -
> you'll get the CSV export feature for free :)
>
> Ciao
> A.J.
> On Thu, Jun 25, 2009 at 11:25 AM, Roman Meier <rom...@gi...>
> wrote:
> 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
>
> ------------------------------------------------------------------------
> ------
> _______________________________________________
>
> 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
|
|
From: Roman M. <rom...@gi...> - 2009-07-05 14:31:28
|
Hi A.J.
I finished the accounting part a few days ago. Since then my boys are
beta testing it. It works fine and the feedback is positive so far. I'm
ready to submit it to you.
Finally I didn't include the cvs part. I wasn't able to fit it into the
design or I simply didn't understand it. Sorry for that. Please feel
free to add it yourself.
How can I submit the code to you?
Kind regards,
Roman
-----Ursprüngliche Nachricht-----
Von: Roman Meier [mailto:rom...@gi...]
Gesendet: Donnerstag, 25. Juni 2009 12:21
An: 'User discussion and support list.'
Betreff: AW: [outkafe] WG: Development of accounting solution
Hi A.J.
Thanks for the cvs report code ! I'll give cvs a chance then :-)
Kind regards,
Roman
-----Ursprüngliche Nachricht-----
Von: A.J. Venter [mailto:ajv...@gm...]
Gesendet: Donnerstag, 25. Juni 2009 09:37
An: User discussion and support list.
Betreff: Re: [outkafe] WG: Development of accounting solution
Hi Roman,
Since you need to extract the data from the database to present a report
you have basically two approaches you can take.
The one is to have your read method export a set of VAR parameters and
feed them back as variables, this is doable and you can put the
conversions in the lib then, - but you have a stack of them so you will
need to use arrays or something... it gets really complex.
The other is to use a tstringlist and set up a function method -which
means the compiler does almost all the work for you, in that case
though, you need to differentiate the columns in some way that will make
it easy to tell them apart on the other end, CVS is by far the easiest
format to parse, heck - here's the code:
Var TmpStr,Time, Description,AmountStr : String;
Amount,Total : Real;
...
Total := 0;
for I in 0 to Stringlist.Count -1 do
Begin
TmpStr := StringList[I];
Time := Copy(TmpStr,1,pos(',',TmpStr)-1);
Delete(TmpStr,1,pos(',',Tmpstr));
Delete (Time,1,1);
Time := Copy(Time,1,pos('"',Time);
//Repeat exactly as above for Description and amountStr
Ammount := StrToFloat(AmountStr);
Total := Total+Amount;
//Add all three to listview, look in the main tab at the userlist
code for an example
End;
//Add the total to the view
Voila - there's the code to display the report, and you already HAVE the
CSV, so adding a button to save the file is now really easy, basically,
I would say if you implement what you want in the easiest possible way -
you'll get the CSV export feature for free :)
Ciao
A.J.
On Thu, Jun 25, 2009 at 11:25 AM, Roman Meier <rom...@gi...>
wrote:
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
------------------------------------------------------------------------
------
_______________________________________________
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
|
|
From: Roman M. <rom...@gi...> - 2009-06-27 08:16:54
|
Hi Clinton Please make sure you also install the timer on the server. The installation script will install it as a new daemon. No manual changes are required for ubuntu gnome systems as far as I know. The name of the client is "oklin". You will find it in folder /usr. There are different ways to run the Outkafe client software: For testing you just open a terminal window and you enter "oklin". The software will then try to connect to the server. Commands are logged in the terminal window. You will be able to detect problems in your configuration. Normally you want to launch the client software anytime you start the pc. In that case you have to add a new start-up session: Preferences -> Sessions -> Add -> Startup Program -> command: /usr/oklin That's it! Enjoy it! It's cool software! Kind regards, Roman -----Ursprüngliche Nachricht----- Von: Clinton Wright [mailto:csw...@gm...] Gesendet: Freitag, 26. Juni 2009 13:59 An: Aki...@li... Betreff: [outkafe] How to initialize the client To whom it may concern, I have setup OutKast Admin and its all working with a database but now I am not sure how to start the client. I have installed the client but I cannot seem to figure out how to run it. Thank you kindly, Clinton |
|
From: Clinton W. <csw...@gm...> - 2009-06-26 14:47:13
|
csw...@gm... |
|
From: Clinton W. <csw...@gm...> - 2009-06-26 14:28:20
|
To whom it may concern, I have setup OutKast Admin and its all working with a database but now I am not sure how to start the client. I have installed the client but I cannot seem to figure out how to run it. Thank you kindly, Clinton |
|
From: A.J. V. <ajv...@gm...> - 2009-06-26 14:13:22
|
The timer should be installed on the SERVER and ought to install itself I believe. The client will try to set itself up in the autostart system, but you may need to move it for ubuntu-gnome, any gnome users want to comment ? A.J. On Fri, Jun 26, 2009 at 3:38 PM, Clinton Wright<csw...@gm...> wrote: > Hi all, > > I have installed OutKafe Admin and have it setup on the server and I now > have setup the OutKast client on a terminal pc but I was wondering how do > you initiate the client and the daemon timer. > > Thanks, > > Clinton > > ------------------------------------------------------------------------------ > > _______________________________________________ > > 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 |
|
From: Clinton W. <csw...@gm...> - 2009-06-26 14:09:41
|
csw...@gm... Please add me to the mailing list. |
|
From: Clinton W. <csw...@gm...> - 2009-06-26 14:08:21
|
Hi all, I have installed OutKafe Admin and have it setup on the server and I now have setup the OutKast client on a terminal pc but I was wondering how do you initiate the client and the daemon timer. Thanks, Clinton |
|
From: Roman M. <rom...@gi...> - 2009-06-25 13:09:30
|
Hi A.J.
Thanks for the cvs report code ! I'll give cvs a chance then :-)
Kind regards,
Roman
-----Ursprüngliche Nachricht-----
Von: A.J. Venter [mailto:ajv...@gm...]
Gesendet: Donnerstag, 25. Juni 2009 09:37
An: User discussion and support list.
Betreff: Re: [outkafe] WG: Development of accounting solution
Hi Roman,
Since you need to extract the data from the database to present a report
you have basically two approaches you can take.
The one is to have your read method export a set of VAR parameters and
feed them back as variables, this is doable and you can put the
conversions in the lib then, - but you have a stack of them so you will
need to use arrays or something... it gets really complex.
The other is to use a tstringlist and set up a function method -which
means the compiler does almost all the work for you, in that case
though, you need to differentiate the columns in some way that will make
it easy to tell them apart on the other end, CVS is by far the easiest
format to parse, heck - here's the code:
Var TmpStr,Time, Description,AmountStr : String;
Amount,Total : Real;
...
Total := 0;
for I in 0 to Stringlist.Count -1 do
Begin
TmpStr := StringList[I];
Time := Copy(TmpStr,1,pos(',',TmpStr)-1);
Delete(TmpStr,1,pos(',',Tmpstr));
Delete (Time,1,1);
Time := Copy(Time,1,pos('"',Time);
//Repeat exactly as above for Description and amountStr
Ammount := StrToFloat(AmountStr);
Total := Total+Amount;
//Add all three to listview, look in the main tab at the userlist
code for an example
End;
//Add the total to the view
Voila - there's the code to display the report, and you already HAVE the
CSV, so adding a button to save the file is now really easy, basically,
I would say if you implement what you want in the easiest possible way -
you'll get the CSV export feature for free :)
Ciao
A.J.
On Thu, Jun 25, 2009 at 11:25 AM, Roman Meier <rom...@gi...>
wrote:
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
------------------------------------------------------------------------
------
_______________________________________________
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
|
|
From: A.J. V. <ajv...@gm...> - 2009-06-25 09:37:31
|
Hi Roman,
Since you need to extract the data from the database to present a report you
have basically two approaches you can take.
The one is to have your read method export a set of VAR parameters and feed
them back as variables, this is doable and you can put the conversions in
the lib then, - but you have a stack of them so you will need to use arrays
or something... it gets really complex.
The other is to use a tstringlist and set up a function method -which means
the compiler does almost all the work for you, in that case though, you need
to differentiate the columns in some way that will make it easy to tell them
apart on the other end, CVS is by far the easiest format to parse, heck -
here's the code:
Var TmpStr,Time, Description,AmountStr : String;
Amount,Total : Real;
...
Total := 0;
for I in 0 to Stringlist.Count -1 do
Begin
TmpStr := StringList[I];
Time := Copy(TmpStr,1,pos(',',TmpStr)-1);
Delete(TmpStr,1,pos(',',Tmpstr));
Delete (Time,1,1);
Time := Copy(Time,1,pos('"',Time);
//Repeat exactly as above for Description and amountStr
Ammount := StrToFloat(AmountStr);
Total := Total+Amount;
//Add all three to listview, look in the main tab at the userlist code
for an example
End;
//Add the total to the view
Voila - there's the code to display the report, and you already HAVE the
CSV, so adding a button to save the file is now really easy, basically, I
would say if you implement what you want in the easiest possible way -
you'll get the CSV export feature for free :)
Ciao
A.J.
On Thu, Jun 25, 2009 at 11:25 AM, Roman Meier <rom...@gi...> wrote:
> 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
>
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
>
> 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
|
2 messages has been excluded from this view by a project administrator.