Re: How to config OFBiz works with Oracle database 11g express?

[Donhu Vy]

I fix my mistake, new one become to:






but still error.


From: Donhu Vy 
Sent: Wednesday, June 28, 2017 10:01:27 AM
To: user@ofbiz.apache.org
Subject: Re: How to config OFBiz works with Oracle database 11g express?


Thank Rishi Solanki,


I uninstall Oracle 11g, then install 12cR2.


I use Oracle 12cR2 at local (Windows 10 pro x64). I added ojdbc7.jar to 
\apache-ofbiz-16.11.02\lib folder.
I create use: ofbiz, password: 123456, SID: orcl.
This is my entityengine.xml
https://gist.github.com/donhuvy/2f21708851eb768259a9fd0873862ccd
This is CMD console: 
https://gist.githubusercontent.com/donhuvy/46a78306d81c111cec0690080f3ca8e9/raw/086a4a16c0e5bd3cf9c8a027f8fc31042e53cbad/cmd.log

How to fix it?


From: Rishi Solanki 
Sent: Wednesday, June 21, 2017 3:28:54 PM
To: ofbizuser
Subject: Re: How to config OFBiz works with Oracle database 11g express?

You can use localoracle and ignore the other one. Note that it will have
the jdbc driver mentioned as jdbc-driver="oracle.jdbc.driver.OracleDriver"
also you need to put the oracle jar (compatible ojdbc jar) file in the lib
folder same as you put for the mysql.

Finally add  with ofbiz entity group. You can create
update and delete in oracle db from OFBiz for all the entities available in
org.ofbiz.

HTH!



Rishi Solanki
Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com

On Wed, Jun 21, 2017 at 9:29 AM, Donhu Vy  wrote:

> I face a hard task. I have been already connect OFBiz with MySQL database
> success. I try to connect OFBiz with Oracle datatabase 11g express.
>
>
> I config in file \framework\entity\config\entityengine.xml
>
>
> With MySQL, I have 3 datasources: localmysql, localmysqlolap,
> localmysqltenant.
>
> But with Oracle, I see 2 datasources: localoracle, localoracledd.
>
>
> I don't know what is the purpose of localoracledd data source? How to
> adapt, when MySQL has 3 datasources while Oracle has 2 datasources, it is a
> mismatch point, and I don't know how to resolve problem.
>
>
> If you have exiting config for Oracle database, can you give it to me?
>
>
> Best regards,
>
>
> Vy
>
>

Re: How to config OFBiz works with Oracle database 11g express?

[Donhu Vy]

Thank Rishi Solanki,


I uninstall Oracle 11g, then install 12cR2.


I use Oracle 12cR2 at local (Windows 10 pro x64). I added ojdbc7.jar to 
\apache-ofbiz-16.11.02\lib folder.
I create use: ofbiz, password: 123456, SID: orcl.
This is my entityengine.xml
https://gist.github.com/donhuvy/2f21708851eb768259a9fd0873862ccd
This is CMD console: 
https://gist.githubusercontent.com/donhuvy/46a78306d81c111cec0690080f3ca8e9/raw/086a4a16c0e5bd3cf9c8a027f8fc31042e53cbad/cmd.log

How to fix it?


From: Rishi Solanki 
Sent: Wednesday, June 21, 2017 3:28:54 PM
To: ofbizuser
Subject: Re: How to config OFBiz works with Oracle database 11g express?

You can use localoracle and ignore the other one. Note that it will have
the jdbc driver mentioned as jdbc-driver="oracle.jdbc.driver.OracleDriver"
also you need to put the oracle jar (compatible ojdbc jar) file in the lib
folder same as you put for the mysql.

Finally add  with ofbiz entity group. You can create
update and delete in oracle db from OFBiz for all the entities available in
org.ofbiz.

HTH!



Rishi Solanki
Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com

On Wed, Jun 21, 2017 at 9:29 AM, Donhu Vy  wrote:

> I face a hard task. I have been already connect OFBiz with MySQL database
> success. I try to connect OFBiz with Oracle datatabase 11g express.
>
>
> I config in file \framework\entity\config\entityengine.xml
>
>
> With MySQL, I have 3 datasources: localmysql, localmysqlolap,
> localmysqltenant.
>
> But with Oracle, I see 2 datasources: localoracle, localoracledd.
>
>
> I don't know what is the purpose of localoracledd data source? How to
> adapt, when MySQL has 3 datasources while Oracle has 2 datasources, it is a
> mismatch point, and I don't know how to resolve problem.
>
>
> If you have exiting config for Oracle database, can you give it to me?
>
>
> Best regards,
>
>
> Vy
>
>

the price of an object and the cart object

[Heidi Dehaes - Olagos]

Hello,

Can anyone give me a hint on how the price which is visualised at a product
in the ecommerce site comes into the cart object for visualisation on the
cart.
I know it is sent via a form into the "additem" request. Via the controller
it goes to the "addToCart" method in the ShoppingCartEvents.java file and
in that method there it goes via the call "cartHelper.addToCart" further.
But i don't see in detail where the price of the product goes into the cart
object.

Can anyone help me? I don't find it immediately.

Thanks in advance,
Eric


Olagos bvba
Heidi Dehaes
Kerkstraat 34
2570 Duffel
Belgium
Tel. : 015/31 53 04
GSM :0485/22 35 80
E-mail : info.ola...@gmail.com
http://www.olagos.eu
http://www.olagos.com
http://www.olagos.be
http://www.olagos.nl

Re: Documentation gradlew loadAll vs gradlew loadDefault

[Michael Brohl]

Hi Tore,

I guess you are on a release version? The documentation you mentioned is 
for the trunk version as stated in the information box on top of the page.


You'll find the docs for 16.11 in 
https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=71011294


Regards,

Michael Brohl
ecomify GmbH
www.ecomify.de


Am 27.06.17 um 19:15 schrieb Tore Van Grembergen:

Dear All,


on the below pages it mentions that the default data needs to be 
loaded via gradlew loadAll,



https://cwiki.apache.org/confluence/display/OFBIZ/Demo+and+Test+Setup+Guide 



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




however i think it needs to be gradlew loadDefault.

If I execute /gradlew loadAll I get

FAILURE: Build failed with an exception.

* What went wrong:
Task 'loadAll' not found in root project 'ofbiz'


Kind regards


Tore






smime.p7s
Description: S/MIME Cryptographic Signature

Documentation gradlew loadAll vs gradlew loadDefault

[Tore Van Grembergen]

Dear All,


on the below pages it mentions that the default data needs to be loaded 
via gradlew loadAll,



https://cwiki.apache.org/confluence/display/OFBIZ/Demo+and+Test+Setup+Guide

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


however i think it needs to be gradlew loadDefault.

If I execute /gradlew loadAll I get

FAILURE: Build failed with an exception.

* What went wrong:
Task 'loadAll' not found in root project 'ofbiz'


Kind regards


Tore

RE: Upload tool

[james]

Thanks Paul.  We are actually evaluating Talend's opensource version. 
That will save a lot of time utilizing such a tool!

Thanks,

James

 Original Message 
Subject: Re: Upload tool
From: Paul Mandeltort 
Date: Tue, June 27, 2017 8:02 am
To: user@ofbiz.apache.org

I’d suggest looking into a proper ETL tool if your’e doing a whole
implementation such as Pentaho (open source) or Informatica
(commercial).

—P


> On Jun 27, 2017, at 9:08 AM,   
> wrote:
> 
> Wow. Thanks for the information. This seems like it should be pretty
> standard if implementing a large customer. There are so many data
> elements that need to be in the system that are not one of the web tool
> items...in which are needed for Go Live that requires upload when
> dealing with a large amount of data. Thanks again for the information.
> 
>  Original Message 
> Subject: Re: Upload tool
> From: Rishi Solanki 
> Date: Tue, June 27, 2017 5:11 am
> To: ofbizuser 
> 
> Only direct data base operations can be imported from webtools and only
> in
> xml format defined by OFBiz as seen in the multiple data files. Another
> option is OFBiz have support to import spreadsheet data, but for all
> types
> of import you need to add your customize code for that. Please refer:
> ImportProductServices class for same.
> 
> 
> 
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: +91-9893287847
> http://www.hotwaxsystems.com
> 
> On Tue, Jun 27, 2017 at 4:38 PM,  wrote:
> 
>> I see there is an upload tool that allows you to upload basic inventory
>> information. Is there a tool that allows you to upload/update inventory
>> with categories, SKU IDs, Parties/Manufacturer, etc. How how different
>> prices for the item and other areas of data outside of what webtools
>> provides?
>> 
>> Thanks,
>> 
>> James
>>

Re: Can't access webapp in debug model

[Jacques Le Roux]

I did not feel any arrogance. I just wanted to explain :)

Jacques


