Converting dBase Files into CSV Files
Prerequisites
You have completed the following steps:
Downloading BW Master Data into a dBase File
Integration
As a result of the geocoding, you receive the dBase file Geocoding_Result.dbf. This file contains the BI master data enhanced by the columns X and Y. Since the attribute table is saved in dBase file format, you now have to convert the table into a CSV ( c omma s eparated v alue) format that can be executed by the BW Staging Engine. You can convert the table in Microsoft Excel.
Procedure
-
Launch Microsoft Excel and choose ...
-
From the selection list in the field Files of Type, choose dBase Files (*.dbf).
-
Open the file Geocoding_Result.dbf. The attribute table with the geo-attributes is displayed in Excel.
-
Choose ...
-
From the Save as Type selection list, choose CSV (Comma Delimited).
-
Save the table.
Results
You have converted the dBase file into a CSV file with the geo-attribute for the dynamic geo-characteristic 0D_SOLD_TO. You system administrator can now schedule a master data upload.

