Difference between revisions of "Error Messages/42780"

(Created page with "= Example Error Message = :The data file being imported has a formatting problem on line 12: :Expected 3 rows of data but only found 1 = Cause = When reading data that is supp...")
 
Line 1: Line 1:
= Example Error Message =
+
[[Category: Error messages]]
  
:The data file being imported has a formatting problem on line 12:
+
== Example error message ==
:Expected 3 rows of data but only found 1
+
<pre style="background:white; border:white; margin-left: 1em; font-style:italic">
 +
The data file being imported has a formatting problem on line 12:
 +
Expected 3 rows of data but only found 1
 +
</pre>
  
= Cause =
+
== Cause ==
  
 
When reading data that is supposed to be in the [[Export-Import data format]], the file does not conform to the proper format. This format is read when you use the '''File&rarr;Import...''' menu command, the [[ReadExportFile]] function, '''Copy Table''' and '''Paste''' between instances of Analytica, or the [[Import]] typescript command.
 
When reading data that is supposed to be in the [[Export-Import data format]], the file does not conform to the proper format. This format is read when you use the '''File&rarr;Import...''' menu command, the [[ReadExportFile]] function, '''Copy Table''' and '''Paste''' between instances of Analytica, or the [[Import]] typescript command.
Line 15: Line 18:
  
 
= See Also =
 
= See Also =
 
+
* [[Using the Import and Export Commands]]
 
* [[Export-Import data format]]
 
* [[Export-Import data format]]
 
* [[ReadExportFile]]
 
* [[ReadExportFile]]
 +
* [[Typescript]]

Revision as of 01:00, 15 March 2016


Example error message

The data file being imported has a formatting problem on line 12:
Expected 3 rows of data but only found 1

Cause

When reading data that is supposed to be in the Export-Import data format, the file does not conform to the proper format. This format is read when you use the File→Import... menu command, the ReadExportFile function, Copy Table and Paste between instances of Analytica, or the Import typescript command.

You might see this when you have created data files in export format yourself, but don't have it quite right.

One case that produces this error is when the first table block in the file has 3 rows, but some later block has fewer or more than 3 rows. Each block should have the same number of rows, since each row corresponds to one element of the row index.

There are a number of mistakes in an export data file that might lead to this error, and underlying mistake can be somewhat different than the error message suggests. What has happened is that the information in the header, or preceding file, has led the parser to believe that the number of rows of table data is wrong. Sometimes your mistake might be in the header portion or the file, so that when it got to the data, what it found wasn't consistent with was the header indexes indicated was coming. In these cases, you have to look at where it found the problem, and think about how the index information preceding that might imply a different number of rows. When doing so, always look one row before and after the reported line number.

See Also

Comments


You are not allowed to post comments.