Re: Build dependencies on OfBiz code for new plugin

[Michael Brohl]

Hi Carsten,

hard to say without seeing what's in your plugin.

Integration of plugins is straightforward. You can even make a symlink 
to an external plugin repo and it normally works.


It sounds like everything is setup ok, the plugin code can be found. 
Does compilation work if you don't have the plugin code under /plugins?


Everything else under /plugins except you plugin folder (the plugin 
needs a separate folder, e.g. /plugins/my-plugin/)?


Maybe you can post the relevant part of the console.log to see more.

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 14.08.23 um 18:29 schrieb Carsten Schinzer:

Hello all,


While I feel this must be a very very basic question, I obviously do not find 
the right search statement to spot any solution on the web. Hum. So apologies 
for the spam if this is for you ,-)
I shall be happy to take any pointer to further reading or to example code for 
this in order to do 'homework' offline.

Context and objective:
I do try to build a standalone component for inclusion as a plugin into the 
OfBiz framework. I initialized the component using the framework’s Gradle task, 
then copied only the contents of the plugin folder over into a dedicated 
repository as my idea is to keep the code repo slim while then doing the 
component integration in a CICD pipeline that will finally produce a docker 
image that includes the component.

Integration steps in the pipeline:
My attempt to build (and then test) the component is the following:
- download the ofbiz framework from repository by cloning release22.01 from git
- create the plugin directory and copy my component code into it
- switch to ofbiz-framework folder and execute ./gradlew build

The issue:
When attempting to build, everything goes smoothly down to
Task :plugins:cdc-tickets:compileJava

where obviously the ofbiz packages are not found. Error message when compiling 
my classes in the component is this:
error: package org.apache.ofbiz.base.util does not exist

My question is:
- am I missing something in the build.gradle? A dependency statement maybe?

I tried with a dependency on the main project (as classpath project (':ofbiz‘), 
but that did not work out.
I checked most of the build.gradle configs in other plugins, but none mentions 
the dependency on ofbiz explicitly it appears; maybe I misread?
Is my approach even correct? It is based on Dan Watford's docker image project 
for OfBiz, so maybe not suited well for the component integration.
I also found nothing explicit in the OfBiz developer handbook or confluence 
space either.

So if you can point me: Many many thanks in advance!

If you want to throw an eye on the code, let me please know you gitlab user id, 
so I can grant you read access.

Warm regards


Carsten

Re: Daemon

[Michael Brohl]

Hi Craig,

you'll find those scripts in the ofbiz-tools repository: 
https://github.com/apache/ofbiz-tools


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 15.08.23 um 18:34 schrieb Craig Parker:
I'm trying to get back into docs, and currently finally have a working 
OFBiz/MySQL install. But the way I documented getting it running as a 
daemon (and starting via systemctl at boot) involved a 
/$ofbizRoot/tools/rc.ofbiz.for.debian file, and there's not even a 
tools directory.


Did I miss something, or there's just a different way now?

Re: Mass email of Statements: no session or request for parseReportOptions.bsh

[Michael Brohl]

Hi,

you installation must be quite old, beanshell (.bsh) scripts are removed 
from OFBiz in around 2016.


From memory you are right that session and request are in place in 
beanshell scripts as they are in the newer groovy scripts - but only if 
you are in a request/response context. This is not the case if you are 
running a scheduled service!


So, guessing blindly without seeing your code, you should check if you 
have the right solution design and if the bsh script is usable in your 
situation.


hth,

best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 04.05.23 um 22:40 schrieb Griffin:

Greetings and salutations,

  


Let me start by saying I inherited a very old installation of ofbiz/opentaps
that cannot be updated because of other infrastructure limitations, so my
problem might relate to something that was fixed a decade or more ago.

  


I am attempting to automate the emailing of statements to all customers with
an outstanding balance. My intention is to write a service and schedule it
to run on the first of each month.

  


Currently, if I navigate to the Collections Summary in Receivables and
select a customer from the list, I can then click a button to generate a PDF
statement. I can then attach this statement to an email and send it.
However, when I write a service to generate this PDF as an attachment to an
email, I consistently run into an issue where parseReportOptions.bsh cannot
find a "request" or a "session".  It is my understanding that these are
supposed to always be in context, however, I consistently get 'void' (not to
be confused with null) for these two items.

  


I am at a loss as to why, and what I can do to fix it.

  


Can anyone make any suggestions?

Re: Class and Methods to find job ID and job Name in a service

[Michael Brohl]

As an addition a few remarks:

OFBiz already has services ready to use for asynchronous mail delivery 
(see services_email.xml in framework/common/servicedef).


The example code for SendEmailService does not represent a valid service 
method signature. It seems to be an event method which is not the same 
thing. Events cannot be scheduled as a job, whereas services can.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 18.04.23 um 14:42 schrieb Aditya Sharma:

Hello Mahi,

Though I could not understand your use case completely, I suspect you are
looking for RuntimeData. Instead of identifying the job and deciding, you
should prepare distinct runtime data for different jobs. RuntimeData will
be passed to the service during job execution, based upon which you could
decide further actions.

Refer to this job data:
https://github.com/apache/ofbiz-framework/blob/49bcc245007b685ff3dc423b143acf9ae22b4a5b/applications/manufacturing/data/ManufacturingScheduledServices.xml#L39


PS. Attachments are filtered out on lists, so you could store the image on
platforms like google drive, dropbox, etc, and share the link here.

HTH

Thanks and Regards,
Aditya Sharma

On Tue, Apr 18, 2023 at 3:53 PM Mahi maheshwari 
wrote:


Hello Community,

Is there a way to find and access the job Id and job name inside a Java
service?
I have a service "SendEmailService" written in Java for mail notification,
for this, I have created the job in jobSandBox.
whenever the "SendEmailService" service is called by the scheduler then
inside this service, I want to know the job name associated with that
service for the calling service.
I'm attaching the image below, please take a look at the attachment for
reference.

*for example: *
SendEmailService(HttpServletRequest request, HttpServletResponse response){
  code to get a job id and job name
}

Regards,
Maheshwari.

Re: How to create entities in the database using java events just as like we do in JDBC

[Michael Brohl]

Hi Mahi,

Apache OFBiz relies on a database agnostic layer which is called the 
Entity Engine.


For OFBiz, tables and views only exist if they are defined in the entity 
model, so it is useless to create them through direct JDBC/SQL 
statements if you want to use them within OFBiz.


If you can give us the reasoning behind your attempt we might be able to 
help find a solution. Please be aware that OFBiz has a mechanism to 
automatically create tables, views, references and indexes from the 
entity definitions.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 22.03.23 um 13:57 schrieb Mahi maheshwari:

Hello Community,

I need help in creating entities through java events but not using
entitymodel.xml file.
like we do in java for creating entities, example was given below for
reference.
EXAMPLE:
try(Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);
Statement stmt = conn.createStatement();
) {
String sql = "CREATE TABLE REGISTRATION " +
"(id INTEGER not NULL, " +
" first VARCHAR(255), " +
" last VARCHAR(255), " +
" age INTEGER, " +
" PRIMARY KEY ( id ))";
  stmt.executeUpdate(sql);
}catch(SQLException  e){
e.printStackTrace();
}

how can I achieve this in ofbiz using java events?

Thank you,
maheshwari.

1.

Re: Async Services

[Michael Brohl]

Hi Ingo,

with a dispatcher of null, I wonder how it should be possible to run a 
service (synx or async)?


If it is a groovy script in the context of a screen, you should have 
dispatcher and delegator available. Else you should provide more 
information of the process/code.


I am not aware of any additional data you have to provide. The service 
engine just takes the provided service context and stores it as 
RuntimeData together with the job in the JobSandbox instead of running 
the service directly.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de

Am 07.03.23 um 09:16 schrieb Ingo Wolfmayr:

Hi Michael,

thanks for the fast response. I have one more question:

I created a services that is fired inside a groovy script - async. When I define persist 
= "true" the dispatcher is null / delegator not defined. I use tenants.

Sync works.
Async with persist = false works
Async with persist = true fails

Did I miss something? Should I pass some specific data to the service when 
using persist = true?

Best regards,
Ingo

-Ursprüngliche Nachricht-
Von: Michael Brohl 
Gesendet: Dienstag, 7. März 2023 08:57
An: user@ofbiz.apache.org
Betreff: Re: Async Services

Hi Ingo,

with persist = true, the async service will be persisted in the Job Sandbox and 
executed, els it will only be executed.

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 07.03.23 um 08:24 schrieb Ingo Wolfmayr:

Hi Michael,

sorry "persist".

Best regards,
Ingo

-Ursprüngliche Nachricht-
Von: Michael Brohl 
Gesendet: Dienstag, 7. März 2023 08:21
An: user@ofbiz.apache.org
Betreff: Re: Async Services

Hi Ingo,

where did you find this option and for which version?

Best regards,

Michael

Am 07.03.23 um 08:04 schrieb Ingo Wolfmayr:

Hi Community,

I would like to know what is the difference between an async service with option set "permit = 
true" or "permit = false".

Best regards,
Ingo

Re: Async Services

[Michael Brohl]

Hi Ingo,

with persist = true, the async service will be persisted in the Job 
Sandbox and executed, els it will only be executed.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 07.03.23 um 08:24 schrieb Ingo Wolfmayr:

Hi Michael,

sorry "persist".

Best regards,
Ingo

-Ursprüngliche Nachricht-
Von: Michael Brohl 
Gesendet: Dienstag, 7. März 2023 08:21
An: user@ofbiz.apache.org
Betreff: Re: Async Services

Hi Ingo,

where did you find this option and for which version?

Best regards,

Michael

Am 07.03.23 um 08:04 schrieb Ingo Wolfmayr:

Hi Community,

I would like to know what is the difference between an async service with option set "permit = 
true" or "permit = false".

Best regards,
Ingo

Re: Async Services

[Michael Brohl]

Hi Ingo,

where did you find this option and for which version?

Best regards,

Michael

Am 07.03.23 um 08:04 schrieb Ingo Wolfmayr:

Hi Community,

I would like to know what is the difference between an async service with option set "permit = 
true" or "permit = false".

Best regards,
Ingo

Re: OFbiz/Tomcat vs Ofbiz/Tomcat/Apache to serve static resources

[Michael Brohl]

Hi Giulio,

I guess that you will be using an Apache Webserver before OFBiz' Tomcat 
anyway, right?


There will always be an overhead if you serve ressources through the 
route client - Apache Webserver - Apache Tomcat - client because of the 
proxy handling between Webserver and Tomcat.


How significant this is for your scenario can best be checked through 
load testing like Taher suggested.


It costs nothing an is easy to setup to serve static content directly 
through the Webserver so we do this in all our production systems.


The above does not apply if Tomcat will be used standalone without any 
Webserver in front of it.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 24.01.23 um 10:38 schrieb Giulio Speri - MpStyle Srl:

Hello everyone,

I hope I found you all well!

I would like to ask you an opinion regarding serving static resources of a
website powered by OFBiz.

We are going to perform a system upgrade (from Ofbiz 13.07.03 to latest)
and we are evaluating who should serve the static resource: now they are
served by Apache Web Served who acts like a proxy in front of OFBiz
application.

Since Tomcat webserver has been upgraded and improved over the years
(version 13.07 is shipped with Tomcat 7) could it be worthy to make it
serve the static resources or having an Apache Web Server in front is still
a better (for performances) solution?

The website involved is an e-commerce site, so there are periods of quite
high traffic load.

What do you think about it?

Thank you all in advance and have a great day ahead,

Giulio

Re: Prevent promo discount when there is already a per order disount

[Michael Brohl]

Thanks Giulio,

that confirms the results of our analysis.

We will now implement a relatively easy solution by extending the 
PromoCode entity with a new flag which says that it can only be used 
exclusively per order.


The validation when entering a promo code will be enhanced to check

- if either an exlusive code is entered while others are already applied

- or if there is already an exlusive promo code applied when entering a 
promo code.


In either case, a message will be rendered to the user interface.

This will be sufficient for our use case. Once this is field tested, we 
will contribute this back to the project.


I also like the approach using promo relations, that would offer more 
flexibility. Looking forward to this.


Thanks and best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 17.11.22 um 10:15 schrieb Giulio Speri - MpStyle Srl:

Good morning Michael,

as per our experience using OFBiz e-commerce with promotions and promo
rules I can tell that there is no direct way to reach that "mutual
exclusion" for promotions.
Indeed the ProductPromos available on the store are processed one after
another, evaluating each by itself; so if you have 3 promotions and all
three have valid conditions, then they will be all applied to the order.

We were starting to think of a possible solution to this, since many of our
customers asked for this kind of exclusion for promotions (in particular
for promocodes).

I think that to reach this goal we need an entity where we can store this
relation between promos, something like:
PROMOTION_FROM:PROMOTION_TO:PROMO_COMPATIBLE[Y/N]
(:FROM_DATE:THRU_DATE:SEQ_NUM,...whatever fields useful for relation
handling)

Obviously the potential bad side of this is that if this entity grows a
lot, the system could spend a lot of time in this evaluation process.

If I am not wrong Magento should handle the promo exclusion in a similar
way.

This could be an interesting new feature for OFBiz e-commerce plugin.

Giulio

Il giorno gio 17 nov 2022 alle ore 05:38 Ashish Vijaywargiya <
ashish.vijaywarg...@hotwaxsystems.com> ha scritto:


Hello Michael,

I hope you are doing well.

Please refer to the following document written by Jacopo:

https://www.hotwaxsystems.com/ofbiz/ofbiz-development/product-promotion-engine/

I am not saying that this document will solve your use case but will help
you think on this side as well.
After this you can try creating some promotions at your end and see if it
suffices your need.

Please explore "Use Limit Per Order" and "Use Limit Per Customer" fields as
well:

https://demo-next.ofbiz.apache.org/catalog/control/EditProductPromo?productPromoId=9012

And the same fields with respect to PromoCode as well:

https://demo-next.ofbiz.apache.org/catalog/control/FindProductPromoCode?productPromoId=9012


--
Kind Regards,
Ashish Vijaywargiya
Vice President of Operations
*HotWax Systems*
*Enterprise open source experts*
http://www.hotwaxsystems.com



On Wed, Nov 16, 2022 at 9:13 PM Michael Brohl 
wrote:


Hi everyone,

is there an out-of-the-box solution for the following promotion scenario:

Prevent a per product or product category promotion if there is already
a per order promotion active.

So if there is already an order percent or flat amount discount, any
other (additional) promotions should be discarded and the user should be
informed that those promotions cannot be combined.

Any hints?

Thanks and regards,

Michael

Prevent promo discount when there is already a per order disount

[Michael Brohl]

Hi everyone,

is there an out-of-the-box solution for the following promotion scenario:

Prevent a per product or product category promotion if there is already 
a per order promotion active.


So if there is already an order percent or flat amount discount, any 
other (additional) promotions should be discarded and the user should be 
informed that those promotions cannot be combined.


Any hints?

Thanks and regards,

Michael

Re: Which Tomcat version ofbiz internally using

[Michael Brohl]

Hi Pranab,

you will most likely have to adjust the configuration of the 
catalina-containerif if you change the major version.


You will find those changes if you search for "tomcat" in the git logs 
or Jira issues.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de



Am 30.07.22 um 12:31 schrieb Pranab Sahoo:

Hi Ayan,

Thanks for the quick reply.

I replaced
   //compile 'org.apache.tomcat:tomcat-catalina-ha:8.5.40'
 //compile 'org.apache.tomcat:tomcat-catalina:8.5.40'
 //compile 'org.apache.tomcat:tomcat-jasper:8.5.40'
 //compile 'org.apache.tomcat:tomcat-tribes:8.5.40'
With
 compile 'org.apache.tomcat:tomcat-catalina-ha:9.0.54'
 compile 'org.apache.tomcat:tomcat-catalina:9.0.54'
 compile 'org.apache.tomcat:tomcat-jasper:9.0.54'
 compile 'org.apache.tomcat:tomcat-tribes:9.0.54'

Can I assume, my embedded tomcat get upgraded. Or there any other dependency 
too I need to upgrade.
Thanks in advance.

Thanks
Pranab

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows

From: Ayan Farooqui<mailto:ayanfarooqui...@gmail.com>
Sent: 29 July 2022 12:34
To: user@ofbiz.apache.org<mailto:user@ofbiz.apache.org>
Subject: Re: Which Tomcat version ofbiz internally using

CAUTION: External Email Sender. Click links or open attachments only from the 
recognized sender.


Hello Pranab,

If you open the build.gradle file inside your OFBiz directory you'll find
all the implemented dependencies, There you can search for Tomcat, the
version number in your setup will be mentioned here.
To upgrade the version you just need to change the version number in
build.gradle file. For more information you can refer to this thread -
https://cwiki.apache.org/confluence/display/OFBIZ/How+to+upgrade+the+embedded+Tomcat

Hope this helps.

Kind Regards,
Ayan Farooqui



On Fri, Jul 29, 2022 at 11:59 AM Pranab Sahoo 
wrote:


Hi Community,

Having very basic question ,
where I will find which version of Tomcat, ofbiz internally using?
Can I upgrade tomcat version.
We using ofbiz version 16.11.07 with some modification.

Thanks
Pranab

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows


Disclaimer: (c) 2022 Truminds Software Systems. This e-mail contains
PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the
addressee(s). If you are not the intended recipient, please notify the
sender by e-mail and delete the original message. Further, you are not to
copy, disclose, or distribute this e-mail or its contents to any other
person and any such actions are unlawful.




Disclaimer: (c) 2022 Truminds Software Systems. This e-mail contains PRIVILEGED 
AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). 
If you are not the intended recipient, please notify the sender by e-mail and 
delete the original message. Further, you are not to copy, disclose, or 
distribute this e-mail or its contents to any other person and any such actions 
are unlawful.

Re: REST API - Access token and refresh token for login

[Michael Brohl]

Hi Rishi,

the client should recognize that the token is not valid or that the 
token based authentication failed and do a refresh of the token by 
re-authenticating again.


Best regards,

Michael Brohl


ecomify GmbH - www.ecomify.de

Am 21.06.22 um 11:26 schrieb Rishi Agr:

Hi,
Whenever I login to the application using the rest api token, the user logs
out after specific time (1800 seconds). This is because the Access token
expires and the user needs to login once again to continue the activities.
Do we have the feature of refresh token in here to make sure the user is
not interrupted after login? Or a workaround to tackle this issue?
Thanks.

Re: Default Transaction Timeout

[Michael Brohl]

Hi Johan,

the default transaction timeout is typically 60 seconds. You can change 
this for specific (service) transactions by using the service attribute 
"transaction-timeout".


See /framework/service/dtd/services.xsd.

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 07.06.22 um 18:53 schrieb Johan Cronje:

Good day,

Where in the release18.12 would I be able to find the default
transaction timeout?
Is there a property file where I can configure this setting?

Kind Regards,
Johan Cronjé

Re: Call Center Software w/ Ofbiz

[Michael Brohl]

Hi James,

no personal experience but there is some documentation about OFBiz / 
Asterisk integration in [1] and [2].


[1] 
https://cwiki.apache.org/confluence/display/OFBIZ/Asterisk+PBX+Server+Integration


[2] 
https://events.static.linuxfound.org/sites/events/files/slides/ApacheCon-Core-EU_2015_Ofbiz-CRM-asterisk-.pdf


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 19.05.22 um 20:20 schrieb ja...@productive1.com:

Anyone have any experience with open source call center software
integrated or built within Ofbiz. Software like Osdial or comparable.
The requirement would be the ability to power dial or auto dial.  All
asterisk base

Thanks,

James

Re: Error building Ofbiz on Windows 10

[Michael Brohl]

Hi Emad,

please have a look at the last output, it states

"BUILD SUCCESSFUL in 8s
15 actionable tasks: 10 executed, 5 up-to-date"

The deprecation warnings are just warnings, stating that the build 
currently uses configurations which are deprecated and which will result 
in an error if Gradle 7.0 is used (which is not the case right now).


You can safely ignore these warnings.

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 04.05.22 um 17:01 schrieb Emad Radwan:

Hi Michael,

Unfortunately, I’m not a java developer!

I re-run with - stacktrace parameter - and got the following. Appreciate if you 
can extract something useful from it.

Regards,
Emad

C:\apache-ofbiz-18>gradle cleanall --warning-mode all --stacktrace


Configure project :

The compile configuration has been deprecated for dependency declaration. This 
will fail with an error in Gradle 7.0. Please use the implementation 
configuration instead. Consult the upgrading guide for further information: 
https://docs.gradle.org/6.5/userguide/upgrading_version_5.html#dependencies_should_no_longer_be_declared_using_the_compile_and_runtime_configurations
 at 
org.gradle.api.internal.artifacts.DefaultDependencySet.warnIfConfigurationIsDeprecated(DefaultDependencySet.java:77)
 at 
org.gradle.api.internal.artifacts.DefaultDependencySet.add(DefaultDependencySet.java:64)
 at 
org.gradle.api.internal.artifacts.DefaultDependencySet.add(DefaultDependencySet.java:36)
 at 
org.gradle.api.internal.artifacts.dsl.dependencies.DefaultDependencyHandler.doAddRegularDependency(DefaultDependencyHandler.java:137)
 at 
org.gradle.api.internal.artifacts.dsl.dependencies.DefaultDependencyHandler.doAdd(DefaultDependencyHandler.java:131)
 at 
org.gradle.api.internal.artifacts.dsl.dependencies.DefaultDependencyHandler.access$100(DefaultDependencyHandler.java:57)
 at 
org.gradle.api.internal.artifacts.dsl.dependencies.DefaultDependencyHandler$DirectDependencyAdder.add(DefaultDependencyHandler.java:337)
 at 
org.gradle.api.internal.artifacts.dsl.dependencies.DefaultDependencyHandler$DirectDependencyAdder.add(DefaultDependencyHandler.java:332)
 at 
org.gradle.api.internal.artifacts.dsl.dependencies.DynamicAddDependencyMethods.tryInvokeMethod(DynamicAddDependencyMethods.java:56)
 at 
org.gradle.internal.extensibility.MixInClosurePropertiesAsMethodsDynamicObject.tryInvokeMethod(MixInClosurePropertiesAsMethodsDynamicObject.java:34)
 at 
build_dlw0bl0qqhtvus3p2ggjy8z4s$_run_closure7.doCall(C:\apache-ofbiz-18\build.gradle:167)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:323)
 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1041)
 at groovy.lang.Closure.call(Closure.java:405)
 at groovy.lang.Closure.call(Closure.java:421)
 at 
org.gradle.util.ClosureBackedAction.execute(ClosureBackedAction.java:71)
 at 
org.gradle.util.ConfigureUtil.configureTarget(ConfigureUtil.java:154)
 at org.gradle.util.ConfigureUtil.configure(ConfigureUtil.java:105)
 at 
org.gradle.api.internal.project.DefaultProject.dependencies(DefaultProject.java:1230)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:323)
 at 
org.gradle.internal.extensibility.MixInClosurePropertiesAsMethodsDynamicObject.tryInvokeMethod(MixInClosurePropertiesAsMethodsDynamicObject.java:34)
 at 
org.gradle.groovy.scripts.BasicScript$ScriptDynamicObject.tryInvokeMethod(BasicScript.java:134)
 at 
org.gradle.groovy.scripts.BasicScript.invokeMethod(BasicScript.java:83)
 at 
build_dlw0bl0qqhtvus3p2ggjy8z4s.run(C:\apache-ofbiz-18\build.gradle:165)
 at 
org.gradle.groovy.scripts.internal.DefaultScriptRunnerFactory$ScriptRunnerImpl.run(DefaultScriptRunnerFactory.java:91)
 at 
org.gradle.configuration.DefaultScriptPluginFactory$ScriptPluginImpl.lambda$apply$0(DefaultScriptPluginFactory.java:133)
 at 
org.gradle.configuration.ProjectScriptTarget.addConfiguration(ProjectScriptTarget.java:77)
 at 
org.gradle.configuration.DefaultScriptPluginFactory$ScriptPluginImpl.apply(DefaultScriptPluginFactory.java:136)
 at 
org.gradle.configuration.BuildOperationScriptPlugin$1$1.run(BuildOperationScriptPlugin.java:69)
 at 
