Loading demo database

View: New views
20 Messages — Rating Filter:   Alert me  
< Prev | 1 - 2 | Next >

Parent Message unknown Loading demo database

by Glenn Lyons :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


> Date: Sun, 25 Oct 2009 12:15:17 +0800
> From: Phil Daintree <phil@...>
> Subject: Re: [WebERP-developers] Loading demo database
> To: webERP Developers <web-erp-developers@...>
> Message-ID: <4AE3D0D5.20402@...>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> If you drop the database completely then rerun.
>
> Phil
>
> Glenn Lyons wrote:
>  
>> Hi all,
>>
>> When loading the demo database I get this error.
>>
>> Command:
>> "mysql --user=root --password=xxxxx <webERP/sql/mysql/weberp-demo.sql"
>>
>> Results:
>> ERROR 1062 (23000) at line 6326: Duplicate entry 'None' for key
>> 'factor_name'
>>
>> I can see that I have half a demo database with only one for the three
>> company records that start on line 6326.
>>
>> How do I fix this? Can I delete the other two duplicate records?
>>
>> Thanks,
>>
>> Glenn
>>
>>
>> ------------------------------------------------------------------------------
>> 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
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web-erp-developers@...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>  
>>    
>
>
>
>  
Hi Phil,

Thanks for the input. Yes I have tried the drop and reload approach a
few times, always with the same resulting Error. I have also downloaded
the distribution again. It is named webERP_3.11.zip and I have
extracted  weberp/webERP/sql/mysql/weberp-demo.sql again, and diff'ed it
against the one I downloaded a week ago and that is giving the error
message. They are identical.

diff weberp-demo.sql weberp-demo.sql.orig ----> 0 exit

The uname command produces, Linux 2.6.31-14-generic #46-Ubuntu SMP Tue
Oct 13 16:47:59 UTC 2009 i686 GNU/Linux.

The mysql --version command produces,  Ver 14.14 Distrib 5.1.37, for
debian-linux-gnu (i486) using  EditLine wrapper

weberp_db_user@localhost has all privileges.

The offending lines are:
INSERT INTO `factorcompanies` VALUES
(4,'None','','','','','','','','','','');
INSERT INTO `factorcompanies` VALUES
(5,'None','','','','','','','','','','');  <-- 6326 ERROR!!!
INSERT INTO `factorcompanies` VALUES
(6,'None','','','','','','','','','','');

If I delete two of the above lines the load executes without error. I
deleted the last two entries.

Has anyone else experienced this error? Can I be that unique?

Can I delete two of the factorcompanies  table rows without  impacting
the demo's functional?

Thanks in advance for anyone that can shed some light on this one.

Glenn





------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: Loading demo database

by Phil Daintree-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I executed the demo script yesterday without errors.
The factor companies can be discarded (as they should in my view) as
soon as possible!

Phil


Glenn Lyons wrote:

>> Date: Sun, 25 Oct 2009 12:15:17 +0800
>> From: Phil Daintree <phil@...>
>> Subject: Re: [WebERP-developers] Loading demo database
>> To: webERP Developers <web-erp-developers@...>
>> Message-ID: <4AE3D0D5.20402@...>
>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>>
>> If you drop the database completely then rerun.
>>
>> Phil
>>
>> Glenn Lyons wrote:
>>  
>>> Hi all,
>>>
>>> When loading the demo database I get this error.
>>>
>>> Command:
>>> "mysql --user=root --password=xxxxx <webERP/sql/mysql/weberp-demo.sql"
>>>
>>> Results:
>>> ERROR 1062 (23000) at line 6326: Duplicate entry 'None' for key
>>> 'factor_name'
>>>
>>> I can see that I have half a demo database with only one for the three
>>> company records that start on line 6326.
>>>
>>> How do I fix this? Can I delete the other two duplicate records?
>>>
>>> Thanks,
>>>
>>> Glenn
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> 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
>>> _______________________________________________
>>> Web-erp-developers mailing list
>>> Web-erp-developers@...
>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>
>>>  
>>>    
>>
>>
>>  
> Hi Phil,
>
> Thanks for the input. Yes I have tried the drop and reload approach a
> few times, always with the same resulting Error. I have also downloaded
> the distribution again. It is named webERP_3.11.zip and I have
> extracted  weberp/webERP/sql/mysql/weberp-demo.sql again, and diff'ed it
> against the one I downloaded a week ago and that is giving the error
> message. They are identical.
>
> diff weberp-demo.sql weberp-demo.sql.orig ----> 0 exit
>
> The uname command produces, Linux 2.6.31-14-generic #46-Ubuntu SMP Tue
> Oct 13 16:47:59 UTC 2009 i686 GNU/Linux.
>
> The mysql --version command produces,  Ver 14.14 Distrib 5.1.37, for
> debian-linux-gnu (i486) using  EditLine wrapper
>
> weberp_db_user@localhost has all privileges.
>
> The offending lines are:
> INSERT INTO `factorcompanies` VALUES
> (4,'None','','','','','','','','','','');
> INSERT INTO `factorcompanies` VALUES
> (5,'None','','','','','','','','','','');  <-- 6326 ERROR!!!
> INSERT INTO `factorcompanies` VALUES
> (6,'None','','','','','','','','','','');
>
> If I delete two of the above lines the load executes without error. I
> deleted the last two entries.
>
> Has anyone else experienced this error? Can I be that unique?
>
> Can I delete two of the factorcompanies  table rows without  impacting
> the demo's functional?
>
> Thanks in advance for anyone that can shed some light on this one.
>
> Glenn
>
>
>
>
>
> ------------------------------------------------------------------------------
> 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
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: Loading demo database

by Glenn Lyons :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Thank you for the reply. 

I will proceed undaunted with only one "factor companies" (whatever they are).

It shall remain unexplained why I get this error and you do not!

Again, thank for your input.

Glenn

Phil Daintree wrote:
I executed the demo script yesterday without errors.
The factor companies can be discarded (as they should in my view) as 
soon as possible!

Phil


Glenn Lyons wrote:
  
Date: Sun, 25 Oct 2009 12:15:17 +0800
From: Phil Daintree phil@...
Subject: Re: [WebERP-developers] Loading demo database
To: webERP Developers web-erp-developers@...
Message-ID: 4AE3D0D5.20402@...
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

If you drop the database completely then rerun.

Phil

Glenn Lyons wrote:
  
      
Hi all,

When loading the demo database I get this error.

Command:
"mysql --user=root --password=xxxxx <webERP/sql/mysql/weberp-demo.sql"

Results:
ERROR 1062 (23000) at line 6326: Duplicate entry 'None' for key 
'factor_name'

I can see that I have half a demo database with only one for the three 
company records that start on line 6326.

How do I fix this? Can I delete the other two duplicate records?

Thanks,

Glenn


------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

  
    
        
  
      
Hi Phil,

Thanks for the input. Yes I have tried the drop and reload approach a 
few times, always with the same resulting Error. I have also downloaded 
the distribution again. It is named webERP_3.11.zip and I have 
extracted  weberp/webERP/sql/mysql/weberp-demo.sql again, and diff'ed it 
against the one I downloaded a week ago and that is giving the error 
message. They are identical.

diff weberp-demo.sql weberp-demo.sql.orig ----> 0 exit

The uname command produces, Linux 2.6.31-14-generic #46-Ubuntu SMP Tue 
Oct 13 16:47:59 UTC 2009 i686 GNU/Linux.

The mysql --version command produces,  Ver 14.14 Distrib 5.1.37, for 
debian-linux-gnu (i486) using  EditLine wrapper

weberp_db_user@localhost has all privileges.

The offending lines are: 
INSERT INTO `factorcompanies` VALUES 
(4,'None','','','','','','','','','','');
INSERT INTO `factorcompanies` VALUES 
(5,'None','','','','','','','','','','');  <-- 6326 ERROR!!!
INSERT INTO `factorcompanies` VALUES 
(6,'None','','','','','','','','','','');

If I delete two of the above lines the load executes without error. I 
deleted the last two entries.

Has anyone else experienced this error? Can I be that unique?

Can I delete two of the factorcompanies  table rows without  impacting 
the demo's functional?

Thanks in advance for anyone that can shed some light on this one.

Glenn





------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

    

------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers



  


------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: Loading demo database

by Javier de Lorenzo-Cáceres :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.
I reported this error to bug tracker http://sourceforge.net/tracker/?group_id=70949&atid=529585 on SEP 1st with the lowest priority (color blue). Its name is "weberp-demo.sql error" and number 2848366. It's still in the first page (first 10) in line 9.
 
