SDG plug-in configuration

The Spreadsheet Data Generator (SDG) plug-in looks up the AR Systemforms, fields, and conditional dependency of fields and retrieves the field properties, such as the help text, length, and label of these fields. The SDG plug-in then generates columns for each field in a Microsoft Excel spreadsheet. The SDG plug-in reformats the data to the correct set, and eliminates the possibility of data mismatch by generating spreadsheets directly from the AR System forms.

Related topic

Troubleshooting-SDG-plug-in-issues

Plug-in type

SDG is a Java-based Filter API plug-in.

AR System server connectivity

The AR System server interacts with the SDG plug-in when a filter API action occurs or a service is executed on a AR Systemform. The SDG plug-in is installed in the ARInstallationFolder\pluginsvr\excelgenerator\lib\sdg.jar folder.

SDG plug-in configuration

The configuration information of the SDG plug-in is available in the AR System Administration: Plugin Server Configuration form.

22_1_SDG plug-in configuration.png

The AR System Administration: AR System Configuration Generic UI form includes the Server-Plugin-Alias setting that points to the correct plug-in server alias:
Server-Plugin-Alias: ARSYS.ARF.SDG ARSYS.ARF.SDG myServer:9999

For more information, see Updating-configuration-settings-by-using-the-AR-System-Configuration-Generic-UI-form, Configuring-Java-plug-in-servers, and Setting-plug-in-server-configuration-options.

The configuration data of knowledge sources is present in the following forms:

  • DMT:SpreadsheetColumnSelections
  • DMT:Spreadsheet

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*