org.gradle.internal.operations.DefaultBuildOperationExecutor$RunnableBuildOperationWorker.execute(DefaultBuildOperationExecutor.java:395)
 at 
org.gradle.internal.operations.DefaultBuildOperationExecutor$RunnableBuildOperationWorker.execute(DefaultBuildOperationExecutor.java:387)
 at 
org.gradle.internal.operations.DefaultBuildOperationExecutor$1.execute(DefaultBuildOperationExecutor.java:157)
 at 
org.gradle.internal.operations.DefaultBuildOperationExecutor.execute(DefaultBuildOperationExec

Re: Error building Ofbiz on Windows 10

[Michael Brohl]

Hi Emad,

It seems the build is running fine with just some deprecation warnings.

What do you think is going wrong?

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 04.05.22 um 15:48 schrieb Emad Radwan:

Hi,

if it helps, I tried ‘cleanall’ and got the following. Anny hint, please.

Regards,
Emad

C:\apache-ofbiz-18>gradle --warning-mode all cleanall


Configure project :

The compile configuration has been deprecated for dependency declaration. This 
will fail with an error in Gradle 7.0. Please use the implementation 
configuration instead. Consult the upgrading guide for further information: 
https://docs.gradle.org/6.5/userguide/upgrading_version_5.html#dependencies_should_no_longer_be_declared_using_the_compile_and_runtime_configurations
 at 
build_dlw0bl0qqhtvus3p2ggjy8z4s$_run_closure7.doCall(C:\apache-ofbiz-18\build.gradle:167)
 (Run with --stacktrace to get the full stack trace of this deprecation 
warning.)
The testCompile configuration has been deprecated for dependency declaration. 
This will fail with an error in Gradle 7.0. Please use the testImplementation 
configuration instead. Consult the upgrading guide for further information: 
https://docs.gradle.org/6.5/userguide/upgrading_version_5.html#dependencies_should_no_longer_be_declared_using_the_compile_and_runtime_configurations
 at 
build_dlw0bl0qqhtvus3p2ggjy8z4s$_run_closure7.doCall(C:\apache-ofbiz-18\build.gradle:228)
 (Run with --stacktrace to get the full stack trace of this deprecation 
warning.)
The runtime configuration has been deprecated for dependency declaration. This 
will fail with an error in Gradle 7.0. Please use the runtimeOnly configuration 
instead. Consult the upgrading guide for further information: 
https://docs.gradle.org/6.5/userguide/upgrading_version_5.html#dependencies_should_no_longer_be_declared_using_the_compile_and_runtime_configurations
 at 
build_dlw0bl0qqhtvus3p2ggjy8z4s$_run_closure7.doCall(C:\apache-ofbiz-18\build.gradle:231)
 (Run with --stacktrace to get the full stack trace of this deprecation 
warning.)
The runtime configuration has been deprecated for resolution. This will fail 
with an error in Gradle 7.0. Please resolve the runtimeClasspath configuration 
instead. Consult the upgrading guide for further information: 
https://docs.gradle.org/6.5/userguide/upgrading_version_5.html#dependencies_should_no_longer_be_declared_using_the_compile_and_runtime_configurations
 at 
build_dlw0bl0qqhtvus3p2ggjy8z4s.getJarManifestClasspathForCurrentOs(C:\apache-ofbiz-18\build.gradle:1162)
 (Run with --stacktrace to get the full stack trace of this deprecation 
warning.)


Task :clean
Task :cleanCatalina
Task :cleanData
Task :cleanDownloads
Task :cleanEclipseClasspath UP-TO-DATE
Task :cleanEclipseJdt UP-TO-DATE
Task :cleanEclipseProject UP-TO-DATE
Task :cleanEclipse UP-TO-DATE
Task :cleanFooterFiles
Task :cleanIndexes
Task :cleanLogs
Task :cleanOutput
Task :cleanTempfiles
Task :cleanUploads
Task :cleanXtra
Task :cleanAll

BUILD SUCCESSFUL in 14s
15 actionable tasks: 11 executed, 4 up-to-date


On 2 May 2022, at 7:27 PM, Emad Radwan  wrote:

Hello Jacques,

Thanks for the help, I changed to JDK 8 and having some progress, but still 
getting an error. How can I fix this?

Regards,
Emad




C:\apache-ofbiz-18>gradle --warning-mode=none loadall ofbiz

Task :compileJava UP-TO-DATE
Task :compileGroovy UP-TO-DATE
Task :processResources UP-TO-DATE
Task :classes UP-TO-DATE
Task :jar UP-TO-DATE
Task :assemble UP-TO-DATE
Task :checkstyleMain FAILED

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':checkstyleMain'.

Unable to create Root Module: config 
{C:\apache-ofbiz-18\config\checkstyle\checkstyle.xml}, classpath 
{C:\apache-ofbiz-18\build\classes\java\main;C:\apache-ofbiz-18\build\classes\groovy\main;C:\apache-ofbiz-18\build\resources\main;C:\Users\20102\.gradle\caches\modules-2\files-2.1\apache-xerces\xercesImpl\2.9.1\7bc7e49ddfe4fb5f193ed37ecc96c12292c8ceb6\xercesImpl-2.9.1.jar;C:\Users\20102\.gradle\caches\modules-2\files-2.1\com.google.zxing\core\3.3.3\b640badcc97f18867c4dfd249ef8d20ec0204c07\core-3.3.3.jar;C:\Users\20102\.gradle\caches\modules-2\files-2.1\com.googlecode.concurrentlinkedhashmap\concurrentl
On 2 May 2022, at 9:19 AM, Jacques Le Roux  wrote:

Hi Emad,

There is a JDK conflict, major version 62 is JDK 17, not yet supported by OFBiz 
only officially JDK 8, the demos are running with JDK 11.

Is that a clean (1st time build) for this instance on this machine? Else try a 
clean before building.

If it's not that, maybe a JDK conflict, especially if you use IntelliJ:
https://stackoverflow.com/questions/67079327/how-can-i-fix-unsupported-class-file-major-version-60-in-intellij-idea

Jacques

Le 02/05/2022 à 04:37, Emad Radwan a écrit :

Unsupported class file major version 62

Re: Scheduled job problem

[Michael Brohl]

Hi,

is it possible that your job run time is longer than the 5 minutes 
scheduling interval and it is not configured against parallel execution?


If yes, consider using the semaphore settings for your service (see [1]).

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


[1] 
https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=7045171#ServiceEngineGuide-serviceDefinition




Am 11.04.22 um 21:27 schrieb Tomek:

Hi,

I have created a job:





I would like to run partialUpdateOfferJob service every 5 minutes. In 
the beginning every thing is ok but after some time the service is 
running two (or even more) times at similar time. Here is a part of my 
data stored in job_sandbox table:


job_id    job_name        run_time status_id parent_job_id
269925    Partial update offer    2022-04-11 17:12:44.883000 
SERVICE_QUEUED     partial-update-offer
269924    Partial update offer    2022-04-11 17:12:44.686000 
SERVICE_QUEUED     partial-update-offer
269923    Partial update offer    2022-04-11 17:12:44.526000 
SERVICE_QUEUED     partial-update-offer
269897    Partial update offer    2022-04-11 16:12:52.199000 
SERVICE_FINISHED     partial-update-offer
269896    Partial update offer    2022-04-11 16:12:52.049000 
SERVICE_FINISHED     partial-update-offer
269895    Partial update offer    2022-04-11 16:12:51.80 
SERVICE_FINISHED     partial-update-offer
269880    Partial update offer    2022-04-11 15:33:06.26 
SERVICE_FINISHED     partial-update-offer
269879    Partial update offer    2022-04-11 15:32:55.404000 
SERVICE_FINISHED     partial-update-offer
269878    Partial update offer    2022-04-11 15:32:55.201000 
SERVICE_FINISHED     partial-update-offer
269851    Partial update offer    2022-04-11 14:53:05.134000 
SERVICE_FINISHED     partial-update-offer


How can i repair it?

BTW: why the service is running at irregular time period?

Re: Store / Facility Relationship

[Michael Brohl]

Hi Emad,

yes. ProductStore.oneInventoryFacility indicates that there is only one 
inventory to check and the one referenced by inventoryFacilityId is used.


If you search the codebase for the mentioned fields you will find the 
business logic which handles it.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 10.04.22 um 16:10 schrieb Emad Radwan:

Hello Michael,

Thanks a lot. So, in this case can I consider the value in 
‘Inventory_Facility_Id’ as a kind on denormalization to provide a default value?

Regards,
Emad



On 10 Apr 2022, at 11:12 AM, Michael Brohl  wrote:

Hi Emad,

please have a look at the facility entity, which has a reference to a product 
store. You can have as much facilities referencing a product store as you want.

You can also have a facility hierarchy by connecting multiple facilities to a 
parent facility.

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 10.04.22 um 03:23 schrieb Emad Radwan:

Hello Community,

I noticed that in the ‘product store’ screen we can assign only one facility - 
via ‘Inventory Facility Id’, isn’t that
a bit restricting or maybe I’m missing something.

Regards,
Emad

Re: Store / Facility Relationship

[Michael Brohl]

Hi Emad,

please have a look at the facility entity, which has a reference to a 
product store. You can have as much facilities referencing a product 
store as you want.


You can also have a facility hierarchy by connecting multiple facilities 
to a parent facility.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 10.04.22 um 03:23 schrieb Emad Radwan:

Hello Community,

I noticed that in the ‘product store’ screen we can assign only one facility - 
via ‘Inventory Facility Id’, isn’t that
a bit restricting or maybe I’m missing something.

Regards,
Emad

Re: Rest-API the request always sets the locale to "en"

[Michael Brohl]

Hi Rishi,

that's a good point, I think this is not handled yet and would be a good 
addition.


Please file a subtask ticket under 
https://issues.apache.org/jira/browse/OFBIZ-11328


Thanks,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 08.04.22 um 16:01 schrieb Rishi Agr:

Hi,
I am trying to send the REST request by setting the language to "de"
(Setting "accept-language: de" in request header). When the request arrives
to the "execute" method of "ServiceRequestHandler" class, the service
context is created and "userLogin" is added to the context. But I do not
see any code snippet that sets "locale" which causes the locale to be set
by default to "en". In my understanding, there should be a code included
just below the line that sets "userLogin"

serviceContext.put("locale", getHttpRequest().getLocale());

Please let me know if I am thinking in the right way or if there is a
different mechanism to send "locale" in the request header.
Thank you, Rishi

Re: rest-api Plugin

[Michael Brohl]

Hi Johan,

If you want to be based on a stable branch, I would switch over to the 
release branch r22.01 and the plugins release r22.01 which contains the 
rest-api. It has no release yet but I guess it will have it's first 
release during this year.


trunk is not advised as the base for production.

The migration from r18.12 to r22.01 should not be too hard, other than 
9.04 to 18.12.


Note that 22.01 will be the first release which requires OpenJDK 11 
(maybe 17, depending of what we decide on base of 
https://lists.apache.org/thread/8cpz4dh7zoznp4mx2xxv35hns4j8mvf0 )


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 24.03.22 um 19:16 schrieb Johan Cronje:

Hi Michael,

Thank you for the advice.
Would you rather advise that I change my source branches over to the
trunk, is the trunk based on the r18.12?
Or should I bring the changes from the trunk over to my r18.12 branch
I have cloned the r18.12 to a local branch as it was the newest at the
time and have been migrating a custom build from 9.04.

Kind Regards
Johan

On Thu, 24 Mar 2022 at 18:04, Michael Brohl  wrote:

Hi Johan,

for r18.12 you would have to make some modifications in the framework /
service engine to make it compatible.

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 24.03.22 um 11:19 schrieb Johan Cronje:

Good day,

I would just like to find out if the rest-api Plugin under trunk
plugin branch is compatible with the release18.02 framework branch as
it is not part of the release18.02 Plugin branch

Kind Regards,
Johan

Re: rest-api Plugin

[Michael Brohl]

Hi Johan,

for r18.12 you would have to make some modifications in the framework / 
service engine to make it compatible.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 24.03.22 um 11:19 schrieb Johan Cronje:

Good day,

I would just like to find out if the rest-api Plugin under trunk
plugin branch is compatible with the release18.02 framework branch as
it is not part of the release18.02 Plugin branch

Kind Regards,
Johan

Re: intstall

[Michael Brohl]

Ah, I see the error.

You have to set the property host-headers-allowed to include your 
domain/IP in framework/security/config/security.properties :


host-headers-allowed=localhost,127.0.0.1,demo-trunk.ofbiz.apache.org,demo-stable.ofbiz.apache.org,demo-old.ofbiz.apache.org,IP>


You will have to setup a valid domain and provide a certificate though, 
else you will not be able to serve over https which is strongly recommended.


As mentioned before, you should NOT install OFBiz under root on your 
server. Better create a new user on the server which does have less 
privileges and install OFBiz there.


It should be possible to run ERPNext and OFBiz side-by-side on one 
Server. You will have to take care about the ports each application is 
using and configure in a way that they use different ports to avoid 
conflicts. Easiest would be to put an Apache webserver before OFBiz and 
serve OFBiz through a subdomain like ofbiz.yourdomain.com.


You'll find further reading in our wiki, for example here: 
https://cwiki.apache.org/confluence/display/OFBIZ/Install+OFBiz+with+MariaDB%2C+Apache2+Proxy+and+SSL


Regards

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 16.03.22 um 18:05 schrieb sa...@maxcapital.co.za:

Hi Michael,

uploaded it to mediafire,

https://www.mediafire.com/file/kgkkat03bcffkrl/opening+with+error.jpg/file 



I will reinstall it from the start under root, have learned alot the 
past few days. Using ERPnext at the moment but would like to see Ofbiz 
and maybe change over. At the moment ERPnext is installed using my 
website domain, is this possible also to link the Ofbiz ecommerce to 
your website domain.


Regards
Reinier


On 2022-03-16 12:10, Michael Brohl wrote:

Hi Reinier,

inline...

Michael


Am 16.03.22 um 16:55 schrieb sa...@maxcapital.co.za:

Hi Michael,

got it loaded with the following code "sudo ufw allow 1:/tcp"


I cannot recommend this setting as it open all ports in this range.
You should only allow the needed ports.




It loads but then gives the screenshot attached.


This mailing list does not allow image attachments. Can you provide
the image elsewhere and give a link?




I unzipped ofbiz 18.12.05 into,

root@ofbiz:~/apache-ofbiz-18.12.05#


You should not run OFBiz under root directly for security reasons.




How can i get into the security.properties to update this, and if 
possible can you tell me where to update.


What do you want to change exactly?




Regards
Reinier


On 2022-03-16 11:43, Michael Brohl wrote:

What is the output of "sudo netstat -plnt" on the server?

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 16.03.22 um 16:29 schrieb sa...@maxcapital.co.za:

Hi Michael,

thanks for the reply, opened the ports on my server but still the 
same problem. Details from the server below.


Rule added (v6)
root@ofbiz:~# sudo ufw allow 8080/tcp
Rule added
Rule added (v6)
root@ofbiz:~# sudo ufw status verbose
Status: active
Logging: on (low)
Default: deny (incoming), allow (outgoing), disabled (routed)
New profiles: skip

To Action  From
-- --  
22 ALLOW IN    Anywhere
80/tcp ALLOW IN    Anywhere
443/tcp    ALLOW IN    Anywhere
8443/tcp   ALLOW IN    Anywhere
8080/tcp   ALLOW IN    Anywhere
22 (v6)    ALLOW IN    Anywhere (v6)
80/tcp (v6)    ALLOW IN    Anywhere (v6)
443/tcp (v6)   ALLOW IN    Anywhere (v6)
8443/tcp (v6)  ALLOW IN    Anywhere (v6)
8080/tcp (v6)  ALLOW IN    Anywhere (v6)

Regards
Reinier




On 2022-03-16 11:05, Michael Brohl wrote:

Hi Reinier,

I don't know Vultr but maybe it does not expose the default ports
OFBiz is running with (8443/8080). Might be a firewall set up 
there to

only expose the standard ports for http(s), ssh, ftp etc.

You'll have to check this with the Hoster and maybe change the 
default

ports in your Catalina configuration to 443/80 to make it work.

For production use, it is recommended to put an Apache Webserver
before the OFBiz instance, connected with AJP.

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 16.03.22 um 15:32 schrieb sa...@maxcapital.co.za:

Hi Mathew,

it's on Vultr.com so it is a remote Ubuntu 20.04 server. Ofbiz 
installed successfully but tried all of the ways with my server 
IP on vultr. i also pinged the ip from the ofbiz on the ubuntu 
server and looks like running fine.


Not sure what else to do from here.

Regards
Reinier

On 2022-03-15 16:11, Mathew Cox wrote:
If your install is on the same machine you are trying to 
connect to,

then you won't use your network ip address but your local machine
address.  For example, if I installed OFBiz on my desktop here, I
would connect to it as follows:

https://localhost:8443/webtools

or alternatively

https://127.0.0.1:8443/webtools

If the install is on a remote machine, only then would 

Re: intstall

[Michael Brohl]

Hi Reinier,

inline...

Michael


Am 16.03.22 um 16:55 schrieb sa...@maxcapital.co.za:

Hi Michael,

got it loaded with the following code "sudo ufw allow 1:/tcp"


I cannot recommend this setting as it open all ports in this range. You 
should only allow the needed ports.





It loads but then gives the screenshot attached.


This mailing list does not allow image attachments. Can you provide the 
image elsewhere and give a link?





I unzipped ofbiz 18.12.05 into,

root@ofbiz:~/apache-ofbiz-18.12.05#


You should not run OFBiz under root directly for security reasons.




How can i get into the security.properties to update this, and if 
possible can you tell me where to update.


What do you want to change exactly?




Regards
Reinier


On 2022-03-16 11:43, Michael Brohl wrote:

What is the output of "sudo netstat -plnt" on the server?

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 16.03.22 um 16:29 schrieb sa...@maxcapital.co.za:

Hi Michael,

thanks for the reply, opened the ports on my server but still the 
same problem. Details from the server below.


Rule added (v6)
root@ofbiz:~# sudo ufw allow 8080/tcp
Rule added
Rule added (v6)
root@ofbiz:~# sudo ufw status verbose
Status: active
Logging: on (low)
Default: deny (incoming), allow (outgoing), disabled (routed)
New profiles: skip

To Action  From
-- --  
22 ALLOW IN    Anywhere
80/tcp ALLOW IN    Anywhere
443/tcp    ALLOW IN    Anywhere
8443/tcp   ALLOW IN    Anywhere
8080/tcp   ALLOW IN    Anywhere
22 (v6)    ALLOW IN    Anywhere (v6)
80/tcp (v6)    ALLOW IN    Anywhere (v6)
443/tcp (v6)   ALLOW IN    Anywhere (v6)
8443/tcp (v6)  ALLOW IN    Anywhere (v6)
8080/tcp (v6)  ALLOW IN    Anywhere (v6)

Regards
Reinier




On 2022-03-16 11:05, Michael Brohl wrote:

Hi Reinier,

I don't know Vultr but maybe it does not expose the default ports
OFBiz is running with (8443/8080). Might be a firewall set up there to
only expose the standard ports for http(s), ssh, ftp etc.

You'll have to check this with the Hoster and maybe change the default
ports in your Catalina configuration to 443/80 to make it work.

For production use, it is recommended to put an Apache Webserver
before the OFBiz instance, connected with AJP.

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 16.03.22 um 15:32 schrieb sa...@maxcapital.co.za:

Hi Mathew,

it's on Vultr.com so it is a remote Ubuntu 20.04 server. Ofbiz 
installed successfully but tried all of the ways with my server IP 
on vultr. i also pinged the ip from the ofbiz on the ubuntu server 
and looks like running fine.


Not sure what else to do from here.

Regards
Reinier

On 2022-03-15 16:11, Mathew Cox wrote:

If your install is on the same machine you are trying to connect to,
then you won't use your network ip address but your local machine
address.  For example, if I installed OFBiz on my desktop here, I
would connect to it as follows:

https://localhost:8443/webtools

or alternatively

https://127.0.0.1:8443/webtools

If the install is on a remote machine, only then would you use an IP
address like the one you listed.

Mathew


From: sa...@maxcapital.co.za 
Sent: Tuesday, March 15, 2022 11:53 AM
To: user@ofbiz.apache.org 
Subject: Re: intstall

Hi Mathew,

sent a email with the attachments but then the email comes back, 
when i

send it without the screenshots the emails can go through to you.

Regards
Reinier

On 2022-03-15 14:40, sa...@maxcapital.co.za wrote:

Hi Mathew,

go it installed at last but cannot open it in the browser. 
Please see
the screenshots attached and i used the below code without any 
errors.
The last screenshot show the screen when trying to open Ofbiz on 
the

web.

# sudo apt update && sudo apt upgrade
Restart

# sudo apt-get install openjdk-8-jdk
java -version

# wget https://dlcdn.apache.org/ofbiz/apache-ofbiz-18.12.05.zip
# ls -1

# unzip apache-ofbiz-18.12.05.zip
# ls -1

# cd apache-ofbiz-18.12.05
# ls -1

# cd gradle
# ls -la
# cd ..

# sudo ./gradle/init-gradle-wrapper.sh

# sudo ./gradlew cleanAll
# sudo ./gradlew cleanAll loadAll
# sudo ./gradlew ofbiz

https://95.179.199.59:8443/accounting
https://95.179.199.59:8443/myportal/control/main

Regards
Reinier

On 2022-03-14 16:01, Mathew Cox wrote:
Let me try and be a little more clear as I think I might have 
not been

as much.

As an example:

I extracted the contents of apache-ofbiz-18.12.05.zip onto my 
desktop

which created the folder:

apache-ofbiz-18.12.05

If I open up my command prompt and navigate to that directory 
it would

look something like this:

$> cd ~/Desktop/apache-ofbiz-18.12.05/
(the ~ means my personal login home directory, not to be 
confused with

/home)

In this directory there is a folder called gradle

Re: intstall

[Michael Brohl]

What is the output of "sudo netstat -plnt" on the server?

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 16.03.22 um 16:29 schrieb sa...@maxcapital.co.za:

Hi Michael,

thanks for the reply, opened the ports on my server but still the same 
problem. Details from the server below.


Rule added (v6)
root@ofbiz:~# sudo ufw allow 8080/tcp
Rule added
Rule added (v6)
root@ofbiz:~# sudo ufw status verbose
Status: active
Logging: on (low)
Default: deny (incoming), allow (outgoing), disabled (routed)
New profiles: skip

To Action  From
-- --  
22 ALLOW IN    Anywhere
80/tcp ALLOW IN    Anywhere
443/tcp    ALLOW IN    Anywhere
8443/tcp   ALLOW IN    Anywhere
8080/tcp   ALLOW IN    Anywhere
22 (v6)    ALLOW IN    Anywhere (v6)
80/tcp (v6)    ALLOW IN    Anywhere (v6)
443/tcp (v6)   ALLOW IN    Anywhere (v6)
8443/tcp (v6)  ALLOW IN    Anywhere (v6)
8080/tcp (v6)  ALLOW IN    Anywhere (v6)

Regards
Reinier




On 2022-03-16 11:05, Michael Brohl wrote:

Hi Reinier,

I don't know Vultr but maybe it does not expose the default ports
OFBiz is running with (8443/8080). Might be a firewall set up there to
only expose the standard ports for http(s), ssh, ftp etc.

You'll have to check this with the Hoster and maybe change the default
ports in your Catalina configuration to 443/80 to make it work.

For production use, it is recommended to put an Apache Webserver
before the OFBiz instance, connected with AJP.

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 16.03.22 um 15:32 schrieb sa...@maxcapital.co.za:

Hi Mathew,

it's on Vultr.com so it is a remote Ubuntu 20.04 server. Ofbiz 
installed successfully but tried all of the ways with my server IP 
on vultr. i also pinged the ip from the ofbiz on the ubuntu server 
and looks like running fine.


Not sure what else to do from here.

Regards
Reinier

On 2022-03-15 16:11, Mathew Cox wrote:

If your install is on the same machine you are trying to connect to,
then you won't use your network ip address but your local machine
address.  For example, if I installed OFBiz on my desktop here, I
would connect to it as follows:

https://localhost:8443/webtools

or alternatively

https://127.0.0.1:8443/webtools

If the install is on a remote machine, only then would you use an IP
address like the one you listed.

Mathew


From: sa...@maxcapital.co.za 
Sent: Tuesday, March 15, 2022 11:53 AM
To: user@ofbiz.apache.org 
Subject: Re: intstall

Hi Mathew,

sent a email with the attachments but then the email comes back, 
when i

send it without the screenshots the emails can go through to you.

Regards
Reinier

On 2022-03-15 14:40, sa...@maxcapital.co.za wrote:

Hi Mathew,

go it installed at last but cannot open it in the browser. Please see
the screenshots attached and i used the below code without any 
errors.

The last screenshot show the screen when trying to open Ofbiz on the
web.

# sudo apt update && sudo apt upgrade
Restart

# sudo apt-get install openjdk-8-jdk
java -version

# wget https://dlcdn.apache.org/ofbiz/apache-ofbiz-18.12.05.zip
# ls -1

# unzip apache-ofbiz-18.12.05.zip
# ls -1

# cd apache-ofbiz-18.12.05
# ls -1

# cd gradle
# ls -la
# cd ..

# sudo ./gradle/init-gradle-wrapper.sh

# sudo ./gradlew cleanAll
# sudo ./gradlew cleanAll loadAll
# sudo ./gradlew ofbiz

https://95.179.199.59:8443/accounting
https://95.179.199.59:8443/myportal/control/main

Regards
Reinier

On 2022-03-14 16:01, Mathew Cox wrote:
Let me try and be a little more clear as I think I might have not 
been

as much.

As an example:

I extracted the contents of apache-ofbiz-18.12.05.zip onto my 
desktop

which created the folder:

apache-ofbiz-18.12.05

If I open up my command prompt and navigate to that directory it 
would

look something like this:

$> cd ~/Desktop/apache-ofbiz-18.12.05/
(the ~ means my personal login home directory, not to be confused 
with

/home)

In this directory there is a folder called gradle

If you type:

$>cd gradle

You will be in this directory and in this directory you should type
the following command:

$> ls -la

You should get a list that looks like this:

total 20
drwxr-xr-x  3 root root 4096 Jan  2 01:20 .
drwxr-xr-x 12 root root 4096 Jan  2 02:56 ..
-rw-r--r--  1 root root 1849 Jan  2 01:20 init-gradle-wrapper.ps1
-rwxr-xr-x  1 root root 4049 Jan  2 01:20 init-gradle-wrapper.sh
drwxr-xr-x  2 root root 4096 Mar 14 12:40 wrapper

I want you to make sure that the file init-gradle-wrapper.sh has 
three

"x" markings where it reads above:

-rwxr-xr-x

It should but we are just checking at this point.

Now type:

$>cd ..

This should take you back to your root directory of the apache
directory.  From this directory, if you type:

$>sudo ./gradle/init-gradle-wrap

Re: intstall

[Michael Brohl]

Hi Reinier,

I don't know Vultr but maybe it does not expose the default ports OFBiz 
is running with (8443/8080). Might be a firewall set up there to only 
expose the standard ports for http(s), ssh, ftp etc.


You'll have to check this with the Hoster and maybe change the default 
ports in your Catalina configuration to 443/80 to make it work.


For production use, it is recommended to put an Apache Webserver before 
the OFBiz instance, connected with AJP.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 16.03.22 um 15:32 schrieb sa...@maxcapital.co.za:

Hi Mathew,

it's on Vultr.com so it is a remote Ubuntu 20.04 server. Ofbiz 
installed successfully but tried all of the ways with my server IP on 
vultr. i also pinged the ip from the ofbiz on the ubuntu server and 
looks like running fine.


Not sure what else to do from here.

Regards
Reinier

On 2022-03-15 16:11, Mathew Cox wrote:

If your install is on the same machine you are trying to connect to,
then you won't use your network ip address but your local machine
address.  For example, if I installed OFBiz on my desktop here, I
would connect to it as follows:

https://localhost:8443/webtools

or alternatively

https://127.0.0.1:8443/webtools

If the install is on a remote machine, only then would you use an IP
address like the one you listed.

Mathew


From: sa...@maxcapital.co.za 
Sent: Tuesday, March 15, 2022 11:53 AM
To: user@ofbiz.apache.org 
Subject: Re: intstall

Hi Mathew,

sent a email with the attachments but then the email comes back, when i
send it without the screenshots the emails can go through to you.

Regards
Reinier

On 2022-03-15 14:40, sa...@maxcapital.co.za wrote:

Hi Mathew,

go it installed at last but cannot open it in the browser. Please see
the screenshots attached and i used the below code without any errors.
The last screenshot show the screen when trying to open Ofbiz on the
web.

# sudo apt update && sudo apt upgrade
Restart

# sudo apt-get install openjdk-8-jdk
java -version

# wget https://dlcdn.apache.org/ofbiz/apache-ofbiz-18.12.05.zip
# ls -1

# unzip apache-ofbiz-18.12.05.zip
# ls -1

# cd apache-ofbiz-18.12.05
# ls -1

# cd gradle
# ls -la
# cd ..

# sudo ./gradle/init-gradle-wrapper.sh

# sudo ./gradlew cleanAll
# sudo ./gradlew cleanAll loadAll
# sudo ./gradlew ofbiz

https://95.179.199.59:8443/accounting
https://95.179.199.59:8443/myportal/control/main

Regards
Reinier

On 2022-03-14 16:01, Mathew Cox wrote:

Let me try and be a little more clear as I think I might have not been
as much.

As an example:

I extracted the contents of apache-ofbiz-18.12.05.zip onto my desktop
which created the folder:

apache-ofbiz-18.12.05

If I open up my command prompt and navigate to that directory it would
look something like this:

$> cd ~/Desktop/apache-ofbiz-18.12.05/
(the ~ means my personal login home directory, not to be confused with
/home)

In this directory there is a folder called gradle

If you type:

$>cd gradle

You will be in this directory and in this directory you should type
the following command:

$> ls -la

You should get a list that looks like this:

total 20
drwxr-xr-x  3 root root 4096 Jan  2 01:20 .
drwxr-xr-x 12 root root 4096 Jan  2 02:56 ..
-rw-r--r--  1 root root 1849 Jan  2 01:20 init-gradle-wrapper.ps1
-rwxr-xr-x  1 root root 4049 Jan  2 01:20 init-gradle-wrapper.sh
drwxr-xr-x  2 root root 4096 Mar 14 12:40 wrapper

I want you to make sure that the file init-gradle-wrapper.sh has three
"x" markings where it reads above:

-rwxr-xr-x

It should but we are just checking at this point.

Now type:

$>cd ..

This should take you back to your root directory of the apache
directory.  From this directory, if you type:

$>sudo ./gradle/init-gradle-wrapper.sh

You should get the following output:

 === Prepare operation ===
/home/root/Desktop/apache-ofbiz-18.12.05/gradle/wrapper/gradle-wrapper.jar 


not found, we download it
 === Download gradle-wrapper.jar ===
 === Download gradle-wrapper.properties ===
 === Control downloaded files ===
gradle/wrapper/gradle-wrapper.jar: OK
gradle/wrapper/gradle-wrapper.properties: OK
gradlew: OK



If you are getting any other output, please post it so we (not
necessarily me) can better diagnose what is going on.



Mathew


From: sa...@maxcapital.co.za 
Sent: Monday, March 14, 2022 6:14 AM
To: user@ofbiz.apache.org 
Subject: Re: intstall

Hi Jacques, Mathew,

still getting the same errors on Ubuntu. Are there any latest scripts
that can be followed step by step to install as i have looked around
online but all seems to be old.

Tried the ./gradle/init-gradle-wrapper.sh (Says no such file found)
Tried the ./gradlew cleanAll loadAll (instead of defaultAll) still the
same error (No such file or directory.

Not sure why i am getting these errors, i have update and upgraded
Ubuntu, restarted the sever. Installed sudo apt-get install
openjdk-8-jdk successfully. T

Re: EmailPasswordUiLabels missing multi-language for certain properties

[Michael Brohl]

Hi Rishi,

if you can provide additional translations, please create a Jira and add 
a patch or pull request.


Thanks and regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 07.03.22 um 10:17 schrieb Rishi Agr:

Hi, There are 2 properties namely *SecurityExtIgnoreEmail* and
*SecurityExtLinkOnce* in *EmailPasswordUiLabels.xml* which have translation
for only english and french. Is there a plan to add other language
translations as in other properties?

Re: Rest API versioning and redirection

[Michael Brohl]

Hi Rishi,

the /rest/ endpoint is fixed in the current implementation but you can 
change it bei changing the webapp path on ofbiz-component.xml.


Versioning can be achieved by multiple rest api configurations where you 
set the resource base path to e.g.  path="/v1/parties" or 
path="/v2/parties".


Redirection is not configurable inside OFBiz currently but you can 
easily achieve what you want with an Apache Web Server (which is 
recommended for productive systems anyway) and rewrite rules.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de

Am 02.03.22 um 08:13 schrieb Rishi Agr:

Can someone provide some information on this?

On Mon, Feb 28, 2022 at 4:47 PM Rishi Agr  wrote:


Hi,
I am trying to add API versioning and I found that there is mount-point
*/rest* in *rest-api/ofbiz-component.xml* which is added as a part of the
path to the API. This is also the case in *swagger-ui.html*. In my
understanding, there needs to be a configurable property that can be used
in both the places and the versioning can be configured as some kind of
property. I tried to do so but was unable to. Please provide a small
snippet that can help me here. Also, I wanted to add a redirection url
where if the old version API is called then it can redirect to the new
version API. Let me know this is possible and a small code snippet would be
very helpful. Thank you.

Re: Rest API does not send the null properties in response

[Michael Brohl]

Hi Rishi,

there is no configuration option currently.

We could either make this configurable or use 
JsonInclude.Include.USE_DEFAULTS to let the source class handle how null 
values will be rendered in the JSON.


As I am currently working on the plugin, please consider creating a Jira 
as a subtask for https://issues.apache.org/jira/browse/OFBIZ-11328 to 
discuss this further and track development.


Thanks and regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 28.02.22 um 11:25 schrieb Rishi Agr:

Hi, I have observed that the response data from any API does not contain
the properties with null values. Upon having a check, I found that the
class "JacksonConfig" has
"objectMapper.setSerializationInclusion(JsonInclude.Include.NON_NULL);"
which excludes the null properties from the response data. Not sending the
null properties has benefits. But I feel that this property should be
configurable and not provide the feature of not sending the null
properties. It can be something like the default behavior is to not send
the null properties in the JSON response and it is configurable where the
developer can set some property to toggle the behavior. Please provide your
view on this and let me know if there is some configuration available and I
am missing something. Thank you.

Re: Rest API bypassing certain APIs from authentication

[Michael Brohl]

Hi Rishi,

how is your operation inside the resource being configured?

If ommitted, auth defaults to true there.

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 22.02.22 um 12:56 schrieb Rishi Agr:

Hi, I am implementing an API that needs to be processed without
authentication. This API will be publicly accessible. I have tried to set
the rest and services definition with auth="false" but it has not helped.
Below is a small code
rest.xml


services.xml


Can someone let me know what am I missing or doing wrong?

Re: Ofbiz Rest API content-type

[Michael Brohl]

Hi,

the REST-API ist designed to either automatically expose standard OFBiz 
services through the export configuration or configure an API through 
the special rest configuration (also using services underneath). It is 
automatically reading body or url parameters, providing them to the 
underlying service and returns the service results in a structured 
format which is currently only JSON.


As Carsten mentioned, for a REST API it is common to have structured 
input/output like JSON or the less used XML format. The REST-API plugin 
currently supports JSON. We are working on enhancing the plugin (see 
[1]) but I don't expect to have it support HTML.


If you want to return HTML, you can just go with the standard way of 
http requests, getting data and rendering through the Freemarker 
template engine.


I agree with Carsten, it sounds like you should use the REST-API as-is 
and render the JSON results using some templating in your consuming client.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de

[1] https://issues.apache.org/jira/browse/OFBIZ-11328

Am 19.02.22 um 07:36 schrieb Carsten Schinzer:

Hi again,


I wonder why a REST API Service would be expected to return HTML. Isn’t the
client of the REST API responsible to render the returned JSON?

If you would expect XML for example, ok. But HTML? Hum.
Maybe it is worth to read the Wikipedia article on REST API and understand
that your idea rather counters its basic idea of separating concerns.
https://en.wikipedia.org/wiki/Representational_state_transfer

You might want to review your “scenario” and consider a HTML rendering step
on your side after retrieving the relevant data from the API?

Warm regards


Carsten


Altafhusen Makandar  schrieb am Fr. 18. Feb. 2022
um 11:06:


Thank you for your response. This is a generic question related to the
request and response object type in ofbiz rest API. In my understanding,
the rest API currently supports the request and response object type as
JSON. I've scenario where I want to return a HTML data and not JSON object.
Similarly, there may be other type of object that I may receive or return.
So I wanted to check if the feature to receive or return other types other
than JSON is available. If it's available then a small code snippet of it's
usage would be helpful to me. It would be great if I get some information
on this. Thank you.

On Fri, Feb 18, 2022, 09:40 Carsten Schinzer <
cars...@dcs-verkaufssysteme.de>
wrote:


Hello,


I am not really sure, your question is clear to everybody. I would

wonder:

Is this a generic question?
I ask, because "application/json" indicates that a structured content

with

key-value pairs (potentially matching a given schema) will be returned
while the other content types you are asking for are (content-wise) not
structured in that sense: text/html, text/plain, multipart/*.
Are you looking for something concrete here?

Maybe it helps to describe your use case a bit more.
Warm regards


Carsten



---


Dr. Carsten Schinzer

*Inhaber*


t +49 89 88569642 | f +49 89 99964059 | m +49 159 05269462

DCS Verkaufssysteme

Gerner Str. 27 | 80638 München | Germany


Am Do., 17. Feb. 2022 um 22:55 Uhr schrieb Altafhusen Makandar <
altafhusen...@gmail.com>:


Can someone please provide some information on this?

On Thu, Feb 17, 2022, 10:43 Altafhusen Makandar <

altafhusen...@gmail.com

wrote:


Hi,

I am using the rest API feature of the ofbiz and I found the
"application/json".as the content-type. Do we have a feature for

other

content types like text/html, text/plain, multipart/* and so on?

Regards,
Altaf.

Re: Session Lost after returning from paypal

[Michael Brohl]

Hi Markus,

I don't think that this scenario will work with a localhost configuration.

For integration testing with paypal, you will need a setting with a 
domain which is reachable by PayPal. An external server or a DynDNS 
setting with a route to the localhost machine should work.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 10.02.22 um 08:53 schrieb Markus:

Hello Ladies and Gentleman,

I'm running Ofbiz 18.12.02 in a local installation on localhost in an 
eCommerce scenario.


I like to setup and run the paypal integration for payments properly. 
The jump to paypal and the processing at paypal works fine. The 
problem starts in the moment the system jumps back from paypal into 
the online-shop. After returning from paypal I see following:


 * Customer is log'ed out from Ofbiz and has to login again.
 * Every order is accepted in Ofbiz independent from Customers decision
   in paypal to accept or cancel the payment;
 * No order confirmation eMail is sent in case of accepting the payment.

Configuration of my paypal payment gateway looks like:

   Business Email a...@markusw.net
   Api User Name sb-xx_api1.business.example.com
   Api Password        Q4UTxBKG
   Api Signature AwTSX5gFmk3QHxjfkJUtN
   Api Environment
   Notify Url https://localhost:8443/ecommerce/control/payPalNotify
   Return Url https://localhost:8443/ecommerce/control/processorder
   Cancel Return URL https://localhost:8443/ecommerce/control/main
   Image Url https://localhost:8443/images/ofbiz_logo.gif
   Confirm Template        /order/emailconfirmation.ftl
   Redirect Url https://www.sandbox.paypal.com/webscr
   Confirm Url https://www.sandbox.paypal.com/us/cgi-bin/webscr
   Shipping Callback Url
   Require Confirmed Shipping  N

For me it looks like the session in Ofbiz got lost or was not 
re-assigned after returning from paypal.    But this is only a guess.


Does someone of you have a good idea what can be wrong?

I checked the documentation and eMail-lists already ... I appreciate 
every link to more detailed documentation.


Best regards

Markus

Re: MRP Not Working

[Michael Brohl]

Hi Steven,

the table RequirementStatus has 3 foreign keys: requirementId, statusId 
and changeByUserLoginId.


Are those ids present in their tables (Requirement, StatusItem, 
UserLogin)? Is all seed data loaded?


Is this a custom installation or standard OFBiz?

If you think this is a bug, you might want to file a Jira. Please give 
as much information as possible there on how to recreate this error.


Thanks and regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 01.02.22 um 21:37 schrieb Steven Payne:

Hi Michael,

Thanks for the quick response.  Here is the full stacktrace (I think)...

2022-02-01 12:33:36,369 |OFBiz-JobQueue-44|ServiceDispatcher 
|E| Service [createRequirementStatus] threw an unexpected exception/error
org.apache.ofbiz.service.GenericServiceException: Cannot run job. (Unable to 
queue job [createRequirementStatus.1643747616369])
 at 
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:143)
 ~[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:70)
 ~[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:748) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:813) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runAsync(GenericDispatcherFactory.java:181)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:131)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:160) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:191) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:514) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.manufacturing.mrp.ProposedOrder.create(ProposedOrder.java:262) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.manufacturing.mrp.MrpServices.executeMrp(MrpServices.java:816) 
[ofbiz.jar:?]
 at sun.reflect.GeneratedMethodAccessor1393.invoke(Unknown Source) 
~[?:?]
 at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 ~[?:1.8.0_312]
 at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_312]
 at 
org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:415) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70) 
[ofbiz.jar:?]
 at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87) 
[ofbiz.jar:?]
 at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 
[?:1.8.0_312]
 at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 
[?:1.8.0_312]
 at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
Caused by: org.apache.ofbiz.service.job.InvalidJobException: Unable to queue 
job [createRequirementStatus.1643747616369]
 at 
org.apache.ofbiz.service.job.GenericServiceJob.deQueue(GenericServiceJob.java:151)
 ~[ofbiz.jar:?]
 at org.apache.ofbiz.service.job.JobPoller.queueNow(JobPoller.java:173) 
~[ofbiz.jar:?]
 at org.apache.ofbiz.service.job.JobManager.runJob(JobManager.java:366) 
~[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:141)
 ~[ofbiz.jar:?]
 ... 25 more
2022-02-01 12:33:36,377 |OFBiz-JobQueue-44|TransactionUtil   
|W| Calling transaction setRollbackOnly; this stack trace shows where this is 
happening:
java.lang.Exception: Service [createRequirementStatus] threw an unexpected 
exception/error
 at 
org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:358)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:292)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:764) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:813) 
[ofbiz.jar

Re: MRP Not Working

[Michael Brohl]

Hi Steven,

it seems that you did not provide the whole stacktrace, at least I 
cannot find a message containing hints for a failed foreign key constraint.


You should find the name of the failed constraint in the error log, near 
the prepared statement log entry.


Please make your credentials shown in the log unreadable next time ;-)

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 01.02.22 um 21:02 schrieb Steven Payne:

Hi All,

I am trying to run the MRP system here and I am coming across a weird error. 
Has anyone else had issues with running MRP and it not being able to create a 
REQUIREMENT_STATUS?

I managed to find the start of the error (posted below) and I am trying one by 
one to add each manufacturing run to see if I can isolate the issue.  No luck 
so far. It states that there is a foreign key constraint breaking...but what FK 
constraint?

2022-02-01 11:59:21,676 |OFBiz-JobQueue-47|ServiceDispatcher 
|E| Service [createRequirementStatus] threw an unexpected exception/error
org.apache.ofbiz.service.GenericServiceException: Cannot run job. (Unable to 
queue job [createRequirementStatus.1643745561676])
 at 
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:143)
 ~[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:70)
 ~[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:748) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:813) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runAsync(GenericDispatcherFactory.java:181)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:131)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:160) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:191) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:514) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.manufacturing.mrp.ProposedOrder.create(ProposedOrder.java:262) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.manufacturing.mrp.MrpServices.executeMrp(MrpServices.java:816) 
[ofbiz.jar:?]
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
~[?:1.8.0_312]
 at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
~[?:1.8.0_312]
 at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 ~[?:1.8.0_312]
 at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_312]
 at 
org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:415) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70) 
[ofbiz.jar:?]
 at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87) 
[ofbiz.jar:?]
 at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 
[?:1.8.0_312]
 at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 
[?:1.8.0_312]
 at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
Caused by: org.apache.ofbiz.service.job.InvalidJobException: Unable to queue 
job [createRequirementStatus.1643745561676]
 at 
org.apache.ofbiz.service.job.GenericServiceJob.deQueue(GenericServiceJob.java:151)
 ~[ofbiz.jar:?]
 at org.apache.ofbiz.service.job.JobPoller.queueNow(JobPoller.java:173) 
~[ofbiz.jar:?]
 at org.apache.ofbiz.service.job.JobManager.runJob(JobManager.java:366) 
~[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:141)
 ~[ofbiz.jar:?]
 ... 26 more
2022-02-01 11:59:21,677 |OFBiz-JobQueue-47|TransactionUtil   
|W| Calling transaction setRollbackOnly; this stack trace shows where this is 
happening:
java.lang.Exception: Service [createRequirementStatus] threw an unexpected 
exception/error

Re: Products included in Service

[Michael Brohl]

Hi Emad,

just a brief guess for now: have you had a look at the ProductConfig* 
and ConfigOptionProductOption entities?


There is some demo data in OrderDemoData.xml.

Services can also be handled as Products of a specified type and you can 
build typed relationships between products (in this case products and 
the service), specifying which products are mandatory and which are 
optional.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 29.01.22 um 13:24 schrieb Emad Radwan:

Hello Community,

Regarding this issue, I found in Silverston's book that he has a table
called 'Product_Component' that handles such situations under 'Products and
Parts' section in chapter 3 on page 100. I understand that we don't have
such a table in Ofbiz data model so I'll appreciate it if someone can guide
me on how this situation is handled.

Regards,

Emad

On 2022/01/27 13:29:08 Emad Radwan wrote:

Hello Community,

I have a scenario where I need to define a service but that one will

include products also; think of a car maintenance shop where the service is
the 5k maintenance and the included products are the spare parts.

Where can I handle this in the GUI?

Regards,

Emad

Re: Support/Installation/Customization of OfBiz

[Michael Brohl]

Some corrections to avoid confusion and going in the wrong directions

- Ingo Könemann (now Ingo Richter) is an employee of ecomify GmbH

- Georg Potthast is an OFBiz user and does not provide support services

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 29.01.22 um 09:35 schrieb Pierre Smits:

Guten Tag, Herr Brandau,

An dem OFBiz-Project sind mehrere deutsche und europäischen Teilnehmer
beteiligt. Viele davon bieten Unterstützung für die OFBiz-Implementierung,
als unabhängiger Freiberufler order als Angestellter eines Unternehmens.

Teilnehmer aus dem deutschsprachigen Raum sind u.A.:

- Sebastian Leitner (Diginea GmbH)
- Carsten Schinzer (DCS Verkaufssysteme GmbH)
- Georg Potthast
- Ingo Könemann (Wolfix Solutions)

Als Europäische Unternehmen gibt es u.A.:

- Dignea GmbH (Deutschland)
- Ilscipio GmbH (Deutschland)
- ISU GmbH (Deutschland)
- Wolfix Solutions (Österreich)
- Nowhow solutions AG (Schweiz)
- Netdava (Rumänien)

Umfangreiche Teilnehmer- und Firmenübersichten finden Sie unter:

-
https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Contributors
-

https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Service+Providers

Ich vertraue darauf, dass das Obige Ihnen weiter helfen kann.

Aufrichtig,
Met vriendelijke groet,

Pierre Smits

Re: Support/Installation/Customization of OfBiz

[Michael Brohl]

Good evening,

at ecomify, we are providing professional services to customize, 
integrate, support and host Apache OFBiz installations.


I will contact you off-list.

Thanks and regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 28.01.22 um 21:44 schrieb Dr. Thorsten Brandau:

Hi

We are looking for someone helping us to customize ofbiz for our in 
house use including data import from our old system.


Are there any (commercial) service providers in Germany or Europe?

Thank you.

Mit freundlichen Grüßen/Best regards/よろしくお願いします
BRACE GmbH

Dr. Thorsten Brandau

Re: Pass JVM options in ofbizBackground

[Michael Brohl]

Hi,

you should be able to pass JVM arguments using "-PjvmArgs".

This should work: gradlew ofbiz -PjvmArgs="-Xms1024M -Xmx2048M"

This is implemented in build.gradle and README.doc. If this still fails, 
please open a Jira bug issue with detailed description of used version 
and process.


Maybe there is a bug using this together with ofbizBackground.

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 10.01.22 um 16:51 schrieb Bs Serge:

Hi all,

I'm starting OFBIZ in the background but I'm failing to add memory JVM
options using below commands :

./gradlew ofbizBackground -PjvmArgs="-Xms1024m -Xmx11g"
./gradlew -Porg.gradle.jvmargs=-Xmx11g ofbizBackground

Below is the command that ends up getting executed with Xms128M -Xmx1024M
instead of specified -Xms1024m -Xmx11g in the command

java -Xms128M -Xmx1024M -Dfile.encoding=UTF-8 -Duser.country
-Duser.language=en -Duser.variant -cp /var/www/build/libs/ofbiz.jar
org.apache.ofbiz.base.start.Start

I found the above command in htop.

Kindly let me know how to start OFBIZ in the background with JVM options.

Best regards,

Re: Demos off for a small time

[Michael Brohl]

Thanks for all your work, Jacques!

Michael


Am 19.12.21 um 13:13 schrieb Jacques Le Roux:

Le 19/12/2021 à 12:51, Jacques Le Roux a écrit :

Hi,

After fixing Loag4j CVEs , to test all is OK, I restart all demos

Thanks for your patience

Jacques


All is working again

Re: LOG4J vulnerability

[Michael Brohl]

As an addition, the JVM parameter to disable the lookup does not work 
for log4j versions < 2.10.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 14.12.21 um 23:07 schrieb Carsten Schinzer:

Hi,


checking the link to Jacques' commit, indeed this is the preferred
option and OFBiz appears to support the upgrade to log4j 2.15 (contains the
patch).
If for some reason you fall into dependencies with earlier versions of
OFBiz, there also is a mitigation to set a runtime parameter
targeting log4j's JNDI lookup configuration, so you would need to check the
startup script and add this specific parameter.

Hope this helps,
warm regards

Carsten

---


Dr. Carsten Schinzer

*Inhaber*


t +49 89 88569642 | f +49 89 99964059 | m +49 159 05269462

DCS Verkaufssysteme

Gerner Str. 27 | 80638 München | Germany


Am Di., 14. Dez. 2021 um 20:26 Uhr schrieb Benjamin Major <
bma...@demoulasmarketbasket.com>:


My plan is to implement the same changes Jacques made on this commit in my
17.12 instance:


https://github.com/apache/ofbiz-framework/commit/bccf14066cb2ca6fc5861eb457d06a2d0429d00b

Hope this helps,
-Ben

-Original Message-
From: Mo 
Sent: Tuesday, December 14, 2021 1:44 PM
To: user@ofbiz.apache.org
Subject: LOG4J vulnerability

Hi Team,

By now, you have all heard about log4j vulnerability:

https://urldefense.com/v3/__https://unit42.paloaltonetworks.com/apache-log4j-vulnerability-cve-2021-44228/__;!!EJa4QJeSQriN6rihOlMA!nTqxZLfyCLC5vmpcDQg0QH8m6OPkD3pLDQ4w1IoIpI5NVqORyEc0e-0kYC1fAL-JzVb2mwNO$

Do we know how this does impact ofbiz customer installations? And how to
solve?

Many thanks

Mo.

Re: Resources for customization

[Michael Brohl]

Hi Raynhold,

the answers to your questions are highly depending on your processes, 
requirements and how you are using OFBiz in general.


Therefore you won't find in-depth answers in an online documentation, 
book or video, I guess.


If there are side-effects can only be answered having a detailed insight 
in your project, which parts of OFBiz you are using and how etc.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 29.11.21 um 20:24 schrieb Raynhold Schapp:

Hi Jacques,

thank you for the moderation and pardon for the circumstances, I tried to
use an email forwarder to use my own domain.

Yes, I'm aware of some of these books, I know the Packt books for
development and also the first of the Volumes from Len Silverston about the
data model. It's great to get an insight into the model behind OFbiz. I'm
also familiar with " The Big Book of Apache OFBiz Data Model"
https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Diagrams which
is great to look up fast Entities by searching in the PDF-Version.

I'm uncertain about how to approach business processes in OFBiz. Like which
type for a party to use? What consequences will this PartyRole bring? In
which plugin is the role relevant? Are there gonna be side effects?
These are big questions, especially the last one ^^

Am Mo., 29. Nov. 2021 um 18:58 Uhr schrieb Jacques Le Roux <
jacques.le.r...@les7arts.com>:


Hi Raynhold,


Your message has been moderated, else it would not have reached this
Mailing List.

Please subscribe to the user ML for such questions and then use your email
client.
See why here http://ofbiz.apache.org/mailing-lists.html.

You will get a better support, people can answer you on the ML.
The wider the audience the better the answers you might get.

Also it's more work for moderators who have to accept your messages as
long as you have not subscribed.
I'll personally no longer accept them (other moderators still could).

Thanks

This said I guess you are aware of
https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Related+Books ?

Of course you may need more specific information from the community and I
trust you will get.

Jacques

Le 29/11/2021 à 17:43, Raynhold Schapp a écrit :

Hi,
I'm since quite a time active in the development of plugins within Apache
OFBiz. After attending a course on the general basics of enterprise
resource planning systems I got some insights into the structure and use
cases.

Since I want to gather more know-how in the process of customizing and
general usage of OFBiz, I wonder if there are any resources like books,
guides, tutorials, or even case studies to practice and learn.

I'm familiar with the work from Sharan Foga (Getting started with Apache
OFBiz Manufacturing & MRP, Getting Started with Apache OFBiz Accounting).
They are great for the beginning and the dive into OFBiz. The points I'm
missing are the consequences, extensive effects, and implications when
setting specific attributes. For example: using one type instead of the
other.

Regards
Raynhold



Regards
Raynhold

Re: how to import/export data from ofbiz to quickbooks and quickbooks to ofbiz

[Michael Brohl]

Hi Maheshwari,

you'll have to implement a scheduled service which reads the files from 
disk, processes them and archives the successfully processed files.


For the handling of your xls files, have a look at the Apache POI 
framework (https://poi.apache.org/).


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 30.11.21 um 06:51 schrieb Mahi maheshwari:

Hi,

I have a spreadsheet folder that contains xls files in my ofbiz root
directory. I want to import these xls files into ofbiz. this import of
files should be automated every 5 minutes. how can I use recurrence_info,
job_sandbox, recurrence_rule entities for this?

is there any way to import and export data automatically from Quickbooks to
ofbiz and ofbiz to QuickBooks?


Regards,
Maheshwari.

Re: Product and Store Relationship

[Michael Brohl]

Hi,

in addition to the other recommendations, I strongly recommend to have a 
look at the OFBiz data model book which shows the data model in-depth.


See https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Diagrams

There you will see that the products are mapped to the ProductCategory 
through the ProductCategoryMember entity. The category structure is 
build by the productCategoryRollup entities and the top-most category is 
mapped to the ProdCatalog through ProdCatalogCategory and finally the 
ProdCatalog ist mapped to the productStore through ProductStoreCatalog.


While you can reuse categories with different roll-ups, you cannot have 
the SAME category containing other products when used with another 
ProductStore.


You surely can build up a SIMILAR category structure twice and map this 
to the catalog/store to achieve your goal.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 26.10.21 um 18:56 schrieb Bs Serge:

Thank you Jacques for the link,

Kindly, can different stores use the same category structure with different
products, Or do categories have to be created for each store?

Thanks again

Best Regards,


On Tue, Oct 26, 2021 at 1:36 PM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:


Hi Serge,

This is old and in French, but I think it can still help


http://www.les7arts.com/assist/OFBiz/Creation%20Catalogue%20de%20produits.htm#_bookmark_551a190

Jacques

Le 26/10/2021 à 11:48, Bs Serge a écrit :

Lastly and most importantly I'd like to ask,

Can different stores have the same category structure but with different
products?

Best Regards,

On Tue, Oct 26, 2021 at 11:04 AM Bs Serge  wrote:


Hi Giulio,

You have been more than helpful to help me understand this,

Regarding the “Browser Root”, it seems like there are different Product
Category Types  (Best Selling, Catalog, Search, …) which I see defines

the

categories that are directly linked to catalogs in different Product
Catalog Category Types (Browser Root, Promotion, Quick Add, Default

Search)

For Example in the “Demo Catalog”, in its Categories, there is a

category

called “CATALOG1” of Browser Root, and that category is of Product

Category

Type “Catalog”, and I see it act as a parent of two other categories of

Ids

100 and 200 which both are also of Category Type “Catalog”, which goes

on

to create a Tree of categories

Does it mean that the Product Category Type of Catalog is also like a
group of categories per se ,.. ?

If so, one would directly wonder what is the role of other Product
Category Types (Best Selling, Search, Tax, Quick Add, Google Base,
Industry, Internal, ... )?

Thank you again,

Best Regards,

On Mon, Oct 25, 2021 at 7:20 PM Giulio Speri - MpStyle Srl <
giulio.sp...@mpstyle.it> wrote:


Hello Serge,

in OFBiz there is not a direct association between a ProductStore and
products, instead ProdCatalog, ProdCatalogCategory,

ProductStoreCatalog,

ProductCategory and ProductCategoryMember entities are used to achieve
this
goal.

You can see the ProdCatalog as a collector of categories: the one that

is

physically associated with a product store is the ProdCatalog through

the

entity  ProductStoreCatalog.
A product catalog is composed by a hierarchy of categories where the

first

(root category) always has to be of type "Browse Root"

(PCCT_BROWSE_ROOT).

This is managed by the entity ProdCatalogCategory.
Under the "Browse Root" category you can then build your own custom
hierarchy of product categories and associate the product to each one

of

it; ProductCategory is the entity used to define a category and a

product

is associated to a specific category through the entity
ProductCategoryMember.

*In short*:

ProductStore/Catalog assoc : ProductStore -> ProdCatalog ->
ProductCatalogCategory (Browse Root)

Browse Root Category/Product categories:
- ProductCategory (Browse Root)
   -- productCategory_1 -> Products (through ProductCategoryMember);
   -- productCategory_2 -> Products;
   ---productSubCategory_2_1 -> Products;
   ---productSubCategory_2_2 -> Products;
   -- productCategory_3 -> Products;

In the online backend demo of OFBiz you can start following this

structure

from the Catalog Manager -> Stores, pick up a store and then open the

tab

"CATALOGS".
You will find different examples of stores and catalogs with different
categories associated, that can give you a good starting point on the
store/catalog/category/product OOTB mechanism.

I hope I have been helpful.

Kind Regards,
Giulio

Il giorno lun 25 ott 2021 alle ore 16:30 Bs Serge 
Hi,

I was browsing through the catalog module and I could not find any

product

and store relationship.

I would assume products are supposed to belong in a certain store!

Kindly enlighten me on how OFBiz handles products and stores

relationships,

or point me to a link that explains it.

Thanks,

Best Regards,


--
Giulio Speri


*Mp Styl**e Srl*
via 

Re: Detailed OFBiz Accounting Tutorial Available

[Michael Brohl]

Hi Sharan,

that's great, thanks for sharing your valuable work with the community!

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 21.10.21 um 19:10 schrieb Sharan Foga:

Hi All

A while ago I put together a detailed accounting tutorial as an appendix for my 
Getting Started with Apache OFBiz Accounting book. Someone asked me about it 
recently and I have decided to give the tutorial to the project as part of the 
overall documentation. It was written in 2014 so the screenshots will look a 
bit different and some things may have changed but taking a quick look through 
I still think it could be useful to the community.

I have loaded it onto the wiki here https://s.apache.org/a3szr

Happy reading and I hope it helps give people a bit more understanding of the 
accounting setup.

Thanks
Sharan

Re: Use OfBiz features trough REST, SOAP or the like?

[Michael Brohl]

Hi Marius,

no, learning OFBiz is not a bad invest. Both projects have their 
strengths and the same root as on e of the creators of OFBiz is also the 
creator and main developer of Moqui.


You should take a look at both and decide which projects suits you better.

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 17.10.21 um 11:42 schrieb Marius Schmidt:

Hi Hans,

thanks for your reply. That looks awesome but instantly raises the 
question, if learning OfBiz is bad invest if there is Moqui around? Is 
the majority of the OfBiz community moving over to Moqui?


On 17.10.21 10:49, Hans Bakker wrote:

Hi Marius

please have a look at GrowERP: https://github.com/growerp

a Flutter ERP frontend  for Moqui and for an older version also OFBiz 
using the REST interaface.


Everything Open Source: Enjoy!

Regards,

Hans

On 10/17/21 3:10 PM, Marius Schmidt wrote:
Is it out-of-the-box possible to access the whole bunch of 
functionality OfBiz provides via SOAP or REST services or the like? 
If not, would it be an easy journey or a lot to adjust?


We could avoid the whole backend ui adjustments then and use a SPA 
instead

Re: Use OfBiz features trough REST, SOAP or the like?

[Michael Brohl]

Hi Marius,

please have a look at the REST integration plugin.

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de

Am 17.10.21 um 10:10 schrieb Marius Schmidt:
Is it out-of-the-box possible to access the whole bunch of 
functionality OfBiz provides via SOAP or REST services or the like? If 
not, would it be an easy journey or a lot to adjust?


We could avoid the whole backend ui adjustments then and use a SPA 
instead

Re: How to facelift the backend applications

[Michael Brohl]

Hi Marius,

welcome to the project!

The OFBiz backend's philosophy is to "show it all" in regards to the 
comprehensive datamodel and the business processes it contains ootb. 
Therefore nearly every project needs some adjustments to the UI, often 
simplifying the processes and amount of UI elements. OFBiz itself is 
designed to be changed and used as a business process framework.


The newer backend themes are based on Bootstrap already. While it 
strongly depends on how far the modifications should go, you have 
several options:


- use the forms capabilities to hide and reorder fields or change for 
actions


- use the freemarker template engine to design your own templates with 
the power to change the UI in every bit


The UI and the underlying service/database layer are decoupled so if you 
change the UI you don't necessarily have to change the services as long 
as you provide all non-optional data.


To retain upgrade compatibility, you should either write your own 
backend modules or, if you only make minor modifications, mark them as 
mods to easily merge while upgrading.


Happy OFBiz journey,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 17.10.21 um 09:41 schrieb Marius Schmidt:

Hi OfBiz Mailing list,

I am currently in the process of evaluating OfBiz as core system to 
manage our newly founded IT cooperative. I might ask a couple of 
questions over the next days :). Unfortunately some of the reactions I 
got in presenting the backend were exclamations like "Really, but that 
UI looks older than me!", "that will not be fun to work with" or "do 
we have to fill all the fields?"


So after reading half of the partially outdated two OfBiz books on 
Packt, the AsciiDocs I found so far and the quite fragmented 
Confluence parts I am still not sure about this:


What would I need to do, to facelift the backend applications to e.g. 
use Bootstrap as base and hide fields we are not going to need while 
at the same time retain upgrade ability to future releases?


Best regards

Marius

Re: Plugin available check?

[Michael Brohl]

Hi Ingo,

I have no access to the code right now, but have you checked the code 
behind the artifact info in webtools [1] ?


This might give you some hints.

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


[1] https://demo-stable.ofbiz.apache.org/webtools/control/ViewComponents

Am 11.10.21 um 16:21 schrieb Ingo Wolfmayr:

Hi,

is there a recommended Ofbiz-way to check if a plugin is available/installed - 
in Java?

Best regards,
Ingo

Re: Demos seem slow

[Michael Brohl]

Hi Yuresh,

as I can see, Nicolas immediately responded to your first request here 
which was just 2 weeks ago.


He asked for more information to be able to help you, which didn't come. 
What else do you expect from the community?


To unsubscibe, please help yourself: 
https://ofbiz.apache.org/mailing-lists.html


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 07.08.21 um 20:30 schrieb Yuresh Akila:

Hi Jaques,

Please unsubscribe me from this group, if you can.

I dont know about the OFBiz Software, I never got a chance to use it.

But the support of this group is not encouraging, not being selfish, Bit I
tried asking help from here for installing OfBiz on Linux 20.4 since April
14th, while doing what I can trial and error.

Nothing with a positive result. I didnt get to install OfBiz and all the
manuals are useless, as I read them all.

So, Bye.



On Sun, 1 Aug 2021, 14:48 Jacques Le Roux, 
wrote:


Hi,

I'm not sure why yet, the trunk demo crashed w/o understandable reason
this night.
It was a weird Gradle crash for one of our demos (trunk) where Gradle
returned a 137 which seems to mean a memory issue.

Also the demos seem slow this morning. I asked Infra, Daniel said he did
not know about any ongoing issues on OFBiz VM.

So seem just smthg weird external to the ASF (AWS?), will check that
later...

Jacques

Re: Product Feature Content handling

[Michael Brohl]

Hi Guilio,

for custom projects and our OFBiz based plattform we have extended the 
database model and API with ProductFeatureContent and 
ProductFeatureContentyType entities.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 12.07.21 um 13:15 schrieb Giulio Speri - MpStyle Srl:

Hello everyone,

For an ecommerce application my team is configuring some virtual products
with selectable features of type color and size.
  We would like to represent in the product detail page a small image
related to the feature color.
Is there any OOTB support for this?
I checked either the data model, back office services and content screens,
but I did not see too much; only one entity seems to have some relation
with the argument: *ProductFeatureDataResource.*
I was thinking about something like ProductContent/ProductContentType
handling for products.

Did I miss something?

OFBiz version 17.12.06 .

Thanks in advance,
Giulio

Re: The Difference between "Current stable Release ERP" and "Developer Trunk ERP"

[Michael Brohl]

As an addition to Gil's informations: the different layouts you see in 
the demos are caused by the theme selection the last demo user was 
using. You can change the current theme anytime. Both demos should have 
the same themes available.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 21.05.21 um 14:44 schrieb Gil Portenseigne:

Hello,

The developer Trunk version is the trunk development branch with all 
the last new features and improvements.


Every period, a release branch is created and maintained, updated with 
bug/security fix only.


During a stabilization period (about one year), stable release are 
created from this branch and published.


These stable release can be safely used in production environment. So 
in current Stable Release demo you got

all features that were present in trunk in December 2017 (17.12).

HTH

Gil



Le 21/05/2021 à 12:30, AJ.345 a écrit :

Hi,

I have logged in to Apache OFBiz Demo ERPs, and there were two versions.

"The Developer Trunk version" looked more beautiful with the black color
theme, and it was very easy to create options for Business 
transactions and

etc. Overall it looks professional and with an energetic background.

on the other hand the "Current stable release" looks more likely back 
office

look, dull and not very easy to use.

Can you please explain what is the difference between these two 
versions, in

the demo section on the website. what do you recommend from these two
versions as an ERP.

Thank you.
Best Wishes!



--
Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html

Re: Naming convention for identifiers?

[Michael Brohl]

Hi Tomek,

there is no hard convention for naming the identifiers. They are 
alphanumerical and you can choose whatever you like. "Speaking" 
identifiers are mostly from load data which was created by hand.


Identifiers which are generated automatically by delegator.getNextSeqId 
using SequenceValueItem are numerical, starting at 1 by default.


Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 12.04.21 um 08:46 schrieb Tomek:

Hi,

I had reviewed a demo data that loaded by loadAll command of Gradle.
Some parts of the data has id like "GZ-1000" (uper case convention) and
other has id like "admin" (lower case convention) or  "DemoSupplier".
What is the recommended naming conventions for identifiers?

Tomek

Re: Build failure > Ofbiz 17.12.06 in Ubuntu 18.04.5 LTS; Build success > Ofbiz 17.12.06 Windows Server 2016 : RESOLVED

[Michael Brohl]

Hi Girish,

the download of the gradle-wrapper.properties file is deliberately 
removed for the 17.12 release because of inconstistencies in the Gradle 
plugins repository which was necessary to use because of the 
JCenter/Bintray shutdown.


The file is not downloaded and the checksum matches the properties file 
present in our repository.


See 
https://issues.apache.org/jira/browse/OFBIZ-12192?focusedCommentId=17300432=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-17300432 
and following.


Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 25.03.21 um 06:52 schrieb Girish Vasmatkar:

Hi Sakthivel

The ticket you're linking to also dealt with a similar issue related to
wget. Based on your logs, I see two issues but while one is apparent and
reproducible, I am not sure why the download is not happening. I think with
latest changes to the file,  gradle-wrapper.properties file no more
downloaded along with the gradle-wrapper.jar but there is a dependent
action to very checksum which now fails. That needs to be fixed.

Could you try the following and see what happens?

Enable wget debug (wget --debug) and see where wget is failing? Also,
please remove the checksum verification for "
gradle/wrapper/gradle-wrapper.properties" on line 30. Once we figure out
the other issue, I can then fix both at once.

Best,
Girish









On Thu, Mar 25, 2021 at 4:59 AM Sakthivel Vellingiri <
info.integ...@gmail.com> wrote:


Believe i found a resolution and the root cause of the issue, the bottom
line is ./gradle/init-gradle-wrapper.sh does not work with wget [When curl
is not installed],
and throws the below error, however when i installed curl things worked as
expected.
Again below is my environment details where wget failed


*OS Version : Ubuntu 18.04.5 LTS*
*Ofbiz Version - 17.12.06*
*Java Version - openjdk version "1.8.0_282"*

*Result for sudo ./gradle/init-gradle-wrapper.sh when curl was not
installed *
*Not sure if it is related to > *

https://issues.apache.org/jira/browse/OFBIZ-12066?page=com.atlassian.jira.plugin.system.issuetabpanels%3Aall-tabpanel














* === Prepare operation

===/home/clintu3/Downloads/apache-ofbiz-17.12.06/gradle/wrapper/gradle-wrapper.jar
not found, we download it === Download gradle-wrapper.jar
===./gradle/init-gradle-wrapper.sh: 50: ./gradle/init-gradle-wrapper.sh:
[[: not foundDownload files gradle-wrapper.jar from
https://github.com/gradle/gradle/raw/v4.5.1/gradle/wrapper/
<https://github.com/gradle/gradle/raw/v4.5.1/gradle/wrapper/>
failed.Please
check the logs, fix the problem and run the script again. === Control
downloaded files ===shasum: gradle/wrapper/gradle-wrapper.jar:
gradle/wrapper/gradle-wrapper.jar: FAILED open or readshasum:
gradle/wrapper/gradle-wrapper.properties: No such file or
directorygradle/wrapper/gradle-wrapper.properties: FAILED open or
readgradlew: OKshasum: WARNING: 2 listed files could not be read*

*Result for sudo ./gradle/init-gradle-wrapper.sh when curl was installed *
*=== Prepare operation ===*






*/home/clintu3/Downloads/apache-ofbiz-17.12.06/gradle/wrapper/gradle-wrapper.jar
not found, we download it === Download gradle-wrapper.jar === === Control
downloaded files ===gradle/wrapper/gradle-wrapper.jar:
OKgradle/wrapper/gradle-wrapper.properties: OKgradlew: OK*
Cheers

On Tue, Mar 23, 2021 at 6:26 PM Sakthivel Vellingiri <
info.integ...@gmail.com> wrote:


Dug a little further and see the below reference (for metadataSources) in
build.gradle, when i commented the below, i get further along and

download

other dependencies, but as expected and noted in the comment below,

unable

to resolve > org.milyn:flute; it appears linux does not seem to like
metadataSources { artifact() }, Any alternative or pointers appreciated.

  maven {
 // org/milyn/flute/1.3/flute-1.3.jar
 // need artifact only because of wrong pom metadata in maven
central
 url "https://repo1.maven.org/maven2;
 metadataSources {
 artifact()
 }
 }

FAILURE: Build failed with an exception.

* Where:
Build file


'/home/clintu2/Downloads/git/integrin_enterprise/com/integrin/erp/erp-17.12.06/build.gradle'

line: 1161

* What went wrong:
A problem occurred evaluating root project 'ofbiz'.

Could not resolve all dependencies for configuration ':runtime'.

> Could not resolve org.milyn:flute:1.3.
  Required by:
  project : > project :plugins:birt >
org.eclipse.birt.runtime:viewservlets:4.5.0 >
org.eclipse.birt.runtime:org.eclipse.birt.runtime:4.4.1
   > Could not resolve org.milyn:flute:1.3.
  > inconsistent module metadata found. Descriptor:

milyn:flute:1.3

Errors: bad group: expected='org.milyn' found='milyn'
   > Could not resolve org.milyn:flute:1.3.
  > inconsistent module metadata found. Descriptor:

milyn:flute:1.3

Errors: bad group: expected

Re: Fwd: Alerte Google : ofbiz

[Michael Brohl]

I'm pretty sure that this is not the kind of popularity we want to have 
for the project and don't see the funny part of it.


Michael

Am 23.03.21 um 09:47 schrieb Jacques Le Roux:

Hi,

Seems that OFBiz is becoming more popular :)

Have a good day

Jacques

Re: Stable is down since Feb. 28

[Michael Brohl]

Looks like the plugins for 17.12 are not up-to-date on the server

The dependency for org.jasig.cas:cas-server-core was changed 
toorg.apereo.cas:cas-server-support-ldap-core


during the JCenter/Maven Central migration.

Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 09.03.21 um 13:01 schrieb Jacques Le Roux:

Hi,

I just noticed that the stable is down since Feb. 28. I'm relying on 
https://www.montastic.com to check demos availabilities but it's not 
reliable. Unfortunately there is no other free choices.


I checked why this happened and found:

Build file '/home/ofbizDemo/branch17.12/build.gradle' line: 1161

* What went wrong:
A problem occurred evaluating root project 'ofbiz'.
> Could not resolve all files for configuration ':runtime'.
   > Could not resolve org.opensaml:opensaml:1.1b.
 Required by:
 project : > project :plugins:ldap > 
org.jasig.cas:cas-server-core:3.3.5

  > Could not resolve org.opensaml:opensaml:1.1b.
 > Could not get resource 
'https://repo.spring.io/plugins-release/org/opensaml/opensaml/1.1b/opensaml-1.1b.pom'.
    > Could not GET 
'https://repo.spring.io/plugins-release/org/opensaml/opensaml/1.1b/opensaml-1.1b.pom'. 
Received status code 401 from server: Unauthorized

   > Could not resolve org.inspektr:inspektr-core:0.7.0.
 Required by:
 project : > project :plugins:ldap > 
org.jasig.cas:cas-server-core:3.3.5

  > Could not resolve org.inspektr:inspektr-core:0.7.0.
 > Could not get resource 
'https://repo.spring.io/plugins-release/org/inspektr/inspektr-core/0.7.0/inspektr-core-0.7.0.pom'.
    > Could not GET 
'https://repo.spring.io/plugins-release/org/inspektr/inspektr-core/0.7.0/inspektr-core-0.7.0.pom'. 
Received status code 401 from server: Unauthorized


The 2 others demo (trunk and old - R16) are OK. Also R17 (stable) 
works locally.


So we have an issue that exists only for the stable OFBiz demo.

I have created https://issues.apache.org/jira/browse/INFRA-21543 for that

Jacques

Re: OFBiz REST implementation session #2 (10/07/2020)

[Michael Brohl]

Hi Girish,

can you give us a resume about the state of the REST plugin 
implementation? Haven't heard about it in a while.


One specific question: does the implementation support getting 
ressources "the REST way" like


   GET https://domain.tld/rest/services/getProduct/1

instead of

   GET https://domain.tld/rest/services/getProduct?productId=1

?

Or, even better

   GET https://domain.tld/rest/product/1

?

Thanks for an update,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 06.10.20 um 16:15 schrieb Girish Vasmatkar:

Hi All

Please note the meeting details for tomorrow's session -

Topic: REST Session #2
Time: Oct 7, 2020 04:00 PM Mumbai, Kolkata, New Delhi, 12:30 PM CET

Join Zoom Meeting
https://us04web.zoom.us/j/2504311919?pwd=WHpkS2pCOEVNRi85Znczc2lMeHYvQT09

Meeting ID: 250 431 1919
Passcode: 4jmxz0

I have also prepared a POSTMAN collection
<https://www.postman.com/collection/> with API request examples that I'll
be walking you through. You can import it on your local workspace. Please
follow the link below.

https://www.getpostman.com/collections/5ef56c4f090b715112bc

Best,
Girish

On Wed, Sep 30, 2020 at 9:07 PM Girish Vasmatkar <
girish.vasmat...@hotwaxsystems.com> wrote:


Hi Everyone!

Please find details of the next session I am planning to hold on OFBiz
REST implementation. This will have some hands-on examples that will help
everyone using it.

Date :  10/07/2020
Time :  4 PM IST, 12:30 PM CET
Meeting URL : TBD, I will send the invite link the day before.
Agenda :

1. Preconfigured Resources (Resources that come OTB)

-

Authentication Token Generating Resource (How to invoke and example
usage)
-

   POST /auth/token
   -

Exportable Services Resource (How to call services with export=true
via REST interface with example usage)
-

   GET | POST | PUT | DELETE | PATCH /services/{serviceName}
   -

   GET vs POST service in parameters difference. How to invoke service
   defined as GET vs POST | POST | PATCH.
   -

OpenAPI Resource
-

   GET /openapi.json
   -

   GET /openapi.yaml
   -

WADL Resource (WADL is to REST as  WSDL is to SOAP)
-

   GET /application.wadl

2.  Standard API responses supported for various use cases (with examples)
and how to interpret them.

-

HTTP 200 OK
-

HTTP 400 Bad Request
-

HTTP 401 Unauthorized
-

HTTP 403 Forbidden
-

HTTP 422 Unprocessable Entity
-

HTTP 405 Method Not Allowed
-

HTTP 406 Not Acceptable
-

HTTP 415 Unsupported Media Type

3. Content Negotiation (JSON)

-

Accept : application/json
-

Content-Type : application/json

4. Q session

Best,
Girish Vasmatkar

Re: Can't have same invoiceID for invoices created in different years

[Michael Brohl]

Hi Andrei,

if you load data through XML files, there is no application logic in 
play. It's a plain import to the database.


So if you load invoices with the same invoice id (which is the primary 
key for the invoice table), the second dataset will overwrite the first.


The mentioned setting will not help with the problem during import. 
Because of the primary key, you cannot have the same invoice id twice so 
*I guess* the setting will generate an invoice id with the year and id 
(like 2021-1 or similar). But I'm not sure though...


Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 20.02.21 um 09:48 schrieb Andrei Stan:

Hello everyone,

I want to import some of my old invoices into ofbiz, and some of those 
invoices have


the same id, but were created in different time periods, different years.

So, for example, i have *EU-1 *created in 2019**and *EU-1 *created in 
2020.


When importing the xml file with data for company, invoices etc., only 
one of those two duplicates is imported, without erros from ofbiz's side.


Have anybody tried this in the Accounting Preferences by set the *Old 
Invoice Sequence Enum ID *to *Restart on Fiscal Year (no gaps, per 
org, reset to one each year) *??


Thank you,

A.

Re: System error, could not commit transaction XAException (null) on resuming transaction

[Michael Brohl]

Hi Giulio,

are there any other ressources in play except OFBiz and a direct 
connection to the MariaDB database? Like another database for e.g. audit 
data or else being part of the XA transaction?


It seems that one of the participants of the transaction does not 
respond during the two phase commit. Have you checked timeout settings 
for the connection pool?


That's plain guessing without having the code and environment visible so 
please excuse if it goes in the wrong direction.


Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 20.02.21 um 19:43 schrieb Giulio Speri - MpStyle Srl:

Hello Michael,

I tried to increase a larger timeout on the parent transaction on the
parent transaction, but the result was the same, but I could debug a little
bit more the service, and the error is raised in the method commit() of
TransactionUtil and searching between all the debug objects I found a
detail message of the Exception that states "*error during phase two commit*",
that is related to XA resources.

I keep investigating and I will keep you up to date.

Giulio



Il giorno ven 19 feb 2021 alle ore 23:46 Giulio Speri - MpStyle Srl <
giulio.sp...@mpstyle.it> ha scritto:


Hello Michael,

thank You for the reply, I will check it for sure.
But this bring me another question: if the parent transaction timeout is
low, when I resume it, shouldn't it fail with a "Error committing
transaction: Transaction has timed out" error? I would expect it.

Giulio

On Thu, Feb 18, 2021, 23:49 Michael Brohl 
wrote:


Hi Giulio,

have you checked that the transaction timeout is set high enough for the
parent transaction?

Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 17.02.21 um 01:08 schrieb Giulio Speri - MpStyle Srl:

Hello everyone,

I hope you are all doing well.

I write because I am facing an exception not so clear to me while

writing a

Java service.
In this service I am using a paged list (EntityUtil.getPagedList(..))

with

an iterator object retrieved using delegator.find(..) method, to process
and delete a lot of records.
Since the records in the target table are several hundreds of

thousands, to

avoid loading everything in RAM (using for example a findList method), I
suspend the "service" transaction, start internally a new transaction,
process and commit each page, and at the end I resume the parent
transaction.
I build pages of 1000 records each and I loop
(start_transaction-process_data-commit) all the pages.

In short the service structure is:

1.iterator <- delegator.find("ShoppingList",...)
2.suspend-parent-transaction
3.paginatedList <- EntityUtil.getPaginatedList(iterator,page1,1000)
4.while(page <= totPages):
4.a)start new transaction;
4.b)nextPage -> EntityUtil.getPagedList(iterator, page+1,1000)
4.c)delete data;
4.d) commit trx
5.finally:
5.a)close the iterator;
*5.b)resume parent trx;*

