CVE-2023-50968: Apache OFBiz: Arbitrary file properties reading and SSRF attack

[Nicolas Malin]

Severity: important

Affected versions:

- Apache OFBiz through 18.12.10

Description:

Arbitrary file properties reading vulnerability in Apache Software Foundation 
Apache OFBiz when user operates an uri call without authorizations.

The same uri can be operated to realize a SSRF attack also  without  
authorizations.

Users are recommended to upgrade to version 18.12.11, which fixes this issue.

Credit:

Yun Peng - 郭 运鹏  (finder)

References:

https://ofbiz.apache.org/download.html
https://ofbiz.apache.org/security.html
https://ofbiz.apache.org/release-notes-18.12.11.html
https://issues.apache.org/jira/browse/OFBIZ-12875
https://ofbiz.apache.org/
https://www.cve.org/CVERecord?id=CVE-2023-50968

Re: Unit Price & Adjustments

[Nicolas Malin]

Normally if you edit your order lines like 
https://demo-trunk.ofbiz.apache.org/ordermgr/control/editOrderItems?orderId=DEMO10090 
you have a adjustment line to add it manually


Nicolas

Le 20/11/2023 à 14:12, Emad Radwan a écrit :

Hello Community,

In the sales order workflow, is there a way to create a 'manual'
adjustment; a discount for example? If yes, what is the UI to do this?

If the above is true, how will this affect the unit price? In other words,
will it be added as an order adjustment for that specific item but not
deducted from the list price or it will be deducted from the list price?

Regards,
Emad

Re: how to upgrade ofbiz

[Nicolas Malin]

Hi Eugen

Le 08/12/2023 à 19:05, Eugen Stan a écrit :

Thanks Nicolas,

Merging git / rebasing does not sound like a fun operation.
How does it go in practice?
How often do you encounter conflicts and how easy it is to deal with 
them.


Do you usually make changes to the ofbiz source code?
How do you add new components?
I live with it well :) because we don't touch the framework and try to 
work mostly on dedicate plugin.
The reason that we tried to improve OFBiz to support most extend cases 
through the plugin.


I am doing some research to support my PR 
https://github.com/apache/ofbiz-framework/pull/678 .

Yeah when we are on refactoring process I agree it's pain.


I believe publishing libraries will open up new deployment options.
Would love to hear your thoughs on that if you have time to check it out.
I started a review of your PR, I'll try to do a constructive return, the 
time that I understand well your goal.


Thanks for your work Eugen !
Nicolas


Regards,
Eugen

La 08.12.2023 15:25, Nicolas Malin a scris:

Hello Eugen,

 From our side, we have the ofbiz-framework dedicate on each project 
on our gitlab.
We add the official repo on available git remote, fetch and merge the 
wanted branch on the following local branch.

After rebase all depending branch to keep all up to date.

If you are not connected to git, I think the better way is retrieve 
the patch between two release tags.


Nicolas


Le 08/12/2023 à 14:12, Eugen Stan a écrit :

Hi,

How does one upgrade OFBiz from one release to the other?

Do you clone the repo and rebase your changes?


Regards,

Re: how to upgrade ofbiz

[Nicolas Malin]

Hello Eugen,

From our side, we have the ofbiz-framework dedicate on each project on 
our gitlab.
We add the official repo on available git remote, fetch and merge the 
wanted branch on the following local branch.

After rebase all depending branch to keep all up to date.

If you are not connected to git, I think the better way is retrieve the 
patch between two release tags.


Nicolas


Le 08/12/2023 à 14:12, Eugen Stan a écrit :

Hi,

How does one upgrade OFBiz from one release to the other?

Do you clone the repo and rebase your changes?


Regards,

Re: What controls the creation of one or more invoices?

[Nicolas Malin]

Hello Emad

Your invoice is created by default from each shipment did.

So if you order is linked to one shipment, you'll have only one invoice.

Nicolas

Le 15/10/2023 à 10:06, Emad Radwan a écrit :

Hello Community,

Please shed some light on this for a sales order. Let's assume the case
that the payment will be made using both Cash On Delivery and a Billing
Account, how will this affect the number of invoices?

Regards,
Emad

Re: Form reuse

[Nicolas Malin]

Hello Ernest,

Can you share me your code,

This would be help to spot the good solution :)

Nicolas

Le 13/10/2023 à 09:34, Ernest Hocking a écrit :

Good afternoon everyone,

I tried to use the include form directive in a plugin screen ( calling the
BOM form from the manufacturing application ). However ofbiz complains
about missing decorators.  Is there something else I need to specify in for
example the controller.xml to enable the full context needed to run the
form?.  The sim is to avoid the user having to switch applications (from
the plugin) to access the functionality

If anyone can point me ti an example in the code base that would be a great
help

Thanks and kind regards

Ernest

Re: Small report from ASF Conference

[Nicolas Malin]

Hello Nicola,

Thanks a lot for your feedback.

From Bratislava, we currently share at Néréide to organize the travel. 
We hope to see you face to face :) .


Nicolas


Le 12/10/2023 à 20:01, Nicola Mazzoni a écrit :

Hi OFBiz users,
I'm returning from Halifax, where the Apache "community over code" 
conference just ended.
Some negative notes, compared to last year I think there was less 
participants. One of the causes is probably political, given that many 
Indian citizens have had problems reaching Canada for the reasons we 
know.
However, the atmosphere is always very familiar and pleasant, it is 
the third Apachecon for me and I can only confirm that it is a very 
enriching experience from a human, cultural and not just strictly 
technological point of view.
The speeches were mainly focused on a limited group of projects, so 
only a small part of the more than 300 Apache projects were 
"represented". To put it very simply: the focus was on big data. This 
year there was also visibility for a business-related project (and not 
just frameworks for other developers), specifically Fineract which 
received many talks and a fair amount of interest. I think that OFBiz 
and Fineract are among the few Apache projects not aimed at developers 
but "concretely" at business users.
As a result, it was no surprise to me to find that almost none of the 
participants I spoke to were familiar with OFBiz; many were unaware of 
what an ERP was, being focused on developments of another nature.
In any case, it is an experience that I recommend everyone to have, 
even if you cannot have direct feedback on your business. However, it 
is an experience that I hope to repeat. Even though I worked on 
ERP/business software and not "frameworks" or "big data", I had the 
opportunity to learn about new projects and understand the trends of 
certain technologies. This certainly helps me to "see from above" and 
to have a different approach to certain problems that I encounter in 
my professional life. Sorry if my English is poor, but it seemed right 
to me to give a little feedback to the OFBiz community as I am the 
only OFBiz committer present (excluding my colleague Giulio Speri).


I hope to meet many of you in Bratislava for the 2024 "community over 
code" EU conference.


Best

Nicola

Re: Running a service instance

[Nicolas Malin]

Hello Ingo,

* Store your upload directory on shared volume (bucket, nfs, sshfs other 
something like that) and mount it on the same patch on each server (like 
/var/lib/ofbiz/contents)

* Use the same path for the ofbiz home on each server hosting each instance.
* Configure the upload content on your ofbiz properties

Let's rock

Nicolas


Le 21/09/2023 à 09:09, Ingo Wolfmayr a écrit :

Hi everybody,

I am thinking about the following setup and I am not sure if it is possible. If 
yes, what are the proposed configurations settings and what should be monitored 
in detail?

Instance1: main instance
- holds images, files ...
- serving views ...

Instance2: service worker instance
- process defined services
-- for example addToSolrIndex
-- import tasks - long running task

Both instances will use the same database.

My concerns:
- how do I configure instance2 to store images uploaded by an import task to 
the right directory (runtime/uploads/... of Instance1, images/products/... of 
instance1)

Any hints, thoughts about this topic would be very appreciated.

Best regards,
Ingo

Re: Cookies creates by OFBiz

[Nicolas Malin]

Hello Tomek,

This cookie help to follow the user connexion through the entity Visit 
on your website, and like this give some statistic on view page


Nicolas

Le 14/09/2023 à 09:23, Tomek a écrit :

Hi,

I'm developing a e-commerce store based on OFBiz and I have to write 
cookies policy. I have noticed that the OFBiz creates OFBiz.Visitor 
cookie. Could you explain me what is the purpose of this Cookie and 
what is it using for?


Best regards

Tomek

Re: Question on Barcode

[Nicolas Malin]

Hello Emad,

Barcode example in OFBiz work only with the productId. Help yourself to 
implement your own screen with what you need :

* create an other screen like**ProductScreens.xml#ProductBarCode.fo
* create a ftl that will contains your barcode as regards to xsl-fo 
documentation


Nicolas

Le 19/06/2023 à 13:09, Emad Radwan a écrit :

Hello Community,

I'm confused about barcodes.

1 - Does it represent another form/format of the productId or it represents
each and every occurrence of that specific product item? In other words, is
it something related to product identification or to inventory as well in
case the barcode is related to each instance of the product?

2 - Is the GoodIdentification entity related to barcode generation and
management?

Regards,
Emad

Re: ECA Custom Service

[Nicolas Malin]

Le 19/06/2023 à 13:05, Bs Serge a écrit :

Hi all,

Kindly help, I have the following ECA customization, I have simple
questions just to clarify: :


 


1. Does it  mean that the customized service will overtake the standard
service, and the results of the customized service will be considered
instead of standard service’s results. Yes or No?

NO


2. Does it mean that the standard service is replaced by the customized
service in all OFBiz operations? Yes or No?

NO


3. In that ECA case, what if I want the standard service to run based on a
parameter that is not in the service context in order to make a condition?
I can add the parameter but I have to also make sure the parameter is
present everywhere the service is called. So it becomes hierarchical. Is
there another way to do it?
As you defined, the customComissionService will be run after the 
getCommissionForProduct service with only on parameters what the 
getCommissionForProduct attendee.


If you takeover it redefine getCommissionForProduct in your custom 
component.


Nicolas


Regards,

Re: Trial of OFbiz for a service company

[Nicolas Malin]

Hello,

When you create your tax authority, do you link it to the geo IT-BA ?

Nicolas

Le 12/06/2023 à 17:16, specificpurpose a écrit :

Hello,
I'm in charge to test OFbiz as ERP and Management software for our company.
I want to use OFbiz for one of our branch providing custom services in a 
specific industry so we do not have any specific catalogue of fixed services or 
products with fixed prices.

I downloaded and installed correctly apache-ofbiz-18.12.05. It works correctly.

My first question is: where can I find a comprehensive guide to make the right 
setup (not installation) of a company management using OFbiz?

I setup the minimal information for the party registered as a company. I've 
created also the party that works like tax authority.
I'm following different guides and videos to understand these steps but I've 
not got a comprehensive guide including and describing well these steps.

Right now I have to prepare a first sales offer for a client. I've found only 
this guide about this 
topics:https://cwiki.apache.org/confluence/display/OFBIZ/Sales+Order+Management+Process+Overview
Thus, following this last guide I've understood I have to create a Product 
Store before preparing a sales offer.

So I'm following this guide to create a product 
store:https://cwiki.apache.org/confluence/display/OFBENDUSER/Product+Stores
 From Catalogue Manager I clicked on the button +New Product Store and I filled 
the required information. Clicking on update, I got the following long message 
error:

The Following Errors Occurred:

