journal file

[Cathie Atkinson]

Hi

SPSS crashed earlier (v17.01) and I lost a syntax file.  I'm trying
to open the journal file (first time in 17) to retrieve my syntax,
but it won't open.  I get an error saying "unkown file type specified
on command line".  I tried to open it with notepad but it's
unreadable that way.  Is there any other way I can get to it?

Thanks!
Cathie

Cathie Atkinson, PhD
Clinical Psychologist
Institute for Behavioral Medicine Research
The Ohio State University
[phone]
[hidden email]

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Fry, Jonathan B.]

The error sounds like you double-clicked the journal file.  You should be able to open it as a syntax file from within Statistics.  I could get to mine by copying the file name from the Edit/Options/File Locations tab, then using File/Open/Syntax and pasting the name.

Jonathan Fry

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Cathie Atkinson
Sent: Thursday, November 05, 2009 11:17 AM
To: [hidden email]
Subject: journal file

Hi

SPSS crashed earlier (v17.01) and I lost a syntax file.  I'm trying
to open the journal file (first time in 17) to retrieve my syntax,
but it won't open.  I get an error saying "unkown file type specified
on command line".  I tried to open it with notepad but it's
unreadable that way.  Is there any other way I can get to it?

Thanks!
Cathie

Cathie Atkinson, PhD
Clinical Psychologist
Institute for Behavioral Medicine Research
The Ohio State University
[phone]
[hidden email]

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Maguin, Eugene]

Cathie,

There's several things you can do. The journal file has an extension of .jnl
and is an ordinary text file. You can rename the file and change the
extension from jnl to sps and open it in spss. You can open it in word,
resave it as a text file and change the name and extension.

Gene Maguin


>>SPSS crashed earlier (v17.01) and I lost a syntax file.  I'm trying
to open the journal file (first time in 17) to retrieve my syntax,
but it won't open.  I get an error saying "unkown file type specified
on command line".  I tried to open it with notepad but it's
unreadable that way.  Is there any other way I can get to it?

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Ater, Josh]

I am working from a very moderate size file of 14,000 records but have a
few tables that consist of several hundred rows. I need to export these
rows into excel and the software keeps stalling on me. Any tricks I can
use?

Josh

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Eric Langston]

I don't know if you have been, but this also advice for the ethos --
don't try to select the table and use Copy + Paste to get it into Excel.
It worked up until SPSS v15, but once the program went Java, using Copy
+ Paste to get stuff to Excel was futile.

I would either right click the output and click "Export" -- make sure
that you click the radio button for "Selected" at the top, otherwise it
will try to export the entire output document.  Also, the format should
be Excel of course :-) That method works well, but does become a bit
ominous for really big tables.

If the resulting Excel file is messed up or the program stalls out, then
get the table formatted correctly in SPSS and then export it to an HTML
file instead.  From there, you can copy and paste it into Excel.  This
method works well for really large tables.

Hope that helps!

-Eric


-----Original Message-----
From: Ater, Josh [mailto:[hidden email]]
Sent: Thursday, November 05, 2009 1:05 PM
Subject: Need to export large table

I am working from a very moderate size file of 14,000 records but have a
few tables that consist of several hundred rows. I need to export these
rows into excel and the software keeps stalling on me. Any tricks I can
use?

Josh

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Melissa Ives]

However, if you have set the Journal to overwrite instead of append, what you lost will be erased as soon as you open SPSS (Statistics; PASW).  If you have NOT changed the journal option, you could open the journal as syntax within SPSS.  However, if you overwrite your journal (which we do since otherwise the journal grows to immense proportions rather rapidly), then use the other options of opening within word or ...

Melissa

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Fry, Jonathan B.
Sent: Thursday, November 05, 2009 11:37 AM
To: [hidden email]
Subject: Re: [SPSSX-L] journal file

The error sounds like you double-clicked the journal file.  You should be able to open it as a syntax file from within Statistics.  I could get to mine by copying the file name from the Edit/Options/File Locations tab, then using File/Open/Syntax and pasting the name.

Jonathan Fry

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Cathie Atkinson
Sent: Thursday, November 05, 2009 11:17 AM
To: [hidden email]
Subject: journal file

Hi

SPSS crashed earlier (v17.01) and I lost a syntax file.  I'm trying to open the journal file (first time in 17) to retrieve my syntax, but it won't open.  I get an error saying "unkown file type specified on command line".  I tried to open it with notepad but it's unreadable that way.  Is there any other way I can get to it?

Thanks!
Cathie

Cathie Atkinson, PhD
Clinical Psychologist
Institute for Behavioral Medicine Research The Ohio State University
[phone]
[hidden email]

=====================
To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND
CONFIDENTIAL information and is intended only for the use of the
addressee. If you are not the designated recipient, or an employee
or agent authorized to deliver such transmittals to the designated
recipient, you are hereby notified that any dissemination,
copying or publication of this transmittal is strictly prohibited. If
you have received this transmittal in error, please notify us
immediately by replying to the sender and delete this copy from your
system. You may also call us at [phone] for assistance.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD