[jira] [Created] (OFBIZ-4270) State dropdown only finds states and does not include country information

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
57 messages Options
123
Reply | Threaded
Open this post in threaded view
|

[jira] [Commented] (OFBIZ-4270) State dropdown only finds states and does not include county information

Nicolas Malin (Jira)

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

Adrian Crum commented on OFBIZ-4270:
------------------------------------

Let's wait and see if Scott has any ideas.


> State dropdown only finds states and does not include county information
> ------------------------------------------------------------------------
>
>                 Key: OFBIZ-4270
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4270
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: SVN trunk
>            Reporter: Sam Hamilton
>            Assignee: Sascha Rodekamp
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch
>
>
> If you are on this page https://demo-trunk.ofbiz.apache.org:8443/ecommerce/control/newcustomer select USA from the country drop down and it will display all the USA states, similarly it works just fine for Spain but if you try once again with either United Kingdom or France it will show "No States/Provinces exist".
> Both UK and France have Counties saved in the datamodel but the form does not lookup in the correct location as they are not defined as State.

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

       
Reply | Threaded
Open this post in threaded view
|

[jira] [Commented] (OFBIZ-4270) State dropdown only finds states and does not include county information

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

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

Jacques Le Roux commented on OFBIZ-4270:
----------------------------------------

Adrian's solution sounds indeed better than the ones we proposed so far.

> State dropdown only finds states and does not include county information
> ------------------------------------------------------------------------
>
>                 Key: OFBIZ-4270
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4270
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: SVN trunk
>            Reporter: Sam Hamilton
>            Assignee: Sascha Rodekamp
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch
>
>
> If you are on this page https://demo-trunk.ofbiz.apache.org:8443/ecommerce/control/newcustomer select USA from the country drop down and it will display all the USA states, similarly it works just fine for Spain but if you try once again with either United Kingdom or France it will show "No States/Provinces exist".
> Both UK and France have Counties saved in the datamodel but the form does not lookup in the correct location as they are not defined as State.

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

       
Reply | Threaded
Open this post in threaded view
|

[jira] [Reopened] (OFBIZ-4270) State dropdown only finds states and does not include county information

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

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

Sascha Rodekamp reopened OFBIZ-4270:
------------------------------------


> State dropdown only finds states and does not include county information
> ------------------------------------------------------------------------
>
>                 Key: OFBIZ-4270
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4270
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: SVN trunk
>            Reporter: Sam Hamilton
>            Assignee: Sascha Rodekamp
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch
>
>
> If you are on this page https://demo-trunk.ofbiz.apache.org:8443/ecommerce/control/newcustomer select USA from the country drop down and it will display all the USA states, similarly it works just fine for Spain but if you try once again with either United Kingdom or France it will show "No States/Provinces exist".
> Both UK and France have Counties saved in the datamodel but the form does not lookup in the correct location as they are not defined as State.

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

       
Reply | Threaded
Open this post in threaded view
|

[jira] [Updated] (OFBIZ-4270) State dropdown only finds states and does not include county information

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

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

Sascha Rodekamp updated OFBIZ-4270:
-----------------------------------

    Attachment: OFBIZ-4270-DependentDropdown.patch

Hey Adrian, hey Scott, hey Jacques, hey Sam

here are my changes as discussed above. I added a new AssocType and create new Assoc for the UI.

It would be great if you can give me a short feedback to the patch file, before i commit it.

Thanks and regards
Sascha


> State dropdown only finds states and does not include county information
> ------------------------------------------------------------------------
>
>                 Key: OFBIZ-4270
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4270
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: SVN trunk
>            Reporter: Sam Hamilton
>            Assignee: Sascha Rodekamp
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch
>
>
> If you are on this page https://demo-trunk.ofbiz.apache.org:8443/ecommerce/control/newcustomer select USA from the country drop down and it will display all the USA states, similarly it works just fine for Spain but if you try once again with either United Kingdom or France it will show "No States/Provinces exist".
> Both UK and France have Counties saved in the datamodel but the form does not lookup in the correct location as they are not defined as State.

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

       
Reply | Threaded
Open this post in threaded view
|

[jira] [Commented] (OFBIZ-4270) State dropdown only finds states and does not include county information

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

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

Adrian Crum commented on OFBIZ-4270:
------------------------------------

The Great Britain association looks backwards. Which brings up a good point: We need to agree on which way the association goes - country to state, or state-to-country.


