subject:"ofbizsetup"

Re: svn commit: r1862206 [2/2] - in /ofbiz/ofbiz-framework/trunk: ./ applications/commonext/webapp/ofbizsetup/WEB-INF/ applications/commonext/widget/ofbizsetup/ framework/entity/src/main/java/org/apac

2019-06-27 Thread Jacques Le Roux


:D

Well spotted Mathieu and the damn Server can't help me

Down again, https://ci.apache.org/projects/ofbiz/rat-output.html

Jacques

Le 27/06/2019 à 15:30, Mathieu Lirzin a écrit :

Hello Jacques,

jler...@apache.org writes:


Added: 
ofbiz/ofbiz-framework/trunk/framework/webtools/src/main/java/org/apache/ofbiz/webtools/EntityJsonEvents.java
URL: 
http://svn.apache.org/viewvc/ofbiz/ofbiz-framework/trunk/framework/webtools/src/main/java/org/apache/ofbiz/webtools/EntityJsonEvents.java?rev=1862206&view=auto
==
--- 
ofbiz/ofbiz-framework/trunk/framework/webtools/src/main/java/org/apache/ofbiz/webtools/EntityJsonEvents.java
 (added)
+++ 
ofbiz/ofbiz-framework/trunk/framework/webtools/src/main/java/org/apache/ofbiz/webtools/EntityJsonEvents.java
 Thu Jun 27 11:49:22 2019
@@ -0,0 +1,159 @@
+package org.apache.ofbiz.webtools;
+
+import org.apache.ofbiz.base.util.Debug;
+import org.apache.ofbiz.base.util.GeneralException;
+import org.apache.ofbiz.entity.Delegator;
+import org.apache.ofbiz.entity.GenericEntityException;
+import org.apache.ofbiz.entity.GenericValue;
+import org.apache.ofbiz.entity.condition.EntityExpr;
+import org.apache.ofbiz.entity.model.ModelEntity;
+import org.apache.ofbiz.entity.model.ModelReader;
+import org.apache.ofbiz.entity.transaction.TransactionUtil;
+import org.apache.ofbiz.entity.util.EntityListIterator;
+import org.apache.ofbiz.security.Security;
+
+import javax.servlet.ServletContext;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+import javax.servlet.http.HttpSession;
+import java.io.IOException;
+import java.io.OutputStream;
+import java.io.PrintWriter;
+import java.util.Collection;
+import java.util.Iterator;
+import java.util.TreeSet;
+
+public class EntityJsonEvents {

It seems that there is a copyright header missing here. Shame! ;-)

Re: svn commit: r1862206 [2/2] - in /ofbiz/ofbiz-framework/trunk: ./ applications/commonext/webapp/ofbizsetup/WEB-INF/ applications/commonext/widget/ofbizsetup/ framework/entity/src/main/java/org/apac

2019-06-27 Thread Mathieu Lirzin

Hello Jacques,

jler...@apache.org writes:

> Added: 
> ofbiz/ofbiz-framework/trunk/framework/webtools/src/main/java/org/apache/ofbiz/webtools/EntityJsonEvents.java
> URL: 
> http://svn.apache.org/viewvc/ofbiz/ofbiz-framework/trunk/framework/webtools/src/main/java/org/apache/ofbiz/webtools/EntityJsonEvents.java?rev=1862206&view=auto
> ==
> --- 
> ofbiz/ofbiz-framework/trunk/framework/webtools/src/main/java/org/apache/ofbiz/webtools/EntityJsonEvents.java
>  (added)
> +++ 
> ofbiz/ofbiz-framework/trunk/framework/webtools/src/main/java/org/apache/ofbiz/webtools/EntityJsonEvents.java
>  Thu Jun 27 11:49:22 2019
> @@ -0,0 +1,159 @@
> +package org.apache.ofbiz.webtools;
> +
> +import org.apache.ofbiz.base.util.Debug;
> +import org.apache.ofbiz.base.util.GeneralException;
> +import org.apache.ofbiz.entity.Delegator;
> +import org.apache.ofbiz.entity.GenericEntityException;
> +import org.apache.ofbiz.entity.GenericValue;
> +import org.apache.ofbiz.entity.condition.EntityExpr;
> +import org.apache.ofbiz.entity.model.ModelEntity;
> +import org.apache.ofbiz.entity.model.ModelReader;
> +import org.apache.ofbiz.entity.transaction.TransactionUtil;
> +import org.apache.ofbiz.entity.util.EntityListIterator;
> +import org.apache.ofbiz.security.Security;
> +
> +import javax.servlet.ServletContext;
> +import javax.servlet.http.HttpServletRequest;
> +import javax.servlet.http.HttpServletResponse;
> +import javax.servlet.http.HttpSession;
> +import java.io.IOException;
> +import java.io.OutputStream;
> +import java.io.PrintWriter;
> +import java.util.Collection;
> +import java.util.Iterator;
> +import java.util.TreeSet;
> +
> +public class EntityJsonEvents {

It seems that there is a copyright header missing here. Shame! ;-)

-- 
Mathieu Lirzin
GPG: F2A3 8D7E EB2B 6640 5761  070D 0ADE E100 9460 4D37

Re: ofbizsetup

2019-04-17 Thread Jacques Le Roux


At least this helps https://markmail.org/message/s6tl7gi3lra2hrea

You need to be in the setup component, which makes sense but got sidetracked by 
an error as explained at OFBIZ-10898

Le 17/04/2019 à 12:20, Jacques Le Roux a écrit :

Hi,

Should we not add an ofbizsetup menu to access it when only seed are loaded?

AFAIK, for now it seems we have only 
https://svn.apache.org/repos/asf/ofbiz/ofbiz-framework/trunk/applications/commonext/data/helpdata/HELP_SETUP.xml as deprecated info and when you try 
to access this help from a system with only seed it fails.


Jacques

ofbizsetup

2019-04-17 Thread Jacques Le Roux


Hi,

Should we not add an ofbizsetup menu to access it when only seed are loaded?

AFAIK, for now it seems we have only https://svn.apache.org/repos/asf/ofbiz/ofbiz-framework/trunk/applications/commonext/data/helpdata/HELP_SETUP.xml 
as deprecated info and when you try to access this help from a system with only seed it fails.


Jacques

[jira] [Closed] (OFBIZ-7797) Bug in OfbizSetup Create Customer Step

2016-07-15 Thread Jacques Le Roux (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-7797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jacques Le Roux closed OFBIZ-7797.
--
   Resolution: Fixed
Fix Version/s: Upcoming Branch

Thanks Derek,

Your proposed change is committed in trunk at revision: 1752810  
I did not backport because of tree conflicts


> Bug in OfbizSetup Create Customer Step
> --
>
> Key: OFBIZ-7797
> URL: https://issues.apache.org/jira/browse/OFBIZ-7797
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Release Branch 14.12, Trunk, Release Branch 15.12
> Environment: Windows 10
>Reporter: Derek Lew
>Assignee: Jacques Le Roux
> Fix For: Upcoming Branch
>
>
> When running the OFBiz Setup Application, the following exception was thrown.
> The Following Errors Occurred:
> ERROR: Could not complete the Create Customer 
> [file:/E:/OfBiz14.12/applications/commonext/script/org/ofbiz/setup/SetupEvents.xml#createOrganization]
>  process [problem invoking the [createCustomTimePeriod] service with the map 
> named [customTimePeriodCtx] containing [{fromDate=2016-01-01, periodNum=1, 
> userLogin=[GenericEntity:UserLogin][createdStamp,2016-07-13 
> 18:19:01.72(java.sql.Timestamp)][createdTxStamp,2016-07-13 
> 18:19:01.608(java.sql.Timestamp)][currentPassword,$SHA$wN7vvoeHKomFb$fhBdrGDkWvhPdxOX3PW8g1ucPP4(java.lang.String)][disabledDateTime,null()][enabled,Y(java.lang.String)][externalAuthId,null()][hasLoggedOut,null()][isSystem,null()][lastCurrencyUom,null()][lastLocale,null()][lastTimeZone,null()][lastUpdatedStamp,2016-07-13
>  18:19:52.017(java.sql.Timestamp)][lastUpdatedTxStamp,2016-07-13 
> 18:19:51.994(java.sql.Timestamp)][partyId,null()][passwordHint,null()][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Long)][userLdapDn,null()][userLoginId,admin(java.lang.String)],
>  isClosed=N, periodTypeId=FISCAL_YEAR, organizationPartyId=10006, 
> periodName=2016, locale=en_US, thruDate=2016-12-31}]: Type check failed for 
> field [createCustomTimePeriod.fromDate]; expected type is 
> [java.sql.Timestamp]; actual type is [java.sql.Date]Type check failed for 
> field [createCustomTimePeriod.thruDate]; expected type is 
> [java.sql.Timestamp]; actual type is [java.sql.Date]]
> • 
> In \applications\commonext\script\org\ofbiz\setup\SetupEvents.xml
> 250from-field="fromDateStamp" type="Date"/>
> 251value="${groovy:org.ofbiz.base.util.UtilDateTime.toSqlDate(endMonth ,endDate 
> , curYearString)}" type="Date"/>
> Need to change to:
> 250 from-field="fromDateStamp" type="java.sql.Timestamp"/>
> 251 value="${groovy:org.ofbiz.base.util.UtilDateTime.toSqlDate(endMonth ,endDate 
> , curYearString)}" type="java.sql.Timestamp"/>



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Assigned] (OFBIZ-7797) Bug in OfbizSetup Create Customer Step

2016-07-15 Thread Jacques Le Roux (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-7797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jacques Le Roux reassigned OFBIZ-7797:
--

Assignee: Jacques Le Roux

> Bug in OfbizSetup Create Customer Step
> --
>
> Key: OFBIZ-7797
> URL: https://issues.apache.org/jira/browse/OFBIZ-7797
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Release Branch 14.12, Trunk, Release Branch 15.12
> Environment: Windows 10
>Reporter: Derek Lew
>Assignee: Jacques Le Roux
>
> When running the OFBiz Setup Application, the following exception was thrown.
> The Following Errors Occurred:
> ERROR: Could not complete the Create Customer 
> [file:/E:/OfBiz14.12/applications/commonext/script/org/ofbiz/setup/SetupEvents.xml#createOrganization]
>  process [problem invoking the [createCustomTimePeriod] service with the map 
> named [customTimePeriodCtx] containing [{fromDate=2016-01-01, periodNum=1, 
> userLogin=[GenericEntity:UserLogin][createdStamp,2016-07-13 
> 18:19:01.72(java.sql.Timestamp)][createdTxStamp,2016-07-13 
> 18:19:01.608(java.sql.Timestamp)][currentPassword,$SHA$wN7vvoeHKomFb$fhBdrGDkWvhPdxOX3PW8g1ucPP4(java.lang.String)][disabledDateTime,null()][enabled,Y(java.lang.String)][externalAuthId,null()][hasLoggedOut,null()][isSystem,null()][lastCurrencyUom,null()][lastLocale,null()][lastTimeZone,null()][lastUpdatedStamp,2016-07-13
>  18:19:52.017(java.sql.Timestamp)][lastUpdatedTxStamp,2016-07-13 
> 18:19:51.994(java.sql.Timestamp)][partyId,null()][passwordHint,null()][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Long)][userLdapDn,null()][userLoginId,admin(java.lang.String)],
>  isClosed=N, periodTypeId=FISCAL_YEAR, organizationPartyId=10006, 
> periodName=2016, locale=en_US, thruDate=2016-12-31}]: Type check failed for 
> field [createCustomTimePeriod.fromDate]; expected type is 
> [java.sql.Timestamp]; actual type is [java.sql.Date]Type check failed for 
> field [createCustomTimePeriod.thruDate]; expected type is 
> [java.sql.Timestamp]; actual type is [java.sql.Date]]
> • 
> In \applications\commonext\script\org\ofbiz\setup\SetupEvents.xml
> 250from-field="fromDateStamp" type="Date"/>
> 251value="${groovy:org.ofbiz.base.util.UtilDateTime.toSqlDate(endMonth ,endDate 
> , curYearString)}" type="Date"/>
> Need to change to:
> 250 from-field="fromDateStamp" type="java.sql.Timestamp"/>
> 251 value="${groovy:org.ofbiz.base.util.UtilDateTime.toSqlDate(endMonth ,endDate 
> , curYearString)}" type="java.sql.Timestamp"/>



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (OFBIZ-7797) Bug in OfbizSetup Create Customer Step

2016-07-14 Thread Derek Lew (JIRA)

Derek Lew created OFBIZ-7797:


 Summary: Bug in OfbizSetup Create Customer Step
 Key: OFBIZ-7797
 URL: https://issues.apache.org/jira/browse/OFBIZ-7797
 Project: OFBiz
  Issue Type: Bug
  Components: commonext/setup
Affects Versions: Release Branch 15.12, Trunk, Release Branch 14.12
 Environment: Windows 10
Reporter: Derek Lew


When running the OFBiz Setup Application, the following exception was thrown.


