The project requires knowledge of Perl, Catalyst, Fast-CGI, HTML, MySQL. The site is a business directory, now in it's 9th year. The directory currently focuses on a very limited geographic area. Users choose a city, then a category, then a sub category to view listings on that category. This project involves four (4) main changes:
1. Add the ability to expand the geographic area by adding states and cities i.e. change the users experience from choosing city then category then sub category, to instead choosing STATE first, then city/category/subcategory. This will involve coding the site to first display STATES rather than first displaying cities, and then display cities after the user chooses a state.
2. Change existing categories and their associated ID numbers to different categories with DIFFERENT ID numbers to be provided (import a list of new categories and associated id numbers).
3. Create a function to import new listings from CSV file into the MySQL database for use by the site.
4. Add the ability for customers to insert a VIDEO LINK (WITH THUMBNAIL VIEW OF VIDEO) to their listing. Ideally this will automatically create a thumbnail of the user's video from their off-site video link and insert the video into their listing in the directory. If it is not possibe to automatically create a thumbnail of an offsite video then it will be necessary to add the ability to instead add a thumbnail IMAGE linking to a video.