If the number of pages are not too high (for example 100) the service

run

just fine, but if the number of pages is higher (for example I tested

the

service with 269 pages), it commits everything as expected, but when it
tries to resume the parent transaction (step *5.b*), the following
exception is thrown:

org.ofbiz.entity.transaction.GenericTransactionException: System error,

could not commit transaction: javax.transaction.xa.XAException (null)
at


org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:304)

~[ofbiz-entity-test.jar:?]
at


org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:252)

~[ofbiz-entity-test.jar:?]
at

org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:546)

[ofbiz-service.jar:?]
at

org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:232)

[ofbiz-service.jar:?]

...
...


Caused by: javax.transaction.xa.XAException
at


org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.commit(LocalXAConnectionFactory.java:214)

~[commons-dbcp-1.4.jar:1.4]
at


org.apache.geronimo.transaction.manager.TransactionImpl.commitResource(TransactionImpl.java:622)

~[geronimo-transaction-3.1.1.jar:3.1.1]
at


org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:305)

~[geronimo-transaction-3.1.1.jar:3.1.1]
at


org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252)

~[geronimo-transaction-3.1.1.jar:3.1.1]
at


org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:266)

~[ofbiz-entity-test.jar:?]
... 37 more
Caused by: java.sql.SQLNonTransientConnectionException: Could not send
query: Connection reset
at


