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

Conference ilbbak::ibi_focus

Title:FOCUS, from INFORMATION BUILDERS
Moderator:ZAYIUS::BROUILLETTE
Created:Thu Feb 19 1987
Last Modified:Mon May 05 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:615
Total number of notes:1779

357.0. "focus and 2020 : DIF format" by BIS1::SCHYNS () Wed Aug 01 1990 09:48

    Trying to link Focus results to 2020(output file = DIF format), 
    I lose some feature from the external file.  I have 2 problems :
    
    1. headings are lost :
    
    	table...            
    	sum expenses
    	across cost_centre
    	for account
    	007xxx as ....  over
    	...
    	on table hold as xxx format DIF
    	end
    
    	In Focus guide, it says that the output is stored with all
    	headings. When loading the file in 2020, all my across headings
    	are lost and do not appear on the worksheet but are well mentionned
    	if I edit the output file. How to have them also in the
    	spreadsheet? Is there a special format to be used ?  Same problem
    	is also mentionned in notes 2020_discussion.
    
    2. set nodata = 0 is not working.
    
    	All 0 values in the output file are transformed in NA even if
    	I have defined the set nodata=0.  How to do to have 0 instead
    	of NA in a DIF file ?
    
    By the way, is it possible to hold an output both in DIF format
    and in Text printable format (it seems that DIF is not working with
    panels specification) ?
    
    Who can help ?
T.RTitleUserPersonal
Name		DateLines
357.1I found the headingsTAVIS::COHENTue Nov 06 1990 08:14166
    I think that it's a simple bug, I checked the .DIF file and the heading
    labels are there, but ....
    
    It seems to me that the heading labels are started from column 1, 
    row 0 as you'll see below, and the data starts again from column 1, 
    row 0 so the data supersedes the heading labels.
    
    I think that we have to forward the problem to IBI (who is the product
    mgr ?) 
    
    Shalom,
    
    Avi
    
    ============ .DIF example ==== note: it's not a complete file 
TABLE
0,1
""
VECTORS
0,        12
""
TUPLES
0,         7
""
LABEL
    1,0                                    <----> column 1, line 0
"CUSTOMER_NO"
LABEL
    2,0
"SITE_NO"
LABEL
    3,0
"SYSTEM_TYPE"
LABEL
    4,0
"NOV_SOLD"
LABEL
    5,0
"NOV_DISC_SOL"
LABEL
    6,0
"NOV_QUOTE"
LABEL
    7,0
"NOV_DISC_QUO"
LABEL
    8,0
"NOV_WARRANTY"
LABEL
    9,0
"NOV_RENEWAL"
LABEL
   10,0
"NOV_DISC_REN"
LABEL
   11,0
"NOV_PER_CALL"
LABEL
   12,0
"NOV_EXTEND"
DATA
0,0
""
-1,0
BOT                                                 and again...
1,0                                               <----> column 1, line 0
"15351"
1,0
"016"
1,0
"MVAX2   "
0,           277.20
V
0,            37.80
V
0,              .00
V
0,              .00
V
0,              .00
V
0,              .00
V
0,              .00
V
0,              .00
V
0,              .00
V
1,0
"S"
1,0
"S"
1,0
"BSS "
0,            14.96
V
0,             2.04
V
0,              .00
V
0,              .00
V
0,              .00
V
0,              .00
V
0,              .00
V
0,              .00
V
1,0
"BSS "
-1,0
BOT
1,0
"15351"
1,0
"060"
1,0
"11785   "
0,          1814.56
V
0,           247.44
V
0,            53.68
V
0,             7.32
V
0,           130.00
V
0,              .00
V
0,              .00
V
0,           176.00
V
0,              .00
V
1,0
"S"
1,0
"S"
1,0
"DSS "
0,           958.32
V
0,           130.68
V
0,              .00
V
0,              .00
V
0,              .00
V
0,              .00                                             
V
0,              .00
V
0,              .00
V
1,0
"DSS "
-1,0
EOD
357.2Have you contacted either hotline ?CUPMK::DICKEllen Dick MKO1-2/D13 264-7195Wed Nov 07 1990 10:328

Are you in the US, or Europe ?  If you call the hotline (or send mail)
someone will work with IBI and you to resolve the problem.

	
Ellen
357.3The bug is somewhere else....TAVIS::COHENThu Nov 08 1990 02:4313
    Sorry,
    
    I jump into conclusion too fast, the problem is within 20/20 (I'll put
    a note in the 20/20 conf.).
    
    The reason I change my mind is a test I did, I used XWAY to change the
    .DIF file to .WK1 (Lotus/123 format) and read it into 20/20 (in 20/20
    you can simply read 123 files) and surprisingly I got the heading
    labels.
    
    Shalom (from Israel),
    
    Avi
357.4a way to handle this bugBIS1::SCHYNSMon Nov 19 1990 12:0236
    Ellen I'm located in Europe (BELGIUM).
    I have not called IBI since in the meantime I found an heavy way to
    handle this bug.
    
    For what regards the headings, I execute 2 procedures :
      For instance I want to have dollars across cost centers.
      In the first process I create a DIF file containing the heading
      values.
    
    		TABLE FILE XXX
    		SUM COST_CENTER
    		ACROSS COST_CENTER
    		ON TABLE HOLD AS COST_CENT FORMAT DIF
    		END
      
      In the second procedure, I create a file containing the data :
    
    		TABLE FILE XXX
    		SUM DOLLARS
    		ACROSS COST_CENTER
    		BY YYYY...
    		ON TABLE HOLD AS DATA FORMAT DIF
    		END
    
      In 2020 I then import the first file in the first row/column and
      the second file starting in the second row.
    
    
    For what regards the NA value, I have written a 2020 macro which is
    looking for the NA value and replacing them systematically by 0.
    If you're interested in this macro just tell me.  It works
    independently of the length of the spreadsheet.
    
    Anyway thanks for your replies,
    
    	Herve.