web-erp-developers — Discussion on development of webERP

Re: [Web-erp-developers] CVS binary files .doc, .jpeg, .gif .....

[Stins, D. <DR...@Zi...>]

Phil,
Yes and no. It has to do with:
For example, when it=92s working between a Unix repository and a Windows =
or
Macintosh working copy, it converts file line endings appropriately for e=
ach
platform. For example,
Unix convention is to use a linefeed (LF) only, whereas Windows expects a
carriage return/linefeed
(CRLF) sequence at the end of each line. Thus, the files in a working cop=
y
on a Windows machine
have CRLF endings, but the files in a working copy of the same project on=
 a
Unix machine have LF
endings (the repository itself is always stored in LF format).
And CVS also expand keywords like:
$Revision$
Also when these are accidentally created in binaries. This will give
problems at any operating system.
With best regards,
Dick Stins

----- Original Message -----
From: "Daintree" <p.d...@pa...>
To: <web...@li...>
Sent: Sunday, March 14, 2004 8:13 PM
Subject: Re: [Web-erp-developers] CVS binary files .doc, .jpeg, .gif ....=
.


I take it that this was the issue with nt cvs - I checked out the cvs to
another linux machine .... no worries with the images for me.

Phil
----- Original Message -----
From: "Stins, Dick" <DR...@Zi...>
To: "Web-ERP Developers" <Web...@li...>
Sent: Sunday, March 14, 2004 11:09 PM
Subject: [Web-erp-developers] CVS binary files .doc, .jpeg, .gif .....


> BlankDear all,
>
> Please add binary files to cvs conform the instructions below.
>
> with best regards,
> Dick Stins
>
> CVS will expand on each commit to include the revision number. For
example,
> it might get expanded to:
> $Revision: 1.3 $
> CVS will keep that string up to date as the file is developed. (The
various
> keyword strings are
> documented in Chapters 4 and 11.)
> This string expansion is a very useful feature in text files, because i=
t
> allows you to see the revision
> number or other information about a file while you=92re editing it. But=
 what
> if the file is a JPEG image
> (with a .JPG extension)? Or a compiled executable program? In those kin=
ds
of
> files, CVS could do
> some serious damage if it blundered around expanding any keyword string
that
> it encountered. In a
> binary, such strings can even appear by coincidence.
> Therefore, when you add a binary file, you have to tell CVS to turn off
both
> keyword expansion and
> line-ending conversion. To do so, use -kb:
>
> yarkon$ cvs add -kb filename
> yarkon$ cvs ci -m "added blah" filename
>
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id638&op=CCk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>




-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id638&op=3Dick
_______________________________________________
Web-erp-developers mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [Web-erp-developers] CVS binary files .doc, .jpeg, .gif .....

[Daintree <p.d...@pa...>]

I take it that this was the issue with nt cvs - I checked out the cvs=
 to
another linux machine .... no worries with the images for me.

Phil
----- Original Message -----
=46rom: "Stins, Dick" <DR...@Zi...>
To: "Web-ERP Developers" <Web...@li...>
Sent: Sunday, March 14, 2004 11:09 PM
Subject: [Web-erp-developers] CVS binary files .doc, .jpeg, .gif ....=
.


> BlankDear all,
>
> Please add binary files to cvs conform the instructions below.
>
> with best regards,
> Dick Stins
>
> CVS will expand on each commit to include the revision number. For
example,
> it might get expanded to:
> $Revision: 1.3 $
> CVS will keep that string up to date as the file is developed. (The
various
> keyword strings are
> documented in Chapters 4 and 11.)
> This string expansion is a very useful feature in text files, becau=
se it
> allows you to see the revision
> number or other information about a file while you=92re editing it.=
 But what
> if the file is a JPEG image
> (with a .JPG extension)? Or a compiled executable program? In those=
 kinds
of
> files, CVS could do
> some serious damage if it blundered around expanding any keyword st=
ring
that
> it encountered. In a
> binary, such strings can even appear by coincidence.
> Therefore, when you add a binary file, you have to tell CVS to turn=
 off
both
> keyword expansion and
> line-ending conversion. To do so, use -kb:
>
> yarkon$ cvs add -kb filename
> yarkon$ cvs ci -m "added blah" filename
>
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO =
of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id638&op=CCk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

[Web-erp-developers] .doc = ms word?

[Stins, D. <DR...@Zi...>]

BlankDear All,

I found the web-erp/doc/webERP_Manual.doc

Please use not the .doc format but the more portable .rtf format (or .pdf or
.html or ....).

With best regards,

Dick Stins

[Web-erp-developers] CVS binary files .doc, .jpeg, .gif .....

[Stins, D. <DR...@Zi...>]

BlankDear all,

Please add binary files to cvs conform the instructions below.

with best regards,
Dick Stins

CVS will expand on each commit to include the revision number. For exampl=
e,
it might get expanded to:
$Revision: 1.3 $
CVS will keep that string up to date as the file is developed. (The vario=
us
keyword strings are
documented in Chapters 4 and 11.)
This string expansion is a very useful feature in text files, because it
allows you to see the revision
number or other information about a file while you=92re editing it. But w=
hat
if the file is a JPEG image
(with a .JPG extension)? Or a compiled executable program? In those kinds=
 of
files, CVS could do
some serious damage if it blundered around expanding any keyword string t=
hat
it encountered. In a
binary, such strings can even appear by coincidence.
Therefore, when you add a binary file, you have to tell CVS to turn off b=
oth
keyword expansion and
line-ending conversion. To do so, use -kb:

