Ron Dorman | 26 Aug 04:59
Favicon

Re: Country - State/Province - Attribute Select Options Defined by Previous Attribute Select???

Gary wrote:
> Ron Dorman wrote:
>>
>>     * the current db tables have no cross referencing of Country to
>>       State/Province to City
>>     * the attribute selects are available as 'send to' criteria that
>>       needs to be retained
>>     * if I go hacking on this, I will probably break something
>>
>> What I am not aware is what really concerns me.
>
>
> I would not do this by making combo fields, make country, state, and 
> city plain old text fields from PHPList's perspective.  It won't care 
> what you stick in them[It might make sense to make country a select 
> field]
>
> Then all you have to do is change the input forms people use to have 
> those fields pull data from a second database.
>
> So for PHPList, you store United States as US, and your select field 
> would send US when United States is selected.
>
> Next, I would suggest /not/ making State/Province and City a select 
> field.  Eventually you will run into something not in your database.  
> Instead use Ajax and make them type ahead fields.
>
> So, for example, I have selected the country United States and then I 
> type "N" in the state field.  Type ahead drop down shows me the 
> options "New York" "New Jersey" "Nebraska" etc. 
(Continue reading)

Ron Dorman | 26 Aug 05:27
Favicon

Re: Country - State/Province - Attribute Select Options Defined by Previous Attribute Select???

Mike Gifford wrote:
Michiel Dethmers wrote:
That sounds like an interesting thing to add. It would be quite some data to pull together: all cities, in all states/provinces of all countries in the world. If you manage to get a list like that, that would be amazing. Maybe they are available somewhere, I've never looked for it. Tricky issue will be to keep it up-to-date. Alternatively you would make that an editors' choice, ie let them do the work to get the data together and just provide them an interface (or simply some triple-nested-array-config) to provide the data.
Would be an interesting application. Much of the data is already here and available: http://www.geonames.org/ I'd see something like a country select box (which is easy to pull off of here): http://openconcept.ca/blog/mgifford/text_list_all_countries And then a fancy ajax form to query the geonames database to allow folks to fill in some, but have the form auto fill in the rest. Would be a nice contribution, but it does sound like time that someone should be paid for to develop this kind of highly customized feature. Mike

I agree with it being an interesting application and that needed data is available for free (geonames, ISO, etc.), and that payment for development is in order.

There are third party providers that deliver this functionality down to the street address level, for a price.

What can we do to provide 'no bells and whistles' basic functionality in an open source package? Thereby allowing bells and whistles to paid for while making phpList the leader in global list delivery with the basic functionality.

Ron D.



_______________________________________________
Phplist-developers mailing list
Phplist-developers <at> tincan.co.uk
http://mail.tincan.co.uk/mailman/listinfo/phplist-developers
Ron Dorman | 26 Aug 05:34
Favicon

Re: Country - State/Province - Attribute Select Options Defined by Previous Attribute Select???

Ron Dorman wrote:
Greetings to All,

I am new to this list and joined because I have a need, and I think my need can be contributed back to phpList and the community.

I have dug around in the forums for a couple of hours and possibly missed what I am needing, so will gladly take a rebuke and pointer to an existing solution that I have missed.

One of my clients has been running phplist for about a year. We originally created select attributes for the Country and for the State/Province of the subscriber, populating the select options lists with the phpList provided defaults. Their subscriber base is expanding and we need to add all the Countries, State/Provinces and Cities of the world. This is easy enough to do with available ISO data downloads. But ...

The feature the client wants is:
  1. a Country select with all countries of the world
  2. a State/Province select with only the States/Provinces within the previously selected Country
  3. a City select within the previously selected Country and State/Province
While this functionality has become popular in several web applications and sites, and existing code could be adapted, I am not yet familiar enough with the phpList code base and db tables to handle this enhancement on my own and seek help.

What I am aware of is:
  • attribute selects are user definable
    • a country select may need to be available without dependencies
    • a state/province select may need to be available without dependencies
    • a City select may need to be available without dependencies
    • there may be a need for dependencies of none or all of the above
  • the current db tables have no cross referencing of Country to State/Province to City
  • the attribute selects are available as 'send to' criteria that needs to be retained
  • if I go hacking on this, I will probably break something
What I am not aware is what really concerns me.

What I am hoping for is 1 or more people that are interested in working on such an enhancement for the community.

I have a delivery time line of 2 months. If this cannot be accomplished as a community project within that time line, I am prepared to contract capable people to get it done.

