Re: Old demo back

2015-09-06 Thread BJ Freeman
just taken time to say thanks for the years of support 


 On Sunday, September 6, 2015 3:41 AM, Jacques Le Roux 
 wrote:
   

 Hi,

The old demo was stale, it's back again

Jacques


   

Re: Implement selling Handyman Sevices.

2015-09-04 Thread BJ Freeman
employee is usually meant for those working for the product store, and/or 
business defined in accounting.what you have would be two types if customers, 
unless you plan to hire the handymen, and pay their wages, as employees.
 


 On Friday, September 4, 2015 7:09 AM, Honey Goyal  
wrote:
   

 I am using release13.07. yeah i will assign EMPLOYEE role to each Handyman.



--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/Implement-selling-Handyman-Sevices-tp4671815p4671867.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


   

Re: Implement selling Handyman Sevices.

2015-09-03 Thread BJ Freeman
Before I jump in, what version are you using?
 


 On Wednesday, September 2, 2015 11:24 PM, Honey Goyal 
 wrote:
   

 Thankyou BJ. Yes, i know about creating new entities. My concern is to use
existing entity model in ofbiz. I have seen Requirement entity and
CustRequest entity. i think both entities can be used to save Customer
Request for a Handyman. But i am not sure.

In Requirement entity, requirementTypeId can be WORK_REQUIREMENT,
CUSTOMER_REQUIREMENT and OrderRequirementCommitment entity can be used for
Order/CustomerRequest association.

Want a expert advise, should i go for these table or is there any other
tables exist in ofbiz. Or should i create my own tables.

 



--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/Implement-selling-Handyman-Sevices-tp4671815p4671820.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


   

Re: Implement selling Handyman Sevices.

2015-09-03 Thread BJ Freeman
First, there are less supplicatedsolutions, however I from experience, I choose 
the more complexsolutions.The core of this solution, 
usesAgreementhttp://demo-stable-ofbiz.apache.org/webtools/control/ArtifactInfo?type=entity=Agreement
 and PartyRelationshipAndDetail 
http://demo-stable-ofbiz.apache.org/webtools/control/ArtifactInfo?type=entity=PartyRelationshipAndDetail
as you see the second one has noservices , forms, screens, so this is where you 
would have to add.
These would be used when a party ofeither type signs up.You can start with one 
genericagreements for each type, something like how they would use the 
site.Then you can add agreements for eachtype of handyman, this way there is no 
misunderstanding 
hope that is enough to get started, orjust leave it out. 


 On Thursday, September 3, 2015 10:51 AM, BJ Freeman 
<bjfr33...@yahoo.com.INVALID> wrote:
   

 Before I jump in, what version are you using?
 


    On Wednesday, September 2, 2015 11:24 PM, Honey Goyal 
<er.honey2...@gmail.com> wrote:
  

 Thankyou BJ. Yes, i know about creating new entities. My concern is to use
existing entity model in ofbiz. I have seen Requirement entity and
CustRequest entity. i think both entities can be used to save Customer
Request for a Handyman. But i am not sure.

In Requirement entity, requirementTypeId can be WORK_REQUIREMENT,
CUSTOMER_REQUIREMENT and OrderRequirementCommitment entity can be used for
Order/CustomerRequest association.

Want a expert advise, should i go for these table or is there any other
tables exist in ofbiz. Or should i create my own tables.

 



--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/Implement-selling-Handyman-Sevices-tp4671815p4671820.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


  

  

Re: Is this forum only for experienced Ofbizers?

2015-09-02 Thread BJ Freeman
this is for any user of Ofbiz.here is the basis of entities,Entity Engine Guide 
- OFBiz (Open For Business) Project Open Wiki - Apache Software Foundation