Glenn, the errors are corrected in the cvs, you will find better and will save your time getting familiar with the project along the program. I think that factor companies are those about collecting or retrieving money from invoices that belong to other companies and were not paid.
 
Thanks for your feedback,
javier
 
 
----- Original Message -----
From: glenn@...
Sent: Wednesday, October 28, 2009 7:31 AM
Subject: Re: [WebERP-developers] Loading demo database

Thank you for the reply. 

I will proceed undaunted with only one "factor companies" (whatever they are).

It shall remain unexplained why I get this error and you do not!

Again, thank for your input.

Glenn

Phil Daintree wrote:
I executed the demo script yesterday without errors.
The factor companies can be discarded (as they should in my view) as 
soon as possible!

Phil


Glenn Lyons wrote:
  
Date: Sun, 25 Oct 2009 12:15:17 +0800
From: Phil Daintree phil@...
Subject: Re: [WebERP-developers] Loading demo database
To: webERP Developers web-erp-developers@...
Message-ID: 4AE3D0D5.20402@...
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

If you drop the database completely then rerun.

Phil

Glenn Lyons wrote:
  
      
Hi all,

When loading the demo database I get this error.

Command:
"mysql --user=root --password=xxxxx <webERP/sql/mysql/weberp-demo.sql"

Results:
ERROR 1062 (23000) at line 6326: Duplicate entry 'None' for key 
'factor_name'

I can see that I have half a demo database with only one for the three 
company records that start on line 6326.

How do I fix this? Can I delete the other two duplicate records?

Thanks,

Glenn


------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

  
    
        
  
      
Hi Phil,

Thanks for the input. Yes I have tried the drop and reload approach a 
few times, always with the same resulting Error. I have also downloaded 
the distribution again. It is named webERP_3.11.zip and I have 
extracted  weberp/webERP/sql/mysql/weberp-demo.sql again, and diff'ed it 
against the one I downloaded a week ago and that is giving the error 
message. They are identical.

diff weberp-demo.sql weberp-demo.sql.orig ----> 0 exit

The uname command produces, Linux 2.6.31-14-generic #46-Ubuntu SMP Tue 
Oct 13 16:47:59 UTC 2009 i686 GNU/Linux.

The mysql --version command produces,  Ver 14.14 Distrib 5.1.37, for 
debian-linux-gnu (i486) using  EditLine wrapper

weberp_db_user@localhost has all privileges.

The offending lines are: 
INSERT INTO `factorcompanies` VALUES 
(4,'None','','','','','','','','','','');
INSERT INTO `factorcompanies` VALUES 
(5,'None','','','','','','','','','','');  <-- 6326 ERROR!!!
INSERT INTO `factorcompanies` VALUES 
(6,'None','','','','','','','','','','');

If I delete two of the above lines the load executes without error. I 
deleted the last two entries.

Has anyone else experienced this error? Can I be that unique?

Can I delete two of the factorcompanies  table rows without  impacting 
the demo's functional?

Thanks in advance for anyone that can shed some light on this one.

Glenn





------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

    

------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers



  


------------------------------------------------------------------------------
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


_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: Loading demo database

by Tim Schofield :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

2009/10/28 AESE, S.L., Javier de Lorenzo-Cáceres. <info@...>:
> I think
> that factor companies are those about collecting or retrieving money from
> invoices that belong to other companies and were not paid.

Factor companies are finance companies - frequently banks - to whom a
supplier has sold the invoice. The cheque and the remittance advice
have to be payable to the factor company and not the supplier. There
are a few UK users I know of that use this functionality which is why
I added it. It was one of my earlier contributions and if I was doing
it now I would implement it differently. I will have a look at it to
see if I can improve it without messing up those that currently use
it.

Thanks
Tim

------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: Loading demo database

by Javier de Lorenzo-Cáceres :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Thanks a lot Tim, it's a very good explanation and it has to do with the bug
reported recently at bug tracker and still open. I have just experienced the
same little error, and it's very easy to sort but it shows another behaviour
I would like to tell you. The bug reported is:

2872789, mysql error - can't add new supplier, Open, 2009-10-05, nobody,
nobody, None, 5

It's because the table factorcompanies is empty. Creating a record for a
default factor called None solves it. I tried to create the factor within
the GUI without success, then I inserted the record manually. Now the
behaviour is that the factor appears in the form to create a supplier but it
doesn't appear in the form to maintain factor companies. Then, I can't edit
the factor and also, the button to create a new second factor does nothing,
better said, it shows a form and the button in this form does nothing.

I think we should,
1) write a comment in bug tracker to explain how to sort this little
problem.
2) include the insert into statement in weberp-new.sql
3) to take a look at Factors.php (when you be able and want of course)

Must say that I liked very much the style of programming with a button to
edit and another to create a new and this last to show a new form to enter
field values, this is the way I like. I only miss a link to go back if the
user doesn't want to create a new factor (the typical cancel or back button
or link) because the browser's back button returns the typical and a bit
annoying "expired page".

Many thanks and regards,
javier


----- Original Message -----
From: "Tim Schofield" <tim.schofield1960@...>
To: "webERP Developers" <web-erp-developers@...>
Sent: Wednesday, October 28, 2009 11:17 AM
Subject: Re: [WebERP-developers] Loading demo database


> 2009/10/28 AESE, S.L., Javier de Lorenzo-Cáceres. <info@...>:
>> I think
>> that factor companies are those about collecting or retrieving money from
>> invoices that belong to other companies and were not paid.
>
> Factor companies are finance companies - frequently banks - to whom a
> supplier has sold the invoice. The cheque and the remittance advice
> have to be payable to the factor company and not the supplier. There
> are a few UK users I know of that use this functionality which is why
> I added it. It was one of my earlier contributions and if I was doing
> it now I would implement it differently. I will have a look at it to
> see if I can improve it without messing up those that currently use
> it.
>
> Thanks
> Tim
>
> ------------------------------------------------------------------------------
> 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
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>


------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: Loading demo database

by Javier de Lorenzo-Cáceres :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Tim, I have just added a comment into the bug and closed it. Forgot to
say that better approachs are possible, these were only early and a bit lazy
ones, of course it would be better to handle the error before it is produced
as you do in many other scripts.

Thanks,
javier


----- Original Message -----
From: "AESE, S.L., Javier de Lorenzo-Cáceres." <info@...>
To: "webERP Developers" <web-erp-developers@...>
Sent: Wednesday, October 28, 2009 11:56 AM
Subject: Re: [WebERP-developers] Loading demo database


> Thanks a lot Tim, it's a very good explanation and it has to do with the
> bug
> reported recently at bug tracker and still open. I have just experienced
> the
> same little error, and it's very easy to sort but it shows another
> behaviour
> I would like to tell you. The bug reported is:
>
> 2872789, mysql error - can't add new supplier, Open, 2009-10-05, nobody,
> nobody, None, 5
>
> It's because the table factorcompanies is empty. Creating a record for a
> default factor called None solves it. I tried to create the factor within
> the GUI without success, then I inserted the record manually. Now the
> behaviour is that the factor appears in the form to create a supplier but
> it
> doesn't appear in the form to maintain factor companies. Then, I can't
> edit
> the factor and also, the button to create a new second factor does
> nothing,
> better said, it shows a form and the button in this form does nothing.
>
> I think we should,
> 1) write a comment in bug tracker to explain how to sort this little
> problem.
> 2) include the insert into statement in weberp-new.sql
> 3) to take a look at Factors.php (when you be able and want of course)
>
> Must say that I liked very much the style of programming with a button to
> edit and another to create a new and this last to show a new form to enter
> field values, this is the way I like. I only miss a link to go back if the
> user doesn't want to create a new factor (the typical cancel or back
> button
> or link) because the browser's back button returns the typical and a bit
> annoying "expired page".
>
> Many thanks and regards,
> javier
>
>
> ----- Original Message -----
> From: "Tim Schofield" <tim.schofield1960@...>
> To: "webERP Developers" <web-erp-developers@...>
> Sent: Wednesday, October 28, 2009 11:17 AM
> Subject: Re: [WebERP-developers] Loading demo database
>
>
>> 2009/10/28 AESE, S.L., Javier de Lorenzo-Cáceres. <info@...>:
>>> I think
>>> that factor companies are those about collecting or retrieving money
>>> from
>>> invoices that belong to other companies and were not paid.
>>
>> Factor companies are finance companies - frequently banks - to whom a
>> supplier has sold the invoice. The cheque and the remittance advice
>> have to be payable to the factor company and not the supplier. There
>> are a few UK users I know of that use this functionality which is why
>> I added it. It was one of my earlier contributions and if I was doing
>> it now I would implement it differently. I will have a look at it to
>> see if I can improve it without messing up those that currently use
>> it.
>>
>> Thanks
>> Tim
>>
>> ------------------------------------------------------------------------------
>> 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
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web-erp-developers@...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>
>
> ------------------------------------------------------------------------------
> 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
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>


