[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference iosg::all-in-1

Title:ALL-IN-1 (tm) Support Conference
Notice:Please spell ALL-IN-1 correctly - all CAPITALS!
Moderator:IOSG::PYECE
Created:Fri Jul 01 1994
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:2716
Total number of notes:12169

2513.0. "A1V3.2 sending EXCEL attachments remote" by ZUR01::TOLBA () Fri Feb 07 1997 10:58

Hello,

I have a problem with ALL-IN-1 V3.2 and at EXCEL attachments.
I am creating a message with Teamlinks V2.7 and attaching a Winword document
and an Excel spreadsheet and sending the message to myself Tolba@a1 or to my
ALL-IN-1 V3.1 account on a remote system.
When I read the new message the winword document is tagged as Winword Document
but the Excel Spreadsheet is tagged to Text and seems to be converted to 
ASCII.

Configuration:   ALL-IN-1 V3.2 BL101B  (US) ENGLISH 17-APR-1996
		 No ALL-IN-1 fixes (ICF's) installed
		 MR V3.3-313



Below the EXCEL part in the NBS file when sending from ALL-IN-1 V3.2:

00DE37   3            FIELD[ATTACH]   Len=00B49F
00DE3E   4                MSG[V2CONT]   Len=00B498
00DE45   5                    FIELD[SUBJ]   Len=000017
00DE47   6                        ASCII   Len=000015
                                      "D:\MANUELA\BOOK1.XLS^@
00DE65   5                    FIELD[CRTDATE]   Len=000012
00DE67   6                        DATE   Len=000010
00DE69   7                            ASCII   Len=00000E
                                          "19970206132506
00DE7E   5                    FIELD[PREC]   Len=000003
00DE80   6                        INT   Len=000001
                                      %01
00DE88   5                    VEND[TYPE]   Len=00000A
00DE8A   6                        ASCII   Len=000008
                                      "DOCUMENT
00DE99   5                    VEND[FORMAT]   Len=000006
00DE9B   6                        ASCII   Len=000004
                                      "XLS5
00DEA6   5                    FIELD[ATTACH]   Len=00B430
00DEAD   6                        MSG[TEXT]   Len=00B429
00DEB3   7                            ASCII   Len=00B423
                                          "<XD0>�^Qࡱ^Z�^@^@^@^@^@^@^@^@^@^@^@

                                          "<XFF><XFF><XFF><XFF>^_^@^@^@^C^@^@^@
                                          "
                                          "
                                          "
                                          "<FF>
                                          "^@^@^@^N^@^@^@^O^@^@^@^P^@^@^@^Q^@^@
                                          "^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^V^@
                                          "
                                          "^B^@<XFF><XFF><XFF><XFF><XFF><XFF>
                                          "
                                          "^B^A<XFF><XFF><XFF><XFF><XFF><XFF>
                                          "_ ;_ "SFr."\ * "-"_ ;_ @_ ^^^D,^@)^@
                                          "{^H
					   ...... 
                                                                        

When I send the message from an ALL-IN-1 V3.1 System to an ALL-IN-1 V3.2 system
the EXCEL part in the NBS File looks ok: 

00A0AF   3            FIELD[ATTACH]   Len=00EAC7
00A0B6   4                MSG[V2CONT]   Len=00EAC0
00A0BF   5                    FIELD[A1_KLUDGE]   Len=00000A
00A0C5   6                        INT   Len=000004
                                      %00000069
00A0D0   5                    FIELD[SUBJ]   Len=000017
00A0D2   6                        ASCII   Len=000015
                                      "D:\MANUELA\BOOK1.XLS^@
00A0F0   5                    FIELD[CRTDATE]   Len=000012
00A0F2   6                        DATE   Len=000010
00A0F4   7                            ASCII   Len=00000E
                                          "19970207095059
00A109   5                    FIELD[PREC]   Len=000003
00A10B   6                        INT   Len=000001
                                      %01
00A113   5                    VEND[TYPE]   Len=00000A
00A115   6                        ASCII   Len=000008
                                      "DOCUMENT
00A124   5                    VEND[FORMAT]   Len=000006
00A126   6                        ASCII   Len=000004
                                      "XLS5
00A131   5                    FIELD[ATTACH]   Len=00EA45
00A138   6                        MSG[DECBODY_07]   Len=00EA3E
00A13F   7                            VEND[IMAGE]   Len=00EA37
00A146   8                                VEND[IMAGTY]   Len=000015
00A14C   9                                    ASCII   Len=00000F
                                                  "XLS5
00A162   8                                VEND[IMAGPROC]   Len=00000D
00A168   9                                    ASCII   Len=000007
                                                  "FOREIGN
00A176   8                                VEND[IMAGDAT]   Len=00EA00
00A17D   9                                    BITS[%00]   Len=000008
                                                  %0402000201000000
00A18C   9                                    BITS[%00]   Len=000054
                                                  %020002000000030004
                                                  %000000000004000100
						  ..........



What has changed in ALL-IN-1 V3.2?


Any ideas where the problem (bug?) could be are most appreciated.

Best regards, 
Manuela Tolba, CSC CH-R�mlang Switzerland
 
T.RTitleUserPersonal
Name
DateLines
2513.1IOSG::STANDAGEMy hovercraft is full of eelsFri Feb 07 1997 11:5210
    
    Manuela,
    
    What happens if you attempt the reverse, i.e. the EXCEL docuemnt is
    sent from the V3.1 system to V3.1 and V3.2. I'm curious to see if
    there's any change in behaviour...
    
    -Kevin.
    
    
2513.2No problems with ALL-IN-1 V3.1ZUR01::TOLBAMon Feb 10 1997 10:4947
    Hello Kevin,
    
    Sending an EXCEL attachment from ALL-IN-1 V3.1 to V3.2 works fine
    see also the extract of the 2nd NBS File in .0.
    The problems seems to be with ALL-IN-1 V3.2 when sending remote.
    
    One of our customers has reported this problems. The difference to our
    support enviroment is that he is using PMDF Gateway instead of Message
    Router. With ALL-IN-1 V3.1 he had no problems sending EXCEL attachments. 
    Since upgrading to ALL-IN-1 V3.2 the problem appeared.
    
    At customer site a Pop3 client which receives the mail with the EXCEL
    attachment sent with ALL-IN-1 V3.2 does see the following information:
    
    Date: Mon, 13 Jan 1997 12:10:20 +0100
    Subject: P:\MSOFFICE\DATEN\TEST.XLS
    MIME-version: 1.0
    Content-type: TEXT/PLAIN; CHARSET=ISO-8859-1	<--------
    Importance: normal
    A1-format: XLS5
    A1-type: DOCUMENT
    
    
    when sent with ALL-IN-1 V3.1 it did look like:
    
    Date: Mon, 13 Jan 1997 12:10:20 +0100
    Subject: P:\MSOFFICE\DATEN\TEST.XLS
    MIME-version: 1.0
    Content-type: APPLICATION/VND.MS-EXCEL5; NAME=EXCEL5.XLS     <-------
    Content-disposition: ATTACHMENT; FILENAME=EXCEL5.XLS
    Content-transfer-encoding: BASE64
    Importance: normal
    A1-format: XLS5
    A1-type: DOCUMENT
    
    
    According to the customer nothing changed to his enviroment except the
    ALL-IN-1 upgrade.
    
    
    As there is also a problem with ALL-IN-1 V3.2 and Message Router I
    would suspect that the problem is really in ALL-IN-1 V3.2.
    
    
    
    Thanks for your help and best regards,
    Manuela
2513.3OA$MTI_TRNS 2: sending EXPRESS or FIRST CLASSZUR01::TOLBAMon Feb 10 1997 14:1942
    Hello Kevin,
    
    I have done some more tests together with Grahame:
    
    ALL-IN-1 V3.2 	OA$MTI_TRNS Logical has a value of 2
    
    1) 	sending a Remote Message as VT user with a Winword and EXCEL 
    	attachment to TOLBA@A1:
    	The body text as well as the 2 attachments will be converted to
    	ASCII, independent of the priority if it is FIRST CLASS or EXPRESS
    
    2)  sending a Remote Message with TeamLinks with a Winword and EXCEL
     	attachment to TOLBA@A1 by FIRST CLASS priority:
    	The Cover Note as well as the 2 attachments will be converted to
    	ASCII.
    
    3) 	sending a Remote Message with TeamLinks with a Winword and EXCEL
    	attachment to TOLBA@A1 by EXPRESS priority:
    	The Cover Note and the EXCEL attachment are converted to ASCII but
    	the Winword document remains as Winword Document.
    
    
    
    So the questions came up:
    
    1)	Is it correct that OA$MTI_TRNS 2 does convert 'FOREIGN' attachments
    	to ASCII?  I thought that only WPS-PLUS attachments will be converted.
    
    2)	If it is correct that also 'FORGEIGN' attachments will be converted is 
    	there a way to supress this to allow to convert only WPS-Plus 
    	attachments?
     	
    3)	What does handle TeamLinks or AIDA Server (?) differently when
    	sending a message FIRST CLASS or EXPRESS?
    
    
    I am looking forward to your feedback.
    
    Thanks and regards,
    Manuela
    
    