|   |
|   |   |   |   |   |
| Entity Engine Guide - OFBiz (Open...Written By: David E. Jones Edited by: Les 
Austin and Pawel H Debski   Table of Contents Related Documents: Entity Engine 
Configuration Guide Introduction  |
|  |
| View on cwiki.apache.org | Preview by Yahoo |
|  |
|   |

service is one to two ways to work with the entity 


 On Wednesday, September 2, 2015 6:21 AM, Barou  wrote:
   

 Sorry about my new bee question.
I am not sure  if I am in the right place.
When I look at Ofbiz doc I  se many examples like the link below.
https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Tutorial+-+A+Beginners+Development+Guide#OFBizTutorial-ABeginnersDevelopmentGuide-WritingCRUDOperations
for example:

    Create a Example
    
    
    
    
    
    


How can I create service that read from several table ? 
Is there a service already implemented in the ofbiz I can use for this
purpose ?
And how do I send user credentials from a form  then used that to fetch the
records created for example  in the product table ?





--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/Is-this-forum-only-for-experienced-Ofbizers-tp4671812.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


  

Re: Implement selling Handyman Sevices.

2015-09-02 Thread BJ Freeman
hello,  i suggest you learn how to create the entities in the entity folder of 
the apps you want to use.by doing this on paper, so to speak, will give you a 
familiarity and a way to maintain your implementation in the future.that said 
you may want to go over the party associations as related to products as well
 


 On Wednesday, September 2, 2015 8:13 AM, Honey Goyal 
 wrote:
   

 Hi,

I want to implement Handyman Services in ofbiz. My requirement is to get
customer request for a Handyman. After that we will create Order and
generate bill for work done by a Handyman. For that purpose i have decide to
use Products having productTypeId="SERVICE".

I want to know more about entities should be for customer request and then
associate those request with order.


Thanks,
Honey Goyal



--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/Implement-selling-Handyman-Sevices-tp4671815.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


  

Re: Is this forum only for experienced Ofbizers?

2015-09-02 Thread BJ Freeman
not sure why the url was not included.
try this again

https://cwiki.apache.org/confluence/display/OFBIZ/Entity+Engine+Guide




On Wednesday, September 2, 2015 11:11 AM, BJ Freeman 
<bjfr33...@yahoo.com.INVALID> wrote:



this is for any user of Ofbiz.here is the basis of entities,Entity Engine Guide 
- OFBiz (Open For Business) Project Open Wiki - Apache Software Foundation

|  |
|  |  |  |  |  |
| Entity Engine Guide - OFBiz (Open...Written By: David E. Jones Edited by: Les 
Austin and Pawel H Debski  Table of Contents Related Documents: Entity Engine 
Configuration Guide Introduction  |
|  |
| View on cwiki.apache.org | Preview by Yahoo |
|  |
|  |

service is one to two ways to work with the entity 



    On Wednesday, September 2, 2015 6:21 AM, Barou <zsba...@gmail.com> wrote:
  

Sorry about my new bee question.
I am not sure  if I am in the right place.
When I look at Ofbiz doc I  se many examples like the link below.
https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Tutorial+-+A+Beginners+Development+Guide#OFBizTutorial-ABeginnersDevelopmentGuide-WritingCRUDOperations
for example:

    Create a Example
    
    
    
    
    
    


How can I create service that read from several table ? 
Is there a service already implemented in the ofbiz I can use for this
purpose ?
And how do I send user credentials from a form  then used that to fetch the
records created for example  in the product table ?





--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/Is-this-forum-only-for-experienced-Ofbizers-tp4671812.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


Re: Comparison of OFBiz and Moqui by prospective user

2015-08-31 Thread BJ Freeman
logged into linkedin and see the article
 


 On Monday, August 31, 2015 6:57 AM, Adrian Crum 
 wrote:
   

 "Post is no longer available"

Perhaps you must be logged in to view it.

Adrian Crum
Sandglass Software
www.sandglass-software.com

On 8/31/2015 4:50 AM, Al Byers wrote:
> Just for your information:
>
> https://www.linkedin.com/pulse/quest-find-right-erp-ofbiz-vs-moqui-baig-mba-pmp-csp-csm-cssbb-
>


   

apj jar for openjk 1.6.36

2015-08-28 Thread BJ Freeman
ok been out of loop.what is the current apj jar


Re: ERROR: Null DispatchContext

2015-08-27 Thread BJ Freeman
when i tracked down a similar problem increasing the memory, solved it.btw i 
got no out of memory error back then



 On Thursday, August 27, 2015 5:35 AM, masionas michael.koro...@gmail.com 
wrote:
   

 I suppose it would show Out of memory message in that case. However system is
functioning just have a problem in services with dispatch context.

Thanks anyway for looking into this BJ.



--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/ERROR-Null-DispatchContext-tp4671492p4671618.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


   

Re: limit Invoice access by logged user (or the Invoice Sales Rep)

2015-08-26 Thread BJ Freeman
quick and dirty would be to have roleTypeId SALES_REP-1 through every how many 
you have.this lets you manage each and tranfer a sales reps data by just adding 
to another roleTypeId SALES_REP-X when one leaves


 On Tuesday, August 25, 2015 5:04 PM, Gabriel Oberreuter 
goberreu...@gmail.com wrote:
   

 Hello,

I have the following requirement:
At our company, Invoices are always assigned to a sales_rep executive, and
in Ofbiz we do this by creating an InvoiceRole (roleTypeId SALES_REP)
between each Invoice and its corresponding sales rep.

Now, we need to limit the access of each sales rep only to his own
Invoices. Can be this done within the included Ofbiz functionality?

As far as I know (don't know much of inner part of ofbiz yet), we need some
customization. I am thinking of modifying each invoice screen (or screen's
forms) to limit the invoice list based on the logged in user, which has to
be some kind of admin or a sales rep. In the latter case, the filter should
only include invoices belonging to this sales rep.

I am also thinking in a hierarchical schemma, were sales_rep supervisors
have access to all their supervised sales_rep.

Any better idea? Am I pointing in the right direction?

I know that we can limit access to accounting with security groups, but I
think that security groups is not the way to go, as I believe they are
thought to restrict by kinds of operations, but not by (sub)groups of
elements meeting certain conditions.

Thanks!!

-- 
Gabriel Oberreuter
Mobile: +56 9 85299198


   

Re: ERROR: Null DispatchContext

2015-08-25 Thread BJ Freeman
ofbiz has two standard start scripts:startofbiz.bat for windows rem set 
MEMIF=-Xms128M -Xmx512M -XX:MaxPermSize=128m
andstartofbiz.bat for linuxMEMIF=-Xms128M -Xmx512M -XX:MaxPermSize=128myou 
can read up on these in java

 


 On Tuesday, August 25, 2015 4:01 AM, masionas michael.koro...@gmail.com 
wrote:
   

 Hi BJ,

Could you please elaborate a bit on it ? I have looked in start.properties
and don't see anything regulating space?



--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/ERROR-Null-DispatchContext-tp4671492p4671558.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


  

Re: ERROR: Null DispatchContext

2015-08-25 Thread BJ Freeman
oops  startofbiz.sh for linux 


 On Tuesday, August 25, 2015 12:30 PM, BJ Freeman bjfr33...@yahoo.com 
wrote:
   

 ofbiz has two standard start scripts:startofbiz.bat for windows rem set 
MEMIF=-Xms128M -Xmx512M -XX:MaxPermSize=128m
andstartofbiz.bat for linuxMEMIF=-Xms128M -Xmx512M -XX:MaxPermSize=128myou 
can read up on these in java

 


 On Tuesday, August 25, 2015 4:01 AM, masionas michael.koro...@gmail.com 
wrote:
   

 Hi BJ,

Could you please elaborate a bit on it ? I have looked in start.properties
and don't see anything regulating space?



--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/ERROR-Null-DispatchContext-tp4671492p4671558.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


   

  

Re: ERROR: Null DispatchContext

2015-08-24 Thread BJ Freeman
sounds like your running out of space for ofbiz.what are the ofbiz startup 
parameter, you are using
 


 On Saturday, August 22, 2015 7:19 AM, masionas michael.koro...@gmail.com 
wrote:
   

 Hi,

From time to time I get this error with no evident consistency. Somehow
dispatch context gets lost. Usually it is cured by application restart. Does
anyone experience anything similar? it is 13.07 version.

Thanks.



--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/ERROR-Null-DispatchContext-tp4671492.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


   

Re: Accounting - has backend for Third Applicaition

2015-08-20 Thread BJ Freeman
as with any application, in ofbiz, you can complete replace them.that is a 
process best covered in a document.you can interface to external accounting 
apps, like quickbooks, which is another route.
 


 On Thursday, August 20, 2015 6:46 AM, FGomez fgo...@mail.com wrote:
   

 HI

Is there is an ofbiz Accounting implementation where Accounting is the 
backend for a third Application?

Regards,
Fernando




   

Re: AW: How to avoid duplicate form submissions with F5

2015-08-20 Thread BJ Freeman
i would suggest a hidden field that gets filled in. it would be a number that 
gets incremented on the web side.if the number is not one then don't process
 


 On Wednesday, August 19, 2015 10:30 PM, akif.d...@t-systems.com 
akif.d...@t-systems.com wrote:
   

 Hello Giulio,

unfortunately the given information below is far too less to investigate into. 
Could you give readers of this list proper reproducible information, in order 
to help you?

Regards,

Akif--

-Ursprüngliche Nachricht-
Von: Giulio Fitini [mailto:g.fit...@telecgt.it] 
Gesendet: Dienstag, 11. August 2015 09:36
An: user@ofbiz.apache.org
Betreff: How to avoid duplicate form submissions with F5

Hi to everyone!
What is the best practice in OfBiz using controller.xml,  to avoid a duplicate 
form submission from F5 pressing?



  

change o email address

2015-08-15 Thread BJ Freeman
to solve sending emails


test email

2015-08-07 Thread bj freeman

sorry been trying to send emails for two years.
hope this one gets thru


Re: Is there a way to use installation offline and then sync with main site

2012-10-14 Thread BJ Freeman

yes.
https://cwiki.apache.org/OFBIZ/sync-setup-notes-and-example.html

Deepak Agarwal sent the following on 10/14/2012 10:30 AM:

Hello,

We are running multiple kiosks for our website. As of now our kiosks are
running independently and there is no accounting is maintained. What we
want is to link all those kiosks to our main server but kiosks are
geographically distributed and having an internet connection without any
intrupption is as of now is doubtful.

So, my question is, is there anyway that we assign the inventory to kiosks
on daily basis and then at the end of the day we could synchronize all the
sale to main server.


Re: osworkflow integration configuration problem

2012-10-12 Thread BJ Freeman

my experience is as you fix one error others will show themselves.
there is no one answer.
you biggest is the hibernate

you will have to see how much you can use ofbiz/Apache code as you can.

Anurag Walia sent the following on 10/12/2012 11:36 AM:

I had putted the oscore.jar and osuser.jar related osworkflow_2-8-0 into the
liberary folder.
And included the osworkflow_2-8-0 /src into new component source .

After when I am building the application I am getting the many errors as in
below.
So I have two ways to do

1. I should remove unwanted java code and took only required for ofbiz.
2.solve all the errors one by one.

But I am not sure which will give me a successfull result back.

could you put some light which is the best way to integrate.

[javac16] Compiling 169 source files to
E:\apache-ofbiz-10.04\hot-deploy\oswf\build\classes
[javac16]
E:\apache-ofbiz-10.04\hot-deploy\oswf\src\com\opensymphony\workflow\AbstractWorkflow.java:14:
warning: [deprecation] com.opensymphony.workflow.query.WorkflowQuery in
com.opensymphony.workflow.query has been deprecated
[javac16] import com.opensymphony.workflow.query.WorkflowQuery;
[javac16]   ^
[javac16]
E:\apache-ofbiz-10.04\hot-deploy\oswf\src\com\opensymphony\workflow\Workflow.java:12:
warning: [deprecation] com.opensymphony.workflow.query.WorkflowQuery in
com.opensymphony.workflow.query has been deprecated
[javac16] import com.opensymphony.workflow.query.WorkflowQuery;
[javac16]   ^
[javac16]
E:\apache-ofbiz-10.04\hot-deploy\oswf\src\com\opensymphony\workflow\AbstractWorkflow.java:634:
warning: [deprecation] com.opensymphony.workflow.query.WorkflowQuery in
com.opensymphony.workflow.query has been deprecated
[javac16] public List query(WorkflowQuery query) throws StoreException {
[javac16]   ^
[javac16]
E:\apache-ofbiz-10.04\hot-deploy\oswf\src\com\opensymphony\workflow\spi\WorkflowStore.java:11:
warning: [deprecation] com.opensymphony.workflow.query.WorkflowQuery in
com.opensymphony.workflow.query has been deprecated
[javac16] import com.opensymphony.workflow.query.WorkflowQuery;
[javac16]   ^
[javac16]
E:\apache-ofbiz-10.04\hot-deploy\oswf\src\com\opensymphony\workflow\ejb\EJBWorkflow.java:15:
warning: [deprecation] com.opensymphony.workflow.query.WorkflowQuery in
com.opensymphony.workflow.query has been deprecated
[javac16] import com.opensymphony.workflow.query.WorkflowQuery;
[javac16]   ^
[javac16]
E:\apache-ofbiz-10.04\hot-deploy\oswf\src\com\opensymphony\workflow\ejb\EJBWorkflow.java:46:
cannot find symbol
[javac16] symbol  : class WorkflowRemote
[javac16] location: class com.opensymphony.workflow.ejb.EJBWorkflow
[javac16] private WorkflowRemote wf;
[javac16] ^
[javac16]
E:\apache-ofbiz-10.04\hot-deploy\oswf\src\com\opensymphony\workflow\ejb\EJBWorkflow.java:264:
warning: [deprecation] com.opensymphony.workflow.query.WorkflowQuery in
com.opensymphony.workflow.query has been deprecated
[javac16] public List query(WorkflowQuery query) throws
WorkflowException {
[javac16]   ^
[javac16]
E:\apache-ofbiz-10.04\hot-deploy\oswf\src\com\opensymphony\workflow\loader\NotNullStringType.java:13:
package net.sf.hibernate.type does not exist
[javac16] import net.sf.hibernate.type.StringType;
[javac16] ^
[javac16]
E:\apache-ofbiz-10.04\hot-deploy\oswf\src\com\opensymphony\workflow\loader\NotNullStringType.java:26:
cannot find symbol
[javac16] symbol: class StringType
[javac16] public class NotNullStringType extends StringType {
[javac16]^
[javac16]
E:\apache-ofbiz-10.04\hot-deploy\oswf\src\com\opensymphony\workflow\soap\BasicSOAPWorkflow.java:20:
warning: [deprecation] com.opensymphony.workflow.query.WorkflowQuery in
com.opensymphony.workflow.query has been deprecated
[javac16] import com.opensymphony.workflow.query.WorkflowQuery;
[javac16]   ^
[javac16]
E:\apache-ofbiz-10.04\hot-deploy\oswf\src\com\opensymphony\workflow\soap\BasicSOAPWorkflow.java:22:
package electric.util does not exist
[javac16] import electric.util.Context;
[javac16] ^
[javac16]
E:\apache-ofbiz-10.04\hot-deploy\oswf\src\com\opensymphony\workflow\soap\BasicSOAPWorkflow.java:112:
warning: [deprecation] com.opensymphony.workflow.query.WorkflowQuery in
com.opensymphony.workflow.query has been deprecated
[javac16] public List query(WorkflowQuery query) throws StoreException {
[javac16]   ^
[javac16]
E:\apache-ofbiz-10.04\hot-deploy\oswf\src\com\opensymphony\workflow\soap\OfbizSOAPWorkflow.java:20:
warning: [deprecation] com.opensymphony.workflow.query.WorkflowQuery in
com.opensymphony.workflow.query has been deprecated
[javac16] import com.opensymphony.workflow.query.WorkflowQuery;
[javac16]   ^
[javac16]

Re: osworkflow integration configuration problem

2012-10-11 Thread BJ Freeman
suggest you track down the source code and find out what it is trying 
todo on those line numbers.


Anurag Walia sent the following on 10/8/2012 12:34 PM:

Hello All,

I am trying Integrate osworkflow but not getting success due to some
configuration missing.

1. I have added src code from osuser,oscore and osworkflow to new component.
2. I had put xml configuration files in META-INF after customizing
osworkflow.xml

like:

osworkflow
   persistence
class=com.opensymphony.workflow.spi.ofbiz.OfbizWorkflowStore /
   factory class=com.opensymphony.workflow.loader.URLWorkflowFactory
 property key=cache value=true /
 property key=resource value=workflows.xml /
   /factory
/osworkflow

and osuser.xml like

opensymphony-user

 provider
class=com.opensymphony.user.provider.ofbiz.OFBizAccessProvider /
 provider
class=com.opensymphony.user.provider.ofbiz.OFBizCredentialsProvider /
 provider
class=com.opensymphony.user.provider.ofbiz.OFBizProfileProvider /
 provider
class=com.opensymphony.user.provider.ofbiz.OFBizAbstractProvider /
/opensymphony-user


but getting error

2012-10-09 00:33:10,531 (http-0.0.0.0-8443-1) [
UserManager.java:132:ERROR] unexpected runtime exception during
initialization
java.lang.RuntimeException: org/ofbiz/core/entity/GenericEntityException
 at
com.opensymphony.user.util.ConfigLoader.load(ConfigLoader.java:76)
 at com.opensymphony.user.UserManager.init(UserManager.java:108)
 at com.opensymphony.user.UserManager.init(UserManager.java:60)
 at
com.opensymphony.user.UserManager.getInstance(UserManager.java:127)

when I am trying to
 execute this line in my code
UserManager um = UserManager.getInstance();

Please let me know if you have something for me.

Regards
A Walia



--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/osworkflow-integration-configuration-problem-tp4636789.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: Help me if you know-please

2012-10-08 Thread BJ Freeman
the standard way is to  martial the data in groovy script that are 
called out(the new way) in a screen definition. you can find many 
examples of this in the code.
The martialed data is then defined and passed to the screen where you 
define screenlets to define layout.


I don't use SQL directly but define a entityview.

Note: I sent this to the user ML so others that may approach this 
differently can respond.
however if you want personalized help, I will be glad to consult for a 
fee with you.


giridhar mungi sent the following on 10/7/2012 10:03 PM:

Hi Freeman,

Good day to you.

my name is giridhar.Thanks for accepting for my connection request in
linkedin. i have seen ur mail id in linkedin.

I have doubt in Sql.please help me if you know.

*TableName:stores*

*storeid  date  price   paymenttype*
101   Oct-0126Creditcard
101   Oct-0125Creditcard
101   Oct-0125Cash
101   Oct-0124Cash
101   Oct-0133Cash
101   Oct-0135Cash.

This is the sample data.I want to display the total creditcard amount and
total cash amount individually per date and storeid.

if we want to display the creditcard,we can give like *select
storeid,date,sum(price) as creditcardtotal from stores where
paymenttype='creditcard'* *group by storeid,date*;

if we want to display the cash total,we can give like *select
storeid,date,sum(price) as cashtotal from stores where
paymenttype='cash'* *group
by storeid,date*;

*How to display the total amounts of credit card and cash  per storeid and
date in a  single query like,

storeid datetotalcreditcardamount totalcashamount


*please help me sir.*
*

Thanks  Regards,,
giridhar.



Re: Ofbiz and Apache HTTPD

2012-08-18 Thread BJ Freeman
clarity. if you run ofbiz as a standalone tomcat server it does not 
interact with HTTPD, but is in competition for the ports.
if you run ofbiz as a proxy through HTTPD, then ports are not in 
competition since you using 8019 port.
you still need to configure ofbiz to return the proper posts in the 
config file.


Sanjeev Gupta sent the following on 8/18/2012 9:58 AM:

@Deepak : the documentation actually suggests that we have Apache  ofbiz use
ports 80  433. I think if  we have ofbiz use different ports (8080  8443)
than HTTPD (80  443) , the urls generate by Ofbiz (with port 8080  8443)
will not work on HTTPD.

@Jacques Yes I followed the documentation for configuring HTTPD.



-
Rgds
Sanjeev
www.sanjeevg.com
@sanjeevgcom
--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/Ofbiz-and-Apache-HTTPD-tp4635813p4635826.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Solved upgrade of PostgreSQL version 8.4,2 to .12 caues connection problem.

2012-07-26 Thread BJ Freeman

it was a combination of two things.
the up grade to 8.4.12 does not use localhost. only host IP address for TCP
netstat -nlp | grep 5432
tcp0  0 xx.xx.xxx.32:5432   0.0.0.0:* 
LISTEN  2699/postmaster
unix  2  [ ACC ] STREAM LISTENING 9964   2699/postmaster 
/tmp/.s.PGSQL.5432

.
next centos 5.8 no longer allows 127.0.1 without it being put in 
firewall for both source and destination as well as port.


Rajbir Saini sent the following on 7/24/2012 8:49 PM:

It looks your PostgreSql is not listening on TCP sockets. Instead it is
listening on Linux socket and that is the reason when you give localhost
switch to psql client, it tries to use the loopback interface.

Simple solution is to make change in your postgresql.conf file to listen
on TCP socket.

Thanks,

Raj

On Wednesday 25 July 2012 08:31 AM, BJ Freeman wrote:

The 5 ofbiz installs have no changes since Jan 2012. the have been
running since 2011.
did a centos 5.6 server upgrade.
console:
[root@main jdbc]# psql -h localhost -U gameserver
passwordfromentityengine.xml

psql: could not connect to server: Connection refused
Is the server running on host localhost and accepting
TCP/IP connections on port 5432?


yet I can without the -h localhost, connect

this is a PostgreSQL problem that I am dealing with in their mailing
list.

just thought I would give a heads up.


Jacques Le Roux sent the following on 7/24/2012 2:01 PM:

I currently use 9.1, no issues in production

Jacques

From: BJ Freeman bjf...@free-man.net

PostgreSQL version 8.4.12 does not support 127.0.0.1 or localhost.
they use 127.0.0.1/32 in allowed host.
my entityengine.xml setting no longer work.
I am still working on a solution.









upgrade of PostgreSQL version 8.4,2 to .12 caues connection problem.

2012-07-24 Thread BJ Freeman

PostgreSQL version 8.4.12 does not support 127.0.0.1 or localhost.
they use 127.0.0.1/32 in allowed host.
my entityengine.xml setting no longer work.
I am still working on a solution.


Re: upgrade of PostgreSQL version 8.4,2 to .12 caues connection problem.

2012-07-24 Thread BJ Freeman
The 5 ofbiz installs have  no changes since Jan 2012. the have been 
running since 2011.

did a centos 5.6 server upgrade.
console:
[root@main jdbc]# psql -h localhost -U gameserver 
passwordfromentityengine.xml


psql: could not connect to server: Connection refused
Is the server running on host localhost and accepting
TCP/IP connections on port 5432?


yet I can without the -h localhost, connect

this is a PostgreSQL problem that I am dealing with in their mailing list.

just thought I would give a heads up.


Jacques Le Roux sent the following on 7/24/2012 2:01 PM:

I currently use 9.1, no issues in production

Jacques

From: BJ Freeman bjf...@free-man.net

PostgreSQL version 8.4.12 does not support 127.0.0.1 or localhost.
they use 127.0.0.1/32 in allowed host.
my entityengine.xml setting no longer work.
I am still working on a solution.




Re: OrderContent - how is the content uploaded?

2012-07-18 Thread BJ Freeman

which version of ofbiz are you using?
can you explain you Upload to order process in more detail?


Paul sent the following on 7/18/2012 10:39 AM:

Hi ,

I looking to attach some documents (scanned images) to order. I can see that
the data model has OrderContent Entity. I also see that there are ftl files
to show uploaded images attached to the order and OrderContentWrapper.java
file providing methods to display content.

What I am unable to find or at least don't see it in the code is a way to
upload content to the order. How is this supposed to work or is this
something not implemented yet?

Thanks in advance for tips/help
Paul

--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/OrderContent-how-is-the-content-uploaded-tp4635015.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: Java Service Classes

2012-07-16 Thread BJ Freeman

there are two different ways depending oh what you trying to do.
when you have data coming from a webpage you want process, use a event 
or service to process the data. I suggest mini lang since it takes a lot 
of coding out of the process.


when you want to display information you use the groovy to marshal the 
data then pass it to the FTL to be rendered.


PS. if is best if you join the ofbiz mailing and include past 
conversations so we can get a sense without hunting through the mailing 
list.


Prabhakar Pandey sent the following on 7/15/2012 10:52 PM:

Thanks everyone.
i want to fetch data from a table.
so how can i implement it using java event class and java service class i.e
first i go to event class and then call the service class so get the data?

On Fri, Jul 13, 2012 at 8:49 PM, Robert G.g...@mercon24.de  wrote:


Why dont you use service-groups

with that you can call a bundle of services, which run all together with
just one call..



--
View this message in context:
http://ofbiz.135035.n4.nabble.com/Java-Service-Classes-tp4634814p4634819.html
Sent from the OFBiz - User mailing list archive at Nabble.com.





Re: Trying to configure Apache HTTPD with Ofbiz

2012-07-10 Thread BJ Freeman

you can also go to the Apache repo
http://svn.apache.org/repos/asf/httpd
and view histories.
I looked and they were working with SSL june 12th

BJ Freeman sent the following on 7/9/2012 1:40 PM:

first start with a ean config file for httpd.
add the VirtualHost to see if that works.

if you notice there are different cofigureation for different httpd servers
if you have more problems I suggest you get on the httpd mailing list.

us...@httpd.apache.org

Sanjeev Gupta sent the following on 7/9/2012 7:38 AM:

Hi,
I'm following the steps given in the link below to configure Apache HTTPD
server with Ofbiz on the windows.
https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-Howtousemodproxyajp


However when i try to start the HTTPD server, i get the error The
requested
operation has failed!. I checked the error.log on the HTTPD server but
nothing in there.

Any idea what i could be doing wrong ??

-
Rgds
Sanjeev
www.sanjeevg.com
@sanjeevgcom
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/Trying-to-configure-Apache-HTTPD-with-Ofbiz-tp4634620.html

Sent from the OFBiz - User mailing list archive at Nabble.com.





Re: Trying to configure Apache HTTPD with Ofbiz

2012-07-10 Thread BJ Freeman

I use webmin which has tools for setting up SSL.

Sanjeev Gupta sent the following on 7/10/2012 12:08 AM:

Thanks Rajbir, BJ for your prompt help.
I think I've figured it out the problem - it's attributed to a couple of
things ..

1) mod_rewrite wasn't enabled while the VirtualHost had RewriteEngine set to
On.
2) as Rajbir said, SSL wasn't configured correctly.. Apache HTTPD doesn't
come with any default SSL Key, so until you create and configure one, it'll
keep throwing an error.

Hopefully once I'm able to deploy a SSL key, I should be all set.

Will post back if I find out any other issues..

-
Rgds
Sanjeev
www.sanjeevg.com
@sanjeevgcom
--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/Trying-to-configure-Apache-HTTPD-with-Ofbiz-tp4634620p4634645.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: Trying to configure Apache HTTPD with Ofbiz

2012-07-09 Thread BJ Freeman

first start with a clean config file for httpd.
add the VirtualHost to see if that works.

if you notice there are different cofigureation for different httpd servers
if you have more problems I suggest you get on the httpd mailing list.

us...@httpd.apache.org

Sanjeev Gupta sent the following on 7/9/2012 7:38 AM:

Hi,
I'm following the steps given in the link below to configure Apache HTTPD
server with Ofbiz on the windows.
https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-Howtousemodproxyajp

However when i try to start the HTTPD server, i get the error The requested
operation has failed!. I checked the error.log on the HTTPD server but
nothing in there.

Any idea what i could be doing wrong ??

-
Rgds
Sanjeev
www.sanjeevg.com
@sanjeevgcom
--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/Trying-to-configure-Apache-HTTPD-with-Ofbiz-tp4634620.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: Best practices to show banners

2012-07-09 Thread BJ Freeman
look in specialpurpose\ecommerce\webapp\ecommerce\content for examples 
of screelets.


start with \specialpurpose\ecommerce\webapp\ecommerce\main.ftl or any 
top level screen definition and work down the chain till you get to the 
Screen definition you want to put the screenlet in.


Create a Css class for your Slider to put in your screenlet




Robert G. sent the following on 7/9/2012 10:43 AM:

I want to archieve a similar thing (content slider on my startpage).

This slider shall include:
- direct link to a product
- link to a category
- link to a content site

To get this, I have to put a link and an image in my backend for each slider
content. I want f.ex. to do it like explained above (do an extra categorie
for each slider content)...but for doing this Im wondering what the
following things are:

- related Url
- alternative Url
- video Url

I think, that alternative Url is handled like an URL rewrite...that I can
get to the target Url with the alternative Url...but if so, what is the
related and the video Url?

For the image I can use the category image, but can I use f.ex. the related
Url to put in there a target Url...this Url I could get from my groovy file
to forward by click to the wanted content...but I do not want to get to the
category I added...

do you know what I mean?

Would appreciate a comment.

--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/Best-practices-to-show-banners-tp4632580p4634625.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: Loyalty / Reward point in ofbiz

2012-07-09 Thread BJ Freeman

inline

Deepak Agarwal sent the following on 7/9/2012 1:47 PM:

I am trying to add loyalty / reward points. So far, I have created a new
financial account type 'LoyaltyPoint' and currency conversion to convert 1$
to 1 point.
Financial for loyalty points give would be handle as discounts, 
Adervisting write off.

to track party point you can use the comments section and have a POINTS=10
other wise use a party agreement and store the points in it.
suggest this be a seperate service so many configuration can be 
calculated by it.


Following I am thinking to give the points to:

1) Signup
2) Reviewing a produc
3) Like on facebook
4) Follow in twitter

Also I would like to have following:
1) Attach some number of points to a product .

best doen with Product Agreements.

2) Attach some number of points to a value of total order. Say, if order is
greater than 100$ then get 50 points extra

this is best done with marketing.

\
First 4 looks to be a settings for loyalty points. But other are a type of
promotions. Either I should handle it in promotion or in some other manner.

just a matter of setting rules


Could you help me setting it up. I also need to dig the point where I can
add my eacs to credit customers financial a/c with these number.

maybe do some re-thinking


Re: add a screen in ecommerce to get extra information from the customer

2012-06-26 Thread BJ Freeman
My answer is based on using ofbiz frame work. So I will briefly 
reference those things and let you research the details.

you create a FTl that has you fields you want the user to filling in.
the submit till send this through the controller, that can be processed 
by code.
the code will take the fields, using Regex that you develop, and find 
the service(product) that you have in ofbiz, then a standard order is 
created.
once the standard order is created, anyone that has permission can view 
this and modify it.
you will have to add statuses to match your work flow that will send 
emails, if you need more than the standard ones ofbiz provide.


estimated time to implement 3-6 months, due to learning curve.


Robert G. sent the following on 6/25/2012 10:26 PM:

Hey Freeman, thanks!