The Following Errors Occurred:
ERROR: Could not complete the Create Customer 
[file:/E:/OfBiz14.12/applications/commonext/script/org/ofbiz/setup/SetupEvents.xml#createOrganization]
 process [problem invoking the [createCustomTimePeriod] service with the map 
named [customTimePeriodCtx] containing [{fromDate=2016-01-01, periodNum=1, 
userLogin=[GenericEntity:UserLogin][createdStamp,2016-07-13 
18:19:01.72(java.sql.Timestamp)][createdTxStamp,2016-07-13 
18:19:01.608(java.sql.Timestamp)][currentPassword,$SHA$wN7vvoeHKomFb$fhBdrGDkWvhPdxOX3PW8g1ucPP4(java.lang.String)][disabledDateTime,null()][enabled,Y(java.lang.String)][externalAuthId,null()][hasLoggedOut,null()][isSystem,null()][lastCurrencyUom,null()][lastLocale,null()][lastTimeZone,null()][lastUpdatedStamp,2016-07-13
 18:19:52.017(java.sql.Timestamp)][lastUpdatedTxStamp,2016-07-13 
18:19:51.994(java.sql.Timestamp)][partyId,null()][passwordHint,null()][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Long)][userLdapDn,null()][userLoginId,admin(java.lang.String)],
 isClosed=N, periodTypeId=FISCAL_YEAR, organizationPartyId=10006, 
periodName=2016, locale=en_US, thruDate=2016-12-31}]: Type check failed for 
field [createCustomTimePeriod.fromDate]; expected type is [java.sql.Timestamp]; 
actual type is [java.sql.Date]Type check failed for field 
[createCustomTimePeriod.thruDate]; expected type is [java.sql.Timestamp]; 
actual type is [java.sql.Date]]
•   

In \applications\commonext\script\org\ofbiz\setup\SetupEvents.xml

250   
251   

Need to change to:

250
251





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Closed] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2016-04-19 Thread Jacques Le Roux (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jacques Le Roux closed OFBIZ-5949.
--
   Resolution: Fixed
Fix Version/s: 13.07.04
   15.12.01
   14.12.01

Thanks Wai,

Your sightly modified patch is in
trunk r1740008
R15.12  r1740009
R14.12  r1740010
R13.07  r1740014

I simply used an UtilValidate.isNotEmpty() method in  EntitySaxReader class

I was initially reluctant to these changes because you can no longer load the 
content of the GlAccountData.xml and ProductStoreData.xml files, or the files 
themselves, using the import XML feature of webtools. But those files are 
specific to the setup component, so they should not be missed, they are 
supposed to be used in this context only.

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Fix For: 14.12.01, 15.12.01, 13.07.04
>
> Attachments: OFBIZ-5949.patch, OFBIZ-5949.patch, OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Comment Edited] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2016-04-19 Thread Jacques Le Roux (JIRA)

[
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14577793#comment-14577793
]

Jacques Le Roux edited comment on OFBIZ-5949 at 4/19/16 8:27 PM:
-

There seems to be a confusion about the

1) ofbizsetup feature
2) multitenancy consideration
3) ofbizsetup as it operates at this time

As I see it...

1) ofbizsetup feature

It is simply a feature that allows a new owner to configure his ofbiz with
initial data to start using his ofbiz. eg. 1st party and username, product,
catalog, categories, product store, and most importantly general ledger setup
for the owner organization.

This feature is friendly and convenient but not necessary as the owner can
always go to the appropriate components to configure the above data provided he
know where to go and what needs to be done.

By 'owner' I mean

a) The party that owns the ofbiz installation. ie
general.properties/mulitenant=N
b) The party that is the owner of the tenant that was assigned to him by a
multitenant ofbiz provider. ie general.properties/mulitenant=Y

2) multitenant consideration

As far as I'm aware, this is already multitenant aware. Ie. the owner logs in
to his ofbiz installation using a preconfigured username with admin
authorizations or logs in as a preconfigured tenant with associated tenantId
and username with admin authorizations for that tenant.

3) ofbizsetup as it operates at this time

It is for this point this jira report was created. As it exist, ofbizsetup is
using a temp file to load template data (eg. ProductStoreData.xml) into the
database. In a multitenant setup, this method is prone to data corruption if 2
tenants are loading their respective template data file.

I think the confusion was further aggrevated by the fact that there is also
another enhancement to the code. And that is the use of FlexibleStringExpander
to load template data files. ie note the the change in the placeholder in
template files...

eg. ProductStoreData.xml
PRODUCTSTOREID to ${productStoreId}
ORGPARTYID to ${orgPartyId}
etc.

As an additional comment, I'm not familiar with the discussion and history of
ofbizsetup that Pierre Smits was referring to. I think that is more related to
the infrastructure of ofbiz. This jira was not about that. This jira is
simply a bug fix + enhancement.

was (Author: wt):
There seems to be a confusion about the

1) ofbizsetup feature
2) multitenancy consideration
3) ofbizsetup as it operates at this time

As I see it...

1) ofbizsetup feature

This feature is friendly and convenient but not necessary as the owner can
always go to the appropriate components to configure the above data provided he
know where to go and what needs to be done.

By 'owner' I mean

2) multitenant consideration

3) ofbizsetup as it operates at this time

eg. ProductStoreData.xml
PRODUCTSTOREID to ${productStoreId}
ORGPARTYID to ${orgPartyId}
etc.

> ofbizsetup create product store cause exception, remove use of temp file to
> load entity data
>
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBI

[jira] [Comment Edited] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2016-04-19 Thread Jacques Le Roux (JIRA)

[
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14577793#comment-14577793
]

Jacques Le Roux edited comment on OFBIZ-5949 at 4/19/16 8:28 PM:
-

There seems to be a confusion about the

1) ofbizsetup feature
2) multitenancy consideration
3) ofbizsetup as it operates at this time

As I see it...

1) ofbizsetup feature

This feature is friendly and convenient but not necessary as the owner can
always go to the appropriate components to configure the above data provided he
know where to go and what needs to be done.

By 'owner' I mean

2) multitenant consideration

3) ofbizsetup as it operates at this time

eg. ProductStoreData.xml
{code}
PRODUCTSTOREID to ${productStoreId}
ORGPARTYID to ${orgPartyId}
{code}
etc.

was (Author: wt):
There seems to be a confusion about the

1) ofbizsetup feature
2) multitenancy consideration
3) ofbizsetup as it operates at this time

As I see it...

1) ofbizsetup feature

This feature is friendly and convenient but not necessary as the owner can
always go to the appropriate components to configure the above data provided he
know where to go and what needs to be done.

By 'owner' I mean

2) multitenant consideration

3) ofbizsetup as it operates at this time

eg. ProductStoreData.xml
PRODUCTSTOREID to ${productStoreId}
ORGPARTYID to ${orgPartyId}
etc.

> ofbizsetup create product store cause exception, remove use of temp file to
> load entity data
>
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBI

[jira] [Assigned] (OFBIZ-6434) In ofbizsetup, create product category causes exception

2015-11-21 Thread Mridul Pathak (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-6434?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mridul Pathak reassigned OFBIZ-6434:


Assignee: Mridul Pathak

> In ofbizsetup, create product category causes exception
> ---
>
> Key: OFBIZ-6434
> URL: https://issues.apache.org/jira/browse/OFBIZ-6434
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>    Assignee: Mridul Pathak
>
> in ofbizsetup. create 1st productCategory gives exception.
> Seems that ofbiz tries to auto create a promotions category but the resulting 
> productCategoryId is too long for for the database field defined as a 
> varchar(20).
> My database is currently configured to use utf8.
> ...console output...
> INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, 
> PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, 
> DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, 
> LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, 
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES 
> ('MYCOCLG1_ID_PROMOTIONS', 'CATALOG_CATEGORY', NULL, 'MYCOCLG1_ID 
> Promotions', NULL, NULL, NULL, NULL, NULL, 
> 'component://ecommerce/widget/CatalogScreens.xml#categorydetailmatrix', NULL, 
> '2015-05-29 13:03:32.74 -04:00:00', '2015-05-29 13:03:32.587000 
> -04:00:00', '2015-05-29 13:03:32.74 -04:00:00', '2015-05-29 
> 13:03:32.587000 -04:00:00')
> 2015-05-29 13:03:32,743 |ttp-bio-8443-exec-10 |GenericDelegator  
> |E| Failure in create operation for entity [ProductCategory]: 
> org.ofbiz.entity.GenericEntityException: Error while inserting: 
> [GenericEntity:ProductCategory][categoryName,MYCOCLG1_ID 
> Promotions(java.lang.String)][createdStamp,2015-05-29 
> 13:03:32.74(java.sql.Timestamp)][createdTxStamp,2015-05-29 
> 13:03:32.587(java.sql.Timestamp)][detailScreen,component://ecommerce/widget/CatalogScreens.xml#categorydetailmatrix(java.lang.String)][lastUpdatedStamp,2015-05-29
>  13:03:32.74(java.sql.Timestamp)][lastUpdatedTxStamp,2015-05-29 
> 13:03:32.587(java.sql.Timestamp)][productCategoryId,MYCOCLG1_ID_PROMOTIONS(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)]
>  (SQL Exception while executing the following:INSERT INTO 
> public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, 
> PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, 
> CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, 
> SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, 
> CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 
> (ERROR: value too long for type character varying(20)))



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-6434) In ofbizsetup, create product category causes exception

2015-11-21 Thread Mridul Pathak (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-6434?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15020441#comment-15020441
 ] 

Mridul Pathak commented on OFBIZ-6434:
--

ofbizsetup component creates the necessary categories when catalog setup is 
done, it creates browse root category which is required for the ecommerce and 
also the base promotion category. I think the current functionality is working 
as expected, the only constraint I see here is that prodCatalogId should be 
small enough to support the additional category creation.

That pops up an obvious question that why are we explicitly creating alphabetic 
IDs for these additional browse root and promotion categories when we could 
simply us OFBiz generated sequence IDs?

> In ofbizsetup, create product category causes exception
> ---
>
> Key: OFBIZ-6434
> URL: https://issues.apache.org/jira/browse/OFBIZ-6434
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>    Reporter: Wai
>
> in ofbizsetup. create 1st productCategory gives exception.
> Seems that ofbiz tries to auto create a promotions category but the resulting 
> productCategoryId is too long for for the database field defined as a 
> varchar(20).
> My database is currently configured to use utf8.
> ...console output...
> INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, 
> PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, 
> DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, 
> LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, 
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES 
> ('MYCOCLG1_ID_PROMOTIONS', 'CATALOG_CATEGORY', NULL, 'MYCOCLG1_ID 
> Promotions', NULL, NULL, NULL, NULL, NULL, 
> 'component://ecommerce/widget/CatalogScreens.xml#categorydetailmatrix', NULL, 
> '2015-05-29 13:03:32.74 -04:00:00', '2015-05-29 13:03:32.587000 
> -04:00:00', '2015-05-29 13:03:32.74 -04:00:00', '2015-05-29 
> 13:03:32.587000 -04:00:00')
> 2015-05-29 13:03:32,743 |ttp-bio-8443-exec-10 |GenericDelegator  
> |E| Failure in create operation for entity [ProductCategory]: 
> org.ofbiz.entity.GenericEntityException: Error while inserting: 
> [GenericEntity:ProductCategory][categoryName,MYCOCLG1_ID 
> Promotions(java.lang.String)][createdStamp,2015-05-29 
> 13:03:32.74(java.sql.Timestamp)][createdTxStamp,2015-05-29 
> 13:03:32.587(java.sql.Timestamp)][detailScreen,component://ecommerce/widget/CatalogScreens.xml#categorydetailmatrix(java.lang.String)][lastUpdatedStamp,2015-05-29
>  13:03:32.74(java.sql.Timestamp)][lastUpdatedTxStamp,2015-05-29 
> 13:03:32.587(java.sql.Timestamp)][productCategoryId,MYCOCLG1_ID_PROMOTIONS(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)]
>  (SQL Exception while executing the following:INSERT INTO 
> public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, 
> PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, 
> CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, 
> SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, 
> CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 
> (ERROR: value too long for type character varying(20)))



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-06-08 Thread Wai (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14577793#comment-14577793
 ] 

Wai commented on OFBIZ-5949:


There seems to be a confusion about the 

1) ofbizsetup feature
2) multitenancy consideration
3) ofbizsetup as it operates at this time

As I see it...

1) ofbizsetup feature

It is simply a feature that allows a new owner to configure his ofbiz with 
initial data to start using his ofbiz. eg. 1st party and username, product, 
catalog, categories, product store, and most importantly general ledger setup 
for the owner organization.

This feature is friendly and convenient but not necessary as the owner can 
always go to the appropriate components to configure the above data provided he 
know where to go and what needs to be done.

By 'owner' I mean

a) The party that owns the ofbiz installation. ie 
general.properties/mulitenant=N
b) The party that is the owner of the tenant that was assigned to him by a 
multitenant ofbiz provider. ie general.properties/mulitenant=Y