org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:125)

~[mariadb-java-client-1.5.4.jar:?]

...
...


Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Could not
send query: Connection reset
at


org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(Abstra

Re: Add CSS/JS to backend theme from plugin

[Michael Brohl]

Hi Ingo,

I see. You want the theme to "visit" every plugin to pick up ressources 
which are meant to enhance the theme, right?


Thats interesting but - to my knowledge - not implemented or possible to 
achieve OOTB. Sounds like a feature worth thinking about though.


Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 17.02.21 um 09:17 schrieb Ingo Wolfmayr:

:) That’s how I do it right now and it works - that’s fine.

Imagine I want to make the plugin availabe to the community. How will I do that? Upload 
the plugin + theme override? I made friends with the idea of using "portlets" 
for application dashboards. Defining them in one place and show them on different 
places/applications. Makes a few things easier to deliver custumizations to my customers. 
In my current case I need additional JS/CSS files required by some portlets.

Nevertheless I guess I have to use the theme override solutions right now.

Thanks for your time!!!

Best Regards,
Ingo

-Ursprüngliche Nachricht-
Von: Michael Brohl 
Gesendet: Dienstag, 16. Februar 2021 20:11
An: user@ofbiz.apache.org
Betreff: Re: Add CSS/JS to backend theme from plugin

But... your plugin is a component as well, right? Just reference it like I 
showed below.

