TE CLI help

[mathewbiju007]

hi, am new to TE CLI and was looking at the documentation, the -S flag per the doco , should point to a path containing the script or inline script.
https://docs.tabulareditor.com/features/Command-line-Options.html
I got it to work with the script embedded in a file and -S refering to that file,
I need to use an inline script instead of a path, anyone has any working example of this please
TIA

[mlonsk]

Hi @mathewbiju007

I believe that the easist way is to do this through Powershell.
Here is an example of this type of way of in-lining script:

$script = @'
Output("Start");
foreach(var t in Model.Tables) {
    Output(t.Name);
}
Output("Done");
'@

Start-Process -FilePath "TabularEditor.exe" -Wait -NoNewWindow -ArgumentList @(
  '"C:\Models\Model.bim"',
  '-S', $script,
  '-B', '"C:\Models\Model_out.bim"'
)

Directly from the Command Line it should look something like this:

start /wait TabularEditor.exe "C:\Models\Model.bim" ^
  -S "Output(""Hello from inline script"");" ^
  -B "C:\Models\Model_out.bim"

But beware of the following when using this way:

• The whole script is wrapped in double quotes after -S.
• Any string literals inside the C# script must use doubled quotes: "" (CMD passes them through as ")

Best
Morten

[mathewbiju007]

thanks @mlonsk this is helpful, the CMD script works fine for me now, thank you! but when i try from windows powershell prompt, it gives

$p = Start-Process -filePath TabularEditor.exe -Wait -NoNewWindow -PassThru -ArgumentList ""c:\testfolder\TestOneDrivePBI - Import.SemanticModel\model.bim" -S "Model.Tables["bm"].Description = "Tx"" -B "c:\testfolder\TestOneDrivePBI - Import.SemanticModel\model5.bim`""

Tabular Editor 2.27.2 (build 2.27.9403.24625)

Loading model...
Script file not found: Model.Tables[bm].Description = Txxxxx

somehow it seem to expect the -S to be the filepath and not the inline. Please let me know if you are across
thanks

[mlonsk]

Hi @mathewbiju007

I can get the following command to work when running it directly in the PowerShell terminal:

& 'C:\Program Files (x86)\Tabular Editor\TabularEditor.exe' 'c:\testfolder\TestOneDrivePBI - Import.SemanticModel\model.bim' -S 'Model.Tables[""bm""].Description = ""Tx"";' -B 'c:\testfolder\TestOneDrivePBI - Import.SemanticModel\model5.bim'

[mathewbiju007]

thanks @mlonsk ! really appreciate it.