Le 27/06/2017 à 15:42, Daniel Coric a écrit :

Hi Jacques,

I just realized that my questions could sound arrogant - I must say, that 
wasn't my attention.
Thank you very much for these explanations - the picture is now much clearer to 
me.

Regards,
Daniel

On 2017-06-27 15:20 (+0200), Jacques Le Roux  
wrote:

To be complete, forgot to say that some ASF Top Level Projects (TLP) are only 
using Git and have no SVN branches. It's often new projects out of ASF
Incubator (was 11 years ago for OFBiz...)

At some point in the future the ASF will no longer use Githup for its Git repos 
but an internal GitBox. It's already the case for some projects, but
not OFBiz.

Some links:

https://git.apache.org/

https://gitbox.apache.org/

Jacques


Le 27/06/2017 à 14:35, Jacques Le Roux a écrit :

It's not against ASF policy to use Git for OFBiz. It's just unofficial and may 
be a bit out of date sometimes (rarely now - if ever, happened more
in the past)

For instance, using "Switch branches/tags" Github feature, you can clone  
R16.11 branch from https://github.com/apache/ofbiz/tree/release16.11 (I
guess you did that)

We have not yet released the new structure (framework+plugins), one headache 
less for now ;)

HTH

Jacques


Le 26/06/2017 à 21:02, Daniel Coric a écrit :

And this, just saw it, "There is no Git repo for the branches which support the 
released packages, but there are SVN repos at".
Is it against ASF policy to use GIT or what?! I don't understand.

On 2017-06-26 20:57 (+0200), "Daniel Coric" wrote:

Hi Jacques,

thanks.

I just saw that you have corrected the "Using GIT from within Eclipse" - wanted 
to recommend the article to Vy.
How do you mean "Freezed just before the framework and plugins split, 12 Feb 
2017"?
I have cloned release16.11 from the very same URL just before I have wrote that 
part.

Regards,
Daniel

On 2017-06-26 20:34 (+0200), Jacques Le Roux  
wrote:

Well spotted Daniel,

Vy, if you run "gradlew eclipse" it will generate the .project and .classpath 
files which are used by Eclipse to handle OFBiz

So it seems you just miss that...

Jacques


Le 26/06/2017 à 20:23, Daniel Coric a écrit :

Hi Vy,

it's pretty clear if you look a bit closely in the Project Explorer at this 
image
https://user-images.githubusercontent.com/1328316/27529985-cf1d158a-5a80-11e7-865f-581a353b94d2.jpg.
You have only empty directory "ofbiz". That means that you cannot have one more 
project under the same name. What again means that you don't
have a project "ofbiz" at all.
And, why are these other maven?! How did you import the project?

Regards,
Daniel

On 2017-06-26 10:27 (+0200), Donhu Vy  wrote:

Did you run gradlew eclipse?

--> I release all Gradle-related commands from CMD.


From: Taher Alkhateeb 
Sent: Monday, June 26, 2017 3:22:35 PM
To: user@ofbiz.apache.org
Subject: Re: Can't access webapp in debug model

Did you run gradlew eclipse?

On Jun 26, 2017 11:15 AM, "Donhu Vy"  wrote:


I try to clean all things.
gradlew cleanAll loadDefault

Indeed, At the previous session, I didn't set anything in tab Source. This
session, I set it (like screenshot https://user-images.
githubusercontent.com/1328316/27529984-cf1c13e2-5a80-11e7-
8277-9cfc20fed94d.jpg )

Tab Connect still like previous session (https://user-images.
githubusercontent.com/1328316/27529985-cf1d158a-5a80-11e7-
865f-581a353b94d2.jpg )
In CMD, Then I release command:
gradlew ofbizDebug

CMD console log has nothing. Console screen inside Eclipse IDE also has
nothing.

Error still looks like previous session (https://user-images.
githubusercontent.com/1328316/27529986-cfbca74e-5a80-11e7-
8c4f-10ba778c94e0.jpg)

This is my Eclipse log https://gist.github.com/donhuvy/
fbf6037ffd941a95729614b056764758 (File .log inside .metadata folder)

Help me debug OFBiz!



From: Jacques Le Roux 
Sent: Monday, June 26, 2017 2:50:01 PM
To: user@ofbiz.apache.org
Subject: Re: Can't access webapp in debug model

Vy,

I don't see what could be missing, seems to be an issue with your debug
config.

Did you set correctly the Debug Source tab (near Connect tab)?

Do you see something in the OFBiz console or console.log?

Did you check the Eclipse log?

Jacques

Le 26/06/2017 à 09:19, Donhu Vy a écrit :

Thank Jacques Le Roux,

I don't understand your reply. I want re-present my work step-by-step.

I am reading https://cwiki.apache.org/confluence/display/OFBIZ/

Running+and+Debugging+OFBiz+in+Eclipse . I am using Windows 10 Pro x64,
Eclipse Neon 3.

 At OFBiz's folder (F:\ofbiz), I release command

gradlew ofbizDebug

(screenshot: https://user-images.githubusercontent.com/1328316/

AW: Variant Price Calculation

[Ingo Wolfmayr]

I did explore the system. The logic for virtual product price display works as 
I stated below:

1.) walk through variants
2.) check smallest default price (Database ProductPrice entity) - not checking 
if the pricerule does any changes

I already changed the price calculation service to my needs on my local 
environment - just wanted to know if the current behavior is wanted by the 
community or my be changes to the calculation logic proposed.

Best regards,
Ingo

-Ursprüngliche Nachricht-
Von: Rishi Solanki [mailto:rishisolan...@gmail.com] 
Gesendet: Dienstag, 27. Juni 2017 16:40
An: ofbizuser 
Betreff: Re: Variant Price Calculation

As I said in my first reply the price engine works for the variant as well.
But while displaying the prices only virtual product id passed and that is why 
it is not showing up. You just need to call the service with proper parameters 
service will give you desired output I believe. Please try to explore how 
system is showing the price after calculation and how it uses the price on 
variant selection and added to cart.

I believe you just need to call the price engine with correct params and no 
improvement required to achieve your requirement. Please refer out parameters :
https://demo-trunk.ofbiz.apache.org/webtools/control/ServiceList?sel_service_name=calculateProductPrice




Rishi Solanki
Sr Manager, Enterprise Software Development HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com

On Tue, Jun 27, 2017 at 6:52 PM, Ingo Wolfmayr 
wrote:

> Thanks for sharing the details. I belive it would be an improvment to 
> have the price calulation service calulate the price for every variant 
> (including price rules) instead of just taking them from the database.
>
> now:
> 1.) walk through variants
> 2.) check smallest default price (Database ProductPrice)
>
> improvement?
> 1.) walk through variants
> 2.) calculate price for variant and check for smallest price
>
> To take the example from before:
>
> If the price is changed from 100€ to 80€ the product price is 
> displayed as "from 80 €".
> If I add a price rule with -20% from 100€ it says "100€" as the price 
> rule is not considered.
>
> The actual logic of the price calculation service looks up the 
> smallest price, but without considering a price rule behind a variant. 
> I think it would be nice if it does, or am I wrong?
>
> Ingo
>
> -Ursprüngliche Nachricht-
> Von: Rishi Solanki [mailto:rishisolan...@gmail.com]
> Gesendet: Dienstag, 27. Juni 2017 11:52
> An: ofbizuser 
> Betreff: Re: Variant Price Calculation
>
> Details you have shared for the price rule working, is working as 
> expected and implemented accordingly. That means, the price engine 
> returns the exact price when we pass the variant id to it. So I think 
> on purchase you should able to get the product as per the rule setup.
>
> I guess your problem is not functional and you want to show the 
> variant price/discount before adding them to the cart. And as while 
> rendering the product system uses the virtual id to extract the price 
> information so it is not showing.
>
> In general, if product and price setup is as per the details shared in 
> the email by you. You may need to extract product price for the 
> product you want to show before rendering and customize the product 
> rendering logic accordingly.
>
> Alternatively, change the product setup treat them as separate 
> finished good. System will automatically render the discounted product price.
>
>
> Alternative way is not recommended as we are manipulating the virtual 
> variant associated products to consider them as finished good. But it 
> should quickly resolve your problem
>
>
>
> Rishi Solanki
> Sr Manager, Enterprise Software Development HotWax Systems Pvt. Ltd.
> Direct: +91-9893287847
> http://www.hotwaxsystems.com
>
> On Mon, Jun 26, 2017 at 11:45 PM, Ingo Wolfmayr 
> 
> wrote:
>
> > Hi everybody,
> >
> > I have a question regarding the pricecalculation.
> >
> > Virtual product: 1000X
> > Variants:
> > ID 10001: Default Price 100 €
> > ID 10002: Default Price 100 €
> > ID 10003: Default Price 100 €
> >
> > Variant 10002 is on sales with a pricerule that calculates 20% off.
> > (Product category with a price rule)
> >
> > Therefore: 10002: 80  €
> >
> > The price calculation service does not take into account price rules 
> > on variants. Therefore it displays 100€ unless I select the variant.
> >
> > Is there a solution/proposal how this can be done? (without changing 
> > the price).
> >
> > Thanks for any pointer,
> >
> > Ingo
> >
>