------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: Loading demo database

by Glenn Lyons :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

AESE, S.L., Javier de Lorenzo-Cáceres. wrote:

> Thanks a lot Tim, it's a very good explanation and it has to do with the bug
> reported recently at bug tracker and still open. I have just experienced the
> same little error, and it's very easy to sort but it shows another behaviour
> I would like to tell you. The bug reported is:
>
> 2872789, mysql error - can't add new supplier, Open, 2009-10-05, nobody,
> nobody, None, 5
>
> It's because the table factorcompanies is empty. Creating a record for a
> default factor called None solves it. I tried to create the factor within
> the GUI without success, then I inserted the record manually. Now the
> behaviour is that the factor appears in the form to create a supplier but it
> doesn't appear in the form to maintain factor companies. Then, I can't edit
> the factor and also, the button to create a new second factor does nothing,
> better said, it shows a form and the button in this form does nothing.
>
> I think we should,
> 1) write a comment in bug tracker to explain how to sort this little
> problem.
> 2) include the insert into statement in weberp-new.sql
> 3) to take a look at Factors.php (when you be able and want of course)
>
> Must say that I liked very much the style of programming with a button to
> edit and another to create a new and this last to show a new form to enter
> field values, this is the way I like. I only miss a link to go back if the
> user doesn't want to create a new factor (the typical cancel or back button
> or link) because the browser's back button returns the typical and a bit
> annoying "expired page".
>
> Many thanks and regards,
> javier
>
>
> ----- Original Message -----
> From: "Tim Schofield" <tim.schofield1960@...>
> To: "webERP Developers" <web-erp-developers@...>
> Sent: Wednesday, October 28, 2009 11:17 AM
> Subject: Re: [WebERP-developers] Loading demo database
>
>
>  
>> 2009/10/28 AESE, S.L., Javier de Lorenzo-Cáceres. <info@...>:
>>    
>>> I think
>>> that factor companies are those about collecting or retrieving money from
>>> invoices that belong to other companies and were not paid.
>>>      
>> Factor companies are finance companies - frequently banks - to whom a
>> supplier has sold the invoice. The cheque and the remittance advice
>> have to be payable to the factor company and not the supplier. There
>> are a few UK users I know of that use this functionality which is why
>> I added it. It was one of my earlier contributions and if I was doing
>> it now I would implement it differently. I will have a look at it to
>> see if I can improve it without messing up those that currently use
>> it.
>>
>> Thanks
>> Tim
>>
>> ------------------------------------------------------------------------------
>> 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
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web-erp-developers@...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>    
>
>
> ------------------------------------------------------------------------------
> 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
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>  
To Javier,

You say  "I only miss a link to go back if the
user doesn't want to create a new factor (the typical cancel or back button..."

Can the window history be used in the footer.inc ........

function goBack() {
        if (window.history.length <= 1)
         window.close();
        else
         window.history.go(-1);
}


I have read the programming standards doc and I understand it is strict
about the use JavaScript.
The goal is minimum bandwidth and maximum portability to browsers.

If JavaScript is not enable then the user does not get this option but
the same functionally still
remains as now. Also I cannot see how this would use much bandwidth and
portability should not be impared as it is not main line functionality,
just a convenience.

I am new to this list, so I will not be offended if you want to set me
straight on the use of JavaScript. (Politely, I hope).


To Tim,

Thanks for the concise explanation  of factorcompanies table . I am
familiar with the concept of  factorizing
of current assets such as outstanding receivable ledger, I did not
connect the table name to it. Too obvious I guess!

Glenn


------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: Loading demo database

by Javier de Lorenzo-Cáceres :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Glenn and Tim

I don't feel like have not been polite, but please pardon me if I was.

thanks,
javier


----- Original Message -----
From: "Glenn Lyons" <glenn@...>
To: "webERP Developers" <web-erp-developers@...>
Sent: Thursday, October 29, 2009 2:39 AM
Subject: Re: [WebERP-developers] Loading demo database


> AESE, S.L., Javier de Lorenzo-Cáceres. wrote:
>> Thanks a lot Tim, it's a very good explanation and it has to do with the
>> bug
>> reported recently at bug tracker and still open. I have just experienced
>> the
>> same little error, and it's very easy to sort but it shows another
>> behaviour
>> I would like to tell you. The bug reported is:
>>
>> 2872789, mysql error - can't add new supplier, Open, 2009-10-05, nobody,
>> nobody, None, 5
>>
>> It's because the table factorcompanies is empty. Creating a record for a
>> default factor called None solves it. I tried to create the factor within
>> the GUI without success, then I inserted the record manually. Now the
>> behaviour is that the factor appears in the form to create a supplier but
>> it
>> doesn't appear in the form to maintain factor companies. Then, I can't
>> edit
>> the factor and also, the button to create a new second factor does
>> nothing,
>> better said, it shows a form and the button in this form does nothing.
>>
>> I think we should,
>> 1) write a comment in bug tracker to explain how to sort this little
>> problem.
>> 2) include the insert into statement in weberp-new.sql
>> 3) to take a look at Factors.php (when you be able and want of course)
>>
>> Must say that I liked very much the style of programming with a button to
>> edit and another to create a new and this last to show a new form to
>> enter
>> field values, this is the way I like. I only miss a link to go back if
>> the
>> user doesn't want to create a new factor (the typical cancel or back
>> button
>> or link) because the browser's back button returns the typical and a bit
>> annoying "expired page".
>>
>> Many thanks and regards,
>> javier
>>
>>
>> ----- Original Message -----
>> From: "Tim Schofield" <tim.schofield1960@...>
>> To: "webERP Developers" <web-erp-developers@...>
>> Sent: Wednesday, October 28, 2009 11:17 AM
>> Subject: Re: [WebERP-developers] Loading demo database
>>
>>
>>
>>> 2009/10/28 AESE, S.L., Javier de Lorenzo-Cáceres. <info@...>:
>>>
>>>> I think
>>>> that factor companies are those about collecting or retrieving money
>>>> from
>>>> invoices that belong to other companies and were not paid.
>>>>
>>> Factor companies are finance companies - frequently banks - to whom a
>>> supplier has sold the invoice. The cheque and the remittance advice
>>> have to be payable to the factor company and not the supplier. There
>>> are a few UK users I know of that use this functionality which is why
>>> I added it. It was one of my earlier contributions and if I was doing
>>> it now I would implement it differently. I will have a look at it to
>>> see if I can improve it without messing up those that currently use
>>> it.
>>>
>>> Thanks
>>> Tim
>>>
>>> ------------------------------------------------------------------------------
>>> 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
>>> _______________________________________________
>>> Web-erp-developers mailing list
>>> Web-erp-developers@...
>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>
>>>
>>
>>
>> ------------------------------------------------------------------------------
>> 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
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web-erp-developers@...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
> To Javier,
>
> You say  "I only miss a link to go back if the
> user doesn't want to create a new factor (the typical cancel or back
> button..."
>
> Can the window history be used in the footer.inc ........
>
> function goBack() {
>        if (window.history.length <= 1)
>         window.close();
>        else
>         window.history.go(-1);
> }
>
>
> I have read the programming standards doc and I understand it is strict
> about the use JavaScript.
> The goal is minimum bandwidth and maximum portability to browsers.
>
> If JavaScript is not enable then the user does not get this option but
> the same functionally still
> remains as now. Also I cannot see how this would use much bandwidth and
> portability should not be impared as it is not main line functionality,
> just a convenience.
>
> I am new to this list, so I will not be offended if you want to set me
> straight on the use of JavaScript. (Politely, I hope).
>
>
> To Tim,
>
> Thanks for the concise explanation  of factorcompanies table . I am
> familiar with the concept of  factorizing
> of current assets such as outstanding receivable ledger, I did not
> connect the table name to it. Too obvious I guess!
>
> Glenn
>
>
> ------------------------------------------------------------------------------
> 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
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>


------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: Loading demo database

by Glenn Lyons :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

AESE, S.L., Javier de Lorenzo-Cáceres. wrote:
> Hi Glenn and Tim
>
> I don't feel like have not been polite, but please pardon me if I was.
>
> thanks,
> javier
>
>
>  
Javier,

You have misunderstood me. I do not suggest that you were "not polite".

My meaning is that *I* might not be polite for making coding suggestions
when I have just joined the list.

