Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Magic Service Desk Enterprise - How are attachments stored?

2 views
Skip to first unread message

Chris

unread,
May 4, 2004, 2:52:11 PM5/4/04
to
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):
----------
----------

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

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

WS_FTP.LOG

Chris

unread,
May 5, 2004, 2:57:31 PM5/5/04
to
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.

xang...@hotmail.com (Chris) wrote in message news:<f74db4c8.04050...@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

0 new messages