Difference between revisions of "Data Grid Export Service"

From Mea Wiki
Jump to navigation Jump to search
(307203)
Line 14: Line 14:
 
# Download the [https://files.qpr.com/releases/DataGridExport/QPRGridExportAddonInstallV001.zip installation package].
 
# Download the [https://files.qpr.com/releases/DataGridExport/QPRGridExportAddonInstallV001.zip installation package].
 
# Unzip the installation package to a temporary folder.
 
# 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).
+
# 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.
 
# 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).
 
# Run '''.\DeployGridExportService.ps1''' and input the application pool user password when requested (if you chose to use custom credentials).
  
 
=== Manual Installation ===
 
=== Manual Installation ===
# Create the folder "'''C:\inetpub\wwwroot\SyncfusionGridExport'''"
+
# Create folder '''C:\inetpub\wwwroot\SyncfusionGridExport'''.
 
# Download the [https://files.qpr.com/releases/DataGridExport/QPRGridExportAddonInstallV001.zip installation package].
 
# Download the [https://files.qpr.com/releases/DataGridExport/QPRGridExportAddonInstallV001.zip installation package].
 
# Unzip the installation package to a temporary folder.
 
# Unzip the installation package to a temporary folder.
# The unzipped install package contains the '''QprGridExportAddon.zip''' file. Unzip the contents of that file to a '''second temporary folder'''.
+
# The unzipped install package contains the '''QprGridExportAddon.zip''' file. Unzip the contents of that file to another temporary folder.
# From the '''second 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:
+
# 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'''"
+
#* Folder named '''bin'''.
#* Files named "'''Global.asx'''" and "'''Web.config'''"
+
#* Files named '''Global.asx''' and '''Web.config'''.
# Open Internet Information Service(IIS) manager.
+
# Open '''Internet Information Service (IIS) Manager'''.
 
# Select '''Application Pools''' > '''Add Application Pool...''', and give the application pool a name.
 
# Select '''Application Pools''' > '''Add Application Pool...''', and give the application pool a name.
 
# Under '''Sites''', right-click '''Default Web Site''' and select '''Add Application...'''
 
# Under '''Sites''', right-click '''Default Web Site''' and select '''Add Application...'''
## Type in "'''SyncfusionGridExport'''" as the '''Alias'''.
+
## Type in '''SyncfusionGridExport''' as the '''Alias'''.
 
## Select the new created application pool from the Application Pool list.
 
## Select the new created application pool from the Application Pool list.
## Define the '''Physical path''' as "'''C:\inetpub\wwwroot\SyncfusionGridExport'''".
+
## Define the '''Physical path''' as '''C:\inetpub\wwwroot\SyncfusionGridExport'''.
  
 
After the installation, the export servers are available in the following URLs:
 
After the installation, the export servers are available in the following URLs:
* Excel: http://<YourHostname>/SyncfusionGridExport/excelExport
+
* Excel: http(s)://<HOSTNAME>/SyncfusionGridExport/excelExport
* Word: http://<YourHostname>/SyncfusionGridExport/wordExport
+
* Word: http(s)://<HOSTNAME>/SyncfusionGridExport/wordExport
* PDF: http://<YourHostname>/SyncfusionGridExport/pdfExport
+
* PDF: http(s)://<HOSTNAME>/SyncfusionGridExport/pdfExport
 
+
where <HOSTNAME> is the QPR UI server name.
 
[[Category: QPR UI]]
 
[[Category: QPR UI]]

Revision as of 16:25, 15 March 2018

Data Grid contents can be exported to Microsoft Excel, Microsoft Word, or a PDF document. The exporting is done by a separate export web service add-on.

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:

Installing

Installation Using Web Deploy

  1. Download the installation package.
  2. Unzip the installation package to a temporary folder.
  3. 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).
  4. Launch Microsoft PowerShell as an Administrator and navigate to the folder containing the deployment files.
  5. Run .\DeployGridExportService.ps1 and input the application pool user password when requested (if you chose to use custom credentials).

Manual Installation

  1. Create folder C:\inetpub\wwwroot\SyncfusionGridExport.
  2. Download the installation package.
  3. Unzip the installation package to a temporary folder.
  4. The unzipped install package contains the QprGridExportAddon.zip file. Unzip the contents of that file to another temporary folder.
  5. 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.
  6. Open Internet Information Service (IIS) Manager.
  7. Select Application Pools > Add Application Pool..., and give the application pool a name.
  8. Under Sites, right-click Default Web Site and select Add Application...
    1. Type in SyncfusionGridExport as the Alias.
    2. Select the new created application pool from the Application Pool list.
    3. 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.