Re: Upload tool

[Paul Mandeltort]

I’d suggest looking into a proper ETL tool if your’e doing a whole 
implementation such as Pentaho (open source) or Informatica (commercial).

—P


> On Jun 27, 2017, at 9:08 AM,   
> wrote:
> 
> Wow.  Thanks for the information.  This seems like it should be pretty
> standard if implementing a large customer.  There are so many data
> elements that need to be in the system that are not one of the web tool
> items...in which are needed for Go Live that requires upload when
> dealing with a large amount of data.  Thanks again for the information.
> 
>  Original Message 
> Subject: Re: Upload tool
> From: Rishi Solanki 
> Date: Tue, June 27, 2017 5:11 am
> To: ofbizuser 
> 
> Only direct data base operations can be imported from webtools and only
> in
> xml format defined by OFBiz as seen in the multiple data files. Another
> option is OFBiz have support to import spreadsheet data, but for all
> types
> of import you need to add your customize code for that. Please refer:
> ImportProductServices class for same.
> 
> 
> 
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: +91-9893287847
> http://www.hotwaxsystems.com
> 
> On Tue, Jun 27, 2017 at 4:38 PM,  wrote:
> 
>> I see there is an upload tool that allows you to upload basic inventory
>> information. Is there a tool that allows you to upload/update inventory
>> with categories, SKU IDs, Parties/Manufacturer, etc. How how different
>> prices for the item and other areas of data outside of what webtools
>> provides?
>> 
>> Thanks,
>> 
>> James
>> 

Re: Variant Price Calculation

[Rishi Solanki]

As I said in my first reply the price engine works for the variant as well.
But while displaying the prices only virtual product id passed and that is
why it is not showing up. You just need to call the service with proper
parameters service will give you desired output I believe. Please try to
explore how system is showing the price after calculation and how it uses
the price on variant selection and added to cart.

I believe you just need to call the price engine with correct params and no
improvement required to achieve your requirement. Please refer out
parameters :
https://demo-trunk.ofbiz.apache.org/webtools/control/ServiceList?sel_service_name=calculateProductPrice




Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com

On Tue, Jun 27, 2017 at 6:52 PM, Ingo Wolfmayr 
wrote:

> Thanks for sharing the details. I belive it would be an improvment to have
> the price calulation service calulate the price for every variant
> (including price rules) instead of just taking them from the database.
>
> now:
> 1.) walk through variants
> 2.) check smallest default price (Database ProductPrice)
>
> improvement?
> 1.) walk through variants
> 2.) calculate price for variant and check for smallest price
>
> To take the example from before:
>
> If the price is changed from 100€ to 80€ the product price is displayed as
> "from 80 €".
> If I add a price rule with -20% from 100€ it says "100€" as the price rule
> is not considered.
>
> The actual logic of the price calculation service looks up the smallest
> price, but without considering a price rule behind a variant. I think it
> would be nice if it does, or am I wrong?
>
> Ingo
>
> -Ursprüngliche Nachricht-
> Von: Rishi Solanki [mailto:rishisolan...@gmail.com]
> Gesendet: Dienstag, 27. Juni 2017 11:52
> An: ofbizuser 
> Betreff: Re: Variant Price Calculation
>
> Details you have shared for the price rule working, is working as expected
> and implemented accordingly. That means, the price engine returns the exact
> price when we pass the variant id to it. So I think on purchase you should
> able to get the product as per the rule setup.
>
> I guess your problem is not functional and you want to show the variant
> price/discount before adding them to the cart. And as while rendering the
> product system uses the virtual id to extract the price information so it
> is not showing.
>
> In general, if product and price setup is as per the details shared in the
> email by you. You may need to extract product price for the product you
> want to show before rendering and customize the product rendering logic
> accordingly.
>
> Alternatively, change the product setup treat them as separate finished
> good. System will automatically render the discounted product price.
>
>
> Alternative way is not recommended as we are manipulating the virtual
> variant associated products to consider them as finished good. But it
> should quickly resolve your problem
>
>
>
> Rishi Solanki
> Sr Manager, Enterprise Software Development HotWax Systems Pvt. Ltd.
> Direct: +91-9893287847
> http://www.hotwaxsystems.com
>
> On Mon, Jun 26, 2017 at 11:45 PM, Ingo Wolfmayr 
> wrote:
>
> > Hi everybody,
> >
> > I have a question regarding the pricecalculation.
> >
> > Virtual product: 1000X
> > Variants:
> > ID 10001: Default Price 100 €
> > ID 10002: Default Price 100 €
> > ID 10003: Default Price 100 €
> >
> > Variant 10002 is on sales with a pricerule that calculates 20% off.
> > (Product category with a price rule)
> >
> > Therefore: 10002: 80  €
> >
> > The price calculation service does not take into account price rules
> > on variants. Therefore it displays 100€ unless I select the variant.
> >
> > Is there a solution/proposal how this can be done? (without changing
> > the price).
> >
> > Thanks for any pointer,
> >
> > Ingo
> >
>

Re: ofbizsetup webapp status. Was [Re: How to add company to OFBiz?]

[Sharan Foga]

I think it could be nice to keep it and tidy it up. (so +1 from me)

Party Manager fits with some of it I think (creating company and customer etc)  
but maybe not all, because if I remember correctly it also sets up a first 
product too, and maybe warehouse so sounds a bit more like a type of general 
setup wizard...

Thanks
Sharan