yarkon$ cvs add -kb filename
yarkon$ cvs ci -m "added blah" filename

[Web-erp-developers] explaination company setup gl accounts

[Stins, D. <DR...@Zi...>]

BlankHoi,

I tried to understand the GL accounts functionality in the company setup.
Please help me to explain.

With best regards,
Dick Stins

Debtors Control GL Account:
- All invoices sent to customers are registrated at this GL

Creditors Control GL Account:
- All received invoices of suppliers are registrated at this GL

Payroll Net Pay Clearing GL Account:
- All netto payed amounts to the employees are registrated at this GL (no
taxes)

Goods Received Clearing GL Account:
- All orders (or invoices of suppliers) are registrated at GL account ....
- When the order is received, then it will be registrated at this goods
received clearing GL account.

Retained Earning Clearing GL Account:
- All payments for invoices send to customers

Freight Re-charged GL Account:
- ?

Exchange Variances GL Account:
- differences in exchange rates ?

Sales Exchange Variances GL Account:
- differences in exchange rates when sold to your clients

Purchases Exchange Variances GL Account:
- differences in exchange rates when bought from your suppliers

Payment Discount GL Account:
- discount when payed in time? or all discounts you give to the customers?
Or discounts from the suppliers?

Re: [Web-erp-developers] Re: Images and ZA SQL etc.

[Stins, D. <DR...@Zi...>]

Phil,

It's Ok with me when you and Dany use testerp.zion-it.com. Also for ftp
exchange.

For the moment, there is a bandwidth available of 5gb/month. I might have to
downgrade this limit in future (I hope not).

With best regards,

Dick Stins
----- Original Message -----
From: "Danie Brink" <br...@na...>
To: "Phil Daintree" <Web...@li...>
Sent: Friday, March 12, 2004 8:13 AM
Subject: [Web-erp-developers] Re: Images and ZA SQL etc.


> Could you provide me with an ftp: site I could upload the images to, it
> simply takes to long to mail. I have cancel the operation.
>
> I have included though the SQL for South African chart of accounts for
> WebERP 2.8 based on SQL_NEW.
>
> Kind Regards
> Danie Brink br...@na...
>
>
>
>
>

[Web-erp-developers] Re: Images and ZA SQL etc.

[Danie B. <br...@na...>]

Could you provide me with an ftp: site I could upload the images to, it
simply takes to long to mail. I have cancel the operation.

I have included though the SQL for South African chart of accounts for
WebERP 2.8 based on SQL_NEW.

Kind Regards
Danie Brink br...@na...



 

[Web-erp-developers] $Revision$ CVS +

[Stins, D. <DR...@Zi...>]

BlankDear all,
When new revisions/versions are delivered to be checked in in CVS, please=
 be
sure to have the following php code in the script:

echo "<!-- \$Revision$ -->";
Why?
See the TaxAuthorityRates.php script.
When someone would like to report a bug, they are able to tell which CVS
revision the bug is found by checking the source in the browser.
When you checkout the script:
TaxAuthorityRates.php
You will see that CVS modified automticallly the code to:
echo "<!-- \$Revision: 1.1 $ -->";
When you display in the browser the source, you will see:
<!-- $Revision: 1.1 $ -->
I think this will save us lot's of time, because we are always sure or ar=
e
able to ask which revision we should use to be able to reproduce an
issue/bug.
I is also nice to be able to read which revision is installed in my own
runtime environment and to check when there is a newer revision available=
 in
CVS.
May be we should consider some other cvs keywords too:

? $Name$=97Name of the sticky tag:
$Name: release_1_14 $
? $RCSfile$=97Name of the RCS file in the repository:
The header would be nice to include it in php comment. That saves bandwid=
ht.
$Header$=97Various pieces of information thought to be useful: full path =
to
the RCS file
in the repository, revision, date (in UTC), author, state, and locker.
(Lockers are rare,
although in the following example, qsmith has a lock.):
$Header: /usr/local/newrepos/myproj/hello.c,v 1.1 2001/06/01 03:21:13 \
random Exp qsmith $
I hope you all see these minor extra coding and use of CVS is valuable.
With best regards,
Dick Stins

Re: [Web-erp-developers] Re: Web-ERP integration with other apps

[Stins, D. <DR...@he...>]

Dear All,

One of the activities on my list is integration with a webshop. OScommerce
might be a good choice.

About SOAP:
I think that nusoap could be a quick start to implement this.
http://sourceforge.net/projects/nusoap/

It is probably better portable then free commercial products like Glue of
Webmethods.

With best regards,

Dick Stins

----- Original Message -----
From: "Daintree" <p.d...@pa...>
To: "Ciprian Popovici" <sf...@us...>
Cc: "Web-ERP List" <web...@li...>; "Web-ERP
Developers" <Web...@li...>
Sent: Tuesday, March 09, 2004 10:45 AM
Subject: [Web-erp-developers] Re: Web-ERP integration with other apps


