How to map data from a CSV file
The following procedure assumes that you have created a data file connection. The procedure uses as an example, a CSV file having the following structure:
PRODUCTNAME,QUANTITYINSTOCK,MSRP
1969 Harley Davidson Ultimate Chopper,7933,95.7
1952 Alpine Renault 1300,7305,214.3
1  
In Options, choose New from file.
2  
In Table Declaration, set properties for the target database, as shown in Figure 3-24.
1  
In Database, type a database name. Alternatively, select an existing database name from the list of target databases.
2  
In Name, type the name a target table to which you will map data. For example, CarInventory.
3  
In Description, type characters that describe information the table will contain, such as Car Inventory and MSRP.
4  
In Action, select Create.
5  
Select Overwrite.
Figure 3-24  
Defining file structure
3  
Select options that match properties of the source file, as shown Figure 3-24.
1  
In Type, select Delimited.
2  
In Encoding, select ASCII.
3  
Select Header. In this example, 1 appears in Skip. Edit the value in Skip to match the number of header rows in the source data file.
4  
In End Line, select CrLf.
5  
In File, select a source file name from the list.
6  
In Delimiter, select comma (,).
7  
In Qualifier, select ".
8  
Select Wellformed.
4  
Choose View to validate the data connection. The file content appears, as shown in Figure 3-25. Choose OK.
Figure 3-25  
Viewing file content
5  
Choose Get columns to import the file metadata.
During the metadata import process, Get columns reads column name information from the header row in the source file, determines a type for each column, and indexes each column.
Definitions for each new column created in the target table appear listed in Table Declaration, as shown in Figure 3-26.
Figure 3-26  
Getting column definitions
6  
To modify properties for a column, select a listed column definition and choose Edit.
1  
In Column Declaration, select or modify any available properties.
2  
To remove index information from a column, deselect Indexed.
3  
To exclude a column from loading, select Skip.
4  
Choose OK.
For example, change the type of the MSRP column from Integer to Real, and set the column to not indexed, as shown in Figure 3-27.
Figure 3-27  
Editing column definition properties
7  
To close a selected database table, in Table Declaration, choose OK.
8  
In Project, choose Save. Choose Yes to confirm saving the script for the current project, as shown in Figure 3-28.
Figure 3-28  
Saving a project
Additional Links: Forums | Blogs | Support | Give Us Feedback | More...

Copyright Actuate Corporation 2013 BIRT Analytics 4.2