Thoga

Hi All,

I've been looking into how to add links to attachments in E-mail Templates that go out to workers. That way they can download the attachments from NS without having necessarily to logon to HD. Has anyone already implemented such a solution or have any pointers on how to go about it?

Many thanks,
Chris

asebastian

Place this code in your email template.

<tr>
<td class="txtMsgLabel">Attachment:&nbsp;</td>
<td class="txtMsgValue"><a href="HDQUERY[[Select url From dbo.workitem_attachment where dbo.workitem_attachment.workitem_number = WORKITEM(workitem_number)]]">HDQUERY[[Select name From dbo.workitem_attachment where dbo.workitem_attachment.workitem_number = WORKITEM(workitem_number)]]</a></td>
</tr>


Thanks!

Amber

Thoga

Hi Amber,

That is just great. Almost exaclty what I needed. The only trouble I have is representing spaces as %20 so that the link is a true HTML link that can be downloaded. Any ideas?

Many Thanks,
Chris

asebastian

I am not sure what you are referring to. I have this in my email templates and I am able to view the attachments from the email that I receive. Below is what I see in my email and I click the attachment name and it will open.
__________________________________________________ __________
A new Helpdesk request has been received:
Details Incident #: 6742
Queue: Dataflex
Contact: Strather, Stephanie
Title: DF-7068144-Juan Wyatt
Attachment: Doc15.doc
__________________________________________________ ___________
Thanks!

Amber

Thoga

Thanks Amber,

What i was referring to is that the links to files that have spaces in them appear in the link with a space within the name since that is the way they appearin table workitem_attachment I would presume. Therefore when I try to download the files the attempt fails.

Incident #: #1093Contact Name: spamalertTitle: [not spam]FW: SPAM: [tc-street] 『デジタルドキュメントシンポジウム2007』参加者募集Attachment: SPAM tc-street .eml

http://svr-nnnn/AeXHD/Upload/1093_1_0_SPAM tc-street .eml

Any ides on how to present this link as:
http://svr-nnnn/AeXHD/Upload/1093_1_...20%20tc-street%20%20.eml

asebastian

My system appears to do that automatically. I have not had an issue opening any of my attachments.

Thanks!

Amber

Thoga

Thanks Amber,

This is already a great help.

kristian

A quick, lazy and late post on the subject....


For the problem with spaces and/or other characters, look at using the
REGEX[[value]][[match]][[replace]]
macro.

Put the HDQUERY macro for the value
".*(\s).*" for the match part
and "%20" for the replace

....

or something along those lines. See p244 of helpdesk_003.pdf