Importing Listings - Top Docs
From Boston Magazine Wiki
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.