Knowledge Base enhancements

Hello Coders. This job represents some enhancments to a pretty simple Knowledge Base application written in ASP/SQL Server 2000. The existing application can be found here [login to view URL] ## Deliverables | [][1]kb enhancement: suggestion words not working terribly well. Search for 'enhance', the Knob will suggest 'enhancement' but the link will not work. Other substrings don’t return results at all. ? [][1]kb enhancement: search is not picking up 'parts of words' very well for example searching for 'keyword' will no pick up 'keywords'. ? [][1]kb enhancement: need to be able to edit user details (password, email, mobile etc) ? [][1]kb enhancement: after a question, show the number of records returned if it is more than 1'. Subsequent records should be numbered. E.g. answer #1…. Answer #2 ? [][1]KB enhancement: have an input box able to edit data that you request. E.g. have each record returned in separate text boxes which can be edited an updated in the same page. Perhaps each record returned in the comment history could be a separate input box with an edit button next to it. ? kb enhancement: username should just be users registered email address. Usernames are not required. ? kb enhancement: [][1]forgot password routine required for users who have forgotten their password or email address. ? kb enhancement: [][1]push ‘enter’ button to login on front page and to submit/ask questions. Must also work in Firefox/mozilla ? [][1]kb enhancement: the session seems to be timing out. The window can only be left open for 10-20 minutes before subsequent questions/comments fail. This is possibly because database connections are not being closed. Users need to be able to keep the window open and usable for days at a time. ? [][1]kb enhancement: the code needs to be browser neutral. Its does not work with Firefox. ? [][1]kb enhancement: tell the user how many characters they have used in the input box in real time so that we can warn them if the text is too long for sms functionality. Keep a character number counter on the screen. Also need an alert for over 8000 characters (too big for database). ? [][1]kb enhancement: all URL’s should come up in the answer as a clickable hyperlink e.g. ‘[login to view URL]'. ? ? [][1]kb enhancement: have a development blog and news streams that can be updatable by admins through the main interface. Each item with certain keywords entered, e.g. “Knob News?? will be automatically included in a list of news items available from a ‘news’ link on the front page. ? kb enhancement: Need to be able to upload, store and retrieve files through the interface. The KNoB will also provide a link for users to retrieve the files when they are searched for. E.g. download the XYZ word file?? or “give me the ABC document??. ? [][1]kb enhancement: when you first log on show welcome to the knob and then show the user their 10 most popular keywords with search links'. ? [][1]kb enhancement: different levels of access (paid, free, introductory etc) allow different privileges. e.g. sms functionality, XL file export, sms query and comment, shared information etc ? [][1]kb enhancement: Auto login for users using cookies. ? [][1]kb enhancement: need users to agree to a registration agreement when registering ? [][1]KB enhancement: remind user about events when they want them. e.g. 'John's birthday is 27/12/65. Remind me on 20/12'. Reminders should display in the user chat window as well as email and SMS where required. The KNoB already has email and SMS gateways. ? [][1]kb enhancement: email or SMS on command. E.g send an email to <john@[login to view URL]> ‘John smith 'I'm home, see you soon’ or [][1]kb enhancement: 'email me everything you have about xyz'. Note that the SMS integration with the software has already been set up. ? [][1]kb enhancement: share certain data with central system repository which only has admin access. this will allow the KnoB to respond to specific questions e.g. 'who are you?’. What is the knob? Etc So an administrator will be able to log in and tell the system information, That information will then be common to all user knowledge bases. ? [][1]KB enhancement: We need a separate area as an administration panel with total rows of data, number of users registered, number of questions and how the data is increased on a weekly basis so that admins can compare data on a week to week basis and plot usage. ? KB enhancement: Store the IP of the registrations so that we can determine country of ID etc. ? [][1]KB enhancement: need to maintain bullet points, paragraphs etc in the database.' ? [][1]KB enhancement: Set focus back to entry box so you can type in info hit enter and type next into etc. remove linefeed characters from end of input. ' ? [][1]KB enhancement: Ability to export all data to XL and order it by the users choice …e.g chronologically, alphabetically. This should be available from the main interface e.g. “export all my phone numbers?? or “send the KB enhancement to Excel?? or “Send my wish list to XL.?? We must also capture keywords “to a file?? or “CSV?? or spreadsheet etc. Or “export all my data to Excel.?? ? KB enhancement: Need to be able to upload existing data in CSV, EXCEL format. This data would be loaded directly into SQL Server so that it can be accessed later through the main interface. The user would ask to upload a data file through the main interface and then a window would pop up so that user can find the file they want to upload. ? [][1]KB enhancement: able to delete or edit individual pieces of data that are returned. ? [][1]kb enhancement: question marks inside the sentence should be catered for. also inside URL's' ? [][1]kb enhancement: facility to delete data input immediately after entering it. E.g it should appear in a text box in the ‘conversation’ window and be eligible for immediate deletion. ? [][1]kb enhancement: no blank fields to the database ? [][1]KB enhancement: change password functionality through the interface ? [][1]KB enhancement: Download the spreadsheets in a new window using the interface! Also download spreadsheets based on the query. E.g. 'download all contacts'' ? [][1]KB Enhancement: Typing ‘enter’ in the window messes with the question. ? [][1]KB enhancement: Cater for SQL injection attacks ? [][1]KB enhancement: deleted data still shows up in hyperlinked guesses to data. ? [][1]KB enhancement: store a flow of conversation rather than just one question and answer. Keep the last 10 questions. ? [][1]kb enhancement: change the green text to black for question and answer conversation history.' ? [][1]kb enhancement: timeout problem. We don't want to have to log in when the server times out every time. ? [][1]KB enhancement: interface with search engine if is answer not found. |