Open main menu

TaticView β

Changes

Automate Update data

349 bytes added, 17:53, 31 July 2017
no edit summary
'''tvcli -cmd import_file -user myemail@email.com -datamart 246 -file "c:\taticview\imp\spreadsheet.xlsx" -type append'''
'''tvcli -cmd import_file -user myemail@email.com -datamart 246 -file "c:\taticview\imp\spreadsheet.xlsx" -type append -nonotifyerror'''
 
 
=== TVCli version === <!--T:35-->
 
<!--T:36-->
Shows TVCli version on console and register into log file.
 
<!--T:37-->
'''Syntax: tvcli -version'''
A notification is sent to the user if an error occurs during the import process.
A log with the details of the executions will be generated in the configuration directory of the user (example: C: \ Users \ <user> \ AppData \ Local \ TVcli \ Logs).
 
<!--T:31-->
An === Script example of Windows running script:===
<!--T:32-->'''@ECHO OFF''' '''call tvcli -cmd import_file -user meuemailjonathan@emailsadig.com -datamart 246 -file "cC:\taticviewUsers\jonathan.SADIG\Documents\TaticView\impImport Files\planilhasales.xlsx" -datamart 674 -wait -notifyshare''' '''if %errorlevel <> % == 0( '''echo "SALES updated successfully!" '''Error notification by email) else ( '''echo "Problems updating SALES!" '''fi) ''' === TVCli version === <!call tvcli -cmd import_file -user jonathan@sadig.com -Tfile "C:35\Users\jonathan.Sadig\Documents\TaticView\Import Files\hr.xlsx" -datamart 673 -> wait '''if %errorlevel% == 0 (< '''echo "HR updated successfully!--T:36-->"Shows TVCli version on console and register into log file. ''') else (  < '''echo "Problems updating HR!--T:37-->" '''Syntax: tvcli -version)'''
<!--T:34-->
The free version grants you automation import from only one data source. You need to configure the feature '''automatic data update''' in your subscription to automate the imports of more data sources.
 
</translate>
Retrieved from "http://wiki.taticview.com/index.php/Special:MobileDiff/11319"