Bug #2063
Updated by Alex Belskis over 10 years ago
Different pages listing URLs/contact info for state IPM resources use different tables in different tables. One table can be edited via an admin interface but the other has no way to edit it.
h1. SORTING OUT CONTACTS DATABASES
Looks like there are two parallel tables with corresponding pages; but only one has an admin interface. Should transfer data from the obsolete table to the functional one and eliminate the obsolete output page, linking instead to the functional page.
h2. Obsolete table:
[pmCenters].[dbo].[IPMHomepages]
DSN: pmcenters
Data from this table is output by one file in ipmcenters.org and several files in sripmc.org.
No edit interface exists.
References:
I:\www_CIPMCF8-1\wwwroot\ipmcenters_org\Producers\homepages\findstate.cfm
[IPM in the US > State IPM Programs]
[Click a state]
[To view info for all states, change URL paramater to ?state=]
I:\www_CIPMCF8-1\wwwroot\sripmc.org\ExtSearch\ipm_states.cfm
[unused, to be deleted]
I:\www_CIPMCF8-1\wwwroot\sripmc.org\IPMContacts\IPMInfo.cfm
[Pulls from same web service as ipm_states.cfm (csrees.cfc), but is not otherwise linked to anything.]
I:\www_CIPMCF8-1\wwwroot\sripmc.org\ipm_states.cfm
[Scroll to bottom of home page and click a linked state abbreviation.]
h2. Functional table:
[contacts].[dbo].[tblwebsites]
DSN: CSREESContacts
No references exist outside of ipmcenters.org.
Both input and output interfaces exist.
References:
I:\www_CIPMCF8-1\wwwroot\ipmcenters_org\Contacts\IPMdirectory.cfm
I:\www_CIPMCF8-1\wwwroot\ipmcenters_org\Contacts\PSEPdirectory.cfm
I:\www_CIPMCF8-1\wwwroot\ipmcenters_org\Internal\Contacts\admin\deleteURLs.cfm
I:\www_CIPMCF8-1\wwwroot\ipmcenters_org\Internal\Contacts\admin\editurls.cfm
I:\www_CIPMCF8-1\wwwroot\ipmcenters_org\Internal\Contacts\admin\editurls1.cfm
I:\www_CIPMCF8-1\wwwroot\ipmcenters_org\Internal\Contacts\admin\editurls2.cfm
I:\www_CIPMCF8-1\wwwroot\ipmcenters_org\Internal\Contacts\IPMdirectory.cfm
I:\www_CIPMCF8-1\wwwroot\ipmcenters_org\Internal\Contacts\PSEPdirectory.cfm
I:\www_CIPMCF8-1\wwwroot\ipmcenters_org\Intranet\directories\IPMdirectory.cfm
I:\www_CIPMCF8-1\wwwroot\ipmcenters_org\Intranet\directories\PSEPdirectory.cfm
h2. TO DO:
* Add comments to sripmc.org pages noting use of an obsolete table. Perhaps create a Redmine issue to update them to use functional table. There might already be a Redmine issue or Outlook to-do item.
* Review ipmcenters.org/Producers/homepages/findstate.cfm, see if it can be simply replaced with a link to one of the other ipmcenters.org pages such as ipmcenters.org/Contacts/IPMdirectory.cfm.
* Transfer data from IPMHomepages table to tblWebsites table.
* See if SRIPMC.org pages can be converted to use the functional table.