Andrei
  • Posts: 398
  • Joined: 7/1/2012
SSMSBoost uses flexible templates system to script Results Grid data.

Users can create own new templates and exchange them easily, as far as settings editor allows to export/import single templates to clipboard in XML format.
Appropriate buttons for import/export are shown on the picture.

We will publish here updated/additional scripting templates.
You are also welcome to share here your own creations !
Andrei attached the following image(s):
settings-export-template.png (24kb) downloaded 92 time(s).

You cannot view/download attachments. Try to login or register.
Chin
  • Posts: 1
  • Joined: 7/14/2016
HI,

I cannot Import a template (from xml) from clipboard. can anyone help?
Error message is: ssmsboost could not create entry from clipboard

below is my script copied from this forum:

Quote:


<?xml version="1.0" encoding="utf-16"?>
<GridCopyTemplate xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Name>&amp;WHERE Column=Value</Name>
<PatchState>1</PatchState>
<FileExtension />
<OpenWithApplication />
<Document>WHERE {Selections}</Document>
<Selection>{Rows}</Selection>
<SelectionsSeparator> OR\r\n</SelectionsSeparator>
<Row>({Values})</Row>
<RowsSeparator> OR\r\n</RowsSeparator>
<Value>[{ColumnName}]{Value}</Value>
<ValuesSeparator> AND </ValuesSeparator>
<StringFormatter>
<Pattern>='{Value}'</Pattern>
</StringFormatter>
<IntegerFormatter>
<Pattern>={Value}</Pattern>
<Format>D</Format>
</IntegerFormatter>
<DoubleFormatter>
<Pattern>={Value}</Pattern>
<Format>G</Format>
</DoubleFormatter>
<CurrencyFormatter>
<Pattern>={Value}</Pattern>
<Format>G</Format>
</CurrencyFormatter>
<DateTimeFormatter>
<Pattern>='{Value}'</Pattern>
<Format>yyyyMMdd HH:mm:ss.fff</Format>
</DateTimeFormatter>
<BooleanFormatter>
<Pattern>={Value}</Pattern>
</BooleanFormatter>
<GuidFormatter>
<Pattern>='{Value}'</Pattern>
</GuidFormatter>
<BinaryFormatter>
<Pattern>={Value}</Pattern>
</BinaryFormatter>
<XmlFormatter>
<Pattern>='{Value}'</Pattern>
</XmlFormatter>
<NullString> is NULL</NullString>
<UseInvariantCulture>true</UseInvariantCulture>
<ValuesEncodeMethod>SqlEncode</ValuesEncodeMethod>
<SavePath>%USERPROFILE%\My Documents\SSMSBoost\{Year}{Month}{Day}_{Hour}{Minute}{Second}.sql</SavePath>
</GridCopyTemplate>

  • You cannot post new topics in this forum.
  • You cannot reply to topics in this forum.
  • You cannot delete your posts in this forum.
  • You cannot edit your posts in this forum.
  • You cannot create polls in this forum.
  • You cannot vote in polls in this forum.