Skip to main content
Skip table of contents

Chart: Generate Chart from Grid Data

Tag: Chart

The Chart function generates charts from the grid.

AttributesAttribute ValuesValue Description
TargetN/AGrid code name
FilePathN/AXML file path containing the chart setup
KeepAliveTrue / FalseN/A


The chart setup dialog is not automated item per item. Instead, an XML setup file generated by Save As... must be used as the value of FilePath (or via automation recording):

XML
<Chart FilePath="C:\dev\Temp_XML\databaseEZ-chart-20_04_2017_16_47_15-Chart.XML"/>

SetParam Options

FieldValues
FilePathTarget image file to save the chart into
Copy"Click": copy image bitmap to clipboard

copy and save buttons

Detailed Description

To save the chart to an image file, two options are available:


1. The above SetParam

XML
<Chart FilePath="C:\dev\Temp_XML\databaseEZ-chart-20_04_2017_16_57_34-Chart.XML">
	<SetParam Field="FilePath" Value="C:\dev\Temp_XML\png chart exports\666.png"/>
</Chart>



2. The Export action:

XML
<Chart FilePath="C:\dev\Temp_XML\databaseEZ-chart-20_04_2017_16_57_34-Chart.XML">
	<Export FilePath="C:\dev\Temp_XML\png chart exports\666.png"/>
</Chart>



To copy to clipboard, two options are available:

1. The above SetParam

XML
<Chart FilePath="C:\dev\Temp_XML\databaseEZ-chart-20_04_2017_16_57_34-Chart.XML">
	<SetParam Field="Copy" Value="Click"/>
</Chart>



2. The CopyToClipboard action:

XML
<Chart FilePath="C:\dev\Temp_XML\databaseEZ-chart-20_04_2017_16_57_34-Chart.XML">
	<CopyToClipboard/>
</Chart>



The chart dialog automatically closes, unless KeepAlive="true" is set. In consoleEZ, as with other grid automation, the Server and Index parameters must be used:

XML
<Chart FilePath="C:\dev\Temp_XML\databaseEZ-chart-20_04_2017_16_47_15-Chart.XML"Server="MAINR5/YTRIA,NOTESAPP/YTRIA" index="1"/>


NEW v. 18 - LOAD CHART SETUP IN SCRIPT

Tag: SetGridChartDefault

Copy and paste the content of a chart setup XML file generated by the chart setup dialog into your own script::

Copy and paste the content of a chart setup XML file generated by the chart setup dialog into your own script

Example Script

XML
<ytriaAutomation Application="sapio365">
	<!--Chart FilePath="C:\dev\Temp_XML\365\chart-users.xml" keepAlive="true"/-->
	<Chart keepAlive="true">
		<SetGridChartDefault>
			<AddColumn ColumnID="department" Title="Department" Type="ValueX"/>
				<AddColumn Calculation="4" Color="4020651" ColumnID="jobTitle" Display="0" Legend="Job title" Title="Job title" Type="ValueY" Unicity="">
				<SetColumnFormat Type="TFMTRegular"/>
				<SetColumnFormat Type="NFMTRegular"/>
				<SetColumnFormat CBX_FMT_CBXSortFlag="0" Type="CheckBoxFmtRegular"/>
				<SetColumnFormat TextAlignment="0" TextCase="0" TextColor="4294967295" TextNotesName="False" Type="TextFmtRegular"/>
			</AddColumn>
			<Option Consolidate="True" Normalize="False" ShowHidden="False" ShowLegendRight="True" ShowLegendTop="False" ShowSegments="False" ShowValues="True" Subtype="0" SwapAxis="False" Title="MY CHART IS BIGGER THAN YOURS" 
			TitleX="Departments" TitleY="New arrivals" Type="0" VisibleOnly="False">
				<SetColumnFormat/>
				<SetColumnFormat Type="0"/>
				<SetColumnFormat Type="0"/>
			</Option>
		</SetGridChartDefault>
	</Chart>
</ytriaAutomation>

This is equivalent to:

XML
<Chart FilePath="C:\dev\Temp_XML\365\chart-users.xml" keepAlive="true"/>


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.