what do you mean exactly with:


BJ Freeman wrote


you can put that page in then in the back in process it into the regular
order data. the problem is matching what the customer writes with what
you have for products.



You mean, that the customer fills in a text formular or sth. else, and this
data I show in my backend-order process?

I think this is a good way, but how can i do this. How do I get these fields
in my productdetail page...?

I can f. ex. integrate them as html form and send the data to server to fill
out kind of order attributes (are they availble? have not seen yet).

would be nice to get an answer from you :)

kindly

Robert

--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/add-a-screen-in-ecommerce-to-get-extra-information-from-the-customer-tp4633245p4634100.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: integrate supplier stock into ours - handle payments, orders, stock etc.

2012-06-26 Thread BJ Freeman
you should get the Data books ofbiz was based on, they explain a lot of 
what you want to do.

https://cwiki.apache.org/OFBADMIN/ofbiz-related-books.html


Robert G. sent the following on 6/25/2012 10:23 PM:

Hey guys,

I have probably a more complexe problem, where i am looking for a solution.

a supplier will create a stock (with his items, so we havent allready bought
them) in our warehouse.

We want:
1. sell these items and pay them to the supplier after we sold them
2. sell items for the supplier customers, so supplier settles a bill to the
customer, but we send these items out to them. So This gets into conflict
with point one. We also want to charge handle and shipping fees to the
supplier for that service.
3. knowing by each customer that this item was taken from this specific
stock (maybe by serial number?).

point 2. maybe I can handle it with a kind of stock move, that I have 2
stocks - one for our selling and one for his selling. Or is there a better
solution? And what about the fees we want to charge our supplier?

etc. etc. etc.

do anyone has a similar problem and got a soultion? Or do anyone has an idea
how to handle that process? Just small hints and ideas can bring me much
further :)

Thanks, Robert

--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/integrate-supplier-stock-into-ours-handle-payments-orders-stock-etc-tp4634099.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: Why are the OLAP and TENANT separate databases?

2012-06-26 Thread BJ Freeman

they are not related.
olap has to do with data mining of what ever you want
it is meant for reporting.
http://en.wikipedia.org/wiki/OLAP_cube

Tenant has to do with multiple separate DBs using the same code base.

Mike sent the following on 6/26/2012 9:10 AM:

Here is something that has always bugged me about the OFBiz setup, and I
was hoping that an OFBiz old-timer can please explain why the above
databases, by default, are configured as separate databases.

I can see, in theory, why TENANT is separate.

In the entityengine.xml, olap and tenant are separate databases.  Is there
any reason why the tables configured by these two databases, during initial
deployment, can't be incorporated into the main ofbiz database?

OLAP tables:
public | currency_dimension  | table | bigfish
public | date_dimension  | table | bigfish
public | inventory_item_fact | table | bigfish
public | product_dimension   | table | bigfish
public | sales_invoice_item_fact | table | bigfish
public | sales_order_item_fact   | table | bigfish

TENANT tables:
public | tenant | table | bigfish
public | tenant_data_source | table | bigfish

The reason I ask is when you are configuring the DB as external to the
running OFBiz java process (not 127.0.0.1, and NOT derby), you now have to
create and maintain 3 databases if you want to externalize the DB.  I would
rather just have to worry about a single database to replicate and backup.

The multi-tenant feature of OFBiz is rather an advanced feature that most
folks are not going to use, and in the event of going that route
(multi-tenant), I could then externalize this database if necessary.

Regarding OLAP, and why it is defined as a separate database is a real
mystery to me.  Can anyone please explain why it MAY be dangerous to merge
the above tables into the main OFBiz database?

Thanks



Re: Removing Controller in URL

2012-06-12 Thread BJ Freeman

if you take the controller out of the URL, you break the model of Ofbiz.
You are not using the ofbiz structure. You would not be able to render 
FTL's or any other docuement type without a lot of work.

to answer your question, the security would be the same as tom cat.


Sachin sent the following on 6/12/2012 1:57 AM:

Well thanks Mr.Gupta. My question is how secure is it to Remove Controller
in URL for entire application. I don't want to display a single URL which
extends /controller/. I changed redirect path to my own customized url for
all components but no luck...


Thanks in Advance


Regards,

Sachin




--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/Removing-Controller-in-URL-tp4633426p4633459.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: Removing Controller in URL

2012-06-12 Thread BJ Freeman

think of http://foo.com/control/webpage.html
as
http://foo.com/control?uri=webpage

if you rewrite the Url, you will need to assign something to redirect to 
control.
this being that control is the URL for accessing the controller.xml in 
ofbiz.


Deepak Agarwal sent the following on 6/12/2012 11:17 AM:

Could url rewriting be a solution ? Like
http://turbine.apache.org/turbine/development/turbine-2.3/howto/url-rewriting-howto.html


On Tue, Jun 12, 2012 at 3:38 PM, BJ Freemanbjf...@free-man.net  wrote:


if you take the controller out of the URL, you break the model of Ofbiz.
You are not using the ofbiz structure. You would not be able to render
FTL's or any other docuement type without a lot of work.
to answer your question, the security would be the same as tom cat.


Sachin sent the following on 6/12/2012 1:57 AM:

  Well thanks Mr.Gupta. My question is how secure is it to Remove

Controller
in URL for entire application. I don't want to display a single URL which
extends /controller/. I changed redirect path to my own customized url for
all components but no luck...


Thanks in Advance


Regards,

Sachin




--
View this message in context: http://ofbiz.135035.n4.nabble.**
com/Removing-Controller-in-**URL-tp4633426p4633459.htmlhttp://ofbiz.135035.n4.nabble.com/Removing-Controller-in-URL-tp4633426p4633459.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

--
Thanks,
Deepak Agarwal,

Paxcel Technologies Pvt Ltd.
Hartron Complex, Sector 18, Gurgaon, India.
E-Mail: deepak.agar...@paxcel.net
Mobile: +91 9910322604






Re: Removing Controller in URL

2012-06-12 Thread BJ Freeman

let us know how it worked.

Deepak Agarwal sent the following on 6/12/2012 2:01 PM:

Just for the sake of if somebody wants to remove 'control' from user at all
then one can configure a rule in tuckey:

  rule
 from/(.*)/from
 to/control/$1/to
 /rule
 outbound-rule
 from^/control/(.*)$/from
 to/$1/to
 /outbound-rule

Not tested though.

On Wed, Jun 13, 2012 at 1:22 AM, BJ Freemanbjf...@free-man.net  wrote:


think of 
http://foo.com/control/**webpage.htmlhttp://foo.com/control/webpage.html
as
http://foo.com/control?uri=**webpagehttp://foo.com/control?uri=webpage

if you rewrite the Url, you will need to assign something to redirect to
control.
this being that control is the URL for accessing the controller.xml in
ofbiz.

Deepak Agarwal sent the following on 6/12/2012 11:17 AM:


Could url rewriting be a solution ? Like
http://turbine.apache.org/**turbine/development/turbine-2.**
3/howto/url-rewriting-howto.**htmlhttp://turbine.apache.org/turbine/development/turbine-2.3/howto/url-rewriting-howto.html


On Tue, Jun 12, 2012 at 3:38 PM, BJ Freemanbjf...@free-man.net   wrote:

  if you take the controller out of the URL, you break the model of Ofbiz.

You are not using the ofbiz structure. You would not be able to render
FTL's or any other docuement type without a lot of work.
to answer your question, the security would be the same as tom cat.


Sachin sent the following on 6/12/2012 1:57 AM:

  Well thanks Mr.Gupta. My question is how secure is it to Remove


Controller
in URL for entire application. I don't want to display a single URL
which
extends /controller/. I changed redirect path to my own customized url
for
all components but no luck...


Thanks in Advance


Regards,

Sachin




--
View this message in context: http://ofbiz.135035.n4.nabble.
com/Removing-Controller-in-URL-tp4633426p4633459.htmlhtt**
p://ofbiz.135035.n4.nabble.**com/Removing-Controller-in-**
URL-tp4633426p4633459.htmlhttp://ofbiz.135035.n4.nabble.com/Removing-Controller-in-URL-tp4633426p4633459.html




Sent from the OFBiz - User mailing list archive at Nabble.com.

--
Thanks,
Deepak Agarwal,

Paxcel Technologies Pvt Ltd.
Hartron Complex, Sector 18, Gurgaon, India.
E-Mail: deepak.agar...@paxcel.net
Mobile: +91 9910322604

--
Thanks,
Deepak Agarwal,

Paxcel Technologies Pvt Ltd.
Hartron Complex, Sector 18, Gurgaon, India.
E-Mail: deepak.agar...@paxcel.net
Mobile: +91 9910322604

  %2B91%209910322604







Re: Shipping Estimates based on ZIP code Ranges

2012-06-09 Thread BJ Freeman
how would you handle multiple shipping facilities based on stocking 
inventory?


it is not a simple project. Like Paul says, you need some custom coding.


mz4whee...@gmail.com sent the following on 6/9/2012 3:24 PM:

What if in shipmentcostestimate there was a new y/n flag that meant goid_fm/to 
was a range vice exact?

That makes sense to me.

Sent via BlackBerry by ATT

-Original Message-
From: Paul Foxworthyp...@cohsoft.com.au
Date: Sat, 9 Jun 2012 07:27:36
To:user@ofbiz.apache.org
Reply-To: user@ofbiz.apache.org
Subject: Re: Shipping Estimates based on ZIP code Ranges

Hi Mike,

No, quantity break won't work. What you need are Geos  for each zip code
range, and a new entity that has a minimum and maximum zip code, and the
geoId for the corresponding zip code range.

Then write a custom service to take sender and destination zip codes,
translate to ranges, then do shipping in the usual way.

Cheers

Paul Foxworthy


Mike Z wrote


Thanks BJ.  I was thinking that maybe creating a new QuantityBreakID type
(SHIPMENT_ZIPCODE) where you can enter a zipcode range and update
ShipmentServices.java may work.

However, the above table shipping combinations (just for USPS) create
about
5000 different shipping rules, so instead I'm just going to create my own
perl-based SOAP server, create a new custom 3rd party shipment service
that
just passes zip+weight and returns rate.  It is probably easier and faster
for what I want to do.

On Thu, Jun 7, 2012 at 4:18 PM, BJ Freemanlt;bjfree@gt; wrote:


Geo can be grouped by areas. so you would first query the Area that
includes the zipcode the marshal all the geos then look uip the cost for
each cost for each Geo to give you a range.
it been a while since I did it so don't remember the exact structure.


Mike sent the following on 6/7/2012 2:53 PM:


I supplier ships to customers based on their zip code and weight.  They
use
a table like this for zip code:

  *ZIP Code Prefix* *Zone* *ZIP Code Prefix* *Zone* *ZIP Code Prefix*
*Zone*
*ZIP Code Prefix* *Zone*  005 4 349 6 496..497 3 716..722 5  006..009 8

350..352 4 498..509 4 723..725 4  010..013 4 354 5 510..513 5 726..731 5
014..034 5 355..359 4 514 4 733 6  035..037 4 360..361 5 515..516 5
734..741
5
Etc...

And their shipping rates/pound look like this:

Weight Postal Zone   (lbs) 1 2 3 4 5 6 7 8  1 $5.65 $5.65 $5.65 $5.65
$5.65 $5.65 $5.65 $5.65  2 $5.65 $5.65 $5.90 $6.55 $8.05 $8.40 $8.75
$9.30
3 $6.25 $6.25 $7.10 $8.10 $9.40 $10.15 $10.65 $11.40  4 $6.95 $6.95
$8.10
$9.10 $10.55 $11.55 $12.25 $13.30  5 $7.80 $7.80 $9.30 $10.35 $11.55
$12.40
$13.05 $14.20
Etc...

I wanted to see if I could setup shipping rules to accurately emulate
the
above in OFBiz, but I was unable to figure out where I could place
ranges
of zip codes in ofbiz.  I first thought that it would be possible to use
something like this:

QuantityBreak quantityBreakId=90001 quantityBreakTypeId=SHIP_**
WEIGHT
fromQuantity=0.00 thruQuantity=1.0/
QuantityBreak quantityBreakId=90102 quantityBreakTypeId=SHIP_**
WEIGHT
fromQuantity=1.01 thruQuantity=2.0/

ShipmentCostEstimate shipmentCostEstimateId=USPS_**STA10001
carrierPartyId=USPS carrierRoleTypeId=CARRIER productStoreId=9000
productStoreShipMethId=9004 orderFlatPrice=5.65
orderPricePercent=0.0 geoIdFrom=00500 geoIdTo=00599
shipmentMethodTypeId=**STANDARD  weightBreakId=90001/

ShipmentCostEstimate shipmentCostEstimateId=USPS_**STA10002
carrierPartyId=USPS carrierRoleTypeId=CARRIER productStoreId=9000
productStoreShipMethId=9004 orderFlatPrice=6.55
orderPricePercent=0.0 geoIdFrom=00500 geoIdTo=00599
shipmentMethodTypeId=**STANDARD  weightBreakId=90102/

But then I soon learned that geoIdFrom and geoIdTo were actual,
exact
FROM/TO zip codes, and not RANGES, which I initially tried.

So I ask:  Is it possible to setup shipping rules based on RANGES of ZIP
codes?  How would you do it?

I already know that I can use USPS to lookups, but I wanted to EXACTLY
duplicate the shipping rates that the supplier uses, then add my own
markup
as I see fit.

Thanks

Mike







-
--
Coherent Software Australia Pty Ltd
http://www.cohsoft.com.au/

Bonsai ERP, the all-inclusive ERP system
http://www.bonsaierp.com.au/

--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/Shipping-Estimates-based-on-ZIP-code-Ranges-tp4633347p4633391.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


Re: Shipping Estimates based on ZIP code Ranges

2012-06-08 Thread BJ Freeman
well you got to get down to the details somewhere. I ran an SQL based 
third party service, then change over to ofbiz structure, that I provide 
as a third party to dumb websites.
it all comes down to processing speed of the CPU and the number of 
instructions it takes to get the results.


off loading it to a third party app is like doing parallel processing.
don't think you will see much performance increase or ease of programming.

good luck in your endeavor.

Mike sent the following on 6/7/2012 7:44 PM:

Thanks BJ.  I was thinking that maybe creating a new QuantityBreakID type
(SHIPMENT_ZIPCODE) where you can enter a zipcode range and update
ShipmentServices.java may work.

However, the above table shipping combinations (just for USPS) create about
5000 different shipping rules, so instead I'm just going to create my own
perl-based SOAP server, create a new custom 3rd party shipment service that
just passes zip+weight and returns rate.  It is probably easier and faster
for what I want to do.

On Thu, Jun 7, 2012 at 4:18 PM, BJ Freemanbjf...@free-man.net  wrote:


Geo can be grouped by areas. so you would first query the Area that
includes the zipcode the marshal all the geos then look uip the cost for
each cost for each Geo to give you a range.
it been a while since I did it so don't remember the exact structure.


Mike sent the following on 6/7/2012 2:53 PM:


I supplier ships to customers based on their zip code and weight.  They
use
a table like this for zip code:

  *ZIP Code Prefix* *Zone* *ZIP Code Prefix* *Zone* *ZIP Code Prefix*
*Zone*
*ZIP Code Prefix* *Zone*  005 4 349 6 496..497 3 716..722 5  006..009 8

350..352 4 498..509 4 723..725 4  010..013 4 354 5 510..513 5 726..731 5
014..034 5 355..359 4 514 4 733 6  035..037 4 360..361 5 515..516 5
734..741
5
Etc...

And their shipping rates/pound look like this:

Weight Postal Zone   (lbs) 1 2 3 4 5 6 7 8  1 $5.65 $5.65 $5.65 $5.65
$5.65 $5.65 $5.65 $5.65  2 $5.65 $5.65 $5.90 $6.55 $8.05 $8.40 $8.75 $9.30
3 $6.25 $6.25 $7.10 $8.10 $9.40 $10.15 $10.65 $11.40  4 $6.95 $6.95 $8.10
$9.10 $10.55 $11.55 $12.25 $13.30  5 $7.80 $7.80 $9.30 $10.35 $11.55
$12.40
$13.05 $14.20
Etc...

I wanted to see if I could setup shipping rules to accurately emulate the
above in OFBiz, but I was unable to figure out where I could place
ranges
of zip codes in ofbiz.  I first thought that it would be possible to use
something like this:

QuantityBreak quantityBreakId=90001 quantityBreakTypeId=SHIP_**
WEIGHT
fromQuantity=0.00 thruQuantity=1.0/
QuantityBreak quantityBreakId=90102 quantityBreakTypeId=SHIP_**
WEIGHT
fromQuantity=1.01 thruQuantity=2.0/

ShipmentCostEstimate shipmentCostEstimateId=USPS_**STA10001
carrierPartyId=USPS carrierRoleTypeId=CARRIER productStoreId=9000
productStoreShipMethId=9004 orderFlatPrice=5.65
orderPricePercent=0.0 geoIdFrom=00500 geoIdTo=00599
shipmentMethodTypeId=**STANDARD  weightBreakId=90001/

ShipmentCostEstimate shipmentCostEstimateId=USPS_**STA10002
carrierPartyId=USPS carrierRoleTypeId=CARRIER productStoreId=9000
productStoreShipMethId=9004 orderFlatPrice=6.55
orderPricePercent=0.0 geoIdFrom=00500 geoIdTo=00599
shipmentMethodTypeId=**STANDARD  weightBreakId=90102/

