Show TOC

Converting dBase Files into CSV FilesLocate this document in the navigation structure

Prerequisites

You have completed the following steps:

Downloading BW Master Data into a dBase File

Geocoding Using ArcView GIS

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


  1. Launch Microsoft Excel and choose Start of the navigation path File Next navigation step Open End of the navigation path...

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

  3. Open the file Geocoding_Result.dbf. The attribute table with the geo-attributes is displayed in Excel.

  4. Choose Start of the navigation path File Next navigation step Save As End of the navigation path...

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

  6. 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.

Note

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.