BGCI Worldwide > How to Edit your Garden Data
How to Edit your Garden Data
Updating Your Garden Profile
If you haven't got a login please complete the garden editor application form to create an account. We will send you a username and password so you can begin.
Once you have received your user name and password, you can update your garden's online information by following the instructions below:
Adding Your Plant Records Via Your Garden Entry
Contributing your garden’s plant lists is a valuable contribution to the monitoring of Target 8 of the Global Strategy for Plant Conservation.
Your plant collection will also be cross referenced against the threatened plant lists and you can obtain a report of your unique holdings. The information is used to inform policy on plant diversity conservation worldwide and to allow networking opportunities for conservation.
How to Add or UpdateYour Plant Records
While editing your garden data in the database, you can also upload, replace or append your garden’s plant holdings.
This is done by cutting and pasting a CSV (coma separated values) file, holding plant name information only.
A Microsoft Excel file can be saved as a CSV file by selecting ‘CSV (comma delimited)’ as the option under ‘Save as Type’ in the ‘File - Save As’ menu.
Adding plant records
To add plant records, select ‘Plant upload’ from the menu on the left, and follow the instructions.
Seven fields only are required (abbreviations of field names taken from ITF2 Standard Field Names (1998):
Genus Hybrid (genhyb)
As a CSV file, this would be written as: genhyb,gen,sphyb,sp,isprk,isp,cul
Any field can hold a blank value, which will be recorded as a comma (which indicates to the computer programme to move to the next field).
If you only have genus and species name, the record would be written as:
With the blanks (-) removed, the record would be ,gen,,sp,,,
So the plant list might look like:
Your plant list is added to by clicking on either ‘Append to plant list’ or ‘Replace current plant list’
You can review your garden plant holdings by clicking on ‘View your current plant list’. At that point, erroneous records can be deleted by clicking the box in the ‘delete’ column and clicking on ‘delete selected’ at the bottom of the table.
Updating plant list
New records can be added to an existing list by appending a new list to a current list – as above.
Alternatively, you can download your current plant list as a CSV file and add new records to the CSV file.
To do this, click on ‘Download your current plant list as CSV’.
This will open your plantlist as a text file. This file should be named plantlist.csv and saved as a text file.
Once the .csv file extension is present, the file can then be opened as a spreadsheet showing the records in the correct column format. The columns called ‘2004_redlist’ and ‘1999_redlist’ should be deleted before new records are added to this list.
The updated list can then be added to the database by clicking on ‘Replace current plant list’