Develop service provider directory for drupal

[tmitchell]

Gupteshwar has pulled something together, perhaps he can track his progress here.

[gupteshwar]

SPD on test.osgeo.net is ready, working towards delegation (edit profile).

[warmerdam]

SPD project definition is at:

​http://wiki.osgeo.org/index.php/Service_Provider_Directory

Gupteshwar, please add links here to different components when you are ready for some testing and comment.

[gupteshwar]

I have setup the the application for testing with the test server. UID problem might be there as the application was running with the MySQL UID and now it with LDAP UID. So you may need to create profile once again. I faced this problem and unable to get problem with it's behavior of restricting me from editing profile. Now it's ready.

​http://test.osgeo.net/profile_submit.php ​http://test.osgeo.net/profile_search.php.

will back with delegation solution soon.

[warmerdam]

Some feedback:

"Search"

• I find the "Show All" vs. "Options" selector clunky. Can we not assume all if no criteria are selected, and to use any criteria that are selected?

• I'd like to see a "no service provider identified meeting your search criteria" or something like that if a search returns nothing.

• I think the Search page needs a better title, and some explanation of what it is about.

• When I hover over a link in the results list on the search page it shows up as: ​http://test.osgeo.net/profile_search.php# but if I click on it, a new page is opened in a seperate window. Why is that? Why not make this a conventional link and let people use normal mechanisms to open it in a distinct window or tab as they wish? I hate these sorts of non-standard navigation.

• Would it make sense to try and put the selection boxes side by side? Perhaps this would not

really work very well due to space considerations?

"Edit Profile"

• Missing the lat/long.

"Submit Business Profile"

• I think the latitude and longitude should be labelled, and an indication given that they are in decimal degrees and should use negatives for "west" and "south".

• The submission page needs a mechanism to request new entries be added to the Languages, Country and Technologies list even if it is just an email address for a maintainer for now (ie. info@…).

• I think the title "submit business profile" should be "Submit Business Profile", or better yet "Submit Service Provider Profile".

• "What country are you located in?" should be "What countries do you have support offices in?"

• "What languages do you speak/write?" should be "What languages do you provide support in?"

• We need more explanatory text about the purpose and approach of the create profile page.

I've asked Tyler for content priveledges on the test server and will try to update some of the simple text myself.

Once we have been through this round of updates we should open this up for comment from WebCom.

[warmerdam]

One more thing, the edit dialog should have a way of removing the profile entirely. We will also need a way for administrators to edit or remove profiles if deemed inappropriate. How would this be accomplished?

[tmitchell]

I have installed taxonomy_access module as requested on both test and live server.

[gupteshwar]

Replying to warmerdam:

Some feedback:

"Search"

• I find the "Show All" vs. "Options" selector clunky. Can we not assume all if no criteria are selected, and to use any criteria that are selected? ----done

• I'd like to see a "no service provider identified meeting your search criteria" or something like that if a search returns nothing. ----done

• I think the Search page needs a better title, and some explanation of what it is about. ---done

• When I hover over a link in the results list on the search page it shows up as: ​http://test.osgeo.net/profile_search.php# but if I click on it, a new page is opened in a seperate window. Why is that? Why not make this a conventional link and let people use normal mechanisms to open it in a distinct window or tab as they wish? I hate these sorts of non-standard navigation. ----done

• Would it make sense to try and put the selection boxes side by side? Perhaps this would not

really work very well due to space considerations? ----done

"Edit Profile"

• Missing the lat/long. ---done

"Submit Business Profile"

• I think the latitude and longitude should be labelled, and an indication given that they are in decimal degrees and should use negatives for "west" and "south". ----done

• The submission page needs a mechanism to request new entries be added to the Languages, Country and Technologies list even if it is just an email address for a maintainer for now (ie. info@…). ----done (with the help of Taxonomy module integration)

• I think the title "submit business profile" should be "Submit Business Profile", or better yet "Submit Service Provider Profile". ----done

• "What country are you located in?" should be "What countries do you have support offices in?"

---done

• "What languages do you speak/write?" should be "What languages do you provide support in?"