My sincere apologies for the confusion.  I read your posts with great
interest and look forward to reading more.

Maybe it is just the way we Aussie's (or this Aussie) choose our words?
I will try and be a little clearer in future posts.

No pardon required.

Glenn





------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: Loading demo database

by Tim Schofield :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Glenn,

Sometimes email and different native languages means that
misunderstandings occur. Good code is acceptable from anybody,
regardless of how long they have been on the list.

 My concern with a back button has always been that users may
duplicate a transaction. I know the same thing is possible if they hit
the back button on the browser, I just feel maybe we shouldn't give
them the ability to do it through webERP.

However I still like the idea of a back button, I often see users
trying to go back. I wonder if its possible to do this in a smart way
so that a transaction can't get reposted?

Thanks
Tim

2009/10/29 Glenn Lyons <glenn@...>:

> AESE, S.L., Javier de Lorenzo-Cáceres. wrote:
>> Hi Glenn and Tim
>>
>> I don't feel like have not been polite, but please pardon me if I was.
>>
>> thanks,
>> javier
>>
>>
>>
> Javier,
>
> You have misunderstood me. I do not suggest that you were "not polite".
>
> My meaning is that *I* might not be polite for making coding suggestions
> when I have just joined the list.
>
> My sincere apologies for the confusion.  I read your posts with great
> interest and look forward to reading more.
>
> Maybe it is just the way we Aussie's (or this Aussie) choose our words?
> I will try and be a little clearer in future posts.
>
> No pardon required.
>
> Glenn
>
>
>
>
>
> ------------------------------------------------------------------------------
> 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
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: Loading demo database

by Phil Daintree-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Well in most (hopefully all) transactions scripts the session variables
containing transactions are emptied (unset) so going back will not hurt
... but almost certainly won't be what the user wants - they will
perhaps want to undo the transactions they just posted ... not sure. In
most cases where a transaction is not involved a back button would be great

Phil

Tim Schofield wrote:

> Hi Glenn,
>
> Sometimes email and different native languages means that
> misunderstandings occur. Good code is acceptable from anybody,
> regardless of how long they have been on the list.
>
>  My concern with a back button has always been that users may
> duplicate a transaction. I know the same thing is possible if they hit
> the back button on the browser, I just feel maybe we shouldn't give
> them the ability to do it through webERP.
>
> However I still like the idea of a back button, I often see users
> trying to go back. I wonder if its possible to do this in a smart way
> so that a transaction can't get reposted?
>
> Thanks
> Tim
>
> 2009/10/29 Glenn Lyons <glenn@...>:
>> AESE, S.L., Javier de Lorenzo-Cáceres. wrote:
>>> Hi Glenn and Tim
>>>
>>> I don't feel like have not been polite, but please pardon me if I was.
>>>
>>> thanks,
>>> javier
>>>
>>>
>>>
>> Javier,
>>
>> You have misunderstood me. I do not suggest that you were "not polite".
>>
>> My meaning is that *I* might not be polite for making coding suggestions
>> when I have just joined the list.
>>
>> My sincere apologies for the confusion.  I read your posts with great
>> interest and look forward to reading more.
>>
>> Maybe it is just the way we Aussie's (or this Aussie) choose our words?
>> I will try and be a little clearer in future posts.
>>
>> No pardon required.
>>
>> Glenn
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> 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
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web-erp-developers@...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>
> ------------------------------------------------------------------------------
> 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
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: Loading demo database

by Javier de Lorenzo-Cáceres :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Glenn,

Sorry. My english is not as good as I would like. I'm able to understand and
explain more or less about tech cause I know the terms and I'm always
reading about it but no further than that. I'm also a bit new to the list,
it was only a few months ago when I joined.

For the subject, I believe that window.history.go(-1) is what browser's back
button does and window.close() will loose focus without closing the session
what may be a security risk if session remains. I believe that javascript
only tells the browser to do something. For the back button, It doesn't
matter what CGI developers use or what browser the client use, care should
always taken about it; it's the natural behaviour and it makes sense since
page content depends on variable values that may have been changed.

I like web applications to hide all browser's controls and window's controls
and provide a consistent GUI. Doing so we avoid the aforementioned
behaviour, have more desktop space and less security concerns.

Developers of desktop applications face a similar challenge when they have
to take care of other window's content to be updated by changes being made
in the active window, especially when both windows content depend on each
other. For example, to ease the pain a bit, C Builder and Delphi provide two
choices for the developer to show a window: Show and ShowModal. ShowModal
protects the application from the user that is determined to make the
database going into an inconsistence state. Also a similar subject has to do
with sessions.

You can save your time not reading the following example using Delphi and a
multi-user local database for Windows. It's more or less the same case that
several browser windows or tabs opened by the user or the application when
the content of them depend on each other. The difference is that here we can
ask if a window is open and also restrict which windows can remain opened
and which not, i.e., we provide the user just one way to do things. You may
think on it as prohibiting the user to open a browser window or tab to
WebERP if another WebERP page is currently open. PhP does something similar
with user php sessions, and Windows Terminal Services Server corrected
sessions on version 2003 cause the "problem" is present on version 2000;
also VNC server has the same "problem" with sessions by now. I quoted
problem because permitting one user account to initiate more than one
session is only a matter of taste, VNC could ask the user if he wants to
connect to the console session or not. The solution making session=user is
only one approach, maybe the prefered, at least the one I prefer, but the
subject could be solved in a different manner.

This is also similar to the old well-known problem solved by ACID
transactions: a bank account with a balance of 10 and two diferent bank
branchs where two separates cheques for that account of 10 each are
presented simultaneously on every branch. Pak Ricard has recently reported
this issue with WebERP Purchase Order. He posted yesterday "To solve it,
needed to update Auto-increment value for purchorders and systypes for
purchorders conveniently". I don't understand the solution very much but I'm
interested and will test as soon as I can.

Thanks for your feedback and warmest regards,
javier

The example you may forget about it :-)
We have two windows, 1 and 6, and the content of them depend on each other.
Window 6 will do transactions. The possible errors, called exceptions, are
handled in the Win32 System Messages Tail that may be captured and handled
using an except statement to call the Win32 API, I omitted the corresponding
code.

begin
if Form1.Table1CustomerID.value = '' then
   ShowMessage ('A Customer is Required. Please, Select a Customer.')
else
   begin
   Form1.Table1.CheckBrowseMode;            //*** It has to do with
concurrency and consistency.
   try                                                               //***
miliseconds can make a difference, system also helps.
      Form1.Table1.Edit;                                  // *** This is the
content on Window 1 that is going to be changed on Window 6.
      if Form1.Table1.State= dsEdit then
         with TForm6.Create(Application) do     //*** The Window 6 is
created dinamically at runtime.
            try
               ShowModal;                                   //*** Modal
means this Window 6 must be closed to continue in another, if not doing so,
Murphy and the user will conspirate :-)
            finally
               Free;                                               // ***
Just after the Window is closed, the Windows is destroyed dinamically at
runtime to save main memory.
               end;
   finally                                                          //
statements forced to be executed
      Form1.Table1.CheckBrowseMode;
      end;
   end;
end;                                                              // end
procedure button 6 click



> AESE, S.L., Javier de Lorenzo-Cáceres. wrote:
>> Hi Glenn and Tim
>>
>> I don't feel like have not been polite, but please pardon me if I was.
>>
>> thanks,
>> javier
>>
>>
>>
> Javier,
>
> You have misunderstood me. I do not suggest that you were "not polite".
>
> My meaning is that *I* might not be polite for making coding suggestions
> when I have just joined the list.
>
> My sincere apologies for the confusion.  I read your posts with great
> interest and look forward to reading more.
>
> Maybe it is just the way we Aussie's (or this Aussie) choose our words?
> I will try and be a little clearer in future posts.
>
> No pardon required.
>
> Glenn
>
>
>
>
>
> ------------------------------------------------------------------------------
> 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
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>


------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: Loading demo database

by Glenn Lyons :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Tim Schofield wrote:

> Hi Glenn,
>
> Sometimes email and different native languages means that
> misunderstandings occur. Good code is acceptable from anybody,
> regardless of how long they have been on the list.
>
>  My concern with a back button has always been that users may
> duplicate a transaction. I know the same thing is possible if they hit
> the back button on the browser, I just feel maybe we shouldn't give
> them the ability to do it through webERP.
>
> However I still like the idea of a back button, I often see users
> trying to go back. I wonder if its possible to do this in a smart way
> so that a transaction can't get reposted?
>
> Thanks
> Tim
>
> 2009/10/29 Glenn Lyons <glenn@...>:
>  
>> AESE, S.L., Javier de Lorenzo-Cáceres. wrote:
>>    
>>> Hi Glenn and Tim
>>>
>>> I don't feel like have not been polite, but please pardon me if I was.
>>>
>>> thanks,
>>> javier
>>>
>>>
>>>
>>>      
>> Javier,
>>
>> You have misunderstood me. I do not suggest that you were "not polite".
>>
>> My meaning is that *I* might not be polite for making coding suggestions
>> when I have just joined the list.
>>
>> My sincere apologies for the confusion.  I read your posts with great---------------------------------------
>> interest and look forward to reading more.
>>
>> Maybe it is just the way we Aussie's (or this Aussie) choose our words?
>> I will try and be a little clearer in future posts.
>>
>> No pardon required.
>>
>> Glenn
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> 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
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web-erp-developers@...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>    
>
> ------------------------------------------------------------------------------
> 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
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>  

Hi Tim, Phil and Javier,

Here goes. Please don't flame me!

Maybe this is more about the navigation than just a back-button on
procedures.

I am new to weberp, so maybe I see the application in a fresh light. I
do feel that the menu layout and operation left me feeling lost at
times. Thinking "Where am I now? How do I get back to the main menu.
First impressions are lasting.

What confuses me most is that the main menu I launch from .....

| Sales | Receivables | Payables | Purchases | Inventory | Manufacturing
| General | Ledger | Setup |

...disappears from view. It stays there for the drop down menus and then
disappears when a procedure is selected, while the top menu, above it,
stays in view. Apart from |logout| it does not help me. The  top menu
appears to hyperlink me to vastly disparate procedures, albeit I suspect
frequently used procedures.

The main menu is the point of reference from where I started, and if it
were to stay in view, it would obviate much of the need for a
back-button .  However, I still believe a back-button consistently
applied would be a big plus.

On Phil's point of "have I committed a transaction or have I not" could
be made more clear by some programming standards. e.g. All buttons that
commit should be bottom and center of the page and be  associated with a
small image to indicate that a mouse click here will create a
transaction. These could also be a set colour.  This would apply only to
actions directly associated with database  write/deletes/updates and
would tell the user he/she is going to make some data persistent.

Further, the procedure should always tell the user a transaction has
been committed to the database, or failed, before changing the page to a
different functional area. After this the user must know a transaction
has occurred, or not.

Javier states "window.close() will loose focus without closing the
session"  and  I think he is arguing
that  this  is a  security risk and  may lead to corrupt transactions.  
I am sure that issue is much bigger than just a back-button. I don't
know enough about the code to comment further. Sound like the scenario
where someone else changes a record after a read and before an update.  
Okay to err on the safer side and forget the "back-button" in favor of
tighter menu navigation.

Selecting the main menu item, if it remained in view, would provide a
similar solution. It would take you back to the drop down menu from
whence you came. As I have not yet found a procedure below a procedure,
this would always give you the reference to where you came from. Also,
the user would be less tempted to back arrow on the browser.

I hope you accept this in good faith and as I intended it, as a
constructive contribution.

Glenn


                                                                                         

                 

















------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: Loading demo database

by Javier de Lorenzo-Cáceres :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Good point both,

It's not easy cause browsers were not designed for applications but
documents. SQL servers implement ACID transactions, D stands for durability,
what means a committed transaction can't be undone, we only can make another
transaction with the opposite values, you have been taking care of this, so
we just need to advice users. A roll-back can only be done in the middle of
a transaction. The typical example is:

Create Button = begin transaction
Accept Button = commit transaction and back to sender object.
Cancel Button = roll-back transaction and back to sender object.

Very easy in Windows, very difficult in browsers (maybe a little less using
Windows ISAPI or Netscape NSAPI).

But I'm not going that far by now. Let's take a less difficult example from
WebERP:

"Set up a New Shipment" = Shipments.php?&NewShipment=Yes

In this case the browser back button doesn't require refresh and resend but
there is an autoincrement value for the shipment number keeping on
incrementing. If I quit WebERP and login again last shipment number is
remembered if session is not unset properly or fails to do so or maybe saved
in the database, I don't know WebERP to explain, I'm still translating it,
but would prefer another behaviour.

Thanks and regards,
javier


----- Original Message -----
From: "Phil Daintree" <phil@...>
To: "webERP Developers" <web-erp-developers@...>
Sent: Thursday, October 29, 2009 10:14 AM
Subject: Re: [WebERP-developers] Loading demo database


Well in most (hopefully all) transactions scripts the session variables
containing transactions are emptied (unset) so going back will not hurt
... but almost certainly won't be what the user wants - they will
perhaps want to undo the transactions they just posted ... not sure. In
most cases where a transaction is not involved a back button would be great

Phil

Tim Schofield wrote:

> Hi Glenn,
>
> Sometimes email and different native languages means that
> misunderstandings occur. Good code is acceptable from anybody,
> regardless of how long they have been on the list.
>
>  My concern with a back button has always been that users may
> duplicate a transaction. I know the same thing is possible if they hit
> the back button on the browser, I just feel maybe we shouldn't give
> them the ability to do it through webERP.
>
> However I still like the idea of a back button, I often see users
> trying to go back. I wonder if its possible to do this in a smart way
> so that a transaction can't get reposted?
>
> Thanks
> Tim
>
> 2009/10/29 Glenn Lyons <glenn@...>:
>> AESE, S.L., Javier de Lorenzo-Cáceres. wrote:
>>> Hi Glenn and Tim
>>>
>>> I don't feel like have not been polite, but please pardon me if I was.
>>>
>>> thanks,
>>> javier
>>>
>>>
>>>
>> Javier,
>>
>> You have misunderstood me. I do not suggest that you were "not polite".
>>
>> My meaning is that *I* might not be polite for making coding suggestions
>> when I have just joined the list.
>>
>> My sincere apologies for the confusion.  I read your posts with great
>> interest and look forward to reading more.
>>
>> Maybe it is just the way we Aussie's (or this Aussie) choose our words?
>> I will try and be a little clearer in future posts.
>>
>> No pardon required.
>>
>> Glenn
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> 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
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web-erp-developers@...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>
> ------------------------------------------------------------------------------
> 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
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers 


------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: Loading demo database

by Javier de Lorenzo-Cáceres :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Glenn, thanks for your comments,

I may be wrong, but I think that Events Oriented procedures are very limited
on browsers, i.e., we can not write something like:

OnRollBackTransaction do begin
  SetSessionVariables(PreviousState);
end;

indeed we don't need it on an event oriented but for the subject here, I
don't know how to do it. Maybe we could take advantage from Stored
Procedures, this would go half the way.

This mean the developer must take a lot of care and put upon his shoulder
the burden of, simulating or emulating, an Event Oriented Operating System,
hence, every change to the GUI is a pain. I may be absolutely wrong but this
is what i think.

For the security risk I mentioned, if you login into WebERP and close the
browser window you loose the oportunity to logout but your session is still
there, until it expires, so anyone that have access to your computer may
access into WebERP page without log in, the same as you can, and if you want
to close the session you have to open the browser window again. But I might
be absolutely wrong.

Again, something like,

OnWindowClose do begin
  Session.Close;
end;

would do, but I don't know how to achieve it and I think is not supported
natively. If someone teachs me I would be very happy.

Thanks,
javier


----- Original Message -----
From: "Glenn Lyons" <glenn@...>
To: "webERP Developers" <web-erp-developers@...>
Sent: Thursday, October 29, 2009 12:29 PM
Subject: Re: [WebERP-developers] Loading demo database


Tim Schofield wrote:

> Hi Glenn,
>
> Sometimes email and different native languages means that
> misunderstandings occur. Good code is acceptable from anybody,
> regardless of how long they have been on the list.
>
>  My concern with a back button has always been that users may
> duplicate a transaction. I know the same thing is possible if they hit
> the back button on the browser, I just feel maybe we shouldn't give
> them the ability to do it through webERP.
>
> However I still like the idea of a back button, I often see users
> trying to go back. I wonder if its possible to do this in a smart way
> so that a transaction can't get reposted?
>
> Thanks
> Tim
>
> 2009/10/29 Glenn Lyons <glenn@...>:
>
>> AESE, S.L., Javier de Lorenzo-Cáceres. wrote:
>>
>>> Hi Glenn and Tim
>>>
>>> I don't feel like have not been polite, but please pardon me if I was.
>>>
>>> thanks,
>>> javier
>>>
>>>
>>>
>>>
>> Javier,
>>
>> You have misunderstood me. I do not suggest that you were "not polite".
>>
>> My meaning is that *I* might not be polite for making coding suggestions
>> when I have just joined the list.
>>
>> My sincere apologies for the confusion.  I read your posts with
>> great---------------------------------------
>> interest and look forward to reading more.
>>
>> Maybe it is just the way we Aussie's (or this Aussie) choose our words?
>> I will try and be a little clearer in future posts.
>>
>> No pardon required.
>>
>> Glenn
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> 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
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web-erp-developers@...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>
> ------------------------------------------------------------------------------
> 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
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>