But then I soon learned that geoIdFrom and geoIdTo were actual, exact
FROM/TO zip codes, and not RANGES, which I initially tried.

So I ask:  Is it possible to setup shipping rules based on RANGES of ZIP
codes?  How would you do it?

I already know that I can use USPS to lookups, but I wanted to EXACTLY
duplicate the shipping rates that the supplier uses, then add my own
markup
as I see fit.

Thanks

Mike






Re: Shipping Estimates based on ZIP code Ranges

2012-06-07 Thread BJ Freeman
Geo can be grouped by areas. so you would first query the Area that 
includes the zipcode the marshal all the geos then look uip the cost for 
each cost for each Geo to give you a range.

it been a while since I did it so don't remember the exact structure.


Mike sent the following on 6/7/2012 2:53 PM:

I supplier ships to customers based on their zip code and weight.  They use
a table like this for zip code:

  *ZIP Code Prefix* *Zone* *ZIP Code Prefix* *Zone* *ZIP Code Prefix* *Zone*
*ZIP Code Prefix* *Zone*  005 4 349 6 496..497 3 716..722 5  006..009 8
350..352 4 498..509 4 723..725 4  010..013 4 354 5 510..513 5 726..731 5
014..034 5 355..359 4 514 4 733 6  035..037 4 360..361 5 515..516 5 734..741
5
Etc...

And their shipping rates/pound look like this:

Weight Postal Zone   (lbs) 1 2 3 4 5 6 7 8  1 $5.65 $5.65 $5.65 $5.65
$5.65 $5.65 $5.65 $5.65  2 $5.65 $5.65 $5.90 $6.55 $8.05 $8.40 $8.75 $9.30
3 $6.25 $6.25 $7.10 $8.10 $9.40 $10.15 $10.65 $11.40  4 $6.95 $6.95 $8.10
$9.10 $10.55 $11.55 $12.25 $13.30  5 $7.80 $7.80 $9.30 $10.35 $11.55 $12.40
$13.05 $14.20
Etc...

I wanted to see if I could setup shipping rules to accurately emulate the
above in OFBiz, but I was unable to figure out where I could place ranges
of zip codes in ofbiz.  I first thought that it would be possible to use
something like this:

QuantityBreak quantityBreakId=90001 quantityBreakTypeId=SHIP_WEIGHT
fromQuantity=0.00 thruQuantity=1.0/
QuantityBreak quantityBreakId=90102 quantityBreakTypeId=SHIP_WEIGHT
fromQuantity=1.01 thruQuantity=2.0/

ShipmentCostEstimate shipmentCostEstimateId=USPS_STA10001
carrierPartyId=USPS carrierRoleTypeId=CARRIER productStoreId=9000
productStoreShipMethId=9004 orderFlatPrice=5.65
orderPricePercent=0.0 geoIdFrom=00500 geoIdTo=00599
shipmentMethodTypeId=STANDARD  weightBreakId=90001/

ShipmentCostEstimate shipmentCostEstimateId=USPS_STA10002
carrierPartyId=USPS carrierRoleTypeId=CARRIER productStoreId=9000
productStoreShipMethId=9004 orderFlatPrice=6.55
orderPricePercent=0.0 geoIdFrom=00500 geoIdTo=00599
shipmentMethodTypeId=STANDARD  weightBreakId=90102/

But then I soon learned that geoIdFrom and geoIdTo were actual, exact
FROM/TO zip codes, and not RANGES, which I initially tried.

So I ask:  Is it possible to setup shipping rules based on RANGES of ZIP
codes?  How would you do it?

I already know that I can use USPS to lookups, but I wanted to EXACTLY
duplicate the shipping rates that the supplier uses, then add my own markup
as I see fit.

Thanks

Mike



Re: add a screen in ecommerce to get extra information from the customer

2012-06-06 Thread BJ Freeman
you can put that page in then in the back in process it into the regular 
order data. the problem is matching what the customer writes with what 
you have for products.
or you can add type-as-you go to let the customer select the data. so if 
the fist letter typed is M then only those in the drop down will be 
those that start with M. if next types 2 then only those with M2 will 
show, etc.
so the customer will get a confirmation order using the normal order 
pages in ofbiz.
then the order will show up in the back end and will start the 
production run, once approved, unless you have automatic approval set.


Robert G. sent the following on 6/6/2012 3:05 PM:

great thanks, ok the manufacturing process sound perfectly.

Concerning the extra information i am not sure, if virtual / variants does
the job I need. F.eX. the repair is for about 5000 models, so I dont want
the customer to choose it in a drop down, I want him to write the
information in a form on checkout, or on product page. These information has
to be shown in the backend system on the order etc.

what do you think?

--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/add-a-screen-in-ecommerce-to-get-extra-information-from-the-customer-tp4633245p4633299.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: add a screen in ecommerce to get extra information from the customer

2012-06-05 Thread BJ Freeman


ofbiz is set up to provide services as a product.
you can use the virtual/variant. to setup manufacture, model, etc.
you can use the manufacturing component to start a route, that waits for 
the item to arrive, then process. part of the process can be to sent a 
part to another facility.

so all your repair steps can be defined

not all of this is OOTB, and requires some customization.

Robert G. sent the following on 6/5/2012 4:42 AM:

Hey,

I have products like service products, where I do cleaning or repairs...

I want to make the process easier, so I want to get specific information
from the customer depending of the product type...

if he want to repair sth, I want f.ex. get the information about the model,
manufacturer and the error description from him.

These information shall be visible in the management system behind the
ecommerce...f.ex. in the order summary etc...that the employee can see the
details. (maybe I use the attributes?)

The second problem is, that we let the things repair by another company. So
after we get the defective good, we send it to the other company...and gets
it repaired back. How can I handle this process, that we know on every time
where the item is and with which status it is there...like waiting for
approval, repaired etc.

what do you think?

--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/add-a-screen-in-ecommerce-to-get-extra-information-from-the-customer-tp4633245.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: Need help using /ofbizsetup!

2012-06-02 Thread BJ Freeman
The seed data does not include some data the demo does, so it will work 
on the Demo trunk but not on an install.

I believe there is a Jira about this and a thread some time back.

Jacques Le Roux sent the following on 6/2/2012 3:08 AM:

Can you reproduce with trunk?

Jacques

From: charleslcso char...@tourdefarm.com

Just installed ofbiz 10.04.02, and following the guide

http://demo-trunk.ofbiz.apache.org/cmssite/cms/APACHE_OFBIZ_HTML

to set it up.

At Product Store section, and upon clicking button Update the following
error occurred:

Error: Error parsing entity xml file:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:CarrierShipmentMethod][createdStamp,2012-06-02
11:52:49.89(java.sql.Timestamp)][createdTxStamp,2012-06-02
11:52:49.701(java.sql.Timestamp)][lastUpdatedStamp,2012-06-02
11:52:49.89(java.sql.Timestamp)][lastUpdatedTxStamp,2012-06-02
11:52:49.701(java.sql.Timestamp)][partyId,Company(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]

(SQL Exception while executing the following:INSERT INTO
public.CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID,
ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?,
?, ?,
?, ?, ?, ?, ?) (ERROR: insert or update on table
carrier_shipment_method
violates foreign key constraint carr_shmeth_typebr/ Detail: Key
(shipment_method_type_id)=(LOCAL_DELIVERY) is not present in table
shipment_method_type.)) calling service parseEntityXmlFile in
importTempDataFile

Checked the table shipment_method_type and it's empty.

How do I manually load all the shipment related tables into the database
using ant?

BTW, I only executed ./ant run-install-extseed before trying to run
/ofbizsetup.

Please help!

--
View this message in context:
http://ofbiz.135035.n4.nabble.com/Need-help-using-ofbizsetup-tp4632997.html

Sent from the OFBiz - User mailing list archive at Nabble.com.




Re: Tips or a cookbook

2012-06-01 Thread BJ Freeman
the best way to learn widget is use a xml editor that will give you each 
valid element as you build the file.
you can also read the Schema file for the widget and the comments buried 
in them.

FTL is how to build files to have it rendered has html.
you marshal the data for the ftl through the grovy files.
if you use screen widgets you can fall the grooby from there.
otherwise name the groovy the same as the FTl file and it will be 
executed before the FTL is called.

there are plenty of examples in code.
expect about a year to learn all the in and outs of ofbiz, minimum.

G.Ben sent the following on 5/31/2012 12:51 AM:

Hi everyone,

I'm having some issues with OFBiz and its tutorials, it's not quite enough
for me, because I'm developping a real application with it,
So, I need to know the syntax of that language, for example : the ui labels
how and what do we use them for ? a HTML page without Ui labels should it be
enough ??
And the form widget, what is syntax that we should follow (for example : to
put an image ? to put a file in attachement etc ... )
And for style, do we always use CSS, if yes, is it like CSS with HTML ...
I have a few knowledge about OFBiz and i'm really struggling with it ... I
keep googling and I don't find simple things.

P.S : Excuse me if my english is not that good.

Thank you for your help.

Regards.

G.Ben

--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/Tips-or-a-cookbook-tp4632835.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: app

2012-06-01 Thread BJ Freeman

qualified no.
as long as you don't want to access data from ofbiz you can use html
you still will need to learn the controller.

G.Ben sent the following on 6/1/2012 3:14 AM:

Hi everyone,

I was wondering if I can develop a whole application with just HTML
(Freemarker template) and without any script of Freemarker and also without
formwidgets, or menu widgets,
Everything in the interface will be in HTML, so it possible ?
Advantages and inconvenients ?

Thank you.

Regards.

G.Ben

--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/app-tp4632918.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: Tips or a cookbook

2012-06-01 Thread BJ Freeman

LOL try it with no documentation there is now.
a year is a short time.

G.Ben sent the following on 6/1/2012 3:57 AM:

Wow a year, that seems a long time.
Well, thank you BJ Freeman.

Rgrds.

G.Ben.

--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/Tips-or-a-cookbook-tp4632835p4632923.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: Tips or a cookbook

2012-06-01 Thread BJ Freeman

I only deal with ofbiz as the modeling it started with for UI.
this is where a Rendering engine is created and defined in the 
controller, and ftl are used as the basis for the rendering.


That said, I also use FTL to prsent a UI front end that is just links to 
other pages. In that I still use a standard screen widget to call it.


I resist other ways to interact with other web systems.



Deepak Agarwal sent the following on 6/1/2012 4:03 AM:

BJ Freeman/All,

We are mainly into zkoss framework (and have integrated well with ofbiz),
but still I find a lot of pain while creating service wrappers in zk over
ofbiz services.
Would like to know your suggestions if we should go with Screen/Widget for
front end design or zkoss is better.

On Fri, Jun 1, 2012 at 4:10 PM, BJ Freemanbjf...@free-man.net  wrote:


the best way to learn widget is use a xml editor that will give you each
valid element as you build the file.
you can also read the Schema file for the widget and the comments buried
in them.
FTL is how to build files to have it rendered has html.
you marshal the data for the ftl through the grovy files.
if you use screen widgets you can fall the grooby from there.
otherwise name the groovy the same as the FTl file and it will be executed
before the FTL is called.
there are plenty of examples in code.
expect about a year to learn all the in and outs of ofbiz, minimum.

G.Ben sent the following on 5/31/2012 12:51 AM:

  Hi everyone,


I'm having some issues with OFBiz and its tutorials, it's not quite enough
for me, because I'm developping a real application with it,
So, I need to know the syntax of that language, for example : the ui
labels
how and what do we use them for ? a HTML page without Ui labels should it
be
enough ??
And the form widget, what is syntax that we should follow (for example :
to
put an image ? to put a file in attachement etc ... )
And for style, do we always use CSS, if yes, is it like CSS with HTML ...
I have a few knowledge about OFBiz and i'm really struggling with it ... I
keep googling and I don't find simple things.

P.S : Excuse me if my english is not that good.

Thank you for your help.

Regards.

G.Ben

--
View this message in context: http://ofbiz.135035.n4.nabble.**
com/Tips-or-a-cookbook-**tp4632835.htmlhttp://ofbiz.135035.n4.nabble.com/Tips-or-a-cookbook-tp4632835.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

--
Thanks,
Deepak Agarwal,







No Copyrights on APIs: Judge Defends Interoperability and Innovation

2012-05-31 Thread BJ Freeman

https://www.eff.org/deeplinks/2012/05/no-copyrights-apis-judge-defends-interoperability-and-innovation


Re: proposal

2012-05-21 Thread BJ Freeman

at the first level you can create a working Catalog that is not online.
then you can use the copy function to the live catalog when ready.
so the only thing necessary is a to from list that a import routing can 
read and do the copies in mass.


Info Olagos sent the following on 5/20/2012 11:33 AM:

Hello,

What should be a very nice feature in Ofbiz which doesn't exist at the
moment, is the following:

It should be nice if you could insert all the data for a certain new
product in different days. Let's say day one, you do the product
properties, day two you continue with the content part, day three you
continue with the price, etc.

You only publish the new product when you have completed all data. So the
product doesn't appear not complete on the webpage.

So one need a PUBLISH button.

I don't think that is possible at the moment in Ofbiz.

Regards,
Heidi  Eric



Re: ASF Board reports and health of the project/community

2012-04-29 Thread BJ Freeman

inline

Adrian Crum sent the following on 4/29/2012 2:04 AM:

On 4/28/2012 11:20 AM, BJ Freeman wrote:

Having adopted Ofbiz Model in 2002 for my business, I am both a User
and developer. the Developer was more forced, do to the attitude that
prevailed at the time.
A re-occurring theme I have heard over the years is that Ofbiz was
created to generate revenue for those developers that had an Ofbiz
email address that has been since moved to hotwax.


That is not an accurate description. OFBiz started out as a programming
project for a specific client, and that project was made open source.

