Download data

When you view a table or case details, you can download the information to various types of files.

Set a default download file type by modifying your user preferences. When downloading, however, you can override the default by selecting another file type.

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 Oracle Empirica Signal.

1. Make sure you have arranged table columns as you want them.
2. From the Signal Review page Header Action menu (), click Download. On other pages, click the Download link.
3. In the Base filename field, enter a filename. Do not include an extension. We recommend that you use a filename that identifies the content of the download.
4. Select 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, 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 determines 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 table, all 100 rows download.

   Note:

   When you download case details, we recommend 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 select Create a Zip archive file for download, the Oracle Empirica Signal 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.

   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.
8. 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 Oracle Empirica Signal while the file is downloading.

   Note:

   When you download data mining results or reports, Oracle Empirica Signal includes notes in the download (to all file types except .xpt and .sas) if they appeared at the time of the download.