Hi Tim, Phil and Javier,

Here goes. Please don't flame me!

Maybe this is more about the navigation than just a back-button on
procedures.

I am new to weberp, so maybe I see the application in a fresh light. I
do feel that the menu layout and operation left me feeling lost at
times. Thinking "Where am I now? How do I get back to the main menu.
First impressions are lasting.

What confuses me most is that the main menu I launch from .....

| Sales | Receivables | Payables | Purchases | Inventory | Manufacturing
| General | Ledger | Setup |

...disappears from view. It stays there for the drop down menus and then
disappears when a procedure is selected, while the top menu, above it,
stays in view. Apart from |logout| it does not help me. The  top menu
appears to hyperlink me to vastly disparate procedures, albeit I suspect
frequently used procedures.

The main menu is the point of reference from where I started, and if it
were to stay in view, it would obviate much of the need for a
back-button .  However, I still believe a back-button consistently
applied would be a big plus.

On Phil's point of "have I committed a transaction or have I not" could
be made more clear by some programming standards. e.g. All buttons that
commit should be bottom and center of the page and be  associated with a
small image to indicate that a mouse click here will create a
transaction. These could also be a set colour.  This would apply only to
actions directly associated with database  write/deletes/updates and
would tell the user he/she is going to make some data persistent.

Further, the procedure should always tell the user a transaction has
been committed to the database, or failed, before changing the page to a
different functional area. After this the user must know a transaction
has occurred, or not.

Javier states "window.close() will loose focus without closing the
session"  and  I think he is arguing
that  this  is a  security risk and  may lead to corrupt transactions.
I am sure that issue is much bigger than just a back-button. I don't
know enough about the code to comment further. Sound like the scenario
where someone else changes a record after a read and before an update.
Okay to err on the safer side and forget the "back-button" in favor of
tighter menu navigation.

Selecting the main menu item, if it remained in view, would provide a
similar solution. It would take you back to the drop down menu from
whence you came. As I have not yet found a procedure below a procedure,
this would always give you the reference to where you came from. Also,
the user would be less tempted to back arrow on the browser.

I hope you accept this in good faith and as I intended it, as a
constructive contribution.

Glenn






















------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers 


------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: Loading demo database

by David Lamotte :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Ah, I see that we are discussing one of my pet issues with webERP -
navigation.  But I haven't raised it before as I have not had the time to
offer any solutions and this is not in the spirit of Open Source.

As a relatively new user to WebERP, I find it fairly difficult to move
around - but rather than look at it from a technical viewpoint, lets
consider it from a usability aspect.

The problems that I find are:

1. If I want to raise a new Customer Order, I have to go into the
customer, select update orders and then click the new link. Why can't I
just raise a new order for the displayed customer ?

2. When I raise the order, the first thing that I am asked is to select
the branch - but I am not presented with a list of branches for the
selected customer and all my customers only have one branch so why am I
being asked to select at all ?

3. To display customer details I must go into edit mode first, when all
that I want to do is look.

4. The ability to print to PDF is brilliant, but some times the pdf opens
in a new window which sometimes has the menu but not other times, but
there are many times when the PDF replaces the current window and only the
PDF viewer plugin is displayed - so no menu is available. This requires
you to use the browser 'back' button where 'resend previous information
warning message is displayed.

Perhaps the above sample of problems could be resolved by using a
consistent menu structure with a breadcrumb navigation menu to show the
user where they are in the screen hierarchy.

You can see an example of what I mean at http://shop.nnlbeersupplies.com.au.

Breadcrumbs are explained at
http://www.smashingmagazine.com/2009/03/17/breadcrumbs-in-web-design-examples-and-best-practices-2/

So, for my examples of moving around the customer screen, if we are
editing the branch details the breadcrumb could be:

Customer : ABC Pty Ltd : Sydney Branch : Edit

To implement a breadcrumb menu just requires a menu array in the session
variable, that is displayed by the page header - at least this is how Zen
Cart does it.

But all the above is just off the top of my head so I could be completely
wrong.

Longer term I think that it would be great to also have a single Names &
Address system so editing many details will also only need to be done in a
single system. This would allow a single entity (ie person) to be say an
employee, purchase order approver, customer (they buy things on staff
discount), a supplier (they contract some work to the company outside
their main employment) etc.

Thanks
David



> Hi Glenn, thanks for your comments,
>
> I may be wrong, but I think that Events Oriented procedures are very
> limited
> on browsers, i.e., we can not write something like:
>
> OnRollBackTransaction do begin
>   SetSessionVariables(PreviousState);
> end;
>
> indeed we don't need it on an event oriented but for the subject here, I
> don't know how to do it. Maybe we could take advantage from Stored
> Procedures, this would go half the way.
>
> This mean the developer must take a lot of care and put upon his shoulder
> the burden of, simulating or emulating, an Event Oriented Operating
> System,
> hence, every change to the GUI is a pain. I may be absolutely wrong but
> this
> is what i think.
>
> For the security risk I mentioned, if you login into WebERP and close the
> browser window you loose the oportunity to logout but your session is
> still
> there, until it expires, so anyone that have access to your computer may
> access into WebERP page without log in, the same as you can, and if you
> want
> to close the session you have to open the browser window again. But I
> might
> be absolutely wrong.
>
> Again, something like,
>
> OnWindowClose do begin
>   Session.Close;
> end;
>
> would do, but I don't know how to achieve it and I think is not supported
> natively. If someone teachs me I would be very happy.
>
> Thanks,
> javier
>
>
> ----- Original Message -----
> From: "Glenn Lyons" <glenn@...>
> To: "webERP Developers" <web-erp-developers@...>
> Sent: Thursday, October 29, 2009 12:29 PM
> Subject: Re: [WebERP-developers] Loading demo database
>
>
> Tim Schofield wrote:
>> Hi Glenn,
>>
>> Sometimes email and different native languages means that
>> misunderstandings occur. Good code is acceptable from anybody,
>> regardless of how long they have been on the list.
>>
>>  My concern with a back button has always been that users may
>> duplicate a transaction. I know the same thing is possible if they hit
>> the back button on the browser, I just feel maybe we shouldn't give
>> them the ability to do it through webERP.
>>
>> However I still like the idea of a back button, I often see users
>> trying to go back. I wonder if its possible to do this in a smart way
>> so that a transaction can't get reposted?
>>
>> Thanks
>> Tim
>>
>> 2009/10/29 Glenn Lyons <glenn@...>:
>>
>>> AESE, S.L., Javier de Lorenzo-Cáceres. wrote:
>>>
>>>> Hi Glenn and Tim
>>>>
>>>> I don't feel like have not been polite, but please pardon me if I was.
>>>>
>>>> thanks,
>>>> javier
>>>>
>>>>
>>>>
>>>>
>>> Javier,
>>>
>>> You have misunderstood me. I do not suggest that you were "not polite".
>>>
>>> My meaning is that *I* might not be polite for making coding
>>> suggestions
>>> when I have just joined the list.
>>>
>>> My sincere apologies for the confusion.  I read your posts with
>>> great---------------------------------------
>>> interest and look forward to reading more.
>>>
>>> Maybe it is just the way we Aussie's (or this Aussie) choose our words?
>>> I will try and be a little clearer in future posts.
>>>
>>> No pardon required.
>>>
>>> Glenn
>>>
>>>
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> 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
>>> _______________________________________________
>>> Web-erp-developers mailing list
>>> Web-erp-developers@...
>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>
>>>
>>
>> ------------------------------------------------------------------------------
>> 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
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web-erp-developers@...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>>
>>
>
> Hi Tim, Phil and Javier,
>
> Here goes. Please don't flame me!
>
> Maybe this is more about the navigation than just a back-button on
> procedures.
>
> I am new to weberp, so maybe I see the application in a fresh light. I
> do feel that the menu layout and operation left me feeling lost at
> times. Thinking "Where am I now? How do I get back to the main menu.
> First impressions are lasting.
>
> What confuses me most is that the main menu I launch from .....
>
> | Sales | Receivables | Payables | Purchases | Inventory | Manufacturing
> | General | Ledger | Setup |
>
> ...disappears from view. It stays there for the drop down menus and then
> disappears when a procedure is selected, while the top menu, above it,
> stays in view. Apart from |logout| it does not help me. The  top menu
> appears to hyperlink me to vastly disparate procedures, albeit I suspect
> frequently used procedures.
>
> The main menu is the point of reference from where I started, and if it
> were to stay in view, it would obviate much of the need for a
> back-button .  However, I still believe a back-button consistently
> applied would be a big plus.
>
> On Phil's point of "have I committed a transaction or have I not" could
> be made more clear by some programming standards. e.g. All buttons that
> commit should be bottom and center of the page and be  associated with a
> small image to indicate that a mouse click here will create a
> transaction. These could also be a set colour.  This would apply only to
> actions directly associated with database  write/deletes/updates and
> would tell the user he/she is going to make some data persistent.
>
> Further, the procedure should always tell the user a transaction has
> been committed to the database, or failed, before changing the page to a
> different functional area. After this the user must know a transaction
> has occurred, or not.
>
> Javier states "window.close() will loose focus without closing the
> session"  and  I think he is arguing
> that  this  is a  security risk and  may lead to corrupt transactions.
> I am sure that issue is much bigger than just a back-button. I don't
> know enough about the code to comment further. Sound like the scenario
> where someone else changes a record after a read and before an update.
> Okay to err on the safer side and forget the "back-button" in favor of
> tighter menu navigation.
>
> Selecting the main menu item, if it remained in view, would provide a
> similar solution. It would take you back to the drop down menu from
> whence you came. As I have not yet found a procedure below a procedure,
> this would always give you the reference to where you came from. Also,
> the user would be less tempted to back arrow on the browser.
>
> I hope you accept this in good faith and as I intended it, as a
> constructive contribution.
>
> Glenn
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> 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
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
> ------------------------------------------------------------------------------
> 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
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>


