Data Import
The entry of indicator data may occur as follows: Manually or through import of data from text files or .DBF.
| • | Manually: Go to each indicator and, in Value Worksheet folder, inform the value. |
| • | Import: Schedule the Data Import. |
SGI searches the directory informed to find .txt, .csv or .dbf files. The structure of these files must be the following:
| 1. | Text Files - The same structure of a .CSV file from Excel, separated by (;) and with extension .txt or .csv. Example: |
Id ;Code; Period; Value; Goal; Description; Preliminary.
10;040;1/1/06;100;110; Number of customers of the tool;100
10;040;1/2/06;90;200; Number of customers of the tool;
The first line is dismissed in the import. Below are the meanings of columns:
| • | ID: Internal indicator code, created by the system. |
| • | Code: Import code manually informed in the indicator registration. |
| • | Period: Target date of value. |
| • | Value: Value (without periods, only commas separating decimals) calculated in the period. |
| • | Goal: Goal (without periods, only commas separating decimals) calculated in the period. |
| • | Description: Indicator description (optional). |
| • | Preliminary: Preliminary value for that indicator in that period. |
Either the ID or the Import Code must be informed. The description is optional.
The update works as follows: Using a text file: If an indicator value or goal is empty in a line of the text file, the value referring to the period already saved in database will be kept. To zero the actual value or the goal value, you must put a 0 (zero) for these values in the text file. The same applies to the preliminary. |
| 2. | DBF Files (The .dbf type must be DBASE III): |
SGI imports data from .dbf files that contain the following field structure:
Field |
Type |
Size |
Decimals |
ID |
Character |
10 |
0 |
CODE |
Character |
30 |
0 |
PERIOD |
Date |
8 |
0 |
VALUE |
Number |
19 |
6 |
GOAL |
Number |
19 |
6 |
The update works as follows:
| • | Using a .dbf file: Fields Value and Goal are optional (but at least one of them must be in the file). Only values of the existing field will be updated. For example, if you do not want to import any goal, just send the file with field Value. Goal values be kept, but all actual values are updated. The same applies to the field Goal. |
Both types of files must be in the directory informed in the scheduling. Once the file was read and imported, it is renamed to bkpnomedoarquivo.*, and moved to a directory named updated, situated below the file source directory.