Export Datawarehouse Tables
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:
- Lookup Tables
- Accounts
- Burdens
- Burden Rates
- Employees
- Employee Labor Rates
- Financial Months
- Labor Classes
- Labor Class Rates
- Labor Subclasses
- Labor Subclass Rates
- Teammates
- Vendors
- Utility Tables
- Estimating Tables
- Estimate Packages
- Estimate Package Components
- Estimate Package Component Details
- Funding Tables
- Funding Packages
- Funding Package Details
- Published Funding Actions
- Reporting Tables
- Commitments
- Funding Actions
- Invoice Details
- Payment Details
- Planned Contract Values
- Time-Phased Baseline Plans
- Task Management Tables
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
- Downloads the .zip file to your browser and saves a copy to your Personal Download Queue for future reference.
Exporting Data
- 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.
- In the Export Options section, specify a record delimiter by selecting a value from the Delimiter drop-down control.
- Select the type of datawarehouse tables that you want to download using the Tables to Export drop-down control.
- Select one or more tables (if available) in the Available Tables list.
- If check boxes are visible, you may select multiple tables from the list.
- If radio buttons are visible, you may only select one table from the list at a time.
- In the Delivery Options section, select one or more delivery options for the .zip file after creation.
- 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