Dear Jinghai, No, we are not using PDM system associated with OFBiz yet, though I would like to try it as well later. So I could not answer to the question. Certainly I would have to get back to you for your help later.
Thanks and have a nice day! B.R. Schumann -----邮件原件----- 发件人: Shi Jinghai <huaru...@hotmail.com> 发送时间: 2018年3月30日 11:11 收件人: user@ofbiz.apache.org 主题: Re: A major bug in OFBiz Manufacturing MRP function Sorry for my question is not clear enough. It's an off-topic investigation. I want to add a new function of exploded view in OFBiz, three.js as the display engine. I want to know if you are using PDM tool/system, what formats it can export as exploded view, whether value of torque exported in the view. -----邮件原件----- 发件人: Schumann Ye [mailto:schumanny...@hotmail.com] 发送时间: 2018年3月30日 9:40 收件人: user@ofbiz.apache.org 主题: 答复: A major bug in OFBiz Manufacturing MRP function Dear Jinghai, I assume you're referring what Type that I use for BOM simulation (Route: Manufacturing - Bill Of Materials - Bom Simulation). If that is the case, yes. Actually it makes no difference for my case by using the type "Explosion" or "Explosion (only for products needing manufacturing)" because the my test Bom Type is "Manufacturing Bill of Materials". Back to your question again, I don't understand what you mean by "format of the exploded view". It's the response ftl from server, located in "manufacturing/template/bom/BomSimulation.ftl". So I would reply the format in html table looks ok and could be adapted as we want! However, if you asked what would be the MRP logic related to explosion type, as per my observations on MrpServices, it seems they are not related. HIH. B.R. Schumann -----邮件原件----- 发件人: Shi Jinghai <huaru...@hotmail.com> 发送时间: 2018年3月30日 9:21 收件人: user@ofbiz.apache.org 主题: Re: A major bug in OFBiz Manufacturing MRP function As I know, Oracle sells MySQL service to enterprises very well in China, the OFBiz-10321 may be a common problem for prove of concept test, I'd suggest don't close it until we resolve it. @Schumann: A question: do you use exploded view in your assembly? If yes, what's the format of the exploded view? Kind Regards, Shi Jinghai -----邮件原件----- 发件人: Schumann Ye [mailto:schumanny...@hotmail.com] 发送时间: 2018年3月30日 8:50 收件人: user@ofbiz.apache.org 主题: 答复: A major bug in OFBiz Manufacturing MRP function Dear Rajesh and Paul, Thanks for your comments. Will have a check on Postgres later. B.R. Schumann -----邮件原件----- 发件人: Paul Mandeltort <p...@marcospec.com> 发送时间: 2018年3月30日 3:02 收件人: user@ofbiz.apache.org 主题: Re: A major bug in OFBiz Manufacturing MRP function Postgres is pretty much standard now, especially now that Amazon AWS has support for it on Aurora. —P > On Mar 29, 2018, at 14:51, Rajesh Mallah <mallah.raj...@gmail.com> wrote: > > Hi Schmann , > > You may consider exploring PostgreSQL. > > regds > mallah. > > On Thu, Mar 29, 2018 at 8:58 PM, Schumann Ye > <schumanny...@hotmail.com> > wrote: > >> Hi Rajesh, >> >> According to the official website documents, it looks like that, >> which is bad for the programmers and the end users. >> What is your suggestion for a production environment, mysql or mssql >> or others? >> I am afraid of future potential similar traps. >> >> B.R. >> Schumann >> >> -----邮件原件----- >> 发件人: Rajesh Mallah <mallah.raj...@gmail.com> >> 发送时间: 2018年3月29日 23:24 >> 收件人: user@ofbiz.apache.org >> 主题: Re: 答复: A major bug in OFBiz Manufacturing MRP function >> >>> However, when MySQL stores a value into a column of any temporal >>> data type, it discards any fractional part and does not store >>> it.Kind regards, >>> >> >> I thought MySQL had by now gotten over from the childhood disease of >> discarding data silently ;-) in many contexts it was like that even >> 10 year back. >> >> regds >> mallah. >>
