Hi,
You can set the attachment slot size for each individual attachment field,
you do not need to set it in ar.cfg.
But this would indeed affect all persons using the same field in the same
form.
And to elaborate my own stuff, and not that this does only work in filters.
If you create a simple filter like this:
Execute on Submit+Modify
Run If: ('TR.Attachment' != $NULL$)
Action: Set-Fields: CURRENT TRANSACTION
CharacterField = $Attachment$
You will get someting like this:
7484;1370;C:\tmp\tmp.def
The first number is the original size, and the second number is the
compressed size of the file.
If you change your field to an Integer instead, you will immediately get
the original size in the integer field, as the AR Server strips out
everything from the first non-numeric character:
Run If: ('TR.Attachment' != $NULL$)
Action: Set-Fields: CURRENT TRANSACTION
OriginalSizeInteger = $Attachment$
The result will be 7484 in the above example.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> IF i put the Attachment size in the ar.cfg file as 2MB, it applies to all
> the customers i have which i really dont want. This 2MB size attachment is
> specifically for a single customer, which i need to validate before the
> respective WEBSERVICE gets called.
>
> I heard like we can write a DIRECT SQL to measure the length of an
> attachment.But I am not able to write it. If any one knows pls let me
> know.
>
> Hi Misi,
>
> Thanks for ur quick response. But,Sorry to say that i really didn't
> understand what u were trying to say.Can you somewhat elaborate it?
>
> With Regards,
> B.Vikram.
> On Wed, Jun 20, 2012 at 11:23 PM, Misi Mladoniczky <[email protected]> wrote:
>
>> Hi,
>>
>> If you set a Character Field to $Attachment Slot$, you will see the name
>> of the attachemnt prefixed by the Compressed and Uncompressed size, with
>> a
>> delimiter. It is not hard to parse out these numbers if you need to.
>>
>> If you need this as individual fields, store it in an Integer field.
>>
>> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>>
>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
>> logs.
>> Find these products, and many free tools and utilities, at
>> http://rrr.se.
>>
>> > Vikram,
>> > If you don't want to allow > 2MB, why don't you just set that as the
>> > maximum size of the attachment field, and let Remedy handle the
>> errors?
>> >
>> > -----Original Message-----
>> > From: Action Request System discussion list(ARSList)
>> > [mailto:[email protected]] On Behalf Of Vikram_Betholi
>> > Sent: Wednesday, June 20, 2012 11:45 AM
>> > To: [email protected]
>> > Subject: Query for measuring Attachment length
>> >
>> > Hi,
>> >
>> > As part of my implementation i need to find the length of an
>> Attachment
>> > and if it is more than 2MB, i need to throw an error message to the
>> user.
>> > Can any one let me know what can be the Query to find the Attachment
>> > length?
>> >
>> > With Regards,
>> > B.Vikram
>> >
>> >
>> _______________________________________________________________________________
>> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend
>> wwrug12
>> > www.wwrug12.com ARSList: "Where the Answers Are"
>> >
>> >
>> _______________________________________________________________________________
>> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>> >
>>
>>
>> _______________________________________________________________________________
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"