Difference between revisions of "Data Grid Export Service"
Jump to navigation
Jump to search
Line 11: | Line 11: | ||
== Installing == | == Installing == | ||
+ | <div class="downloadButton" style="width:270px;float:right;margin:30px 20px 0px 30px;">[[QPR_Product_Downloads#QPR_UI_Data_Grid_Export_Service|Download Data Grid<br />Export Service for QPR UI]]</div> | ||
=== Installation Using Web Deploy === | === Installation Using Web Deploy === | ||
− | |||
− | |||
# Download the latest installation package (link on the right). | # Download the latest installation package (link on the right). | ||
# Unzip the installation package to a temporary folder. | # Unzip the installation package to a temporary folder. |
Revision as of 10:05, 21 February 2019
Data Grid Export Service is a separately installed add-on for QPR UI that enables to export Data Grids contents as Microsoft Excel, Microsoft Word and PDF documents. This page describes how the Data Grid Export Service is installed. In addition, when using QPR UI Data Grids, export buttons need to be enabled in the data grid settings, or when using PAPO the EnableTableExporting, variable needs to be set.
Prerequisites
The following prerequisites are needed for installing the data grid export web service:
- .NET Framework 4.6.1 or later.
- Microsoft Internet Information Services.
Additionally, installation via Web Deploy has the following prerequisites:
- Microsoft Web Deploy 3.0 or later installed on the system - http://www.iis.net/downloads/microsoft/web-deploy
- Microsoft PowerShell 2.0 or later running as an Administrator
Installing
Installation Using Web Deploy
- Download the latest installation package (link on the right).
- Unzip the installation package to a temporary folder.
- Open Configuration.ps1 into text editor and modify the values according to your system and desired installation type. With the $customAppPoolCredentials setting you can define whether the application pool will be run as a user defined in $appPoolUser setting (password for the account will be requested during the installation).
- Launch Microsoft PowerShell as an Administrator and navigate to the folder containing the deployment files.
- Run .\DeployGridExportService.ps1 and input the application pool user password when requested (if you chose to use custom credentials).
Manual Installation
- Create folder C:\inetpub\wwwroot\SyncfusionGridExport.
- Download the latest installation package (link on the right).
- Unzip the installation package to a temporary folder.
- The unzipped install package contains the QprGridExportAddon.zip file. Unzip the contents of that file to another temporary folder.
- From this other temporary folder, copy the contents of the Content\website\ folder to the C:\inetpub\wwwroot\SyncfusionGridExport folder. After this the C:\inetpub\wwwroot\SyncfusionGridExport folder should contain the following:
- Folder named bin.
- Files named Global.asx and Web.config.
- Open Internet Information Service (IIS) Manager.
- Select Application Pools > Add Application Pool..., and give the application pool a name.
- Under Sites, right-click Default Web Site and select Add Application...
- Type in SyncfusionGridExport as the Alias.
- Select the new created application pool from the Application Pool list.
- Define the Physical path as C:\inetpub\wwwroot\SyncfusionGridExport.
After the installation, the export servers are available in the following URLs:
- Excel: http(s)://<HOSTNAME>/SyncfusionGridExport/excelExport
- Word: http(s)://<HOSTNAME>/SyncfusionGridExport/wordExport
- PDF: http(s)://<HOSTNAME>/SyncfusionGridExport/pdfExport
where <HOSTNAME> is the QPR UI server name.