Orders not submitting
Hello, Today we can't get order to submit and create in ofbiz. This is the error that we get. The Following Errors Occurred: Did not complete the order, the following occurred:Caught generic service exception while getting order Id How do we fix this?
Invoice before shipment
Hello, How can we invoice a sales order before the product has been shipped? Our customer is setup on Prepayment terms. Justine
Ofbiz Demos
Hello, Does anyone know when the Ofbiz demos will be back up again? -Justine
Import CSV
Hello, I am trying to import products using CSV. The ofbiz docs have some documentation but are very vague. How do I get the data file to upload CSV files? Justine
Re: Price Rules and Customer Classifications
Hello, We tried that and still, nothing works. We even tried a specific product SKU and it still didn't work. Is there any other way to limit a certain customer classification from ordering certain items? On Wed, Dec 8, 2021 at 8:49 AM Jason RJ wrote: > Hi Justine > > This is mostly from memory of situations I've seen, I seem to recall > having issues with PartyClassifications in rules, as an experiment it > might be worth checking using a different condition on the price rule > instead of Party Classification (even just a PartyId) you could also try > setting them to $0.50 instead and see if that works just to sanity check > the rule logic because the price calculations might be preferring a > different non-zero price. > > Jason > > On 07/12/2021 21:56, Justine Nowak wrote: > > Hello, > > > > We have decided that some of our customers shouldn't be allowed to > submit a > > sales order. We have approached this by creating a category called "No > > Sales" and when we want products to not be sold to a customer we add them > > to this category. We also add our customers to a party classification. > This > > way we set up a price rule that sets the sale price for products under a > > category and for users under a specific classification to $0.00 limiting > > them from ordering that product. > > > > But when we do this it doesn't work. How can we fix this? > > > > Thanks Justine > > >
Price Rules and Customer Classifications
Hello, We have decided that some of our customers shouldn't be allowed to submit a sales order. We have approached this by creating a category called "No Sales" and when we want products to not be sold to a customer we add them to this category. We also add our customers to a party classification. This way we set up a price rule that sets the sale price for products under a category and for users under a specific classification to $0.00 limiting them from ordering that product. But when we do this it doesn't work. How can we fix this? Thanks Justine
Quote PDf not loading, ERROR
Hello, When I click the PDF button on a quotes page, a new tab opens up but instead of the pdf loading, I get the following error message. The Following Errors Occurred: Unable to transform FO file: org.apache.fop.apps.FOPException: javax.xml.transform.TransformerException: org.apache.fop.fo.ValidationException: null:35:34: "fo:table-cell" is missing child elements. Required content model: marker* (%block;)+ (See position 35:34) javax.xml.transform.TransformerException: org.apache.fop.fo.ValidationException: null:35:34: "fo:table-cell" is missing child elements. Required content model: marker* (%block;)+ (See position 35:34)
Re: CSS not loading
Hi Jacques, We are using Mysql, what command would we use for Mysql. On Mon, Nov 15, 2021 at 3:08 AM Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > Hi Justine, > > Are you using Derby (OOTB DBMS) or another external DBMS like Postgres? > In the 1st case simply try "gradlew cleanData loadAll ofbiz" > > HTH > > Jacques > > Le 14/11/2021 à 20:32, Justine Nowak a écrit : > > Hello, > > > > We rebuilt Ofbiz to get the NPM to load all the files and we now get the > > following error on our website. > > > > *Type* Exception Report > > > > *Message* Could not get next sequenced ID for sequence name: Visit > > > > *Description* The server encountered an unexpected condition that > prevented > > it from fulfilling the request. > > > > *Exception* > > > > java.lang.IllegalArgumentException: Could not get next sequenced ID > > for sequence name: Visit > > > > org.apache.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2362) > > > > org.apache.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2349) > > > org.apache.ofbiz.entity.GenericEntity.setNextSeqId(GenericEntity.java:726) > > > > org.apache.ofbiz.entity.GenericDelegator.createSetNextSeqId(GenericDelegator.java:784) > > > org.apache.ofbiz.webapp.stats.VisitHandler.getVisit(VisitHandler.java:189) > > > org.apache.ofbiz.webapp.stats.VisitHandler.getVisitId(VisitHandler.java:100) > > > > org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:214) > > > org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:96) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:655) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:764) > > > org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) > > > > org.apache.ofbiz.webapp.control.SameSiteFilter.doFilter(SameSiteFilter.java:45) > > > > org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185) > > > > org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:156) > > javax.servlet.http.HttpFilter.doFilter(HttpFilter.java:57) > > > > org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) > > > > *Note* The full stack trace of the root cause is available in the server > > logs. > > > > > > > > > > On Sun, Nov 14, 2021 at 1:22 AM Jacques Le Roux < > > jacques.le.r...@les7arts.com> wrote: > > > >> Hi Justine, > >> > >> Actually it's normally loaded by npm when you build OFBiz with Gradle. > >> Gradle uses the > >> https://plugins.gradle.org/plugin/com.github.node-gradle.node plugin > for > >> executing loading few js libs. > >> > >> What are you actually doing "When [you] go to open the JS files tomcat"? > >> > >> > >> Le 14/11/2021 à 06:17, Justine Nowak a écrit : > >>> Hi Jacques, > >>> > >>> When I go to open the JS files tomcat gives me this output- The > requested > >>> resource [/common/js/node_modules/jquery/dist/jquery.min.js] is not > >>> available > >>> > >>> Where do I download the JS libs or does NPM do that? > >>> > >>> > >>> On Sat, Nov 13, 2021 at 2:48 AM Jacques Le Roux < > >>> jacques.le.r...@les7arts.com> wrote: > >>> > >>>> Forgot: note that when I speak about trunk and R18 I always speak > about > >>>> the HEAD versions, ie the last up to date versions. > >>>> > >>>> Le 13/11/2021 à 09:38, Jacques Le Roux a écrit : > >>>>> Hi Justine, > >>>>> > >>>>> Mmm, that's no good. I know you made a versions mix at a moment. > Which > >>>> version are you now using? Or at least what is your primarily version? > >>>>> Because in trunk we now use npm to dynamically load (once) some js > libs > >>>> (jQuery is one) but in R18 all js libs are preloaded. > >>>>> As I see jquery-ui-1.13.0.min.js, I can conclude that you are rather > >>>> basically using a R18 version. In trunk, npm dynamically loads > jquery-ui > >>>> and we > >>>>> no longer put the version in the file name (it's anyway inside the > >>>> file). So check that you have all the js libs downloaded. > >>>>> I think you can neglect the 2nd point
Re: CSS not loading
Forgot the previous email, we fixed it. But still, after rebuilding Ofbiz we still don't have the Javascript libs created. On Sun, Nov 14, 2021 at 1:32 PM Justine Nowak wrote: > Hello, > > We rebuilt Ofbiz to get the NPM to load all the files and we now get the > following error on our website. > > *Type* Exception Report > > *Message* Could not get next sequenced ID for sequence name: Visit > > *Description* The server encountered an unexpected condition that > prevented it from fulfilling the request. > > *Exception* > > java.lang.IllegalArgumentException: Could not get next sequenced ID for > sequence name: Visit > > org.apache.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2362) > > org.apache.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2349) > > org.apache.ofbiz.entity.GenericEntity.setNextSeqId(GenericEntity.java:726) > > org.apache.ofbiz.entity.GenericDelegator.createSetNextSeqId(GenericDelegator.java:784) > > org.apache.ofbiz.webapp.stats.VisitHandler.getVisit(VisitHandler.java:189) > > org.apache.ofbiz.webapp.stats.VisitHandler.getVisitId(VisitHandler.java:100) > > org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:214) > > org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:96) > javax.servlet.http.HttpServlet.service(HttpServlet.java:655) > javax.servlet.http.HttpServlet.service(HttpServlet.java:764) > org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) > > org.apache.ofbiz.webapp.control.SameSiteFilter.doFilter(SameSiteFilter.java:45) > > org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185) > > org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:156) > javax.servlet.http.HttpFilter.doFilter(HttpFilter.java:57) > > org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) > > *Note* The full stack trace of the root cause is available in the server > logs. > > > > > On Sun, Nov 14, 2021 at 1:22 AM Jacques Le Roux < > jacques.le.r...@les7arts.com> wrote: > >> Hi Justine, >> >> Actually it's normally loaded by npm when you build OFBiz with Gradle. >> Gradle uses the >> https://plugins.gradle.org/plugin/com.github.node-gradle.node plugin for >> executing loading few js libs. >> >> What are you actually doing "When [you] go to open the JS files tomcat"? >> >> >> Le 14/11/2021 à 06:17, Justine Nowak a écrit : >> > Hi Jacques, >> > >> > When I go to open the JS files tomcat gives me this output- The >> requested >> > resource [/common/js/node_modules/jquery/dist/jquery.min.js] is not >> > available >> > >> > Where do I download the JS libs or does NPM do that? >> > >> > >> > On Sat, Nov 13, 2021 at 2:48 AM Jacques Le Roux < >> > jacques.le.r...@les7arts.com> wrote: >> > >> >> Forgot: note that when I speak about trunk and R18 I always speak about >> >> the HEAD versions, ie the last up to date versions. >> >> >> >> Le 13/11/2021 à 09:38, Jacques Le Roux a écrit : >> >>> Hi Justine, >> >>> >> >>> Mmm, that's no good. I know you made a versions mix at a moment. Which >> >> version are you now using? Or at least what is your primarily version? >> >>> Because in trunk we now use npm to dynamically load (once) some js >> libs >> >> (jQuery is one) but in R18 all js libs are preloaded. >> >>> As I see jquery-ui-1.13.0.min.js, I can conclude that you are rather >> >> basically using a R18 version. In trunk, npm dynamically loads >> jquery-ui >> >> and we >> >>> no longer put the version in the file name (it's anyway inside the >> >> file). So check that you have all the js libs downloaded. >> >>> I think you can neglect the 2nd point. It's a [Report Only]: >> >>> >> >> >> https://developer.mozilla.org/en-US/docs/Web/HTTP/Headers/Content-Security-Policy-Report-Only >> >>> This said where do you get this error (URL)? >> >>> >> >>> HTH >> >>> >> >>> Jacques >> >>> >> >>> >> >>> Le 13/11/2021 à 06:39, Justine Nowak a écrit : >> >>>> Hi Jacques, >> >>>> >> >>>> This is what shows when we check the Console. >> >>
Re: CSS not loading
Hello, We rebuilt Ofbiz to get the NPM to load all the files and we now get the following error on our website. *Type* Exception Report *Message* Could not get next sequenced ID for sequence name: Visit *Description* The server encountered an unexpected condition that prevented it from fulfilling the request. *Exception* java.lang.IllegalArgumentException: Could not get next sequenced ID for sequence name: Visit org.apache.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2362) org.apache.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2349) org.apache.ofbiz.entity.GenericEntity.setNextSeqId(GenericEntity.java:726) org.apache.ofbiz.entity.GenericDelegator.createSetNextSeqId(GenericDelegator.java:784) org.apache.ofbiz.webapp.stats.VisitHandler.getVisit(VisitHandler.java:189) org.apache.ofbiz.webapp.stats.VisitHandler.getVisitId(VisitHandler.java:100) org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:214) org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:96) javax.servlet.http.HttpServlet.service(HttpServlet.java:655) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) org.apache.ofbiz.webapp.control.SameSiteFilter.doFilter(SameSiteFilter.java:45) org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185) org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:156) javax.servlet.http.HttpFilter.doFilter(HttpFilter.java:57) org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) *Note* The full stack trace of the root cause is available in the server logs. On Sun, Nov 14, 2021 at 1:22 AM Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > Hi Justine, > > Actually it's normally loaded by npm when you build OFBiz with Gradle. > Gradle uses the > https://plugins.gradle.org/plugin/com.github.node-gradle.node plugin for > executing loading few js libs. > > What are you actually doing "When [you] go to open the JS files tomcat"? > > > Le 14/11/2021 à 06:17, Justine Nowak a écrit : > > Hi Jacques, > > > > When I go to open the JS files tomcat gives me this output- The requested > > resource [/common/js/node_modules/jquery/dist/jquery.min.js] is not > > available > > > > Where do I download the JS libs or does NPM do that? > > > > > > On Sat, Nov 13, 2021 at 2:48 AM Jacques Le Roux < > > jacques.le.r...@les7arts.com> wrote: > > > >> Forgot: note that when I speak about trunk and R18 I always speak about > >> the HEAD versions, ie the last up to date versions. > >> > >> Le 13/11/2021 à 09:38, Jacques Le Roux a écrit : > >>> Hi Justine, > >>> > >>> Mmm, that's no good. I know you made a versions mix at a moment. Which > >> version are you now using? Or at least what is your primarily version? > >>> Because in trunk we now use npm to dynamically load (once) some js libs > >> (jQuery is one) but in R18 all js libs are preloaded. > >>> As I see jquery-ui-1.13.0.min.js, I can conclude that you are rather > >> basically using a R18 version. In trunk, npm dynamically loads jquery-ui > >> and we > >>> no longer put the version in the file name (it's anyway inside the > >> file). So check that you have all the js libs downloaded. > >>> I think you can neglect the 2nd point. It's a [Report Only]: > >>> > >> > https://developer.mozilla.org/en-US/docs/Web/HTTP/Headers/Content-Security-Policy-Report-Only > >>> This said where do you get this error (URL)? > >>> > >>> HTH > >>> > >>> Jacques > >>> > >>> > >>> Le 13/11/2021 à 06:39, Justine Nowak a écrit : > >>>> Hi Jacques, > >>>> > >>>> This is what shows when we check the Console. > >>>> > >>>> Uncaught ReferenceError: jQuery is not defined > >>>> at jquery-ui-1.13.0.min.js:6 > >>>> at jquery-ui-1.13.0.min.js:6 > >>>> > >>>> [Report Only] Refused to load the stylesheet ' > >>>> > >> > https://fonts.googleapis.com/css2?family=Quicksand:wght@300;400;500;600;700&display=swap > >> ' > >>>> because it violates the following Content Security Policy directive: > >>>> "default-src 'self'". Note that 'style-src-elem' was not explicitly
Re: CSS not loading
Hi Jacques, When I go to open the JS files tomcat gives me this output- The requested resource [/common/js/node_modules/jquery/dist/jquery.min.js] is not available Where do I download the JS libs or does NPM do that? On Sat, Nov 13, 2021 at 2:48 AM Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > Forgot: note that when I speak about trunk and R18 I always speak about > the HEAD versions, ie the last up to date versions. > > Le 13/11/2021 à 09:38, Jacques Le Roux a écrit : > > Hi Justine, > > > > Mmm, that's no good. I know you made a versions mix at a moment. Which > version are you now using? Or at least what is your primarily version? > > > > Because in trunk we now use npm to dynamically load (once) some js libs > (jQuery is one) but in R18 all js libs are preloaded. > > > > As I see jquery-ui-1.13.0.min.js, I can conclude that you are rather > basically using a R18 version. In trunk, npm dynamically loads jquery-ui > and we > > no longer put the version in the file name (it's anyway inside the > file). So check that you have all the js libs downloaded. > > > > I think you can neglect the 2nd point. It's a [Report Only]: > > > https://developer.mozilla.org/en-US/docs/Web/HTTP/Headers/Content-Security-Policy-Report-Only > > This said where do you get this error (URL)? > > > > HTH > > > > Jacques > > > > > > Le 13/11/2021 à 06:39, Justine Nowak a écrit : > >> Hi Jacques, > >> > >> This is what shows when we check the Console. > >> > >> Uncaught ReferenceError: jQuery is not defined > >> at jquery-ui-1.13.0.min.js:6 > >> at jquery-ui-1.13.0.min.js:6 > >> > >> [Report Only] Refused to load the stylesheet ' > >> > https://fonts.googleapis.com/css2?family=Quicksand:wght@300;400;500;600;700&display=swap > ' > >> because it violates the following Content Security Policy directive: > >> "default-src 'self'". Note that 'style-src-elem' was not explicitly > set, so > >> 'default-src' is used as a fallback. > >> > >> > >> > >> On Fri, Nov 12, 2021 at 1:52 AM Jacques Le Roux < > >> jacques.le.r...@les7arts.com> wrote: > >> > >>> Hi, > >>> > >>> You did not give enough information to help you. I suggest to have a > look > >>> with the js console in your browser (F12 key there) > >>> > >>> Jacques > >>> > >>> Le 11/11/2021 à 03:38, Justine Nowak a écrit : > >>>> Hello, > >>>> > >>>> We got everything fixed, the CSS has not loaded and the system > upgrade is > >>>> finished. But once again we run into a product, non of the javascript > is > >>>> working, the button inside of the text field to bring up the popup > search > >>>> isn't showing and non of the expanded forms are opening up. > >>>> > >>>> How do we fix this? > >>>> > >>>> > >>>> On Sun, Nov 7, 2021 at 2:18 AM Pierre Smits > >>> wrote: > >>>>> Goeiemoarn Justine, > >>>>> > >>>>> If the backend database of your OFBiz implementation is professional > >>> grade > >>>>> (meaning anything else than the default integrated Apache Derby), > >>> cleanAll > >>>>> won't delete your data. > >>>>> > >>>>> > >>>>> > >>>>> Met vriendelijke groet, > >>>>> > >>>>> Pierre Smits > >>>>> *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> > >>> since > >>>>> 2008 (without privileges) > >>>>> Proud contributor to the ASF since 2006 > >>>>> > >>>>> *Apache Directory <https://directory.apache.org>, PMC Member* > >>>>> > >>>>> > >>>>> On Sun, Nov 7, 2021 at 7:42 AM Jacques Le Roux < > >>>>> jacques.le.r...@les7arts.com> > >>>>> wrote: > >>>>> > >>>>>> Hi Justine, > >>>>>> > >>>>>> It will "only" replace the current DB content by the demo data. So > if > >>> you > >>>>>> have important data there you need to keep a dump and then > meticulously > >>>>>> replace it again. If you don'
Re: CSS not loading
Hi Jacques, This is what shows when we check the Console. Uncaught ReferenceError: jQuery is not defined at jquery-ui-1.13.0.min.js:6 at jquery-ui-1.13.0.min.js:6 [Report Only] Refused to load the stylesheet ' https://fonts.googleapis.com/css2?family=Quicksand:wght@300;400;500;600;700&display=swap' because it violates the following Content Security Policy directive: "default-src 'self'". Note that 'style-src-elem' was not explicitly set, so 'default-src' is used as a fallback. On Fri, Nov 12, 2021 at 1:52 AM Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > Hi, > > You did not give enough information to help you. I suggest to have a look > with the js console in your browser (F12 key there) > > Jacques > > Le 11/11/2021 à 03:38, Justine Nowak a écrit : > > Hello, > > > > We got everything fixed, the CSS has not loaded and the system upgrade is > > finished. But once again we run into a product, non of the javascript is > > working, the button inside of the text field to bring up the popup search > > isn't showing and non of the expanded forms are opening up. > > > > How do we fix this? > > > > > > On Sun, Nov 7, 2021 at 2:18 AM Pierre Smits > wrote: > > > >> Goeiemoarn Justine, > >> > >> If the backend database of your OFBiz implementation is professional > grade > >> (meaning anything else than the default integrated Apache Derby), > cleanAll > >> won't delete your data. > >> > >> > >> > >> Met vriendelijke groet, > >> > >> Pierre Smits > >> *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> > since > >> 2008 (without privileges) > >> Proud contributor to the ASF since 2006 > >> > >> *Apache Directory <https://directory.apache.org>, PMC Member* > >> > >> > >> On Sun, Nov 7, 2021 at 7:42 AM Jacques Le Roux < > >> jacques.le.r...@les7arts.com> > >> wrote: > >> > >>> Hi Justine, > >>> > >>> It will "only" replace the current DB content by the demo data. So if > you > >>> have important data there you need to keep a dump and then meticulously > >>> replace it again. If you don't want all the demo date load only the > seed. > >>> checkhttps:// > >>> > >> > ci.apache.org/projects/ofbiz/site/trunk/readme/html5/README.html#data-loading-tasks > >>> out > >>> > >>> With something like|< >>> readers=seed,seed-initial,ext,ext-demo">> you don't have to fear for > you > >>> own templates. Only data will be affected. Jacques | > >>> > >>> Le 06/11/2021 à 22:32, Justine Nowak a écrit : > >>>> Thank you for this information Jacques, > >>>> > >>>> gradlew cleanData loadAll - If we do this will it remove our database > >>>> content, or will it just load the ofbiz files. And if we have > >> customized > >>>> template files can we just save them and reupload them after? > >>>> > >>>> > >>>> On Sat, Nov 6, 2021 at 2:58 PM Jacques Le Roux< > >>> jacques.le.r...@les7arts.com> > >>>> wrote: > >>>> > >>>>> Hi Justine, > >>>>> > >>>>> Inline... > >>>>> > >>>>> Le 06/11/2021 à 20:46, Justine Nowak a écrit : > >>>>>> maybe mixing trunk data with 18 design perhaps?? > >>>>>> > >>>>>> I believe that is the issue, how would we go with resolving this? > >>>>> I believe a simple "gradlew cleanData loadAll" should work if you > have > >>> not > >>>>> mixed code between R18 and trunk. If you mixed code then you must > >> start > >>>>> from scratch being sure that you keep the your own modified code. > >>>>>> Also,version 18.12 doesn't include the Helveticus themes. > >>>>> If you want Helveticus then you must use trunk > >>>>> > >>>>> HTH > >>>>> > >>>>> Jacques > >>>>> > >>>>>> -Justine > >>>>>> > >>>>>> On Sat, Nov 6, 2021 at 7:35 AM Pierre Smits > >>>>> wrote: > >>>>>>> Bonjour Justine, > >>>>>>> > >>>>
Re: CSS not loading
Hello, We got everything fixed, the CSS has not loaded and the system upgrade is finished. But once again we run into a product, non of the javascript is working, the button inside of the text field to bring up the popup search isn't showing and non of the expanded forms are opening up. How do we fix this? On Sun, Nov 7, 2021 at 2:18 AM Pierre Smits wrote: > Goeiemoarn Justine, > > If the backend database of your OFBiz implementation is professional grade > (meaning anything else than the default integrated Apache Derby), cleanAll > won't delete your data. > > > > Met vriendelijke groet, > > Pierre Smits > *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since > 2008 (without privileges) > Proud contributor to the ASF since 2006 > > *Apache Directory <https://directory.apache.org>, PMC Member* > > > On Sun, Nov 7, 2021 at 7:42 AM Jacques Le Roux < > jacques.le.r...@les7arts.com> > wrote: > > > Hi Justine, > > > > It will "only" replace the current DB content by the demo data. So if you > > have important data there you need to keep a dump and then meticulously > > replace it again. If you don't want all the demo date load only the seed. > > checkhttps:// > > > ci.apache.org/projects/ofbiz/site/trunk/readme/html5/README.html#data-loading-tasks > > out > > > > With something like|< > readers=seed,seed-initial,ext,ext-demo">> you don't have to fear for you > > own templates. Only data will be affected. Jacques | > > > > Le 06/11/2021 à 22:32, Justine Nowak a écrit : > > > Thank you for this information Jacques, > > > > > > gradlew cleanData loadAll - If we do this will it remove our database > > > content, or will it just load the ofbiz files. And if we have > customized > > > template files can we just save them and reupload them after? > > > > > > > > > On Sat, Nov 6, 2021 at 2:58 PM Jacques Le Roux< > > jacques.le.r...@les7arts.com> > > > wrote: > > > > > >> Hi Justine, > > >> > > >> Inline... > > >> > > >> Le 06/11/2021 à 20:46, Justine Nowak a écrit : > > >>> maybe mixing trunk data with 18 design perhaps?? > > >>> > > >>> I believe that is the issue, how would we go with resolving this? > > >> I believe a simple "gradlew cleanData loadAll" should work if you have > > not > > >> mixed code between R18 and trunk. If you mixed code then you must > start > > >> from scratch being sure that you keep the your own modified code. > > >>> Also,version 18.12 doesn't include the Helveticus themes. > > >> If you want Helveticus then you must use trunk > > >> > > >> HTH > > >> > > >> Jacques > > >> > > >>> -Justine > > >>> > > >>> On Sat, Nov 6, 2021 at 7:35 AM Pierre Smits > > >> wrote: > > >>>> Bonjour Justine, > > >>>> > > >>>> As the 18 branch has come available as a demo site, we can now - in > a > > >> handy > > >>>> kind of way - compare local implementations against what is in the > > repo. > > >>>> See e.ghttps://demo-stable.ofbiz.apache.org/accounting > > >>>> > > >>>> As it shows nothing wrong there, it seems that a mixup of events at > > your > > >>>> side (maybe mixing trunk data with 18 design perhaps??) led to the > > issue > > >>>> you reported here. > > >>>> > > >>>> I trust everything is ok now. > > >>>> > > >>>> Met vriendelijke groet, > > >>>> > > >>>> Pierre Smits > > >>>> *Proud* *contributor** of* Apache OFBiz<https://ofbiz.apache.org/> > > >> since > > >>>> 2008 (without privileges) > > >>>> Proud contributor to the ASF since 2006 > > >>>> > > >>>> *Apache Directory<https://directory.apache.org>, PMC Member* > > >>>> > > >>>> > > >>>> On Sat, Nov 6, 2021 at 1:10 AM Justine Nowak > > >>>> wrote: > > >>>> > > >>>>> Are you confident that data sets were loaded correctly? > > >>>>> > > >>>>> I'm not sure they were, we did try to upgrade Ofbiz last week to > > 18.12 > > >&g
Re: Product Specifications
Thank you Jason, Also how do we show the product features to the eCommerce site? On Tue, Nov 9, 2021 at 4:57 AM Jason RJ wrote: > Hi Justine, > > On the Product->Feature page at the bottom you can add "Product Feature > Attributes" so for example if you have a Product Feature assigned such > as "Camera" for a mobile phone, then you add Feature Attributes > Name/Value pairs e.g. "Flash":"Yes", "Main Camera":"12.0mp", "Image Geo > Tagging":"Yes". > > Jason > > On 08/11/2021 21:33, Justine Nowak wrote: > > Hello, > > > > How do we add custom product specifications and how do we display them on > > the e-commerce website? This would have to be dynamic templating because > > each product could have a different spec with a different value. Do we > use > > attributes or features or something else? > > > > > > > > Example:https://imgur.com/a/7R3hdYx > > > > -Justine > >
Product Specifications
Hello, How do we add custom product specifications and how do we display them on the e-commerce website? This would have to be dynamic templating because each product could have a different spec with a different value. Do we use attributes or features or something else? Example: https://imgur.com/a/7R3hdYx -Justine
Re: CSS not loading
Thank you for this information Jacques, gradlew cleanData loadAll - If we do this will it remove our database content, or will it just load the ofbiz files. And if we have customized template files can we just save them and reupload them after? On Sat, Nov 6, 2021 at 2:58 PM Jacques Le Roux wrote: > Hi Justine, > > Inline... > > Le 06/11/2021 à 20:46, Justine Nowak a écrit : > > maybe mixing trunk data with 18 design perhaps?? > > > > I believe that is the issue, how would we go with resolving this? > I believe a simple "gradlew cleanData loadAll" should work if you have not > mixed code between R18 and trunk. If you mixed code then you must start > from scratch being sure that you keep the your own modified code. > > Also,version 18.12 doesn't include the Helveticus themes. > > If you want Helveticus then you must use trunk > > HTH > > Jacques > > > > > -Justine > > > > On Sat, Nov 6, 2021 at 7:35 AM Pierre Smits > wrote: > > > >> Bonjour Justine, > >> > >> As the 18 branch has come available as a demo site, we can now - in a > handy > >> kind of way - compare local implementations against what is in the repo. > >> See e.g https://demo-stable.ofbiz.apache.org/accounting > >> > >> As it shows nothing wrong there, it seems that a mixup of events at your > >> side (maybe mixing trunk data with 18 design perhaps??) led to the issue > >> you reported here. > >> > >> I trust everything is ok now. > >> > >> Met vriendelijke groet, > >> > >> Pierre Smits > >> *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> > since > >> 2008 (without privileges) > >> Proud contributor to the ASF since 2006 > >> > >> *Apache Directory <https://directory.apache.org>, PMC Member* > >> > >> > >> On Sat, Nov 6, 2021 at 1:10 AM Justine Nowak > >> wrote: > >> > >>> Are you confident that data sets were loaded correctly? > >>> > >>> I'm not sure they were, we did try to upgrade Ofbiz last week to 18.12 > >> but > >>> that was unsuccessful so we reverted back to the Trunk version. > >>> > >>> > >>> On Fri, Nov 5, 2021 at 2:40 AM Pierre Smits > >>> wrote: > >>> > >>>> Bore Da Justine, > >>>> > >>>> Weird. I tried it using the various applications with the themes > >>> available > >>>> in trunk this morning, and could not detect anything wrong on first > >>> sight > >>>> (visual inspection in browser and in log). > >>>> > >>>> Are you confident that data sets were loaded correctly? > >>>> > >>>> Met vriendelijke groet, > >>>> > >>>> Pierre Smits > >>>> *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> > >>> since > >>>> 2008 (without privileges) > >>>> Proud contributor to the ASF since 2006 > >>>> > >>>> *Apache Directory <https://directory.apache.org>, PMC Member* > >>>> > >>>> > >>>> On Thu, Nov 4, 2021 at 6:43 PM Justine Nowak > >>>> wrote: > >>>> > >>>>> Hi Pierre, > >>>>> > >>>>> We are using the Trunk version and there are no custom CSS / themes. > >>>>> > >>>>> > >>>>> On Thu, Nov 4, 2021 at 4:09 AM Pierre Smits > >>>>> wrote: > >>>>> > >>>>>> Bonjour Justine, > >>>>>> > >>>>>> Unfortunately, settings regarding this mailing list doesn't allow > >>>>>> attachments to come through. > >>>>>> > >>>>>> Can you tell which OFBiz version you are using, and whether the > >>>> theme/css > >>>>>> is custom? > >>>>>> > >>>>>> > >>>>>> > >>>>>> Met vriendelijke groet, > >>>>>> > >>>>>> Pierre Smits > >>>>>> *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/ > >>>>> since > >>>>>> 2008 (without privileges) > >>>>>> > >>>>>> *Apache Directory <https://directory.apache.org>, PMC Member* > >>>>>> Apache Incubator <https://incubator.apache.org>, committer > >>>>>> Apache Steve <https://steve.apache.org>, committer > >>>>>> > >>>>>> > >>>>>> On Wed, Nov 3, 2021 at 9:49 PM Justine Nowak < > >> cougar11...@gmail.com> > >>>>>> wrote: > >>>>>> > >>>>>>> Hello, > >>>>>>> > >>>>>>> The past few days our css in our backend applications (catalog, > >>>>> partymgr, > >>>>>>> webtools) has not been loading. > >>>>>>> [image: Screen Shot 2021-11-03 at 3.47.51 PM.png] > >>>>>>> > >>>>>>> The HTML code shows the CSS link connected but it doesn't render > >>> it. > >>>>> Even > >>>>>>> after refreshing and clearing all cookies, and on multiple > >> devices. > >>>>>>> How do we fix this? > >>>>>>> > >>>>>>> -Justine > >>>>>>> >
Re: CSS not loading
maybe mixing trunk data with 18 design perhaps?? I believe that is the issue, how would we go with resolving this? Also, version 18.12 doesn't include the Helveticus themes. -Justine On Sat, Nov 6, 2021 at 7:35 AM Pierre Smits wrote: > Bonjour Justine, > > As the 18 branch has come available as a demo site, we can now - in a handy > kind of way - compare local implementations against what is in the repo. > See e.g https://demo-stable.ofbiz.apache.org/accounting > > As it shows nothing wrong there, it seems that a mixup of events at your > side (maybe mixing trunk data with 18 design perhaps??) led to the issue > you reported here. > > I trust everything is ok now. > > Met vriendelijke groet, > > Pierre Smits > *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since > 2008 (without privileges) > Proud contributor to the ASF since 2006 > > *Apache Directory <https://directory.apache.org>, PMC Member* > > > On Sat, Nov 6, 2021 at 1:10 AM Justine Nowak > wrote: > > > Are you confident that data sets were loaded correctly? > > > > I'm not sure they were, we did try to upgrade Ofbiz last week to 18.12 > but > > that was unsuccessful so we reverted back to the Trunk version. > > > > > > On Fri, Nov 5, 2021 at 2:40 AM Pierre Smits > > wrote: > > > > > Bore Da Justine, > > > > > > Weird. I tried it using the various applications with the themes > > available > > > in trunk this morning, and could not detect anything wrong on first > > sight > > > (visual inspection in browser and in log). > > > > > > Are you confident that data sets were loaded correctly? > > > > > > Met vriendelijke groet, > > > > > > Pierre Smits > > > *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> > > since > > > 2008 (without privileges) > > > Proud contributor to the ASF since 2006 > > > > > > *Apache Directory <https://directory.apache.org>, PMC Member* > > > > > > > > > On Thu, Nov 4, 2021 at 6:43 PM Justine Nowak > > > wrote: > > > > > > > Hi Pierre, > > > > > > > > We are using the Trunk version and there are no custom CSS / themes. > > > > > > > > > > > > On Thu, Nov 4, 2021 at 4:09 AM Pierre Smits > > > > wrote: > > > > > > > > > Bonjour Justine, > > > > > > > > > > Unfortunately, settings regarding this mailing list doesn't allow > > > > > attachments to come through. > > > > > > > > > > Can you tell which OFBiz version you are using, and whether the > > > theme/css > > > > > is custom? > > > > > > > > > > > > > > > > > > > > Met vriendelijke groet, > > > > > > > > > > Pierre Smits > > > > > *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/ > > > > > > since > > > > > 2008 (without privileges) > > > > > > > > > > *Apache Directory <https://directory.apache.org>, PMC Member* > > > > > Apache Incubator <https://incubator.apache.org>, committer > > > > > Apache Steve <https://steve.apache.org>, committer > > > > > > > > > > > > > > > On Wed, Nov 3, 2021 at 9:49 PM Justine Nowak < > cougar11...@gmail.com> > > > > > wrote: > > > > > > > > > > > Hello, > > > > > > > > > > > > The past few days our css in our backend applications (catalog, > > > > partymgr, > > > > > > webtools) has not been loading. > > > > > > [image: Screen Shot 2021-11-03 at 3.47.51 PM.png] > > > > > > > > > > > > The HTML code shows the CSS link connected but it doesn't render > > it. > > > > Even > > > > > > after refreshing and clearing all cookies, and on multiple > devices. > > > > > > > > > > > > How do we fix this? > > > > > > > > > > > > -Justine > > > > > > > > > > > > > > > > > > > > >
Re: CSS not loading
Are you confident that data sets were loaded correctly? I'm not sure they were, we did try to upgrade Ofbiz last week to 18.12 but that was unsuccessful so we reverted back to the Trunk version. On Fri, Nov 5, 2021 at 2:40 AM Pierre Smits wrote: > Bore Da Justine, > > Weird. I tried it using the various applications with the themes available > in trunk this morning, and could not detect anything wrong on first sight > (visual inspection in browser and in log). > > Are you confident that data sets were loaded correctly? > > Met vriendelijke groet, > > Pierre Smits > *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since > 2008 (without privileges) > Proud contributor to the ASF since 2006 > > *Apache Directory <https://directory.apache.org>, PMC Member* > > > On Thu, Nov 4, 2021 at 6:43 PM Justine Nowak > wrote: > > > Hi Pierre, > > > > We are using the Trunk version and there are no custom CSS / themes. > > > > > > On Thu, Nov 4, 2021 at 4:09 AM Pierre Smits > > wrote: > > > > > Bonjour Justine, > > > > > > Unfortunately, settings regarding this mailing list doesn't allow > > > attachments to come through. > > > > > > Can you tell which OFBiz version you are using, and whether the > theme/css > > > is custom? > > > > > > > > > > > > Met vriendelijke groet, > > > > > > Pierre Smits > > > *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> > > since > > > 2008 (without privileges) > > > > > > *Apache Directory <https://directory.apache.org>, PMC Member* > > > Apache Incubator <https://incubator.apache.org>, committer > > > Apache Steve <https://steve.apache.org>, committer > > > > > > > > > On Wed, Nov 3, 2021 at 9:49 PM Justine Nowak > > > wrote: > > > > > > > Hello, > > > > > > > > The past few days our css in our backend applications (catalog, > > partymgr, > > > > webtools) has not been loading. > > > > [image: Screen Shot 2021-11-03 at 3.47.51 PM.png] > > > > > > > > The HTML code shows the CSS link connected but it doesn't render it. > > Even > > > > after refreshing and clearing all cookies, and on multiple devices. > > > > > > > > How do we fix this? > > > > > > > > -Justine > > > > > > > > > >
Re: CSS not loading
Hi Pierre, We are using the Trunk version and there are no custom CSS / themes. On Thu, Nov 4, 2021 at 4:09 AM Pierre Smits wrote: > Bonjour Justine, > > Unfortunately, settings regarding this mailing list doesn't allow > attachments to come through. > > Can you tell which OFBiz version you are using, and whether the theme/css > is custom? > > > > Met vriendelijke groet, > > Pierre Smits > *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since > 2008 (without privileges) > > *Apache Directory <https://directory.apache.org>, PMC Member* > Apache Incubator <https://incubator.apache.org>, committer > Apache Steve <https://steve.apache.org>, committer > > > On Wed, Nov 3, 2021 at 9:49 PM Justine Nowak > wrote: > > > Hello, > > > > The past few days our css in our backend applications (catalog, partymgr, > > webtools) has not been loading. > > [image: Screen Shot 2021-11-03 at 3.47.51 PM.png] > > > > The HTML code shows the CSS link connected but it doesn't render it. Even > > after refreshing and clearing all cookies, and on multiple devices. > > > > How do we fix this? > > > > -Justine > > >
CSS not loading
Hello, The past few days our css in our backend applications (catalog, partymgr, webtools) has not been loading. [image: Screen Shot 2021-11-03 at 3.47.51 PM.png] The HTML code shows the CSS link connected but it doesn't render it. Even after refreshing and clearing all cookies, and on multiple devices. How do we fix this? -Justine
Quote Quantity field
Hello, I am trying to create a quote item but run into the issue with the "Quantity" field. The quote is successfully created but when I go to add a quote item the "Quantity" field is empty, there is no text field to add the quantity for that item. Also, How do we add shipping estimates to a quote? Thanks, Justine
user@ofbiz.apache.org
Hi Steve, Just tried that and got the following error. The Following Errors Occurred: ERROR: parsing file: ERROR parsing Entity Xml file: org.xml.sax.SAXException: A transaction error occurred reading dataorg.xml.sax.SAXException: Fatal Error reading XML on line 2, column 409org.xml.sax.SAXParseException; lineNumber: 2; columnNumber: 409; Element type "Product" must be followed by either attribute specifications, ">" or "/>". Thanks, Justine On Sun, Oct 24, 2021 at 12:16 PM Steven Payne wrote: > Hi Justine, > > You need to escape some of those characters. the "&" needs to be replaced > with "&" > > Regards, > Steve Payne > > On Sun, Oct 24, 2021 at 9:57 AM Justine Nowak > wrote: > > > Hello, > > > > I am trying to import our products into Ofbiz and some of our products > have > > a "&" in the productName field. For example, "Gummy with Vitamins A & D". > > > > How do we get the system to allow this product to get created? > > > > The Following Errors Occurred: > > > > ERROR: parsing file: ERROR parsing Entity Xml file: > > org.xml.sax.SAXException: A transaction error occurred reading > > dataorg.xml.sax.SAXException: Fatal Error reading XML on line 12, > > column 408org.xml.sax.SAXParseException; lineNumber: 12; > columnNumber: > > 408; The entity name must immediately follow the '&' in the entity > > reference. > > > > > > Thanks, Justine > > >
user@ofbiz.apache.org
Hello, I am trying to import our products into Ofbiz and some of our products have a "&" in the productName field. For example, "Gummy with Vitamins A & D". How do we get the system to allow this product to get created? The Following Errors Occurred: ERROR: parsing file: ERROR parsing Entity Xml file: org.xml.sax.SAXException: A transaction error occurred reading dataorg.xml.sax.SAXException: Fatal Error reading XML on line 12, column 408org.xml.sax.SAXParseException; lineNumber: 12; columnNumber: 408; The entity name must immediately follow the '&' in the entity reference. Thanks, Justine
Product Detail - Extra Information
Hello, We are trying to display extra information for our products on the eCommerce website. For instance, How do we display Good Identifications, Brand Name, Product dimensions, and Weight? What type of code do we have to create in the Template file to display this information? Thank you, Justine.
eCommerce Checkout
Hello, How do we disable checking out without a registration? And how would we disable user registration, only allowing users to log in by a username and password provided by us. Also how do we remove the Paypal Express Checkout button on the top right corner. Thank you.
eCommerce front page / Categories sidebar
Hello, How do we change the content of the front page of the eCommerce site? And also we have 20+ categories but the categories are not showing up in the categories sidebar. How do we get to do this?
Category Restrictions
Hello, How can we limit a customer to only order products that are included in a certain category?
Product Key duplicate error
Hello, We did an XML upload of a lot of SKUs into Ofbiz, but today when I go to manually add a new product without a Product Id letting the system automatically decide that. I get the following error. (SQL Exception while executing the following:null (Duplicate entry '10044' for key 'PRODUCT.PRIMARY' How do we get the system to automatically generate the Product Id based on the next one in line.
Ecommerce sitemap.xml
Hello, Does anyone know how to get a sitemap for the ecommerce website or does it already come with ofbiz?
Product Data Import xml
Hello, We have tried to import new products into Ofbiz, right now we have successfully imported product descriptions and product IDs but when it comes to importing pricing, categories, and supplier information we get the following error about the Primary key. The Following Errors Occurred: ERROR: parsing file: ERROR parsing Entity Xml file: org.xml.sax.SAXException: A transaction error occurred reading dataorg.xml.sax.SAXException: Cannot store value with incomplete primary key with more than 1 primary key field:
Re: Custom Pricing on eCommerce Storefront
Thanks Aditya, is there anyway we can also show the custom price types on the eCommerce storefront? On Wed, Oct 6, 2021 at 1:27 AM Aditya Sharma wrote: > Hello Justine, > > Here you could find list of price types available: > > https://demo-trunk.ofbiz.apache.org/webtools/control/entity/find/ProductPriceType > > Here you could find the seed data for the same: > > https://github.com/apache/ofbiz-framework/blob/75d3367d47abae604126a97a80e715a798e7fc55/applications/datamodel/data/seed/ProductSeedData.xml#L271 > > You could create prices for specific price types: > > https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductPrices?productId=WG-9943 > > For custom values, you could just create data in ProductPriceType entity. > > HTH > Thanks and Regards, > Aditya Sharma > > > On Wed, Oct 6, 2021 at 11:29 AM Justine Nowak > wrote: > > > Hello, > > > > We want to add custom pricing types to our products. For example, we > have a > > product that will have a "Default Price" (this is what gets charged to > the > > invoice), but we also need to add other price types for example, Resell > > Price / MSRP / MAP price. How do we create these new types and have them > > show up on the eCommerce site without them interfering with the actual > > selling price? > > > > -Justine > > >
Custom Pricing on eCommerce Storefront
Hello, We want to add custom pricing types to our products. For example, we have a product that will have a "Default Price" (this is what gets charged to the invoice), but we also need to add other price types for example, Resell Price / MSRP / MAP price. How do we create these new types and have them show up on the eCommerce site without them interfering with the actual selling price? -Justine
Product Minimum Quantity
Hello, We have a product that requires is sold as 24 units how do we have the system require the user to increment by 24 each time.
Re: Unable to open file for writing
Hi Deepak, We have done that, we changed permissions for all the folders and files recursively to 777, and the problem still continues. When you said accessible by the OFBiz application, should the ofbiz application have its own user or group like how apache sometimes has? On Tue, Oct 5, 2021 at 1:58 AM Deepak Nigam wrote: > Hi Justine, > > It seems the issue is permission related. Kindly check if the directory > where you are trying to keep the image (/var/www/) is accessible (read > and write permission) by the OFBiz application. > > Thanks & Regards > -- > Deepak Nigam > > > > > On Tue, Oct 5, 2021, 12:23 PM Justine Nowak wrote: > > > We have been trying to add an image to a product from the content tab, > but > > get this error message every time. We tried this in our PROD system, > > Demo-Trunk and Demo-Stable and the same error has occurred. Whenever we > try > > to add a "Add to Cart Image" > > > > > > The Following Errors Occurred: > > > > Unable to open file for writing: > > > > > /var/www/ofbiz/themes/common-theme/webapp/images/products/10010/additionalE/original.jpeg > > >
Unable to open file for writing
We have been trying to add an image to a product from the content tab, but get this error message every time. We tried this in our PROD system, Demo-Trunk and Demo-Stable and the same error has occurred. Whenever we try to add a "Add to Cart Image" The Following Errors Occurred: Unable to open file for writing: /var/www/ofbiz/themes/common-theme/webapp/images/products/10010/additionalE/original.jpeg
