Importing Listings - Top Docs

May 18th we imported the 'Top Docs 2001' for Philly. Here is the file that Tim delivered to us: File:PM top docs 2010 for web.xls.

This is what we had do to:

• Save the Excel file as a Tab Delimited text file.
• Upload to the www.metrocorp/scripts/import/ folder.
• Modify the doc_import.php file appropriately.
• The categories with Ampersands "&" in the category name didnt import properly. So i created a new script called doc_import_missing_categories.php to make those associations. Adjust this file and execute.
• The search_index script needs to run to get this data in to the site_index table and the appropriate DB Views.
• Adjust the local/classes/Modules/TopDocs_Advanced.class appropriately to use the correct display year for the results.