Exception thrown while creating the "newEntity" GenericValue: 
org.apache.ofbiz.entity.GenericEntityException: Error while inserting: 
[GenericEntity:ProductStore][addToCartRemoveIncompat,Y(java.lang.String)][addToCartReplaceUpsell,Y(java.lang.String)][allowComment,Y(java.lang.String)][allowPassword,N(java.lang.String)][authDeclinedMessage,null()][authErrorMessage,null()][authFraudMessage,null()][autoApproveInvoice,N(java.lang.String)][autoApproveOrder,N(java.lang.String)][autoApproveReviews,N(java.lang.String)][autoInvoiceDigitalItems,N(java.lang.String)][autoOrderCcTryExp,Y(java.lang.String)][autoOrderCcTryLaterMax,null()][autoOrderCcTryLaterNsf,Y(java.lang.String)][autoOrderCcTryOtherCards,Y(java.lang.String)][autoSaveCart,N(java.lang.String)][balanceResOnOrderCreation,N(java.lang.String)][checkGcBalance,N(java.lang.String)][checkInventory,N(java.lang.String)][companyName,SD
 Companies(java.lang.String)][createdStamp,2023-06-12 
17:10:57.705(java.sql.Timestamp)][createdTxStamp,2023-06-12 
17:10:57.692(java.sql.Timestamp)][daysToCancelNonPay,null()][defaultCurrencyUomId,EUR(java.lang.String)][defaultLocaleString,null()][defaultPassword,null()][defaultSalesChannelEnumId,UNKNWN_SALES_CHANNEL(java.lang.String)][defaultTimeZoneString,IT(java.lang.String)][digProdUploadCategoryId,null()][digitalItemApprovedStatus,ITEM_APPROVED(java.lang.String)][enableAutoSuggestionList,N(java.lang.String)][enableDigProdUpload,N(java.lang.String)][explodeOrderItems,N(java.lang.String)][headerApprovedStatus,ORDER_APPROVED(java.lang.String)][headerCancelStatus,ORDER_CANCELLED(java.lang.String)][headerDeclinedStatus,ORDER_REJECTED(java.lang.String)][inventoryFacilityId,1(java.lang.String)][isDemoStore,N(java.lang.String)][isImmediatelyFulfilled,N(java.lang.String)][itemApprovedStatus,ITEM_APPROVED(java.lang.String)][itemCancelStatus,ITEM_CANCELLED(java.lang.String)][itemDeclinedStatus,ITEM_REJECTED(java.lang.String)][lastUpdatedStamp,2023-06-12
 17:10:57.705(java.sql.Timestamp)][lastUpdatedTxStamp,2023-06-12 
17:10:57.692(java.sql.Timestamp)][managedByLot,N(java.lang.String)][manualAuthIsCapture,N(java.lang.String)][oldHeaderLogo,null()][oldHeaderMiddleBackground,null()][oldHeaderRightBackground,null()][oldStyleSheet,null()][oneInventoryFacility,Y(java.lang.String)][orderDecimalQuantity,null()][orderNumberPrefix,SERVIZIO(java.lang.String)][payToPartyId,1(java.lang.String)][primaryStoreGroupId,null()][prodSearchExcludeVariants,Y(java.lang.String)][productStoreId,10010(java.lang.String)][prorateShipping,Y(java.lang.String)][prorateTaxes,Y(java.lang.String)][reqReturnInventoryReceive,null()][reqShipAddrForDigItems,Y(java.lang.String)][requireCustomerRole,N(java.lang.String)][requireInventory,N(java.lang.String)][requirementMethodEnumId,null()][reserveInventory,Y(java.lang.String)][reserveOrderEnumId,null()][retryFailedAuths,Y(java.lang.String)][selectPaymentTypePerItem,N(java.lang.String)][setOwnerUponIssuance,null()][shipIfCaptureFails,Y(java.lang.String)][showCheckoutGiftOptions,Y(java.lang.String)][showOutOfStockProducts,N(java.lang.String)][showPricesWithVatTax,N(java.lang.String)][showTaxIsExempt,N(java.lang.String)][splitPayPrefPerShpGrp,Y(java.lang.String)][storeCreditAccountEnumId,FIN_ACCOUNT(java.lang.String)][storeCreditValidDays,null()][storeName,Servizi
 - Ufficio 

Re: Job priority

[Nicolas Malin]

Hello Ingo,

At this time no priority are present on service job.

For our part, when this appear we deploy a dedicate ofbiz with it own 
pool for high level job.


We also thinking about increase the capacity for the service engine to 
manage job (sharing charge, priority, dedicate pool) but not take the 
time o implement.


Nicolas

Le 15/06/2023 à 08:44, Ingo Wolfmayr a écrit :

Hi everybody,

I have seen that there is an option to define the priority of a job  (LOW, 
HIGH, NORMAL). Where and how is it supposed to be set.

For example I have the job "addToSolr" set as async eca and want it to run with 
low priority. Sending e-mail confirmations should be run with higher priority.

Best regards,
Ingo

Re: Pricing process in the Quote

[Nicolas Malin]

Hello,

The pricing for the quote is exactly the same than an order.

Can you explain your attendee case ?

Nicolas

Le 13/06/2023 à 20:13, specificpurpose a écrit :

Hi Team,

Could you please help with any documentation describing the pricing settings 
for new quotes processes?
Quick help will be appreciated!

Sent with [Proton Mail](https://proton.me/) secure email.

Re: how can I increase the size of any column of SecurityGroup entity

[Nicolas Malin]

What's didn't works ?

When you recreate all the db with OFBiz after a change, or just restart 
OFBiz on existing database ?


On the second you need to apply an ALTER TABLE on your field.

For the first, check that you modified the good fieldType file.

Nicolas

On 20/05/2023 12:06, Mahi maheshwari wrote:

Hello Community,

I'm trying to change the size of groupId column of the SecurityGroup 
entity.

I tried changing the size from 20 to 80 as mentioned below.

Method: 1

I replaced this line with the below line of code




Method: 2
and also tried changing the below-mentioned code, I changed the type 
to the description for groupId.




      
      
      
    

both methods didn't work, please guide me If I'm going wrong anywhere.
I'm also attaching the screenshot for you to have a look at.

Regards,
Maheshwari.

Re: Uploading of file

[Nicolas Malin]

Hello Swati,

You already have all in ofbiz to load natively. Check on the source code 
the service uploadPartyContentFile.


    transaction-timeout="300">

    Upload and attach a file to a party
    
    result-to-context="true"/>

    
    
    

You create you own service who load the file through 
createContentFromUploadedFile and after call your specific working 
process on second service.


After for the form ckeck all form with 'type="upload" ' with a attribute of type 


Nicolas

On 18/05/2023 00:54, Swati Srivastava wrote:

Hello Community.



I am trying to upload a file (image/txt/word/pdf) in the ofbiz application 
using ftl and java method. After parsing the file , item listed in the list is 
coming as null. Please help.



My FTL code is a simple form like below with name testUpload.ft

​



     

     





My controller is configured as follows:











   








     

     

     





In the java class FileUpload.java:



package com.apache.xerus.services;



import org.apache.commons.fileupload.FileItem;

import org.apache.commons.fileupload.FileUploadException;

import org.apache.commons.fileupload.disk.DiskFileItemFactory;

import org.apache.commons.fileupload.servlet.ServletFileUpload;

import java.io.File;

import java.nio.ByteBuffer;

import java.util.HashMap;

import java.util.List;

import java.util.Locale;

import java.util.Map;

import javax.servlet.ServletConfig;

import javax.servlet.ServletContext;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.io.IOException;

import java.net.URLEncoder;

import java.util.Locale;

import org.apache.commons.io.FilenameUtils;

import java.io.InputStream;

import java.io.OutputStream;

import java.io.OutputStreamWriter;

import java.io.Writer;

import java.net.HttpURLConnection;

import java.net.URL;

import org.apache.ofbiz.base.util.Debug;

import org.apache.ofbiz.base.util.GeneralException;

import org.apache.ofbiz.base.util.GeneralRuntimeException;

import java.util.Iterator;

import org.apache.ofbiz.entity.Delegator;

import org.apache.ofbiz.entity.GenericEntityException;

import org.apache.ofbiz.entity.GenericValue;

import org.apache.ofbiz.service.LocalDispatcher;

import org.apache.ofbiz.base.util.UtilGenerics;

import org.apache.ofbiz.base.util.UtilHttp;

import javax.servlet.http.HttpSession;

import org.apache.ofbiz.base.util.FileUtil;

import org.apache.ofbiz.base.util.UtilProperties;

import org.apache.ofbiz.service.ServiceUtil;





public class FileUpload {



     public static final String module = FileUpload.class.getName();




     public static String uploadFile(HttpServletRequest request, 
HttpServletResponse response) {

   


   // Check if the request is a multipart request

     boolean isMultipart = ServletFileUpload.isMultipartContent(request);



     if (isMultipart) {

     // Create a file upload handler

     DiskFileItemFactory factory = new DiskFileItemFactory();

     ServletFileUpload upload = new ServletFileUpload(factory);



     try {

     // Parse the request

     List items = upload.parseRequest(request);

     System.out.println(" Items present : "+items);

     // Process each uploaded file

     for (FileItem item : items) {

     if (!item.isFormField()) {

     // Get the uploaded file name

     String fileName = item.getName();

     System.out.println("fileName : "+fileName);

     // Get the uploaded file content

     byte[] fileContent = item.get();

     System.out.println("fileContent : "+fileContent);

     // Process the file as needed (e.g., save to disk, 
store in database, etc.)

     // ...

     }

     }

     } catch (FileUploadException e) {

     Debug.logError(e, module);

     Debug.logError("[FileUpload.FileUpload] " + e.getMessage(), 
module);

     }

     } else {

     System.out.println("It is not multipart");

     }





I have added the screen in XerusSceen.xml and logging in the app by typing 
localhost:8443/xerus/control/fileUplodingFtl and the page is opening but when I 
am selecting the file and pressing the Upload button, I can see in the logs of 
ofbiz  as  ' Items present: {} '. I am wondering , what is wrong with this 
code? Why is there no file present



Please guide me how to achieve uploading of files in OFbiz



Thank You



Regards,

Swati

Re: AW: Async Services

[Nicolas Malin]

Hello,

With persist='false' your service will running on an other thread
With persist='true' your service will store on jobSandbox entity for an 
execution throw the job poller


Nicolas

On 07/03/2023 08:24, Ingo Wolfmayr wrote:

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: Manual for distribution build

[Nicolas Malin]

You can use it on production site with systemd, untar on /opt and uste 
it like


|# nano /etc/systemd/system/ofbiz.service|

|[Unit] Description=OFBiz [Service] Type=exec User=ofbiz 
WorkingDirectory=/opt/ofbiz/ EnvironmentFile=/etc/default/ofbiz 
ExecStart=/usr/bin/ofbiz -u ExecStop=/usr/bin/ofbiz -d [Install] 
WantedBy=multi-user.target|



|# ln -s /opt/ofbiz/bin/ofbiz /usr/bin/ofbiz|
|# systemctl daemon-reload
||

# systemctl start ofbiz
|||
Nicolas

On 03/02/2023 13:38, Ingo Wolfmayr wrote:


Hi Community,

is there a description what can be done with the ofbiz.tar/zip files 
in build/distribution.


Best regards,

Ingo

Mag. (FH) Ingo Wolfmayr

*Wolfix Solutions*

Gänsgasse 14

A-5282 Ranshofen

Tel.: +43 (0) 664 2549626

Web: https://www.wolfix.at

Xing: https://www.xing.com/profile/Ingo_Wolfmayr/

emailsignatur

Re: Calling grubbgroovy device from form field

[Nicolas Malin]

To complete

You can define a request-map

    

    

    

    

    



    


on









This works only on OFBiz 22.01, on previous version you need to use 
javascript call directly


  



Don't forget to define your screen DisplayTestCal with the simple decorator to 
minimize the html code return on the response

Nicolas

On 24/01/2023 08:23, Taher Alkhateeb wrote:

Hello,

So you cannot call groovy, or any other programming language for that matter, 
from your browser. The only thing you can call from the browser is javascript 
and the DOM.

So if you want to wire a button to some piece of code that you would like to 
execute, then this is simply a good-old http-request / http-response thing just 
like in any other technology / programming language / framework.

So what you want to do, is to call an end-point that is defined in 
Controller.xml and pass whatever parameters you need to it, and from there now 
you're in server-land and you can do whatever you're used to in OFBiz. Note 
that it's quite different to call an HTTP end-point by submitting a form (the 
browser does it) vs calling it from Javascript (you do it) because in the 
latter case you are not redirected to another page.

In other words, perhaps the problem is simply not differentiating between what 
is server-side code and client-side code. If you make the distinction clear 
then you just realize it's a matter of HTTP communication between the two.

I hope this helps!

Cheers,

Taher Alkhateeb

On Tuesday, January 24, 2023 04:09 +03, Ernest 
Hocking  wrote:
  Hi everyone

I'd like to use groovy to implement some business logic and call that logic
from a button in a form.

E.g Add a button on the product measures form to calculate the volume
given a product's dimensions.. I've tried







I can call/test the service "testCalc" from webtools etc but not use the
button.

Can anyone point me to an example in the existing code base that I can use
as a reference model.

thanks in advance

Ernest

Jira non-asf account disabled

[Nicolas Malin]

Hello Guys,

Non asf accounts was disabled the last month, on a discussion with the 
conclusion here [1]/.
By the way If anyone have a problem to login one the asf jira, don't 
hesitate to send a message to priv...@ofbiz.apache.org with :


  * your email address
  * preferred username (N.B. hyphens not allowed) different than your 
currently

  * alternate username (in case the preferred one is already in use)
  * display name, if it is different from the username

Or replay to this message if send to private is disrupting for you.

I'll watch any demand.

You can have the asf process here [2]

Cheers,

Nicolas

[1] https://infra.apache.org/blog/jira-public-signup-disabled.html
[2] https://infra.apache.org/jira-guidelines.html#account

Re: Applying patch for ofbiz 18.12.06

[Nicolas Malin]

Hello,

You can extract the needed patch with git between official tag.

If you want I already do that and available from the nereide's cloud [1] 
but it's unofficial and own our risk


Cheers,
Nicolas

[1] https://cloud.nereide.fr/index.php/s/8PsEJiE2LQnqGRM

On 03/09/2022 04:08, Avijit Bose wrote:

Hi Jac,

Your message is not clear. Request...pls clarify it clearly how to apply
patch for individual cases or for all items together.

regards
Avijit

On Fri, Sep 2, 2022 at 5:21 PM Jacques Le Roux
wrote:


Hi,

You need at least the Sub-task (related to security) and Bug lists here:
https://ofbiz.apache.org/release-notes-18.12.06.html

For the rest it's up to you...

HTH

Jacques

Le 02/09/2022 à 12:54, Avijit Bose a écrit :

Hi,

Presently I am using 18.12.05. All applications are set. I wish not to
install 18.12.06 afresh and new. I am thinking of applying patch to

upgrade

from 18.12.05 to 18.12.06.

Please let us know how to apply patches correctly with patch files.

regards
Avijit

Re: Success message stuck

[Nicolas Malin]

This is normal process when you use entity-auto.

If you want a dedicate message or no message, override you service by an 
other




  

BookServices.groovy:

def createBookForUser() {
   run service: 'createBook', with: parameters
   return success("My message")
//or
//   return success()
}

Nicolas

On 30/07/2022 05:21, Avijit Bose wrote:

Hello,

1. After completion of a db row creation, the blue success message (alert)
is showing but gets stuck. It does not 'goes off' of its own. Clicking the
close (X) button does not work. I am using a simple create service method
to create a single row in db.

*

Create New Book


 
*

2. It also happens when creating many rows in many database consecutively
in a single process.

No error message etc.

Pls let me know why this happens?

Re: Transforming ofbiz FIND and corresponding LIST in FTL

[Nicolas Malin]

You're welcome

On 18/07/2022 10:05, Avijit Bose wrote:

Thank you Nicolas it worked.

regards
Avijit

On Mon, Jul 18, 2022 at 10:59 AM Avijit Bose  
wrote:


I am using 18.12.05 version.

As you suggested... I will try and update you all.

thank you
Avijit

On Mon, Jul 18, 2022 at 9:40 AM Nicolas Malin
 wrote:

Which Apache OFBiz version you use ? mini-lang is deprecated
and I invite you to use groovy dsl instead.

After that, call your find from as script on screen action
element.

Put your result on the context and iterate from ftl like :
applications/accounting/widget/ap/InvoiceScreens.xml#CommissionRun

Nicolas

On 18/07/2022 05:49, Avijit Bose wrote:

Dear Sir,

Presently the ofbiz FIND and its corresponding LIST is written in 
minilang
in ofbiz Forms.

Pls let us all know how we can convert this into ftl file. In other
words how to implement FIND and its LIST in FTL.

If this can be done then we can use FTL in all the code except screens,
etc. which will make coding life very easy.

It seems that there are lots of bottlenecks in minilang which is making
coding tougher.

regards
Avijit

Re: Transforming ofbiz FIND and corresponding LIST in FTL

[Nicolas Malin]

Which Apache OFBiz version you use ? mini-lang is deprecated and I 
invite you to use groovy dsl instead.


After that, call your find from as script on screen action element.

Put your result on the context and iterate from ftl like :
applications/accounting/widget/ap/InvoiceScreens.xml#CommissionRun

Nicolas

On 18/07/2022 05:49, Avijit Bose wrote:

Dear Sir,

Presently the ofbiz FIND and its corresponding LIST is written in minilang
in ofbiz Forms.

Pls let us all know how we can convert this into ftl file. In other
words how to implement FIND and its LIST in FTL.

If this can be done then we can use FTL in all the code except screens,
etc. which will make coding life very easy.

It seems that there are lots of bottlenecks in minilang which is making
coding tougher.

regards
Avijit

Re: Viewing PDF and Image in New Tab/Window in Ofbiz

[Nicolas Malin]

Hello,

Load your pdf as content and call stream request-map
like this :

applications/accounting/widget/AgreementForms.xml#ListAgreementContent :
    
    description="${contentName}" key-field-name="contentId">
    description="${contentId}" link-type="anchor">

    
    
    
    

Nicolas

On 18/07/2022 05:40, Avijit Bose wrote:

Dear Sir,

I have a link in the form as shown below:
--

 
   
 

--

Note: "salaryCertificateUrl" is a path of a pdf file. I DON'T WANT TO
GENERATE PDF FILE. JUST WANT TO VIEW PRE_GENERATED PDFs. I am uploading it
and then wants to view it from the link in my form. Same this for images.

Pls let me know how do I view this.

regards
Avijit

Re: Can Columns in an entity be array

[Nicolas Malin]

hello Swati

You can check on this file framework/entity/fieldtype/fieldtypepostgres.xml

Currently there is not field type for table, feel free to improve it !

Others way, use a string as list.

Nicolas

On 11/07/2022 21:47, Swati Srivastava wrote:

Hello,

I am making a new entity in entitymodel.xml file of my plugin. My requirement 
is to have a column as array. In postgres it is possible but just want to know 
if it is feasible in ofbiz or not. As far as I have found, type is not 
described as String[] or id[] anywhere in ofbiz but can we make changes 
anywhere to create a column as an array. Please let me know if it can be done.



Thank You



Regards

Swati Srivastava

Re: Passing "CONTEXT" from FTL to Java

[Nicolas Malin]

Hello Avijit,

Can you share some peace of code, I didn't understand your ftl to java ?

You have a ftl template and go to java service through request call or
you want to call a java code on a ftl code ?

Nicolas

On 28/06/2022 12:45, Avijit Bose wrote:
> Dear Sir,
>
> Can the 'context' be passed from a ftl file to java?
>
> I see a 'globalContext' in this link...
> https://cwiki.apache.org/confluence/display/OFBIZ/Variables+always+available+in+screen+context
>
> My goal is to use context here..
> ---
> dbName.setNonPKFields(context);
> -
> in a method...
> 
> public static String createSubscriber(HttpServletRequest request,
> HttpServletResponse response) {  }
> ---
> can I use 'globalContext' in place of 'context'?
>
> regards
> Avijit
>

Re: Caching does not work if offset and limit are used in a query

[Nicolas Malin]

Hello Rishi,

Check with an EntityListIterator instead of a List, like it already done
with performFind service and Form list.

You extract from the data base only the segment needed through a
database pointer.

Nicolas

On 08/07/2022 08:30, Rishi Agr wrote:
> Hi, I have created a view and the query on it has the pagination
> implementation. The search on this view returns more than one page of data
> and I would like to cache this. I've observed that the cache does not work
> as expected if I have the offset and limit in the query. Also, if I change
> the page size the previous selected size is not overridden. Let me know if
> I need to add some other stuff in the query to make it work. Thank you.
>

Re: List table field width or column size

[Nicolas Malin]

Yes use size attribute on the child element of the field
Nicolas

On 17/05/2022 04:01, Avijit Bose wrote:
> Hello Sir,
>
> I am using lots of List table after performFind in ofbiz. When a
> certain column data is long...it pushes the entire table leftward or
> rightward disturbing the table UI. Is it possible to set the column
> width or size for individual field in find list?
>
> regards
> Avijit

Re: Ofbiz FIND Constraints

[Nicolas Malin]

   
   

 
And your target return on form with performFind like 
applications/order/widget/ordermgr/FieldLookupForms.xml#ListLookupOrderHeader

Nicolas

On 13/05/2022 06:27, Avijit Bose wrote:
> Hello,
>
> Presently I am using FIND as mentioned below:
> ---
>  target="FindDomesticCustomers" default-entity-name="AkmCustomer">
>   
> 
> 
> 
>  key-field-name="customerId" entity-name="AkmCustomer">
> 
> 
> 
> 
> 
>  widget-style="smallSubmit">
>  image-location="/images/icons/magnifier.png"/>
> 
> 
> --
>
> I need to put some entity constraints in FETCHING rows from the
> AkmCustomer entity. Like ' where customerTypeId = 'Domestic' '.
>
> Pls let me know how to put the constraints in the search form. So that
> when I click the 'Find' button with noConditionFind = Y, the list
> should show only rows whose   " customerTypeId = ''Domestic" ".
>
> Pls help.
>
> regards
> Avijit

Re: Urgent please. Ofbiz hang while loadAll CleanAll

[Nicolas Malin]

Emad, It's really hard to help you with few information.

Give me your framework/entity/config/entityengine.xml (without password)
and all log return by ofbiz after the cmd ./gradlew loadAll

Thanks,
Nicolas

On 13/05/2022 12:56, Emad Radwan wrote:
> Hello Community,
>
> With a fresh install and while running ‘gradlew cleanAll loadAll’ the process 
> hangs at the following message.
>
> I dropped the DB,  re-created it, and started the process a few times with 
> the same error.
>
> Appreciate your help, please.
>
> Regards,
> Emad
>
> 2022-05-13 12:41:48,322 |main |ServiceDispatcher 
> |T| Sync service [entity-default/getInventoryAvailableByFacility] finished in 
> [16] milliseconds
> 2022-05-13 12:41:48,400 |main |UtilProperties
> |I| ResourceBundle DefaultMessagesUiLabels (en) created in 0.078s with 11 
> properties
> c

Re: Confused about Customer request Item table and product price relation

[Nicolas Malin]

Hello Emad,

You you initialize your CustRequest, You have the functional context to
resolve the product price use (invoice, order, quote). So propage your
unit price on the custRequestItem.

Nicolas


On 10/05/2022 22:24, Emad Radwan wrote:
> Hello Community,
>
> I need help, please. CustRequestItem table reference Product via productId. 
> On the other hand, each product may have different prices as per 
> product_prices table. The question here, by storing only productId in 
> CustRequestItem how Ofbiz will remember such info as maybe the request was 
> made based on a promo price not the default one?
>
> Regards,
> Emad

Re: Help needed - Ofbiz Find from list

[Nicolas Malin]

Hello Avijit,

My correction in line

On 13/05/2022 04:42, Avijit Bose wrote:
> Hello,
>
> First: I have a list in the groovy file which as follows:
> 
> EntityCondition condition1 = EntityCondition.makeCondition(
> EntityCondition.makeCondition("customerTypeId", "Domestic")
> )
> List domesticCustomerList = from("AkmCustomer").where(condition1).queryList();
> context.domesticCustomerList = domesticCustomerList;
context.domesticCustomerList = from("AkmCustomer").where(customerTypeId:
"Domestic").queryList()
> ---
>
> Second: [...]
> ---
>
>  target="FindDomesticCustomers" list-name="domesticCustomerList">

> [...]
> 
> ---
>
> Third: I have a list form as mentioned below.
> ---
>  list-name="listIt" paginate-target="FindDomesticCustomers"
> default-entity-name="domesticCustomerList">

> [...]
> ---
>
> Problem: I am not able to search items from the '
> list-name="domesticCustomerList" ' when clicking the 'Find' button.
>
> Please help.
>
> regards
> Avijit
You can also remove your script and just do :

 
   
   
   
   
   ...


Nicolas

Re: Product Name storage and search and image storage

[Nicolas Malin]

Hello Hussain,
please help your-self :
https://ofbiz.apache.org/mailing-lists.html : Un-subscribing from our
Mailing Lists

Nicolas

On 09/05/2022 09:36, Hussain Thangal wrote:
> Please unsubscribe me from user lists.
> With best regards.
>
>> On 9 May 2022, at 9:47 AM, Rishi Agr  wrote:
>>
>> Hi,
>> I have a situation where I need to store the name and description of the
>> product is language specific (one product with name in different languages)
>> and needs to be stored in the database. In my understanding, the Product
>> table does not have this flexibility. I wanted to store these in the
>> Content table and refer to ProductContent. For this I need some small code
>> snippets to implement the product search on product name. Do I need to add
>> these values in ProductKeywordNew or do we have different ways to search. I
>> do not have knowledge of productSearch and could be very useful to me if
>> someone provides some code snippet with some explanation or a link to any
>> existing document that can help me out in this regard.
>>
>> Also, I need to store several images and was thinking of using the Content
>> table itself instead of using the Product table. Need your suggestions on
>> this.
>>
>> Thank you.

Re: Product Name storage and search and image storage

[Nicolas Malin]

Hello Rishi,

You currently do here [1], use "Create New Product Content" and not
"Override Simple Fields"

After the better way would be dedicate your own screen to manage product
content connected to the different services

Nicolas

[1] here
https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductContent?productId=WG-9943

On 09/05/2022 08:47, Rishi Agr wrote:
> Hi,
> I have a situation where I need to store the name and description of the
> product is language specific (one product with name in different languages)
> and needs to be stored in the database. In my understanding, the Product
> table does not have this flexibility. I wanted to store these in the
> Content table and refer to ProductContent. For this I need some small code
> snippets to implement the product search on product name. Do I need to add
> these values in ProductKeywordNew or do we have different ways to search. I
> do not have knowledge of productSearch and could be very useful to me if
> someone provides some code snippet with some explanation or a link to any
> existing document that can help me out in this regard.
>
> Also, I need to store several images and was thinking of using the Content
> table itself instead of using the Product table. Need your suggestions on
> this.
>
> Thank you.
>

Re: Help required in Ofbiz development - Unable to retrieve parameter using HTTPRequest

[Nicolas Malin]

I use in groovy event

***
    Map requestAttrs = UtilHttp.getAttributeMap(request)
    Map parameters = UtilHttp.getParameterMap(request)
***

It's same with java
Nicolas

On 29/04/2022 04:34, Avijit Bose wrote:
> Hello Nicolas,
>
> Could you pls give me an example or some piece of code of how to use
> “raw method to resolve parameters from the request”?
>
> I am sending you this reply again because I had sent it in html format
> which the server refused.
>
> regards
> Avijit Bose
>
> On Thu, Apr 28, 2022 at 7:29 PM Avijit Bose  wrote:
>> Hello Sir,
>>
>>
>>
>> Could you pls show me an example of how to use “raw method to resolve 
>> parameters from the request”?
>>
>>
>>
>> regards
>>
>>
>>
>> Sent from Mail for Windows
>>
>>
>>
>> From: Nicolas Malin
>> Sent: 28 April 2022 12:19 PM
>> To: user@ofbiz.apache.org
>> Subject: Re: Help required in Ofbiz development - Unable to retrieve 
>> parameter using HTTPRequest
>>
>>
>>
>> Hello,
>>
>>
>>
>> You use a raw method to resolve parameters from the request.
>>
>>
>>
>> I suggest that the problem came from the form html definition. When you
>>
>> submit do you analyzed the request send by your browser ? (F12 ->
>>
>> Network on firefox)
>>
>>
>>
>> Nicolas
>>
>>
>>
>> On 28/04/2022 05:48, Avijit Bose wrote:
>>
>>> My code is as follows:
>>> “finalizeLC.ftl”
>>>  
>>> 
>>>   >>  name="finalizeLCUpdate" id="finalizeLCUpdate">
>>>
>>>
>>>
>>>  
>>> 
>>>   
>>> 
>>> 
>>> 
>>>>> for="LcReceiveDate">${uiLabelMap.LcReceiveDate}
>>> 
>>> 
>>>>> style="background-color:#D6F2FF" value="${LcReceiveDate!}" required>
>>> 
>>> 
>>>   
>>>   
>>> 
>>> 
>>> 
>>>>> for="countDownDays">${uiLabelMap.countDownDays}
>>> 
>>> 
>>>>> name="countDownDays" style="background-color:#D6F2FF"
>>> value="${countDownDays!}" required>
>>> 
>>> 
>>>   
>>> 
>>> 
>>> 
>>> 
>>>>> for="remarks">${uiLabelMap.remarks}
>>> 
>>> 
>>>  >> value="${remarks!}" name="remarks" size="100"
>>> style="background-color:#D6F2FF" required>
>>> 
>>> 
>>>   
>>> 
>>>   
>>>  
>>> 
>>>   
>>> 
>>> 
>>> 
>>> 
>>> 
>>>  >> value="Submit">${uiLabelMap.finalizeLC}
>>>
>>> 
>>>   
>>> 
>>>   
>>> 
>>> 
>>> “UpdateLCServices.java and method finalizeLCUpdate”
>>> 
>>>public static String finalizeLCUpdate(HttpServletRequest
>>> request, HttpServletResponse response) {
>>>   Delegator delegator = (Delegator)
>>> request.getAttribute("delegator");
>>>   String LcReceiveDate =
>>> request.getParameter("LcReceiveDate").trim();
>>>  String countDownDays =
>>> request.getParameter("countDownDays").trim();
>>>   String remarks = 
>>> request.getParameter("remarks").trim();
>>>  Debug.logInfo("===LcReceiveDate=",
>>> LcReceiveDate);
>>>  Debug.logInfo("===countDownDays=",
>>> countDownDays);
>>>  Debug.logInfo("===remarks=", remarks);
>>>}
>>> “Controller”
>>> 
>>> 
>>> 
>>> >> invoke="finalizeLCUpdate"/>
>>> 
>>> 
>>> I am passing hidden values from the “finalizeLC.ftl” file and unable
>>> to retrieve data in the java class “UpdateLCServices.java and method
>>> finalizeLCUpdate”. Debug.loginfo showing null values.
>>> Pls help in how to pass form parameter values to ftl java class in Ofbiz.
>>> Regards
>>> Avijit Bose
>>
>>
>>

Re: What are the best practices to develop with OFBiz?

[Nicolas Malin]

Hello

On 28/04/2022 01:39, Jean-Nicolas Boulay Desjardins wrote:
> Hello!
>
> I notice in the documentation it says to modify the configurations inside
> the framework itself.
>
> Is this the best practice?
It's a old documentation, but currently the main that we can detail.
Other process are not ready yet, and at Nereide we try to work on better
solution however we are a little bit overload by customer project to
finalize it correctly.
> Is there a way to have those configurations somewhere else?
Mainly, from our part, we use environment variable when it's possible
and a configuration branch in git repo. Both cover all case that we meet.
> Can everything be overwritten with the help of a plugin not just
> configurations but also code?
Most of OFBiz element can be surcharge by a plugin. Theme, entity,
service, controller, screen can be overwrite or extend. Just need to be
calm and go slowly to escape an headhash :)
> Is there documentation that someone can recommend that relates to these
> questions?
https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Tutorial+-+A+Beginners+Development+Guide

but it's generic case
>
> Does anyone here have some tips?
For a custom site, create to repo, one fork from ofbiz, second for your
plugin.

Create a specific branch on your ofbiz-framework to isolate your change.
Try to override what you need on your plugin.

Nicolas
>
> I am still quite new to OFBiz.
>
> What I was planning to do is fork the ofbiz-framework repo into a private
> one where I can put my modifications and then once they are changes in the
> upstream repo I can merge them without losing my changes.
>
> Thank you for your help!
>

Re: Help required in Ofbiz development - Unable to retrieve parameter using HTTPRequest

[Nicolas Malin]

Hello,

You use a raw method to resolve parameters from the request.

I suggest that the problem came from the form html definition. When you
submit do you analyzed the request send by your browser ? (F12 ->
Network on firefox)

Nicolas

On 28/04/2022 05:48, Avijit Bose wrote:
> My code is as follows:
>
> “finalizeLC.ftl”
>  
> 
> name="finalizeLCUpdate" id="finalizeLCUpdate">
>
>
>
>
>
>
>  
> 
>   
> 
> 
> 
> for="LcReceiveDate">${uiLabelMap.LcReceiveDate}
> 
> 
> style="background-color:#D6F2FF" value="${LcReceiveDate!}" required>
> 
> 
>   
>   
> 
> 
> 
> for="countDownDays">${uiLabelMap.countDownDays}
> 
> 
> name="countDownDays" style="background-color:#D6F2FF"
> value="${countDownDays!}" required>
> 
> 
>   
> 
> 
> 
> 
> for="remarks">${uiLabelMap.remarks}
> 
> 
>   value="${remarks!}" name="remarks" size="100"
> style="background-color:#D6F2FF" required>
> 
> 
>   
> 
>   
>
>  
> 
>   
> 
> 
> 
>
> 
> 
>
>   value="Submit">${uiLabelMap.finalizeLC}
>
> 
>   
> 
>   
> 
> 
>
>
> “UpdateLCServices.java and method finalizeLCUpdate”
> 
>public static String finalizeLCUpdate(HttpServletRequest
> request, HttpServletResponse response) {
>
>   Delegator delegator = (Delegator)
> request.getAttribute("delegator");
>
>   String LcReceiveDate =
> request.getParameter("LcReceiveDate").trim();
>  String countDownDays =
> request.getParameter("countDownDays").trim();
>   String remarks = request.getParameter("remarks").trim();
>
>  Debug.logInfo("===LcReceiveDate=",
> LcReceiveDate);
>  Debug.logInfo("===countDownDays=",
> countDownDays);
>  Debug.logInfo("===remarks=", remarks);
>}
>
>
> “Controller”
> 
> 
> 
>  invoke="finalizeLCUpdate"/>
> 
> 
>
>
> I am passing hidden values from the “finalizeLC.ftl” file and unable
> to retrieve data in the java class “UpdateLCServices.java and method
> finalizeLCUpdate”. Debug.loginfo showing null values.
>
> Pls help in how to pass form parameter values to ftl java class in Ofbiz.
>
> Regards
> Avijit Bose

Re: Notify Party Shipment has arrived

[Nicolas Malin]

Hello Steven,

Create a seca on your component for the service update shipment to
generate a notification when the shipment status change to completed

Nicolas


On 07/04/2022 23:54, Steven Payne wrote:
> Hi All,
>
> Is there a way OOTB to notify a user that a shipment has arrived or a PO has 
> been completed?
>
> I'm imagining something along the lines of when a PO is completed, the party 
> associated with the PO gets an email notification.
>
> Any help is appreciated.
>
> Regards,
> Steven Payne
> Inventory Control Coordinator
>
>

Re: How do I use Linux env variables inside my XML configurations?

[Nicolas Malin]

Salut Jean-Nicolas,

Currently we use the issue OFBIZ-9498 [1] on our production site, it's
not perfect but do the job !

Nicolas

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

On 25/04/2022 23:21, Jean-Nicolas Boulay Desjardins wrote:
> Hi!
>
> How do I use Linux env variables inside my XML configurations?
>
> For example inside of framework/entity/config/entityengine.xml
>
> 
>
> Thank you
>

Re: Receiving inventory for a product without supplier

[Nicolas Malin]

Hello Emad,

A product as always a supplier, maybe in your case it's yourself.

But if it's for increase your stock, you can do an inventory instead.

Nicolas

On 23/03/2022 21:18, Emad Radwan wrote:
> Hello Community,
>
> While testing, I was able to achieve the subject scenario, how is this 
> possible?!
>
> I defined a product, added a facility, then without adding a supplier for the 
> product, I tried to receive 
> inventory thinking that it’s a flexibility in Ofbiz and that it’ll ask for 
> the supplier while doing this step and link it to the product on the fly, but 
> it didn’t!
>
> Is there a scenario where this is possible?
>
>
> Regards,
> Emad

Re: Demos are back

[Nicolas Malin]

Kudos Jacques :)


