Refresh Files

[wagb278]

I posted to the Source Forge site a similar wish.  Not sure if this is redundant.

Unless I am missing something, SOSWP does not provide a file refresh capability.  I post a few PDF files on my SOSWP site. When I change those files I have to delete the old files from my site and load the new version. My PDF files appear as links on my "Downloadable Forms" page. This requires me to re-establish links et al.  I, for one, would prefer to have a "Refresh File" button along with the Delete and Edit buttons.  The "Update Document" button title on the Edit page is a little miss-leading, all it does is save the change in the file title.

Thanks, and I really like SOSWP. I use it as a home site for my residential LAN providing easy access to Web-enabled applications hosted on two Linux nodes.

[HandsomeWeb]

No, this is not possible.  But that is a great suggestion.  I will include it in future releases.

[HandsomeWeb]

This feature has been added in the latest release (Version 1.1.5).

[wagb278]

I updated to version 1.1.5 and tested the new feature.

I had to clear the browser cache to see the replacement file.  That had me confused for a while; is there a flush cache capability that can be initiated through PHP or javascript?  Or - when a file is replaced change the filename in the database. Also, the file date did not change when I uploaded a replacement; I think the date should change. However, I opened the database using phpmyadmin and noticed the NOW function on the date field.  Using the phpmyadmin change action on the appropriate record (but not making any changes) activated the NOW function and updated the date field.  Is there a "touch" or "update" action that can be used to get the date to change?

Thanks for the feature addition - definitely better!

Another suggestion to consider - provide a means to specify the order for these files to appear on the Web page.  This would probably need another field in the forms table to hold the display order which could be used in an ORDER BY phrase when fetching the forms from the database.  The existing forms_id field would not be appropriate because it relates to the sequence the files were added, not a presentation order.  Consider this when you run out of things to do.

Thanks,
Jim

[HandsomeWeb]

I had to clear the browser cache to see the replacement file.  That had me confused for a while; is there a flush cache capability that can be initiated through PHP or javascript? 

Actually, it just rewrites the file without hitting the database.  I'll update later to update the date in the database.  I don't think forcing a download of a chached file is possible without always forcing it.  That would slow down the site for visitors.  I am guessing you would not have had to clear your browser cache if you had closed your browser.  So site visitors would typically get the new file.

Another suggestion to consider - provide a means to specify the order for these files to appear on the Web page.  This would probably need another field in the forms table to hold the display order which could be used in an ORDER BY phrase when fetching the forms from the database.  The existing forms_id field would not be appropriate because it relates to the sequence the files were added, not a presentation order.  Consider this when you run out of things to do.

I will consider.  I hate database changes, so I might put it off until 1.2.  Thanks for your good ideas.

[HandsomeWeb]

An updated admin_forms.php file is in the SVN at SourceForge.