Your plugin's ofbiz-component.xml starts with

    

in your Theme.xml

All out of my mind but I think this should work. Did I miss something?

Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 16.02.21 um 19:52 schrieb Ingo Wolfmayr:

Hi Michael,

that’s what I already did - and yes it works. I am looking for a way to add js/css files 
to the plugin and make it available in other application. Saying: "Common-theme here 
are some additional files"

Something like:

  

I have a plugin that provides two files - one css and one js. I would have to 
create, role-out and maintain the additionial theme just for the purpose of 
providing two files.

Best regards,
Ingo

-Ursprüngliche Nachricht-
Von: Michael Brohl 
Gesendet: Dienstag, 16. Februar 2021 18:52
An: user@ofbiz.apache.org
Betreff: Re: Add CSS/JS to backend theme from plugin

Hi Ingo,

I'm not sure if I understand correctly, but you should be able to assign 
ressources through a component reference.

Have you tried to use





in your Theme.xml? This works OOTB with ftl files, should also work with 
JavaScript, no?

HTH,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 16.02.21 um 17:44 schrieb Ingo Wolfmayr:

Hi Aditya,

I already create my own theme by extending an existing one. It works but I feel 
quite uncomfortable by creating a new theme for the purpose of adding a single 
.js file to an existing theme. I was hoping there would be a better solution 
and handle those things via the plugin.

Thanks,
Ingo

-Ursprüngliche Nachricht-
Von: Aditya Sharma 
Gesendet: Dienstag, 16. Februar 2021 16:04
An: user@ofbiz.apache.org
Betreff: Re: Add CSS/JS to backend theme from plugin

Hi Ingo,

You may refer to documentation in themes.adoc[1]. Though I am not
sure if this is the right solution, maybe you can create your own
theme extending the existing one[2]

HTH

1.
https://github.com/apache/ofbiz-framework/blob/trunk/themes/docs/them
e
s.adoc
2.
https://github.com/apache/ofbiz-framework/blob/trunk/themes/docs/them
e
s.adoc#extends-common-theme

Thanks and regards,
Aditya Sharma

On Tue, Feb 16, 2021 at 5:58 PM Ingo Wolfmayr

wrote:


Hi everybody,

is it possible to add a javascript/css from an addon to an existing
backend theme.

Case: I have created a plugin that provides various reports via portlets.
Now I want to use the portlet logic to show those reports on
different places like accounting, catalog a.s.o. Therefore I want
the necessary JS/CSS files loaded for the whole theme - not for the plugin only.

Long time ago I would have added those scripts via
VisualThemeResource
:) If possible I do not want to touch the original theme and I want
to avoid creating a new plugin just for the purpose of providing those filed.

Every idea would be highly appreciated.

Best regards,
Ingo

Re: System error, could not commit transaction XAException (null) on resuming transaction

[Michael Brohl]

Hi Giulio,

have you checked that the transaction timeout is set high enough for the 
parent transaction?


Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 17.02.21 um 01:08 schrieb Giulio Speri - MpStyle Srl:

Hello everyone,

I hope you are all doing well.

I write because I am facing an exception not so clear to me while writing a
Java service.
In this service I am using a paged list (EntityUtil.getPagedList(..)) with
an iterator object retrieved using delegator.find(..) method, to process
and delete a lot of records.
Since the records in the target table are several hundreds of thousands, to
avoid loading everything in RAM (using for example a findList method), I
suspend the "service" transaction, start internally a new transaction,
process and commit each page, and at the end I resume the parent
transaction.
I build pages of 1000 records each and I loop
(start_transaction-process_data-commit) all the pages.

In short the service structure is:

1.iterator <- delegator.find("ShoppingList",...)
2.suspend-parent-transaction
3.paginatedList <- EntityUtil.getPaginatedList(iterator,page1,1000)
4.while(page <= totPages):
4.a)start new transaction;
4.b)nextPage -> EntityUtil.getPagedList(iterator, page+1,1000)
4.c)delete data;
4.d) commit trx
5.finally:
5.a)close the iterator;
*5.b)resume parent trx;*

If the number of pages are not too high (for example 100) the service run
just fine, but if the number of pages is higher (for example I tested the
service with 269 pages), it commits everything as expected, but when it
tries to resume the parent transaction (step *5.b*), the following
exception is thrown:

org.ofbiz.entity.transaction.GenericTransactionException: System error,

could not commit transaction: javax.transaction.xa.XAException (null)
at
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:304)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:252)
~[ofbiz-entity-test.jar:?]
at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:546)
[ofbiz-service.jar:?]
at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:232)
[ofbiz-service.jar:?]

...
...


Caused by: javax.transaction.xa.XAException
at
org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.commit(LocalXAConnectionFactory.java:214)
~[commons-dbcp-1.4.jar:1.4]
at
org.apache.geronimo.transaction.manager.TransactionImpl.commitResource(TransactionImpl.java:622)
~[geronimo-transaction-3.1.1.jar:3.1.1]
at
org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:305)
~[geronimo-transaction-3.1.1.jar:3.1.1]
at
org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252)
~[geronimo-transaction-3.1.1.jar:3.1.1]
at
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:266)
~[ofbiz-entity-test.jar:?]
... 37 more
Caused by: java.sql.SQLNonTransientConnectionException: Could not send
query: Connection reset
at
org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:125)
~[mariadb-java-client-1.5.4.jar:?]

...
...


Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Could not
send query: Connection reset
at
org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:144)
~[mariadb-java-client-1.5.4.jar:?]
at
org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:251)
~[mariadb-java-client-1.5.4.jar:?]
at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:273)
~[mariadb-java-client-1.5.4.jar:?]
at org.mariadb.jdbc.MariaDbConnection.commit(MariaDbConnection.java:598)
~[mariadb-java-client-1.5.4.jar:?]
at
org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.commit(LocalXAConnectionFactory.java:211)
~[commons-dbcp-1.4.jar:1.4]
at
org.apache.geronimo.transaction.manager.TransactionImpl.commitResource(TransactionImpl.java:622)
~[geronimo-transaction-3.1.1.jar:3.1.1]
at
org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:305)
~[geronimo-transaction-3.1.1.jar:3.1.1]
at
org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252)
~[geronimo-transaction-3.1.1.jar:3.1.1]
at
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:266)
~[ofbiz-entity-test.jar:?]
... 37 more
Caused by: java.net.SocketException: Connection reset
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
~[?:1.8.0_102]
at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
~[?:1.8.0_102]
at
org.mariadb.jdbc.internal.stream.PacketOutputStream.send(PacketOutputStream.java:933)
~[mariadb-java-client-1.5.4.jar:?]


I did some research and I found that some tuning on MariaDB timeouts could
solve the issue (or move it later if number records are higher), but I
already wrote services that stop the parent transaction to 

Re: Add CSS/JS to backend theme from plugin

[Michael Brohl]

But... your plugin is a component as well, right? Just reference it like 
I showed below.


Your plugin's ofbiz-component.xml starts with

    value="component://my-plugin/vendors/myscript.js" />


in your Theme.xml

All out of my mind but I think this should work. Did I miss something?

Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 16.02.21 um 19:52 schrieb Ingo Wolfmayr:

Hi Michael,

that’s what I already did - and yes it works. I am looking for a way to add js/css files 
to the plugin and make it available in other application. Saying: "Common-theme here 
are some additional files"

Something like:

 

I have a plugin that provides two files - one css and one js. I would have to 
create, role-out and maintain the additionial theme just for the purpose of 
providing two files.

Best regards,
Ingo

-Ursprüngliche Nachricht-
Von: Michael Brohl 
Gesendet: Dienstag, 16. Februar 2021 18:52
An: user@ofbiz.apache.org
Betreff: Re: Add CSS/JS to backend theme from plugin

Hi Ingo,

I'm not sure if I understand correctly, but you should be able to assign 
ressources through a component reference.

Have you tried to use





in your Theme.xml? This works OOTB with ftl files, should also work with 
JavaScript, no?

HTH,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 16.02.21 um 17:44 schrieb Ingo Wolfmayr:

Hi Aditya,

I already create my own theme by extending an existing one. It works but I feel 
quite uncomfortable by creating a new theme for the purpose of adding a single 
.js file to an existing theme. I was hoping there would be a better solution 
and handle those things via the plugin.

Thanks,
Ingo

-Ursprüngliche Nachricht-
Von: Aditya Sharma 
Gesendet: Dienstag, 16. Februar 2021 16:04
An: user@ofbiz.apache.org
Betreff: Re: Add CSS/JS to backend theme from plugin

Hi Ingo,

You may refer to documentation in themes.adoc[1]. Though I am not sure
if this is the right solution, maybe you can create your own theme
extending the existing one[2]

HTH

1.
https://github.com/apache/ofbiz-framework/blob/trunk/themes/docs/theme
s.adoc
2.
https://github.com/apache/ofbiz-framework/blob/trunk/themes/docs/theme
s.adoc#extends-common-theme

Thanks and regards,
Aditya Sharma

On Tue, Feb 16, 2021 at 5:58 PM Ingo Wolfmayr

wrote:


Hi everybody,

is it possible to add a javascript/css from an addon to an existing
backend theme.

Case: I have created a plugin that provides various reports via portlets.
Now I want to use the portlet logic to show those reports on
different places like accounting, catalog a.s.o. Therefore I want the
necessary JS/CSS files loaded for the whole theme - not for the plugin only.

Long time ago I would have added those scripts via
VisualThemeResource
:) If possible I do not want to touch the original theme and I want
to avoid creating a new plugin just for the purpose of providing those filed.

Every idea would be highly appreciated.

Best regards,
Ingo

Re: Add CSS/JS to backend theme from plugin

[Michael Brohl]

Hi Ingo,

I'm not sure if I understand correctly, but you should be able to assign 
ressources through a component reference.


Have you tried to use

value="component://my-component/vendors/myspecialscript.js" />


value="/my-theme/vendors/myscript.js" />


in your Theme.xml? This works OOTB with ftl files, should also work with 
JavaScript, no?


HTH,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 16.02.21 um 17:44 schrieb Ingo Wolfmayr:

Hi Aditya,

I already create my own theme by extending an existing one. It works but I feel 
quite uncomfortable by creating a new theme for the purpose of adding a single 
.js file to an existing theme. I was hoping there would be a better solution 
and handle those things via the plugin.

Thanks,
Ingo

-Ursprüngliche Nachricht-
Von: Aditya Sharma 
Gesendet: Dienstag, 16. Februar 2021 16:04
An: user@ofbiz.apache.org
Betreff: Re: Add CSS/JS to backend theme from plugin

Hi Ingo,

You may refer to documentation in themes.adoc[1]. Though I am not sure if this 
is the right solution, maybe you can create your own theme extending the 
existing one[2]

HTH

1.
https://github.com/apache/ofbiz-framework/blob/trunk/themes/docs/themes.adoc
2.
https://github.com/apache/ofbiz-framework/blob/trunk/themes/docs/themes.adoc#extends-common-theme

Thanks and regards,
Aditya Sharma

On Tue, Feb 16, 2021 at 5:58 PM Ingo Wolfmayr 
wrote:


Hi everybody,

is it possible to add a javascript/css from an addon to an existing
backend theme.

Case: I have created a plugin that provides various reports via portlets.
Now I want to use the portlet logic to show those reports on different
places like accounting, catalog a.s.o. Therefore I want the necessary
JS/CSS files loaded for the whole theme - not for the plugin only.

Long time ago I would have added those scripts via VisualThemeResource
:) If possible I do not want to touch the original theme and I want to
avoid creating a new plugin just for the purpose of providing those filed.

Every idea would be highly appreciated.

Best regards,
Ingo

Re: How to get a service call stack?

[Michael Brohl]

Hi Danny,

in such a case, I would simply search the codebase for the service name 
to see where it is referenced.


In most cases, an eeca or seca is the cause for unexpected high 
frequency service calls.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 05.02.21 um 11:58 schrieb Danny Trunk:

Hi Girish,

I already put this into the service wrapper method right before the runSync 
call (dumpedStack is a static AtomicBoolean):

if (!dumpedStack.getAndSet(true)) {
log.warn("Stack trace:\n{}", 
Arrays.stream(Thread.currentThread().getStackTrace()).map(StackTraceElement::toString).collect(Collectors.joining("\\n")));
}