On 31/03/2022 08:54, Jacques Le Roux wrote:
> Hi,
>
> The Demos are back and running :)
>
> Enjoy
>
> Jacques
>

Re: Avoid creating entry in content_keyword on content and party_content creation

[Nicolas Malin]

Hello Altafhusen,

Check the file applications/content/entitydef/eecas.xml that contains
trigger to call service to create content keywords.

And after create your own implementation of service
'indexContentKeywords' to populate the entity as you wish.


    
    Index the Keywords for a Content
    
    
    
    
    
    
    


Cheers,
Nicolas

On 22/03/2022 09:27, Altafhusen Makandar wrote:
> Can someone provide some solution on this?
>
> On Mon, Mar 21, 2022, 09:42 Altafhusen Makandar 
> wrote:
>
>> Hi, When I create a record in the "content" table using
>> dispatcher.runSync("createContent", map), it also creates an entry in
>> "content_keyword" table with keyword=contentId. Is there a way to avoid
>> creating this entry? Also, when I create a records in "party_content" table
>> using  dispatcher.runSync("createPartyContent", map), it creates entries in
>> "content_keyword" with keywords having the values from "groupName" in
>> "party_group" table. Is there a way to avoid this as well? Thank you in
>> advance.
>>

Re: new user installation error.

[Nicolas Malin]

