Database description
Hi; Can any one tell how I can find the description of the database.. I wan to know the role of each table. With Regards, Manish.K www.cevalsoft.com Go Green Print only when necessary.
Re: problem Running with MS-SQL
Actually, I think I had a similar problem: http://www.nabble.com/Violation-of-PRIMARY-KEY-constraint-%27PK_SERVER_HIT%27.-Cannot-insert-duplicate-key-in-object-%27ofbiz.SERVER_HIT%27-tp23479493p23479493.html Weixue Zhang wrote: > > I am using ms sql server 2005 and this problem had bothered me for long > time. At last I found it was caused by a few unique indices of some tables > (You can find them by searching with "unique="true"" in files > entitymodel.xml). After I changed them into "unique=false", demo data > works fine. Can anybody explain why this problem doesn't exist with other > database servers, and why we need to set unique=true at some indices while > most others are unique=false? > -- View this message in context: http://www.nabble.com/problem-Running-with-MS-SQL-tp24895969p25019038.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: is compile and ofbiz restart still needed for java changes?
Hi Bob, The mocking code sounds great. Would you be happy to share? Bob Morley wrote: > > We typically execute Ofbiz from Eclipse and some people have reported that > the hot-swapping works fairly well. (Usually we do not run an ant build > until right before check-in and then just to ensure we are compiling and > avoiding classpath issues). > > The approach I often take is to write my unit test in conjunction with the > service implementation I am working on. I have added some mocking > capabilities in our Ofbiz installation, so I can avoid starting up the > container at all and still exercise all of the logic in the service > method. Result is usually a sub-second unit test. Naturally an > integration test would require container start-up and a reasonably heavy > penalty. > > Another approach others have used is to write the service method in groovy > and once working convert this into java. From memory there is really only > a single sample of a groovy implemented service, and when I went to do > there there was at least one bug I had to resolve. But this is a feasible > way and the groovy is quite a bit like java. :) > > - Bob > > > Ruth Hoffman-2 wrote: >> >> Hi Chris: >> I guess I'm just use to the inconvenience. :-( The other thing I do to >> try and minimize restart time is to comment out the components I might >> not be using. >> Ruth >> > > -- View this message in context: http://www.nabble.com/is-compile-and-ofbiz-restart-still-needed-for-java-changes--tp24971472p25019021.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: OFBiz-AliPay has been released
Hmm, I haven't reach the level to feel the tones in English. Thanks for your simple and clear guide! I like it. I'll try to learn how PayFlow Pro works in this way and do it the same way. Regards, Shi Jinghai 在 2009-08-17一的 11:41 -0600，Tim Ruppert写道： > I didn't mean to come on too strong Shi - and I've seen you around, so > I know you're working here - but know that most of the actual > implementations of the payment processors have small steps that bring > in the files that cannot be put back into OFBiz. So, if it's still a > possibility, what the community would ask you to do in order to be > able to commit it would be (and this is the same for PayFlow Pro as > well): > > 1. Make all of the code files in OFBiz Apache licensed > 2. Add an exclude in the accounting build file for Java files that are > dependent upon their libs > -- If necessary > 3. Add a writeup to docs.ofbiz.org that explains the additional steps > -- ie getting the additional libs and key files from the All Pay guys. > > I hope this shows what I was saying - there will always be pieces of > these implementations that are not compatible, but having them in the > project other than the incompatible libs increases the chances of > everyone getting to use them. Thanks and I look forward to your next > response. > > Cheers, > Tim > -- > Tim Ruppert > HotWax Media > http://www.hotwaxmedia.com > > o:801.649.6594 > f:801.649.6595 > > On Aug 17, 2009, at 11:19 AM, Shi Jinghai wrote: > > > Yes, I know. Jasig has just changed its license to Apache license. > > > > Apache has a very good reputation in China. Perhaps someday in the > > future we'll have the courage to change our license to Apache :). > > > > Shi Jinghai > > > > > > 在 2009-08-17一的 09:55 -0700，Adrian Crum写道： > >> You don't have to be an Apache project to use the Apache license. > >> > >> -Adrian > >> > >> Shi Jinghai wrote: > >>> Tim, > >>> > >>> As the component depends on Alipay's java files, I asked the > >>> Alipay.com > >>> what license of the source files and got the reply that it's in a > >>> license we can use them freely without viciousness. I'm not sure > >>> what it > >>> is, so I used our default license. > >>> > >>> We're trying to setup our own opensource brand, it's reasonable to > >>> choose LGPL as we're NOT Apache, and LGPL 3.0 is compatible with > >>> Apache > >>> License 2.0 for everybody. > >>> > >>> BTW, there are a lot of outstanding opensources in LGPL and also > >>> useful > >>> for OFBiz, such as captcha, I think Langhua Opensource as a third > >>> party > >>> will be helpful for the community to fill the licenses gap. "There > >>> are > >>> mountains, here is a valley" is our slogan and target. > >>> > >>> We DO work with the community :). > >>> > >>> Regards, > >>> > >>> Shi Jinghai/Langhua Opensource Foundation > >>> > >>> > >>> 在 2009-08-17一的 06:43 -0600，Tim Ruppert写道： > Shi - why put this out LGPL? Why not work with the rest of the > community and make it so it can be added to the project? Thanks > for > doing the work, but please work with the community to put this in. > > Cheers, > Tim > -- > Tim Ruppert > HotWax Media > http://www.hotwaxmedia.com > > o:801.649.6594 > f:801.649.6595 > > On Aug 16, 2009, at 10:19 PM, Shi Jinghai wrote: > > > Hi list, > > > > I'm glad to announce a new OFBiz component, OFBiz-AliPay has been > > released. This component is licensed in LGPL v3.0. > > > > AliPay is a leading payment gateway in China, you can visit its > > website > > for more info: https://www.alipay.com/ > > > > You can get OFBiz-AliPay release version from: > > http://maven2.langhua.org/archiva/browse/ofbiz/ofbiz-alipay/09.04 > > > > You can get the source code from: > > http://langhua.org/opensource/ofbiz/ofbiz-alipay/trunk/ > > > > Enjoy it. > > > > Shi Jinghai/Beijing Langhua Ltd. > > http://langhua.org/ > > http://langhua.biz/ > > http://www.langhua.cn/ > > > > > >>> > >>> > > >
Re: is compile and ofbiz restart still needed for java changes?
We typically execute Ofbiz from Eclipse and some people have reported that the hot-swapping works fairly well. (Usually we do not run an ant build until right before check-in and then just to ensure we are compiling and avoiding classpath issues). The approach I often take is to write my unit test in conjunction with the service implementation I am working on. I have added some mocking capabilities in our Ofbiz installation, so I can avoid starting up the container at all and still exercise all of the logic in the service method. Result is usually a sub-second unit test. Naturally an integration test would require container start-up and a reasonably heavy penalty. Another approach others have used is to write the service method in groovy and once working convert this into java. From memory there is really only a single sample of a groovy implemented service, and when I went to do there there was at least one bug I had to resolve. But this is a feasible way and the groovy is quite a bit like java. :) - Bob Ruth Hoffman-2 wrote: > > Hi Chris: > I guess I'm just use to the inconvenience. :-( The other thing I do to > try and minimize restart time is to comment out the components I might > not be using. > Ruth > -- View this message in context: http://www.nabble.com/is-compile-and-ofbiz-restart-still-needed-for-java-changes--tp24971472p25018438.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: entity condition expression problem
I think I would create a view-entity that aliased all of the fields you have
here and added a complex-alias for the difference of the actual and
estimated net amounts. Something like --
Then do your entity condition on this field in your v-e.
Bob
snowc wrote:
>
> I have some legacy data that I am trying to access in ofbiz.
>
>
>
>
>
>
>
> Conceptually, I want to filter as shown here:
>
> SELECT e1Id, actualNetAmount, estimatedNetAmount
> FROM E1 WHERE actualNetAmount > estimatedNetAmount
>
>
> value="${this.estimatedNetAmount}"/>
>
>
> How can I achieve the equivalent of "this" is a entity condition
> expression?
>
> I do not want to filter by iterating the list as the data volumes are
> huge.
>
> One option I am thinking of is to create a SQL view and use that to filter
> the data:
>
> SELECT
> e1Id, actualNetAmount, estimatedNetAmount,
> CASE
> WHEN actualNetAmount > estimatedNetAmount THEN 1
> ELSE 0
> END CASE AS actualGTEstimated
> FROM E1
>
> Maybe I could use DynamicViewEntities, but I was trying to use less
> beanshell/java and more minilang.
>
> Many thanks in advance, Chris
>
>
--
View this message in context:
http://www.nabble.com/entity-condition-expression-problem-tp25010865p25018276.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: need to recalculate trial balance
No, I had too many entries to reverse. I backed out all data related to orders starting with AcctgTransEntry and worked my way up the stack. I am considering writing a simple method to iterate thru AcctgTrans and call the service that does the calc. Vince Clark www.globalera.com vcl...@globalera.com (303) 493-6723 office (303) 523-4843 cell - Original Message - From: "Yoke Power" To: user@ofbiz.apache.org Sent: Monday, August 17, 2009 8:22:13 PM GMT -07:00 US/Canada Mountain Subject: Re: need to recalculate trial balance Hi Vince, Are you using accounting module to revert the transaction; Use the Accounting module and Try Finding the transaction in question; Click on *Revert Accounting Transaction* button; and post the transaction, this will cancel the already created transaction; Then try creating the Trial Balance; Hope this helps, Regards Sakthi On Sun, Aug 16, 2009 at 7:55 PM, Vince Clark wrote: > I had to back out some orders manually and now I need to recalculate > financial reports. The only services I see for this seem to require a > transaction id. Is there a way to just recalculate the whole thing? > > > > Vince Clark > www.globalera.com > vcl...@globalera.com > (303) 493-6723 office > (303) 523-4843 cell > >
Re: need to recalculate trial balance
Hi Vince, Are you using accounting module to revert the transaction; Use the Accounting module and Try Finding the transaction in question; Click on *Revert Accounting Transaction* button; and post the transaction, this will cancel the already created transaction; Then try creating the Trial Balance; Hope this helps, Regards Sakthi On Sun, Aug 16, 2009 at 7:55 PM, Vince Clark wrote: > I had to back out some orders manually and now I need to recalculate > financial reports. The only services I see for this seem to require a > transaction id. Is there a way to just recalculate the whole thing? > > > > Vince Clark > www.globalera.com > vcl...@globalera.com > (303) 493-6723 office > (303) 523-4843 cell > >
Re: Search Issue
Hi, Also If I run a like query "select * from product_keyword where keyword like '%aries%'" I get zero results. But in site I got 9 results. I am bit confuse how search is actually working in ofbiz. Regards, Abhishake On Tue, Aug 11, 2009 at 10:37 PM, Abhishake Agarwal < abhishake.agar...@gmail.com> wrote: > Thanks Scott, > > Is there any way to make EQUAL query i.e (Exact keyword match) > > Regards, > Abhishake > > > > > On Tue, Aug 11, 2009 at 8:47 PM, Scott Gray wrote: > >> It's a LIKE query so it will return keywords containing aries such as >> diaries. >> >> Regards >> Scott >> >> HotWax Media >> http://www.hotwaxmedia.com >> >> >> On 12/08/2009, at 3:02 AM, Abhishake Agarwal wrote: >> >> Hi, >>> >>> I facing an issue related to search which I found to be similar in >>> http://demo.ofbiz.org/ecommerce. >>> >>> When I search a word 'aries' on demo site I got nine search results. But >>> If >>> I look at ProductKeyword table there is no entry for keyword 'aries'. >>> >>> Also if you search 'aries1' then it gives 'no result found' which is >>> correct. >>> >>> Please let me know what is missing. >>> >>> Regards, >>> Abhishake >>> >> >> >
Re: Compilation error on IBM System i (iSeries, AS/400)
Hi Jacques,
Yes I tried as Deyan suggested and that reduced the number of compilation
errors by 5, but I still get 5 compilation errors casting from "operator"
to "EntityComparisonOperator" and "EntityJoinOperator" like the following::
[javac15]
/ofbiz/framework/entity/src/org/ofbiz/entity/model/ModelViewEntity.java:1271:
inconvertible types
[javac15] found : org.ofbiz.entity.condition.EntityOperator
[javac15] required: org.ofbiz.entity.condition.EntityComparisonOperator
[javac15]
EntityCondition.makeCondition(EntityFunction.UPPER(lhs),
(EntityComparisonOperator) operator , EntityFunction.UPPER(rhs)),
[javac15]^
Any suggestions?
-André
On Friday den 14. August 2009 19:35:09 Jacques Le Roux wrote:
> Did you try to change for equals as Deyan suggested ?
>
> Jacques
>
> From: "André Herbst"
>
> >I am not sure what the following piece of code from class ModelViewEntity
> > is trying to acheive, but as "operator" and "EntityOperator.IN" are both
> > objects and not primitives the "==" as far as I know test if those two
> > variables reference the same object and not if the values are equal.
> >
> > // If IN or BETWEEN operator, see if value is a literal list and split it
> >if ((operator == EntityOperator.IN || operator ==
> > EntityOperator.BETWEEN)
> >&& value instanceof String) {
> >String delim = null;
> >if (((String)value).indexOf("|") >= 0) {
> >delim = "|";
> >} else if (((String)value).indexOf(",") >= 0) {
> >delim = ",";
> >}
> >if (UtilValidate.isNotEmpty(delim)) {
> >value = StringUtil.split((String) value, delim);
> >}
> >
> > Further the equals() method is overridden in class EntityOperator with
> > the following:
> >
> > // FIXME: CCE
> >@Override
> >public boolean equals(Object obj) {
> >EntityOperator otherOper = (EntityOperator) obj;
> >return this.idInt == otherOper.idInt;
> >}
> >
> > So if using equals as in: "if ((operator.equals(EntityOperator.IN)" this
> > method would be called.
> >
> > Any comments and suggestions will be much appreciated, thanks.
> >
> > -André
> >
> > On Wednesday den 29. July 2009 12:55:30 Deyan Tsvetanov wrote:
> >> Does it work with equals() instead of == ?
> >>
> >>
> >>
> >> -Original Message-
> >> From: BJ Freeman
> >> Reply-to: user@ofbiz.apache.org
> >> To: user@ofbiz.apache.org
> >> Subject: Re: Compilation error on IBM System i (iSeries, AS/400)
> >> Date: Wed, 29 Jul 2009 03:44:25 -0700
> >>
> >>
> >> Ok then my next suggestion is you try this on he demo trunk and see if
> >> you can duplicate the problem. If so then create a Jira.
> >>
> >> André Herbst sent the following on 7/28/2009 11:26 PM:
> >> > Thanks BJ,
> >> >
> >> > I would prefer to keep up with the latest revisions from the trunk, so
> >> > I hope David or Scott can help me with this problem.
> >> >
> >> > -André
> >> >
> >> > On Tuesday den 28. July 2009 15:53:17 BJ Freeman wrote:
> >> >> David and Scott have done some modification and refactoring on
> >> >> ModelViewEntity.java
> >> >> you can wait for their response or revert to before 790472 and see if
> >> >> you still have the problem.
> >> >>
> >> >> André Herbst sent the following on 7/28/2009 2:05 AM:
> >> >>> Hi All,
> >> >>>
> >> >>> I am working on getting OFBiz to run on an IBM System i server,
> >> >>> using the systems native DB2 database, but have run into problems
> >> >>> with compling after an upgrade to a newer version of the trunk.
> >> >>>
> >> >>> I am using the OFBiz trunk version 793888 and is getting the
> >> >>> following compile error:
> >> >>>
> >> >>> [javac15]
> >> >>> /ofbiz/framework/entity/src/org/ofbiz/entity/model/ModelViewEntity.j
> >> >>>ava
> >> >>>
> >> >>>:1 232: incomparable types:
> >> >>>
> >> >>> org.ofbiz.entity.contiontion.EntityOperator and
> >> >>> org.ofbiz.entity.condition.EntityComparisonOperator
> >> >>> [javac15] if ((operator == EntityOperator.IN || operator
> >> >>> == EntityOperator.BETWEEN) [javac15]
> >> >>> ^
> >> >>>
> >> >>> I am using the "IBM Developer Kit for Java - IBM J9 VM (build 2.3,
> >> >>> J2RE 1.5.0 IBM J9 2.3 OS400 ppc-32 j9vmap3223-20080315 (JIT
> >> >>> enabled)". There is no similar problem when I am compiling the same
> >> >>> source on my Linux box.
> >> >>>
> >> >>> Any help would be very much appreciated.
> >> >>>
> >> >>> -André
Re: product hierarchies
Hi Ruth, The stock number that is allocated is shared by all components of the vehicle. Therefore, the product ID would probably be a manufacturer identifier, e.g. E320C for a specific engine type. For an item of stock such as the engine E320C. The description and photos would be for the product, but each inventory item would probably need additional comments relating to the specific item. For example: Product: Engine[E320C] |-Inventory Item StockNum[ABC123] - condition new |-Inventory Item StockNum[DEF234] - engine seized. will not start. Would this type of structure work for virtual products? E.g. the Engine E320C is the virtual product. But Engine StockNum[ABC123] and Engine StockNum[DEF234] are the actual physical products with inventory items? Many thanks in advance, Chris. Ruth Hoffman-2 wrote: > > Thanks. Please keep us posted. > Ruth > snowc wrote: >> Hi Ruth, >> >> Please feel free to use this as an example. >> >> I have some more information to follow later... >> >> Many thanks, >> >> Chris >> >> >> Ruth Hoffman-2 wrote: >> >>> Hi Chris: >>> Quick answer and MHO would be as follows (and I'm hardly an expert on >>> this, so others, feel free to chime in): >>> snowc wrote: >>> Hi Ruth, When a vehicle is received, they would like to book the vehicle and each of it's main components (Engine, Gearbox, Axles, Body, Etc) into stock: Vehicle (e.g. StockRef[ABC123] Make[Volvo] Model[F10] Type[4x2 TU] Year[2000]) |- Engine (e.g. ModelId[400E34]) |- Gearbox (e.g. ModelId[5206B]) |- Etc Vehicle (e.g. StockRef[ABC234] Make[Ford] Model[Escort] Type[Sedan] Year[1985]) |- Engine (e.g. ModelId[231AA]) |- Gearbox (e.g. ModelId[345BB]) |- Etc When the vehicle is received whole, the component locations will be the same as the vehicle location. However, when broken, the individual components locations will be different. The customer would like to be able to answer customer enquiries such as: "Do you have any Ford Escort engines (model 231AA) in stock?". The customer would like to also list all stock (vehicle and components) on their website. They do not want ecommerce cart, just a list of available stock. I think I can maybe model the relationship between the vehicle and component as associations, e.g.: Engine (StockRef[231AA]) is an "Actual Product Component" of Vehicle (StockRef[ABC234]) Does this relationship make sense? >>> Yes. Here is my reasoning: Since you want to track and list major >>> components as entities separate from their source - a vehicle, I think >>> both the vehicle and each of the major components that you want to track >>> are "PRODUCTS". The productID could be the StockRef# or VIN depending on >>> the item (since I don't think gear boxes have VINs?). >>> >>> Then, for browsing (and tracking) purposes you could create one or more >>> product associations (bundles) so that an engine (StockRef#/VIN, >>> facilityID=still in the vehicle) may be associated with a vehicle (with >>> stockref #/VIN, facilityId = sitting on back lot) and a gearbox (with >>> stockref #, facilityId = building 10, shelf 2) may be associated with a >>> vehicle etc. You could even have categories set up to just show gear >>> boxes (as products) or entire vehicles. >>> >>> So, without actually trying this out with some test data, I can't really >>> say if it would work exactly as you envision. [if you don't mind I'd >>> like to use something like this example in the book since, as of today, >>> I don't really talk much about product associations. This would be a >>> great use-case.] >>> For storing the attibutes such as make, model, year would feature be the best way? For example, if I create a feature hierarchy: Make (E.g. Ford) | - Model (e.g. Escort) I would also create a feature group for each Make/Model combination to constrain the allowed make model combinations. >>> Exactly how I would do it. >>> I like to keep things as simple as possible. And so, maybe I'm missing >>> something here - but I think that is all you need to do. Maybe someone >>> who has lots of experience with product data modeling and OFBiz could >>> comment? >>> Does the above approach make sense? Many thanks in advance... Ruth Hoffman-2 wrote: > Just curious - do they only want to list configurations (like > inventory) > or do they intend to sell either the vehicles or parts thereof? > Ruth > BJ Freeman wrote: > > >> yes. >> Could do it OOTB but a lot of data entry. >> Look at the PC configure for Ideas. >> https://demo.ofbiz.org/catalog/control/EditProductCon
Re: OFBiz-AliPay has been released
I didn't mean to come on too strong Shi - and I've seen you around, so I know you're working here - but know that most of the actual implementations of the payment processors have small steps that bring in the files that cannot be put back into OFBiz. So, if it's still a possibility, what the community would ask you to do in order to be able to commit it would be (and this is the same for PayFlow Pro as well): 1. Make all of the code files in OFBiz Apache licensed 2. Add an exclude in the accounting build file for Java files that are dependent upon their libs -- If necessary 3. Add a writeup to docs.ofbiz.org that explains the additional steps -- ie getting the additional libs and key files from the All Pay guys. I hope this shows what I was saying - there will always be pieces of these implementations that are not compatible, but having them in the project other than the incompatible libs increases the chances of everyone getting to use them. Thanks and I look forward to your next response. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 On Aug 17, 2009, at 11:19 AM, Shi Jinghai wrote: Yes, I know. Jasig has just changed its license to Apache license. Apache has a very good reputation in China. Perhaps someday in the future we'll have the courage to change our license to Apache :). Shi Jinghai 在 2009-08-17一的 09:55 -0700，Adrian Crum写道： You don't have to be an Apache project to use the Apache license. -Adrian Shi Jinghai wrote: Tim, As the component depends on Alipay's java files, I asked the Alipay.com what license of the source files and got the reply that it's in a license we can use them freely without viciousness. I'm not sure what it is, so I used our default license. We're trying to setup our own opensource brand, it's reasonable to choose LGPL as we're NOT Apache, and LGPL 3.0 is compatible with Apache License 2.0 for everybody. BTW, there are a lot of outstanding opensources in LGPL and also useful for OFBiz, such as captcha, I think Langhua Opensource as a third party will be helpful for the community to fill the licenses gap. "There are mountains, here is a valley" is our slogan and target. We DO work with the community :). Regards, Shi Jinghai/Langhua Opensource Foundation 在 2009-08-17一的 06:43 -0600，Tim Ruppert写道： Shi - why put this out LGPL? Why not work with the rest of the community and make it so it can be added to the project? Thanks for doing the work, but please work with the community to put this in. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 On Aug 16, 2009, at 10:19 PM, Shi Jinghai wrote: Hi list, I'm glad to announce a new OFBiz component, OFBiz-AliPay has been released. This component is licensed in LGPL v3.0. AliPay is a leading payment gateway in China, you can visit its website for more info: https://www.alipay.com/ You can get OFBiz-AliPay release version from: http://maven2.langhua.org/archiva/browse/ofbiz/ofbiz-alipay/09.04 You can get the source code from: http://langhua.org/opensource/ofbiz/ofbiz-alipay/trunk/ Enjoy it. Shi Jinghai/Beijing Langhua Ltd. http://langhua.org/ http://langhua.biz/ http://www.langhua.cn/ smime.p7s Description: S/MIME cryptographic signature
Re: entity condition expression problem
Never Mind.
shot from the hip.
BJ Freeman sent the following on 8/17/2009 10:35 AM:
> step one is created a viewentity for the equivalent Select
> then use the entity condition for the viewenitity
>
> snowc sent the following on 8/17/2009 10:26 AM:
>> I have some legacy data that I am trying to access in ofbiz.
>>
>>
>>
>>
>>
>>
>>
>> Conceptually, I want to filter as shown here:
>>
>> SELECT e1Id, actualNetAmount, estimatedNetAmount
>> FROM E1 WHERE actualNetAmount > estimatedNetAmount
>>
>>
>>> value="${this.estimatedNetAmount}"/>
>>
>>
>> How can I achieve the equivalent of "this" is a entity condition expression?
>>
>> I do not want to filter by iterating the list as the data volumes are huge.
>>
>> One option I am thinking of is to create a SQL view and use that to filter
>> the data:
>>
>> SELECT
>> e1Id, actualNetAmount, estimatedNetAmount,
>> CASE
>> WHEN actualNetAmount > estimatedNetAmount THEN 1
>> ELSE 0
>> END CASE AS actualGTEstimated
>> FROM E1
>>
>> Maybe I could use DynamicViewEntities, but I was trying to use less
>> beanshell/java and more minilang.
>>
>> Many thanks in advance, Chris
>>
>
--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.
Re: entity condition expression problem
step one is created a viewentity for the equivalent Select
then use the entity condition for the viewenitity
snowc sent the following on 8/17/2009 10:26 AM:
> I have some legacy data that I am trying to access in ofbiz.
>
>
>
>
>
>
>
> Conceptually, I want to filter as shown here:
>
> SELECT e1Id, actualNetAmount, estimatedNetAmount
> FROM E1 WHERE actualNetAmount > estimatedNetAmount
>
>
> value="${this.estimatedNetAmount}"/>
>
>
> How can I achieve the equivalent of "this" is a entity condition expression?
>
> I do not want to filter by iterating the list as the data volumes are huge.
>
> One option I am thinking of is to create a SQL view and use that to filter
> the data:
>
> SELECT
> e1Id, actualNetAmount, estimatedNetAmount,
> CASE
> WHEN actualNetAmount > estimatedNetAmount THEN 1
> ELSE 0
> END CASE AS actualGTEstimated
> FROM E1
>
> Maybe I could use DynamicViewEntities, but I was trying to use less
> beanshell/java and more minilang.
>
> Many thanks in advance, Chris
>
--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.
entity condition expression problem
I have some legacy data that I am trying to access in ofbiz. Conceptually, I want to filter as shown here: SELECT e1Id, actualNetAmount, estimatedNetAmount FROM E1 WHERE actualNetAmount > estimatedNetAmount How can I achieve the equivalent of "this" is a entity condition expression? I do not want to filter by iterating the list as the data volumes are huge. One option I am thinking of is to create a SQL view and use that to filter the data: SELECT e1Id, actualNetAmount, estimatedNetAmount, CASE WHEN actualNetAmount > estimatedNetAmount THEN 1 ELSE 0 END CASE AS actualGTEstimated FROM E1 Maybe I could use DynamicViewEntities, but I was trying to use less beanshell/java and more minilang. Many thanks in advance, Chris -- View this message in context: http://www.nabble.com/entity-condition-expression-problem-tp25010865p25010865.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: OFBiz-AliPay has been released
Yes, I know. Jasig has just changed its license to Apache license. Apache has a very good reputation in China. Perhaps someday in the future we'll have the courage to change our license to Apache :). Shi Jinghai 在 2009-08-17一的 09:55 -0700，Adrian Crum写道： > You don't have to be an Apache project to use the Apache license. > > -Adrian > > Shi Jinghai wrote: > > Tim, > > > > As the component depends on Alipay's java files, I asked the Alipay.com > > what license of the source files and got the reply that it's in a > > license we can use them freely without viciousness. I'm not sure what it > > is, so I used our default license. > > > > We're trying to setup our own opensource brand, it's reasonable to > > choose LGPL as we're NOT Apache, and LGPL 3.0 is compatible with Apache > > License 2.0 for everybody. > > > > BTW, there are a lot of outstanding opensources in LGPL and also useful > > for OFBiz, such as captcha, I think Langhua Opensource as a third party > > will be helpful for the community to fill the licenses gap. "There are > > mountains, here is a valley" is our slogan and target. > > > > We DO work with the community :). > > > > Regards, > > > > Shi Jinghai/Langhua Opensource Foundation > > > > > > 在 2009-08-17一的 06:43 -0600，Tim Ruppert写道： > >> Shi - why put this out LGPL? Why not work with the rest of the > >> community and make it so it can be added to the project? Thanks for > >> doing the work, but please work with the community to put this in. > >> > >> Cheers, > >> Tim > >> -- > >> Tim Ruppert > >> HotWax Media > >> http://www.hotwaxmedia.com > >> > >> o:801.649.6594 > >> f:801.649.6595 > >> > >> On Aug 16, 2009, at 10:19 PM, Shi Jinghai wrote: > >> > >>> Hi list, > >>> > >>> I'm glad to announce a new OFBiz component, OFBiz-AliPay has been > >>> released. This component is licensed in LGPL v3.0. > >>> > >>> AliPay is a leading payment gateway in China, you can visit its > >>> website > >>> for more info: https://www.alipay.com/ > >>> > >>> You can get OFBiz-AliPay release version from: > >>> http://maven2.langhua.org/archiva/browse/ofbiz/ofbiz-alipay/09.04 > >>> > >>> You can get the source code from: > >>> http://langhua.org/opensource/ofbiz/ofbiz-alipay/trunk/ > >>> > >>> Enjoy it. > >>> > >>> Shi Jinghai/Beijing Langhua Ltd. > >>> http://langhua.org/ > >>> http://langhua.biz/ > >>> http://www.langhua.cn/ > >>> > >>> > > > >
Re: OFBiz-AliPay has been released
You don't have to be an Apache project to use the Apache license. -Adrian Shi Jinghai wrote: Tim, As the component depends on Alipay's java files, I asked the Alipay.com what license of the source files and got the reply that it's in a license we can use them freely without viciousness. I'm not sure what it is, so I used our default license. We're trying to setup our own opensource brand, it's reasonable to choose LGPL as we're NOT Apache, and LGPL 3.0 is compatible with Apache License 2.0 for everybody. BTW, there are a lot of outstanding opensources in LGPL and also useful for OFBiz, such as captcha, I think Langhua Opensource as a third party will be helpful for the community to fill the licenses gap. "There are mountains, here is a valley" is our slogan and target. We DO work with the community :). Regards, Shi Jinghai/Langhua Opensource Foundation 在 2009-08-17一的 06:43 -0600，Tim Ruppert写道： Shi - why put this out LGPL? Why not work with the rest of the community and make it so it can be added to the project? Thanks for doing the work, but please work with the community to put this in. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 On Aug 16, 2009, at 10:19 PM, Shi Jinghai wrote: Hi list, I'm glad to announce a new OFBiz component, OFBiz-AliPay has been released. This component is licensed in LGPL v3.0. AliPay is a leading payment gateway in China, you can visit its website for more info: https://www.alipay.com/ You can get OFBiz-AliPay release version from: http://maven2.langhua.org/archiva/browse/ofbiz/ofbiz-alipay/09.04 You can get the source code from: http://langhua.org/opensource/ofbiz/ofbiz-alipay/trunk/ Enjoy it. Shi Jinghai/Beijing Langhua Ltd. http://langhua.org/ http://langhua.biz/ http://www.langhua.cn/
Re: OFBiz-AliPay has been released
Tim, As the component depends on Alipay's java files, I asked the Alipay.com what license of the source files and got the reply that it's in a license we can use them freely without viciousness. I'm not sure what it is, so I used our default license. We're trying to setup our own opensource brand, it's reasonable to choose LGPL as we're NOT Apache, and LGPL 3.0 is compatible with Apache License 2.0 for everybody. BTW, there are a lot of outstanding opensources in LGPL and also useful for OFBiz, such as captcha, I think Langhua Opensource as a third party will be helpful for the community to fill the licenses gap. "There are mountains, here is a valley" is our slogan and target. We DO work with the community :). Regards, Shi Jinghai/Langhua Opensource Foundation 在 2009-08-17一的 06:43 -0600，Tim Ruppert写道： > Shi - why put this out LGPL? Why not work with the rest of the > community and make it so it can be added to the project? Thanks for > doing the work, but please work with the community to put this in. > > Cheers, > Tim > -- > Tim Ruppert > HotWax Media > http://www.hotwaxmedia.com > > o:801.649.6594 > f:801.649.6595 > > On Aug 16, 2009, at 10:19 PM, Shi Jinghai wrote: > > > Hi list, > > > > I'm glad to announce a new OFBiz component, OFBiz-AliPay has been > > released. This component is licensed in LGPL v3.0. > > > > AliPay is a leading payment gateway in China, you can visit its > > website > > for more info: https://www.alipay.com/ > > > > You can get OFBiz-AliPay release version from: > > http://maven2.langhua.org/archiva/browse/ofbiz/ofbiz-alipay/09.04 > > > > You can get the source code from: > > http://langhua.org/opensource/ofbiz/ofbiz-alipay/trunk/ > > > > Enjoy it. > > > > Shi Jinghai/Beijing Langhua Ltd. > > http://langhua.org/ > > http://langhua.biz/ > > http://www.langhua.cn/ > > > > >
cannot update description fields in InvoiceType and InvoiceItemType
This is probably happening with other entities as well. But these are the only two I have run into it so far. When we try updating a description thru Webtools entity data maintenance the old value stays. Is this being cached somewhere? I have tried clearing cache and even restarting. If I do a direct database update the value changes in the db but still displays the old value in the entity engine. Vince Clark www.globalera.com vcl...@globalera.com (303) 493-6723 office (303) 523-4843 cell
Re: product hierarchies
Thanks. Please keep us posted. Ruth snowc wrote: Hi Ruth, Please feel free to use this as an example. I have some more information to follow later... Many thanks, Chris Ruth Hoffman-2 wrote: Hi Chris: Quick answer and MHO would be as follows (and I'm hardly an expert on this, so others, feel free to chime in): snowc wrote: Hi Ruth, When a vehicle is received, they would like to book the vehicle and each of it's main components (Engine, Gearbox, Axles, Body, Etc) into stock: Vehicle (e.g. StockRef[ABC123] Make[Volvo] Model[F10] Type[4x2 TU] Year[2000]) |- Engine (e.g. ModelId[400E34]) |- Gearbox (e.g. ModelId[5206B]) |- Etc Vehicle (e.g. StockRef[ABC234] Make[Ford] Model[Escort] Type[Sedan] Year[1985]) |- Engine (e.g. ModelId[231AA]) |- Gearbox (e.g. ModelId[345BB]) |- Etc When the vehicle is received whole, the component locations will be the same as the vehicle location. However, when broken, the individual components locations will be different. The customer would like to be able to answer customer enquiries such as: "Do you have any Ford Escort engines (model 231AA) in stock?". The customer would like to also list all stock (vehicle and components) on their website. They do not want ecommerce cart, just a list of available stock. I think I can maybe model the relationship between the vehicle and component as associations, e.g.: Engine (StockRef[231AA]) is an "Actual Product Component" of Vehicle (StockRef[ABC234]) Does this relationship make sense? Yes. Here is my reasoning: Since you want to track and list major components as entities separate from their source - a vehicle, I think both the vehicle and each of the major components that you want to track are "PRODUCTS". The productID could be the StockRef# or VIN depending on the item (since I don't think gear boxes have VINs?). Then, for browsing (and tracking) purposes you could create one or more product associations (bundles) so that an engine (StockRef#/VIN, facilityID=still in the vehicle) may be associated with a vehicle (with stockref #/VIN, facilityId = sitting on back lot) and a gearbox (with stockref #, facilityId = building 10, shelf 2) may be associated with a vehicle etc. You could even have categories set up to just show gear boxes (as products) or entire vehicles. So, without actually trying this out with some test data, I can't really say if it would work exactly as you envision. [if you don't mind I'd like to use something like this example in the book since, as of today, I don't really talk much about product associations. This would be a great use-case.] For storing the attibutes such as make, model, year would feature be the best way? For example, if I create a feature hierarchy: Make (E.g. Ford) | - Model (e.g. Escort) I would also create a feature group for each Make/Model combination to constrain the allowed make model combinations. Exactly how I would do it. I like to keep things as simple as possible. And so, maybe I'm missing something here - but I think that is all you need to do. Maybe someone who has lots of experience with product data modeling and OFBiz could comment? Does the above approach make sense? Many thanks in advance... Ruth Hoffman-2 wrote: Just curious - do they only want to list configurations (like inventory) or do they intend to sell either the vehicles or parts thereof? Ruth BJ Freeman wrote: yes. Could do it OOTB but a lot of data entry. Look at the PC configure for Ideas. https://demo.ofbiz.org/catalog/control/EditProductConfigs?productId=PC001 Customization would let them build a library of car models then it would automatically build the products. snowc sent the following on 8/7/2009 12:14 PM: I have some customers that break second hand cars and trucks. When they receive a vehicle for breaking, they would like to enter the vehicle into ofbiz and also input the major components that the vehicle can be broken into. The whole vehicle and the major components will be listed on the ecommerce site. Is this possible? how? Many thank in advance...
Re: is compile and ofbiz restart still needed for java changes?
Hi Chris: I guess I'm just use to the inconvenience. :-( The other thing I do to try and minimize restart time is to comment out the components I might not be using. Ruth snowc wrote: Hi Ruth - I am compiling at the component level. Ruth Hoffman-2 wrote: Hi Jacques: True, but I have found that many times Java is the preferable way to go. That said, I wonder, Chris, are you building (running ant) at the component level? If so, then I wonder why it would take that long. If you build at the root level, yes, that is a pain. But locally in the component...that, to me is worth the small amount of time it takes build and restart. Just my 2 cents. Ruth Jacques Le Roux wrote: OFBiz has been conceived with this idea in mind. I mean reducing the need to restart the server. That's one of the reason why the minilang exists... Jacques From: "snowc" Although I much prefer editing java over bsh, I keep finding myself using bsh over java to overcome the lengthy compile/restart cycle (similar to the problem with fat ejb versus thin pojo development). Is there a way to reduce this cycle? jacques.le.roux wrote: As long as you modify Java code, you will still need to compile, hence to stop and restart the server (else you get a conflict on jars used when compiling) Jacques From: "snowc" Everytime I make a change to java code, I run "ant" and then restart the ofbiz service to pick up the changes. Is this still necessary? I am running r4.0. What about 9.04 -- View this message in context: http://www.nabble.com/is-compile-and-ofbiz-restart-still-needed-for-java-changes--tp24971472p24971472.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/is-compile-and-ofbiz-restart-still-needed-for-java-changes--tp24971472p24971811.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: OFBiz-AliPay has been released
Shi - why put this out LGPL? Why not work with the rest of the community and make it so it can be added to the project? Thanks for doing the work, but please work with the community to put this in. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 On Aug 16, 2009, at 10:19 PM, Shi Jinghai wrote: Hi list, I'm glad to announce a new OFBiz component, OFBiz-AliPay has been released. This component is licensed in LGPL v3.0. AliPay is a leading payment gateway in China, you can visit its website for more info: https://www.alipay.com/ You can get OFBiz-AliPay release version from: http://maven2.langhua.org/archiva/browse/ofbiz/ofbiz-alipay/09.04 You can get the source code from: http://langhua.org/opensource/ofbiz/ofbiz-alipay/trunk/ Enjoy it. Shi Jinghai/Beijing Langhua Ltd. http://langhua.org/ http://langhua.biz/ http://www.langhua.cn/ smime.p7s Description: S/MIME cryptographic signature
Re: Trying to access OFBiz web service through an external java client.
Have you read about SOAP in FAQ ?
Jacques
From:
Hi,
I am trying to access OFBiz web service through an external java client.
I have created a service in OFBiz with parameter export="true". I get the
wsdl file generated successfully.
But when I try to access the service using client, I get the following
exception:
Aug 17, 2009 12:47:52 PM org.apache.axis.utils.JavaUtils
isAttachmentSupported
WARNING: Unable to find required classes (javax.activation.DataHandler and
javax.mail.internet.MimeMultipart). Attachment support is disabled.
javax.xml.rpc.ServiceException: Error processing WSDL document:
javax.xml.rpc.ServiceException: Error processing WSDL document:
javax.xml.rpc.ServiceException: Cannot find service: test
at org.apache.axis.client.Service.initService(Service.java:250)
at org.apache.axis.client.Service.(Service.java:165)
at org.apache.axis.client.ServiceFactory.createService(
ServiceFactory.java:198)
at NewClient.main(NewClient.java:26)
My client class code is:
public class Client {
public static void main(String args[]){
String wsdlURL =
"http://localhost:8088/webtools/control/SOAPService/test?wsdl";;
String namespace = "";
String serviceName = "test";
QName serviceQN = new QName(namespace, serviceName);
ServiceFactory serviceFactory;
try {
serviceFactory = ServiceFactory.newInstance();
Service service = serviceFactory.createService(new
URL(wsdlURL), serviceQN);
} catch (MalformedURLException e) {
e.printStackTrace();
} catch (ServiceException e) {
e.printStackTrace();
}
}
}
I have also included the jar files required to run the client as mentioned
below:
axis.jar
jaxrpc.jar
commons-logging-1.1.1.jar
wsdl4j-1.5.1.jar
saaj.jar
webserviceutils.jar
commonsdiscovery-0.2.jar
I tried the same thing using C# client,but got the same problem.I feel
that the OFBiz wsdl gets created in such a way that it does not get
exposed to external client. Kindly let me know the reason of the
exception.Is the way i am following, correct? Also, if there is some other
way to do the task.
Thanks & Regards,
Neha Mehta
Software Engineer (A-1-1)
Larsen & Toubro Infotech Ltd.
__
Re: Order Manager - Audit trail
Hi Vikas, I checked out the issue http://svn.apache.org/viewvc?view=rev&revision=778406 that you referred. Does most of what I was looking for and should be able to extend. Now looks like this is available only in the trunk while I started with 9.04 as the stable branch? So, I know this is going to be situational, but since I haven't progressed much is it better to move to trunk or move the relevant changes to 9.04. For my requirement, I just need order management and anything essential to make it work. Also I see a feature to show "Item Unit Price History" but changes made to unit price through order item edit does not seem to take effect. Is that a bug? If it is then I would be happy to work on it and hope to pick some ofbiz understanding. Thanks in advance Aray Vikas Mayur-3 wrote: > > This can be achieved using enable-audit-log feature - > http://svn.apache.org/viewvc?view=rev&revision=652226 > > Example Implementation can be found at > http://svn.apache.org/viewvc?view=rev&revision=778406 > > Vikas > > On Aug 11, 2009, at 11:17 PM, ARays wrote: > >> >> Hi All, >> >> I have a requirement to show details of changes made to a submitted >> orders. >> Essentially audit trail of which user modified what, field by field. >> This >> would need to include change made to line items besides of course >> shipping >> details etc. In short all details linked to orderid. >> >> Going through the Nabble archives found the thread below. >> >> http://www.nabble.com/audit-trail-to9675210.html#a9675210 >> >> Q1: Was this implemented? While I am looking, thought would be >> useful if >> anyone can throw some pointers. >> >> Q2: There would be an upstream system where the initial orders are >> posted. >> Till fulfillment orders would be tracked in ofbiz and sent back to >> the up >> stream system for invoicing and financials. Any suggested design >> approaches >> to achieve this? I am thinking of a cron job to dump the order data >> from up >> stream system using some standard EDI format and update Ofbiz order >> tables. >> Once fulfilled do the same other way around. That still leaves the >> situation >> where changes are made on both systems which may conflict. >> >> Thanks in advance >> - Aray >> -- >> View this message in context: >> http://www.nabble.com/Order-Manager---Audit-trail-tp24922448p24922448.html >> Sent from the OFBiz - User mailing list archive at Nabble.com. >> > > > -- View this message in context: http://www.nabble.com/Order-Manager---Audit-trail-tp24922448p25005258.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: is compile and ofbiz restart still needed for java changes?
Hi Ruth - I am compiling at the component level. Ruth Hoffman-2 wrote: > > Hi Jacques: > True, but I have found that many times Java is the preferable way to go. > That said, I wonder, Chris, are you building (running ant) at the > component level? If so, then I wonder why it would take that long. If > you build at the root level, yes, that is a pain. But locally in the > component...that, to me is worth the small amount of time it takes build > and restart. > Just my 2 cents. > Ruth > Jacques Le Roux wrote: >> OFBiz has been conceived with this idea in mind. I mean reducing the >> need to restart the server. That's one of the reason why the minilang >> exists... >> >> Jacques >> >> From: "snowc" >>> Although I much prefer editing java over bsh, I keep finding myself >>> using bsh >>> over java to overcome the lengthy compile/restart cycle (similar to the >>> problem with fat ejb versus thin pojo development). Is there a way to >>> reduce this cycle? >>> >>> >>> jacques.le.roux wrote: As long as you modify Java code, you will still need to compile, hence to stop and restart the server (else you get a conflict on jars used when compiling) Jacques From: "snowc" > > Everytime I make a change to java code, I run "ant" and then > restart the > ofbiz service to pick up the changes. > > Is this still necessary? I am running r4.0. What about 9.04 > -- > View this message in context: > http://www.nabble.com/is-compile-and-ofbiz-restart-still-needed-for-java-changes--tp24971472p24971472.html > > > Sent from the OFBiz - User mailing list archive at Nabble.com. > >>> >>> -- >>> View this message in context: >>> http://www.nabble.com/is-compile-and-ofbiz-restart-still-needed-for-java-changes--tp24971472p24971811.html >>> >>> >>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>> >> >> >> > > > -- View this message in context: http://www.nabble.com/is-compile-and-ofbiz-restart-still-needed-for-java-changes--tp24971472p25005031.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Importing products from another database
Hello Asgaut, In order to import the product data, you need to focus on two things.. First, study which tables and columns are used by OFBiz in order to add a product to the database. Also, which fields are mandatory in those tables. Secondly, study all the data, which need to be imported and available to you (by your client). Once you study all that.. you have to create the XML files, containing all the import data. Now you can import the newly created xml file(s) to the OFBiz database from web tools. Hint: You can also create xml files with desired import data using sql queries. That was just the overview to implement the task. If you need any further support on how to do this in detail, please feel free to email us at of...@palinfocom.net -- Best regards, Ajay Sodhi Software Engineer, Pal InfoCom Technologies (P) Ltd., Mohali - India Marketing office - Portland (USA) Phone: +91-172-461-8033 Email: a...@palinfocom.net Skype: ajay.palinfocom Website: http://www.PalInfoCom.net/ ** Web, wireless & SMS enabled applications development & maintenance ** Ofbiz enterprise solution implementation ** Offshore project management Asgaut Mjølne wrote: > > Thanks, we were looking at attributes too. > > Do you have a recipe of how to create a product with attributes and > everything else that relates to it? What tables are necessary and so > forth. > We need this in order to write some code that import and map products from > another database. > > Sorry if I am asking basic questions but I am new to OFBiz :) > > Asgaut Mjølne > > > > Vince Clark wrote: >> >> We have researched integrating with publisher catalog feeds such as >> Ingram. >> >> If I recall correctly we were planning on using attributes pretty >> heavily, and standardizing on attribute names like AUTHOR, CONTRIBUTOR, >> etc. For identifiers like ISBN use the Good Identifiers tab in Product. >> >> >> Vince Clark >> www.globalera.com >> vcl...@globalera.com >> (303) 493-6723 office >> (303) 523-4843 cell >> >> >> - Original Message - >> From: "Asgaut Mjølne" >> To: user@ofbiz.apache.org >> Sent: Friday, August 14, 2009 5:42:32 AM GMT -07:00 US/Canada Mountain >> Subject: Importing products from another database >> >> >> We are creating a e-commerce book store solution with OFBiz and need to >> import product data from another database. >> >> There will be columns such as ISBN, author, publishing house and so on. >> They >> are present in a great number of book store, non-generic tables. >> >> How can we import/map these data into the generic data model of OFBiz >> most >> efficiently? >> >> >> Thanks. >> >> >> Asgaut Mjølne >> -- >> View this message in context: >> http://www.nabble.com/Importing-products-from-another-database-tp24970374p24970374.html >> Sent from the OFBiz - User mailing list archive at Nabble.com. >> >> >> > > -- View this message in context: http://www.nabble.com/Importing-products-from-another-database-tp24970374p25004466.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Trying to access OFBiz web service through an external java client.
Hi,
I am trying to access OFBiz web service through an external java client.
I have created a service in OFBiz with parameter export="true". I get the
wsdl file generated successfully.
But when I try to access the service using client, I get the following
exception:
Aug 17, 2009 12:47:52 PM org.apache.axis.utils.JavaUtils
isAttachmentSupported
WARNING: Unable to find required classes (javax.activation.DataHandler and
javax.mail.internet.MimeMultipart). Attachment support is disabled.
javax.xml.rpc.ServiceException: Error processing WSDL document:
javax.xml.rpc.ServiceException: Error processing WSDL document:
javax.xml.rpc.ServiceException: Cannot find service: test
at org.apache.axis.client.Service.initService(Service.java:250)
at org.apache.axis.client.Service.(Service.java:165)
at org.apache.axis.client.ServiceFactory.createService(
ServiceFactory.java:198)
at NewClient.main(NewClient.java:26)
My client class code is:
public class Client {
public static void main(String args[]){
String wsdlURL =
"http://localhost:8088/webtools/control/SOAPService/test?wsdl";;
String namespace = "";
String serviceName = "test";
QName serviceQN = new QName(namespace, serviceName);
ServiceFactory serviceFactory;
try {
serviceFactory = ServiceFactory.newInstance();
Service service = serviceFactory.createService(new
URL(wsdlURL), serviceQN);
} catch (MalformedURLException e) {
e.printStackTrace();
} catch (ServiceException e) {
e.printStackTrace();
}
}
}
I have also included the jar files required to run the client as mentioned
below:
axis.jar
jaxrpc.jar
commons-logging-1.1.1.jar
wsdl4j-1.5.1.jar
saaj.jar
webserviceutils.jar
commonsdiscovery-0.2.jar
I tried the same thing using C# client,but got the same problem.I feel
that the OFBiz wsdl gets created in such a way that it does not get
exposed to external client. Kindly let me know the reason of the
exception.Is the way i am following, correct? Also, if there is some other
way to do the task.
Thanks & Regards,
Neha Mehta
Software Engineer (A-1-1)
Larsen & Toubro Infotech Ltd.
__
Re: OFBiz Content Management System.
From: "Bravo Pal" Friends, I've some questions on OFBiz CMS : 1. Is OFBiz CMS can be used as Central Document Management repository where user can perform operation like(Check in, Checkout etc.)? Not exactly, especially regarding concurrency. You maybe interested by this discussion http://markmail.org/thread/3iqhk47m6oriopr3 1. Purpose of CompDoc sub module of Content module ? To create specific composite documents based on "primitive" content types 2. Is OFBiz CMS provide file tracking facility ? Same anser than 1 Jacques Waiting for any response. Thanks, Bravo Pal.
Re: product hierarchies
Hi Ruth, Please feel free to use this as an example. I have some more information to follow later... Many thanks, Chris Ruth Hoffman-2 wrote: > > Hi Chris: > Quick answer and MHO would be as follows (and I'm hardly an expert on > this, so others, feel free to chime in): > snowc wrote: >> Hi Ruth, >> >> When a vehicle is received, they would like to book the vehicle and each >> of >> it's main components (Engine, Gearbox, Axles, Body, Etc) into stock: >> >> Vehicle (e.g. StockRef[ABC123] Make[Volvo] Model[F10] Type[4x2 TU] >> Year[2000]) >> |- Engine (e.g. ModelId[400E34]) >> |- Gearbox (e.g. ModelId[5206B]) >> |- Etc >> >> Vehicle (e.g. StockRef[ABC234] Make[Ford] Model[Escort] Type[Sedan] >> Year[1985]) >> |- Engine (e.g. ModelId[231AA]) >> |- Gearbox (e.g. ModelId[345BB]) >> |- Etc >> >> When the vehicle is received whole, the component locations will be the >> same >> as the vehicle location. However, when broken, the individual components >> locations will be different. >> >> The customer would like to be able to answer customer enquiries such as: >> "Do >> you have any Ford Escort engines (model 231AA) in stock?". >> >> The customer would like to also list all stock (vehicle and components) >> on >> their website. They do not want ecommerce cart, just a list of available >> stock. >> >> I think I can maybe model the relationship between the vehicle and >> component >> as associations, e.g.: >> >> Engine (StockRef[231AA]) is an "Actual Product Component" of Vehicle >> (StockRef[ABC234]) >> >> >> Does this relationship make sense? >> >> > Yes. Here is my reasoning: Since you want to track and list major > components as entities separate from their source - a vehicle, I think > both the vehicle and each of the major components that you want to track > are "PRODUCTS". The productID could be the StockRef# or VIN depending on > the item (since I don't think gear boxes have VINs?). > > Then, for browsing (and tracking) purposes you could create one or more > product associations (bundles) so that an engine (StockRef#/VIN, > facilityID=still in the vehicle) may be associated with a vehicle (with > stockref #/VIN, facilityId = sitting on back lot) and a gearbox (with > stockref #, facilityId = building 10, shelf 2) may be associated with a > vehicle etc. You could even have categories set up to just show gear > boxes (as products) or entire vehicles. > > So, without actually trying this out with some test data, I can't really > say if it would work exactly as you envision. [if you don't mind I'd > like to use something like this example in the book since, as of today, > I don't really talk much about product associations. This would be a > great use-case.] >> For storing the attibutes such as make, model, year would feature be the >> best way? For example, if I create a feature hierarchy: >> >> Make (E.g. Ford) >> | - Model (e.g. Escort) >> >> I would also create a feature group for each Make/Model combination to >> constrain the allowed make model combinations. >> >> > Exactly how I would do it. > I like to keep things as simple as possible. And so, maybe I'm missing > something here - but I think that is all you need to do. Maybe someone > who has lots of experience with product data modeling and OFBiz could > comment? >> Does the above approach make sense? >> >> Many thanks in advance... >> >> >> >> >> Ruth Hoffman-2 wrote: >> >>> Just curious - do they only want to list configurations (like inventory) >>> or do they intend to sell either the vehicles or parts thereof? >>> Ruth >>> BJ Freeman wrote: >>> yes. Could do it OOTB but a lot of data entry. Look at the PC configure for Ideas. https://demo.ofbiz.org/catalog/control/EditProductConfigs?productId=PC001 Customization would let them build a library of car models then it would automatically build the products. snowc sent the following on 8/7/2009 12:14 PM: > I have some customers that break second hand cars and trucks. When > they > receive a vehicle for breaking, they would like to enter the vehicle > into > ofbiz and also input the major components that the vehicle can be > broken > into. The whole vehicle and the major components will be listed on > the > ecommerce site. > > Is this possible? how? > > Many thank in advance... > > >>> >>> >> >> > > > -- View this message in context: http://www.nabble.com/product-hierarchies-tp24870315p25003579.html Sent from the OFBiz - User mailing list archive at Nabble.com.