On 2017-06-27 14:26 (+0200), Michael Brohl  wrote: 
> +1 for maintaining it.
> 
> I think this could be integrated in the Party Manager instead of being a 
> separate component.
> 
> Regards,
> 
> Michael
> 
> 
> Am 27.06.17 um 14:09 schrieb Jacques Le Roux:
> > Sharan, All,
> >
> > I think it's good to have such end users documentation. I just thought 
> > that this is related with the ofbizsetup webapp (in commonext).
> >
> > I was just wondering about its status. I just checked with trunk at 
> > https://localhost:8443/ofbizsetup/control/main. It seems to still be 
> > there but needs more work (eg nothing in SetupData.xml)
> >
> > Are we interested in maintaining it? Or should we only refer to end 
> > users documentation and put this webapp and related files in Attic?
> >
> > Maybe we can have both, but then ofbizsetup needs clear specs and 
> > eventually a good implementation.
> >
> > Jacques
> >
> >
> > Le 27/06/2017 à 12:01, Sharan Foga a écrit :
> >> Hi Vy
> >>
> >> I've started writing some How to documentation about this. It will be 
> >> especially for people who have installed OFBiz without any of the 
> >> demo data so the main setup like Company does not already exist.
> >>
> >> It isnt finished  https://s.apache.org/LSVW  but the main steps 
> >> should be:
> >>
> >> 1. Create an new party group (Note that you can enter the Party ID so 
> >> you can call it Company)
> >> 2. Add an address and address purposes (You will need at least a 
> >> primary address)
> >> 3. Add the role 'internal organization' as the main role
> >> 4. In Accounting / Organisation GL Settings click the 'Create New 
> >> Accounting Company' then 'Setup' next to your company (then you 
> >> should be able to setup your chart of accounts and account mappings)
> >>
> >> You might also need to make sure that you have at least some accounts 
> >> in your global GL settings template before you try creating the 
> >> accounting company...
> >>
> >> After that you should be able to setup the accounting preferences, 
> >> setup the chart of account you want, and the account mappings.
> >>
> >> Thanks
> >> Sharan
> >>
> >>
> >>
> >> On 2017-06-27 11:22 (+0200), Donhu Vy  wrote:
> >>> It is too old, out of date. I can't follow.
> >>>
> >>> 
> >>> From: Daniel Coric 
> >>> Sent: Tuesday, June 27, 2017 4:04:11 PM
> >>> To: user@ofbiz.apache.org
> >>> Subject: Re: How to add company to OFBiz?
> >>>
> >>> Hi Vy,
> >>>
> >>> there is a wiki page "How to Setup a Company".
> >>> https://cwiki.apache.org/confluence/display/OFBIZ/How+to+Setup+a+Company 
> >>>
> >>>
> >>> Hope this help.
> >>>
> >>> Regards,
> >>> Daniel
> >>>
> >>> On 2017-06-27 10:26 (+0200), Donhu Vy  wrote:
>  Sample database has a company with internal departments. I deleted 
>  it. How to add a company to this?
>  (Screenshot: 
>  https://user-images.githubusercontent.com/1328316/27577941-acece1f8-5b4c-11e7-8845-7da74d777cae.jpg)
> 
> >
> 
> 
> 

RE: Business Process Question - Best Way to Handle

[james]

Team - I think we are close to defining this process with a little bit
of custom code.  Quick question.  We used Cores as a Service item but
when we go to invoice it is left off of the invoice since Service items
must be marked as performed as well as invoiced seperately.  Is there
another item type that can go on the sales ordernot need to be
picked in the Warehouse.and will go on the invoice with all the
other products from the order when packed?

Craig - Give me a call and we can discuss what we've done which may help
you with your Lenovo customer

Thanks!

 Original Message 
Subject: RE: Business Process Question - Best Way to Handle
From: 
Date: Wed, June 14, 2017 4:59 am
To: user@ofbiz.apache.org

Pierre - Thank you for this description. So if I am correct...I
invoices a virtual "core charge" item and utilizing the RMA section
there is an "internal refurbishment" section of the RMA that will
convert the core charge inventory into a new different part ID? If so
this will definitely work. Please let me know

 Original Message 
Subject: Re: Business Process Question - Best Way to Handle
From: Pierre Smits 
Date: Thu, March 09, 2017 12:38 am
To: user@ofbiz.apache.org

James,

Based on your short description, it looks like you're talking about the
delivery and invoicing of non-serialized products, the return thereof
and
the further processing (internal/external refurbishment or replacement
by
supplier).

Delivery of the product is straight-forward, invoicing it (as a charge)
also. The return process (and associated credit-note) also Look at the
RMAs. On internal refurbishment the returned product goes through a
(virtual) refurbishment process (use manufacturing) to assign it a new
product-id and other attributes and have the new product registered in
inventory.

Best regards,

Pierre Smits

ORRTIZ.COM 
OFBiz based solutions & services

OFBiz Extensions Marketplace
http://oem.ofbizci.net/oci-2/

On Thu, Mar 9, 2017 at 2:02 AM, Shi Jinghai 
wrote:

> Thanks Paul!
>
> Great answer, very helpful to me.
>
> Glad to see James are working on a similar project as what we'll do for
> Lenovo next month. It seems the customer service functions of manufacturers
> are clouding, hope our OFBiz community can catch up this chance.
>
>
> -邮件原件-
> 发件人: Paul Mandeltort [mailto:p...@marcospec.com]
> 发送时间: 2017年3月9日 3:35
> 收件人: user@ofbiz.apache.org
> 主题: Re: Business Process Question - Best Way to Handle
>
> Technically you are buying the core from the customer and selling them a
> new one.
>
> Here’s an off-the-top-of-my-head way to try but I may have missed a step
> or two but will at least give you some ideas:
>
> To make it fit OFBiz flow, kick off a purchase order to that customer for
> the core, which will put it into inventory and will work with the receive
> PO flows when they do send it back. Ideally you would have unique part
> number for each type of core involved to track that stuff properly.
>
> Then you can track each core with inventory items which can hold the core
> serial numbers and statuses for their flow through refurbishment or
> scrapping or manufacturer’s credit and all that jazz. If you end up sending
> them to the manufacturer you just spit out a sales order for those specific
> inventory items and everything is tidy.
>
> If you get fancy you can use the MRP process to put the cores through
> internal refurbishment processes and put it back into inventory to send it
> out again for future customers if the volume gets crazy and accountants get
> involved. :-)
>
> If the purchase order gets filled (e.g. core received) take that payment
> and apply it to the sales invoice. If it doesn’t, then apply the cash
> payment to the invoice and cancel the PO.
>
> So you’ll always have a Core item on there and then either a payment from
> the PO from the returned core, or a payment from the customer in cash for
> the non-returned core and everything balances.
>
> You could adjust the PO forms so they are a “core return order” or
> something like that for the customer to send the core to you.
>
> Only complication there is you need to make sure the customers are
> identified as suppliers for those cores which could get a little
> complicated and might muddy data a bit. Might be easier to make a generic
> “Customer Core Return” supplier so it doesn’t get too messy. I think you
> can still route the payments without customizing anything.
>
> —P
>
>
> > On Mar 8, 2017, at 12:57 PM,  <
> ja...@productive1.com> wrote:
> >
> > Thanks Craig. The main thing with the cores is you have to track that
> > it is Outstanding with the customer and then when it comes back how do
> > you account for it in inventory since it can be refurbished and then
> > resold.
> >
> > Anyone else experience the business process of Cores and refurbishments?
> >
> > Thanks,
> >
> > 

RE: Upload tool

[james]

Wow.  Thanks for the information.  This seems like it should be pretty
standard if implementing a large customer.  There are so many data
elements that need to be in the system that are not one of the web tool
items...in which are needed for Go Live that requires upload when
dealing with a large amount of data.  Thanks again for the information.

 Original Message 
Subject: Re: Upload tool
From: Rishi Solanki 
Date: Tue, June 27, 2017 5:11 am
To: ofbizuser 

Only direct data base operations can be imported from webtools and only
in
xml format defined by OFBiz as seen in the multiple data files. Another
option is OFBiz have support to import spreadsheet data, but for all
types
of import you need to add your customize code for that. Please refer:
ImportProductServices class for same.



Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com

On Tue, Jun 27, 2017 at 4:38 PM,  wrote:

> I see there is an upload tool that allows you to upload basic inventory
> information. Is there a tool that allows you to upload/update inventory
> with categories, SKU IDs, Parties/Manufacturer, etc. How how different
> prices for the item and other areas of data outside of what webtools
> provides?
>
> Thanks,
>
> James
>

Re: Can't access webapp in debug model

[Daniel Coric]

Hi Jacques,

I just realized that my questions could sound arrogant - I must say, that 
wasn't my attention.
Thank you very much for these explanations - the picture is now much clearer to 
me.

Regards,
Daniel

On 2017-06-27 15:20 (+0200), Jacques Le Roux  
wrote: 
> To be complete, forgot to say that some ASF Top Level Projects (TLP) are only 
> using Git and have no SVN branches. It's often new projects out of ASF 
> Incubator (was 11 years ago for OFBiz...)
> 
> At some point in the future the ASF will no longer use Githup for its Git 
> repos but an internal GitBox. It's already the case for some projects, but 
> not OFBiz.
> 
> Some links:
> 
> https://git.apache.org/
> 
> https://gitbox.apache.org/
> 
> Jacques
> 
> 
> Le 27/06/2017 à 14:35, Jacques Le Roux a écrit :
> > It's not against ASF policy to use Git for OFBiz. It's just unofficial and 
> > may be a bit out of date sometimes (rarely now - if ever, happened more 
> > in the past)
> >
> > For instance, using "Switch branches/tags" Github feature, you can clone  
> > R16.11 branch from https://github.com/apache/ofbiz/tree/release16.11 (I 
> > guess you did that)
> >
> > We have not yet released the new structure (framework+plugins), one 
> > headache less for now ;)
> >
> > HTH
> >
> > Jacques
> >
> >
> > Le 26/06/2017 à 21:02, Daniel Coric a écrit :
> >> And this, just saw it, "There is no Git repo for the branches which 
> >> support the released packages, but there are SVN repos at".
> >> Is it against ASF policy to use GIT or what?! I don't understand.
> >>
> >> On 2017-06-26 20:57 (+0200), "Daniel Coric" wrote:
> >>> Hi Jacques,
> >>>
> >>> thanks.
> >>>
> >>> I just saw that you have corrected the "Using GIT from within Eclipse" - 
> >>> wanted to recommend the article to Vy.
> >>> How do you mean "Freezed just before the framework and plugins split, 12 
> >>> Feb 2017"?
> >>> I have cloned release16.11 from the very same URL just before I have 
> >>> wrote that part.
> >>>
> >>> Regards,
> >>> Daniel
> >>>
> >>> On 2017-06-26 20:34 (+0200), Jacques Le Roux 
> >>>  wrote:
>  Well spotted Daniel,
> 
>  Vy, if you run "gradlew eclipse" it will generate the .project and 
>  .classpath files which are used by Eclipse to handle OFBiz
> 
>  So it seems you just miss that...
> 
>  Jacques
> 
> 
>  Le 26/06/2017 à 20:23, Daniel Coric a écrit :
> > Hi Vy,
> >
> > it's pretty clear if you look a bit closely in the Project Explorer at 
> > this image 
> > https://user-images.githubusercontent.com/1328316/27529985-cf1d158a-5a80-11e7-865f-581a353b94d2.jpg.
> > You have only empty directory "ofbiz". That means that you cannot have 
> > one more project under the same name. What again means that you don't 
> > have a project "ofbiz" at all.
> > And, why are these other maven?! How did you import the project?
> >
> > Regards,
> > Daniel
> >
> > On 2017-06-26 10:27 (+0200), Donhu Vy  wrote:
> >>> Did you run gradlew eclipse?
> >> --> I release all Gradle-related commands from CMD.
> >>
> >> 
> >> From: Taher Alkhateeb 
> >> Sent: Monday, June 26, 2017 3:22:35 PM
> >> To: user@ofbiz.apache.org
> >> Subject: Re: Can't access webapp in debug model
> >>
> >> Did you run gradlew eclipse?
> >>
> >> On Jun 26, 2017 11:15 AM, "Donhu Vy"  wrote:
> >>
> >>> I try to clean all things.
> >>> gradlew cleanAll loadDefault
> >>>
> >>> Indeed, At the previous session, I didn't set anything in tab Source. 
> >>> This
> >>> session, I set it (like screenshot https://user-images.
> >>> githubusercontent.com/1328316/27529984-cf1c13e2-5a80-11e7-
> >>> 8277-9cfc20fed94d.jpg )
> >>>
> >>> Tab Connect still like previous session (https://user-images.
> >>> githubusercontent.com/1328316/27529985-cf1d158a-5a80-11e7-
> >>> 865f-581a353b94d2.jpg )
> >>> In CMD, Then I release command:
> >>> gradlew ofbizDebug
> >>>
> >>> CMD console log has nothing. Console screen inside Eclipse IDE also 
> >>> has
> >>> nothing.
> >>>
> >>> Error still looks like previous session (https://user-images.
> >>> githubusercontent.com/1328316/27529986-cfbca74e-5a80-11e7-
> >>> 8c4f-10ba778c94e0.jpg)
> >>>
> >>> This is my Eclipse log https://gist.github.com/donhuvy/
> >>> fbf6037ffd941a95729614b056764758 (File .log inside .metadata folder)
> >>>
> >>> Help me debug OFBiz!
> >>>
> >>>
> >>> 
> >>> From: Jacques Le Roux 
> >>> Sent: Monday, June 26, 2017 2:50:01 PM
> >>> To: user@ofbiz.apache.org
> >>> Subject: Re: Can't access webapp in debug model
> >>>
> 