2513.4Why 'convert' everything?ZUR01::ASHGGrahame Ash @RLEMon Feb 17 1997 12:167
As part of this investigation, we also wondered what is supposed to happen 
with non-WPS-PLUS attachments if oa$mti_trns is set to 2. e.g what is the 
point of converting Excel to ASCII?

Or should this be reported by IPMT?

grahame
2513.5Is this the best solution?ZUR01::ASHGGrahame Ash @RLEThu Mar 06 1997 09:3712
Does no-one think this is worthy of some discussion?

It seems strange that the Sender will convert ALL non-text attachments to 
ASCII (i.e. rubbish in most cases), whereas the user is carefully prevented 
from doing this explicitly (the Convert Document option will not let you 
convert Excel for instance).

Although I appreciate the difficulty in deciding what the Sender SHOULD do, I 
don't believe the current solution is what most people would want. Or is it - 
does everyone expect their attachments to be wrecked if oa$mti_trns = 2?

grahame
2513.6Send requirement to V5.0 Product Manager...IOSG::PYEGraham - ALL-IN-1 Sorcerer&#039;s ApprenticeThu Mar 06 1997 09:5412
    This is now a CLD.
    
    My view on this is that Grahame is right, and this is no longer the
    best solution. When WPS-PLUS was the only format that we knew how to
    convert, and that wasn't understood by some remote recipients, then
    this functionality, as it was designed and implemented, was correct.
    
    And IMHO, it's described to convert *ALL* messages to ASCII.
    
    The way forward from here is to extend the functionality so that it can
    be specified whether only WPS-PLUS, or all document types, be
    converted. This is unlikely to happen in V4.0 though.
2513.7In A1V31 only WPS-Plus attachments were convertedZUR01::TOLBAThu Mar 06 1997 12:3515
    just some additional comment....
    
    I have opened an IPMT for this case (CFS.49186).
    
    An interesting aspect is that in ALL-IN-1 V3.1 OA$MTI_TRNS 2 only
    converted WPS-Plus attachments and left for example Winword and Excel
    as it is (as it was not possible in ALL-IN-1 V3.1 A1CONFIG to set the 
    value to 2 for OA$MTI_TRNS the customer redefined the logical and
    stopped/started the Sender).  My customer was just happy with this 
    behavior until upgraded to ALL-IN-1 V3.2.
    
    We will send also a requirement to the Product Manager.
    
    Regards,
    Manuela