Converting dBase Files into CSV Files 

Prerequisites

You have completed the following steps:

Downloaded BW master data into a dBase file

Execute Geocoding with ArcView Gis

Integration

As a result of the geocoding, you receive the dBase file Geocoding_Result.dbf. This file includes the enriched BW master data for columns X and Y. Since the attribute table is stored in the dBase file format, you have to convert the table into CSV format (comma separated value), which can be executed by the BW 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 downloading the CSV file, you have to map the values in column X for the attribute 0LONGITUDE and the values in column Y for the attribute 0LATITUDE.