Letter Printing

[gboot1tc]

Hi

I trying to print a letter from the web, and come up with the following code:

IF eval_valid("session.centre") = .f. Then
goto skipletter
end if
dim filter as c
dim order as c
Filter = "Centre_Id="+quote(session.centre)
Dim filename as c
filename = session.session_folder + chr(92) + "templetter1.pdf"
filename = letter.saveas("three_week@[PathAlias.ADB_Path]\threeweek.set","pdf",filter,order,filename,.f.)
if file.exists(filename)
response.redirect(session.session_url + "templetter1.pdf?" + time("hms3"))
end if
skipletter:
this works on the local server but not on our main web server.....

The code may be completly wrong and it only works locally by some amazing chance of fate.

Can anyone help?????????

[Lenny Forziati]

What happens on the server where it is not working? Do you get any type of error message or anything?

Hi

I trying to print a letter from the web, and come up with the following code:

IF eval_valid("session.centre") = .f. Then
goto skipletter
end if
dim filter as c
dim order as c
Filter = "Centre_Id="+quote(session.centre)
Dim filename as c
filename = session.session_folder + chr(92) + "templetter1.pdf"
filename = letter.saveas("three_week@[PathAlias.ADB_Path]\threeweek.set","pdf",filter,order,filename,.f.)
if file.exists(filename)
response.redirect(session.session_url + "templetter1.pdf?" + time("hms3"))
end if
skipletter:
this works on the local server but not on our main web server.....

The code may be completly wrong and it only works locally by some amazing chance of fate.

Can anyone help?????????

[gboot1tc]

Just a blank browser screen

[JerryBrightbill]

When you get the blank browser screen, check the URL. If the URL is the name of the pdf, the problem may that Acrobat is not opening in the browser. If you are using Mozilla and an earlier Acrobat like 5.0, the browser won't open the file. Updating to Acrobat reader 7 should fix that problem.

[Peter.Wayne]

Check that on the main server the [PathAlias.ADB_path] in your letter definition has been replaced with the correct path to the data. Look in c:\a5webroot or wherever the actual webroot is to look at what has been "published" to the webroot.

[gboot1tc]

I have reports that run on the same system using a similiar script and they work fine.... Its a real puzzle all the correct files have been published to their correct locations in the webroot.

The print script i used was for a report that works, and has been modified to point to the letter....

[JerryBrightbill]

Your script looks very good with one exception. You don't need the chr(92) after session.session_folder. If you test the value by outputting it on a test page, you will get something like this

C:\A5Webroot\session_folders\7ae629dabf8f4df88181e89f59e3722b\

that includes the ending backsplash. Other than that, the script looks fine. As a test, you could try temporarily hardcoding a filter expression with values you know work on the desktop instead of using the session variable.

Again, after the code runs, what URL is in the address bar? The answer to that is very important to determine where the error occurs in the process.

If the server has error logging it turned on, are any errors recorded? Error logging is a great way to track unknown problems.

[gboot1tc]

After the page runs the url points to http://centredb.tamworth.ac.uk/printletter1.a5w wich is the page that has the script......

[Lenny Forziati]

That seems to indicate that the PDF was not generated. Try changing

if file.exists(filename)
    response.redirect(session.session_url + "templetter1.pdf?" + time("hms3"))
end if

to

if file.exists(filename)
    response.redirect(session.session_url + "templetter1.pdf?" + time("hms3"))
else
    ? "The PDF file (" + filename + ") was not created."
end if

After the page runs the url points to http://centredb.tamworth.ac.uk/printletter1.a5w wich is the page that has the script......