AW: Variant Price Calculation

[Ingo Wolfmayr]

Thanks for sharing the details. I belive it would be an improvment to have the 
price calulation service calulate the price for every variant (including price 
rules) instead of just taking them from the database.

now:
1.) walk through variants 
2.) check smallest default price (Database ProductPrice)

improvement?
1.) walk through variants
2.) calculate price for variant and check for smallest price

To take the example from before:

If the price is changed from 100€ to 80€ the product price is displayed as 
"from 80 €".
If I add a price rule with -20% from 100€ it says "100€" as the price rule is 
not considered.

The actual logic of the price calculation service looks up the smallest price, 
but without considering a price rule behind a variant. I think it would be nice 
if it does, or am I wrong?

Ingo

-Ursprüngliche Nachricht-
Von: Rishi Solanki [mailto:rishisolan...@gmail.com] 
Gesendet: Dienstag, 27. Juni 2017 11:52
An: ofbizuser 
Betreff: Re: Variant Price Calculation

Details you have shared for the price rule working, is working as expected and 
implemented accordingly. That means, the price engine returns the exact price 
when we pass the variant id to it. So I think on purchase you should able to 
get the product as per the rule setup.

I guess your problem is not functional and you want to show the variant 
price/discount before adding them to the cart. And as while rendering the 
product system uses the virtual id to extract the price information so it is 
not showing.

In general, if product and price setup is as per the details shared in the 
email by you. You may need to extract product price for the product you want to 
show before rendering and customize the product rendering logic accordingly.

Alternatively, change the product setup treat them as separate finished good. 
System will automatically render the discounted product price.


Alternative way is not recommended as we are manipulating the virtual variant 
associated products to consider them as finished good. But it should quickly 
resolve your problem



Rishi Solanki
Sr Manager, Enterprise Software Development HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com

On Mon, Jun 26, 2017 at 11:45 PM, Ingo Wolfmayr 
wrote:

> Hi everybody,
>
> I have a question regarding the pricecalculation.
>
> Virtual product: 1000X
> Variants:
> ID 10001: Default Price 100 €
> ID 10002: Default Price 100 €
> ID 10003: Default Price 100 €
>
> Variant 10002 is on sales with a pricerule that calculates 20% off.
> (Product category with a price rule)
>
> Therefore: 10002: 80  €
>
> The price calculation service does not take into account price rules 
> on variants. Therefore it displays 100€ unless I select the variant.
>
> Is there a solution/proposal how this can be done? (without changing 
> the price).
>
> Thanks for any pointer,
>
> Ingo
>

Re: Can't access webapp in debug model

[Jacques Le Roux]

To be complete, forgot to say that some ASF Top Level Projects (TLP) are only using Git and have no SVN branches. It's often new projects out of ASF 
Incubator (was 11 years ago for OFBiz...)


At some point in the future the ASF will no longer use Githup for its Git repos but an internal GitBox. It's already the case for some projects, but 
not OFBiz.


Some links:

https://git.apache.org/

https://gitbox.apache.org/

Jacques


Le 27/06/2017 à 14:35, Jacques Le Roux a écrit :
It's not against ASF policy to use Git for OFBiz. It's just unofficial and may be a bit out of date sometimes (rarely now - if ever, happened more 
in the past)


For instance, using "Switch branches/tags" Github feature, you can clone  R16.11 branch from https://github.com/apache/ofbiz/tree/release16.11 (I 
guess you did that)


We have not yet released the new structure (framework+plugins), one headache 
less for now ;)

HTH

Jacques


Le 26/06/2017 à 21:02, Daniel Coric a écrit :

And this, just saw it, "There is no Git repo for the branches which support the 
released packages, but there are SVN repos at".
Is it against ASF policy to use GIT or what?! I don't understand.

On 2017-06-26 20:57 (+0200), "Daniel Coric" wrote:

Hi Jacques,

thanks.

I just saw that you have corrected the "Using GIT from within Eclipse" - wanted 
to recommend the article to Vy.
How do you mean "Freezed just before the framework and plugins split, 12 Feb 
2017"?
I have cloned release16.11 from the very same URL just before I have wrote that 
part.

Regards,
Daniel

On 2017-06-26 20:34 (+0200), Jacques Le Roux  
wrote:

Well spotted Daniel,

Vy, if you run "gradlew eclipse" it will generate the .project and .classpath 
files which are used by Eclipse to handle OFBiz

So it seems you just miss that...

Jacques


Le 26/06/2017 à 20:23, Daniel Coric a écrit :

Hi Vy,

it's pretty clear if you look a bit closely in the Project Explorer at this image 
https://user-images.githubusercontent.com/1328316/27529985-cf1d158a-5a80-11e7-865f-581a353b94d2.jpg.
You have only empty directory "ofbiz". That means that you cannot have one more project under the same name. What again means that you don't 
have a project "ofbiz" at all.

And, why are these other maven?! How did you import the project?

Regards,
Daniel

On 2017-06-26 10:27 (+0200), Donhu Vy  wrote:

Did you run gradlew eclipse?

--> I release all Gradle-related commands from CMD.


From: Taher Alkhateeb 
Sent: Monday, June 26, 2017 3:22:35 PM
To: user@ofbiz.apache.org
Subject: Re: Can't access webapp in debug model

Did you run gradlew eclipse?

On Jun 26, 2017 11:15 AM, "Donhu Vy"  wrote:


I try to clean all things.
gradlew cleanAll loadDefault

Indeed, At the previous session, I didn't set anything in tab Source. This
session, I set it (like screenshot https://user-images.
githubusercontent.com/1328316/27529984-cf1c13e2-5a80-11e7-
8277-9cfc20fed94d.jpg )

Tab Connect still like previous session (https://user-images.
githubusercontent.com/1328316/27529985-cf1d158a-5a80-11e7-
865f-581a353b94d2.jpg )
In CMD, Then I release command:
gradlew ofbizDebug

CMD console log has nothing. Console screen inside Eclipse IDE also has
nothing.

Error still looks like previous session (https://user-images.
githubusercontent.com/1328316/27529986-cfbca74e-5a80-11e7-
8c4f-10ba778c94e0.jpg)

This is my Eclipse log https://gist.github.com/donhuvy/
fbf6037ffd941a95729614b056764758 (File .log inside .metadata folder)

Help me debug OFBiz!



From: Jacques Le Roux 
Sent: Monday, June 26, 2017 2:50:01 PM
To: user@ofbiz.apache.org
Subject: Re: Can't access webapp in debug model

Vy,

I don't see what could be missing, seems to be an issue with your debug
config.

Did you set correctly the Debug Source tab (near Connect tab)?

