MRN
  • Posts: 1
  • Joined: 3/4/2016
You can use this template to export a grid to Jira table format. I assume it will work for Confluence also but I have not tested. Note: You will want to change the SavePath to be your SavePath.


<?xml version="1.0" encoding="utf-16"?>
<GridScripterTemplate xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Name>Jira</Name>
  <SaveGranularity>Entire</SaveGranularity>
  <SavePath>C:\SSMSBoost\{Year}{Month}{Day}_{Hour}{Minute}{Second}.txt</SavePath>
  <OpenWithApplication />
  <InvokeParametersReplacement>false</InvokeParametersReplacement>
  <DefaultClipboardFormat>Text</DefaultClipboardFormat>
  <Document>{Selections}</Document>
  <Selection>||{HeadersRow}||
{Rows}
</Selection>
  <SelectionsSeparator>\r\n\r\n</SelectionsSeparator>
  <Header>{ColumnName}</Header>
  <HeadersSeparator>||</HeadersSeparator>
  <Row>|{Values}|</Row>
  <RowsSeparator>\r\n</RowsSeparator>
  <ColumnName>{ColumnName}</ColumnName>
  <ColumnNamesSeparator>|</ColumnNamesSeparator>
  <Value>{Value}</Value>
  <ValuesSeparator>|</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>yyyy-MM-dd HH:mm:ss.fff</Format>
  </DateTimeFormatter>
  <DateFormatter>
    <Pattern>{Value}</Pattern>
    <Format>yyyy-MM-dd</Format>
  </DateFormatter>
  <TimeFormatter>
    <Pattern>{Value}</Pattern>
    <Format>HH:mm:ss.fff</Format>
  </TimeFormatter>
  <BooleanFormatter>
    <Pattern>{Value}</Pattern>
    <TrueString>1</TrueString>
    <FalseString>0</FalseString>
  </BooleanFormatter>
  <GuidFormatter>
    <Pattern>{Value}</Pattern>
    <Format />
  </GuidFormatter>
  <BinaryFormatter>
    <Pattern>{Value}</Pattern>
  </BinaryFormatter>
  <XmlFormatter>
    <Pattern>{Value}</Pattern>
  </XmlFormatter>
  <SpatialFormatter>
    <Pattern>{Value}</Pattern>
    <AsText>true</AsText>
  </SpatialFormatter>
  <NullString>NULL</NullString>
  <UseInvariantCulture>false</UseInvariantCulture>
  <MaxCharsPerValue>0</MaxCharsPerValue>
  <ValuesEncodeMethod>None</ValuesEncodeMethod>
</GridScripterTemplate>
Similar Topics
  • 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.