> State dropdown only finds states and does not include county information
> ------------------------------------------------------------------------
>
>                 Key: OFBIZ-4270
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4270
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: SVN trunk
>            Reporter: Sam Hamilton
>            Assignee: Sascha Rodekamp
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch
>
>
> If you are on this page https://demo-trunk.ofbiz.apache.org:8443/ecommerce/control/newcustomer select USA from the country drop down and it will display all the USA states, similarly it works just fine for Spain but if you try once again with either United Kingdom or France it will show "No States/Provinces exist".
> Both UK and France have Counties saved in the datamodel but the form does not lookup in the correct location as they are not defined as State.

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

       
Reply | Threaded
Open this post in threaded view
|

[jira] [Commented] (OFBIZ-4270) State dropdown only finds states and does not include county information

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

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

Scott Gray commented on OFBIZ-4270:
-----------------------------------

With not go ahead with a supporting entity but make it something more like this:
CountryPostalAddressFormat (maybe something shorter haha)
- geoId (pk)
- stateProvinceGeoAssocTypeId (tells us what assocType to use to find valid states/provinces, null would hide the drop-down)
- requireStateProvinceId (if state/province records are found then selection of one is mandatory)
- requirePostalCode
- postalCodeRegex (?)
- hasPostalCodeExt
- requirePostalCodeExt
- ...


> State dropdown only finds states and does not include county information
> ------------------------------------------------------------------------
>
>                 Key: OFBIZ-4270
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4270
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: SVN trunk
>            Reporter: Sam Hamilton
>            Assignee: Sascha Rodekamp
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch
>
>
> If you are on this page https://demo-trunk.ofbiz.apache.org:8443/ecommerce/control/newcustomer select USA from the country drop down and it will display all the USA states, similarly it works just fine for Spain but if you try once again with either United Kingdom or France it will show "No States/Provinces exist".
> Both UK and France have Counties saved in the datamodel but the form does not lookup in the correct location as they are not defined as State.

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

       
Reply | Threaded
Open this post in threaded view
|

[jira] [Commented] (OFBIZ-4270) State dropdown only finds states and does not include county information

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

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

Scott Gray commented on OFBIZ-4270:
-----------------------------------

Correction, I meant "Why not go ahead..."

> State dropdown only finds states and does not include county information
> ------------------------------------------------------------------------
>
>                 Key: OFBIZ-4270
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4270
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: SVN trunk
>            Reporter: Sam Hamilton
>            Assignee: Sascha Rodekamp
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch
>
>
> If you are on this page https://demo-trunk.ofbiz.apache.org:8443/ecommerce/control/newcustomer select USA from the country drop down and it will display all the USA states, similarly it works just fine for Spain but if you try once again with either United Kingdom or France it will show "No States/Provinces exist".
> Both UK and France have Counties saved in the datamodel but the form does not lookup in the correct location as they are not defined as State.

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

       
Reply | Threaded
Open this post in threaded view
|

[jira] [Commented] (OFBIZ-4270) State dropdown only finds states and does not include county information

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

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

Sascha Rodekamp commented on OFBIZ-4270:
----------------------------------------

Hi Adrian i would prefer country-to-state. Because we get a country from the UI and determine the states.
GBR is defined as group of states which have countries. So why is the association backwards?

Hi Scott a few posts above we decided to use the existing data structures.
Your proposal covers more functionality (post code validation) when we plan to include this, i think it's a good idea to create a new table.

> State dropdown only finds states and does not include county information
> ------------------------------------------------------------------------
>
>                 Key: OFBIZ-4270
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4270
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: SVN trunk
>            Reporter: Sam Hamilton
>            Assignee: Sascha Rodekamp
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch
>
>
> If you are on this page https://demo-trunk.ofbiz.apache.org:8443/ecommerce/control/newcustomer select USA from the country drop down and it will display all the USA states, similarly it works just fine for Spain but if you try once again with either United Kingdom or France it will show "No States/Provinces exist".
> Both UK and France have Counties saved in the datamodel but the form does not lookup in the correct location as they are not defined as State.

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

       
Reply | Threaded
Open this post in threaded view
|

[jira] [Commented] (OFBIZ-4270) State dropdown only finds states and does not include county information

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

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

Scott Gray commented on OFBIZ-4270:
-----------------------------------

Yes I read those posts and that's why I decided to suggest an alternative.  Why not work towards a long term solution instead of applying a band-aid to the current problem at hand?  Step back from the tree and see the forest.

> State dropdown only finds states and does not include county information
> ------------------------------------------------------------------------
>
>                 Key: OFBIZ-4270
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4270
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: SVN trunk
>            Reporter: Sam Hamilton
>            Assignee: Sascha Rodekamp
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch
>
>
> If you are on this page https://demo-trunk.ofbiz.apache.org:8443/ecommerce/control/newcustomer select USA from the country drop down and it will display all the USA states, similarly it works just fine for Spain but if you try once again with either United Kingdom or France it will show "No States/Provinces exist".
> Both UK and France have Counties saved in the datamodel but the form does not lookup in the correct location as they are not defined as State.

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

       
Reply | Threaded
Open this post in threaded view
|