------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: Loading demo database

by Javier de Lorenzo-Cáceres :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi David, good points, brilliant indeed,

By now, I only can help with pdf behaviour and not sure. It's, the #4 in
your post.

I have observed that when pdf  opens in another window the WebERP window
turns blank, for example PDFPriceList.pdf or AgedDebtors.pdf . What is new
to me and I appreciate is the fact that it doesn't happen with all of them.
Please, would you show me an example? (There are many reports and four
kinds)

The function that serves pdf is the one that Tim is correcting precisely
now:

Output($name, $dest)
Where $name is a string for the filename and $dest is a string for How
report is served to clients.

About the two I have seen  PDFPriceList.pdf   and   AgedDebtors.pdf  , both
use PDFStarter.php

PDFPriceList.pdf   has
----------------------
Line 176, output();
Line 194, Output($FileName, 'I');
Where $FileName=$_SESSION['DatabaseName'].'_'.date('Y-m-d').'.pdf';
but the file ends as doc[1].pdf


AgedDebtors.pdf   has
----------------------
Line 448, stream();
Line 426, $buf = $pdf->output();


$dest can take one of the following values:

'I'    Inline, to be opened in the same browser window, plugin must be
installed or pdf downloaded.
'D'   Download, forces a pdf file download.
'F'   File, saves to a local file.
'S'   String, returns the document as a string.

We have selected to use 'I' (as most people), what means that is up to the
user to install a plugin or not, to have the pdf document in the same
browser window or opened apart in the Reader/Viewer/Editor application.

Maybe we could do something like to open another browser window/tab first,
and then call to the php script that creates the pdf.

For example, and this is an early thought, if we call the pdf script from a
link, maybe we could add to the link,

onclick="window.open('xxx.php');

And if we call it from a button on a form we could do something like:

<form action="PDFPriceList.php" method="post" target="_blank">

or

<form action="PDFPriceList.php" method="post" target="foo"
onSubmit="window.open('', 'foo', 'width=123', height=123, status=yes, et
cetera);


Could it be?
Thanks,
javier



----- Original Message -----
From: <david@...>
To: "webERP Developers" <web-erp-developers@...>
Sent: Friday, October 30, 2009 12:32 AM
Subject: Re: [WebERP-developers] Loading demo database


Ah, I see that we are discussing one of my pet issues with webERP -
navigation.  But I haven't raised it before as I have not had the time to
offer any solutions and this is not in the spirit of Open Source.

As a relatively new user to WebERP, I find it fairly difficult to move
around - but rather than look at it from a technical viewpoint, lets
consider it from a usability aspect.

The problems that I find are:

1. If I want to raise a new Customer Order, I have to go into the
customer, select update orders and then click the new link. Why can't I
just raise a new order for the displayed customer ?

2. When I raise the order, the first thing that I am asked is to select
the branch - but I am not presented with a list of branches for the
selected customer and all my customers only have one branch so why am I
being asked to select at all ?

3. To display customer details I must go into edit mode first, when all
that I want to do is look.

4. The ability to print to PDF is brilliant, but some times the pdf opens
in a new window which sometimes has the menu but not other times, but
there are many times when the PDF replaces the current window and only the
PDF viewer plugin is displayed - so no menu is available. This requires
you to use the browser 'back' button where 'resend previous information
warning message is displayed.

Perhaps the above sample of problems could be resolved by using a
consistent menu structure with a breadcrumb navigation menu to show the
user where they are in the screen hierarchy.

You can see an example of what I mean at http://shop.nnlbeersupplies.com.au.

Breadcrumbs are explained at
http://www.smashingmagazine.com/2009/03/17/breadcrumbs-in-web-design-examples-and-best-practices-2/

So, for my examples of moving around the customer screen, if we are
editing the branch details the breadcrumb could be:

Customer : ABC Pty Ltd : Sydney Branch : Edit

To implement a breadcrumb menu just requires a menu array in the session
variable, that is displayed by the page header - at least this is how Zen
Cart does it.

But all the above is just off the top of my head so I could be completely
wrong.

Longer term I think that it would be great to also have a single Names &
Address system so editing many details will also only need to be done in a
single system. This would allow a single entity (ie person) to be say an
employee, purchase order approver, customer (they buy things on staff
discount), a supplier (they contract some work to the company outside
their main employment) etc.

Thanks
David



