
'DATA MANAGEMENT'- Export to EXCEL-General Exception Error
Exporting to EXCEL is an easy one-button process, , once the two programs - J&J and Excel hav e been configued properly.
First run a proram 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 wich to 'remove' it [use the back arrow] before exporting to EXCEL.




TROUBLESHOOTING:
Some users have reported getting Export Errors.
The General Exception error provides a spreadsheet with no data columns.
A more frequent error is the awarening of Excel for a moment as the data is written to the spreadsheet, then the whole Excel program disappears.
SOLUTIONS:
A careful, step-by-step analysis of this problem revealed no apprent problems with the J&J Export program as a whole; however users with these errors can get it to export properly by spending a little time re-configuring the Export Window.
Here is how to get it working again:
1. Change Update Unit: Trial Length or 10 sec. seems best for troubleshooting.
2. Use Average Output, not Basic Statistics.
3. Remove [<--] all Signals except for the most basic EMG, HR, Sc, Temp, SUDS, etc:


After each step, press OK to test that EXCEL is now working.
It appears that some attempts to export to Excel do not synchronize cells in the right order for Excel. Once the J&J Export Window is re-configured, these problems go away, and everything works.
By re-configuring the Export Window I have been able to 'recover' data sets that many researchers thought were corrupted or beyond salvage.
BOTTOM LINE:
DO NOT ERASE 'BAD' DATA. Save them, and Archieve them. [See How to Archieve].
After Archieving, get hold of Dr. Grove through J&J. He will instruct you to send them to Dr. Grove at a special email address for analysis.
Reminder: Excel may take take a long time to fill a speadsheet. So be patient and do nothing until you see the opop-up window:
"Do you want to save the changes you made to Book 1?'
Answer No to have Excel disapper.
Answer Yes to have it Save as 'book1.' This is not recommended, and is only if you are in a hurry!
Click on Cancel, and then "Save As" .. in a follder for later Excell Analyisis.
LIMIT ON NUMBER OF SIGNALS IS 29.
A few applications save more than 29 signals. Some Excel programs limit the number of Excel exports to 29 signals. To see if you have more than 29, count up all the Exported Signals.
Solution: Move unnecessary signals to the left side box, Saved Signals.
When you are left with 29, press OK.
[Read more below...]
29 Maximum Exported Signals here
29 Maximum Exported Signals here
Originally blank, the program will save and recall those signals removed from 'Export' so you can repeat the process for the next session's data