But that's not really helpful because the information included doesn't contain 
service names and I don't think async service calls will be respected with that 
approach.


Girish Vasmatkar  hat am 05.02.2021 11:08 
geschrieben:

  
Hi Danny,


While this feature isn't available, you can just put a try catch (in the
service you think is getting called too much). In the try block, throw an
exception and in the catch just do printStackTrace(), you will get to know
where that service is getting called from.

This is of course an ugly solution but works especially if you're in the
development phase. That said, it would be a nice feature to have the
DispatchContext have information about current execution context.

Best Regards,
Girish





On Fri, Feb 5, 2021 at 1:08 PM Danny Trunk  wrote:


Hi Deepak Dixit,

the use case is debugging. There's a service getting called a lot and I
can't find the origin while checking all the servicedef/entitydef XMLs. And
I think it's quite useful to have such a feature.

Kind regards
Danny.


Deepak Dixit  hat am 04.02.2021 18:19

geschrieben:


Hi Danny Trunk,

Could you please share the use case why you need a service call stack?

If you share the use case it may be possible you will get a better

answer.

Kind Regards,
Deepak Dixit
DIRECTOR OF PRODUCT ENGINEERING
mobile: +91 9826754548
email: deepak.di...@hotwax.co
*www.hotwax.co <http://www.hotwax.co/>*


On Thu, Feb 4, 2021 at 8:40 PM Danny Trunk  wrote:


Hello,

let's imagine Service A is calling Service B directly through
dispatcher.runSync and Service C is running as an SECA action of

Service B.

The call stack would be: Service A -> Service B -> Service C (through

SECA)

Or let's imagine Service D is running as an EECA action of entity

Product.

The call stack would be: Product Entity -> Service D (through EECA)

Is it possible to get that information somehow?
I can't find anything helpful in DispatchContext or GenericDispatcher.

Output into a log file would be great.

Kind regards
Danny.


ZYRES digital media systems GmbH
Stuttgarter Straße 25 60329 Frankfurt am Main Phone +49 69 98 55 99 - 0
Fax +49 69 98 55 99 - 11

Firmensitz: Stuttgarter Straße 25 60329 Frankfurt am Main
Registergericht: Amtsgericht Frankfurt am Main, HRB 76374
Geschäftsführer: Sebastian Schirmer

http://www.zyres.com/


ZYRES digital media systems GmbH
Stuttgarter Straße 25 60329 Frankfurt am Main Phone +49 69 98 55 99 - 0
Fax +49 69 98 55 99 - 11

Firmensitz: Stuttgarter Straße 25 60329 Frankfurt am Main
Registergericht: Amtsgericht Frankfurt am Main, HRB 76374
Geschäftsführer: Sebastian Schirmer

http://www.zyres.com/

Re: How to create a new facility in Apache Ofbiz 17.12.05?

[Michael Brohl]

Hi,

it seems that the fix was made in trunk and only backported to 18.12., 
not 17.12.


We just released the last version of the 17.12 release so there will not 
be another bugfix release for it.


You can either switch to 18.12 (no release, just checkout from GitHub) 
or try to apply the patch from the Jira issue to your 17.12 release.


Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 03.02.21 um 09:10 schrieb Vy Do:

(1) I am using Apache Ofbiz 17.12.05 (release version). I download at
https://downloads.apache.org/ofbiz/apache-ofbiz-17.12.05.zip No button for
creating new facility (as you see in the screenshot).

(2) I run demo site at
https://demo-trunk.ofbiz.apache.org/facility/control/EditFacility , the
error is resolved.

(3) I confirm that this issue
https://issues.apache.org/jira/browse/OFBIZ-10501 closed is true.

Thank you.

On Wed, Feb 3, 2021 at 2:12 PM Pritam Kute 
wrote:


Which OFBiz version you are using? I can see that this issue is fixed on
trunk.

https://demo-trunk.ofbiz.apache.org/facility/control/FindFacility

You might be interested to look into the following JIRA ticket.

https://issues.apache.org/jira/browse/OFBIZ-10501

Kind Regards,
--
Pritam Kute


On Wed, Feb 3, 2021 at 12:30 PM Vy Do  wrote:


Yes, it is an error, GUI have no button or text link for creating/add new
facility. Then I found a way, access this feature by go to URL directly:
https://localhost:8443/facility/control/CreateFacility

Please create an issue ticket on JIRA, today, I tried reset password

JIRA,

but I still don't receive email for reset password.

My screenshot for temporary solution:



https://user-images.githubusercontent.com/74403808/106710147-0c899400-6628-11eb-8b00-ac6f57208b58.png

On Wed, Feb 3, 2021 at 1:57 PM Pawan Verma  wrote:


Hi Vy Do,

Is there any error? Please share it with us.
--
Thanks & Regards
Pawan Verma
ofbiz.apache.org


On Wed, Feb 3, 2021 at 9:59 AM Vy Do  wrote:


I am using Apache Ofbiz 17.12.05 , I load all seed, demo data, login

by

user admin, password ofbiz. I can create new party group, create new
facility group, v.v.. But I cannot create a new facility.

Please guide me this task.

Few screenshot:



https://user-images.githubusercontent.com/74403808/106698117-bc540700-6612-11eb-8079-82f09b21a007.png




https://user-images.githubusercontent.com/74403808/106698189-e4dc0100-6612-11eb-8070-a83494a245e6.png

Thanks!

Re: OFBiz Community Days - November 2020

[Michael Brohl]

You can simply continue with your email instead of choosing Google.

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 27.11.20 um 12:19 schrieb Georg Potthast 2:

At least I cannot successfully open an account on Slack. When I selected "Access 
with Google" as offered on the screen, I was asked if I would allow to provide 
access to my data to Slack and after I answered yes, I was presented with a drop-down 
list with all my email addresses to choose from.


Michael Brohl  hat am 27.11.2020 08:24 geschrieben:

  
Good morning Georg,


there are several people on the #ofbiz Slack channel with mail addresses
other than @apache.org so this should work.

What makes you think that Slack will read all your email contacts then?
I am pretty sure that this can be switched off for data protection reasons.

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 27.11.20 um 08:07 schrieb Georg Potthast:

Devanshu,

I tried to get an account with Slack to join the room as you
mentioned. However, I can only create an account with an email address
that ends with @apache.org. When I try to get an account with Google
instead, it apparently reads all my email addresses from my PC. But
following that I cannot use one of these because I have no @apache.org
email address.

Georg

-Ursprüngliche Nachricht- From: Devanshu Vyas
Sent: Saturday, November 21, 2020 2:18 PM
To: user@ofbiz.apache.org
Subject: OFBiz Community Days - November 2020

Hello all,

We are back with OFBiz Community Days, hope you are excited too! :-)
The community days are organized once per quarter so a total of four(4)
events throughout the year.

We are having a sequence of 5 days that form the Community Days. This
extends the time frame and gives people more flexibility to contribute.
So, this month our Community Days will be from *27th November – 1st
December 2020*.

If you are new to the concept of Community Days then please take a
look at
the following wiki pages:
https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Community+Days
https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Community+Days+Dates


This is such an event where anyone can participate (and we would like to
encourage as many people as possible to do so)

If there is an OFBiz task or particular area that you would like to
work on
then please see if you can set aside some time over the next few days
to do
it. (Even an hour will help!)

Remember that you do not have to work on it alone, our Community Days are
also a chance to collaborate with others in the community.

Our Community Days are not only coding related, but we would also like to
do some tidy up of our wiki and our project documentation.

*Testing, Review and Committing Patches*
Testing and applying patches is always an important area. Many
contributors
from the community have provided patches for bugs and improvements but
before committing them we need to test to them.

Patches can become out of date very quickly meaning that if they are not
tested early enough then they can miss out on being included. We have a
large number of patches available so this could be a good opportunity for
test, review and commit.

*Documentation*
We know that our current documentation could be a whole lot better so any
contribution that helps us improve it is welcome.

*Jira Sprint*
I will create a Jira sprint "OFBiz Community Day (November 2020)" so
please
add any Jira tasks when you are working on it.
This Jira Sprint helps us track and report on the work done during the
Community Days so please try to make sure your work is included.
To set the sprint on an existing issue, simply click on the "Edit" option
on the issue and select the sprint field.

We should add the Sprint in all the cases:
1.) If we create a ticket we should add it.
2.) If we start working on an existing ticket (adding patch or closing it
after a commit) we should add sprint if it is missing.

Basically adding Sprint will make sure the contribution will be
counted in
OFBiz community days event, which is from 27th November – 1st December.
At the end of November's OFBiz Community day i.e. after 1st December,
this
will help us in reporting.

*OFBiz Slack Channel*
If you haven't already taken a look, our OFBiz Slack channel is available
all the time but can be especially useful when collaborating during our
Community Days event. Please join our room using the link below:
https://s.apache.org/ofbiz-slack-channel

To chat with users and developers of Apache OFBiz. Please create a Slack
account using this invite link <https://s.apache.org/slack-invite> and
join
the *#ofbiz channel*. <https://s.apache.org/ofbiz-slack-channel>
Please do
*not* ask OFBiz questions/discussion in the #general channel.

Let's all collaborate to improve OFBiz, have fun and enjoy working
together.

Thanks & Regards,
Devanshu Vyas.




smime.p7s
Description: S/MIME Cryptographic Signature

Re: OFBiz Community Days - November 2020

[Michael Brohl]

Good morning Georg,

there are several people on the #ofbiz Slack channel with mail addresses 
other than @apache.org so this should work.


What makes you think that Slack will read all your email contacts then? 
I am pretty sure that this can be switched off for data protection reasons.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 27.11.20 um 08:07 schrieb Georg Potthast:

Devanshu,

I tried to get an account with Slack to join the room as you 
mentioned. However, I can only create an account with an email address 
that ends with @apache.org. When I try to get an account with Google 
instead, it apparently reads all my email addresses from my PC. But 
following that I cannot use one of these because I have no @apache.org 
email address.


Georg

-Ursprüngliche Nachricht- From: Devanshu Vyas
Sent: Saturday, November 21, 2020 2:18 PM
To: user@ofbiz.apache.org
Subject: OFBiz Community Days - November 2020

Hello all,

We are back with OFBiz Community Days, hope you are excited too! :-)
The community days are organized once per quarter so a total of four(4)
events throughout the year.

We are having a sequence of 5 days that form the Community Days. This
extends the time frame and gives people more flexibility to contribute.
So, this month our Community Days will be from *27th November – 1st
December 2020*.

If you are new to the concept of Community Days then please take a 
look at

the following wiki pages:
https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Community+Days
https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Community+Days+Dates 



This is such an event where anyone can participate (and we would like to
encourage as many people as possible to do so)

If there is an OFBiz task or particular area that you would like to 
work on
then please see if you can set aside some time over the next few days 
to do

it. (Even an hour will help!)

Remember that you do not have to work on it alone, our Community Days are
also a chance to collaborate with others in the community.

Our Community Days are not only coding related, but we would also like to
do some tidy up of our wiki and our project documentation.

*Testing, Review and Committing Patches*
Testing and applying patches is always an important area. Many 
contributors

from the community have provided patches for bugs and improvements but
before committing them we need to test to them.

Patches can become out of date very quickly meaning that if they are not
tested early enough then they can miss out on being included. We have a
large number of patches available so this could be a good opportunity for
test, review and commit.

*Documentation*
We know that our current documentation could be a whole lot better so any
contribution that helps us improve it is welcome.

*Jira Sprint*
I will create a Jira sprint "OFBiz Community Day (November 2020)" so 
please

add any Jira tasks when you are working on it.
This Jira Sprint helps us track and report on the work done during the
Community Days so please try to make sure your work is included.
To set the sprint on an existing issue, simply click on the "Edit" option
on the issue and select the sprint field.

We should add the Sprint in all the cases:
1.) If we create a ticket we should add it.
2.) If we start working on an existing ticket (adding patch or closing it
after a commit) we should add sprint if it is missing.

Basically adding Sprint will make sure the contribution will be 
counted in

OFBiz community days event, which is from 27th November – 1st December.
At the end of November's OFBiz Community day i.e. after 1st December, 
this

will help us in reporting.

*OFBiz Slack Channel*
If you haven't already taken a look, our OFBiz Slack channel is available
all the time but can be especially useful when collaborating during our
Community Days event. Please join our room using the link below:
https://s.apache.org/ofbiz-slack-channel

To chat with users and developers of Apache OFBiz. Please create a Slack
account using this invite link <https://s.apache.org/slack-invite> and 
join
the *#ofbiz channel*. <https://s.apache.org/ofbiz-slack-channel> 
Please do

*not* ask OFBiz questions/discussion in the #general channel.

Let's all collaborate to improve OFBiz, have fun and enjoy working 
together.


Thanks & Regards,
Devanshu Vyas.




smime.p7s
Description: S/MIME Cryptographic Signature

Re: How to return to a previous plugin version?

[Michael Brohl]

Additionally, I'd recommend putting a component-load.xml in the plugins 
directory where you can specify which plugin(s) should be loaded and in 
which order.


For a quick change, simply comment out the plugins you do not need and 
restart ofbiz.


component-load.xml

http://www.w3.org/2001/XMLSchema-instance;
xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/component-loader.xsd;>
    
    
   


You should be able to see the loading of your plugin(s) in the log like 
this:


2020-11-02 14:56:23,028 |main |CatalinaContainer |I| 
Creating context [mytest]



Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 02.11.20 um 07:19 schrieb Aditya Sharma:

Hi Georg,

What I suspect with a cursory reading is as you made a replica the values
of mount point etc may be the same
https://github.com/apache/ofbiz-plugins/blob/trunk/ecommerce/ofbiz-component.xml#L55

As you are new to OFBiz, I would recommend using the Gradle task to create
a new plugin instead of replicating it.

if you just want to play with it with various versions of same plugin. I
would recommend you is to initialise plugin as a local git repo and create
separate branches for drastic changes. This way it would easy to track the
changes also.
https://git-scm.com/docs/git-init

HTH

Thanks and Regards,
Aditya Sharma

On Mon, Nov 2, 2020 at 2:11 AM Georg Potthast 
wrote:


For testing I create a plugin, e.g. mytest: “gradlew
createPlugin -PpluginId=mytest”. To be able to fall back to a working
version, I frequently copy this plugin directory to e.g. mytest-1,
mytest-2
etc. When I decide to use the mytest-1 directory again, I rename the
directory I am currently working with to mytest-current and copy mytest-1
to
mytest. Then I restart ofbiz and expect that to work with this mytest
directory.

However, OFBiz seems to continue to work with the former current
directory.
E.g. I have made three menu items in mytest-current while I had just two
menu items in the older mytest-1 directory. After copying the mytest-1
directory to mytest and restarting OFBiz, I still have three menu items
displayed although there should be only two.

What could be the reason for this and what do I have to do to properly
fall
back to the state of mytest-1?






smime.p7s
Description: S/MIME Cryptographic Signature

Re: How to Configure Ofbiz SSL

[Michael Brohl]

Hi Dominic,

welcome to the OFBiz community!

If you think there is a bug, please file a Jira issue in our bug 
tracking system, describing the exact steps and possibly provide 
screenshots to be able to validate the problem.


Thanks,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 27.10.20 um 14:34 schrieb Dominic Amann:

Yes, I did stumble upon that documentation eventually. It seems (as usual)
that google is a better way to search than a site's own index/search. I
think the main problem I encountered (re: docs) is that there appear to be
3 sets of documentation out there, with things pertaining to different
aspects being best served in different places.

Ultimately I did figure out everything about the install (Java 8 on debian
10, mariadb, SSL with Lets Encrypt, Apache proxying, direct serving static
content). However a bug in OFBiz itself is preventing me from actually
using it for accounting. It is impossible to enter postal addresses in a
clean install of 17.12.04, due to pull down for province/state not working.
I need a work-around for this. The state date is being imported from the
XML, it is in the database. Is there a specific release where this does
work?

On Tue, 27 Oct 2020 at 08:39, Jacques Le Roux 
wrote:


Le 25/10/2020 à 14:36, dimonic a écrit :

Jacques Le Roux wrote

Short answer: preferably look at letsencrypt for a free certificate (must
be renewed every 3 months but there are tools for that)

For instance for the trunk demo we use

## SSL directives
SSLEngine on
SSLCertificateFile
"/etc/letsencrypt/live/ofbiz-vm2.apache.org/cert.pem"
SSLCertificateKeyFile
"/etc/letsencrypt/live/ofbiz-vm2.apache.org/privkey.pem"
SSLCertificateChainFile
"/etc/letsencrypt/live/ofbiz-vm2.apache.org/chain.pem"
SSLCACertificatePath"/etc/ssl/certs"

## Custom fragment
ProxyRequests Off
ProxyPreserveHost On
# do not proxy letsencrypt cert renewal requests
ProxyPass /.well-known !
ProxyPass / ajp://localhost:8009/

I let you figure the rest out

We should really update the Apache+OFBiz+Technical+Production+Setup+Guide

This looks like you expect us to proxy the ofbiz server - am I correct?

You referred to https://markmail.org/message/3uf5axg2xzvlxuh5 which is a
thread about  "a test deployment (on a given domain)", so yes!


There is also a lack of documentation on how to achieve this. I am setting
this up myself, and documenting as I go (because the available docs are
fragmented, out of date and incomplete). I would be happy to submit working
setup documentation for your consideration (once I can get SSL configured)?

The setup I am documenting is debian based, and includes exactly how one has
to setup Java 8 (which is not in mainline repos), how to configure for
mariadb, leave out the demo data (but have the admin login available),
launch (and stop) the server using systemd, how to replace the certs for
working SSL (presumably with apache2 reverse proxy).

How (with which tools) do you intend to document that?
We now preferably use AsciiDoc and the documentation is generated at
https://ci.apache.org/projects/ofbiz/site/trunk/

This is not yet official, but it's the more up to date way.
You can find more info into documentation_guidelines.adoc in docs\asciidoc
(not generated yet, I just spotted, but you can read it as simple text
anyway)

You even have a CONTRIBUTING.adoc file in your local copy. Just linking
for now to

https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Contribution+and+Development
<https://cwiki.apache.org/confluence/display/OFBIZ/Wiki+access>

Be prepared, OFBiz is a wild beast :)

HTH

Jacques


--
Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html






smime.p7s
Description: S/MIME Cryptographic Signature

Double posts

[Michael Brohl]

Hi,

anyone else receiving double posts in this list since yesterday?

Thanks,

Michael Brohl

ecomify GmbH - www.ecomify.de




smime.p7s
Description: S/MIME Cryptographic Signature

Re: Fail installing apache-ofbiz-17.12.04 on windows 10

[Michael Brohl]

Thanks, Jacques.

As an addition: the Oracle JDK 8 is out of free support (no security 
fixes or else without paid subscription). To get free bug/security fixes 
you'll have to switch to the next JDK version about every 6 months which 
is not practicable in a serious production environment.


The Adopt OpenJDK Long Term Support (LTS) releases are maintained much 
longer without any fee. See https://adoptopenjdk.net/support.html for 
the release roadmap.


This gives us enough time tp prepare for the next LTS version and users 
are not forced to switch without enough testing time.


We are using the Adopt OpenJDK releases in our customer/internal 
production systems for quite a while now and haven't had any problems so 
far.


Regarding the install: you do not have to uninstall other Java 
installations to make OFBiz work on your machine. Just unpack the JDK in 
your preferred folder and point the JAVA_HOME environment variable to 
this folder. I recommend doing this in the start/stop scripts to avoid 
problems with other applications relying on the JAVA_HOME from the 
global Windows environment variables.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 15.08.20 um 14:43 schrieb Jacques Le Roux:

Hi Georg,

We preconise to use https://adoptopenjdk.net/releases.html

And exactly for OFBiz 
https://adoptopenjdk.net/releases.html?variant=openjdk8=hotspot 
(All OFBiz versions currently support only Java 8)


HTH

Jacques

Le 15/08/2020 à 06:55, Georg Potthast a écrit :
Just saw a bug in my notes. I had tried Java 14.0.2 first which 
failed and left that in the notes. It should read:

JAVA_HOME to C:\Program Files\Java\jdk1.8.0_261

So replace "C:\Program Files\Java\jdk-14.0.2" with "C:\Program 
Files\Java\jdk1.8.0_261" in the notes.


-Ursprüngliche Nachricht- From: Georg Potthast
Sent: Saturday, August 15, 2020 6:35 AM
To: user@ofbiz.apache.org
Subject: Re: Fail installing apache-ofbiz-17.12.04 on windows 10

I recently installed OFBiz on my Windows 10 system and made notes how 
I did
it, so I can repeat it on a different machine if necessary. Hope this 
helps.



Install OFBiz on Microsoft Windows 10

1. Uninstall Java Runtime  to get JDK and JRE to the same version

2. Download Java SE JDK
https://www.oracle.com/java/technologies/java-se-glance.html
Use the Java SE 8u261 version. Register with Oracle to be able to 
download

that version.

3. Run the downloaded file and install the Java JDK and JRE. Do not 
modify

the default file paths.

4. Download the OFBiz ZIP archive
https://ofbiz.apache.org/download.html

5. Unpack the directory apache-ofbiz-17.12.04 in the zip file.
You can rename this directory to e.g. c:\ofbiz

6. Set the environment variables
control panel – extended system settings – environment variables, new
JAVA_HOME variable
JAVA_HOME to C:\Program Files\Java\jdk-14.0.2
test the setting of this variable in the command window:
C:\Users\Potthast>echo %JAVA_HOME%
C:\Program Files\Java\jdk-14.0.2

Add paths to system path variable:
control panel – extended system settings – environment variables, 
existing

path variable
%JAVA_HOME% (=C:\Program Files\Java\jdk-14.0.2)
%JAVA_HOME\bin%
close these windows again to get Windows to enable these

7. Test the path variable
open new command window
enter java
enter javac
if these output a lot of explanations, your are ok

8. Test OFBiz
Open the INSTALL file and follow the instructions in there

open a command window in administrator mode
for that right-click on the start button, open search, enter cmd and 
execute

as administrator
get into the ofbiz directory you created, e.g. c:\ofbiz
enter:
init-gradle-wrapper (=init-gradle-wrapper.bat)

and then enter:
gradlew cleanAll loadAll (=gradlew.bat cleanAll loadAll)
allow this script to download files when queried by Windows

Finally start OFBiz by entering: gradlew ofbiz
You can make a startofbiz.bat file with this command and generate a 
link to

that from your desktop to restart it conveniantly.

OFBiz will compile and start. When the message OFBiz is started and 
ready
appears, followed by several further messages, it will stop with the 
prompt
:ofbiz. Then open a browser window and enter 
https://localhost:8443/webtools

(or ecommerce, or catalog)

The default login is admin, password ofbiz

9. Stopping OFBiz

You may use Ctrl+C in the terminal were you started OFBiz.

The „official“ way, which takes way longer, is to open another 
terminal and
navigate to the ofbiz directory. In there enter gradlew „ofbiz 
--shutdown“






smime.p7s
Description: S/MIME Cryptographic Signature

Re: Trouble getting ofbizDemo to run

[Michael Brohl]

Good evening,

is there a resource OfbizDemoUiLabels.xml located in the config 
directory of the newly created plugin? Maybe it's just a matter of 
lowercase/uppercase naming.


Hard to say without seeing the code and files.

The hot-deploy mechanism refers to older versions of OFBiz, it was 
replaced by the plugins mechanism. Every third party or custom 
enhancement should be located in the plugins directory.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 02.08.20 um 10:54 schrieb Georg Potthast:

I installed the JDK version 8 and OFBiz on my Windows 10 system in Germany
ok and can run the provided applications like catalog or webtools.
  
Now I want to follow the tutorial “OFBiz Tutorial - A Beginners Development Guide”.

So I entered “gradlew createPlugin -PpluginId=ofbizDemo”
and run “gradlew loadAll ofbiz” Seemed to work ok.
When I enter “https://localhost:8443/ofbizDemo” I get the error message
"ERROR MESSAGE java.lang.IllegalArgumentException: Could not find resource
bundle [OfbizDemoUiLabels] in the locale [de]"

What do I need to do to get that to work?

Additional question: old tutorials refer to a hot-deploy directory. Is this
no longer working?





