You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by "R. S." <ru...@meinkino.com> on 2010/06/01 11:08:47 UTC
Re: StateList
Thank you Atul,
sorry I don't have your mail read correctly. Now I know what you meant :-)
Best Regards,
Rudolf
Atul Vani schrieb:
> Hi R.S.,
>
> When you will add the data mentioned
> and re-install the data (or you can also use webtools' import facility),
> the view entity will get populated automatically :)
>
Re: StateList
Posted by "R. S." <ru...@meinkino.com>.
Hello Atul, Hello Jacques,
I didn't have enough time to create the issue yesterday. Thank you Atul.
Regards
Rudolf
Atul Vani schrieb:
> Hello Jacques, R.S.,
>
> I have created the issue, here's the link
> https://issues.apache.org/jira/browse/OFBIZ-3799
>
Re: StateList
Posted by Jacques Le Roux <ja...@les7arts.com>.
Thanks Atul!
Jacques
From: "Atul Vani" <at...@hotwaxmedia.com>
> Hello Jacques, R.S.,
>
> I have created the issue, here's the link
> https://issues.apache.org/jira/browse/OFBIZ-3799
>
> --
> Thanks & Regards
> Atul Vani
> Enterprise Software Developer
> HotWax Media Pvt. Ltd.
> http://www.hotwaxmedia.com/
> We are the Global Leaders in Apache OFBiz, Google 'ofbiz' and see for yourself.
>
>
> Jacques Le Roux wrote:
>> R.S.
>>
>> Would you consider to add the data you created in a patch attached to
>> a Jira?
>> http://cwiki.apache.org/confluence/x/JIB2
>>
>> TIA
>>
>> Jacques
>> PS : 2d try, that's why I use a tiny link here. It seems plain links
>> (even from https://cwiki.apache.org/confluence/display) have trouble
>> to get through these last times...
>>
>> From: "R. S." <ru...@meinkino.com>
>>> Great, Thanks. All the time I thought that "ant run-install" would
>>> remove my old data.
>>> You leave and Learn :-)
>>>
>>> Atul Vani schrieb:
>>>> Hi R.S.,
>>>>
>>>> Glad to know your work's done.
>>>>
>>>> Just wanted to let you know that "ant run-install" doesn't remove
>>>> old data,
>>>> it just updates the data from data files.
>>>>
>>>> So if you have any new data in the database, like say you created a
>>>> few customers, then it will not be affected.
>>>>
>>>
>>
>>
>
Re: StateList
Posted by Atul Vani <at...@hotwaxmedia.com>.
Hello Jacques, R.S.,
I have created the issue, here's the link
https://issues.apache.org/jira/browse/OFBIZ-3799
--
Thanks & Regards
Atul Vani
Enterprise Software Developer
HotWax Media Pvt. Ltd.
http://www.hotwaxmedia.com/
We are the Global Leaders in Apache OFBiz, Google 'ofbiz' and see for yourself.
Jacques Le Roux wrote:
> R.S.
>
> Would you consider to add the data you created in a patch attached to
> a Jira?
> http://cwiki.apache.org/confluence/x/JIB2
>
> TIA
>
> Jacques
> PS : 2d try, that's why I use a tiny link here. It seems plain links
> (even from https://cwiki.apache.org/confluence/display) have trouble
> to get through these last times...
>
> From: "R. S." <ru...@meinkino.com>
>> Great, Thanks. All the time I thought that "ant run-install" would
>> remove my old data.
>> You leave and Learn :-)
>>
>> Atul Vani schrieb:
>>> Hi R.S.,
>>>
>>> Glad to know your work's done.
>>>
>>> Just wanted to let you know that "ant run-install" doesn't remove
>>> old data,
>>> it just updates the data from data files.
>>>
>>> So if you have any new data in the database, like say you created a
>>> few customers, then it will not be affected.
>>>
>>
>
>
Re: StateList
Posted by Jacques Le Roux <ja...@les7arts.com>.
R.S.
Would you consider to add the data you created in a patch attached to a Jira?
http://cwiki.apache.org/confluence/x/JIB2
TIA
Jacques
PS : 2d try, that's why I use a tiny link here. It seems plain links (even from https://cwiki.apache.org/confluence/display) have
trouble to get through these last times...
From: "R. S." <ru...@meinkino.com>
> Great, Thanks. All the time I thought that "ant run-install" would remove my old data.
> You leave and Learn :-)
>
> Atul Vani schrieb:
>> Hi R.S.,
>>
>> Glad to know your work's done.
>>
>> Just wanted to let you know that "ant run-install" doesn't remove old data,
>> it just updates the data from data files.
>>
>> So if you have any new data in the database, like say you created a few customers, then it will not be affected.
>>
>
Re: StateList
Posted by "R. S." <ru...@meinkino.com>.
Great, Thanks. All the time I thought that "ant run-install" would
remove my old data.
You leave and Learn :-)
Atul Vani schrieb:
> Hi R.S.,
>
> Glad to know your work's done.
>
> Just wanted to let you know that "ant run-install" doesn't remove old
> data,
> it just updates the data from data files.
>
> So if you have any new data in the database, like say you created a
> few customers, then it will not be affected.
>
Re: StateList
Posted by Matt Warnock <mw...@ridgecrestherbals.com>.
However, it does seem to reset all the passwords to the install
defaults, which is important to know. At least that was my experience.
--
Matt Warnock <mw...@ridgecrestherbals.com>
RidgeCrest Herbals, Inc.
On Wed, 2010-06-02 at 15:08 +0530, Atul Vani wrote:
> Hi R.S.,
>
> Glad to know your work's done.
>
> Just wanted to let you know that "ant run-install" doesn't remove old data,
> it just updates the data from data files.
>
> So if you have any new data in the database, like say you created a few
> customers, then it will not be affected.
>
Re: StateList
Posted by Atul Vani <at...@hotwaxmedia.com>.
Hi R.S.,
Glad to know your work's done.
Just wanted to let you know that "ant run-install" doesn't remove old data,
it just updates the data from data files.
So if you have any new data in the database, like say you created a few
customers, then it will not be affected.
--
Thanks & Regards
Atul Vani
Enterprise Software Developer
HotWax Media Pvt. Ltd.
http://www.hotwaxmedia.com/
We are the Global Leaders in Apache OFBiz, Google 'ofbiz' and see for yourself.
R. S. wrote:
> I have already entered a lot of data and so I wanted not to run "run
> install". The use of the import function, was the best solution for
> me. Thank you.
>
> Best Regards
> Rudolf
>
>
> Atul Vani schrieb:
>> Hi R.S.,
>>
>> those steps were just another method of adding data to the database,
>> of course you don't need to that explicitly,
>> it's done automatically by "ant run-install" (or any other command
>> which loads seed data) if you have added the data to "GeoData_DE.xml"
>> (or may be you want to add it any other data file of your project,
>> just for the sake of not editing OOTB files)
Re: StateList
Posted by "R. S." <ru...@meinkino.com>.
I have already entered a lot of data and so I wanted not to run "run
install". The use of the import function, was the best solution for me.
Thank you.
Best Regards
Rudolf
Atul Vani schrieb:
> Hi R.S.,
>
> those steps were just another method of adding data to the database,
> of course you don't need to that explicitly,
> it's done automatically by "ant run-install" (or any other command
> which loads seed data) if you have added the data to "GeoData_DE.xml"
> (or may be you want to add it any other data file of your project,
> just for the sake of not editing OOTB files)
>
Re: StateList
Posted by Atul Vani <at...@hotwaxmedia.com>.
Hi R.S.,
those steps were just another method of adding data to the database,
of course you don't need to that explicitly,
it's done automatically by "ant run-install" (or any other command which
loads seed data) if you have added the data to "GeoData_DE.xml"
(or may be you want to add it any other data file of your project, just
for the sake of not editing OOTB files)
--
Thanks & Regards
Atul Vani
Enterprise Software Developer
HotWax Media Pvt. Ltd.
http://www.hotwaxmedia.com/
We are the Global Leaders in Apache OFBiz, Google 'ofbiz' and see for yourself.
R. S. wrote:
> Thank You, that works great. But what about the lines I added to the
> "dataGeoData_DE.xml" file? Will they only be loaded when I run an
> installation again?
>
> The link
> https://demo-stable.ofbiz.apache.org:8443/webtools/control/FindGeneric?entityName=GeoAssocAndGeoTo
>
>
> causes an error like
>
> org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
> [component://webtools/widget/EntityScreens.xml#FindGeneric]:
> org.ofbiz.base.util.GeneralException: Error running Groovy script at
> location
> [component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.groovy]
> ( ............
>
> Best Regards,
> Rudolf
>
>
> Atul Vani schrieb:
>> Hi R.S.,
>>
>> The deprecated warning is coz of "EntityExpr" you can use
>> "EntityCondition" instead.
>>
>> About GeoAssocAndGeoTo, rel-optional is not something that would be
>> of help here. and with just the data loaded properly it should show up.
>>
>> I tried it on demo-stable server and it works for me. you can verify
>> it from
>> https://demo-stable.ofbiz.apache.org:8443/webtools/control/FindGeneric?entityName=GeoAssocAndGeoTo
>>
>>
>>
>> just in case, if you need steps,
>> 1. goto https://localhost:8443/webtools/control/EntityImport
>> 2. paste the data below and hit 'Import Text button.
>>
>> <GeoAssoc geoId="DE" geoIdTo="DE-BW" geoAssocTypeId="REGIONS"/>
>> <GeoAssoc geoId="DE" geoIdTo="DE-BY" geoAssocTypeId="REGIONS"/>
>> <GeoAssoc geoId="DE" geoIdTo="DE-BE" geoAssocTypeId="REGIONS"/>
>> <GeoAssoc geoId="DE" geoIdTo="DE-BR" geoAssocTypeId="REGIONS"/>
>> <GeoAssoc geoId="DE" geoIdTo="DE-HB" geoAssocTypeId="REGIONS"/>
>> <GeoAssoc geoId="DE" geoIdTo="DE-HH" geoAssocTypeId="REGIONS"/>
>> <GeoAssoc geoId="DE" geoIdTo="DE-HE" geoAssocTypeId="REGIONS"/>
>> <GeoAssoc geoId="DE" geoIdTo="DE-MV" geoAssocTypeId="REGIONS"/>
>> <GeoAssoc geoId="DE" geoIdTo="DE-NI" geoAssocTypeId="REGIONS"/>
>> <GeoAssoc geoId="DE" geoIdTo="DE-NW" geoAssocTypeId="REGIONS"/>
>> <GeoAssoc geoId="DE" geoIdTo="DE-RP" geoAssocTypeId="REGIONS"/>
>> <GeoAssoc geoId="DE" geoIdTo="DE-SL" geoAssocTypeId="REGIONS"/>
>> <GeoAssoc geoId="DE" geoIdTo="DE-SH" geoAssocTypeId="REGIONS"/>
>> <GeoAssoc geoId="DE" geoIdTo="DE-SN" geoAssocTypeId="REGIONS"/>
>> <GeoAssoc geoId="DE" geoIdTo="DE-SA" geoAssocTypeId="REGIONS"/>
>> <GeoAssoc geoId="DE" geoIdTo="DE-TH" geoAssocTypeId="REGIONS"/>
>>
>> 3. verify the data from
>> https://localhost:8443/webtools/control/FindGeneric?entityName=GeoAssocAndGeoTo
>>
>>
Re: StateList
Posted by "R. S." <ru...@meinkino.com>.
Thank You, that works great. But what about the lines I added to the
"dataGeoData_DE.xml" file? Will they only be loaded when I run an
installation again?
The link
https://demo-stable.ofbiz.apache.org:8443/webtools/control/FindGeneric?entityName=GeoAssocAndGeoTo
causes an error like
org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
[component://webtools/widget/EntityScreens.xml#FindGeneric]:
org.ofbiz.base.util.GeneralException: Error running Groovy script at
location
[component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.groovy]
( ............
Best Regards,
Rudolf
Atul Vani schrieb:
> Hi R.S.,
>
> The deprecated warning is coz of "EntityExpr" you can use
> "EntityCondition" instead.
>
> About GeoAssocAndGeoTo, rel-optional is not something that would be of
> help here. and with just the data loaded properly it should show up.
>
> I tried it on demo-stable server and it works for me. you can verify
> it from
> https://demo-stable.ofbiz.apache.org:8443/webtools/control/FindGeneric?entityName=GeoAssocAndGeoTo
>
>
>
> just in case, if you need steps,
> 1. goto https://localhost:8443/webtools/control/EntityImport
> 2. paste the data below and hit 'Import Text button.
>
> <GeoAssoc geoId="DE" geoIdTo="DE-BW" geoAssocTypeId="REGIONS"/>
> <GeoAssoc geoId="DE" geoIdTo="DE-BY" geoAssocTypeId="REGIONS"/>
> <GeoAssoc geoId="DE" geoIdTo="DE-BE" geoAssocTypeId="REGIONS"/>
> <GeoAssoc geoId="DE" geoIdTo="DE-BR" geoAssocTypeId="REGIONS"/>
> <GeoAssoc geoId="DE" geoIdTo="DE-HB" geoAssocTypeId="REGIONS"/>
> <GeoAssoc geoId="DE" geoIdTo="DE-HH" geoAssocTypeId="REGIONS"/>
> <GeoAssoc geoId="DE" geoIdTo="DE-HE" geoAssocTypeId="REGIONS"/>
> <GeoAssoc geoId="DE" geoIdTo="DE-MV" geoAssocTypeId="REGIONS"/>
> <GeoAssoc geoId="DE" geoIdTo="DE-NI" geoAssocTypeId="REGIONS"/>
> <GeoAssoc geoId="DE" geoIdTo="DE-NW" geoAssocTypeId="REGIONS"/>
> <GeoAssoc geoId="DE" geoIdTo="DE-RP" geoAssocTypeId="REGIONS"/>
> <GeoAssoc geoId="DE" geoIdTo="DE-SL" geoAssocTypeId="REGIONS"/>
> <GeoAssoc geoId="DE" geoIdTo="DE-SH" geoAssocTypeId="REGIONS"/>
> <GeoAssoc geoId="DE" geoIdTo="DE-SN" geoAssocTypeId="REGIONS"/>
> <GeoAssoc geoId="DE" geoIdTo="DE-SA" geoAssocTypeId="REGIONS"/>
> <GeoAssoc geoId="DE" geoIdTo="DE-TH" geoAssocTypeId="REGIONS"/>
>
> 3. verify the data from
> https://localhost:8443/webtools/control/FindGeneric?entityName=GeoAssocAndGeoTo
>
>
Re: StateList
Posted by Atul Vani <at...@hotwaxmedia.com>.
Hi R.S.,
The deprecated warning is coz of "EntityExpr" you can use
"EntityCondition" instead.
About GeoAssocAndGeoTo, rel-optional is not something that would be of
help here. and with just the data loaded properly it should show up.
I tried it on demo-stable server and it works for me. you can verify it
from
https://demo-stable.ofbiz.apache.org:8443/webtools/control/FindGeneric?entityName=GeoAssocAndGeoTo
just in case, if you need steps,
1. goto https://localhost:8443/webtools/control/EntityImport
2. paste the data below and hit 'Import Text button.
<GeoAssoc geoId="DE" geoIdTo="DE-BW" geoAssocTypeId="REGIONS"/>
<GeoAssoc geoId="DE" geoIdTo="DE-BY" geoAssocTypeId="REGIONS"/>
<GeoAssoc geoId="DE" geoIdTo="DE-BE" geoAssocTypeId="REGIONS"/>
<GeoAssoc geoId="DE" geoIdTo="DE-BR" geoAssocTypeId="REGIONS"/>
<GeoAssoc geoId="DE" geoIdTo="DE-HB" geoAssocTypeId="REGIONS"/>
<GeoAssoc geoId="DE" geoIdTo="DE-HH" geoAssocTypeId="REGIONS"/>
<GeoAssoc geoId="DE" geoIdTo="DE-HE" geoAssocTypeId="REGIONS"/>
<GeoAssoc geoId="DE" geoIdTo="DE-MV" geoAssocTypeId="REGIONS"/>
<GeoAssoc geoId="DE" geoIdTo="DE-NI" geoAssocTypeId="REGIONS"/>
<GeoAssoc geoId="DE" geoIdTo="DE-NW" geoAssocTypeId="REGIONS"/>
<GeoAssoc geoId="DE" geoIdTo="DE-RP" geoAssocTypeId="REGIONS"/>
<GeoAssoc geoId="DE" geoIdTo="DE-SL" geoAssocTypeId="REGIONS"/>
<GeoAssoc geoId="DE" geoIdTo="DE-SH" geoAssocTypeId="REGIONS"/>
<GeoAssoc geoId="DE" geoIdTo="DE-SN" geoAssocTypeId="REGIONS"/>
<GeoAssoc geoId="DE" geoIdTo="DE-SA" geoAssocTypeId="REGIONS"/>
<GeoAssoc geoId="DE" geoIdTo="DE-TH" geoAssocTypeId="REGIONS"/>
3. verify the data from
https://localhost:8443/webtools/control/FindGeneric?entityName=GeoAssocAndGeoTo
--
Thanks & Regards
Atul Vani
Enterprise Software Developer
HotWax Media Pvt. Ltd.
http://www.hotwaxmedia.com/
We are the Global Leaders in Apache OFBiz, Google 'ofbiz' and see for yourself.
R. S. wrote:
> IMHO the Entity View uses an inner join and that is one of the reasons
> why all the 16 German states doesn't appear in this view.
> After I added <GeoAssoc geoId="DE" geoIdTo="DE-BW"
> geoAssocTypeId="REGIONS"/> (and other 15 states) to the
> "/framework/common/dataGeoData_DE.xml", rebuild and restart the
> server, nothing happend in the "GeoAssocAndGeoTo" Entity View. To do
> an outer join with "rel-optional="true"" brought also nothing. I don't
> know if it is a bug or my disability :-) Maybe I make something wrong.
> The other question is, why I get a deprecated warning after I add this
>
> "EntityCondition.makeCondition("geoTypeId", "STATE"), new
> EntityExpr("geoId", EntityOperator.LIKE, "DE-%"));"
>
> to CommonWorkers.java
>
> Best Regards,
> Rudolf
>
>
> Atul Vani schrieb:
>> Hi All,
>>
>> I wonder if the problem R.S. faced was actually a bug or done so
>> intentionally. If it's a mistake I would like to provide a patch and
>> get it fixed. Please share you opinions.
>>
Re: StateList
Posted by "R. S." <ru...@meinkino.com>.
IMHO the Entity View uses an inner join and that is one of the reasons
why all the 16 German states doesn't appear in this view.
After I added <GeoAssoc geoId="DE" geoIdTo="DE-BW"
geoAssocTypeId="REGIONS"/> (and other 15 states) to the
"/framework/common/dataGeoData_DE.xml", rebuild and restart the server,
nothing happend in the "GeoAssocAndGeoTo" Entity View. To do an outer
join with "rel-optional="true"" brought also nothing. I don't know if it
is a bug or my disability :-) Maybe I make something wrong.
The other question is, why I get a deprecated warning after I add this
"EntityCondition.makeCondition("geoTypeId", "STATE"), new
EntityExpr("geoId", EntityOperator.LIKE, "DE-%"));"
to CommonWorkers.java
Best Regards,
Rudolf
Atul Vani schrieb:
> Hi All,
>
> I wonder if the problem R.S. faced was actually a bug or done so
> intentionally. If it's a mistake I would like to provide a patch and
> get it fixed. Please share you opinions.
>
Re: StateList
Posted by Atul Vani <at...@hotwaxmedia.com>.
Hi All,
I wonder if the problem R.S. faced was actually a bug or done so
intentionally. If it's a mistake I would like to provide a patch and get
it fixed. Please share you opinions.
--
Thanks & Regards
Atul Vani
Enterprise Software Developer
HotWax Media Pvt. Ltd.
http://www.hotwaxmedia.com/
We are the Global Leaders in Apache OFBiz, Google 'ofbiz' and see for yourself.
R. S. wrote:
> Thank you Atul,
> sorry I don't have your mail read correctly. Now I know what you meant
> :-)
>
> Best Regards,
> Rudolf
>
>
>
> Atul Vani schrieb:
>> Hi R.S.,
>>
>> When you will add the data mentioned
>> and re-install the data (or you can also use webtools' import facility),
>> the view entity will get populated automatically :)
>>