The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Origin behaves badly reading wide file

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
a_user Posted - 08/19/1998 : 3:59:00 PM
I am using Origin 5.0,
on a 200MHz Pentium Pro with 256 MB of RAM,
8GB of disk, 6 GB of disk free,
1GB of swap, nearly all free, etc., etc.

Origin behaves badly when I attempt to read in the attached
wide file - which is the actual data I want to manipulate.
The file is attached in whatever format Microsoft Outlook
attaches files in.

Input File Description

The file is notable, perhaps, in that it is quite wide:

120 lines
61 columns
558 characters/line, on average

It contains tab-separated-values (a Microsoft TSV).

It contains certain fields that contain text data,
in particular containing commas, such as
spec95,099.go,I=ref,S=5stone21

It contains the string "undef" to indicate missing data.

It contains fieldnames as the first line of the file.
It may be worth noting that these fieldnames contain
underscores and periods, e.g.
ctr16.benchmark_unique_name

Problem Description

Two problems:

(1) the file will not load correctly.
(2) invariably, when I try to load it a second time,
Origin crashes

Let me describe these problems in more detail

(1) the file will not load correctly

When I do "File/Import/ASCII" and click my filename,
without setting any special data templates, invariably

a) Origin correctly detects that it is tab separated - GOOD

b) Origin decides that line 26 contains the fieldnames
(column labels, whatever) - BAD
Q: why not the first line?

c) Origin only loads in data lines 33-61 - BAD
(although so far as I can tell, the data is loaded in correctly for
these lines).

d) Origin only loads in 24 characters for each text field

e) various goofinesses relating to "undef" text fields in data fields

This is PRETTY DAMN BAD.

I can imagine that Orign may have various filesize and/or line length limits.
But it should at least provide error messages when these limits are exceeded.

I note that I have also tried explicitly setting flags, such as indicating the
delimiter,
and converting the "undef" strings to numeric values (-9999). No help.

(2) Origin crashes

If I attempt to perform the same action again, "File/Import/ASCII" ...
Origin just plain crashes, with an error window and an instruction number from
the debugger.

No matter what the user priblem, it is just plain bad to crash.

Attached Files

I'd attach the files here, except that I can't in this web page

1   L A T E S T    R E P L I E S    (Newest First)
Gary Lane Posted - 08/19/1998 : 4:02:00 PM
Import file by setting ASCII Import Options and Column Type

Origin crashed when importing your file because the first line contained
illegal characters for worksheet column names. Select File:Import ther
Options(other ASCII Import Options) from the Origin main menu and uncheck
everything except Append Column Name to Label. This will allow the file to be
imported without
a crash.

If you change the first two columns of your worksheet to be of Column Type
Text(double click on the column name and select Text from the Column Type list
box)then your other problems should be solved as well.


Current topic MiniMenu


The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000