Re: How to specify Windows file path for gradlew "ofbiz --load-data file=foo/bar/FileNameHere.xml"?

[Aditya Sharma]

Hi,
I think relative path from the root should work.
Try
`gradlew "ofbiz --load-data file=/foo/bar/FileNameHere.xml"
adding "/" at the beginning will point file from the root directory i.e. C:
I guess.

It works for Ubuntu.

HTH

Thanks and Regards,

*Aditya Sharma* | Enterprise Software Engineer
HotWax Commerce  by HotWax Systems




On Thu, Dec 28, 2017 at 8:38 AM, Mike  wrote:

> Skip gradlew or ant by calling java directly.  No sense loading a bunch of
> junk prior to loading.  The below gets right down to business and just
> loads the XML.
>
> Here is an example, which may require tweaking for 16.x... The below is
> what I use for 13.04.
>
> /usr/lib/jvm/java-8-openjdk-amd64/jre/bin/java -Xms128M -Xmx2048M
> -XX:MaxPermSize=1024M -jar /opt/ofbiz/ofbiz.jar load-data delegator=default
> file=FILE2LOAD.xml
>
>
> On Wed, Dec 27, 2017 at 1:17 PM, Boyden, Timothy <
> tboy...@electroswitch.com>
> wrote:
>
> > How do you specify a Windows file path for command line command `gradlew
> > "ofbiz --load-data file=foo/bar/FileNameHere.xml"`?
> >
> > I put C:\SomePath\SomeFile.xml and the command errored with: Project
> > 'ofbiz --load-data file=C' not found in root project 'ofbiz'.
> >
> > Thanks,
> >
> > Tim
> >
>

Re: How to specify Windows file path for gradlew "ofbiz --load-data file=foo/bar/FileNameHere.xml"?

[Mike]

Skip gradlew or ant by calling java directly.  No sense loading a bunch of
junk prior to loading.  The below gets right down to business and just
loads the XML.

Here is an example, which may require tweaking for 16.x... The below is
what I use for 13.04.

/usr/lib/jvm/java-8-openjdk-amd64/jre/bin/java -Xms128M -Xmx2048M
-XX:MaxPermSize=1024M -jar /opt/ofbiz/ofbiz.jar load-data delegator=default
file=FILE2LOAD.xml


On Wed, Dec 27, 2017 at 1:17 PM, Boyden, Timothy 
wrote:

> How do you specify a Windows file path for command line command `gradlew
> "ofbiz --load-data file=foo/bar/FileNameHere.xml"`?
>
> I put C:\SomePath\SomeFile.xml and the command errored with: Project
> 'ofbiz --load-data file=C' not found in root project 'ofbiz'.
>
> Thanks,
>
> Tim
>

How to specify Windows file path for gradlew "ofbiz --load-data file=foo/bar/FileNameHere.xml"?

[Boyden, Timothy]

How do you specify a Windows file path for command line command `gradlew "ofbiz 
--load-data file=foo/bar/FileNameHere.xml"`?

I put C:\SomePath\SomeFile.xml and the command errored with: Project 'ofbiz 
--load-data file=C' not found in root project 'ofbiz'.

Thanks,

Tim

Fwd: MODERATE for user@ofbiz.apache.org

[Deepak Dixit]

-- Forwarded message --
From: "krishna8...@gmail.com" 
To: 
Cc:
Bcc:
Date: Wed, 27 Dec 2017 15:06:39 -
Subject: Re: [MODERATE EMAIL] Unable to access local ecommerce application
Hi Michael,

I don't see anything in the browser (in Firefox). I tried enabling the
debug. The request doesn't seem hitting the server. When i tried from IE, I
see 404 error.

"The webpage cannot be found

  HTTP 404"

The console log says that the server is listening on 8080.

Thanks,
Krish