> Hi Ciprian,
>
> There is not SOAP interface built for import and export of data. One of
the
> developers Danie Brink is interested in adding some import/export
> functionality - in more of a batch mode I think his intention is to allow
> remote branches to upload transactions at other branches. It is not clear
> how this will be done... I have some reservations as to how seperate sites
> will retain full integrity, part of the beauty of the system is that only
> one db is necessary accross branches and remote sites can access over the
> net ..... The stumbling block is that bandwidth in South Africa is still
> very expensive and full time connections to the internet are prohibitive.
>
> I am currently working on EANCOM EDI orders. This will allow customers to
> send flat file purchase orders that will be parsed and create a web-erp
> sales order with no user input. A customer service person will be emailed
> that the order has been created so it can be fulfilled.
>
> EANCOM EDI invoices were added in version 2.8 - although these are only
beta
> until someone lets me have a go at implementing them live somewhere. These
> EDI invoices, produce a flat file of the invoice in the UN/EDIFACT - in
fact
> the EANCOM subset format - with some flexibility about the fields that are
> exported. Unfortunately, EDI is a little unweildy and is more a scheduled
> batch process than real time exchange of data a la SOAP.
>
> What sort of data would you be thinking of exchanging. Of course the data
is
> all retained in either a MySQL (and a Postgres database option is now
> available).
>
> In summary .... troublesome I would say. I would be prepared to go to some
> trouble if there are serious functionality gains to be had from
OsCommerce -
> which I am not familar with. There are a number of people now wanting to
add
> some CRM functionality and I am not sure if this would be better to build
or
> patch on some well regarded third party software.
>
> Phil
>
> ----- Original Message -----
> From: "Ciprian Popovici" <sf...@us...>
> To: <dai...@us...>
> Cc: <sf...@us...>
> Sent: Tuesday, March 09, 2004 9:57 PM
> Subject: Web-ERP integration with other apps
>
>
> >
> > Hello,
> >
> >
> >
> > I would like to know if it's possible to integrate web-erp
> >
> > with another application in any way. I would like to
> >
> > integrate it with OsCommerce, but from the web-erp docs and
> >
> > site as well as the functional demo it is not clear whether
> >
> > any kind of import/export of data is possible. I found some
> >
> > recent messages on the user mailing list that seem to hint
> >
> > that such functionality is just now starting to be
> >
> > considered for implementation in web-erp.
> >
> >
> >
> > By "integration" I mean being able to move data both ways,
> >
> > ideally with a real-time method such as SOAP. Exchanging
> >
> > files in a common format would be the next best thing.
> >
> >
> >
> > I've already done some major modifications to OsCommerce so
> >
> > additional work to play nice with web-erp wouldn't be such a
> >
> > hassle, however implementing this feature in web-erp in case
> >
> > it doesn't have it already would be troublesome.
> >
> >
> >
> > Thanks for your time.
> >
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

[Web-erp-developers] Re: Web-ERP integration with other apps

[Daintree <p.d...@pa...>]

Hi Ciprian,

There is not SOAP interface built for import and export of data. One of the
developers Danie Brink is interested in adding some import/export
functionality - in more of a batch mode I think his intention is to allow
remote branches to upload transactions at other branches. It is not clear
how this will be done... I have some reservations as to how seperate sites
will retain full integrity, part of the beauty of the system is that only
one db is necessary accross branches and remote sites can access over the
net ..... The stumbling block is that bandwidth in South Africa is still
very expensive and full time connections to the internet are prohibitive.

I am currently working on EANCOM EDI orders. This will allow customers to
send flat file purchase orders that will be parsed and create a web-erp
sales order with no user input. A customer service person will be emailed
that the order has been created so it can be fulfilled.

EANCOM EDI invoices were added in version 2.8 - although these are only beta
until someone lets me have a go at implementing them live somewhere. These
EDI invoices, produce a flat file of the invoice in the UN/EDIFACT - in fact
the EANCOM subset format - with some flexibility about the fields that are
exported. Unfortunately, EDI is a little unweildy and is more a scheduled
batch process than real time exchange of data a la SOAP.

What sort of data would you be thinking of exchanging. Of course the data is
all retained in either a MySQL (and a Postgres database option is now
available).

In summary .... troublesome I would say. I would be prepared to go to some
trouble if there are serious functionality gains to be had from OsCommerce -
which I am not familar with. There are a number of people now wanting to add
some CRM functionality and I am not sure if this would be better to build or
patch on some well regarded third party software.

Phil

----- Original Message -----
From: "Ciprian Popovici" <sf...@us...>
To: <dai...@us...>
Cc: <sf...@us...>
Sent: Tuesday, March 09, 2004 9:57 PM
Subject: Web-ERP integration with other apps


>
> Hello,
>
>
>
> I would like to know if it's possible to integrate web-erp
>
> with another application in any way. I would like to
>
> integrate it with OsCommerce, but from the web-erp docs and
>
> site as well as the functional demo it is not clear whether
>
> any kind of import/export of data is possible. I found some
>
> recent messages on the user mailing list that seem to hint
>
> that such functionality is just now starting to be
>
> considered for implementation in web-erp.
>
>
>
> By "integration" I mean being able to move data both ways,
>
> ideally with a real-time method such as SOAP. Exchanging
>
> files in a common format would be the next best thing.
>
>
>
> I've already done some major modifications to OsCommerce so
>
> additional work to play nice with web-erp wouldn't be such a
>
> hassle, however implementing this feature in web-erp in case
>
> it doesn't have it already would be troublesome.
>
>
>
> Thanks for your time.
>

Re: [Web-erp-developers] Session_start error

[Stins, D. <DR...@Zi...>]

Phil,

Thanks. Some of the nasty messages are gone. Unfortunately not all and the
layout is mixed up. For some reason is more mixed up than my other new
installation.

