Automated Google shopping products.txt generation

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   So,

Apparently scheduling stuff on a Windows server is quite a bit trickier than setting up a cron job with Linux. Plus, a script should "just work", not require a bunch of configuration. With that in mind, I'm looking to set up a "fake schedule" for this script by including a small snippet into my AdminHeader.asp file. I'm also considering putting this snippet in menu.asp instead. We'll see. Anyways here's the code:

'// Automated Google Products Submission

If DateDiff("d", Application("LastScheduledRunD"), Now()) > 0 Then

    ' This is where you put the commands you want to run on the

    ' schedule set up by the above condition.

    Application.Lock

    Application("LastScheduledRunD") = Now()

    Application.UnLock     

     Response.Redirect("exportFroogleAuto.asp")

End If

'// END Automated Google Products Submission

Now, what I'd like to put at the bottom of exportFroogleAuto.asp is a redirect to take you back to where you were. I figured:

Response.Redirect(Request.ServerVariables("HTTP_REFERER"))

Would do the trick, but unfortunately it doesn't. It looks like HTTP_REFERER is not set when a page is redirected to with response.redirect. So, I figured I would simply redirect it to menu.asp. However, for some reason none of my response.redirect calls are working on this script.

Does anyone know how I can get this exportFroogleAuto.asp script to redirect you to menu.asp after it's generated the .txt file?

*Edit*

This is where I found the great advice for scheduling ASP files:

http://www.asp101.com/articles/john/schedule/default.asp

Edited by Brett - 08-March-2011 at 3:06pm