|
|
|
| Script Usage |
Can be Referenced/Imported/Copy-Pasted
Preferred Usage: Referencing |
| Category |
FusionCharts Path & Init |
| Script Parameters |
No Script Parameters |
| Description |
Returns the path to the FusionCharts html file |
| Result |
Returns the path to the FusionCharts html file |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 01/08/2007
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Returns The Path To The FusionCharts HTML File
# Script Parameters:
# No Script Parameters
# Return Value:
# The Path To The FusionCharts HTML File
# Pre-requisites For This Script:
# Assumes That The FusionCharts.html Is Present In The Same Directory, If Not Already Set By Initializing FusionCharts
# ---------------------------------------------
If [ IsEmpty($$FusionChartsFilePath) ]
# Assigns The Path To The Current Directory
Set Variable [ $currentDir; Value:Let ( folderPath=Left ( Get ( FilePath ) ; Position ( Get
( FilePath ) ; "/" ; Length (Get (FilePath)) ; -1));
Let (curDir=folderPath ; If ( Abs ( Get ( SystemPlatform )) = 2 ;
curDir ; Substitute (curDir ; "file:/" ; "file:///Volumes/" ) ))) ]
# Assigns The Path To The FusionCharts File
Set Variable [ $FusionChartsFilePath; Value:$currentDir & "FusionCharts.html" ]
Else
Set Variable [ $FusionChartsFilePath; Value:$$FusionChartsFilePath ]
End If
Exit Script [ Result: $FusionChartsFilePath ]
|
| Scripts used in this script |
|
| Pre-requisites for this script |
|
|
| |
| Script Usage |
Can be Referenced/Imported/Copy-Pasted
Preferred Usage: Referencing |
| Category |
FusionCharts Path & Init |
| Script Parameters |
No Script Parameters |
| Description |
Returns the path to the FusionCharts folder containing the engine files |
| Result |
Returns the path to the FusionCharts folder containing the engine files |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 01/08/2007
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Returns The Path To The FusionCharts HTML File
# Script Parameters:
# No Script Parameters
# Return Value:
# The Path To The FusionCharts HTML File
# Pre-requisites For This Script:
# Assumes That The FusionCharts.html Is Present In The Same Directory If FusionCharts FilePath Is Not Already Set
# ---------------------------------------------
If [ IsEmpty($$FusionChartsFolderPath) ]
# Assigns The Path To The Current Directory
Set Variable [ $currentDir; Value:Let ( folderPath=Left ( Get ( FilePath ) ; Position ( Get
( FilePath ) ; "/" ; Length (Get (FilePath)) ; -1));
Let (curDir=folderPath ; If ( Abs ( Get ( SystemPlatform )) = 2 ;
curDir ; Substitute (curDir ; "file:/" ; "file:///Volumes/" ) ))) ]
# Assigns The Path To The Charts Folder
Set Variable [ $FusionChartsFolderPath; Value:$currentDir ]
Else
Set Variable [ $FusionChartsFolderPath; Value:$$FusionChartsFolderPath ]
End If
Exit Script [ Result: $FusionChartsFolderPath ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
|
|
| |
| Script Usage |
Can be Referenced/Imported/Copy-Pasted
Preferred Usage: Referencing |
| Category |
FusionCharts Path & Init |
| Script Parameters |
No Script Parameters |
| Description |
Returns The Version Of FusionCharts Being Used |
| Result |
Returns The Version Of FusionCharts Being Used |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 01/08/2007
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Returns The Version Of FusionCharts Being Used
# Script Parameters:
# No Script Parameters
# Return Value:
# The Version Of FusionCharts Being Used
# Pre-requisites For This Script:
# Nil
# ---------------------------------------------
# Version : free
Set Variable [ $$version; Value:"free" ]
Exit Script [ Result: $$version ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
|
|
| |
| Script Usage |
Can be Referenced/Imported/Copy-Pasted
Preferred Usage: Referencing |
| Category |
FusionCharts Path & Init |
| Script Parameters |
No Script Parameters |
| Description |
Returns The Path To The HTML File Used To Show Preview Of Color |
| Result |
Returns The Path To The HTML File Used To Show Preview Of Color |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 01/08/2007
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Returns The Path To The HexColor HTML File
# Script Parameters:
# No Script Parameters
# Return Value:
# The Path To The HTML File Used To Show Preview Of Color
# Pre-requisites For This Script:
# Assumes That The HexColor.html Is Present In The Same Directory
# ---------------------------------------------
# Assigns The Path To The Current Directory
Set Variable [ $currentDir; Value:Let ( folderPath=Left ( Get ( FilePath ) ; Position ( Get
( FilePath ) ; "/" ; Length (Get (FilePath)) ; -1));
Let (curDir=folderPath ; If ( Abs ( Get ( SystemPlatform )) = 2 ;
curDir ; Substitute (curDir ; "file:/" ; "file:///Volumes/" ) ))) ]
# Assigns The Path To The Charts Folder
Set Variable [ $HexColorFilePath; Value:$currentDir &"HexColor.html" ]
Exit Script [ Result: $HexColorFilePath ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
|
|
|
|
| Script Usage |
Can be Referenced/Imported/Copy-Pasted.
Preferred Usage: Referencing |
| Category |
FusionCharts Path & Init |
| Script Parameters |
1. folderPath - (Optional) The Path To The Folder Containing The FusionCharts Engine Files.This Is An Optional Parameter. The Default Value Used Is Calculated To Be The Current Directory Path |
| Description |
Initializes FusionCharts File Path. Takes care of path differences in Mac OS and Windows. |
| Result |
If completed successfully, returns True. |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 01/08/2007
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Initializes FusionCharts File Path
# Script Parameters:
# 1. FolderPath- (Optional) The Path To The Folder Containing The FusionCharts Engine Files
# This Is An Optional Parameter. The Default Value Used Is Calculated To Be The Current Directory Path
# Return Value:
# If Done, Returns True
# Pre-requisites For This Script:
# Nil
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $folderPath; Value:GetValue($parameters;1) ]
# Assigns The Path To The Current Directory
Set Variable [ $$currentDir; Value:Let ( folderPath=Left ( Get ( FilePath ) ; Position ( Get
( FilePath ) ; "/" ; Length (Get (FilePath)) ; -1));
Let (curDir=folderPath ; If ( Abs ( Get ( SystemPlatform )) = 2 ;
curDir ; Substitute (curDir ; "file:/" ; "file:///Volumes/" ) ))) ]
If [ IsEmpty($folderPath) ]
Set Variable [ $$FusionChartsFolderPath; Value:$$currentDir ]
# Assigns The Path To The FusionCharts File
Set Variable [ $$FusionChartsFilePath; Value:$$currentDir & "FusionCharts.html" ]
Else
Set Variable [ $$FusionChartsFolderPath; Value:$folderPath ]
Set Variable [ $$FusionChartsFilePath; Value:$folderPath & "FusionCharts.html" ]
End If
Exit Script [ Result: True ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
|
|
| |
| Script Usage |
Can be Referenced/Imported/Copy-Pasted.
Preferred Usage: Referencing |
| Category |
FusionCharts Path & Init |
| Script Parameters |
1. delimiter - (Optional) The delimiter to be used throughout the application. This is an optional parameter. The default value used is ; |
| Description |
Initializes FusionCharts. Sets values for globally used variables. Takes care of path differences in Mac OS and Windows. |
| Result |
No return value |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 01/08/2007
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Initializes FusionCharts. Sets Values For Globally Used Variables.
# Script Parameters:
# 1. delimiter - (Optional) The Delimiter To Be Used Throughout The Application.
# This Is An Optional Parameter. The Default Value Used Is ;
# Return Value:
# No Return Value
# Pre-requisites For This Script:
# Nil
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $$delimiter; Value:GetValue($parameters;1) ]
# Assigns The Path To The FusionCharts File
Perform Script [ “InitializeFusionChartsFilePath” ]
Set Variable [ $$delimiter; Value:If(IsEmpty($$delimiter);";";$$delimiter) ]
Set Variable [ $$version; Value:"free" ]
Exit Script [ Result: True ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
|
|
| |
| |
| Script Usage |
Can be Referenced.
Preferred Usage: Referencing |
| Category |
FusionCharts URL Creation Helper Scripts |
| Script Parameters |
- ChartType - Type of chart. Takes values like Pie3D, Column3D
- ChartWidth - Width of the chart in pixels
- ChartHeight - Height of the chart in pixel
|
| Description |
Appends the QueryString starting with ?, followed by the
parameters to the FusionCharts html file path. The File path is got from
$$FusionChartsFilePath which is initialized in InitializeFusionCharts script.
Also, this script uses the $$delimiter initialized in InitializeFusionCharts
script. |
| Result |
Returns the new URL with the chart parameters appended to
it |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 01/08/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Appends The QueryString Starting With ?, Followed By The Parameters To The Given Address
# Script Parameters:
# 1. ChartType - Type Of chart. Takes Values Like Pie3D, Column3D
# 2. ChartWidth - Width Of The Chart In Pixels
# 3. ChartHeight - Height Of The Chart In Pixels
# Return Value:
# The New URL With The Chart Parameters Appended To It
# Pre-requisites For This Script:
# Nil
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $ChartType; Value:GetValue ( $parameters;1) ]
Set Variable [ $ChartWidth; Value:GetAsNumber (GetValue ( $parameters;2)) ]
Set Variable [ $ChartHeight; Value:GetAsNumber (GetValue ( $parameters;3 )) ]
Set Variable [ $WebAddress; Value:$$FusionChartsFilePath ]
If [ IsEmpty($$FusionChartsFilePath) ]
Perform Script [ “InitializeFusionCharts” ]
End If
# Appends The QueryString Starting With ?, Followed By The Parameters
Set Variable [ $WebAddress; Value: $WebAddress & "?v="& $$version &"&sep=" &$$delimiter& "&chart=[" & "chartType=" &$ChartType& $
$delimiter & "chartWidth=" &$ChartWidth& $$delimiter & "chartHeight=" &$ChartHeight& "]" ]
# Returns The Address With The Appended Query String
Exit Script [ Result: $WebAddress ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
|
|
| |
| Script Usage |
Can be Referenced.
Preferred Usage: Referencing |
| Category |
FusionCharts URL Creation Helper Scripts |
| Script Parameters |
- ChartType - Type of chart. Takes values like Pie3D, Column3D
- ChartWidth - Width of the chart in pixels
- ChartHeight - Height of the chart in pixel
- ChartOptions - Other chart parameters like Caption, Sub-Caption separated
by delimiter.
|
| Description |
Appends the QueryString starting with ?, followed by the
chart parameters and the chartParams parameter to the FusionCharts html
file path |
| Result |
Returns the complete URL with the chart parameters appended
to it |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 01/08/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Appends The QueryString Starting With ?, Followed By The Parameters To The Given Address
# And Also Appends The chartParams Parameter
# This Script Expects FusionCharts To Be Initialized
# If It Is Not Initialized, It Initializes It By Using Current Directory Path
# Script Parameters:
# 1. ChartType - Type Of Chart. Takes Values Like Pie3D, Column3D
# 2. ChartWidth - Width Of The Chart In Pixels
# 3. ChartHeight - Height Of The Chart In Pixels
# 4. ChartOptions - Other Chart Parameters Like Caption, Sub-Caption
# Sample For This Parameter: "caption=Monthly Sales;subCaption=For the entire period;numberPrefix=$"
# Return Value:
# The New URL With The Chart Parameters Appended To It
# Pre-requisites For This Script:
# Nil
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $ChartType; Value:GetValue ( $parameters;1) ]
Set Variable [ $ChartWidth; Value:GetAsNumber (GetValue ( $parameters;2)) ]
Set Variable [ $ChartHeight; Value:GetAsNumber (GetValue ( $parameters;3 )) ]
Set Variable [ $ChartOptions; Value:GetValue ( $parameters;4 ) ]
Set Variable [ $WebAddress; Value:$$FusionChartsFilePath ]
If [ IsEmpty($$FusionChartsFilePath) ]
Perform Script [ “InitializeFusionCharts” ]
End If
# Appends The QueryString Starting With ?, Followed By The Parameters
Set Variable [ $WebAddress; Value: $WebAddress & "?v=" &$$version& "&sep=" &$$delimiter& "&chart=[" & "chartType=" &$ChartType& $
$delimiter & "chartWidth=" &$ChartWidth& $$delimiter & "chartHeight=" &$ChartHeight& "]" & "&chartParams=[" & $ChartOptions&
"]" ]
# Returns The Address With The Appended Query String Appended To It
Exit Script [ Result: $WebAddress ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
|
|
| |
| Script Usage |
Can be Referenced/Imported/Copy-Pasted.
Preferred Usage: Referencing |
| Category |
FusionCharts URL Creation Helper Scripts |
| Script Parameters |
- WebAddress - The address to which chart parameter needs to be appended
- ChartParams - This is a delimiter separated set of key- value pairs
used to configure the chart.
|
| Description |
Appends the QueryString starting with ?, followed by the
parameters to the FusionCharts html file path. The File path is got from
$$FusionChartsFilePath which is initialized in InitializeFusionCharts script.
Also, this scriptuses the $$delimiter initialized in InitializeFusionCharts
script. |
| Result |
Returns the new URL with the chart parameters appended to
it |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/08/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Appends The Charts Parameters To The Given Address.
# Here It Is Assumed That The First Block Of Chart Parameters:
# chartType,chartWidth and chartHeight Have Been Assigned Already.
# The ChartParams Parameter Provided Here Is appended With "&chartParams="
# And Then Appended To The Web Address
# Script Parameters:
# ----------------------
# 1. WebAddress - The Address To Which Chart Parameter Needs To Be Appended
# 2. ChartParams - This Is A Delimiter Separated Set Of Key-Value Pairs Used To Configure The Chart.
# There Can Be Several Chart Parameters Like Caption, Sub-Caption, numberPrefix.
# Sample For This Parameter: "caption=Monthly Sales;subCaption=For the entire period;numberPrefix=$"
# Return Value:
# The New URL With The chartParams Parameter Appended To It
# Pre-requisites For This Script:
# WebAddress Parameter Already Has The First Set Of Parameters In The QueryString Starting With ?
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $WebAddress; Value:GetValue ( $parameters;1) ]
Set Variable [ $ChartParams; Value:GetValue ( $parameters;2) ]
# Appends The ChartParams To The Web Address
Set Variable [ $WebAddress; Value: $WebAddress & "&chartParams=[" & $ChartParams& "]" ]
# Returns The Address With The ChartParams Appended To It
Exit Script [ Result: $WebAddress ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
|
|
| |
| Script Usage |
Can be Referenced/Imported/Copy-Pasted.
Preferred Usage: Referencing |
| Category |
FusionCharts URL Creation Helper Scripts |
| Script Parameters |
- WebAddress - The address to which chart parameter needs to be appended
- labels - The labels to be shown on the chart separated by delimiter
- data - The data to be shown on the chart separated by delimiter
|
| Description |
Appends the labels and data parameters to the given Web Address.
Appends the corresponding parameter name before each parameter value. |
| Result |
Returns the new URL with the labels and data parameters appended
to it |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
BuildAndAppendSSDataParams - FromRepetitions
BuildAndAppendSSDataParams - BySummingValuesInLayout
BuildAndAppendSSDataParams - LoopThroughPortalRows
BuildAndAppendSSDataParams - LoopThroughPortalInGroups
BuildAndAppendSSDataParams-UsingGetNthRecord
BuildAndAppendSSDataParams-UsingGetNthRecord
-UseLabelList
BuildAndAppendSSDataParams-LoopInGroups-UsingGetNthRecord
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/08/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Appends The Labels And The Data For A Single-Series Chart
# Script Parameters:
# 1. WebAddress - The Address To Which Chart Parameter Needs To Be Appended
# 2. labels - The Labels To Be Shown On The Chart Separated By Delimiter
# 3. data - The Data To Be Shown On The Chart Separated By Delimiter
# Return Value:
# Returns The New URL With The Labels And Data Appended To It
# Pre-requisites For This Script:
# WebAddress Parameter Already Has The First Set Of Parameters In The QueryString Starting With ?
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $WebAddress; Value:GetValue ( $parameters;1) ]
Set Variable [ $labels; Value:GetValue ( $parameters;2) ]
Set Variable [ $data; Value:GetValue ( $parameters;3) ]
# Appends The Labels And Data By Prepending Them With Their Parameter Names
Set Variable [ $WebAddress; Value: $WebAddress & "&labels=" & $labels & "&data=" & $data ]
# Returns The Address With The Appended Labels And Data
Exit Script [ Result: $WebAddress ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
WebAddress parameter already has first set of parameters
in the QueryString starting with ?. |
|
| |
| Script Usage |
Can be Referenced/Imported/Copy-Pasted.
Preferred Usage: Referencing |
| Category |
FusionCharts URL Creation Helper Scripts |
| Script Parameters |
- WebAddress - The address to which chart parameter needs to be appended
- labels - The labels to be shown on the chart separated by delimiter
|
| Description |
Appends the labels parameter to the given Web Address. Appends
the corresponding parameter name before the parameter value. |
| Result |
Returns the new URL with the labels appended to it |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
AppendLabelsFromValueList
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/08/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Appends The Labels To The URL
# Script Parameters:
# 1. WebAddress - The Address To Which Chart Parameter Needs To Be Appended
# 2. labels - The Labels To Be Shown On The Chart Separated By Delimiter
# Return Value:
# The New URL With The Labels Appended To It
# Pre-requisites For This Script:
# WebAddress Parameter Already Has The First Set Of Parameters In The QueryString Starting With ?
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $WebAddress; Value:GetValue ( $parameters;1) ]
Set Variable [ $labels; Value:GetValue ( $parameters;2) ]
# Appends The Labels And Data By Prepending Them With Their Parameter Names
Set Variable [ $WebAddress; Value: $WebAddress & "&labels=" & $labels ]
# Returns The Address With The Appended Labels And Data
Exit Script [ Result: $WebAddress ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
WebAddress parameter already has first set of parameters in the QueryString
starting with ?. |
|
| |
| Script Usage |
Can be Referenced/Imported/Copy-Pasted.
Preferred Usage: Referencing |
| Category |
FusionCharts URL Creation Helper Scripts |
| Script Parameters |
- WebAddress - The URL to which data parameters have to be appended
- LabelListName - The Value List which has to be used for labels
- FileName - The FileName where Value List is present
- delimiter - (Optional) The delimiter to be used in this script. This is an optional parameter. The default value used is the one specified in global values when FusionCharts is initialized.
|
| Description |
Appends the labels from the Value List to the given URL |
| Result |
Returns the new web address with the labels appended to the given web address |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/08/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Appends The Labels From The Value List To The Given URL
# Script Parameters:
# 1. WebAddress - The URL To Which Data Parameters Have To Be Appended
# 2. LabelListName - The Value List Which Has To Be Used For Labels
# 3. FileName - The FileName Where Value List Is Present
# 4. delimiter - (Optional) The Delimiter To Be Used In This Script.
# This Is An Optional Parameter. The Default Value Used Is The One Specified In Global Values When FusionCharts Is
Initialized.
# Return Value:
# The New Web Address With The Labels
# Appended To The Given Web Address
# Pre-requisites For This Script:
# Nil
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]
Set Variable [ $LabelListName; Value:GetValue($parameters;2) ]
Set Variable [ $FileName; Value:GetValue($parameters;3) ]
Set Variable [ $delimiter; Value:GetValue($parameters;4) ]
Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) ]
Set Variable [ $labels; Value:Substitute(ValueListItems ( $FileName; $LabelListName );"¶";$delimiter) ]
# Perform Script To Append The Labels
Perform Script [ “AppendLabelsToURL”; Parameter: $WebAddress & "¶" & $labels ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
WebAddress parameter already has first set of parameters in the QueryString starting with ?. |
|
| |
| Script Usage |
Can be Referenced/Imported/Copy-Pasted.
Preferred Usage: Referencing |
| Category |
FusionCharts URL Creation Helper Scripts |
| Script Parameters |
- WebAddress - The address to which chart parameter needs to be appended
- StyleDefValue - This is a value for the styleDef parameter
- Block of values. Each block enclosed in square brackets. Each parameter
separatedby delimiter
- Sample for this parameter: "[name=captionStyle;type=font;size=14;font=Arial]
- [name=subCaptionStyle;type=font;size=12;font=Arial]"
|
| Description |
Appends the styleDef parameter to the given Web Address.
Appends the corresponding parameter name before the parameter value. |
| Result |
Returns the new URL with the styleDef parameter appended
to it |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/08/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Appends The styleDef Parameter To The Given Address.
# The Parameter Name And Value Are Appended To The WebAddress
# In The Format "& styleDef=" & $StyleDefValue
# And Then Appended To The Web Address
# Script Parameters:
# 1. WebAddress - The Address To Which Chart Parameter Needs To Be Appended
# 2. StyleDefValue - This Is A Value For The styleDef Parameter
# Block Of Values. Each Block Enclosed In Square Brackets. Each Parameter Separated By Delimiter
# Sample For This Parameter: "[name=captionStyle;type=font;size=14;font=Arial]
# [name=subCaptionStyle;type=font;size=12;font=Arial]"
# Return Value:
# Returns The New URL With The styleDef Parameter Appended To It
# Pre-requisites For This Script:
# WebAddress Parameter Already Has The First Set Of Parameters In The QueryString Starting With ?
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $WebAddress; Value:GetValue ( $parameters;1) ]
Set Variable [ $StyleDefValue; Value:GetValue ( $parameters;2) ]
# Appends The Given Parameter To The WebAddress
Set Variable [ $WebAddress; Value: $WebAddress & "&styleDef=" &$StyleDefValue ]
# Returns The Address With The Given Parameter Appended To It
Exit Script [ Result: $WebAddress ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
WebAddress parameter already has first set of parameters in the QueryString
starting with ?. |
|
| |
| Script Usage |
Can be Referenced/Imported/Copy-Pasted.
Preferred Usage: Referencing |
| Category |
FusionCharts URL Creation Helper Scripts |
| Script Parameters |
- WebAddress - The address to which chart parameter needs to be appended
- StyleAppValue - This is a value for the styleApp parameter
- Block of values. Each block enclosed in square brackets. Each parameter
separatedby delimiter
- Sample for this parameter: "[toobject=caption;styles=captionStyle]
- [toobject=subcaption;styles=subCaptionStyle]"
|
| Description |
Appends the styleApp parameter to the given Web Address.
Appends the corresponding parameter name before the parameter value. |
| Result |
Returns the new URL with the styleApp parameter appended
to it |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/08/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Appends The styleDef Parameter To The Given Address.
# The Parameter Name And Value Are Appended To The WebAddress
# In The Format "& styleApp=" & $StyleDefValue
# And Then Appended To The Web Address
#
# Script Parameters:
# 1. WebAddress - The Address To Which Chart Parameter Needs To Be Appended
# 2. StyleAppValue - This Is A Value For The styleApp Parameter
# Block Of Values. Each Block Enclosed In Square Brackets.
# Each Parameter Separated By Delimiter
# Sample For This Parameter: "[toobject=caption;styles=captionStyle]
# [toobject=subcaption;styles=subCaptionStyle]"
# Return Value:
# Returns The New URL With The styleApp Parameter Appended To It
# Pre-requisites For This Script:
# WebAddress Parameter Already Has The First Set Of Parameters In The QueryString Starting With ?
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $WebAddress; Value:GetValue ( $parameters;1) ]
Set Variable [ $StyleAppValue; Value:GetValue ( $parameters;2) ]
# Appends The Given Parameter To The WebAddress
Set Variable [ $WebAddress; Value: $WebAddress & "&styleApp=" &$StyleAppValue ]
# Returns The Address With The Given Parameter Appended To It
Exit Script [ Result: $WebAddress ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
WebAddress parameter already has first set of parameters in the QueryString
starting with ?. |
|
| |
| Script Usage |
Can be Referenced/Imported/Copy-Pasted.
Preferred Usage: Referencing |
| Category |
FusionCharts URL Creation Helper Scripts |
| Script Parameters |
- WebAddress - The address to which chart parameter needs to be appended
- ParameterName - This is a name of the parameter to be appended
- Sample for this parameter: "styleDef"
- ParameterValue - This is a value for the parameter
- Sample for this parameter: "[name=captionStyle;type=font;size=14;font=Arial]
[name=subCaptionStyle;type=font;size=12;font=Arial]"
|
| Description |
Appends the given parameter to the given Web Address. Appends
the corresponding parameter name before the parameter value. |
| Result |
Returns the new URL with the given parameter appended to
it |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/08/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Appends The Charts' Parameters To The Given Address.
# chartType,chartWidth and chartHeight Have Been Assigned Already.
# The Parameter Name And Value Are Appended To The WebAddress
# In The Format "&"& $ParameterName &"=" & $ParameterValue
# And Then Appended To The Web Address
# Script Parameters:
# 1. WebAddress - The Address To Which Chart Parameter Needs To Be Appended
# 2. ParameterName - This Is A Name Of The Parameter To Be Appended
# Sample For This Parameter: "styleDef"
# 3. ParameterValue - This Is A Value For The Parameter
# Sample For This Parameter: "[name=captionStyle;type=font;size=14;font=Arial]
# [name=subCaptionStyle;type=font;size=12;font=Arial]"
# Return Value:
# The New URL With The Given Parameter Appended To It
# Pre-requisites For This Script:
# WebAddress Parameter Already Has The First Set Of Parameters In The QueryString Starting With ?
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $WebAddress; Value:GetValue ( $parameters;1) ]
Set Variable [ $ParameterName; Value:GetValue ( $parameters;2) ]
Set Variable [ $ParameterValue; Value:GetValue ( $parameters;3) ]
# Appends The Given Parameter To The WebAddress
Set Variable [ $WebAddress; Value: $WebAddress & "&" &$ParameterName& "=" &$ParameterValue ]
# Returns The Address With The Given Parameter Appended To It
Exit Script [ Result: $WebAddress ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
WebAddress parameter already has first set of parameters in the QueryString
starting with ?. |
|
| |
| |
| Script Usage |
Can be Referenced/Imported/Copy-Pasted.
Preferred Usage: Referencing
Note that this script should be used only when percent character and forward slash character has to be escaped. |
| Category |
FusionCharts Utility Scripts |
| Script Parameters |
- text - The text which needs to be escaped
|
| Description |
Escapes the special characters % and / in the given text and returns the
escaped text. |
| Result |
Returns the escaped text |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/08/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Escapes The % And / Special Characters Which When Used Within Parameter Values, Can Cause Trouble
# Script Parameters:
# The Text Which Needs To Be Escaped
# Return Value:
# The New Text With The % And / Special Characters Escaped
# Pre-requisites For This Script:
# Nil
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $text; Value:GetValue ( $parameters;1) ]
If [ Abs ( Get ( SystemPlatform )) = 2 ]
# Windows Platform
# Need To Double Escape The Characters
Set Variable [ $text; Value:Substitute($text;"%";"%2525") ]
Set Variable [ $text; Value:Substitute($text;"/";"%252f") ]
Else If [ Abs ( Get ( SystemPlatform )) = 1 ]
# Mac OS
# Need To Escape The Characters Only Once
Set Variable [ $text; Value:Substitute($text;"%";"%25") ]
Set Variable [ $text; Value:Substitute($text;"/";"%2f") ]
End If
Exit Script [ Result: $text ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
No special character in the text should already be escaped,
otherwise the script may return unexpected results.
|
|
| |
| Script Usage |
Can be Referenced/Imported/Copy-Pasted.
Preferred Usage: Referencing
Note that this script should be used only when all the below listed characters
need to be escaped:
| ¢ |
%25a2 |
| £ |
%25a3 |
| ¥ |
%25a5 |
# |
%2523 |
[ |
%255b |
& |
%2526 |
? |
%253f |
; |
%253b |
> |
%2526gt%253b |
| / |
%252f |
| € |
%25e2%2582%25ac |
| ₣ |
%25e2%2582%25a3 |
| % |
%2525 |
| |
%257c |
] |
%255d |
@ |
%2540 |
+ |
%252b |
= |
%253d |
< |
%2526lt%253b |
| \ |
%255c |
|
| Category |
FusionCharts URL Utility Scripts |
| Script Parameters |
- text - The text which needs to be escaped
|
| Description |
Escapes the special characters in the given text
and returns the escaped text. |
| Result |
Returns the escaped text |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/12/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Escapes The Special Characters Which When Used Within Parameter Values, Can Cause Trouble
# Script Parameters:
# The Text Which Needs To Be Escaped
# Return Value:
# The New Text With The Special Characters Escaped
# Pre-requisites For This Script:
# Nil
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $text; Value:GetValue ( $parameters;1) ]
If [ Abs ( Get ( SystemPlatform )) = 2 ]
# Windows Platform
# Need To Double Escape The Characters
Set Variable [ $text; Value:Substitute($text;"%";"%2525") ]
Set Variable [ $text; Value:Substitute($text;"\"";"%2522") ]
Set Variable [ $text; Value:Substitute($text;"/";"%252f") ]
Set Variable [ $text; Value:Substitute($text;"\\";"%255c") ]
Set Variable [ $text; Value:Substitute($text;"#";"%2523") ]
Set Variable [ $text; Value:Substitute($text;"&";"%2526") ]
Set Variable [ $text; Value:Substitute($text;";";"%253b") ]
Set Variable [ $text; Value:Substitute($text;"=";"%253d") ]
Set Variable [ $text; Value:Substitute($text;">";"%2526gt%253b") ]
Set Variable [ $text; Value:Substitute($text;"?";"%253f") ]
# Note: This Character Will Not Appear On Screen In FusionCharts
Set Variable [ $text; Value:Substitute($text;"#";"%23") ]
Set Variable [ $text; Value:Substitute($text;"&";"%26") ]
Set Variable [ $text; Value:Substitute($text;";";"%3b") ]
Set Variable [ $text; Value:Substitute($text;"=";"%3d") ]
Set Variable [ $text; Value:Substitute($text;">";"%26gt%3b") ]
Set Variable [ $text; Value:Substitute($text;"?";"%3f") ]
# Note: This Character Will Not Appear On Screen In FusionCharts Free Version
Set Variable [ $text; Value:Substitute($text;"<";"%26lt%3b") ]
Set Variable [ $text; Value:Substitute($text;"@";"%40") ]
Set Variable [ $text; Value:Substitute($text;"[";"%5b") ]
Set Variable [ $text; Value:Substitute($text;"]";"%5d") ]
Set Variable [ $text; Value:Substitute($text;"|";"%7c") ]
Set Variable [ $text; Value:Substitute($text;"+";"%2b") ]
Set Variable [ $text; Value:Substitute($text;"¢";"%a2") ]
Set Variable [ $text; Value:Substitute($text;"£";"%a3") ]
Set Variable [ $text; Value:Substitute($text;"¥";"%a5") ]
Set Variable [ $text; Value:Substitute($text;"€";"%E2%82%AC") ]
Set Variable [ $text; Value:Substitute($text;"T";"%E2%82%A3") ]
End If
Exit Script [ Result: $text ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
No special character in the text should already
be escaped, otherwise the script may return unexpected results.
|
|
| |
| Script Usage |
Can be Referenced/Imported/Copy-Pasted.
Preferred Usage: Referencing |
| Category |
FusionCharts Utility Scripts |
| Script Parameters |
- quotedlist - The list which is present within quotes and in which the value has to be replaced.
- position - The position in the list at which the new value needs to be put
- NewValue - The new value that has to replace the existing value
|
| Description |
Replaces the value present at a given position in a list, with the new value |
| Result |
Returns the new list (within quotes) |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/08/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Replaces The Value Present At A Position
# In A List, With The New Value
# Script Parameters:
# 1. quotedlist - The List Which Is Present Within Quotes.
# 2. position - The Position At Which New Value Needs To Be Put
# 3. NewValue - The New Value That Has To Replace The Existing Value
# Return Value:
# The New List (Within Quotes)
# Appended To The Given Web Address
# Pre-requisites For This Script:
# Nil
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $quotedlist; Value:GetValue($parameters;1) ]
Set Variable [ $position; Value:GetAsNumber(GetValue($parameters;2)) ]
Set Variable [ $NewValue; Value:GetValue($parameters;3) ]
Set Variable [ $i; Value:1 ]
Set Variable [ $list; Value:Evaluate($quotedlist) ]
Loop
Exit Loop If [ $i>ValueCount ( $list ) ]
If [ $i U $position ]
Set Variable [ $newList; Value:If ($i U 1 ;$newList & "¶";"") & GetValue($list;$i) ]
Else
Set Variable [ $newList; Value:If ($i U 1 ;$newList & "¶";"") & $NewValue ]
End If
Set Variable [ $i; Value:$i+1 ]
End Loop
Exit Script [ Result: Quote($newList) ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
|
|
| |
| Script Usage |
Can be Imported/Copy-Pasted.
Preferred Usage: Import |
| Category |
FusionCharts Utility Scripts |
| Script Parameters |
- |
| Description |
Prints the chart currently being viewed. Provides a dialog to either print to paper or pdf or cancel the request. If pdf is selected, then Save records as PDF is performed. If printing has to be carried out to paper then, Print[] step is performed. In both cases, the user gets the corresponding options dialog. |
| Result |
- |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/08/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# This Script Can be Used For Printing.
# Script Parameters:
# Nil
# Return Value:
# Nil
# Pre-requisites For This Script:
# We Are In The Layout Where The Data To Be Printed Is Present.
# The Layout Has Been Created For Printing To The Right Size Paper, In Case Of Paper Printing.
# ---------------------------------------------
Show/Hide Status Area
[ Show ]
Allow User Abort [ Off ]
Print Setup [ Orientation: Landscape; Paper size: 8.5" x 12.69" ]
[ Restore; No dialog ]
Set Variable [ $CurrentRecordNumber; Value:Get(RecordNumber) ]
# Enter The Preview Mode
Enter Preview Mode
# Go To The Current Record
Go to Record/Request/Page [ $CurrentRecordNumber ]
[ No dialog ]
Adjust Window
[ Maximize ]
# Present Dialog For PDF Or Paper Printing
Show Custom Dialog [ Title: "Print Options"; Message: "Would you like to print to a PDF or to Paper?"; Buttons: “PDF”, “Paper”, “Cancel” ]
# User Cancels The Print
If [ Get ( LastMessageChoice ) = 3 ]
Enter Browse Mode
Exit Script [ ]
Else
Set Variable [ $Output; Value:If ( Get ( LastMessageChoice ) = 1 ; "PDF" ; "Paper" ) ]
End If
# If Print To PDF Was Selected, Use Save Records As PDF Command
If [ $Output = "PDF" ]
Allow User Abort [ Off ]
Save Records as PDF [ Current record ]
[ Document - Compatibility: Acrobat 5 and later ]
[ Pages - Number Pages From: 1; Include: All pages ]
[ Security - Printing: High Resolution; Editing: Any except extracting pages; Enable copying; Enable Screen Reader ]
[ Initial View - Show: Page Only; Page Layout: Single Page; Magnification: 75% ]
[ Restore ]
Else
# Print To Paper
Print [ ]
End If
# Enter Browse Mode
Enter Browse Mode |
| Scripts used in this script |
|
| Pre-requisites for this script |
|
|
| |
|
| |
| Script Usage |
Can be Imported/Copy-Pasted.
Preferred Usage: Import |
| Category |
FusionCharts Data Parameters Helper Scripts |
| Script Parameters |
- WebAddress - The URL to which data parameters have to be appended
- LabelFieldName - The field which has to be used for labels
- DataFieldName - The name of the field which has to be used for value
- NumberOfRepetitions - The number of repetitions of the field
- delimiter - (Optional) The delimiter to be used in this script. This
is an optional parameter. The default value used is the one specified
in global values when FusionCharts is initialized.
|
| Description |
Constructs and appends the data parameter by getting the values in the
repetition field |
| Result |
Returns the new web address with the data parameters appended to the
given web address |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/08/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Constructs And Appends The Data Parameter
# By Getting The Values In The Repetition Field
# Script Parameters:
# 1. WebAddress - The URL To Which Data Parameters Have To Be Appended
# 2. LabelFieldName - The Field Which Has To Be Used For Labels
# 3. DataFieldName - The Name Of The Field Which Has To Be Used For Value
# 4. NumberOfRepetitions - The Number Of Repetitions Of The Field
# 5. delimiter - (Optional) The Delimiter To Be Used In This Script.
# This Is An Optional Parameter. The Default Value Used Is The One Specified In Global Values When FusionCharts Is
Initialized.
# Return Value:
# The New Web Address With The Data Parameters
# Appended To The Given Web Address
# Pre-requisites For This Script:
# WebAddress Parameter Already Has The First Set Of Parameters In The QueryString Starting With ?
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]
Set Variable [ $LabelFieldName; Value:GetValue($parameters;2) ]
Set Variable [ $DataFieldName; Value:GetValue($parameters;3) ]
Set Variable [ $NumberOfRepetitions; Value:GetAsNumber(GetValue($parameters;4)) ]
Set Variable [ $delimiter; Value:GetValue($parameters;5) ]
Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) ]
# Initialize Values
Set Variable [ $LoopCounter; Value:1 ]
Set Variable [ $data; Value:"" ]
Loop
Exit Loop If [ $LoopCounter > $NumberOfRepetitions ]
Set Variable [ $labels; Value:$labels & If($LoopCounter I 1;$delimiter;"") & GetField($LabelFieldName) ]
Set Variable [ $data; Value:$data & If($LoopCounter I 1;$delimiter;"") & GetRepetition ( Evaluate(""&$DataFieldName);
$LoopCounter ) ]
Set Variable [ $LoopCounter; Value:$LoopCounter + 1 ]
End Loop
# Append The Labels And Data By Performing Script From FusionCharts Library
Perform Script [ “AppendSSLabelsAndDataToURL” from file: “FusionCharts Library”; Parameter: $WebAddress & "¶" & $labels & "¶" &
$data ]
Set Variable [ $NewWebAddress; Value:Get(ScriptResult) ]
Exit Script [ Result: $NewWebAddress ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
WebAddress parameter already has first set of parameters in the QueryString
starting with ?. |
|
| |
| Script Usage |
Can be Imported/Copy-Pasted.
Preferred Usage: Import |
| Category |
FusionCharts Data Parameters Helper Scripts |
| Script Parameters |
- WebAddress - The URL to which data parameters have to be appended
- LabelFieldName - The field which has to be used for labels
- SumByFieldName - The name of the field which has to be used for grouping
data
- DataFieldName - The name of the field which has to be used for value
- delimiter - (Optional) The delimiter to be used in this script. This
is an optional parameter. The default value used is the one specified
in global values when FusionCharts is initialized.
|
| Description |
Constructs the data parameter by summing the values by grouping data
based on SumByFieldName parameter and appends it to the given web address |
| Result |
Returns the new web address with the data parameters appended to the
given web address |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/11/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Constructs The Data Parameter
# By Summing The Values By Grouping Data Based On SumByFieldName Parameter
# Script Parameters:
# 1. WebAddress - The URL To Which Data Parameters Have To Be Appended
# 2. LabelFieldName - The Field Which Has To Be Used For Labels
# 3. SumByFieldName - The Name Of The Field Which Has To Be Used For Grouping Data
# 4. DataFieldName - The Name Of The Field Which Has To Be Used For Value
# 5. delimiter - (Optional) The Delimiter To Be Used In This Script.
# This Is An Optional Parameter. The Default Value Used Is
# The One Specified In Global Values When FusionCharts Is Initialized.
# Return Value:
# The New Web Address With The Data Parameters
# Appended To The Given Web Address
# Pre-requisites For This Script:
# WebAddress Parameter Already Has The First Set Of Parameters In The QueryString Starting With ?
# The Data Has To Be Sorted By SumByFieldName Field.
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]
Set Variable [ $LabelFieldName; Value:GetValue($parameters;2) ]
Set Variable [ $SumByFieldName; Value:GetValue($parameters;3) ]
Set Variable [ $DataFieldName; Value:GetValue($parameters;4) ]
Set Variable [ $delimiter; Value:GetValue($parameters;5) ]
Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) ]
# Initialize Values
Set Variable [ $TotalRows; Value:Get(FoundCount) ]
Set Variable [ $LoopCounter; Value:1 ]
Set Variable [ $previousTotalValue; Value:0 ]
Set Variable [ $PreviousSumByFieldValue; Value:"" ]
Set Variable [ $appendDelimiter; Value:False ]
# Loop Through The Records To Calculate The Total Values
Loop
Exit Loop If [ $LoopCounter > $TotalRows ]
Go to Record/Request/Page [ $LoopCounter ]
[ No dialog ]
# Get The Field Value Of $SumByFieldName By Which The Data Has To Be Grouped And Summed Up.
Set Variable [ $SumByFieldValue; Value:GetField($SumByFieldName) ]
# Get The Label For This Record
Set Variable [ $LabelValue; Value:GetField($LabelFieldName) ]
Set Variable [ $currentValue; Value:GetField($DataFieldName) ]
# If sumByFieldValue For This Record Is Not Equal To That Of Previous Record,
# Then Append The Previous Totals To The Data Parameter
If [ $SumByFieldValue I $PreviousSumByFieldValue and $LoopCounter I 1 ]
Set Variable [ $labels; Value:$labels & If($appendDelimiter;$delimiter;"") & $previousLabel ]
Set Variable [ $data; Value:$data & If($appendDelimiter;$delimiter;"") & $previousTotalValue ]
Set Variable [ $appendDelimiter; Value:True ]
Set Variable [ $previousTotalValue; Value:0 ]
End If
Set Variable [ $previousLabel; Value:$LabelValue ]
Set Variable [ $previousTotalValue; Value:$previousTotalValue + $currentValue ]
# For The Last Record
If [ $LoopCounter=$TotalRows ]
Set Variable [ $labels; Value:$labels & If($appendDelimiter;$delimiter;"") & $previousLabel ]
Set Variable [ $data; Value:$data & If($appendDelimiter;$delimiter;"") & $previousTotalValue ]
Set Variable [ $appendDelimiter; Value:True ]
Set Variable [ $previousTotalValue; Value:0 ]
End If
Set Variable [ $currentValue; Value:0 ]
Set Variable [ $LoopCounter; Value:$LoopCounter + 1 ]
Set Variable [ $PreviousSumByFieldValue; Value:$SumByFieldValue ]
End Loop
# Escape The Labels For Forward Slash And Percentage Characters.
# Perform Script From Library
Perform Script [ “EscapePercentAndForwardSlashCharacters” from file: “FusionCharts Library”; Parameter: $labels ]
Set Variable [ $labels; Value:Get(ScriptResult) ]
# Append The Labels And Data By Performing A Script From FusionCharts Library
Perform Script [ “AppendSSLabelsAndDataToURL” from file: “FusionCharts Library”; Parameter: $WebAddress & "¶" & $labels & "¶" &
$data ]
Set Variable [ $NewWebAddress; Value:Get(ScriptResult) ]
# Return The New Web Address
Exit Script [ Result: $NewWebAddress ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
WebAddress parameter already has first set of parameters in the QueryString
starting with ?.
The data has to be sorted by SumByFieldName field. |
|
| |
| Script Usage |
Can be Imported/Copy-Pasted.
Preferred Usage: Import |
| Category |
FusionCharts Data Parameters Helper Scripts |
| Script Parameters |
- WebAddress - The URL to which data parameters have to be appended
- LabelFieldName - The field which has to be used for labels
- DataFieldName - The name of the field which has to be used for value
- delimiter - (Optional) The delimiter to be used in this script. This
is an optional parameter. The default value used is the one specified
in global values when FusionCharts is initialized.
|
| Description |
Constructs the data parameter by looping through the portal record by
record. Assumes that we are in the layout where the data is present in
portal and uses the values from Active portal.
The data is gathered from the active portal in the current layout. |
| Result |
Returns the new web address with the data parameters appended to the
given web address |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/11/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# This Script Constructs The Data Parameter
# By Looping Through The Portal Record By Record
# Assumes That We Are In The Layout Where The Data Is Present In Portal
# And Uses The Values From Active Portal
# Script Parameters:
# 1. WebAddress - The URL To Which Data Parameters Have To Be Appended
# 2. LabelFieldName - The Field Which Has To Be Used For Labels
# 3. DataFieldName - The Name Of The Field Which Has To Be Used For Value
# 4. delimiter - (Optional) The Delimiter To Be Used In This Script.
# This Is An Optional Parameter. The Default Value Used Is The One Specified In Global Values When FusionCharts Is
Initialized.
# Return Value:
# The New Web Address With The Data Parameters
# Appended To The Given Web Address
# Pre-requisites For This Script:
# WebAddress Parameter Already Has The First Set Of Parameters In The QueryString Starting With ?
# We Are In The Layout Where The Portal Is Present And The Portal With The Data Is Active.
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]
Set Variable [ $LabelFieldName; Value:GetValue($parameters;2) ]
Set Variable [ $DataFieldName; Value:GetValue($parameters;3) ]
Set Variable [ $delimiter; Value:GetValue($parameters;4) ]
# Delimiter Value To Be Used For This Chart
Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) ]
# Initializing All Variables That Are Being Used In This Script
Set Variable [ $data; Value:"" ]
Set Variable [ $labels; Value:"" ]
Set Variable [ $recordCount; Value:1 ]
Set Variable [ $OriginalSelectedRow; Value:Get(PortalRowNumber) ]
# Go To The Last Row In The Portal
Go to Portal Row
[ Last ]
# Get The Total Number Of Rows
Set Variable [ $TotalRows; Value:Get(PortalRowNumber) ]
Set Variable [ $appendDelimiter; Value:False ]
# Loop Through The Records To Create
# The Data Parameters Part Of The Query String
Loop
Exit Loop If [ $recordCount > $TotalRows ]
Go to Portal Row [ $recordCount ]
[ No dialog ]
# Labels To Be Displayed,
# Separated By Delimiter
Set Variable [ $labels; Value:$labels & If($appendDelimiter;$delimiter;"") & GetField($LabelFieldName) ]
# The Data Used To Draw The Chart - The Amount Field Value
Set Variable [ $data; Value:$data & If($appendDelimiter;$delimiter;"") & GetField($DataFieldName) ]
Set Variable [ $appendDelimiter; Value:True ]
Set Variable [ $recordCount; Value:$recordCount + 1 ]
End Loop
# Go To The Portal Row Where The Focus Initially Was
Go to Portal Row [ $OriginalSelectedRow ]
[ No dialog ]
Perform Script [ “AppendSSLabelsAndDataToURL” from file: “FusionCharts Library”; Parameter: $WebAddress & "¶" & $labels &"¶" &
$data ]
Set Variable [ $NewWebAddress; Value:Get(ScriptResult) ]
Exit Script [ Result: $NewWebAddress ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
WebAddress parameter already has first set of parameters in the QueryString
starting with ?.
We are in the layout where the portal is present and the portal with
the data is active.
|
|
| |
| Script Usage |
Can be Imported/Copy-Pasted.
Preferred Usage: Import |
| Category |
FusionCharts Data Parameters Helper Scripts |
| Script Parameters |
- WebAddress - The URL to which data parameters have to be appended
- LabelFieldName - The field which has to be used for labels
- DataFieldName - The name of the field which has to be used for value
- GroupByFieldName - The name of the field by which the data is grouped
- GroupByCountField - The name of the summary field which gives the
count
- delimiter - (Optional) The delimiter to be used in this script. This
is an optional parameter. The default value used is the one specified
in global values when FusionCharts is initialized.
|
| Description |
Constructs the data parameter by summing the value, after grouping by
the SumByFieldName.
The data is gathered from the active portal in the current layout. |
| Result |
Returns the new web address with the data parameters appended to the
given web address |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/11/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# This Script Constructs The Data Parameter
# By Using GetSummary, After Grouping By The GroupByFieldName
# Assumes That We Are In The Layout Where The Data Is Present In Portal
# And Uses The Values From Active Portal
# Script Parameters:
# 1. WebAddress - The URL To Which Data Parameters Have To Be Appended
# 2. LabelFieldName - The Field Which Has To Be Used For Labels
# 3. DataFieldName - The Name Of The Field Which Has To Be Used For Value
# 4. GroupByFieldName - The Name Of The Field By Which The Data Is Grouped
# 5. GroupByCountField - The Name Of The Summary Field Which Gives The Count
# 6. delimiter - (Optional) The Delimiter To Be Used In This Script.
# This Is An Optional Parameter. The Default Value Used Is The One Specified In Global Values When FusionCharts Is
Initialized.
# Return Value:
# The New Web Address With The Data Parameters
# Appended To The Given Web Address
# Pre-requisites For This Script:
# WebAddress Parameter Already Has The First Set Of Parameters In The QueryString Starting With ?
# We Are In The Layout Where The Portal Is Present And The Portal With The Data Is Active.
# Count field(GroupByCountField) Is Defined For The Field (GroupByFieldName) By Which Data Is Sorted.
# Count field Is A Summary Field Defined As The Count Of A Unique Field,
# Summary Restarted For Each Group When Sorted By A GroupByFieldName Field.
# The Data Has To Be Sorted By This GroupByFieldName Field.
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]
Set Variable [ $LabelFieldName; Value:GetValue($parameters;2) ]
Set Variable [ $DataFieldName; Value:GetValue($parameters;3) ]
Set Variable [ $GroupByFieldName; Value:GetValue($parameters;4) ]
Set Variable [ $GroupByCountField; Value:GetValue($parameters;5) ]
Set Variable [ $delimiter; Value:GetValue($parameters;6) ]
# Delimiter Value To Be Used For This Chart
Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) ]
# Initializing All Variables That Are Being Used In This Script
Set Variable [ $data; Value:"" ]
Set Variable [ $labels; Value:"" ]
Set Variable [ $loopCounter; Value:0 ]
Set Variable [ $OriginalSelectedRow; Value:Get(PortalRowNumber) ]
# Go To The Last Row In The Portal
Go to Portal Row
[ Last ]
# Get The Total Number Of Rows
Set Variable [ $totalRows; Value:Get(PortalRowNumber) ]
Set Variable [ $recordCount; Value:1 ]
Set Error Capture [ On ]
# Go To The First Row In The Portal
Go to Portal Row
[ Select; First ]
# Loop Through Each Row In The Portal
Loop
Exit Loop If [ $recordCount > $totalRows ]
Set Variable [ $loopCounter; Value:$loopCounter+1 ]
If [ $loopCounter=1 ]
Set Variable [ $delim; Value:"" ]
Else
Set Variable [ $delim; Value:$delimiter ]
End If
# Get The Value For Label
Set Variable [ $labels; Value:$labels & $delim & GetField($LabelFieldName) ]
# Get The Value Present In $DataFieldName Using GetField
# This Field Will Usually Be The Summary Field
# Containing The Sum When Grouped By The Field GroupByFieldName
Set Variable [ $data; Value:$data & $delim & GetField($DataFieldName) ]
Set Variable [ $counter; Value:GetSummary ( GetField($GroupByCountField);GetField($GroupByFieldName)) ]
Exit Loop If [ IsEmpty($counter) or $counter=0 ]
Set Variable [ $recordCount; Value:$recordCount + $counter ]
# Go To The Next Portal Row - Move To Next Group In The Portal
Go to Portal Row [ $recordCount ]
[ Select; No dialog ]
End Loop
# Go To The Row Which Was Initially Selected By The User
Go to Portal Row [ $OriginalSelectedRow ]
[ No dialog ]
# Perform Script From FusionCharts Library To Append The Labels And Data To The URL
Perform Script [ “AppendSSLabelsAndDataToURL” from file: “FusionCharts Library”; Parameter: $WebAddress &"¶" & $labels & "¶" &
$data ]
Set Variable [ $NewWebAddress; Value:Get(ScriptResult) ]
# Return The New Web Address
Exit Script [ Result: $NewWebAddress ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
WebAddress parameter already has first set of parameters in the QueryString
starting with ?.
We are in the layout where the portal is present and the portal with
the data is active.
Count field(GroupByCountField) is defined for the field (GroupByFieldName)
by which data is sorted. Count field is a summary field defined as the
count of a unique field, summary restarted for each group when sorted
by a GroupByFieldName field. The data has to be sorted by this GroupByFieldName
field.
|
|
| |
| Script Usage |
Can be Imported/Copy-Pasted.
Preferred Usage: Import |
| Category |
FusionCharts Data Parameters Helper Scripts |
| Script Parameters |
- WebAddress - The URL to which data parameters have to be appended
- LabelFieldName - The field which has to be used for labels
- DataFieldName - The name of the field which has to be used for value
- delimiter - (Optional) The delimiter to be used in this script. This
is an optional parameter. The default value used is the one specified
in global values when FusionCharts is initialized.
|
| Description |
Constructs the data parameter by using the DataFieldName field for value.
Assumes that we are in the layout where the data is present and uses
GetNthRecord for getting the values |
| Result |
Returns the new web address with the data parameters appended to the
given web address |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/11/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# This Script Constructs The Data Parameter
# By Using The DataFieldName Field For Value
# Assumes That We Are In The Layout Where The Data Is Present
# And Uses GetNthRecord For Getting The Values
# Script Parameters:
# 1. WebAddress - The URL To Which Data Parameters Have To Be Appended
# 2. LabelFieldName - The Field Which Has To Be Used For Labels
# 3. DataFieldName - The Name Of The Field Which Has To Be Used For Value
# 4. delimiter - (Optional) The Delimiter To Be Used In This Script.
# This Is An Optional Parameter. The Default Value Used Is The One Specified In Global Values When FusionCharts Is
Initialized.
# Return Value:
# The New Web Address With The Data Parameters
# Appended To The Given Web Address
# Pre-requisites For This Script:
# WebAddress Parameter Already Has The First Set Of Parameters In The QueryString Starting With ?
# We Are In The Layout Where The Data Is Present.
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]
Set Variable [ $LabelFieldName; Value:GetValue($parameters;2) ]
Set Variable [ $DataFieldName; Value:GetValue($parameters;3) ]
Set Variable [ $delimiter; Value:GetValue($parameters;4) ]
# Delimiter Value To Be Used For This Chart
Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) ]
# Initializing All Variables That Are Being Used In This Script
Set Variable [ $values; Value:"" ]
Set Variable [ $showLabels; Value:"" ]
Set Variable [ $labels; Value:"" ]
Set Variable [ $loopCounter; Value:0 ]
Set Variable [ $recordCount; Value:1 ]
# Get The Total Number Of Rows
Set Variable [ $totalRows; Value:Get(FoundCount) ]
Set Error Capture [ On ]
# Loop Through The Records
Loop
Exit Loop If [ $recordCount > $totalRows ]
Set Variable [ $currentLabel; Value:GetNthRecord (GetField($LabelFieldName); $recordCount) ]
Set Variable [ $currentValue; Value:GetNthRecord (GetField($DataFieldName);$recordCount) ]
Set Variable [ $loopCounter; Value:$loopCounter+1 ]
If [ $loopCounter=1 ]
Set Variable [ $delim; Value:"" ]
Else
Set Variable [ $delim; Value:$delimiter ]
End If
# The Label Used For Display In The Chart
Set Variable [ $labels; Value:$labels & $delim & $currentLabel ]
# The Value Used In The Chart
Set Variable [ $values; Value:$values & $delim & $currentValue ]
# Loop Through The Records One By One
Set Variable [ $recordCount; Value:$recordCount +1 ]
End Loop
# Perform Script From FusionCharts Library To Append The Labels And Data To The URL
Perform Script [ “AppendSSLabelsAndDataToURL” from file: “FusionCharts Library”; Parameter: $WebAddress &"¶" & $labels & "¶" &
$values ]
Set Variable [ $NewWebAddress; Value:Get(ScriptResult) ]
# Return The New Web Address
Exit Script [ Result: $NewWebAddress ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
WebAddress parameter already has first set of parameters in the QueryString
starting with ?.
We are in the layout where the data is present.
|
|
| |
| Script Usage |
Can be Imported/Copy-Pasted.
Preferred Usage: Import |
| Category |
FusionCharts Data Parameters Helper Scripts |
| Script Parameters |
- WebAddress - The URL to which data parameters have to be appended
- LabelFieldName - The field which has to be used for labels
- DataFieldName - The name of the field which has to be used for value
- delimiter - (Optional) The delimiter to be used in this script. This is an optional parameter. The default value used is the one specified in global values when FusionCharts is initialized.
|
| Description |
Constructs the data parameter by using the DataFieldName field for value.
Assumes that we are in the layout where the data is present and uses GetNthRecord for getting the values
Note that this script is exactly same as the previous script. This script uses a user-friendly script name. That is all. |
| Result |
Returns the new web address with the data parameters appended to the given web address |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/11/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# This Script Constructs The Data Parameter
# By Using The DataFieldName Field For Value
# Assumes That We Are In The Layout Where The Data Is Present
# And Uses GetNthRecord For Getting The Values
# Script Parameters:
# 1. WebAddress - The URL To Which Data Parameters Have To Be Appended
# 2. LabelFieldName - The Field Which Has To Be Used For Labels
# 3. DataFieldName - The Name Of The Field Which Has To Be Used For Value
# 4. delimiter - (Optional) The Delimiter To Be Used In This Script.
# This Is An Optional Parameter. The Default Value Used Is The One Specified In Global Values When FusionCharts Is
Initialized.
# Return Value:
# The New Web Address With The Data Parameters
# Appended To The Given Web Address
# Pre-requisites For This Script:
# WebAddress Parameter Already Has The First Set Of Parameters In The QueryString Starting With ?
# We Are In The Layout Where The Data Is Present.
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]
Set Variable [ $LabelFieldName; Value:GetValue($parameters;2) ]
Set Variable [ $DataFieldName; Value:GetValue($parameters;3) ]
Set Variable [ $delimiter; Value:GetValue($parameters;4) ]
# Delimiter Value To Be Used For This Chart
Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) ]
# Initializing All Variables That Are Being Used In This Script
Set Variable [ $values; Value:"" ]
Set Variable [ $showLabels; Value:"" ]
Set Variable [ $labels; Value:"" ]
Set Variable [ $loopCounter; Value:0 ]
Set Variable [ $recordCount; Value:1 ]
# Get The Total Number Of Rows
Set Variable [ $totalRows; Value:Get(FoundCount) ]
Set Error Capture [ On ]
# Loop Through The Records
Loop
Exit Loop If [ $recordCount > $totalRows ]
Set Variable [ $currentLabel; Value:GetNthRecord (GetField($LabelFieldName); $recordCount) ]
Set Variable [ $currentValue; Value:GetNthRecord (GetField($DataFieldName);$recordCount) ]
Set Variable [ $loopCounter; Value:$loopCounter+1 ]
If [ $loopCounter=1 ]
Set Variable [ $delim; Value:"" ]
Else
Set Variable [ $delim; Value:$delimiter ]
End If
# The Label Used For Display In The Chart
Set Variable [ $labels; Value:$labels & $delim & $currentLabel ]
# The Value Used In The Chart
Set Variable [ $values; Value:$values & $delim & $currentValue ]
# Loop Through The Records One By One
Set Variable [ $recordCount; Value:$recordCount +1 ]
End Loop
# Perform Script From FusionCharts Library To Append The Labels And Data To The URL
Perform Script [ “AppendSSLabelsAndDataToURL” from file: “FusionCharts Library”; Parameter: $WebAddress &"¶" & $labels & "¶" &
$values ]
Set Variable [ $NewWebAddress; Value:Get(ScriptResult) ]
# Return The New Web Address
Exit Script [ Result: $NewWebAddress ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
WebAddress parameter already has first set of parameters in the QueryString starting with ?.
We are in the layout where the data is present. |
|
| |
| Script Usage |
Can be Imported/Copy-Pasted.
Preferred Usage: Import |
| Category |
FusionCharts Data Parameters Helper Scripts |
| Script Parameters |
- WebAddress - The URL to which data parameters have to be appended
- LabelListName - The Value List which has to be used for labels
- DataFieldName - The name of the field which has to be used for value
- delimiter - (Optional) The delimiter to be used in this script. This
is an optional parameter. The default value used is the one specified
in global values when FusionCharts is initialized.
|
| Description |
Constructs the data parameter from the DataFieldName field.
Assumes that we are in the layout where the data is present and uses
GetNthRecord for getting the values. Uses Value
List to get the labels. |
| Result |
Returns the new web address with the data parameters appended to the
given web address |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/11/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# This Script Constructs The Data Parameter
# By Using GetNthRecord For Data And Value List For Labels
# Assumes That We Are In The Layout Where The Data Is Present
# Script Parameters:
# 1. WebAddress - The URL To Which Data Parameters Have To Be Appended
# 2. LabelListName - The Value List Which Has To Be Used For Labels
# 3. DataFieldName - The Name Of The Field Which Has To Be Used For Value
# 4. delimiter - (Optional) The Delimiter To Be Used In This Script.
# This Is An Optional Parameter. The Default Value Used Is The One Specified In Global Values When FusionCharts Is
Initialized.
# Return Value:
# The New Web Address With The Data Parameters
# Appended To The Given Web Address
# Pre-requisites For This Script:
# WebAddress Parameter Already Has The First Set Of Parameters In The QueryString Starting With ?
# We Are In The Layout Where The Data Is Present.
# Value List With The Name As Specified In LabelList Is Defined.
# The Value List Identified By LabelListName Is Present In The Same fp7 As This Script.
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]
Set Variable [ $LabelListName; Value:GetValue($parameters;2) ]
Set Variable [ $DataFieldName; Value:GetValue($parameters;3) ]
Set Variable [ $delimiter; Value:GetValue($parameters;4) ]
# Delimiter Value To Be Used For This Chart
Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) ]
# Initializing All Variables That Are Being Used In This Script
Set Variable [ $values; Value:"" ]
Set Variable [ $showLabels; Value:"" ]
Set Variable [ $loopCounter; Value:0 ]
Set Variable [ $recordCount; Value:1 ]
# Get The Total Number Of Rows
Set Variable [ $totalRows; Value:Get(FoundCount) ]
Set Variable [ $labels; Value:Substitute(ValueListItems(Get(FileName);$LabelListName);"¶";$$delimiter) ]
Set Error Capture [ On ]
# Loop Through The Records
Loop
Exit Loop If [ $recordCount > $totalRows ]
Set Variable [ $currentValue; Value:GetNthRecord (GetField($DataFieldName);$recordCount) ]
Set Variable [ $loopCounter; Value:$loopCounter+1 ]
If [ $loopCounter=1 ]
Set Variable [ $delim; Value:"" ]
Set Variable [ $delim; Value:$delimiter ]
End If
# The Value Used In The Chart
Set Variable [ $values; Value:$values & $delim & $currentValue ]
# Loop Through The Records One By One
Set Variable [ $recordCount; Value:$recordCount +1 ]
End Loop
# Perform Script From FusionCharts Library To Append The Labels And Data To The URL
Perform Script [ “AppendSSLabelsAndDataToURL” from file: “FusionCharts Library”; Parameter: $WebAddress &"¶" & $labels & "¶" &
$values ]
Set Variable [ $NewWebAddress; Value:Get(ScriptResult) ]
# Return The New Web Address
Exit Script [ Result: $NewWebAddress ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
WebAddress parameter already has first set of parameters in the QueryString
starting with ?.
We are in the layout where the data is present.
LabelList and the file in which it is present has to be accessible from
external fp7 file. |
|
| |
| Script Usage |
Can be Imported/Copy-Pasted.
Preferred Usage: Import |
| Category |
FusionCharts Data Parameters Helper Scripts |
| Script Parameters |
- WebAddress - The URL to which data parameters have to be appended
- LabelFieldName - The field which has to be used for labels
- DataFieldName - The name of the field which has to be used for value
- CountSummaryField - The name of the summary field for the count of records in each group
- recordCount - The record number to start from
- delimiter - (Optional) The delimiter to be used in this script. This
is an optional parameter. The default value used is the one specified
in global values when FusionCharts is initialized.
|
| Description |
Constructs the data parameter by using the DataFieldName field for value.
Moves through records in groups instead of one after the other
Assumes that we are in the layout where the data is present and uses
GetNthRecord for getting the values. |
| Result |
Returns the new web address with the data parameters appended to the
given web address |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/11/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# This Script Constructs The Data Parameter
# By Using The DataFieldName Field For Value.
# Moves Through Records In Groups Instead Of One After The Other.
# Assumes That We Are In The Layout Where The Data Is Present
# And Uses GetNthRecord For Getting The Values.
# Most Importantly, It Assumes That The Summary Field Has Been Created.
# Script Parameters:
# 1. WebAddress - The URL To Which Data Parameters Have To Be Appended
# 2. LabelFieldName - The Field Which Has To Be Used For Labels
# 3. DataFieldName - The Name Of The Field Which Has To Be Used For Value
# 4. CountSummaryField - The Name Of The Summary Field For The Count Of Records In Each Group
# 5. recordCount - The Record Number To Start From
# 6. delimiter - (Optional) The Delimiter To Be Used In This Script.
# This Is An Optional Parameter. The Default Value Used Is The One Specified In Global Values When FusionCharts Is
Initialized.
# Return Value:
# The New Web Address With The Data Parameters
# Appended To The Given Web Address
# Pre-requisites For This Script:
# WebAddress Parameter Already Has The First Set Of Parameters In The QueryString Starting With ?
# We Are In The Layout Where The Data Is Present.
# Count Field Is Defined For The Field By Which Data Is Sorted.
# Count Field Is A Summary Field Defined As The Count Of A Unique Field,
# Summary Restarted For Each Group When Sorted By A Particular Field.
# The Data Has To Be Sorted By This Particular Field.
# Requires A Count Field And A Summary Field Which Summarizes The Count For Each Group.
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]
Set Variable [ $LabelFieldName; Value:GetValue($parameters;2) ]
Set Variable [ $DataFieldName; Value:GetValue($parameters;3) ]
Set Variable [ $GroupByCountField; Value:GetValue($parameters;4) ]
# Record Number To Start From
Set Variable [ $recordCount; Value:GetAsNumber(GetValue ($parameters;5)) ]
Set Variable [ $delimiter; Value:GetValue($parameters;6) ]
# Delimiter Value To Be Used For This Chart
Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) ]
# Initializing All Variables That Are Being Used In This Script
Set Variable [ $values; Value:"" ]
Set Variable [ $showLabels; Value:"" ]
Set Variable [ $labels; Value:"" ]
Set Variable [ $loopCounter; Value:0 ]
# Get The Total Number Of Rows
Set Variable [ $totalRows; Value:Get(FoundCount) ]
Set Error Capture [ On ]
# Loop Through The Records
Loop
Exit Loop If [ $recordCount > $totalRows ]
Set Variable [ $currentLabel; Value:GetNthRecord (GetField($LabelFieldName); $recordCount) ]
Set Variable [ $currentValue; Value:GetNthRecord (GetField($DataFieldName);$recordCount) ]
# Get The Total Number Of Records In This Group
Set Variable [ $currentTotalForGroupCount; Value:GetNthRecord (GetField($GroupByCountField);$recordCount) ]
Set Variable [ $loopCounter; Value:$loopCounter+1 ]
If [ $loopCounter=1 ]
Set Variable [ $delim; Value:"" ]
Else
Set Variable [ $delim; Value:$delimiter ]
End If
# The Label Used For Display In The Chart
Set Variable [ $labels; Value:$labels & $delim & $currentLabel ]
# The Value Used In The Chart (Summary Field Containing The Total For This Group)
Set Variable [ $values; Value:$values & $delim & $currentValue ]
# Loop Through The Records In Groups
# Move On To The Next Group So That We Get Unique Values
Set Variable [ $recordCount; Value:$recordCount +$currentTotalForGroupCount ]
End Loop
# Perform Script From FusionCharts Library To Append The Labels And Data To The URL
Perform Script [ “AppendSSLabelsAndDataToURL” from file: “FusionCharts Library”; Parameter: $WebAddress &"¶" & $labels & "¶" &
$values ]
Set Variable [ $NewWebAddress; Value:Get(ScriptResult) ]
# Return The New Web Address
Exit Script [ Result: $NewWebAddress ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
WebAddress parameter already has first set of parameters in the QueryString
starting with ?.
We are in the layout where the data is present.
Summary field is defined as the total number of records in each group. The data has to be sorted
by this particular field.
|
|
| |
| Script Usage |
Can be Imported/Copy-Pasted.
Preferred Usage: Import |
| Category |
FusionCharts Data Parameters Helper Scripts |
| Script Parameters |
- WebAddress - The URL to which data parameters have to be appended
- LabelFieldName - The field which has to be used for labels
- DataFieldName - The name of the field which has to be used for value
- GroupByCountField - The name of the count field for the groups
- recordCount - The record number to start from
- delimiter - (Optional) The delimiter to be used in this script. This is an optional parameter. The default value used is the one specified in global values when FusionCharts is initialized.
|
| Description |
Constructs the data parameter by using the DataFieldName field for value. Moves through records in groups instead of one after the other
Assumes that we are in the layout where the data is present and uses GetNthRecord for getting the values. |
| Result |
Returns the new web address with the data parameters appended to the given web address |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/11/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# This Script Constructs The Data Parameter
# By Using The DataFieldName Field For Value.
# Moves Through Records In Groups Instead Of One After The Other.
# Assumes That We Are In The Layout Where The Data Is Present
# And Uses GetNthRecord For Getting The Values.
# Requires Count Field To Be Defined For Groups.
# Script Parameters:
# 1. WebAddress - The URL To Which Data Parameters Have To Be Appended
# 2. LabelFieldName - The Field Which Has To Be Used For Labels
# 3. DataFieldName - The Name Of The Field Which Has To Be Used For Value
# 4. GroupByFieldName - The Name Of The Field By Which To Group Data
# 5. GroupByCountField - The Name Of The Count Field For The Groups
# 6. recordCount - The Record Number To Start From
# 7. delimiter - (Optional) The Delimiter To Be Used In This Script.
# This Is An Optional Parameter. The Default Value Used Is The One Specified In Global Values When FusionCharts Is
Initialized.
# Return Value:
# The New Web Address With The Data Parameters
# Appended To The Given Web Address
# Pre-requisites For This Script:
# WebAddress Parameter Already Has The First Set Of Parameters In The QueryString Starting With ?
# Count Field Is Defined For The Field By Which Data Is Sorted.
# Count Field Is A Summary Field Defined As The Count Of A Unique Field,
# Summary Restarted For Each Group When Sorted By A Particular Field.
# The Data Has To Be Sorted By This Particular Field.
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]
Set Variable [ $LabelFieldName; Value:GetValue($parameters;2) ]
Set Variable [ $DataFieldName; Value:GetValue($parameters;3) ]
Set Variable [ $GroupByFieldName; Value:GetValue($parameters;4) ]
Set Variable [ $GroupByCountField; Value:GetValue($parameters;5) ]
# Record Number To Start From
Set Variable [ $recordCount; Value:GetAsNumber(GetValue ($parameters;6)) ]
Set Variable [ $delimiter; Value:GetValue($parameters;7) ]
# Delimiter Value To Be Used For This Chart
Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) ]
# Initializing All Variables That Are Being Used In This Script
Set Variable [ $values; Value:"" ]
Set Variable [ $showLabels; Value:"" ]
Set Variable [ $labels; Value:"" ]
Set Variable [ $loopCounter; Value:0 ]
# Get The Total Number Of Rows
Set Variable [ $totalRows; Value:Get(FoundCount) ]
Set Error Capture [ On ]
# Loop Through The Records
Loop
Exit Loop If [ $recordCount > $totalRows ]
Set Variable [ $currentLabel; Value:GetNthRecord (GetField($LabelFieldName); $recordCount) ]
Set Variable [ $currentValue; Value:GetNthRecord (GetField($DataFieldName);$recordCount) ]
Set Variable [ $currentGroupBy; Value:GetNthRecord (GetField($GroupByFieldName);$recordCount) ]
# Get The Total Number Of Records In This Group
Set Variable [ $currentTotalForGroupCount; Value:GetSummary ( GetField($GroupByCountField);$currentGroupBy) ]
Set Variable [ $loopCounter; Value:$loopCounter+1 ]
If [ $loopCounter=1 ]
Set Variable [ $delim; Value:"" ]
Else
Set Variable [ $delim; Value:$delimiter ]
End If
# The Label Used For Display In The Chart
Set Variable [ $labels; Value:$labels & $delim & $currentLabel ]
# The Value Used In The Chart (Summary Field Containing The Total For This Group)
Set Variable [ $values; Value:$values & $delim & $currentValue ]
# Loop Through The Records In Groups
# Move On To The Next Group So That We Get Unique Values
Set Variable [ $recordCount; Value:$recordCount +$currentTotalForGroupCount ]
End Loop
# Perform Script From FusionCharts Library To Append The Labels And Data To The URL
Perform Script [ “AppendSSLabelsAndDataToURL” from file: “FusionCharts Library”; Parameter: $WebAddress &"¶" & $labels & "¶" &
$values ]
Set Variable [ $NewWebAddress; Value:Get(ScriptResult) ]
# Return The New Web Address
Exit Script [ Result: $NewWebAddress ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
WebAddress parameter already has first set of parameters in the QueryString starting with ?.
We are in the layout where the data is present.
Count field is defined for the field by which data is sorted. Count field is a summary field defined as the count of a unique field, summary restarted for each group when sorted by a particular field. The data has to be sorted by this particular field. |
|
| |
| Script Usage |
Can be Imported/Copy-Pasted.
Preferred Usage: Import |
| Category |
FusionCharts Data Parameters Helper Scripts |
| Script Parameters |
- WebAddress - The URL to which data parameters have to be appended
- LabelFieldName - The field which has to be used for labels
- DataFieldName - The name of the field which has to be used for label
- SeriesNameField - The field which has to be used as series name
- NumberOfRepetitions - The number of repetitions of the field
- delimiter - (Optional) The delimiter to be used in this script.
This is an optional parameter. The default value used is
the one specified in global values when FusionCharts is initialized.
|
| Description |
Constructs and appends the data parameter for multi-series chart by getting the values in the repetition field.
Assumes that the current layout has the data and uses GetNthRecord for getting the values. |
| Result |
Returns the new web address with the data parameters appended to the given web address |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/11/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Constructs And Appends The Data Parameter
# By Getting The Values In The Repetition Field
# Script Parameters:
# 1. WebAddress - The URL To Which Data Parameters Have To Be Appended
# 2. LabelFieldName - The Field Which Has To Be Used For Labels
# 3. DataFieldName - The Name Of The Field Which Has To Be Used For Value
# 4. SeriesNameField - The Field Which Has To Be Used As The Series Name
# 5. NumberOfRepetitions - The Number Of Repetitions Of The Field
# 6. delimiter - (Optional) The Delimiter To Be Used In This Script.
# This Is An Optional Parameter. The Default Value Used Is
# The One Specified In Global Values When FusionCharts Is Initialized.
# Return Value:
# The New Web Address With The Data Parameters
# Appended To The Given Web Address
# Pre-requisites For This Script:
# WebAddress Parameter Already Has The First Set Of Parameters In The QueryString Starting With ?
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]
Set Variable [ $LabelFieldName; Value:GetValue($parameters;2) ]
Set Variable [ $DataFieldName; Value:GetValue($parameters;3) ]
Set Variable [ $SeriesNameField; Value:GetValue($parameters;4) ]
Set Variable [ $NumberOfRepetitions; Value:GetAsNumber(GetValue($parameters;5)) ]
Set Variable [ $delimiter; Value:GetValue($parameters;6) ]
Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) ]
# Initialize Values
Set Variable [ $data; Value:"" ]
Set Variable [ $labels; Value:Substitute(List(Evaluate($LabelFieldName));"¶";$delimiter) ]
Go to Record/Request/Page
[ First ]
Loop
Set Variable [ $seriesName; Value:GetField($SeriesNameField) ]
Set Variable [ $dataSeries; Value:"&data=[seriesName=" &$seriesName& "]" & Substitute(List(Evaluate($DataFieldName));"¶";
$delimiter) ]
Set Variable [ $data; Value:$data & $dataSeries ]
Go to Record/Request/Page
[ Next; Exit after last ]
End Loop
Set Variable [ $NewWebAddress; Value:$WebAddress & "&labels=" & $labels & $data ]
Exit Script [ Result: $NewWebAddress ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
WebAddress parameter already has first set of parameters in the QueryString starting with ?.
We are in the layout where the data is present. The Value List identified by LabelListName is present in the same fp7 as this script.
Note that this script needs to be imported/copy-pasted as mentioned in the Script Usage. |
|
| |
| Script Usage |
Can be Imported/Copy-Pasted.
Preferred Usage: Import |
| Category |
FusionCharts Data Parameters Helper Scripts |
| Script Parameters |
- WebAddress - The URL to which data parameters have to be appended
- LabelFieldName - The field which has to be used for labels
- DataFieldName - The name of the field which has to be used for value
- GroupByCountField - The name of the count field for the groups
- recordCount - The record number to start from
- delimiter - (Optional) The delimiter to be used in this script. This
is an optional parameter. The default value used is the one specified
in global values when FusionCharts is initialized.
|
| Description |
Constructs the data parameter for multi-series chart by using the DataFieldName
field for value and SeriesFieldName for seriesName. Moves through records
one after the other.
Assumes that we are in the layout where the data is present and uses
GetNthRecord for getting the values. |
| Result |
Returns the new web address with the data parameters appended to the
given web address |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/11/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# This Script Constructs The Data Parameter
# For A Multi-Series Chart
# By Going Through Each Record, Using SeriesFieldName Value For seriesName
# and DataFieldName For Values To Be Shown On Chart
# Uses LabelListName Value List To Construct The Labels
# Assumes That We Are In The Layout Where The Data Is Present
# And Uses GetNthRecord For Getting The Values.
# Assumes That The Records In The Layout Are Sorted By SeriesFieldName Field.
# Script Parameters:
# 1. WebAddress - The URL To Which Data Parameters Have To Be Appended
# 2. LabelListName - The Value List Which Has To Be Used For Labels
# 3. SeriesFieldName - The Name Of The Field Which Has To Be Used As Name For Series
# 4. DataFieldName - The Name Of The Field Which Has To Be Used For Value
# 5. delimiter - (Optional) The Delimiter To Be Used In This Script.
# This Is An Optional Parameter. The Default Value Used Is The One Specified In Global Values When FusionCharts Is
Initialized.
# Return Value:
# The New Web Address With The Data Parameters
# Appended To The Given Web Address
# Pre-requisites For This Script:
# WebAddress Parameter Already Has The First Set Of Parameters In The QueryString Starting With ?
# Value List With The Name As Specified In LabelList Is Defined.
# The Value List Identified By LabelListName Is Present In The Same fp7 As This Script.
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]
Set Variable [ $LabelListName; Value:GetValue($parameters;2) ]
Set Variable [ $SeriesFieldName; Value:GetValue($parameters;3) ]
Set Variable [ $DataFieldName; Value:GetValue($parameters;4) ]
Set Variable [ $delimiter; Value:GetValue($parameters;5) ]
# Delimiter Value To Be Used For This Chart
Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) ]
# The Label Used For Display In The Chart
Set Variable [ $labels; Value: Substitute(ValueListItems (Get(FileName); $LabelListName);"¶";$delimiter) ]
# Initializing All Variables That Are Being Used In This Script
Set Variable [ $values; Value:"" ]
Set Variable [ $data; Value:"" ]
Set Variable [ $showLabels; Value:"" ]
Set Variable [ $valueCounter; Value:0 ]
Set Variable [ $recordCount; Value:1 ]
# Get The Total Number Of Rows
Set Variable [ $totalRows; Value:Get(FoundCount) ]
Set Variable [ $appendDelimiter; Value:False ]
Set Error Capture [ On ]
# Loop Through The Records
Loop
Exit Loop If [ $recordCount > $totalRows ]
Set Variable [ $currentValue; Value:GetNthRecord (GetField($DataFieldName);$recordCount) ]
Set Variable [ $currentSeriesName; Value:GetNthRecord (GetField($SeriesFieldName);$recordCount) ]
Set Variable [ $valueCounter; Value:$valueCounter+1 ]
# For The First Record, Set The $previousSeriesName
If [ $recordCount=1 ]
Set Variable [ $previousSeriesName; Value:$currentSeriesName ]
End If
# Append The Delimiter Only For Values After The First Value In Each Series
If [ $valueCounter > 1 ]
Set Variable [ $appendDelimiter; Value:True ]
End If
If [ $currentSeriesName 1 $previousSeriesName ]
# Implies That All Values In The Previous Series Have Been Obtained.
# Create A Series With The $previousSeriesName and $values.
Set Variable [ $data; Value:$data & "&data=[seriesName=" &$previousSeriesName &"]" &$values ]
# Reset The Variable Value $values to "" So That It Can Hold Values For The Next Series
Set Variable [ $values; Value:"" ]
Set Variable [ $appendDelimiter; Value:False ]
Set Variable [ $valueCounter; Value:1 ]
End If
Set Variable [ $previousSeriesName; Value:$currentSeriesName ]
Set Variable [ $values; Value:$values & If($appendDelimiter;$delimiter;"") & $currentValue ]
If [ $recordCount= $totalRows ]
Set Variable [ $data; Value:$data & "&data=[seriesName=" &$previousSeriesName &"]" &$values ]
End If
# Loop Through The Records One By One
Set Variable [ $recordCount; Value:$recordCount +1 ]
End Loop
Set Variable [ $NewWebAddress; Value:$WebAddress & "&labels="& $labels & $data ]
# Return The New Web Address
Exit Script [ Result: $NewWebAddress ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
WebAddress parameter already has first set of parameters in the QueryString
starting with ?.
We are in the layout where the data is present. The Value List identified
by LabelListName is present in the same fp7 as this script.
Note that this script needs to be imported/copy-pasted as mentioned in
the Script Usage.
|
|
| |
| Script Usage |
Can be Imported/Copy-Pasted.
Preferred Usage: Import |
| Category |
FusionCharts Data Parameters Helper Scripts |
| Script Parameters |
- WebAddress - The URL to which data parameters have to be appended
- LabelListName - The Value List which has to be used for labels
- SeriesListName - The Value List name which has to be used for the
Series Names
- DataFieldName - The name of the field which has to be used for value
(Summary field)
- GroupByFieldName - The name of the field by which the data has to
be grouped first
- GroupByCountField - The name of the count field for the first field
- GroupByFieldName2 - The name of the field by which the data has to
be grouped second
- GroupByCountField2 - The name of the count field for the second field
- delimiter - (Optional) The delimiter to be used in this script. This
is an optional parameter. The default value used is the one specified
in global values when FusionCharts is initialized.
|
| Description |
Constructs the data parameter for multi-series chart by using the SeriesFieldName
for seriesName. Moves through records in portal in groups using the GroupByCountField
by grouping data with GroupByFieldName field. While moving in groups of
GroupByFieldName, performs sub-script to get the data. This sub-script
uses GroupByFieldName2 and GroupByCountField2 to move in groups of the
GroupByFieldName2
Uses Value List for creation of labels parameter.
Assumes that we are in the layout where the data is present and uses
GetNthRecord for getting the values.
Appends zeroes for missing data. |
| Result |
Returns the new web address with the data parameters appended to the
given web address |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/11/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# This Script Constructs The Data Parameter
# For A Multi-Series Chart
# Loops Through One Field And Performs Script Within This Loop,
# Which Loops To Get The Values For The Other Field
# This Script Requires That The Summary Field For Value Be Defined
# Also Requires The CountField For Each Of The Two Fields Which Are Used To Group Data
# Assumes That We Are In The Layout Where The Data Is Present
# Assumes That The Data In The Layout Is Already Sorted By The Two Group-By Fields
# Script Parameters:
# 1. WebAddress - The URL To Which Data Parameters Have To Be Appended
# 2. LabelListName - The Value List Which Has To Be Used For Labels
# 3.SeriesListName - The Value List Name Which Has To Be Used For The Series Names
# 4. DataFieldName - The Name Of The Field Which Has To Be Used For Value (Summary Field)
# 5. GroupByFieldName - The Name Of The Field By Which The Data Has To Be Grouped First
# 6. GroupByCountField - The name of the count field for the first field
# 7. GroupByFieldName2 - The Name Of The Field By Which The Data Has To Be Grouped Second
# 8. GroupByCountField2 -The Name Of The Count Field For The Second GroupBy Field
# 9. delimiter - (Optional) The Delimiter To Be Used In This Script.
# This Is An Optional Parameter. The Default Value Used Is The One Specified In Global Values When FusionCharts Is
Initialized.
# Return Value:
# The New Web Address With The Data Parameters
# Appended To The Given Web Address
# Pre-requisites For This Script:
# WebAddress Parameter Already Has The First Set Of Parameters In The QueryString Starting With ?
# We Are In The Layout Where The Portal Is Present And The Portal With The Data Is Active.
# The Value List Identified By LabelListName Is Present In The Same fp7 As This Script.
# The Data Is Sorted By GroupByFieldName And GroupByFieldName2.
# Count field(GroupByCountField) Is Defined For The Field (GroupByFieldName) By Which Data Is Sorted.
# Count Field Is A Summary Field Defined As The Count Of A Unique Field,
# Summary Restarted For Each Group When Sorted By A GroupByFieldName Field.
# The Data Has To Be Sorted By This GroupByFieldName Field.
# Similar Conditions Apply To GroupByCountField2 and GroupByFieldName2.
# If Importing This Script, Please Also Import The Script
# GetData-LoopThroughPortalInGroups-UseLabelList
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]
Set Variable [ $LabelListName; Value:GetValue($parameters;2) ]
Set Variable [ $SeriesListName; Value:GetValue($parameters;3) ]
Set Variable [ $DataFieldName; Value:GetValue($parameters;4) ]
Set Variable [ $GroupByFieldName; Value:GetValue($parameters;5) ]
Set Variable [ $GroupByCountField; Value:GetValue($parameters;6) ]
Set Variable [ $GroupByFieldName2; Value:GetValue($parameters;7) ]
Set Variable [ $GroupByCountField2; Value:GetValue($parameters;8) ]
Set Variable [ $delimiter; Value:GetValue($parameters;9) ]
# Delimiter Value To Be Used For This Chart
Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) ]
# Go To The Last Row In The Portal
Go to Portal Row
[ Last ]
# Get The Total Number Of Rows
Set Variable [ $TotalRows; Value:Get(PortalRowNumber) ]
# Initialize Variables
Set Variable [ $labels; Value: Substitute(ValueListItems (Get(FileName); $LabelListName);"¶";$delimiter) ]
Set Variable [ $SeriesList; Value:ValueListItems (Get(FileName); $SeriesListName) ]
Set Variable [ $numberOfSeries; Value:ValueCount(ValueListItems (Get(FileName); $SeriesListName)) ]
Set Variable [ $numberOfLabels; Value:ValueCount(ValueListItems (Get(FileName); $LabelListName)) ]
Set Variable [ $labels; Value:"&labels="&$labels ]
# Append The Labels To $DataParams
Set Variable [ $DataParams; Value:$DataParams&$labels ]
# Construct A Zero Data Series That Can Be Used For Any Missing Data
Set Variable [ $i; Value:1 ]
Loop
Exit Loop If [ $i>$numberOfLabels ]
Set Variable [ $ZeroSeriesData; Value:$ZeroSeriesData &If($i 1 1;$delimiter;"")& "0" ]
Set Variable [ $i; Value:$i+1 ]
End Loop
Set Variable [ $currentPos; Value:1 ]
Set Variable [ $loopCounter; Value:0 ]
Set Variable [ $recordCount; Value:1 ]
# Loop Through Each Row In The Portal
Loop
Exit Loop If [ $recordCount>$TotalRows ]
# Go To The Start Row Specified In The Parameter
Go to Portal Row [ $recordCount ]
[ No dialog ]
Set Variable [ $loopCounter; Value:$loopCounter +1 ]
Set Variable [ $seriesName; Value:GetField($GroupByFieldName) ]
Set Variable [ $SeriesData; Value:"" ]
# Number Of Records In This Group
Set Variable [ $summaryVal; Value: GetSummary(GetField($GroupByCountField);GetField($GroupByFieldName)) ]
Set Variable [ $endRowNumber; Value:$recordCount +$summaryVal ]
Set Variable [ $foundThisItem; Value:False ]
# Loop Through Each Item In The SeriesList To See,
# If The Current SeriesName Is Present In The Current Position
Loop
Set Variable [ $tempItem; Value:GetValue($SeriesList;$currentPos) ]
Exit Loop If [ $foundThisItem or $currentPos > $numberOfSeries ]
If [ $seriesName=$tempItem ]
# Found The Item In The List Which Corresponds To The Current Portal Row's SeriesName Value
Set Variable [ $foundThisItem; Value:True ]
# For This Group, Find The Values For Each GroupByField2 By Performing Script For Getting Data
Perform Script [ “GetData-LoopThroughPortalInGroups-UseLabelList”; Parameter: $LabelListName & "¶" &
$DataFieldName& "¶" & $GroupByFieldName2 &"¶" & $GroupByCountField2 & "¶"&$recordCount&"¶"&
$endRowNumber ]
Set Variable [ $SeriesData; Value:Get(ScriptResult) ]
# Prepend The seriesData Generated By The Subscript With &data= ...
Set Variable [ $SeriesData; Value:"&data=[seriesName="&$seriesName& $delimiter&"parentYAxis=P"&"]"&$SeriesData ]
Set Variable [ $foundThisItem; Value:True ]
Else
# Since There Are No Values For This Item In The Portal, Initialize Zeroes With This Series Name
Set Variable [ $SeriesData; Value:"&data=[seriesName="&$tempItem& $delimiter&"parentYAxis=P"&"]"& $ZeroSeriesData ]
End If
# The Current Position In The Series List Is Incremented By 1
Set Variable [ $currentPos; Value:$currentPos+1 ]
End Loop
# $recordCount Is Assigned The Value Of $endRowNumber
# Thus, We Move To The Next Row Which Corresponds To The Next Group
Set Variable [ $recordCount; Value:$endRowNumber ]
Set Variable [ $DataParams; Value:$DataParams&$SeriesData ]
End Loop
# After Looping Through All The Portal Rows, Check If There Are Any Items Left In The List.
# If So, Append Zero Series Data For Each One Of Them
Loop
Exit Loop If [ $currentPos > $numberOfSegments ]
Set Variable [ $tempItem; Value:GetValue($SeriesList;$currentPos) ]
Set Variable [ $SeriesData; Value:"&data=[seriesName="&$tempItem& $delimiter&"parentYAxis=P"&"]"& $ZeroSeriesData ]
Set Variable [ $DataParams; Value:$DataParams&$SeriesData ]
Set Variable [ $currentPos; Value:$currentPos+1 ]
End Loop
Set Variable [ $NewWebAddress; Value:$WebAddress & $DataParams ]
# Return The New Web Address
Exit Script [ Result: $NewWebAddress ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
WebAddress parameter already has first set of parameters in the QueryString
starting with ?.
We are in the layout where the data is present in portal. Uses data from
the active portal. The Value List identified by LabelListName is present
in the same fp7 as this script.
Note that this script needs to be imported/copy-pasted as mentioned in
the Script Usage.
The data is sorted by GroupByFieldName and GroupByFieldName2.
Count field(GroupByCountField) is defined for the field (GroupByFieldName)
by which data is sorted. Count field is a summary field defined as the
count of a unique field, summary restarted for each group when sorted
by a GroupByFieldName field. The data has to be sorted by this GroupByFieldName
field. Similarly with GroupByCountField2 and GroupByFieldName2. |
|
| |
| Script Usage |
Can be Imported/Copy-Pasted.
Preferred Usage: Import |
| Category |
FusionCharts Data Parameters Helper Scripts |
| Script Parameters |
- WebAddress - The URL to which data parameters have to be appended
- DataFieldName - The name of the field which has to be used for value
(Summary field)
- GroupByFieldName - The name of the field by which the data has to
be grouped first
- GroupByCountField - The name of the count field for the first field
- startNum - The record number where the looping has to begin
- endNum - The record number where the looping has to end (this last
row is not included)
- delimiter - (Optional) The delimiter to be used in this script. This
is an optional parameter. The default value used is the one specified
in global values when FusionCharts is initialized.
|
| Description |
Scans the portal rows and gets the values separated by delimiter. Moves
through records in portal in groups using the GroupByCountField by grouping
data with GroupByFieldName field. While moving in groups of GroupByFieldName,
gets the value for DataFieldName field.
Assumes that we are in the layout where the data is present in portal
and uses the data from the active portal.
Appends zeroes for missing data. |
| Result |
Returns the delimiter separated values for the DataFieldName field in
all the groups. |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/11/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# Generates Multi-Series Data.
# This Script Is Used For Scanning The Portal Rows And Getting The Values Separated By Delimiter.
# Assumes That We Are In The Layout Where The Data Is Present In Portal
# And Uses The Values From Active Portal.
# Assumes That The Portal Is Sorted Accordingly.
# Script Parameters:
# 1. LabelListName - The Value List Which Has To Be Used For Labels
# 2. DataFieldName - The Name Of The Field Which Has To Be Used For Value
# 3. GroupByFieldName - The Name Of The Field By Which To Data Is Grouped
# 4. GroupByCountField - The Name Of The Summary Field Which Gives The Count
# 5. startNum - The record number where the looping has to begin
# 6. endNum - The Record Number Where The Looping Has To End (This Last Row Is Not Included)
# 7. delimiter - (Optional) The Delimiter To Be Used In This Script.
# This Is An Optional Parameter. The Default Value Used Is The One Specified In Global Values When FusionCharts Is
Initialized.
# Return Value:
# The Delimiter Separated Values For This Field (All Groups)
# Pre-requisites For This Script:
# WebAddress Parameter Already Has The First Set Of Parameters In The QueryString Starting With ?
# We Are In The Layout Where The Portal Is Present And The Portal With The Data Is Active.
# The Value List Identified By LabelListName Is Present In The Same fp7 As This Script.
# Portal Has To Be Sorted By GroupByFieldName Field.
# ---------------------------------------------
Set Variable [ $delimiter; Value:";" ]
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $LabelListName; Value:GetValue($parameters;1) ]
Set Variable [ $DataFieldName; Value:GetValue($parameters;2) ]
Set Variable [ $GroupByFieldName; Value:GetValue($parameters;3) ]
Set Variable [ $GroupByCountField; Value:GetValue($parameters;4) ]
Set Variable [ $startNum; Value:GetAsNumber(GetValue($parameters; 5)) ]
Set Variable [ $endNum; Value:GetAsNumber(GetValue($parameters; 6)) ]
Set Variable [ $delimiter; Value:GetValue($parameters;7) ]
Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) ]
Set Variable [ $recordCount; Value:$startNum ]
Set Variable [ $currentPos; Value:1 ]
Set Variable [ $LabelList; Value:ValueListItems(Get(FileName);$LabelListName) ]
Set Variable [ $TotalItems; Value:ValueCount ($LabelList) ]
# Loop Through The Records
Loop
Exit Loop If [ $recordCount $endNum ]
Go to Portal Row [ $recordCount ]
[ No dialog ]
Set Variable [ $totalValueForGroup; Value:GetField($DataFieldName) ]
Set Variable [ $currentItem; Value:GetField($GroupByFieldName) ]
# Loop Through The ValueList And Check If This Item Is In The Right Position Of SeriesData, If Not Append Zeroes
Set Variable [ $foundItem; Value:False ]
Loop
Exit Loop If [ $foundItem or $currentPos>$TotalItems ]
If [ $SeriesData="" ]
Set Variable [ $delim; Value:"" ]
Else
Set Variable [ $delim; Value:$delimiter ]
End If
Set Variable [ $tempItem; Value:GetAsNumber(GetValue($LabelList;$currentPos)) ]
If [ $tempItem=$currentItem ]
Set Variable [ $SeriesData; Value:$SeriesData &$delim&$totalValueForGroup ]
Set Variable [ $foundItem; Value:True ]
Else
# Appending Zeroes For The Values That Are Not Found
Set Variable [ $SeriesData; Value:$SeriesData&$delim&"0" ]
End If
Set Variable [ $currentPos; Value:$currentPos+1 ]
End Loop
# Set $recordCount Value Such That We Move To The Next Group In The Portal
Set Variable [ $summaryVal; Value: GetSummary ( GetField($GroupByCountField);GetField($GroupByFieldName)) ]
Set Variable [ $recordCount; Value:$recordCount +$summaryVal ]
End Loop
# Loop To Add Zeroes For Missing Data After Looping Through All Rows For That Group.
Loop
Exit Loop If [ $currentPos>$TotalItems ]
Set Variable [ $SeriesData; Value:$SeriesData&$delim&"0" ]
Set Variable [ $currentPos; Value:$currentPos+1 ]
End Loop
# Return The Delimiter Separated Data For All The Groups Of This Field
Exit Script [ Result: $SeriesData ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
WebAddress parameter already has first set of parameters in the QueryString
starting with ?.
We are in the layout where the data is present in portal and that portal
is the active portal.
Portal has to be sorted by GroupByFieldName field.
|
|
| |
| Script Usage |
Can be Referenced.
Preferred Usage: Referencing |
| Category |
FusionCharts Configuration Tool |
| Script Parameters |
- InteractiveMode - Whether configuration tool has to be opened for visual interactive configuration or not
Values Expected: "true" Or "false"
- ConfigId - The ConfigId corresponding to a previously saved configuration.
Can be an empty string in case of a new configuration.
- delimiter - (Optional) The delimiter that should be used for this chart.
This is an optional parameter. The default value used is ;
|
| Description |
Returns the new web address and the saved config id separated by carriage return. |
| Result |
Returns the new web address and the saved config id separated by carriage return. |
| Run script with full access privileges |
Off |
| Include In Menu |
No |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Steps |
# DEPRECATED - Please Avoid The Use Of This Script.
# Instead, use BuildFusionChartsURLWithNamedConfiguration
# Author: InfoSoft Global(P) Ltd.
# Creation Date: 03/11/2008
# Modification Date: mm/dd/yyyy
# ---------------------------------------------
# About this Script:
# This Script Helps In The Configuration Of Chart.
# Uses The FusionCharts Configuration Tool To AchieveThis.
# Script Parameters:
# 1. InteractiveMode - Whether FusionCharts Configuration Tool Has To Open
# And Visual Configuration Needs To Be Done Or Not.
# Values Expected: "true" Or "false"
# 2. ConfigId - The ConfigId Corresponding To A Previously Saved/Default Configuration.
# Can Be An Empty String In Case Of New Configuration
# 3. delimiter - (Optional) The Delimiter To Be Used For This Chart
# This Is An Optional Parameter. The Default Value Used Is ;
# Return Value:
# The New Web Address And The Saved ConfigId Separated By Carriage Return
# Pre-requisites For This Script:
# FusionCharts Configuration Tool.fp7 File Is Accessible
# ---------------------------------------------
Set Variable [ $parameters; Value:Get(ScriptParameter) ]
Set Variable [ $InteractiveMode; Value:GetValue($parameters;1) ]
Set Variable [ $ConfigId; Value:GetValue($parameters;2) ]
Set Variable [ $delimiter; Value:GetValue($parameters;3) ]
If [ IsEmpty($delimiter) ]
Set Variable [ $delimiter; Value:$$delimiter ]
End If
# If FusionCharts Configuration Tool File Is Not Already Open,
If [ not PatternCount(DatabaseNames;"FusionCharts Configuration Tool") ]
# If InteractiveMode Is Set To "true", Then Open The File.
If [ $InteractiveMode="true" ]
Open File [ “FusionCharts Configuration Tool” ]
Else
Open File [ “FusionCharts Configuration Tool” ]
[ Open hidden ]
End If
End If
# Perform The Script From FusionCharts Configuration Tool,
# By Passing Appropriate Parameters.
Perform Script [ “ConfigureChart” from file: “FusionCharts Configuration Tool”; Parameter: $InteractiveMode & "¶" & $ConfigId & "¶" &
$delimiter ]
Set Variable [ $Result; Value:Get(ScriptResult) ]
Close File [ “FusionCharts Configuration Tool” ]
# Result Obtained From This Script Contains Two Values.
# Use GetValue To Get The Two Values.
Set Variable [ $NewWebAddress; Value:GetValue($Result;1) ]
Set Variable [ $NewConfigId; Value:GetValue($Result;2) ]
# Return The Values
Exit Script [ Result: $NewWebAddress & "¶" & $NewConfigId ] |
| Scripts used in this script |
|
| Pre-requisites for this script |
FusionCharts Configuration Tool.fp7 file is accessible from the FusionCharts Library file |
|
| |
|
| FusionCharts Library |
file:FusionCharts Library.fp7 |
|