----done

• We need more explanatory text about the purpose and approach of the create profile page.

-----done

I've asked Tyler for content priveledges on the test server and will try to update some of the simple text myself.

Once we have been through this round of updates we should open this up for comment from WebCom.

• TAXONOMY module is required (need to be installed so working copy can be uploaded.)

[gupteshwar]

New changes has been uploaded with test.osgeo.net Containing following links 1 submit_profile.php 2 search_profile.php -> directs to edit_profile.php

Modification is going on with search profile as it's pagination based on self script which is to replace with in built drupal module . (Which already delayed the uploading, so uploaded as it is working). Suggestions are welcome.

Regards Gupteshwar Joshi.

[warmerdam]

Links for use:

​http://test.osgeo.net/search_profile.php

​http://test.osgeo.net/submit_profile.php

Things seem to be working pretty well. I'm not fond of launching new windows for the profile editing, but I can live with that for now. How does the system decide to populate the "Delegate" list? It doesn't seem like this will scale well when the LDAP has thousands of userids.

Is there any reason we shouldn't ask webcom and others for feedback on the application? I would like to deploy it within a few days on the main server, and start soliciting real entries soon.

[gupteshwar.joshi@…]

Hello all, I have uploaded new search page on test.osgeo.net/spd_search.php for Service Provider Directory modified using drupal modules. Though it is working but not completed.For which I need some help. I require new module called panels for delegation list autocompletion in the edit page So , I can finish out the uploading make it available for user testing.

Regards Gupteshwar Joshi

[warmerdam]

Gupteshwar,

Could we skip autocompletion, and just people type stuff in to avoid the panels requirement? I don't like adding too many requirements as it is likely to complicate future upgrades.

We *should* verify that the entered id is valid.

[gupteshwar]

Frank, Skipping the auto completion or listing user will also do. As it will make application easier and whoever wants to delegate should be knowing to whomever he is handing over so there is no as such issue in it.

I will make appropriate changes and make it available ASAP.

Regards

[warmerdam]

Gupteshwar,

Sounds good ... keep us informed when it is ready for wider testing.

[gupteshwar]

Hello All, I have made the changes with the application.And now it is ready for user testing. links in applications are test.osgeo.net/submit_profile.php test.osgeo.net/search_profile.php which internally relates to test.osgeo.net/edit_profile.php for editing and deleting also.

I request all the concerned members should go through this and suggest anything they find as problem both in terms of implementation and working.

Waiting for your replies (Specially problems/suggetions).

Regards Gupteshwar Joshi

[warmerdam]

I have updated the wiki topic somewhat, and posted a request to webcom for review.

[arnulf]

• I get a warning when trying to submit. Admittedly our official company name has an ampersand in it.

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'N,7.0707E,'​http://www.wheregroup.com ','00001','00008','00012 00014 00015 00016 0' at line 1 query: INSERT INTO business_profile (ID,MODIFIER,ENTRY_TIME,MODIFIED,B_NAME,NO_OF_EMP,LATITUDE,LONGITUDE,WEB_SITE,COUNTRY,LANGUAGE,TECHNOLOGY) values ('23','23',1176997206,1176997206,'WhereGroup GmbH & Co. KG',20,50.7342N,7.0707E,'​http://www.wheregroup.com ','00001','00008','00012 00014 00015 00016 00018') in /var/www/html/includes/database.mysql.inc on line 121.

• maybe we could change this to use prepared statements? in the end this is PHP and MySQl... :-)
• It should be easy to identify who submitted the entry, for example by adding the user name who submitted the entry

[jbirch]

If the user does not enter a website, it inserts a blank hyperlink, which some browsers interpret as a link to ​http://www.osgeo.org/ . If there is no url, then the anchor tag should not be generated.

Of course, I'm not sure why a user would not enter a website, since this is the only real contact method we provide...

[gupteshwar]

I have already encorporated this thing with application. I need to debug out. I expect some mistake there. I will let you know when I finished.

[gupteshwar]

Problem resolved. No link will appear for the business name who haven't provided the website link.

[tmitchell]

Closing, as we have something working fine now.