Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
talendtester
Creator III
Creator III

How do I get the output from a .bat using tSystem?

I have a simple .bat job which prints the date time

@echo off echo %date:~10,4%-%date:~4,2%-%date:~7,2% %time:~0,2%:%time:~3,2%:%time:~6,2% exit;

 

I call the .bat job with tSystem component:

command "cmd /c start D:\\myDate.bat"

 

How do I write the returned date time to a file?

I tried all the Standard Output choices but every time a blank line is written to my output file.

Labels (2)
1 Solution

Accepted Solutions
TRF
Champion II
Champion II

Just to be sure, here is a capture of my tSystem component:

0683p000009Lty6.png

 

 

View solution in original post

4 Replies
TRF
Champion II
Champion II

In tSystem set "Standard Output" to "to Global variable".

Now the result is available from tSystem_2_OUTPUT (in tSystem name is tSystem_2).

You can easily put the result into a file using a tFixedInputFlow connected to a tFileOutputDelimited (for example).

Here is the tFixedInputFlow:0683p000009Lty1.png

Enjoy!

 

talendtester
Creator III
Creator III
Author

Starting a .bat in the Command of tSystem I wasn't able to get it to pass back the output of the .bat.

 

My job looks like: tSystem_1 onSubjobOk  tFixedFlowInput_1>tFileOutputDelimited_1.

 

Apparently the echo date time command must be in the Command of tSystem.

 

 

TRF
Champion II
Champion II

Not necessary. In the example I give, I used a command file, just removed the exit, the rest is copy/paste from your script.
TRF
Champion II
Champion II

Just to be sure, here is a capture of my tSystem component:

0683p000009Lty6.png