openledger-developer Mailing List for OpenLedger (Page 3)
Brought to you by:
klavs
Menu
▾
▴
openledger-developer — Developer list for discussing SL3 development
You can subscribe to this list here.
| 2005 |
Jan
|
Feb
(15) |
Mar
(83) |
Apr
(23) |
May
(10) |
Jun
(6) |
Jul
(14) |
Aug
(5) |
Sep
(1) |
Oct
(7) |
Nov
(6) |
Dec
(1) |
|---|
|
From: David P. <dp...@he...> - 2005-04-29 18:38:35
|
Roland, We have used SQL Ledger for years and are also very skilled in Perl development. Unfortunately modification and integration of a project like SQL-Ledger is too big a task for us to take on in small projects. That is why we are participating in a project who's main purpose is to make SQL-Ledger more modular and capable of integration. I think the project team for that project (Open Ledger) would be very happy to have someone with a concrete problem that needs solved. I suggest you sign up for the developer's list serve and begin discussing your needs there: https://lists.sourceforge.net/lists/listinfo/openledger-developer David David Pool, MBA Principal Naked Ape Consulting, Ltd. http://naked-ape.com On Wed, 2005-04-27 at 17:13 -0700, Roland Porth wrote: > Hello, > > I am interested in using SQL-Ledger as our accounting system and > integrating it with our website software which is OSCommerce 2.2 MS2. > Do you have any experience in performing such an integration? What > are the issues involved? What is the best way to link them together? > Is this the kind of service you might provide? > > Regards, > > Roland > > > -- > Roland Porth > QuiltHome.com - Quality, Service, > Innovation > Colville, Wa 99114 > 509-684-9000 > QuiltHome.com > |
|
From: David P. <dp...@he...> - 2005-04-29 15:51:55
|
I had an inquiry from a potential client asking generally about this integration. Since I thought there was someone who'd already done it, I thought I'd put the two in touch. It looks like I was mistaking where someone had said they wanted to do so for having actually done it. d On Fri, 2005-04-29 at 22:31 +0000, Ang Tun Chek wrote: > can you just tell us what to do, so that we can take it as a > consideration while we are writing code for openledger > > cheers > Ang > > David Pool wrote: > > >Was there someone on the list who'd actually integrated SQL-Ledger and > >OS Commerce? I thought there was but can't find the message. If so, > >please contact me as I may have some work for you. > > > >David > > > > > > > >------------------------------------------------------- > >SF.Net email is sponsored by: Tell us your software development plans! > >Take this survey and enter to win a one-year sub to SourceForge.net > >Plus IDC's 2005 look-ahead and a copy of this survey > >Click here to start! http://www.idcswdc.com/cgi-bin/survey?id=105hix > >_______________________________________________ > >Openledger-developer mailing list > >Ope...@li... > >https://lists.sourceforge.net/lists/listinfo/openledger-developer > > > > > > > > |
|
From: udono <ud...@gm...> - 2005-04-29 11:39:41
|
Hello, I like to try a bit on a general Report module for oo. Is there someone still working on this? Greetings from Udo |
|
From: udono <ud...@gm...> - 2005-04-29 11:02:12
|
Hello Ang, Modern_design88 schrieb: > To all > the parts.pm is ready for testing. please download from cvs I try it out, and it works... There has been one error in the Parts.pm, the Patch is attached. I extend the test.pl for testing the Parts (not in the cvs - use the test.pl.diff) > one more question > 1) SL's IC.pm has a item serves as "alternate". can anyone tell me what > is it? not exactly, it seems to me, that it is something for a future feature, but nothing for now. Alternate is just used in the ic and IC but without a value declaration and there is a Column in the parts table ... Bye Udo -- Udo S. |
|
From: David P. <dp...@he...> - 2005-04-28 20:34:38
|
Was there someone on the list who'd actually integrated SQL-Ledger and OS Commerce? I thought there was but can't find the message. If so, please contact me as I may have some work for you. David |
|
From: Modern_design88 <wa...@pl...> - 2005-04-28 17:44:37
|
To all the parts.pm is ready for testing. please download from cvs one more question 1) SL's IC.pm has a item serves as "alternate". can anyone tell me what is it? cheers Ang |
|
From: Tony F. <to...@sy...> - 2005-04-26 15:35:36
|
On Mon, 2005-04-25 at 17:03, Ang Tun Chek wrote: > To All, > i have been studying the IC.pm on SL 2.4.11 and i have some questions here > > 1) what is partscustomer and partsvendor in the database? I haven't looked at this feature much but I would say they're for the price matrix feature. If your new to the 2.4 version have a look in "Goods & Services->(Add|Edit) Part" you'll see that you can assign a price, etc... per customer or a partnumber, cost, etc... per vendor. > 2) how warehousing works in SL? what inventory table do? The inventory table keeps track of individual shipping and receiving reports. When you go to the "Shipping->(Ship|Receive)" screens when you click "Done" SL inserts a row into inventory and updates orderitems.serialnumber for each line that you receive or ship. Purchase Orders have a positive inventory.qty and Sales Orders have a negative inventory.qty When you do a "Shipping->Transfer" 2 rows are inserted into inventory for each part number you transfer one with the "from" warehouse_id and a negative qty and one with the "to" warehouse_id and a positive qty. The oe_id and orderitems_id columns seem to be left NULL for transfers. > 3) SL comes with a "labor", do we really need it? or we can treat it as > another service? (i prefer to treat it as a service) The idea of a "Labour" item is that it can be included onto an assembly as a cost to assemble the the assembly or an overhead associated with assembly like "Shop Supplies". -- Tony Fraser to...@sy... Sybaspace Internet Solutions System Administrator phone: (250) 246-5368 fax: (250) 246-5398 |
|
From: Ang T. C. <at...@ew...> - 2005-04-25 15:53:44
|
To All, i have been studying the IC.pm on SL 2.4.11 and i have some questions here 1) what is partscustomer and partsvendor in the database? 2) how warehousing works in SL? what inventory table do? 3) SL comes with a "labor", do we really need it? or we can treat it as another service? (i prefer to treat it as a service) |
|
From: Ang T. C. <at...@ew...> - 2005-04-14 12:33:29
|
hi i will upload the vendor.pm. i mised that one, sorry bout that. well, currently invoice class is not yet ready. notice will be given to everyone once ready thanks Ang udono wrote: > Solved. > > udono schrieb: > >> Hello Ang, >> >> many thanks for helping on cvs... It works :-) >> >> After this I get the Sql-ledger Version 2.4.7 running and create a >> table 'sql-ledger', an user 'user' like discribed in the >> users/user.conf... everything works fine. >> >> But there is a missing Vendor.pm Class included in Openledger.pm and >> used in test.pl. >> >> Do you know, where I find this Vendor.pm? > > > I did a search for 'customer' replaced with 'vendor' and a seach for > 'Customer' replaced with 'Customer'. Saved the file als Vendor.pm - > and test.pl works without problems. > > Is there any testing environment for the invoice class out? > > Greetings from Udo > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click > _______________________________________________ > Openledger-developer mailing list > Ope...@li... > https://lists.sourceforge.net/lists/listinfo/openledger-developer |
|
From: udono <ud...@gm...> - 2005-04-14 12:26:55
|
Solved. udono schrieb: > Hello Ang, > > many thanks for helping on cvs... It works :-) > > After this I get the Sql-ledger Version 2.4.7 running and create a table > 'sql-ledger', an user 'user' like discribed in the users/user.conf... > everything works fine. > > But there is a missing Vendor.pm Class included in Openledger.pm and > used in test.pl. > > Do you know, where I find this Vendor.pm? I did a search for 'customer' replaced with 'vendor' and a seach for 'Customer' replaced with 'Customer'. Saved the file als Vendor.pm - and test.pl works without problems. Is there any testing environment for the invoice class out? Greetings from Udo |
|
From: udono <ud...@gm...> - 2005-04-14 12:03:58
|
Hello Ang, many thanks for helping on cvs... It works :-) After this I get the Sql-ledger Version 2.4.7 running and create a table 'sql-ledger', an user 'user' like discribed in the users/user.conf... everything works fine. But there is a missing Vendor.pm Class included in Openledger.pm and used in test.pl. Do you know, where I find this Vendor.pm? Greetings from Udo |
|
From: Ang T. C. <at...@ew...> - 2005-04-14 02:09:03
|
this is the correct way cvs -z3 -d:pserver:ano...@cv...:/cvsroot/openledger co -P perlapi udono wrote: > Hello, > > i like to test the openledger api, but never used cvs. I tried : > # cvs -z3 > -d:pserver:ano...@cv...:/cvsroot/openledger/perlapi > co -P test.pl > > and it err: > > cvs checkout: authorization failed: server cvs.sourceforge.net > rejected access to /cvsroot/openledger/perlapi for user anonymous > cvs checkout: used empty password; try "cvs login" with a real password > > Did I need a Password to download openledger? > > Greetings from Udo > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click > _______________________________________________ > Openledger-developer mailing list > Ope...@li... > https://lists.sourceforge.net/lists/listinfo/openledger-developer |
|
From: udono <ud...@gm...> - 2005-04-13 22:15:03
|
Hello, i like to test the openledger api, but never used cvs. I tried : # cvs -z3 -d:pserver:ano...@cv...:/cvsroot/openledger/perlapi co -P test.pl and it err: cvs checkout: authorization failed: server cvs.sourceforge.net rejected access to /cvsroot/openledger/perlapi for user anonymous cvs checkout: used empty password; try "cvs login" with a real password Did I need a Password to download openledger? Greetings from Udo |
|
From: Ang T. C. <at...@ew...> - 2005-04-09 17:52:38
|
To all, Customer, Vendor and CT class is almost done. it comes with save and get functions. please try it at test.pl btw, i am going to do a search functions which may return 1 or more results . any of you have any idea or references? it must be able to accept any conditions from users. and are we going to have a report class? any suggestion? from Ang |
|
From: Ang T. C. <at...@ew...> - 2005-04-08 02:15:31
|
hi thanks for quick reply. well we got a polish translator here we will let you know when the transation is required cheers ANg Peter Dabrowski wrote: >Hi, >I will do translations to Polish > >Peter >----- Original Message ----- >From: "Ang Tun Chek" <at...@ew...> >To: "David Pool" <dp...@he...> >Subject: Re: [Openledger-developer] where is everyone? >Date: Thu, 07 Apr 2005 21:08:13 +0000 > > > >>To all >>i am happy to see some responses here, at least we are not alone. >>well, i will just keep going with my code because i am believe we >>have to get the fundamental done first then modify as needed. ok, >>this is what i am going to do now. >> >>1) Complete Customer, Vendor class >>2) upload sql tables >>3) enhance User class >> >>currently i will stick with what SL has and probably import some >>feature from my OBA projects (fork of SL) >>http://oba.sourceforge.net >> >>btw, i want to know who can do what in this projects, like joseph , >>he can write a manual! if anyone of you want to contribute >>something but dont know how. please let us know. we will give you >>some job to do :) >> >> >>cheers >>Ang >> >> >>------------------------------------------------------- >>SF email is sponsored by - The IT Product Guide >>Read honest & candid reviews on hundreds of IT Products from real users. >>Discover which products truly live up to the hype. Start reading now. >>http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click >>_______________________________________________ >>Openledger-developer mailing list >>Ope...@li... >>https://lists.sourceforge.net/lists/listinfo/openledger-developer >> >> > > > |
|
From: Peter D. <mer...@ma...> - 2005-04-07 13:30:53
|
Hi, I will do translations to Polish Peter ----- Original Message ----- From: "Ang Tun Chek" <at...@ew...> To: "David Pool" <dp...@he...> Subject: Re: [Openledger-developer] where is everyone? Date: Thu, 07 Apr 2005 21:08:13 +0000 >=20 > To all > i am happy to see some responses here, at least we are not alone.=20 > well, i will just keep going with my code because i am believe we=20 > have to get the fundamental done first then modify as needed. ok,=20 > this is what i am going to do now. >=20 > 1) Complete Customer, Vendor class > 2) upload sql tables > 3) enhance User class >=20 > currently i will stick with what SL has and probably import some=20 > feature from my OBA projects (fork of SL) > http://oba.sourceforge.net >=20 > btw, i want to know who can do what in this projects, like joseph ,=20 > he can write a manual! if anyone of you want to contribute=20 > something but dont know how. please let us know. we will give you=20 > some job to do :) >=20 >=20 > cheers > Ang >=20 >=20 > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_id=3D6595&alloc_id=3D14396&op=3Dclick > _______________________________________________ > Openledger-developer mailing list > Ope...@li... > https://lists.sourceforge.net/lists/listinfo/openledger-developer --=20 ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm |
|
From: Ang T. C. <at...@ew...> - 2005-04-07 13:01:15
|
To all i am happy to see some responses here, at least we are not alone. well, i will just keep going with my code because i am believe we have to get the fundamental done first then modify as needed. ok, this is what i am going to do now. 1) Complete Customer, Vendor class 2) upload sql tables 3) enhance User class currently i will stick with what SL has and probably import some feature from my OBA projects (fork of SL) http://oba.sourceforge.net btw, i want to know who can do what in this projects, like joseph , he can write a manual! if anyone of you want to contribute something but dont know how. please let us know. we will give you some job to do :) cheers Ang |
|
From: David P. <dp...@he...> - 2005-04-06 18:15:17
|
On Wed, 2005-04-06 at 12:02 -0600, Joseph wrote: > On Wed, 2005-04-06 at 10:36 -0700, David Pool wrote: > > > > Hurdle 1 - Decision making > > How do we decide on issues like archetecture and commit priviledges. > > Sooner or later we'll have a conflict arise and without some process > > for > > deciding we're screwed. I'd propose that Klavs and two other people > > form > > an initial leadership team. I'd want most discussion and decision > > making > > to come from this list, but for tough decisions I'd want a clear > > process > > for reaching a decision > > I'm not a developer (I could write instruction manual for the rest of > us) but the best approach would be democratic one via voting between > those who contribute. "those who contribute" is too ambiguous for dealing with contentious issues. I'd agree with the concept but suggest a model like Apache where the initial team nominates and votes in people who have shown that they are contributing to the project. > If somebody is against one approach or another he/she should point the > problem and suggest better solution. This is the heart of open source and independent of having a decision making group. Most issues should be hashed out on the Openledger- developer list just as you suggest. If it comes down to two conflicting patches against the core project there should be a decision making group that can decide. This group's functioning should be fair game for discussion. The SQL Ledger leader's decision to squelch conversation about the direction of that project is what brought me to Open Ledger. To me Free Software implies Free Speech. David |
|
From: Joseph <sy...@in...> - 2005-04-06 18:00:58
|
On Wed, 2005-04-06 at 10:36 -0700, David Pool wrote: > > Hurdle 1 - Decision making > How do we decide on issues like archetecture and commit priviledges. > Sooner or later we'll have a conflict arise and without some process > for > deciding we're screwed. I'd propose that Klavs and two other people > form > an initial leadership team. I'd want most discussion and decision > making > to come from this list, but for tough decisions I'd want a clear > process > for reaching a decision I'm not a developer (I could write instruction manual for the rest of us) but the best approach would be democratic one via voting between those who contribute. If somebody is against one approach or another he/she should point the problem and suggest better solution. Just my 0.2 -- #Joseph |
|
From: David P. <dp...@he...> - 2005-04-06 17:36:51
|
On Tue, 2005-04-05 at 17:24 +0000, Ang Tun Chek wrote: > just wonder if this project is still running... > please reply!!! Thanks Ang, I was wondering the same thing. I too am interested in helping this project along. I could go approach other SL forks, other projects in need of a backend, and hopefully in the future attract dollars to support ongoing development. I see some hurdles though. Hurdle 1 - Decision making How do we decide on issues like archetecture and commit priviledges. Sooner or later we'll have a conflict arise and without some process for deciding we're screwed. I'd propose that Klavs and two other people form an initial leadership team. I'd want most discussion and decision making to come from this list, but for tough decisions I'd want a clear process for reaching a decision Hurdle 2 - Nah, the rest of the hurdles are bumps compared to the issue of our own self governance... what do people think about that first hurdle? David |
|
From: Ang T. C. <at...@ew...> - 2005-04-05 14:20:56
|
>p.s. Ang - pls. do follow the CVS guide on SF - you have CVS access, >so you can happily play along with the current code - and implement >your login code. > > Ok i will try that >p.p.s. I do think it is "wrong" to include SL code for login handling >- - I'd prefer moving the code to the new API - as the old code is >supposed to "go away", once the OpenLedger API supports everything >that is needed. > >The code in CVS already, serves me very well every day. > > well i will just stick with this login function first until we found a new way. |
|
From: Klavs K. <kl...@vs...> - 2005-04-05 09:40:35
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 on 04/05/05 19:24 Ang Tun Chek wrote: > just wonder if this project is still running... please reply!!! To me it is. However I believe someone has to find the time (ie. priorities) to further it. I will continue scratching my own itch, as I find the time and I HOPE that others will come along and see the value of a Community Ledger Software package, and want to spend their time here. How to further this.. I guess writing something better on the openledger.sf.net homepage would be a start :) All ideas are welcome, and if anyone wants to commit code - feel free. p.s. Ang - pls. do follow the CVS guide on SF - you have CVS access, so you can happily play along with the current code - and implement your login code. p.p.s. I do think it is "wrong" to include SL code for login handling - - I'd prefer moving the code to the new API - as the old code is supposed to "go away", once the OpenLedger API supports everything that is needed. The code in CVS already, serves me very well every day. I think, for this project to gain momentum, we would have to get the attention of some of the projects that could use an accounting backend - - without having to code it themselves. Much of the code they'd need is already available in OpenLedger.pm. [SNIP] - -- Regards, Klavs Klavsen, GSEC - kl...@vs... - http://www.vsen.dk PGP: 7E063C62/2873 188C 968E 600D D8F8 B8DA 3D3A 0B79 7E06 3C62 "Those who do not understand Unix are condemned to reinvent it, poorly." --Henry Spencer -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (GNU/Linux) iD8DBQFCUl0kPToLeX4GPGIRAoshAJ4inYBtZZ2Z4kF6PfEquCen/gNEVgCfRxI+ F853sbzYec5vomymPKFsZvI= =87ps -----END PGP SIGNATURE----- |
|
From: Ang T. C. <at...@ew...> - 2005-04-05 09:15:29
|
just wonder if this project is still running... please reply!!! |
|
From: Ang T. C. <at...@ew...> - 2005-03-26 16:08:44
|
To all, a functional openledger object is almost done it currently support 1) allow to do authentication using SL user configuration 2) save a login member infomation into user configuration file 3) customer module now able to create and save to database current to do. need help here 1) User.pm - a working function to update database defaults table after user configuration is saved. 2) Customer.pm - a working function to retrieve customer data from database. please read the test.pl inside the archive. it shows you some examples on using the objects and functions. please download at http://openledger.sourceforge.net/openledger.tar.gz by the way, can anyone help me to upload to cvs becuase i have problem to do it here. thanks Ang Tun CHek |
|
From: Klavs K. <kl...@vs...> - 2005-03-24 09:03:33
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 on 03/23/05 19:08 Tony Fraser wrote: [SNIP] | | So, say I'm writing a Tk based POS because I'm unhappy with the | data entry rate of a web interface. Each POS machine is making | conntions directly to the DB. Now, because customers are | unpredictable creatures and often change their mind half way | through a POS transaction I create a hold function. ie. Take the | current transaction and set it aside and start a new transaction so | the clerk can help the next person in line. | | Your saying that I would have to create a OpenLedger.pm object when | I put a transaction on hold? Ehh - why would that have ANYTHING to do with OpenLedger transactions? situations like that is helped, because the clerk is NOT going to "post" the transaction, before he actually finishes defining it (ie. filling the object) and has received payment from the customer. And if he puts a case on hold -that just means he'll put that "invoice/whatever-POS" object aside, and then perhaps post it to OpenLedger, when he finalizes the transaction. Starting a db-transaction at all, before every data has been collected, and the clerk is actually certain it needs to be done, is simply a waste of time, and IMHO bad practice. |> When searching for invoices, I was planning on returning an array |> of invoice-objects - ie. the resulting invoices. If we did that, |> a DB connection for each of them would be inevitable, and very |> ressource consuming. | | | That would be fine but the objects would have to be read only. And | hence wouldn't have to have a backing DB connection. When the user | decides on a particular invoice to edit, a new connection should be | opened and an new DB transaction started by re-retrieving the | invoice. | I don't like that the object should have it's own db-connection, and if it hasn't, there's no need for the code to re-retrive the invoice once it is seeked to be editted. I would prefer it be posted to an "invoiceEdit" function, and then the invoicenr is used as the ref. and the old invoice is removed, and the new one posted. Making the code having to re-retrive the invoice, and then do the exact same thing they could have done to the original object makes no sense. The code using the OpenLedger API should be able to alter the invoices, as they see fit. Even if you "try" to make it more troublesome, by forcing them to re-retrive it, they can still do the exact same things, which just means its a waste of code, and unnecessarily troublesome to work with. | Or you could just use a different (generic) ResultSet type object | that only retrieves the fields that the user requests for the | search in the fist place. We could. But seeing as how we need to fetch and search the DB anyways, and chances are they need the invoice-object, we might as well fetch them all as invoice-objects, and then they can simply pull out the invoice from the array, that they want to work with. Don't like to have more datatypes or different types of resultsets, if it isn't necessary. In short, I'd like to make it as simple as possible - and don't force complexity on it, that does not need to be there. Then we can always alter/enhance the code, if we find something needs to be rethought, but I doubt we'll actually see the "right way" before having tried and learned - and that's why I prefer the KISS approach :) - a simple design (and mind you, simple is not necessarily bad - it is most often - - also in security, a good thing) will also make it easier/quicker for us to get OpenLedger off the ground. You totally missed commenting on: Ahh - Then I have no problem with that - except for one thing. The fact that you define a BACKEND on the invoice/transaction etc. object. But that I've argued in the above segment :) Having the BACKEND there, also means you can't just post the object to another OpenLedger object (or crm or whatever uses the same objects), as you'd have to redefine the BACKEND var in the object then. This can be done, but is IMHO object-orientation. I see no reason for the data-object to know anything about who uses it (ie. the BACKEND to which is from or will be posted too). - -- Regards, Klavs Klavsen, GSEC - kl...@vs... - http://www.vsen.dk PGP: 7E063C62/2873 188C 968E 600D D8F8 B8DA 3D3A 0B79 7E06 3C62 "Those who do not understand Unix are condemned to reinvent it, poorly." ~ --Henry Spencer -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (GNU/Linux) iD8DBQFCQoJrPToLeX4GPGIRAouHAJ9VIbms5kk9gpMYjVWOLeW+4sRylwCfalHX 4mvTrYS21Q1x3VlmvD3Zr9I= =1ipI -----END PGP SIGNATURE----- |
