When you view a table or a Case Details window, you can download the information to various types of files. When viewing case details, you can download the details to an Excel spreadsheet or a Rich Text Format file.
You can set your user preference, Default download file type, to a file type to be used by default. When downloading, however, you can override the default by selecting another file type as needed.
Note: For floating-point numbers that are downloaded, the precision of the numbers is accurate to the level of precision in the numbers, as displayed in the Empirica Signal application.
1. Make sure you have arranged table columns as you want them.
2. Click Download.
The Download dialog box appears.
3. In the Base filename field, enter a filename. Do not include an extension. Oracle recommends that you use a filename that identifies the content of the download.
4. Click one of the following file types. For some types of information, only certain file types are available.
|
File Type |
Description |
|
Comma-separated file (.csv) |
Text file in which values are separated by a comma. Can be used as input to or output from Microsoft Excel. Note: Leading zeroes in values are not retained when you download to a .csv file. |
|
Tab delimited file (.txt) |
Plain text file. Typically, the file extension .txt is associated with a text editor, such as Microsoft Notepad. |
|
Excel spreadsheet (.xls) |
Spreadsheet file that can be opened by Microsoft Excel. You must have Microsoft Excel installed on your computer. If you try to download a table of more than 65,535 rows, a message warns you that this exceeds the capacity of Excel. Note: If dates are not displayed appropriately in Excel, you might need to change the display format in Excel. |
|
Excel spreadsheet (.xlsx) |
Spreadsheet file that can be opened by Microsoft Excel. You must have Microsoft Excel installed on your computer. If you try to download a table of more than 1,048,575 rows, a message warns you that this exceeds the capacity of Excel. When you download case details to an Excel spreadsheet, a separate worksheet is used for each of the different types of data shown on the Case Details page. Each worksheet is limited to 1,048,575 rows. Note: If dates are not displayed appropriately in Excel, you might need to change the display format in Excel. |
|
SAS Version 5 transport (.xpt) |
Industry-standard SAS transport file, as defined for SAS Version 5 (XPORT format). |
|
SAS data step definition (.sas) |
SAS data step file, which can be used by SAS software to create a native SAS dataset. |
|
Portable Document Format (.pdf) |
File that includes formatting and layout information, as well as the data. This option requires the Adobe Acrobat Reader. |
Note: When you are downloading case details, only the Excel spreadsheet (.xlsx) or Word Rich Text Format (.rtf) formats are available.
5. In the Limit to field, you can enter the number of rows that you want to download (instead of downloading the entire table). For example, if you specify 1000, only the first 1,000 rows of the table download. Keep in mind that the way in which the table is sorted determine which rows are downloaded. If you do not fill in the Limit to field, all rows of the table download.
The number of rows per page of the displayed table has no effect on downloading. For example, the table includes 100 rows and 25 rows appear per page. If you download the entire table, all 100 rows download.
Note: When you download case details, Oracle recommends that you do not limit the number of rows. The limit applies to each type of data. For example, if you limit the download to two rows, only the first two drugs and the first two adverse events for the case are downloaded.
6. If you check Create a Zip archive file for download, the application creates a file with the extension .zip to hold the file that contains the downloaded table. You must have a ZIP file compression and extraction utility, such as WinZip, installed on your computer, as described in Prerequisites and usage notes.
The zip file also includes an id.txt file that provides the name of the user who downloaded the table and the date and time of the download.
Note: When you download data from a report, you can also include a report definition file and analysis files. The report definition is an XML representation of the report. The analysis files include an analysis description file and an analysis script file (if defined for the report).
7. Click OK.
The File Download dialog box opens and you can choose to open or save the file. For large case series, a message appears stating the file is being prepared. You can leave this page and click anywhere in the Empirica Signal application while the file is downloading.
Note: When you download data mining results or reports, the application includes notes in the download (to all file types except .xpt and .sas) if they appeared at the time of the download.