Thank you,
Ron D.


My client is wanting project estimates to make this happen within a month and a half.

Where and how should  I request estimates/quotes for this functionality?
Can development costs be shared by multiple interested parties?
Is Tincan willing to foot some of the bill?

I thank you all for the responses and look forward to what they create.

Ron D.
-- Ron Dorman Simply Digital Technologies www.simplydigtech.net rwd <at> simplydigtech.net 817-503-7704 ofc 817-503-7719 fax
_______________________________________________
Phplist-developers mailing list
Phplist-developers <at> tincan.co.uk
http://mail.tincan.co.uk/mailman/listinfo/phplist-developers
Michiel Dethmers | 26 Aug 14:24
Picon
Favicon

mailinglist changes


Hi All,

Over the weekend we've moved the mailinglists to a new server, and we've 
dropped qmail/ezmlm and are now working with postfix/mailman

The new location for subscription management is 
http://mail.tincan.co.uk/mailman/listinfo/phplist-developers/

--

-- 
Michiel

--
Michiel Dethmers
Tincan Limited
London, Buenos Aires & Machynlleth
Tel: +44 (0)1654 702413
Email: michiel <at> tincan.co.uk
pgp: http://tincan.co.uk/michiel.asc

_______________________________________________
Phplist-developers mailing list
Phplist-developers <at> tincan.co.uk
http://mail.tincan.co.uk/mailman/listinfo/phplist-developers

Michiel Dethmers | 26 Aug 14:48
Picon
Favicon

Re: Country - State/Province - Attribute Select Options Defined by Previous Attribute Select???


I'm afraid I'm currently too busy to take it on, but I'd happily assist in creating the system, preferably via this list. I'll be travelling for the next 5 weeks, so my availability will be limited.

Michiel

Ron Dorman wrote:
Ron Dorman wrote:
Greetings to All,

I am new to this list and joined because I have a need, and I think my need can be contributed back to phpList and the community.

I have dug around in the forums for a couple of hours and possibly missed what I am needing, so will gladly take a rebuke and pointer to an existing solution that I have missed.

One of my clients has been running phplist for about a year. We originally created select attributes for the Country and for the State/Province of the subscriber, populating the select options lists with the phpList provided defaults. Their subscriber base is expanding and we need to add all the Countries, State/Provinces and Cities of the world. This is easy enough to do with available ISO data downloads. But ...

The feature the client wants is:
  1. a Country select with all countries of the world
  2. a State/Province select with only the States/Provinces within the previously selected Country
  3. a City select within the previously selected Country and State/Province
While this functionality has become popular in several web applications and sites, and existing code could be adapted, I am not yet familiar enough with the phpList code base and db tables to handle this enhancement on my own and seek help.

What I am aware of is:
  • attribute selects are user definable
    • a country select may need to be available without dependencies
    • a state/province select may need to be available without dependencies
    • a City select may need to be available without dependencies
    • there may be a need for dependencies of none or all of the above
  • the current db tables have no cross referencing of Country to State/Province to City
  • the attribute selects are available as 'send to' criteria that needs to be retained
  • if I go hacking on this, I will probably break something
What I am not aware is what really concerns me.

What I am hoping for is 1 or more people that are interested in working on such an enhancement for the community.

I have a delivery time line of 2 months. If this cannot be accomplished as a community project within that time line, I am prepared to contract capable people to get it done.

Thank you,
Ron D.


My client is wanting project estimates to make this happen within a month and a half.

Where and how should  I request estimates/quotes for this functionality?
Can development costs be shared by multiple interested parties?
Is Tincan willing to foot some of the bill?

I thank you all for the responses and look forward to what they create.

Ron D.
-- Ron Dorman Simply Digital Technologies www.simplydigtech.net rwd <at> simplydigtech.net 817-503-7704 ofc 817-503-7719 fax _______________________________________________ Phplist-developers mailing list Phplist-developers <at> tincan.co.uk http://mail.tincan.co.uk/mailman/listinfo/phplist-developers

-- Michiel -- Michiel Dethmers Tincan Limited London, Buenos Aires & Machynlleth Tel: +44 (0)1654 702413 Email: michiel <at> tincan.co.uk pgp: http://tincan.co.uk/michiel.asc
_______________________________________________
Phplist-developers mailing list
Phplist-developers <at> tincan.co.uk
http://mail.tincan.co.uk/mailman/listinfo/phplist-developers

Gmane