1,438
edits
Changes
Marked this version for translation
'''Call "C:\Program Files\TvCli\tvcli" -cmd import_file -user myemail@email.com -datamart 246 -file "D:\taticview\imp\spreadsheet.xlsx" -wait'''
=== Running TVCli from BAT (Script) file ===<!--T:52-->
<!--T:53-->
You can create BAT files to schedule a bunch of TVCli commands. Doing so the entire process can be automated. As you can schedule using Windows scheduler or other similar tool.
<!--T:54-->
'''''Attention'''''<br>
To execute TVCli from a BAT file, you have to use the Windows [https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/call CALL] command. Ie.:
At end of a command execution, TVCli returns specific codes to inform the success or failure of the command. This allows the BAT file to verify if the previous TVCli command was completed successfully.
<!--T:55-->
Currently, the available codes are:
For this you can [https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2012-r2-and-2012/cc754335(v=ws.11) use ERROLEVEL] Windows environment variable. Ie.:
<!--T:56-->if %errorlevel% == 0 (
echo SALES updated successfully!
) else (
=== Other TVCli commands ===<!--T:57-->
==== TVCli show version ==== <!--T:35-->
==== TVCli show log ==== <!--T:47-->
<!--T:58-->
''since TVCli version 1.1''