Do you see something in the OFBiz console or console.log?

Did you check the Eclipse log?

Jacques

Le 26/06/2017 à 09:19, Donhu Vy a écrit :

Thank Jacques Le Roux,

I don't understand your reply. I want re-present my work step-by-step.

I am reading https://cwiki.apache.org/confluence/display/OFBIZ/

Running+and+Debugging+OFBiz+in+Eclipse . I am using Windows 10 Pro x64,
Eclipse Neon 3.

At OFBiz's folder (F:\ofbiz), I release command

gradlew ofbizDebug

(screenshot: https://user-images.githubusercontent.com/1328316/

27528187-72519bca-5a79-11e7-8bd2-e4d3751642f7.jpg )

At Debug configuration windows, I set configuration like screenshot

https://user-images.githubusercontent.com/1328316/
27528188-7276fc1c-5a79-11e7-846c-85d75b037f5d.jpg

When I press button "Debug", I see error:
Problem Occurred
'Launching gradle_remote_debug' has encountered a problem. Launch

configuration gradle_remote_debug references closed project ofbiz.

Details: Launch configuration gradle_remote_debug 

Re: Can't access webapp in debug model

[Jacques Le Roux]

It's not against ASF policy to use Git for OFBiz. It's just unofficial and may be a bit out of date sometimes (rarely now - if ever, happened more in 
the past)


For instance, using "Switch branches/tags" Github feature, you can clone  R16.11 branch from https://github.com/apache/ofbiz/tree/release16.11 (I 
guess you did that)


We have not yet released the new structure (framework+plugins), one headache 
less for now ;)

HTH

Jacques


Le 26/06/2017 à 21:02, Daniel Coric a écrit :

And this, just saw it, "There is no Git repo for the branches which support the 
released packages, but there are SVN repos at".
Is it against ASF policy to use GIT or what?! I don't understand.

On 2017-06-26 20:57 (+0200), "Daniel Coric" wrote:

Hi Jacques,

thanks.

I just saw that you have corrected the "Using GIT from within Eclipse" - wanted 
to recommend the article to Vy.
How do you mean "Freezed just before the framework and plugins split, 12 Feb 
2017"?
I have cloned release16.11 from the very same URL just before I have wrote that 
part.

Regards,
Daniel

On 2017-06-26 20:34 (+0200), Jacques Le Roux  
wrote:

Well spotted Daniel,

Vy, if you run "gradlew eclipse" it will generate the .project and .classpath 
files which are used by Eclipse to handle OFBiz

So it seems you just miss that...

Jacques


Le 26/06/2017 à 20:23, Daniel Coric a écrit :

Hi Vy,

it's pretty clear if you look a bit closely in the Project Explorer at this 
image 
https://user-images.githubusercontent.com/1328316/27529985-cf1d158a-5a80-11e7-865f-581a353b94d2.jpg.
You have only empty directory "ofbiz". That means that you cannot have one more project 
under the same name. What again means that you don't have a project "ofbiz" at all.
And, why are these other maven?! How did you import the project?

Regards,
Daniel

On 2017-06-26 10:27 (+0200), Donhu Vy  wrote:

Did you run gradlew eclipse?

--> I release all Gradle-related commands from CMD.


From: Taher Alkhateeb 
Sent: Monday, June 26, 2017 3:22:35 PM
To: user@ofbiz.apache.org
Subject: Re: Can't access webapp in debug model

Did you run gradlew eclipse?

On Jun 26, 2017 11:15 AM, "Donhu Vy"  wrote:


I try to clean all things.
gradlew cleanAll loadDefault

Indeed, At the previous session, I didn't set anything in tab Source. This
session, I set it (like screenshot https://user-images.
githubusercontent.com/1328316/27529984-cf1c13e2-5a80-11e7-
8277-9cfc20fed94d.jpg )

Tab Connect still like previous session (https://user-images.
githubusercontent.com/1328316/27529985-cf1d158a-5a80-11e7-
865f-581a353b94d2.jpg )
In CMD, Then I release command:
gradlew ofbizDebug

CMD console log has nothing. Console screen inside Eclipse IDE also has
nothing.

Error still looks like previous session (https://user-images.
githubusercontent.com/1328316/27529986-cfbca74e-5a80-11e7-
8c4f-10ba778c94e0.jpg)

This is my Eclipse log https://gist.github.com/donhuvy/
fbf6037ffd941a95729614b056764758 (File .log inside .metadata folder)

Help me debug OFBiz!



From: Jacques Le Roux 
Sent: Monday, June 26, 2017 2:50:01 PM
To: user@ofbiz.apache.org
Subject: Re: Can't access webapp in debug model

Vy,

I don't see what could be missing, seems to be an issue with your debug
config.

Did you set correctly the Debug Source tab (near Connect tab)?

Do you see something in the OFBiz console or console.log?

Did you check the Eclipse log?

Jacques

Le 26/06/2017 à 09:19, Donhu Vy a écrit :

Thank Jacques Le Roux,

I don't understand your reply. I want re-present my work step-by-step.

I am reading https://cwiki.apache.org/confluence/display/OFBIZ/

Running+and+Debugging+OFBiz+in+Eclipse . I am using Windows 10 Pro x64,
Eclipse Neon 3.

At OFBiz's folder (F:\ofbiz), I release command

gradlew ofbizDebug

(screenshot: https://user-images.githubusercontent.com/1328316/

27528187-72519bca-5a79-11e7-8bd2-e4d3751642f7.jpg )

At Debug configuration windows, I set configuration like screenshot

https://user-images.githubusercontent.com/1328316/
27528188-7276fc1c-5a79-11e7-846c-85d75b037f5d.jpg

When I press button "Debug", I see error:
Problem Occurred
'Launching gradle_remote_debug' has encountered a problem. Launch

configuration gradle_remote_debug references closed project ofbiz.

Details: Launch configuration gradle_remote_debug references closed

project ofbiz

(Screenshot: https://user-images.githubusercontent.com/1328316/

27528317-19ce76c0-5a7a-11e7-9635-e0e38adb07ca.jpg )

How to debug OFBiz inside Eclipse IDE?


Vy


From: Jacques Le Roux 
Sent: Monday, June 26, 2017 1:32:39 PM
To: user@ofbiz.apache.org
Subject: Re: Can't access webapp in debug model

Hi,

You need to start a debugger for OFBiz to continue and be ready.

When you use 

Re: ofbizsetup webapp status. Was [Re: How to add company to OFBiz?]

[Michael Brohl]

+1 for maintaining it.

I think this could be integrated in the Party Manager instead of being a 
separate component.


Regards,

Michael


Am 27.06.17 um 14:09 schrieb Jacques Le Roux:

Sharan, All,

I think it's good to have such end users documentation. I just thought 
that this is related with the ofbizsetup webapp (in commonext).


I was just wondering about its status. I just checked with trunk at 
https://localhost:8443/ofbizsetup/control/main. It seems to still be 
there but needs more work (eg nothing in SetupData.xml)


Are we interested in maintaining it? Or should we only refer to end 
users documentation and put this webapp and related files in Attic?


Maybe we can have both, but then ofbizsetup needs clear specs and 
eventually a good implementation.


Jacques


Le 27/06/2017 à 12:01, Sharan Foga a écrit :

Hi Vy

I've started writing some How to documentation about this. It will be 
especially for people who have installed OFBiz without any of the 
demo data so the main setup like Company does not already exist.


It isnt finished  https://s.apache.org/LSVW  but the main steps 
should be:


1. Create an new party group (Note that you can enter the Party ID so 
you can call it Company)
2. Add an address and address purposes (You will need at least a 
primary address)

3. Add the role 'internal organization' as the main role
4. In Accounting / Organisation GL Settings click the 'Create New 
Accounting Company' then 'Setup' next to your company (then you 
should be able to setup your chart of accounts and account mappings)


You might also need to make sure that you have at least some accounts 
in your global GL settings template before you try creating the 
accounting company...


After that you should be able to setup the accounting preferences, 
setup the chart of account you want, and the account mappings.


Thanks
Sharan



On 2017-06-27 11:22 (+0200), Donhu Vy  wrote:

It is too old, out of date. I can't follow.


From: Daniel Coric 
Sent: Tuesday, June 27, 2017 4:04:11 PM
To: user@ofbiz.apache.org
Subject: Re: How to add company to OFBiz?

Hi Vy,

there is a wiki page "How to Setup a Company".
https://cwiki.apache.org/confluence/display/OFBIZ/How+to+Setup+a+Company 



Hope this help.

Regards,
Daniel