On 2017-12-25 10:01, Michael Brohl  wrote:
> Hi Krish,
>
> there seems to be everything ok with the log, the request is served
> without errors.
>
> What did you see in your browser?
>
> Regards
>
> Michael
>
>
> Am 25.12.17 um 10:16 schrieb Deepak Dixit:
> > Hi Krish,
> >
> > Your email has been moderated, Please subscribe mailing list
> > http://ofbiz.apache.org/mailing-lists.html
> >
> > Thanks & Regards
> > --
> > Deepak Dixit
> > www.hotwaxsystems.com
> > www.hotwax.co
> >
> > -- Forwarded message --
> > From: "krishna8...@gmail.com" 
> > To: 
> > Cc:
> > Bcc:
> > Date: Mon, 25 Dec 2017 02:33:32 -
> > Subject: Unable to access local ecommerce application
> > Hi,
> >
> > I have been following the instruction under Demo and Setup guide under -
> > https://cwiki.apache.org/confluence/display/OFBIZ/Demo+
and+Test+Setup+Guide
> >
> > I was able to start OFBiz with embedded Tomcat (Step 4).
> >
> > But I am unable to access - http://127.0.0.1:8080/ecommerce/control/main
> > for the ecommerce application. The request is not being served.
> >
> > This is the log message in the console (Last few lines) -
> > 
> > 
---
> > 2017-12-25 02:27:31,162 |main |ContainerLoader
> >   |I| Started container birt-container
> > 2017-12-25 02:27:32,115 |OFBiz-JobPoller  |JobManager
> >|I| No crashed jobs to re-schedule
> > 2017-12-25 02:28:06,901 |http-nio-8080-exec-1 |ControlEventListener
> >|I| Creating session:  hidden sessionId by default.
> > 2017-12-25 02:28:06,917 |http-nio-8080-exec-1 |CategoryWorker
> >|I| [CategoryWorker.getCatalogTopCategory] Setting new top category:
> > CATALOG1
> > 2017-12-25 02:28:07,073 |http-nio-8080-exec-1 |ControlServlet
> >|T| [[[main(Domain:http://127.0.0.1)] Request Begun,
encoding=[UTF-8]-
> > total:0.0,since last(Begin):0.015]]
> > 2017-12-25 02:28:07,089 |http-nio-8080-exec-1 |VisitHandler
> >|I| Found visitorId [1] in cookie
> > 2017-12-25 02:28:07,104 |http-nio-8080-exec-1 |TransactionUtil
> >   |W| No transaction in place, so not suspending.
> > 2017-12-25 02:28:07,167 |http-nio-8080-exec-1 |SequenceUtil
> >|I| Got bank of sequenced IDs for [Visit]; curSeqId=10600,
> > maxSeqId=10700, bankSize=100
> > 2017-12-25 02:28:07,276 |http-nio-8080-exec-1 |ConfigXMLReader
> >   |I| controller loaded: 0.015s, 289 requests, 95 views in
> > file:/C:/apache-ofbiz/ofbiz/specialpurpose/ecommerce/
> > webapp/ecommerce/WEB-INF/controller.xml
> > 2017-12-25 02:28:07,339 |http-nio-8080-exec-1 |RequestHandler
> >|I| Sending redirect to: [https://127.0.0.1/ecommerce/control/main].
> > Hidden sessionId by default.
> > 2017-12-25 02:28:07,479 |http-nio-8080-exec-1 |ServerHitBin
> >|I| Visit delegatorName=default, ServerHitBin delegatorName=default
> > 2017-12-25 02:28:07,604 |http-nio-8080-exec-1 |ControlServlet
> >|T| [[[main(Domain:http://127.0.0.1)] Request Done- total:0.531,since
> > last([main(Domain:http...):0.531]]
> > 
> > 
---
> >
> > I could access
> > https://127.0.0.1:8443/webtools/control/main for the WebTools
application or
> > https://127.0.0.1:8443/catalog/control/main for the Catalog Manager
> > application.
> >
> > Can someone help me please?
> >
> > JAVA_HOME - C:\Program Files\Java\jdk1.8.0_131
> >
> > And it is the latest OFBiz - apache-ofbiz-16.11.03
> >
> > Thanks,
> > Krish
> >
>
>
>

Re: [MODERATE EMAIL] Unable to access local ecommerce application

[krishna8...@gmail.com]

Hi Deepak,

Thanks for your response. 

It is not external tomcat. Its embedded tomcat from the downloaded bundle.

As per the documentation (in the earlier provided link), 8080 is being used for 
e-commerce application.

What do you mean by "8443 port is missing". As per documentation, I see 8443 
being used for WebTools and CatalogManager.

Sorry, this is first time I am trying the Apache OFBiZ.

Thanks,
Krish

On 2017-12-26 06:24, Deepak Dixit  wrote: 
> Hi Krish,
> 
> It seems configuration issue. Please refer
> https://issues.apache.org/jira/browse/OFBIZ-6849
> You need to configure https as well on external tomcat.
> 
> {code}
> 2017-12-25 02:28:07,339 |http-nio-8080-exec-1 |RequestHandler
>   |I| Sending redirect to: [https://127.0.0.1/ecommerce/control/main].
> Hidden sessionId by default.
> {code}
> 
> RequestHandler redirecting it to https://127.0.0.1/ecommerce/control/main,
> 8443 port is missing.
> 
> Thanks & Regards
> --
> Deepak Dixit
> www.hotwaxsystems.com
> www.hotwax.co
> 
> On Mon, Dec 25, 2017 at 3:31 PM, Michael Brohl 
> wrote:
> 
> > Hi Krish,
> >
> > there seems to be everything ok with the log, the request is served
> > without errors.
> >
> > What did you see in your browser?
> >
> > Regards
> >
> > Michael
> >
> >
> > Am 25.12.17 um 10:16 schrieb Deepak Dixit:
> >
> > Hi Krish,
> >>
> >> Your email has been moderated, Please subscribe mailing list
> >> http://ofbiz.apache.org/mailing-lists.html
> >>
> >> Thanks & Regards
> >> --
> >> Deepak Dixit
> >> www.hotwaxsystems.com
> >> www.hotwax.co
> >>
> >> -- Forwarded message --
> >> From: "krishna8...@gmail.com" 
> >> To: 
> >> Cc:
> >> Bcc:
> >> Date: Mon, 25 Dec 2017 02:33:32 -
> >> Subject: Unable to access local ecommerce application
> >> Hi,
> >>
> >> I have been following the instruction under Demo and Setup guide under -
> >> https://cwiki.apache.org/confluence/display/OFBIZ/Demo+and+
> >> Test+Setup+Guide
> >>
> >> I was able to start OFBiz with embedded Tomcat (Step 4).
> >>
> >> But I am unable to access - http://127.0.0.1:8080/ecommerce/control/main
> >> for the ecommerce application. The request is not being served.
> >>
> >> This is the log message in the console (Last few lines) -
> >> 
> >> 
> >> ---
> >> 2017-12-25 02:27:31,162 |main |ContainerLoader
> >>   |I| Started container birt-container
> >> 2017-12-25 02:27:32,115 |OFBiz-JobPoller  |JobManager
> >>|I| No crashed jobs to re-schedule
> >> 2017-12-25 02:28:06,901 |http-nio-8080-exec-1 |ControlEventListener
> >>|I| Creating session:  hidden sessionId by default.
> >> 2017-12-25 02:28:06,917 |http-nio-8080-exec-1 |CategoryWorker
> >>|I| [CategoryWorker.getCatalogTopCategory] Setting new top category:
> >> CATALOG1
> >> 2017-12-25 02:28:07,073 |http-nio-8080-exec-1 |ControlServlet
> >>|T| [[[main(Domain:http://127.0.0.1)] Request Begun, encoding=[UTF-8]-
> >> total:0.0,since last(Begin):0.015]]
> >> 2017-12-25 02:28:07,089 |http-nio-8080-exec-1 |VisitHandler
> >>|I| Found visitorId [1] in cookie
> >> 2017-12-25 02:28:07,104 |http-nio-8080-exec-1 |TransactionUtil
> >>   |W| No transaction in place, so not suspending.
> >> 2017-12-25 02:28:07,167 |http-nio-8080-exec-1 |SequenceUtil
> >>|I| Got bank of sequenced IDs for [Visit]; curSeqId=10600,
> >> maxSeqId=10700, bankSize=100
> >> 2017-12-25 02:28:07,276 |http-nio-8080-exec-1 |ConfigXMLReader
> >>   |I| controller loaded: 0.015s, 289 requests, 95 views in
> >> file:/C:/apache-ofbiz/ofbiz/specialpurpose/ecommerce/
> >> webapp/ecommerce/WEB-INF/controller.xml
> >> 2017-12-25 02:28:07,339 |http-nio-8080-exec-1 |RequestHandler
> >>|I| Sending redirect to: [https://127.0.0.1/ecommerce/control/main].
> >> Hidden sessionId by default.
> >> 2017-12-25 02:28:07,479 |http-nio-8080-exec-1 |ServerHitBin
> >>|I| Visit delegatorName=default, ServerHitBin delegatorName=default
> >> 2017-12-25 02:28:07,604 |http-nio-8080-exec-1 |ControlServlet
> >>|T| [[[main(Domain:http://127.0.0.1)] Request Done- total:0.531,since
> >> last([main(Domain:http...):0.531]]
> >> 
> >> 
> >> ---
> >>
> >> I could access
> >> https://127.0.0.1:8443/webtools/control/main for the WebTools
> >> application or
> >> https://127.0.0.1:8443/catalog/control/main for the Catalog Manager
> >> application.
> >>
> >> Can someone help me please?
> >>
> >> JAVA_HOME - C:\Program Files\Java\jdk1.8.0_131
> >>
> >> And it is the latest OFBiz - apache-ofbiz-16.11.03
> >>
> >> Thanks,
> >> Krish
> >>
> >>
> >
> >
> 

RE: Data Load tips/tricks?

[Boyden, Timothy]

Thanks Taher and Nicolas. I'll check those out.

-Tim

-Original Message-
From: Taher Alkhateeb [mailto:slidingfilame...@gmail.com] 
Sent: Wednesday, December 27, 2017 7:18 AM
To: user@ofbiz.apache.org
Subject: Re: Data Load tips/tricks?

Hi Tim,

My recommendation is to avoid using the web tools altogether, and instead using 
the CLI. The exact documentation for how to import from XML files is specified 
in the README.md. This has the benefit of not only reducing resource usage but 
also allows for automation instead of doing this stuff manually by hand

On Wed, Dec 27, 2017 at 3:06 PM, Boyden, Timothy  
wrote:
> I started writing scripts this week to export data from our current ERP to 
> the OFBiz XML data formats. I have loaded about 25,000 of our 150,000 
> products through the Web Tools Import XML utility. Are there any tips to 
> improve load speed, such as temporarily disabling indexing or anything else 
> anyone has experience with?
>
> Thanks,
>
> Tim

Re: Data Load tips/tricks?

[Nicolas Malin]

Disable eeca on your delegator like :

    entity-group-reader="main" entity-eca-reader="main" 
*entity-eca-enabled="false"* distributed-cache-clear-enabled="false">


Nicolas
Le 27/12/2017 à 13:06, Boyden, Timothy a écrit :

I started writing scripts this week to export data from our current ERP to the 
OFBiz XML data formats. I have loaded about 25,000 of our 150,000 products 
through the Web Tools Import XML utility. Are there any tips to improve load 
speed, such as temporarily disabling indexing or anything else anyone has 
experience with?

Thanks,

Tim

Re: Data Load tips/tricks?

[Taher Alkhateeb]

Hi Tim,

My recommendation is to avoid using the web tools altogether, and
instead using the CLI. The exact documentation for how to import from
XML files is specified in the README.md. This has the benefit of not
only reducing resource usage but also allows for automation instead of
doing this stuff manually by hand

On Wed, Dec 27, 2017 at 3:06 PM, Boyden, Timothy
 wrote:
> I started writing scripts this week to export data from our current ERP to 
> the OFBiz XML data formats. I have loaded about 25,000 of our 150,000 
> products through the Web Tools Import XML utility. Are there any tips to 
> improve load speed, such as temporarily disabling indexing or anything else 
> anyone has experience with?
>
> Thanks,
>
> Tim

Data Load tips/tricks?

[Boyden, Timothy]

I started writing scripts this week to export data from our current ERP to the 
OFBiz XML data formats. I have loaded about 25,000 of our 150,000 products 
through the Web Tools Import XML utility. Are there any tips to improve load 
speed, such as temporarily disabling indexing or anything else anyone has 
experience with?

Thanks,

Tim