IPMCenters.org national site

Different pages listing URLs/contact info for state IPM resources use different tables in different tables. 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.

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.]

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

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.