Create gcp from Excel

Plant database files

It is possible to attach a plant database file to a design created using gCADPlus. Think of this file as a simple text list of plants that you might use in a design.

The figure below shows an example of one such file.

Note the order of fields: Botanical Name, Common Name, TYPE, CODE, POT SIZE, COST, CUSTOM.

Tip: These text files are simple space-delimited ASCII files with the extension .gcp. We include quite a number in your Windows Documents folder during the installation of gCADPlus.

Most files are quite small an contain a limited number of species. The most comprehensive is a file called GardenCAD.gcp which has > 500 species to choose from.

Clearly, it is not possible for us to provide plant database files for every locality. You can, however, make your own from scratch.

If you are able to obtain a text or Excel file of plant names from a local nursery, it is possible to quickly create a custom database file suitable for use with local plant species in gCADPlus (or GardenCAD).

Creating a gcp file from Excel data

Many nurseries can supply a list of plants in the Excel spreadsheet application. In the example shown below-the data was in CSV text form and to load it, I had to change the files of type to CSV. There are three columns of data. Note that neither the order of columns or headings does not match the gcp standard used by gCADPlus.

In order to use the data in gCADPlus, column headings and order need to be changed to match the standard as shown below.

Once that was done, (remembering that the file is still in CSV comma separated format), the file is saved as a space-delimited file.

Finally, Windows Explorer is used to rename the file with a .gcp extension. That file will now load into gCADPlus using the gCADPlus drop menu > Plant Schedules and Lists > Attach gcp file

Here is an example of the file in use. We are in the process of adding some new codes rather than relying on (but still keeping) the nursery codes.