On 2017-06-27 10:26 (+0200), Donhu Vy  wrote:
Sample database has a company with internal departments. I deleted 
it. How to add a company to this?
(Screenshot: 
https://user-images.githubusercontent.com/1328316/27577941-acece1f8-5b4c-11e7-8845-7da74d777cae.jpg)









smime.p7s
Description: S/MIME Cryptographic Signature

Re: Can't access webapp in debug model

[Jacques Le Roux]

Hi Daniel,

Before the Feb 12 2017 there was only 1 trunk containing both the framework and plugins directories. Same in all currently released packages and 
related branches.


After this date we have split the trunk in 2 "repos" (actually only branches, SVN at the ASF is sharing/using the same repo http://svn.apache.org/ 
with/for all projects)


You can start here to better understand the OFBiz SVN structure: 
http://svn.apache.org/viewvc/ofbiz/

Now for Git: OFBiz is using SVN as official repository. Git repos are only 
copies based on SVN branches.

There is some information about that at 
http://ofbiz.apache.org/source-repositories.html

If you clone from https://github.com/apache/ofbiz then you are not really 
cloning the R16 branch, but the trunk as it was the Feb 12 2017

HTH

Jacques


Le 26/06/2017 à 20:57, Daniel Coric a écrit :

Hi Jacques,

thanks.

I just saw that you have corrected the "Using GIT from within Eclipse" - wanted 
to recommend the article to Vy.
How do you mean "Freezed just before the framework and plugins split, 12 Feb 
2017"?
I have cloned release16.11 from the very same URL just before I have wrote that 
part.

Regards,
Daniel

On 2017-06-26 20:34 (+0200), Jacques Le Roux  
wrote:

Well spotted Daniel,

Vy, if you run "gradlew eclipse" it will generate the .project and .classpath 
files which are used by Eclipse to handle OFBiz

So it seems you just miss that...

Jacques


Le 26/06/2017 à 20:23, Daniel Coric a écrit :

Hi Vy,

it's pretty clear if you look a bit closely in the Project Explorer at this 
image 
https://user-images.githubusercontent.com/1328316/27529985-cf1d158a-5a80-11e7-865f-581a353b94d2.jpg.
You have only empty directory "ofbiz". That means that you cannot have one more project 
under the same name. What again means that you don't have a project "ofbiz" at all.
And, why are these other maven?! How did you import the project?

Regards,
Daniel

On 2017-06-26 10:27 (+0200), Donhu Vy  wrote:

Did you run gradlew eclipse?

--> I release all Gradle-related commands from CMD.


From: Taher Alkhateeb 
Sent: Monday, June 26, 2017 3:22:35 PM
To: user@ofbiz.apache.org
Subject: Re: Can't access webapp in debug model

Did you run gradlew eclipse?

On Jun 26, 2017 11:15 AM, "Donhu Vy"  wrote:


I try to clean all things.
gradlew cleanAll loadDefault

Indeed, At the previous session, I didn't set anything in tab Source. This
session, I set it (like screenshot https://user-images.
githubusercontent.com/1328316/27529984-cf1c13e2-5a80-11e7-
8277-9cfc20fed94d.jpg )

Tab Connect still like previous session (https://user-images.
githubusercontent.com/1328316/27529985-cf1d158a-5a80-11e7-
865f-581a353b94d2.jpg )
In CMD, Then I release command:
gradlew ofbizDebug

CMD console log has nothing. Console screen inside Eclipse IDE also has
nothing.

Error still looks like previous session (https://user-images.
githubusercontent.com/1328316/27529986-cfbca74e-5a80-11e7-
8c4f-10ba778c94e0.jpg)

This is my Eclipse log https://gist.github.com/donhuvy/
fbf6037ffd941a95729614b056764758 (File .log inside .metadata folder)

Help me debug OFBiz!



From: Jacques Le Roux 
Sent: Monday, June 26, 2017 2:50:01 PM
To: user@ofbiz.apache.org
Subject: Re: Can't access webapp in debug model

Vy,

I don't see what could be missing, seems to be an issue with your debug
config.

Did you set correctly the Debug Source tab (near Connect tab)?

Do you see something in the OFBiz console or console.log?

Did you check the Eclipse log?

Jacques

Le 26/06/2017 à 09:19, Donhu Vy a écrit :

Thank Jacques Le Roux,

I don't understand your reply. I want re-present my work step-by-step.

I am reading https://cwiki.apache.org/confluence/display/OFBIZ/

Running+and+Debugging+OFBiz+in+Eclipse . I am using Windows 10 Pro x64,
Eclipse Neon 3.

At OFBiz's folder (F:\ofbiz), I release command

gradlew ofbizDebug

(screenshot: https://user-images.githubusercontent.com/1328316/

27528187-72519bca-5a79-11e7-8bd2-e4d3751642f7.jpg )

At Debug configuration windows, I set configuration like screenshot

https://user-images.githubusercontent.com/1328316/
27528188-7276fc1c-5a79-11e7-846c-85d75b037f5d.jpg

When I press button "Debug", I see error:
Problem Occurred
'Launching gradle_remote_debug' has encountered a problem. Launch

configuration gradle_remote_debug references closed project ofbiz.

Details: Launch configuration gradle_remote_debug references closed

project ofbiz

(Screenshot: https://user-images.githubusercontent.com/1328316/

27528317-19ce76c0-5a7a-11e7-9635-e0e38adb07ca.jpg )

How to debug OFBiz inside Eclipse IDE?


Vy


From: Jacques Le Roux 
Sent: Monday, June 26, 2017 1:32:39 PM
To: user@ofbiz.apache.org
Subject: Re: Can't access webapp in debug 

Re: Upload tool

[Rishi Solanki]

Only direct data base operations can be imported from webtools and only in
xml format defined by OFBiz as seen in the multiple data files. Another
option is OFBiz have support to import spreadsheet data, but for all types
of import you need to add your customize code for that. Please refer:
ImportProductServices class for same.



Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com

On Tue, Jun 27, 2017 at 4:38 PM,  wrote:

> I see there is an upload tool that allows you to upload basic inventory
> information.  Is there a tool that allows you to upload/update inventory
> with categories, SKU IDs, Parties/Manufacturer, etc.  How how different
> prices for the item and other areas of data outside of what webtools
> provides?
>
> Thanks,
>
> James
>

ofbizsetup webapp status. Was [Re: How to add company to OFBiz?]

[Jacques Le Roux]

Sharan, All,

I think it's good to have such end users documentation. I just thought that 
this is related with the ofbizsetup webapp (in commonext).

I was just wondering about its status. I just checked with trunk at https://localhost:8443/ofbizsetup/control/main. It seems to still be there but 
needs more work (eg nothing in SetupData.xml)


Are we interested in maintaining it? Or should we only refer to end users 
documentation and put this webapp and related files in Attic?

Maybe we can have both, but then ofbizsetup needs clear specs and eventually a 
good implementation.

Jacques


Le 27/06/2017 à 12:01, Sharan Foga a écrit :

Hi Vy

I've started writing some How to documentation about this. It will be 
especially for people who have installed OFBiz without any of the demo data so 
the main setup like Company does not already exist.

It isnt finished  https://s.apache.org/LSVW  but the main steps should be:

1. Create an new party group (Note that you can enter the Party ID so you can 
call it Company)
2. Add an address and address purposes (You will need at least a primary 
address)
3. Add the role 'internal organization' as the main role
4. In Accounting / Organisation GL Settings click the 'Create New Accounting 
Company' then 'Setup' next to your company (then you should be able to setup 
your chart of accounts and account mappings)

You might also need to make sure that you have at least some accounts in your 
global GL settings template before you try creating the accounting company...

After that you should be able to setup the accounting preferences, setup the 
chart of account you want, and the account mappings.

Thanks
Sharan



On 2017-06-27 11:22 (+0200), Donhu Vy  wrote:

It is too old, out of date. I can't follow.


From: Daniel Coric 
Sent: Tuesday, June 27, 2017 4:04:11 PM
To: user@ofbiz.apache.org
Subject: Re: How to add company to OFBiz?

Hi Vy,

there is a wiki page "How to Setup a Company".
https://cwiki.apache.org/confluence/display/OFBIZ/How+to+Setup+a+Company

Hope this help.

Regards,
Daniel

On 2017-06-27 10:26 (+0200), Donhu Vy  wrote:

Sample database has a company with internal departments. I deleted it. How to 
add a company to this?
(Screenshot: 
https://user-images.githubusercontent.com/1328316/27577941-acece1f8-5b4c-11e7-8845-7da74d777cae.jpg)

Upload tool

[james]

I see there is an upload tool that allows you to upload basic inventory
information.  Is there a tool that allows you to upload/update inventory
with categories, SKU IDs, Parties/Manufacturer, etc.  How how different
prices for the item and other areas of data outside of what webtools
provides?

Thanks,

James

Re: How to add company to OFBiz?

[Rishi Solanki]

Also you can refer: accounting/data/DemoOrganizationData.xml



--
Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com

On Tue, Jun 27, 2017 at 3:31 PM, Sharan Foga  wrote:

> Hi Vy
>
> I've started writing some How to documentation about this. It will be
> especially for people who have installed OFBiz without any of the demo data
> so the main setup like Company does not already exist.
>
> It isnt finished  https://s.apache.org/LSVW  but the main steps should be:
>
> 1. Create an new party group (Note that you can enter the Party ID so you
> can call it Company)
> 2. Add an address and address purposes (You will need at least a primary
> address)
> 3. Add the role 'internal organization' as the main role
> 4. In Accounting / Organisation GL Settings click the 'Create New
> Accounting Company' then 'Setup' next to your company (then you should be
> able to setup your chart of accounts and account mappings)
>
> You might also need to make sure that you have at least some accounts in
> your global GL settings template before you try creating the accounting
> company...
>
> After that you should be able to setup the accounting preferences, setup
> the chart of account you want, and the account mappings.
>
> Thanks
> Sharan
>
>
>
> On 2017-06-27 11:22 (+0200), Donhu Vy  wrote:
> > It is too old, out of date. I can't follow.
> >
> > 
> > From: Daniel Coric 
> > Sent: Tuesday, June 27, 2017 4:04:11 PM
> > To: user@ofbiz.apache.org
> > Subject: Re: How to add company to OFBiz?
> >
> > Hi Vy,
> >
> > there is a wiki page "How to Setup a Company".
> > https://cwiki.apache.org/confluence/display/OFBIZ/How+to+Setup+a+Company
> >
> > Hope this help.
> >
> > Regards,
> > Daniel
> >
> > On 2017-06-27 10:26 (+0200), Donhu Vy  wrote:
> > > Sample database has a company with internal departments. I deleted it.
> How to add a company to this?
> > > (Screenshot: https://user-images.githubusercontent.com/1328316/
> 27577941-acece1f8-5b4c-11e7-8845-7da74d777cae.jpg)
> > >
> >
>

Re: How to add a new product success?

[Rishi Solanki]

Vy,
Error says:
Detail: Key (manufacturer_party_id)=(SD301_CR) is not present in table
"party".)))

You need to create manufacturer party before creating the product. Or
may be for now you can simply

load the party entity data with manufacturer role from webtools. I'm
not sure you got my point,

consider it as simple database fk error and create the party before
using it into product entity or leave the field blank.


--
Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com

On Tue, Jun 27, 2017 at 3:20 PM, Donhu Vy  wrote:

> I use OFBiz 16.11.02 on Windows, at link: https://localhost:8443/
> catalog/control/createProduct
> Screenshot:
> https://user-images.githubusercontent.com/1328316/
> 27581643-6fe3e480-5b58-11e7-85e6-797e73226f0c.jpg
> https://user-images.githubusercontent.com/1328316/
> 27581645-70517040-5b58-11e7-846d-8297a39412ae.jpg
>
> Error message: https://gist.githubusercontent.com/donhuvy/
> 51acfd8454d641307e5c8b4bf5e17624/raw/fa5b0d0f2a87acbe2b759d226c3edf
> a2c55be9ac/error.log
>
> How to avoid error?
>
>

Re: How to add company to OFBiz?

[Sharan Foga]

Hi Vy

I've started writing some How to documentation about this. It will be 
especially for people who have installed OFBiz without any of the demo data so 
the main setup like Company does not already exist.

It isnt finished  https://s.apache.org/LSVW  but the main steps should be:

1. Create an new party group (Note that you can enter the Party ID so you can 
call it Company)
2. Add an address and address purposes (You will need at least a primary 
address)
3. Add the role 'internal organization' as the main role
4. In Accounting / Organisation GL Settings click the 'Create New Accounting 
Company' then 'Setup' next to your company (then you should be able to setup 
your chart of accounts and account mappings)

You might also need to make sure that you have at least some accounts in your 
global GL settings template before you try creating the accounting company...

After that you should be able to setup the accounting preferences, setup the 
chart of account you want, and the account mappings.

Thanks
Sharan 



On 2017-06-27 11:22 (+0200), Donhu Vy  wrote:  
> It is too old, out of date. I can't follow.
> 
> 
> From: Daniel Coric 
> Sent: Tuesday, June 27, 2017 4:04:11 PM
> To: user@ofbiz.apache.org
> Subject: Re: How to add company to OFBiz?
> 
> Hi Vy,
> 
> there is a wiki page "How to Setup a Company".
> https://cwiki.apache.org/confluence/display/OFBIZ/How+to+Setup+a+Company
> 
> Hope this help.
> 
> Regards,
> Daniel
> 
> On 2017-06-27 10:26 (+0200), Donhu Vy  wrote:
> > Sample database has a company with internal departments. I deleted it. How 
> > to add a company to this?
> > (Screenshot: 
> > https://user-images.githubusercontent.com/1328316/27577941-acece1f8-5b4c-11e7-8845-7da74d777cae.jpg)
> >
> 

Re: Variant Price Calculation

[Rishi Solanki]

Details you have shared for the price rule working, is working as expected
and implemented accordingly. That means, the price engine returns the exact
price when we pass the variant id to it. So I think on purchase you should
able to get the product as per the rule setup.

I guess your problem is not functional and you want to show the variant
price/discount before adding them to the cart. And as while rendering the
product system uses the virtual id to extract the price information so it
is not showing.

In general, if product and price setup is as per the details shared in the
email by you. You may need to extract product price for the product you
want to show before rendering and customize the product rendering logic
accordingly.

Alternatively, change the product setup treat them as separate finished
good. System will automatically render the discounted product price.


Alternative way is not recommended as we are manipulating the virtual
variant associated products to consider them as finished good. But it
should quickly resolve your problem



Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com

On Mon, Jun 26, 2017 at 11:45 PM, Ingo Wolfmayr 
wrote:

> Hi everybody,
>
> I have a question regarding the pricecalculation.
>
> Virtual product: 1000X
> Variants:
> ID 10001: Default Price 100 €
> ID 10002: Default Price 100 €
> ID 10003: Default Price 100 €
>
> Variant 10002 is on sales with a pricerule that calculates 20% off.
> (Product category with a price rule)
>
> Therefore: 10002: 80  €
>
> The price calculation service does not take into account price rules on
> variants. Therefore it displays 100€ unless I select the variant.
>
> Is there a solution/proposal how this can be done? (without changing the
> price).
>
> Thanks for any pointer,
>
> Ingo
>

How to add a new product success?

[Donhu Vy]

I use OFBiz 16.11.02 on Windows, at link: 
https://localhost:8443/catalog/control/createProduct
Screenshot:
https://user-images.githubusercontent.com/1328316/27581643-6fe3e480-5b58-11e7-85e6-797e73226f0c.jpg
https://user-images.githubusercontent.com/1328316/27581645-70517040-5b58-11e7-846d-8297a39412ae.jpg

Error message: 
https://gist.githubusercontent.com/donhuvy/51acfd8454d641307e5c8b4bf5e17624/raw/fa5b0d0f2a87acbe2b759d226c3edfa2c55be9ac/error.log

How to avoid error?

Re: How to add company to OFBiz?

[Donhu Vy]

It is too old, out of date. I can't follow.


From: Daniel Coric 
Sent: Tuesday, June 27, 2017 4:04:11 PM
To: user@ofbiz.apache.org
Subject: Re: How to add company to OFBiz?

Hi Vy,

there is a wiki page "How to Setup a Company".
https://cwiki.apache.org/confluence/display/OFBIZ/How+to+Setup+a+Company

Hope this help.

Regards,
Daniel

On 2017-06-27 10:26 (+0200), Donhu Vy  wrote:
> Sample database has a company with internal departments. I deleted it. How to 
> add a company to this?
> (Screenshot: 
> https://user-images.githubusercontent.com/1328316/27577941-acece1f8-5b4c-11e7-8845-7da74d777cae.jpg)
>

Re: How to add company to OFBiz?

[Daniel Coric]

Hi Vy,

there is a wiki page "How to Setup a Company".
https://cwiki.apache.org/confluence/display/OFBIZ/How+to+Setup+a+Company

Hope this help.

Regards,
Daniel

On 2017-06-27 10:26 (+0200), Donhu Vy  wrote: 
> Sample database has a company with internal departments. I deleted it. How to 
> add a company to this?
> (Screenshot: 
> https://user-images.githubusercontent.com/1328316/27577941-acece1f8-5b4c-11e7-8845-7da74d777cae.jpg)
> 

How to add company to OFBiz?

[Donhu Vy]

Sample database has a company with internal departments. I deleted it. How to 
add a company to this?
(Screenshot: 
https://user-images.githubusercontent.com/1328316/27577941-acece1f8-5b4c-11e7-8845-7da74d777cae.jpg)