Author Topic: Copying plants from the Master database  (Read 4399 times)

0 Members and 1 Guest are viewing this topic.

Offline mendipdobbin

  • Newbie
  • *
  • Posts: 4
Copying plants from the Master database
« on: February 18, 2008, 06:22:01 PM »
Hi there everone. I'm new to this game - only installed Ideas Genie yesterday - so forgive me if this is a stupid question or has already been covered somewhere...
I've started looking at copying plants from the Master database into my own database, and have come across what seems to be a problem. The Master DB includes its own set of Plant culture and Plant care classifications. These differ slightly to the ones included in the installed My MAIN DB - for example the Master DB includes a Plant care entry of 'Mulch', which isn't in my DB. So, when I copy a plant from the Master DB into my DB, it doesn't copy across the culture and care information. In fact, even if I do have similar entries to the Master DB (eg both the Master and My MAIN DB have a culture property of 'Flowering time' with the same list of grades) the values don't seem to be copied over - I assume because the DB uses non-visible unique record identifiers & these are different between the 2 databases.
So, the question is, can I copy across the Plant culture and Plant care files from the Master DB to my DB? And if so, how do I do it?
Or am I just misunderstanding something?

Thanks in anticipation...

Claire (mendipdobbin)

Online ideasguy

  • Administrator
  • Hero Member
  • *****
  • Posts: 6326
  • Just me
    • Ideas for Gardens
Re: Copying plants from the Master database
« Reply #1 on: February 18, 2008, 08:33:00 PM »
Hi Clair, and welcome to the forum and the Ideas Genie Community!
It was nice to have that chat this evening before you raced out to your badminton! I'm really pleased to learn you are a fellow software developer  :)

RE:
Quote
can I copy across the Plant culture and Plant care files from the Master DB to my DB? And if so, how do I do it?
That is a very good question for someone with one day of IG experience  :)
The answer at present is no, I'm afraid  :-[
The reason for this is pretty much as you have described. As you now know, each Culture/Property characteristic (which I referred to as a query statement)  is made up of three elements. In the database, each element is stored as a single character - the non-visible information. Being user configurable,  A, B and C could mean something entirely different in the database of User A to that in the database of User B, even when the descriptions are identical, and even that would also be pretty unlikely.

As explained on the phone, I do hope to offer an interactive solution, similar to that which you will probably come across when Plant Types dont match when copying a plant from the Master DB.  The program offers the user a choice:
a) Create a Plant Type exactly as the Plant Type being copied or
b) Select a Plant type in your own database.(you can also use Files>GA018 to add Plant types to your own database, of course)

e.g. Heres an example where you may get that interactive screen. In your database, you (in the UK) may have a plant type called Hardy Annual.
I used to have that plant type in the Master Database.
However, Katie at Covington Water District (USA) asked me if it was an oxymoron!
With my sheltered life in Engineering, I'm afraid I had to do a bit of surfin' to find out what an Oxymoron was (quicky came up with one of my own - Personal Computer)
They dont use that "hardy" term in the USA for plant types.
On further investigation, the penny dropped on why the RHS A-Z book doesnt refer to "hardy perennial", "hardy annual" etc. Its because that book is also sold in the US. Instead, its Perennial and Annual. I followed their guidelines.

You can see the dilemna.

The intereactive solution will allow the user to see what the characteristics are for the plant being copied, and allow the same type of options as  for Plant Types.
However, that would slow down the copy process - a lot.

So, Ive left it to the user at present.Its a quick copy from the Master database of the Plant Name and non-configurable data - very little user interaction required.
The user can then play with two of the three buttons in the Plant Profile (edit) screen GA100S36.
The a) Google button and b) The BBC button
Info on plants are easy to find using those resources, and better still, you can select a site which offers information relevant to your region - which as no doubt everyone knows by now can be "controversial". All part of the fun!



Offline mendipdobbin

  • Newbie
  • *
  • Posts: 4
Re: Copying plants from the Master database
« Reply #2 on: February 19, 2008, 12:36:00 PM »
Hi George,

Thanks for the explanation - makes a lot of sense. I'm going to have another play with it now - as the weather is so cold here at the moment I don't feel like getting out into the garden (it went down to -4 last night, and is still hovering around freezing, and foggy). Brrrr!

Claire

Online ideasguy

  • Administrator
  • Hero Member
  • *****
  • Posts: 6326
  • Just me
    • Ideas for Gardens
Re: Copying plants from the Master database
« Reply #3 on: February 19, 2008, 12:51:58 PM »
Very frosty overnight here too, Claire - to the point that I'm really worried about losing my tender plants.

Theres another option in relation to Copying plants.
I can write the Culture/Property statements AND the Care records to the Plant Data text region.
Thus, when you copy the plant, all that info will be captured.
With this option, the Plant data info will have extra text appended, like:
Hardiness Zones (US) - Suitable for Zone 7, Zone 8
Hardiness ratings (UK)- Categorise as Fully Hardy
Divide March
etc

The user can then manually apply the relevant information (using Global Editing-GA100S30xx screen set) , and delete whats not.