The cpanel software is standard when you order a hosting package (6.5
euro/month excl. vat) at my company. Also fantastico which installs lot's of
php scripts (when you want to evaluate this, then I will activate
fantastico.).

The software is not very cheap. You have to pay per cpu or something like
that.

You can use also ftp: ftp://te...@te...

with best regards,

Dick Stins


----- Original Message -----
From: "Phil Daintree" <ph...@du...>
To: <web...@li...>
Sent: Tuesday, March 09, 2004 7:03 AM
Subject: [Web-erp-developers] Session_start error


> This was some blank lines at the end of the config.php - I fixed them the
> nasty messages have gone ...
>
> The image files are a mystery. I think another checkout might be in order
> clearly something has gone sadly wrong with these.
>
> Had not seen this cpanel software before it is great!! Is it open-source?
>
> Phil
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

[Web-erp-developers] Session_start error

[Phil D. <ph...@du...>]

This was some blank lines at the end of the config.php - I fixed them the 
nasty messages have gone ...

The image files are a mystery. I think another checkout might be in order 
clearly something has gone sadly wrong with these. 

Had not seen this cpanel software before it is great!! Is it open-source?

Phil

[Web-erp-developers] Re: First Mysql 2 Pgsql util and ConnectDB for Postgres

[Phil D. <ph...@du...>]

Hi Danie,

Just thinking about this ....

This conversion program is fantastic for those who wish to convert an existing 
db - I am sure it would have wider appeal that just weberp too! 

Those more familiar with pg might want to use it from the start even. If you 
could send me a pg db dump then I should include this in the distribution too 
... I think? I don't have python installed. Maybe I'd better and then I can 
get a script to create the necessary db scripts.


Phil

On Thursday 04 March 2004 19:52, you wrote:
> I will check out the latest version from CVS as soon as I can, and will
> make the changes to this version again. Its not much, a simple change in
> ConnectDB.inc ( MySQL version ) and 5 more updates regrading the
> retrieval of last_ID. The changes in MySQL version of ConnectDB.inc are
> superficial as the new parameters are ignored.
>
> The reason is because MySQL changed their duel license library from LGPL
> to GPL which may cause problems for businesses in future. This option
> will allow them to convert current database to Postgress and simply swap
> over.

[Web-erp-developers] Re: Assorted Really small Web-ERP bugs

[Phil D. <ph...@du...>]

Richard,

Please just email any scripts to p.d...@pa...
but first please ensure the scripts you modified are freshly updated from CVS 
on sourceforge.

----------------------------
> Problem
> -------
> Bad title (first clue problem was comming)
> error loading page on click 'login'
>
> Changed
> -------
>   "<?echo" replaced with "<?php echo"
>
> files affected
> --------------
>   includes/Login.php
>   index.php
>


There were quite a few other short tags used .. I have replaced all of these 
with <?php throughout



> -----------------------------------------
> Problem
> -------
> undefined index error visible
>
> Changed
> -------
>   add line
>         $hide_menu = false ;
>   (could go anywhere, I put it at the end)
>
> Files affected
> --------------
>   config.php
>

I removed this variable altogether now so no need to define it in config.php


>
> Problem
> -------
> undefined index error visible on first load of app
>
> Changed
> -------
>
>   added the lines (after session_start;)
>
>     if (!isset($_SESSION["AttemptsCounter"]))
>     {
>       $_SESSION["AttemptsCounter"] = 0 ;
>     }
>
> Files affected
> --------------
>     session.inc
>
> -----------------------------------------

This is a curious one since the latest version 2.8 actually has this code 
already in session.inc ?? I haven't changed it but would like to confirm you 
are using a prior version Richard??

>
> Problem
> -------
> logo image not displaying in footer
>
> Changed
> -------
>
>   replaced line 23 in footer.inc
>
> old    <td align="center"><img
> src="<?="$rootpath/css/$theme/images/webERP+sm.gif";?>"></td>
> new    <td align="center"><img src="<?php echo
> "$rootpath/css/$theme/images/webERP+sm.gif";?>"></td>
>
> Files affected
> --------------
>     footer.inc

fixed.
>
> -----------------------------------------
> Problem
> -------
>   Version downloaded said 2.8  Config.php says  $Version = "0.2.7";
> Files affected
> --------------
>   Config.php
> Changed
> -------
> no action taken

Well here we have the explanation to my earlier question - you have version 
2.7!! That explains the AttemptsCounter issue. I am guessing you do not have 
CustEDIConfig.php EDIMessageFormat.php and a few other scripts at all. I 
think the sourceforge mirroring might be a little flaky.

> -----------------------------------------
> Problem
> -------
> Lots of Undefined Variable notices, I suggest some of the testing needs to
> be
> done with notices shown (php.ini setting) rather than switched off.
>

Good point - will do!

>
> Otherwise looking very much smoother than the earlier versions.
>
> I have a prospective user, so my interest has increased.

Hope he/she bites!

Phil

Re: [Web-erp-developers] Re: What might be a bug Customer Transaction Inquiry

[Daintree <p.d...@pa...>]

Danie,

If you could send the new ConnectDB.inc for postgres to me and any changes
to the scripts that were necessary to p.d...@pa... that would
be great.

Will have a look at this issue.

Many thanks
Phil

----- Original Message -----
From: "Danie Brink" <br...@na...>
To: "Phil Daintree" <Web...@li...>
Sent: Wednesday, March 03, 2004 1:50 AM
Subject: [Web-erp-developers] Re: What might be a bug Customer Transaction
Inquiry


