https://wiki.cs.earlham.edu/api.php?action=feedcontributions&user=Bogatjo&feedformat=atom Earlham CS Department - User contributions [en] 2024-03-28T12:40:04Z User contributions MediaWiki 1.32.1 https://wiki.cs.earlham.edu/index.php?title=WebDev&diff=1581 WebDev 2006-04-03T14:34:40Z <p>Bogatjo: /* The Courses Project (Outdated)*/</p> <hr /> <div>==Content Administration Group==<br /> All the current issues we are working with, or are on our to do list.<br /> ----<br /> ==AlumniDB==<br /> <br /> Features to add:<br /> &lt;ul&gt;&lt;li&gt;Ability to view internships currently being offered by alumni(all)&lt;/li&gt;<br /> &lt;li&gt;View of all alumni who are willing to be contacted for job opportunites and the like from current students(all)&lt;/li&gt;<br /> &lt;li&gt;Admin Functionality<br /> &lt;ul&gt;&lt;li&gt;Ability to change user type&lt;/li&gt;<br /> &lt;li&gt;*BETA TEST MODE*Add new functions to the data base. UPDATE:3/12/2006: This looks like it is working, but it has not been tested extensively. PLEASE ONLY USE FOR REAL FUNCTIONS as everything gets added to the DB. There is no code to check and make sure the functionality is in place.&lt;/li&gt;<br /> &lt;li&gt;Speaking of which. Write an additional function to check to see if the function the admin is trying to add exists.&lt;/li&gt;<br /> &lt;/ul&gt;&lt;/li&gt;<br /> &lt;li&gt;Write a function (put in common.inc) which returns a users type. This should be determined based on information in the DB and grad year (ex: someone who is not an admin and has not graduated yet is a current student)&lt;/li&gt;<br /> &lt;li&gt;Can't log in from the successful log out screen. Takes to main alumniDB page instead, even when user/pass is incorrect. 'request=' in address bar.&lt;/li&gt;<br /> &lt;/ul&gt;<br /> <br /> --[[User:Weissto|Tom]] 17:12, 2 Mar 2006 (EST)<br /> <br /> ----<br /> <br /> ==ToDo==<br /> &lt;ul&gt;&lt;li&gt;Continue to Report CVS bugs....( all )&lt;/li&gt;<br /> &lt;li&gt;Validate our XHTML and CSS and links( all )&lt;/li&gt;<br /> &lt;li&gt;Install the W3C Log Validator to automate the above task..(CS Admins working on this)&lt;/li&gt;<br /> &lt;li&gt;Replace center tags with something valid XHTML/CSS (Jon)<br /> Update 03/08/06: This sort of spawned another project... The CSS is a bit lengthy so I'm also looking into tightening the CSS in general a bit. (Jon) &lt;/li&gt;<br /> &lt;li&gt;Get feedback from the rest of the CS Department about AlumniDB&lt;/li&gt;<br /> &lt;li&gt;Fix everything under /html/courses it is all out of date. Part of this is getting the XML feed working and the other part is organizing old course folders and the like. (Jon)<br /> Update 03/08/06: I just wrapped up debugging the XSL transforms for the feed, so that gnome on my back has been shot after many hours of frustrated gnome-wrangling. Now it looks like another two weeks and I'll hopefully be able to have a tangible product in place for dynamic fetching of the course list. (Jon)&lt;/li&gt;<br /> &lt;li&gt;Fix our mail to system (possibly data base driven php? )&lt;/li&gt;<br /> &lt;/ul&gt;<br /> <br /> ==The Courses Project (outdated)==<br /> <br /> ''The information on this project is outdated and is for the most part in need of rather serious revision. A direction for how to implement this has been chosen and work progresses steadily, it is at this point a very easy task, depending on a few external factors. In any event, use the below information only as historical reference.'' --[[User:Bogatjo|Jon]] 09:34, 3 Apr 2006 (EST)<br /> <br /> Since I'm (albeit slowly) approaching the programming phase I thought maybe an opened discourse would be useful about my plans for making the course list dynamic.<br /> For efficiency's sake there's really no need to continually be parsing what will be pretty much a static XML feed from WebDB. So what I thought was we'll throw a perlscript in the Courses sub-directory and execute it from crontab every semester or so... It can pull in the XML, apply the XSL transform, and generate the course list.<br /> Dynamic, but not wasteful, is what I'm aiming for.<br /> Thoughts?<br /> <br /> Last updated [[User:bogatjo|Jon]] 23:56, 8 Mar 2006 (EST)<br /> <br /> <br /> It might make more sense to put the perl script into the cgi-bin, just to help keep the file structure as clean and organized as possible...<br /> --[[User:Weissto|Tom]] 16:51, 12 Mar 2006 (EST)<br /> <br /> <br /> Well, theoretically I should be able to add to the cgi-bin CVS module, I'll throw it in there when I get back to Indiana. Somehow I lost my ability to tunnel through Quark with SSH to my desktop so the XML parser'll have to wait for implementation until after Spring Break. <br /> <br /> We need to come up with a location for cache.html; the generated HTML course list which'll live as cache for the perlscript. We also need to deal with $recache; the variable which indicates after what period new content should be generated. And, finally, we need to determine whether it is necessary to generate an MD5 sum of the cache to check for validity; otherwise it'd be damned easy for somebody to inject an SSI into cache.html which calls God Knows What.<br /> <br /> One thought I had was generating cache.html from the XML parser and then chucking it into the Content database, which if I recall was just brought into existence. We can throw it in along with an MD5 sum of the page and when it was cached, hell we can even create an archive kind of deal where we keep old caches and let people browse 'em for historical purposes or for predicting what courses could be offered in the future, somewhat like what's there now.<br /> <br /> [[User:bogatjo|Jon]] 16:09, 21 Mar 2006 (EST)<br /> <br /> <br /> Okay, Jim brought up in an e-mail that it would be more efficient to have the perlscript run at a specific time through I imagine a Crontab, instead of through an SSI. I think that I want to avoid Crontab so what I'm going to is suggest that we use the Perlscript we have but instead of SSI we run with AJAX.<br /> What I think should happen is that in the Courses page we have an iframe linked to the cached generated course content. That way the user at least sees something when he or she enters, and odds are it'll never be that far off.<br /> In the background, JavaScript should call the Perlscript and send as its GET variable the result of querying through the document object module cache.html's document.lastModified variable; then the Perlscript can check that against the current date and time, and then use that to determine whether to regenerate the cache.<br /> In any case, the Perlscript will send back either the word &quot;refresh&quot; or &quot;norefresh&quot; and that can be evaluated to determine whether to refresh the iframe.<br /> <br /> AJAX allows us to offload the processing to the background; I think it should be considered instead of Crontabs. I'm going to start looking at the feasibility of implementing this, unless anybody has any objections to raise on the matter...<br /> <br /> [[User:bogatjo|Jon]] 14:05, 25 Mar 2006 (EST)<br /> ----<br /> <br /> ==Fixed Problems==<br /> <br /> &lt;ul&gt;<br /> &lt;li&gt;Register function for AlumniDB is broken.&lt;/li&gt;<br /> &lt;li&gt; Revert to yourself function is broken. Get a 404 error and your stuck as the new user until you relogin.&lt;/li&gt;<br /> &lt;li&gt;Fix AlumniDB admin function changeuser to show the info of the user that was switched to instead of admin's info on the 'view my info' page.&lt;/li&gt;<br /> &lt;li&gt;Ability to create an email list of all current alumni (admin only)&lt;/li&gt;<br /> &lt;li&gt;Revert function is broken again, in a different way though. When reverting from a user who isn't admin, the revert function serves up error.php&lt;/li&gt;<br /> <br /> &lt;/ul&gt;</div> Bogatjo https://wiki.cs.earlham.edu/index.php?title=WebDev&diff=1485 WebDev 2006-03-25T19:06:28Z <p>Bogatjo: /* The Courses Project */</p> <hr /> <div>==Content Administration Group==<br /> All the current issues we are working with, or are on our to do list.<br /> ----<br /> ==AlumniDB==<br /> <br /> Features to add:<br /> &lt;ul&gt;&lt;li&gt;Ability to view internships currently being offered by alumni(all)&lt;/li&gt;<br /> &lt;li&gt;View of all alumni who are willing to be contacted for job opportunites and the like from current students(all)&lt;/li&gt;<br /> &lt;li&gt;Admin Functionality<br /> &lt;ul&gt;&lt;li&gt;Ability to change user type&lt;/li&gt;<br /> &lt;li&gt;*BETA TEST MODE*Add new functions to the data base. UPDATE:3/12/2006: This looks like it is working, but it has not been tested extensively. PLEASE ONLY USE FOR REAL FUNCTIONS as everything gets added to the DB. There is no code to check and make sure the functionality is in place.&lt;/li&gt;<br /> &lt;li&gt;Speaking of which. Write an additional function to check to see if the function the admin is trying to add exists.&lt;/li&gt;<br /> &lt;/ul&gt;&lt;/li&gt;<br /> &lt;li&gt;Write a function (put in common.inc) which returns a users type. This should be determined based on information in the DB and grad year (ex: someone who is not an admin and has not graduated yet is a current student)&lt;/li&gt;<br /> &lt;li&gt;Can't log in from the successful log out screen. Takes to main alumniDB page instead, even when user/pass is incorrect. 'request=' in address bar.&lt;/li&gt;<br /> &lt;/ul&gt;<br /> <br /> --[[User:Weissto|Tom]] 17:12, 2 Mar 2006 (EST)<br /> <br /> ----<br /> <br /> ==ToDo==<br /> &lt;ul&gt;&lt;li&gt;Continue to Report CVS bugs....( all )&lt;/li&gt;<br /> &lt;li&gt;Validate our XHTML and CSS and links( all )&lt;/li&gt;<br /> &lt;li&gt;Install the W3C Log Validator to automate the above task..(CS Admins working on this)&lt;/li&gt;<br /> &lt;li&gt;Replace center tags with something valid XHTML/CSS (Jon)<br /> Update 03/08/06: This sort of spawned another project... The CSS is a bit lengthy so I'm also looking into tightening the CSS in general a bit. (Jon) &lt;/li&gt;<br /> &lt;li&gt;Get feedback from the rest of the CS Department about AlumniDB&lt;/li&gt;<br /> &lt;li&gt;Fix everything under /html/courses it is all out of date. Part of this is getting the XML feed working and the other part is organizing old course folders and the like. (Jon)<br /> Update 03/08/06: I just wrapped up debugging the XSL transforms for the feed, so that gnome on my back has been shot after many hours of frustrated gnome-wrangling. Now it looks like another two weeks and I'll hopefully be able to have a tangible product in place for dynamic fetching of the course list. (Jon)&lt;/li&gt;<br /> &lt;li&gt;Fix our mail to system (possibly data base driven php? )&lt;/li&gt;<br /> &lt;/ul&gt;<br /> <br /> ==The Courses Project==<br /> <br /> Since I'm (albeit slowly) approaching the programming phase I thought maybe an opened discourse would be useful about my plans for making the course list dynamic.<br /> For efficiency's sake there's really no need to continually be parsing what will be pretty much a static XML feed from WebDB. So what I thought was we'll throw a perlscript in the Courses sub-directory and execute it from crontab every semester or so... It can pull in the XML, apply the XSL transform, and generate the course list.<br /> Dynamic, but not wasteful, is what I'm aiming for.<br /> Thoughts?<br /> <br /> Last updated [[User:bogatjo|Jon]] 23:56, 8 Mar 2006 (EST)<br /> <br /> <br /> It might make more sense to put the perl script into the cgi-bin, just to help keep the file structure as clean and organized as possible...<br /> --[[User:Weissto|Tom]] 16:51, 12 Mar 2006 (EST)<br /> <br /> <br /> Well, theoretically I should be able to add to the cgi-bin CVS module, I'll throw it in there when I get back to Indiana. Somehow I lost my ability to tunnel through Quark with SSH to my desktop so the XML parser'll have to wait for implementation until after Spring Break. <br /> <br /> We need to come up with a location for cache.html; the generated HTML course list which'll live as cache for the perlscript. We also need to deal with $recache; the variable which indicates after what period new content should be generated. And, finally, we need to determine whether it is necessary to generate an MD5 sum of the cache to check for validity; otherwise it'd be damned easy for somebody to inject an SSI into cache.html which calls God Knows What.<br /> <br /> One thought I had was generating cache.html from the XML parser and then chucking it into the Content database, which if I recall was just brought into existence. We can throw it in along with an MD5 sum of the page and when it was cached, hell we can even create an archive kind of deal where we keep old caches and let people browse 'em for historical purposes or for predicting what courses could be offered in the future, somewhat like what's there now.<br /> <br /> [[User:bogatjo|Jon]] 16:09, 21 Mar 2006 (EST)<br /> <br /> <br /> Okay, Jim brought up in an e-mail that it would be more efficient to have the perlscript run at a specific time through I imagine a Crontab, instead of through an SSI. I think that I want to avoid Crontab so what I'm going to is suggest that we use the Perlscript we have but instead of SSI we run with AJAX.<br /> What I think should happen is that in the Courses page we have an iframe linked to the cached generated course content. That way the user at least sees something when he or she enters, and odds are it'll never be that far off.<br /> In the background, JavaScript should call the Perlscript and send as its GET variable the result of querying through the document object module cache.html's document.lastModified variable; then the Perlscript can check that against the current date and time, and then use that to determine whether to regenerate the cache.<br /> In any case, the Perlscript will send back either the word &quot;refresh&quot; or &quot;norefresh&quot; and that can be evaluated to determine whether to refresh the iframe.<br /> <br /> AJAX allows us to offload the processing to the background; I think it should be considered instead of Crontabs. I'm going to start looking at the feasibility of implementing this, unless anybody has any objections to raise on the matter...<br /> <br /> [[User:bogatjo|Jon]] 14:05, 25 Mar 2006 (EST)<br /> <br /> ----<br /> <br /> ==Fixed Problems==<br /> <br /> &lt;ul&gt;<br /> &lt;li&gt;Register function for AlumniDB is broken.&lt;/li&gt;<br /> &lt;li&gt; Revert to yourself function is broken. Get a 404 error and your stuck as the new user until you relogin.&lt;/li&gt;<br /> &lt;li&gt;Fix AlumniDB admin function changeuser to show the info of the user that was switched to instead of admin's info on the 'view my info' page.&lt;/li&gt;<br /> &lt;li&gt;Ability to create an email list of all current alumni (admin only)&lt;/li&gt;<br /> &lt;li&gt;Revert function is broken again, in a different way though. When reverting from a user who isn't admin, the revert function serves up error.php&lt;/li&gt;<br /> <br /> &lt;/ul&gt;</div> Bogatjo https://wiki.cs.earlham.edu/index.php?title=WebDev&diff=1408 WebDev 2006-03-25T19:05:54Z <p>Bogatjo: /* The Courses Project */</p> <hr /> <div>==Content Administration Group==<br /> All the current issues we are working with, or are on our to do list.<br /> ----<br /> ==AlumniDB==<br /> <br /> Features to add:<br /> &lt;ul&gt;&lt;li&gt;Ability to view internships currently being offered by alumni(all)&lt;/li&gt;<br /> &lt;li&gt;View of all alumni who are willing to be contacted for job opportunites and the like from current students(all)&lt;/li&gt;<br /> &lt;li&gt;Admin Functionality<br /> &lt;ul&gt;&lt;li&gt;Ability to change user type&lt;/li&gt;<br /> &lt;li&gt;*BETA TEST MODE*Add new functions to the data base. UPDATE:3/12/2006: This looks like it is working, but it has not been tested extensively. PLEASE ONLY USE FOR REAL FUNCTIONS as everything gets added to the DB. There is no code to check and make sure the functionality is in place.&lt;/li&gt;<br /> &lt;li&gt;Speaking of which. Write an additional function to check to see if the function the admin is trying to add exists.&lt;/li&gt;<br /> &lt;/ul&gt;&lt;/li&gt;<br /> &lt;li&gt;Write a function (put in common.inc) which returns a users type. This should be determined based on information in the DB and grad year (ex: someone who is not an admin and has not graduated yet is a current student)&lt;/li&gt;<br /> &lt;li&gt;Can't log in from the successful log out screen. Takes to main alumniDB page instead, even when user/pass is incorrect. 'request=' in address bar.&lt;/li&gt;<br /> &lt;/ul&gt;<br /> <br /> --[[User:Weissto|Tom]] 17:12, 2 Mar 2006 (EST)<br /> <br /> ----<br /> <br /> ==ToDo==<br /> &lt;ul&gt;&lt;li&gt;Continue to Report CVS bugs....( all )&lt;/li&gt;<br /> &lt;li&gt;Validate our XHTML and CSS and links( all )&lt;/li&gt;<br /> &lt;li&gt;Install the W3C Log Validator to automate the above task..(CS Admins working on this)&lt;/li&gt;<br /> &lt;li&gt;Replace center tags with something valid XHTML/CSS (Jon)<br /> Update 03/08/06: This sort of spawned another project... The CSS is a bit lengthy so I'm also looking into tightening the CSS in general a bit. (Jon) &lt;/li&gt;<br /> &lt;li&gt;Get feedback from the rest of the CS Department about AlumniDB&lt;/li&gt;<br /> &lt;li&gt;Fix everything under /html/courses it is all out of date. Part of this is getting the XML feed working and the other part is organizing old course folders and the like. (Jon)<br /> Update 03/08/06: I just wrapped up debugging the XSL transforms for the feed, so that gnome on my back has been shot after many hours of frustrated gnome-wrangling. Now it looks like another two weeks and I'll hopefully be able to have a tangible product in place for dynamic fetching of the course list. (Jon)&lt;/li&gt;<br /> &lt;li&gt;Fix our mail to system (possibly data base driven php? )&lt;/li&gt;<br /> &lt;/ul&gt;<br /> <br /> ==The Courses Project==<br /> <br /> Since I'm (albeit slowly) approaching the programming phase I thought maybe an opened discourse would be useful about my plans for making the course list dynamic.<br /> For efficiency's sake there's really no need to continually be parsing what will be pretty much a static XML feed from WebDB. So what I thought was we'll throw a perlscript in the Courses sub-directory and execute it from crontab every semester or so... It can pull in the XML, apply the XSL transform, and generate the course list.<br /> Dynamic, but not wasteful, is what I'm aiming for.<br /> Thoughts?<br /> <br /> Last updated [[User:bogatjo|Jon]] 23:56, 8 Mar 2006 (EST)<br /> <br /> <br /> It might make more sense to put the perl script into the cgi-bin, just to help keep the file structure as clean and organized as possible...<br /> --[[User:Weissto|Tom]] 16:51, 12 Mar 2006 (EST)<br /> <br /> <br /> Well, theoretically I should be able to add to the cgi-bin CVS module, I'll throw it in there when I get back to Indiana. Somehow I lost my ability to tunnel through Quark with SSH to my desktop so the XML parser'll have to wait for implementation until after Spring Break. <br /> <br /> We need to come up with a location for cache.html; the generated HTML course list which'll live as cache for the perlscript. We also need to deal with $recache; the variable which indicates after what period new content should be generated. And, finally, we need to determine whether it is necessary to generate an MD5 sum of the cache to check for validity; otherwise it'd be damned easy for somebody to inject an SSI into cache.html which calls God Knows What.<br /> <br /> One thought I had was generating cache.html from the XML parser and then chucking it into the Content database, which if I recall was just brought into existence. We can throw it in along with an MD5 sum of the page and when it was cached, hell we can even create an archive kind of deal where we keep old caches and let people browse 'em for historical purposes or for predicting what courses could be offered in the future, somewhat like what's there now.<br /> <br /> [[User:bogatjo|Jon]] 16:09, 21 Mar 2006 (EST)<br /> <br /> <br /> Okay, Jim brought up in an e-mail that it would be more efficient to have the perlscript run at a specific time through I imagine a Crontab, instead of through an SSI. I think that I want to avoid Crontab so what I'm going to is suggest that we use the Perlscript we have but instead of SSI we run with AJAX.<br /> What I think should happen is that in the Courses page we have an iframe linked to the cached generated course content. That way the user at least sees something when he or she enters, and odds are it'll never be that far off.<br /> In the background, JavaScript should call the Perlscript and send as its GET variable the result of querying through the document object module cache.html's document.lastModified variable; then the Perlscript can check that against the current date and time, and then use that to determine whether to regenerate the cache.<br /> In any case, the Perlscript will send back either the word &quot;refresh&quot; or &quot;norefresh&quot; and that can be evaluated to determine whether to refresh the iframe.<br /> <br /> AJAX allows us to offload the processing to the background; I think it should be considered instead of Crontabs. I'm going to start looking at the feasibility of implementing this, unless anybody has any objections to raise on the matter...<br /> <br /> [[User:bogatjo[Jon]] 14:05, 25 Mar 2006 (EST)<br /> <br /> ----<br /> <br /> ==Fixed Problems==<br /> <br /> &lt;ul&gt;<br /> &lt;li&gt;Register function for AlumniDB is broken.&lt;/li&gt;<br /> &lt;li&gt; Revert to yourself function is broken. Get a 404 error and your stuck as the new user until you relogin.&lt;/li&gt;<br /> &lt;li&gt;Fix AlumniDB admin function changeuser to show the info of the user that was switched to instead of admin's info on the 'view my info' page.&lt;/li&gt;<br /> &lt;li&gt;Ability to create an email list of all current alumni (admin only)&lt;/li&gt;<br /> &lt;li&gt;Revert function is broken again, in a different way though. When reverting from a user who isn't admin, the revert function serves up error.php&lt;/li&gt;<br /> <br /> &lt;/ul&gt;</div> Bogatjo https://wiki.cs.earlham.edu/index.php?title=WebDev&diff=1407 WebDev 2006-03-21T21:09:51Z <p>Bogatjo: /* The Courses Project */</p> <hr /> <div>==Content Administration Group==<br /> All the current issues we are working with, or are on our to do list.<br /> ----<br /> ==AlumniDB==<br /> <br /> Features to add:<br /> &lt;ul&gt;&lt;li&gt;Ability to view internships currently being offered by alumni(all)&lt;/li&gt;<br /> &lt;li&gt;View of all alumni who are willing to be contacted for job opportunites and the like from current students(all)&lt;/li&gt;<br /> &lt;li&gt;Admin Functionality<br /> &lt;ul&gt;&lt;li&gt;Ability to change user type&lt;/li&gt;<br /> &lt;li&gt;*BETA TEST MODE*Add new functions to the data base. UPDATE:3/12/2006: This looks like it is working, but it has not been tested extensively. PLEASE ONLY USE FOR REAL FUNCTIONS as everything gets added to the DB. There is no code to check and make sure the functionality is in place.&lt;/li&gt;<br /> &lt;li&gt;Speaking of which. Write an additional function to check to see if the function the admin is trying to add exists.&lt;/li&gt;<br /> &lt;/ul&gt;&lt;/li&gt;<br /> &lt;li&gt;Write a function (put in common.inc) which returns a users type. This should be determined based on information in the DB and grad year (ex: someone who is not an admin and has not graduated yet is a current student)&lt;/li&gt;<br /> &lt;li&gt;Can't log in from the successful log out screen. Takes to main alumniDB page instead, even when user/pass is incorrect. 'request=' in address bar.&lt;/li&gt;<br /> &lt;/ul&gt;<br /> <br /> --[[User:Weissto|Tom]] 17:12, 2 Mar 2006 (EST)<br /> <br /> ----<br /> <br /> ==ToDo==<br /> &lt;ul&gt;&lt;li&gt;Continue to Report CVS bugs....( all )&lt;/li&gt;<br /> &lt;li&gt;Validate our XHTML and CSS and links( all )&lt;/li&gt;<br /> &lt;li&gt;Install the W3C Log Validator to automate the above task..(CS Admins working on this)&lt;/li&gt;<br /> &lt;li&gt;Replace center tags with something valid XHTML/CSS (Jon)<br /> Update 03/08/06: This sort of spawned another project... The CSS is a bit lengthy so I'm also looking into tightening the CSS in general a bit. (Jon) &lt;/li&gt;<br /> &lt;li&gt;Get feedback from the rest of the CS Department about AlumniDB&lt;/li&gt;<br /> &lt;li&gt;Fix everything under /html/courses it is all out of date. Part of this is getting the XML feed working and the other part is organizing old course folders and the like. (Jon)<br /> Update 03/08/06: I just wrapped up debugging the XSL transforms for the feed, so that gnome on my back has been shot after many hours of frustrated gnome-wrangling. Now it looks like another two weeks and I'll hopefully be able to have a tangible product in place for dynamic fetching of the course list. (Jon)&lt;/li&gt;<br /> &lt;li&gt;Fix our mail to system (possibly data base driven php? )&lt;/li&gt;<br /> &lt;/ul&gt;<br /> <br /> ==The Courses Project==<br /> <br /> Since I'm (albeit slowly) approaching the programming phase I thought maybe an opened discourse would be useful about my plans for making the course list dynamic.<br /> For efficiency's sake there's really no need to continually be parsing what will be pretty much a static XML feed from WebDB. So what I thought was we'll throw a perlscript in the Courses sub-directory and execute it from crontab every semester or so... It can pull in the XML, apply the XSL transform, and generate the course list.<br /> Dynamic, but not wasteful, is what I'm aiming for.<br /> Thoughts?<br /> <br /> Last updated [[User:bogatjo|Jon]] 23:56, 8 Mar 2006 (EST)<br /> <br /> <br /> It might make more sense to put the perl script into the cgi-bin, just to help keep the file structure as clean and organized as possible...<br /> --[[User:Weissto|Tom]] 16:51, 12 Mar 2006 (EST)<br /> <br /> <br /> Well, theoretically I should be able to add to the cgi-bin CVS module, I'll throw it in there when I get back to Indiana. Somehow I lost my ability to tunnel through Quark with SSH to my desktop so the XML parser'll have to wait for implementation until after Spring Break. <br /> <br /> We need to come up with a location for cache.html; the generated HTML course list which'll live as cache for the perlscript. We also need to deal with $recache; the variable which indicates after what period new content should be generated. And, finally, we need to determine whether it is necessary to generate an MD5 sum of the cache to check for validity; otherwise it'd be damned easy for somebody to inject an SSI into cache.html which calls God Knows What.<br /> <br /> One thought I had was generating cache.html from the XML parser and then chucking it into the Content database, which if I recall was just brought into existence. We can throw it in along with an MD5 sum of the page and when it was cached, hell we can even create an archive kind of deal where we keep old caches and let people browse 'em for historical purposes or for predicting what courses could be offered in the future, somewhat like what's there now.<br /> <br /> It'd mean a bit more work hacking code but that's not much trouble; I've got the time to spend so long as the college doesn't mind spending the money. :)<br /> <br /> [[User:bogatjo|Jon]] 16:09, 21 Mar 2006 (EST)<br /> <br /> ----<br /> <br /> ==Fixed Problems==<br /> <br /> &lt;ul&gt;<br /> &lt;li&gt;Register function for AlumniDB is broken.&lt;/li&gt;<br /> &lt;li&gt; Revert to yourself function is broken. Get a 404 error and your stuck as the new user until you relogin.&lt;/li&gt;<br /> &lt;li&gt;Fix AlumniDB admin function changeuser to show the info of the user that was switched to instead of admin's info on the 'view my info' page.&lt;/li&gt;<br /> &lt;li&gt;Ability to create an email list of all current alumni (admin only)&lt;/li&gt;<br /> &lt;li&gt;Revert function is broken again, in a different way though. When reverting from a user who isn't admin, the revert function serves up error.php&lt;/li&gt;<br /> <br /> &lt;/ul&gt;</div> Bogatjo https://wiki.cs.earlham.edu/index.php?title=WebDev&diff=1354 WebDev 2006-03-09T04:57:19Z <p>Bogatjo: </p> <hr /> <div>==Content Administration Group==<br /> All the current issues we are working with, or are on our to do list.<br /> ----<br /> ==AlumniDB==<br /> <br /> Features to add:<br /> &lt;ul&gt;&lt;li&gt;Ability to view internships currently being offered by alumni(all)&lt;/li&gt;<br /> &lt;li&gt;Ability to create an email list of all current alumni (admin only)&lt;/li&gt;<br /> &lt;li&gt;View of all alumni who are willing to be contacted for job opportunites and the like from current students(all)&lt;/li&gt;<br /> &lt;li&gt;Admin Functionality<br /> &lt;ul&gt;&lt;li&gt;Ability to change user type&lt;/li&gt;<br /> &lt;li&gt;Add new functions to the data base (write some code to check and validate the functions before they are added )&lt;/li&gt;<br /> &lt;/ul&gt;&lt;/li&gt;<br /> &lt;/ul&gt;<br /> <br /> --[[User:Weissto|Tom]] 17:12, 2 Mar 2006 (EST)<br /> <br /> ----<br /> <br /> ==ToDo==<br /> &lt;ul&gt;&lt;li&gt;Continue to Report CVS bugs....( all )&lt;/li&gt;<br /> &lt;li&gt;Validate our XHTML and CSS and links( all )&lt;/li&gt;<br /> &lt;li&gt;Install the W3C Log Validator to automate the above task..(Tom)&lt;/li&gt;<br /> &lt;li&gt;Replace center tags with something valid XHTML/CSS (Jon)<br /> Update 03/08/06: This sort of spawned another project... The CSS is a bit lengthy so I'm also looking into tightening the CSS in general a bit. (Jon) &lt;/li&gt;<br /> &lt;li&gt;Get feedback from the rest of the CS Department about AlumniDB&lt;/li&gt;<br /> &lt;li&gt;Fix everything under /html/courses it is all out of date. Part of this is getting the XML feed working and the other part is organizing old course folders and the like. (Jon)<br /> Update 03/08/06: I just wrapped up debugging the XSL transforms for the feed, so that gnome on my back has been shot after many hours of frustrated gnome-wrangling. Now it looks like another two weeks and I'll hopefully be able to have a tangible product in place for dynamic fetching of the course list. (Jon)&lt;/li&gt;<br /> &lt;li&gt;Fix AlumniDB admin function changeuser to show the info of the user that was switched to instead of admin's info on the 'view my info' page.&lt;/li&gt;<br /> &lt;li&gt;Revert to yourself function is broken. Get a 404 error and your stuck as the new user until you relogin.&lt;/li&gt;<br /> &lt;li&gt;Can't log in from the successful log out screen. Takes to main alumniDB page instead, even when user/pass is incorrect. 'request=' in address bar.&lt;/li&gt;<br /> &lt;li&gt;Register function for AlumniDB is broken.&lt;/li&gt;<br /> &lt;/ul&gt;<br /> <br /> ==The Courses Project==<br /> <br /> Since I'm (albeit slowly) approaching the programming phase I thought maybe an opened discourse would be useful about my plans for making the course list dynamic.<br /> For efficiency's sake there's really no need to continually be parsing what will be pretty much a static XML feed from WebDB. So what I thought was we'll throw a perlscript in the Courses sub-directory and execute it from crontab every semester or so... It can pull in the XML, apply the XSL transform, and generate the course list.<br /> Dynamic, but not wasteful, is what I'm aiming for.<br /> Thoughts?<br /> <br /> Last updated [[User:bogatjo|Jon]] 23:56, 8 Mar 2006 (EST)<br /> <br /> <br /> Add more as people think of it</div> Bogatjo