[jira] [Commented] (OFBIZ-4270) State dropdown only finds states and does not include county information

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

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

Sascha Rodekamp commented on OFBIZ-4270:
----------------------------------------

Ok Scott that's a valuable reason.

Beside the postal code validation, address formats in general comes to my mind.
http://en.wikipedia.org/wiki/Address_%28geography%29#Germany
http://www.bitboost.com/ref/international-address-formats.html

The new table could be a good place to store this information. (We have to agree on a good format for it).
Any additional ideas where the table could be used for?







> State dropdown only finds states and does not include county information
> ------------------------------------------------------------------------
>
>                 Key: OFBIZ-4270
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4270
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: SVN trunk
>            Reporter: Sam Hamilton
>            Assignee: Sascha Rodekamp
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch
>
>
> If you are on this page https://demo-trunk.ofbiz.apache.org:8443/ecommerce/control/newcustomer select USA from the country drop down and it will display all the USA states, similarly it works just fine for Spain but if you try once again with either United Kingdom or France it will show "No States/Provinces exist".
> Both UK and France have Counties saved in the datamodel but the form does not lookup in the correct location as they are not defined as State.

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

       
Reply | Threaded
Open this post in threaded view
|

[jira] [Updated] (OFBIZ-4270) State dropdown only finds states and does not include county information

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

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

Sascha Rodekamp updated OFBIZ-4270:
-----------------------------------

    Attachment: OFBIZ-4270-DependentDropdown.patch

Hi,

here is another proposal. I adopted Scotts idea and created another table with the proposed fields + an address format validation field.

What do you think is better keep my view-entity which maps the related fields or write a routine in java which determine the states?

Have a good day, Regards
Sascha

> State dropdown only finds states and does not include county information
> ------------------------------------------------------------------------
>
>                 Key: OFBIZ-4270
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4270
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: SVN trunk
>            Reporter: Sam Hamilton
>            Assignee: Sascha Rodekamp
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch
>
>
> If you are on this page https://demo-trunk.ofbiz.apache.org:8443/ecommerce/control/newcustomer select USA from the country drop down and it will display all the USA states, similarly it works just fine for Spain but if you try once again with either United Kingdom or France it will show "No States/Provinces exist".
> Both UK and France have Counties saved in the datamodel but the form does not lookup in the correct location as they are not defined as State.

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

       
Reply | Threaded
Open this post in threaded view
|

[jira] [Commented] (OFBIZ-4270) State dropdown only finds states and does not include county information

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

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

Adrian Crum commented on OFBIZ-4270:
------------------------------------

I have no comment on the approach taken, but I seem some problems in the patch. I believe some databases have a size limit for foreign key names, so you might need to fix that. Also, what is the purpose of the <CountryAddressFormat geoId="FRA"... > entry? It doesn't contain any meaningful data.


> State dropdown only finds states and does not include county information
> ------------------------------------------------------------------------
>
>                 Key: OFBIZ-4270
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4270
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: SVN trunk
>            Reporter: Sam Hamilton
>            Assignee: Sascha Rodekamp
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch
>
>
> If you are on this page https://demo-trunk.ofbiz.apache.org:8443/ecommerce/control/newcustomer select USA from the country drop down and it will display all the USA states, similarly it works just fine for Spain but if you try once again with either United Kingdom or France it will show "No States/Provinces exist".
> Both UK and France have Counties saved in the datamodel but the form does not lookup in the correct location as they are not defined as State.

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

       
Reply | Threaded
Open this post in threaded view
|

[jira] [Issue Comment Edited] (OFBIZ-4270) State dropdown only finds states and does not include county information

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

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

Adrian Crum edited comment on OFBIZ-4270 at 7/29/11 7:34 AM:
-------------------------------------------------------------

I have no comment on the approach taken, but I see some problems in the patch. I believe some databases have a size limit for foreign key names, so you might need to fix that. Also, what is the purpose of the <CountryAddressFormat geoId="FRA"... > entry? It doesn't contain any meaningful data.


      was (Author: [hidden email]):
    I have no comment on the approach taken, but I seem some problems in the patch. I believe some databases have a size limit for foreign key names, so you might need to fix that. Also, what is the purpose of the <CountryAddressFormat geoId="FRA"... > entry? It doesn't contain any meaningful data.

 

