Page 1 of 1

ASCIIOUTPUT formate

Posted: Wed May 30, 2012 1:27 pm
by mincharug.shulft
Hi All,
I have asciioutput like this

asciioutput('exit.log',str_datum | ' ' | cube,
str_datum | ' '|cube1,
str_datum |' '|cube2 |);
And my out is
exit.log with below format
20120530145735 b_testuser3_ce,20120530145735 }ElementAttributes_b_testuser3_ce,20120530145735 }ElementAttributes_memo_b_testuser3_ce
BUT I want to see my out below format (means one below one)
20120530145735 b_testuser3_ce,
20120530145735 }ElementAttributes_b_testuser3_ce,
20120530145735 }ElementAttributes_memo_b_testuser3_ce
How to get one below one –is there any function in TI to get the above ?
Thanks for advance.

Re: ASCIIOUTPUT formate

Posted: Wed May 30, 2012 1:35 pm
by lotsaram
mincharug.shulft wrote:Hi All,
I have asciioutput like this

asciioutput('exit.log',str_datum | ' ' | cube,
str_datum | ' '|cube1,
str_datum |' '|cube2 |);
And my out is
exit.log with below format
20120530145735 b_testuser3_ce,20120530145735 }ElementAttributes_b_testuser3_ce,20120530145735 }ElementAttributes_memo_b_testuser3_ce
BUT I want to see my out below format (means one below one)
20120530145735 b_testuser3_ce,
20120530145735 }ElementAttributes_b_testuser3_ce,
20120530145735 }ElementAttributes_memo_b_testuser3_ce
How to get one below one –is there any function in TI to get the above ?
Thanks for advance.
May I kindly suggest the following:
1/ Stop
2/ Think
3/ Type

As opposed to going straight to item 3 and typing without stop and think.

I believe this should do what you want. I also believe that with 15 seconds devoted to stop and think you would be able to come up with this yourself.
asciioutput('exit.log',str_datum | ' ' | cube);
asciioutput('exit.log',str_datum | ' '|cube1);
asciioutput('exit.log',str_datum |' '|cube2);

Re: ASCIIOUTPUT formate

Posted: Wed May 30, 2012 2:02 pm
by Wim Gielis
You're too good for this world Lotsaram :-D

Next question: Help, my records are eaten up!
I put an ASCIIOUTPUT in the Metadata tab and an ASCIIOUTPUT in the Data tab and now I don't see the Metadata tab records!
:-)

Anyways, back to work again.

Re: ASCIIOUTPUT formate

Posted: Wed May 30, 2012 3:55 pm
by anoops81
If you use the ASCIIOutput function to write to the same file in multiple procedures (tabs) of a TurboIntegrator process, the file will be overwritten each time it is opened for a new procedure.

Re: ASCIIOUTPUT formate

Posted: Wed May 30, 2012 5:09 pm
by rkaif
anoops81 wrote:If you use the ASCIIOutput function to write to the same file in multiple procedures (tabs) of a TurboIntegrator process, the file will be overwritten each time it is opened for a new procedure.
You are right but it was a joke from Wim Gielis :))

Re: ASCIIOUTPUT formate

Posted: Wed May 30, 2012 5:44 pm
by mincharug.shulft
I have its almost same scenario.

I have an asciioutput file which is there in the prolog.
Whenever TI runs it’s over writing content which is there in the .txt BUT I don’t want to over the content so whenever TI runs the content has to add not to over write.
Is it possible?

Re: ASCIIOUTPUT formate

Posted: Wed May 30, 2012 5:47 pm
by mincharug.shulft
lotsaram ,
i am sorry actually i was not expert like you ,i just started learning
however i would really handsup to your support.

Re: ASCIIOUTPUT formate

Posted: Wed May 30, 2012 6:04 pm
by lotsaram
This is explained in the product documentation (reference guide).
ASCIIOutput
This is a TM1® TurboIntegrator function, valid only in TurboIntegrator processes.
This function writes a comma-delimited record to an ASCII file.The ASCII file is opened when the first record is written, and is closed when the TurboIntegrator procedure (Prolog, Metadata, Data, or Epilog) containing the ASCIIIOutput function finishes processing.
......
If you use the ASCIIOutput function to write to the same file in multiple procedures (tabs) of a TurboIntegrator process, the file will be overwritten each time it is opened for a new procedure.
This limitation has certainly been discussed elsewhere here on this forum. To save you the effort of searching basically if you want to capture custom log output from separate "procedures" (in other words "advanced" code tabs) then there is no option except to declare separate output file names for each procedure and then if you want it all in one file to use a batch file and executecommand to concatenate the files together.

Re: ASCIIOUTPUT formate

Posted: Wed May 30, 2012 8:05 pm
by Wim Gielis
rkaif wrote:
anoops81 wrote:If you use the ASCIIOutput function to write to the same file in multiple procedures (tabs) of a TurboIntegrator process, the file will be overwritten each time it is opened for a new procedure.
You are right but it was a joke from Wim Gielis :))
:D :D

Re: ASCIIOUTPUT formate

Posted: Wed May 30, 2012 8:07 pm
by tomok
mincharug.shulft wrote:lotsaram ,
i am sorry actually i was not expert like you ,i just started learning
however i would really handsup to your support.
"Give a man a fish, and you feed him for a day; show him how to catch fish, and you feed him for a lifetime". You really are not doing yourself any favors just asking everyone else how to do something, especially when the answer is in the manuals. The only way to become an expert is to struggle and figure things out for yourself. Only come and ask when you've exhausted all other options, including using the search feature on this site!

Re: ASCIIOUTPUT formate

Posted: Thu May 31, 2012 5:35 am
by anoops81
rkaif wrote:
anoops81 wrote:If you use the ASCIIOutput function to write to the same file in multiple procedures (tabs) of a TurboIntegrator process, the file will be overwritten each time it is opened for a new procedure.
You are right but it was a joke from Wim Gielis :))
Okkk ... :D I was thinking WTF...

Wim Gielis, who is currently a Business Intelligence consultant , responsible for implementing custom IBM Cognos TM1 applications And he don't know this ??

I was feeling soo proud about myself :D :D