Since then, many of the contributions made to OFBiz are driven by
clients who fund the development. Other contributions are volunteer
efforts (the refactorings I've done are an example).


Also that those that are first to contribute have the control of the
particular projecct, even if it does not fight the model ofbiz started
with.


Maybe that is because the model changes over time. That is not a bad
thing. There are some things in the original OFBiz that were done wrong.
Should we keep them that way forever?


this is my main focus, I believe you confuse Model with implementation.
for instance, the model for rendering was that many forms of rendering 
could take the same parameters and generate different outputs. This just 
took defining the Rendering engine.
this has been bypassed, so there is no easy way to remove or add 
rendering as one chooses.



Many contribute based on their background that corrupts the ofbiz
model, particularly how UI is created.


If you have something specific in mind, then please open a Jira issue
and provide a patch.


All these things and few other less significant attitudes has left me
no other choice than to not use the ofbiz repository as a source of
solutions.
First I have a business to run, and the volatility of the Code does
not make it any easier to have dependable, Stable code base or
operation parameters.
Second the code base is used as a developer playground, not to service
the end user.


That phrase keeps popping up, but I have no idea what it means. I have
been involved with the project for 8 years, and I can't see where anyone
is using OFBiz as a developer's playground. From my perspective, the
OFBiz developer community is composed of skilled professionals who work
hard to make OFBiz a stable, robust platform for web application
development.
this I attribute to a different perspective about how to develop and 
provide updates.
The biggest is there is not testing from beginning to end only testing a 
module with set fixed inputs, but not all those that the modules using 
it could generate.
The effort to have migration process, so the upgrade path is easy for 
the end user.
that code gets changes that any customization is make inert because the 
code it depended on is removed or changed to the level it will not work.





We review the commits for Ideas but implement them to fit the model we
started out with.
In my view there is no roadmap for ofbiz just a bunch of Kludges.
As you see I monitor the ML, but don't see any use in contributing.


Everyone can choose to curse the darkness or light a candle. From what I
recall, whenever you have been asked to provide a patch to address your
concerns, you create a Jira issue but don't provide a patch, or you make
an excuse why you can't be bothered. The bottom line is, you get out of
OFBiz what you put into it. So, if you're not getting anything out of
OFBiz...

I since I branched from Ofbiz repository, where I have control, and I 
put effort into that, I am getting all I need.
Though it is not possible to do that with the way ofbiz is managed 
currently.

I don't see trying to redo code that someone has put in and not fixed.
Like the way partyrelations was implemented in the HR component.
This again is about the model.

-Adrian




Re: ASF Board reports and health of the project/community

2012-04-28 Thread BJ Freeman
Having adopted Ofbiz Model in 2002 for my business, I am both a User and 
developer. the Developer was more forced, do to the attitude that 
prevailed at the time.
A re-occurring theme I have heard over the years is that Ofbiz was 
created to generate revenue for those developers that  had an Ofbiz 
email address that has been since moved to hotwax.
Also that those that are first to contribute have the control of the 
particular projecct, even if it does not fight the model ofbiz started with.
Many contribute based on their background that corrupts the ofbiz model, 
particularly how UI is created.
All these things and few other less significant attitudes has left me no 
other choice than to not use the ofbiz repository as a source of solutions.
First I have a business to run, and the volatility of the Code does not 
make it any easier to have dependable, Stable code base or operation 
parameters.
Second the code base is used as a developer playground, not to service 
the end user.
We review the commits for Ideas but implement them to fit the model we 
started out with.

In my view there is no roadmap for ofbiz just a bunch of Kludges.
As you see I monitor the ML, but don't see any use in contributing.



Pierre Smits sent the following on 4/27/2012 6:25 AM:

Dear OFBiz Community Member,

I herewith take the opportunity to inform you about the obligation on the
OFBiz PMC to inform the ASF Board about how we as a community are doing.
These reports can be found at:
https://cwiki.apache.org/OFBADMIN/asf-board-reports.html.

Following the project since it came out of incubation in 2006 and
contributing since august 2008 I believe that the OFBiz PMC doesn't
communicate as well as it could and should. Looking back through old email
I noticed that only in 2009 there was a reference to ASF Board reports. Not
informing the community (through mailing lists) about upcoming reports and
not communicating that a new report has been submitted is an oversight that
can easily be remitted. Informing the community that new reports are
pending  or submitted should be one of the obligations of the OFBiz PMC to
the community.

Looking at the upcoming Board report (intended June 2012, found here:
https://cwiki.apache.org/OFBADMIN/asf-board-report-2012-06-draft.html) I
find that it should contain more than just a statement that R10.04.02 has
been released and a lot of copy-pasting of the previous report. Please read
the report.

Under the heading of Infrastructure
I believe that it should mentioned that no automated building and testing
has taken place since Jan 2012 on the underlying system of buildbot. And
that uptake by the INFRA community is slow.

Under the heading of Community and Project
I believe that it should state the progress regarding the roadmap. We can
communicate more on how we are moving ahead with code.

I also believe that it should mention (under the heading of Community and
Project) that although interactions on user and dev mailling list remain
high, the number of interacting PMC members and Committers is dwindling.
Of the 16 PMC members and 22 committers on the list only a handful
participate in user questions and developer issues. Even the last voting on
the release of 10.04.02 attracted no more than 4 PMC members to vote. And
that I find very alarming. The project deserves more actively participating
PMC Members and Committers.

In stead of having an active participation in the strengthening and
expanding the community and enhancing/improving OFBiz, we are on a road of
contraction (moving code out of OFBiz in the hope/trust that if important
enough it will be picked up by another community), which will lead to even
less participation in the OFBiz community via mailing lists and product
development. I find that disturbing.

We currently have about 640 unaddressed issues referenced in JIRA, of which
more than half are registered with a classification of mayor or higher
impact. It shows that, apart from the handful of Commiters working on
issues not referenced in JIRA, we have serious issues to deal with. These
issues should be addressed within the community and mentioned to ASF Board.

If we do not address the issues the project is facing it might come to a
point that the viability of this project is questioned. I believe we (as a
community) don't want that.

So, I invite you to share your thoughts on how this community is doing,
what can be improved and what should be reported to the ASF Board.

Sincerely yours,

Pierre Smits



Re: The end of ERP

2012-04-11 Thread BJ Freeman
ERP as in Enterprise Resource Management, May change as far as the 
Enterprises that use it. But the Functions for Resource management is 
well and good for any business that wants to maximize their profits.
My small(med) business use the ofbiz core with enhancement for Software 
design and project management, as well as the hardware design we do.
Though we use Build to order, most of the time, doing resource 
evaluation to determine when we start to build to possible orders is 
important. Where the break point of Resources against Keeping stock, 
make sense.
This ofoourse means fleshing out the budget entities, tied into a 
business plan, to be automatic.


Jacques Le Roux sent the following on 4/10/2012 11:51 PM:

Hi,

This morning I read
http://www.forbes.com/sites/ciocentral/2012/02/09/the-end-of-erp
Here is a review of this article
http://www.javacodegeeks.com/2012/04/end-of-erp-as-we-know-it.html

I can tell you that OFBiz is not a perfect solution for the new
subscription model, but mostly it works. It's time to think more about
it though... This is coming fast...

Jacques



Re: Tally Integration

2012-04-04 Thread BJ Freeman

from tally sight
Is Tally is web-enabled?
No. However, you may use Synchronisation feature and access Tally.
this might be like the Intuit bridge that was used in Ofbiz a few years back

Dhiraj Gupta sent the following on 4/4/2012 12:44 AM:

Hi I want to integrate ofbiz with tally. Can do you have any suggestion about 
it .Tally is accounting software used in India in wast manner.


ThanksDhiraj Gupta9990220686



Re: Beanshell source code

2012-03-25 Thread BJ Freeman

http://svn.apache.org/viewvc?view=revisionrevision=533448
https://issues.apache.org/jira/browse/OFBIZ-528

Daniel McAllister sent the following on 3/23/2012 6:13 AM:

Hello!

I'm using an old version of Ofbiz. It's the Ofbiz 4.0. What I'm looking for
is the Beanshell source-code that is bundled with this version. More
specifically the the bsh-2.0b4.jar. Unfortunately the jar file has been
patched, but the jar file's name doesn't reflect the patches. I have found
several patches at here https://issues.apache.org/jira/browse/OFBIZ but
it's very confusing what patches should i apply on the original Beanshell
source.

Someone please send me the source-code of the bsh jar.

Thx, Daniel.



Re: Beanshell source code

2012-03-25 Thread BJ Freeman

http://svn.apache.org/viewvc?view=revisionrevision=929809

BJ Freeman sent the following on 3/25/2012 2:12 AM:

http://svn.apache.org/viewvc?view=revisionrevision=533448
https://issues.apache.org/jira/browse/OFBIZ-528

Daniel McAllister sent the following on 3/23/2012 6:13 AM:

Hello!

I'm using an old version of Ofbiz. It's the Ofbiz 4.0. What I'm
looking for
is the Beanshell source-code that is bundled with this version. More
specifically the the bsh-2.0b4.jar. Unfortunately the jar file has been
patched, but the jar file's name doesn't reflect the patches. I have
found
several patches at here https://issues.apache.org/jira/browse/OFBIZ but
it's very confusing what patches should i apply on the original Beanshell
source.

Someone please send me the source-code of the bsh jar.

Thx, Daniel.





Re: Beanshell source code

2012-03-25 Thread BJ Freeman

thanks for clean up on wiki.
I missed 303 so now we have a complete path.


Jacques Le Roux sent the following on 3/25/2012 2:41 AM:

in https://issues.apache.org/jira/browse/OFBIZ-528
I updated the link to OFBiz Customized BeanShell Source (with
ParsedScript object) in wiki

Hopefully the required sources are in OFBIZ-528, I did not check.

Ha yes it's here https://issues.apache.org/jira/browse/OFBIZ-303, right?

Jacques

From: BJ Freeman bjf...@free-man.net

http://svn.apache.org/viewvc?view=revisionrevision=533448
https://issues.apache.org/jira/browse/OFBIZ-528

Daniel McAllister sent the following on 3/23/2012 6:13 AM:

Hello!

I'm using an old version of Ofbiz. It's the Ofbiz 4.0. What I'm
looking for
is the Beanshell source-code that is bundled with this version. More
specifically the the bsh-2.0b4.jar. Unfortunately the jar file has been
patched, but the jar file's name doesn't reflect the patches. I have
found
several patches at here https://issues.apache.org/jira/browse/OFBIZ but
it's very confusing what patches should i apply on the original
Beanshell
source.

Someone please send me the source-code of the bsh jar.

Thx, Daniel.





Re: discussion: b2b versus b2c

2012-03-05 Thread BJ Freeman
if the partyrelationship is used as in Vol1 of the data manual, there 
should be no problem, which is why I reverted to the way the databook 
did it.


Hans Bakker sent the following on 3/5/2012 12:13 AM:

At the moment the system is focused being a b2c (business to consumer)
system. We are now getting more and more requests for systems mainly for
b2b (business to business)

The main difference is that in the b2c case the order/invoice is for the
person and in a b2b the order/invoice is for the related company of that
person.

In the registration process a person can register referring to a
company, a second person can register to the same company however
somewhere needs to be a approval process.

I was thinking introducing a system parameter to make the related
company of a person mandatory or not

any thoughts on this?

Regards,
Hans



Fleet tracking

2012-02-01 Thread BJ Freeman
here is a start point for you to create your own tracking module.
http://tinkerlog.com/2009/05/15/interfacing-arduino-with-a-telit-gm862/
cost per unit is about $300 in parts.
you will have to modify the code.
for enhancement you can
http://tinkerlog.com/2007/07/28/using-google-maps-with-a-mobile-gps-tracker/


Re: version 11.4 or 10.4 most stable?

2012-01-31 Thread BJ Freeman
if you want control of your code and want the latest and greatest I
suggest you maintain your own code repository, and use the commits after
reviewing them. Then run you full tests against the the complete system.

Info Olagos sent the following on 1/27/2012 2:48 AM:
 Hello,
 
 Can anyone inform me about the latest versions of Ofbiz.
 
 Is version 11.4 or rather 10.4 the most stable ?
 
 Regards,
 Heidi
 


Re: version 11.4 or 10.4 most stable?

2012-01-31 Thread BJ Freeman
https://cwiki.apache.org/OFBADMIN/mailing-lists.html
comm...@ofbiz.apache.org
this will give you thee actual commit files.

Info Olagos sent the following on 1/31/2012 2:29 AM:
 Hello,
 
 Ok that seems me a good idea.
 But where to find these commits? and from which commit on to start.
 
 Heidi
 
 2012/1/31, BJ Freeman bjf...@free-man.net:
 if you want control of your code and want the latest and greatest I
 suggest you maintain your own code repository, and use the commits after
 reviewing them. Then run you full tests against the the complete system.

 Info Olagos sent the following on 1/27/2012 2:48 AM:
 Hello,

 Can anyone inform me about the latest versions of Ofbiz.

 Is version 11.4 or rather 10.4 the most stable ?

 Regards,
 Heidi


 
 


Re: version 11.4 or 10.4 most stable?

2012-01-31 Thread BJ Freeman
yes, but compared to keep the code so a change does not effect custom
code is better than having to redo a large code base it depends on.

Adrian Crum sent the following on 1/31/2012 3:22 AM:
 That approach is what I like to call an internal fork. It is a good way
 to maintain control of the codebase, but it is expensive to maintain.
 
 -Adrian
 
 On 1/31/2012 10:15 AM, BJ Freeman wrote:
 if you want control of your code and want the latest and greatest I
 suggest you maintain your own code repository, and use the commits after
 reviewing them. Then run you full tests against the the complete system.

 Info Olagos sent the following on 1/27/2012 2:48 AM:
 Hello,

 Can anyone inform me about the latest versions of Ofbiz.

 Is version 11.4 or rather 10.4 the most stable ?

 Regards,
 Heidi

 


Re: Endicia integration now available for ofbiz

2012-01-28 Thread BJ Freeman
did that a few years back.
why not stick with the direct USPS?

Si Chen sent the following on 1/27/2012 10:30 AM:
 Hi everybody,
 
 Happy new year!
 
 We've just implemented an Endicia integration for ofbiz, so now you can use
 Endicia to print USPS mailing labels from ofbiz (as well as opentaps).  For
 more information, please see
 http://shop.opentaps.org/index.php/featured/opentaps-ofbiz-endicia-integration-module.html
 


Re: Running under external tomcat

2012-01-28 Thread BJ Freeman
Just a guess, Hans put in some code for vitural server. might want to
check it out

Mansour Al Akeel sent the following on 1/27/2012 11:46 AM:
 This is issue is still pending. The recent revision from trunk doesn't
 work on external tomcat.
 And I was not able to trouble shoot the issue.
 I commented out all the app context in the generated
 TOMCAT_HOME/conf/server.xml and left bi to see the results.
 All I get is:
 
 
 INFO: Starting service Catalina
 Jan 27, 2012 2:34:36 PM org.apache.catalina.core.StandardEngine start
 INFO: Starting Servlet Engine: Apache Tomcat/6.0.29
 Jan 27, 2012 2:34:37 PM org.apache.catalina.core.StandardContext start
 SEVERE: Error listenerStart
 Jan 27, 2012 2:34:37 PM org.apache.catalina.core.StandardContext start
 SEVERE: Context [/bi] startup failed due to previous errors
 Jan 27, 2012 2:34:37 PM org.apache.catalina.startup.HostConfig 
 deployDescriptor
 INFO: Deploying configuration descriptor manager.xml
 Jan 27, 2012 2:34:37 PM org.apache.catalina.startup.HostConfig 
 deployDescriptor
 
 I managed to get it running in the past with 10.04, but not from
 trunk. The svn doesn't show any significant changes. Any help ?
 
 
 On Sun, Jan 15, 2012 at 7:46 AM, Mansour Al Akeel
 mansour.alak...@gmail.com wrote:
 Can you please provide details about how to generating the templates for
 tomcat7 ?
 I can see only tomcat6 and tomcat55.

 On Sun Jan 15,2012 09:32 am, Erwan de FERRIERES wrote:
 Le 14/01/2012 23:54, Mansour Al Akeel a ?crit :
 It has been a month, and no answer yet. Is there some missing
 information, that may help solving this issue. I remember it worked with
 ofbiz-10.04 . If running under tomcat for 11.04 or trunk-SVN, is no
 longer supported then please let me know.




 On Thu Dec 15,2011 03:53 pm, Mansour Al Akeel wrote:
 I am trying to running ofbiz under a stanalone tomcat as per
 https://cwiki.apache.org/confluence/display/OFBTECH/Tomcat

 I am unable to run it as described. I am using the same version of
 tomcat in the document: 6.0.16


 Hi Mansour,

 OFBiz trunk is now using tomcat 7. If you still want to use a tomcat 6,
 you may take a revision before 1203470
 http://svn.apache.org/viewvc?rev=1203470view=rev (november 18th) from
 the OFBiz svn.

 Cheers,

 --
 Erwan de FERRIERES
 www.nereide.biz
 


Re: version 11.4 or 10.4 most stable?

2012-01-28 Thread BJ Freeman
My two cents :
when you change any code you have reduced the reliability of code that
depends on that code.
The More code that is changed, the less the reliability.
Till rigorous testing of all code that depends on the code changed,, one
can not say it is dependable.
Though code is Frozen in releases as candidates, no one demonstrated
this level of testing.
With that said, what will Be, 11.04. has had not only code but structure
changes, compared to 10.4.

It has been said that those that have an interest and are first to add
code set the tone of what they put in, wheather any code review has been
done.
I can point out many instances where code does not follow good coding
practices and/or follow the design of ofbiz.
And yes I have attempted t point this out and it has fell on deaf ears.

So yes those that want stability and dependability must take
responsibility to do there own testing.



Ruth Hoffman sent the following on 1/28/2012 5:41 AM:
 Jacopo:
 Thanks for the clarification.
 
 Would it also be fair to say that there is no Apache OFBiz project
 official upgrade path or document?
 
 Each OFBiz user is on their own when it comes to upgrade policies and
 procedures?
 
 Best Regards,
 Ruth
 
 On 1/27/12 2:49 PM, Info Olagos wrote:
 Jacopo,

 So what is then the most intelligent to upgrade from version 09.04 ?

 To release 10.04 or to the trunk?

 Heidi

 2012/1/27 Jacopo Cappellatojacopo.cappell...@hotwaxmedia.com:
 Just to clarify: Hans is expressing a personal opinion and/or
 conveying the marketing message of his own company; in this context
 us means Hans' company, and it is not associated to the Apache
 OFBiz project and community.

 10.04 is the latest official release with features freezed on April 2010
 09.04.01 is an official release with features freezed on April 2009

 Soon we should release the first official release on the 11.04 series
 (with feature freezed on April 2011)

 Kind regards,

 Jacopo

 On Jan 27, 2012, at 1:04 PM, Hans Bakker wrote:

 Heidi,

 Yes, AND upgrading much easier...we do it at least every 3 months in
 less than a couple of hours of work.
 If you have a support contract with us, we even guarantee that a
 blocking error is solved within hours.

 Or of course try our SAAS solution at http://ofbizsaas.com (also
 runs on trunk)

 Regards,
 Hans

 On 01/27/2012 07:00 PM, Info Olagos wrote:
 ok thank you.
 So not version 10.4 nor 11.4 but the trunk?

 Regards,
 Heidi

 2012/1/27, Hans Bakkermailingl...@antwebsystems.com:
 Hi Heidi,

 I think in the OFBiz case, 'trunk' is just as stable as the other
 versionsand with a lot of extra functionality

 we use trunk for almost all customers.

 Regards, Hans
 -
 OFBiz software as a service? try the demo version:
 http://ofbizsaas.com

 On 01/27/2012 05:48 PM, Info Olagos wrote:
 Hello,

 Can anyone inform me about the latest versions of Ofbiz.

 Is version 11.4 or rather 10.4 the most stable ?

 Regards,
 Heidi



 


Re: Question on services methods

2012-01-20 Thread BJ Freeman
short answer the origial design was to have individual routines so it
could be reused.
That got lost with new committers.
I dont use the SVN since I have re-factored ofbiz.

Foo Shyn Chung sent the following on 1/18/2012 8:49 PM:
 Hi all,
 
 This may sounds stupid, please spare me =p.
 
 I've noticed that methods in the Services class are written as static and
 i'd come across a discussion thread that talked about why it is so.
 (http://osdir.com/ml/user.ofbiz.apache.org/2009-09/msg00284.html)
 
 However, there are times that a method in the Service class is either too
 long or there are common codes between 2 methods that i would like to
 refactor them into using a new method. Since all the methods need to be
 static, so the new smaller methods that i'm creating will be in static as
 well. I wonder whether this would cause the thread-safe issue concerning
 the static state of the methods?
 
 Thanx
 FooShyn
 


Re: OfBiz with RFID and SAP

2012-01-20 Thread BJ Freeman
short answer is yes you can add RFID and integrate SAP
plan on about a man month of effort to accomplish.

balakrishna_r sent the following on 1/19/2012 2:47
 Hi,
 
 We have been exploring OfBiz from a couple of months, and getting to know so
 many interesting things ofbiz offers out of the box.
 
 Would like to know on how OfBiz supports RFID implementation (as in
 warehouses for stock movements) and the integration with SAP to
 import/export data.
 
 Please throw some light on the above features if some one has explored
 earlier.
 
 
 Thanks,
 Balakrishna
 
 
 --
 View this message in context: 
 http://ofbiz.135035.n4.nabble.com/OfBiz-with-RFID-and-SAP-tp4309702p4309702.html
 Sent from the OFBiz - User mailing list archive at Nabble.com.
 


Re: Question on payment capture

2012-01-20 Thread BJ Freeman
What SVN version is you check out?

Sandeep A sent the following on 1/18/2012 10:46 AM:
 Hi,
 
 I had a question regarding the capture process in the ofbiz...
 
 
 Below is the code in
 org.ofbiz.accounting.payment.PaymentGatewayServices.java
 OrderReadHelper orh = new OrderReadHelper(orderHeader);
  BigDecimal orderGrandTotal = orh.getOrderGrandTotal();
  orderGrandTotal = orderGrandTotal.setScale(decimals, rounding);
 
 //Here  getting total payments from payment entity
 ** BigDecimal totalPayments =
 PaymentWorker.getPaymentsTotal(orh.getOrderPayments()); **//this is where
 my question is
  totalPayments = totalPayments.setScale(decimals, rounding);
  BigDecimal remainingTotalBd = orderGrandTotal.subtract(totalPayments);
 
  // The amount to capture cannot be greater than the remaining total
  amountToCapture = amountToCapture.min(remainingTotalBd);
 
 What i understood from the line
 PaymentWorker.getPaymentsTotal(orh.getOrderPayments());
 is we get all payments (i.e received or sent) and add their amounts.
 
 Now my question is why are we not distinguishing between the status of
 Payment while adding them up?
 This question comes from
 Assume we had order with $100 captured and $10 refunded... total payments
 results in $110,
 but the order grand total would reflect as $90.
 
 Now if we perform a capture of $19 again i.e order total would be $90 +
 $19=$109
 the above mentioned condition was capturing $1, whereas it should have
 captured $19
 
 Any ideas of why this is being done?
 
 


Re: How to handle Returns from the Post Office

2012-01-11 Thread BJ Freeman
When a return happens a route segment is created to show that it came
back in the same shipping stream. The added code then puts it in a
holding areas in the facility for future deposition. Once the CRM is
completed, then the shipment is re-stocked an the refund it issued, or a
new shipping segments are generated with a re-ship status.
so the order has the history of the shipping history in tack.
Yes the code is not in the SVN or OTTB.





Craig Ambrose sent the following on 1/10/2012 4:18 PM:
 BJ,
 
 We have a similar scenario on our hands. We send out our shipment using UPS
 and it is not received by the customer for any number of reasons and the
 package is returned to our facility. We typically do as you suggest and it
 enters a CRM workflow and in most cases we want to re-ship the order. I
 don't want to handle it as a return with the stock going back into inventory
 in case the inventory gets reserved by a subsequent order.
 
 In any case, what do you mean by re-ship? Will this result in a new
 Shipment entity and all of it's relationships? Or will it just be a new
 ShipmentRouteSegment or some other addendum.
 
 I've been poking around the Facility and Order applications and haven't seen
 anything that looks like a re-ship operation. I'd like to maintain the
 history of this order in terms of the Shipment being sent and the UPS
 tracking ID that was generated and used and that subsequently it left the
 facility again with a new UPS tracking ID.
 
 Thanks for the insights.
 
 -craig
 
 --
 View this message in context: 
 http://ofbiz.135035.n4.nabble.com/How-to-handle-Returns-from-the-Post-Office-tp1677185p4283972.html
 Sent from the OFBiz - User mailing list archive at Nabble.com.
 


Restraunt feature with ofbiz.

2012-01-08 Thread BJ Freeman
using 10.2 tablets, customer can order and pay for meals.
with the GPS built in position in the restaurant can be determine and
translated to table an place at the table.
the staff have to be trained to put the tables in preconfigured places
and ways.
the payment allows for spiting the bill and manually Entering the CC
info for each that is paying or use the attached card swipe.


Re: Restaurant feature with ofbiz.

2012-01-08 Thread BJ Freeman
how do you explain surveying with gps?

David Legg sent the following on 1/8/2012 9:21 AM:
 Nice idea but I don't think this would work very well unless you were
 eating alfresco!
 
 GPS signals don't penetrate buildings very well and triangulation using
 cell tower signals would mean you would have to place each table several
 hundred yards apart!
 
 David Legg
 
 On 08/01/12 16:34, BJ Freeman wrote:
 using 10.2 tablets, customer can order and pay for meals.
 with the GPS built in position in the restaurant can be determine and
 translated to table an place at the table.
 the staff have to be trained to put the tables in preconfigured places
 and ways.
 the payment allows for spiting the bill and manually Entering the CC
 info for each that is paying or use the attached card swipe.


 
 


Re: Restaurant feature with ofbiz.

2012-01-08 Thread BJ Freeman
GPS Differential Beacon Signal (DGPS) receivers deliver positions
accurate to within 10 meters, and potentially to 1 meter.
these rebroacast in a building gives fairly accurate measurements.

David Legg sent the following on 1/8/2012 10:42 AM:
 When I do surveys for OpenStreetmap.org I take my GPS unit outside and
 traverse the street/path/road etc in both directions to get a good
 average set of nodes.  On a good day here in the UK I can get the
 accuracy down to a few feet using a Garmin eTrex Vista HCx.  But that's
 only after letting the unit track all available satellites for a minute
 or two.
 
 Getting sufficient signal inside a multi-story building is pretty
 difficult.
 
 I've started testing a Samsung Galaxy Tablet and using Google maps to
 show where you are causes your position to jump about as the unit flips
 between the different methods of locating your position.
 
 
 On 08/01/12 17:57, BJ Freeman wrote:
 how do you explain surveying with gps?

 David Legg sent the following on 1/8/2012 9:21 AM:
 Nice idea but I don't think this would work very well unless you were
 eating alfresco!

 GPS signals don't penetrate buildings very well and triangulation using
 cell tower signals would mean you would have to place each table several
 hundred yards apart!

 David Legg

 On 08/01/12 16:34, BJ Freeman wrote:
 using 10.2 tablets, customer can order and pay for meals.
 with the GPS built in position in the restaurant can be determine and
 translated to table an place at the table.
 the staff have to be trained to put the tables in preconfigured places
 and ways.
 the payment allows for spiting the bill and manually Entering the CC
 info for each that is paying or use the attached card swipe.




 
 


Re: Restaurant feature with ofbiz.

2012-01-08 Thread BJ Freeman
I have a device that plugs into the 10.2 mPCIe
the 10.2 is custom.

shi.jinghai sent the following on 1/8/2012 1:50 PM:
 You have to use a Blue Tooth solution inside a building to get accurate 
 position.
 
 
 On 2012-1-9, at 上午3:05, BJ Freeman wrote:
 
 GPS Differential Beacon Signal (DGPS) receivers deliver positions
 accurate to within 10 meters, and potentially to 1 meter.
 these rebroacast in a building gives fairly accurate measurements.

 David Legg sent the following on 1/8/2012 10:42 AM:
 When I do surveys for OpenStreetmap.org I take my GPS unit outside and
 traverse the street/path/road etc in both directions to get a good
 average set of nodes.  On a good day here in the UK I can get the
 accuracy down to a few feet using a Garmin eTrex Vista HCx.  But that's
 only after letting the unit track all available satellites for a minute
 or two.

 Getting sufficient signal inside a multi-story building is pretty
 difficult.

 I've started testing a Samsung Galaxy Tablet and using Google maps to
 show where you are causes your position to jump about as the unit flips
 between the different methods of locating your position.


 On 08/01/12 17:57, BJ Freeman wrote:
 how do you explain surveying with gps?

 David Legg sent the following on 1/8/2012 9:21 AM:
 Nice idea but I don't think this would work very well unless you were
 eating alfresco!

 GPS signals don't penetrate buildings very well and triangulation using
 cell tower signals would mean you would have to place each table several
 hundred yards apart!

 David Legg

 On 08/01/12 16:34, BJ Freeman wrote:
 using 10.2 tablets, customer can order and pay for meals.
 with the GPS built in position in the restaurant can be determine and
 translated to table an place at the table.
 the staff have to be trained to put the tables in preconfigured places
 and ways.
 the payment allows for spiting the bill and manually Entering the CC
 info for each that is paying or use the attached card swipe.







 
 


Re: who is going to land Best-Buy

2011-12-23 Thread BJ Freeman
not at the momement I have my and full. heard on the news.
figure anyone interested would do the research. 
http://online.wsj.com/article/SB10001424052970204464404577115490099023190.html

Sascha Rodekamp sent the following on 12/23/2011 12:35 AM:
 Interesting, do you have any details?
 
 Am 22.12.2011 um 22:43 schrieb BJ Freeman bjf...@free-man.net:
 
 Best-Buy over sold between online and B/M.
 perfect time to pitch them for ofbiz.
 


who is going to land Best-Buy

2011-12-22 Thread BJ Freeman
Best-Buy over sold between online and B/M.
perfect time to pitch them for ofbiz.


Re: vendors and suppliers

2011-12-10 Thread BJ Freeman
I remember my first confusion when I first started.
I agree that from a ofbiz data model book that Vendor is selling what
the ofbiz company produces.
and that Supplier has been defined as those that sell to the ofbiz company.

However in the manufacturing world I grew up a Vendor was someone that
warehoused someone else products top be sold to the ofbiz company and a
supplier was a company the made a product to sell to the ofbiz company.

To remedy this I made a different set of Widget/controller/code that
deal from a user perspective. I do all the interpretation of the OOTB
and display it the way the ofbiz company will use them.

I have had to do this for each industry/ofbiz company customer I have had.

David E Jones sent the following on 12/9/2011 6:31 PM:
 
 
 Ruth Hoffman wrote:
 Hi David:
 Nice to hear from you again. Thanks for your input. I have some
 responses. Please see below:

 On 12/9/11 4:44 PM, David E Jones wrote:

 Ruth Hoffman wrote:
 2) If you look at how vendor/supplier is used in some of the OFBiz
 applications, you might observe that:

 A vendor supplies goods or services to the Company of record for the
 OFBiz instance. Those goods or services may be raw materials for
 manufacturing, products for resale on the ecommerce site or computers to
 run your business. When a vendor (with a record in the VENDOR table)
 supplies you with something, they are acting in a role called a
 SUPPLIER.

 So, in the OFBiz world, my interpretation is: A vendor is a supplier. It
 is as simple as that. Anything more is making it too complicated :-)

 Anyone care to comment on my interpretation?
 Actually a Supplier is a Party the sells things to the company running
 OFBiz, hence the SupplierProduct entity. In other words, a purchase
 order is sent to a Supplier.
 A vendor is also a Party that could sell things to the company running
 OFBiz. Just depends on how you set up your accounting system and how you
 name your accounts.
 The term vendor doesn't mean much in OFBiz, but has been used for any
 Party that sells something. For example, if you have multiple stores in
 your OFBiz instance you may have a vendor per store. You could also have
 multiple vendors selling through a single store.
 Seems to me if the Party sells something and the term vendor is used to
 express that activity, then the term DOES have lots of meaning. OFBiz
 e-commerce, after all, is all about selling products.

 That said, there is also an entity named VendorProduct that when coupled
 with the Vendor entity may be used in the same way as the
 SupplierProduct entity. Perhaps I should have said a vendor is a type of
 supplier? Unfortunately (or maybe fortuneately - who is to say?), the
 data model does not enforce this relationship.
 
 Okay, so did you ask to get an answer, or did you ask to start a
 discussion? It's not like this is open to interpretation, this was
 discussed and decided on a long time ago.
 
 A supplier sells stuff to the company running OFBiz. A vendor sells
 stuff to the customers of the company, and a vendor could be an
 affiliate or consignment seller sort of thing.
 
 The SupplierProduct and VendorProduct entities are VERY different and
 meant to model these 2 totally different things. I'm sorry, but looking
 at them again to make sure, I'm not even sure how they could possibly be
 confused.
 
 They are not really equivalent terms.
 Maybe, maybe not, but I would argue, based on the data model, that they
 ARE equivalent terms when a vendor acts in the role of supplier.
 Regardless, there is really no need to make this more confusing or
 complex than it already is.
 
 There is a clear distinction here. It's not making things complex, it's
 two different concepts. It's not one concept, that would be
 over-simplifying it. It is two separate, distinct concepts that need
 different words, and have them.
 
 Damn, with all the mis-information buzzing around these lists no wonder
 people have so many issues with OFBiz. Of course, OFBiz itself is
 admittedly complex and often unclear or just plain buggy and
 inconsistent, so this is understandable.
 
 I don't know exactly what we can do about all of this, but being more
 careful and detailed might be a good start for all of us.
 
 -David
 