> System seems to log of user for no reason :
>
> Sequence :
> Select Main Menu -> Receivables
> Select Inquiries and Reports -> Transaction Inquiries
> Show Transactions ( Sales Invoices From 01/03/2003 To 02/03/2004)
> Click Spy-Glass next to any transaction
> New Page Pops Up & Present Transaction
> Close New Page
> Click any Link and system asks for login
>
> The same seems to happen with Review Sales Order fro Search All Sales
Orders
> And also Search Outstanding Sales Orders.
>
> --
> I am currently making screen-shots for the documentation, so I am trying
> to get examples of everything.
> --
>
> Also I finally noticed there are no GPL Headers or any mention in any
> of the documentation, however the project is listed as such under SF.net.
> Should we not add this ??
>
> P.S. OK, I figured out that version 1.8 does not exist was simply a
> figure of my imagination.
>
> P.S.2 Should I send the DB conversion stuff ???
> I do not know much about CVS and from my experience with
> DWS(DelphiWebScript) and FreePascal things can go horribly wrong.
>
>
> Kind Regards
> Danie Brink
>
>
>
> -------------------------------------------------------
> SF.Net is sponsored by: Speed Start Your Linux Apps Now.
> Build and deploy apps & Web services for Linux with
> a free DVD software kit from IBM. Click Now!
> http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

[Web-erp-developers] Re: What might be a bug Customer Transaction Inquiry

[Danie B. <br...@na...>]

System seems to log of user for no reason :

Sequence :
Select Main Menu -> Receivables
Select Inquiries and Reports -> Transaction Inquiries
Show Transactions ( Sales Invoices From 01/03/2003 To 02/03/2004)
Click Spy-Glass next to any transaction
New Page Pops Up & Present Transaction
Close New Page
Click any Link and system asks for login

The same seems to happen with Review Sales Order fro Search All Sales Orders
And also Search Outstanding Sales Orders.

--
I am currently making screen-shots for the documentation, so I am trying
to get examples of everything.
--

Also I finally noticed there are no GPL Headers or any mention in any 
of the documentation, however the project is listed as such under SF.net.
Should we not add this ??

P.S. OK, I figured out that version 1.8 does not exist was simply a 
figure of my imagination.

P.S.2 Should I send the DB conversion stuff ??? 
I do not know much about CVS and from my experience with 
DWS(DelphiWebScript) and FreePascal things can go horribly wrong.


Kind Regards
Danie Brink

Re: [Web-erp-developers] Download manager

[Phil D. <ph...@du...>]

I use SuSE 8.2
I see what you mean about select max when the transaction has incremented
the autonumber column.It would be nicer to retrieve this ID from the detail
table after the insert. However, I just did a search and discovered. ...

pg_last_oid
(PHP 4 >= 4.2.0)

pg_last_oid -- Returns the last object's oid
Description
int pg_last_oid ( resource result)


pg_last_oid() is used to retrieve the oid assigned to an inserted tuple
(record) if the result resource is used from the last command sent via
pg_query() and was an SQL INSERT. Returns a positive integer if there was a
valid oid. It returns FALSE if an error occurs or the last command sent via
pg_query() was not an INSERT or INSERT is failed.

OID field became an optional field from PostgreSQL 7.2. When OID field is
not defined in a table, programmer must use pg_result_status() to check if
record is is inserted successfully or not.

  Note: This function used to be called pg_getlastoid().

See also pg_query() and pg_result_status()


> >
> Yes, standard transacting is supported, however it using "select max" is
> still a clutch for now, I will replace it with looking up the current
> generator/autonumber value which is guaranteed to be correct in a
> transaction on a per connection basis. The changes to
> DB_LastInsertID is already done, and MySQL still runs without a hitch.
>
> I am busy finalizing the converter to calculate the generator/autonumber
> for setting it at the end of the script. So far everything imports.
>
> I would like to test it in the sql with the foreign keys included.
> I use > mysqldump -u root -c -Q weberp18 >./weberp.sql
>
> Danie
>

[Web-erp-developers] Re: TaxAuthLevels

[Phil D. <ph...@du...>]

Thanks very much Dick, I will include it tonight and try for a release too.

Gosh you have a thousand ideas .... all gratefully received.I will do some
more research on these. I am aware of PEAR - the most popular module being
the db abstration layer. However, there is really quite a performance
penalty in using it so I avoided it deliberately. I have an uneducated
preference for including class files like we have for pdf.php -the R & OS
pdf class and htmlMimeMail.php class for sending email attachments where we
can make it simple for installation and administration.

With respect to include files called .inc you are right. We should try to
change these over time to .php.

With repect to functions used in other scripts, i agree we should keep these
available in a seperate script to be included with each script that needs
them. The script SQL_CommonFunctions.inc is for this purpose. However, I
have the view that functions that are only ever used by the one script can
be left in that script.

Phil

----- Original Message -----
From: "Stins, D.R." <d.r...@wo...>
To: <ph...@du...>
Sent: Thursday, February 26, 2004 12:05 PM
Subject: Re: TaxAuthLevels