Hello Hans,

On the Reademe.adoc :


== 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).

[[download-the-gradle-wrapper]]
=== Download the Gradle wrapper:

MS Windows: `init-gradle-wrapper`

Unix-like OS: `./gradle/init-gradle-wrapper.sh`


This came from the need to delivery the release source code without
binary as the ASF recommand.

Nicolas


On 06/01/2022 12:10, Hans Bakker wrote:
> Today i installed ofbiz from scratch
>
> i went to:
> https://cwiki.apache.org/confluence/display/ofbiz/demo+and+test+setup+guide
> which told be to install the latest version from
> http://ofbiz.apache.org/download.html
>
> i installed from
> https://www.apache.org/dyn/closer.lua/ofbiz/apache-ofbiz-18.12.05.zip
>
> unzipped the archive and
>
> started ofbiz with: ./gradlew ofbiz (i have linux)
>
> the result: Error: Could not find or load main class
> org.gradle.wrapper.GradleWrapperMain
>
> the reason is that the gradle-wrapper.jar is missing in the
> gradle/wrapper directory
>
> should this file not be included in the zip I downloaded?
>
> after installing this jar file it works
>
> Regards,
>
> Hans
>

Re: Log4j in OFBiz

[Nicolas Malin]

Hello,
OFBiz is affected by this.
This week-end we publish a corrective version 18.12.03 [1], and the
trunk has been also corrected(many thanks to Jacques !)

If you want to fix your OFBiz version, update your log4j dependencies to
version 2.15.0.

You can check the Jacques's commit
64a0b6e8d04b936f472b418cc8847c03b462d3a0 for more details

Nicolas

[1] https://dlcdn.apache.org/ofbiz/apache-ofbiz-18.12.03.zip
[2]
https://github.com/apache/ofbiz-framework/commit/64a0b6e8d04b936f472b418cc8847c03b462d3a0
On 13/12/2021 09:50, Bs Serge wrote:
> Hi all,
>
> I’m sure all of you are aware of what’s going with the Log4j security
> vulnerability, If not then :
>
> - https://www.wired.com/story/log4j-flaw-hacking-internet/
> -
> https://logging-apache-org.translate.goog/log4j/2.x/security.html?_x_tr_sl=de&_x_tr_tl=en&_x_tr_hl=en-US
>
> So some of us are wondering :
>
> Does this affect at least some versions of OFBiz? and What can one do to
> make sure that they are safe from this vulnerability?
>
> Best Regards,
>

Re: Build Error

[Nicolas Malin]

With pleasure :)

I open a fix issue https://issues.apache.org/jira/browse/OFBIZ-12437 , I
just wait some suggest before push it on the code base.

Nicolas

