When preparing geometry files for import, you can review and modify the .DBF file to ensure they contain accurate and up-to-date data for your import.
This is typically optional and you can review the results of your Geometry imports in Borealis then troubleshoot through the .DBF as needed.
Open a dBase (.DBF) file in Excel
Before starting, you will need to remove the .DBF file from the Compressed file (.ZIP) folder and put it in a regular folder somewhere on your desktop.
You may want to keep a copy of the original .DBF file in case mishaps happen during the editing process.
- Open a new blank Excel workbook.
- Click the File menu and select Open.
- Browse your computer to the location of the .DBF file you want to open.
- Click the file extension selector drop-down list, usually sporting the default label All Excel Files, and select dBase Files.
- Select the .DBF file you want to review.
- Click the Open button.
Review the Content of your .DBF file
You can then proceed to review the data of your .DBF file as needed.
Do note that while you can freely edit the .DBF file, you should keep in mind the following:
- The relation between the records in the .SHP file and the .DBF file is one-to-one and based on record number (position) in the files.
- The list of items (ID column) in the .DBF file should be in the same order as the list of items found in the .SHP file so that they can be linked together by the system during import.
Save and Add the New .DBF File to your Geometry Compressed .ZIP
Once you are done reviewing the file, save it as its default type (.DBF) and add it back to your Geometry compressed .ZIP file.
You can then proceed to import the Geometry .ZIP file to Borealis.