> Phil,
>
> I prefer to finish it by myself, but you are in a hurry and I do not have
> enough time left. I was delayed by the flue. So be my guest.
>
> I think that the attached scripts runs fine.
>
> I hoped to make it compatible with the current frontend. Like you said, I
> was struggling understanding a bad example. I hope my proposal is simple
and
> easy to understand.
>
> I splitted the database functions from the frontend script. We get then a
> better readable frontend script and we can reuse the database functions in
> other scripts and it is easier to port to other database engines, since
all
> database engine related functions are in "one" include file. Later I might
> consider to generate these very basic functions from the datamodel for
every
> table.
>
> I do not like the .inc suffix, since people can download the php code with
> the .inc suffix at most servers.
> That's why I used the Inc prefix.
>
> I think we should stop support for disabled foreign keys, but release 2.8
is
> probably too early for that. So you to upgrade the taxauthority.php script
> for release 2.8.
>
> We should consider use classes. See for a introduction:
> http://www.webreference.com/programming/phpanth2/
>
> Since we have future plans for CRM, I think we should consider the horde
> application framework. I mgiht also speedup new developments.
>
> See www.horde.org and http://dev.horde.org/api/horde/.  I think it is a
very
> good example for use of classes. Horde uses also PEAR:
http://pear.php.net/
>
> The documentation is created with http://www.phpdoc.org
>
> Maybe a good idea to use this documentation concept also for web-erp.
>
> With best regards,
>
> Dick Stins
>
> ----- Original Message -----
> From: "Phil Daintree" <ph...@du...>
> To: <DR...@Zi...>
> Sent: Wednesday, February 25, 2004 9:57 AM
> Subject: TaxAuthLevels
>
>
> > Dick,
> >
> > I guess you are struggling here with this. If you send me what you have
I
> will
> > finish it off. Alternatively if you would prefer me to write it, please
> let
> > me know.
> >
> > Since there is a bug in 2.7 I am very keen to get 2.8 out.
> >
> > Sorry to push.
> >
> > Thanks for your help.
> > Phil
> >
>

Re: [Web-erp-developers] Download manager

[Phil D. <ph...@du...>]

Hi Danie,

I have been mucking about with Konqueror and Kget and cant duplicate this 
behaviour.

Are you using the demo on sourceforge or some remote machine or is it all 
local to your LAN. Could it be that the connection was broken for whatever 
reason and kget had to start another download?

Most folks here use windows anyway so I suspect your configuration would no be 
the norm. Mozillia has an inbuilt download manager which I use all the time 
with no worries - Opera too.

I would love to duplicate this problem!

>
> 1 ) request of last inserted id (DB_Last_Inser_ID(&$Conn)), required two
> extra parameters, table, and ID field, these are not used under MySQL,
> but is needed for Postgres, they are therefore enforced, new parameters
> looks as follows, DB_Last_Inser_ID(&$Conn,$table, $fieldname ). This is
> because postgres needs to exec a query like "Select Max(field) from
> tabel" in order to get the last ID, I have not yet resolved the issue of

Last_Insert_ID is used in I think 2 maybe 3 places it maybe there is a better 
work around in these three instances than re-writing the code in 
ConnectDB.inc - the code will need to be re-written anyway because of the 
extra parameters required. Since LastInsertID is mysql specific I'd rather do 
away with it in the interests of compatibility.

> Transaction, as is required, will implement as soon as possible. Needs a
> bit more work.

I thought:

begin

rollback

and 

commit 

were standard ANSI SQL - these are used everywhere and would prevent quite a 
snag if they need to be re-written.

Phil

Re: [Web-erp-developers] Download manager

[Daintree <p.d...@pa...>]

There are quite a few options to the command line utility mysqldump that may
be of use in creating the db sql in the format you require.

I will try Kget in Konqueror

Phil
----- Original Message -----
From: "Danie Brink" <br...@na...>
To: "Phil Daintree" <p.d...@pa...>
Sent: Wednesday, February 25, 2004 9:12 AM
Subject: Re: [Web-erp-developers] Download manager


> On Wed, 2004-02-25 at 09:49, Daintree wrote:
> I use KGet, integrated into Konqueror.
>
> KGet integrates directly into, it can be disabled through KGet's
> settings/preferences.
>
> I am wondering whether a redirect would also be needed on posts, not
> sure!!
>
> P.S. Re:Database
>
> Made the basic modification to access Postgres. I am currently in the
> process of writing a small python SQL translator that can take a MySQL
> export, as provided through phpMyAdmin, and convert it to PGSQL for
> import. This will include the data/inserts but not the aditional indexes
> for now. This will also therefore allow us to scale a client from MySQL
> to Postgres if a bigger database is required at a later stage.
>
> Problems resolved so far :
>
> 1 ) request of last inserted id (DB_Last_Inser_ID(&$Conn)), required two
> extra parameters, table, and ID field, these are not used under MySQL,
> but is needed for Postgres, they are therefore enforced, new parameters
> looks as follows, DB_Last_Inser_ID(&$Conn,$table, $fieldname ). This is
> because postgres needs to exec a query like "Select Max(field) from
> tabel" in order to get the last ID, I have not yet resolved the issue of
> Transaction, as is required, will implement as soon as possible. Needs a
> bit more work.
>
> Kind Regards
> Danie Brink br...@na...
>
>
> > I need to try one of these things.
> >
> > Which one do you use?
> >
> > The work around sounds good.
> >
> > Phil
> >
> >
> > -------------------------------------------------------
> > SF.Net is sponsored by: Speed Start Your Linux Apps Now.
> > Build and deploy apps & Web services for Linux with
> > a free DVD software kit from IBM. Click Now!
> > http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >
>
>

Re: [Web-erp-developers] create demo script

