Creating a folder archive from a database

Discussion in 'Programming' started by bexisgod, Jun 23, 2008.

  1. #1
    I am currently attempting to create a page where users are able to access minutes from previous meetings for different departments but am unsure where to start.

    The general structure I want is to display the different departments as the parent folder, then when expanded it will show the next level of folders (a list of years that have meetings taken place), once the specific year folder is expanded it will then show folders for all the different meeting dates for that year. Finally, once the user has selected the specific meeting date, the folder will expand to show the minutes document for that meeting and be able to open/download it.

    I have all the information in a database named CommitteesMeetings that has the following fields:

    CommitteeDisplayName (varchar) - This is just the title I want displayed as the parent folder
    YearDisplayName (varchar) - Again the way the year is to be displayed to the user
    MeetingDisplayName (date) - The way the meeting date should be displayed to the user
    CommitteeID (int) - The specific ID for each department
    MeetingID (int) - The specific ID for each different meeting
    CommitteeFolder (varchar) - The name of the parent folder where the data is saved
    YearFolder (varchar) - The year the meeting has taken place (NOTE: this is not a real folder, but is generated from the date of the meeting)
    MeetingFolder (varchar) - This is the actual sub-folder to CommitteeFolder where all the different meetings have their own folder for the date the meeting took place and the actual minutes are inside this folder.

    NOTE: There is not a field with each individual document name

    Do I need another table to define what the document type is? 90% (if not all of them) are Word documents.

    I hope someone can help as I've been trying to work on a function for this for a couple days now with no joy! :(
     
    bexisgod, Jun 23, 2008 IP