'DATA MANAGEMENT'- Export to EXCEL
First run a progam and EXIT and SAVE. You can save twice if you would like, once to J&Js 'Save to Database,' and once to 'EXPORT.' However it is safest to ALWAYS save to J&Js Database BEFORE exporting. You can export J&Js data files at any time to Excel, but if Excel is not working or you erase the spreadsheet, you can only recover by retrieving J&Js Datafile.
So to Export, just select EXPORT from the Data Management Window, check off the signals and Update times and press OK.
SUGGESTIONS: Many applications save more signals than are needed for research. For example, 'HR-Above' is a signal that counts the number of beats above a HR threshold. This is not usually needed for research, so you may wish to 'remove' it [use the back arrow] before exporting to EXCEL.
29 Maximum Exported Signals here
Exporting Data to Excel or Your Own Database
Exporting data does not affect the original data record. It only exports copies of the data. To export data, first follow the instructions for selecting session data under the Managing Data section above. Then click Export.
In the right side of the Export Dialog window, uncheck any information you do not wish to include. In the Update drop-down box, choose the update rate, which is the averaging interval time in seconds (decreasing the rate reduces file size and makes charting the data more feasible). Select either Average Only or Basic Statistic (described in the Quick Reports section). If you don’t want to export all of the signals, highlight individual signals and move them into the Saved Signals box using the left-arrow.
If you wish to export to Excel, select Excel in the Export Type box and-click OK. Click Yes in the save prompt pop-up window, browse to a folder location, type in a unique filename and click Save. If you wish to include screen captures in your Excel report, or add textboxes or charts, you may want follow the directions in the Creating Excel Reports section instead of exporting data.
If you wish to have Physiolab automatically generate filenames and save to a pre-selected target location, check the Autosave check box, then follow the instructions below in the Automatically Generating Filenames section.
When Autosave is checked Excel will pop open and populate with data, then the save window will briefly appear and disappear as the file is automatically saved to your target location, and Excel will close. It may take a few minutes for these steps to execute, especially with large files.
If you wish to export to another database, select Asci in the Export Type box.
You must click Change File to specify an initial target location. In the pop-up window, browse to the folder into which you want to save the data. You must replace the asterisk(*) with a unique filename, then click Open.
It is important to specify which symbols your database will be looking for in order to interpret divisions between data elements. Click the radio button next to the appropriate symbol combination in the “Data Delimiter” box.
Do not close the Export Dialog window using the X in the upper right corner. The file will not be saved until you click OK in the Export Dialog window.
If you are using your own database program, use the instructions supplied with that program for importing and manipulating data.
Automatically Generating Filenames for Export Data
Once you have used Change File to specify an initial target location and filename, you can let Physiolab automatically generate a new filename and export to your initially specified location by default each time you export data. When you click Export the next time, the target location and filename from your last export will be used again unless you specify something different. It is important to select Auto Increment in the Export Dialog window or the exported data will overwrite the previously saved file with the same filename. When Auto Increment is checked, the number in the Auto Increment textbox will be added to your initial filename. When you click OK at the bottom of the Export Dialog window, the data will be exported and the Auto Increment number will increase by one integer. You can start Auto Increment over at zero or at any other number you choose by typing that number in the textbox to the right of the Auto Increment check box.
Even with Auto Increment selected, you always have the option of manually specifying a unique filename by clicking on the “Change File” button, typing your new filename, then clicking Open. The number in the Auto Increment textbox will be added to your manually typed filename when you click OK in the Export Dialog window to export your data. This new filename will become the new default template filename unless you change it back.
To automatically generate data export filenames using a client name as the filename template, both the Use client name as Template and the Auto Increment checkboxes must be checked. Even if you have exported data before using “Change File” to specify a location, you must specify an initial target location again when switching to using the client name as a filename template. When “Use client name as a template” is checked, the “Change File” button opens a window to select a file export location only, without a textbox for specifying a filename. Browse to the data destination folder of your choice, then click OK to confirm your target location and close the window. Click OK in the Export Dialog window to export your data. For future data exports, once you have selected a data session and clicked Export, your target location and filename will be automatically set and you will need to simply click OK to export.
Exporting to EXCEL is an easy one-button process, , once the two programs - J&J and Excel have been configured properly.