Converting dBase Files into CSV Files 

Prerequisites

You have completed the following steps:

Downloading BI master data into a dBase file

Geocoded using ArcView GIS

Integration

The result of the geocoding is the dBase file Geocodierung_Result.dbf. This file contains the BI master data enhanced with columns X and Y. Since the attribute table is stored in dBase file format, you must convert it into CSV (comma separate value) format, which is executed by the BI Staging Engine. You can convert the table in Microsoft Excel.

Procedure

...

       1.      Launch Microsoft Excel and choose File → Open...

       2.      From the selection list in the field Files of Type, choose dBase Files (*.dbf).

       3.      Open the Geocoding_Result.dbf file. The attribute table with the geoattributes is displayed in Excel.

       4.      Choose File → Save As...

       5.      From the Save as Type selection list, choose CSV (Comma Delimited).

       6.      Save the table.

Result

You have converted the dBase file into a CSV file with the geoattribute for the dynamic geocharacteristic 0D_SOLD_TO. You system administrator can now schedule a master data upload.

When you upload the CSV file, you have to map the values in column X to the attribute 0LONGITUDE, and the values in column Y to the attribute 0LATITUDE.