Hello all, I have been working with this software for about 3 months. Everything smoothe sailing thanks to this forum. Today I implemented the new ticket file upload funtions by future (Upload_no_com_v2.zip)and seems to work rather well. I would like to be able to grant my users access to the uploaded document on the ticket. Currently the REP is the only one's able to execute or download the file, and the USER can see the file, but no reference to execute or download it. What code will I need to change to make the attachment on the ticket available to the users as well as the reps? Thank You in advance, this system is the best. Paul
users can only see the attachments, but not able to execute or download the file
Thanks,
Charan.P
I solved this by modifying the details.asp file in /user. Just did this 5mins ago and works! Code as follows:
Around line 285 you should have 'Uploaded Files:' heading. (or just do a Find) It should look like this:
Uploaded Files:</td></tr><tr class="Body1"><td colspan="2" ><% = rstproblem("Upload") %></td></tr>
Change the last line to the following:
<td colspan="2" ><% Response.Write "<a href='../../../uploads/" &rstProblem("Upload")& "' target='blank'>"&rstProblem("Upload")&"</a>" %></td></tr>
Update the line to include the correct path to your Uploads folder.
Well hell I have been running that mod for along time and never noticed the users could not click the attachment..lol I will implement this mod and try it too. Thanks for this..
Well dam. Look at that. Worked great! Nice mod thanks
Is therea step by step instructions on how to implement "Upload_no_com_v2.ZIP" mod?
the Read me text files are confusing to those who are not fluent with SQL data bases.
If you can show a documenet how to create the necessay tables and colunms in the database etc...
Most of us here are probably from a desktop/network support background, this is my first at anything remotely code based and its ASP w/SQL to boot! Make use of the forums, there are tons of information there. This is my post regarding the Attachments mod on Rob Atkinson's latest forum.
This is how I got it working thanks to the old forums.
You need to make the following changes to your SQL DB.
1. Add 'uploads' (text) column to your problems table2. Add 'AllowAttachments' (int) column to your tblConfig table3. Create the table 'Attachments' as indicated in the ReadMe.txt4. Copy the User and Rep folders in the zip to your dir.
Take it one step at a time. I started with just the Rep folder and worked through each error I encountered then copied over the User files. It should go without saying you need to backup your existing files before doing anything!!
Search the old forums, TONS of information there!
Old Forums: http://www.liberum.org/snitz/
Good luck!
Thx Blue for your response.
Yes I did search the old forum, but my main concern is that all these mods may conflict if the Instructions are not complete.
And yes I'll be following the steps that you indicated and other did to how to setup the upload mod.
It will be nice to combine some these mods into the main source code and make it like Liberum ver 2.0.
BTW is Helpdesk 1.1 beta a combination of these mods?
The problem with the method shown here is that only one file can be uploaded per problem. (OK for most problems). With a little searching in the old forums and a little coding, I was able to get the attach.asp file working for users and reps. This is nice because it stores the files in a separate table, and allows multiple attachments. We've been using liberum for a long time and have been needing file attachments since we started, so I'm glad to finally get that working. I also changed the upload code to add the date and time to the end of the filename so that the file is always unique AND a savvy user can't look at another person's uploaded files. It is easy to figure out that another file with the same name exists if I see a [1] after the filename, this is too easy.
I look forward to this being updated to 1.x someday and to the .Net version.
tommcmur
i've been trying to get the multiple file upload to work properly but have been unable to do so. Can you share with us the steps required to get it working.
blue
I would be curious to see how you got the mutli fille attach to work...
I'll put together the steps and get back to you. Do you know if it is possible to upload files here? if not, i'll have to post a link to some updated files that I had to fix.
Any update on those steps? I've tried to do it again but having the same issues. I even recreated the database. I guess I'll start with a full install and see what happens. My issue is I can upload A file. I'm unable to do multiple file uploads. I think I made a change in one of the files somewhere when I coudln't get the multi-upload to work which might be causing my issue.