> Hi Glenn, thanks for your comments,
>
> I may be wrong, but I think that Events Oriented procedures are very
> limited
> on browsers, i.e., we can not write something like:
>
> OnRollBackTransaction do begin
>   SetSessionVariables(PreviousState);
> end;
>
> indeed we don't need it on an event oriented but for the subject here, I
> don't know how to do it. Maybe we could take advantage from Stored
> Procedures, this would go half the way.
>
> This mean the developer must take a lot of care and put upon his shoulder
> the burden of, simulating or emulating, an Event Oriented Operating
> System,
> hence, every change to the GUI is a pain. I may be absolutely wrong but
> this
> is what i think.
>
> For the security risk I mentioned, if you login into WebERP and close the
> browser window you loose the oportunity to logout but your session is
> still
> there, until it expires, so anyone that have access to your computer may
> access into WebERP page without log in, the same as you can, and if you
> want
> to close the session you have to open the browser window again. But I
> might
> be absolutely wrong.
>
> Again, something like,
>
> OnWindowClose do begin
>   Session.Close;
> end;
>
> would do, but I don't know how to achieve it and I think is not supported
> natively. If someone teachs me I would be very happy.
>
> Thanks,
> javier
>
>
> ----- Original Message -----
> From: "Glenn Lyons" <glenn@...>
> To: "webERP Developers" <web-erp-developers@...>
> Sent: Thursday, October 29, 2009 12:29 PM
> Subject: Re: [WebERP-developers] Loading demo database
>
>
> Tim Schofield wrote:
>> Hi Glenn,
>>
>> Sometimes email and different native languages means that
>> misunderstandings occur. Good code is acceptable from anybody,
>> regardless of how long they have been on the list.
>>
>>  My concern with a back button has always been that users may
>> duplicate a transaction. I know the same thing is possible if they hit
>> the back button on the browser, I just feel maybe we shouldn't give
>> them the ability to do it through webERP.
>>
>> However I still like the idea of a back button, I often see users
>> trying to go back. I wonder if its possible to do this in a smart way
>> so that a transaction can't get reposted?
>>
>> Thanks
>> Tim
>>
>> 2009/10/29 Glenn Lyons <glenn@...>:
>>
>>> AESE, S.L., Javier de Lorenzo-Cáceres. wrote:
>>>
>>>> Hi Glenn and Tim
>>>>
>>>> I don't feel like have not been polite, but please pardon me if I was.
>>>>
>>>> thanks,
>>>> javier
>>>>
>>>>
>>>>
>>>>
>>> Javier,
>>>
>>> You have misunderstood me. I do not suggest that you were "not polite".
>>>
>>> My meaning is that *I* might not be polite for making coding
>>> suggestions
>>> when I have just joined the list.
>>>
>>> My sincere apologies for the confusion.  I read your posts with
>>> great---------------------------------------
>>> interest and look forward to reading more.
>>>
>>> Maybe it is just the way we Aussie's (or this Aussie) choose our words?
>>> I will try and be a little clearer in future posts.
>>>
>>> No pardon required.
>>>
>>> Glenn
>>>
>>>
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> 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
>>> _______________________________________________
>>> Web-erp-developers mailing list
>>> Web-erp-developers@...
>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>
>>>
>>
>> ------------------------------------------------------------------------------
>> 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
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web-erp-developers@...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>>
>>
>
> Hi Tim, Phil and Javier,
>
> Here goes. Please don't flame me!
>
> Maybe this is more about the navigation than just a back-button on
> procedures.
>
> I am new to weberp, so maybe I see the application in a fresh light. I
> do feel that the menu layout and operation left me feeling lost at
> times. Thinking "Where am I now? How do I get back to the main menu.
> First impressions are lasting.
>
> What confuses me most is that the main menu I launch from .....
>
> | Sales | Receivables | Payables | Purchases | Inventory | Manufacturing
> | General | Ledger | Setup |
>
> ...disappears from view. It stays there for the drop down menus and then
> disappears when a procedure is selected, while the top menu, above it,
> stays in view. Apart from |logout| it does not help me. The  top menu
> appears to hyperlink me to vastly disparate procedures, albeit I suspect
> frequently used procedures.
>
> The main menu is the point of reference from where I started, and if it
> were to stay in view, it would obviate much of the need for a
> back-button .  However, I still believe a back-button consistently
> applied would be a big plus.
>
> On Phil's point of "have I committed a transaction or have I not" could
> be made more clear by some programming standards. e.g. All buttons that
> commit should be bottom and center of the page and be  associated with a
> small image to indicate that a mouse click here will create a
> transaction. These could also be a set colour.  This would apply only to
> actions directly associated with database  write/deletes/updates and
> would tell the user he/she is going to make some data persistent.
>
> Further, the procedure should always tell the user a transaction has
> been committed to the database, or failed, before changing the page to a
> different functional area. After this the user must know a transaction
> has occurred, or not.
>
> Javier states "window.close() will loose focus without closing the
> session"  and  I think he is arguing
> that  this  is a  security risk and  may lead to corrupt transactions.
> I am sure that issue is much bigger than just a back-button. I don't
> know enough about the code to comment further. Sound like the scenario
> where someone else changes a record after a read and before an update.
> Okay to err on the safer side and forget the "back-button" in favor of
> tighter menu navigation.
>
> Selecting the main menu item, if it remained in view, would provide a
> similar solution. It would take you back to the drop down menu from
> whence you came. As I have not yet found a procedure below a procedure,
> this would always give you the reference to where you came from. Also,
> the user would be less tempted to back arrow on the browser.
>
> I hope you accept this in good faith and as I intended it, as a
> constructive contribution.
>
> Glenn
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> 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
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
> ------------------------------------------------------------------------------
> 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
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>


------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers 


------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: Loading demo database

by Tim Schofield :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Glenn,

2009/10/29 Glenn Lyons <glenn@...>:

> Hi Tim, Phil and Javier,
>
> Here goes. Please don't flame me!

Hopefully constructive criticism never gets flamed.

>
> Maybe this is more about the navigation than just a back-button on
> procedures.
>
> I am new to weberp, so maybe I see the application in a fresh light. I
> do feel that the menu layout and operation left me feeling lost at
> times. Thinking "Where am I now? How do I get back to the main menu.
> First impressions are lasting.
>
> What confuses me most is that the main menu I launch from .....
>
> | Sales | Receivables | Payables | Purchases | Inventory | Manufacturing
> | General | Ledger | Setup |
>
> ...disappears from view. It stays there for the drop down menus and then
> disappears when a procedure is selected, while the top menu, above it,
> stays in view. Apart from |logout| it does not help me. The  top menu
> appears to hyperlink me to vastly disparate procedures, albeit I suspect
> frequently used procedures.

This got me thinking about this menu. How about having it dynamically
created? Perhaps a users frequently used tasks, or perhaps tasks
related to the one the user is currently doing. Or perhaps I have just
had too much African sun :-)

>
> The main menu is the point of reference from where I started, and if it
> were to stay in view, it would obviate much of the need for a
> back-button .  However, I still believe a back-button consistently
> applied would be a big plus.

There is a link to return to the main menu in the top menu. I would be
concerned that by including the main menu bar in a transaction screen
would make it too easy for users to accidentally abort a transaction.
Just my view, have other people views?

>
> On Phil's point of "have I committed a transaction or have I not" could
> be made more clear by some programming standards. e.g. All buttons that
> commit should be bottom and center of the page and be  associated with a
> small image to indicate that a mouse click here will create a
> transaction. These could also be a set colour.  This would apply only to
> actions directly associated with database  write/deletes/updates and
> would tell the user he/she is going to make some data persistent.
>
> Further, the procedure should always tell the user a transaction has
> been committed to the database, or failed, before changing the page to a
> different functional area. After this the user must know a transaction
> has occurred, or not.

There are already information bars in different colours to tell a user
whether the transaction has succeeded or not.

>
> Javier states "window.close() will loose focus without closing the
> session"  and  I think he is arguing
> that  this  is a  security risk and  may lead to corrupt transactions.
> I am sure that issue is much bigger than just a back-button. I don't
> know enough about the code to comment further. Sound like the scenario
> where someone else changes a record after a read and before an update.
> Okay to err on the safer side and forget the "back-button" in favor of
> tighter menu navigation.
>
> Selecting the main menu item, if it remained in view, would provide a
> similar solution. It would take you back to the drop down menu from
> whence you came. As I have not yet found a procedure below a procedure,
> this would always give you the reference to where you came from. Also,
> the user would be less tempted to back arrow on the browser.
>
> I hope you accept this in good faith and as I intended it, as a
> constructive contribution.
>
> Glenn
>

Thanks
Tim

------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: Loading demo database

by Tim Schofield :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I seem to recall seeing a user hit the back button choose yes to the
question of resending data and the transaction being posted twice.
However I can't immediately recall which transaction it was, and maybe
I am just plain wrong :)

Tim


2009/10/29 Phil Daintree <phil@...>:

> Well in most (hopefully all) transactions scripts the session variables
> containing transactions are emptied (unset) so going back will not hurt
> ... but almost certainly won't be what the user wants - they will
> perhaps want to undo the transactions they just posted ... not sure. In
> most cases where a transaction is not involved a back button would be great
>
> Phil
>
> Tim Schofield wrote:
>> Hi Glenn,
>>
>> Sometimes email and different native languages means that
>> misunderstandings occur. Good code is acceptable from anybody,
>> regardless of how long they have been on the list.
>>
>>  My concern with a back button has always been that users may
>> duplicate a transaction. I know the same thing is possible if they hit
>> the back button on the browser, I just feel maybe we shouldn't give
>> them the ability to do it through webERP.
>>
>> However I still like the idea of a back button, I often see users
>> trying to go back. I wonder if its possible to do this in a smart way
>> so that a transaction can't get reposted?
>>
>> Thanks
>> Tim
>>
>> 2009/10/29 Glenn Lyons <glenn@...>:
>>> AESE, S.L., Javier de Lorenzo-Cáceres. wrote:
>>>> Hi Glenn and Tim
>>>>
>>>> I don't feel like have not been polite, but please pardon me if I was.
>>>>
>>>> thanks,
>>>> javier
>>>>
>>>>
>>>>
>>> Javier,
>>>
>>> You have misunderstood me. I do not suggest that you were "not polite".
>>>
>>> My meaning is that *I* might not be polite for making coding suggestions
>>> when I have just joined the list.
>>>
>>> My sincere apologies for the confusion.  I read your posts with great
>>> interest and look forward to reading more.
>>>
>>> Maybe it is just the way we Aussie's (or this Aussie) choose our words?
>>> I will try and be a little clearer in future posts.
>>>
>>> No pardon required.
>>>
>>> Glenn
>>>
>>>
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> 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
>>> _______________________________________________
>>> Web-erp-developers mailing list
>>> Web-erp-developers@...
>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>
>>
>> ------------------------------------------------------------------------------
>> 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
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web-erp-developers@...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>
> ------------------------------------------------------------------------------
> 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
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

------------------------------------------------------------------------------
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
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers
< Prev | 1 - 2 | Next >