On 07/12/2021 19:04, Jeremy Olmstead wrote:
> This worked, thank you so much!
>
> On Tue, Dec 7, 2021 at 10:51 AM Nicolas Malin
> mailto:nicolas.ma...@nereide.fr>> wrote:
>
> Hello Jeremy,
>
> We detect this error from our side, but not update on the project.
>
> Try to apply this patch :
>
> diff --git a/build.gradle b/build.gradle
> index 1bc148e636..4c256c74d8 100644
> --- a/build.gradle
> +++ b/build.gradle
> @@ -292,7 +292,7 @@ sourceSets {
>  resources {
>  srcDirs = 
> getDirectoryInActiveComponentsIfExists('src/main/java')
>  srcDirs += getDirectoryInActiveComponentsIfExists('config')
> -srcDirs += "${rootDir}/framework/base/dtd"
> +srcDirs += getDirectoryInActiveComponentsIfExists('dtd')
>  exclude excludedJavaSources
>  exclude excludedConfigFiles
>  // Below are necessary for unit tests run by Gradle and 
> integration tests
>
> This error appears because the resolution of some xsd failed
>
> Nicolas
>
> On 07/12/2021 16:59, Jeremy Olmstead wrote:
>> I can't figure out what has changed, but I am now getting a
>> compilation error during the task 'test' when I try to build. Does 
>> anybody
>> have any insights as to what may have happened? The error I get is 
>> below. I
>> am running a heavily customized 18.12 on a Windows 11 development 
>> machine.
>> After this failure, if I copy the entire directory from a machine that
>> works, it will still fail even though the OFBiz directory is identical to
>> the working machine. Thank you for any help you can provide.
>>
>> PS C:\ofbiz.18.12> .\gradlew
>> Listening for transport dt_socket at address: 8091
>>> 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 :compileTestJava UP-TO-DATE
>>> Task :compileTestGroovy UP-TO-DATE
>>> Task :processTestResources UP-TO-DATE
>>> Task :testClasses UP-TO-DATE
>>> Task :test
>> org.apache.ofbiz.entity.DelegatorUnitTests >
>> delegatorCreationUsingConstructorFailsIfConfigurationIsMissing FAILED
>> java.lang.AssertionError
>>
>> org.apache.ofbiz.entity.DelegatorUnitTests >
>> delegatorCreationUsingFactoryGetDelegator FAILED
>> java.lang.AssertionError at DelegatorUnitTests.java:87
>>
>> org.apache.ofbiz.entity.DelegatorUnitTests >
>> delegatorCreationUsingFactoryGetInstance FAILED
>> java.lang.AssertionError at DelegatorUnitTests.java:75
>>
>> org.apache.ofbiz.entity.DelegatorUnitTests >
>> delegatorCreationUsingConstructor FAILED
>> org.apache.ofbiz.entity.GenericEntityConfException at
>> DelegatorUnitTests.java:63
>>
>> org.apache.ofbiz.entity.util.EntitySaxReaderTests > parse FAILED
>> java.lang.IllegalStateException at EntitySaxReaderTests.java:82
>>
>> 47 tests completed, 5 failed
>>
>>> Task :test FAILED
>> FAILURE: Build failed with an exception.
>>
>

Re: GlobalDecorator

[Nicolas Malin]

Hello Mani,

In your definition you just need to extend thomahawk.

Copy the decorator GlobalDecorator in your theme and define it like
 
*themes/xerus-theme/widget/Theme.xml (add) :
    
    
    
    
    

With this your condition and property on SidebarTemplateLocation is
unecessary because mandatory by your theme, so directly present on your
theme decorator code.

Nicolas

On 16/11/2021 11:37, Mahi maheshwari wrote:
> Hi,
>
> I have created the custom visual theme for my side-bar requirement by
> following this doc
> https://github.com/apache/ofbiz-framework/blob/trunk/themes/docs/themes.adoc
>
> but I want Tomahawk theme styles, so I copied all the css, js, images into
> my custom theme called "xerus-theme" by following this doc
> https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=74685960
>
> the entire custom theme folder structure is here
> 
> below are the changes I have done
> *themes/xerus-theme/ofbiz-component.xml*
>
>  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance;
> xsi:noNamespaceSchemaLocation="
> https://ofbiz.apache.org/dtds/ofbiz-component.xsd;>
> 
> 
>
> 
>  location="data/Xerus-themeThemeData.xml"/>
>
> 
>  title="xerus-theme"
> menu-name="secondary"
> server="default-server"
> location="webapp/xerus-theme"
> mount-point="/xerus-theme"
> app-bar-display="false"/>
> 
>
> *themes/xerus-theme/widget/Theme.xml  => here I have made an entry for
> sidebar as "VT_SIDEBAR_TMPLT_LOC". rest is same as tomahawk.*
>
>  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance;
>xmlns="http://ofbiz.apache.org/Widget-Theme; xsi:schemaLocation="
> http://ofbiz.apache.org/Widget-Theme
> http://ofbiz.apache.org/dtds/widget-theme.xsd;>
> 
> 
> ${util:label('CommonEntityLabels',
> 'VisualTheme.description.TOMAHAWK', locale)}
> 
> 
> 
> 
> 
> 
> 
>  value="component://xerus-theme/template/Header.ftl"/>
>  value="component://xerus-theme/template/Footer.ftl"/>
>  value="component://xerus-theme/template/AppBarOpen.ftl"/>
>  value="component://xerus-theme/template/AppBarClose.ftl"/>
> * value="component://xerus-theme/template/SideBar.ftl"/>*
> 
> 
> 
> 
>  value="/xerus-theme/js/dropdown.js"/>
> 
>  value="/xerus-theme/css/style.css"/>
>  value="/xerus-theme/css/help.css"/>
>  value="/xerus-theme/webapp/xerus-theme/css/docbook.css"/>
> 
> 
>
> *themes/xerus-theme/data/Xerus-themeThemeData.xml*
> 
>  description="xerus theme: the evolution of the tomahawk theme"/>
>  resourceTypeEnumId="VT_STYLESHEET"
> resourceValue="component://xerus-theme/webapp/css/style.css"
> sequenceId="01"/>
>  resourceTypeEnumId="VT_HDR_TMPLT_LOC"
> resourceValue="component://xerus-theme/template/Header.ftl"
> sequenceId="08"/>
>  resourceTypeEnumId="VT_FTR_TMPLT_LOC"
> resourceValue="component://xerus-theme/template/Footer.ftl"
> sequenceId="10"/>
> * resourceTypeEnumId="VT_SIDEBAR_TMPLT_LOC"
> resourceValue="component://xerus-theme/template/SideBar.ftl"
> sequenceId="26"/>*
> 
>
> *themes/common-theme/widget/CommonScreens.xml => GlobalDecorator Screen*
>  form-field="layoutSettings.VT_SIDEBAR_TMPLT_LOC"/>
> *added this section for side-bar*
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  location="${SidebarTemplateLocation}" />
> 
> 
> 
> 
>
> *themes/common-theme/widget/Theme.xml*
> added a property
>
>  value="component://xerus-theme/template/SideBar.ftl"/>
>
> *framework/common/data/CommonTypeData.xml*
> made an Enumeration entry for side-bar
> 
>
> *all the styles and templates(header, footer)  were rendered except
> side-bar.*
> I ran* gradlew "ofbiz --load-data readers=seed" *after all the changes.
>
> is this the correct way, or am I missing something?. I dont want to change
> the entire theme just wanted a side-bar in all the modules and sub-modules.
> the entire theme will be same as tomahawk but there will be an  added
> side-bar => please refer this image
>  . I
> have extended Tomahawk theme in this custom theme.
>
> Thanks and Regards,
> Maheshwari.
>

Re: Build Error

[Nicolas Malin]

Hello Jeremy,

We detect this error from our side, but not update on the project.

Try to apply this patch :

diff --git a/build.gradle b/build.gradle
index 1bc148e636..4c256c74d8 100644
--- a/build.gradle
+++ b/build.gradle
@@ -292,7 +292,7 @@ sourceSets {
 resources {
 srcDirs = getDirectoryInActiveComponentsIfExists('src/main/java')
 srcDirs += getDirectoryInActiveComponentsIfExists('config')
-srcDirs += "${rootDir}/framework/base/dtd"
+srcDirs += getDirectoryInActiveComponentsIfExists('dtd')
 exclude excludedJavaSources
 exclude excludedConfigFiles
 // Below are necessary for unit tests run by Gradle and 
integration tests

This error appears because the resolution of some xsd failed

Nicolas

On 07/12/2021 16:59, Jeremy Olmstead wrote:
> I can't figure out what has changed, but I am now getting a
> compilation error during the task 'test' when I try to build. Does anybody
> have any insights as to what may have happened? The error I get is below. I
> am running a heavily customized 18.12 on a Windows 11 development machine.
> After this failure, if I copy the entire directory from a machine that
> works, it will still fail even though the OFBiz directory is identical to
> the working machine. Thank you for any help you can provide.
>
> PS C:\ofbiz.18.12> .\gradlew
> Listening for transport dt_socket at address: 8091
>> 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 :compileTestJava UP-TO-DATE
>> Task :compileTestGroovy UP-TO-DATE
>> Task :processTestResources UP-TO-DATE
>> Task :testClasses UP-TO-DATE
>> Task :test
> org.apache.ofbiz.entity.DelegatorUnitTests >
> delegatorCreationUsingConstructorFailsIfConfigurationIsMissing FAILED
> java.lang.AssertionError
>
> org.apache.ofbiz.entity.DelegatorUnitTests >
> delegatorCreationUsingFactoryGetDelegator FAILED
> java.lang.AssertionError at DelegatorUnitTests.java:87
>
> org.apache.ofbiz.entity.DelegatorUnitTests >
> delegatorCreationUsingFactoryGetInstance FAILED
> java.lang.AssertionError at DelegatorUnitTests.java:75
>
> org.apache.ofbiz.entity.DelegatorUnitTests >
> delegatorCreationUsingConstructor FAILED
> org.apache.ofbiz.entity.GenericEntityConfException at
> DelegatorUnitTests.java:63
>
> org.apache.ofbiz.entity.util.EntitySaxReaderTests > parse FAILED
> java.lang.IllegalStateException at EntitySaxReaderTests.java:82
>
> 47 tests completed, 5 failed
>
>> Task :test FAILED
> FAILURE: Build failed with an exception.
>

Re: Images not working

[Nicolas Malin]

Hello Steven,

With the creation of the common-theme, by default the webapp directory
is now ofbiz-framework/themes/common-theme/webapp/images/

I encourage to check where is your images webapp :
* themes/common-theme/ofbiz-component.xml
    


And check where are your pictures on the server to synchronize files and
webapp.

Don't hesitate if you need some additional,

Nicolas
On 01/12/2021 18:06, Steven Payne wrote:
> Hi All,
>
> I've run into a problem where all the images stopped working.  I've upgraded 
> from 17 to 18 and all the image links are broken.  I can still see the images 
> on the server.
>
> Does anyone know where to start with this?
>
> 
> HTTP Status 404 - Not Found
> Type Status Report
>
> Message The requested resource [/images/products/0-10NL-25-RP/original.png] 
> is not available
>
> Description The origin server did not find a current representation for the 
> target resource or is not willing to disclose that one exists.
>
> Apache Tomcat/9.0.54
> --
>
> Regards,
> Steven Payne
> Inventory Control Coordinator
>
>

Re: Invoice - Discount

[Nicolas Malin]

Hello Ingo,

I see 3 possibilities (depends to the global context, that I unknown) :
* Your payment come before the order sent, you set it as order payment
preference so you apply a orderAdjustment with timelife to 10 days (you
run every days a job to disable adjustment over)
* The Invoice is already ready, you can generate during the
paymentApplication an invoice refund with the discount and link it to
the first invoice
* During the payment process, generate add a "discount payment" to the
invoice to not impact it.

I hope this help to found the good way,
Nicolas

On 03/12/2021 08:49, Ingo Wolfmayr wrote:
>
> Hi everybody,
>
>  
>
> I have an accounting question regarding discount on early payment.
>
>  
>
> For example a customer has a payment target of 10 days. If he pays
> within those 10 days, he can subtract a discount of 2%.
>
> There is an invoice amount of € 100,- (the invoice is sent to the
> customer and therefore editing the invoice is disabled)
>
>  
>
> The customer pays € 98,- A payment is created and assigned to the
> invoice. The invoice says € 2,- open.
>
>  
>
> How do I get the discount into the system?
>
>  
>
> Best regards,
> Inog
>
>  
>
> Mag. (FH) Ingo Wolfmayr
>
> *Wolfix Solutions*
>
> Gänsgasse 14
>
> A-5282 Ranshofen
>
>  
>
> Tel.: +43 (0) 664 2549626
>
> Web: https://www.wolfix.at 
>
> Xing: https://www.xing.com/profile/Ingo_Wolfmayr/
> 
>
>  
>
> emailsignatur
>
>  
>
>  
>

Re: how to render ftl file in screen

[Nicolas Malin]

Hello Maheshwari,

You need to change the GlobalDecorator. I suggest you to create a new
theme that extend tomahawk and change this decorator to include your
template.

See
https://github.com/apache/ofbiz-framework/blob/trunk/themes/docs/themes.adoc

Nicolas

On 15/11/2021 09:40, Mahi maheshwari wrote:
> Hi,
>
> I'm using a tomahawk theme. I want to render a navigation sidebar(side-bar
> ) in
> all the components/modules, even in sub-modules also.
> The navigation sidebar will have all module names. by clicking on the
> respective module name it will take you to the respective module.
> but I want this requirement in the existing tomahawk theme that will
> display this sidebar in all the modules and sub-modules. but I'm not able
> to do so as few files are ftl and few are XML => referThis
> 
>
> have tried creating ftl and tried to put it in screen like this
>  location="component://common-theme/template/ViewBlocked.ftl"/>
> but this did not  work.
> shall I create the screen and include that screen in common screens.xml
> file like this
> 
>  location="${groovy:commonScreenLocations.FindScreenDecorator?commonScreenLocations.FindScreenDecorator:commonDecoratorLocation}"/>
> if this will work then how can I create screens and render them.
>
> which approach do I have to use or are any other approaches for my
> requirement?
>
> Best Regards,
> Maheshwari.
>

Re: custom UI requirement

[Nicolas Malin]

Create a new theme that implement your own template

please read the documentation :
https://github.com/apache/ofbiz-framework/blob/trunk/themes/docs/themes.adoc

Nicolas

On 01/11/2021 20:52, Mahi maheshwari wrote:
> Hi,
> I have a custom Ui requirement that goes like It will have a
> header,sidebar(will be on the left hand side of the page),container(will be
> in the center of the page) and a footer.
> The layout for the ui is here => layout
> 
> I have created a plugin called "HOME" for the home page.
> In this home page plugin I have created an ftl file for the ui of the home
> page.
> The path for the ftl file where I have created the home page ui is
> plugins/HOME/webapp/HOME/crud/AddHome.ftl =>pathToTheFile
> 
> The Home page UI will look like this => homePageUi
>  now
> I want to display the same header,sidebar and footer of the home page to
> all the modules in the ofbiz like for asset
> maintenance,party,manufacturing,product catalog,facility and order.
> The container content will change according to the module.
> for example, If I click on the asset maintenance module in the side-bar in
> the home page It will direct me to the asset maintenance page and this
> change of the modules content should happen only inside the container(which
> is of grey color) =>  referToThis
> 
>
> The code for home page ui is as below
> 
> <#if !userLogin?has_content>
>   ${uiLabelMap.WebtoolsForSomethingInteresting}.
>   
>   ${uiLabelMap.WebtoolsNoteAntRunInstall}
>   
>href="<@ofbizUrl>checkLogin">${uiLabelMap.CommonLogin}
> 
> <#if userLogin?has_content>
>   
>   href="/manufacturing/control/main?externalLoginKey=ELf8650276-c0c1-4952-9936-fd87e090beff">
>  ${uiLabelMap.HOMEProduction}
>  
>   href="/facility/control/main?externalLoginKey=ELfccd14d0-0b7b-4ded-844d-d8a9b950187c">
>  ${uiLabelMap.HOMEInventoryManagement}
>  
>   href="/assetmaint/control/main?externalLoginKey=ELfccd14d0-0b7b-4ded-844d-d8a9b950187c">
>  ${uiLabelMap.HOMEAssetMaintenance}
>  
>   href="/ordermgr/control/main?externalLoginKey=ELe412b3d4-a7a5-42a8-bc8c-9be077c664b9">
>  ${uiLabelMap.HOMEOrder}
>  
>   href="/partymgr/control/main?externalLoginKey=EL154c28ab-c21d-4004-8ab4-cc18d49bbe65">
>  ${uiLabelMap.HOMEUsers}
>  
>   href="/catalog/control/main?externalLoginKey=ELfccd14d0-0b7b-4ded-844d-d8a9b950187c">
>  ${uiLabelMap.HOMEProductCatalog}
>  
>
>  
> 
> 
>
>
> how can I do this?
>
> Thanks.
>

Re: Attach original accounting documents to invoices

[Nicolas Malin]

You have the entity InvoiceContent [1] that manage your case.
At this time there is no native interface on the OFBiz standard to
manage it.

The idea is :
 * you define different invoice content type to identify the purpose of
a document for the invoice
 * you load your document as content
 * you link it with the good invoice content type.

You have many example on the framework like CustRequest, Party, Product
or CommunicationEvent

Have fun,
Nicolas

[1]
https://demo-trunk.ofbiz.apache.org/webtools/control/entity/find/InvoiceContent
On 17/10/2021 10:44, Marius Schmidt wrote:
> Is it possible to attach the original accounting documents to
> invoices? The ones, we got mailed or scanned ourselves?
>
> In the accounting software I used so far, we have some process like that:
>
>  * Bank account transactions enter the system via API
>  * Invoices arriving on the billing mail address are added as new
>    entries to an "accounting document list", stating they are to-do
>  * Other invoices and scans we upload to that list manually, also
>    making them new entries
>  * The accountant does his accounting stuff and relates bank account
>    transaction and accounting documents to a  certain ledger transaction
>
> That way I can easily review everything that happened based on a
> certain invoice document. How could the process look like in OfBiz?
>
> Best regards, have a nice weekend,
>
> Marius
>

Re: Kotlin integration

[Nicolas Malin]

Not at this time, we never confronted to the necessary to use Kotlin.
If you have the possibility to add a new engine on the service engine,
all contribution are welcome :)

Nicolas

On 17/10/2021 09:55, Marius Schmidt wrote:
> Has someone tried to use Kotlin for services and events yet with
> success and maybe wrote about it somewhere?
>
>

Re: Product Detail - Extra Information

[Nicolas Malin]

Hello Justine,

You want display these information on the product summary or product
detail ?

You have all template here
https://github.com/apache/ofbiz-plugins/tree/trunk/ecommerce/template/catalog

Nicolas
On 21/10/2021 05:07, Justine Nowak wrote:
> Hello,
>
> We are trying to display extra information for our products on the
> eCommerce website.
>
> For instance, How do we display Good Identifications, Brand Name, Product
> dimensions, and Weight?
>
> What type of code do we have to create in the Template file to display this
> information?
>
> Thank you, Justine.
>

Re: Fwd: Sales Order

[Nicolas Malin]

Hello Woyce,

your image isn't present on the mail, can you reproduce the problematic
on the demo trunk [1] ?

Nicolas

[1] https://demo-trunk.ofbiz.apache.org/ordermgr/control/main

On 30/08/2021 13:37, Woyce Batkins wrote:
> Just to answer my own question:
> I had not configured the accepted payment in the corresponding webstore
> Thanks.
>

Re: How to Upgrade OFBiz

[Nicolas Malin]

Hello,

If you follow the best practice to develop your specific without change
on the framework, just deploy the new ofbiz and load your plugins into.

For other case all is on the wiki [1].

Nicolas

[1]
https://cwiki.apache.org/confluence/display/OFBIZ/Revisions+Requiring+Data+Migration+-+upgrade+ofbiz

On 25/08/2021 22:33, Bryan Boone wrote:
> Hi everyone.  I see that a new version of OFBiz was recently released.
>
> I currently have an older version installed, 17.12.08.  I don’t see any 
> documentation on how to upgrade to newer versions as they are released.
>
> Is there a document somewhere?
>
> thanks

Re: Attachments

[Nicolas Malin]

Hello Steven,

Your question is large, because it's important to know why you link a
document. And following the response the solution can be completely
different.

But a simple example con be found when you create a communication or a
customer request.

Nicolas

On 26/08/2021 16:46, Steven Payne wrote:
> Is there any way OOTB to attach a file to a purchase order in OFBiz?
>
> I've tried looking at the content management system, but I can't seem to find 
> a spot where I can associate it to the PO. Is there a tutorial somewhere that 
> explains how to add attachments to things in OFBiz?
>
> I am thinking of something where a user can click on the content and it 
> simply downloads the file to their computer for viewing. Just like the logo 
> URL in the party window.

Re: Demos down?

[Nicolas Malin]

Demo are come back.

Thanks to Chris Thistlethwaite for is help

Nicolas

On 19/08/2021 15:54, Nicolas Malin wrote:
> I didn't find the reason,
>
> I asked the asf Infra team under issue INFRA-5 [1], and I will
> inform when it would be fixed
>
> Nicolas
>
> [1] https://issues.apache.org/jira/browse/INFRA-5
>
> On 19/08/2021 15:13, Nicolas Malin wrote:
>> Hello,
>>
>> Yes the demos are down and I didn't take the time with my jobto have a look.
>>
>> FYI Jacques is on vacation.
>>
>> Nicolas
>>
>>
>> On 19/08/2021 15:08, G.W. Haywood wrote:
>>> Hi there,
>>>
>>> At least from my perspective in England I can't seem to see the demos.
>>>
>>> Our monitoring system, which reports on them, alerted me about 1430 BST
>>> yesterday.  I mailed Jacques about it yesterday but I've seen no reply.
>>>

Re: Demos down?

[Nicolas Malin]

I didn't find the reason,

I asked the asf Infra team under issue INFRA-5 [1], and I will
inform when it would be fixed

Nicolas

[1] https://issues.apache.org/jira/browse/INFRA-5

On 19/08/2021 15:13, Nicolas Malin wrote:
> Hello,
>
> Yes the demos are down and I didn't take the time with my jobto have a look.
>
> FYI Jacques is on vacation.
>
> Nicolas
>
>
> On 19/08/2021 15:08, G.W. Haywood wrote:
>> Hi there,
>>
>> At least from my perspective in England I can't seem to see the demos.
>>
>> Our monitoring system, which reports on them, alerted me about 1430 BST
>> yesterday.  I mailed Jacques about it yesterday but I've seen no reply.
>>

Re: Demos down?

[Nicolas Malin]

Hello,

Yes the demos are down and I didn't take the time with my jobto have a look.

FYI Jacques is on vacation.

Nicolas


On 19/08/2021 15:08, G.W. Haywood wrote:
> Hi there,
>
> At least from my perspective in England I can't seem to see the demos.
>
> Our monitoring system, which reports on them, alerted me about 1430 BST
> yesterday.  I mailed Jacques about it yesterday but I've seen no reply.
>

Re: XML Exports

[Nicolas Malin]

On the server, you need to have an access to it. By experience, we
create a directory export on the server to dump all into.

Just a suggest, if you use import from an xml export, use a delegator
without seca.

Cheers,

Nicolas

On 11/08/2021 14:47, ja...@productive1.com wrote:
> Where does it dump the xml files?
>
>
>  Original Message 
> Subject: Re: XML Exports
> From: Gil Portenseigne 
> Date: Wed, August 11, 2021 1:39 am
> To: user@ofbiz.apache.org
>
> Hello James,
>
> You can find in webtools [1] several tools to export your data.
> You can select the table to export or export all data.
>
> Regards,
>
> Gil
>
> [1] https://demo-trunk.ofbiz.apache.org/webtools/control/xmldsdump
>
> On Tue, Aug 10, 2021 at 07:59:03AM -0700, ja...@productive1.com wrote:
>> Is there a way to get all XML data formats out of OFbiz so the template
>> can be used for import?
>>
>> Thanks,
>>
>> James

Re: OFBiz 17 vs 18

[Nicolas Malin]

We use the 18.12 branch in production since 2 two years without issues.

For the migration just take care about the theme if you have your own
theme that need to migrate on common-theme support.

Nicolas

On 29/07/2021 20:01, Carlos Navarro wrote:
> Hi all,
>
> Hoping you are all doing well.
>
> Is it OFBiz 18 enough stable to put in production or not yet? In case not, if 
> not complex modifications are made to OFBiz 17: is it hard to migrate from 
> OFBiz 17 to OFBiz 18?
>
> Many thanks.
>
> Carlos Navarro

Re: database upgrade

[Nicolas Malin]

Hello,

Help yourself, all database change is present here
https://cwiki.apache.org/confluence/display/OFBIZ/Revisions+Requiring+Data+Migration+-+upgrade+ofbiz

Copy your database run different sql to migrate some entities and let's rock

Nicolas

On 29/07/2021 22:05, Parminder S. Lehal wrote:
> Hello,
> What is the best path for upgrading ofbiz database from older version(12)
> to current production(17) as importing database backup  on top of created
> database schema complains about foreign key constraints violations.
> Running current ofbiz on old database  although does work but does not
>  make any database schema changes. Is there any specific tool in the ofbiz
> package for updating database schema or for testing its compliance?
>
> If we load default seed data and then import xml using web tools then most
> of sequences  get thrown out of sync(which is not that that hard to fix..)
> but wanted to know if  there is any better technique.
>
>  

Run OFBiz on ubuntu (was: Re: Subscription Extension)

[Nicolas Malin]

Hello Yuresh,

What OFBiz that you tried to install ?

What the result of the command : $ java -version ?

What command you use to run ofbiz ?

Nicolas

On 26/07/2021 10:42, Yuresh Akila wrote:
> Hi somebody here can help me with installing ofbiz on ubuntu 20.04, will be
> greatly appreciated.
>
> I have been trying to read the ofbiz threads, and all the current manuals
> and asking people to help me with, but none of it worked.
>
> I am trying to install this software on my ubuntu, since April.
>
> If anyone who would willing to help please Respond, and appreciate with all
> Greatfulness.
>
> Thank You,
> Yuresh.
>
> On Fri, 23 Jul 2021, 16:34 Jacques Le Roux, 
> wrote:
>
>> Hi Serge,
>>
>> This should help:
>> https://cwiki.apache.org/confluence/display/OFBIZ/Subscription
>>
>> HTH
>>
>> Jacques
>>
>> Le 21/07/2021 à 20:18, Bs Serge a écrit :
>>> Hello Ofbiz Team,
>>>
>>> Is there a way to make a subscription extend it's thru date on expiration
>>> instead of creating a new subscription ID each time the subscription
>>> expires?
>>>
>>> Any thoughts would be appreciated,
>>>
>>> Best Regards,
>>

Re: Free Shipping for specific Classification of Customers

[Nicolas Malin]

Hello James,

I suggest you to check with product promo rule.

I think you can't use ShipmentCostEstimate due to the present of Party
classification

Nicolas

On 24/07/2021 12:43, ja...@productive1.com wrote:
> What is the best way to set up free shipping based on total amount of
> order and only for specific classifications of customers?
>
> Thanks,
>
> James 

Re: Batch Print Invoices in OFBIZ

[Nicolas Malin]

Without code modification I think no, but the work to realize it seem to
be accessible.

Under a linux server I would do :

 * instantiate a cups server with different print queues

 * create a job you run periodically which :

 * resolve each ready invoice between the last running time and now

 * for each, call the invoice screen and store the output stream in
tmp file

 * call cups by cmd line (through java) with the queue and tmp file

That all :)

Nicolas

On 16/07/2021 00:39, ja...@productive1.com wrote:
> Is it possible to Batch Print Invoices by Date Range OTB in Of Biz?
>
> Thanks,
>
> James

Re: Organization of Tests

[Nicolas Malin]

HI both,

Currently I work with Gil for a customer site to different process for
implement some integration and unit test dedicate to business case.

We will try to share some tips on the following weeks.

Nicolas

On 20/05/2021 20:46, Carsten Schinzer wrote:
> Hello,
>
>
> definitely I am interested and also would like to work against an aligned
> standard. For example I found the issue of missing unit tests when
> refactoring some simple methods to groovy (I promise to finish and submit
> my started jira tickets in the upcoming Community Days). And I also asked
> myself the same questions as you do. For the time being I have just guessed
> where to place them, but yet a better approach would be to document
> practice with this somewhere and track improvements in Jira.
>
> I also would support unit testing from integration testing, which comes
> along with a definition of unit of course. I prefer the definition of a
> class method as a unit over the class itself as a unit, but I am open to
> arguments.
>
> My 2 cents.
> Warm regards
>
>
> Carsten
>
> Am Do., 20. Mai 2021 um 15:51 Uhr schrieb Erwin Penner <
> erwin.pen...@mindbit.de>:
>
>> Hello everybody,
>>
>> I would like to create unit and integration tests for my custom modules in
>> OFBiz.
>> Unfortunately, information on this subject is sparse.
>> For this reason, I checked how it is currently solved in the OFBiz modules.
>> I'll explain what it's about first. At the end of the mail I have some
>> questions.
>>
>> Using the example of the base or common modules in the OFBiz framework,
>> simple unit tests can be found in a separate test source folder.
>> src/test/java
>>
>> There are also test classes (presumably integration tests) in
>> base/src/main/java/org/apach /ofbiz/base/test
>> common/src/main/java/org/apache/ofbiz/common/test
>>
>> In the base module there are further test classes in
>> base/src/main/java/org/apache/ofbiz/base/util/string/test
>>
>> So, I thought simple unit tests should be in the separate test source
>> folder and integration tests under src/main/java/.../test
>>
>> Additionally, I found this (old) Confluence entry and was a bit confused:
>>
>> https://cwiki.apache.org/confluence/display/OFBIZ/Code+and+test+separation+for+Apache+OFBiz
>>
>> My questions are:
>> - Which test classes belong where?
>> - Is the current directory structure for tests the final solution or an
>> incomplete refactoring?
>> - Could/Should all tests (unit and integration tests) be maintained in
>> /src/test/?
>> - Which test classes must be described in the xml-definition under
>> /testdef ? (My impression so far is that the OFBiz modules only list
>> classes for integration tests.)
>> - Should I use the ext-test-reader in my custom ofbiz-component.xml to
>> load data for integration tests?
>> - Can I define a different data source for the test delegator than for the
>> default delegator?
>> Because a comment in the entityengine.xml says "Be sure that your default
>> delegator (or the one you use) uses the same datasource for test."
>>
>> Thanks in advance! I look forward to your answer/s! :-)
>>
>> Erwin
>>

