[Webcom] Service Provider Fix/Upgrade

[Frank Warmerdam]

Folks,

Good news!  Digging around in that backup I found the contents of node/326.
 I'll try to figure out how to reincorporate it tonight.

Best regards,
Frank



On Tue, Jul 30, 2013 at 1:49 PM, Frank Warmerdam <warmerdam at pobox.com>wrote:

> Ian,
>
> Sorry, I'm not sure.   I don't see any of the old backup stuff I vaguely
> recall from years ago when I tried to be involved in osgeo1 backups now in
> /root or root's "crontab -l" output.
>
> I do see a backup in /root/MySQL-Dumps/ that might be helpful.  It is from
> Jan 5, 2013.  I'm guessing this was before the last attempt at a drupal
> migration?
>
> Hmm, I'm going to dig around a bit in that and see if I can find something
> helpful.
>
> Best regards,
> Frank
>
>
>
> On Tue, Jul 30, 2013 at 1:29 PM, Ian Edwards <iedwards.pub at gmail.com>wrote:
>
>> Okay - I've read the ticket now. I did see this go past a few weeks ago
>> (but back then it was someone else's problem!)
>>
>> Frank - do we have database backups anywhere? - it's real easy to pull
>> the missing code from the backup. We need a backup from before
>> 2013-01-21...
>>
>>
>> On Tue, Jul 30, 2013 at 9:11 PM, Frank Warmerdam <warmerdam at pobox.com>wrote:
>>
>>> For the sake of completeness, I'm copying this reply from Ian here:
>>>
>>> """
>>>
>>> Hi Adam,
>>>
>>> If we throw away what we currently have and start from scratch then I agree
>>> that views would be the obvious way to go.
>>>
>>> As far as I can see, your suggestion doesn't allow an institution to log in
>>> and edit their own profile - instead someone with the correct role can edit
>>> all 'service provider' nodes?
>>>
>>> Is your plan for migrating the exiting profile information to cut and
>>> paste?  We'd then remove the old pages and allow external search engines to
>>> reindex?
>>>
>>> The new guidelines would be to contact WebCom to get pages added or updated?
>>>
>>> I haven't had a proper look, but the custom PHP code does not look that
>>> complicated - but it's proper legacy code and presumably would require live
>>> editing and testing to fix.  I also don't currently understand our LDAP
>>> integration.  I'm happy to test and document what we currently have and
>>> suggest a fix. It's obvious that we'll need to replace this at some stage
>>> in the future, but that probably applies to many other areas of the site
>>> and we'll want approach any redesign in a well thought our and consistent
>>> way.
>>>
>>> Ian
>>>
>>> """
>>>
>>>
>>>
>>> On Tue, Jul 30, 2013 at 11:37 AM, Frank Warmerdam <warmerdam at pobox.com>wrote:
>>>
>>>> Folks,
>>>>
>>>> I'm opening a new thread to discuss Adam Włodarkiewicz's suggested plan
>>>> to fix the Service Provider Directory which is currently broken due to the
>>>> mysterious loss of a page of PHP code, described in:
>>>>
>>>>   http://trac.osgeo.org/osgeo/ticket/1105
>>>>
>>>> Adam has suggested:
>>>> """
>>>> I propose introducing a 'service provider' content type. This would
>>>> give it
>>>> the advantage of customizable permissions and easy integration with
>>>> views
>>>> among other Drupal goodness. Permissions can be configured to give
>>>> editing
>>>> rights not just to osgeo.org maintainers, but any user with the correct
>>>> role (again, configurable in Drupal). Such role can be given to users
>>>> who
>>>> are representatives of the service providers. Views module allows
>>>> creation
>>>> of different kinds of lists and displays of content. A list containing
>>>> only
>>>> the service provider content type would be trivial to create, much like
>>>> creating filters to limit the list to only service provider from a given
>>>> country, etc. Further more, this filter can be exposed to the user (for
>>>> example as a select box) and ajax can be used to refresh the list. As
>>>> far
>>>> as I understand, this pretty much covers the current functionality and
>>>> more, in addition to being drupalish. All of the above mentioned
>>>> configuration can be done via clicking in the administration menu.
>>>>
>>>> Importing existing entries can be easily done via a proper import
>>>> module,
>>>> assuming it would not be too difficult to export the current data in,
>>>> for
>>>> example, csv format.
>>>> """
>>>>
>>>> I'm slightly concerned that the filtering may be more clumsy than the
>>>> service provider directory.  Adam, can you point me at something similar
>>>> done with Drupal so I have a sense of what it might look like and
>>>> interact
>>>> like?
>>>>
>>>> I will note that the existing service provider directory is in a mysql
>>>> table
>>>> - the same one as the drupal content.
>>>>
>>>> Ian has also expressed interest in helping with this issue - Ian, do you
>>>> have thoughts on this approach?
>>>>
>>>> Personally, it sounds pretty good to me.  I'm wondering if it is
>>>> something
>>>> we could start prototyping on Drupal now and just not link to it from
>>>> anywhere prominent on the web site.  If there are no immediate concerns
>>>> I would be interesting in starting an experiment on this new content
>>>> type
>>>> and filtering interaction and could arrange appropriate access for Adam.
>>>> Perhaps a motion covering the experiment would be appropriate to
>>>> gauge support.  I'd also include adding Adam to Webcom.
>>>>
>>>> Best regards,
>>>> --
>>>>
>>>> ---------------------------------------+--------------------------------------
>>>> I set the clouds in motion - turn up   | Frank Warmerdam,
>>>> warmerdam at pobox.com
>>>> light and sound - activate the windows | http://pobox.com/~warmerdam
>>>> and watch the world go round - Rush    | Geospatial Software Developer
>>>>
>>>
>>>
>>>
>>> --
>>>
>>> ---------------------------------------+--------------------------------------
>>> I set the clouds in motion - turn up   | Frank Warmerdam,
>>> warmerdam at pobox.com
>>> light and sound - activate the windows | http://pobox.com/~warmerdam
>>> and watch the world go round - Rush    | Geospatial Software Developer
>>>
>>
>>
>
>
> --
>
> ---------------------------------------+--------------------------------------
> I set the clouds in motion - turn up   | Frank Warmerdam,
> warmerdam at pobox.com
> light and sound - activate the windows | http://pobox.com/~warmerdam
> and watch the world go round - Rush    | Geospatial Software Developer
>



-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam,
warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Software Developer