Magic Service Desk Enterprise - How are attachments stored? - Thread - go-pugleaf

Thread View: bit.listserv.hdesk-l

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Chris Tue, 04 May 2004 18:52

Magic Service Desk Enterprise - How are attachments stored?

#162

Author: Chris
Date: Tue, 04 May 2004 18:52

33 lines
2199 bytes

I'm working on a web based interface that will be used to pre-approve
certain requests before they are insterted into a Magic Service Desk
Enterprise 7.5 system (SQL Server backend).  The bulk of the work is
done but the client has requested an add-on to allow the uploading of
related documentation. I know that the Magic system supports
attachments and stores them in the _TELATTACH_ table, but I've been
unable to replicate the format that the files are stored in. (This is
neccessary as I use a staging database to store the pre-approval
requests and then copy the data to the Magic system.)

Does anyone know if the Magic system is compressing the files or
storing them in some other format?  A simple
RS("fileblob").AppendChunk doesn't seem to be correct.

An example perhaps?  For a file called WS_FTP.LOG it will store the
following (actual line breaks):
----------
begin 660 WS_FTP.LOG
M,C`P-"XP-2XP,R`Q,SHT,B!"($,Z7$1O8W5M96YT<R!A;F0@4V5T=&EN9W-<
M8V)L;V]M7$1E<VMT;W!<:W)O8F5R='-`;'=G8VYH+F-O;2YI868@+2T^('=W
L=RYM864M9&%T82YC;VT@+R!K<F]B97)T<T!L=V=C;F@N8V]M+FEA9@T*#0IW
end
----------

The file itself contains (no line breaks):
----------
2004.05.03 13:42 B C:\Documents and
Settings\cbloom\Desktop\kroberts@lwgcnh.com.iaf --> www.mae-data.com /
kroberts@lwgcnh.com.iaf
----------

Any help would be appreciated. If possible, please CC
xangelusx@_NOSPAM_hotmail.com in any replies.

Re: Magic Service Desk Enterprise - How are attachments stored?

#163

Author: Chris
Date: Wed, 05 May 2004 18:57

45 lines
2881 bytes

With the help of a colleague I figured it out, and I'll post it here in case
anyone else should come looking for the information.

The files are UUEncoded and stored as text.  I encoded one of my example
files using Alladin's StuffIt, and the encoding was similar enough where
pasting it into Magic's [_TELATTACH_].[fileblob] column and then opening the
attachment via Magic resulted in the correct file, with all of it's bits
intact.



xangelusx@hotmail.com (Chris) wrote in message news:<f74db4c8.0405041052.7a4f4d9c@posting.google.com>...
> I'm working on a web based interface that will be used to pre-approve
> certain requests before they are insterted into a Magic Service Desk
> Enterprise 7.5 system (SQL Server backend).  The bulk of the work is
> done but the client has requested an add-on to allow the uploading of
> related documentation. I know that the Magic system supports
> attachments and stores them in the _TELATTACH_ table, but I've been
> unable to replicate the format that the files are stored in. (This is
> neccessary as I use a staging database to store the pre-approval
> requests and then copy the data to the Magic system.)
> 
> Does anyone know if the Magic system is compressing the files or
> storing them in some other format?  A simple
> RS("fileblob").AppendChunk doesn't seem to be correct.
> 
> An example perhaps?  For a file called WS_FTP.LOG it will store the
> following (actual line breaks):
> ----------
> begin 660 WS_FTP.LOG
> M,C`P-"XP-2XP,R`Q,SHT,B!"($,Z7$1O8W5M96YT<R!A;F0@4V5T=&EN9W-<
> M8V)L;V]M7$1E<VMT;W!<:W)O8F5R='-`;'=G8VYH+F-O;2YI868@+2T^('=W
> L=RYM864M9&%T82YC;VT@+R!K<F]B97)T<T!L=V=C;F@N8V]M+FEA9@T*#0IW
> end
> ----------
> 
> The file itself contains (no line breaks):
> ----------
> 2004.05.03 13:42 B C:\Documents and
> Settings\cbloom\Desktop\kroberts@lwgcnh.com.iaf --> www.mae-data.com /
> kroberts@lwgcnh.com.iaf
> ----------
> 
> Any help would be appreciated. If possible, please CC
> xangelusx@_NOSPAM_hotmail.com in any replies.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads