Exporting
E-Prime data files may be exported to a tab-delimited text file for import into an external package, or for re-import into E-DataAid via the Export command in the File menu or the Export tool button.
The Export command displays the Export dialog box, which allows the export of all unhidden columns and rows in the spreadsheet to a text file. The dialog offers options to export to a format compatible with Excel, StatView, SPSS, or E-Prime text. The dialog also offers an “Other” option, which allows some flexibility in formatting the text file so that it can later be imported into other packages with minimal modifications.
Export Data to Excel
To export to Excel, choose the Excel option in the “Export to“ field. When exporting to Excel, the application automatically chooses the file configuration to export to a tab-delimited text file.
After the format for export is specified, the Export As dialog is displayed. In the Export As dialog, navigate to the path where the file is to be saved, and supply a name for the file in the “File Name” field. Once exported, the resulting text file can be imported into Excel using the Open command in the Excel File menu.
Export Data to StatView
To export to StatView or SPSS, choose the StatView and SPSS option in the “Export to” field. When exporting to StatView, the application automatically chooses the file configuration to export to a tab-delimited text file.
After the format for export is specified (click OK in the Export dialog), the Export As dialog is displayed. In the Export As dialog, navigate to the path where the file is to be saved, and supply a name for the file in the "File name" field. Once exported, the resulting text file can be imported into Statview using the Open command in the StatView File menu.
Export Data to E-Prime Text
To export to a text file that may be re-imported into E-DataAid, choose the E-Prime Text option in the “Export to” field. When exporting to E-Prime text, the application automatically chooses the file configuration to export to a tab-delimited text file.
After the format for export is specified (click OK in the Export dialog), the Export As dialog is displayed. In the Export As dialog, navigate to the path where the file is to be saved, and supply a name for the file in the File Name field.
Once exported, the resulting text file can be re-imported into E-DataAid using the Import command in the E-DataAid File menu.
NOTE: Only data visible in the spreadsheet will be exported.
In order to export the raw data file as E-Prime text, redisplay all hidden rows and columns and remove active filters, or use the Restore Spreadsheet command. The Restore Spreadsheet command in the View menu clears all active filters, redisplays all hidden columns, and restores the columns to the default order.
Export Data to Other Format
To export to a text file which may be imported into an external package other than StatView or Excel, choose the “Other” option in the “Export to” field. When exporting using the “Other” option, the application allows the user to designate the file configuration for the export.
The user must designate how to export missing data, comments, and column headers. In addition, the configuration must indicate how the separators between variables and data are specified, as well as the information indicating the beginning and ends of individual lines of data.
Common characters appropriate for each field are included in drop-down boxes for each field. The user may select from one of the options in the drop-down box, or may type another alternative directly in the field. After the format for export is specified (click OK in the Export dialog), the Export As dialog is displayed. In the Export As dialog, navigate to the path where the file is to be saved, and supply a name for the file in the File Name field. Once exported, the resulting text file can be imported into the intended external package.
Importing
The Import command in the File menu may be used to import MEL Professional v2.x data saved as text files, PsyScope data files, and E-Prime data saved as text files.
E-Prime Text File
The E-Prime Text File option allows the import of an E-Prime file containing raw data. The E-Prime text file must be created by exporting the E-Prime data file (filename.edat3) to a text file using the Export command within E-DataAid. The E-Prime Text File option displays the Import E-Prime Text File dialog box.
Navigate to the folder containing the E-Prime text file, select the file to import and click the Open button. The text file will be imported into E-DataAid as a new, untitled E-Prime data file (Untitled.edat3). E-DataAid interprets all data as strings with the exception of subject and session numbers, and level numbers, which are interpreted as integers.
Not all E-Prime Text Files can be imported. Files which may not be imported include any files containing two or more sessions with the same subject and session number, any files not containing a subject, session or ExperimentName field, or any files containing variable fields without the corresponding level field (e.g., a file containing a field for a trial level variable, but no field for the trial level).
Next Article: E-DATAAID: Printing a Spreadsheet [22834]
Previous Article: E-DATAAID: Security in E-DataAid [22827]
Comments
0 comments
Please sign in to leave a comment.