The Export Datawarehouse Tables function on the Datawarehouse tab of the Admin Page is available for Administrators to export data from the iSite Datawarehouse into text files.  Once data is exported out of iSite, this data can be used in external reporting tools for customized data analysis, reporting, charting and more.


Availability

Only users with the Portal Administrator permission will have access to this function.


Navigation

Admin > Datawarehouse > Export Datawarehouse Tables


File Formats

When executing the Export Datawarehouse Tables function, a .zip file will be created with one or more text files embedded inside of it.  Each text file is a delimited file, which means that each field of a table is separated (delimited) by a comma or a tab character.  Each record is separated by a new line.


See the Comma-separated values Wikipedia entry for more detailed information on delimited files.


Available Tables

The Export Datawarehouse Tables function provides export capabilities for a number of tables within iSite.  A list of those tables are as follows:



Specifying Delivery Options

When the .zip file is created with your desired tables, you have multiple options to choose from for the delivery of your file.


  • E-Mail to Me
    • E-mails a copy of the .zip file to your iSite e-mail address.
  • E-Mail to Others
    • Allows you to specify one or more e-mail addresses to to send a copy of the .zip file to.
  • Save to Document Library
    • Allows you to specify a Document Library and Folder to save a copy of the .zip file to.
  • Download to Personal Download Queue


Exporting Data

  1. A default File Name will be generated for you.  However, if you want to specify a different file name, enter the new name in the File Name textbox.
  2. In the Export Options section, specify a record delimiter by selecting a value from the Delimiter drop-down control.
  3. Select the type of datawarehouse tables that you want to download using the Tables to Export drop-down control.
  4. Select one or more tables (if available) in the Available Tables list.
    1. If check boxes are visible, you may select multiple tables from the list.
    2. If radio buttons are visible, you may only select one table from the list at a time.
  5. In the Delivery Options section, select one or more delivery options for the .zip file after creation.
  6. Click the Generate Export File button to create the .zip file with the specified options, or click the Cancel button to return to the Admin menu.


MVCDELETE


Page ID:6320-3206-6425