Re: HelpMePlease - Problem installing OfBiz

2011-12-06 Thread BJ Freeman
thanks for the heads up that ofbiz will need work on java 7
right now ofbiz works on java 6.
you can have multiple Java SDK installed in different folders.
then point ofbiz to the Java 6 SDK.

marco bocca sent the following on 12/6/2011 6:16 AM:
 Hi,
 
 I'm trying to install your product in a WINSERVER2003 with jdk1.7.0_01.
 
 The OFBIZ version is apache-ofbiz-10.04
 
 When I'm compiling the project with ANT run-install run there is a error 
 message
 
 classes:
   [javac16] Compiling 13 source files to 
 C:\_portable\PortableApps\apache-ofbiz-10.04\framework\security\build\classes
   [javac16] warning: [options] bootstrap class path not set in conjunction 
 with -source 1.6
   [javac16] 
 C:\_portable\PortableApps\apache-ofbiz-10.04\framework\security\src\org\ofbiz\security\OFBizSecurity.java:52:
  error: invalid inferred types for V; inferred type does not conform to 
 declared bound(s)
   [javac16] protected static final MapString, MapString, String 
 simpleRoleEntity = UtilMisc.toMap(
   [javac16]   
^
   [javac16] inferred: MapString,Object
   [javac16] bound(s): MapString,String
   [javac16]   where V,V1,V2,V3 are type-variables:
   [javac16] V extends Object declared in method 
 V,V1,V2,V3toMap(String,V1,String,V2,String,V3)
   [javac16] V1 extends V declared in method 
 V,V1,V2,V3toMap(String,V1,String,V2,String,V3)
   [javac16] V2 extends V declared in method 
 V,V1,V2,V3toMap(String,V1,String,V2,String,V3)
   [javac16] V3 extends V declared in method 
 V,V1,V2,V3toMap(String,V1,String,V2,String,V3)
   [javac16] 1 error
   [javac16] 1 warning
 
 Could you help me, please ?
 
 I have tried to reinstall ALL piece but doesn't work ?
 
 Marco


Re: APACHE_OFBIZ_HTML

2011-12-05 Thread BJ Freeman
or use this one that has additions
http://ofbiz.businessesnetwork.com/cmssite/cms/APACHE_OFBIZ_HTM

Jacques Le Roux sent the following on 12/5/2011 6:14 AM:
 Hi,
 
 Since this morning, it seems someone is much using the online help on
 demo trunk server. This is maybe why the server is so slow.
 If you do so, please rather use the online help locally, on your own
 machine...
 
 Thanks
 
 Jacques
 


Re: Tax calculation for all order adjustments

2011-12-05 Thread BJ Freeman
the Tax Authority was implemented and VAT was added later.
Thanks for your links.
Since you have a thread on the Dev list, lets keep it on the dev list
for continuity.

biletnikov sent the following on 12/5/2011 12:38 AM:
 Thank you for your reply BJ Freeman.
 I am not aware of USA Tax Authority, just know some basic principles. VAT
 system is used by many countries. Of course, gross profit is very important
 for any company and it is used in tax computation for local Tax authority.
 Some VAT info you may read here:
 http://en.wikipedia.org/wiki/Value_added_tax
 http://en.wikipedia.org/wiki/Value_added_tax 
 The main points for VAT is:
 VAT amount depends on a country
 Some products, materials or services can have different VAT amount per
 country (but that is more exceptional case, when a government wishes to
 reduce taxes for some kinds of business...)
 VAT is applied for product, material or service
 VAT should be specified in each order and invoice (for some countries, it is
 mandatory, but for another it is a best practice)
 
From these points, it is interesting to know is VAT the same as Sales
 tax , I saw many discussions about this in the mail list, and as I see VAT
 is the same as Sales tax. Ok.
 
 According to VAT, all order items and invoice items must have VAT. In OFBiz,
 adjustments are additional things and services! *Shipping charge* is the
 service adjustment. Fortunately, OFBiz can tax it.
 
 Conclusion, 
 for VAT users it is important to have the correct orders and invoices. They
 are correct, when they have all necessary items and adjustments, plus tax
 (VAT). Currently, the orders and invoices are not correct if a company use
 additional adjustments (not shipping and promotion), because they can not be
 taxed. To fix it,  the company must edit each order manually. When you add
 additional tax for some adjustments, OFBiz makes tax recalculation according
 to its internal tax model and compensate additional tax by tax deduction.
 This tax deduction must be removed manually. As result ,we have manual,
 unhandy and error risky tax calculation. Each order must be reworked.
 
 
 -
 Kind regards,
 Sergei
 --
 View this message in context: 
 http://ofbiz.135035.n4.nabble.com/Tax-calculation-for-all-order-adjustments-tp4119597p4159691.html
 Sent from the OFBiz - User mailing list archive at Nabble.com.
 


Re: Trunk demo error

2011-12-05 Thread BJ Freeman
I check using tracert. Use tracetroute.org to test from different places.
 corv-car1-gw.nero.net [207.98.64.177]
 ofbiz-vm2.apache.org [140.211.11.51]
showed high time to live
above 200 ms


Jacques Le Roux sent the following on 12/5/2011 2:21 PM:
 Currently trunk is slow, and I'm not sure why. We will see tomorrow
 morning now (it's already late here)
 But it builds since I systematically revert r1202849  from where the
 build problem comes. You may try that if you get the same, I thought you
 were aware
 
 Jacques
 
 From: Tolu Williams tolu.willi...@cultureshockmedia.com
 Does anyone here have any clue why the demo server build would be
 failing?

 -- 
 View this message in context:
 http://ofbiz.135035.n4.nabble.com/Trunk-demo-error-tp4079709p4162281.html
 Sent from the OFBiz - User mailing list archive at Nabble.com. 
 


Re: APACHE_OFBIZ_HTML

2011-12-05 Thread BJ Freeman
I have been adding a rev history in the ones I have added.
the addition you will not find in the svn.

Wai sent the following on 12/5/2011 11:10 AM:
 Hello BJ,
 
 Could you tell me when
 http://ofbiz.businessesnetwork.com/cmssite/cms/APACHE_OFBIZ_HTML was last
 updated?  Is there a way to find this information?
 
 Thanks
 
 --
 View this message in context: 
 http://ofbiz.135035.n4.nabble.com/APACHE-OFBIZ-HTML-tp4160628p4161769.html
 Sent from the OFBiz - User mailing list archive at Nabble.com.
 


Re: Tax calculation for all order adjustments

2011-12-04 Thread BJ Freeman
I am not familiar with VAT so I can not comment on the best way to
approach this for VAT.
For USA our Tax Authority is based on Government (IRS) which I guess is
similar to VAT But not on Items but gross profit at the end of the
fiscal year. In manufacturing you can not charge off the deduction of
the piece manufactured till the piece is sold. Under this scenario the
calculations are done during the manufacturing process and is additive,
then assigned to IRIS ledger..

The Tax authority for Sales is based on Geo with separate Tax
authorities. Like State, County, city. These are compounded So
Adjustments are complex in computations.

 I bring this up so that the model that is used will accommodate all Tax
Authority scenarios.

This was not a simple effort when we did it so I don't think a
discussion would be simple.
Maybe a Wiki page would be appropriate to come up with a viable design.



biletnikov sent the following on 12/4/2011 9:17 AM:
 In my opinion, TaxAuthorityRateAdjustment can not relate to
 TaxAuthorityRateProduct, because these entities are responsible for
 different taxing scopes :  Product and  Adjustment.
 
 *TaxAuthorityRateAdjustment*  has relation to :
 
- 
 TAXAUTHORITYhttps://demo-trunk.ofbiz.apache.org/webtools/control/FindGeneric?entityName=TaxAuthorityfind=trueVIEW_SIZE=50VIEW_INDEX=0
- 
 TAXAUTHORITYRATETYPEhttps://demo-trunk.ofbiz.apache.org/webtools/control/FindGeneric?entityName=TaxAuthorityRateTypefind=trueVIEW_SIZE=50VIEW_INDEX=0
- 
 PRODUCTSTOREhttps://demo-trunk.ofbiz.apache.org/webtools/control/FindGeneric?entityName=ProductStorefind=trueVIEW_SIZE=50VIEW_INDEX=0
 
 
 Product or adjustment can be items in each order and it is reasonable to
 have the ability for each item being taxed, as I said that is very actual
 for VAT style calculation.
 
 These TaxAuthorityRateAdjustment and TaxAuthorityRateProduct  will exist in
 parallel, but TaxAuthorityRateProduct  is oriented on product store and
 product categories,  but TaxAuthorityRateAdjustment operates with product
 store and adjustment types!
 
 The tax computation should be carried out in this order:
 
- Read the appropriate tax authority rates
- Calculate product taxes
- Calculate adjustment taxes
- Sum these adjustments
 
 
 On Sat, Dec 3, 2011 at 8:57 PM, BJ Freeman [via OFBiz] 
 ml-node+s135035n4154077...@n4.nabble.com wrote:
 
 how does this relate to

 https://demo-trunk.ofbiz.apache.org/webtools/control/ViewRelations?entityName=TaxAuthorityRateProduct
 Order Adustements
 an
 return Adjustments

 biletnikov sent the following on 12/3/2011 1:26 AM:

 In general, we manage tax calculation for products and adjustments (only
 for
 shipping and promotions).
 As we have TaxAuthorityRateProduct in OFBiz to manage the taxing of
 products, so why not to have the same system for adjustments?
 I propose the solution to have the TaxAuthorityRateAdjustment entity,
 who is
 related in similar order to TaxAuthority.
 TaxAuthorityRateAdjustment will have the following fields:

 *Tax type*   (Sales Tax, etc)
 *Store ID*
 *Catetgory*  (empty category means all categories)
 Title Transfer   ???  (I do not know, what can you suggest?)
 Min Item Pirce  ??? (I do not know, what can you suggest?)
 Min Purchase Price   (I do not know, what can you suggest?)
 *Tax Percentage *
 *From Date *
 *Thru Date*
 *Description*

 The settings will be placed in the separate tab near to Product rates
 (Tax
 Authority settings).
 The UI is very similar!

 RE: TaxAuthorityRateAdjustment
 we should retire
 *Tax Shipping*
 *Tax Promotions*
 because they look more like a hack.


 The tax calculation service must be reworked,

 service name=calcTax engine=java
 location=org.ofbiz.accounting.tax.TaxAuthorityServices
 invoke=rateProductTaxCalc
descriptionTax Authority Rate Product Calc
 Service/description
implements service=calcTaxInterface/
 /service

service name=calcTaxInterface engine=interface location=
 invoke=
descriptionTax Calc Service Interface/description
attribute name=productStoreId type=String mode=IN
 optional=true/attribute
attribute name=facilityId type=String mode=IN
 optional=true/attribute
attribute name=payToPartyId type=String mode=IN
 optional=true/
attribute name=billToPartyId type=String mode=IN
 optional=true/attribute
attribute name=itemProductList type=java.util.List mode=IN
 optional=false/attribute
attribute name=itemAmountList type=java.util.List mode=IN
 optional=false/attribute
attribute name=itemPriceList type=java.util.List mode=IN
 optional=false/attribute
attribute name=itemQuantityList type=java.util.List
 mode=IN
 optional=true/attribute
attribute name=itemShippingList type=java.util.List
 mode=IN
 optional=true/attribute
 *   attribute name=orderShippingAmount type=BigDecimal
 mode=IN
 optional=true/
attribute name=orderPromotionsAmount type=BigDecimal
 mode=IN
 optional

Re: Tax calculation for all order adjustments

2011-12-03 Thread BJ Freeman
how does this relate to
https://demo-trunk.ofbiz.apache.org/webtools/control/ViewRelations?entityName=TaxAuthorityRateProduct
Order Adustements
an
return Adjustments

biletnikov sent the following on 12/3/2011 1:26 AM:
 In general, we manage tax calculation for products and adjustments (only for
 shipping and promotions).
 As we have TaxAuthorityRateProduct in OFBiz to manage the taxing of
 products, so why not to have the same system for adjustments?
 I propose the solution to have the TaxAuthorityRateAdjustment entity, who is
 related in similar order to TaxAuthority.
 TaxAuthorityRateAdjustment will have the following fields:
 
 *Tax type*   (Sales Tax, etc)
 *Store ID*
 *Catetgory*  (empty category means all categories)
 Title Transfer   ???  (I do not know, what can you suggest?)
 Min Item Pirce  ??? (I do not know, what can you suggest?)
 Min Purchase Price   (I do not know, what can you suggest?)
 *Tax Percentage *
 *From Date *
 *Thru Date*
 *Description*
 
 The settings will be placed in the separate tab near to Product rates (Tax
 Authority settings).
 The UI is very similar!
 
 RE: TaxAuthorityRateAdjustment 
 we should retire 
 *Tax Shipping*
 *Tax Promotions*
 because they look more like a hack.
 
 
 The tax calculation service must be reworked,
 
 service name=calcTax engine=java
 location=org.ofbiz.accounting.tax.TaxAuthorityServices
 invoke=rateProductTaxCalc
descriptionTax Authority Rate Product Calc Service/description
implements service=calcTaxInterface/
 /service
 
service name=calcTaxInterface engine=interface location=
 invoke=
descriptionTax Calc Service Interface/description
attribute name=productStoreId type=String mode=IN
 optional=true/attribute
attribute name=facilityId type=String mode=IN
 optional=true/attribute
attribute name=payToPartyId type=String mode=IN
 optional=true/
attribute name=billToPartyId type=String mode=IN
 optional=true/attribute
attribute name=itemProductList type=java.util.List mode=IN
 optional=false/attribute
attribute name=itemAmountList type=java.util.List mode=IN
 optional=false/attribute
attribute name=itemPriceList type=java.util.List mode=IN
 optional=false/attribute
attribute name=itemQuantityList type=java.util.List mode=IN
 optional=true/attribute
attribute name=itemShippingList type=java.util.List mode=IN
 optional=true/attribute
 *   attribute name=orderShippingAmount type=BigDecimal mode=IN
 optional=true/
attribute name=orderPromotionsAmount type=BigDecimal mode=IN
 optional=true/
 *   attribute name=shippingAddress
 type=org.ofbiz.entity.GenericValue mode=IN optional=true/
attribute name=orderAdjustments type=java.util.List mode=OUT
 optional=false/attribute
attribute name=itemAdjustments type=java.util.List mode=OUT
 optional=false/attribute
/service
 
 This interface must have /OrderAdjustment/ list as IN parameter. 
 
 That is my draft solution.
 What do you think about this?
 
 --
 View this message in context: 
 http://ofbiz.135035.n4.nabble.com/Tax-calculation-for-all-order-adjustments-tp4119597p4152813.html
 Sent from the OFBiz - User mailing list archive at Nabble.com.
 


Re: How to a list index to use as row numbering ofbiz form widget

2011-12-02 Thread BJ Freeman
having had to learn from the code with no documentation, I don't have
much sympathy for those that wanted it handed to them on a plate.
the answer I gave you answers a lot. Sorry you are unable to glean the
info you need.

Justin Robinson sent the following on 12/2/2011 1:21 AM:
 Thanks for your answer what you mentioned here can all be found in ofbiz
 resources online, even the Apache Ofbiz cookbook  Apache Ofbiz
 Developement book only give you the basics, but without a precise
 understanding of the inner workings, it's time consuming to reverse
 engineer this information out, in order to get fine grain control of ofbiz
 widgets.
 
 If you are able to give me some deeper insight into ofbiz widgets or a
 place to find that info.it'd be much appreciated.
 
 It seemed likely that row-actions would be executed before each row is
 rendered. (I mean what else could row-actions be)
 
 But the problem is that whenever it happens it must be before  itemIndex is
 set (though even that doesn't make complete sense, in view of the test
 results)
 
 Placing the groovy scriplet, see in the example, in row-actions results
 in each row having the same number.
 
 The following works, problem is this is not supposed to be a link.
 
  field name=fieldName title=headerName 
   hyperlink description=${groovy: ((viewIndex * viewSize) +
 (itemIndex + 1))} also-hidden=false link-type=anchor  target=/
  /field
 
 I also see you can't get a field name with an expression, this must be
 because of the data binding happening behind the scenes.
 
 field name=${groovy: ((viewIndex * viewSize) + (itemIndex + 1))}
 title=headerNamedisplay //field
 
 Any idea's what I'm missing?
 Thanks, for the help.
 
 
 On Fri, Dec 2, 2011 at 12:19 AM, BJ Freeman bjf...@free-man.net wrote:
 
 all the actions inside the “row-actions” section are executed before
 each row is rendered; this tag is similar to the “actions” tag
 the “service” action called within the row-actions, is a convenient way
 to invoke a service: the service name is specified with the
 “service-name” attribute, the “field-map” elements are used to pass the
 input parameters to the service, the “result-map” attribute defines the
 name of the output map
 look in
 specialpurpose\projectmgr\widget\forms\ProjectForms.xml#hoursNotYetBilled

row-actions
set field=showPosition1 value=${script:String
 prev=(String)previousItem.get(quot;workEffortIdquot;);return
 !(prev!=nullamp;amp;prev.equals(workEffortId));} type=Boolean/
/row-actions

 also look at framework\widget\dtd\widget-form.xsd

 Justin Robinson sent the following on 12/1/2011 9:46 AM:
 form name=listAssetItems type=list target= list-name=AssetItems
 title= paginate-target=createAsset paginate=true
 actions

 entity-one entity-name=AssetHeader
 value-field=assetHeader/
 set field=assetValueQty
 from-field=assetHeader.assetValueQty type=Integer/
 entity-condition entity-name=FindAssetItemsView
 list=AssetItems
 condition-list combine=or
 condition-expr field-name=orderId
 operator=equals from-field=parameters.orderId/
 condition-expr field-name=productFeatureId
 operator=equals from-field=nullField/
 /condition-list
 /entity-condition
 set field=rowSeqNum value=1 type=Integer/
 /actions
 row-actions
 set field=rowSeqNum from-field=rowSeqNum + 1/
 /row-actions


  etc.

 This restults in each row displaying the number '2' is there any way to
 ref
 the type=list index.

 Any clues would be helpful.



 
 
 


Re: How to a list index to use as row numbering ofbiz form widget

2011-12-01 Thread BJ Freeman
all the actions inside the “row-actions” section are executed before
each row is rendered; this tag is similar to the “actions” tag
the “service” action called within the row-actions, is a convenient way
to invoke a service: the service name is specified with the
“service-name” attribute, the “field-map” elements are used to pass the
input parameters to the service, the “result-map” attribute defines the
name of the output map
look in
specialpurpose\projectmgr\widget\forms\ProjectForms.xml#hoursNotYetBilled

row-actions
set field=showPosition1 value=${script:String
prev=(String)previousItem.get(quot;workEffortIdquot;);return
!(prev!=nullamp;amp;prev.equals(workEffortId));} type=Boolean/
/row-actions

also look at framework\widget\dtd\widget-form.xsd

Justin Robinson sent the following on 12/1/2011 9:46 AM:
 form name=listAssetItems type=list target= list-name=AssetItems
 title= paginate-target=createAsset paginate=true
 actions
 
 entity-one entity-name=AssetHeader
 value-field=assetHeader/
 set field=assetValueQty
 from-field=assetHeader.assetValueQty type=Integer/
 entity-condition entity-name=FindAssetItemsView
 list=AssetItems
 condition-list combine=or
 condition-expr field-name=orderId
 operator=equals from-field=parameters.orderId/
 condition-expr field-name=productFeatureId
 operator=equals from-field=nullField/
 /condition-list
 /entity-condition
 set field=rowSeqNum value=1 type=Integer/
 /actions
 row-actions
 set field=rowSeqNum from-field=rowSeqNum + 1/
 /row-actions
 
 
  etc.
 
 This restults in each row displaying the number '2' is there any way to ref
 the type=list index.
 
 Any clues would be helpful.
 
 


Re: Ofbiz Manufacturing @ ISA-88, ISA-95 and B2MML

2011-11-26 Thread BJ Freeman
I will let someone else respond to what ofbiz is now and the standards.
I have implemented three manufacturing solutions based on ofbiz and what
is in WIP.
Considerable Coding and Adding of entities to provide a solution were
required.
One was a software project with manufacturing of media, packaging, and a
public face to sell.

Second one deals with electronic, and mechanical production, and
assembly. There is a testing component. the Use of badges and been
adding Tablets, at workstations. the Goal was to pull all the
Manufacturing Knowledge into the system so it would not be last with
retirements.

The Third one is still in process. We are still designing to integrate
many system in many states to work under ofbiz. The requremts deal with
large bill of materials for both Engineering and Productions,
Manufacturing of many disipines, Like Casting, millng integration.
there are inpection process that could change the Production run.
Transporting of parts between plants, Tacking Parts that have been
farmed out to other companies.
The automation portion of ofbiz is use for management and status
reports. This is expected to be implement by 2013.

Pierre Smits sent the following on 11/26/2011 4:33 AM:
 Dear all,
 
 Currently I am involved in a EU program regarding Factories of the Future,
 and in particular the Dynamic Manufacturing Network. As such I am looking
 (on a side track) into the manufacturing functionalities of OFBiz. Part of
 the project I am involved in is defining blueprints related to ISA-88,
 ISA-99 and B2MML and I was wondering how OFBiz is stacking up against these
 standards.
 
 Maybe you have implemented OFbiz in a manufacturing environment or you are
 using OFBiz for manufacturing and you can share your insights regarding:
 
 
- How does OFBiz stack up visavis Manufacturing functionalities?
- How much does OFBiz comply with or adhere to standards like ISA-88 and
ISA-99?
- Is OFBiz compliant to B2MML?
 
 
 I am looking forward to read your comments/posts.
 
 With regards,
 
 Pierre
 


Re: OFBiz BIRT compatible report development toolchain

2011-11-26 Thread BJ Freeman
have you followed the example file.
in ofbiz you must call the file through the contoller view

Bruno Busco sent the following on 11/26/2011 5:34 AM:
 Hi,
 I am trying to write some OFBiz report using BIRT.
 I installed the INDINGO release of Eclipse and then the BIRT package.
 
 The version of the BIRT package I got is 3.7.1 but the rtpdesign files
 generated with this tool does not seem to be compatible with the BIRT
 engine that is embedded into OFBiz (version 2.6).
 
 I got this error when I simply open and save again one of the OFBiz OOTB
 provided .rptdesign files.
 
 --
 Nov 26, 2011 2:12:39 PM
 org.eclipse.birt.report.engine.api.impl.ReportEngineHelper
 getReportDesignHandle
 SEVERE: invalid design file stream
 --
 
 I tryed to install an older BIRT package into Eclipse INDINGO but the
 oldest available to install is version 3.7.0 whish I guess would give the
 same problem.
 
 Has anybody any advice to solve the problem?
 What is the OFBiz BIRT compatible report development toolchain ?
 
 Thank you,
 Bruno Busco
 


Re: Import addresses with special characters.

2011-11-25 Thread BJ Freeman
like ofbiz has escape of html, I suggest you have an escape method for
each language. if you key it off the Locale then it will import based on
the language selected for the sight.
Or make sure your DB can accept Unicode (16 bit)

rohit sent the following on 11/25/2011 4:55 AM:
 hi,
 
 we are trying to import addresses from a tab-delimited file. The addresses
 in the file are in local languages such as German or Japanese, which contain
 special characters.
 
 Though ofbiz supports multiple languages, i am not sure how to import them
 into the database.
 
 I will appreciate if anyone can help.
 
 Thanks,
 
 Rohit
 
 
 -
 saanjhi.com 
 --
 View this message in context: 
 http://ofbiz.135035.n4.nabble.com/Import-addresses-with-special-characters-tp4107252p4107252.html
 Sent from the OFBiz - User mailing list archive at Nabble.com.
 


Re: Import addresses with special characters.

2011-11-25 Thread BJ Freeman
http://www.postgresql.org/docs/8.2/static/multibyte.html

Mike sent the following on 11/25/2011 10:09 AM:
 Your database must already be set to UTF-8.
 
 If you are using postgres, you can test this by:
 
 postgres=#  \c ofbiz;
 psql (8.4.7)
 You are now connected to database ofbiz.
 ofbiz=# \l
List of databases
 Name |  Owner   | Encoding |  Collation  |Ctype|
 Access privileges
 -+--+--+-+-+---
  ofbiz   | ofbiz| UTF8 | en_US.UTF-8 | en_US.UTF-8 |
 
 If you are using mysql, and can test this by:
 
 mysql SHOW CREATE DATABASE ofbiz;
 +--+--+
 | Database | Create Database  
 |
 +--+--+
 | ofbiz| CREATE DATABASE `ofbiz` /*!40100 DEFAULT CHARACTER SET utf8 */ |
 +--+--+
 
 Also, check a REAL table as well, like this:
 
 mysql SHOW CREATE TABLE ZIP_SALES_RULE_LOOKUP;
 
 And look for DEFAULT CHARSET=utf8
 
 However, I bet it ISN'T because the default that ofbiz sets in
 framework/entity/config/entityengine.xml for mysql is:
 character-set=latin1
 collate=latin1_general_cs
 
 And to support UTF8 the mysql section needs to be set to:
 character-set=utf8
 collate=utf8_general_ci
 
 jdbc-uri=jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true;characterEncoding=UTF-8
 
 If you are already using this mysql DB for production, this could be
 VERY tricky.  Basically, you have to convert the database to utf8,
 which isn't easy and has risk.  Backups are critical.
 
 Here is a good reference:
 
 http://en.gentoo-wiki.com/wiki/TIP_Convert_latin1_to_UTF-8_in_MySQL
 
 After conversion change framework/entity/config/entityengine.xml and
 test things.
 
 Also, don't forget your terminal needs also to be set to UTF8.  I use
 putty, and this is set under:
 
 Window - Translation - UTF-8
 
 Try first on a test system [grin].  Proceed with caution please.
 
 
 On Fri, Nov 25, 2011 at 4:55 AM, rohit rohitksur...@yahoo.com wrote:
 hi,

 we are trying to import addresses from a tab-delimited file. The addresses
 in the file are in local languages such as German or Japanese, which contain
 special characters.

 Though ofbiz supports multiple languages, i am not sure how to import them
 into the database.

 I will appreciate if anyone can help.

 Thanks,

 Rohit


 -
 saanjhi.com
 --
 View this message in context: 
 http://ofbiz.135035.n4.nabble.com/Import-addresses-with-special-characters-tp4107252p4107252.html
 Sent from the OFBiz - User mailing list archive at Nabble.com.

 


Re: Ofbiz Application Need to Restart

2011-11-23 Thread BJ Freeman
explain your setup including you Start up memory

ofbiz prod sent the following on 11/23/2011 12:48 AM:
 We have created one web based ERP solution using Ofbiz. Problem is that we
 have to restart the application (apache-tomcat instance) every couple of
 hours otherwise website is not opening. There are no errors found in
 application as well as system log. Application is hosted on OpenSuse Linux
 on X-Series IBM box.
 
 Kindly suggest how to troubleshoot.
 


Re: Installation on CentOS 5.6 with PostgreSQL

2011-11-18 Thread BJ Freeman
I have found that Webmin covers all the FAQ and more if used properly.
I am using the Webmin Scripts to created the DB for Tenants.

Jacques Le Roux sent the following on 11/17/2011 11:14 PM:
 Not sure why this was missing on user ML(!?)
 https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-Howtousemodproxyajp
 
 
 Jacques
 
 - Original Message - From: Jacques Le Roux
 jacques.le.r...@les7arts.com
 To: user@ofbiz.apache.org
 Sent: Friday, November 18, 2011 7:07 AM
 Subject: Re: Installation on CentOS 5.6 with PostgreSQL
 
 
 https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-Howtousemodproxyajp


 Jacques

 From: BJ Freeman bjf...@free-man.net
 I have 5 instances using AJP with Apache httpd and Ofbiz core. No
 problem.
 and I have phpPqAdmin installed but don't use it.


 champagroup sent the following on 11/17/2011 9:54 AM:
 Thanks. I had already installed Webmin, though, and the PostgreSQL
 module.
 What I really wanted to use was the phpPgAdmin software. But, from
 what I
 understand, it requires Apache and we did not install Apache since
 OFBiz
 uses Tomcat. I was also told that ports could be a problem if we
 were to
 install Apache with OFBiz. AT that rate, it doesn't look like I'd be
 able to
 use phpPgAdmin.

 -- 
 View this message in context:
 http://ofbiz.135035.n4.nabble.com/Installation-on-CentOS-5-6-with-PostgreSQL-tp4024345p4080936.html

 Sent from the OFBiz - User mailing list archive at Nabble.com.


 


Re: Installation on CentOS 5.6 with PostgreSQL

2011-11-17 Thread BJ Freeman
I have 5 instances using AJP with Apache httpd and Ofbiz core. No problem.
and I have phpPqAdmin installed but don't use it.


champagroup sent the following on 11/17/2011 9:54 AM:
 Thanks. I had already installed Webmin, though, and the PostgreSQL module.
 What I really wanted to use was the phpPgAdmin software. But, from what I
 understand, it requires Apache and we did not install Apache since OFBiz
 uses Tomcat. I was also told that ports could be a problem if we were to
 install Apache with OFBiz. AT that rate, it doesn't look like I'd be able to
 use phpPgAdmin. 
 
 --
 View this message in context: 
 http://ofbiz.135035.n4.nabble.com/Installation-on-CentOS-5-6-with-PostgreSQL-tp4024345p4080936.html
 Sent from the OFBiz - User mailing list archive at Nabble.com.
 


Re: Installation on CentOS 5.6 with PostgreSQL

2011-11-16 Thread BJ Freeman
look at webmin it lets you deal with all this in a more uniform way.
http://www.how2centos.com/installing-webmin-on-centos-5-5-tutorial/

champagroup sent the following on 11/16/2011 8:24 AM:
 Well, I had just looked mine over and it's all en_US.UTF-8. So I should be in
 the clear.
 
 --
 View this message in context: 
 http://ofbiz.135035.n4.nabble.com/Installation-on-CentOS-5-6-with-PostgreSQL-tp4024345p4076918.html
 Sent from the OFBiz - User mailing list archive at Nabble.com.
 


Re: Barcode scanning in Management Apps more

2011-11-14 Thread BJ Freeman
if you use a barcode scanner that goes through the keyboard the only
code change is to set the field as defualt for cursor. The barcode
scanner can be programmed to send a CR which activated the look up.


Yoke Power sent the following on 11/14/2011 4:37 AM:
 Appreciate your detailed response Bilgin; I do understand Product
 lookup by ProductId is supported out of box in Ofbiz; however I'm
 looking forward to automate product look-up in the above mentioned
 screens using Barcode scanner i.e When I scan the product barcode the
 productId should automatically be keyed in the ProductId field; With
 further research; it appears there are a couple of options including
 - Integrate Barcode Applet with Ofbiz Managemant screens requires
 handful of code changes
 - Use Barcode scanner with keyboard simulation and keep the cursor on
 the ProductId field and scan the barcode; Scanner will display
 ProductId in the field no code changes required; as this depends on
 the hardware fearure
 Anyone has success or complaints with the above options or others?
 Appreciate your thoughts!
 
 - Sakthi
 
 On 11/13/11, Bilgin Ibryam bibr...@gmail.com wrote:
 Hi Sakthi,

 On Fri, Nov 11, 2011 at 1:06 PM, Yoke Power yokepo...@gmail.com wrote:
 Hi Ofbiz Users,

 Context: Has anyone done hands-free barcode scanning for ProductId
 in Management apps Order Manager, Catalog Manager?


 If I got it right, what you want is easily doable with a little bit of
 coding.

 GoodIdentification contains the mapping between barcode number and
 product Id. And Catalog Manager app already provides screens for
 managing product codes/Ids. Also the main (first) screen in catalog
 manager app has Find Product with ID Value field that uses the
 product Ids. I suppose you need something similar for the Order
 Manager app, where you can find products by its barcode and then
 create order.

 The only thing that have to be extended is to include also the
 GoodIdentification in the product search. For an example you can even
 use WebPos application, it does something similar.

 HTH
 Bilgin Ibryam



 Approach: I do understand the above is supported out of the box in
 POS; however I need the above support in Management Apps; I'm able to
 extract the text from the scanner, I need some pointers or some sample
 code for integrating them with the Management screens;

 Highly Appreciate any pointers on this;

 - Sakthi



 --
 Sent from my mobile device


 


Re: Error creating Product STore

2011-11-11 Thread BJ Freeman
do a google on
ofbiz GenericEntity:CarrierShipmentMethod
there was a email thread and jira back in aug and Sept of this year.


Jonas Colmsjo sent the following on 11/11/2011 6:57 AM:
 Hi,
 
 I just installed ofbiz and I'm trying to do the initial setup. I get an
 error when trying to create the Product Store (tab three in the Initial
 Setup):
 
 The Following Errors Occurred:
 
 Error: Error parsing entity xml file:
 org.ofbiz.entity.GenericEntityException: Error while inserting:
 [GenericEntity:CarrierShipmentMethod][createdStamp,2011-11-11
 15:50:17.968(java.sql.Timestamp)][createdTxStamp,2011-11-11
 15:50:17.866(java.sql.Timestamp)][lastUpdatedStamp,2011-11-11
 15:50:17.968(java.sql.Timestamp)][lastUpdatedTxStamp,2011-11-11
 15:50:17.866(java.sql.Timestamp)][partyId,1(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]
 (SQL Exception while executing the following:INSERT INTO
 OFBIZ.CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID,
 ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP,
 LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
 ?, ?, ?, ?, ?) (INSERT on table 'CARRIER_SHIPMENT_METHOD' caused a
 violation of foreign key constraint 'CARR_SHMETH_TYPE' for key
 (LOCAL_DELIVERY). The statement has been rolled back.))  calling service
 parseEntityXmlFile in importTempDataFile
 
 I've reinstalled the application but I'm getting the same error.
 
 I'm running OSX Lion.
 $ java -version
 java version 1.6.0_29
 Java(TM) SE Runtime Environment (build 1.6.0_29-b11-402-11M3527)
 Java HotSpot(TM) 64-Bit Server VM (build 20.4-b02-402, mixed mode)
 
 What am I doing wrong?
 
 /BR
 Jonas
 


Re: Ofbiz - Multi Tenant support

2011-11-04 Thread BJ Freeman
the only thing effected in tenant mode is the data.
the caveat to this is that the data hold information to content.
Like preferences, themes.

Sasi Paul (Director Engineering) sent the following on 11/4/2011 2:16 AM:
 Hi,
 I have configured Ofbiz in Multi-tenant mode.  Its working well with Tenant 
 ID directing to separate data sources.
 
 Just wanted to know if I change any screen, will it be tenant specific or 
 will it be visible for both tenants.
 
 Regards,
 Sasi
 
 Director of Engineering
 Cura Software Solutions
 
 
 


Re: Not committing transaction, status is No Transaction (6)

2011-11-02 Thread BJ Freeman
do a search in code for
TransactionUtil.begin
you will see many exammples.
also a fast way to get info is
google search preface by ofbiz
so
ofbiz transaction

Justin Robinson sent the following on 11/2/2011 8:23 AM:
 How the transactions work is a bit of a mystery to me.
 Can anyone give me a bit of background on what Not committing transaction,
 status is No Transaction (6) is or rather what conditions result it it.
 
 I have something like this
 TransactionUtil.begin()
 for(:){
 
 try/catch
 some db related code that may throw exceptions
 
 }
 TransactionUtil.commit()
 
 Any clues would be helpful, have often had this problem but have never
 gotten to the bottom of why it happens.
 


Re: access to different component requires login process

2011-10-26 Thread BJ Freeman
http://mail-archives.apache.org/mod_mbox/ofbiz-user/201007.mbox/%3caanlktilyhtxjy82f5wehz7rqqvohaz5himn7aveyi...@mail.gmail.com%3E

Bilgin Ibryam sent the following on 10/26/2011 9:29 AM:
 I see this question coming up regularly from time to time.
 Some times ago I explained why this behavior happens but cannot find
 my post right now.
 Also it should be fixed with OFBIZ-3862 long time ago, but there might
 be other corner cases that cause it.
 
 Basically what happened in the past was that every action that
 rendered a screen in the background (like an ajax call) invalidated
 externalLoginKey which is used to transfer the session between
 applications. And if you try to login to another application while the
 externalLoginKey is not valid, you get the login screen.
 
 If you can provide exact steps how to get, I'll take a look.
 
 Cheers,
 Bilgin
 
 On Wed, Oct 26, 2011 at 4:32 PM, Wai bzb.of...@gmail.com wrote:
 Hello All,

 Having logged in to use one ofbiz component, I have to perform another login
 process whenever I make use of another component.  I vaguely remember a
 posting that mentioned that this is the way ofbiz works.  Does anyone have
 any tips to allow a user to login once and allow the user to access other
 components (given that the user has permission to do so) without having to
 go through the login process again?

 Thanks.

 --
 View this message in context: 
 http://ofbiz.135035.n4.nabble.com/access-to-different-component-requires-login-process-tp3941033p3941033.html
 Sent from the OFBiz - User mailing list archive at Nabble.com.

 


Re: access to different component requires login process

2011-10-26 Thread BJ Freeman
you will see a externalLoginKey=EL32757843547
this is time sensitive but is the mechanism for going between application.
if your on a intranet not internet you lengthen the timeout.
also look up
xs:attribute name=target-type default=intra-app
read the widge-*.xsd for documentation.

BJ Freeman sent the following on 10/26/2011 1:21 PM:
 http://mail-archives.apache.org/mod_mbox/ofbiz-user/201007.mbox/%3caanlktilyhtxjy82f5wehz7rqqvohaz5himn7aveyi...@mail.gmail.com%3E
 
 Bilgin Ibryam sent the following on 10/26/2011 9:29 AM:
 I see this question coming up regularly from time to time.
 Some times ago I explained why this behavior happens but cannot find
 my post right now.
 Also it should be fixed with OFBIZ-3862 long time ago, but there might
 be other corner cases that cause it.

 Basically what happened in the past was that every action that
 rendered a screen in the background (like an ajax call) invalidated
 externalLoginKey which is used to transfer the session between
 applications. And if you try to login to another application while the
 externalLoginKey is not valid, you get the login screen.

 If you can provide exact steps how to get, I'll take a look.

 Cheers,
 Bilgin

 On Wed, Oct 26, 2011 at 4:32 PM, Wai bzb.of...@gmail.com wrote:
 Hello All,

 Having logged in to use one ofbiz component, I have to perform another login
 process whenever I make use of another component.  I vaguely remember a
 posting that mentioned that this is the way ofbiz works.  Does anyone have
 any tips to allow a user to login once and allow the user to access other
 components (given that the user has permission to do so) without having to
 go through the login process again?

 Thanks.

 --
 View this message in context: 
 http://ofbiz.135035.n4.nabble.com/access-to-different-component-requires-login-process-tp3941033p3941033.html
 Sent from the OFBiz - User mailing list archive at Nabble.com.


 


  1   2   3   4   5   6   7   8   9   10   >