Page 1 of 1

A "Garden Plants" Base add-on

PostPosted: Mon Feb 16, 2015 1:27 pm
by papijo
Hi all,

It is my pleasure to invite you to browse my first AOO/LO base add-on.
The beta version can be downloaded here:

The gardenplants application is an add-on to be used with Apache OpenOffice (AOO) or LibreOffice (LO) . It is aimed at enthusiast gardeners who wish to maintain a database of the plants in their garden, organized according to standard botanical principles.
No knowledge of the inner workings of AOO/LO base component is required, as a user-friendly interface is provided.
The gardenplants application consists of a main document with two forms for entering and browsing the database records. On the Edit Plants form/page, gardeners can enter detailed general information about the plants they have (or plan to have) in their garden. Such information can easily be found in horticultural manuals or on gardening websites.
On the Edit Specimens form/page, gardeners can enter specific information about those plant specimens that are actually planted in their own garden. Easy navigation is provided between the two forms.

Technical details
    * Uses a split database with HyperSQL DataBase driver, version 2.3.2.
    * Shipped with the original *.odb base document, complete with unprotected macros.
    * 2 standalone forms documents for easy managing of the database.
    * Full instructions for installing and using the add-on: AOO/LO document with screen shots, about 20 pages.
    * Makes heavy use of macros for a better and safer user experience and user-friendly warning and error messages.
    * Includes a cascading feature for the Family > Genus > Species > Cultivar taxonomy feature.
I am heavily indebted to several active members of this forum who have kindly answered my questions over the past few months as I was striving to create this add-on. I hope those members (and others) will find the time to have a look at my gardenplants application and am looking forward to any bug report, improvement suggestions, etc.

Thanks in advance. ;)

Re: A "Garden Plants" Base add-on

PostPosted: Sun Jul 05, 2015 11:21 am
by IGraham
Hello papijo

Have just downloaded your plants database, impressive.
Was considering making one myself and was looking for hints as to what to include, how to go about it. Yours is however better (beyond my abilities) and includes plant features i would not have included but which are better included as an option to use.
I haven't as yet tried to enter data as as good as your database is it does not include features i would like but because of my inferior skill set would be unable to include myself.
I did want to include information as to
    where the plants were planted in the garden - reference to a grid system/map
    when and from whom they were purchased, price
    when planted/died

As I said I'm unable to implement these features myself but am wondering if you have developed the database further and possibly included 'extra' features
Or am i going to have to make an inferior database, if so thanks for giving your version, from which i'll take good ideas - even if I'll only ever be a lowly aspirant

Re: A "Garden Plants" Base add-on

PostPosted: Sun Jul 05, 2015 11:53 am
by papijo
Hi IGraham,
Thanks for your appreciation of my Garden plants db. I have now made a bilingual version (English-French) which I use for my own garden plants. This new version also has new features and some bug fixes. I might make it available if there is interest.
Re your suggestions for improvement. In the "Edit specimens" mode, there are indeed fields for plant location in the garden : Location and Plan reference and also Origin (where purchased/obtained, etc). Maybe the term used "origin" is ambiguous, as it might be thought to refer to the geographical provenance of the plant, but it is not ambiguous when you are in "Edit specimens" mode.
I had thought about a "price" field, but did not implement it. I agree it might be useful.
Again, the information about when plant died (or was removed from garden) would be useful. What I do at the moment is simply set the group quantity number to zero. And any detailed information as to what happened can be entered for that specimen in one of the 2 available text fields : Notes and Cultivation notes.

I hope this answers your questions. Please contact me by PM if you have further questions and if you would like to download a more current version.

Re: A "Garden Plants" Base add-on

PostPosted: Sun Jul 05, 2015 11:05 pm
by IGraham
I'll get back to you on this - haven't forgotten or gone away, just trying it out

Re: A "Garden Plants" Base add-on

PostPosted: Sun Jan 24, 2016 2:10 pm
by Write!365
Thank you ever so much!!

This add-on is not "a nice to have" it's really "a need to have"!! :)

It's always exciting to upgrade knowledge (databases..) when it includes something you enjoy, as gardening.

So, now I'm digging in to something, for me, completely new. :)

Re: A "Garden Plants" Base add-on

PostPosted: Sun Jan 24, 2016 6:21 pm
by papijo
Hi Write!365 and thanks for your interest in my "gardenplants" DB.
I am still using it, but not currently maintaining it, as I have now moved my "virtual garden" on-line. You are welcome to visit it at

Re: A "Garden Plants" Base add-on

PostPosted: Wed Nov 23, 2016 5:37 pm
by papijo
I have made a new, all English, version of my gardenplants base add-on. It is available with detailed installation and use instructions at this address:
Comments welcome!