2) multitenant consideration

As far as I'm aware, this is already multitenant aware. Ie. the owner logs in 
to his ofbiz installation using a preconfigured username with admin 
authorizations or logs in as a preconfigured tenant with associated tenantId 
and username with admin authorizations for that tenant.

3) ofbizsetup as it operates at this time

It is for this point this jira report was created. As it exist, ofbizsetup is 
using a temp file to load template data (eg. ProductStoreData.xml) into the 
database.  In a multitenant setup, this method is prone to data corruption if 2 
tenants are loading their respective template data file.

I think the confusion was further aggrevated by the fact that there is also 
another enhancement to the code.  And that is the use of FlexibleStringExpander 
to load template data files. ie note the the change in the placeholder in 
template files...

eg. ProductStoreData.xml
PRODUCTSTOREID to ${productStoreId}
ORGPARTYID to ${orgPartyId}
etc.


As an additional comment, I'm not familiar with the discussion and history of 
ofbizsetup that Pierre Smits was referring to.  I think that is more related to 
the infrastructure of ofbiz.  This jira was not about that.  This jira is 
simply a bug fix + enhancement.

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch, OFBIZ-5949.patch, OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-06-08 Thread Jacques Le Roux (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14577129#comment-14577129
 ] 

Jacques Le Roux commented on OFBIZ-5949:


{quote}
Maybe the ofbiz-setup application was indeed intended as a means to provide 
some kind of multi-tenancy functionality, but we have since (and maybe also 
before that implementation) put more effort in place to get a better separation 
of tenant functionality.
{quote}
Actually no, the setup component was introduced before the tenant feature.

{quote}
The ofbiz-setup application delivers a specific feature set for a select group 
of users, and should - in my opinion - be disentangled from commonext and move 
to the special purpose stack.
{quote}

Pierre, I agree, this is related 
https://issues.apache.org/jira/browse/OFBIZ-3329?focusedCommentId=14151214 
pending work at OFBIZ-3329...

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch, OFBIZ-5949.patch, OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Comment Edited] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-06-08 Thread Pierre Smits (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14577057#comment-14577057
 ] 

Pierre Smits edited comment on OFBIZ-5949 at 6/8/15 11:39 AM:
--

Maybe the ofbiz-setup application was indeed intended as a means to provide 
some kind of multi-tenancy functionality, but we have since (and maybe also 
before that implementation) put more effort in place to get a better separation 
of tenant functionality.

On top of that, as far as I can assess the mail threads, the original intention 
of the commonext component was to provide a means to implementers to extend 
functionality in the common component (in framework). 

The ofbiz-setup application delivers a specific feature set for a select group 
of users, and should - in my opinion - be disentangled from commonext and move 
to the special purpose stack.


was (Author: pfm.smits):
Maybe the ofbiz-setup application was indeed intended as a means to provide 
some kind of multi-tenancy functionality, but we have since (and maybe also 
before that implementation) put more effort in place to get a better separation 
of tenant...

On top of that, as far as I can assess the mail threads, the original intention 
of the commonext component was to provide a means to implementers to extend 
functionality in the common component (in framework). 

The ofbiz-setup application delivers a specific feature set for a select group 
of users, and should - in my opinion - be disentangled from commonext and move 
to the special purpose stack.

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch, OFBIZ-5949.patch, OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-06-08 Thread Pierre Smits (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14577057#comment-14577057
 ] 

Pierre Smits commented on OFBIZ-5949:
-

Maybe the ofbiz-setup application was indeed intended as a means to provide 
some kind of multi-tenancy functionality, but we have since (and maybe also 
before that implementation) put more effort in place to get a better separation 
of tenant...

On top of that, as far as I can assess the mail threads, the original intention 
of the commonext component was to provide a means to implementers to extend 
functionality in the common component (in framework). 

The ofbiz-setup application delivers a specific feature set for a select group 
of users, and should - in my opinion - be disentangled from commonext and move 
to the special purpose stack.

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch, OFBIZ-5949.patch, OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-06-08 Thread Jacques Le Roux (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14577032#comment-14577032
 ] 

Jacques Le Roux commented on OFBIZ-5949:


Hi Wai,

I'm still undecided on this. Though I was part of the project which introduced 
the multi-tenant feature in OFBiz in Winter 2010, I have not used this feature 
much since. I must say I'd appreciate others opinions and even more tests...

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch, OFBIZ-5949.patch, OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (OFBIZ-6434) In ofbizsetup, create product category causes exception

2015-05-30 Thread Wai (JIRA)

Wai created OFBIZ-6434:
--

 Summary: In ofbizsetup, create product category causes exception
 Key: OFBIZ-6434
 URL: https://issues.apache.org/jira/browse/OFBIZ-6434
 Project: OFBiz
  Issue Type: Bug
  Components: commonext/setup
Affects Versions: Trunk
Reporter: Wai


in ofbizsetup. create 1st productCategory gives exception.
Seems that ofbiz tries to auto create a promotions category but the resulting 
productCategoryId is too long for for the database field defined as a 
varchar(20).
My database is currently configured to use utf8.

...console output...
INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, 
PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, 
DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, 
LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, 
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES 
('MYCOCLG1_ID_PROMOTIONS', 'CATALOG_CATEGORY', NULL, 'MYCOCLG1_ID Promotions', 
NULL, NULL, NULL, NULL, NULL, 
'component://ecommerce/widget/CatalogScreens.xml#categorydetailmatrix', NULL, 
'2015-05-29 13:03:32.74 -04:00:00', '2015-05-29 13:03:32.587000 -04:00:00', 
'2015-05-29 13:03:32.74 -04:00:00', '2015-05-29 13:03:32.587000 -04:00:00')
2015-05-29 13:03:32,743 |ttp-bio-8443-exec-10 |GenericDelegator  
|E| Failure in create operation for entity [ProductCategory]: 
org.ofbiz.entity.GenericEntityException: Error while inserting: 
[GenericEntity:ProductCategory][categoryName,MYCOCLG1_ID 
Promotions(java.lang.String)][createdStamp,2015-05-29 
13:03:32.74(java.sql.Timestamp)][createdTxStamp,2015-05-29 
13:03:32.587(java.sql.Timestamp)][detailScreen,component://ecommerce/widget/CatalogScreens.xml#categorydetailmatrix(java.lang.String)][lastUpdatedStamp,2015-05-29
 13:03:32.74(java.sql.Timestamp)][lastUpdatedTxStamp,2015-05-29 
13:03:32.587(java.sql.Timestamp)][productCategoryId,MYCOCLG1_ID_PROMOTIONS(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)]
 (SQL Exception while executing the following:INSERT INTO 
public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, 
PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, 
CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, 
SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, 
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: 
value too long for type character varying(20)))



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-05-29 Thread Wai (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Wai updated OFBIZ-5949:
---
Attachment: OFBIZ-5949.patch

OFBIZ-6216 solved the foreign key violation issue related to NEXT_DAY_AIR in 
the template file ProductStoreData.xml.
Now this patch contains only the modifications related to a multitenant 
friendly way of loading data from a template file (eg. ProductStoreData.xml).

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch, OFBIZ-5949.patch, OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-05-27 Thread Jacques Le Roux (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14561810#comment-14561810
 ] 

Jacques Le Roux commented on OFBIZ-5949:


Could you please have a look at OFBIZ-6216 and give me your feedback, thanks!

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch, OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-04-08 Thread Wai (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14485742#comment-14485742
 ] 

Wai commented on OFBIZ-5949:


hello again.
Could someone commit the changes and close this issue.
Thanks

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch, OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-03-18 Thread Wai (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Wai updated OFBIZ-5949:
---
Attachment: OFBIZ-5949.patch

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch, OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-03-18 Thread Jacques Le Roux (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14367767#comment-14367767
 ] 

Jacques Le Roux commented on OFBIZ-5949:


Yes, the problem with "philosophy" is you might keep chunks of code which have 
no longer any interest nor relation with a new context. It's sometimes 
confusing and counter productive. So it depends on cases. I believe here we can 
remove.

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Comment Edited] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-03-18 Thread Pierre Smits (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14367739#comment-14367739
 ] 

Pierre Smits edited comment on OFBIZ-5949 at 3/18/15 7:34 PM:
--

Luckily we have version control management, so we can always retrieve code from 
a previous commit.


was (Author: pfm.smits):
Luckily we version control management, so we can always retrieve code from a 
previous commit.

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-03-18 Thread Pierre Smits (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14367739#comment-14367739
 ] 

Pierre Smits commented on OFBIZ-5949:
-

Luckily we version control management, so we can always retrieve code from a 
previous commit.

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-03-18 Thread Wai (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14367706#comment-14367706
 ] 

Wai commented on OFBIZ-5949:


The importTempDataFile method was commented out and labeled 'obsoleted'. I did 
not remove it because I or someone else might be able to reference the code for 
some other purpose later on.  I was following David Jones' philosophy of not 
removing code even if it is not used. If you want it removed, I could do so and 
provide another patch.

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-03-17 Thread Jacques Le Roux (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14366061#comment-14366061
 ] 

Jacques Le Roux commented on OFBIZ-5949:


Hi Wai,

If this is a bug fix, why not completely remove importTempDataFile?

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (OFBIZ-6167) Ensure that appropriate fields of the OfbizSetup process in commonext register as SystemProperty entity records

2015-03-16 Thread Pierre Smits (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-6167?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pierre Smits updated OFBIZ-6167:

Affects Version/s: Trunk

> Ensure that appropriate fields of the OfbizSetup process in commonext 
> register as SystemProperty entity records
> ---
>
> Key: OFBIZ-6167
> URL: https://issues.apache.org/jira/browse/OFBIZ-6167
> Project: OFBiz
>  Issue Type: Sub-task
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Pierre Smits
>  Labels: configuration, multi-tenant, setup
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (OFBIZ-6167) Ensure that appropriate fields of the OfbizSetup process in commonext register as SystemProperty entity records

2015-03-16 Thread Pierre Smits (JIRA)

Pierre Smits created OFBIZ-6167:
---

 Summary: Ensure that appropriate fields of the OfbizSetup process 
in commonext register as SystemProperty entity records
 Key: OFBIZ-6167
 URL: https://issues.apache.org/jira/browse/OFBIZ-6167
 Project: OFBiz
  Issue Type: Sub-task
  Components: commonext/setup
Reporter: Pierre Smits






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-03-15 Thread Wai (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14362719#comment-14362719
 ] 

Wai commented on OFBIZ-5949:


Just giving a little nudge to see if anyone is interested in committing this 
patch.

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-03-06 Thread Pierre Smits (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pierre Smits updated OFBIZ-5949:

Component/s: (was: framework)
 commonext/setup

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Comment Edited] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-03-05 Thread Wai (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14350018#comment-14350018
 ] 

Wai edited comment on OFBIZ-5949 at 3/6/15 7:13 AM:


To answer your previous question, "...OOTB there are no "NEXT_DAY_AIR"..."
You are correct.  That data is not loaded via any of the readers 
(seed,seed-initial,ext,...).
The "NEXT_DAY_AIR" data is located in 
applications/commonext/data/ShippingData.xml
The contents of this file is loaded during the creation of the product store 
when the simple method 
commonext/script/org/ofbiz/setup/SetupEvents.xml#createProductStoreWithDefaultSetting
 is called.

That explains why you would not be able to locate the corresponding entries 
containing "NEXT_DAY_AIR" during a fresh install. But once you create your 
first product store. The data in question will be initialized in the database.

commonext/data/ShippingData.xml also contains the initialization data for 
CarrierShipmentMethod entity.


was (Author: wt):
To answer your previous question, "...OOTB there are no "NEXT_DAY_AIR"..."
You are correct.  That data is not loaded via any of the readers 
(seed,seed-initial,ext,...).
The "NEXT_DAY_AIR" data is located in 
applications/commonext/data/ShippingData.xml
The contents of this file is loaded during the creation of the product store 
when the simple method 
commonext/script/org/ofbiz/setup/SetupEvents.xml#createProductStoreWithDefaultSetting
 is called.

That explains why you would not be able to locate the corresponding entries 
containing "NEXT_DAY_AIR" during a fresh install. But once you create your 
first product store. The data in question will be initialized in the database.

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: framework
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Comment Edited] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-03-05 Thread Wai (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14349700#comment-14349700
 ] 

Wai edited comment on OFBIZ-5949 at 3/6/15 7:12 AM:


There are 2 changes in this patch.

Modification#1: 

An enhancement to use FlexibleStringExpander as a means to modify the 
placeholders in applications/commonext/data/GlAccountData.xml.

replacing all occurrence of ORGPARTYID with ${orgPartyId}
replacing all occurrence of PRODUCTSTOREID with ${productStoreId}

This change alone constitutes the large patch file size.

Modification#2:

When creating the product store in ofbizsetup, a foreign key violation was 
encountered.  I narrowed it down to line#69 of 
applications/commonext/data/ProductStoreData.xml.
ShipmentCostEstimate.shipmentMethodTypeId=NEXT_DAY refers to an entry in 
ShipmentMethodType that does not exist.  Hence, the foreign key violation.
I simply modified the entry's ShipmentCostEstimate.shipmentMethodTypeId from 
NEXT_DAY (which does not exist) to NEXT_DAY_AIR (which does) to resolve the 
foreign key violation.

As mentioned in the previous comment, I do not know if this change in the data 
is sensical, and I ask the community to offer some insight.



was (Author: wt):
There are 2 changes in this patch.

Modification#1: 

An enhancement to use FlexibleStringExpander as a means to modify the 
placeholders in applications/commonext/data/GlAccountData.xml.

replacing all occurrence of ORGPARTYID with ${orgPartyId}
replacing all occurrence of PRODUCTSTOREID with ${productStoreId}

This change alone constitutes the large patch file size.

Modification#2:

When creating the product store in ofbizsetup, a foreign key violation was 
encountered.  I narrowed it down to line#69 of 
applications/commonext/data/ProductStoreData.xml.
ShipmentCostEstimate.shipmentMethodTypeId=NEXT_DAY refers to an entry in 
ShipmentMethodType that does not exist.  Hence, the foreign key violation.
I simply modified the entry's ShipmentCostEstimate.shipmentMethodTypeId from 
NEXT_DAY (which does not exist) to NEXT_DAY_AIR (which does) to resolve the 
foreign key violation.

As mentioned in the previous comment, I do not know if this change in the data 
is sensical, and I ask the community to offer some insight.

You can make this change to the data, or you can add an entry in 
ShipmentMethodType with a primary key of NEXT_DAY.

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: framework
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-03-05 Thread Wai (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14350018#comment-14350018
 ] 

Wai commented on OFBIZ-5949:


To answer your previous question, "...OOTB there are no "NEXT_DAY_AIR"..."
You are correct.  That data is not loaded via any of the readers 
(seed,seed-initial,ext,...).
The "NEXT_DAY_AIR" data is located in 
applications/commonext/data/ShippingData.xml
The contents of this file is loaded during the creation of the product store 
when the simple method 
commonext/script/org/ofbiz/setup/SetupEvents.xml#createProductStoreWithDefaultSetting
 is called.

That explains why you would not be able to locate the corresponding entries 
containing "NEXT_DAY_AIR" during a fresh install. But once you create your 
first product store. The data in question will be initialized in the database.

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: framework
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-03-05 Thread Wai (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14349700#comment-14349700
 ] 

Wai commented on OFBIZ-5949:


There are 2 changes in this patch.

Modification#1: 

An enhancement to use FlexibleStringExpander as a means to modify the 
placeholders in applications/commonext/data/GlAccountData.xml.

replacing all occurrence of ORGPARTYID with ${orgPartyId}
replacing all occurrence of PRODUCTSTOREID with ${productStoreId}

This change alone constitutes the large patch file size.

Modification#2:

When creating the product store in ofbizsetup, a foreign key violation was 
encountered.  I narrowed it down to line#69 of 
applications/commonext/data/ProductStoreData.xml.
ShipmentCostEstimate.shipmentMethodTypeId=NEXT_DAY refers to an entry in 
ShipmentMethodType that does not exist.  Hence, the foreign key violation.
I simply modified the entry's ShipmentCostEstimate.shipmentMethodTypeId from 
NEXT_DAY (which does not exist) to NEXT_DAY_AIR (which does) to resolve the 
foreign key violation.

As mentioned in the previous comment, I do not know if this change in the data 
is sensical, and I ask the community to offer some insight.

You can make this change to the data, or you can add an entry in 
ShipmentMethodType with a primary key of NEXT_DAY.

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: framework
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Comment Edited] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-03-05 Thread Jacques Le Roux (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14349488#comment-14349488
 ] 

