Exporting data

In Xpand Portal, data that you see on a grid or detail page can be saved in the following formats:

  • PDF
  • Microsoft Excel Workbook
  • CSV (Comma-separated values)

  Note

For this feature to be available on a page, it must be added to the grid or detail page, and the role that you belong to must have permissions to use this function on that page.

When you export data from a detail page, you do not need to select record - the data from the related record is exported.

To save data as PDF

  1. Open a portal page the data from which you want to save as PDF.

  2. Select records that you want to save. You can do this by selecting the check box on the line or by selecting the Select All check box to select all the records currently visible on the page.

  1. Select the Save as PDF icon.

  2. In the dialog window that appears (the look of which is configurable, and may be different in your case), in the File name, edit the suggested file name if necessary (you'll be able to also do this in the standard Windows dialog later), and then select Export.

      Note

    A page may have a big number of records. In this case, use the navigation buttons to switch pages. If you want to export all records from all pages, select the Save as PDF  icon while not having any particular records selected, and then select EXPORT ALL in the dialog box that appears.

  3. In the Save as dialog window, specify the location and file name, and then select Save.

The selected records are saved in the PDF (.pdf) format that you can open in any application that supports PDF files.

To save data as Excel Workbook

  1. Open a portal page, the data from which you want to save as PDF.

  2. Select records that you want to save. You can do this be selecting the check box on the line or by selecting the Select All check box to select all the records currently visible on the page.

  3. Select the Export to Excel  icon.

  4. In the dialog window that appears (the look of which is configurable, and may be different in your case), in the File name, edit the suggested file name if necessary (you'll be able to also do this in the standard Windows dialog later), and then select Export.

  Note

A page may have a big number of records. In this case, use the navigate buttons to switch pages. If you want to export all records from all pages, select the Export to Excel  icon while not having any particular records selected, and then select EXPORT ALL in the dialog box that appears.

  1. In the Save as dialog window, specify the location and file name, and then select Save.

The selected records are saved in the Excel Workbook (.xlsx) format that you can open in Microsoft Office Excel.

To save data as CSV

  1. Open a portal page the data from which you want to save as a CSV (comma-separated file).

  2. Select records that you want to save. You can do this by selecting the check box on the line or by selecting the Select All check box to select all the records currently visible on the page.

  3. Select the Save as CSV icon.

  4. In the dialog window that appears (the look of which is configurable, and may be different in your case), in the File name, edit the suggested file name if necessary (you'll be able to also do this in the standard Windows dialog later), and then select Export.

  Note

A page may have a big number of records. In this case, use the navigate buttons to switch pages. If you want to export all records from all pages, select the Save as CSV  icon while not having any particular records selected, and then select EXPORT ALL in the dialog box that appears.

  1. In the Save as dialog window, specify the location and file name, and then select Save.

The selected records are saved in the CSV (.csv) format that you can open in any application that supports CSV files.