Re: OFBiz in Canada?
On Nov 12, 2009, at 7:34 AM, Christopher Snow wrote: Ofbiz community seems to be focused on making ofbiz generate as much consulting revenue as possible and not on making ofbiz a great shrink wrapped product. For example, end users having to use svn and patches so to keep their systems up to date is crazy. I don't think that the focus of the OFBiz community is to make OFBiz a consulting revenue generator, nor I think that the absence of a stable recent release is a consequence of this. The awful truth, imo, is that maintaining a release is expensive (in terms of man hours) and the time contributed by the users of OFBiz (i.e. its community made of final users, consultants etc...) until now has not been enough to have a good release plan. Jacopo
Re: PaymentUtil class
Hi Abdullah, I suggest you create a Jira and upload a patch for review http://docs.ofbiz.org/display/OFBADMIN/OFBiz+Contributors+Best+Practices Thanks Jacques From: Abdullah Shaikh abdullah.sha...@viithiisys.com Anyone... ? I think the util class should be named PaymentGatewayUtil instead of PaymentUtil On Sun, Nov 8, 2009 at 10:34 PM, Abdullah Shaikh abdullah.sha...@viithiisys.com wrote: Can we have a class which will provide utility methods which can be used when implementing a payment gateway, I guess this will help in code redundancy, to make code more readable and maybe more. Currently the thing that we can put in PaymentUtil, can be methods to create payment gateway responses, as below, toAuthorisationMap((Boolean authResult, String authCode, String authFlag, BigDecimal processAmount, String authRefNum, String authAltRefNum, String authMessage) toCaptureMap(Boolean captureResult, String captureCode, String captureFlag, BigDecimal captureAmount, String captureRefNum, String captureAltRefNum, String captureMessage) . same for other responses This method will create the map from parameters and return the map back, this will help in reducing the code (map creation code) as we will be implementing more more payment gateways, right now we have 9 implemented, so instead of creating the map manually we can have this utility method. And as the payment gateway response fields are not dynamic, I mean they are restricted to only the fields defined in processAuthResult service, I guess this will help. I have already implemented this class for use in implementing payment gateway that I am using. Please let me know your thoughts.
Re: OFBiz in Canada?
Are you saying that there are now enough contributors to implement a good release plan? Many thanks, Chris Jacopo Cappellato wrote: On Nov 12, 2009, at 7:34 AM, Christopher Snow wrote: Ofbiz community seems to be focused on making ofbiz generate as much consulting revenue as possible and not on making ofbiz a great shrink wrapped product. For example, end users having to use svn and patches so to keep their systems up to date is crazy. I don't think that the focus of the OFBiz community is to make OFBiz a consulting revenue generator, nor I think that the absence of a stable recent release is a consequence of this. The awful truth, imo, is that maintaining a release is expensive (in terms of man hours) and the time contributed by the users of OFBiz (i.e. its community made of final users, consultants etc...) until now has not been enough to have a good release plan. Jacopo
Re: OFBiz4.0 clustering,session replication, failover and load balancing - Howto
Hi Carsten, Culd you please elaborate upon your statement,Are you sure you copied over the very same workers.properties (the config for mod_jk) ? ? I could not understand it well... Here are my configuration files.. workers.properties worker.worker2.port=8006 worker.worker2.host=172.17.88.196 worker.worker2.type=ajp13 worker.worker2.lbfactor=100 worker.worker2.redirect=worker1 worker.worker1.port=8009 worker.worker1.host=172.17.88.52 worker.worker1.type=ajp13 worker.worker1.lbfactor=1 worker.worker1.redirect=worker2 worker.list=worker1, worker2, loadbalancer worker.loadbalancer.type=lb worker.loadbalancer.balanced_workers=worker1, worker2 httpd.conf : LoadModule jk_module modules/mod_jk.so JkWorkersFile conf/workers.properties JkShmFile logs/mod_jk.shm JkLogFile logs/mod_jk.log JkLogLevelinfo JkLogStampFormat [%a %b %d %H:%M:%S %Y] httpd-vhosts.conf --- i have used virtual hosting for switching of application between secured and non-secured ports. VirtualHost *:80 ServerName 172.17.88.52:80 JkMount /* loadbalancer JkMount /*/control/* loadbalancer /VirtualHost On windows, everything is working great along with session replication. If i have OFBiz code base on linux servers and APache Http Server on windows, even then all works fine But if i have APache http server on linux, it does not connect to OFBiz server. I am not able to find the problem . Please help me out, i am stuck up here... Thanks Regards, Neha Mehta __
Re: OFBiz in Canada?
Yes we need more solid teams, this is improving... Jacques From: Christopher Snow sno...@snowconsulting.co.uk Are you saying that there are now enough contributors to implement a good release plan? Many thanks, Chris Jacopo Cappellato wrote: On Nov 12, 2009, at 7:34 AM, Christopher Snow wrote: Ofbiz community seems to be focused on making ofbiz generate as much consulting revenue as possible and not on making ofbiz a great shrink wrapped product. For example, end users having to use svn and patches so to keep their systems up to date is crazy. I don't think that the focus of the OFBiz community is to make OFBiz a consulting revenue generator, nor I think that the absence of a stable recent release is a consequence of this. The awful truth, imo, is that maintaining a release is expensive (in terms of man hours) and the time contributed by the users of OFBiz (i.e. its community made of final users, consultants etc...) until now has not been enough to have a good release plan. Jacopo
Re: OFBiz in Canada?
Not having a stable release is certainly a hindrance in OFBiz adapter. Even though we have release branch, there is no released binaries which runs without development time tool chain. I can commit my time to: 1. Write ant target/Maven goals to create a binary only release. 2. Write an nice looking installer to install OFBiz with few mouse clicks. Thanks, Raj Jacques Le Roux wrote: From: Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com On Nov 12, 2009, at 7:34 AM, Christopher Snow wrote: Ofbiz community seems to be focused on making ofbiz generate as much consulting revenue as possible and not on making ofbiz a great shrink wrapped product. For example, end users having to use svn and patches so to keep their systems up to date is crazy. I don't think that the focus of the OFBiz community is to make OFBiz a consulting revenue generator, nor I think that the absence of a stable recent release is a consequence of this. The awful truth, imo, is that maintaining a release is expensive (in terms of man hours) and the time contributed by the users of OFBiz (i.e. its community made of final users, consultants etc...) until now has not been enough to have a good release plan. Jacopo I totally agree with Jacopo, BTW it's a well known fact in the OFBiz community which has been repeated many times on this ML. Though this is slowly improving... Jacques
Re: OFBiz in Canada?
Chris, it is just a matter of priorities most of the time driven by end customers. At least here, customers want certain features like reporting and SFA and want to know how the system works. We are creating the help files and a general OFBiz document generated from that. We also use the newer functions like email, myportal, selenium, ebay, Birt which are not fully available in the older releases and we enhance the system all the time. On the Antwebsystems.com system we install a new trunk version very frequently. We know very quickly if a version is stable, when not we go back or fix the problem as quick as we can. We use that experience for our customer sites. So for us, a shrink wrapped or older version we will not use, not for us and not for our customers and therefore have less interest creating or maintaining it. Regards, Hans On Thu, 2009-11-12 at 06:34 +, Christopher Snow wrote: Hi Ruth, I think there are two main issues which slow the adoption of ofbiz: 1 - lack of quality documentation 2 - the community focus The problem with the lack of quality documentation is well known and needs no further discusssion. In my experience, there is a problem with the ofbiz community focus. Communities such as those surrounding ubuntu and adempiere seem to be focused on making the product the best it can possibly be. Ofbiz community seems to be focused on making ofbiz generate as much consulting revenue as possible and not on making ofbiz a great shrink wrapped product. For example, end users having to use svn and patches so to keep their systems up to date is crazy. Also, end users typically want stability, yet the advice on the mailing lists is to Ofbiz to use trunk. I will say though that help on the mailing lists is fantastic (even if the same questions are answered over-and-over again due to the lack of documentation). I think that until the above issues are resolved, adoption of this fantastic framework will be slow. Cheers, Chris Ruth Hoffman wrote: Hi Chris: Thanks for the info and the endorsement. One question: Do you consider long term operational costs (support and maintenance) when you bid a job? I'm trying to understand if there is any value in a single OFBiz solution vs. supporting multiple applications/databases. Or is that something that your client's don't really care about? Do you have any thoughts on that? re: Job boards. It is true that OFBiz doesn't seem to get much air time. Ok, truth be told - here in the US - I don't think I've ever seen a job requirement for OFBiz. I certainly would be the first to respond to opportunities for OFBiz integrator/developers if I ever saw any. Writing books does not pay very well :-( I think the only thing that will cure this is time. The more new adopters we get, the more likely OFBiz will be brought into the enterprise and become mainstream. And then the secret will be out and everyone will be salivating all over it - just like the do with Spring and Hibernate. Regards, Ruth Christopher Snow wrote: Hi Ruth, I spend a lot of time learning. I am learning new systems all the time and to date I have implemented a multitude of opensource solutions . I enjoy learning, I enjoy new technologies. The knowledge I need I normally get from reading books. I have found that it is just not cost effective (i.e. time effective) to try to learn from trial and error, reading wikis or studying source code. I normally do not attend training courses because I can't afford the lost consulting time. Ebooks are great, you can print out a chapter, stick it in your back pocket and read it waiting for a train. In my mind, the best thing that has made ofbiz accessible to me are your books and the book from Jonathon Wong. Unfortunately these resources cover maybe 10% of the total knowledge needed to implement ofbiz. When looking at returns, as a contractor, I usually notice what skills the UK job boards are asking for. I have seen a few jobs recently asking for adempiere and compiere skills. I have not seen many jobs requiring ofbiz skills, but I do have a number of small companies that want bespoke enterprise application development that suits the ofbiz framework. As for investment cost: Adempiere functional implementation: ebook cost* - £20. Time to read - 40 hours. *http://www.packtpub.com/adempiere-3-4-erp-solutions/book Ofbiz functional implementation: training cost , additional time to learn from wiki, source code etc - 300 hours (this is a wild guess). Cheers, Chris Ruth Hoffman wrote: Hello Christopher: I'm wondering, since I've never had to use the OFBiz accounting features to run a business, if you have analyzed the ROI on learning and supporting another platform and software application such as OpenBravo vs. dealing with the
Re: OFBiz in Canada?
So it's the chicken-and-egg situtation? There are not enough contributors to focus on making stable releases and documentation. But without stable releases and documentation, new contributors are not attracted to ofbiz. Jacques Le Roux wrote: Yes we need more solid teams, this is improving... Jacques From: Christopher Snow sno...@snowconsulting.co.uk Are you saying that there are now enough contributors to implement a good release plan? Many thanks, Chris Jacopo Cappellato wrote: On Nov 12, 2009, at 7:34 AM, Christopher Snow wrote: Ofbiz community seems to be focused on making ofbiz generate as much consulting revenue as possible and not on making ofbiz a great shrink wrapped product. For example, end users having to use svn and patches so to keep their systems up to date is crazy. I don't think that the focus of the OFBiz community is to make OFBiz a consulting revenue generator, nor I think that the absence of a stable recent release is a consequence of this. The awful truth, imo, is that maintaining a release is expensive (in terms of man hours) and the time contributed by the users of OFBiz (i.e. its community made of final users, consultants etc...) until now has not been enough to have a good release plan. Jacopo
Re: Currency UOM
Hello Prabhakaran, Go to webtools and edit the entity PartyAcctgPreference by setting its baseCurrencyUomId to INR. Thanks and Regards Santosh Malviya On Thu, Nov 12, 2009 at 2:08 PM, Prabhakaran Duraisamy prabhaka...@formativesolutions.co.in wrote: Hi Santhosh Sorry I cant get you Can Explain detail On Thu, Nov 12, 2009 at 12:17 PM, Santosh Malviya santosh.of...@gmail.comwrote: Hi Prabhakaran, Default currencyUom is USD so you have to change it to INR and this is not possible throuth UI because Accounting Preference in accounting component is not editable mode due to some reason, so you can change it manually by going to entity PartyAcctgPreference. Thanks and Regards Santosh Malviya On Thu, Nov 12, 2009 at 11:00 AM, Prabhakaran Duraisamy prabhaka...@formativesolutions.co.in wrote: Hi while I am trying BOM Simulation in Manufacturins Bill of Matrials if Selected INR - Indian Rupee following error is occured How can i resolve this Error in simple-method [Convert UOM values [file:/D:/ofbiz/framework/common/script/org/ofbiz/common/CommonServices.xml#convertUom]]: ; [UOM Conversion Relationship Not Found]) pls give Suggestion for this -- Regards, Prabhakaran.D +91 99 520 93 900 -- Regards, Prabhakaran.D +91 99 520 93 900
Re: OFBiz in Canada?
From: Christopher Snow sno...@snowconsulting.co.uk So it's the chicken-and-egg situtation? No : it's improving and the curve is not exponential nor even quadratic but is more than flat. Actually this is very clear since we released 9.04 And maybe the new effort which may happend on SME will increase even more this curve http://markmail.org/thread/whm4uqjhcvwz6pvp Jacques There are not enough contributors to focus on making stable releases and documentation. But without stable releases and documentation, new contributors are not attracted to ofbiz. Jacques Le Roux wrote: Yes we need more solid teams, this is improving... Jacques From: Christopher Snow sno...@snowconsulting.co.uk Are you saying that there are now enough contributors to implement a good release plan? Many thanks, Chris Jacopo Cappellato wrote: On Nov 12, 2009, at 7:34 AM, Christopher Snow wrote: Ofbiz community seems to be focused on making ofbiz generate as much consulting revenue as possible and not on making ofbiz a great shrink wrapped product. For example, end users having to use svn and patches so to keep their systems up to date is crazy. I don't think that the focus of the OFBiz community is to make OFBiz a consulting revenue generator, nor I think that the absence of a stable recent release is a consequence of this. The awful truth, imo, is that maintaining a release is expensive (in terms of man hours) and the time contributed by the users of OFBiz (i.e. its community made of final users, consultants etc...) until now has not been enough to have a good release plan. Jacopo
Re: OFBiz in Canada?
Hi Raj, This would be surely very appreciated! BTW what about OFBIZ-1560 ;o) Jacques From: Raj Saini rajsa...@gmail.com Not having a stable release is certainly a hindrance in OFBiz adapter. Even though we have release branch, there is no released binaries which runs without development time tool chain. I can commit my time to: 1. Write ant target/Maven goals to create a binary only release. 2. Write an nice looking installer to install OFBiz with few mouse clicks. Thanks, Raj Jacques Le Roux wrote: From: Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com On Nov 12, 2009, at 7:34 AM, Christopher Snow wrote: Ofbiz community seems to be focused on making ofbiz generate as much consulting revenue as possible and not on making ofbiz a great shrink wrapped product. For example, end users having to use svn and patches so to keep their systems up to date is crazy. I don't think that the focus of the OFBiz community is to make OFBiz a consulting revenue generator, nor I think that the absence of a stable recent release is a consequence of this. The awful truth, imo, is that maintaining a release is expensive (in terms of man hours) and the time contributed by the users of OFBiz (i.e. its community made of final users, consultants etc...) until now has not been enough to have a good release plan. Jacopo I totally agree with Jacopo, BTW it's a well known fact in the OFBiz community which has been repeated many times on this ML. Though this is slowly improving... Jacques
Re: Currency UOM
Hi Santhosh , I did the Same But Same Error On Thu, Nov 12, 2009 at 3:16 PM, Santosh Malviya santosh.of...@gmail.comwrote: Hello Prabhakaran, Go to webtools and edit the entity PartyAcctgPreference by setting its baseCurrencyUomId to INR. Thanks and Regards Santosh Malviya On Thu, Nov 12, 2009 at 2:08 PM, Prabhakaran Duraisamy prabhaka...@formativesolutions.co.in wrote: Hi Santhosh Sorry I cant get you Can Explain detail On Thu, Nov 12, 2009 at 12:17 PM, Santosh Malviya santosh.of...@gmail.comwrote: Hi Prabhakaran, Default currencyUom is USD so you have to change it to INR and this is not possible throuth UI because Accounting Preference in accounting component is not editable mode due to some reason, so you can change it manually by going to entity PartyAcctgPreference. Thanks and Regards Santosh Malviya On Thu, Nov 12, 2009 at 11:00 AM, Prabhakaran Duraisamy prabhaka...@formativesolutions.co.in wrote: Hi while I am trying BOM Simulation in Manufacturins Bill of Matrials if Selected INR - Indian Rupee following error is occured How can i resolve this Error in simple-method [Convert UOM values [file:/D:/ofbiz/framework/common/script/org/ofbiz/common/CommonServices.xml#convertUom]]: ; [UOM Conversion Relationship Not Found]) pls give Suggestion for this -- Regards, Prabhakaran.D +91 99 520 93 900 -- Regards, Prabhakaran.D +91 99 520 93 900 -- Regards, Prabhakaran.D +91 99 520 93 900
Re: OFBiz in Canada?
Christopher, Sorry this is maybe a bit a technical answer, but I believe it shows another mindset One of the causes, which is maybe hidden for philosophical and pragmatical reasons, is that we (should) always use RTC mode (Review-Then-Commit) For more on this apect you could be interested by http://old.nabble.com/Review-Then-Commit-td26303921.html To commiters : this does not mean that I'm pushing for CTR mode, only that it's interesting to see how other communities are doing and reactions about that ;o) Jacques From: Jacques Le Roux jacques.le.r...@les7arts.com From: Christopher Snow sno...@snowconsulting.co.uk So it's the chicken-and-egg situtation? No : it's improving and the curve is not exponential nor even quadratic but is more than flat. Actually this is very clear since we released 9.04 And maybe the new effort which may happend on SME will increase even more this curve http://markmail.org/thread/whm4uqjhcvwz6pvp Jacques There are not enough contributors to focus on making stable releases and documentation. But without stable releases and documentation, new contributors are not attracted to ofbiz. Jacques Le Roux wrote: Yes we need more solid teams, this is improving... Jacques From: Christopher Snow sno...@snowconsulting.co.uk Are you saying that there are now enough contributors to implement a good release plan? Many thanks, Chris Jacopo Cappellato wrote: On Nov 12, 2009, at 7:34 AM, Christopher Snow wrote: Ofbiz community seems to be focused on making ofbiz generate as much consulting revenue as possible and not on making ofbiz a great shrink wrapped product. For example, end users having to use svn and patches so to keep their systems up to date is crazy. I don't think that the focus of the OFBiz community is to make OFBiz a consulting revenue generator, nor I think that the absence of a stable recent release is a consequence of this. The awful truth, imo, is that maintaining a release is expensive (in terms of man hours) and the time contributed by the users of OFBiz (i.e. its community made of final users, consultants etc...) until now has not been enough to have a good release plan. Jacopo
Re: OFBiz in Canada?
Unrelated: +1 thread hijack :P Back to the discussed matter: As a programmer, I'd be interested to know more about how I can help. I'm not really used to open-source projects, but I'm going to have to implement this solution for my company. Which is why I want to find other Canadian (preferably Quebec) users, and lend a hand if possible. What would I need to know to participate? Olivier Le 2009-11-12 à 06:20, Jacques Le Roux a écrit : Christopher, Sorry this is maybe a bit a technical answer, but I believe it shows another mindset One of the causes, which is maybe hidden for philosophical and pragmatical reasons, is that we (should) always use RTC mode (Review- Then-Commit) For more on this apect you could be interested by http://old.nabble.com/Review-Then-Commit-td26303921.html To commiters : this does not mean that I'm pushing for CTR mode, only that it's interesting to see how other communities are doing and reactions about that ;o) Jacques From: Jacques Le Roux jacques.le.r...@les7arts.com From: Christopher Snow sno...@snowconsulting.co.uk So it's the chicken-and-egg situtation? No : it's improving and the curve is not exponential nor even quadratic but is more than flat. Actually this is very clear since we released 9.04 And maybe the new effort which may happend on SME will increase even more this curve http://markmail.org/thread/whm4uqjhcvwz6pvp Jacques There are not enough contributors to focus on making stable releases and documentation. But without stable releases and documentation, new contributors are not attracted to ofbiz. Jacques Le Roux wrote: Yes we need more solid teams, this is improving... Jacques From: Christopher Snow sno...@snowconsulting.co.uk Are you saying that there are now enough contributors to implement a good release plan? Many thanks, Chris Jacopo Cappellato wrote: On Nov 12, 2009, at 7:34 AM, Christopher Snow wrote: Ofbiz community seems to be focused on making ofbiz generate as much consulting revenue as possible and not on making ofbiz a great shrink wrapped product. For example, end users having to use svn and patches so to keep their systems up to date is crazy. I don't think that the focus of the OFBiz community is to make OFBiz a consulting revenue generator, nor I think that the absence of a stable recent release is a consequence of this. The awful truth, imo, is that maintaining a release is expensive (in terms of man hours) and the time contributed by the users of OFBiz (i.e. its community made of final users, consultants etc...) until now has not been enough to have a good release plan. Jacopo
Re: OFBiz in Canada?
Hi Olivier, Try this link to give you an idéa: http://docs.ofbiz.org/display/OFBADMIN/OFBiz+Contributors+Best+Practices -André Unrelated: +1 thread hijack :P Back to the discussed matter: As a programmer, I'd be interested to know more about how I can help. I'm not really used to open-source projects, but I'm going to have to implement this solution for my company. Which is why I want to find other Canadian (preferably Quebec) users, and lend a hand if possible. What would I need to know to participate? Olivier Le 2009-11-12 à 06:20, Jacques Le Roux a écrit : Christopher, Sorry this is maybe a bit a technical answer, but I believe it shows another mindset One of the causes, which is maybe hidden for philosophical and pragmatical reasons, is that we (should) always use RTC mode (Review- Then-Commit) For more on this apect you could be interested by http://old.nabble.com/Review-Then-Commit-td26303921.html To commiters : this does not mean that I'm pushing for CTR mode, only that it's interesting to see how other communities are doing and reactions about that ;o) Jacques From: Jacques Le Roux jacques.le.r...@les7arts.com From: Christopher Snow sno...@snowconsulting.co.uk So it's the chicken-and-egg situtation? No : it's improving and the curve is not exponential nor even quadratic but is more than flat. Actually this is very clear since we released 9.04 And maybe the new effort which may happend on SME will increase even more this curve http://markmail.org/thread/whm4uqjhcvwz6pvp Jacques There are not enough contributors to focus on making stable releases and documentation. But without stable releases and documentation, new contributors are not attracted to ofbiz. Jacques Le Roux wrote: Yes we need more solid teams, this is improving... Jacques From: Christopher Snow sno...@snowconsulting.co.uk Are you saying that there are now enough contributors to implement a good release plan? Many thanks, Chris Jacopo Cappellato wrote: On Nov 12, 2009, at 7:34 AM, Christopher Snow wrote: Ofbiz community seems to be focused on making ofbiz generate as much consulting revenue as possible and not on making ofbiz a great shrink wrapped product. For example, end users having to use svn and patches so to keep their systems up to date is crazy. I don't think that the focus of the OFBiz community is to make OFBiz a consulting revenue generator, nor I think that the absence of a stable recent release is a consequence of this. The awful truth, imo, is that maintaining a release is expensive (in terms of man hours) and the time contributed by the users of OFBiz (i.e. its community made of final users, consultants etc...) until now has not been enough to have a good release plan. Jacopo
Re: OFBiz in Canada?
From: Olivier Tremblay oliviertrembla...@gmail.com Unrelated: +1 thread hijack :P Yes, but if you read it all you will find that some ideas there matter and are related to the subject Chris submitted This said, sorry for the thread hijack but it was Chris's actually ;o) Jacques Back to the discussed matter: As a programmer, I'd be interested to know more about how I can help. I'm not really used to open-source projects, but I'm going to have to implement this solution for my company. Which is why I want to find other Canadian (preferably Quebec) users, and lend a hand if possible. What would I need to know to participate? Olivier Le 2009-11-12 à 06:20, Jacques Le Roux a écrit : Christopher, Sorry this is maybe a bit a technical answer, but I believe it shows another mindset One of the causes, which is maybe hidden for philosophical and pragmatical reasons, is that we (should) always use RTC mode (Review- Then-Commit) For more on this apect you could be interested by http://old.nabble.com/Review-Then-Commit-td26303921.html To commiters : this does not mean that I'm pushing for CTR mode, only that it's interesting to see how other communities are doing and reactions about that ;o) Jacques From: Jacques Le Roux jacques.le.r...@les7arts.com From: Christopher Snow sno...@snowconsulting.co.uk So it's the chicken-and-egg situtation? No : it's improving and the curve is not exponential nor even quadratic but is more than flat. Actually this is very clear since we released 9.04 And maybe the new effort which may happend on SME will increase even more this curve http://markmail.org/thread/whm4uqjhcvwz6pvp Jacques There are not enough contributors to focus on making stable releases and documentation. But without stable releases and documentation, new contributors are not attracted to ofbiz. Jacques Le Roux wrote: Yes we need more solid teams, this is improving... Jacques From: Christopher Snow sno...@snowconsulting.co.uk Are you saying that there are now enough contributors to implement a good release plan? Many thanks, Chris Jacopo Cappellato wrote: On Nov 12, 2009, at 7:34 AM, Christopher Snow wrote: Ofbiz community seems to be focused on making ofbiz generate as much consulting revenue as possible and not on making ofbiz a great shrink wrapped product. For example, end users having to use svn and patches so to keep their systems up to date is crazy. I don't think that the focus of the OFBiz community is to make OFBiz a consulting revenue generator, nor I think that the absence of a stable recent release is a consequence of this. The awful truth, imo, is that maintaining a release is expensive (in terms of man hours) and the time contributed by the users of OFBiz (i.e. its community made of final users, consultants etc...) until now has not been enough to have a good release plan. Jacopo
Re: Help required about custom service and transactions
Hi Cimballi, TransactionUtil.rollback(boolean beganTransaction, String causeMessage, Throwable causeThrowable) will be your friend here. On passing beganTrasaction value to tru it will rollback the current thread transactions. Rishi Solanki Enterprise Software Developer HotWax Media Pvt. Ltd. On Thu, Nov 12, 2009 at 5:19 AM, Cimballi cimba...@cimballi.net wrote: Hi, I have developed several custom services and I encounter a problem with transactions. My service is calling other services and I notice that when a first service successed, but a second failed, the data of the first service has not been rolled back. Example : - First, I call createPersonAndUserLogin using dispatcher.runSync - Second, I call createPartyRole using dispatcher.runSync The second call failed because I didn't provide all parameters, but the party created in the first call is still there. Is there a way to avoid this, to have a transaction covering all runSync calls ? Thanks, Cimballi
Re: OFBiz in Canada?
Yes, I take the credit for the hijack! Jacques Le Roux wrote: From: Olivier Tremblay oliviertrembla...@gmail.com Unrelated: +1 thread hijack :P Yes, but if you read it all you will find that some ideas there matter and are related to the subject Chris submitted This said, sorry for the thread hijack but it was Chris's actually ;o) Jacques Back to the discussed matter: As a programmer, I'd be interested to know more about how I can help. I'm not really used to open-source projects, but I'm going to have to implement this solution for my company. Which is why I want to find other Canadian (preferably Quebec) users, and lend a hand if possible. What would I need to know to participate? Olivier Le 2009-11-12 à 06:20, Jacques Le Roux a écrit : Christopher, Sorry this is maybe a bit a technical answer, but I believe it shows another mindset One of the causes, which is maybe hidden for philosophical and pragmatical reasons, is that we (should) always use RTC mode (Review- Then-Commit) For more on this apect you could be interested by http://old.nabble.com/Review-Then-Commit-td26303921.html To commiters : this does not mean that I'm pushing for CTR mode, only that it's interesting to see how other communities are doing and reactions about that ;o) Jacques From: Jacques Le Roux jacques.le.r...@les7arts.com From: Christopher Snow sno...@snowconsulting.co.uk So it's the chicken-and-egg situtation? No : it's improving and the curve is not exponential nor even quadratic but is more than flat. Actually this is very clear since we released 9.04 And maybe the new effort which may happend on SME will increase even more this curve http://markmail.org/thread/whm4uqjhcvwz6pvp Jacques There are not enough contributors to focus on making stable releases and documentation. But without stable releases and documentation, new contributors are not attracted to ofbiz. Jacques Le Roux wrote: Yes we need more solid teams, this is improving... Jacques From: Christopher Snow sno...@snowconsulting.co.uk Are you saying that there are now enough contributors to implement a good release plan? Many thanks, Chris Jacopo Cappellato wrote: On Nov 12, 2009, at 7:34 AM, Christopher Snow wrote: Ofbiz community seems to be focused on making ofbiz generate as much consulting revenue as possible and not on making ofbiz a great shrink wrapped product. For example, end users having to use svn and patches so to keep their systems up to date is crazy. I don't think that the focus of the OFBiz community is to make OFBiz a consulting revenue generator, nor I think that the absence of a stable recent release is a consequence of this. The awful truth, imo, is that maintaining a release is expensive (in terms of man hours) and the time contributed by the users of OFBiz (i.e. its community made of final users, consultants etc...) until now has not been enough to have a good release plan. Jacopo
Re: Need a ofbiz teacher
Hi Zafaralikhan14: Please see my website: http://www.myofbiz.com. You will find instructions on purchasing the books and more information about each book's content. Regards, Ruth zafaralikhan14 wrote: Exalted Ruth Hoffman, Thanks for favorable reply 1. How can i get your written book(s)? 2. Is there any book + video ? Thanks again best regards On Wed, Nov 11, 2009 at 7:15 PM, Ruth Hoffman-2 [via OFBiz] ml-node+585970-821614...@n4.nabble.comml-node%2b585970-821614...@n4.nabble.com wrote: Hello Zafaralikhan14: I can't help you with Teamviewer, but I can offer that you read my books. They are targeted to new OFBiz end-users. Lots of screen shots and descriptive text on what you can expect with OFBiz OOTB. Then, I might suggest, if you are looking at developing software using the OFBiz framework, Jonathon Wong and Rupert Howell's excellent beginner's tutorial. Regards, Ruth Ruth Hoffman, Author, Mentor OFBiz Enthusiast [hidden email]http://n4.nabble.com/user/SendEmail.jtp?type=nodenode=585970i=0 Want to know more about OFBiz? Please visit my website: http://www.myofbiz.com zafaralikhan14 wrote: I need experience OfBiz teacher who can teach me via teamviewer Thanks best regards -- View message @ http://n4.nabble.com/Need-a-ofbiz-teacher-tp585963p585970.html To unsubscribe from Need a ofbiz teacher, click here (link removed) ==.
Re: OFBiz in Canada?
Well, regarding participation, we just had an excellent Talk about participating in open source - and guess what even more detailed: on ASF - projects here at W-JAX 2009 in Munich. It was especially of interest, since it drew a couple of examples what the motivation of people would be to participate. And you will not be surprised to see that a certain commercial interest is not unusual. However, the argument of critical mass being brought up above seems a little vague to me: What is actually the number of comitters / contributors required to switch into a good release plan? Any ideas? Is it dependant on the BUG statistics reported on JIRA? How many are they and how good are we contributors in fixing them? Are we currently building a backlog? Is it for trunk or for releases only? How are bug reports/bugs distributed across components? Is it possibly critical to have a certain number of committers per component? Back to the talk I mentioned: Once I have the slides, I will distribute the link across people (or here) if there is interest. Kind regards Carsten 2009/11/12 Christopher Snow sno...@snowconsulting.co.uk Yes, I take the credit for the hijack! Jacques Le Roux wrote: From: Olivier Tremblay oliviertrembla...@gmail.com Unrelated: +1 thread hijack :P Yes, but if you read it all you will find that some ideas there matter and are related to the subject Chris submitted This said, sorry for the thread hijack but it was Chris's actually ;o) Jacques Back to the discussed matter: As a programmer, I'd be interested to know more about how I can help. I'm not really used to open-source projects, but I'm going to have to implement this solution for my company. Which is why I want to find other Canadian (preferably Quebec) users, and lend a hand if possible. What would I need to know to participate? Olivier Le 2009-11-12 à 06:20, Jacques Le Roux a écrit : Christopher, Sorry this is maybe a bit a technical answer, but I believe it shows another mindset One of the causes, which is maybe hidden for philosophical and pragmatical reasons, is that we (should) always use RTC mode (Review- Then-Commit) For more on this apect you could be interested by http://old.nabble.com/Review-Then-Commit-td26303921.html To commiters : this does not mean that I'm pushing for CTR mode, only that it's interesting to see how other communities are doing and reactions about that ;o) Jacques From: Jacques Le Roux jacques.le.r...@les7arts.com From: Christopher Snow sno...@snowconsulting.co.uk So it's the chicken-and-egg situtation? No : it's improving and the curve is not exponential nor even quadratic but is more than flat. Actually this is very clear since we released 9.04 And maybe the new effort which may happend on SME will increase even more this curve http://markmail.org/thread/whm4uqjhcvwz6pvp Jacques There are not enough contributors to focus on making stable releases and documentation. But without stable releases and documentation, new contributors are not attracted to ofbiz. Jacques Le Roux wrote: Yes we need more solid teams, this is improving... Jacques From: Christopher Snow sno...@snowconsulting.co.uk Are you saying that there are now enough contributors to implement a good release plan? Many thanks, Chris Jacopo Cappellato wrote: On Nov 12, 2009, at 7:34 AM, Christopher Snow wrote: Ofbiz community seems to be focused on making ofbiz generate as much consulting revenue as possible and not on making ofbiz a great shrink wrapped product. For example, end users having to use svn and patches so to keep their systems up to date is crazy. I don't think that the focus of the OFBiz community is to make OFBiz a consulting revenue generator, nor I think that the absence of a stable recent release is a consequence of this. The awful truth, imo, is that maintaining a release is expensive (in terms of man hours) and the time contributed by the users of OFBiz (i.e. its community made of final users, consultants etc...) until now has not been enough to have a good release plan. Jacopo -- Best Carsten Schinzer Waisenhausstr. 53a 80637 München Germany
Re: how to import data from excel sheet
Hi Pradeep,
Thanks for your response.
Sorry I am new to ofbiz. But I am not sure where to define the entity names
and the entity-field names where I want to insert the data(as all the
information like price and others for the product is not stored in only
'Product' entity, I need to insert the data in multiple entities)?
Do I have to specify in XML? Do you have any sample xml file? I want to
insert data for new products
Also, I see entity DataImportProduct. What is that for?
Once again thank you for the help.
Shuchi-
S K Pradeep kumar wrote:
Hi shuchi,
Convert your .cvs to xml and use webtools entity import.
With regards,
S K Pradeep kumar,
On Thu, Nov 12, 2009 at 12:52 AM, su2 shu...@pexsupply.com wrote:
Hi Jacques,
I want to insert all the excel data into the database. I looked at
viewdatafile screen, and looked like, using that I can not insert all my
excel data into database tables.
Jacques Le Roux wrote:
I'd use CSV with https://localhost:8443/webtools/control/viewdatafile.
I
let you find more on this ML archives...
Jacques
From: su2 shu...@pexsupply.com
Hi Nalin,
We have similar requirement where we want to upload/import all the
product
information from excel sheet.
I would really appreciate if you could tell me, how we can achieve
that.
Thank you.
Shuchi-
Nalin Chandra wrote:
Hi All
I want to import the product related data from excel sheet. I did it
but
i
have one problem in this.
I excel sheet i have absolute path of image now i want to upload the
image
from that absolute path to our application as well store the relative
path
in data base as we did in product content section.
i am able to store the relative path in database but image in not
uploading in the required folder.
Main problem is that here i am not using any html form.
i paste the code below for it
public static String uploadCategory(HttpServletRequest request,
HttpServletResponse response) {
try
{
String filename = D:/category.xls;
WorkbookSettings ws = new WorkbookSettings();
ws.setLocale(new Locale(en, EN));
Workbook workbook = Workbook.getWorkbook(new
File(filename),ws);
Sheet s = workbook.getSheet(0);
readCategoryDataSheet(s, request);
workbook.close();
}
catch (IOException e)
{
e.printStackTrace();
}
catch (BiffException e)
{
e.printStackTrace();
}
return success;
}
private static void readCategoryDataSheet(Sheet s,
HttpServletRequest
request)
{
Cell rowData[] = null;
int successCount = 0;
int failCount = 0;
int rows = s.getRows();
int column = s.getColumns();
String productCategoryId = ;
String productCategoryTypeId = ;
String primaryParentCategoryId = ;
String categoryName = ;
String description = ;
String longDescription = ;
String categoryImageUrl = ;
String linkOneImageUrl = ;
String prodCatalogId = ;
String prodCatalogCategoryTypeId = ;
String sequenceNum = ;
for (int i = 1; i rows; i++) {
rowData = s.getRow(i);
if (rowData[0].getContents().length() != 0) {
for (int j = 0; j column; j++) {
switch (j) {
case 0:
productCategoryId =
rowData[j].getContents();
case 1:
productCategoryTypeId
=
rowData[j].getContents();
case 2:
primaryParentCategoryId
=
rowData[j].getContents();
case 3:
categoryName =
rowData[j].getContents();
case 4:
description =
rowData[j].getContents();
case 5:
longDescription =
rowData[j].getContents();
case 6:
categoryImageUrl =
rowData[j].getContents();
case 7:
linkOneImageUrl =
rowData[j].getContents();
default:
break;
}
}
}
String
Re: how to import data from excel sheet
you can find the xml filse in the data folder in all the application/*
module , to create the new products use DemoProduct.xml file.
With regards,
S K Pradeep kumar,
On Thu, Nov 12, 2009 at 7:12 PM, su2 shu...@pexsupply.com wrote:
Hi Pradeep,
Thanks for your response.
Sorry I am new to ofbiz. But I am not sure where to define the entity names
and the entity-field names where I want to insert the data(as all the
information like price and others for the product is not stored in only
'Product' entity, I need to insert the data in multiple entities)?
Do I have to specify in XML? Do you have any sample xml file? I want to
insert data for new products
Also, I see entity DataImportProduct. What is that for?
Once again thank you for the help.
Shuchi-
S K Pradeep kumar wrote:
Hi shuchi,
Convert your .cvs to xml and use webtools entity import.
With regards,
S K Pradeep kumar,
On Thu, Nov 12, 2009 at 12:52 AM, su2 shu...@pexsupply.com wrote:
Hi Jacques,
I want to insert all the excel data into the database. I looked at
viewdatafile screen, and looked like, using that I can not insert all my
excel data into database tables.
Jacques Le Roux wrote:
I'd use CSV with https://localhost:8443/webtools/control/viewdatafile
.
I
let you find more on this ML archives...
Jacques
From: su2 shu...@pexsupply.com
Hi Nalin,
We have similar requirement where we want to upload/import all the
product
information from excel sheet.
I would really appreciate if you could tell me, how we can achieve
that.
Thank you.
Shuchi-
Nalin Chandra wrote:
Hi All
I want to import the product related data from excel sheet. I did it
but
i
have one problem in this.
I excel sheet i have absolute path of image now i want to upload the
image
from that absolute path to our application as well store the
relative
path
in data base as we did in product content section.
i am able to store the relative path in database but image in not
uploading in the required folder.
Main problem is that here i am not using any html form.
i paste the code below for it
public static String uploadCategory(HttpServletRequest request,
HttpServletResponse response) {
try
{
String filename = D:/category.xls;
WorkbookSettings ws = new WorkbookSettings();
ws.setLocale(new Locale(en, EN));
Workbook workbook = Workbook.getWorkbook(new
File(filename),ws);
Sheet s = workbook.getSheet(0);
readCategoryDataSheet(s, request);
workbook.close();
}
catch (IOException e)
{
e.printStackTrace();
}
catch (BiffException e)
{
e.printStackTrace();
}
return success;
}
private static void readCategoryDataSheet(Sheet s,
HttpServletRequest
request)
{
Cell rowData[] = null;
int successCount = 0;
int failCount = 0;
int rows = s.getRows();
int column = s.getColumns();
String productCategoryId = ;
String productCategoryTypeId = ;
String primaryParentCategoryId = ;
String categoryName = ;
String description = ;
String longDescription = ;
String categoryImageUrl = ;
String linkOneImageUrl = ;
String prodCatalogId = ;
String prodCatalogCategoryTypeId = ;
String sequenceNum = ;
for (int i = 1; i rows; i++) {
rowData = s.getRow(i);
if (rowData[0].getContents().length() != 0)
{
for (int j = 0; j column; j++) {
switch (j) {
case 0:
productCategoryId =
rowData[j].getContents();
case 1:
productCategoryTypeId
=
rowData[j].getContents();
case 2:
primaryParentCategoryId
=
rowData[j].getContents();
case 3:
categoryName =
rowData[j].getContents();
case 4:
description =
rowData[j].getContents();
case 5:
longDescription =
rowData[j].getContents();
case 6:
categoryImageUrl =
rowData[j].getContents();
case 7:
linkOneImageUrl =
Re: Help required about custom service and transactions
Hey Rishi, thanks for the answer. To be more clear, I am calling my service via RMI. I didn't specify any specific configuration in the service XML file, but I suppose that my service is encapsulated in a transaction, no ? And so I would expect the transaction being rolled back by the dispatcher as my service returns error. Shouldn't it work this way ? Cimballi On Thu, Nov 12, 2009 at 7:18 AM, Rishi Solanki rishisolan...@gmail.com wrote: Hi Cimballi, TransactionUtil.rollback(boolean beganTransaction, String causeMessage, Throwable causeThrowable) will be your friend here. On passing beganTrasaction value to tru it will rollback the current thread transactions. Rishi Solanki Enterprise Software Developer HotWax Media Pvt. Ltd. On Thu, Nov 12, 2009 at 5:19 AM, Cimballi cimba...@cimballi.net wrote: Hi, I have developed several custom services and I encounter a problem with transactions. My service is calling other services and I notice that when a first service successed, but a second failed, the data of the first service has not been rolled back. Example : - First, I call createPersonAndUserLogin using dispatcher.runSync - Second, I call createPartyRole using dispatcher.runSync The second call failed because I didn't provide all parameters, but the party created in the first call is still there. Is there a way to avoid this, to have a transaction covering all runSync calls ? Thanks, Cimballi
Re: permission error on cancel order item from ecommerce
Hi Scott, as per your suggestion I have implemented a permission checking service, please have a look and let me know if its alright, although I tested this on my system, it was working fine, I didn't got any permission error. Patch attached - https://issues.apache.org/jira/browse/OFBIZ-3075 - Abdullah On Wed, Oct 28, 2009 at 7:32 PM, Abdullah Shaikh abdullah.sha...@viithiisys.com wrote: I tried this, it's working fine using the permission-service-element, there is no security error when doing a cancel item, but the cancel functionality is not working, the item is not getting cancelled, I will take a look at it later and post the details, will raise a jira issue for this. Will be submitting the patch for security error. On Mon, Oct 26, 2009 at 3:13 PM, Abdullah Shaikh abdullah.sha...@viithiisys.com wrote: Scott, I had a look at it and I guess this should work, I will try it out later in the day and let you know. Thanks for pointing On Mon, Oct 26, 2009 at 2:56 PM, Scott Gray scott.g...@hotwaxmedia.comwrote: Okay I did the search :-) Check out partyContactMechPermissionCheck and note it's usage in the service defs with the permission-service element. Regards Scott On 26/10/2009, at 9:31 PM, Abdullah Shaikh wrote: ok, I will take a look, can you please point to one of them, if you have any in mind. Also, I didn't get what you meant by change the permission check to allow the placing party authorization, can you please explain a bit more ? On Mon, Oct 26, 2009 at 1:50 PM, Scott Gray scott.g...@hotwaxmedia.com wrote: Why do we need to use the system userlogin? If we change the permission check to allow the placing party authorization then we shouldn't need to switch anything. This type of situation is handled in a few places around OFBiz, I would suggest that you find and take a look at them (which is what I would have to do to answer any more questions :-) Regards Scott On 26/10/2009, at 9:05 PM, Abdullah Shaikh wrote: Hi Scott, Yes, I too thought of improving the already implemented service, I always have that as a first preference, and all should, to make more better code. Now coming back to the issue, below is what I have already comment in previous post. This error is because the party (customer) doesn't have the ORDERMGR_CREATE or ORDERMGR_ADMIN permission, but we can't give this permission to a customer, further as the common service is called from ecommerce and order manager for cancel, the solution will be to check the party's role, if its a CUSTOMER, then I guess we can use the SYSTEM user in place of the PARTY(CUSTOMER), for this we need to give ORDERMGR permission to the SYSTEM user. But then it will seem as if the SYSTEM user has cancelled the order and not the CUSTOMER ? The only thought that came to my mind to improve the permission check service is as above, but then I guess it will lead to some other issues. - Abdullah On Mon, Oct 26, 2009 at 1:20 PM, Scott Gray scott.g...@hotwaxmedia.com wrote: My first thought without looking at it is that the permission checking service should be improved to allow the order placing party to invoke the service. I don't personally think a separate service definition is the way to go. Regards Scott HotWax Media http://www.hotwaxmedia.com On 26/10/2009, at 8:43 PM, Abdullah Shaikh wrote: Hi All, Any thoughts on this ? Jacques, should I proceed with the overriding service patch ? On Fri, Oct 23, 2009 at 6:21 PM, Abdullah Shaikh abdullah.sha...@viithiisys.com wrote: Yes, I guess maybe this is the only solution for this, should I submit the overriding service patch for this or should I wait for some more ideas to pour in for this ? On Fri, Oct 23, 2009 at 6:09 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: Abdullah, Yes, overriding the service without permission check only for ecommerce use seems the better choise IMO Jacques From: Abdullah Shaikh abdullah.sha...@viithiisys.com If I cancel an order item from ecommerce. I get, the below error displayed on the page. The Following Errors Occurred: Unable to cancel order line : WSCO11640 / 1 / null Note to test this you need to take the latest update of apply this patch https://issues.apache.org/jira/browse/OFBIZ-2408. Below is the error trace from console, this error is because the party (customer) doesn't have the ORDERMGR_CREATE or ORDERMGR_ADMIN permission, but we can't give this permission to a customer, further as the common service is called from ecommerce and order manager for cancel, the solution will be to check the party's role, if its a CUSTOMER, then I guess we can use the SYSTEM user in place of the PARTY(CUSTOMER), for this we need to give ORDERMGR permission to the SYSTEM user. But then it will seem as if the SYSTEM user has cancelled the order and not the CUSTOMER ? Another solution will be
Re: how to import data from excel sheet
Hi Pradeep,
Sorry still little confuse. How am I going to use DemoProduct.xml file? I
understood the file I can have all my required data there, but after that
what should I be doing in order to insert the data in entities?
Thank you.
Shuchi -
S K Pradeep kumar wrote:
you can find the xml filse in the data folder in all the application/*
module , to create the new products use DemoProduct.xml file.
With regards,
S K Pradeep kumar,
On Thu, Nov 12, 2009 at 7:12 PM, su2 shu...@pexsupply.com wrote:
Hi Pradeep,
Thanks for your response.
Sorry I am new to ofbiz. But I am not sure where to define the entity
names
and the entity-field names where I want to insert the data(as all the
information like price and others for the product is not stored in only
'Product' entity, I need to insert the data in multiple entities)?
Do I have to specify in XML? Do you have any sample xml file? I want to
insert data for new products
Also, I see entity DataImportProduct. What is that for?
Once again thank you for the help.
Shuchi-
S K Pradeep kumar wrote:
Hi shuchi,
Convert your .cvs to xml and use webtools entity import.
With regards,
S K Pradeep kumar,
On Thu, Nov 12, 2009 at 12:52 AM, su2 shu...@pexsupply.com wrote:
Hi Jacques,
I want to insert all the excel data into the database. I looked at
viewdatafile screen, and looked like, using that I can not insert all
my
excel data into database tables.
Jacques Le Roux wrote:
I'd use CSV with
https://localhost:8443/webtools/control/viewdatafile
.
I
let you find more on this ML archives...
Jacques
From: su2 shu...@pexsupply.com
Hi Nalin,
We have similar requirement where we want to upload/import all the
product
information from excel sheet.
I would really appreciate if you could tell me, how we can achieve
that.
Thank you.
Shuchi-
Nalin Chandra wrote:
Hi All
I want to import the product related data from excel sheet. I did
it
but
i
have one problem in this.
I excel sheet i have absolute path of image now i want to upload
the
image
from that absolute path to our application as well store the
relative
path
in data base as we did in product content section.
i am able to store the relative path in database but image in not
uploading in the required folder.
Main problem is that here i am not using any html form.
i paste the code below for it
public static String uploadCategory(HttpServletRequest request,
HttpServletResponse response) {
try
{
String filename = D:/category.xls;
WorkbookSettings ws = new WorkbookSettings();
ws.setLocale(new Locale(en, EN));
Workbook workbook = Workbook.getWorkbook(new
File(filename),ws);
Sheet s = workbook.getSheet(0);
readCategoryDataSheet(s, request);
workbook.close();
}
catch (IOException e)
{
e.printStackTrace();
}
catch (BiffException e)
{
e.printStackTrace();
}
return success;
}
private static void readCategoryDataSheet(Sheet s,
HttpServletRequest
request)
{
Cell rowData[] = null;
int successCount = 0;
int failCount = 0;
int rows = s.getRows();
int column = s.getColumns();
String productCategoryId = ;
String productCategoryTypeId = ;
String primaryParentCategoryId = ;
String categoryName = ;
String description = ;
String longDescription = ;
String categoryImageUrl = ;
String linkOneImageUrl = ;
String prodCatalogId = ;
String prodCatalogCategoryTypeId = ;
String sequenceNum = ;
for (int i = 1; i rows; i++) {
rowData = s.getRow(i);
if (rowData[0].getContents().length() !=
0)
{
for (int j = 0; j column; j++) {
switch (j) {
case 0:
productCategoryId
=
rowData[j].getContents();
case 1:
productCategoryTypeId
=
rowData[j].getContents();
case 2:
primaryParentCategoryId
=
rowData[j].getContents();
case 3:
categoryName =
rowData[j].getContents();
case 4:
description =
rowData[j].getContents();
case 5:
longDescription =
Release strategy and community WAS Re: OFBiz in Canada?
Hi Carsten, On Nov 12, 2009, at 2:31 PM, Carsten Schinzer wrote: Well, regarding participation, we just had an excellent Talk about participating in open source - and guess what even more detailed: on ASF - projects here at W-JAX 2009 in Munich. It was especially of interest, since it drew a couple of examples what the motivation of people would be to participate. And you will not be surprised to see that a certain commercial interest is not unusual. However, the argument of critical mass being brought up above seems a little vague to me: What is actually the number of comitters / contributors required to switch into a good release plan? Yes it is vague for sure, and it is based on a reality check: OFbiz's community is active, OFBiz is widely used, a lot of new features are freely contributed everyday but very few people or companies seem interested in contributing time to maintain a release plan. This is why I said this. We can probably try do something to better use the efforts of the ones willing to help maintain releases, ideas are welcome. Kind regards, Jacopo Any ideas? Is it dependant on the BUG statistics reported on JIRA? How many are they and how good are we contributors in fixing them? Are we currently building a backlog? Is it for trunk or for releases only? How are bug reports/bugs distributed across components? Is it possibly critical to have a certain number of committers per component? Back to the talk I mentioned: Once I have the slides, I will distribute the link across people (or here) if there is interest. Kind regards Carsten 2009/11/12 Christopher Snow sno...@snowconsulting.co.uk Yes, I take the credit for the hijack! Jacques Le Roux wrote: From: Olivier Tremblay oliviertrembla...@gmail.com Unrelated: +1 thread hijack :P Yes, but if you read it all you will find that some ideas there matter and are related to the subject Chris submitted This said, sorry for the thread hijack but it was Chris's actually ;o) Jacques Back to the discussed matter: As a programmer, I'd be interested to know more about how I can help. I'm not really used to open-source projects, but I'm going to have to implement this solution for my company. Which is why I want to find other Canadian (preferably Quebec) users, and lend a hand if possible. What would I need to know to participate? Olivier Le 2009-11-12 à 06:20, Jacques Le Roux a écrit : Christopher, Sorry this is maybe a bit a technical answer, but I believe it shows another mindset One of the causes, which is maybe hidden for philosophical and pragmatical reasons, is that we (should) always use RTC mode (Review- Then-Commit) For more on this apect you could be interested by http://old.nabble.com/Review-Then-Commit-td26303921.html To commiters : this does not mean that I'm pushing for CTR mode, only that it's interesting to see how other communities are doing and reactions about that ;o) Jacques From: Jacques Le Roux jacques.le.r...@les7arts.com From: Christopher Snow sno...@snowconsulting.co.uk So it's the chicken-and-egg situtation? No : it's improving and the curve is not exponential nor even quadratic but is more than flat. Actually this is very clear since we released 9.04 And maybe the new effort which may happend on SME will increase even more this curve http://markmail.org/thread/whm4uqjhcvwz6pvp Jacques There are not enough contributors to focus on making stable releases and documentation. But without stable releases and documentation, new contributors are not attracted to ofbiz. Jacques Le Roux wrote: Yes we need more solid teams, this is improving... Jacques From: Christopher Snow sno...@snowconsulting.co.uk Are you saying that there are now enough contributors to implement a good release plan? Many thanks, Chris Jacopo Cappellato wrote: On Nov 12, 2009, at 7:34 AM, Christopher Snow wrote: Ofbiz community seems to be focused on making ofbiz generate as much consulting revenue as possible and not on making ofbiz a great shrink wrapped product. For example, end users having to use svn and patches so to keep their systems up to date is crazy. I don't think that the focus of the OFBiz community is to make OFBiz a consulting revenue generator, nor I think that the absence of a stable recent release is a consequence of this. The awful truth, imo, is that maintaining a release is expensive (in terms of man hours) and the time contributed by the users of OFBiz (i.e. its community made of final users, consultants etc...) until now has not been enough to have a good release plan. Jacopo -- Best Carsten Schinzer Waisenhausstr. 53a 80637 München Germany
Re: Help required about custom service and transactions
On Nov 12, 2009, at 12:49 AM, Cimballi wrote: Hi, I have developed several custom services and I encounter a problem with transactions. My service is calling other services and I notice that when a first service successed, but a second failed, the data of the first service has not been rolled back. Example : - First, I call createPersonAndUserLogin using dispatcher.runSync - Second, I call createPartyRole using dispatcher.runSync The second call failed because I didn't provide all parameters, but the party created in the first call is still there. The reason is in the service definition for createPersonAndUserLogin: service name=createPersonAndUserLogin engine=simple require-new-transaction=true location=component://party/script/org/ofbiz/party/party/PartySimpleMethods.xml invoke=createPersonAndUserLogin auth=false descriptionCreate a Person and UserLogin/description implements service=createUserLogin/ auto-attributes entity-name=Person mode=IN include=nonpk optional=true/ auto-attributes entity-name=Party mode=IN include=nonpk optional=true/ attribute name=partyId type=String mode=INOUT optional=true entity-name=Person/ attribute name=newUserLogin type=Map mode=OUT optional=false/ /service This service is executed in its own transaction because of the attribute: require-new-transaction=true Jacopo Is there a way to avoid this, to have a transaction covering all runSync calls ? Thanks, Cimballi
Re: Help required about custom service and transactions
Ok ! Thanks a lot Jacopo ! Cimballi On Thu, Nov 12, 2009 at 10:07 AM, Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com wrote: On Nov 12, 2009, at 12:49 AM, Cimballi wrote: Hi, I have developed several custom services and I encounter a problem with transactions. My service is calling other services and I notice that when a first service successed, but a second failed, the data of the first service has not been rolled back. Example : - First, I call createPersonAndUserLogin using dispatcher.runSync - Second, I call createPartyRole using dispatcher.runSync The second call failed because I didn't provide all parameters, but the party created in the first call is still there. The reason is in the service definition for createPersonAndUserLogin: service name=createPersonAndUserLogin engine=simple require-new-transaction=true location=component://party/script/org/ofbiz/party/party/PartySimpleMethods.xml invoke=createPersonAndUserLogin auth=false descriptionCreate a Person and UserLogin/description implements service=createUserLogin/ auto-attributes entity-name=Person mode=IN include=nonpk optional=true/ auto-attributes entity-name=Party mode=IN include=nonpk optional=true/ attribute name=partyId type=String mode=INOUT optional=true entity-name=Person/ attribute name=newUserLogin type=Map mode=OUT optional=false/ /service This service is executed in its own transaction because of the attribute: require-new-transaction=true Jacopo Is there a way to avoid this, to have a transaction covering all runSync calls ? Thanks, Cimballi
Re: OFBiz in Canada?
Hi Carsten, Theses are very good questions but difficult to answer. For me it's more a felling than numbers. For the moment I only use this metric http://tinyurl.com/yb3h4hv. So you see it's more in survival mode. Also I presume that it would be difficult to organize things (and even more people) as you suggested because we all depend on clients requests and that changes pretty much all the time. But yes we may think about it... IMO, the backlog concept could be the one we could focus on 1st. There has been some attempts but not directed to a release http://docs.ofbiz.org/display/OFBADMIN/New+Features+Roadmap+-+Living+Document Jacques From: Carsten Schinzer c.schin...@googlemail.com However, the argument of critical mass being brought up above seems a little vague to me: What is actually the number of comitters / contributors required to switch into a good release plan? Any ideas? Is it dependant on the BUG statistics reported on JIRA? How many are they and how good are we contributors in fixing them? Are we currently building a backlog? Is it for trunk or for releases only? How are bug reports/bugs distributed across components? Is it possibly critical to have a certain number of committers per component? Kind regards Carsten
Re: OFBiz in Canada?
I feel it is worth looking at the other way too. If ofbiz were to move towards reusing projects like hibernate and spring and generalize some of the cool concepts into reusable libraries packaged through something like Apache Commons or ofbiz subprojects it would drive adoption. By resuable i mean things like XML form based langugage, renderers. minilang. These nice ideas do not need to be ofbiz only. I realize this is difficult and not immediate focus of ofiz.. I am also sure this may not always be best design or priority fit. .. but it does cause practical problems - developers pay by not learning other things that are potentially more mature in design and popularity, this in turn can lead to lower financial returns as outlined by Christopher. For employers, if a developer votes with their feet a lot of training investment is lost. Books really help. Cost of understanding and maintaining ofbiz based projects and having developers feel it is the right thing to learn is very important i feel. Harmeet - Original Message - From: Ruth Hoffman rhoff...@aesolves.com The more new adopters we get, the more likely OFBiz will be brought into the enterprise and become mainstream. And then the secret will be out and everyone will be salivating all over it - just like the do with Spring and Hibernate. Christopher Snow wrote: I spend a lot of time learning. I am learning new systems all the time and to date I have implemented a multitude of opensource solutions . I enjoy learning, I enjoy new technologies. ... When looking at returns, as a contractor, I usually notice what skills the UK job boards are asking for. I have seen a few jobs recently asking for adempiere and compiere skills. I have not seen many jobs requiring ofbiz skills, but I do have a number of small companies that want bespoke enterprise application development that suits the ofbiz framework.
Re: ApacheCon 2009 Round Table User Feedback
Hi Jacopo, I put your comments at http://docs.ofbiz.org/display/OFBADMIN/New+Features+Roadmap+-+Living+Document?focusedCommentId=9524#comment-9524 Thanks Jacques From: Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com On Nov 11, 2009, at 2:18 AM, Shi Jinghai wrote: Forgot to say, Facebook and iGoogle are the best samples of all :). H... the ui of FB and Google are example of ui that are richer than the one of OFBiz, but I would not say that they are good examples of good ui. Often what is nice is not really useful, especially when the user performs repetitive tasks. For example: sometimes it is annoying to move your hands from the keyboard to the mouse. Some general enhancements I would like to see in OFBiz: * better error/success messages * better handling of keyboard tab to move from one field to another * more and better multi row submit screens * more informative form fields (e.g. showing descriptions instead of just ids) * enhancing field interactions (the value of one field can change/ hide/ etc other elements/data in the screen) BTW, I think it would be much better to focus on specific use cases/ workflows/system interactions, and suggest enhancements; for example: 1) go to order manager 2) select order entry 3) select a customer; SUGGESTION: here I would like to get a better selection mechanism, with 4) after the selection of a customer, etc... In this way it will be easier to focus on specific solutions and improve, working with the community, key processes in the system. Cheers, Jacopo 在 2009-11-11三的 09:13 +0800，Shi Jinghai写道： In the architectural level, JBoss Portal can be a good sample, the concepts are portal, page, window. http://www.jboss.org/jbossportal/ or http://www.jboss.org/gatein If you're interested in how a user configs his/her page, you can login our portal: http://sso.langhua.org/cas/login?service=http%3A%2F%2Flanghua.org% 2Fportal%2Fauth%2Fportal%2Fdefault%2FHome Username: anon Password: anon In window level, OpenCms is a good example, list, dialog and etc. http://demo.opencms.org/en/ If you're interested in how a user use it, you can login our cms workplace: http://sso.langhua.org/cas/login?service=http%3A%2F %2Fcms.langhua.org% 3A80%2Fopencms705%2Fopencms%2Fsystem%2Flogin%2Findex.html Username: anon Password: anon Regards, Shi Jinghai/Beijing Langhua Ltd. 在 2009-11-10二的 19:02 -0500，Ruth Hoffman写道： Hello Shi: Please excuse my ignorance, but what exactly do you mean by web GUI? Could you give an example of another application suite that has a web GUI as you suggest? Regards, Ruth Shi Jinghai wrote: OFBiz already has a core system (like a dos or linux core), it needs a Windows/GNU(web GUI), perhaps it's time to consider to introduce a new party who is an expert on this. Please don't confuse the GUI with CSS, it's on dialog, window, menu, list, form and etc. Just my 2 cents, Shi Jinghai/Beijing Langhua Ltd. PS: please rename the GUI in framework to another name. 在 2009-11-10二的 07:17 -0700，Brett Palmer写é“： Here are the notes that I took during the ApacheCon 2009 User Round Table. The conference was a success but I believe was less attended than normal. I've been to about 6 ofbiz conferences and this one was the least attended by ofbiz users than others. I attribute this to the current economic situation rather than anything else. Interestingly, a lot of the comments during the round table were similar to ones that we have had in the past. The project continues to make progress but from outsiders it is difficult to measure as some of the new features takes months to see in the end product. There were six people in attendance at the round table. A few had to leave early to catch planes in the afternoon. Of those that attended the round table two were speakers (myself and Ruth). Three of the attendees were service providers trying to better understand the direction of ofbiz and one was a new user that was active in other Apache projects and wanted to know more about ofbiz. Here are the key comments: * Everyone was very interested in the new project that Dave introduced a couple of weeks ago about a specialized application for small business. They wanted to know a lot more about this project and what it would include. There was a lot of excitement about the proposal. I didn't have a lot of details to share so I told them to watch the mailing list for more details on the subject. * Most common complaint. The UI for the out of the box ecommerce application. The general feedback was that from a technical perspective people like ofbiz but it was difficult to convince key business people that ofbiz was right for their organization because of the lacking sizzle in the default application. Non-technical people have a hard time determining how difficult it is to customize the UI and in a quick review will opt for a better looking application because that is all they can really
Re: how to import data from excel sheet
look in the /framework/datafile/dtd/datafiles.xsd
it has how to make your data definition file.
also
http://docs.ofbiz.org/display/OFBENDUSER/OFBiz's+Data+File+Tools
http://docs.ofbiz.org/display/OFBIZ/Handling+of+External+data
once you build the data definintion files then you can use
https://localhost:8443/webtools/control/viewdatafile
su2 sent the following on 11/11/2009 11:22 AM:
Hi Jacques,
I want to insert all the excel data into the database. I looked at
viewdatafile screen, and looked like, using that I can not insert all my
excel data into database tables.
Jacques Le Roux wrote:
I'd use CSV with https://localhost:8443/webtools/control/viewdatafile. I
let you find more on this ML archives...
Jacques
From: su2 shu...@pexsupply.com
Hi Nalin,
We have similar requirement where we want to upload/import all the
product
information from excel sheet.
I would really appreciate if you could tell me, how we can achieve that.
Thank you.
Shuchi-
Nalin Chandra wrote:
Hi All
I want to import the product related data from excel sheet. I did it but
i
have one problem in this.
I excel sheet i have absolute path of image now i want to upload the
image
from that absolute path to our application as well store the relative
path
in data base as we did in product content section.
i am able to store the relative path in database but image in not
uploading in the required folder.
Main problem is that here i am not using any html form.
i paste the code below for it
public static String uploadCategory(HttpServletRequest request,
HttpServletResponse response) {
try
{
String filename = D:/category.xls;
WorkbookSettings ws = new WorkbookSettings();
ws.setLocale(new Locale(en, EN));
Workbook workbook = Workbook.getWorkbook(new
File(filename),ws);
Sheet s = workbook.getSheet(0);
readCategoryDataSheet(s, request);
workbook.close();
}
catch (IOException e)
{
e.printStackTrace();
}
catch (BiffException e)
{
e.printStackTrace();
}
return success;
}
private static void readCategoryDataSheet(Sheet s,
HttpServletRequest
request)
{
Cell rowData[] = null;
int successCount = 0;
int failCount = 0;
int rows = s.getRows();
int column = s.getColumns();
String productCategoryId = ;
String productCategoryTypeId = ;
String primaryParentCategoryId = ;
String categoryName = ;
String description = ;
String longDescription = ;
String categoryImageUrl = ;
String linkOneImageUrl = ;
String prodCatalogId = ;
String prodCatalogCategoryTypeId = ;
String sequenceNum = ;
for (int i = 1; i rows; i++) {
rowData = s.getRow(i);
if (rowData[0].getContents().length() != 0) {
for (int j = 0; j column; j++) {
switch (j) {
case 0:
productCategoryId =
rowData[j].getContents();
case 1:
productCategoryTypeId =
rowData[j].getContents();
case 2:
primaryParentCategoryId
=
rowData[j].getContents();
case 3:
categoryName =
rowData[j].getContents();
case 4:
description =
rowData[j].getContents();
case 5:
longDescription =
rowData[j].getContents();
case 6:
categoryImageUrl =
rowData[j].getContents();
case 7:
linkOneImageUrl =
rowData[j].getContents();
default:
break;
}
}
}
String imageFilenameFormat =
UtilProperties.getPropertyValue(catalog, image.filename.format);
String imageServerPath =
UtilProperties.getPropertyValue(catalog, image.server.path);
String imageUrlPrefix =
UtilProperties.getPropertyValue(catalog, image.url.prefix);
// upload image
FlexibleStringExpander
Re: How to set partyId in request in javascript
Thanks Rishi, I try this and if i have any doubt then get back to you.
Thanks
Ramkrishna
On Wed, Nov 11, 2009 at 11:51 AM, Rishi Solanki rishisolan...@gmail.comwrote:
I suggested the both way, If you want to pass the parameter then use ;
parameters: {productPromoCodeId:$F('productPromoCode')} line 418.
Here the service will get the productPromoCodeId as parameter, note there
is
no form submit.
Here
Rishi Solanki
Enterprise Software Developer
HotWax Media Pvt. Ltd.
On Tue, Nov 10, 2009 at 10:21 AM, Ramkrishna Swamy
ramkrishna.swamyof...@gmail.com wrote:
Hi Rishi,
I saw the suggested file but in the file parameters are sent after
submitting the form but in my case I don't submit the form and want to
pass
the parameter.
--
Thanks
Ramkrishna
On Mon, Nov 9, 2009 at 5:12 PM, Rishi Solanki rishisolan...@gmail.com
wrote:
Hi Ram,
If you are on same window then you can easily copy value by using its
id.
$('targetId').value = $('sourceId').value in JS.
If you need to pass it as request then can see many example of form
parameters submission in checkoutProcess.js.
If wanna to submit whole form then go like ;
parameters: $('shippingOptionForm').serialize(), requestHeaders:
{Accept:
'application/json'}
if wanna to submit single or two value then go like ;
parameters: {productPromoCodeId:$F('productPromoCode')}
Reference file in OFBiz -
/ecommerce/webapp/ecommerce/images/checkoutProcess.js
Rishi Solanki
Enterprise Software Developer
HotWax Media Pvt. Ltd.
On Fri, Nov 6, 2009 at 1:47 PM, Ramkrishna Swamy
ramkrishna.swamyof...@gmail.com wrote:
Is this possible or not???
Actually i have a drop down and i want selected partyid to be passed
on
to
other form without submitting the first form.
plz hlp
Thanks
Ramkrishna
On Thu, Nov 5, 2009 at 12:36 PM, RamKrishna Swamy
ramkrishna.swamyof...@gmail.com wrote:
Hi list,
How can I set a selected partyId's value in request/parameter in
javascript??
Please help.
Thanks
Ramkrishna
Re: Currency UOM
Hi Prabhakaran, It is working fine for me, let you know later on when I'll get a chance, till then you can check whether your product's price is also having INR currencyUomId in Catalog component. Thanks and Regards Santosh Malviya On Thu, Nov 12, 2009 at 3:59 PM, Prabhakaran Duraisamy prabhaka...@formativesolutions.co.in wrote: Hi Santhosh , I did the Same But Same Error On Thu, Nov 12, 2009 at 3:16 PM, Santosh Malviya santosh.of...@gmail.com wrote: Hello Prabhakaran, Go to webtools and edit the entity PartyAcctgPreference by setting its baseCurrencyUomId to INR. Thanks and Regards Santosh Malviya On Thu, Nov 12, 2009 at 2:08 PM, Prabhakaran Duraisamy prabhaka...@formativesolutions.co.in wrote: Hi Santhosh Sorry I cant get you Can Explain detail On Thu, Nov 12, 2009 at 12:17 PM, Santosh Malviya santosh.of...@gmail.comwrote: Hi Prabhakaran, Default currencyUom is USD so you have to change it to INR and this is not possible throuth UI because Accounting Preference in accounting component is not editable mode due to some reason, so you can change it manually by going to entity PartyAcctgPreference. Thanks and Regards Santosh Malviya On Thu, Nov 12, 2009 at 11:00 AM, Prabhakaran Duraisamy prabhaka...@formativesolutions.co.in wrote: Hi while I am trying BOM Simulation in Manufacturins Bill of Matrials if Selected INR - Indian Rupee following error is occured How can i resolve this Error in simple-method [Convert UOM values [file:/D:/ofbiz/framework/common/script/org/ofbiz/common/CommonServices.xml#convertUom]]: ; [UOM Conversion Relationship Not Found]) pls give Suggestion for this -- Regards, Prabhakaran.D +91 99 520 93 900 -- Regards, Prabhakaran.D +91 99 520 93 900 -- Regards, Prabhakaran.D +91 99 520 93 900
Re: how to import data from excel sheet
Study about webtools there is one data import facility study that and use it
for your requirements.
With regards,
S K Pradeep kumar,
On Thu, Nov 12, 2009 at 8:05 PM, su2 shu...@pexsupply.com wrote:
Hi Pradeep,
Sorry still little confuse. How am I going to use DemoProduct.xml file? I
understood the file I can have all my required data there, but after that
what should I be doing in order to insert the data in entities?
Thank you.
Shuchi -
S K Pradeep kumar wrote:
you can find the xml filse in the data folder in all the application/*
module , to create the new products use DemoProduct.xml file.
With regards,
S K Pradeep kumar,
On Thu, Nov 12, 2009 at 7:12 PM, su2 shu...@pexsupply.com wrote:
Hi Pradeep,
Thanks for your response.
Sorry I am new to ofbiz. But I am not sure where to define the entity
names
and the entity-field names where I want to insert the data(as all the
information like price and others for the product is not stored in only
'Product' entity, I need to insert the data in multiple entities)?
Do I have to specify in XML? Do you have any sample xml file? I want to
insert data for new products
Also, I see entity DataImportProduct. What is that for?
Once again thank you for the help.
Shuchi-
S K Pradeep kumar wrote:
Hi shuchi,
Convert your .cvs to xml and use webtools entity import.
With regards,
S K Pradeep kumar,
On Thu, Nov 12, 2009 at 12:52 AM, su2 shu...@pexsupply.com wrote:
Hi Jacques,
I want to insert all the excel data into the database. I looked at
viewdatafile screen, and looked like, using that I can not insert all
my
excel data into database tables.
Jacques Le Roux wrote:
I'd use CSV with
https://localhost:8443/webtools/control/viewdatafile
.
I
let you find more on this ML archives...
Jacques
From: su2 shu...@pexsupply.com
Hi Nalin,
We have similar requirement where we want to upload/import all the
product
information from excel sheet.
I would really appreciate if you could tell me, how we can achieve
that.
Thank you.
Shuchi-
Nalin Chandra wrote:
Hi All
I want to import the product related data from excel sheet. I did
it
but
i
have one problem in this.
I excel sheet i have absolute path of image now i want to upload
the
image
from that absolute path to our application as well store the
relative
path
in data base as we did in product content section.
i am able to store the relative path in database but image in not
uploading in the required folder.
Main problem is that here i am not using any html form.
i paste the code below for it
public static String uploadCategory(HttpServletRequest request,
HttpServletResponse response) {
try
{
String filename = D:/category.xls;
WorkbookSettings ws = new WorkbookSettings();
ws.setLocale(new Locale(en, EN));
Workbook workbook = Workbook.getWorkbook(new
File(filename),ws);
Sheet s = workbook.getSheet(0);
readCategoryDataSheet(s, request);
workbook.close();
}
catch (IOException e)
{
e.printStackTrace();
}
catch (BiffException e)
{
e.printStackTrace();
}
return success;
}
private static void readCategoryDataSheet(Sheet s,
HttpServletRequest
request)
{
Cell rowData[] = null;
int successCount = 0;
int failCount = 0;
int rows = s.getRows();
int column = s.getColumns();
String productCategoryId = ;
String productCategoryTypeId = ;
String primaryParentCategoryId = ;
String categoryName = ;
String description = ;
String longDescription = ;
String categoryImageUrl = ;
String linkOneImageUrl = ;
String prodCatalogId = ;
String prodCatalogCategoryTypeId = ;
String sequenceNum = ;
for (int i = 1; i rows; i++) {
rowData = s.getRow(i);
if (rowData[0].getContents().length() !=
0)
{
for (int j = 0; j column; j++)
{
switch (j) {
case 0:
productCategoryId
=
rowData[j].getContents();
case 1:
productCategoryTypeId
=
rowData[j].getContents();
case 2:
primaryParentCategoryId
=
rowData[j].getContents();
case
Re: Currency UOM
Hi Prabhakaran, Prabhakaran Duraisamy wrote: Hi while I am trying BOM Simulation in Manufacturins Bill of Matrials if Selected INR - Indian Rupee following error is occured How can i resolve this Error in simple-method [Convert UOM values [file:/D:/ofbiz/framework/common/script/org/ofbiz/common/CommonServices.xml#convertUom]]: ; [UOM Conversion Relationship Not Found]) You need to setup data for UomConversionDated entity. Look on DemoGlSetupData.xml you will get more information. pls give Suggestion for this Thanks And Regards -- Amit Sharma
Re: Currency UOM
Ok Santosh.. Thanks On Fri, Nov 13, 2009 at 10:38 AM, Santosh Malviya santosh.of...@gmail.comwrote: Hi Prabhakaran, It is working fine for me, let you know later on when I'll get a chance, till then you can check whether your product's price is also having INR currencyUomId in Catalog component. Thanks and Regards Santosh Malviya On Thu, Nov 12, 2009 at 3:59 PM, Prabhakaran Duraisamy prabhaka...@formativesolutions.co.in wrote: Hi Santhosh , I did the Same But Same Error On Thu, Nov 12, 2009 at 3:16 PM, Santosh Malviya santosh.of...@gmail.com wrote: Hello Prabhakaran, Go to webtools and edit the entity PartyAcctgPreference by setting its baseCurrencyUomId to INR. Thanks and Regards Santosh Malviya On Thu, Nov 12, 2009 at 2:08 PM, Prabhakaran Duraisamy prabhaka...@formativesolutions.co.in wrote: Hi Santhosh Sorry I cant get you Can Explain detail On Thu, Nov 12, 2009 at 12:17 PM, Santosh Malviya santosh.of...@gmail.comwrote: Hi Prabhakaran, Default currencyUom is USD so you have to change it to INR and this is not possible throuth UI because Accounting Preference in accounting component is not editable mode due to some reason, so you can change it manually by going to entity PartyAcctgPreference. Thanks and Regards Santosh Malviya On Thu, Nov 12, 2009 at 11:00 AM, Prabhakaran Duraisamy prabhaka...@formativesolutions.co.in wrote: Hi while I am trying BOM Simulation in Manufacturins Bill of Matrials if Selected INR - Indian Rupee following error is occured How can i resolve this Error in simple-method [Convert UOM values [file:/D:/ofbiz/framework/common/script/org/ofbiz/common/CommonServices.xml#convertUom]]: ; [UOM Conversion Relationship Not Found]) pls give Suggestion for this -- Regards, Prabhakaran.D +91 99 520 93 900 -- Regards, Prabhakaran.D +91 99 520 93 900 -- Regards, Prabhakaran.D +91 99 520 93 900 -- Regards, Prabhakaran.D +91 99 520 93 900
Re: Currency UOM
Hi Santhosh, Its Working fine Santosh , I didnt Change INR in Catalog Pls Again another Query In that BOM Simulation in the that table the cost is not displayed On Fri, Nov 13, 2009 at 10:38 AM, Santosh Malviya santosh.of...@gmail.comwrote: Hi Prabhakaran, It is working fine for me, let you know later on when I'll get a chance, till then you can check whether your product's price is also having INR currencyUomId in Catalog component. Thanks and Regards Santosh Malviya On Thu, Nov 12, 2009 at 3:59 PM, Prabhakaran Duraisamy prabhaka...@formativesolutions.co.in wrote: Hi Santhosh , I did the Same But Same Error On Thu, Nov 12, 2009 at 3:16 PM, Santosh Malviya santosh.of...@gmail.com wrote: Hello Prabhakaran, Go to webtools and edit the entity PartyAcctgPreference by setting its baseCurrencyUomId to INR. Thanks and Regards Santosh Malviya On Thu, Nov 12, 2009 at 2:08 PM, Prabhakaran Duraisamy prabhaka...@formativesolutions.co.in wrote: Hi Santhosh Sorry I cant get you Can Explain detail On Thu, Nov 12, 2009 at 12:17 PM, Santosh Malviya santosh.of...@gmail.comwrote: Hi Prabhakaran, Default currencyUom is USD so you have to change it to INR and this is not possible throuth UI because Accounting Preference in accounting component is not editable mode due to some reason, so you can change it manually by going to entity PartyAcctgPreference. Thanks and Regards Santosh Malviya On Thu, Nov 12, 2009 at 11:00 AM, Prabhakaran Duraisamy prabhaka...@formativesolutions.co.in wrote: Hi while I am trying BOM Simulation in Manufacturins Bill of Matrials if Selected INR - Indian Rupee following error is occured How can i resolve this Error in simple-method [Convert UOM values [file:/D:/ofbiz/framework/common/script/org/ofbiz/common/CommonServices.xml#convertUom]]: ; [UOM Conversion Relationship Not Found]) pls give Suggestion for this -- Regards, Prabhakaran.D +91 99 520 93 900 -- Regards, Prabhakaran.D +91 99 520 93 900 -- Regards, Prabhakaran.D +91 99 520 93 900 -- Regards, Prabhakaran.D +91 99 520 93 900
Re: how to import data from excel sheet
Hi,
Look at the ImportProductServices.java, here you will get the
productImportFromSpreadsheet() service to import the product data from Excel
sheet.
You just need to put your Excel sheet in your ${OFBIZ-HOME}/spreadsheet
directory (need to create). Now go to webtools run service
productImportFromSpreadsheet without passing any parameter. If your Excell
Sheet has some other Product entity field then those needs to be handle by
modifying the service.
Rishi Solanki
Enterprise Software Developer
HotWax Media Pvt. Ltd.
On Fri, Nov 13, 2009 at 10:57 AM, S K Pradeep kumar
s.k.pradeepku...@gmail.com wrote:
Study about webtools there is one data import facility study that and use
it
for your requirements.
With regards,
S K Pradeep kumar,
On Thu, Nov 12, 2009 at 8:05 PM, su2 shu...@pexsupply.com wrote:
Hi Pradeep,
Sorry still little confuse. How am I going to use DemoProduct.xml file? I
understood the file I can have all my required data there, but after that
what should I be doing in order to insert the data in entities?
Thank you.
Shuchi -
S K Pradeep kumar wrote:
you can find the xml filse in the data folder in all the application/*
module , to create the new products use DemoProduct.xml file.
With regards,
S K Pradeep kumar,
On Thu, Nov 12, 2009 at 7:12 PM, su2 shu...@pexsupply.com wrote:
Hi Pradeep,
Thanks for your response.
Sorry I am new to ofbiz. But I am not sure where to define the entity
names
and the entity-field names where I want to insert the data(as all the
information like price and others for the product is not stored in
only
'Product' entity, I need to insert the data in multiple entities)?
Do I have to specify in XML? Do you have any sample xml file? I want
to
insert data for new products
Also, I see entity DataImportProduct. What is that for?
Once again thank you for the help.
Shuchi-
S K Pradeep kumar wrote:
Hi shuchi,
Convert your .cvs to xml and use webtools entity import.
With regards,
S K Pradeep kumar,
On Thu, Nov 12, 2009 at 12:52 AM, su2 shu...@pexsupply.com wrote:
Hi Jacques,
I want to insert all the excel data into the database. I looked at
viewdatafile screen, and looked like, using that I can not insert
all
my
excel data into database tables.
Jacques Le Roux wrote:
I'd use CSV with
https://localhost:8443/webtools/control/viewdatafile
.
I
let you find more on this ML archives...
Jacques
From: su2 shu...@pexsupply.com
Hi Nalin,
We have similar requirement where we want to upload/import all
the
product
information from excel sheet.
I would really appreciate if you could tell me, how we can
achieve
that.
Thank you.
Shuchi-
Nalin Chandra wrote:
Hi All
I want to import the product related data from excel sheet. I
did
it
but
i
have one problem in this.
I excel sheet i have absolute path of image now i want to
upload
the
image
from that absolute path to our application as well store the
relative
path
in data base as we did in product content section.
i am able to store the relative path in database but image in
not
uploading in the required folder.
Main problem is that here i am not using any html form.
i paste the code below for it
public static String uploadCategory(HttpServletRequest request,
HttpServletResponse response) {
try
{
String filename = D:/category.xls;
WorkbookSettings ws = new WorkbookSettings();
ws.setLocale(new Locale(en, EN));
Workbook workbook = Workbook.getWorkbook(new
File(filename),ws);
Sheet s = workbook.getSheet(0);
readCategoryDataSheet(s, request);
workbook.close();
}
catch (IOException e)
{
e.printStackTrace();
}
catch (BiffException e)
{
e.printStackTrace();
}
return success;
}
private static void readCategoryDataSheet(Sheet s,
HttpServletRequest
request)
{
Cell rowData[] = null;
int successCount = 0;
int failCount = 0;
int rows = s.getRows();
int column = s.getColumns();
String productCategoryId = ;
String productCategoryTypeId = ;
String primaryParentCategoryId = ;
String categoryName = ;
String description = ;
String longDescription = ;
String categoryImageUrl = ;
String linkOneImageUrl = ;
String prodCatalogId = ;
String
Re: Currency UOM
Click on the NA link under cost and edit the cost for the product. Thanks and Regards Santosh Malviya On Fri, Nov 13, 2009 at 11:40 AM, Prabhakaran Duraisamy prabhaka...@formativesolutions.co.in wrote: Hi Santhosh, Its Working fine Santosh , I didnt Change INR in Catalog Pls Again another Query In that BOM Simulation in the that table the cost is not displayed On Fri, Nov 13, 2009 at 10:38 AM, Santosh Malviya santosh.of...@gmail.comwrote: Hi Prabhakaran, It is working fine for me, let you know later on when I'll get a chance, till then you can check whether your product's price is also having INR currencyUomId in Catalog component. Thanks and Regards Santosh Malviya On Thu, Nov 12, 2009 at 3:59 PM, Prabhakaran Duraisamy prabhaka...@formativesolutions.co.in wrote: Hi Santhosh , I did the Same But Same Error On Thu, Nov 12, 2009 at 3:16 PM, Santosh Malviya santosh.of...@gmail.com wrote: Hello Prabhakaran, Go to webtools and edit the entity PartyAcctgPreference by setting its baseCurrencyUomId to INR. Thanks and Regards Santosh Malviya On Thu, Nov 12, 2009 at 2:08 PM, Prabhakaran Duraisamy prabhaka...@formativesolutions.co.in wrote: Hi Santhosh Sorry I cant get you Can Explain detail On Thu, Nov 12, 2009 at 12:17 PM, Santosh Malviya santosh.of...@gmail.comwrote: Hi Prabhakaran, Default currencyUom is USD so you have to change it to INR and this is not possible throuth UI because Accounting Preference in accounting component is not editable mode due to some reason, so you can change it manually by going to entity PartyAcctgPreference. Thanks and Regards Santosh Malviya On Thu, Nov 12, 2009 at 11:00 AM, Prabhakaran Duraisamy prabhaka...@formativesolutions.co.in wrote: Hi while I am trying BOM Simulation in Manufacturins Bill of Matrials if Selected INR - Indian Rupee following error is occured How can i resolve this Error in simple-method [Convert UOM values [file:/D:/ofbiz/framework/common/script/org/ofbiz/common/CommonServices.xml#convertUom]]: ; [UOM Conversion Relationship Not Found]) pls give Suggestion for this -- Regards, Prabhakaran.D +91 99 520 93 900 -- Regards, Prabhakaran.D +91 99 520 93 900 -- Regards, Prabhakaran.D +91 99 520 93 900 -- Regards, Prabhakaran.D +91 99 520 93 900
Re: OFBiz in Canada?
It would be a good idea a full integration of Maven2 on Ofbiz? it is already considered/done? I think it may be helpful to control the release mechanism and also gives the ability to separate everything in modules as Harmet said. For example, Ofbiz core would be the main module and all the compoments will depend of it so in order to activate/deactivate components it will be very easy, just changing the main POM should be enough. I've only seen one person who is using his own repository of release 9.04, but probably it is a good idea to have ofbiz on a public repository. Sorry if it doesn't make sense, it's just an idea from an ofbiz noob. On Thu, Nov 12, 2009 at 6:37 PM, Harmeet Bedi harmeet.b...@gmail.comwrote: I feel it is worth looking at the other way too. If ofbiz were to move towards reusing projects like hibernate and spring and generalize some of the cool concepts into reusable libraries packaged through something like Apache Commons or ofbiz subprojects it would drive adoption. By resuable i mean things like XML form based langugage, renderers. minilang. These nice ideas do not need to be ofbiz only. I realize this is difficult and not immediate focus of ofiz.. I am also sure this may not always be best design or priority fit. .. but it does cause practical problems - developers pay by not learning other things that are potentially more mature in design and popularity, this in turn can lead to lower financial returns as outlined by Christopher. For employers, if a developer votes with their feet a lot of training investment is lost. Books really help. Cost of understanding and maintaining ofbiz based projects and having developers feel it is the right thing to learn is very important i feel. Harmeet - Original Message - From: Ruth Hoffman rhoff...@aesolves.com The more new adopters we get, the more likely OFBiz will be brought into the enterprise and become mainstream. And then the secret will be out and everyone will be salivating all over it - just like the do with Spring and Hibernate. Christopher Snow wrote: I spend a lot of time learning. I am learning new systems all the time and to date I have implemented a multitude of opensource solutions . I enjoy learning, I enjoy new technologies. ... When looking at returns, as a contractor, I usually notice what skills the UK job boards are asking for. I have seen a few jobs recently asking for adempiere and compiere skills. I have not seen many jobs requiring ofbiz skills, but I do have a number of small companies that want bespoke enterprise application development that suits the ofbiz framework. -- Jonatan Soto Aguilera C/ Comte Borrell, 328 3º4ª 08029 Barcelona Telf: +34935350010 Móvil: +34669908135 www.japanflavour.com
