Re: [Freesurfer] QDEC table loading errors
there a line break script, which is somehow installed in my system (Sentos),
which cleans this up. you basically type lb "FILENAME"
i can't try and find out what it contains, if you can't get it to work
On 22 September 2010 11:28, James Porter wrote:
> Hello-
>
> I'm having a resurgence of an old problem (
> http://www.mail-archive.com/freesurfer@nmr.mgh.harvard.edu/msg12152.html)
> but the old solution is not cutting it. When I try to load a table in QDEC
> 1.4, I get the following error:
>
> Loading data table qdec.table.dat...
> ERROR: QdecDataTable::Load did not find a column named 'fsid', 'ID', or
> 'Subject' in the first column of qdec.table.dat!
> Error loading the data table.
>
> However, the file definitely does have 'fsid' as the first column.
>
> > head qdec.table.dat | awk '{print $1, $2, $3}'
> fsid Sex AgeGrp
> 14080 Female Oldr
> 14081 Female Oldr
> 14286 Female Oldr
> 14287 Female Oldr
> 14390 Female Oldr
> 14391 Male Oldr
> 14392 Male Oldr
> 14428 Female Oldr
> 14430 Male Oldr
>
> Creating the file on Windows, Mac, and Unix platforms using a variety of
> programs (kate, oocalc, text wrangler, excel, word, notepad, etc) with
> 'fsid', 'ID', or 'Subject' as the column title doesn't help, nor does
> running dos2unix on the file(s). Having tab delimited or space delimited
> files doesn't make any difference, either. Trying to open the tables with
> QDEC in Unix (RedHat) or Mac (10.6.4) doesn't change the outcome.
>
> Any ideas on how to solve this riddle?
>
> Thanks,
> Jim
>
> --
> Jim Porter, M.A.
> Graduate Student
> Clinical Science and Psychopathology Research
> University of Minnesota
>
>
>
> ___
> Freesurfer mailing list
> Freesurfer@nmr.mgh.harvard.edu
> https://mail.nmr.mgh.harvard.edu/mailman/listinfo/freesurfer
>
>
> The information in this e-mail is intended only for the person to whom it
> is
> addressed. If you believe this e-mail was sent to you in error and the
> e-mail
> contains patient information, please contact the Partners Compliance
> HelpLine at
> http://www.partners.org/complianceline . If the e-mail was sent to you in
> error
> but does not contain patient information, please contact the sender and
> properly
> dispose of the e-mail.
>
>
--
***
Ilana Hairston ,PhD
Research Assistant Professor
4250 Plymouth Rd. (rm 2439)
Psychiatry Department, Addiction Research Center
University of Michigan, Ann Arbor MI 48109-2700
Tel: 734-232-0232; Mobile: 650-906-8449
Sentimental Insomnia and Nostalgia Disorders Sciences
___
Freesurfer mailing list
Freesurfer@nmr.mgh.harvard.edu
https://mail.nmr.mgh.harvard.edu/mailman/listinfo/freesurfer
The information in this e-mail is intended only for the person to whom it is
addressed. If you believe this e-mail was sent to you in error and the e-mail
contains patient information, please contact the Partners Compliance HelpLine at
http://www.partners.org/complianceline . If the e-mail was sent to you in error
but does not contain patient information, please contact the sender and properly
dispose of the e-mail.
Re: [Freesurfer] QDEC table loading errors
there shouldn't be a limit on the number of columns it will read. the
thing to be careful about is the name of a column. sometimes when
importing a spreadsheet, a column name will consist of two words (thus
messing-up the detected number of columns), or it will have a minus "-"
char in the name, which doesnt get interpreted properly. probably there
is a column name which is not a single word.
n.
On Wed, 2010-09-22 at 10:45 -0500, James Porter wrote:
> Of course, once I ask for help I stumble immediately upon the
> solution. There appears to be a limit to the number of columns that
> QDEC is willing to put up with when reading in tables. If I create a
> table that only has the few columns that I'm interested in (as opposed
> to the kitchen sink spreadsheet I was working with), then it reads in
> without error.
>
> Thanks for the help by proxy!
> Jim
>
>
> On 9/22/10 10:38 AM, Nick Schmansky wrote:
> > can you send me the file?
> >
> > n.
> >
> > On Wed, 2010-09-22 at 10:28 -0500, James Porter wrote:
> > > Hello-
> > >
> > > I'm having a resurgence of an old problem
> > > (http://www.mail-archive.com/freesurfer@nmr.mgh.harvard.edu/msg12152.html)
> > > but the old solution is not cutting it. When I try to load a table in
> > > QDEC 1.4, I get the following error:
> > >
> > > Loading data table qdec.table.dat...
> > > ERROR: QdecDataTable::Load did not find a column named 'fsid',
> > > 'ID', or 'Subject' in the first column of qdec.table.dat!
> > > Error loading the data table.
> > >
> > > However, the file definitely does have 'fsid' as the first column.
> > >
> > > > head qdec.table.dat | awk '{print $1, $2, $3}'
> > > fsid Sex AgeGrp
> > > 14080 Female Oldr
> > > 14081 Female Oldr
> > > 14286 Female Oldr
> > > 14287 Female Oldr
> > > 14390 Female Oldr
> > > 14391 Male Oldr
> > > 14392 Male Oldr
> > > 14428 Female Oldr
> > > 14430 Male Oldr
> > >
> > > Creating the file on Windows, Mac, and Unix platforms using a variety
> > > of programs (kate, oocalc, text wrangler, excel, word, notepad, etc)
> > > with 'fsid', 'ID', or 'Subject' as the column title doesn't help, nor
> > > does running dos2unix on the file(s). Having tab delimited or space
> > > delimited files doesn't make any difference, either. Trying to open
> > > the tables with QDEC in Unix (RedHat) or Mac (10.6.4) doesn't change
> > > the outcome.
> > >
> > > Any ideas on how to solve this riddle?
> > >
> > > Thanks,
> > > Jim
> > > --
> > > Jim Porter, M.A.
> > > Graduate Student
> > > Clinical Science and Psychopathology Research
> > > University of Minnesota
> > >
> > > ___
> > > Freesurfer mailing list
> > > Freesurfer@nmr.mgh.harvard.edu
> > > https://mail.nmr.mgh.harvard.edu/mailman/listinfo/freesurfer
> >
> >
> > The information in this e-mail is intended only for the person to whom it is
> > addressed. If you believe this e-mail was sent to you in error and the
> > e-mail
> > contains patient information, please contact the Partners Compliance
> > HelpLine at
> > http://www.partners.org/complianceline . If the e-mail was sent to you in
> > error
> > but does not contain patient information, please contact the sender and
> > properly
> > dispose of the e-mail.
> >
___
Freesurfer mailing list
Freesurfer@nmr.mgh.harvard.edu
https://mail.nmr.mgh.harvard.edu/mailman/listinfo/freesurfer
Re: [Freesurfer] QDEC table loading errors
Of course, once I ask
for help I stumble immediately upon the solution. There appears to
be a limit to the number of columns that QDEC is willing to put up
with when reading in tables. If I create a table that only has the
few columns that I'm interested in (as opposed to the kitchen sink
spreadsheet I was working with), then it reads in without
error.
Thanks for the help by proxy!
Jim
On 9/22/10 10:38 AM, Nick Schmansky wrote:
can you send me the file?
n.
On Wed, 2010-09-22 at 10:28 -0500, James Porter wrote:
Hello-
I'm having a resurgence of an old problem
(http://www.mail-archive.com/freesurfer@nmr.mgh.harvard.edu/msg12152.html) but the old solution is not cutting it. When I try to load a table in QDEC 1.4, I get the following error:
Loading data table qdec.table.dat...
ERROR: QdecDataTable::Load did not find a column named 'fsid',
'ID', or 'Subject' in the first column of qdec.table.dat!
Error loading the data table.
However, the file definitely does have 'fsid' as the first column.
> head qdec.table.dat | awk '{print $1, $2, $3}'
fsid Sex AgeGrp
14080 Female Oldr
14081 Female Oldr
14286 Female Oldr
14287 Female Oldr
14390 Female Oldr
14391 Male Oldr
14392 Male Oldr
14428 Female Oldr
14430 Male Oldr
Creating the file on Windows, Mac, and Unix platforms using a variety
of programs (kate, oocalc, text wrangler, excel, word, notepad, etc)
with 'fsid', 'ID', or 'Subject' as the column title doesn't help, nor
does running dos2unix on the file(s). Having tab delimited or space
delimited files doesn't make any difference, either. Trying to open
the tables with QDEC in Unix (RedHat) or Mac (10.6.4) doesn't change
the outcome.
Any ideas on how to solve this riddle?
Thanks,
Jim
--
Jim Porter, M.A.
Graduate Student
Clinical Science and Psychopathology Research
University of Minnesota
___
Freesurfer mailing list
Freesurfer@nmr.mgh.harvard.edu
https://mail.nmr.mgh.harvard.edu/mailman/listinfo/freesurfer
The information in this e-mail is intended only for the person to whom it is
addressed. If you believe this e-mail was sent to you in error and the e-mail
contains patient information, please contact the Partners Compliance HelpLine at
http://www.partners.org/complianceline . If the e-mail was sent to you in error
but does not contain patient information, please contact the sender and properly
dispose of the e-mail.
___
Freesurfer mailing list
Freesurfer@nmr.mgh.harvard.edu
https://mail.nmr.mgh.harvard.edu/mailman/listinfo/freesurfer
The information in this e-mail is intended only for the person to whom it is
addressed. If you believe this e-mail was sent to you in error and the e-mail
contains patient information, please contact the Partners Compliance HelpLine at
http://www.partners.org/complianceline . If the e-mail was sent to you in error
but does not contain patient information, please contact the sender and properly
dispose of the e-mail.
Re: [Freesurfer] QDEC table loading errors
can you send me the file?
n.
On Wed, 2010-09-22 at 10:28 -0500, James Porter wrote:
> Hello-
>
> I'm having a resurgence of an old problem
> (http://www.mail-archive.com/freesurfer@nmr.mgh.harvard.edu/msg12152.html)
> but the old solution is not cutting it. When I try to load a table in QDEC
> 1.4, I get the following error:
>
> Loading data table qdec.table.dat...
> ERROR: QdecDataTable::Load did not find a column named 'fsid',
> 'ID', or 'Subject' in the first column of qdec.table.dat!
> Error loading the data table.
>
> However, the file definitely does have 'fsid' as the first column.
>
> > head qdec.table.dat | awk '{print $1, $2, $3}'
> fsid Sex AgeGrp
> 14080 Female Oldr
> 14081 Female Oldr
> 14286 Female Oldr
> 14287 Female Oldr
> 14390 Female Oldr
> 14391 Male Oldr
> 14392 Male Oldr
> 14428 Female Oldr
> 14430 Male Oldr
>
> Creating the file on Windows, Mac, and Unix platforms using a variety
> of programs (kate, oocalc, text wrangler, excel, word, notepad, etc)
> with 'fsid', 'ID', or 'Subject' as the column title doesn't help, nor
> does running dos2unix on the file(s). Having tab delimited or space
> delimited files doesn't make any difference, either. Trying to open
> the tables with QDEC in Unix (RedHat) or Mac (10.6.4) doesn't change
> the outcome.
>
> Any ideas on how to solve this riddle?
>
> Thanks,
> Jim
> --
> Jim Porter, M.A.
> Graduate Student
> Clinical Science and Psychopathology Research
> University of Minnesota
>
> ___
> Freesurfer mailing list
> Freesurfer@nmr.mgh.harvard.edu
> https://mail.nmr.mgh.harvard.edu/mailman/listinfo/freesurfer
___
Freesurfer mailing list
Freesurfer@nmr.mgh.harvard.edu
https://mail.nmr.mgh.harvard.edu/mailman/listinfo/freesurfer
The information in this e-mail is intended only for the person to whom it is
addressed. If you believe this e-mail was sent to you in error and the e-mail
contains patient information, please contact the Partners Compliance HelpLine at
http://www.partners.org/complianceline . If the e-mail was sent to you in error
but does not contain patient information, please contact the sender and properly
dispose of the e-mail.
[Freesurfer] QDEC table loading errors
Hello-
I'm having a resurgence of an old problem
(http://www.mail-archive.com/freesurfer@nmr.mgh.harvard.edu/msg12152.html)
but the old solution is not cutting it. When I try to load a table
in QDEC 1.4, I get the following error:
Loading data table qdec.table.dat...
ERROR: QdecDataTable::Load did not find a column named 'fsid',
'ID', or 'Subject' in the first column of qdec.table.dat!
Error loading the data table.
However, the file definitely does have 'fsid' as the first column.
> head qdec.table.dat | awk '{print $1, $2, $3}'
fsid Sex AgeGrp
14080 Female Oldr
14081 Female Oldr
14286 Female Oldr
14287 Female Oldr
14390 Female Oldr
14391 Male Oldr
14392 Male Oldr
14428 Female Oldr
14430 Male Oldr
Creating the file on Windows, Mac, and Unix platforms using a
variety of programs (kate, oocalc, text wrangler, excel, word,
notepad, etc) with 'fsid', 'ID', or 'Subject' as the column title
doesn't help, nor does running dos2unix on the file(s). Having tab
delimited or space delimited files doesn't make any difference,
either. Trying to open the tables with QDEC in Unix (RedHat) or
Mac (10.6.4) doesn't change the outcome.
Any ideas on how to solve this riddle?
Thanks,
Jim
--
Jim Porter, M.A.
Graduate Student
Clinical Science and Psychopathology Research
University of Minnesota
___
Freesurfer mailing list
Freesurfer@nmr.mgh.harvard.edu
https://mail.nmr.mgh.harvard.edu/mailman/listinfo/freesurfer
The information in this e-mail is intended only for the person to whom it is
addressed. If you believe this e-mail was sent to you in error and the e-mail
contains patient information, please contact the Partners Compliance HelpLine at
http://www.partners.org/complianceline . If the e-mail was sent to you in error
but does not contain patient information, please contact the sender and properly
dispose of the e-mail.
