Importing data into Autobox
Data import into Autobox can be achieved in several ways depending on the source of data. Please review the table below to find which method to use.
| Data Type | Procedure |
|---|---|
| Autobox | New time series data is imported via the ADD
option while adding values is done with the APPEND
option. Data can be in either TXT
format or DBF
format. |
Text File (Without Header) |
Here we present an example
of a plain txt file which can contain a number of time series. This
example has two series. |
| Text File (With Header) | Here we present an example
of a plain txt file which can contain a number of time series. This
example has two series the first being monthly and the second series is
annual. |
| DBF File (Without Header) | Here we present an example of a dbf file which contains no header information other than the name of the series. This example has four series whose seasonality has not yet been specified. The series should be UPPER/LEFT justified in that there can be no columns
to the left of the data or any columns above the data. There can be no
formatting of the data (i.e. commas). |
| DBF File (With Header) | Here we present an example of a dbf file which contains header information. This example has one weekly series staring at week 11 in 1989 with header information preceeding it. The series should be UPPER/LEFT justified in that there can be no columns
to the left of the data or any columns above the data. There can be no
formatting of the data (i.e. commas). |
| Access(97) Mdb file* |
Autobox uses an Access database platform. Autobox requires a table that describes the features of the series in the database. You can see this structure by viewing one of the many mdb files that are installed along with Autobox. |
* (Access files must be saved in Access 97 format, Access 2000 format will not work. For more information on converting formats please see Tools/Database Utilites/Convert Database in the Access application.)