Jacques Le Roux edited comment on OFBIZ-5949 at 3/5/15 9:32 PM:


Wai,

Do you say that there is only 1 modification in your patch? Because your patch 
is 64 KB and contains "tons" of modifications. 
Also your change is about 
{quote}
replacing shipmentMethodTypeId="NEXT_DAY" to shipmentMethodTypeId="NEXT_DAY_AIR"
{quote}
But OOTB there are no "NEXT_DAY_AIR shipmentMethodTypeId, only "NEXT_DAY" and 
"AIR" shipmentMethodTypeIds

Could you explain more please? From where does come this combination? I don't 
clearly understand your statement:
{quote}
This is required because the original data references a nonexistent entry in 
CarrierShipmentMethod and causes a foreign key violation
{quote}
"NEXT_DAY" is not a carrier (nor "AIR" BTW). A carrier must be a party with a 
valid partyId.



was (Author: jacques.le.roux):
Wai,

Do you say that there is only 1 modification in your patch? Because your patch 
is 64 KB and contains "tons" of modifications. 
Also your change is about 
{quote}
replacing shipmentMethodTypeId="NEXT_DAY" to shipmentMethodTypeId="NEXT_DAY_AIR"
{quote}
But OOTB there are no "NEXT_DAY_AIR shipmentMethodTypeId, only "NEXT_DAY" and 
"AIR" shipmentMethodTypeId

Could you explain more please? From where does come this combination? I don't 
clearly understand your statement:
{quote}
This is required because the original data references a nonexistent entry in 
CarrierShipmentMethod and causes a foreign key violation
{quote}
"NEXT_DAY" is not a carrier (nor "AIR" BTW). A carrier must be a party with a 
valid partyId.


> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: framework
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-03-05 Thread Jacques Le Roux (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14349488#comment-14349488
 ] 

Jacques Le Roux commented on OFBIZ-5949:


Wai,

Do you say that there is only 1 modification in your patch? Because your patch 
is 64 KB and contains "tons" of modifications. 
Also your change is about 
{quote}
replacing shipmentMethodTypeId="NEXT_DAY" to shipmentMethodTypeId="NEXT_DAY_AIR"
{quote}
But OOTB there are no "NEXT_DAY_AIR shipmentMethodTypeId, only "NEXT_DAY" and 
"AIR" shipmentMethodTypeId

Could you explain more please? From where does come this combination? I don't 
clearly understand your statement:
{quote}
This is required because the original data references a nonexistent entry in 
CarrierShipmentMethod and causes a foreign key violation
{quote}
"NEXT_DAY" is not a carrier (nor "AIR" BTW). A carrier must be a party with a 
valid partyId.


> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: framework
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Assigned] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-03-05 Thread Jacques Le Roux (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jacques Le Roux reassigned OFBIZ-5949:
--

Assignee: Jacques Le Roux

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: framework
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
> Attachments: OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-03-05 Thread Wai (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14349251#comment-14349251
 ] 

Wai commented on OFBIZ-5949:


Can someone take a look at this improvement and decide to commit it?
Thanks

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: framework
>Affects Versions: Trunk
>Reporter: Wai
> Attachments: OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Reopened] (OFBIZ-6054) ofbizsetup cannot create first customer. problem with state/province dropdown

2015-03-05 Thread Wai (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-6054?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Wai reopened OFBIZ-6054:


I should have been more clear about the reported issue.
The database had been loaded with seed ,and seed-initial data.
in https://localhost:8443/ofbizsetup
I had already created the following:
party for the enterprise
associated facility
associated product store
associated website

The issue surfaces when I'm trying to create the 1st customer.
In this form, the province/state dropdown was not auto-filled when the country 
dropdown is used.

On further investigation, the origin of the issue comes from the initial data 
for configuring the javascript, in 
common/webcommon/includes/setDependentDropdownValuesJs.ftl, to be used with the 
forms NewCustomer and NewUser.  Where NewCustomer subclasses NewUser.

Since the dropdowns in question are defined in NewUser (which uses a difference 
prefix label for its controls then NewCustomer), the configured data for the 
javascript code failed to identify the appropriate dropdown controls in NewUser.


> ofbizsetup cannot create first customer. problem with state/province dropdown
> -
>
> Key: OFBIZ-6054
> URL: https://issues.apache.org/jira/browse/OFBIZ-6054
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
>
> -use empty database.
> -go to url. https://localhost:8443/ofbizsetup/control/firstcustomer
> notice that when entering the postal address, the state/province dropdown is 
> empty and remains empty regardless of selection of the country dropdown.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Closed] (OFBIZ-6054) ofbizsetup cannot create first customer. problem with state/province dropdown

2015-03-05 Thread Jacques Le Roux (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-6054?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jacques Le Roux closed OFBIZ-6054.
--
Resolution: Invalid
  Assignee: Jacques Le Roux

> ofbizsetup cannot create first customer. problem with state/province dropdown
> -
>
> Key: OFBIZ-6054
> URL: https://issues.apache.org/jira/browse/OFBIZ-6054
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>Assignee: Jacques Le Roux
>
> -use empty database.
> -go to url. https://localhost:8443/ofbizsetup/control/firstcustomer
> notice that when entering the postal address, the state/province dropdown is 
> empty and remains empty regardless of selection of the country dropdown.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-6054) ofbizsetup cannot create first customer. problem with state/province dropdown

2015-03-04 Thread Jacques Le Roux (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-6054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14348338#comment-14348338
 ] 

Jacques Le Roux commented on OFBIZ-6054:


Should we not close as invalid?

> ofbizsetup cannot create first customer. problem with state/province dropdown
> -
>
> Key: OFBIZ-6054
> URL: https://issues.apache.org/jira/browse/OFBIZ-6054
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>
> -use empty database.
> -go to url. https://localhost:8443/ofbizsetup/control/firstcustomer
> notice that when entering the postal address, the state/province dropdown is 
> empty and remains empty regardless of selection of the country dropdown.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-6054) ofbizsetup cannot create first customer. problem with state/province dropdown

2015-03-04 Thread Pierre Smits (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-6054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14347200#comment-14347200
 ] 

Pierre Smits commented on OFBIZ-6054:
-

That is what you get when working with an empty database. In order to have 
certain functions to work properly at least some setup data (seed, init, ext) 
is required.

> ofbizsetup cannot create first customer. problem with state/province dropdown
> -
>
> Key: OFBIZ-6054
> URL: https://issues.apache.org/jira/browse/OFBIZ-6054
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>
> -use empty database.
> -go to url. https://localhost:8443/ofbizsetup/control/firstcustomer
> notice that when entering the postal address, the state/province dropdown is 
> empty and remains empty regardless of selection of the country dropdown.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (OFBIZ-6054) ofbizsetup cannot create first customer. problem with state/province dropdown

