Difference between revisions of "Data Grid Export Service"
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 | + | # 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 | + | # The unzipped install package contains the '''QprGridExportAddon.zip''' file. Unzip the contents of that file to another temporary folder. |
| − | # From | + | # 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 | + | #* Folder named '''bin'''. |
| − | #* Files named | + | #* Files named '''Global.asx''' and '''Web.config'''. |
| − | # Open Internet Information Service(IIS) | + | # 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 | + | ## 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 | + | ## 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://< | + | * Excel: http(s)://<HOSTNAME>/SyncfusionGridExport/excelExport |
| − | * Word: http://< | + | * Word: http(s)://<HOSTNAME>/SyncfusionGridExport/wordExport |
| − | * PDF: http://< | + | * 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:
- 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 installation package.
- 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 installation package.
- 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.