> State dropdown only finds states and does not include county information
> ------------------------------------------------------------------------
>
>                 Key: OFBIZ-4270
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4270
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: SVN trunk
>            Reporter: Sam Hamilton
>            Assignee: Sascha Rodekamp
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch
>
>
> If you are on this page https://demo-trunk.ofbiz.apache.org:8443/ecommerce/control/newcustomer select USA from the country drop down and it will display all the USA states, similarly it works just fine for Spain but if you try once again with either United Kingdom or France it will show "No States/Provinces exist".
> Both UK and France have Counties saved in the datamodel but the form does not lookup in the correct location as they are not defined as State.

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

       
Reply | Threaded
Open this post in threaded view
|

[jira] [Commented] (OFBIZ-4270) State dropdown only finds states and does not include county information

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

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

Sascha Rodekamp commented on OFBIZ-4270:
----------------------------------------

Hi Adrian

"believe some databases have a size limit for foreign key names": Ok i will fix that.

France is simply an example how countries should handled where states should be shown in the drop down list. I have to fill up the other fields like postalCodeRegex etc. but the interesting point is set stateProvinceGeoAssocTypeId to null (or leave it empty).

Cheers
Sascha

> State dropdown only finds states and does not include county information
> ------------------------------------------------------------------------
>
>                 Key: OFBIZ-4270
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4270
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: SVN trunk
>            Reporter: Sam Hamilton
>            Assignee: Sascha Rodekamp
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch
>
>
> If you are on this page https://demo-trunk.ofbiz.apache.org:8443/ecommerce/control/newcustomer select USA from the country drop down and it will display all the USA states, similarly it works just fine for Spain but if you try once again with either United Kingdom or France it will show "No States/Provinces exist".
> Both UK and France have Counties saved in the datamodel but the form does not lookup in the correct location as they are not defined as State.

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

       
Reply | Threaded
Open this post in threaded view
|

[jira] [Closed] (OFBIZ-4270) State dropdown only finds states and does not include county information

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

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

Sascha Rodekamp closed OFBIZ-4270.
----------------------------------

    Resolution: Fixed

New version is in Trunk @Rev1153402

> State dropdown only finds states and does not include county information
> ------------------------------------------------------------------------
>
>                 Key: OFBIZ-4270
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4270
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: SVN trunk
>            Reporter: Sam Hamilton
>            Assignee: Sascha Rodekamp
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch
>
>
> If you are on this page https://demo-trunk.ofbiz.apache.org:8443/ecommerce/control/newcustomer select USA from the country drop down and it will display all the USA states, similarly it works just fine for Spain but if you try once again with either United Kingdom or France it will show "No States/Provinces exist".
> Both UK and France have Counties saved in the datamodel but the form does not lookup in the correct location as they are not defined as State.

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

       
Reply | Threaded
Open this post in threaded view
|

[jira] [Commented] (OFBIZ-4270) State dropdown only finds states and does not include county information

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

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

Sam Hamilton commented on OFBIZ-4270:
-------------------------------------

Many thanks everyone!

> State dropdown only finds states and does not include county information
> ------------------------------------------------------------------------
>
>                 Key: OFBIZ-4270
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4270
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: SVN trunk
>            Reporter: Sam Hamilton
>            Assignee: Sascha Rodekamp
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch
>
>
> If you are on this page https://demo-trunk.ofbiz.apache.org:8443/ecommerce/control/newcustomer select USA from the country drop down and it will display all the USA states, similarly it works just fine for Spain but if you try once again with either United Kingdom or France it will show "No States/Provinces exist".
> Both UK and France have Counties saved in the datamodel but the form does not lookup in the correct location as they are not defined as State.

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

       
Reply | Threaded
Open this post in threaded view
|

[jira] [Commented] (OFBIZ-4270) State dropdown only finds states and does not include county information

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

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

Leon commented on OFBIZ-4270:
-----------------------------

Some info related to this commit, pls see OFBIZ-4376

> State dropdown only finds states and does not include county information
> ------------------------------------------------------------------------
>
>                 Key: OFBIZ-4270
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4270
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: SVN trunk
>            Reporter: Sam Hamilton
>            Assignee: Sascha Rodekamp
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch, OFBIZ-4270-DependentDropdown.patch
>
>
> If you are on this page https://demo-trunk.ofbiz.apache.org:8443/ecommerce/control/newcustomer select USA from the country drop down and it will display all the USA states, similarly it works just fine for Spain but if you try once again with either United Kingdom or France it will show "No States/Provinces exist".
> Both UK and France have Counties saved in the datamodel but the form does not lookup in the correct location as they are not defined as State.

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

       
123