smime.p7s
Description: S/MIME Cryptographic Signature

Re: Need help/direction getting started with OFBIZ ERP

[Michael Brohl]

Hi Phoon,

see here: https://www.youtube.com/watch?v=Lzmv0DCC5N4

Should be very similar to the MariaDB configuration.

For MariaDB installation: 
https://vitux.com/how-to-install-and-configure-mysql-in-ubuntu-18-04-lts/


hth,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 17.07.20 um 10:22 schrieb phoo...@yahoo.com.INVALID:

Thanks Joseph,

I'm just asking how you install MariaDB on OFBiz since you did it successfully. 
It would definitely help to speed up and probably lesser problem on my end.

Cheers
Phoon

-Original Message-
From: Joseph Francois 
Sent: Friday, 17 July 2020 3:55 pm
To: user@ofbiz.apache.org
Subject: Re: Need help/direction getting started with OFBIZ ERP

Hell Phoon,

It doesn't matter how you install the DB, just use your Linux distribution 
package management. However, this is an OFBIZ user forum, so we really should 
stick to OFBIZ topics.

Regards,
Joseph

On Fri, 17 Jul 2020 at 05:18, Tuck Seng Phoon 
wrote:


Hi Joseph,
Do you have the steps to install MariaDB?
Thanks
CheersPhoon

 On Friday, July 10, 2020, 04:08:41 PM GMT+8, Joseph Francois <
joefranc...@gmail.com> wrote:

  Hello Phoon,

You should follow Jacques' advice. Here are a few gotcha that I faced.

*Mysql configuration*
I installed the latest MariaDB 10.5 and it worked well. You also can
install MySQL, it should work as well. However, make sure that you
change MySQL configurations to that utf8 is your default character set
as shown in the instructions

mysql.conf
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8


After just create the databases and users as required. As an example,
I copy-paste from the instruction.

mysql>create database ofbiz;
mysql>create database ofbizolap;
mysql>create database ofbiztenant;
mysql>use mysql;
mysql>select database();
mysql>create user ofbiz@localhost;
mysql>create user ofbizolap@localhost; create user
mysql>ofbiztenant@localhost; update user set
mysql>password=PASSWORD("ofbiz") where User='ofbiz'; update user set
mysql>password=PASSWORD("ofbizolap") where
User='ofbizolap';
mysql>update user set password=PASSWORD("ofbiztenant") where
User='ofbiztenant';
mysql>grant all privileges on *.* to 'ofbiz'@localhost identified by
'ofbiz';
mysql>grant all privileges on *.* to 'ofbizolap'@localhost identified
mysql>by
'ofbizolap';
mysql>grant all privileges on *.* to 'ofbiztenant'@localhost
mysql>identified by
'ofbiztenant';

That would be it for MySQL.

*Gradle configurations*

You need to make sure that you have the right JDBC driver (MySQL in
this case). The easiest I found was to just let the Gradle script
download it from JCenter, as mention by Jacques.
- Using your favourite editor (vi, nano, etc..)  open
$OFBIZ_HOME/build.gradle
- Starting from line 164 add the following line (Use the other lines
as an example of the syntax).
 runtime 'mysql:mysql-connector-java:5.1.36'
- So now OFBIZ will be capable of reading and writing data in MySQL.

*OFBIZ configurations*
Now you need to tell OFBIZ to use MySQL and give the server, database
to use and how to authenticate. All this is done in entityengine.xml.
*(This is where my knowledge decreases, I will just tell you what I
understand.)*
- The"delegator" records tell what OFBIZ where to look for the
configuration to connect to the database. So basically what database
to use.  There are 3 delegators you need to change so that they point
to your MYSQL records.
   1. Default
   2. default-no-eca
   3. test
-  Since there are three databases, you will need to have a
configuration for each of them. The three databases are:
 1. ofbiz
 2. olap
 3 tenant
- In practice, you should just modify the records for localmysql/
localmysqlolap/localmysql to have them reflect your MySQL setup. and
update the delegators with  localmysql/ localmysqlolap/localmysql
respectively.


*Conclusion*
if your ofbiz server has access to the Internet to download the driver
and it can connect, authenticate to the database server and the DB
exists, all should work as normal.


Hope that was of help.

Regards,
Josep


On Fri, 10 Jul 2020 at 09:06, Jacques Le Roux <
jacques.le.r...@les7arts.com>
wrote:


Hi Phoon,

You should refer to the README.adoc file. At section "Setup an
external database like MySQL, PostgreSQL, etc" it says:

To setup an external database instead of the default embedded Apache
Derby, you will need to follow the following instructions:

1.  Find the JDBC driver suitable for your database using one of the
following
options:

* Search for the JDBC driver in
https://bintray.com/bintray/jcenter[jcenter] and place it in
build.gradle dependencies e.g.
`runtime 'mysql:mysql-connector-java:5.1.36'`
+
OR
* Download the JDBC driver jar and place it in $OFBIZ_HOME/lib or
the lib sub-d

Re: OFBiz configuration on production site

[Michael Brohl]

Hi Katie,

can you provide your Apache virtual host configuration with the AJP 
settings?


Thanks,

Michael


Am 13.07.20 um 09:10 schrieb Katie Qiu:

Hi Pierre, Jacques and Michael,

I want to thank you all again. I am finally able to make OFBiz on Windows 
Server work with SSL  Let's encrypt and Apache. I couldn't have done it without 
your support :-)

Now I am facing a new problem on production: Please check my website: 
https://www.polluniverse.com/

You will see the page shows as below:
Index of /
apache-ofbiz-17.12.03/
webapp/

When visiting  https://www.polluniverse.com/webapp/ecommerce/ I expect I should 
see the index.jsp page in the folder, but I see the source code of the 
index.jsp page
I have done the following
1.  Put the following in HTTPD

 DirectoryIndex index.jsp


2.  apache-ofbiz-17.12.03 and webapp are two folders. These two folders are 
located
at SITEROOT "C:/apache24/htdocs/www/polluniverse.com"

A.  apache-ofbiz-17.12.03 is the project folder (what I downloaded from 
Ofbiz website).

B.  webapp is from folder at 
C:\Apache24\htdocs\www\polluniverse.com\apache-ofbiz-17.12.03\plugins\ecommerce\webapp
 and I copy it to SITEROOT C:/apache24/htdocs/www/polluniverse.com"

C.  In ofbiz-component.xml, I change the "mount-point" attribute on that tag to 
""


I'm not sure if I have moved the ecommerce webapp folder correctly or not. The 
reason I did it is because I read about Mounting a Root WebApp from the OFBiz 
Production Setup page.





smime.p7s
Description: S/MIME Cryptographic Signature

Re: [TUTORIAL] APACHE OFBIZ INSTALL ON WINDOWS 10

[Michael Brohl]

Hi Mohammad,

please refer the INSTALL/README files included in the release download 
package. They describe the correct way to install and load demo data for 
the release you have downloaded.


Various information on the web resources may not be correct related to 
the specific release because we had changes in the task naming 
(loadAll/loadDefault).


Thanks,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 07.07.20 um 20:59 schrieb moh.kar...@gmail.com:

Dear SK

The same problem

The Load data failed!!

Thank you
MOhammad

-Original Message-
From: S K Pradeep Kumar 
Sent: Tuesday, July 7, 2020 3:27 PM
To: user@ofbiz.apache.org
Subject: Re: [TUTORIAL] APACHE OFBIZ INSTALL ON WINDOWS 10

https://cwiki.apache.org/confluence/display/OFBENDUSER/How+to+install+OFBiz+with+the+Demo+Data



With regards,
S K Pradeep Kumar,
9035009495


On Sun, Jul 5, 2020 at 10:00 PM John The 
wrote:


Hi Support,



Do you have tutorial for installation Apache OfBiz on Windows 10 OS?

Thank  you.



*Regards,*







*John The*



[image: TrustLogoT2]

*CV. TRUST TECHNOLOGY*

*Kompleks Cemara Hijau Blok R24*

*Desa Sampali, Percut Sei. Tuan*

*Deli Serdang – 20371*

*Sumatera Utara – Indonesia*

*Telp. +62-811-650-1126*

*Fax. +62-61-6639283*

*WA/HP. +62-819-88-3425*

www.trust-technology.co.id







smime.p7s
Description: S/MIME Cryptographic Signature

Re: [TUTORIAL] APACHE OFBIZ INSTALL ON WINDOWS 10

[Michael Brohl]

Hi John,

it's all in the INSTALL/README files included in the release download 
package.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 05.07.20 um 18:15 schrieb John The:


Hi Support,

Do you have tutorial for installation Apache OfBiz on Windows 10 OS?

Thank  you.

*Regards,*

*_John The_*

*__*

TrustLogoT2

*CV. TRUST TECHNOLOGY*

*Kompleks Cemara Hijau Blok R24*

*Desa Sampali, Percut Sei. Tuan*

*Deli Serdang – 20371*

*Sumatera Utara – Indonesia*

*Telp. +62-811-650-1126*

*Fax. +62-61-6639283*

*WA/HP. +62-819-88-3425*

www.trust-technology.co.id <http://www.trust-technology.co.id>





smime.p7s
Description: S/MIME Cryptographic Signature

Re: OFBiz configuration on production site

[Michael Brohl]

Hi Katie,

please refer to our Wiki: 
https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQTipsTricksCookbookHowTo-HTTPD


If you use the Apache Webserver you don't need to bother with the Tomcat 
keystore.


HTH,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 26.06.20 um 09:30 schrieb Katie Qiu:

Hi,

I'm new to OFBiz, Please check the steps I have taken and pointed out what I
miss because it's not working on production site

  


1. I was able to make it work on localhost. I'm also able to access data
that came with the project (ex:
<https://localhost:8443/webtools/control/entitymaint>
https://localhost:8443/webtools/control/entitymaint)

  


2. I installed SSL Certificate in Microsoft IIS for the project on
production site my Windows Server 2012 (I was able to access
<https://www.mywebsitedomain.com/> https://www.mywebsitedomain.com now)

  


a.  I use virtual private server from IONOS and it provides me a free SSL. I
imported .PFX file provided from IONOS, then the domain can be accessed as
https

  


b. As you suggested, I looked into  <https://letsencrypt.org/>
https://letsencrypt.org/, but I didn't see any .PFX file neither other
certificate files that IONOS provided me (on the OFBiz Product Setup page,
it shows .cer files (which I also got from IONOS) is used to enter Keystore.
Maybe I missed something. For now, I use SSL from IONOS, but if you think I
should use Let's encrypt, then please let me know if have to have the .PFX
and cer files

  


3. I installed Apache 24 on Windows server as well. I was able to access
localhost and see the index page showing "it works"

  


4. I have edited "keystoreFile" and "KeyPass" in ofbiz-component  at
apache-ofbiz-17.12.03\framework\catalina



 

 

 

  


5.  I then tried to follow  <https://s.apache.org/vmemj>
https://s.apache.org/vmemj and edit httpd.conf file and httpd-ssl.conf, but
when trying to Start Apache 24, it gives me some error messages (I got no
error before editing the two files).

a.  I have edited ofbiz-containers.xml and url.properties file (change 8080
to 80 and 8443 to 443)

b. For httpd.conf: not recognizing some words like "RewriteEngine On"
"Order"

c. For httpd-ssl.conf, for example, I get error "AH00526: Syntax error on
line 177 of c:/Apache24/conf/extra/httpd-ssl.conf: SSLCertificate KeyFile:
file 'c:/Apache24/conf/server.key' does not exit or is empty"  - It's true,
I don't have such file, but I'm not sure where I can get it.

  


Thank you very much  in advance

Katie

  







smime.p7s
Description: S/MIME Cryptographic Signature

Re: Open Source Enterprise Job Scheduler with Ofbiz in Production

[Michael Brohl]

Hi Sakthivel,

OFBiz already comes with a job scheduler, see 
https://demo-trunk.ofbiz.apache.org/webtools/control/scheduleJob


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 07.05.20 um 05:32 schrieb Sakthivel Vellingiri:

Hi All, Wanted to reach out to see if you have any recommendation for Open
Source Enterprise Job Scheduler, that works well for you with Ofbiz (or any
other java based or other) in Production; Appreciate your insights

regards
Sakthivel Vellingiri





smime.p7s
Description: S/MIME Cryptographic Signature

Re: Multiple configuration for different environments

[Michael Brohl]

Hi Tomek,

this is not easily possible OOTB. For some approaches, see discussion in 
[1].


We are using a custom configure mechanism which is described in [2]. It 
is on my todo list to explain it a bit more and provide a patch/proposal 
for introduction into OFBiz.


Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


[1] 
https://lists.apache.org/thread.html/a4d6afc536b33182651f01e25d50ce684d055b4d7aea45e9e15d7c0a%40%3Cdev.ofbiz.apache.org%3E


[2] 
https://lists.apache.org/thread.html/b95e239250880d9a5b34268b3b711f0f8f7f0540a26bb41c5ced493a@1213087551@%3Cdev.ofbiz.apache.org%3E



Am 19.04.20 um 12:44 schrieb Tomek:

Hello,

I would like to configure Ofbiz for both development and production 
environment and I would like to switch between them (I need use 
different data source for development environment and different data 
source for production environment etc). What is the proper why to do it?


Tomek





smime.p7s
Description: S/MIME Cryptographic Signature

Re: Ofbiz integration with Azure AD SSO

[Michael Brohl]

Hi Vipin,

we have implemented an SSO integration via SAML2 with Azure for a portal 
solution and several subsystems based on OFBiz recently.


The solution mainly consists of

* a SAML API implementation using the OneLogin SAML API

* this was modified to make use of the internal OFBiz login service for 
the local OFBiz webapp login


* the integration happens using the OFBiz login extension mechnism 
(which we also have improved for dealing with logout) by an 
implementation of org.apache.ofbiz.webapp.control.LoginCheck to hook 
into LoginWorker.extensionCheckLogin for webapp specific external SAML2 
authentication


* the SAML SSO login can be configured/activated per webapp


You will still need an OFBiz user for the use of your application, if it 
is not to be used anonymously.



Hope that helps, best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 23.03.20 um 11:14 schrieb vipin nirwal:

Hi All,

I have to integrate ofbiz with Azure Active Directory SSO.

Requirement: I have a portal for users which is integrated with Azure SSO.
When a call is being made to ofbiz from my portal, then i do not want to
pass ofbiz username/password in that call, even i want to use the SSO only. Is
there a tighter integration that ofbiz can have with an SSO so that a user
may get authenticated directly without using an ofbiz user?

Please let me know , how can i achieve this?


Thank you in advance.





smime.p7s
Description: S/MIME Cryptographic Signature

Re: Unsubscribe from Mailing List

[Michael Brohl]

Hi Garima,

please help yourself: https://ofbiz.apache.org/mailing-lists.html (at 
the bottom).


Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 04.02.20 um 13:12 schrieb Garima Jain:

I request you to unsubscribe me from your mailing list.





smime.p7s
Description: S/MIME Cryptographic Signature

Re: Start Service on Ofbiz Startup

[Michael Brohl]

Is it important to establish the connection to the external storage 
system only after OFBiz has been startet?


Can it be established beforehand? If yes, I would either startup the 
connection in your OFBiz start script or completely independend of OFBiz 
on the server level (mounting on startup).


Michael Brohl

ecomify GmbH - www.ecomify.de


Am 28.01.20 um 11:06 schrieb Gil Portenseigne:

Hello Ingo,

For this case, i think I would plan a job to run every X minutes, that
will check if the connexion is alive or, establish it.

The jobPoller will then take care of it after OFBiz is launched.
Depending on the connexion type it might be enough.

AFAIK there is no standard configuration to launch a service at OFBiz
start.

Gil

On Tue, Jan 28, 2020 at 10:58:14AM +0100, Ingo Wolfmayr wrote:

Hi everybody,

is it possible to start a service when Ofbiz has started and is ready?

Use case: I need to startup a connection to an external storage system. In my
case a TCP/IP connection that is permanent.

Best regards,
Ingo






smime.p7s
Description: S/MIME Cryptographic Signature

Re: Solr Demo

[Michael Brohl]

Hi James,

the official demos include the Solr integration. I'm not sure what you 
are missing, can you specify more detailed what you like to see?


Thanks,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 27.01.20 um 02:15 schrieb ja...@productive1.com:

Is there a demo of the Solr integration with Ofbiz?

Thanks,

James




smime.p7s
Description: S/MIME Cryptographic Signature

Re: Developing a client site with OFBIZ.

[Michael Brohl]

Hi Robert,

which version/release of OFBiz do you use?

In general, I recommend to extend OFBiz by using the plugin mechanism 
and not directly change the OFBiz standard components. This way you 
vendor updates are easier.


You should set up your git project in a way where you use a remote 
branch to the OFBiz source branch as an upstream branch and merge from 
this upstream branch towards your development branch (or whichever 
branch you need depending on your project's branching model). This even 
works with an upstream based on SVN (for older release branches).


You can then easily update even if you made changes/MODS in the standard 
components (which should be avoided where possible), git mergetool will 
help you during merge.


Hope this helps,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 24.01.20 um 17:45 schrieb Robert Wynkoop:

Hello everyone.

Still trying to figure out a development strategy, where I can continue to
get OFBIZ updates and build a client site.

Using eCommerce as a base, I created my own GIT project and modified
eCommerce so it was my own, with my site URL.

I discovered that OFBIZ framework / application / order / templates have
direct references back to the eCommerce site.

I'm not understanding how to use OFBIZ as a framework for a custom site.

I had hoped not to change framework source, but to extend it.

"Am I doing it all wrong"

Robert Wynkoop





smime.p7s
Description: S/MIME Cryptographic Signature

Re: Installation trouble

[Michael Brohl]

Feel free to improve them if you see room for optimization, Pierre.

Thanks,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 23.01.20 um 13:00 schrieb Pierre Smits:

Perhaps the instructions are not as clesr as they could be...

Op do 23 jan. 2020 12:38 schreef L :


./gradlew loadAll doesn't do anything and supplies no output.  It just
returns to the CLI instantly:

[root@localhost ofbiz]# ./gradlew loadAll
[root@localhost ofbiz]#

On 1/22/20 9:08 AM, Parminder S. Lehal wrote:

The problem lies with the download files. Some of the zip files *even
the latest 16.11 zip) does not have gradlew file included in them. It
is pathetic that the final package file served  from the mirrors is
incomplete(May be someone will pay some attention to this decline
in quality). I also found this after wasting some time.  Easier
solution may be to use svn for downloading whatever version you are
looking for.
On Wed, 2020-01-22 at 10:32 +0100, Gil Portenseigne wrote:

On Wed, Jan 22, 2020 at 10:30:14AM +0100, Gil Portenseigne wrote:

Hello,


Typo :And you should be able to : $ ./gradlew loadAll







smime.p7s
Description: S/MIME Cryptographic Signature

Re: Installation trouble

[Michael Brohl]

Hi,

as you might have noticed, my answer was addressed to Parminder's 
answer, particularily the fact that the gradlew file is not included.


I may come back to your topics if noone else beats me to it.

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 22.01.20 um 20:50 schrieb L:

And this still does not help why my gradlew seems to do nothing.

I've been through the README.md and I met all the requirements (not 
many listed).

What in the README did I miss?

Excerpts from the README:

The first requirement to run OFBiz is to have the Java Development Kit 
(JDK)
version 8 installed on your system (not just the JRE, but the full 
JDK) which

you can download from the below link.

    [root@localhost ~]# java -version
    openjdk version "11.0.6" 2020-01-14 LTS
    OpenJDK Runtime Environment 18.9 (build 11.0.6+10-LTS)
    OpenJDK 64-Bit Server VM 18.9 (build 11.0.6+10-LTS, mixed mode, 
sharing)


The second requirement is to setup the Gradle wrapper files that are used
build the system.
order to fulfill this requirement, you can run the following command:

Unix-like OS:
`./gradle/init-gradle-wrapper`

    [root@localhost ~]# cd /usr/local/ofbiz/
    [root@localhost ofbiz]# ./gradle/init-gradle-wrapper.sh
 === Prepare operation ===
    /usr/local/ofbiz/gradle/wrapper/gradle-wrapper.jar not found, we 
download it

 ===     Download gradle-wrapper.jar ===
 === Download gradle-wrapper.properties ===
 === Download script wrapper ===
 === Control downloaded files ===
    gradle/wrapper/gradle-wrapper.jar: OK
    gradle/wrapper/gradle-wrapper.properties: OK
    gradlew: OK

So far, so good ( I think, it only took 3 seconds and no other 
output).  Then:


Quick start
---

To quickly install and fire-up OFBiz, please follow the below 
instructions

from the command line at the OFBiz top level directory (folder)

### Prepare OFBiz:
Unix-like OS:
`./gradlew cleanAll loadDefault`

    [root@localhost ofbiz]# ./gradlew cleanAll loadDefault
    [root@localhost ofbiz]#

Unix-like OS:
`./gradlew ofbiz`

    [root@localhost ofbiz]# ./gradlew ofbiz
    [root@localhost ofbiz]#

Again no outout and appears to do NOTHING.


On 1/22/20 12:42 PM, Michael Brohl wrote:
This is well documented in the README along with the system 
requirements which is always a good read ;-)


You can find the reasons for this here: [1]

Thanks,

Michael Brohl

ecomify GmbH - www.ecomify.de


[1] https://issues.apache.org/jira/browse/OFBIZ-10145

Am 22.01.20 um 15:08 schrieb Parminder S. Lehal:

The problem lies with the download files. Some of the zip files *even
the latest 16.11 zip) does not have gradlew file included in them. It
is pathetic that the final package file served  from the mirrors is
incomplete(May be someone will pay some attention to this decline
in quality). I also found this after wasting some time. Easier
solution may be to use svn for downloading whatever version you are
looking for.
On Wed, 2020-01-22 at 10:32 +0100, Gil Portenseigne wrote:

On Wed, Jan 22, 2020 at 10:30:14AM +0100, Gil Portenseigne wrote:

Hello,


Typo :And you should be able to : $ ./gradlew loadAll








smime.p7s
Description: S/MIME Cryptographic Signature

Re: Installation trouble

[Michael Brohl]

This is well documented in the README along with the system requirements 
which is always a good read ;-)


You can find the reasons for this here: [1]

Thanks,

Michael Brohl

ecomify GmbH - www.ecomify.de


[1] https://issues.apache.org/jira/browse/OFBIZ-10145

Am 22.01.20 um 15:08 schrieb Parminder S. Lehal:

The problem lies with the download files. Some of the zip files *even
the latest 16.11 zip) does not have gradlew file included in them. It
is pathetic that the final package file served  from the mirrors is
incomplete(May be someone will pay some attention to this decline
in quality). I also found this after wasting some time.  Easier
solution may be to use svn for downloading whatever version you are
looking for.
On Wed, 2020-01-22 at 10:32 +0100, Gil Portenseigne wrote:

On Wed, Jan 22, 2020 at 10:30:14AM +0100, Gil Portenseigne wrote:

Hello,


Typo :And you should be able to : $ ./gradlew loadAll




smime.p7s
Description: S/MIME Cryptographic Signature

Re: Multi Tenancy Support

[Michael Brohl]

Hi Rajesh,

I'm not sure if I understand correctly: are you offering to provide the 
fix under the condition that you are being paid for it?


Regards,

Michael


Am 16.10.19 um 17:47 schrieb Rajesh Mallah:

Hi

We are willing to sponsor the resolution of this issue.
https://issues.apache.org/jira/browse/OFBIZ-10284

Conditions are:

(1) We have a limited budget hence the effort analysis needs to be done and
a reasonable quote is to be presented.
(2) The fix should be good enough that it gets merged into the ofbiz trunk
( in other words we are willing to contribute the fix back to community).

I am open to discuss and explain the issue in depth.
Kindly contact privately to mal...@redgrape.tech

Regards
Director
Redgrape Technologies Pvt Ltd.
India.









On Thu, Oct 3, 2019 at 10:50 PM Rajesh Mallah 
wrote:


Hi

Multitenency is supported with OOTB interfaces . But when it comes to
integrating the ofbiz
framework with other systems the Webservices do not support it. For SAAS
operators
multi-tenancy is a game-changing feature, due to the issue above  i am
forced to
create separate installations.

An issue was filed and a patch was contributed, But i request senior and
experienced
contributors to look into it.