Re: Setting up a new company

[Nicolas Malin]

Hello Woyce,

You can edit this file
https://github.com/apache/ofbiz-framework/blob/trunk/applications/accounting/data/OfbizSetupChartOfAccountsData.xml
and change Company by your own party.

After you can load is through webtools by Import/export tools.

Nicolas

On 08/05/2021 20:20, Woyce Batkins wrote:
> I am trying to set up a new company in ofbiz. I will like to reuse the
> chart of account of the demoCompany. What steps should I follow? Can't seem
> to find the right anser.
> Thanks
>

Re: Questions to speed up learning process.

[Nicolas Malin]

Hello

On 09/05/2021 20:31, MONTAÑA Gonzalo wrote:
> 1) Most widely used DB for OfBIZ in production environment would be
> postgres or mariadb?. Reason I asked is to have wider support and
> knowledge in case of problems.

>From our part, at Nereide we deploy all OFBiz with Postgres database.

Nicolas

Re: Payment & Purchase order

[Nicolas Malin]

Hello Woyce,

My vision, on order is not link to a payment, it's only an order payment
preference.

So by default, following your configuration, OFBiz generate for an order
a void payment when the invoice is generate mark as not paid.

You can remove or edit it. But in all case if you create a new payment
(from accounting component) you can only link to the invoice generate
from your purchase order.

Nicolas

On 05/05/2021 00:24, Woyce Batkins wrote:
> Hello,
> I am testing the process of purchasing from a supplier and I got stuck at
> the payment application step and don't know how to proceed. Here are the
> steps I went through:
> - Created a Purchase Order PO1
> - Payment P1 was generated with value 1010 USD
> - Voided the Payment P1 by mistake
> - Created another Payment P2 with value 1010 USD
> - Now I am stuck. I do not know how to link the new payment P2 to the
> purchase order PO1 so that it is fully paid
> Any Idea?
>

Re: How to Reset OfBiz Admin Login (Forgot Password)

[Nicolas Malin]

Hello Ben,

Help yourself :) 

$ grep admin README.adoc
  `gradlew lAUL -PuserLoginId=myadmin`

You call this with your admin id to force the reset

Nicolas

On 15/03/2021 05:00, Ben wrote:
> Hi everyone, I recently changed the admin organization in ofbiz and can no 
> longer login with the original details. I tried the forgot password option 
> but I guess I couldn't get a reset email because my STMP isn't configured 
> yet. How else can i get options to reset or retrieve login details?

Re: Service Engine - Thread pool

[Nicolas Malin]

On 09/03/2021 19:31, pratyush Giri wrote:
> Thank you Nicolas. I appreciate the response.
>
> When you say the configuration works fine, what do you mean? Do you see 4
> threads getting created ( I think not as you suggested that this
> configuration is not for the Ofbiz main thread)?

My service engine return me :

Job Queue Service Threads

Keep Alive Time In Seconds  120
Number Of Core Invoker Threads  4
Current Number Of Invoker Threads   4
Number Of Active Invoker Threads0
Max Number Of Invoker Threads   7
Greatest Number Of Invoker Threads  4
Number Of Completed Tasks   99


>  Have you tested bombarding
> the system with many concurrent order requests? How many concurrent orders
> we can create with 1 Ofbiz node ( I am hoping I can scale horizontally by
> adding more nodes to the cluster).

Currently we create ~2000 order/day with some peak to ~5000 order/day
distributed on 2 nodes.

The jvm have 4GB allocate and the OFBiz is tuned for the performance
(low log, high cache, disable all audit and tracking)

> While I agree and am looking at the other things you mentioned, I feel
> there may be a way to increase the thread count of the main Ofbiz
> application. Is there one?
OFBiz manage himself the number of thread needed to response, just
ensure that you have enough resource for them (CPU and Memory)
>
> Are there any production level configurations (best practices) around
> threads and memory?

Have you check this faq ?
https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQTipsTricksCookbookHowTo-Audit

For summarize : Enable your cache, configure your log level, synchronize
your entity engine configuration with your database, allow enough
resource for your JVM

Nicolas

