<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: To Quiz or not to Quiz...</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>If you look at the number of times that this topic has come up on this list, it seems to me that the .CSV file output type needs to be added to Quiz. Not only that but it would also be nice to have a .CSV input file type for qtp.</FONT></P>
<P><FONT SIZE=2>What do you think Erik, can you twist a few arms in Product Development?</FONT>
</P>
<P><FONT SIZE=2>Timothy J Cummings</FONT>
<BR><FONT SIZE=2>Milford, Ohio 45150</FONT>
<BR><FONT SIZE=2><<A HREF="mailto:Tim.Cummings@Frequencymarketing.Com">mailto:Tim.Cummings@Frequencymarketing.Com</A>></FONT>
</P>
<BR>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Hurworth, Erik [<A HREF="mailto:Erik.Hurworth@cognos.com">mailto:Erik.Hurworth@cognos.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Monday, June 13, 2005 5:59 AM</FONT>
<BR><FONT SIZE=2>To: powerh-l@lists.sowder.com</FONT>
<BR><FONT SIZE=2>Subject: RE: To Quiz or not to Quiz...</FONT>
</P>
<BR>
<P><FONT SIZE=2>Hi chaps,</FONT>
</P>
<P><FONT SIZE=2>I wrote an article on how to generate a comma-delimited file in</FONT>
<BR><FONT SIZE=2>Supportlink Article in VOL 9 NO 1 JAN 1999, page 58. The technique can</FONT>
<BR><FONT SIZE=2>be simplified with the use of the FORMATNUMBER function which is now</FONT>
<BR><FONT SIZE=2>available in all supported versions of PowerHouse.</FONT>
</P>
<P><FONT SIZE=2>Basically, there is no auto-format option when writing to subfiles or</FONT>
<BR><FONT SIZE=2>flat files,</FONT>
</P>
<P><FONT SIZE=2>Regards</FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2>Erik A. Hurworth</FONT>
<BR><FONT SIZE=2>Customer Support</FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2>( FreePhone 00 800 14 COGNOS (00 800 14 264667)</FONT>
<BR><FONT SIZE=2>* +44 / (0)1344 / 707799</FONT>
<BR><FONT SIZE=2>________________________________________________</FONT>
<BR><FONT SIZE=2>Cognos Ltd</FONT>
<BR><FONT SIZE=2>Registered in England, number 4625339.</FONT>
<BR><FONT SIZE=2>Registered office: Westerly Point, Market Street, Bracknell, Berkshire,</FONT>
<BR><FONT SIZE=2>RG12 1QB, U.K. </FONT>
<BR><FONT SIZE=2>Cognos Home Page: <<A HREF="http://www.cognos.com/" TARGET="_blank">http://www.cognos.com/</A>></FONT>
<BR><FONT SIZE=2>Cognos Support Page: <<A HREF="http://support.cognos.com/" TARGET="_blank">http://support.cognos.com/</A>></FONT>
<BR><FONT SIZE=2>Cognos Online Support: <<A HREF="http://support.cognos.com/servlet-cs/createcase" TARGET="_blank">http://support.cognos.com/servlet-cs/createcase</A>></FONT>
<BR><FONT SIZE=2>Cognos KnowlegdeBase: <A HREF="http://support.cognos.com/servlet-cs/kbsearch" TARGET="_blank">http://support.cognos.com/servlet-cs/kbsearch</A> </FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: powerh-l-bounces+erik.hurworth=cognos.com@lists.sowder.com</FONT>
<BR><FONT SIZE=2>[<A HREF="mailto:powerh-l-bounces+erik.hurworth=cognos.com@lists.sowder.com">mailto:powerh-l-bounces+erik.hurworth=cognos.com@lists.sowder.com</A>] On</FONT>
<BR><FONT SIZE=2>Behalf Of Jeff Hoffman</FONT>
<BR><FONT SIZE=2>Sent: 09 June 2005 23:24</FONT>
<BR><FONT SIZE=2>To: powerh-l@lists.sowder.com</FONT>
<BR><FONT SIZE=2>Subject: Re: To Quiz or not to Quiz...</FONT>
</P>
<P><FONT SIZE=2>Hi</FONT>
</P>
<P><FONT SIZE=2>Depending upon what you are using the data for I remember some time ago </FONT>
<BR><FONT SIZE=2>somebody mentioning the use of a continuation character then you can use</FONT>
</P>
<P><FONT SIZE=2>more than 1 line.</FONT>
</P>
<P><FONT SIZE=2>Alternatively</FONT>
</P>
<P><FONT SIZE=2>you can define a large field and then pack the data into this field and</FONT>
<BR><FONT SIZE=2>use </FONT>
<BR><FONT SIZE=2>subfiles. Numeric data can be formatted using 'formatnumber'.</FONT>
</P>
<P><FONT SIZE=2>def sep-char char*1="," ; or tab</FONT>
<BR><FONT SIZE=2>def x char*2000 = trunc(xyz) + sep-char + formatnumber(abc,"$00,000.00")</FONT>
<BR><FONT SIZE=2>+ </FONT>
<BR><FONT SIZE=2>sep-char ...etc</FONT>
<BR><FONT SIZE=2>set subfile name file1</FONT>
<BR><FONT SIZE=2>rep sum x</FONT>
<BR><FONT SIZE=2>go</FONT>
</P>
<P><FONT SIZE=2>Then in the O/S remove trailing spaces, if necessary.</FONT>
</P>
<P><FONT SIZE=2>Jeff Hoffman</FONT>
<BR><FONT SIZE=2>Wonicon Ply Ltd</FONT>
</P>
<BR>
<P><FONT SIZE=2>At 07:13 AM 10/06/2005, you wrote:</FONT>
</P>
<P><FONT SIZE=2>>Hi everybody,</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>I'm trying to extract powerhouse data to an ASCII file keeping the</FONT>
<BR><FONT SIZE=2>correct </FONT>
<BR><FONT SIZE=2>>dictionary picture format.</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>Using Quiz, everything is OK, it's like a report, so the numbers are </FONT>
<BR><FONT SIZE=2>>formatted according to the dictionary format without having to specify</FONT>
<BR><FONT SIZE=2>a </FONT>
<BR><FONT SIZE=2>>picture for every field. Good! But, I cannot exceed the 263</FONT>
<BR><FONT SIZE=2>characters </FONT>
<BR><FONT SIZE=2>>barrier for a record. It wraps the line. ... hum... too bad...</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>Using QTP, I don't have the wraparound problem but the format of the </FONT>
<BR><FONT SIZE=2>>fields is catastrophic. Presented as they are stored on file, without</FONT>
<BR><FONT SIZE=2>any </FONT>
<BR><FONT SIZE=2>>decimal format, the numbers are useless.</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>There is certainly a way to create records more than 263 characters</FONT>
<BR><FONT SIZE=2>long </FONT>
<BR><FONT SIZE=2>>in Quiz or to use the dictionary format in QTP ?</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>Surely I'm missing something.... ?</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>I'm talking about powerhouse 7.10.E sitting on a vax computer running </FONT>
<BR><FONT SIZE=2>>OpenVMS 6.2</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>Thank's !</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>Best regards.</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>Pierre McLeod Tremblay</FONT>
<BR><FONT SIZE=2>>Consultant T.I. / I.T. Consultant</FONT>
<BR><FONT SIZE=2>>pmcleod@videotron.ca</FONT>
<BR><FONT SIZE=2>>819.263.0791 fax: 819.263.0792</FONT>
<BR><FONT SIZE=2>>My french is better than my english. Sorry for the Frenglish...</FONT>
<BR><FONT SIZE=2>>--</FONT>
<BR><FONT SIZE=2>>= = = = = = = = = = = = = = = = = = = = = = = = = = = =</FONT>
<BR><FONT SIZE=2>>Mailing list: powerh-l@lists.sowder.com</FONT>
<BR><FONT SIZE=2>>Subscribe: "subscribe" in message body to</FONT>
<BR><FONT SIZE=2>powerh-l-request@lists.sowder.com</FONT>
<BR><FONT SIZE=2>>Unsubscribe: "unsubscribe &lt;password&gt;" in message body to </FONT>
<BR><FONT SIZE=2>>powerh-l-request@lists.sowder.com</FONT>
<BR><FONT SIZE=2>><A HREF="http://lists.sowder.com/mailman/listinfo/powerh-l" TARGET="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</A></FONT>
<BR><FONT SIZE=2>>This list is closed, thus to post to the list you must be a subscriber.</FONT>
</P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>= = = = = = = = = = = = = = = = = = = = = = = = = = = =</FONT>
<BR><FONT SIZE=2>Mailing list: powerh-l@lists.sowder.com</FONT>
<BR><FONT SIZE=2>Subscribe: "subscribe" in message body to</FONT>
<BR><FONT SIZE=2>powerh-l-request@lists.sowder.com</FONT>
<BR><FONT SIZE=2>Unsubscribe: "unsubscribe &lt;password&gt;" in message body to</FONT>
<BR><FONT SIZE=2>powerh-l-request@lists.sowder.com</FONT>
<BR><FONT SIZE=2><A HREF="http://lists.sowder.com/mailman/listinfo/powerh-l" TARGET="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</A></FONT>
<BR><FONT SIZE=2>This list is closed, thus to post to the list you must be a subscriber.</FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2> This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank You.</FONT></P>
<P><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2> Cognos Forum</FONT>
<BR><FONT SIZE=2> Our Annual Customer Conference</FONT>
<BR><FONT SIZE=2> Orlando, June 26-29, 2005</FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2> Best Practices. Tips and Techniques. Expert Advice.</FONT>
<BR><FONT SIZE=2> Get more from your Cognos investment.</FONT>
<BR><FONT SIZE=2> Register today at www.cognos.com/cognosforum</FONT>
</P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>= = = = = = = = = = = = = = = = = = = = = = = = = = = =</FONT>
<BR><FONT SIZE=2>Mailing list: powerh-l@lists.sowder.com</FONT>
<BR><FONT SIZE=2>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com</FONT>
<BR><FONT SIZE=2>Unsubscribe: "unsubscribe &lt;password&gt;" in message body to powerh-l-request@lists.sowder.com</FONT>
<BR><FONT SIZE=2><A HREF="http://lists.sowder.com/mailman/listinfo/powerh-l" TARGET="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</A></FONT>
<BR><FONT SIZE=2>This list is closed, thus to post to the list you must be a subscriber.</FONT>
</P>
</BODY>
</HTML>