Importing a database

Database before
Database before: using the basic labels

Although this is not difficult, it can be headache to prepare your data.

There are a few steps:

  1. Create a database file with attribute data in Excel
  2. The first column should be named ‘ID’ corresponding to the ID in Map Maker.
  3. The database id must match ONLY one label in the .dra file (remember you can edit the .dbf file from the Project Manager Data link menu or Utilities, Edit Database).
  4. The spreadsheet can ONLY have as many rows (ex the title row) as there are mapping units (lines, polygons which are best not mixed!).
  5. Also, the ID column must be text format and any formulas converted to values.
  6. There should be no empty values (remember to use the default -99 for missing values)
  7. Save this file as an .dbf (or .xls file, though this can be problematical)
  8. When this is done, you can import into MapMaker.
  9. This is done through the Project Manager, and the layer that you wish to link to (chose .xls from the drop down).
Database after
Database after: a new database has been attached and different columns show

This process is by no means simple, especially if your database and polygon files are complex and reference to the Map Maker manual is highly advisable.

Published by

@ourlocality

@OurLocality Publishing Locally in East Lothian - JOIN FREE