Re: SEO manual

[Wolfgang Paul Rauchholz]

I checked this link. I gives me what I copy underneath. I migh be wrong,
but I do bot consider this a user manual. that explains some comcepts and
then goes down onto field level to explain at least the most relevent ones
one by one.


Wolfgang

If Search Engine Optimisation
<http://en.wikipedia.org/wiki/Search_engine_optimization> has no interest
on the backend side, because the backend  is most often used in an
intranet, it's a main concern on the eCommerce side.



In OFBiz, there are 2 ways to handle SEO on the eCommerce side of OFBiz,
depending if you use the ecommerce webapp
<https://demo-trunk.ofbiz.apache.org/ecommerce/control/main> or it's new
SEO specialised clone ecomseo webapp
<https://demo-trunk.ofbiz.apache.org/ecomseo> (since r1655803
<http://svn.apache.org/viewvc?view=revision=1655803>)

As you are probably aware, OFBiz has a pretty uncommon way of generating
URLs. Most of this has to do with the fact that OFBiz uses a servlet
(ControlServlet) to handle all requests. The servlet is mounted at
/control, so that it won't interfere with other servlets. Though
functionally valid, this has the side effect that all URLs are actually
created on /control, which is neither pretty, nor good by any measures of
SEO. It also means that a few 302 redirects are necessary to forward the
user from / to /control/main. It also makes requests more complicated,
since many forwards are necessary whenever somebody wants to move away from
this implementation. If this is acceptable for the ERP backend it's less
desirable for an eCommerce frontend. This is what you get with the ecommerce
webapp <https://demo-trunk.ofbiz.apache.org/ecommerce/control/main>. On the
other hand the SEO specialised ecomseo webapp
<https://demo-trunk.ofbiz.apache.org/ecomseo> offers you more:

   - Removal of /control out of all the urls
   - SEO-friendly URLS
   - Configurable product/category and other URLs
   - Frontpage mapping from /main to /

So before implementing your eCommerce application be sure to compare this 2
ways of doing things...

On Fri, Jul 26, 2019 at 1:48 PM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Hi Wolfgang,
>
> Did you check ecomseo?
>
>
> https://cwiki.apache.org/confluence/display/OFBIZ/Search+Engine+Optimisation%2C+SEO+in+ecommerce
>
> Jacques
>
> Le 17/07/2019 à 13:41, Wolfgang Paul Rauchholz a écrit :
> > *Screen “Content”, tab in Product Maintenance*
> >
> > Are the list of fields underneath metatags that get added to the HTML
> code
> > of e-commerce page?
> >
> >
> > - *Page Title: *Example: Tiny Gizmo : OFBiz E-Commerce Store
> > ”
> > - *Description*:Example: 
> > * Description Long: *Example:
> > 
> > This gizmo is very small and runs on solar power.
> > 
> > - *Image Alt Text – Detail/Large/Medium/Small: *Example: > http://example.com/foto.jpg” alt=”Tiny-Gizmo” />
> > * Alternative URL*: what exactly is it and what is the correct syntax?
> > I like to re-write ecomseo URLs, can I do this in standard?
> > Example: Standard ofbiz creates the following URL:
> >
> https://demo-trunk.ofbiz.apache.org/ecomseo/product/Tiny-Gizmo-GZ-1000.html
> > How can I use the system to create the following URL?
> > https://demo-trunk.ofbiz.apache.org/ > name>/Tiny-Gizmo-GZ-1000.html
> >
> > *Screen “Keywords”, tab in Product Maintenance*
> >
> > What are keywords being used for?
> >
> > What is the difference to Meta Keywords from Content Tab of the Part
> Number?
> >
> > - *Field: **Keyword Type Id: *what is the difference between “Tag”
> and
> > “Keyword”?
> > *Relevancy Weight*: what is this field being used for?
> >
> > *Questions:*
> >
> > - How can I create H1 – H6 meta tags?
> > - How can I add image long description in Ofbiz? Example:
> > http://example.com/parque-cientifico-tecnologico-albacete.jpg”
> > alt=”Longtext=”http://example.com/.html” />
> > - Does ofbiz has capability to create sitemmap.xml/.html file?
> > - How can I create canonical URLs in Ofbiz? Example:  > rel=”canonical” href=http://www..html/>
> > - How can I define in Ofbiz featured HTML snippets to support better
> > search by voice?
> >
> >
> > Thanks,Wolfgang
> >
> > On Wed, Jul 17, 2019 at 11:52 AM Swapnil M Mane  >
> > wrote:
> >
> >> Hi Wolfgang,
> >>
> >> As mentioned in my recent email on a separate thread,
> >> the link demo-trunk-ofbiz.apache.org/catalog should be
> >> demo-trunk.ofbiz.apache.org/catalog (A dot should be between,
> demo-trunk
> >> and ofbiz word)
> >>

Re: SEO manual

[Wolfgang Paul Rauchholz]

*Screen “Content”, tab in Product Maintenance*

Are the list of fields underneath metatags that get added to the HTML code
of e-commerce page?


   - *Page Title: *Example: Tiny Gizmo : OFBiz E-Commerce Store
   ”
   - *Description*:Example: 
* Description Long: *Example:
   
   This gizmo is very small and runs on solar power.
   
   - *Image Alt Text – Detail/Large/Medium/Small: *Example:http://example.com/foto.jpg” alt=”Tiny-Gizmo” />
* Alternative URL*: what exactly is it and what is the correct syntax?
   I like to re-write ecomseo URLs, can I do this in standard?
   Example: Standard ofbiz creates the following URL:
   https://demo-trunk.ofbiz.apache.org/ecomseo/product/Tiny-Gizmo-GZ-1000.html
   How can I use the system to create the following URL?
   https://demo-trunk.ofbiz.apache.org//Tiny-Gizmo-GZ-1000.html

*Screen “Keywords”, tab in Product Maintenance*

What are keywords being used for?

What is the difference to Meta Keywords from Content Tab of the Part Number?

   - *Field: **Keyword Type Id: *what is the difference between “Tag” and
   “Keyword”?
   *Relevancy Weight*: what is this field being used for?

*Questions:*

   - How can I create H1 – H6 meta tags?
   - How can I add image long description in Ofbiz? Example:
http://example.com/parque-cientifico-tecnologico-albacete.jpg”
   alt=”Longtext=”http://example.com/.html” />
   - Does ofbiz has capability to create sitemmap.xml/.html file?
   - How can I create canonical URLs in Ofbiz? Example: http://www..html/>
   - How can I define in Ofbiz featured HTML snippets to support better
   search by voice?


Thanks,Wolfgang

On Wed, Jul 17, 2019 at 11:52 AM Swapnil M Mane 
wrote:

> Hi Wolfgang,
>
> As mentioned in my recent email on a separate thread,
> the link demo-trunk-ofbiz.apache.org/catalog should be
> demo-trunk.ofbiz.apache.org/catalog (A dot should be between, demo-trunk
> and ofbiz word)
>
> P.S. Please include user mailing list in reply, in this way the wider
> audience will be available to help you :-)
>
>
> Best Regards,
> Swapnil M Mane,
> ofbiz.apache.org
>
>
>
> On Wed, Jul 17, 2019 at 12:20 PM Wolfgang Paul Rauchholz <
> wp.rauchh...@gmail.com> wrote:
>
>> Thank you Swapnil.
>>
>> I went through the document 'Search Engine Optiomization, SEO in
>> ecommerce' and also through thread 'SEO Optimizer'
>> Most of the links from the Jabber thread don't work (e.g.
>> https://demo-trunk-ofbiz.apache.org/catalog/control/EditProductContent?productId=GZ-2644
>> )
>> And the text from the Cookbook - Howto is very generic.
>> SEO is much more than keywords.
>>
>> Again, if there is somebody that is willing to explain on a field level
>> Ofbiz, I will write the manual.
>> I don't think the time required for this is much.
>>
>> Wolfgang
>>
>>
>>
>>
>> On Wed, Jul 17, 2019 at 7:19 AM Swapnil M Mane 
>> wrote:
>>
>>> Hello Wolfgang,
>>>
>>> This links [1][2] may help you.
>>>
>>> [1] http://ofbiz.135035.n4.nabble.com/SEO-Optimizer-td4725734.html
>>> [2]
>>> https://cwiki.apache.org/confluence/display/OFBIZ/Search+Engine+Optimisation%2C+SEO+in+ecommerce
>>>
>>>
>>> - Best Regards,
>>> Swapnil M Mane,
>>> ofbiz.apache.org
>>>
>>>
>>>
>>> On Tue, Jul 16, 2019 at 8:14 PM Wolfgang Paul Rauchholz <
>>> wp.rauchh...@gmail.com> wrote:
>>>
>>>> Good day,
>>>>
>>>> I was looking for a manual that explains how to do SEO with Ofbiz. I was
>>>> not able to find one and would like to create a manual myself and
>>>> publish
>>>> it for all to use.
>>>> Manual would include a short introduction as to what SEO is, elements
>>>> of it
>>>> (meta descriptions, URLs, page speed, quality content, etc..) and how
>>>> this
>>>> can be implemented with Ofbiz.
>>>> I will need a help with Ofbiz. I need to understand more in detail what
>>>> the
>>>> different fields on catalogs, categories, parts etc, ... do and what the
>>>> correct syntax is.
>>>> If there is a volunteer that can help, please send me an email and we
>>>> take
>>>> it form there.
>>>>
>>>> Thanks, Wolfgang
>>>>
>>>
>>
>> --
>>
>> Wolfgang Rauchholz
>>
>>
>>
>>

-- 

Wolfgang Rauchholz

SEO manual

[Wolfgang Paul Rauchholz]

Good day,

I was looking for a manual that explains how to do SEO with Ofbiz. I was
not able to find one and would like to create a manual myself and publish
it for all to use.
Manual would include a short introduction as to what SEO is, elements of it
(meta descriptions, URLs, page speed, quality content, etc..) and how this
can be implemented with Ofbiz.
I will need a help with Ofbiz. I need to understand more in detail what the
different fields on catalogs, categories, parts etc, ... do and what the
correct syntax is.
If there is a volunteer that can help, please send me an email and we take
it form there.

Thanks, Wolfgang

Re: VAT setup in ofbiz

[Wolfgang Paul Rauchholz]

Thank you Jacques

On Sat, Apr 13, 2019 at 6:10 PM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> It works following this tip, I just moved the 2nd and 3rd line above the
> 1st.
>
> Else you get an explaining error. You need to set the fields "Vat Tax Auth
> Geo Id"and especially "Vat Tax Auth Party Id" before setting "Show Prices
> With Vat Tax"=Y.
> I used respectively FRA and FRA_TA
>
> For the point 4.c, I set a 20% percentage for the type Value Added Tax
>
> To create this example:
> https://demo-trunk.ofbiz.apache.org/ordermgr/control/orderview?orderId=WSCO1
> where you can see a VAT of 20% (only today,
> the shared DB is only for 1 day) I ordered as FrenchCustomer (I create a
> password for it before)
>
> Because, as explained in the line for Vat Tax Auth Geo Id: "it's a default
> value, remember the VAT is applied in function of the client Geo"
>
> Et voilà
>
> HTH
>
> Jacques
>
> Le 12/04/2019 à 13:22, Jacques Le Roux a écrit :
> > Ah sorry no, I confused with the advice below ("Certificate for RMI")
> >
> > I'll check anyway
> >
> > Le 12/04/2019 à 13:20, Jacques Le Roux a écrit :
> >> Thanks,
> >>
> >> Mmm, as I suspected this is a very old advice (more than 10 years).
> I'll have a look...
> >>
> >> Jacques
> >>
> >> Le 11/04/2019 à 20:33, Wolfgang Paul Rauchholz a écrit :
> >>> Here is the link:
> >>>
> https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-PricesWithVAT
> >>>
> >>>
> >>>
> >>> On Thu, Apr 11, 2019 at 19:50 Jacques Le Roux <
> jacques.le.r...@les7arts.com>
> >>> wrote:
> >>>
> >>>> Le 11/04/2019 à 15:19, wp.rauchh...@gmail.com a écrit :
> >>>>> Show prices with VAT included in eCommerce (B2C)
> >>>> Where does that come from exactly? Have you an URL, something else?
> >>>>
> >>>> Jacques
> >>>>
> >>>> --
> >>> Wolfgang Rauchholz
> >>>
> >>
> >
>


-- 

Wolfgang Rauchholz

Re: VAT setup in ofbiz

[Wolfgang Paul Rauchholz]

Here is the link:
https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-PricesWithVAT



On Thu, Apr 11, 2019 at 19:50 Jacques Le Roux 
wrote:

> Le 11/04/2019 à 15:19, wp.rauchh...@gmail.com a écrit :
> > Show prices with VAT included in eCommerce (B2C)
>
> Where does that come from exactly? Have you an URL, something else?
>
> Jacques
>
> --

Wolfgang Rauchholz

Re: Error adding Carrier Ship Method Type ID

[Wolfgang Paul Rauchholz]

Please add error message 

Sent from my iPad

> On 1 Apr 2019, at 21:12,   
> wrote:
> 
> When trying to add carrier ship method ID we are getting the attached
> error.  Has anyone seen this or can point me in the right direction to
> fix it?
> 
> Thanks,
> 
> James

Re: Translating UOMs

[Wolfgang Paul Rauchholz]

Thank you.

Wolfgang

On Thu, Mar 28, 2019 at 6:58 PM Michael Brohl 
wrote:

> Yes, see
> https://cwiki.apache.org/confluence/display/OFBIZ/Text+Translation
> (*EntityLabels.xml)
>
> Regards,
>
> Michael
>
> Am 28.03.19 um 18:10 schrieb wp.rauchh...@gmail.com:
> > Is there a possibility to translate UOMs so this it shows in the
> language as chosen by the user?
> > I could not find it in  WebTools > Label Manager.
> >
> > Thanks, Wolfgang
>
>

-- 

Wolfgang Rauchholz

Re: Product Manager > Rate > Rating Type Enum and Rate > Rating

[Wolfgang Paul Rauchholz]

Thank you very much for explanation. That was very helpful

On Sat, Mar 23, 2019 at 07:39 Ankush Upadhyay <
ankush.upadh...@hotwaxsystems.com> wrote:

> Hi Wolfgang,
> This is about to show *Average Rating* on customer's review section over
> Product detail section.
> Regarding Rating Type Enum:
> - Min Rating says, display at least rating by comparing average ratings
> given by customers and rating setup on product so let's say average rating
> calculated is 10 but min rating setup is 15 so Average Rating will be shown
> 15.
> - Max Rating says, display at most rating by comparing average ratings
> given by customers and rating setup on product so let's say average rating
> calculated is 15 but max rating setup is 10 so Average Rating will be shown
> 10.
> - Rating override, override whatever is setup on product.
> You can explore ProductWorker.getAverageProductRating() to understand how
> it works.
>
> Thanks
> --
> Ankush Upadhyay
>
>
> On Fri, Mar 22, 2019 at 5:06 PM Pierre Smits 
> wrote:
>
> > Hi Wolfgang ,
> >
> > The rating in the product is about how customers value the product.
> >
> > On Fri, 22 Mar 2019 at 10:05 wp.rauchholz 
> wrote:
> >
> > > What do these two fields do in Ofbiz?
> > > Can't really find documentaiton about it
> > >
> > > Thanks, Wolfgang
> > >
> > >
> > >
> > > --
> > > Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html
> > >
> > --
> > Sent from my phone
> >
>
-- 

Wolfgang Rauchholz

Re: myportal config.

[Wolfgang Paul Rauchholz]

ityName=PortalPage=_NA__MODE=DELETE>
_NA_ For using genericPortletScreen To be able to have parameters at the
portlet level, not PortletPage level _NA_

0
2019-03-09 12:20:10.0 2019-03-09 12:20:10.0 2019-03-09 12:20:10.0 2019-03-09
12:20:10.0

On Thu, Mar 14, 2019 at 9:56 AM Arun Patidar  wrote:

