Re: auto delete file after download


"kick ass" <pub_lander@xxxxxxxxx> wrote in message
news:et6ge1$p9j$1@xxxxxxxxxxxxxxxxxx
| Thanks,
| What you are saying makes sense to me.
| I will shortly explain what I am trying to do:
|
| On my page all users have they own username and password.
| When I translate some document, I upload that document into specific users
| 'mailbox' on my website. So when user logs in, he can see the list of
files
| I uploaded for him and he can download them.
| I will not attempt to delete file after download any more, as you said,
it's
| not a good idea.
| Now, since I keep tracking changes that user makes in my database (i.e.
when
| I upload file, it is recorded in database), I would like to do the
tracking
| of downloaded files.
| So when user downloads the file, I would like the php script to insert
that
| record into database
| (i.e. RECORD_NO:216, USER: some_user, DATE OF DOWNLOAD:13.03.2007.,
| FILE_DOWNLOADED: some_filename).
| In that way, I could visit my website once a week and even manualy delete
| files that user "took away" to his computer.
| Is this possible to do in some way, or is it too complicated?
|
| Thanks for your efforts

you're welcome...and, it's not too complicated at all. i'd take a two
pronged approach. i've described the expiration method already. i'd also
allow the user to manually delete files that are no longer of their
interest. they may see them as clutter in their 'mailbox'. giving them the
ability to delete them is just good etiquette on your part.

i'd not actually delete the files if you plan on tracking/auditing...just
mark them as 'inactive' or something and don't display them again. that way,
depending on the nature/importance, of what is being communicated, your
report showing the communications will be more valuable...especially if the
authenticisty of the downloaded doc comes into question i.e. altered
(important for contracts, bol's, sla's, rfp's etc.)

anyway, i get the impression that you're comfortable with the db stuff so i
won't go into all that. i would however, still suggest that you run your
expiration script in an automated fashion (like on a cron job). you can
still build in the ability for you to manually expire stuff too.

anyway, hth.


.

Relevant Pages

  • Re: Main Menu Form Will Not Open
    ... Download ... Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia ... Dim fldEntityName As Field ... What is the name of the form that should open when the database ...
    (microsoft.public.access.forms)
  • Re: newbie need samples --( with tip of hat to Jeff Conrad )
    ... > Where to find information about designing a database in Microsoft Access: ... > ACC2000: "Understanding Relational Database Design" ... > (See the last download titled "Understanding Normalization") ... > Security FAQ: ...
    (microsoft.public.access.dataaccess.pages)
  • RE: FP database problems after installing URLscan tool
    ... The fpdbrgn2 file does not have the ... >Are you able to download the 4 files I uploaded, ... Now browse to the database page, ... >upload it to any ftp/free site location and give me the ...
    (microsoft.public.frontpage.extensions.windowsnt)
  • Re: Choosing the right embedded database.
    ... We want a simple database ... > Most users would download the application and data from a website via DIAL ... > access is the only real method of distribution, ... > local data store via an internet link. ...
    (borland.public.delphi.thirdpartytools.general)
  • Choosing the right embedded database.
    ... I am looking for the right tool for the job and came across you database ... Most users would download the application and data from a website via DIAL ... access is the only real method of distribution, ... local data store via an internet link. ...
    (borland.public.delphi.thirdpartytools.general)