[Phil D. <ph...@du...>]

There will always be an inconsistency when creating a database for the first
time - eg.

DebtorTrans table is attempted to be created first - it would NOT be allowed
because the SysTypes tables does not exist yet and there is a foreign key
for this table which cannot be validated until the SysTypes table can be
created.

I  found that I could not drop tables out of sequence ie one has to drop the
DebtorTrans Table before the SysTypes table to ensure integrity of foreign
keys.

I think in the circumstances foreign keys should be disabled on the creation
of new DBs.

Phil

----- Original Message -----
From: "Stins, Dick" <DR...@Zi...>
To: "Web ERP Developers" <Web...@li...>
Sent: Wednesday, February 25, 2004 11:08 AM
Subject: Re: [Web-erp-developers] create demo script


> Phil,
>
> Dropping the tables is not the problem. MySql just drops it without any
> warning!!! I expect that it also does not function for an empty database.
>
> For the dataload it is too dangerous to turn foreign key checks off,
because
> I am afraid that you might to be able to load data which is not validated
by
> the foreign key constraints.
>
> With best regards,
>
> Dick Stins
>
> ----- Original Message -----
> From: "Phil Daintree" <ph...@du...>
> To: "Web ERP Developers" <Web...@li...>
> Sent: Tuesday, February 24, 2004 10:42 PM
> Subject: Re: [Web-erp-developers] create demo script
>
>
> > BlankYes I saw that. I thought the upgrade script would work for those
> that
> > already had a weberp db. Running the web_erp_demo.sql would hit snags
> > naturally in deleting the tables where there are foreign key constraints
> in
> > other tables. The upgrade script would not have a problem with this.
> >
> > What I haven't tried is running the script when a previous version of
the
> db
> > is not already existing, does this fail too?
> >
> > Loading the demo data from scratch with the web_erp_demo.sql should
> probably
> > have the disable foreign key checks option in like you say - I will
modify
> > this.
> >
> > P
> >   ----- Original Message -----
> >   From: Stins, Dick
> >   To: web...@li...
> >   Sent: Wednesday, February 25, 2004 10:18 AM
> >   Subject: [Web-erp-developers] create demo script
> >
> >
> >     Hoi,
> >
> >     I tried to setup a new demo database.
> >
> >     The foreign keys are causing some trouble.
> >
> >     Although I think we should not use the next statement, it is a quick
> > workaround to add to the script:
> >
> > mysql> SET FOREIGN_KEY_CHECKS = 0;
> > mysql> SOURCE dump_file_name;
> > mysql> SET FOREIGN_KEY_CHECKS = 1;
> > To be in control, we should deliver a script which does
> > not need this workaround.
> > See also:
> > http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html
> >     The load of the demo data is also complaining about the foreign key
> > constraints.
> >
> >     The workaround works too, but there is a chance that the data
> integrity
> > is corrupted, because I suppose that mysql does not check the data
> integrity
> > (foreign keys) when the foreign keys are enabled.
> >
> >     To be sure, we should improve the script with the ability to load
the
> > (demo) data without any problems while the foreign key checks are
enabled.
> >
> >     With best regards,
> >
> >     Dick Stins
> >
>
>
>
>
> -------------------------------------------------------
> SF.Net is sponsored by: Speed Start Your Linux Apps Now.
> Build and deploy apps & Web services for Linux with
> a free DVD software kit from IBM. Click Now!
> http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [Web-erp-developers] create demo script

[Stins, D. <DR...@Zi...>]

Phil,

Dropping the tables is not the problem. MySql just drops it without any
warning!!! I expect that it also does not function for an empty database.

For the dataload it is too dangerous to turn foreign key checks off, because
I am afraid that you might to be able to load data which is not validated by
the foreign key constraints.

With best regards,

Dick Stins

----- Original Message -----
From: "Phil Daintree" <ph...@du...>
To: "Web ERP Developers" <Web...@li...>
Sent: Tuesday, February 24, 2004 10:42 PM
Subject: Re: [Web-erp-developers] create demo script


> BlankYes I saw that. I thought the upgrade script would work for those
that
> already had a weberp db. Running the web_erp_demo.sql would hit snags
> naturally in deleting the tables where there are foreign key constraints
in
> other tables. The upgrade script would not have a problem with this.
>
> What I haven't tried is running the script when a previous version of the
db
> is not already existing, does this fail too?
>
> Loading the demo data from scratch with the web_erp_demo.sql should
probably
> have the disable foreign key checks option in like you say - I will modify
> this.
>
> P
>   ----- Original Message -----
>   From: Stins, Dick
>   To: web...@li...
>   Sent: Wednesday, February 25, 2004 10:18 AM
>   Subject: [Web-erp-developers] create demo script
>
>
>     Hoi,
>
>     I tried to setup a new demo database.
>
>     The foreign keys are causing some trouble.
>
>     Although I think we should not use the next statement, it is a quick
> workaround to add to the script:
>
> mysql> SET FOREIGN_KEY_CHECKS = 0;
> mysql> SOURCE dump_file_name;
> mysql> SET FOREIGN_KEY_CHECKS = 1;
> To be in control, we should deliver a script which does
> not need this workaround.
> See also:
> http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html
>     The load of the demo data is also complaining about the foreign key
> constraints.
>
>     The workaround works too, but there is a chance that the data
integrity
> is corrupted, because I suppose that mysql does not check the data
integrity
> (foreign keys) when the foreign keys are enabled.
>
>     To be sure, we should improve the script with the ability to load the
> (demo) data without any problems while the foreign key checks are enabled.
>
>     With best regards,
>
>     Dick Stins
>

