View source for Import and Export data

[[Category: Analytica User Guide]]
<breadcrumbs> Analytica User Guide > Integration with data and applications > {{PAGENAME}}</breadcrumbs><br />
 
== Import into an Edit Table or List from a text file  ==

To import a definition from a text file into an edit table or list:

# Select the definition field of the variable in either the [[Object window]] or [[Attribute panel]] definition view. If variable is a table, open the edit table.
# If you are importing a simple tab-delimited file, then select the cell(s) in which to import. If you are importing a data file in the format described in [[Model file formats]], then the cell selection is not used.
# Select '''Import''' from the [[File menu]]. A dialog prompts you for the file name from which to import.<br />

:[[File:18.7.png]]<br />

To import all the elements of a multidimensional table (including all the slices), a special text format is required (see [[Model file formats]]). This is also the format in which an edit table or result table is exported. The indexes of the table must have been previously created as nodes.

==Export a result table to a text file==

To export a variable’s result table to a text file, first be certain that the text file is closed.

# Select the variable to be exported from and open its [[Result window]].
# Select '''Export''' from the [[File menu]]. A dialog prompts you for the file name to export to.

==Printing to a File==

Another way of exporting any [[Diagram window]], [[Object window]], or [[Result window]] to a file is to print to a file:

# Select '''Print''' from the [[File menu]].
# Select '''Print to File''' and press ''Enter'' or click '''OK'''.
# Enter the name of the file and the format for the file in the dialog that appears.

:[[File:18.8.png]]

==Edit Table Data Import/Export Format==

Multidimensional data being imported or copied into an edit table must be in a text file with the special format described in this section. This is also the format in which an edit table or result table is exported.

*<tt>TextTable</tt> is a keyword.
*<tt>View</tt> is the name of the view from which the data originated. If your data was exported from an edit table, this is <tt>EditTable</tt>. If it was exported from a result table, it will be <tt>Value, Mean, Statistics, Probbands, PDF, CDF</tt> or <tt>Sample</tt>.
*<tt>Variable identifier</tt> is the identifier of the variable node where the data originated.
*<tt>Index identifier</tt> is the identifier of the index for this variable. An index with this name must already exist in the model, with the same length as in the file. When the index is a domain index, the <<tt>Index Identifier</tt>> is of the form <tt>Domain of</tt> <<tt>identifier</tt>>.
*Each index value and array value pair must be separated by tab characters.
**Numeric values appear directly, in any of Analytica’s standard number or date/time formats.
**Text values are enclosed in either double (") or single (') quotes. Tab and newline characters cannot appear between the quotes. If the text between the quotes includes a tab or newline character, it must be escaped using one of the sequences: <code>\n, \r, \t</code>. If a backslash or quote character appears in the text, it too must be escaped using <code>\\, \'</code>or<code>\"</code>. (When the text is enclosed in double quotes, single quotes don’t have to be escaped, and vice versa).
**Expressions (from edit table cells), which include distribution functions that might appear in edit table cells, appear without quotes as long as they single-line expressions (i.e., do not contain any newline characters), do not start and end with the same quote character (such as the expression <code>"a" & "b"</code>), and do not contain any tab character. Otherwise, the entire expression is enclosed between tildes, and the escape sequences <code>\n, \r, \t, \\, \~</code> are used for newline, tab, backslash or tilde characters. For example, the following multi-line expression:
:::<code>var s:= "~~”;</code>
:::<code>JoinText(A, I, s) & '\' </code>
::would appear as <code>~var s:= "\~\~”;\rJoinText(A, I, s) & '\\'~</code>.
* The value null may appear as [[Null]].

===One-dimensional array===
The format for a one-dimensional array is:

<pre style="background:white; border:white; margin-left: 1em;">
TextTable <View> <Variable identifier> <line break>
<Index identifier><line break>
<Index value><tab><Array value><line break>
</pre>

'''Example'''

:[[File:18.9.png]]

===Two-dimensional array===
The format for a two-dimensional array is:
<pre style="background:white; border:white; margin-left: 1em;">
TextTable <View><Variable identifier><line break>
<Index1 identifier><tab><Index1 values separated by tabs>
<line break>
<Index2 identifier><line break>
<Index2 value1><tab><Array values separated by tabs><line break>
<Index2 value2><tab><Array values separated by tabs><line break>
<Index2 valueN><tab><Array values separated by tabs><line break>
</pre>

'''Example'''
 
:[[File:18.10.png]]

===Three-dimensional array===

The format for a three-dimensional array is:

<pre style="background:white; border:white; margin-left: 1em;">
TextTable <View> <Variable identifier> <line break>
<Index1 identifier><tab><Index1 Value1><line break>
<Index2 identifier><tab><Index2 values separated by tabs><line break>
<Index3 identifier><line break>
<Index3 value1><tab><Array values separated by tabs><line break>
<Index3 value2><tab><Array values separated by tabs><line break>
<Index3 valueN><tab><Array values separated by tabs><line break>
<Index1 identifier><tab><Index1 Value2><line break>
<Index2 identifier><tab><Index2 values separated by tabs><line break>
<Index3 identifier><line break>
<Index3 value1><tab><Array values separated by tabs><line break>
<Index3 value2><tab><Array values separated by tabs><line break>
<Index3 valueN><tab><Array values separated by tabs><line break>
</pre>

And so on for each value of <code>Index1</code>.

'''Example'''

:[[File:18.11.png]]
 
===Number format===

Numerical data can be imported in any format recognized by Analytica (see [[Number formats]]). 

Numerical data is exported in the format set for the table, with these exceptions:
* Suffix format numbers are exported in scientific exponential format.
* Fixed decimal point numbers of more than 9 digits are exported in scientific exponential format.
* If a date format begins with the day of the week, e.g., “Saturday, January 1, 2000”, the weekday is suppressed: “January 1, 2000”.

==See Also==
* [[Export-Import data format]]
* [[Model file formats]]
* [[Number formats]]
* [[ReadExportFile]]
* [[Export]]


<footer> Read data from URL on internet  / {{PAGENAME}} / OLE linking</footer>