View source for Error Messages/42780

[[Category: Error messages]]

== Example error message ==
<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 ==

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.

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 =
* [[Using the Import and Export Commands]]
* [[Export-Import data format]]
* [[ReadExportFile]]
* [[Typescript]]