https://issues.apache.org/jira/browse/OFBIZ-10284

Thanks & Regards

mallah.


On Wed, Oct 2, 2019 at 3:34 PM Suraj Khurana 
wrote:


Hello Sridharreddy,

Yes, OFBiz support multi-tenancy. This document might help you:

https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+support

--
Kind Regards,
Suraj Khurana
Technical Consultant
HotWax Systems
Enterprise open source experts
http://www.hotwaxsystems.com






On Wed, Oct 2, 2019 at 3:29 PM sridharreddy u 
wrote:


Dear Support,

We sell SAAS software to Financial Organisation. Each Organisation needs
their own ERP for account management.  So, we are evaluating OFBIZ to

use

this purpose. We will integrate our application with OFBIZ (as plugin)

and

each organisation will have their own view of accounting.

Does OFBIZ support multi tenancy model where I deploy OFBIZ (with single
instance in scalable mode) in CLOUD and each organisation will be able

to

access their own data.

If not, do you have any suggestion on how to USE OFBIZ for multi tenancy
purpose.


BR,
Sridhar Reddy U





smime.p7s
Description: S/MIME Cryptographic Signature

Re: Update about Apachecon 2019, Las Vegas(September 09 - September 12)

[Michael Brohl]

Hi Ashish,

thank you for the great summary, insights and photos!

You all seem to have had a great time, wish I could have been there too.

Kudos,

Michael


Am 26.09.19 um 15:04 schrieb Ashish Vijaywargiya:

Dear All,

I am writing this email to share the update about Apachecon 2019 which was
organized in Flamingo Hotel, Las Vegas, Nevada USA(September 09 - 12,
2019). This was my second chance to attend Apachecon conference. Last time
I attended it in New Orleans in the year 2008. Attending the 20th
anniversary of ASF was one of the best experiences of my life and also
there were so many learnings for me as an individual.

1) Flamingo Hotel and the arrangements within the hotel was very nice.
Breakfast, Lunch was also very good and the coffee, beverages were
available all the time.

2) Meeting the community members who are engaged in Apache OFBiz project
like Sharan, Nicola and my other colleague from HotWax Systems like Mike,
Ben, Desiree, Patrick, Jacopo, Anil, Divesh, Swapnil, Mridul and Deepak was
a very nice experience.

3) Sharan has organized an evening get together with some OFBiz folks and
guys from other great ASF projects: we had a pleasant time having some
drinks and sharing our impressions about the conference, plans and
memories! The other guys who joined were Paul King(PMC Chair of Groovy, One
of the founder of Groovy language and the author of the book Groovy in
Action), Lars Eilebrecht(One of the founders of HTTP project), Claude
Warren(ASF Member and associated with Apache Jena project), Chris
Dutz(Member on Plc4x project and also tac PMC member) and Justin Mclean(PMC
Chair of Mynewt and PMC of server other projects and expert of IoT). You
feel so great when you meet the core members of any of the open-source
project who are the driving force for it.

4) Meeting with James Gosling is the dream come true situation for an
individual. Deepak got a chance to meet with James Gosling and he couldn't
stop himself to take a selfie with James. Please see Deepak's pic with
James Gosling here: https://cwiki.apache.org/confluence/x/ExLABw

5) There were three sessions organized from Apache OFBiz panel and all the
sessions were a very informative one. Those sessions were:
5a) Apache OFBiz in the Cloud(s) by Deepak Dixit
5b) OFBiz in the fashion industry, an omnichannel approach by Nicola
Mazzoni.
5c) The ASF and OFBiz - How Community Makes It All Possible by Mike Bates.

More details about these presentations are available here:
https://cwiki.apache.org/confluence/x/nxWrBw

We have also taken a few photographs from the conference and those
photographs are shared here: https://cwiki.apache.org/confluence/x/ExLABw

I was reading the quote for Las Vegas and all the quotes present on this
link are true and we could feel it when we were in Vegas. :-)
Here they are: https://www.techjunkie.com/las-vegas-captions/

I would like to pass on my thanks to ASF for organizing such a nice event
each year and this 20th year anniversary was an amazing one. The organizing
committee members managed to plan such a nice and big event from the remote
locations. And as a participant, you would be amazed to see such a nice
arrangement. All the sessions were running very smoothly, you can go and
attend any of the sessions. The session details present on the mobile app
was very friendly. Keynote sessions in the big hall were the amazing one.
Such a nice events give the opportunity to all the participants to meet
with each other and plan something meaningful in the open-source world.

Thanks so much to everyone for making the open-source world so beautiful.
Together we can create so many amazing and meaningful things for our
community!

--
Kind Regards,
Ashish Vijaywargiya
Vice President of Operations
*HotWax Systems*
*Enterprise open source experts*
cell: +91-9893479711
http://www.hotwaxsystems.com





smime.p7s
Description: S/MIME Cryptographic Signature

Re: Looking for a consultant

[Michael Brohl]

Hi Mariano,

welcome to the OFBiz community!

You will find a list of service providers for Apache OFBiz in our wiki: 
https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Service+Providers


Best regards,

Michael


Am 12.07.19 um 04:29 schrieb Mariano Marks:

Hello everybody,

I am looking for a consultant to help me setup a website using OFBIZ. I
want to use Posgressql on AWS (amazon web services).

I have some basic experience but I need help with setting up Eclipse (to
make possible changes), and deploying in a AWS server.

Thank you

Mariano





smime.p7s
Description: S/MIME Cryptographic Signature

Re: OFBiz Community Days – May 2019

[Michael Brohl]

Hi Swapnil,

thank you and everyone involved for the efforts and insights!

Best regards,

Michael


Am 08.06.19 um 09:41 schrieb Swapnil M Mane:

Thanks so much everyone who participated in the OFBiz community day.
Indeed it was a very impactful community day, the community worked on
around 31 issues, more details can be found here [1].

Please refer to this document [2] for the responses of the survey.

Our next community day is planned on *23rd to 27th August 2019*, for more
detail please refer to this document [3], stay tuned!

Keep contributing!!

Thanks again Sharan Foga for building the assets and documentation related
to OFBiz Community Days.


[1]
https://issues.apache.org/jira/secure/RapidBoard.jspa?rapidView=318=OFBIZ=reporting=sprintRetrospective=523
[2]
https://cwiki.apache.org/confluence/display/OFBIZ/May+2019+-+Community+Day+Survey
[3]
https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Community+Days+Dates


- Best Regards,
Swapnil M Mane,
ofbiz.apache.org



On Mon, Jun 3, 2019 at 11:42 AM Swapnil M Mane 
wrote:


Hello Pierre,
If you feel please share your proposal in detail (like the list of
questions to be asked) on the *separate* email thread.


- Thanks & Regards,
Swapnil M Mane,
ofbiz.apache.org



On Thu, May 30, 2019 at 4:06 PM Pierre Smits 
wrote:


Maybe those who did not participate should also be asked some questions in
that survey (e.g. why they didn't). There can also much be learned from
them, in order to improve what the project is doing regarding engagement &
participation.

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 Thu, May 30, 2019 at 11:59 AM Swapnil M Mane 
wrote:


Hello all,

A big thank you to everyone who participated in the OFBiz community day.
Every contribution matters!
Indeed, this was an impactful event, a lot of traffic was seen in

commits

and notifications list.

We'd also like anyone who participated to complete a brief
survey. This will help us gather some feedback and information about

how we

can improve future Community Days.

*IMPORTANT NOTE*: Please only complete the survey if you actually
participated in Community Day.

Please feel this short survey,
(There are only 9 questions so it really won't take much time)


https://www.surveymonkey.com/r/998GG8Y

The survey will be open until *June 5th, 2019.* and I will document
the results on the Wiki and publish it on the mailing list.

P.S. I am closing the "OFBiz Community Day (May 2019)" Jira sprint.

Thank you, Sharan Foga for designing the survey, all your prepared

assets

for community day is helping us very much! :-)


- Best Regards,
Swapnil M Mane,
ofbiz.apache.org


On Sat, May 25, 2019 at 5:12 PM Swapnil M Mane 
Hello Rishi,

Thanks for your concern, I am sure it will help others too.
We should add the Sprint in all the cases.

1.) If we create a ticket we should add it.
2.) If we start working on an existing ticket (adding patch or

closing it

after a commit) we should add sprint if it is missing.

Basically adding Sprint will make sure the contribution will be

counted

in *OFBiz

community days *event, which is from 24th – 28th May.
At the end of May's OFBiz Community day i.e. after 28 May.
This will help us in reporting.

- Best Regards,
Swapnil M Mane,
ofbiz.apache.org



On Sat, May 25, 2019 at 5:10 PM Rishi Solanki <

rishisolan...@gmail.com>

wrote:


Dear Swapnil,
Can you please help on which tickets we should consider in sprint?

Tickets Closed during the activity right?

Best Regards,
--
*Rishi Solanki* | Sr Manager, Enterprise Software Development
HotWax Systems 
Linkedin: *Rishi Solanki*

Direct: +91-9893287847


On Fri, May 24, 2019 at 10:31 AM Swapnil M Mane <

swapnilmm...@apache.org>

wrote:


Hello all,

Our OFBiz community days event for May 2019 (24th – 28th May) is

starting

from today.
Please don't forgot to update the Sprint in Jira tickets.

We have created a Jira sprint "OFBiz Community Day (May 2019)" so

please

add any Jira tasks you are working on, to it.
This Jira Sprint helps us track and report on the work done during

the

Community Days so please try to make sure your work is included.

To set the sprint on an existing issue, simply click on the "Edit"

option

on the issue and select the Sprint field.
For a new issue, please select the Sprint field at the time of Jira

ticket

creation.


- Best Regards,
Swapnil M Mane,
ofbiz.apache.org



On Mon, May 20, 2019 at 1:00 PM Swapnil M Mane <

swapnilmm...@apache.org

wrote:


Hello all,

We are pleased to announce, we are reviving the celebration of

OFBiz

community days.
The community days are organized once 

Re: Fwd: Unsubscribe footer

[Michael Brohl]

+1 for Taher's statement.

The Apache way is about community, discussion and consensus.

Not caring about the project's community opinion but simply forcing 
through own ideas or acting on behalf of the project without any 
legitimation is exactly the opposite.


Regards,

Michael


Am 07.06.19 um 13:48 schrieb Pierre Smits:

To keep everyone interested in the loop.

-- Forwarded message -
From: Taher Alkhateeb 
Date: Fri, 7 Jun 2019 at 13:44
Subject: Re: Unsubscribe footer
To: Pierre Smits 


Ignoring and disregarding community is neither an "Apache Way" nor "morally
right". When a community opposes something that someone did and their reply
is "I had an itch" it sends a message: I don't care what you think and I'm
not wrong.

Typical behavior, I'm not surprised.

On Fri, Jun 7, 2019, 12:44 PM Pierre Smits  wrote:


First of all: IANAL, and for those who don't know what that means (or don't
do acronyms): I Am Not A Lawyer!

That being said, the question has been raised and needs to be answered:
Why?

The answer to that question is simple when having the Apache Way and its
vernacular in mind:

I experienced an itch, and, per good old Apache custom, I scratched it.


I acted not only with the various anti-spam legislations in mind ([1] may
provide a good starting point).

Some here may see it ethically wrong, but it felt morally right.

[1]

https://litmus.com/blog/the-ultimate-guide-to-international-email-law-infographic

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 (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer




On Thu, Jun 6, 2019 at 2:23 PM Michael Brohl 
wrote:


Thanks everyone,

the footers are removed by Infra on my request (with apologies) with
reference to this discussion (see [1]).

@Pierre: do you want to tell us why you think it's ok to act
independently of any community consensus or even discussion?

Thanks,

Michael

[1] https://issues.apache.org/jira/browse/INFRA-18553

Am 06.06.19 um 06:37 schrieb Swapnil M Mane:

+1


- Best Regards,
Swapnil M Mane



On Wed, Jun 5, 2019 at 5:58 PM Taher Alkhateeb <

slidingfilame...@gmail.com>

wrote:


I would recommend removing all footers from all emails. It's not worth

the

extra noise for the rare occasions of some individuals not wanting to
unsubscribe.

I would also recommend that future actions with infra to be taken by a

PMC

member (after community approval) since they have access to necessary
resources and are hence best fit to guide infra on the needs of the
project.

On Wed, Jun 5, 2019, 11:09 AM Michael Brohl 
Hi all,

I've already informed Infra about this step taken without approvement
from the community, see [1]

Should I ask them to remove the footers?

Thanks,

Michael


[1] https://issues.apache.org/jira/browse/INFRA-18553


Am 03.06.19 um 15:12 schrieb Michael Brohl:

I don't think that we need a technical enforcement, community code

of

conduct should be enough.

I don't see a problem with a longer signature from newcomers here

and

there, but those who participate more often should be able to

create a

shot signature which does not pollute the mail threads.

Thanks,

Michael

Am 03.06.19 um 13:11 schrieb Jacques Le Roux:

+1

But I can't see a way to enforce that. Apart maybe asking infra,

and

even then not sure it makes sense for "external writers" who have
those kinds of disclaimer messages at bottom

Jacques

Le 03/06/2019 à 12:36, Michael Brohl a écrit :

Good question, Taher.

This was done without any envolvement of others. I think we should
have consensus before taking any action towards infra.

Personally, I am not in favor of having another/additional
signatures. In the contrary, I would like to see them reduced to 1
or two lines to make them more readable.

Some bad example with a content/noise ratio of 1:7 lines can be

seen

below...

Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 03.06.19 um 12:24 schrieb Taher Alkhateeb:

Why was this done without community agreement first?

On Mon, Jun 3, 2019 at 8:59 AM Pierre Smits
 wrote:

The unsubscribe footer is now in play for mail to dev@ofbiz.a.o

Best regards,

Pierre Smits







smime.p7s
Description: S/MIME Cryptographic Signature

Re: Unsubscribe footer

[Michael Brohl]

Thanks everyone,

the footers are removed by Infra on my request (with apologies) with 
reference to this discussion (see [1]).


@Pierre: do you want to tell us why you think it's ok to act 
independently of any community consensus or even discussion?


Thanks,

Michael

[1] https://issues.apache.org/jira/browse/INFRA-18553

Am 06.06.19 um 06:37 schrieb Swapnil M Mane:

+1


- Best Regards,
Swapnil M Mane



On Wed, Jun 5, 2019 at 5:58 PM Taher Alkhateeb 
wrote:


I would recommend removing all footers from all emails. It's not worth the
extra noise for the rare occasions of some individuals not wanting to
unsubscribe.

I would also recommend that future actions with infra to be taken by a PMC
member (after community approval) since they have access to necessary
resources and are hence best fit to guide infra on the needs of the
project.

On Wed, Jun 5, 2019, 11:09 AM Michael Brohl 
wrote:


Hi all,

I've already informed Infra about this step taken without approvement
from the community, see [1]

Should I ask them to remove the footers?

Thanks,

Michael


[1] https://issues.apache.org/jira/browse/INFRA-18553


Am 03.06.19 um 15:12 schrieb Michael Brohl:

I don't think that we need a technical enforcement, community code of
conduct should be enough.

I don't see a problem with a longer signature from newcomers here and
there, but those who participate more often should be able to create a
shot signature which does not pollute the mail threads.

Thanks,

Michael

Am 03.06.19 um 13:11 schrieb Jacques Le Roux:

+1

But I can't see a way to enforce that. Apart maybe asking infra, and
even then not sure it makes sense for "external writers" who have
those kinds of disclaimer messages at bottom

Jacques

Le 03/06/2019 à 12:36, Michael Brohl a écrit :

Good question, Taher.

This was done without any envolvement of others. I think we should
have consensus before taking any action towards infra.

Personally, I am not in favor of having another/additional
signatures. In the contrary, I would like to see them reduced to 1
or two lines to make them more readable.

Some bad example with a content/noise ratio of 1:7 lines can be seen
below...

Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 03.06.19 um 12:24 schrieb Taher Alkhateeb:

Why was this done without community agreement first?

On Mon, Jun 3, 2019 at 8:59 AM Pierre Smits
 wrote:

The unsubscribe footer is now in play for mail to dev@ofbiz.a.o

Best regards,

Pierre Smits







smime.p7s
Description: S/MIME Cryptographic Signature

Re: Unsubscribe footer

[Michael Brohl]

Hi all,

I've already informed Infra about this step taken without approvement 
from the community, see [1]


Should I ask them to remove the footers?

Thanks,

Michael


[1] https://issues.apache.org/jira/browse/INFRA-18553


Am 03.06.19 um 15:12 schrieb Michael Brohl:
I don't think that we need a technical enforcement, community code of 
conduct should be enough.


I don't see a problem with a longer signature from newcomers here and 
there, but those who participate more often should be able to create a 
shot signature which does not pollute the mail threads.


Thanks,

Michael

Am 03.06.19 um 13:11 schrieb Jacques Le Roux:

+1

But I can't see a way to enforce that. Apart maybe asking infra, and 
even then not sure it makes sense for "external writers" who have 
those kinds of disclaimer messages at bottom


Jacques

Le 03/06/2019 à 12:36, Michael Brohl a écrit :

Good question, Taher.

This was done without any envolvement of others. I think we should 
have consensus before taking any action towards infra.


Personally, I am not in favor of having another/additional 
signatures. In the contrary, I would like to see them reduced to 1 
or two lines to make them more readable.


Some bad example with a content/noise ratio of 1:7 lines can be seen 
below...


Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 03.06.19 um 12:24 schrieb Taher Alkhateeb:

Why was this done without community agreement first?

On Mon, Jun 3, 2019 at 8:59 AM Pierre Smits 
 wrote:

The unsubscribe footer is now in play for mail to dev@ofbiz.a.o

Best regards,

Pierre Smits







smime.p7s
Description: S/MIME Cryptographic Signature

Re: Unsubscribe footer

[Michael Brohl]

I don't think that we need a technical enforcement, community code of 
conduct should be enough.


I don't see a problem with a longer signature from newcomers here and 
there, but those who participate more often should be able to create a 
shot signature which does not pollute the mail threads.


Thanks,

Michael

Am 03.06.19 um 13:11 schrieb Jacques Le Roux:

+1

But I can't see a way to enforce that. Apart maybe asking infra, and 
even then not sure it makes sense for "external writers" who have 
those kinds of disclaimer messages at bottom


Jacques

Le 03/06/2019 à 12:36, Michael Brohl a écrit :

Good question, Taher.

This was done without any envolvement of others. I think we should 
have consensus before taking any action towards infra.


Personally, I am not in favor of having another/additional 
signatures. In the contrary, I would like to see them reduced to 1 or 
two lines to make them more readable.


Some bad example with a content/noise ratio of 1:7 lines can be seen 
below...


Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 03.06.19 um 12:24 schrieb Taher Alkhateeb:

Why was this done without community agreement first?

On Mon, Jun 3, 2019 at 8:59 AM Pierre Smits  
wrote:

The unsubscribe footer is now in play for mail to dev@ofbiz.a.o

Best regards,

Pierre Smits





smime.p7s
Description: S/MIME Cryptographic Signature

Re: Unsubscribe footer

[Michael Brohl]

Good question, Taher.

This was done without any envolvement of others. I think we should have 
consensus before taking any action towards infra.


Personally, I am not in favor of having another/additional signatures. 
In the contrary, I would like to see them reduced to 1 or two lines to 
make them more readable.


Some bad example with a content/noise ratio of 1:7 lines can be seen 
below...


Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 03.06.19 um 12:24 schrieb Taher Alkhateeb:

Why was this done without community agreement first?

On Mon, Jun 3, 2019 at 8:59 AM Pierre Smits  wrote:

The unsubscribe footer is now in play for mail to dev@ofbiz.a.o

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 (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer


On Sun, Jun 2, 2019 at 9:00 PM Pierre Smits  wrote:


Hi all,

I have asked INFRA to place an unsubscribe footer automatically at the end
of each distributed posting.

Best regards,

Pierre





smime.p7s
Description: S/MIME Cryptographic Signature

Re: Plugin development with pure java

[Michael Brohl]

Just an addon to Rishi's summary: you will find services and event logic 
programmed in mini/simple lang (XML). This is deprecated and will be 
replaced by Groovy over time.


Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 07.05.19 um 13:52 schrieb Rishi Solanki:

Dear OFBiz User,
All configurations under config folder, ofbiz-component.xml, entitydef,
servicedef folders, widgets and webapp requires xml which should not be
replace, as it helps us to easily achieve complex architecture. But you can
replace all forms using any UI technologies or free market template
directly supported by OFBiz.
For business logic development there is no need to go for XML instead you
can use the complete Java or Java like scripting language groovy. Please
revert back in case you are looking for something else with more details.

HTH!

Best Regards,
--
*Rishi Solanki* | Sr Manager, Enterprise Software Development
HotWax Systems <http://www.hotwaxsystems.com/>
Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center, Indore,
M.P 452010
Linkedin: *Rishi Solanki*
<https://www.linkedin.com/in/rishi-solanki-62271b7/>
Direct: +91-9893287847


On Tue, May 7, 2019 at 4:23 PM Илья Михайлов 
wrote:


Hallo!

Is it possible plugin or app development with pure java without xml?

Can you provide some examples please?

Regards, Ilya





smime.p7s
Description: S/MIME Cryptographic Signature

Re: Legacy Data

[Michael Brohl]

You can also easily generate load data by Excel itself:

- create a new sheet and insert a formula concatenating the static parts 
with the dynamic parts/cells of the data sheet (see example).


- apply the formula to each row by dragging the lower right corner of 
the cell containing the formula for the number of rows containing data


- copy the first column and paste into the load data xml file.

Example:

=CONCATENATE(
"externalId='";sheet1!C65;"' statusId='";sheet1!D65;"' />"

)

Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 01.05.19 um 18:22 schrieb ja...@productive1.com:

We are trying to upload legacy customers into ofbiz using the data
import tool.  Is there a spreadsheet template to utilize?  I uploaded my
file but the "not processed" field still shows 0.  Can someone send me
the excel template for uploading?

Thanks,

James




smime.p7s
Description: S/MIME Cryptographic Signature

Re: Problem creating task and phases in Projects

[Michael Brohl]

Please see https://ofbiz.apache.org/mailing-lists.html

Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 15.04.19 um 08:42 schrieb ariela.ele...@gmail.com:

Hello Jacques,

I am trying to find the link to subscribe to the users mailing list, but I 
can't find it. It says:
- Log in using a Google Account
- Log in using Apache
  But it doesn't give the option to register.

Could you send me the direct link to subscribe?.

Thank you


On 2019/04/12 11:17:36, Jacques Le Roux  wrote:

Hi,

Your message has been moderated.

Please subscribe to the user ML for such questions and then use your email 
client
See also why here http://ofbiz.apache.org/mailing-lists.html

You will get a better support , it's more fair to share with everybody  and 
people can answer you on the ML rather than directly to you
The wider the audience the better the answers you might get

Also it's more work for moderators who have to accept your messages as long as 
you have not subscribed.
I'll personally no longer accept them (other moderators still could)

Thanks

Jacques

Le 12/04/2019 à 10:27, ariela.ele...@gmail.com a écrit :

Hello,

I have downloaded Apache recently and I am trying to use the Project section.

I found a few problems and I would like to know if somebody could help me with 
them:

- I created a new Project and then I tried to create a few Phases associated 
with that project. The phases were created but the start and end dates are by 
default today's date, and there is no options to edit the phases schedule.

- When I try to open the schedule of the new phases nothing happens, the 
emerging window does not work.

- When I try to create a new Task, associated with the new phases of the 
project, it does not recognize the new phases and gives me the option to 
associate the new task to phases of other existing demo projects and not the 
new one.

Thank you very much and I will be waiting for your response





smime.p7s
Description: S/MIME Cryptographic Signature

Re: Responsive Theme

[Michael Brohl]

As far as I know, Scipio is not compatible with current versions of 
standard OFBiz.


It's based on the 14.12 branch which is out of support and the 
widget/template mechanism was changed.


Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 12.04.19 um 23:58 schrieb jhlab:

Hello,
I would like to know if there is any responsive theme to use with Ofbiz

and

I would also like to know if Scipio ERP (Ofbiz fork) responsive themes can be 
used within Ofbiz

Thanks!
Regards




smime.p7s
Description: S/MIME Cryptographic Signature