> Looks like portalPageId is empty value in screen
> component://common/widget/PortalPageScreens.xml#showPortalPage.
>
> Please verify.
>
> Kind Regards,
> *Arun Patidar*
>
>
>
> On Thu, Mar 14, 2019 at 1:35 PM Wolfgang Paul Rauchholz <
> wp.rauchh...@gmail.com> wrote:
>
> > Good day Arun. Here we go
> >
> > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
> > screen [component://common/widget/PortalPageScreens.xml#showPortalPage]:
> > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
> > screen [component://myportal/widget/CommonScreens.xml#main-decorator]:
> > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
> > screen
> > [component://commonext/widget/CommonScreens.xml#ApplicationDecorator]:
> > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
> > screen [component://common/widget/CommonScreens.xml#GlobalDecorator]:
> > java.lang.RuntimeException: Could not find PortalPage with portalPageId
> []
> > (Could not find PortalPage with portalPageId [] ) (Error rendering screen
> > [component://common/widget/CommonScreens.xml#GlobalDecorator]:
> > java.lang.RuntimeException: Could not find PortalPage with portalPageId
> []
> > (Could not find PortalPage with portalPageId [] )) (Error rendering
> screen
> > [component://commonext/widget/CommonScreens.xml#ApplicationDecorator]:
> > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
> > screen [component://common/widget/CommonScreens.xml#GlobalDecorator]:
> > java.lang.RuntimeException: Could not find PortalPage with portalPageId
> []
> > (Could not find PortalPage with portalPageId [] ) (Error rendering screen
> > [component://common/widget/CommonScreens.xml#GlobalDecorator]:
> > java.lang.RuntimeException: Could not find PortalPage with portalPageId
> []
> > (Could not find PortalPage with portalPageId [] ))) (Error rendering
> screen
> > [component://myportal/widget/CommonScreens.xml#main-decorator]:
> > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
> > screen
> > [component://commonext/widget/CommonScreens.xml#ApplicationDecorator]:
> > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
> > screen [component://common/widget/CommonScreens.xml#GlobalDecorator]:
> > java.lang.RuntimeException: Could not find PortalPage with portalPageId
> []
> > (Could not find PortalPage with portalPageId [] ) (Error rendering screen
> > [component://common/widget/CommonScreens.xml#GlobalDecorator]:
> > java.lang.RuntimeException: Could not find PortalPage with portalPageId
> []
> > (Could not find PortalPage with portalPageId [] )) (Error rendering
> screen
> > [component://commonext/widget/CommonScreens.xml#ApplicationDecorator]:
> > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
> > screen [component://common/widget/CommonScreens.xml#GlobalDecorator]:
> > java.lang.RuntimeException: Could not find PortalPage with portalPageId
> []
> > (Could not find PortalPage with portalPageId [] ) (Error rendering screen
> > [component://common/widget/CommonScreens.xml#GlobalDecorator]:
> > java.lang.RuntimeException: Could not find PortalPage with portalPageId
> []
> > (Could not find PortalPage with portalPageId [] 
> >
> > Wolfgang
> >
> > On Thu, Mar 14, 2019 at 6:27 AM Arun Patidar <
> > arun.pati...@hotwaxsystems.com>
> > wrote:
> >
> > > Hi WOlfgang,
> > >
> > > Please share your error message in detail here.
> > >
> > > Kind Regards,
> > > *Arun Patidar* | Manager, Enterprise Development
> > > HotWax Systems <http://www.hotwaxsystems.com/>
> > > Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center,
> > > Indore, M.P. 452010
> > > Linkedin: *Arun Patidar* <https://www.linkedin.com/in/arunpatidar>
> > >
> > >
> > >
> > > On Thu, Mar 7, 2019 at 11:11 PM wp.rauchh...@gmail.com <
> > > wp.rauchh...@gmail.com> wrote:
> > >
> > > > I'd appreciate a hint form the community in what I am doing wrong
> with
> > > the
> > > > myportal setup. I get a long error message when accessing:
> > > > org.apache.ofbiz.widg

Re: Error message price list

[Wolfgang Paul Rauchholz]

Okay, I will post in mailing list in the future. But I just got a last
quesiton.
I am currentyly on 16.11
I executed 'svn up'. The only thing that happend was that plugins in
/usr/loocal/ofbiz/specialpurpose we restored, but no further update done.
So I still have the issue of the price list.

Wolfgang

On Thu, Mar 14, 2019 at 11:39 AM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Done quickly
>
> HTH
>
> Le 14/03/2019 à 10:43, Jacques Le Roux a écrit :
> > Thanks Wolfgang,
> >
> > I was unaware of this page, I'll complete it when I'll get a chance...
> >
> > Jacques
> >
> > Le 14/03/2019 à 09:36, Wolfgang Paul Rauchholz a écrit :
> >> Thank you Jacques.
> >> How to apply a patch in ofbiz.
> >> The Howto is not yet dome.
> >>
> https://cwiki.apache.org/confluence/display/OFBENDUSER/How+to+apply+a+patch+to+OFBiz
> >>
> >> Wolfgang
> >>
> >> On Thu, Mar 14, 2019 at 9:32 AM Jacques Le Roux <
> >> jacques.le.r...@les7arts.com> wrote:
> >>
> >>> Hi Wolfgang,
> >>>
> >>> Actually you did not use the last stable release but the R16 branch.
> >>>
> >>> I have fixed the issue with
> >>> https://issues.apache.org/jira/browse/OFBIZ-10837
> >>>
> >>> Please update and try again
> >>>
> >>> Thanks
> >>>
> >>> Jacques
> >>>
> >>> Le 14/03/2019 à 09:01, Wolfgang Paul Rauchholz a écrit :
> >>>> I re-produced the error:
> >>>>
> >>>>  1. Go to Catalog > Product>
> >>>>  2. Select a Product
> >>>>  3. Got to tab  'Prices':
> >>>> 1. Price Type: Promotional Price or Defasul Price
> >>>> 2. Price
> >>>> 3. termUOMId: Other: Each
> >>>> 4. Tax Percentage: 10%
> >>>> 5. Tax in Price
> >>>>
> >>>> This generates the error as described.
> >>>>
> >>>> Wolfgang
> >>>>
> >>>>
> >>>>
> >>>> On Thu, Mar 14, 2019 at 7:04 AM Amit Gadaley <
> >>> amit.gada...@hotwaxsystems.com>
> >>>> wrote:
> >>>>
> >>>>> Hi Wolfgang,
> >>>>>
> >>>>> Could you please add more details like which screen are you using to
> run
> >>>>> this operation and the data that are you trying to insert.
> >>>>>
> >>>>> On Sat, Mar 9, 2019 at 5:45 PM wp.rauchh...@gmail.com <
> >>>>> wp.rauchh...@gmail.com> wrote:
> >>>>>
> >>>>>> I made a fresh install of latest 16.11  stable.
> >>>>>> When entering a new price I get hte following error message:
> >>>>>> java.lang.ClassCastException: Incompatible class: java.sql.Timestamp
> >>>>>> A price record through is was created.
> >>>>>>
> >>>>>> When deleting a reord, I get he dollowing message:
> >>>>>> java.lang.ClassCastException: Incompatible class:
> java.math.BigDecimal
> >>>>>>
> >>>>>> Thanks, Wolfgang
> >>>>>>
> >>>>> --
> >>>>> Kind Regards,
> >>>>> *Amit Gadaley* | Technical Consultant
> >>>>> HotWax Systems <http://www.hotwaxsystems.com/>
> >>>>> Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center,
> >>>>> Indore,
> >>>>> M.P., India - 452010
> >>>>>
> >>
> >
>


-- 

Wolfgang Rauchholz

Re: Error message price list

[Wolfgang Paul Rauchholz]

svn co http://svn.apache.org/repos/asf/ofbiz/branches/release16.11
ofbiz.16.11


On Thu, Mar 14, 2019 at 9:41 AM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> You maybe not need to, how did you download the version you use?
>
> Jacques
>
> Le 14/03/2019 à 09:36, Wolfgang Paul Rauchholz a écrit :
> > Thank you Jacques.
> > How to apply a patch in ofbiz.
> > The Howto is not yet dome.
> >
> https://cwiki.apache.org/confluence/display/OFBENDUSER/How+to+apply+a+patch+to+OFBiz
> >
> > Wolfgang
> >
> > On Thu, Mar 14, 2019 at 9:32 AM Jacques Le Roux <
> > jacques.le.r...@les7arts.com> wrote:
> >
> >> Hi Wolfgang,
> >>
> >> Actually you did not use the last stable release but the R16 branch.
> >>
> >> I have fixed the issue with
> >> https://issues.apache.org/jira/browse/OFBIZ-10837
> >>
> >> Please update and try again
> >>
> >> Thanks
> >>
> >> Jacques
> >>
> >> Le 14/03/2019 à 09:01, Wolfgang Paul Rauchholz a écrit :
> >>> I re-produced the error:
> >>>
> >>>  1. Go to Catalog > Product>
> >>>  2. Select a Product
> >>>  3. Got to tab  'Prices':
> >>> 1. Price Type: Promotional Price or Defasul Price
> >>> 2. Price
> >>> 3. termUOMId: Other: Each
> >>> 4. Tax Percentage: 10%
> >>> 5. Tax in Price
> >>>
> >>> This generates the error as described.
> >>>
> >>> Wolfgang
> >>>
> >>>
> >>>
> >>> On Thu, Mar 14, 2019 at 7:04 AM Amit Gadaley <
> >> amit.gada...@hotwaxsystems.com>
> >>> wrote:
> >>>
> >>>> Hi Wolfgang,
> >>>>
> >>>> Could you please add more details like which screen are you using to
> run
> >>>> this operation and the data that are you trying to insert.
> >>>>
> >>>> On Sat, Mar 9, 2019 at 5:45 PM wp.rauchh...@gmail.com <
> >>>> wp.rauchh...@gmail.com> wrote:
> >>>>
> >>>>> I made a fresh install of latest 16.11  stable.
> >>>>> When entering a new price I get hte following error message:
> >>>>> java.lang.ClassCastException: Incompatible class: java.sql.Timestamp
> >>>>> A price record through is was created.
> >>>>>
> >>>>> When deleting a reord, I get he dollowing message:
> >>>>> java.lang.ClassCastException: Incompatible class:
> java.math.BigDecimal
> >>>>>
> >>>>> Thanks, Wolfgang
> >>>>>
> >>>> --
> >>>> Kind Regards,
> >>>> *Amit Gadaley* | Technical Consultant
> >>>> HotWax Systems <http://www.hotwaxsystems.com/>
> >>>> Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center,
> >>>> Indore,
> >>>> M.P., India - 452010
> >>>>
> >
>


-- 

Wolfgang Rauchholz

Re: Error message price list

[Wolfgang Paul Rauchholz]

Thank you Jacques.
How to apply a patch in ofbiz.
The Howto is not yet dome.
https://cwiki.apache.org/confluence/display/OFBENDUSER/How+to+apply+a+patch+to+OFBiz

Wolfgang

On Thu, Mar 14, 2019 at 9:32 AM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Hi Wolfgang,
>
> Actually you did not use the last stable release but the R16 branch.
>
> I have fixed the issue with
> https://issues.apache.org/jira/browse/OFBIZ-10837
>
> Please update and try again
>
> Thanks
>
> Jacques
>
> Le 14/03/2019 à 09:01, Wolfgang Paul Rauchholz a écrit :
> > I re-produced the error:
> >
> > 1. Go to Catalog > Product>
> > 2. Select a Product
> > 3. Got to tab  'Prices':
> >1. Price Type: Promotional Price or Defasul Price
> >2. Price
> >3. termUOMId: Other: Each
> >4. Tax Percentage: 10%
> >5. Tax in Price
> >
> > This generates the error as described.
> >
> > Wolfgang
> >
> >
> >
> > On Thu, Mar 14, 2019 at 7:04 AM Amit Gadaley <
> amit.gada...@hotwaxsystems.com>
> > wrote:
> >
> >> Hi Wolfgang,
> >>
> >> Could you please add more details like which screen are you using to run
> >> this operation and the data that are you trying to insert.
> >>
> >> On Sat, Mar 9, 2019 at 5:45 PM wp.rauchh...@gmail.com <
> >> wp.rauchh...@gmail.com> wrote:
> >>
> >>> I made a fresh install of latest 16.11  stable.
> >>> When entering a new price I get hte following error message:
> >>> java.lang.ClassCastException: Incompatible class: java.sql.Timestamp
> >>> A price record through is was created.
> >>>
> >>> When deleting a reord, I get he dollowing message:
> >>> java.lang.ClassCastException: Incompatible class: java.math.BigDecimal
> >>>
> >>> Thanks, Wolfgang
> >>>
> >>
> >> --
> >> Kind Regards,
> >> *Amit Gadaley* | Technical Consultant
> >> HotWax Systems <http://www.hotwaxsystems.com/>
> >> Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center,
> >> Indore,
> >> M.P., India - 452010
> >>
> >
>


-- 

Wolfgang Rauchholz

Re: myportal config.

[Wolfgang Paul Rauchholz]

Good day Arun. Here we go

org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
screen [component://common/widget/PortalPageScreens.xml#showPortalPage]:
org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
screen [component://myportal/widget/CommonScreens.xml#main-decorator]:
org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
screen
[component://commonext/widget/CommonScreens.xml#ApplicationDecorator]:
org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
screen [component://common/widget/CommonScreens.xml#GlobalDecorator]:
java.lang.RuntimeException: Could not find PortalPage with portalPageId []
(Could not find PortalPage with portalPageId [] ) (Error rendering screen
[component://common/widget/CommonScreens.xml#GlobalDecorator]:
java.lang.RuntimeException: Could not find PortalPage with portalPageId []
(Could not find PortalPage with portalPageId [] )) (Error rendering screen
[component://commonext/widget/CommonScreens.xml#ApplicationDecorator]:
org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
screen [component://common/widget/CommonScreens.xml#GlobalDecorator]:
java.lang.RuntimeException: Could not find PortalPage with portalPageId []
(Could not find PortalPage with portalPageId [] ) (Error rendering screen
[component://common/widget/CommonScreens.xml#GlobalDecorator]:
java.lang.RuntimeException: Could not find PortalPage with portalPageId []
(Could not find PortalPage with portalPageId [] ))) (Error rendering screen
[component://myportal/widget/CommonScreens.xml#main-decorator]:
org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
screen
[component://commonext/widget/CommonScreens.xml#ApplicationDecorator]:
org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
screen [component://common/widget/CommonScreens.xml#GlobalDecorator]:
java.lang.RuntimeException: Could not find PortalPage with portalPageId []
(Could not find PortalPage with portalPageId [] ) (Error rendering screen
[component://common/widget/CommonScreens.xml#GlobalDecorator]:
java.lang.RuntimeException: Could not find PortalPage with portalPageId []
(Could not find PortalPage with portalPageId [] )) (Error rendering screen
[component://commonext/widget/CommonScreens.xml#ApplicationDecorator]:
org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
screen [component://common/widget/CommonScreens.xml#GlobalDecorator]:
java.lang.RuntimeException: Could not find PortalPage with portalPageId []
(Could not find PortalPage with portalPageId [] ) (Error rendering screen
[component://common/widget/CommonScreens.xml#GlobalDecorator]:
java.lang.RuntimeException: Could not find PortalPage with portalPageId []
(Could not find PortalPage with portalPageId [] 

Wolfgang

On Thu, Mar 14, 2019 at 6:27 AM Arun Patidar 
wrote:

> Hi WOlfgang,
>
> Please share your error message in detail here.
>
> Kind Regards,
> *Arun Patidar* | Manager, Enterprise Development
> HotWax Systems 
> Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center,
> Indore, M.P. 452010
> Linkedin: *Arun Patidar* 
>
>
>
> On Thu, Mar 7, 2019 at 11:11 PM wp.rauchh...@gmail.com <
> wp.rauchh...@gmail.com> wrote:
>
> > I'd appreciate a hint form the community in what I am doing wrong with
> the
> > myportal setup. I get a long error message when accessing:
> > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
> > screen [component://common.
> >
> > That is what I did:
> > I added a new security group MYPORTAL_EMPLOYEE (as in demo).
> > In permissions I added amongst others:  MYPORTALBASE_ADMIN ALL MyPortal
> > base operations  and
> > I created then a new Portal Page ID added as  'Owner User Login ID' my
> own
> > login, set the  Security Group Id  to MYPORTAL_EMPLOYEE and added
> portlets.
> >
> > But still not working, what am I missing?
> > What I notices is that - in contrast to the demo version - when I go to
> > Preferences part in MyPortal, I only can create a new Portal Page, the
> the
> > ones created do not show up there.
> >
> > Thanks, WOlfgang
> >
>


-- 

Wolfgang Rauchholz

Re: Error message price list

[Wolfgang Paul Rauchholz]

I re-produced the error:

   1. Go to Catalog > Product>
   2. Select a Product
   3. Got to tab  'Prices':
  1. Price Type: Promotional Price or Defasul Price
  2. Price
  3. termUOMId: Other: Each
  4. Tax Percentage: 10%
  5. Tax in Price

This generates the error as described.

Wolfgang



On Thu, Mar 14, 2019 at 7:04 AM Amit Gadaley 
wrote:

> Hi Wolfgang,
>
> Could you please add more details like which screen are you using to run
> this operation and the data that are you trying to insert.
>
> On Sat, Mar 9, 2019 at 5:45 PM wp.rauchh...@gmail.com <
> wp.rauchh...@gmail.com> wrote:
>
> > I made a fresh install of latest 16.11  stable.
> > When entering a new price I get hte following error message:
> > java.lang.ClassCastException: Incompatible class: java.sql.Timestamp
> > A price record through is was created.
> >
> > When deleting a reord, I get he dollowing message:
> > java.lang.ClassCastException: Incompatible class: java.math.BigDecimal
> >
> > Thanks, Wolfgang
> >
>
>
> --
> Kind Regards,
> *Amit Gadaley* | Technical Consultant
> HotWax Systems 
> Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center,
> Indore,
> M.P., India - 452010
>


-- 

Wolfgang Rauchholz

Re: Ofbiz accounting / ecomseo vs ecommerce

[Wolfgang Paul Rauchholz]

Thanks for the clarification.

what is the minimum setup of financial model to be able to run ofbiz sales,
purchasing, production, inventory, e commerce

The GL transaction simply stay there and nothing happens with them I assume.

Wolfgang


On Wed, Mar 6, 2019 at 10:23 AM Deepak Dixit  wrote:

> @Michael,
> I think Wolfgang is talking about enable/disable Accounting feature, This
> feature is committed only on trunk.
> This will be part of R18.12.
> Here is the reference ticket for this feature implementation
> https://issues.apache.org/jira/browse/OFBIZ-10391
>
>
> Kind Regards,
> Deepak Dixit
>
>
> On Wed, Mar 6, 2019 at 2:46 PM Michael Brohl 
> wrote:
>
> > This is already rolled out in the standard plugins release. The plugins
> > are maintained separately to keep the framework light.
> >
> > To use it, you'll have to put the plugin(s) into the /plugins directory.
> > There are also Gradle tasks to pull plugin(s) into the framework
> > automatically, see README.adoc.
> >
> > Regards,
> >
> > Michael
> >
> > Am 06.03.19 um 09:42 schrieb Wolfgang Paul Rauchholz:
> > > Thank you Arun,
> > >
> > >
> > > when will this feature get rolled out into standard?
> > > I see it on the demo trunk, but it believe it is not yet included in
> > > latest stable?
> > >
> > > Disabling accounting will have any impact onthe payment gateway?
> > >
> > >
> > > Wolfgang
> > >
> > >
> > > On Wed, 2019-03-06 at 10:54 +0530, Arun Patidar wrote:
> > >> Hello Wolfgang,
> > >>
> > >> In trunk, there is support to enable/disable accounting transactions.
> > >> Please refer 'enableAccounting' field of 'PartyAcctgPreference'
> > >> entity.
> > >>
> > >>
> > >>
> > >> Kind Regards,
> > >> *Arun Patidar* | Manager, Enterprise Development
> > >> HotWax Systems <http://www.hotwaxsystems.com/>
> > >> Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center,
> > >> Indore, M.P. 452010
> > >> Linkedin: *Arun Patidar* <https://www.linkedin.com/in/arunpatidar>
> > >>
> > >>
> > >>
> > >> On Tue, Mar 5, 2019 at 10:55 PM wp.rauchholz 
> > >> wrote:
> > >>
> > >>> Is there a possibility to 'switch off' the financial modules of
> > >>> Ofbiz. The
> > >>> bookkeeping is outsourced and the the provider runs their own
> > >>> system.
> > >>>
> > >>>
> > >>> What exactly is the difference between ecomseo and ecommerce in
> > >>> Orbiz??
> > >>> Is there somewhere a bit more in-depth explanation then here?
> > >>>
> > >>>
> > >
> >
> https://cwiki.apache.org/confluence/display/OFBIZ/Search+Engine+Optimisation%2C+SEO+in+ecommerce
> > >>>
> > >>>
> > >>> Thanks, Wolfgang
> > >>>
> > >>>
> > >>>
> > >>> --
> > >>> Sent from:
> > >>> http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html
> > >>>
> >
> >
>


-- 

Wolfgang Rauchholz

Re: Ofbiz accounting / ecomseo vs ecommerce

[Wolfgang Paul Rauchholz]

Thank you Arun,


when will this feature get rolled out into standard?
I see it on the demo trunk, but it believe it is not yet included in
latest stable?

Disabling accounting will have any impact onthe payment gateway?


Wolfgang


On Wed, 2019-03-06 at 10:54 +0530, Arun Patidar wrote:
> Hello Wolfgang,
> 
> In trunk, there is support to enable/disable accounting transactions.
> Please refer 'enableAccounting' field of 'PartyAcctgPreference'
> entity.
> 
> 
> 
> Kind Regards,
> *Arun Patidar* | Manager, Enterprise Development
> HotWax Systems 
> Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center,
> Indore, M.P. 452010
> Linkedin: *Arun Patidar* 
> 
> 
> 
> On Tue, Mar 5, 2019 at 10:55 PM wp.rauchholz 
> wrote:
> 
> > Is there a possibility to 'switch off' the financial modules of
> > Ofbiz. The
> > bookkeeping is outsourced and the the provider runs their own
> > system.
> > 
> > 
> > What exactly is the difference between ecomseo and ecommerce in
> > Orbiz??
> > Is there somewhere a bit more in-depth explanation then here?
> > 
> > 
https://cwiki.apache.org/confluence/display/OFBIZ/Search+Engine+Optimisation%2C+SEO+in+ecommerce
> > 
> > 
> > 
> > Thanks, Wolfgang
> > 
> > 
> > 
> > --
> > Sent from: 
> > http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html
> > 

Re: Web analytics

[Wolfgang Paul Rauchholz]

I installed Matomo.
Would you please tell me  which files I have to add the JavaScript
Tracking Code to track the traffic on the ecommercie pages?


Thank you,

Wolfgang


On Thu, 2019-02-28 at 10:46 +0530, Aditya Sharma wrote:
> Hi Wolfgang,
> 
> For OFBiz OOTB tracking. You can enable server stats in OFBiz from
> serverstats.properties file. Refer to this [1] document
> Refer Visit and ServerHit entities. These visits can be viewed from
> the
> Find Visit [2] page of partymgr component.
> 
> If you are looking for open source tools like Google Web Analytics,
> indeed
> Matomo (formerly known as Piwik) would be a good choice.
> 
> HTH
> 
> 
> [1].
> 
https://cwiki.apache.org/confluence/display/OFBIZ/Framework+Configuration+Guide#FrameworkConfigurationGuide-serverstats.properties
> [2]. https://demo-stable.ofbiz.apache.org/partymgr/control/findVisits
> 
> Thanks and Regards,
> *Aditya Sharma* | Enterprise Software Engineer
> HotWax Systems 
> Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center,
> Indore,
> M.P 452010
> Linkedin: *Aditya Sharma* <
> https://www.linkedin.com/in/aditya-p-sharma/>
> 
> 
> 
> On Wed, Feb 27, 2019 at 10:44 PM Michael Brohl <
> michael.br...@ecomify.de>
> wrote:
> 
> > Hi Wolfgang,
> > 
> > OFBiz itself can track visits and tracking codes, see the marketing
> > application.
> > 
> > We are mainly using Matomo (formerly known as Piwik) for web
> > analytics
> > with OFBiz.
> > 
> > Best regards,
> > 
> > Michael
> > 
> > 
> > Am 27.02.19 um 15:03 schrieb wp.rauchh...@gmail.com:
> > > I do have a few  questions around ofbiz and web analytics:
> > > 
> > > * Where can I find document on how to setup it up in orbiz?
> > > * Does ifbiz has reporting on board I did not find?
> > > * From your experience which other tools than google webanalytics
> > > can be
> > 
> > used to drive in-depth reports? I'd rather prefer an open source
> > tool than
> > big brother google.
> > > 
> > > 
> > > Thanks, Wolfgang
> > 
> > 

Re: Web analytics

[Wolfgang Paul Rauchholz]

Thank you for responses.

Wolfgang

On Thu, 2019-02-28 at 10:46 +0530, Aditya Sharma wrote:
> Hi Wolfgang,
> 
> For OFBiz OOTB tracking. You can enable server stats in OFBiz from
> serverstats.properties file. Refer to this [1] document
> Refer Visit and ServerHit entities. These visits can be viewed from
> the
> Find Visit [2] page of partymgr component.
> 
> If you are looking for open source tools like Google Web Analytics,
> indeed
> Matomo (formerly known as Piwik) would be a good choice.
> 
> HTH
> 
> 
> [1].
> 
https://cwiki.apache.org/confluence/display/OFBIZ/Framework+Configuration+Guide#FrameworkConfigurationGuide-serverstats.properties
> [2]. https://demo-stable.ofbiz.apache.org/partymgr/control/findVisits
> 
> Thanks and Regards,
> *Aditya Sharma* | Enterprise Software Engineer
> HotWax Systems 
> Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center,
> Indore,
> M.P 452010
> Linkedin: *Aditya Sharma* <
> https://www.linkedin.com/in/aditya-p-sharma/>
> 
> 
> 
> On Wed, Feb 27, 2019 at 10:44 PM Michael Brohl <
> michael.br...@ecomify.de>
> wrote:
> 
> > Hi Wolfgang,
> > 
> > OFBiz itself can track visits and tracking codes, see the marketing
> > application.
> > 
> > We are mainly using Matomo (formerly known as Piwik) for web
> > analytics
> > with OFBiz.
> > 
> > Best regards,
> > 
> > Michael
> > 
> > 
> > Am 27.02.19 um 15:03 schrieb wp.rauchh...@gmail.com:
> > > I do have a few  questions around ofbiz and web analytics:
> > > 
> > > * Where can I find document on how to setup it up in orbiz?
> > > * Does ifbiz has reporting on board I did not find?
> > > * From your experience which other tools than google webanalytics
> > > can be
> > 
> > used to drive in-depth reports? I'd rather prefer an open source
> > tool than
> > big brother google.
> > > 
> > > 
> > > Thanks, Wolfgang
> > 
> > 

Re: Food nutrition database

[Wolfgang Paul Rauchholz]

Thanks for pointing me to this solution. That works really great!

Quesiton I still have; what is the best usage of the tab 'Attributes'?

Wolfgang



On Mon, 2019-02-18 at 09:39 -0600, Paul Mandeltort wrote:
> You’ll want to use Features which already has units support built
> in. 
> 
> Add a broad feature Type for Nutrition
> https://demo-trunk.ofbiz.apache.org/catalog/control/EditFeatureTypes
>  trunk.ofbiz.apache.org/catalog/control/EditFeatureTypes>
> 
> And define the specific Nutrition things as features which live in
> Feature Categories:
>  
> https://demo-trunk.ofbiz.apache.org/catalog/control/EditFeatureCategories
>  <
> https://demo-trunk.ofbiz.apache.org/catalog/control/EditFeatureCategories
> >
> 
> Then you can manage specific features in the per-product features: 
> 
https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductFeatures?productId=WG-9943
>  <
> https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductFeatures?productId=WG-9943
> >
> 
> 
> --P
> --
> Paul Mandeltort,  Marco Specialties, Inc.  +1(512)394-8119  
> p...@marcospec.com 
> 
> > On Feb 18, 2019, at 3:51 AM, wp.rauchh...@gmail.com wrote:
> > 
> > Good day.
> > 
> > we want to use ofbiz for a food related business.
> > For tyhat we need to setup a database of ingredients and their
> > nutritional properties.
> > Is this best done hrough the 'Attributes' in the item master or is
> > there a better way?
> > Underneath an example of the data model for an apple.
> > 
> > Component Value UnitSource
> > Proximales  
> > alcohol (ethanol) 0 g   310
> > fat, total (total lipid)trace   g   258
> > protein, total  0.3 g   258
> > water (moisture)85.7g   258
> > Hidratos de Carbono 
> > carbohydrate12g 258
> > sucrose 2.4   g 341
> > fibre, total dietary2 g 258
> > 
> > Thanks, Wolfgang
> 
> 

Re: ofbiz and SSL & apache

[Wolfgang Paul Rauchholz]

I took a bit time, but what finally helped me to fix it was a
combination of this procedure

https://cwiki.apache.org/confluence/display/OFBiz/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-SSLCertificateSetup
 

and this 2nd one:
https://ilhicas.com/2018/04/08/How-to-use-letsencrypt-jks.html


Apache Proxy in from of Tomcat:
Has somebody here sucesfully implemented an apache proxy for tomcat
that redirects traffic to ofbiz as well to the other webser services
(all php based)?

Thanks for your help.



Wolfgang

On Tue, 2019-02-19 at 12:52 +0100, Michael Brohl wrote:
> You will need to store a certificate for the domain you want to use.
> 
> Maybe you should create your own keystore containing only your 
> certificate and point to this file instead of the original.
> 
> Regards,
> 
> Michael
> 
> 
> Am 19.02.19 um 12:22 schrieb Wolfgang Paul Rauchholz:
> > I am trying to get SSL working w/o apache for the time being.
> > 
> > I followed your procedure and could sucesfully import. Thanks.
> > Great!
> > 
> > I went the into the following file:
> > /usr/local/ofbiz/framework/catalina/ofbiz-component.xml and changed
> > the
> > following two lines:
> > 
> >   > value="framework/base/config/ofbiz.jks"/>
> >  
> > 
> > Which seems not to be the right, because firefox still complaints
> > When I call https:www.wo-lar.com:8443/myportal/control/main. I get
> > a
> > "Your connection is not secure". www.wo-lar.com:8443 uses an
> > invalid
> > security certificate.
> > 
> > 
> > When I run :8443:/myportal/control/main I get the
> > same
> > error message. But I can look at hte certificate and that tells me
> > that
> > it still points to the wrong certificate:
> > Common name: ofbiz-vm.apache.org
> > 
> > Any thoughts?
> > 
> > Wolfgang
> > 
> > 
> > 
> > 
> > On Tue, 2019-02-19 at 11:53 +0100, Michael Brohl wrote:
> > > Hi Wolfgang,
> > > 
> > > if you already have a ceritificate, you should skip steps 2 
> > > andhttps://cwiki.apache.org/confluence/display/OFBiz/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-SSLCertificateSetup
> > > 3!
> > > 
> > > If I understand the steps correctly, with the certreq command you
> > > now
> > > have a certificate request with alias "ssl" in your keystore.
> > > Later
> > > you
> > > try to import a certificate which is not based on your
> > > certificate
> > > request under the same alias "ssl".
> > > 
> > > Just import your certificate with another alias and you should be
> > > fine.
> > > 
> > > Remember: if you use an Apache Webserver before your OFBiz
> > > instance,
> > > you
> > > do not need to import the certificate in the keystore!
> > > 
> > > Regards,
> > > 
> > > Michael Brohl
> > > ecomify GmbH
> > > www.ecomify.de
> > > 
> > > 
> > > Am 19.02.19 um 11:26 schrieb Wolfgang Paul Rauchholz:
> > > > How does this procedure work in case of an existing letsencrypt
> > > > certificate?
> > > > 
> > > > Because I have an existing certificate, can I skip steps 3?
> > > > I continued directly with step 4, uploading and conveting
> > > > cert.pem
> > > > to
> > > > cert.der.
> > > > 
> > > > But importe step 5 throws out an error: keytool error:
> > > > java.lang.Exception: Public keys in reply and keystore don't
> > > > match:
> > > > 
> > > > 
> > > > 1. Run: "keytool -genkey -keyalg RSA -alias ssl -keystore
> > > > [keystore
> > > > name]"
> > > > 2. Run: "keytool -certreq -alias ssl -keyalg RSA -file
> > > > certreq.csr
> > > > -keystore [keystore name]"
> > > > 3. Submit the CSR to a signing authority (Thawte, Verisign,
> > > > etc)
> > > > 4. Download your certificate from the signing authority. Please
> > > > remember to download the Certificate in PKCS#7 format. If you
> > > > get a
> > > > certificate in pem format don't convert to PKCS#7/P7B Format
> > > > but
> > > > der
> > > > format
> > > > 5. Import the Certificate into the keystore by running:
> > > > "keytool -import -alias ssl -trustcacerts -file
> &g

Re: ofbiz and SSL & apache

[Wolfgang Paul Rauchholz]

That is what I thought I did:
0) shut down ogbiz1) keytool -import -alias  -trustcacerts -file
cert.der -keystore .jks2) keytool -import -alias ofbiz
-trustcacerts -file cert.der -keystore .jks3) cp name.jks to
/usr/local/ofbiz/framework/base/config/4) edit file
/usr/local/ofbiz/framework/catalina/ofbiz-component.xml row
147: row 150: 5) start ofbiz
What am I doing wrong?
Thanks for hwlping. Wolfgang

On Tue, 2019-02-19 at 12:52 +0100, Michael Brohl wrote:
> You will need to store a certificate for the domain you want to use.
> 
> Maybe you should create your own keystore containing only your 
> certificate and point to this file instead of the original.
> 
> Regards,
> 
> Michael
> 
> 
> Am 19.02.19 um 12:22 schrieb Wolfgang Paul Rauchholz:
> > I am trying to get SSL working w/o apache for the time being.
> > I followed your procedure and could sucesfully import. Thanks.
> > Great!
> > I went the into the following
> > file:/usr/local/ofbiz/framework/catalina/ofbiz-component.xml and
> > changed thefollowing two lines:
> >   > name="keystoreFile"value="framework/base/config/ofbiz.jks"/>   
> >   
> > Which seems not to be the right, because firefox still
> > complaintsWhen I call https:
> > www.wo-lar.com:8443/myportal/control/main. I get a"Your connection
> > is not secure". www.wo-lar.com:8443 uses an invalidsecurity
> > certificate.
> > 
> > When I run :8443:/myportal/control/main I get the
> > sameerror message. But I can look at hte certificate and that tells
> > me thatit still points to the wrong certificate:Common name: ofbiz-
> > vm.apache.org
> > Any thoughts?
> > Wolfgang
> > 
> > 
> > 
> > On Tue, 2019-02-19 at 11:53 +0100, Michael Brohl wrote:
> > > Hi Wolfgang,
> > > if you already have a ceritificate, you should skip steps 2 and
> > > 3!
> > > If I understand the steps correctly, with the certreq command
> > > younowhave a certificate request with alias "ssl" in your
> > > keystore. Lateryoutry to import a certificate which is not based
> > > on your certificaterequest under the same alias "ssl".
> > > Just import your certificate with another alias and you should
> > > befine.
> > > Remember: if you use an Apache Webserver before your OFBiz
> > > instance,youdo not need to import the certificate in the
> > > keystore!
> > > Regards,
> > > Michael Brohlecomify GmbHwww.ecomify.de
> > > 
> > > Am 19.02.19 um 11:26 schrieb Wolfgang Paul Rauchholz:
> > > > How does this procedure work in case of an existing
> > > > letsencryptcertificate?
> > > > Because I have an existing certificate, can I skip steps 3?I
> > > > continued directly with step 4, uploading and conveting
> > > > cert.pemtocert.der.
> > > > But importe step 5 throws out an error: keytool
> > > > error:java.lang.Exception: Public keys in reply and keystore
> > > > don't match:
> > > > 
> > > > 1. Run: "keytool -genkey -keyalg RSA -alias ssl -keystore
> > > > [keystorename]"2. Run: "keytool -certreq -alias ssl -keyalg RSA
> > > > -file certreq.csr-keystore [keystore name]"3. Submit the CSR to
> > > > a signing authority (Thawte, Verisign, etc)4. Download your
> > > > certificate from the signing authority. Pleaseremember to
> > > > download the Certificate in PKCS#7 format. If you get
> > > > acertificate in pem format don't convert to PKCS#7/P7B Format
> > > > butderformat5. Import the Certificate into the keystore by
> > > > running:"keytool -import -alias ssl -trustcacerts -file
> > > > mysignedcert.cer-keystore [keystore name]"
> > > > 
> > > > Thanks, Wolfgang
> > > > On Mon, 2019-02-18 at 11:35 +0100, Michael Brohl wrote:
> > > > > You will have to import your certificate to the Java keystore
> > > > > and
> > > > > configure Tomcat to use it [1,2].
> > > > > 
> > > > > The standard way would be to run OFBiz behind an Apache
> > > > > webserver
> > > > > with
> > > > > the virtual hosts configured to use the certificate.
> > > > > 
> > > > > Regards,
> > > > > 
> > > > > Michael Brohl
> > > > > ecomify GmbH
> > > > > www.ecomify.de
> > > > > 
> > > > > [1] https://tomcat.apache.org/tomcat-8.5-doc/ssl-howto.html
> > > > > 
> > > > > [2]
> > > > > 
> > 
> > 
https://cwiki.apache.org/confluence/display/OFBiz/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-SSLCertificateSetup
> > > > > Am 18.02.19 um 10:53 schrieb wp.rauchh...@gmail.com:
> > > > > > Would you please point me to a procedure how to setup ofbiz
> > > > > > to
> > > > > > use
> > > > > > my letsencrypt  certificates?
> > > > > > I don't seem to be able to find one.
> > > > > > 
> > > > > > Is it possible to ruj Ofbiz under Apache webser?
> > > > > > 
> > > > > > 
> > > > > > Thank you, Wolfgang
> > > > > > 
> > > > > > 
> > > > > > 

Re: ofbiz and SSL & apache

[Wolfgang Paul Rauchholz]

I am trying to get SSL working w/o apache for the time being.

I followed your procedure and could sucesfully import. Thanks. Great!

I went the into the following file:
/usr/local/ofbiz/framework/catalina/ofbiz-component.xml and changed the
following two lines:




Which seems not to be the right, because firefox still complaints
When I call https:www.wo-lar.com:8443/myportal/control/main. I get a
"Your connection is not secure". www.wo-lar.com:8443 uses an invalid
security certificate.


When I run :8443:/myportal/control/main I get the same
error message. But I can look at hte certificate and that tells me that
it still points to the wrong certificate:
Common name: ofbiz-vm.apache.org

Any thoughts?

Wolfgang




On Tue, 2019-02-19 at 11:53 +0100, Michael Brohl wrote:
> Hi Wolfgang,
> 
> if you already have a ceritificate, you should skip steps 2 and 3!
> 
> If I understand the steps correctly, with the certreq command you
> now 
> have a certificate request with alias "ssl" in your keystore. Later
> you 
> try to import a certificate which is not based on your certificate 
> request under the same alias "ssl".
> 
> Just import your certificate with another alias and you should be
> fine.
> 
> Remember: if you use an Apache Webserver before your OFBiz instance,
> you 
> do not need to import the certificate in the keystore!
> 
> Regards,
> 
> Michael Brohl
> ecomify GmbH
> www.ecomify.de
> 
> 
> Am 19.02.19 um 11:26 schrieb Wolfgang Paul Rauchholz:
> > How does this procedure work in case of an existing letsencrypt
> > certificate?
> > 
> > Because I have an existing certificate, can I skip steps 3?
> > I continued directly with step 4, uploading and conveting cert.pem
> > to
> > cert.der.
> > 
> > But importe step 5 throws out an error: keytool error:
> > java.lang.Exception: Public keys in reply and keystore don't match:
> > 
> > 
> > 1. Run: "keytool -genkey -keyalg RSA -alias ssl -keystore [keystore
> > name]"
> > 2. Run: "keytool -certreq -alias ssl -keyalg RSA -file certreq.csr
> > -keystore [keystore name]"
> > 3. Submit the CSR to a signing authority (Thawte, Verisign, etc)
> > 4. Download your certificate from the signing authority. Please
> > remember to download the Certificate in PKCS#7 format. If you get a
> > certificate in pem format don't convert to PKCS#7/P7B Format but
> > der
> > format
> > 5. Import the Certificate into the keystore by running:
> > "keytool -import -alias ssl -trustcacerts -file mysignedcert.cer
> > -keystore [keystore name]"
> > 
> > 
> > Thanks, Wolfgang
> > 
> > On Mon, 2019-02-18 at 11:35 +0100, Michael Brohl wrote:
> > > You will have to import your certificate to the Java keystore and
> > > configure Tomcat to use it [1,2].
> > > 
> > > The standard way would be to run OFBiz behind an Apache webserver
> > > with
> > > the virtual hosts configured to use the certificate.
> > > 
> > > Regards,
> > > 
> > > Michael Brohl
> > > ecomify GmbH
> > > www.ecomify.de
> > > 
> > > [1] https://tomcat.apache.org/tomcat-8.5-doc/ssl-howto.html
> > > 
> > > [2]
> > > 
> > 
> > 
https://cwiki.apache.org/confluence/display/OFBiz/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-SSLCertificateSetup
> > > 
> > > Am 18.02.19 um 10:53 schrieb wp.rauchh...@gmail.com:
> > > > Would you please point me to a procedure how to setup ofbiz to
> > > > use
> > > > my letsencrypt  certificates?
> > > > I don't seem to be able to find one.
> > > > 
> > > > Is it possible to ruj Ofbiz under Apache webser?
> > > > 
> > > > 
> > > > Thank you, Wolfgang
> > > > 
> > > > 
> > > > 
> 
> 

Re: ofbiz and SSL & apache

[Wolfgang Paul Rauchholz]

How does this procedure work in case of an existing letsencrypt
certificate?

Because I have an existing certificate, can I skip steps 3?
I continued directly with step 4, uploading and conveting cert.pem to
cert.der.

But importe step 5 throws out an error: keytool error:
java.lang.Exception: Public keys in reply and keystore don't match:


1. Run: "keytool -genkey -keyalg RSA -alias ssl -keystore [keystore
name]"
2. Run: "keytool -certreq -alias ssl -keyalg RSA -file certreq.csr
-keystore [keystore name]"
3. Submit the CSR to a signing authority (Thawte, Verisign, etc)
4. Download your certificate from the signing authority. Please
remember to download the Certificate in PKCS#7 format. If you get a
certificate in pem format don't convert to PKCS#7/P7B Format but der
format
5. Import the Certificate into the keystore by running:
"keytool -import -alias ssl -trustcacerts -file mysignedcert.cer
-keystore [keystore name]"


Thanks, Wolfgang

On Mon, 2019-02-18 at 11:35 +0100, Michael Brohl wrote:
> You will have to import your certificate to the Java keystore and 
> configure Tomcat to use it [1,2].
> 
> The standard way would be to run OFBiz behind an Apache webserver
> with 
> the virtual hosts configured to use the certificate.
> 
> Regards,
> 
> Michael Brohl
> ecomify GmbH
> www.ecomify.de
> 
> [1] https://tomcat.apache.org/tomcat-8.5-doc/ssl-howto.html
> 
> [2] 
> 
https://cwiki.apache.org/confluence/display/OFBiz/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-SSLCertificateSetup
> 
> 
> Am 18.02.19 um 10:53 schrieb wp.rauchh...@gmail.com:
> > Would you please point me to a procedure how to setup ofbiz to use
> > my letsencrypt  certificates?
> > I don't seem to be able to find one.
> > 
> > Is it possible to ruj Ofbiz under Apache webser?
> > 
> > 
> > Thank you, Wolfgang
> > 
> > 
> > 
> 
> 

Re: How to configure two different BOMs for same product?

[Wolfgang Paul Rauchholz]

As you speak about recipe I assume we sre talking process industry?

What is the difference between B and C. Are you using the same or different
process when using B and/or C to produce a?

Wolfgang

On Mon, Feb 4, 2019 at 3:33 PM Yashwant Dhakad <
yashwant.dha...@hotwaxsystems.com> wrote:

> Hi,
> Can you please provide your use cases where you are using this scenario.
>
> We achieved this use case by creating the substitute product of
> productA and also customized the reservation and issuance workflow. But we
> can't select the specific BOM at the time of job creation and this is the
> limitation in the current system.
>
> Thanks & Regards
> --
> Yashwant Dhakad
>
>
> On Mon, Feb 4, 2019 at 7:04 PM Julien NICOLAS 
> wrote:
>
> > Hello Rahul,
> >
> > Your user case puzzle me, could you explain a little bit more about it ?
> >
> > Thanks,
> >
> > Julien.
> >
> > Le 04/02/2019 à 12:53, Rahul Vangari a écrit :
> > > Hello,
> > >
> > > I have a product say productA which can be made from productB.
> > >
> > > Also I have another recipe in which I can make productA from productC
> > > which is totally independent from above.
> > >
> > > How can I configure two manufacturing BOMs for same productA with
> > > different components?
> > >
> >
>


-- 

Wolfgang Rauchholz

Re: BOM With Multiple Levels

[Wolfgang Paul Rauchholz]

Are the intermediate products in your production run stockable items or do
they move directly to the next production step?
In that case, you could maybe define these items as phantom items and blow
demand through them (in case Ofbiz offers this functionality).
Like that you build-up your BOM as the product, but reduce number of
transaction.

Wolfgang

On Mon, Jan 28, 2019 at 5:14 AM Yashwant Dhakad <
yashwant.dha...@hotwaxsystems.com> wrote:

> Hi James,
> Yes, It supported and while creating production run please select the
> *Create
> Dependent Production Runs *field to yes.
>
> Thanks & Regards
> --
> Yashwant Dhakad
>
>
> On Mon, Jan 28, 2019 at 2:36 AM  wrote:
>
> > All - Does Ofbiz handle Multi-Level BOM in one production process?
> >
> > For Example for Product ABC the components are:
> >
> > Mix123
> > CAP218
> > Bottle127
> >
> > However MIX123 also has components:
> > DP2897 & M2781
> >
> > So the question is can I make Mix 123 as the 1st part of the production
> > process in Making Product ABC?
> >
> > Thanks,
> >
> > James
> >
>


-- 

Wolfgang Rauchholz

Re: Wikipedia update

[Wolfgang Paul Rauchholz]

I can contribute to the Spanish pages.
I am not a Wilipedia talent, but I gues in a team we can get his one solved

Saludos, Wolfgang



On Tue, Nov 27, 2018 at 11:16 AM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Hi,
>
> Today I spent some time to update the latest released version and date on
> Wikipedia French and English pages.
>
> It's really uneasy in French which uses Infobox and Wikidata. I'm often
> lost, after 3 time I still did not understand how it really works, anyway.
>
> I'd really appreciate if you have some Wikipedia talent to help with other
> pages (Spanish and Russian) and help to maintain Wikipedia pages at large.
>
> With Julien Nicolas we have to battle last year to keep the French page
> (yes they wanted to delete it).
>
> English Wikipedia moderators seems less rude and the page contains only
> warnings. It would still be good if we could cleanup these warnings.
>
> Thanks
>
> Jacques
>
>

-- 

Wolfgang Rauchholz

Re: VAT

[Wolfgang Paul Rauchholz]

Go to their web page.
I contacted with Paul Piper:
p...@ilscipio.com

On Thu, Oct 25, 2018 at 3:29 PM  wrote:

> is there a contact at Scipio ERP
>
>
>  Original Message 
> Subject: Re: VAT
> From: Wolfgang Paul Rauchholz 
> Date: Thu, October 25, 2018 5:40 am
> To: user@ofbiz.apache.org
>
> Alternatively you can check Scipio ERP.
> A German derivate of ofbiz.
>
> On Thu, 25 Oct 2018 at 13:15,  wrote:
>
> > I found on the web there was some development done specifically for
> > Opentaps for sale. It covered VAT for Sales Side, Purchase Side, and
> > reporting.
> >
> >
> http://shop.opentaps.org/index.php/featured/vat-module-by-integratingweb.html
> >
> > I am hesitant to purchase anything on this site as I am not sure how
> > active it is. Anyone know anyone from Integrating Web, Opentaps, or
> > Shen Chi who may have access to this code?
> >
> > It includes:
> >
> > The Vat module by IntegratingWeb, an opentaps Partner, allows you to
> > easily manage VAT for sales orders, purchase orders and invoice in your
> > Opentaps CRM-ERP System. This module includes gwt integration, ledger
> > posting, detailed reports and the capability to override VAT when you
> > create an invoice.
> >
> > Features of the VAT module include:
> >
> > Adds vat to Sales orders and Purchase orders
> >
> > Calculates vat using the rate associated to the product and the geo
> > location of the customer or supplier
> >
> > Adds an extra vat number field to the crm module: account and leads.
> >
> > Vat number associated to a party can be validated with a syntax
> > validator and with the VIES system
> >
> > Prints the vat number on the invoices
> >
> > Sales and vendor vat invoices
> >
> > Vat on invoices can be overridden
> >
> > Vat posting on specific gl accounts
> >
> > Vat posting on gl accounts can be configured
> >
> > Vat reports that calculate the vat return.
> >
> > Thanks,
> >
> > James
> >
> >  Original Message 
> > Subject: Re: VAT
> > From: Wolfgang Paul Rauchholz 
> > Date: Wed, October 24, 2018 11:23 pm
> > To: user@ofbiz.apache.org
> >
> > Here some reads about treatment of VAT in ofbiz.
> >
> https://cwiki.apache.org/confluence/display/OFBENDUSER/08+Tax+Authorities
> >
> >
> https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-PricesWithVAT
> >
> >
> https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz%27s+Tax+Authority+Data+Model
> >
> > Wolfgang
> >
> > On Thu, Oct 25, 2018 at 4:42 AM  wrote:
> >
> > >
> > > Does Ofbiz handle VAT for the EU both on the sales side as well as
> > > purchasing side? If so has anyone explored the new electronic
> > > integration to the government that is being required in 2019?
> > >
> > > Thanks,
> > >
> > > James
> > >
> >
> >
> > --
> >
> > Wolfgang Rauchholz
> >
> --
>
> Wolfgang Rauchholz
>


-- 

Wolfgang Rauchholz

Re: VAT

[Wolfgang Paul Rauchholz]

Alternatively you can check Scipio ERP.
A German derivate of ofbiz.

On Thu, 25 Oct 2018 at 13:15,  wrote:

> I found on the web there was some development done specifically for
> Opentaps for sale.  It covered VAT for Sales Side, Purchase Side, and
> reporting.
>
> http://shop.opentaps.org/index.php/featured/vat-module-by-integratingweb.html
>
> I am hesitant to purchase anything on this site as I am not sure how
> active it is.  Anyone know anyone from Integrating Web, Opentaps, or
> Shen Chi who may have access to this code?
>
> It includes:
>
> The Vat module by IntegratingWeb, an opentaps Partner, allows you to
> easily manage VAT for sales orders, purchase orders and invoice in your
> Opentaps CRM-ERP System. This module includes gwt integration, ledger
> posting, detailed reports and the capability to override VAT when you
> create an invoice.
>
> Features of the VAT module include:
>
> Adds vat to Sales orders and Purchase orders
>
> Calculates vat using the rate associated to the product and the geo
> location of the customer or supplier
>
> Adds an extra vat number field to the crm module: account and leads.
>
> Vat number associated to a party can be validated with a syntax
> validator and with the VIES system
>
> Prints the vat number on the invoices
>
> Sales and vendor vat invoices
>
> Vat on invoices can be overridden
>
> Vat posting on specific gl accounts
>
> Vat posting on gl accounts can be configured
>
> Vat reports that calculate the vat return.
>
> Thanks,
>
> James
>
>  Original Message 
> Subject: Re: VAT
> From: Wolfgang Paul Rauchholz 
> Date: Wed, October 24, 2018 11:23 pm
> To: user@ofbiz.apache.org
>
> Here some reads about treatment of VAT in ofbiz.
> https://cwiki.apache.org/confluence/display/OFBENDUSER/08+Tax+Authorities
>
> https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-PricesWithVAT
>
> https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz%27s+Tax+Authority+Data+Model
>
> Wolfgang
>
> On Thu, Oct 25, 2018 at 4:42 AM  wrote:
>
> >
> > Does Ofbiz handle VAT for the EU both on the sales side as well as
> > purchasing side? If so has anyone explored the new electronic
> > integration to the government that is being required in 2019?
> >
> > Thanks,
> >
> > James
> >
>
>
> --
>
> Wolfgang Rauchholz
>
-- 

Wolfgang Rauchholz

Re: VAT

[Wolfgang Paul Rauchholz]

Here some reads about treatment of VAT in ofbiz.
https://cwiki.apache.org/confluence/display/OFBENDUSER/08+Tax+Authorities
https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-PricesWithVAT
https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz%27s+Tax+Authority+Data+Model

Wolfgang

On Thu, Oct 25, 2018 at 4:42 AM  wrote:

>
> Does Ofbiz handle VAT for the EU both on the sales side as well as
> purchasing side?  If so has anyone explored the new electronic
> integration to the government that is being required in 2019?
>
> Thanks,
>
> James
>


-- 

Wolfgang Rauchholz

Re: Delivery schedules for product categories

[Wolfgang Paul Rauchholz]

What are we trying to accomplish?
We want to setup with ofbiz a weekly subscription based food delivery
business.
In order to complete the order, the customer has to take some decisions:

   - # days; for how many days of the week do I want to receive weekly
   servings? Example: 3 days
   - # people; for how many people am I ordering food? Example: 4 people

This information tells the system the size of the weekly food kit. 3 days x
4 people = 12 servings

To complete the order we need to know which servings (or dishes) are being
packed into the food kit.
Ofbiz shall offer a proposed kit of 3 days worth of servings for 12 people
(can be done with the sequence number in category / item roll-up)
But the customer should be able to change the servings within the kit. I
consider now to create 12 unique food kit part numbers; one for each
possible combination of #days and # servings. (is this the best option?)
There are several challenges I have not found the right answer for.

   - The Food Kit part is best configured as:
  - Finished Good / Virtual/ Variant
  - Finished Good / Variant
  - Configurable Product / Variant (is this even possible?
  - Configurable Product only
  - Marketing Package
  - Any other?
   - Weekly planning of food kit; the customer should only see and
   configure the food kit delivery of next week, but also the possibilities of
   food kit deliveries the following 3 weeks

I hope this explains better what we are trying to achieve and thank you for
helping.

Wolfgang


On Thu, Oct 18, 2018 at 1:36 PM Rishi Solanki 
wrote:

> Dear Wolfgang,
> Could you please share the details one more time with some example you
> wanted to achieve. Also challenge you are facing is not much clear. I again
> read your email, and feels I replied to your question without proper
> attention.
> Please share the details one more time with some example, will help us to
> understand your requirement.
>
> Best Regards,
> --
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: +91-9893287847
> http://www.hotwaxsystems.com
> www.hotwax.co
>
>
> On Wed, Oct 17, 2018 at 6:54 PM Wolfgang Paul Rauchholz <
> wp.rauchh...@gmail.com> wrote:
>
> > Thank you Rishi,
> >
> > I tried t Catalog option too, but it poses the same challenges I cannot
> > overcome which is to define a delivery schedule (from...to) for each
> > category (or catalog)
> > Products from Category 1 can only be delivered in week from Oct 22 - 28
> > Products from Category 2 can only be delivered in week from Oct 29 - Nov
> 4
> > Products from Category 3 can only be delivered in week from Nov 5 - Nov
> 11
> > etc...
> >
> > Or am I missing something?
> >
> > Wolfgang
> >
> >
> > On Wed, Oct 17, 2018 at 2:01 PM Rishi Solanki 
> > wrote:
> >
> > > Two ways to achieve this;
> > > Setup Catalog for each week and configure them in ProductStoreCatalog.
> > > And as per your approach use ProductCategoryRollup for the same.
> > >
> > > Refer OrderDemoData.xml to understand it better.
> > >
> > > Best Regards,
> > > --
> > > Rishi Solanki
> > > Sr Manager, Enterprise Software Development
> > > HotWax Systems Pvt. Ltd.
> > > Direct: +91-9893287847
> > > http://www.hotwaxsystems.com
> > > www.hotwax.co
> > >
> > >
> > > On Wed, Oct 17, 2018 at 2:29 PM wp.rauchh...@gmail.com <
> > > wp.rauchh...@gmail.com> wrote:
> > >
> > > > After testing with ofbiz, I need advice from experts if the following
> > is
> > > > possible.
> > > >
> > > > Background:
> > > > We need to show in e-Commerce a schedule of parts in weekly buckets
> for
> > > > the next six weeks. I use categories for this. Example
> > > > •   Product Category Name: Products week 42: 15/10 – 21/10
> > > > •   Product Category Name: Products week 43: 22/10 – 28/10
> > > > •   Product Category Name: Products week 44: 29/10 – 4/11
> > > > •   Product Category Name: Products week 45: 5/11 – 11/11
> > > >
> > > > The customer can order products in any of these weeks; but these will
> > > also
> > > > be delivered only in that same week.
> > > > I set the THROUGH DATE in Category Roll-up to the end of each
> > > > corresponding week (21/10, 28/10, etc..). The category will disappear
> > > once
> > > > this date is passed. This is what we need.
> > > >
> > > > Challenge:
> > > > I have not been able to define for product categories delivery valid
> > > dates
> > > > from – to. If a customer enters an order e.g. for wk 44, he/she can
> > > enter a
> > > > deliver for another week.
> > > >
> > > > Thanks for your insight. Wolfgang
> > > >
> > > >
> > >
> >
> >
> > --
> >
> > Wolfgang Rauchholz
> >
>


-- 

Wolfgang Rauchholz

Re: Delivery schedules for product categories

[Wolfgang Paul Rauchholz]

Thank you Rishi,

I tried t Catalog option too, but it poses the same challenges I cannot
overcome which is to define a delivery schedule (from...to) for each
category (or catalog)
Products from Category 1 can only be delivered in week from Oct 22 - 28
Products from Category 2 can only be delivered in week from Oct 29 - Nov 4
Products from Category 3 can only be delivered in week from Nov 5 - Nov 11
etc...

Or am I missing something?

Wolfgang


On Wed, Oct 17, 2018 at 2:01 PM Rishi Solanki 
wrote:

> Two ways to achieve this;
> Setup Catalog for each week and configure them in ProductStoreCatalog.
> And as per your approach use ProductCategoryRollup for the same.
>
> Refer OrderDemoData.xml to understand it better.
>
> Best Regards,
> --
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: +91-9893287847
> http://www.hotwaxsystems.com
> www.hotwax.co
>
>
> On Wed, Oct 17, 2018 at 2:29 PM wp.rauchh...@gmail.com <
> wp.rauchh...@gmail.com> wrote:
>
> > After testing with ofbiz, I need advice from experts if the following is
> > possible.
> >
> > Background:
> > We need to show in e-Commerce a schedule of parts in weekly buckets for
> > the next six weeks. I use categories for this. Example
> > •   Product Category Name: Products week 42: 15/10 – 21/10
> > •   Product Category Name: Products week 43: 22/10 – 28/10
> > •   Product Category Name: Products week 44: 29/10 – 4/11
> > •   Product Category Name: Products week 45: 5/11 – 11/11
> >
> > The customer can order products in any of these weeks; but these will
> also
> > be delivered only in that same week.
> > I set the THROUGH DATE in Category Roll-up to the end of each
> > corresponding week (21/10, 28/10, etc..). The category will disappear
> once
> > this date is passed. This is what we need.
> >
> > Challenge:
> > I have not been able to define for product categories delivery valid
> dates
> > from – to. If a customer enters an order e.g. for wk 44, he/she can
> enter a
> > deliver for another week.
> >
> > Thanks for your insight. Wolfgang
> >
> >
>


-- 

Wolfgang Rauchholz

Re: Credit Card payment service

[Wolfgang Paul Rauchholz]

Thank you

Wolfgang

On Wed, Oct 17, 2018 at 10:26 AM Pierre Smits 
wrote:

> Hi Wolfgang,
>
> There are many more 3rd party fintech integrations. You can find a overview
> of what is available OOTB at [1]. Please be aware that some are not
> working.
>
> I have also created a 3rd party fintech integration for Multisafepay [2]
> back in 2015, which is publicly available via [3]. And currently I am
> working on another integration for [4] that I hope to be able to make
> available soon.
>
> [1]
>
> https://svn.apache.org/viewvc/ofbiz/ofbiz-framework/trunk/applications/accounting/src/main/java/org/apache/ofbiz/accounting/thirdparty/
> [2] https://www.multisafepay.com/es_es/
> [3] https://github.com/orrtiz/omultisafepay
> [4] https://www.adyen.com
>
> Best regards,
>
> Pierre Smits
>
> *Apache Trafodion , Vice President*
> *Apache Directory , PMC Member*
> Apache Incubator , committer
> *Apache OFBiz , contributor (without privileges)
> since 2008*
> Apache Steve , committer
>
>
> On Wed, Oct 17, 2018 at 8:53 AM wp.rauchh...@gmail.com <
> wp.rauchh...@gmail.com> wrote:
>
> > I found these providers are in the manual. Are they all tested and all
> > working with ofbiz?
> > CyberSource
> > ClearCommerce.
> > PCCharge.
> > RiTA
> > Verisign PayFlo Pro
> > ValueLink (gift cards)
> >
> > Are there others?
> >
> > Wolfgang
> >
>


-- 

Wolfgang Rauchholz

Re: Make-to-Order / Drop-ship only

[Wolfgang Paul Rauchholz]

Thank you Pierre.
I will test this different scenarios which we could face:
(1) Customer places order, we place PO on supplier and from there it ships
directly
(2) Customer places order, we replenish components, a job shop completes to
create the fingood and supplier ships directly to customer
(3) Customer places order, we replenish components only partiall, a job
shop completes to create the fingood and supplier ships directly to customer

I went through thr cyclke as you suggested
(1) created e-Commerce order
(2) approved PO
(3) Quick Complete Drop Shipment (from PO)

I see it created the paid invoice. Att he bottom of the sales, although it
says Status 'Completed' and Invoiced 1 pcs, it also still says 'Remaining 1
pcs' and 'Qty Shipped 0'.
Is this correct?

Wolfgang


On Sun, Oct 14, 2018 at 9:12 AM Pierre Smits  wrote:

> Hi Wolfgang,
>
> Yes, OFBiz has such feature out of the box.
>
> A product with the setting 'Drop-ship only' activated works as a
> make-to-order product. When one of your customers orders such a product
> through the ecommerce component, 2 orders are created: 1 sales order (from
> you to your customer) and 1 purchase order (from you to your supplier). You
> can test this in the ecommerce  component of the demo site with
> https://demo-trunk.ofbiz.apache.org/ecommerce/dropship1-dropShip1-p
>
> When you go through the checkout process and you have the final order
> confirmation, you'll see in the back-end order component the two orders
> created. If your customer orders multiple drop-ship products, with each
> product having a different supplier, you should see multiple purchase
> orders.
>
> Best regards,
>
> Pierre Smits
>
> *Apache Trafodion , Vice President*
> *Apache Directory , PMC Member*
> Apache Incubator , committer
> *Apache OFBiz , contributor (without privileges)
> since 2008*
> Apache Steve , committer
>
>
> On Sat, Oct 13, 2018 at 9:35 PM wp.rauchh...@gmail.com <
> wp.rauchh...@gmail.com> wrote:
>
> > (1) Does ofbiz have a functionality on board that allows to create
> > back-to-back purchase orders from e-Commerce sales orders (single sales
> > orders with multiple lines back to back into a single purchase order with
> > the same lines.), skipping requirements all together.
> > In my case I work with a single source of supply who is doing kitting for
> > us.
> >
> > (2) How exactly works the parameter 'Drop-ship only' set in item master /
> > inventory?
> >
> > Thanks, Wolfgang
> >
> >
> >
>


-- 

Wolfgang Rauchholz

Re: Error when receiving purchase order

[Wolfgang Paul Rauchholz]

Hi Rishi, I revised setup of accounting. There was setup missing in Invoive
Item Type.
This is fixed now.

Thanks.

Wolfgang

On Sat, Oct 13, 2018 at 2:05 PM Rishi Solanki 
wrote:

> Hi Wolfgang,
> Could you please share the default gl account setup data set in the
> InvoiceItemType and GlAccount at your end?
> The error you are getting should not come with correct data setup.
>
> --
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: +91-9893287847
> http://www.hotwaxsystems.com
> www.hotwax.co
>
>
> On Fri, Oct 12, 2018 at 11:33 PM wp.rauchh...@gmail.com <
> wp.rauchh...@gmail.com> wrote:
>
> > Sorry for re-sending this email, but I cannot get past this error.
> >
> > Thanks for helping.
> >
> > I set the tax account in GL ACCOUNT DEFAULTS..
> > Would you please help me to fix this one. Thank you. Wolfgang
> >
> > The Following Errors Occurred:
> > Error trying to begin transaction, could not process method: The current
> > transaction is marked for rollback, not beginning a new transaction and
> > aborting current operation; the rollbackOnly was caused by: Error in
> > simple-method [Post a AcctgTrans
> >
> >
> [file:/usr/local/ofbiz.17.12/applications/accounting/minilang/ledger/AcctgTransServices.xml#postAcctgTrans]]:
> > [Gl account id is not set for 2 or mapping not found for account type
> > Gl account id is not set for 3 or mapping not found for account type
> > TAX_ACCOUNT]
> >
> >
> > Wolfgang
> >
>


-- 

Wolfgang Rauchholz

Re: Error when receiving purchase order

[Wolfgang Paul Rauchholz]

I was too fast with te disregard
I got another tax related message when trying to ' Quick Ship Entire Order'.
I set hte tax account in GL ACCOUNT DEFAULTS..
Would you please help me to fix this one. Tjank you. Wolfgang

×
The Following Errors Occurred:

Error trying to begin transaction, could not process method: The current
transaction is marked for rollback, not beginning a new transaction and
aborting current operation; the rollbackOnly was caused by: Error in
simple-method [Post a AcctgTrans
[file:/usr/local/ofbiz.17.12/applications/accounting/minilang/ledger/AcctgTransServices.xml#postAcctgTrans]]:
; [Gl account id is not set for 2 or mapping not found for account type
, Gl account id is not set for 3 or mapping not found for account type
TAX_ACCOUNT]


On Wed, Oct 10, 2018 at 12:48 PM Wolfgang Paul Rauchholz <
wp.rauchh...@gmail.com> wrote:

> Please disregard. I had forgotten to set GL ACCOUNT DEFAULTS.
>
> Wolfgang
>
>
> On Wed, Oct 10, 2018 at 12:35 PM wp.rauchh...@gmail.com <
> wp.rauchh...@gmail.com> wrote:
>
>> I started a fresh ofbiz install (no demo data).
>> I also setup GL chart of Account and reporting periods. I did not setup
>> any accounts on part number level though (tab accounts)
>> I can enter the PO with no problem, but when receiving I get error
>> message.Which points to a problem with GL account setup. But I cannot
>> figure out what it is.
>> Thanks for your help. Wolfgang
>>
>>
>> Error:Error trying to begin transaction, could not process method:
>> The current transaction is marked for rollback, not beginning a new
>> transaction and aborting current operation; the rollbackOnly was caused by:
>> Error in simple-method [Post a AcctgTrans
>> [file:/usr/local/ofbiz.17.12/applications/accounting/minilang/ledger/AcctgTransServices.xml#postAcctgTrans]]:
>> ; [Gl account id is not set for 1 or mapping not found for account type
>> UNINVOICED_SHIP_RCPT, Gl account id is not set for 2 or mapping not
>> found for account type INVENTORY_ACCOUNT]
>>
>
>
> --
>
> Wolfgang Rauchholz
>
>
>
>

-- 

Wolfgang Rauchholz

Re: Error when receiving purchase order

[Wolfgang Paul Rauchholz]

Please disregard. I had forgotten to set GL ACCOUNT DEFAULTS.

Wolfgang


On Wed, Oct 10, 2018 at 12:35 PM wp.rauchh...@gmail.com <
wp.rauchh...@gmail.com> wrote:

> I started a fresh ofbiz install (no demo data).
> I also setup GL chart of Account and reporting periods. I did not setup
> any accounts on part number level though (tab accounts)
> I can enter the PO with no problem, but when receiving I get error
> message.Which points to a problem with GL account setup. But I cannot
> figure out what it is.
> Thanks for your help. Wolfgang
>
>
> Error:Error trying to begin transaction, could not process method:
> The current transaction is marked for rollback, not beginning a new
> transaction and aborting current operation; the rollbackOnly was caused by:
> Error in simple-method [Post a AcctgTrans
> [file:/usr/local/ofbiz.17.12/applications/accounting/minilang/ledger/AcctgTransServices.xml#postAcctgTrans]]:
> ; [Gl account id is not set for 1 or mapping not found for account type
> UNINVOICED_SHIP_RCPT, Gl account id is not set for 2 or mapping not
> found for account type INVENTORY_ACCOUNT]
>


-- 

Wolfgang Rauchholz

Re: OFbiz on LAMP server

[Wolfgang Paul Rauchholz]

I do a have several services on my home server (CRM, personal finance.
etc..), that all run through apache server.
I do have a domain and a certificate from letsencrypt.

I want to have the possibility to test ofibz (planning a startup and
travelling a lot) accessing through www
I want to leverage letsencrypt certificate
Want access through port 443
Certificate management through letsencrypt/apache is easier than through
ofbiz way

Wolfgang

Wolfgang


On Sun, Oct 7, 2018 at 11:38 PM Taher Alkhateeb 
wrote:

> Hi
>
> Can you shed some light on what you're trying to do? What is the purpose of
> going through LAMP. I am asking because it might not necessarily be the
> best or only option depending on your goal.
>
> On Sat, Oct 6, 2018, 8:41 PM wp.rauchh...@gmail.com <
> wp.rauchh...@gmail.com>
> wrote:
>
> > I like to integrate OFbiz on my LAMP server and run it through Apache web
> > server.
> > I googled quite a bit but can;t find anything.
> > Would you please point me to a how too other resources for this purpose.
> >
> > Thanks, Wolfgang
> >
> >
>


-- 

Wolfgang Rauchholz

Re: Missing State/Province

[Wolfgang Paul Rauchholz]

I am happy to help. But, being a non-technical person, I need explanations
in layman terms.
'CommonWorker.getAssociatedStateList' does not tell me anything.
Also. the list should be exended into other languages like Cataln, Fren,
etc...


Wolfgang


On Mon, Oct 8, 2018 at 8:12 AM Deepak Dixit  wrote:

> Hi Wolfgang,
>
> GeoData exists for Spain Comunidades Autónomas/Provincias
>
>
> https://svn.apache.org/repos/asf/ofbiz/ofbiz-framework/trunk/framework/common/data/GeoData_ES.xml
>
> Need to improve CommonWorker.getAssociatedStateList method to return the
> correct result.
>
> https://www.iso.org/obp/ui/#iso:code:3166:ES
>
> Thanks & Regards
> --
> Deepak Dixit
>
>
> On Fri, Oct 5, 2018 at 8:16 PM, wp.rauchh...@gmail.com <
> wp.rauchh...@gmail.com> wrote:
>
> > The State/Provinces for Spain are missing.
> > When entering a new address the system shows "No States/Provinces exist"
> > I like to add a list of the autonomous regions in several languages to
> > standard ofibz.
> > How is this been done?
> >
> > Thanks, Wolfgang
> >
> >
> >
>


-- 

Wolfgang Rauchholz

Re: OFbiz on LAMP server

[Wolfgang Paul Rauchholz]

Do you refer to this link?
https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-HTTPD

Asking, because it creates conflicts with other services on this
server/domain

Wolfgang

On Sun, Oct 7, 2018 at 10:15 AM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Hi  Wolfgang,
>
> Did you check the FAQ in the wiki? There is some information about that
> there
>
> Jacques
>
>
> Le 06/10/2018 à 18:41, wp.rauchh...@gmail.com a écrit :
> > I like to integrate OFbiz on my LAMP server and run it through Apache
> web server.
> > I googled quite a bit but can;t find anything.
> > Would you please point me to a how too other resources for this purpose.
> >
> > Thanks, Wolfgang
> >
> >
>
>

-- 

Wolfgang Rauchholz

Re: Creating product packs

[Wolfgang Paul Rauchholz]

That explains it Thank you.

Wolfgang

On Fri, Oct 5, 2018 at 8:38 AM Pritam Kute 
wrote:

> Hi,
>
> As I said in my previous email, it is just a UI layer problem. There is no
> out of the box UI available on e-commerce for displaying the components of
> the kit product. You need a little bit of customization in the code for
> displaying those components on the product details page.
>
> Thanks and Regards
> --
> Pritam Kute
>
>
> On Thu, Oct 4, 2018 at 8:48 PM Wolfgang Paul Rauchholz <
> wp.rauchh...@gmail.com> wrote:
>
> > I don’t know what I am missing. This is my setup.
> >
> > Part number for the pack / basket:
> > PACK7: defined as Marketing Package: Auto Manufactured (I tried also the
> > Assembly type)
> >
> > Part number products
> > 1000, 1001 and 1002 defined as Finished Good
> >
> > In Tab ASSOCIATION of PACK7 I tried all possible scenarios:
> >
> > Swapping Product ID and Product IT to. Trying several different
> association
> > types.
> >
> > On e-Commerce page, when clicking PACK7 and ofbiz drills down to the
> > product detail page, I do not see the products 100, 1001, 1002 (the
> > contentt of the pack).
> >
> >
> >
> > What am I doing wrong?
> >
> >
> >
> > On Thu, Oct 4, 2018 at 12:30 PM Pritam Kute <
> pritam.k...@hotwaxsystems.com
> > >
> > wrote:
> >
> > > Whatever I can learn from the explanation you have provided, it is
> just a
> > > UI layer you are talking about. Like you just need to show individual
> > > servings to the customer under a particular product pack. There is no
> any
> > > requirement of modifying/deleting of any servings.
> > >
> > > If this is the case, then the marketing package can be exploded using
> the
> > > associations created in "ProductAssoc" entity. I recommend you to go
> > > through the demo data of GZ-BASKET. It will clear all your questions.
> > >
> > > Thanks and Regards
> > > --
> > > Pritam Kute
> > >
> > >
> > > On Thu, Oct 4, 2018 at 3:17 PM Wolfgang Paul Rauchholz <
> > > wp.rauchh...@gmail.com> wrote:
> > >
> > > > Thanks for responses.
> > > > To you question what do you mean by "open the pack and see what is
> > > inside".
> > > > On the e-Commerce page the Customer will pick the product pack that
> is
> > > > composed of 7 servings, from Monday to Sunday. The Customer wants to
> > see
> > > > the individual servings inside the pack.
> > > > In other word, the Customer should be able to 'explode' the pack into
> > its
> > > > individual products.
> > > >
> > > >
> > > > On Thu, Oct 4, 2018 at 11:39 AM Pritam Kute <
> > > pritam.k...@hotwaxsystems.com
> > > > >
> > > > wrote:
> > > >
> > > > > Please see my comments inline.
> > > > >
> > > > > Thanks and Regards
> > > > > --
> > > > > Pritam Kute
> > > > >
> > > > >
> > > > > On Thu, Oct 4, 2018 at 2:19 PM wp.rauchh...@gmail.com <
> > > > > wp.rauchh...@gmail.com> wrote:
> > > > >
> > > > > > How to best setup a pack in ofbiz?
> > > > > > With pack I mean a product (e.g. a pack for 7 days of food
> > servings)
> > > > that
> > > > > > includes in this example 7 individual servings. Each of these
> > > servings
> > > > > > could be sold individually too.
> > > > > >
> > > > >
> > > > > Yes. This is a best case for Marketing Package. See the defination
> of
> > > > > marketing package here
> > > > > https://cwiki.apache.org/confluence/display/OFBENDUSER/Products
> > > > >
> > > > > The price is set for the pack, but the Customer should have the
> > > > possibility
> > > > > > on e-Commerce to open the pack and see what is inside.
> > > > > >
> > > > >
> > > > > Price can be set for the complete set in marketing package type
> > > product.
> > > > > Can you please ellaborate more about the line "open the pack and
> see
> > > what
> > > > > is inside". Like do they just need to see the package content or
> they
> > > can
> > > > > change some packs from the already built package?
> > > > >
> > > > >
> > > > > > The pack is either defined or can be configured.
> > > > > >
> > > > >
> > > > > IMO, defined pakages can be created by using marketing package
> > concept
> > > > > directly but for configured package, you should go for configurable
> > > > product
> > > > > setup.
> > > > >
> > > > >
> > > > > > Is this a case where 'Marketing Package' is used?
> > > > > >
> > > > > > Thanks, Wolfgang
> > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > > > --
> > > >
> > > > Wolfgang Rauchholz
> > > >
> > >
> >
> >
> > --
> >
> > Wolfgang Rauchholz
> >
>


-- 

Wolfgang Rauchholz

Re: Creating product packs

[Wolfgang Paul Rauchholz]

I don’t know what I am missing. This is my setup.

Part number for the pack / basket:
PACK7: defined as Marketing Package: Auto Manufactured (I tried also the
Assembly type)

Part number products
1000, 1001 and 1002 defined as Finished Good

In Tab ASSOCIATION of PACK7 I tried all possible scenarios:

Swapping Product ID and Product IT to. Trying several different association
types.

On e-Commerce page, when clicking PACK7 and ofbiz drills down to the
product detail page, I do not see the products 100, 1001, 1002 (the
contentt of the pack).



What am I doing wrong?



On Thu, Oct 4, 2018 at 12:30 PM Pritam Kute 
wrote:

> Whatever I can learn from the explanation you have provided, it is just a
> UI layer you are talking about. Like you just need to show individual
> servings to the customer under a particular product pack. There is no any
> requirement of modifying/deleting of any servings.
>
> If this is the case, then the marketing package can be exploded using the
> associations created in "ProductAssoc" entity. I recommend you to go
> through the demo data of GZ-BASKET. It will clear all your questions.
>
> Thanks and Regards
> --
> Pritam Kute
>
>
> On Thu, Oct 4, 2018 at 3:17 PM Wolfgang Paul Rauchholz <
> wp.rauchh...@gmail.com> wrote:
>
> > Thanks for responses.
> > To you question what do you mean by "open the pack and see what is
> inside".
> > On the e-Commerce page the Customer will pick the product pack that is
> > composed of 7 servings, from Monday to Sunday. The Customer wants to see
> > the individual servings inside the pack.
> > In other word, the Customer should be able to 'explode' the pack into its
> > individual products.
> >
> >
> > On Thu, Oct 4, 2018 at 11:39 AM Pritam Kute <
> pritam.k...@hotwaxsystems.com
> > >
> > wrote:
> >
> > > Please see my comments inline.
> > >
> > > Thanks and Regards
> > > --
> > > Pritam Kute
> > >
> > >
> > > On Thu, Oct 4, 2018 at 2:19 PM wp.rauchh...@gmail.com <
> > > wp.rauchh...@gmail.com> wrote:
> > >
> > > > How to best setup a pack in ofbiz?
> > > > With pack I mean a product (e.g. a pack for 7 days of food servings)
> > that
> > > > includes in this example 7 individual servings. Each of these
> servings
> > > > could be sold individually too.
> > > >
> > >
> > > Yes. This is a best case for Marketing Package. See the defination of
> > > marketing package here
> > > https://cwiki.apache.org/confluence/display/OFBENDUSER/Products
> > >
> > > The price is set for the pack, but the Customer should have the
> > possibility
> > > > on e-Commerce to open the pack and see what is inside.
> > > >
> > >
> > > Price can be set for the complete set in marketing package type
> product.
> > > Can you please ellaborate more about the line "open the pack and see
> what
> > > is inside". Like do they just need to see the package content or they
> can
> > > change some packs from the already built package?
> > >
> > >
> > > > The pack is either defined or can be configured.
> > > >
> > >
> > > IMO, defined pakages can be created by using marketing package concept
> > > directly but for configured package, you should go for configurable
> > product
> > > setup.
> > >
> > >
> > > > Is this a case where 'Marketing Package' is used?
> > > >
> > > > Thanks, Wolfgang
> > > >
> > > >
> > >
> >
> >
> > --
> >
> > Wolfgang Rauchholz
> >
>


-- 

Wolfgang Rauchholz

Re: Creating product packs

[Wolfgang Paul Rauchholz]

Thanks for responses.
To you question what do you mean by "open the pack and see what is inside".
On the e-Commerce page the Customer will pick the product pack that is
composed of 7 servings, from Monday to Sunday. The Customer wants to see
the individual servings inside the pack.
In other word, the Customer should be able to 'explode' the pack into its
individual products.


On Thu, Oct 4, 2018 at 11:39 AM Pritam Kute 
wrote:

> Please see my comments inline.
>
> Thanks and Regards
> --
> Pritam Kute
>
>
> On Thu, Oct 4, 2018 at 2:19 PM wp.rauchh...@gmail.com <
> wp.rauchh...@gmail.com> wrote:
>
> > How to best setup a pack in ofbiz?
> > With pack I mean a product (e.g. a pack for 7 days of food servings) that
> > includes in this example 7 individual servings. Each of these servings
> > could be sold individually too.
> >
>
> Yes. This is a best case for Marketing Package. See the defination of
> marketing package here
> https://cwiki.apache.org/confluence/display/OFBENDUSER/Products
>
> The price is set for the pack, but the Customer should have the possibility
> > on e-Commerce to open the pack and see what is inside.
> >
>
> Price can be set for the complete set in marketing package type product.
> Can you please ellaborate more about the line "open the pack and see what
> is inside". Like do they just need to see the package content or they can
> change some packs from the already built package?
>
>
> > The pack is either defined or can be configured.
> >
>
> IMO, defined pakages can be created by using marketing package concept
> directly but for configured package, you should go for configurable product
> setup.
>
>
> > Is this a case where 'Marketing Package' is used?
> >
> > Thanks, Wolfgang
> >
> >
>


-- 

Wolfgang Rauchholz

Re: How to manage recepies through content functionality

[Wolfgang Paul Rauchholz]

Thank you for picking up my question Deepak.
UOM defining on component level. I miss the field, I went through the
complete item master and BOM screen. On which is the standard UOM for a
part defined?

Content manager; I am not a very technical person ContentMapFacade
and *ContentWrapper: into what does it translate in layman terms?

THanks for your help.

Wolfgang

On Mon, Oct 1, 2018 at 12:19 PM Deepak Dixit  wrote:

> Hi Wolfgang,
>
> You can set the UOM at the component level, and for the recipe, you can use
> ProductContent
>
> https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductContent?productId=PIZZA
>
> You can explore ecommerceseo component for reference, there are lots of
> ways to render content, You can use ContentMapFacade, of *ContentWrapper
> classes to get the needed data.
>
> Thanks & Regards
> --
> Deepak Dixit
>
>
> On Mon, Oct 1, 2018 at 3:35 PM, wp.rauchh...@gmail.com <
> wp.rauchh...@gmail.com> wrote:
>
> > Good day!
> >
> > Background:
> > We are in the process of setting up a food service business. We decided
> to
> > go with ofbiz as it allows us to contain investment-$ initially. We are
> > trying in phase 1 to use ofbiz standard. (maybe with exception
> ofeComemrce
> > page)
> > We tested different scenarios and are left with a few questions we were
> > not able to resolve.
> >
> >
> > Problem descriptions
> >
> > (1) BOM UOM.
> > Ingrediens in different UOMs (ml, gr, kg, pcs, etc..).
> > When defining BOM, UOM cannot be defined. Where can I set the UOM for the
> > BOM?
> >
> >
> > (2) For each dish we need to upload its recipe along with pictures of
> > the different cooking phases (either as an online text or downloadable
> > pdf). Example: https://www.bbcgoodfood.com/recipes/2089/spiced-carrot-
> > and-lentil-soup
> >
> > We were testing with the Content page of the part itself as well as the
> > Content menu (Forum, Blog, Content, etc..). Unfortunately, we were not
> able
> > to achieve that a recipe is shown on the eCommerce page along with the
> > dish, or to define a link that refers to that recipe and then being
> opened
> > in a separate window.
> > Is this something ofbiz offers as functionality and where can I find a
> > Howto?
> >
> > Thanks for your help, Wolfgang
> >
>


-- 

Wolfgang Rauchholz

Re: Question about product costing

[Wolfgang Paul Rauchholz]

Thanks, that helped a lot.

Wolfgang

On Sat, Jun 23, 2018 at 7:49 AM Arun Patidar  wrote:

> Hi,
>
> In the code, value of  'taskCost' depends on fields 'estimatedTaskTime',
> 'usageCost.amount', 'setupTime' and 'setupCost.amount'. You can add log
> messages in 'getTaskCost' service to see the values of all these variables
> on the console.
>
>
>
> On Sun, Jun 17, 2018 at 2:59 PM wp.rauchh...@gmail.com <
> wp.rauchh...@gmail.com> wrote:
>
> > I setup a fingood that is produced.
> >
> > It consists of
> > (1) a single level Manufacturing BOM with 6 componens. All these
> > components have a PO cost setup and I ran 'Auto-Calculate Costs' for
> them,
> > meaning thet all have an 'Estimated Standard Materials Cost'
> >
> > (2) Routing
> > a) Manufacturing Manager  > Cost
> > 2 Cost Component Cal Entrie:
> >
> > b) Manufacturing Manager  > Routing Task
> > 1 Routing Tasks that include 2 Cost Components (COST COMPONENT TYPE ID
> ')
> > 'defined under a)
> >
> > c) Manufacturing Manager > Routing
> > 1 Routing that includes Routing Taks defined undere b)
> >
> > When I run now 'Auto-Calculate Costs' for the manufacturing product, I
> get
> > an error message.
> >
> > The Following Errors Occurred:
> > ERROR: Could not complete the Calculates the product's cost
> >
> [file:/usr/local/ofbiz_sam/applications/product/minilang/product/cost/CostServices.xml#calculateProductCosts]
> > process [problem invoking the [getTaskCost] service with the map named
> > [callSvcMap] containing [{workEffortId=1,
> > userLogin=[GenericEntity:UserLogin][createdStamp,2018-06-08
> > 11:09:05.0(java.sql.Timestamp)][createdTxStamp,2018-06-08
> >
> 11:09:05.0(java.sql.Timestamp)][currentPassword,$SHA$4g$nHI14NDsYqeu7vLMX5iFXS2Ni0U(java.lang.String)][disabledBy,null()][disabledDateTime,null()][enabled,Y(java.lang.String)][externalAuthId,null()][hasLoggedOut,N(java.lang.String)][isSystem,null()][lastCurrencyUom,null()][lastLocale,en_US(java.lang.String)][lastTimeZone,null()][lastUpdatedStamp,2018-06-17
> > 11:00:09.0(java.sql.Timestamp)][lastUpdatedTxStamp,2018-06-17
> >
> 11:00:09.0(java.sql.Timestamp)][partyId,wp.rauchholz(java.lang.String)][passwordHint,null()][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,null()][userLdapDn,null()][userLoginId,wp.rauchholz(java.lang.String)],
> > currencyUomId=BRL, routingId=10001, productId=1, locale=en_US}]:
> > Outgoing result (in runSync : getTaskCost) does not match expected
> > requirements (The following required parameter is missing: [OUT]
> > [getTaskCost.taskCost])]
> >
> >
> > I was looking in source code for [OUT] [getTaskCost.taskCost], but can't
> > find the root cause of the problem.
> > I'd appreciate if somebody could point me to the solution.
> >
> > Thanks you, Wolfgang
> >
> >
> >
> >
>
> --
>
> Best regards,
>
> Arun Patidar
> Director of Information SystemsHotWax Commerce 
>


-- 

Wolfgang Rauchholz

Re: ofbizsetup procedure

[Wolfgang Paul Rauchholz]

Thanks

On Fri, Jun 8, 2018 at 3:19 PM Pierre Smits  wrote:

> Hi Wolfgang,
>
> Yes, you can change the currency of the default internal company via the
> Entity Data Maintenance functions in web tools. Have a look at:
> PartyAcctgPreference
>
>
> Best regards,
>
> Pierre Smits
>
> Apache Trafodion <https://trafodion.apache.org>, Vice President
> Apache Directory <https://directory.apache.org>, PMC Member
> Apache Incubator <https://incubator.apache.org>, committer
> Apache OFBiz <https://ofbiz.apache.org>, contributor since 2008
> Apache Steve <https://steve.apache.org>, committer
>
> On Fri, Jun 8, 2018 at 1:07 PM, Wolfgang Paul Rauchholz <
> wp.rauchh...@gmail.com> wrote:
>
> > Please disregard ' Problem: eCommerce page does not show prices in BRL.
> It
> > Shows ‘Your Price: $0.00’'
> > After a while it shows now in BRL. As if updates would take some time to
> > take effect?
> >
> > But still, how can I change the  ‘Internal Accounting Organizations’, via
> > 'Entity Data Maintenance'?
> >
> > On Fri, Jun 8, 2018 at 11:31 AM wp.rauchh...@gmail.com <
> > wp.rauchh...@gmail.com> wrote:
> >
> > > Still playing with ofbiz. Now setting it up using the script
> ofbizsetup:
> > > https://10.5.2.1:8443/ofbizsetup/control/main
> > >
> > > Observations:
> > > Tab ‘PRODUCT STORE’; does not allow to set a currency. Ofbiz assumes
> USD.
> > > Tab ‘First CUSTOMER’; missing password field under ‘User name’ on
> screen
> > > causes error message: Work-around; open a new ofbiz session and enter a
> > > customer before continuing with ofbizsetup procedure
> > > Tab ‘First PRODUCT’; does not allow to set a currency. Ofbiz assumes
> USD.
> > > This procedure ends up with ‘Internal Accounting Organizations’ in USD.
> > > The eCommerce page shows sales prices in USD too
> > >
> > > I changed/added to BRL currency in the following screens:
> > > •   Party > ‘Preferred Currency Uom Id’: set to BRL
> > > •   Deleted / added standard/list price and avg cost for product to
> > BRL
> > > •   Store > Localization >Default Currency Uom Id’ Set to BRL
> > > Problem: eCommerce page does not show prices in BRL. It Shows ‘Your
> > Price:
> > > $0.00’
> > >
> > > Questions:
> > > (1) How can I change currency of ‘Internal Accounting
> Organizations’
> > > to BRL?
> > > (2) How to show prices in Brasilian Reais?
> > >
> > > Thanks, Wolfgang
> > >
> >
> >
> > --
> >
> > Wolfgang Rauchholz
> >
>


-- 

Wolfgang Rauchholz

Re: ofbizsetup procedure

[Wolfgang Paul Rauchholz]

Please disregard ' Problem: eCommerce page does not show prices in BRL. It
Shows ‘Your Price: $0.00’'
After a while it shows now in BRL. As if updates would take some time to
take effect?

But still, how can I change the  ‘Internal Accounting Organizations’, via
'Entity Data Maintenance'?

On Fri, Jun 8, 2018 at 11:31 AM wp.rauchh...@gmail.com <
wp.rauchh...@gmail.com> wrote:

> Still playing with ofbiz. Now setting it up using the script ofbizsetup:
> https://10.5.2.1:8443/ofbizsetup/control/main
>
> Observations:
> Tab ‘PRODUCT STORE’; does not allow to set a currency. Ofbiz assumes USD.
> Tab ‘First CUSTOMER’; missing password field under ‘User name’ on screen
> causes error message: Work-around; open a new ofbiz session and enter a
> customer before continuing with ofbizsetup procedure
> Tab ‘First PRODUCT’; does not allow to set a currency. Ofbiz assumes USD.
> This procedure ends up with ‘Internal Accounting Organizations’ in USD.
> The eCommerce page shows sales prices in USD too
>
> I changed/added to BRL currency in the following screens:
> •   Party > ‘Preferred Currency Uom Id’: set to BRL
> •   Deleted / added standard/list price and avg cost for product to BRL
> •   Store > Localization >Default Currency Uom Id’ Set to BRL
> Problem: eCommerce page does not show prices in BRL. It Shows ‘Your Price:
> $0.00’
>
> Questions:
> (1) How can I change currency of ‘Internal Accounting Organizations’
> to BRL?
> (2) How to show prices in Brasilian Reais?
>
> Thanks, Wolfgang
>


-- 

Wolfgang Rauchholz

Re: A Product Store has not been defined for this ecommerce site.

[Wolfgang Paul Rauchholz]

Thx to both!
That helped to solve my issue.

On Thu, 7 Jun 2018 at 13:34, Rishi Solanki  wrote:

> Forgot to share the related link;
>
> 1)
>
> https://cwiki.apache.org/confluence/display/OFBENDUSER/How+to+Install+OFBiz+without+the+Demo+Data
>
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: +91-9893287847
> http://www.hotwaxsystems.com
> www.hotwax.co
>
> On Thu, Jun 7, 2018 at 5:02 PM, Rishi Solanki 
> wrote:
>
> > Assuming you have loaded the other required data except demo data. Please
> > refer the #1 to get idea on how to setup basic store with categories.
> > You can also consider to refer plugins/ecommerce/data/DemoProduct.xml to
> > get an idea about what data required to setup the store, catalog,
> > categories, product and all.
> >
> > HTH!
> >
> > Rishi Solanki
> > Sr Manager, Enterprise Software Development
> > HotWax Systems Pvt. Ltd.
> > Direct: +91-9893287847
> > http://www.hotwaxsystems.com
> > www.hotwax.co
> >
> > On Thu, Jun 7, 2018 at 4:43 PM, Sita Ram Pothula <
> > sitaram.poth...@gmail.com> wrote:
> >
> >> if the problem is with eCommerce check FACILITY, PARTY and PARTY_ROLE
> >> tables. I guess the data in these tables missing and you need to create
> >> default webstore.
> >>
> >> On Wed, Jun 6, 2018 at 10:44 PM, wp.rauchh...@gmail.com <
> >> wp.rauchh...@gmail.com> wrote:
> >>
> >> > I am setting up a data model starting with an empty database.
> >> >
> >> > I am getting above message when trying to open the eCommerce page.
> >> > That is what I setup:
> >> > * Catalog + 2 categories (Promotion and Browse Root). Both categories
> >> have
> >> > Products defined.
> >> > * Store, and within the store a Website, facility, etc..
> >> >
> >> > I basically replicated the way it is setup in the demo system.
> >> >
> >> > What is missing?
> >> >
> >> > Wolfgang
> >> >
> >>
> >
> >
>
-- 

Wolfgang Rauchholz

Re: Payment Gateway Config Error

[Wolfgang Paul Rauchholz]

Not sure it makes sense what I am saying here, but at the end I was able to
upload the file.
I opened the XML file and copied it into 'XML Import to DataSource(s)' >
'Import Text'
There was a spaceline after each record (see also underneath) . After
deleteing the space line, it uploaded fine. With the space line it would
not.









On Wed, Jun 6, 2018 at 11:37 AM, Wolfgang Paul Rauchholz <
wp.rauchh...@gmail.com> wrote:

> Hi Jacques, I tried with a fresh DB again and got the same problem. Right
> now I am setting up a data model in ofbiz that would represent what we plan
> to do. Slow process, can do this only in my 'leisure time'
> I have no issue when entering the data manually so far.What I have
> experiences so far is that some of the error messages are very technical
> and not deciphable for end-users.
>
>
> I will post/ask learnigs or problems I run into.
>
>
> Sales Channels (1) Sale from central DC to end-user (eCommerce)
> (2) Sale from central DC to wholesaler
> FINGDOOD transfers (3) Inventory transfer from central DC to retail shops
> for sale to end-user
> Title remains with 'Company'. Consignemt stock
> Shops are 'children' of central DC
> Production  *All products produced by Sub-contractor
> * Sub-contracted supplier operates central DC
> * Title of inventory @ central DC remains with Company
> Sourcing / Replenishment Performed by 'Company'. Direct material
> drop-shipped
> to Sub-Contractor and stored there as consignment stock
> Thanks for your support. Wolfgang
>
> On Wed, Jun 6, 2018 at 11:07 AM, Jacques Le Roux <
> jacques.le.r...@les7arts.com> wrote:
>
>> Hi,
>>
>> Yes those are only warning and show that your DB differs from the data
>> loaded. You might try to begin with a fresh DB again if you have still
>> issues. Else you can live with it, though I'd no recommend that in
>> production.
>>
>> Jacques
>>
>>
>>
>> Le 05/06/2018 à 16:59, Wolfgang Paul Rauchholz a écrit :
>>
>>> When running the ./gradlew commant I redicrected the output into a .txt
>>> file to review.
>>> There is not a single error message I can find, but some messages I
>>> assume
>>> are Warnings, like e.g.
>>>
>>> 2018-06-04 14:57:47,991 |OFBiz-batch-1|DatabaseUtil
>>>|W| Column [LAST_UPDATED_TX_STAMP] of table [SALES_ORDER_ITEM_FACT] of
>>> entity [SalesOrderItemFact] has a column size of [19] in the database,
>>> but
>>> is defined to have a column size of [3] in the entity definition.
>>> 2018-06-04 14:57:47,991 |OFBiz-batch-1|DatabaseUtil
>>>|W| Column [CREATED_STAMP] of table [SALES_ORDER_ITEM_FACT] of entity
>>> [SalesOrderItemFact] has a column size of [19] in the database, but is
>>> defined to have a column size of [3] in the entity definition.
>>> 2018-06-04 14:57:47,991 |OFBiz-batch-1|DatabaseUtil
>>>|W| Table named [ACCOMMODATION_CLASS] exists in the database but has
>>> no
>>> corresponding entity
>>> 2018-06-04 14:57:47,991 |OFBiz-batch-1|DatabaseUtil
>>>|W| Table named [ACCOMMODATION_MAP] exists in the database but has no
>>> corresponding entity
>>> 2018-06-04 14:57:47,991 |OFBiz-batch-1|DatabaseUtil
>>>|W| Table named [ACCOMMODATION_MAP_TYPE] exists in the database but
>>> has
>>> no corresponding entity
>>> 2018-06-04 14:57:47,991 |OFBiz-batch-1|DatabaseUtil
>>>|W| Table named [ACCOMMODATION_SPOT] exists in the database but has no
>>> corresponding entity
>>> 2018-06-04 14:57:47,991 |OFBiz-batch-1|DatabaseUtil
>>>|W| Table named [ACCTG_TRANS] exists in the database but has no
>>> corresponding entity
>>>
>>>
>>>
>>>
>>> 2018-06-04 14:57:48,179 |OFBiz-batch-2|DatabaseUtil
>>>|W| Column [RESERVED_DATETIME] of table [ORDER_ITEM_SHIP_GRP_INV_RES]
>>> of
>>> entity [OrderItemShipGrpInvRes] has a column size of [19] in the
>>> database,
>>> but is defined to have a column size of [3] in the entity definition.
>>> 2018-06-04 14:57:48,179 |OFBiz-batch-2|DatabaseUtil
>>>|W| Column [PROMISED_DATETIME] of table [ORDER_ITEM_SHIP_GRP_INV_RES]
>>> of
>>> entity [OrderItemShipGrpInvRes] has a column size of [19] in the
>>> database,
>>> but is defined to have a column size of [3] in the entity definition.
>>> 2018-06-04 14:57:48,179 |OFBiz-batch-2|DatabaseUtil
>>>|W| Column [LAST_UPDATED_TX_STAMP] of table [ORDER_ITEM_TYPE] of
>>> entity
>>> [OrderIte

Re: Payment Gateway Config Error

[Wolfgang Paul Rauchholz]

Hi Jacques, I tried with a fresh DB again and got the same problem. Right
now I am setting up a data model in ofbiz that would represent what we plan
to do. Slow process, can do this only in my 'leisure time'
I have no issue when entering the data manually so far.What I have
experiences so far is that some of the error messages are very technical
and not deciphable for end-users.


I will post/ask learnigs or problems I run into.


Sales Channels (1) Sale from central DC to end-user (eCommerce)
(2) Sale from central DC to wholesaler
FINGDOOD transfers (3) Inventory transfer from central DC to retail shops
for sale to end-user
Title remains with 'Company'. Consignemt stock
Shops are 'children' of central DC
Production  *All products produced by Sub-contractor
* Sub-contracted supplier operates central DC
* Title of inventory @ central DC remains with Company
Sourcing / Replenishment Performed by 'Company'. Direct material
drop-shipped
to Sub-Contractor and stored there as consignment stock
Thanks for your support. Wolfgang

On Wed, Jun 6, 2018 at 11:07 AM, Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Hi,
>
> Yes those are only warning and show that your DB differs from the data
> loaded. You might try to begin with a fresh DB again if you have still
> issues. Else you can live with it, though I'd no recommend that in
> production.
>
> Jacques
>
>
>
> Le 05/06/2018 à 16:59, Wolfgang Paul Rauchholz a écrit :
>
>> When running the ./gradlew commant I redicrected the output into a .txt
>> file to review.
>> There is not a single error message I can find, but some messages I assume
>> are Warnings, like e.g.
>>
>> 2018-06-04 14:57:47,991 |OFBiz-batch-1|DatabaseUtil
>>|W| Column [LAST_UPDATED_TX_STAMP] of table [SALES_ORDER_ITEM_FACT] of
>> entity [SalesOrderItemFact] has a column size of [19] in the database, but
>> is defined to have a column size of [3] in the entity definition.
>> 2018-06-04 14:57:47,991 |OFBiz-batch-1|DatabaseUtil
>>|W| Column [CREATED_STAMP] of table [SALES_ORDER_ITEM_FACT] of entity
>> [SalesOrderItemFact] has a column size of [19] in the database, but is
>> defined to have a column size of [3] in the entity definition.
>> 2018-06-04 14:57:47,991 |OFBiz-batch-1|DatabaseUtil
>>|W| Table named [ACCOMMODATION_CLASS] exists in the database but has no
>> corresponding entity
>> 2018-06-04 14:57:47,991 |OFBiz-batch-1|DatabaseUtil
>>|W| Table named [ACCOMMODATION_MAP] exists in the database but has no
>> corresponding entity
>> 2018-06-04 14:57:47,991 |OFBiz-batch-1|DatabaseUtil
>>|W| Table named [ACCOMMODATION_MAP_TYPE] exists in the database but has
>> no corresponding entity
>> 2018-06-04 14:57:47,991 |OFBiz-batch-1|DatabaseUtil
>>|W| Table named [ACCOMMODATION_SPOT] exists in the database but has no
>> corresponding entity
>> 2018-06-04 14:57:47,991 |OFBiz-batch-1|DatabaseUtil
>>|W| Table named [ACCTG_TRANS] exists in the database but has no
>> corresponding entity
>>
>>
>>
>>
>> 2018-06-04 14:57:48,179 |OFBiz-batch-2|DatabaseUtil
>>|W| Column [RESERVED_DATETIME] of table [ORDER_ITEM_SHIP_GRP_INV_RES]
>> of
>> entity [OrderItemShipGrpInvRes] has a column size of [19] in the database,
>> but is defined to have a column size of [3] in the entity definition.
>> 2018-06-04 14:57:48,179 |OFBiz-batch-2|DatabaseUtil
>>|W| Column [PROMISED_DATETIME] of table [ORDER_ITEM_SHIP_GRP_INV_RES]
>> of
>> entity [OrderItemShipGrpInvRes] has a column size of [19] in the database,
>> but is defined to have a column size of [3] in the entity definition.
>> 2018-06-04 14:57:48,179 |OFBiz-batch-2|DatabaseUtil
>>|W| Column [LAST_UPDATED_TX_STAMP] of table [ORDER_ITEM_TYPE] of entity
>> [OrderItemType] has a column size of [19] in the database, but is defined
>> to have a column size of [3] in the entity definition.
>> 2018-06-04 14:57:48,179 |OFBiz-batch-2|DatabaseUtil
>>|W| Column [LAST_UPDATED_STAMP] of table [ORDER_ITEM_TYPE] of entity
>> [OrderItemType] has a column size of [19] in the database, but is defined
>> to have a column size of [3] in the entity definition.
>> 2018-06-04 14:57:48,180 |OFBiz-batch-2|DatabaseUtil
>>|W| Column [CREATED_STAMP] of table [ORDER_ITEM_TYPE] of entity
>> [OrderItemType] has a column size of [19] in the database, but is defined
>> to have a column size of [3] in the entity definition.
>> 2018-06-04 14:57:48,180 |OFBiz-batch-2|DatabaseUtil
>>|W| Column [CREATED_TX_STAMP] of table [ORDER_ITEM_TYPE] of entity
>> [OrderItemType]

Re: Payment Gateway Config Error

[Wolfgang Paul Rauchholz]

When running the ./gradlew commant I redicrected the output into a .txt
file to review.
There is not a single error message I can find, but some messages I assume
are Warnings, like e.g.

2018-06-04 14:57:47,991 |OFBiz-batch-1|DatabaseUtil
  |W| Column [LAST_UPDATED_TX_STAMP] of table [SALES_ORDER_ITEM_FACT] of
entity [SalesOrderItemFact] has a column size of [19] in the database, but
is defined to have a column size of [3] in the entity definition.
2018-06-04 14:57:47,991 |OFBiz-batch-1|DatabaseUtil
  |W| Column [CREATED_STAMP] of table [SALES_ORDER_ITEM_FACT] of entity
[SalesOrderItemFact] has a column size of [19] in the database, but is
defined to have a column size of [3] in the entity definition.
2018-06-04 14:57:47,991 |OFBiz-batch-1|DatabaseUtil
  |W| Table named [ACCOMMODATION_CLASS] exists in the database but has no
corresponding entity
2018-06-04 14:57:47,991 |OFBiz-batch-1|DatabaseUtil
  |W| Table named [ACCOMMODATION_MAP] exists in the database but has no
corresponding entity
2018-06-04 14:57:47,991 |OFBiz-batch-1|DatabaseUtil
  |W| Table named [ACCOMMODATION_MAP_TYPE] exists in the database but has
no corresponding entity
2018-06-04 14:57:47,991 |OFBiz-batch-1|DatabaseUtil
  |W| Table named [ACCOMMODATION_SPOT] exists in the database but has no
corresponding entity
2018-06-04 14:57:47,991 |OFBiz-batch-1|DatabaseUtil
  |W| Table named [ACCTG_TRANS] exists in the database but has no
corresponding entity




2018-06-04 14:57:48,179 |OFBiz-batch-2|DatabaseUtil
  |W| Column [RESERVED_DATETIME] of table [ORDER_ITEM_SHIP_GRP_INV_RES] of
entity [OrderItemShipGrpInvRes] has a column size of [19] in the database,
but is defined to have a column size of [3] in the entity definition.
2018-06-04 14:57:48,179 |OFBiz-batch-2|DatabaseUtil
  |W| Column [PROMISED_DATETIME] of table [ORDER_ITEM_SHIP_GRP_INV_RES] of
entity [OrderItemShipGrpInvRes] has a column size of [19] in the database,
but is defined to have a column size of [3] in the entity definition.
2018-06-04 14:57:48,179 |OFBiz-batch-2|DatabaseUtil
  |W| Column [LAST_UPDATED_TX_STAMP] of table [ORDER_ITEM_TYPE] of entity
[OrderItemType] has a column size of [19] in the database, but is defined
to have a column size of [3] in the entity definition.
2018-06-04 14:57:48,179 |OFBiz-batch-2|DatabaseUtil
  |W| Column [LAST_UPDATED_STAMP] of table [ORDER_ITEM_TYPE] of entity
[OrderItemType] has a column size of [19] in the database, but is defined
to have a column size of [3] in the entity definition.
2018-06-04 14:57:48,180 |OFBiz-batch-2|DatabaseUtil
  |W| Column [CREATED_STAMP] of table [ORDER_ITEM_TYPE] of entity
[OrderItemType] has a column size of [19] in the database, but is defined
to have a column size of [3] in the entity definition.
2018-06-04 14:57:48,180 |OFBiz-batch-2|DatabaseUtil
  |W| Column [CREATED_TX_STAMP] of table [ORDER_ITEM_TYPE] of entity
[OrderItemType] has a column size of [19] in the database, but is defined
to have a column size of [3] in the entity definition.

On Tue, Jun 5, 2018 at 4:18 PM, Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> To be frank, like you, I prefer to use a branch rather than a package
> because it has the last fixes.
>
> So for me (only, not as an official PMC member) no, svn is stabler than a
> package.
>
> This said I have still no ideas why you get issues ;)
>
> Jacques
>
>
>
> Le 05/06/2018 à 12:06, Wolfgang Paul Rauchholz a écrit :
>
>> I run OfBiz on Centos 7 home server. Latest kernel version.
>>
>> Database Product Name is MySQL
>> Database Product Version is 5.5.56-MariaDB
>> Database Driver Name is MySQL Connector Java
>> Database Driver Version is mysql-connector-java-5.1.25 ( Revision:
>> ${bzr.revision-id} )
>> Database Driver JDBC Version is 4.0
>>
>> Install sources. Is zip file a better (stabler0 version than svn?
>>
>>
>>
>> On Sun, Jun 3, 2018 at 2:39 PM, Jacques Le Roux <
>> jacques.le.r...@les7arts.com> wrote:
>>
>> Le 01/06/2018 à 15:23, Wolfgang Paul Rauchholz a écrit :
>>>
>>> Not sure what happend, but I really did not change anything. I do also
>>>> have
>>>> problems with uploading XML files I had created before by exporting from
>>>> ofbiz into the empye db.
>>>>
>>>> What might help here are small relevant log extracts
>>>
>>> Did I do something wrong with setting up the installation? This is what I
>>>
>>>> did:
>>>> (1) Install sources:
>>>> svn co http://svn.apache.org/repos/asf/ofbiz/branches/release16.11
>>>> ofbiz
>>>>
>>>> That sounds good if you want to work from a not released branch instead
>>> of
>>> 

Re: Payment Gateway Config Error

[Wolfgang Paul Rauchholz]

I run OfBiz on Centos 7 home server. Latest kernel version.

Database Product Name is MySQL
Database Product Version is 5.5.56-MariaDB
Database Driver Name is MySQL Connector Java
Database Driver Version is mysql-connector-java-5.1.25 ( Revision:
${bzr.revision-id} )
Database Driver JDBC Version is 4.0

Install sources. Is zip file a better (stabler0 version than svn?



On Sun, Jun 3, 2018 at 2:39 PM, Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

>
> Le 01/06/2018 à 15:23, Wolfgang Paul Rauchholz a écrit :
>
>> Not sure what happend, but I really did not change anything. I do also
>> have
>> problems with uploading XML files I had created before by exporting from
>> ofbiz into the empye db.
>>
> What might help here are small relevant log extracts
>
> Did I do something wrong with setting up the installation? This is what I
>> did:
>> (1) Install sources:
>> svn co http://svn.apache.org/repos/asf/ofbiz/branches/release16.11 ofbiz
>>
> That sounds good if you want to work from a not released branch instead of
> a package
>
> cd ofbiz
>> svn co http://svn.apache.org/repos/asf/ofbiz/tools ofbiz-tools
>> svn co http://svn.apache.org/repos/asf/ofbiz/site ofbiz-website
>>
> You should not need those apart if you want to contribute to them
>
> (2) runnning on mysql  I made changes in gradle.build and entityengine.xml
>> accordingly.
>>
> Sounds good
>
> (3) create database ofbiz
>> (4) ./gradlew build
>> (5) ./gradlew "ofbiz --load-data readers=seed,seed-initial"
>> loadAdminUserLogin -PuserLoginId=my_username
>>
> You might even chain all of them, in one command but that's good
>
> gradlew ran wi/o an error message. Initial data were (mostly I guess)
>> loaded correctly.
>>
> Sincerely I have no ideas, relevant traces (ie not repeating same things
> ad nauseam) in logs should help
>
> BTW on which OS are you running?
>
> HTH
>
> Jacques
>
>
>> Wolfgang
>>
>> On Thu, May 31, 2018 at 10:04 PM, Jacques Le Roux <
>> jacques.le.r...@les7arts.com> wrote:
>>
>> You certainly changed something. It works in demos
>>>
>>> https://demo-trunk.ofbiz.apache.org/accounting/control/EditP
>>> aymentGatewayConfig?paymentGatewayConfigId=CLEARCOMMERCE_CONFIG
>>>
>>> https://demo-stable.ofbiz.apache.org/accounting/control/Edit
>>> PaymentGatewayConfig?paymentGatewayConfigId=CLEARCOMMERCE_CONFIG
>>>
>>> This said and unrelated I don't see Authorize Dot Net Config <
>>> https://demo-stable.ofbiz.apache.org/accounting/control/Edi
>>> tPaymentGatewayConfig?paymentGatewayConfigId=AUTHORIZE_NET_CONFIG> in
>>> trunk (exists in stable)
>>>
>>> https://demo-trunk.ofbiz.apache.org/accounting/control/FindP
>>> aymentGatewayConfig
>>>
>>> Jacques
>>>
>>>
>>>
>>> Le 31/05/2018 à 18:25, wp.rauchh...@gmail.com a écrit :
>>>
>>> I am in the Payment Gateway Config module.
>>>> When hitting the link 'Authorize Dot Net Config' ofbiz shows the
>>>> configuration of it.
>>>> but when I hit "Clear Commerce Config" it throws out an error message
>>>>
>>>> Any idea whay this happens? I did not change anything, just wanted to
>>>> look.
>>>>
>>>> Thanks, WOlfgang
>>>>
>>>>
>>>> ERROR rendering error page [/error/error.jsp], but here is the error
>>>> text: org.apache.ofbiz.widget.renderer.ScreenRenderException: Error
>>>> rendering screen [component://accounting/widget
>>>> /PaymentGatewayConfigScreens.xml#EditPaymentGatewayConfig]:
>>>> java.lang.IllegalArgumentException: Error doing entity query by
>>>> condition: org.apache.ofbiz.base.util.GeneralException: Error finding
>>>> entity value by primary key with entity-one:
>>>> org.apache.ofbiz.entity.GenericEntityException:
>>>> org.apache.shiro.crypto.CryptoException: Unable to execute 'doFinal'
>>>> with cipher instance [javax.crypto.Cipher@53a1f3aa]. (Unable to execute
>>>> 'doFinal' with cipher instance [javax.crypto.Cipher@53a1f3aa].)
>>>> (org.apache.shiro.crypto.CryptoException: Unable to execute 'doFinal'
>>>> with cipher instance [javax.crypto.Cipher@53a1f3aa]. (Unable to execute
>>>> 'doFinal' with cipher instance [javax.crypto.Cipher@53a1f3aa].)) (Error
>>>> doing entity query by condition: org.apache.ofbiz.base.util.Gen
>>>> eralException:
>>>> Error finding entity value by
>>>>primary key with entity-one: org.apache.ofbiz.entity.Generi
>>>> cEntityException:
>>>> org.apache.shiro.crypto.CryptoException: Unable to execute 'doFinal'
>>>> with cipher instance [javax.crypto.Cipher@53a1f3aa]. (Unable to execute
>>>> 'doFinal' with cipher instance [javax.crypto.Cipher@53a1f3aa].)
>>>> (org.apache.shiro.crypto.CryptoException: Unable to execute 'doFinal'
>>>> with cipher instance [javax.crypto.Cipher@53a1f3aa]. (Unable to execute
>>>> 'doFinal' with cipher instance [javax.crypto.Cipher@53a1f3aa].)))
>>>>
>>>>
>>>>
>>>>
>>>>
>>
>


-- 

Wolfgang Rauchholz

Re: Payment Gateway Config Error

[Wolfgang Paul Rauchholz]

Not sure what happend, but I really did not change anything. I do also have
problems with uploading XML files I had created before by exporting from
ofbiz into the empye db.
Did I do something wrong with setting up the installation? This is what I
did:
(1) Install sources:
svn co http://svn.apache.org/repos/asf/ofbiz/branches/release16.11 ofbiz
cd ofbiz
svn co http://svn.apache.org/repos/asf/ofbiz/tools ofbiz-tools
svn co http://svn.apache.org/repos/asf/ofbiz/site ofbiz-website

(2) runnning on mysql  I made changes in gradle.build and entityengine.xml
accordingly.
(3) create database ofbiz
(4) ./gradlew build
(5) ./gradlew "ofbiz --load-data readers=seed,seed-initial"
loadAdminUserLogin -PuserLoginId=my_username

gradlew ran wi/o an error message. Initial data were (mostly I guess)
loaded correctly.

Wolfgang

On Thu, May 31, 2018 at 10:04 PM, Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> You certainly changed something. It works in demos
>
> https://demo-trunk.ofbiz.apache.org/accounting/control/EditP
> aymentGatewayConfig?paymentGatewayConfigId=CLEARCOMMERCE_CONFIG
>
> https://demo-stable.ofbiz.apache.org/accounting/control/Edit
> PaymentGatewayConfig?paymentGatewayConfigId=CLEARCOMMERCE_CONFIG
>
> This said and unrelated I don't see Authorize Dot Net Config <
> https://demo-stable.ofbiz.apache.org/accounting/control/Edi
> tPaymentGatewayConfig?paymentGatewayConfigId=AUTHORIZE_NET_CONFIG> in
> trunk (exists in stable)
>
> https://demo-trunk.ofbiz.apache.org/accounting/control/FindP
> aymentGatewayConfig
>
> Jacques
>
>
>
> Le 31/05/2018 à 18:25, wp.rauchh...@gmail.com a écrit :
>
>> I am in the Payment Gateway Config module.
>> When hitting the link 'Authorize Dot Net Config' ofbiz shows the
>> configuration of it.
>> but when I hit "Clear Commerce Config" it throws out an error message
>>
>> Any idea whay this happens? I did not change anything, just wanted to
>> look.
>>
>> Thanks, WOlfgang
>>
>>
>> ERROR rendering error page [/error/error.jsp], but here is the error
>> text: org.apache.ofbiz.widget.renderer.ScreenRenderException: Error
>> rendering screen [component://accounting/widget
>> /PaymentGatewayConfigScreens.xml#EditPaymentGatewayConfig]:
>> java.lang.IllegalArgumentException: Error doing entity query by
>> condition: org.apache.ofbiz.base.util.GeneralException: Error finding
>> entity value by primary key with entity-one: 
>> org.apache.ofbiz.entity.GenericEntityException:
>> org.apache.shiro.crypto.CryptoException: Unable to execute 'doFinal'
>> with cipher instance [javax.crypto.Cipher@53a1f3aa]. (Unable to execute
>> 'doFinal' with cipher instance [javax.crypto.Cipher@53a1f3aa].)
>> (org.apache.shiro.crypto.CryptoException: Unable to execute 'doFinal'
>> with cipher instance [javax.crypto.Cipher@53a1f3aa]. (Unable to execute
>> 'doFinal' with cipher instance [javax.crypto.Cipher@53a1f3aa].)) (Error
>> doing entity query by condition: org.apache.ofbiz.base.util.GeneralException:
>> Error finding entity value by
>>   primary key with entity-one: 
>> org.apache.ofbiz.entity.GenericEntityException:
>> org.apache.shiro.crypto.CryptoException: Unable to execute 'doFinal'
>> with cipher instance [javax.crypto.Cipher@53a1f3aa]. (Unable to execute
>> 'doFinal' with cipher instance [javax.crypto.Cipher@53a1f3aa].)
>> (org.apache.shiro.crypto.CryptoException: Unable to execute 'doFinal'
>> with cipher instance [javax.crypto.Cipher@53a1f3aa]. (Unable to execute
>> 'doFinal' with cipher instance [javax.crypto.Cipher@53a1f3aa].)))
>>
>>
>>
>>
>


-- 

Wolfgang Rauchholz

Re: Error messages when uploading xml files

[Wolfgang Paul Rauchholz]

Manually I can enter the GL accounts without a problem.

Wolfgang


On Tue, May 29, 2018 at 9:26 AM, Wolfgang Paul Rauchholz <
wp.rauchh...@gmail.com> wrote:

> Thank you for following up Paul. The log is very long. This is a very
> small snapshot
>
> 2018-05-29 09:22:49,152 |http-nio-8443-exec-3 |EntitySaxReader |I|
> Beginning import from URL: file:/home/wp.rauchholz/ofbiz/GlAccount.xml
> 2018-05-29 09:22:49,156 |http-nio-8443-exec-3 |EntitySaxReader |I|
> Transaction Timeout set to 2 hours (7200 seconds)
> 2018-05-29 09:22:49,159 |xer_default_products |DocumentIndexer |I|
> DocumentIndexer_default_products: indexed Lucene document: productId:20011
> 2018-05-29 09:22:49,170 |xer_default_products |DocumentIndexer |I|
> DocumentIndexer_default_products: indexed Lucene document: productId:10003
> 2018-05-29 09:22:49,171 |http-nio-8443-exec-3 |GenericDelegator |E|
> Failure in create operation for entity [GlAccount]: 
> org.apache.ofbiz.entity.GenericEntityException:
> Error while inserting: [GenericEntity:GlAccount][
> accountCode,402000(java.lang.String)][accountName,Miscellaneous
> Sales(java.lang.String)][createdStamp,2018-05-29 09:22:49.175(java.sql.
> Timestamp)][createdTxStamp,2018-05-29 09:22:49.156(java.sql.
> Timestamp)][glAccountClassId,REVENUE(java.lang.String)][
> glAccountId,10015(java.lang.String)][glAccountTypeId,_NA_(
> java.lang.String)][glResourceTypeId,MONEY(java.lang.String)][lastUpdatedStamp,2018-05-29
> 09:22:49.175(java.sql.Timestamp)][lastUpdatedTxStamp,2018-05-29
> 09:22:49.156(java.sql.Timestamp)][parentGlAccountId,10177(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO GL_ACCOUNT
> (GL_ACCOUNT_ID, GL_ACCOUNT_TYPE_ID, GL_ACCOUNT_CLASS_ID,
> GL_RESOURCE_TYPE_ID, GL_XBRL_CLASS_ID, PARENT_GL_ACCOUNT_ID, ACCOUNT_CODE,
> ACCOUNT_NAME, DESCRIPTION, PRODUCT_ID, EXTERNAL_ID, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a
> foreign key constraint fails (`ofbiz`.`GL_ACCOUNT`, CONSTRAINT `GLACCT_PAR`
> FOREIGN KEY (`PARENT_GL_ACCOUNT_ID`) REFERENCES `GL_ACCOUNT`
> (`GL_ACCOUNT_ID`. Rolling back transaction.
> 2018-05-29 09:22:49,171 |http-nio-8443-exec-3 |TransactionUtil |W| Calling
> transaction setRollbackOnly; this stack trace shows where this is happening:
> java.lang.Exception: Failure in create operation for entity [GlAccount]:
> org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:GlAccount][accountCode,402000(java.lang.
> String)][accountName,Miscellaneous 
> Sales(java.lang.String)][createdStamp,2018-05-29
> 09:22:49.175(java.sql.Timestamp)][createdTxStamp,2018-05-29
> 09:22:49.156(java.sql.Timestamp)][glAccountClassId,
> REVENUE(java.lang.String)][glAccountId,10015(java.lang.
> String)][glAccountTypeId,_NA_(java.lang.String)][
> glResourceTypeId,MONEY(java.lang.String)][lastUpdatedStamp,2018-05-29
> 09:22:49.175(java.sql.Timestamp)][lastUpdatedTxStamp,2018-05-29
> 09:22:49.156(java.sql.Timestamp)][parentGlAccountId,10177(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO GL_ACCOUNT
> (GL_ACCOUNT_ID, GL_ACCOUNT_TYPE_ID, GL_ACCOUNT_CLASS_ID,
> GL_RESOURCE_TYPE_ID, GL_XBRL_CLASS_ID, PARENT_GL_ACCOUNT_ID, ACCOUNT_CODE,
> ACCOUNT_NAME, DESCRIPTION, PRODUCT_ID, EXTERNAL_ID, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a
> foreign key constraint fails (`ofbiz`.`GL_ACCOUNT`, CONSTRAINT `GLACCT_PAR`
> FOREIGN KEY (`PARENT_GL_ACCOUNT_ID`) REFERENCES `GL_ACCOUNT`
> (`GL_ACCOUNT_ID`. Rolling back transaction.
>
>
>
>
> 2018-05-29 09:22:49,183 |xer_default_products |DocumentIndexer |I|
> DocumentIndexer_default_products: indexed Lucene document: productId:20017
> 2018-05-29 09:22:49,176 |http-nio-8443-exec-3 |GenericDelegator |E|
> Failure in storeAll operation: org.apache.ofbiz.entity.GenericEntityException:
> org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:GlAccount][accountCode,402000(java.lang.
> String)][accountName,Miscellaneous 
> Sales(java.lang.String)][createdStamp,2018-05-29
> 09:22:49.175(java.sql.Timestamp)][createdTxStamp,2018-05-29
> 09:22:49.156(java.sql.Timestamp)][glAccountClassId,
> REVENUE(java.lang.String)][glAccountId,10015(java.lang.
> String)][glAccountTypeId,_NA_(java.lang.String)][
> glResourceTypeId,MONEY(java.lang.String)][lastUpdatedStamp,2018-05-29
> 09:22:49.175(java.sql.Timestamp)][lastUpdatedTxStamp,2018-05-29
> 09:22:49.156(java.sql.Timestamp)][parentGlAccountId,10177(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO GL_ACCOUNT
&g

Re: Error messages when uploading xml files

[Wolfgang Paul Rauchholz]

Thank you for following up Paul. The log is very long. This is a very small
snapshot

2018-05-29 09:22:49,152 |http-nio-8443-exec-3 |EntitySaxReader |I|
Beginning import from URL: file:/home/wp.rauchholz/ofbiz/GlAccount.xml
2018-05-29 09:22:49,156 |http-nio-8443-exec-3 |EntitySaxReader |I|
Transaction Timeout set to 2 hours (7200 seconds)
2018-05-29 09:22:49,159 |xer_default_products |DocumentIndexer |I|
DocumentIndexer_default_products: indexed Lucene document: productId:20011
2018-05-29 09:22:49,170 |xer_default_products |DocumentIndexer |I|
DocumentIndexer_default_products: indexed Lucene document: productId:10003
2018-05-29 09:22:49,171 |http-nio-8443-exec-3 |GenericDelegator |E| Failure
in create operation for entity [GlAccount]:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:GlAccount][accountCode,402000(java.lang.String)][accountName,Miscellaneous
Sales(java.lang.String)][createdStamp,2018-05-29
09:22:49.175(java.sql.Timestamp)][createdTxStamp,2018-05-29
09:22:49.156(java.sql.Timestamp)][glAccountClassId,REVENUE(java.lang.String)][glAccountId,10015(java.lang.String)][glAccountTypeId,_NA_(java.lang.String)][glResourceTypeId,MONEY(java.lang.String)][lastUpdatedStamp,2018-05-29
09:22:49.175(java.sql.Timestamp)][lastUpdatedTxStamp,2018-05-29
09:22:49.156(java.sql.Timestamp)][parentGlAccountId,10177(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO GL_ACCOUNT
(GL_ACCOUNT_ID, GL_ACCOUNT_TYPE_ID, GL_ACCOUNT_CLASS_ID,
GL_RESOURCE_TYPE_ID, GL_XBRL_CLASS_ID, PARENT_GL_ACCOUNT_ID, ACCOUNT_CODE,
ACCOUNT_NAME, DESCRIPTION, PRODUCT_ID, EXTERNAL_ID, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a
foreign key constraint fails (`ofbiz`.`GL_ACCOUNT`, CONSTRAINT `GLACCT_PAR`
FOREIGN KEY (`PARENT_GL_ACCOUNT_ID`) REFERENCES `GL_ACCOUNT`
(`GL_ACCOUNT_ID`. Rolling back transaction.
2018-05-29 09:22:49,171 |http-nio-8443-exec-3 |TransactionUtil |W| Calling
transaction setRollbackOnly; this stack trace shows where this is happening:
java.lang.Exception: Failure in create operation for entity [GlAccount]:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:GlAccount][accountCode,402000(java.lang.String)][accountName,Miscellaneous
Sales(java.lang.String)][createdStamp,2018-05-29
09:22:49.175(java.sql.Timestamp)][createdTxStamp,2018-05-29
09:22:49.156(java.sql.Timestamp)][glAccountClassId,REVENUE(java.lang.String)][glAccountId,10015(java.lang.String)][glAccountTypeId,_NA_(java.lang.String)][glResourceTypeId,MONEY(java.lang.String)][lastUpdatedStamp,2018-05-29
09:22:49.175(java.sql.Timestamp)][lastUpdatedTxStamp,2018-05-29
09:22:49.156(java.sql.Timestamp)][parentGlAccountId,10177(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO GL_ACCOUNT
(GL_ACCOUNT_ID, GL_ACCOUNT_TYPE_ID, GL_ACCOUNT_CLASS_ID,
GL_RESOURCE_TYPE_ID, GL_XBRL_CLASS_ID, PARENT_GL_ACCOUNT_ID, ACCOUNT_CODE,
ACCOUNT_NAME, DESCRIPTION, PRODUCT_ID, EXTERNAL_ID, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a
foreign key constraint fails (`ofbiz`.`GL_ACCOUNT`, CONSTRAINT `GLACCT_PAR`
FOREIGN KEY (`PARENT_GL_ACCOUNT_ID`) REFERENCES `GL_ACCOUNT`
(`GL_ACCOUNT_ID`. Rolling back transaction.




2018-05-29 09:22:49,183 |xer_default_products |DocumentIndexer |I|
DocumentIndexer_default_products: indexed Lucene document: productId:20017
2018-05-29 09:22:49,176 |http-nio-8443-exec-3 |GenericDelegator |E| Failure
in storeAll operation: org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:GlAccount][accountCode,402000(java.lang.String)][accountName,Miscellaneous
Sales(java.lang.String)][createdStamp,2018-05-29
09:22:49.175(java.sql.Timestamp)][createdTxStamp,2018-05-29
09:22:49.156(java.sql.Timestamp)][glAccountClassId,REVENUE(java.lang.String)][glAccountId,10015(java.lang.String)][glAccountTypeId,_NA_(java.lang.String)][glResourceTypeId,MONEY(java.lang.String)][lastUpdatedStamp,2018-05-29
09:22:49.175(java.sql.Timestamp)][lastUpdatedTxStamp,2018-05-29
09:22:49.156(java.sql.Timestamp)][parentGlAccountId,10177(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO GL_ACCOUNT
(GL_ACCOUNT_ID, GL_ACCOUNT_TYPE_ID, GL_ACCOUNT_CLASS_ID,
GL_RESOURCE_TYPE_ID, GL_XBRL_CLASS_ID, PARENT_GL_ACCOUNT_ID, ACCOUNT_CODE,
ACCOUNT_NAME, DESCRIPTION, PRODUCT_ID, EXTERNAL_ID, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a
foreign key constraint fails (`ofbiz`.`GL_ACCOUNT`, CONSTRAINT `GLACCT_PAR`
FOREIGN KEY (`PARENT_GL_ACCOUNT_ID`) REFERENCES `GL_ACCOUNT`
(`GL_ACCOUNT_ID` (Error while inserting:

Re: OFBiz MRP & Manufacturing: subcontract-work

[Wolfgang Paul Rauchholz]

I hope that works

Company needs to control WO cost and retains title of raw material
inventory stored at Sub-Contractor
Sub-Contractor only invoices labor cost (and sometimes freight in case of
drop-ship to customer)


*Company* *Sub-Contractor*
(1) Company receives SO from customer
(2) Company places purchase orders for raw mtrl to supplier
Some raw mtrl orders are based on MRP explosion
Some raw mtrl orders are back to back orders
(3) Supplier drop-ships raw material to Sub-contractor
(4) Company releases work order for FINGOOD
A PO be created with the material consumed on work order and linked to WO
routing task (can be automatic with WO release?)

(5) Sub-contractor produces FINGOOD

(6) Sub-contractor either

drop-ships FINGOOD to customer, or

ships FINGOOD to company
(7) PO receipt of FINGOOD closes purchase order and correspondent task on
work order routing (can be automatic with PO receipt?)

(8) Sub-contractor to issue invoice

On Thu, May 24, 2018 at 6:36 PM, Pierre Smits <pierresm...@apache.org>
wrote:

> Hey Wolfang,
>
> Unfortunately the ASF removes attachments from emails sent to mailing
> lists.
>
>
>
>
> Best regards,
>
> Pierre Smits
>
> Apache Trafodion <https://trafodion.apache.org>, Vice President
> Apache Directory <https://directory.apache.org>, PMC Member
> Apache Incubator <https://incubator.apache.org>, committer
> Apache OFBiz <https://ofbiz.apache.org>, contributor since 2008
> Apache Steve <https://steve.apache.org>, committer
>
> On Thu, May 24, 2018 at 9:25 AM, Wolfgang Paul Rauchholz <
> wp.rauchh...@gmail.com> wrote:
>
> > Attached a simplified process description of the scenario to be
> > implemented:
> > Important is:
> > (1) Company controls cost of out-sourced production
> > (2) Company retains title of ownership of raw material @ sub-contractor
> > site
> >
> > To make this process as automatic as possible, it would be helpful if a
> PO
> > is created automatically when work order (WO) is released and that WO is
> > closed once that PO was received.
> > Is this possible?
> >
> > Wolfgang
> >
> >
> >
> >
> > On Wed, May 23, 2018 at 9:37 PM, Pierre Smits <pierresm...@apache.org>
> > wrote:
> >
> >> Are we addressing here the supply chain involving an OEM (see [1]) where
> >> one manucaturer produces parts (or even the entire product) for a
> >> 'manufacturer'  that incorporates it into its product (think Foxconn
> >> producing for Apple)?
> >>
> >> Or are we addressing the issue of having people participating in the
> >> manufacturing process?
> >>
> >> If it is the latter case, then this becomes like a 'hiring a temp'
> >> business
> >> case handled between HRM and the Purchasing Department (establishing
> >> service agreements) to raise the correct 'service' P.O.
> >>
> >> If it is the first case (supply chain) then it is way more complex.
> >>
> >> Looking at this from the the viewpoint of the Manufacturing Manager of
> >> internal company (the party using OFBiz) and the OEM providing parts to
> >> the
> >> production run at the right moment in time (JIT), a task to produce the
> >> part would - for some -make sense. But if we're talking JIT delivery,
> then
> >> it is actually not a production step, but rather the delivery of the
> part
> >> to the warehouse just before the ProductionRun (or even a task therein)
> is
> >> started. Making it more an issue of setting correct facility and order
> >> thresholds for the component in the catalog app. When the ProductionRun
> is
> >> confirmed (in the Manufacturing component, by the Manufacturing
> Manager) ,
> >> the ATP should be checked and if it doesn't meet the ProductionRun
> >> requirements it should trigger the creation of the P.O.
> >>
> >> Entity-wise everything is in place. SECA-wise there might be some gaps.
> >>
> >> All in all there is more to this (more details - business analysis-
> >>  required than outlined outlined in the various postings in this thread.
> >>
> >>
> >> [1] https://en.wikipedia.org/wiki/Original_equipment_manufacturer
> >>
> >> Best regards,
> >>
> >> Pierre Smits
> >>
> >> Apache Trafodion <https://trafodion.apache.org>, Vice President
> >> Apache Directory <https://directory.apache.org>, PMC Member
> >> Apache Incubator <https://incubator.apache.org>, committer
> >> Apache OFBiz <https://ofbiz.apache.org>, cont

Re: OFBiz MRP & Manufacturing: subcontract-work

[Wolfgang Paul Rauchholz]

Attached a simplified process description of the scenario to be implemented:
Important is:
(1) Company controls cost of out-sourced production
(2) Company retains title of ownership of raw material @ sub-contractor site

To make this process as automatic as possible, it would be helpful if a PO
is created automatically when work order (WO) is released and that WO is
closed once that PO was received.
Is this possible?

Wolfgang




On Wed, May 23, 2018 at 9:37 PM, Pierre Smits 
wrote:

> Are we addressing here the supply chain involving an OEM (see [1]) where
> one manucaturer produces parts (or even the entire product) for a
> 'manufacturer'  that incorporates it into its product (think Foxconn
> producing for Apple)?
>
> Or are we addressing the issue of having people participating in the
> manufacturing process?
>
> If it is the latter case, then this becomes like a 'hiring a temp' business
> case handled between HRM and the Purchasing Department (establishing
> service agreements) to raise the correct 'service' P.O.
>
> If it is the first case (supply chain) then it is way more complex.
>
> Looking at this from the the viewpoint of the Manufacturing Manager of
> internal company (the party using OFBiz) and the OEM providing parts to the
> production run at the right moment in time (JIT), a task to produce the
> part would - for some -make sense. But if we're talking JIT delivery, then
> it is actually not a production step, but rather the delivery of the part
> to the warehouse just before the ProductionRun (or even a task therein) is
> started. Making it more an issue of setting correct facility and order
> thresholds for the component in the catalog app. When the ProductionRun is
> confirmed (in the Manufacturing component, by the Manufacturing Manager) ,
> the ATP should be checked and if it doesn't meet the ProductionRun
> requirements it should trigger the creation of the P.O.
>
> Entity-wise everything is in place. SECA-wise there might be some gaps.
>
> All in all there is more to this (more details - business analysis-
>  required than outlined outlined in the various postings in this thread.
>
>
> [1] https://en.wikipedia.org/wiki/Original_equipment_manufacturer
>
> Best regards,
>
> Pierre Smits
>
> Apache Trafodion , Vice President
> Apache Directory , PMC Member
> Apache Incubator , committer
> Apache OFBiz , contributor since 2008
> Apache Steve , committer
>
> On Wed, May 23, 2018 at 2:40 PM, wp.rauchh...@gmail.com <
> wp.rauchh...@gmail.com> wrote:
>
> >
> > Following up on you discussion of sub-contracting. I am testing too.
> > I defined the BOM and routing task with type Subcontracting. This routing
> > task was assigned a routing and all components that go to the
> subcontractor
> > were added using 'EDIT ROUTING PRODUCT LINK'.
> > When releasing a work order, the system does not seem to create a PO
> > automatically.
> > This PO should have the components attached and move the material from
> > their inventory to the sub-contractor facility. By receiving the PO back,
> > the task in work order should close too.
> > Am I missing something or does this functionality not exist?
> >
> > How do I do a BOM / routing cost roll-up over the standard BOM/routing to
> > set the standard cost?
> >
> > Thanks, Wolfgang
> >
> >
> >
>



-- 

Wolfgang Rauchholz

ofbiz contributor

[Wolfgang Paul Rauchholz]

Hello,

My name is Wolfgang and I have signed the ICLA
My confluence username is wp.rauchholz and email wp.rauchh...@gmail.com
Please register me as a contributor.

A bit about me. I am more a 'operations guy' rather than a 'technical guy'.
Professionally I started my career implementing MRP-II applications, before
moving into true operational jobs.
My main background here is the entire planning cycle down to execution,
logistics/distribution and international trade, including trade compliance.

I have currently no project in mind and are open for suggestions. Just
contact me.
I started testing ofbiz in my 'leisure' time and have still a long way to
go to understand the system.
I am based in Barcelona/Spain.


Regards, Wolfgang
www.linkedin.com/in/wolfgangrauchholz

Re: Problems setting up eCommerce

[Wolfgang Paul Rauchholz]

Thank you for pointing me to this.
I do have another questions; I would like to reset the database I used for
testing and start with an db for production. How do I do this best?

Wolfgang

On Mon, May 14, 2018 at 3:40 PM, Rishi Solanki 
wrote:

> Please check if your catalog have one PCCT_SEARCH category and then all the
> products your want to be in front store search should be member of that
> category.
> Other related catalog categories PCCT_VIEW_ALLW and PCCT_PURCH_ALLW.
>
> HTH!
>
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: +91-9893287847
> http://www.hotwaxsystems.com
> www.hotwax.co
>
> On Sun, May 13, 2018 at 11:10 PM, wp.rauchh...@gmail.com <
> wp.rauchh...@gmail.com> wrote:
>
> > Problem statement: Not able to see sub-categories and their products
> > together on the on the eCommerce page.
> >
> > Configuration:
> > Catalog > Browse Root Catalog   > Sub-category 1 > Products
> >  > Sub-category 2 >
> > Products
> >
> > I added the Browse Root Category to the Catalog (Browse Root One)
> > I linked both Subcategories to Browse Root Category as “Primary Parent
> > Category” and created products in each of these Sub-Categories
> >
> >
> > Results:
> > (1) When I am in Browse Root Catalog and hit the “CATEGORY PAGE”, ofbiz
> > opens an empty (no sub-categories, no products) eCommerce screen with the
> > following message: There are no products in this category
> > (2) When I am in the Sub-category 1 and hit the button “CATEGORY PAGE”,
> it
> > opens the eCommerce page of this sub-category and its products.
> > When hitting the button “Main” the group and the products disappear. No
> > link to the sub-category is available o go back.
> > Same happens when I am in Sub-category 1.
> >
> > What am I doing wrong?
> >
> >
> > Wolfgang
> >
>



-- 

Wolfgang Rauchholz

Re: Fwd: MODERATE for user@ofbiz.apache.org

[Wolfgang Paul Rauchholz]

Please disregard my former email. It went through ok.
I was missing a quote sign in the statement and I had tot take -3 off.

Correct statement looks like this:
runtime 'mysql:mysql-connector-java:5.1.25'


Thank you, Wolfgang


On Wed, May 9, 2018 at 12:04 PM, Wolfgang Paul Rauchholz <
wp.rauchh...@gmail.com> wrote:

> Thanks for helping...
> I added the above line into the runtime section of the dependencies
> I got an error message:
>
> * What went wrong:
> Could not compile build file '/usr/local/ofbiz/build.gradle'.
> > startup failed:
>   build file '/usr/local/ofbiz/build.gradle': 138: expecting '}', found
> ':' @ line 138, column 39.
>  runtime mysql:mysql-connector-java:5.1.25-3
>^
>
>
> On Wed, May 9, 2018 at 10:16 AM, Deepak Dixit <deepak.dixit@hotwaxsystems.
> com> wrote:
>
>> use following code
>>
>> runtime mysql:mysql-connector-java:5.1.25-3
>>
>>
>>
>>
>> Thanks & Regards
>> --
>> Deepak Dixit
>> www.hotwax.co
>>
>> On Wed, May 9, 2018 at 1:36 PM, Wolfgang Paul Rauchholz <
>> wp.rauchh...@gmail.com> wrote:
>>
>> > The on in the main ofbiz directory
>> >
>> > /usr/local/ofbiz/build.gradle
>> >
>> > On Wed, May 9, 2018 at 7:40 AM, Deepak Dixit
>> <deepak.dixit@hotwaxsystems.
>> > com
>> > > wrote:
>> >
>> > > Hi Wolfgang,
>> > >
>> > > Could you please share in which build.gradle you are adding
>> > > pluginLibsRuntime?
>> > >
>> > > if you are using main build.gradle then you need to add following
>> entry:
>> > >
>> > > runtime mysql:mysql-connector-java:5.1.25-3
>> > >
>> > >
>> > > And if you are using plugins component build.gradle file then you
>> need to
>> > > use
>> > >
>> > > pluginLibsRuntime "mysql:mysql-connector-java:5.1.25-3"
>> > >
>> > >
>> > >
>> > >
>> > >
>> > > Thanks & Regards
>> > > --
>> > > Deepak Dixit
>> > > www.hotwax.co
>> > >
>> > > On Wed, May 9, 2018 at 1:07 AM, wp.rauchh...@gmail.com <
>> > > wp.rauchh...@gmail.com> wrote:
>> > >
>> > > > I am trying to install ofbiz in a CENTOS 7 server with mariadb.
>> > > > Ofbiz runs fine with derby database, but I am not getting mariadb up
>> > and
>> > > > running
>> > > > This is what I did so far
>> > > > created databases in mariadb
>> > > > the following connector is installed: mysql-connector-java-5.1.25-3.
>> > > > el7.noarch
>> > > > I added the following line to the build.gradle  file:
>> > > >
>> > > > ...
>> > > > dependencies {
>> > > > // ofbiz compile libs
>> > > >
>> > > > pluginLibsRuntime "mysql:mysql-connector-java:5.1.25-3"
>> > > >
>> > > > compile 'apache-xerces:xercesImpl:2.9.1'
>> > > > compile 'com.google.zxing:core:3.2.1'
>> > > > ..
>> > > >
>> > > >
>> > > > * What went wrong:
>> > > > A problem occurred evaluating root project 'ofbiz'.
>> > > > > Could not find method pluginLibsRuntime() for arguments
>> > > > [mysql:mysql-connector-java:5.1.25-3] on root project 'ofbiz'.
>> > > >
>> > > >
>> > > > What am I doing wrong? Thanks for your help. Wolfgang
>> > > >
>> > > >
>> > > >
>> > > > On 2018/05/08 16:40:15, Deepak Dixit <deepak.di...@hotwaxsystems.co
>> m>
>> > > > wrote:
>> > > > > Hi wp.rauchholz,
>> > > > >
>> > > > > Your email has been moderated, Please subscribe mailing list
>> > > > > http://ofbiz.apache.org/mailing-lists.html
>> > > > >
>> > > > >
>> > > > > Thanks & Regards
>> > > > > --
>> > > > > Deepak Dixit
>> > > > >
>> > > > >
>> > > > > -- Forwarded message --
>> > > > > From: "wp.rauchh...@gmail.com" <wp.rauchh...@gmail.com>
>> > > > > To: <user@ofbiz.apache.org>
>> > > > > Cc:
>> > > > > Bcc:
>> > > > > Date: Tue, 08 May 2018 15:10:52 -
>> > > > > Subject: Connect to mariadb
>> > > > > Good day,
>> > > > >
>> > > > > would you please confirm that the procedure referenced underneath
>> is
>> > > > still
>> > > > > up to date to connect to mariadb? I can't make it happen. Is
>> there a
>> > > > better
>> > > > > procedure out there?
>> > > > >
>> > > > > java -jar ofbiz.jar -install: throws out a message that -install
>> is
>> > > > unknown
>> > > > > option
>> > > > >
>> > > > > https://cwiki.apache.org/confluence/display/OFBIZ/How+
>> > > > > to+migrate+OFBiz+from+Derby+to+MySQL+database
>> > > > >
>> > > > >
>> > > > > Thank you for your help, Wolfgang
>> > > > >
>> > > >
>> > >
>> >
>> >
>> >
>> > --
>> >
>> > Wolfgang Rauchholz
>> >
>>
>
>
>
> --
>
> Wolfgang Rauchholz
>
>
>
>


-- 

Wolfgang Rauchholz

Re: Fwd: MODERATE for user@ofbiz.apache.org

[Wolfgang Paul Rauchholz]

Just as addtl info and to makle sure everything is fine with java.

[root@home ofbiz]# echo $JAVA_HOME
/usr/java/jdk1.8.0_171/
[root@home ofbiz]# java -version
java version "1.8.0_171"
Java(TM) SE Runtime Environment (build 1.8.0_171-b11)
Java HotSpot(TM) 64-Bit Server VM (build 25.171-b11, mixed mode)

On Wed, May 9, 2018 at 10:16 AM, Deepak Dixit <
deepak.di...@hotwaxsystems.com> wrote:

> use following code
>
> runtime mysql:mysql-connector-java:5.1.25-3
>
>
>
>
> Thanks & Regards
> --
> Deepak Dixit
> www.hotwax.co
>
> On Wed, May 9, 2018 at 1:36 PM, Wolfgang Paul Rauchholz <
> wp.rauchh...@gmail.com> wrote:
>
> > The on in the main ofbiz directory
> >
> > /usr/local/ofbiz/build.gradle
> >
> > On Wed, May 9, 2018 at 7:40 AM, Deepak Dixit <deepak.dixit@hotwaxsystems.
> > com
> > > wrote:
> >
> > > Hi Wolfgang,
> > >
> > > Could you please share in which build.gradle you are adding
> > > pluginLibsRuntime?
> > >
> > > if you are using main build.gradle then you need to add following
> entry:
> > >
> > > runtime mysql:mysql-connector-java:5.1.25-3
> > >
> > >
> > > And if you are using plugins component build.gradle file then you need
> to
> > > use
> > >
> > > pluginLibsRuntime "mysql:mysql-connector-java:5.1.25-3"
> > >
> > >
> > >
> > >
> > >
> > > Thanks & Regards
> > > --
> > > Deepak Dixit
> > > www.hotwax.co
> > >
> > > On Wed, May 9, 2018 at 1:07 AM, wp.rauchh...@gmail.com <
> > > wp.rauchh...@gmail.com> wrote:
> > >
> > > > I am trying to install ofbiz in a CENTOS 7 server with mariadb.
> > > > Ofbiz runs fine with derby database, but I am not getting mariadb up
> > and
> > > > running
> > > > This is what I did so far
> > > > created databases in mariadb
> > > > the following connector is installed: mysql-connector-java-5.1.25-3.
> > > > el7.noarch
> > > > I added the following line to the build.gradle  file:
> > > >
> > > > ...
> > > > dependencies {
> > > > // ofbiz compile libs
> > > >
> > > > pluginLibsRuntime "mysql:mysql-connector-java:5.1.25-3"
> > > >
> > > > compile 'apache-xerces:xercesImpl:2.9.1'
> > > > compile 'com.google.zxing:core:3.2.1'
> > > > ..
> > > >
> > > >
> > > > * What went wrong:
> > > > A problem occurred evaluating root project 'ofbiz'.
> > > > > Could not find method pluginLibsRuntime() for arguments
> > > > [mysql:mysql-connector-java:5.1.25-3] on root project 'ofbiz'.
> > > >
> > > >
> > > > What am I doing wrong? Thanks for your help. Wolfgang
> > > >
> > > >
> > > >
> > > > On 2018/05/08 16:40:15, Deepak Dixit <deepak.di...@hotwaxsystems.com
> >
> > > > wrote:
> > > > > Hi wp.rauchholz,
> > > > >
> > > > > Your email has been moderated, Please subscribe mailing list
> > > > > http://ofbiz.apache.org/mailing-lists.html
> > > > >
> > > > >
> > > > > Thanks & Regards
> > > > > --
> > > > > Deepak Dixit
> > > > >
> > > > >
> > > > > -- Forwarded message --
> > > > > From: "wp.rauchh...@gmail.com" <wp.rauchh...@gmail.com>
> > > > > To: <user@ofbiz.apache.org>
> > > > > Cc:
> > > > > Bcc:
> > > > > Date: Tue, 08 May 2018 15:10:52 -
> > > > > Subject: Connect to mariadb
> > > > > Good day,
> > > > >
> > > > > would you please confirm that the procedure referenced underneath
> is
> > > > still
> > > > > up to date to connect to mariadb? I can't make it happen. Is there
> a
> > > > better
> > > > > procedure out there?
> > > > >
> > > > > java -jar ofbiz.jar -install: throws out a message that -install is
> > > > unknown
> > > > > option
> > > > >
> > > > > https://cwiki.apache.org/confluence/display/OFBIZ/How+
> > > > > to+migrate+OFBiz+from+Derby+to+MySQL+database
> > > > >
> > > > >
> > > > > Thank you for your help, Wolfgang
> > > > >
> > > >
> > >
> >
> >
> >
> > --
> >
> > Wolfgang Rauchholz
> >
>



-- 

Wolfgang Rauchholz

Re: Fwd: MODERATE for user@ofbiz.apache.org

[Wolfgang Paul Rauchholz]

Thanks for helping...
I added the above line into the runtime section of the dependencies
I got an error message:

* What went wrong:
Could not compile build file '/usr/local/ofbiz/build.gradle'.
> startup failed:
  build file '/usr/local/ofbiz/build.gradle': 138: expecting '}', found ':'
@ line 138, column 39.
 runtime mysql:mysql-connector-java:5.1.25-3
   ^


On Wed, May 9, 2018 at 10:16 AM, Deepak Dixit <
deepak.di...@hotwaxsystems.com> wrote:

> use following code
>
> runtime mysql:mysql-connector-java:5.1.25-3
>
>
>
>
> Thanks & Regards
> --
> Deepak Dixit
> www.hotwax.co
>
> On Wed, May 9, 2018 at 1:36 PM, Wolfgang Paul Rauchholz <
> wp.rauchh...@gmail.com> wrote:
>
> > The on in the main ofbiz directory
> >
> > /usr/local/ofbiz/build.gradle
> >
> > On Wed, May 9, 2018 at 7:40 AM, Deepak Dixit <deepak.dixit@hotwaxsystems.
> > com
> > > wrote:
> >
> > > Hi Wolfgang,
> > >
> > > Could you please share in which build.gradle you are adding
> > > pluginLibsRuntime?
> > >
> > > if you are using main build.gradle then you need to add following
> entry:
> > >
> > > runtime mysql:mysql-connector-java:5.1.25-3
> > >
> > >
> > > And if you are using plugins component build.gradle file then you need
> to
> > > use
> > >
> > > pluginLibsRuntime "mysql:mysql-connector-java:5.1.25-3"
> > >
> > >
> > >
> > >
> > >
> > > Thanks & Regards
> > > --
> > > Deepak Dixit
> > > www.hotwax.co
> > >
> > > On Wed, May 9, 2018 at 1:07 AM, wp.rauchh...@gmail.com <
> > > wp.rauchh...@gmail.com> wrote:
> > >
> > > > I am trying to install ofbiz in a CENTOS 7 server with mariadb.
> > > > Ofbiz runs fine with derby database, but I am not getting mariadb up
> > and
> > > > running
> > > > This is what I did so far
> > > > created databases in mariadb
> > > > the following connector is installed: mysql-connector-java-5.1.25-3.
> > > > el7.noarch
> > > > I added the following line to the build.gradle  file:
> > > >
> > > > ...
> > > > dependencies {
> > > > // ofbiz compile libs
> > > >
> > > > pluginLibsRuntime "mysql:mysql-connector-java:5.1.25-3"
> > > >
> > > > compile 'apache-xerces:xercesImpl:2.9.1'
> > > > compile 'com.google.zxing:core:3.2.1'
> > > > ..
> > > >
> > > >
> > > > * What went wrong:
> > > > A problem occurred evaluating root project 'ofbiz'.
> > > > > Could not find method pluginLibsRuntime() for arguments
> > > > [mysql:mysql-connector-java:5.1.25-3] on root project 'ofbiz'.
> > > >
> > > >
> > > > What am I doing wrong? Thanks for your help. Wolfgang
> > > >
> > > >
> > > >
> > > > On 2018/05/08 16:40:15, Deepak Dixit <deepak.di...@hotwaxsystems.com
> >
> > > > wrote:
> > > > > Hi wp.rauchholz,
> > > > >
> > > > > Your email has been moderated, Please subscribe mailing list
> > > > > http://ofbiz.apache.org/mailing-lists.html
> > > > >
> > > > >
> > > > > Thanks & Regards
> > > > > --
> > > > > Deepak Dixit
> > > > >
> > > > >
> > > > > -- Forwarded message --
> > > > > From: "wp.rauchh...@gmail.com" <wp.rauchh...@gmail.com>
> > > > > To: <user@ofbiz.apache.org>
> > > > > Cc:
> > > > > Bcc:
> > > > > Date: Tue, 08 May 2018 15:10:52 -
> > > > > Subject: Connect to mariadb
> > > > > Good day,
> > > > >
> > > > > would you please confirm that the procedure referenced underneath
> is
> > > > still
> > > > > up to date to connect to mariadb? I can't make it happen. Is there
> a
> > > > better
> > > > > procedure out there?
> > > > >
> > > > > java -jar ofbiz.jar -install: throws out a message that -install is
> > > > unknown
> > > > > option
> > > > >
> > > > > https://cwiki.apache.org/confluence/display/OFBIZ/How+
> > > > > to+migrate+OFBiz+from+Derby+to+MySQL+database
> > > > >
> > > > >
> > > > > Thank you for your help, Wolfgang
> > > > >
> > > >
> > >
> >
> >
> >
> > --
> >
> > Wolfgang Rauchholz
> >
>



-- 

Wolfgang Rauchholz

Re: Fwd: MODERATE for user@ofbiz.apache.org

[Wolfgang Paul Rauchholz]

The on in the main ofbiz directory

/usr/local/ofbiz/build.gradle

On Wed, May 9, 2018 at 7:40 AM, Deepak Dixit  wrote:

> Hi Wolfgang,
>
> Could you please share in which build.gradle you are adding
> pluginLibsRuntime?
>
> if you are using main build.gradle then you need to add following entry:
>
> runtime mysql:mysql-connector-java:5.1.25-3
>
>
> And if you are using plugins component build.gradle file then you need to
> use
>
> pluginLibsRuntime "mysql:mysql-connector-java:5.1.25-3"
>
>
>
>
>
> Thanks & Regards
> --
> Deepak Dixit
> www.hotwax.co
>
> On Wed, May 9, 2018 at 1:07 AM, wp.rauchh...@gmail.com <
> wp.rauchh...@gmail.com> wrote:
>
> > I am trying to install ofbiz in a CENTOS 7 server with mariadb.
> > Ofbiz runs fine with derby database, but I am not getting mariadb up and
> > running
> > This is what I did so far
> > created databases in mariadb
> > the following connector is installed: mysql-connector-java-5.1.25-3.
> > el7.noarch
> > I added the following line to the build.gradle  file:
> >
> > ...
> > dependencies {
> > // ofbiz compile libs
> >
> > pluginLibsRuntime "mysql:mysql-connector-java:5.1.25-3"
> >
> > compile 'apache-xerces:xercesImpl:2.9.1'
> > compile 'com.google.zxing:core:3.2.1'
> > ..
> >
> >
> > * What went wrong:
> > A problem occurred evaluating root project 'ofbiz'.
> > > Could not find method pluginLibsRuntime() for arguments
> > [mysql:mysql-connector-java:5.1.25-3] on root project 'ofbiz'.
> >
> >
> > What am I doing wrong? Thanks for your help. Wolfgang
> >
> >
> >
> > On 2018/05/08 16:40:15, Deepak Dixit 
> > wrote:
> > > Hi wp.rauchholz,
> > >
> > > Your email has been moderated, Please subscribe mailing list
> > > http://ofbiz.apache.org/mailing-lists.html
> > >
> > >
> > > Thanks & Regards
> > > --
> > > Deepak Dixit
> > >
> > >
> > > -- Forwarded message --
> > > From: "wp.rauchh...@gmail.com" 
> > > To: 
> > > Cc:
> > > Bcc:
> > > Date: Tue, 08 May 2018 15:10:52 -
> > > Subject: Connect to mariadb
> > > Good day,
> > >
> > > would you please confirm that the procedure referenced underneath is
> > still
> > > up to date to connect to mariadb? I can't make it happen. Is there a
> > better
> > > procedure out there?
> > >
> > > java -jar ofbiz.jar -install: throws out a message that -install is
> > unknown
> > > option
> > >
> > > https://cwiki.apache.org/confluence/display/OFBIZ/How+
> > > to+migrate+OFBiz+from+Derby+to+MySQL+database
> > >
> > >
> > > Thank you for your help, Wolfgang
> > >
> >
>



-- 

Wolfgang Rauchholz