>
> Best,
> Pratyush
>
>
>
> On Tue, Mar 9, 2021 at 12:26 AM Nicolas Malin 
> wrote:
>
>> Hello Pratyush,
>>
>> I have this configuration that works fine
>>
>> > purge-job-days="4" failed-retry-min="30" 
>> ttl="12" jobs="100" 
>> min-threads="4" max-threads="7" 
>> poll-enabled="true" poll-db-millis="3">
>> 
>>
>> But not sure that your on the good way to solve your problem. This 
>> configuration is for the job manager and not increase the threading on your 
>> server for main OFBiz thread.
>> I suggest you to check your jvm values, database activity for improve 
>> indexes, or analyze secas or eecas not useful for your process to increase 
>> your velocity
>>
>> Cheers,
>> Nicolas
>>
>>
>> On 08/03/2021 22:18, pratyush Giri wrote:
>>
>> Hi All,
>>
>> I researched the topic and could not find answers and hence the question. If 
>> I was not able to figure out the appropriate search query, my aplogies.
>>
>> I am trying to increase the thread count for the service engine (min - 20, 
>> max: 200). Currently, I am exploring and would like to find the optimum for 
>> my use-case (that's on me).
>>
>> >From the documentation, I modified the service engine xml as follows:
>>
>> >  purge-job-days="4"
>>  failed-retry-min="3"
>>  ttl="12"
>>  jobs="300"
>>  min-threads="20"
>>  max-threads="200"
>>  poll-enabled="true"
>>  poll-db-millis="3">
>> 
>> 
>>
>> However, on my restart of the server, the link thread list shows still as a 
>> min. of 2 and a max of 5 threads.
>> https://localhost:8443/webtools/control/threadList
>>
>> Keep Alive Time In Seconds   120
>> Number Of Core Invoker Threads   2
>> Current Number Of Invoker Threads2
>> Number Of Active Invoker Threads 0
>> Max Number Of Invoker Threads5
>> Greatest Number Of Invoker Threads   2
>> Number Of Completed Tasks32
>>
>> Question: Why are the serviceengine.xml settings are not honored? Did I miss 
>> something else?
>>
>> On a side note, with the same settings, i.e. min of 2 and max of 5 threads, 
>> when I hit about 100 concurrent requests to create order:  
>> org.apache.ofbiz.order.shoppingcart.CheckOutHelper.createOrder method gets 
>> exponentially delayed sometimes talking around 3 minutes to complete and 
>> sometimes timing out. That is the reason for my exploration. My system is 
>> backed by a Postgres database.
>>
>> Thank you all in advance.
>>
>> Best,
>> Pratyush
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>

Re: Service Engine - Thread pool

[Nicolas Malin]

Hello Pratyush,

I have this configuration that works fine






But not sure that your on the good way to solve your problem. This 
configuration is for the job manager and not increase the threading on your 
server for main OFBiz thread.
I suggest you to check your jvm values, database activity for improve indexes, 
or analyze secas or eecas not useful for your process to increase your velocity

Cheers,
Nicolas

On 08/03/2021 22:18, pratyush Giri wrote:
> Hi All,
>
> I researched the topic and could not find answers and hence the question. If 
> I was not able to figure out the appropriate search query, my aplogies.
>
> I am trying to increase the thread count for the service engine (min - 20, 
> max: 200). Currently, I am exploring and would like to find the optimum for 
> my use-case (that's on me).
>
> >From the documentation, I modified the service engine xml as follows:
>
>   purge-job-days="4"
>  failed-retry-min="3"
>  ttl="12"
>  jobs="300"
>  min-threads="20"
>  max-threads="200"
>  poll-enabled="true"
>  poll-db-millis="3">
> 
> 
>
> However, on my restart of the server, the link thread list shows still as a 
> min. of 2 and a max of 5 threads. 
>
> https://localhost:8443/webtools/control/threadList
>
> Keep Alive Time In Seconds120
> Number Of Core Invoker Threads2
> Current Number Of Invoker Threads 2
> Number Of Active Invoker Threads  0
> Max Number Of Invoker Threads 5
> Greatest Number Of Invoker Threads2
> Number Of Completed Tasks 32
>
> Question: Why are the serviceengine.xml settings are not honored? Did I miss 
> something else?
>
> On a side note, with the same settings, i.e. min of 2 and max of 5 threads, 
> when I hit about 100 concurrent requests to create order:  
> org.apache.ofbiz.order.shoppingcart.CheckOutHelper.createOrder method gets 
> exponentially delayed sometimes talking around 3 minutes to complete and 
> sometimes timing out. That is the reason for my exploration. My system is 
> backed by a Postgres database.
>
> Thank you all in advance. 
>
> Best,
> Pratyush
>
>
>
>
>
>
>
>

Re: AW: Add CSS/JS to backend theme from plugin

[Nicolas Malin]

Hello,

What I understand, your can cover your requirement through the decorator
extended in your customized theme.

By feedback it's more easier to manage each specificity through a
dedicated theme that extend the common-theme (or other) instead inject
some cross-functional dependencies.

But I grant that, it's currently not easier because each framework
screen doesn't have a decorator that we can extend.

Nicolas

On 19/02/2021 09:32, Ingo Wolfmayr wrote:
> Hi Michael,
>
> yes. It is in my working queue. I will create a jira with a proposal when I 
> am ready.
>
> Best regards,
> Ingo
>
>  
>
>
> -Ursprüngliche Nachricht-
> Von: Michael Brohl  
> Gesendet: Donnerstag, 18. Februar 2021 23:56
> An: user@ofbiz.apache.org
> Betreff: Re: Add CSS/JS to backend theme from plugin
>
> 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
>>
>>     >
>> Your Javascript is in
>>
>>     plugins/my-plugin/webapp/my-plugin/vendors/myscript.js
>>
>> You reference it as
>>
>>     > 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:
>>> >> resourceTypeEnumId="VT_HDR_JAVASCRIPT" sequenceId="12" 
>>> resourceValue="/reporting/js/Chart.min.js"/>
>>>   >> resourceTypeEnumId="VT_STYLESHEET" sequenceId="10"
>>> resourceValue="/reporting/css/Chart.min.css"/>
>>>
>>> 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
>>>
>>> >> 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/the
 m
 e
 s.adoc
 2.
 

Re: Manufacturing -> Production Orders & Set Up

[Nicolas Malin]

When you task move to planned, you can set a seca on workeffort status
change to run the pick list preparation.

On production site, I did the same to planned move stock from a
warehouse facility to production facility.

Nicolas

On 06/02/2021 14:46, ja...@productive1.com wrote:
> Any idea or direction of where I can look?
>
>  Original Message 
> Subject: Manufacturing -> Production Orders & Set Up
> From: 
> Date: Wed, February 03, 2021 9:09 pm
> To: "user@ofbiz.apache.org" 
>
> All we are setting up a BOM, Routing and Routing Tasks that operates as
> follows
>
> My Routing will consist of the following Routing Tasks
>
> Task 1
> Task 2
> Task 3
>
> My BOM is made up of 5 Products
> Product 1 - Associated with Task 1
> Product 2-Associated with Task 1
> Product 3-Associated with Task 2
> Product 4-Associated with Task 2
> Product 5-Associated with Task 2
>
> When running the production run I want product picked based on the tasks
> they are associated with. Is this possible? 
>
> We are having issues where ALL of the BOM is not showing up on the
> Production run
>
> Thanks,
>
> James

Re: Embedding an HTML page in a screen

[Nicolas Malin]

Hello ReEWok,

I suggest you to use a simple way: introduce a new screen that contains
a ftl template to call with html iframe your reports.

I move your message on user list because your question is how use ofbiz
for my dev and not how improve ofbiz dev.

Cheers,

Nicolas

On 25/01/2021 15:05, ReEWok wrote:
> I have an existing website that runs reports not involved with my OFBiz. I
> want to embed this webiste in to an app on my webtools portal. How would I
> do this?
>
>
>
> --
> Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-Dev-f165671.html

Re: How to get a service call stack?

[Nicolas Malin]

Hello Danny,

Currently you haven't solution instead analyze the timeline logs to
follow different service calls.

if an error raise, we haven't information on any java stack trace, so
you idea to implement a possibility to display a service call trace is a
nice idea.

Don't hesitate to open an issue if you have an idea to implement this.

Cheers

Nicolas

On 05/02/2021 08:38, 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 *
>>
>>
>> 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/

Re: Party Types

[Nicolas Malin]

For elements present on entity PartyType: 'PERSON' and 'PARTY_GROUP' has
the hasTable to 'Y' and other to 'N'

If you check entities, we have an entity Person and PartyGroup. The
logic is, I say hasTable='Y' to indicate that for this type we have some
complementary fields for an element on this type present on the entity
with the same name. It's a simple pattern to extends a entity.

Nicolas

On 07/12/2020 23:20, Emad Radwan wrote:
> Hi Nicolas,
>
> Yes, it makes sense, thank you. One more related issue please, what is the
> purpose of the ‘hasTable’ flag.
>
> Regards,
>
> Emad
>
> On Monday, December 7, 2020, Nicolas Malin  wrote:
>
>> Hi Emad,
>>
>> PARTY_GROUP and PERSON are root type for other.
>>
>> If you identify a party as CORPORATION by relation is a PARTY_GROUP.
>>
>> on demo data you have this :
>>
>> > parentTypeId="PARTY_GROUP" partyTypeId="LEGAL_ORGANIZATION"/>
>>
>> > parentTypeId="LEGAL_ORGANIZATION" partyTypeId="CORPORATION"/>
>>
>> So you can read as a corporation is a specialization of a legal
>> organization that is a specialization of a party group.
>> This help to qualify a party with force this nature.
>>
>> Nicolas
>>
>> On 07/12/2020 19:35, Emad Radwan wrote:
>>> Hi There,
>>>
>>> While navigating from the party search grid to the Party Profile there
>> is a logic that checks if the party is in PartyAndGroup or PartyAndPerson
>> view entities to decide the party type and decide the relevant details.,
>> That's all fine and understood, also the demo data has all parties in the
>> party grid assigned either Party Group or Person. My question is, why we
>> have other values in the seeded party types table like the following? In
>> other words, if I assign something like 'Legal Organization' as party type,
>> is there other logic path to handle it as it's not a party group or a
>> person and as I understand each party can be assigned one party type only!
>>> Appreciate if you shed some light,
>>>
>>> Regards,
>>>
>>> Emad.
>>>
>>> AUTOMATED_AGENT CORPORATION
>>> FAMILY GOVERNMENT_AGENCY INFORMAL_GROUP LEGAL_ORGANIZATION PARTY_GROUP
>> PERSON
>>> TEAM

Re: Party Types

[Nicolas Malin]

Hi Emad,

PARTY_GROUP and PERSON are root type for other.

If you identify a party as CORPORATION by relation is a PARTY_GROUP.

on demo data you have this :





So you can read as a corporation is a specialization of a legal organization 
that is a specialization of a party group.
This help to qualify a party with force this nature.

Nicolas

On 07/12/2020 19:35, Emad Radwan wrote:
> Hi There,
>
> While navigating from the party search grid to the Party Profile there is a 
> logic that checks if the party is in PartyAndGroup or PartyAndPerson view 
> entities to decide the party type and decide the relevant details.,  That's 
> all fine and understood, also the demo data has all parties in the party grid 
> assigned either Party Group or Person. My question is, why we have other 
> values in the seeded party types table like the following? In other words, if 
> I assign something like 'Legal Organization' as party type, is there other 
> logic path to handle it as it's not a party group or a person and as I 
> understand each party can be assigned one party type only! 
>
> Appreciate if you shed some light,
>
> Regards,
>
> Emad.
>
> AUTOMATED_AGENT CORPORATION
> FAMILY GOVERNMENT_AGENCY INFORMAL_GROUP LEGAL_ORGANIZATION PARTY_GROUP PERSON
> TEAM

Re: Backing up ofbiz

[Nicolas Malin]

Hi Daniel,

>From my part, I configure the OFBiz to be sure that no data are present
on the core.

In this case I save tow element :

 * the database

 * /var/lib/ofbiz/

For the second I configure all content, image loading and other file
generation to spot the directory /var/lib/ofbiz who is in general a
network storage.

Concerning ofbiz configuration, all is loaded as code on a separate git
branch for non secret information, and on local server as env or loaded
as secret on the infra as code system (depending the customer site)

With this all code present on the ofbiz core can be crashed and
regenerate from source as you need.

Nicolas

On 03/12/2020 13:15, Daniel Watford wrote:
> Hello,
>
> What are the minimal components of an ofbiz deployment that should be
> backed up such that it can be restored on a new host?
>
> I know we could grab a copy of the whole filesystem and database, but I
> would like to explore how to keep the size of the backup as small as
> possible. Part of the reason for this question is to determine what should
> be exposed to the host filesystem for a docker deployment.
>
> The things I thought might need backing up are:
> - Database dump
> - Database configuration ($ofbiz/framework/entity/config/entityengine.xml)
> - Base configuration ($ofbiz/framework/base/config/*)
> - Common configuration ($ofbiz/framework/common/config/*)
> - Any other modified configuration files
> - Any customised template files such as
> $ofbiz/application/accounting/template/invoice/*
>
> I have left out the plugins directory as I have assumed these would be
> installed as part of any deployment script. However any configuration files
> for those plugins would need to be backed up.
>
> Where does uploaded content get stored? This will need to be backed up too.
>
> Any comments, additions and removals to the above gratefully received.
>
> Also any war stories about backup strategies you employ, any recommended
> tools, experience of performing an emergency restore, how big your backups
> get, etc. would be good to share.
>
> Thanks,
>
> Dan.
>

Re: Ofbiz & Excel Export

[Nicolas Malin]

Hi Sakthivel,

I introduced the screenxls type screen to use the spread software
functionality to convert a html table to spread table with possibility
to indicate the cell format.
So you can use screencsv if you not need format and screenxls if you
need format.
If you need to export are native xlsx format as unofficial plugins we
develop a XlsUtil class [1] to convert a screenxls to native xlsx with a
new view type : "exportxls"



    
    

You can use it as you want for your case.

An others solution also is create your how Handler to create your export
with Apache POI [2] :

*

Workbook workbook = new XSSFWorkbook(); [...]

response.setContentType(contentType); OutputStream outputStream = 
response.getOutputStream(); workbook.write(outputStream); outputStream.flush();

*

Let me know if you found your happiness!
Cheers,
Nicolas

[1] https://labs.nereide.fr/10031/plugins/nereideutils/

[2] https://poi.apache.org/

On 02/09/2020 22:08, Sakthivel Vellingiri wrote:
> All, Does Ofbiz support Excel export natively? i see most of the Out of the
> box exports are using .csv.instead, however i do see an Excel sample in the
> Example plugin and below is the url to the Ofbiz instance running locally
> It uses the view-map type as "screenxls", but when the export is complete
> it does not produce an xls file rather it produces a html response; It may
> not be a big deal as .csv works as expected and .csv could be saved as .xls
> or .xlsx, But wanted to check with the community if there is anything
> missed in the Excel Export to function natively; Thanks for any pointers.
>
>  page="component://example/widget/example/ExampleScreens.xml#ExampleReport"
> content-type="application/vnd.ms-excel"/>
> https://localhost:9443/example/control/EditExample?exampleId=EX01
>
> 
>
> http://www.w3.org/1999/xhtml;>
>   
> 
>   
>
>   
> 
> .txf {
> mso-number-format: \@
> }
>
> .cf {
> mso-number-format: "\#\#0.00"
> }
>
> .nf {
> mso-number-format: "0.00"
> }
>
> .tf {
> mso-number-format: "HH:mm:ss"
> }
>
> .df {
> mso-number-format: "-MM-dd"
> }
>
> .dtf {
> mso-number-format: "-MM-dd HH:mm:ss"
> }
> 
> 
> Example IDEX01
> 
> TypeContrived
> 
> StatusIn Design
> 
> Example NameExample 1
> 
> Description
> 
> Long Description
> 
> Comments
> 
> Example Size
> 
> Example Date
> 
> Another Date
> 
> Another Text
> 
> 
> 
>   
> 
> 
>


pEpkey.asc
Description: application/pgp-keys


pEpkey.asc
Description: application/pgp-keys

Re: Open Source - Vertical Applications

[Nicolas Malin]

Hello Neetan,

I move your thread to user list (it's not related to the community dev)

With the OFBiz data model you can implement without major problem for
journey business with major entites like WorkEffort, FixedAsset and Party.

The better tips that I can shared, put massively your code and extension
on dedicate plugins. Do not fear to implement your own screen with your
business rule.

Nicolas

On 30/07/2020 22:05, Neetan Chopra wrote:
> Hi there
>
> This is Neetan. I am a Group CTO working in Dubai.
> Having worked in the Airline industry for 23 years (with Emirates) I have
> been thinking about open sourcing one of the core aviation applications.
> However there does not seem to be any example of a vertical OSS
> application which has made an impact.
>
> I just wanted to reach out to you to seek your advice on how the journey
> with ofbiz has been and the lessons learnt for other open source enterprise
> software endeavours.
> Thank you and would be most grateful for any advice you can offer.
>
> warm regards
> Neetan Chopra
>


pEpkey.asc
Description: application/pgp-keys

Re: About your contributions to the OFBiz project

[Nicolas Malin]

Mathieu,

On 05/03/2020 20:12, Mathieu Lirzin wrote:
>>> I apologize if I am writing you a private email! I am one of the OFBiz
>>> committers/PMC members and I just want to tell you that I greatly
>>> appreciate your contributions to the project and the constructive attitude
>>> you maintain in community discussions.
>>> Please keep up the great work and be patient because sometimes community
>>> interaction can be frustrating but in the end is not as bad as someone is
>>> trying to portray it to you.
> Am I supposed to be the “someone”?

Through my community history I translate 'someone' by each other that
interferes with different vision/opinion.

Keep in mind that your recent resignation due to conflict, appear as a
failure from some PMC so from my part it's a good initiative from Jacopo
to "take care" of contributors.

> If yes, I would have rather preferred that you expressed your
> disagreement with my point of view either directly or on the public
> mailing list instead of “not interfering” and telling Daniel in private
> that was trying to portray community interactions badly, when instead I
> was just trying to provide constructive input on the subject of using
> Mocks for tests.

And continue to share your vision, it's nice and important for all. No
bad assumption on previous Jacopo's email, read it with positive approach.

Nicolas




pEpkey.asc
Description: application/pgp-keys

Re: OFBiz Community Days – February 2020

[Nicolas Malin]

No problem Dan, I trusted you :)

You're now assigned to this issue

Nicolas

On 20/02/2020 20:51, Daniel Watford wrote:
> Hi Nicolas,
>
> I've just signed and emailed my ICLA document to secret...@apache.org
> <mailto:secret...@apache.org>, so depending on how long it takes for
> processing I should be able to submit contributions soon.
>
> Regarding OFBIZ-4035, after taking another look it might be that all
> required functionality has been provided by
> ModelFormField#getContainerId. I'll check a few use cases and confirm
> in the ticket comments.
>
> Thanks,
>
> Dan.
>
> On Thu, 20 Feb 2020 at 17:22, Nicolas Malin  <mailto:nicolas.ma...@nereide.fr>> wrote:
>
> Hi Daniel,
>
> I loaded it on the sprint, but I can't assign it because your aren't
> identify as contributor.
>
> Do you have send your ICLA [1] because I didn't found you here [2] ?
>
> Nicolas
>
> [1]
> 
> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Contributors
>
> [2] https://people.apache.org/unlistedclas.html
>
> On 20/02/2020 18:01, Daniel Watford wrote:
> > Hi Devanshu,
> >
> > I'd like to work on
> https://issues.apache.org/jira/browse/OFBIZ-4035 but am
> > unable to edit the jira to set myself as the assignee or to
> allocate to the
> > Community Day Sprint.
> >
> > Is anyone able to modify this ticket for me?
> >
> > Thanks,
> >
> > Dan Watford.
> >
> > On Thu, 20 Feb 2020 at 04:41, Devanshu Vyas
> mailto:vyas.devansh...@gmail.com>>
> > wrote:
> >
> >> Hello all,
> >>
> >> We have created a Jira sprint OFBiz Community Day (Feb 2020)
> >> <
> >>
> 
> https://issues.apache.org/jira/secure/RapidBoard.jspa?rapidView=318=OFBIZ
> >> for our February community days.
> >> 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.
> >>
> >> We should add the Sprint in cases like:
> >> 1. When we create a ticket
> >> 2. When we start working on an existing ticket (adding patch or
> closing
> >> it after a commit).
> >>
> >> 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.
> >>
> >> Basically adding Sprint will make sure your contribution will
> be counted in
> >> OFBiz community days event, which is from *21st-25th February*.
> >>
> >> Let's work together to improve OFBiz, have fun and enjoy
> working together.
> >>
> >>
> >> Thanks & Regards,
> >> Devanshu Vyas.
> >>
> >>
> >> On Mon, Feb 3, 2020 at 5:26 PM Devanshu Vyas
> mailto:vyas.devansh...@gmail.com>>
> >> wrote:
> >>
> >>> 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 *21st – 25th
> February*.
> >>>
> >>> 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 

Re: OFBiz Community Days – February 2020

[Nicolas Malin]

Hi Daniel,

I loaded it on the sprint, but I can't assign it because your aren't
identify as contributor.

Do you have send your ICLA [1] because I didn't found you here [2] ?

Nicolas

[1]
https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Contributors

[2] https://people.apache.org/unlistedclas.html

On 20/02/2020 18:01, Daniel Watford wrote:
> Hi Devanshu,
>
> I'd like to work on https://issues.apache.org/jira/browse/OFBIZ-4035 but am
> unable to edit the jira to set myself as the assignee or to allocate to the
> Community Day Sprint.
>
> Is anyone able to modify this ticket for me?
>
> Thanks,
>
> Dan Watford.
>
> On Thu, 20 Feb 2020 at 04:41, Devanshu Vyas 
> wrote:
>
>> Hello all,
>>
>> We have created a Jira sprint OFBiz Community Day (Feb 2020)
>> <
>> https://issues.apache.org/jira/secure/RapidBoard.jspa?rapidView=318=OFBIZ
>> for our February community days.
>> 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.
>>
>> We should add the Sprint in cases like:
>> 1. When we create a ticket
>> 2. When we start working on an existing ticket (adding patch or closing
>> it after a commit).
>>
>> 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.
>>
>> Basically adding Sprint will make sure your contribution will be counted in
>> OFBiz community days event, which is from *21st-25th February*.
>>
>> Let's work together to improve OFBiz, have fun and enjoy working together.
>>
>>
>> Thanks & Regards,
>> Devanshu Vyas.
>>
>>
>> On Mon, Feb 3, 2020 at 5:26 PM Devanshu Vyas 
>> wrote:
>>
>>> 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 *21st – 25th February*.
>>>
>>> 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 (February 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 21st – 25th February.
>>> At the end of February's OFBiz Community day i.e. after 25th
>>> February, 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 

Re: OFBiz Community Days – February 2020

[Nicolas Malin]

Thanks for this preparation Devanshu,

I loaded on the sprint the minilang conversion task [1] and create some
new sub tasks to convert minilang services in party component.

Cheers,

Nicolas

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

On 20/02/2020 05:41, Devanshu Vyas wrote:
> Hello all,
>
> We have created a Jira sprint OFBiz Community Day (Feb 2020)
> 
> for our February community days.
> 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.
>
> We should add the Sprint in cases like:
> 1. When we create a ticket
> 2. When we start working on an existing ticket (adding patch or closing
> it after a commit).
>
> 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.
>
> Basically adding Sprint will make sure your contribution will be counted in
> OFBiz community days event, which is from *21st-25th February*.
>
> Let's work together to improve OFBiz, have fun and enjoy working together.
>
>
> Thanks & Regards,
> Devanshu Vyas.
>
>
> On Mon, Feb 3, 2020 at 5:26 PM Devanshu Vyas 
> wrote:
>
>> 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 *21st – 25th February*.
>>
>> 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 (February 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 21st – 25th February.
>> At the end of February's OFBiz Community day i.e. after 25th
>> February, 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  and
>> join the *#ofbiz 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.
>>


pEpkey.asc
Description: 

Re: Installation trouble

[Nicolas Malin]

I found the problem :)

 $ grep JDK README.md
 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
 [JDK download](https://adoptopenjdk.net/)

On your case, it's java 11.0.6 that unsupport by gradle 2.13

Nicolas

On 23/01/2020 13:35, Daniel Watford wrote:
> I can reproduce the behaviour L is seeing in a docker container - see steps
> below.
>
> I don't have a solution yet though, sorry.
>
>
>
> Repro Steps:
>
> docker run -t -i openjdk:11 /bin/bash
>
> root@b1d80d7d85ab:/# javac -version
> javac 11.0.6
> root@b1d80d7d85ab:/# echo $JAVA_HOME
> /usr/local/openjdk-11root@b1d80d7d85ab:/# cd /usr/local
> root@b1d80d7d85ab:/usr/local# wget
> http://apache.mirror.anlx.net/ofbiz/apache-ofbiz-16.11.06.zip
> --2020-01-23 12:25:08--
> http://apache.mirror.anlx.net/ofbiz/apache-ofbiz-16.11.06.zip
> Resolving apache.mirror.anlx.net (apache.mirror.anlx.net)... 81.91.108.244,
> 81.91.108.244
> Connecting to apache.mirror.anlx.net
> (apache.mirror.anlx.net)|81.91.108.244|:80...
> connected.
> HTTP request sent, awaiting response... 200 OK
> Length: 31289456 (30M) [application/zip]
> Saving to: ‘apache-ofbiz-16.11.06.zip’
>
> apache-ofbiz-16.11.06.zip
> 100%[===>]
> 29.84M 3.19MB/s in 9.4s
>
> 2020-01-23 12:25:17 (3.16 MB/s) - ‘apache-ofbiz-16.11.06.zip’ saved
> [31289456/31289456]
>
> root@b1d80d7d85ab:/usr/local# unzip -q apache-ofbiz-16.11.06.zip
> root@b1d80d7d85ab:/usr/local# mv apache-ofbiz-16.11.06 ofbiz
> root@b1d80d7d85ab:/usr/local# cd ofbiz/
> root@b1d80d7d85ab:/usr/local/ofbiz# ls -l
> total 180
> -rw-r--r-- 1 root staff 7136 Jul 11 2016 APACHE2_HEADER
> -rw-r--r-- 1 root staff 13794 Oct 5 2016 LICENSE
> -rw-r--r-- 1 root staff 166 Jun 19 2019 NOTICE
> -rw-r--r-- 1 root staff 1747 Sep 23 2016 OPTIONAL_LIBRARIES
> -rw-r--r-- 1 root staff 20560 Aug 23 08:12 README.md
> -rw-r--r-- 1 root staff 26396 Aug 23 08:12 README.md.html
> drwxr-sr-x 14 root staff 4096 Aug 27 09:30 applications
> -rw-r--r-- 1 root staff 42437 Aug 9 13:02 build.gradle
> -rw-r--r-- 1 root staff 1929 Sep 22 2016 common.gradle
> drwxr-sr-x 19 root staff 4096 Aug 27 09:30 framework
> drwxr-sr-x 3 root staff 4096 Aug 27 09:31 gradle
> drwxr-sr-x 2 root staff 4096 Aug 27 09:30 hot-deploy
> -rwxr-xr-x 1 root staff 1180 Aug 18 15:06 init-gradle-wrapper.bat
> drwxr-sr-x 2 root staff 4096 Aug 27 09:30 lib
> -rw-r--r-- 1 root staff 7 Aug 27 09:31 revision.txt
> drwxr-sr-x 10 root staff 4096 Aug 27 09:30 runtime
> -rw-r--r-- 1 root staff 1150 Jul 30 2016 settings.gradle
> drwxr-sr-x 20 root staff 4096 Aug 27 09:31 specialpurpose
> drwxr-sr-x 7 root staff 4096 Aug 27 09:30 themes
> drwxr-sr-x 5 root staff 4096 Aug 27 09:30 tools
>
>
> root@b1d80d7d85ab:/usr/local/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
> root@b1d80d7d85ab:/usr/local/ofbiz# ls -l
> total 188
> -rw-r--r-- 1 root staff 7136 Jul 11 2016 APACHE2_HEADER
> -rw-r--r-- 1 root staff 13794 Oct 5 2016 LICENSE
> -rw-r--r-- 1 root staff 166 Jun 19 2019 NOTICE
> -rw-r--r-- 1 root staff 1747 Sep 23 2016 OPTIONAL_LIBRARIES
> -rw-r--r-- 1 root staff 20560 Aug 23 08:12 README.md
> -rw-r--r-- 1 root staff 26396 Aug 23 08:12 README.md.html
> drwxr-sr-x 14 root staff 4096 Aug 27 09:30 applications
> -rw-r--r-- 1 root staff 42437 Aug 9 13:02 build.gradle
> -rw-r--r-- 1 root staff 1929 Sep 22 2016 common.gradle
> drwxr-sr-x 19 root staff 4096 Aug 27 09:30 framework
> drwxr-sr-x 3 root staff 4096 Aug 27 09:31 gradle
> -rwxr--r-- 1 root staff 5875 Jan 23 12:26 gradlew
> drwxr-sr-x 2 root staff 4096 Aug 27 09:30 hot-deploy
> -rwxr-xr-x 1 root staff 1180 Aug 18 15:06 init-gradle-wrapper.bat
> drwxr-sr-x 2 root staff 4096 Aug 27 09:30 lib
> -rw-r--r-- 1 root staff 7 Aug 27 09:31 revision.txt
> drwxr-sr-x 10 root staff 4096 Aug 27 09:30 runtime
> -rw-r--r-- 1 root staff 1150 Jul 30 2016 settings.gradle
> drwxr-sr-x 20 root staff 4096 Aug 27 09:31 specialpurpose
> drwxr-sr-x 7 root staff 4096 Aug 27 09:30 themes
> drwxr-sr-x 5 root staff 4096 Aug 27 09:30 tools
>
>
> Windows Terminal
> root@b1d80d7d85ab:/usr/local/ofbiz# ./gradlew cleanAll loadDefault
> Downloading https://services.gradle.org/distributions/gradle-2.13-bin.zip
> .
> 

Re: Installation trouble

[Nicolas Malin]

do you analyse the gradlew script present ?

    $ file gradlew
    gradlew: a /usr/bin/env sh script, ASCII text executable   

    $ ls -l gradlew
    -rwxrwxr-x 1 mnicolas mnicolas 6128 - gradlew

From my part I run form fresh download the process and all work fine.
Just I never run it as root.

I can also try to find the problem with :

$ ./gradlew --debug

Nicolas

On 22/01/2020 17:15, L wrote:
> ./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
>
>
>


pEpkey.asc
Description: application/pgp-keys

Re: Installation trouble

[Nicolas Malin]

Hello L,

After you download the wrapper with the help script, you just run

$ ./gradlew ofbiz

the command `gradle wrapper --gradle-version 2.13`need to be run if you
currently have gradle on your system and you prefer to load the wrapper
with it.

Nicolas

On 22/01/2020 00:38, L wrote:
> Having trouble getting this working.  I the installation docs are
> pretty thin on details.
> I started with a clean install of CentOS7 updated:
>
>     [root@localhost ~]# cat /etc/redhat-release
>
> Followed these instructionsQuick & Easy Setup:
> https://cwiki.apache.org/confluence/display/OFBIZ/Demo+and+Test+Setup+Guide
>
>
>     Download an OFBiz release
>
> 1. Download and install Java 1.8 or higher JDK/J2SDK (not the JRE, you
>    need the full SDK) from Sun's Java (J2SE) site. You can use OpenJdk
>    8 (or higher).
>    Make sure your JAVA_HOME environment variable is set to this JDK
>    after installation (NOTE that for Mac OS X no JVM setup is needed,
>    just make sure Java is up to date with the OS X Software Update
>    facility).
>    There are still people using older versions, even it it's of course
>    not recommened, notably for security reasons
>   
> .
>    By and large see this page on system requirements
>   
> .
>
>    [root@localhost ~]# yum install java-11-openjdk
>    [root@localhost ~]# java --version
>    openjdk 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)
>    [root@localhost ~]# unzip
> /media/sf_Downloads/apache-ofbiz-16.11.06.zip
>
>
> 2. "Download" OFBiz in the directory of your choice (see comments below
>    about that). This should create one sub-directory: *ofbiz*. This
>    will be the OFBIZ_HOME location.
>
>    [root@localhost ~]# unzip
> /media/sf_Downloads/apache-ofbiz-16.11.06.zip
>    [root@localhost ~]# mv apache-ofbiz-16.11.06/ /usr/local/ofbiz
>    [root@localhost ~]# cd /usr/local/ofbiz/
>
> 3. (*not for snapshots*) Load OFBiz demo data in the embedded Apache
>    Derby database running *"gradlew loadAll"*on Windows or *"./gradlew
>    loadAll"*on Linux/Unix/OSX.
>
>    [root@localhost ofbiz]# ./gradlew loadAll
>    -bash: ./gradlew: No such file or director
>
>    a) I read the README.md that said to run ./gradle/init-gradle-wrapper
>
>    [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
>
>
>    b) README says:
>
>    you can setup the Gradle wrapper for OFBiz by executing the
>    following from
>    the command line at the OFBiz top level directory (folder):
>
>    `gradle wrapper --gradle-version 2.13`
>
>    [root@localhost ofbiz]# gradle wrapper --gradle-version 2.13
>    -bash: gradle: command not found
>
>
>     From there things go downhill,none of these work:
>
>    Linux/Unix/OSX: *"./gradlew**ofbiz"*or *"./startofbiz.sh"*(or even
>    "$JAVA_HOME/bin/java -jar build/libs/ofbiz.jar").
>
> What do I need to do to get this stuff to work?  Never had so much
> trouble installing an app before.
>
> Are there updated instructions anywhere?
>
>


pEpkey.asc
Description: application/pgp-keys

Re: How to test DCC whether its working or not?

[Nicolas Malin]

Hello,

Display on your instance first OFBiz instance a party, go to your cache
maintenance [1] and check it's loaded with values.

On your second instance, edit this party through webtools [2], edit it

Now on your first instance [1] your cache are normally clear.

Nicolas

[1]
webtools/control/FindUtilCacheElements?UTIL_CACHE_NAME=entitycache.entity.default.Party

[2] webtools/control/FindGeneric?entityName=Party

On 31/12/2019 07:26, vipin nirwal wrote:
> Hi All,
>
> I have implemented DCC functionality as mentioned on below link.
>
> https://cwiki.apache.org/confluence/display/OFBIZ/Distributed+Entity+Cache+Clear+%28DCC%29+Mechanism#DistributedEntityCacheClear(DCC)Mechanism-DistributedEntityCacheClear(DCC)Mechanism
>
>
> I can see counter increasing for Enqueue and Dequeue messages in ActiveMQ
> topic. But  how can i test for sure that DCC is working? Is there a testing
> mechanism for DCC? Please let me know.
> Where can i see that cache is being cleared whenever i am updating a
> product( product description for example)?
>


pEpkey.asc
Description: application/pgp-keys

Re: Interested in helping to organize the OFBiz Community Days?

[Nicolas Malin]

Hello,

I'm also available, I propose for the next to sychronized us on Slack room

Thanks to you Swapnil for maintain work on the community days

Nicolas

On 28/11/2019 11:27, Swapnil M Mane wrote:

Great, thank you Devanshu and Sanjay for offering your help.
I will sync up with you.


- Best regards,
Swapnil M Mane,
ofbiz.apache.org

On Wed, Nov 27, 2019 at 7:10 PM Sanjay Yadav 
wrote:


I am interested. Please count me in.

Thanks.
--
Sanjay Yadav
Manager, Enterprise Quality Assurance
*HotWax Systems*
*Enterprise open source experts*
cell: +91-787.918.8830
http://www.hotwaxsystems.com


On Wed, Nov 27, 2019 at 4:17 PM Swapnil M Mane 
wrote:


Hello all,

As you are aware, we organize OFBiz Community Days [*] once per quarter.
Sharan has contributed very much in organizing these events in the
past (thank you Sharan :), then I took this initiative forward.

If you are interested in helping to organize this event, please let us
know.
Following are the key activities, we perform to organize OFBiz Community
Days.

1. Create a Jira sprint for the community days.
2. Send a mail on the user list to give an idea about community days.
(usually 1st day of that month).
3. Marketing and publicity on social media
4. Reminder mail for community days (usually three days before
starting of community day).
5. Survey mail after the community days event.
6. Share the report of the survey response with the community.

[*] https://s.apache.org/OFBiz-Community-Days
[*] https://s.apache.org/OFBiz-Community-Days-Dates

Best regards,
Swapnil M Mane,
ofbiz.apache.org

Re: Over Packing

[Nicolas Malin]

I would checked Promotion Rule to adding the over quantity

Nicolas

On 21/11/2019 13:42, ja...@productive1.com wrote:

Team - We have a requirement that in some situations there is a need to
over pack when shipping products on a sales order.  I have seen other
systems that allow you to over receive as well as over pack.  Is there a
way to do this OTB with Ofbiz?

Scenario 1  - Purchase Order for GZ-1000 quantity 100 but I need to
receive and pay for quantity of 105
Scenario 2 Sales Order GZ-1005 quantity 100 but I need to pack and
invoice quantity of 105

Is this possible OTB

Thanks,

James

Re: Customer Product ID Mapping

[Nicolas Malin]

This depends of your business context where and how you will use it.

Some ideas :

 * few suppliers but huge request to resolve products -> GoodIdentification
 * Products need more information how supplier works with its -> 
SupplierProduct
 * No special use just for information or huge switch Product and 
Supplier or Other -> extend ProductRole


Cheers Nicolas

On 21/11/2019 13:38, ja...@productive1.com wrote:


On the catalog tab I see the suppliers tab which is a good way to map
the suppliers product ID to our internal product ID.  What is the best
way to map a customers product ID to our product ID.  Is there a way out
of the box?


Thanks,


James

Re: Support for Connecting to Remote Database with SSL

[Nicolas Malin]

Hello,

OFBiz use jdbc driver so for postgresql check your ssl configuration [1] 
and add ssl=true on your jdbc path 
|'jdbc:postgresql://remote-host:5432/database?ssl=true'|


||Nicolas

[1] https://jdbc.postgresql.org/documentation/91/ssl-client.html

On 12/11/2019 09:27, Bagas Sanjaya wrote:


Sorry, not the expected answer.

What my question means are: Does OFBiz support connecting to remote 
databases over SSL (that is, using SSL for connecting to database)? 
How can I configure it?


On 12/11/19 14.44, Rahul Chohal wrote:

Hello Bagas,

1. *OFBiz* comes with the necessary *SSL *certificate installed to 
*support* a

generic web browser to web server *SSL* environment

2. Please refer this document

https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide 



HTH!

On Tue, 12 Nov 2019 at 7:12 AM, Bagas Sanjaya  
wrote:



Hello,

I would like to set up OFBiz instance, which use remote database.
Connecting to database is done using SSL.

I have some question:

1. Does OFBiz support remote database connection with SSL?

2. If it is supported, how can I configure my instance to use SSL for
connecting to database?

Bagas

--
An old man doll... just what I always wanted! - Clara

Re: OFBiz upgrade guidelines : Post 16.11

[Nicolas Malin]

Hello,

If you respect the separation framework / plugins the migration is easy, 
you can the data model modification here 
https://cwiki.apache.org/confluence/display/OFBIZ/Data+Migration+by+releases


Nicolas

On 07/10/2019 10:38, Sandeep Singh wrote:

Hi All,
   Is there any recommendation or some guidelines for upgrading ofbiz. 
We are using the latest release version 16.11. I tried looking through the user 
and developer mailing list and couldnt find anything that outlines the steps or 
the effort.

Please point me a thread/descussion or some documentation that outlines the 
upgrade approach.

Thanks
--Sandeep

Re: Live Shipping Rates

[Nicolas Malin]

On 01/10/2019 19:51, ja...@productive1.com wrote:

The only thing that is added when an invoice generates is the live
estimate on the sales order as well as the estimate generated on the
pack.  However the actual charges are not added to the invoice.


Hi James,

I never use this process, but if you charge didn't add to you invoice 
it's came from that didn't set as order adjustment before you generate 
the ship.


In other word, when you call UPS for the cost, you need to check if 
OFBiz spread this information on the order. Also if you ship has many 
order how you allocate between its.


Nicolas

Re: Improve use of EntityAuditLog

[Nicolas Malin]

Hi Pierre,

On 07/10/2019 10:15, pierre.gaudin wrote:

Hi all,

OFBiz has an EntityAuditLog entity log system, which allows all 
changes to be recorded in a specific field of a table. This allows you 
to have a technical follow-up on what is recorded in a field. 
Following monitoring needs on a production environment at a customer's 
site, we have identified two limitations to the current implementation.


First, unlike logs that can be modified in production, it is not 
possible to modify the audit values of entities in production. It is 
therefore not possible to take advantage of the information provided 
by this entity to help detect production problems. To do this, it 
would be necessary to be able to activate and deactivate the audit of 
a field without having to redeploy or restart OFBiz. Currently the 
activation is done in the entity definition. The objective would be to 
be able to define it at another level in order to be able to modify 
the value dynamically.

We can use the same pattern use on cache system to define it.


Second, the entityauditlog entity is used to store functional data. We 
believe that this is a mistake and that the use of this entity must be 
purely technical. For this reason we propose to modify the current 
code in order to remove the use of the entity audit entity log in a 
functional way.


In my vision use entity audit log to detect some functional modification 
seems to be a bad hack to compensate bad functional design.


So +1 to quick out all functional analyze that exploits entity audit log

Nicolas



What do you think of that?


Thanks


Pierre GAUDIN

Re: Representing transport jobs in Ofbiz

[Nicolas Malin]

Hello Daniel,

As you describe your jobs, I would tend to use WorkEffort entity with 
sub workEffort for each sub invoicing part.


When your functional schema is operational, detect what element trigger 
the invoicing and peraphs create your own service to convert your 
workEffort to invoice


Nicolas

On 13/10/2019 21:24, Daniel Watford wrote:

Hello,

A shipping company client of mine needs to replace their current 
operations management software. I would like to build a solution based 
on ofbiz, with a plugin designed to manage their operations.


The company creates Jobs to represent orders/instructions from their 
customers. Each job can have a number of involved parties, including 
potentially multiple parties being invoiced for different parts of the 
job.


The new plugin should be able to replicate the company's Jobs with the 
introduction of some Job related entities. Please see attached diagram.


Eventually the operations software would need to generate invoices, 
email them to customers and post relevant information to accounting 
ledgers. Therefore I thought I would really need to link a Job with an 
Order.


When reading the code behind OrderServices#createOrder I noticed that 
to create a SALES_ORDER it was necessary to include a productStoreId. 
It seems that if I try to make use of the existing createOrder method 
I will need to set up some other 'infrastructure' to make the company 
appear a bit more like an ecommerce environment.


Is it appropriate for me to link Jobs to Orders in this way, or should 
I be keeping the two entities separate and find an alternative way to 
manage invoices?


If appropriate to link Jobs to Orders, should I avoid using the 
existing OrderServices#createOrder method and just construct entities 
as needed for my plugin's needs, or should I create any entities 
createOrder might need (such as productId) to ensure Orders are 
constructed in a consistent manner for use in other parts of ofbiz?


Any comments or suggestions greatly appreciated.

Many thanks,

Dan.
image.png

--
Daniel Watford

Re: Bug "scoreboard is full, not at MaxRequestWorkers" solved!

[Nicolas Malin]

Thanks a lot for this share Nicola, I forward your feedback to user

Nicolas

On 9/19/19 2:22 PM, Nicola Mazzoni wrote:

Hello All,

On a clustered installation we have two "front" nodes with OfBiz + Http2
(connected with Ajp). The system, even with modest loads, saturated the
memory and crashed the system signaling "scoreboard is full, not at
MaxRequestWorkers" in the logs.

Needless to say, the continuous cluster crashes and performance drops
caused us many problems with the customer!

Everything was due to a bug in Apache Http2 (Bug 53555), fixed in version
2.4.25.

After updating Apache http2 on all nodes, 3 months apart, after carrying
out several stress tests, the problem never reappeared.

I hope my "bad experience" can help anyone.

Regards