Re: [Web-erp-developers] Download Managers

[Phil D. <ph...@du...>]

I just downloaded Fresh Download and it worked flawlessly - maybe its only
some download managers??

Phil
----- Original Message -----
From: "Danie Brink" <br...@na...>
To: "Phil Daintree" <ph...@du...>
Sent: Wednesday, February 25, 2004 10:10 AM
Subject: Re: [Web-erp-developers] Download Managers


> The download manager follows the instructions it gets from the browser,
> the browser is set to accept mime-types of html/xml/txt directly into
> the browser and also anything sitting inside a <img> tag. Exceptions may
> be made also with jpg, gif and other image file extensions, browser is
> capable of displaying. In other cases it is simply passed to the
> download manager.
>
> Hope this explanation helps.
>
> Kind Regards
> Danie Brink br...@na...
>
>
> On Wed, 2004-02-25 at 12:01, Phil Daintree wrote:
> > So could it be disabled for extensions of .pdf by some configuration of
the
> > download manager ie download managers presumably don't work on standard
web
> > pages only on files like .zip, .gz, .exe, .jpg, .gif etc .... or do
they?
> >
> > We seem to be blessed with good cheap bandwidth in NZ so I really need
to
> > get up to speed with these things.
> >
> > Phil
> >
> > >Hi,
> >
> > >I think that the download manager is activated when it gets an url with
a
> > >suffix .pdf
> > >So while web-erp opens the pdf, then it should be opened with an url
with
> > >suffix .pdf. Probably is this good enough for all download managers.
> > >Some free download managers at:
> >
> > >www.freshdevices.com
> >
> > >www.metaproducts.com
> >
> > >With best regards,
> > >Dick Stins
> >
> > ----- Original Message -----
> > From: "Daintree" <p.d...@pa...>
> > To: "Web-ERP Developers" <Web...@li...>
> > Sent: Tuesday, February 24, 2004 7:49 PM
> > Subject: [Web-erp-developers] Download manager
> >
> >
> > > I need to try one of these things.
> > >
> > > Which one do you use?
> > >
> > > The work around sounds good.
> > >
> > > Phil
> >
> >
> >
> >
> >
> >
> > -------------------------------------------------------
> > SF.Net is sponsored by: Speed Start Your Linux Apps Now.
> > Build and deploy apps & Web services for Linux with
> > a free DVD software kit from IBM. Click Now!
> > http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >
>

Re: [Web-erp-developers] create demo script

[Phil D. <ph...@du...>]

BlankYes I saw that. I thought the upgrade script would work for those that
already had a weberp db. Running the web_erp_demo.sql would hit snags
naturally in deleting the tables where there are foreign key constraints in
other tables. The upgrade script would not have a problem with this.

What I haven't tried is running the script when a previous version of the db
is not already existing, does this fail too?

Loading the demo data from scratch with the web_erp_demo.sql should probably
have the disable foreign key checks option in like you say - I will modify
this.

P
  ----- Original Message -----
  From: Stins, Dick
  To: web...@li...
  Sent: Wednesday, February 25, 2004 10:18 AM
  Subject: [Web-erp-developers] create demo script


    Hoi,

    I tried to setup a new demo database.

    The foreign keys are causing some trouble.

    Although I think we should not use the next statement, it is a quick
workaround to add to the script:

mysql> SET FOREIGN_KEY_CHECKS = 0;
mysql> SOURCE dump_file_name;
mysql> SET FOREIGN_KEY_CHECKS = 1;
To be in control, we should deliver a script which does
not need this workaround.
See also:
http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html
    The load of the demo data is also complaining about the foreign key
constraints.

    The workaround works too, but there is a chance that the data integrity
is corrupted, because I suppose that mysql does not check the data integrity
(foreign keys) when the foreign keys are enabled.

    To be sure, we should improve the script with the ability to load the
(demo) data without any problems while the foreign key checks are enabled.

    With best regards,

    Dick Stins

Re: [Web-erp-developers] POS

[Stins, D. <DR...@Zi...>]

 Hoi,

 I know that in The Netherlands, there is a bakery chain using (free?)
 mercator. I has over 100 shops.

 Their amount of different items is limited. I guess about 200.

 With best regards,

 Dick Stins

> ----- Original Message -----
> From: "Phil Daintree" <ph...@du...>
> To: <web...@li...>
> Sent: Tuesday, February 24, 2004 8:31 AM
> Subject: [Web-erp-developers] POS
>
>
> >
> > I am almost clueless about what is required for a POS system but here
are
> a
> > few links:
> >
> > The perl ones ... ???
> > http://gibbon.sourceforge.net/
> > http://l-ane.sourceforge.net/
> >
> > a php one ...
> > http://www.phppointofsale.com/
> >
> > java ones ..
> >
> > http://freemercator.sourceforge.net/
> > http://www.open-mag.com/features/Vol_65/POS/mercator.htm
> >
> > General POS info:
> >
> > http://www.linux-pos.org/openspos.html
> >
> > Phil
> >
> >
> >
> >
> >
> > -------------------------------------------------------
> > SF.Net is sponsored by: Speed Start Your Linux Apps Now.
> > Build and deploy apps & Web services for Linux with
> > a free DVD software kit from IBM. Click Now!
> > http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >
>
>
>