2015-02-20 Thread Sharan Foga (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-6054?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sharan Foga updated OFBIZ-6054:
---
Sprint: Bug Crush Event - 21/2/2015

> ofbizsetup cannot create first customer. problem with state/province dropdown
> -
>
> Key: OFBIZ-6054
> URL: https://issues.apache.org/jira/browse/OFBIZ-6054
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Wai
>
> -use empty database.
> -go to url. https://localhost:8443/ofbizsetup/control/firstcustomer
> notice that when entering the postal address, the state/province dropdown is 
> empty and remains empty regardless of selection of the country dropdown.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-02-20 Thread Sharan Foga (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sharan Foga updated OFBIZ-5949:
---
Sprint: Bug Crush Event - 21/2/2015

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: framework
>Affects Versions: Trunk
>Reporter: Wai
> Attachments: OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (OFBIZ-6054) ofbizsetup cannot create first customer. problem with state/province dropdown

2015-02-02 Thread Wai (JIRA)

Wai created OFBIZ-6054:
--

 Summary: ofbizsetup cannot create first customer. problem with 
state/province dropdown
 Key: OFBIZ-6054
 URL: https://issues.apache.org/jira/browse/OFBIZ-6054
 Project: OFBiz
  Issue Type: Bug
  Components: commonext/setup
Affects Versions: Trunk
Reporter: Wai


-use empty database.
-go to url. https://localhost:8443/ofbizsetup/control/firstcustomer

notice that when entering the postal address, the state/province dropdown is 
empty and remains empty regardless of selection of the country dropdown.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

2015-01-08 Thread Wai (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Wai updated OFBIZ-5949:
---
Summary: ofbizsetup create product store cause exception, remove use of 
temp file to load entity data  (was: ofbizsetup create product store cause 
exception)

> ofbizsetup create product store cause exception, remove use of temp file to 
> load entity data
> 
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: framework
>Affects Versions: Trunk
>Reporter: Wai
> Attachments: OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (OFBIZ-5949) ofbizsetup create product store cause exception

2015-01-08 Thread Wai (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Wai updated OFBIZ-5949:
---
Description: 
The exception is caused by foreign key constraint violation between 
ShipmentCostEstimate and  CarrierShipmentMethod entities.

Currently, when creating a new product store using ofbizsetup component default 
data associated with the product store is loaded into the database using the 
following steps.

1. read default data from entity xml file and replace specific items in the 
read data and write to temp file.
2. use service=parseEntityXmlFile to load the processed file into database.

The issue with this method is that the temp file can present a problem when 
ofbiz is operating in multitenant mode.

The solution is to modify the relevant services so that no temp file needs 
generated.

  was:
Currently, when creating a new product store using ofbizsetup component default 
data associated with the product store is loaded into the database using the 
following steps.

1. read default data from entity xml file and replace specific items in the 
read data and write to temp file.
2. use service=parseEntityXmlFile to load the processed file into database.

The issue with this method is that the temp file can present a problem when 
ofbiz is operating in multitenant mode.

The solution is to modify the relevant services so that no temp file needs 
generated.


> ofbizsetup create product store cause exception
> ---
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: framework
>Affects Versions: Trunk
>Reporter: Wai
> Attachments: OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between 
> ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (OFBIZ-5949) ofbizsetup create product store cause exception

2015-01-08 Thread Wai (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Wai updated OFBIZ-5949:
---
Summary: ofbizsetup create product store cause exception  (was: Remove 
generation of temp file when loading entity xml file containing placeholders)

> ofbizsetup create product store cause exception
> ---
>
> Key: OFBIZ-5949
> URL: https://issues.apache.org/jira/browse/OFBIZ-5949
> Project: OFBiz
>  Issue Type: Bug
>  Components: framework
>Affects Versions: Trunk
>Reporter: Wai
> Attachments: OFBIZ-5949.patch
>
>
> Currently, when creating a new product store using ofbizsetup component 
> default data associated with the product store is loaded into the database 
> using the following steps.
> 1. read default data from entity xml file and replace specific items in the 
> read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when 
> ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs 
> generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Reopened] (OFBIZ-5821) Incomplete data of GlAccount for using ofbizsetup wizard

2014-10-19 Thread Jacques Le Roux (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-5821?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jacques Le Roux reopened OFBIZ-5821:


> Incomplete data of GlAccount for using ofbizsetup wizard
> 
>
> Key: OFBIZ-5821
> URL: https://issues.apache.org/jira/browse/OFBIZ-5821
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Arun Patidar
>Priority: Minor
>
> Add missing GlAccount data(GlAccountData.xml) to prevent error in ofbizsetup 
> wizard processes.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Reopened] (OFBIZ-5820) Error in ofbizsetup wizard due to incorrect GlAccount data

2014-10-19 Thread Jacques Le Roux (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-5820?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jacques Le Roux reopened OFBIZ-5820:


> Error in ofbizsetup wizard due to incorrect GlAccount data
> --
>
> Key: OFBIZ-5820
> URL: https://issues.apache.org/jira/browse/OFBIZ-5820
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: 13.07.01
>Reporter: Arun Patidar
>Priority: Minor
>
> Need to remove incomplete GlAccount data (GlAccountData.xml) to prevent error 
> in ofbizsetup wizard.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Closed] (OFBIZ-5821) Incomplete data of GlAccount for using ofbizsetup wizard

2014-10-19 Thread Jacques Le Roux (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-5821?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jacques Le Roux closed OFBIZ-5821.
--
Resolution: Not a Problem

> Incomplete data of GlAccount for using ofbizsetup wizard
> 
>
> Key: OFBIZ-5821
> URL: https://issues.apache.org/jira/browse/OFBIZ-5821
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Arun Patidar
>Priority: Minor
>
> Add missing GlAccount data(GlAccountData.xml) to prevent error in ofbizsetup 
> wizard processes.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Closed] (OFBIZ-5820) Error in ofbizsetup wizard due to incorrect GlAccount data

2014-10-19 Thread Jacques Le Roux (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-5820?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jacques Le Roux closed OFBIZ-5820.
--
Resolution: Not a Problem

> Error in ofbizsetup wizard due to incorrect GlAccount data
> --
>
> Key: OFBIZ-5820
> URL: https://issues.apache.org/jira/browse/OFBIZ-5820
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: 13.07.01
>Reporter: Arun Patidar
>Priority: Minor
>
> Need to remove incomplete GlAccount data (GlAccountData.xml) to prevent error 
> in ofbizsetup wizard.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Closed] (OFBIZ-5821) Incomplete data of GlAccount for using ofbizsetup wizard

2014-10-18 Thread Arun Patidar (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-5821?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Arun Patidar closed OFBIZ-5821.
---
Resolution: Fixed

Its not a valid issue. All the missing data creates on clicking 'Set To 
Complete' button action. 

> Incomplete data of GlAccount for using ofbizsetup wizard
> 
>
> Key: OFBIZ-5821
> URL: https://issues.apache.org/jira/browse/OFBIZ-5821
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Arun Patidar
>Priority: Minor
>
> Add missing GlAccount data(GlAccountData.xml) to prevent error in ofbizsetup 
> wizard processes.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Closed] (OFBIZ-5820) Error in ofbizsetup wizard due to incorrect GlAccount data

2014-10-18 Thread Arun Patidar (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-5820?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Arun Patidar closed OFBIZ-5820.
---

Its not a valid issue. All the missing data creates on clicking 'Set To 
Complete' button action.  

> Error in ofbizsetup wizard due to incorrect GlAccount data
> --
>
> Key: OFBIZ-5820
> URL: https://issues.apache.org/jira/browse/OFBIZ-5820
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: 13.07.01
>Reporter: Arun Patidar
>Priority: Minor
>
> Need to remove incomplete GlAccount data (GlAccountData.xml) to prevent error 
> in ofbizsetup wizard.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-5821) Incomplete data of GlAccount for using ofbizsetup wizard

2014-10-17 Thread Arun Patidar (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5821?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14175841#comment-14175841
 ] 

Arun Patidar commented on OFBIZ-5821:
-

Hi Pierre,

ofbizsetup wizard should work correctly with extseed data only. So there should 
not be dependency on demo data of OFBiz.

> Incomplete data of GlAccount for using ofbizsetup wizard
> 
>
> Key: OFBIZ-5821
> URL: https://issues.apache.org/jira/browse/OFBIZ-5821
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Arun Patidar
>Priority: Minor
>
> Add missing GlAccount data(GlAccountData.xml) to prevent error in ofbizsetup 
> wizard processes.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-5821) Incomplete data of GlAccount for using ofbizsetup wizard

2014-10-17 Thread Pierre Smits (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5821?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14175056#comment-14175056
 ] 

Pierre Smits commented on OFBIZ-5821:
-

Hi Arun,

So, trying to understand you correctly you are trying to use the setup process 
without having the supporting data? And you get error messages because you are 
missing the required data elements?

It seems the functionality is behaving correctly by showing the error when you 
don't have the pre-requisites complete.
Or are we missing something here trying to understand the issue?


> Incomplete data of GlAccount for using ofbizsetup wizard
> 
>
> Key: OFBIZ-5821
> URL: https://issues.apache.org/jira/browse/OFBIZ-5821
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Arun Patidar
>Priority: Minor
>
> Add missing GlAccount data(GlAccountData.xml) to prevent error in ofbizsetup 
> wizard processes.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-5821) Incomplete data of GlAccount for using ofbizsetup wizard

2014-10-17 Thread Arun Patidar (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5821?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14174998#comment-14174998
 ] 

Arun Patidar commented on OFBIZ-5821:
-

Hi Pierre,

I am working to fulfill missing data. Missing data is like as follows:

In GlAccountData.xml file, there are records like:


For using ofbizsetup wizard, we only need to load extseed data. So in this case 
glAccountId="10" data does not get load with this.

Same case exists for all records of file.



> Incomplete data of GlAccount for using ofbizsetup wizard
> 
>
> Key: OFBIZ-5821
> URL: https://issues.apache.org/jira/browse/OFBIZ-5821
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Arun Patidar
>Priority: Minor
>
> Add missing GlAccount data(GlAccountData.xml) to prevent error in ofbizsetup 
> wizard processes.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-5821) Incomplete data of GlAccount for using ofbizsetup wizard

2014-10-17 Thread Pierre Smits (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-5821?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14174983#comment-14174983
 ] 

Pierre Smits commented on OFBIZ-5821:
-

Hi Arun,

Can you please provide details about what is missing to complete the setup 
process? It will surely help speed up the process of getting this issue 
resolved.

Regards,

Pierre

> Incomplete data of GlAccount for using ofbizsetup wizard
> 
>
> Key: OFBIZ-5821
> URL: https://issues.apache.org/jira/browse/OFBIZ-5821
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Trunk
>Reporter: Arun Patidar
>Priority: Minor
>
> Add missing GlAccount data(GlAccountData.xml) to prevent error in ofbizsetup 
> wizard processes.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (OFBIZ-5821) Incomplete data of GlAccount for using ofbizsetup wizard

2014-10-17 Thread Arun Patidar (JIRA)

Arun Patidar created OFBIZ-5821:
---

 Summary: Incomplete data of GlAccount for using ofbizsetup wizard
 Key: OFBIZ-5821
 URL: https://issues.apache.org/jira/browse/OFBIZ-5821
 Project: OFBiz
  Issue Type: Bug
  Components: commonext/setup
Affects Versions: Trunk
Reporter: Arun Patidar
Priority: Minor


Add missing GlAccount data(GlAccountData.xml) to prevent error in ofbizsetup 
wizard processes.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (OFBIZ-5820) Error in ofbizsetup wizard due to incorrect GlAccount data

2014-10-17 Thread Arun Patidar (JIRA)

Arun Patidar created OFBIZ-5820:
---

 Summary: Error in ofbizsetup wizard due to incorrect GlAccount data
 Key: OFBIZ-5820
 URL: https://issues.apache.org/jira/browse/OFBIZ-5820
 Project: OFBiz
  Issue Type: Bug
  Components: commonext/setup
Affects Versions: 13.07.01
Reporter: Arun Patidar
Priority: Minor


Need to remove incomplete GlAccount data (GlAccountData.xml) to prevent error 
in ofbizsetup wizard.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (OFBIZ-4381) ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created

2012-02-05 Thread Jacques Le Roux (Commented) (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13200929#comment-13200929
 ] 

Jacques Le Roux commented on OFBIZ-4381:


This has been reverted, see OFBIZ-4675
    
> ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created 
> 
>
> Key: OFBIZ-4381
> URL: https://issues.apache.org/jira/browse/OFBIZ-4381
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Release 10.04
>Reporter: Marcelo Giubergia
>Assignee: Jacques Le Roux
>Priority: Minor
> Attachments: OFBIZ-4381.patch, OFBIZ-4381.patch
>
>
> I installed ofbiz from scratch according with recommended method
> >ant clean-all
> >ant run-install-extseed
> >ant create-admin-setup
> >./startofbiz.sh
> Then, when I create an store by 
> https://localhost:8443/ofbizsetup/control/createProductStore
> Error: Error parsing entity xml file: 
> org.ofbiz.entity.GenericEntityException: Error while inserting: 
> [GenericEntity:CarrierShipmentMethod][createdStamp,2011-08-29 
> 11:16:33.247(java.sql.Timestamp)][createdTxStamp,2011-08-29 
> 11:16:32.951(java.sql.Timestamp)][lastUpdatedStamp,2011-08-29 
> 11:16:33.247(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-29 
> 11:16:32.951(java.sql.Timestamp)][partyId,sds(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]
>  (SQL Exception while executing the following:INSERT INTO 
> public.CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, 
> ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, 
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, 
> ?, ?, ?, ?, ?) (ERROR: inserción o actualización en la tabla 
> «carrier_shipment_method» viola la llave foránea «carr_shmeth_type» 
> Detail: La llave (shipment_method_type_id)=(LOCAL_DELIVERY) no está presente 
> en la tabla «shipment_method_type».)) calling service parseEntityXmlFile in 
> importTempDataFile 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (OFBIZ-4381) ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created

2011-11-12 Thread Jacques Le Roux (Commented) (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13149118#comment-13149118
 ] 

Jacques Le Roux commented on OFBIZ-4381:


It may depend from where you downloaded the file, which revision are you using?
    
> ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created 
> 
>
> Key: OFBIZ-4381
> URL: https://issues.apache.org/jira/browse/OFBIZ-4381
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Release 10.04
>Reporter: Marcelo Giubergia
>Assignee: Jacques Le Roux
>Priority: Minor
> Attachments: OFBIZ-4381.patch, OFBIZ-4381.patch
>
>
> I installed ofbiz from scratch according with recommended method
> >ant clean-all
> >ant run-install-extseed
> >ant create-admin-setup
> >./startofbiz.sh
> Then, when I create an store by 
> https://localhost:8443/ofbizsetup/control/createProductStore
> Error: Error parsing entity xml file: 
> org.ofbiz.entity.GenericEntityException: Error while inserting: 
> [GenericEntity:CarrierShipmentMethod][createdStamp,2011-08-29 
> 11:16:33.247(java.sql.Timestamp)][createdTxStamp,2011-08-29 
> 11:16:32.951(java.sql.Timestamp)][lastUpdatedStamp,2011-08-29 
> 11:16:33.247(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-29 
> 11:16:32.951(java.sql.Timestamp)][partyId,sds(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]
>  (SQL Exception while executing the following:INSERT INTO 
> public.CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, 
> ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, 
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, 
> ?, ?, ?, ?, ?) (ERROR: inserción o actualización en la tabla 
> «carrier_shipment_method» viola la llave foránea «carr_shmeth_type» 
> Detail: La llave (shipment_method_type_id)=(LOCAL_DELIVERY) no está presente 
> en la tabla «shipment_method_type».)) calling service parseEntityXmlFile in 
> importTempDataFile 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (OFBIZ-4381) ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created

2011-11-12 Thread Commented


[ 
https://issues.apache.org/jira/browse/OFBIZ-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13149088#comment-13149088
 ] 

Jonas Colmsjö commented on OFBIZ-4381:
--

I just installed the latest version of ofbiz (10.04) on OSX Lion and have the 
same error. Applying the patch made no difference though. I'm a beginner at 
ofbiz. What more do I need to do?

/BR
Jonas

    
> ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created 
> 
>
> Key: OFBIZ-4381
> URL: https://issues.apache.org/jira/browse/OFBIZ-4381
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Release 10.04
>Reporter: Marcelo Giubergia
>Assignee: Jacques Le Roux
>Priority: Minor
> Attachments: OFBIZ-4381.patch, OFBIZ-4381.patch
>
>
> I installed ofbiz from scratch according with recommended method
> >ant clean-all
> >ant run-install-extseed
> >ant create-admin-setup
> >./startofbiz.sh
> Then, when I create an store by 
> https://localhost:8443/ofbizsetup/control/createProductStore
> Error: Error parsing entity xml file: 
> org.ofbiz.entity.GenericEntityException: Error while inserting: 
> [GenericEntity:CarrierShipmentMethod][createdStamp,2011-08-29 
> 11:16:33.247(java.sql.Timestamp)][createdTxStamp,2011-08-29 
> 11:16:32.951(java.sql.Timestamp)][lastUpdatedStamp,2011-08-29 
> 11:16:33.247(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-29 
> 11:16:32.951(java.sql.Timestamp)][partyId,sds(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]
>  (SQL Exception while executing the following:INSERT INTO 
> public.CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, 
> ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, 
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, 
> ?, ?, ?, ?, ?) (ERROR: inserción o actualización en la tabla 
> «carrier_shipment_method» viola la llave foránea «carr_shmeth_type» 
> Detail: La llave (shipment_method_type_id)=(LOCAL_DELIVERY) no está presente 
> en la tabla «shipment_method_type».)) calling service parseEntityXmlFile in 
> importTempDataFile 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Closed] (OFBIZ-4381) ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created

2011-09-10 Thread Jacques Le Roux (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jacques Le Roux closed OFBIZ-4381.
--

Resolution: Fixed
  Assignee: Jacques Le Roux

Thanks Marcelo,

Your patch is in 
trunk r1167510
R11.04 r1167513
R10.04 r1167514



> ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created 
> 
>
> Key: OFBIZ-4381
> URL: https://issues.apache.org/jira/browse/OFBIZ-4381
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Release 10.04
>Reporter: Marcelo Giubergia
>Assignee: Jacques Le Roux
>Priority: Minor
> Attachments: OFBIZ-4381.patch, OFBIZ-4381.patch
>
>
> I installed ofbiz from scratch according with recommended method
> >ant clean-all
> >ant run-install-extseed
> >ant create-admin-setup
> >./startofbiz.sh
> Then, when I create an store by 
> https://localhost:8443/ofbizsetup/control/createProductStore
> Error: Error parsing entity xml file: 
> org.ofbiz.entity.GenericEntityException: Error while inserting: 
> [GenericEntity:CarrierShipmentMethod][createdStamp,2011-08-29 
> 11:16:33.247(java.sql.Timestamp)][createdTxStamp,2011-08-29 
> 11:16:32.951(java.sql.Timestamp)][lastUpdatedStamp,2011-08-29 
> 11:16:33.247(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-29 
> 11:16:32.951(java.sql.Timestamp)][partyId,sds(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]
>  (SQL Exception while executing the following:INSERT INTO 
> public.CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, 
> ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, 
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, 
> ?, ?, ?, ?, ?) (ERROR: inserción o actualización en la tabla 
> «carrier_shipment_method» viola la llave foránea «carr_shmeth_type» 
> Detail: La llave (shipment_method_type_id)=(LOCAL_DELIVERY) no está presente 
> en la tabla «shipment_method_type».)) calling service parseEntityXmlFile in 
> importTempDataFile 

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (OFBIZ-4381) ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created

2011-08-31 Thread Marcelo Giubergia (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13094429#comment-13094429
 ] 

Marcelo Giubergia commented on OFBIZ-4381:
--

Hi Jacques, 

create-admin-setup target doesn't exist. Sorry about my mistake, I meant 
create-admin-user-login

Regards

> ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created 
> 
>
> Key: OFBIZ-4381
> URL: https://issues.apache.org/jira/browse/OFBIZ-4381
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Release 10.04
>Reporter: Marcelo Giubergia
>Priority: Minor
> Attachments: OFBIZ-4381.patch, OFBIZ-4381.patch
>
>
> I installed ofbiz from scratch according with recommended method
> >ant clean-all
> >ant run-install-extseed
> >ant create-admin-setup
> >./startofbiz.sh
> Then, when I create an store by 
> https://localhost:8443/ofbizsetup/control/createProductStore
> Error: Error parsing entity xml file: 
> org.ofbiz.entity.GenericEntityException: Error while inserting: 
> [GenericEntity:CarrierShipmentMethod][createdStamp,2011-08-29 
> 11:16:33.247(java.sql.Timestamp)][createdTxStamp,2011-08-29 
> 11:16:32.951(java.sql.Timestamp)][lastUpdatedStamp,2011-08-29 
> 11:16:33.247(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-29 
> 11:16:32.951(java.sql.Timestamp)][partyId,sds(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]
>  (SQL Exception while executing the following:INSERT INTO 
> public.CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, 
> ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, 
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, 
> ?, ?, ?, ?, ?) (ERROR: inserción o actualización en la tabla 
> «carrier_shipment_method» viola la llave foránea «carr_shmeth_type» 
> Detail: La llave (shipment_method_type_id)=(LOCAL_DELIVERY) no está presente 
> en la tabla «shipment_method_type».)) calling service parseEntityXmlFile in 
> importTempDataFile 

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (OFBIZ-4381) ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created

2011-08-30 Thread Jacques Le Roux (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13094280#comment-13094280
 ] 

Jacques Le Roux commented on OFBIZ-4381:


Hi Marcello,

There is any create-admin-setup target in both R10.04 and trunk, so I wonder...

> ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created 
> 
>
> Key: OFBIZ-4381
> URL: https://issues.apache.org/jira/browse/OFBIZ-4381
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Release 10.04
>Reporter: Marcelo Giubergia
>Priority: Minor
> Attachments: OFBIZ-4381.patch, OFBIZ-4381.patch
>
>
> I installed ofbiz from scratch according with recommended method
> >ant clean-all
> >ant run-install-extseed
> >ant create-admin-setup
> >./startofbiz.sh
> Then, when I create an store by 
> https://localhost:8443/ofbizsetup/control/createProductStore
> Error: Error parsing entity xml file: 
> org.ofbiz.entity.GenericEntityException: Error while inserting: 
> [GenericEntity:CarrierShipmentMethod][createdStamp,2011-08-29 
> 11:16:33.247(java.sql.Timestamp)][createdTxStamp,2011-08-29 
> 11:16:32.951(java.sql.Timestamp)][lastUpdatedStamp,2011-08-29 
> 11:16:33.247(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-29 
> 11:16:32.951(java.sql.Timestamp)][partyId,sds(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]
>  (SQL Exception while executing the following:INSERT INTO 
> public.CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, 
> ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, 
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, 
> ?, ?, ?, ?, ?) (ERROR: inserción o actualización en la tabla 
> «carrier_shipment_method» viola la llave foránea «carr_shmeth_type» 
> Detail: La llave (shipment_method_type_id)=(LOCAL_DELIVERY) no está presente 
> en la tabla «shipment_method_type».)) calling service parseEntityXmlFile in 
> importTempDataFile 

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (OFBIZ-4381) ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created

2011-08-30 Thread Marcelo Giubergia (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Marcelo Giubergia updated OFBIZ-4381:
-

Attachment: OFBIZ-4381.patch

sorry, this is the correct patch

> ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created 
> 
>
> Key: OFBIZ-4381
> URL: https://issues.apache.org/jira/browse/OFBIZ-4381
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Release 10.04
>Reporter: Marcelo Giubergia
>Priority: Minor
> Attachments: OFBIZ-4381.patch, OFBIZ-4381.patch
>
>
> I installed ofbiz from scratch according with recommended method
> >ant clean-all
> >ant run-install-extseed
> >ant create-admin-setup
> >./startofbiz.sh
> Then, when I create an store by 
> https://localhost:8443/ofbizsetup/control/createProductStore
> Error: Error parsing entity xml file: 
> org.ofbiz.entity.GenericEntityException: Error while inserting: 
> [GenericEntity:CarrierShipmentMethod][createdStamp,2011-08-29 
> 11:16:33.247(java.sql.Timestamp)][createdTxStamp,2011-08-29 
> 11:16:32.951(java.sql.Timestamp)][lastUpdatedStamp,2011-08-29 
> 11:16:33.247(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-29 
> 11:16:32.951(java.sql.Timestamp)][partyId,sds(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]
>  (SQL Exception while executing the following:INSERT INTO 
> public.CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, 
> ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, 
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, 
> ?, ?, ?, ?, ?) (ERROR: inserción o actualización en la tabla 
> «carrier_shipment_method» viola la llave foránea «carr_shmeth_type» 
> Detail: La llave (shipment_method_type_id)=(LOCAL_DELIVERY) no está presente 
> en la tabla «shipment_method_type».)) calling service parseEntityXmlFile in 
> importTempDataFile 

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (OFBIZ-4381) ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created

2011-08-29 Thread Marcelo Giubergia (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Marcelo Giubergia updated OFBIZ-4381:
-

Attachment: OFBIZ-4381.patch

This patch add ShippingData in seed reader

/applications/commonext/ofbiz-component.xml



> ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created 
> 
>
> Key: OFBIZ-4381
> URL: https://issues.apache.org/jira/browse/OFBIZ-4381
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Release 10.04
>Reporter: Marcelo Giubergia
>Priority: Minor
> Attachments: OFBIZ-4381.patch
>
>
> I installed ofbiz from scratch according with recommended method
> >ant clean-all
> >ant run-install-extseed
> >ant create-admin-setup
> >./startofbiz.sh
> Then, when I create an store by 
> https://localhost:8443/ofbizsetup/control/createProductStore
> Error: Error parsing entity xml file: 
> org.ofbiz.entity.GenericEntityException: Error while inserting: 
> [GenericEntity:CarrierShipmentMethod][createdStamp,2011-08-29 
> 11:16:33.247(java.sql.Timestamp)][createdTxStamp,2011-08-29 
> 11:16:32.951(java.sql.Timestamp)][lastUpdatedStamp,2011-08-29 
> 11:16:33.247(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-29 
> 11:16:32.951(java.sql.Timestamp)][partyId,sds(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]
>  (SQL Exception while executing the following:INSERT INTO 
> public.CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, 
> ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, 
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, 
> ?, ?, ?, ?, ?) (ERROR: inserción o actualización en la tabla 
> «carrier_shipment_method» viola la llave foránea «carr_shmeth_type» 
> Detail: La llave (shipment_method_type_id)=(LOCAL_DELIVERY) no está presente 
> en la tabla «shipment_method_type».)) calling service parseEntityXmlFile in 
> importTempDataFile 

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Created] (OFBIZ-4381) ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created

2011-08-29 Thread Marcelo Giubergia (JIRA)

ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created 


 Key: OFBIZ-4381
 URL: https://issues.apache.org/jira/browse/OFBIZ-4381
 Project: OFBiz
  Issue Type: Bug
  Components: commonext/setup
Affects Versions: Release 10.04
Reporter: Marcelo Giubergia
Priority: Minor


I installed ofbiz from scratch according with recommended method

>ant clean-all
>ant run-install-extseed
>ant create-admin-setup
>./startofbiz.sh

Then, when I create an store by 
https://localhost:8443/ofbizsetup/control/createProductStore

Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: 
Error while inserting: 
[GenericEntity:CarrierShipmentMethod][createdStamp,2011-08-29 
11:16:33.247(java.sql.Timestamp)][createdTxStamp,2011-08-29 
11:16:32.951(java.sql.Timestamp)][lastUpdatedStamp,2011-08-29 
11:16:33.247(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-29 
11:16:32.951(java.sql.Timestamp)][partyId,sds(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]
 (SQL Exception while executing the following:INSERT INTO 
public.CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, 
ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, 
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, 
?, ?, ?, ?) (ERROR: inserción o actualización en la tabla 
«carrier_shipment_method» viola la llave foránea «carr_shmeth_type» 
Detail: La llave (shipment_method_type_id)=(LOCAL_DELIVERY) no está presente en 
la tabla «shipment_method_type».)) calling service parseEntityXmlFile in 
importTempDataFile 



--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (OFBIZ-4381) ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created

2011-08-29 Thread Marcelo Giubergia (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13093205#comment-13093205
 ] 

Marcelo Giubergia commented on OFBIZ-4381:
--

the ${ofbiz-dir}/applications/commonext/ofbiz-component.xml

doesn't contains  

> ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created 
> 
>
> Key: OFBIZ-4381
> URL: https://issues.apache.org/jira/browse/OFBIZ-4381
> Project: OFBiz
>  Issue Type: Bug
>  Components: commonext/setup
>Affects Versions: Release 10.04
>Reporter: Marcelo Giubergia
>Priority: Minor
>
> I installed ofbiz from scratch according with recommended method
> >ant clean-all
> >ant run-install-extseed
> >ant create-admin-setup
> >./startofbiz.sh
> Then, when I create an store by 
> https://localhost:8443/ofbizsetup/control/createProductStore
> Error: Error parsing entity xml file: 
> org.ofbiz.entity.GenericEntityException: Error while inserting: 
> [GenericEntity:CarrierShipmentMethod][createdStamp,2011-08-29 
> 11:16:33.247(java.sql.Timestamp)][createdTxStamp,2011-08-29 
> 11:16:32.951(java.sql.Timestamp)][lastUpdatedStamp,2011-08-29 
> 11:16:33.247(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-29 
> 11:16:32.951(java.sql.Timestamp)][partyId,sds(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]
>  (SQL Exception while executing the following:INSERT INTO 
> public.CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, 
> ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, 
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, 
> ?, ?, ?, ?, ?) (ERROR: inserción o actualización en la tabla 
> «carrier_shipment_method» viola la llave foránea «carr_shmeth_type» 
> Detail: La llave (shipment_method_type_id)=(LOCAL_DELIVERY) no está presente 
> en la tabla «shipment_method_type».)) calling service parseEntityXmlFile in 
> importTempDataFile 

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] Commented: (OFBIZ-4031) Add Traditional Chinese translation for applications, ecommerce, and ofbizsetup

2010-11-29 Thread Jacques Le Roux (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-4031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12964709#action_12964709
 ] 

Jacques Le Roux commented on OFBIZ-4031:


Thanks Dukian,

At r1040078, I have removed those lines. I just kept 2 duplicates in Chinese 
(and one in German), check if you like...

> Add Traditional Chinese translation for applications, ecommerce, and 
> ofbizsetup
> ---
>
> Key: OFBIZ-4031
> URL: https://issues.apache.org/jira/browse/OFBIZ-4031
> Project: OFBiz
>  Issue Type: Improvement
>Affects Versions: SVN trunk
>Reporter: dukian
>Assignee: Jacques Le Roux
> Fix For: SVN trunk
>
> Attachments: chk_files.txt, chk_r1039859.txt, OFBIZ-4031-FAULTS.png, 
> OFBIZ-4031_zh_TW.patch.zip, trans_chk.py
>
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Updated: (OFBIZ-4031) Add Traditional Chinese translation for applications, ecommerce, and ofbizsetup

2010-11-29 Thread dukian (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-4031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

dukian updated OFBIZ-4031:
--

Attachment: OFBIZ-4031-FAULTS.png

Hi Jacques,

Because I misused merge tool under Mercurial MQ for several months(maintains 
zh_TW patch),  those were removed properties but still add  tags to 
related position.

The case likes attachment OFBIZ-4031-FAULTS.png: the left side is my patch, the 
center is base revision, the right side is new revision.

I consider these  tags should be erased. Thanks for you support.

> Add Traditional Chinese translation for applications, ecommerce, and 
> ofbizsetup
> ---
>
> Key: OFBIZ-4031
> URL: https://issues.apache.org/jira/browse/OFBIZ-4031
> Project: OFBiz
>  Issue Type: Improvement
>Affects Versions: SVN trunk
>Reporter: dukian
>Assignee: Jacques Le Roux
> Fix For: SVN trunk
>
> Attachments: chk_files.txt, chk_r1039859.txt, OFBIZ-4031-FAULTS.png, 
> OFBIZ-4031_zh_TW.patch.zip, trans_chk.py
>
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Issue Comment Edited: (OFBIZ-4031) Add Traditional Chinese translation for applications, ecommerce, and ofbizsetup

2010-11-28 Thread Jacques Le Roux (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-4031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12964563#action_12964563
 ] 

Jacques Le Roux edited comment on OFBIZ-4031 at 11/28/10 11:36 AM:
---

***EDIT** forgot the revision number
Thanks Dukian,

According to your py program (sounds good to me), there was only one error 
remaining. It's fixed at r1039892

If you want to check more I have not removed the culprit lines but commented 
them out with one these comments




  was (Author: jacques.le.roux):
Thanks Dukian,

According to your py program (sounds good to me), there was only one error 
remaining. It's fixed at r

If you want to check more I have not removed the culprit lines but commented 
them out with one these comments



  
> Add Traditional Chinese translation for applications, ecommerce, and 
> ofbizsetup
> ---
>
> Key: OFBIZ-4031
> URL: https://issues.apache.org/jira/browse/OFBIZ-4031
> Project: OFBiz
>  Issue Type: Improvement
>Affects Versions: SVN trunk
>Reporter: dukian
>Assignee: Jacques Le Roux
> Fix For: SVN trunk
>
> Attachments: chk_files.txt, chk_r1039859.txt, 
> OFBIZ-4031_zh_TW.patch.zip, trans_chk.py
>
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Commented: (OFBIZ-4031) Add Traditional Chinese translation for applications, ecommerce, and ofbizsetup

2010-11-28 Thread Jacques Le Roux (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-4031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12964563#action_12964563
 ] 

Jacques Le Roux commented on OFBIZ-4031:


Thanks Dukian,

According to your py program (sounds good to me), there was only one error 
remaining. It's fixed at r

If you want to check more I have not removed the culprit lines but commented 
them out with one these comments




> Add Traditional Chinese translation for applications, ecommerce, and 
> ofbizsetup
> ---
>
> Key: OFBIZ-4031
> URL: https://issues.apache.org/jira/browse/OFBIZ-4031
> Project: OFBiz
>  Issue Type: Improvement
>Affects Versions: SVN trunk
>Reporter: dukian
>Assignee: Jacques Le Roux
> Fix For: SVN trunk
>
> Attachments: chk_files.txt, chk_r1039859.txt, 
> OFBIZ-4031_zh_TW.patch.zip, trans_chk.py
>
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Updated: (OFBIZ-4031) Add Traditional Chinese translation for applications, ecommerce, and ofbizsetup

2010-11-28 Thread dukian (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-4031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

dukian updated OFBIZ-4031:
--

Attachment: chk_r1039859.txt
chk_files.txt
trans_chk.py

sorry for my mistake.

I just arrange a program to check this problem(trans_chk.py). It will take care 
each property set, and checks tag  is inside or outside.

And prepare all change file names in r1039574  to a text file: chk_files.txt, 
and execute following command under OFBiz directory:

{quote}
 $ cat ../chk_files.txt | xargs python ~/trans_chk.py > chk_r1039574.txt
{quote}

I run above command under r1039574 and r1039859, and results as attachment.

It seems some probelms in specialpurpose/ecommerce/config/EcommerceUiLabels.xml.

please check it, thanks :-)

> Add Traditional Chinese translation for applications, ecommerce, and 
> ofbizsetup
> ---
>
> Key: OFBIZ-4031
> URL: https://issues.apache.org/jira/browse/OFBIZ-4031
> Project: OFBiz
>  Issue Type: Improvement
>Affects Versions: SVN trunk
>Reporter: dukian
>Assignee: Jacques Le Roux
> Fix For: SVN trunk
>
> Attachments: chk_files.txt, chk_r1039859.txt, 
> OFBIZ-4031_zh_TW.patch.zip, trans_chk.py
>
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Commented: (OFBIZ-4031) Add Traditional Chinese translation for applications, ecommerce, and ofbizsetup

2010-11-28 Thread Jacques Le Roux (JIRA)


[ 
https://issues.apache.org/jira/browse/OFBIZ-4031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12964525#action_12964525
 ] 

Jacques Le Roux commented on OFBIZ-4031:


Hi Dukian,

At [r1039651|http://svn.apache.org/viewvc?rev=1039859&view=rev] I have fixed 
some errors in your patch. There are annoying because AFAIK we have noways to 
spot them automatically:
* The are not reported as errors by XSD when you load the file in an XML editor
* The Label manager does not report them
* The patch is 93074 lines and 5MB
* It's hard to scan this kind of errors in a patch even a small one

Could you please have a look to ensure that there are no other  tags 
outside of the  tags introduced with your changes, thanks!

There were also some duplicates, look for them at 
[r1039858|http://svn.apache.org/viewvc?rev=1039858&view=rev].

> Add Traditional Chinese translation for applications, ecommerce, and 
> ofbizsetup
> ---
>
> Key: OFBIZ-4031
> URL: https://issues.apache.org/jira/browse/OFBIZ-4031
> Project: OFBiz
>  Issue Type: Improvement
>Affects Versions: SVN trunk
>Reporter: dukian
>Assignee: Jacques Le Roux
> Fix For: SVN trunk
>
> Attachments: OFBIZ-4031_zh_TW.patch.zip
>
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Closed: (OFBIZ-4031) Add Traditional Chinese translation for applications, ecommerce, and ofbizsetup

2010-11-26 Thread Jacques Le Roux (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-4031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jacques Le Roux closed OFBIZ-4031.
--

   Resolution: Fixed
Fix Version/s: SVN trunk
 Assignee: Jacques Le Roux

Thanks Dukian,

Your patch is in trunk at r1039574

> Add Traditional Chinese translation for applications, ecommerce, and 
> ofbizsetup
> ---
>
> Key: OFBIZ-4031
> URL: https://issues.apache.org/jira/browse/OFBIZ-4031
> Project: OFBiz
>  Issue Type: Improvement
>Affects Versions: SVN trunk
>Reporter: dukian
>Assignee: Jacques Le Roux
> Fix For: SVN trunk
>
> Attachments: OFBIZ-4031_zh_TW.patch.zip
>
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Updated: (OFBIZ-4031) Add Traditional Chinese translation for applications, ecommerce, and ofbizsetup

2010-11-22 Thread dukian (JIRA)


 [ 
https://issues.apache.org/jira/browse/OFBIZ-4031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

dukian updated OFBIZ-4031:
--

Attachment: OFBIZ-4031_zh_TW.patch.zip

$ svn info
Path: .
URL: https://svn.apache.org/repos/asf/ofbiz/trunk
Repository Root: https://svn.apache.org/repos/asf
Repository UUID: 13f79535-47bb-0310-9956-ffa450edef68
Revision: 1037754
Node Kind: directory
Schedule: normal
Last Changed Author: hansbak
Last Changed Rev: 1037624
Last Changed Date: 2010-11-22 15:55:56 +0800 (Mon, 22 Nov 2010)

$ svn st
M   applications/party/config/PartyUiLabels.xml
M   applications/party/config/PartyErrorUiLabels.xml
M   applications/party/config/PartyEntityLabels.xml
M   applications/product/config/ProductEntityLabels.xml
M   applications/product/config/ProductUiLabels.xml
A   applications/product/config/promotext_zh_TW.properties
M   applications/product/config/ProductErrorUiLabels.xml
M   applications/marketing/config/MarketingEntityLabels.xml
M   applications/marketing/config/MarketingUiLabels.xml
M   applications/humanres/config/HumanResUiLabels.xml
M   applications/manufacturing/config/ManufacturingEntityLabels.xml
M   applications/manufacturing/config/ManufacturingReportsUiLabels.xml
M   applications/manufacturing/config/ManufacturingUiLabels.xml
M   applications/workeffort/config/WorkEffortEntityLabels.xml
M   applications/workeffort/config/WorkEffortUiLabels.xml
M   applications/commonext/config/SetupUiLabels.xml
M   applications/accounting/config/AccountingErrorUiLabels.xml
M   applications/accounting/config/AccountingEntityLabels.xml
M   applications/accounting/config/AccountingUiLabels.xml
M   applications/content/config/ContentErrorUiLabels.xml
M   applications/content/config/ContentEntityLabels.xml
M   applications/content/config/ContentUiLabels.xml
M   applications/order/config/OrderErrorUiLabels.xml
M   applications/order/config/OrderEntityLabels.xml
M   applications/order/config/OrderUiLabels.xml
M   framework/widget/config/conditional.xml
M   framework/common/config/CommonHelpUiLabels.xml
M   framework/common/config/CommonErrorUiLabels.xml
M   framework/common/config/TemporalExpressionUiLabels.xml
M   framework/common/config/CommonEntityLabels.xml
M   framework/common/config/CommonUiLabels.xml
M   framework/common/config/SecurityextUiLabels.xml
M   framework/common/config/CommonPortalEntityLabels.xml
M   framework/minilang/config/MiniLangErrorUiLabels.xml
M   framework/minilang/config/DefaultMessages.xml
M   framework/webtools/config/WebtoolsErrorUiLabels.xml
M   framework/webtools/config/WebtoolsUiLabels.xml
M   framework/service/config/ServiceErrorUiLabels.xml
M   framework/images/webapp/images/calendarDateSelect/locale/zh.js
M   framework/security/config/SecurityEntityLabels.xml
M   framework/base/config/DateTimeLabels.xml
M   framework/webapp/config/WebappEntityLabels.xml
M   framework/webapp/config/WebappUiLabels.xml
M   specialpurpose/ecommerce/config/EcommerceUiLabels.xml
M   specialpurpose/myportal/config/MyPortalUiLabels.xml

> Add Traditional Chinese translation for applications, ecommerce, and 
> ofbizsetup
> ---
>
> Key: OFBIZ-4031
> URL: https://issues.apache.org/jira/browse/OFBIZ-4031
> Project: OFBiz
>  Issue Type: Improvement
>Affects Versions: SVN trunk
>Reporter: dukian
> Attachments: OFBIZ-4031_zh_TW.patch.zip
>
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Created: (OFBIZ-4031) Add Traditional Chinese translation for applications, ecommerce, and ofbizsetup

2010-11-22 Thread dukian (JIRA)

Add Traditional Chinese translation for applications, ecommerce, and ofbizsetup
---

 Key: OFBIZ-4031
 URL: https://issues.apache.org/jira/browse/OFBIZ-4031
 Project: OFBiz
  Issue Type: Improvement
Affects Versions: SVN trunk
Reporter: dukian




-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Re: ofbizsetup Docs

2010-08-28 Thread BJ Freeman


Thanks Hans.

=
BJ Freeman  
Strategic Power Office with Supplier Automation  

Specialtymarket.com  
Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man


Hans Bakker sent the following on 8/28/2010 6:32 PM:

Hi BJ,

We originally developed this and do not have plans at the moment. So
sure, please go ahead...

Regards,
Hans

Re: ofbizsetup Docs

2010-08-28 Thread Hans Bakker

Hi BJ,

We originally developed this and do not have plans at the moment. So
sure, please go ahead...

Regards,
Hans

-- 
Ofbiz on twitter: http://twitter.com/apache_ofbiz
Myself on twitter: http://twitter.com/hansbak
Antwebsystems.com: Quality services for competitive rates.

On Sat, 2010-08-28 at 09:12 -0700, BJ Freeman wrote:
> checked under
> /application/commonext/documentation?setup.xml
> is there any links that has documents of what is planned?
> I want to integrate the setup system I have with this but don't want to 
> step on other efforts.
> 
> =
> BJ Freeman  
> Strategic Power Office with Supplier Automation  
> 
> Specialtymarket.com  
> Systems Integrator-- Glad to Assist
> 
> Chat  Y! messenger: bjfr33man
>

ofbizsetup Docs

2010-08-28 Thread BJ Freeman


checked under
/application/commonext/documentation?setup.xml
is there any links that has documents of what is planned?
I want to integrate the setup system I have with this but don't want to 
step on other efforts.


=
BJ Freeman  
Strategic Power Office with Supplier Automation  

Specialtymarket.com  
Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man

Re: in OFBizSetup app: why cannot I create my own WebsiteId?

2010-07-16 Thread Jacques Le Roux


And please David, use rather user ML for such questions, see why here :
http://cwiki.apache.org/confluence/display/OFBADMIN/Mailing+Lists#MailingLists-DesignanddevelopmentList:dev@ofbiz.apache.org

Thanks

Jacques

From: "BJ Freeman" 

the websiteID must match the parm in the ecommerce web.xml
this is meant for someone with no expertise or knowledge of how ofbiz works.
someone with expertise would develop data files or use the UI and create 
a productstore then a websiteID that would be put in the web.xml




David-DiSiD Technologies sent the following on 7/16/2010 1:04 AM:


In OFBizSetup application, in the section "Web Site" (during the setup of new
organization) the value of Website ID is always WebStore, I cannot change it
with my own Website ID.

That's because the service called is this:


 
 


It overwrites the value of webSiteId.

Is there any reason for this?
If not, I can provide a patch for this (replacing the service called from
controller of FBizSetup app)

I'm using branch release10.4, but also I see it in trunk.

Thanks,

-
David Cervera - dcervera at disid dot com
DiSiD Technologies, S.L. - http://www.disid.com

Re: in OFBizSetup app: why cannot I create my own WebsiteId?

2010-07-16 Thread BJ Freeman


the websiteID must match the parm in the ecommerce web.xml
this is meant for someone with no expertise or knowledge of how ofbiz works.
someone with expertise would develop data files or use the UI and create 
a productstore then a websiteID that would be put in the web.xml




David-DiSiD Technologies sent the following on 7/16/2010 1:04 AM:


In OFBizSetup application, in the section "Web Site" (during the setup of new
organization) the value of Website ID is always WebStore, I cannot change it
with my own Website ID.

That's because the service called is this:


 
 


It overwrites the value of webSiteId.

Is there any reason for this?
If not, I can provide a patch for this (replacing the service called from
controller of FBizSetup app)

I'm using branch release10.4, but also I see it in trunk.

Thanks,

-
David Cervera - dcervera at disid dot com
DiSiD Technologies, S.L. - http://www.disid.com

in OFBizSetup app: why cannot I create my own WebsiteId?

2010-07-16 Thread David-DiSiD Technologies


In OFBizSetup application, in the section "Web Site" (during the setup of new
organization) the value of Website ID is always WebStore, I cannot change it
with my own Website ID.

That's because the service called is this:






It overwrites the value of webSiteId.

Is there any reason for this?
If not, I can provide a patch for this (replacing the service called from
controller of FBizSetup app)

I'm using branch release10.4, but also I see it in trunk.

Thanks,

-
David Cervera - dcervera at disid dot com
DiSiD Technologies, S.L. - http://www.disid.com
-- 
View this message in context: 
http://ofbiz.135035.n4.nabble.com/in-OFBizSetup-app-why-cannot-I-create-my-own-WebsiteId-tp2291061p2291061.html
Sent from the OFBiz - Dev mailing list archive at Nabble.com.

Re: OfbizSetup and localisation

2010-05-05 Thread BJ Freeman

can this not be part of the labels and internationalization.

=
BJ Freeman
http://bjfreeman.elance.com
Strategic Power Office with Supplier Automation 
<http://www.businessesnetwork.com/automation/viewforum.php?f=93>
Specialtymarket.com <http://www.specialtymarket.com/>

Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man
Linkedin
<http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>


Nicolas Malin sent the following on 5/5/2010 5:59 AM:
> Jacques, Erwan, and other,
> 
> I works on ofbizsetup system to create quickly a french society.
> Currently, input forms and data are oriented for american society. Do
> you have idea to manage and stock french specific (Trésor Public, La
> poste, PartyIdentification, French TVA, etc ...)?
> 
> I propose to create a directory by country in commonext/data that
> contains all data xml file and when the new organization is created, we
> load the good directory by entity import directory in terms of main
> postal address.
> 
> Others suggestions ?
> 
> Nicolas
>

Re: OfbizSetup and localisation

2010-05-05 Thread Nicolas Malin


Yes jacques, it's also a possibility.

I choice directory to have the possibility to separate data.
I will try your solution ;)

Nicolas

Jacques Le Roux wrote:

Hi Nicolas,

This looks like a good idea to me, but I did not look into details.
Would you really need to create a directory for each country (with 
data of course).
Could not the data been put in a single file by country with a suffix 
in file name?

Could be named from SetupData.xml, for instance SetupData_fr.xml, etc.
We could then import from a single file using the suffix (I guess 
programmaticaly)


My 2cts so far

Jacques

From: "Nicolas Malin" 

Jacques, Erwan, and other,

I works on ofbizsetup system to create quickly a french society. 
Currently, input forms and data are oriented for american society. Do 
you have idea to manage and stock french specific (Trésor Public, La 
poste, PartyIdentification, French TVA, etc ...)?


I propose to create a directory by country in commonext/data that 
contains all data xml file and when the new organization is created, 
we load the good directory by entity import directory in terms of 
main postal address.


Others suggestions ?

Nicolas

--
Nicolas MALIN
Consultant
Tél : 06.17.66.40.06
Site projet : http://www.neogia.org/
---
Société LibrenBerry
Tél : 02.48.02.56.12
Site : http://www.librenberry.net/







--
Nicolas MALIN
Consultant
Tél : 06.17.66.40.06
Site projet : http://www.neogia.org/
---
Société LibrenBerry
Tél : 02.48.02.56.12
Site : http://www.librenberry.net/

Re: OfbizSetup and localisation

2010-05-05 Thread Jacques Le Roux


Hi Nicolas,

This looks like a good idea to me, but I did not look into details.
Would you really need to create a directory for each country (with data of 
course).
Could not the data been put in a single file by country with a suffix in file 
name?
Could be named from SetupData.xml, for instance SetupData_fr.xml, etc.
We could then import from a single file using the suffix (I guess 
programmaticaly)

My 2cts so far

Jacques

From: "Nicolas Malin" 

Jacques, Erwan, and other,

I works on ofbizsetup system to create quickly a french society. Currently, input forms and data are oriented for american 
society. Do you have idea to manage and stock french specific (Trésor Public, La poste, PartyIdentification, French TVA, etc ...)?


I propose to create a directory by country in commonext/data that contains all data xml file and when the new organization is 
created, we load the good directory by entity import directory in terms of main postal address.


Others suggestions ?

Nicolas

--
Nicolas MALIN
Consultant
Tél : 06.17.66.40.06
Site projet : http://www.neogia.org/
---
Société LibrenBerry
Tél : 02.48.02.56.12
Site : http://www.librenberry.net/

OfbizSetup and localisation

2010-05-05 Thread Nicolas Malin


Jacques, Erwan, and other,

I works on ofbizsetup system to create quickly a french society. 
Currently, input forms and data are oriented for american society. Do 
you have idea to manage and stock french specific (Trésor Public, La 
poste, PartyIdentification, French TVA, etc ...)?


I propose to create a directory by country in commonext/data that 
contains all data xml file and when the new organization is created, we 
load the good directory by entity import directory in terms of main 
postal address.


Others suggestions ?

Nicolas

--
Nicolas MALIN
Consultant
Tél : 06.17.66.40.06
Site projet : http://www.neogia.org/
---
Société LibrenBerry
Tél : 02.48.02.56.12
Site : http://www.librenberry.net/

Re: svn commit: r904970 - in /ofbiz/trunk: applications/commonext/script/ applications/commonext/webapp/ofbizsetup/organization/ applications/commonext/widget/ framework/common/widget/ themes/bizzness

2010-02-03 Thread Adam Heath

hans...@apache.org wrote:
> Author: hansbak
> Date: Sun Jan 31 03:59:51 2010
> New Revision: 904970
> 
> URL: http://svn.apache.org/viewvc?rev=904970&view=rev
> Log:
> removed framework dependency on the commonext component introduced in 816083 
> and as reported in he mailinglist by Adrian
> 
> Added:
> 
> ofbiz/trunk/applications/commonext/webapp/ofbizsetup/organization/changeOrgPartyId.groovy
>   - copied unchanged from r904004, 
> ofbiz/trunk/applications/commonext/script/changeOrgPartyId.groovy
> Removed:
> ofbiz/trunk/applications/commonext/script/changeOrgPartyId.groovy
> Modified:
> ofbiz/trunk/applications/commonext/widget/CommonScreens.xml
> ofbiz/trunk/framework/common/widget/CommonScreens.xml
> ofbiz/trunk/themes/bizznesstime/includes/appbar.ftl
> ofbiz/trunk/themes/bluelight/includes/appbarOpen.ftl
> ofbiz/trunk/themes/droppingcrumbs/includes/appbarOpen.ftl
> ofbiz/trunk/themes/flatgrey/includes/appbar.ftl
> 
> Modified: ofbiz/trunk/themes/bizznesstime/includes/appbar.ftl
> URL: 
> http://svn.apache.org/viewvc/ofbiz/trunk/themes/bizznesstime/includes/appbar.ftl?rev=904970&r1=904969&r2=904970&view=diff
> ==
> --- ofbiz/trunk/themes/bizznesstime/includes/appbar.ftl (original)
> +++ ofbiz/trunk/themes/bizznesstime/includes/appbar.ftl Sun Jan 31 03:59:51 
> 2010
> @@ -28,7 +28,7 @@
>  
>  
>  ${uiLabelMap.CommonPrimaryApps}
> -<#list displayApps as display>
> +<#list displayApps as display>
><#assign thisApp = display.getContextRoot()>
><#assign permission = true>
><#assign selected = false>

don't mix code changes and formatting changes together.  What if you
had introduced a typo when this line was reformatted.  In some cases,
such a typo might not be noticed right away.  Later, when someone does
notice something wrong, they will start looking thru svn commit
history.  The commit for this change doesn't say anything about fixing
this issue, so this commit might get skipped when trying to find the
cause.

91 matches

Mail list logo