Orchid record keeping
Login
User Name
Password   


Registration is FREE. Click to become a member of OrchidBoard community
(You're NOT logged in)

menu menu

Sponsor
Donate Now
and become
Forum Supporter.

Orchid record keeping
Many perks!
<...more...>


Sponsor
 

Google


Fauna Top Sites
LOG IN/REGISTER TO CLOSE THIS ADVERTISEMENT
  #1  
Old 01-06-2019, 06:04 PM
ramp ramp is offline
Senior Member
 

Join Date: Mar 2008
Location: Antwerp, Belgium
Age: 59
Posts: 151
Default Orchid record keeping

Hi all,

After a nearly fatal accident, 2 year ago, I recovred enough to start keeping some orchids again and I'm trying to get back on track.

However, I lost my acces database I used to use.

So I was wondering if someone Has a record keeping database (editable) for PC, exel or access to share free of charge so I can start over again.

Since I'm not sure where to post this, I posted it in the beginner and advanced section. So moderators please move it when in the wrong category.

Thanks already, Marc
Reply With Quote
  #2  
Old 01-22-2019, 10:42 PM
SouthPark's Avatar
SouthPark SouthPark is offline
Senior Member
 

Join Date: Dec 2018
Member of:AOS
Location: Australia, North Queensland
Posts: 5,214
Default

Is Microsoft Excel spreadsheet suitable for the book-keeping work?

Maybe a Microsoft Excel WorkBook file could get the job done .... the workbook file can store multiple spreadsheets.... 1 spreadsheet per main group of plants.
Reply With Quote
  #3  
Old 06-07-2019, 06:58 PM
SouthPark's Avatar
SouthPark SouthPark is offline
Senior Member
 

Join Date: Dec 2018
Member of:AOS
Location: Australia, North Queensland
Posts: 5,214
Default

Quote:
Originally Posted by ramp View Post
So I was wondering if someone Has a record keeping database (editable) for PC, excel or access to share free of charge so I can start over again.
I didn't have an excel orchid list before. But decided to try my hand at using excel to just get some ideas about structuring an orchid list in excel.

I can upload an microsoft excel 'workbook' .xlsx file. Anybody is allowed to tinker with it, modify it, and use it for their own purposes. The usual golden rule is --- whatever database we use --- and whatever files we have, always make backups, and store those backups in various different places - not on the same computer. That's to avoid tears if a file gets corrupted somehow.

The attached file is a zipped (winzip) file. It needs to be extracted, in order to get an orchids.xlsx file out of it. And then you can use a recent-enough version of microsoft excel spreadsheet to open the workbook. And down the bottom will be various 'tabs' for jumping around the various spreadsheets contained within this 'workbook'.

Excel has built-in features like alphabetical sort for a particular column. So even if a column isn't alphabetical order ----- excel has inbuilt sorting functions that can quickly sort names into alphabetical order if needed.

With the attached spreadsheet workbook file, the user simply fills in some information, and some cell commands does the rest for us, like conveniently string together the full name of the orchid.

For cases where the full name of the orchid doesn't automatically get generated, you just need to copy the the contents of the cell (which contains the cell command) ABOVE it to the cell where the full name hasn't been generated. Basically just a copy/paste CTRL-C and CTRL-V thing. Quite simple.

No "macros" (scripts) are used in this spreadsheet - so completely safe. No security issues.

[UPDATE] - added extra unique ID generator for orchid book keeping purposes if needed - based on date/time generation.
Attached Files
File Type: zip orchids.zip (21.5 KB, 76 views)
File Type: zip IDgen.zip (16.0 KB, 34 views)

Last edited by SouthPark; 09-08-2019 at 06:04 PM..
Reply With Quote
  #4  
Old 06-17-2019, 04:42 AM
MiniMoth MiniMoth is offline
Jr. Member
 

Join Date: May 2019
Posts: 29
Orchid record keeping Female
Default

Check out Ricci's free software (English) at rz-orchideen.de - I loooove it!

Found it by accident on a German forum, autotranslate on Chrome worked good enough for me.

https://www.lonisorchideenforum.de/t252f45-Kostenlose-Windows-Software-zur-Orchideen-Verwaltung.html

(sorry, I cannot post working links yet, maybe mods can fix this)

It's awesome! Super easy and quick to use, no clutter. Space for free-style notes and some other nifty features (automatic "cash accounting", blooming graph for each plant, filtering by groups).

Absolute favorite feature - I can attach multiple images to one plant (including date and a quick note for every picture). Easy to track progress

My orchid "collection" went from zero to 34 in just three months, so it's getting out of hand really fast

For a quick portable reference I use Gardenize app on my phone, but I don't like it...
Reply With Quote
Post Thanks / Like - 1 Likes
Likes IngieBee liked this post
  #5  
Old 06-17-2019, 06:05 AM
IngieBee IngieBee is offline
Senior Member
 

Join Date: May 2019
Zone: 9b
Location: San Fernando Valley, California
Posts: 121
Orchid record keeping
Default

@MiniMoth, thank you so much for that link! What a cool program, and super interesting website!
Reply With Quote
  #6  
Old 06-17-2019, 11:36 AM
borofan borofan is offline
Jr. Member
 

Join Date: Jun 2018
Posts: 26
Orchid record keeping
Default

Looks promising but only available for Windows, not Mac!
Reply With Quote
  #7  
Old 06-17-2019, 12:01 PM
camille1585's Avatar
camille1585 camille1585 is offline
Administrator
 

Join Date: Oct 2007
Location: middle of the Netherlands
Posts: 13,683
Default

For an orchid journal, I dug through the forum to find an old thread I had in mind.

software database

Last post has a link that may interest you, an OB member developed an Mac/PC app for tracking/logging orchids. I use the journal in Orchidwiz, but think I'll try this to see how it compares.
__________________
Camille

Completely orchid obsessed and loving every minute of it....

My Orchid Photos

Last edited by camille1585; 06-17-2019 at 12:04 PM.. Reason: replying to wrong post
Reply With Quote
Post Thanks / Like - 1 Likes
Likes SouthPark liked this post
  #8  
Old 06-17-2019, 04:14 PM
SouthPark's Avatar
SouthPark SouthPark is offline
Senior Member
 

Join Date: Dec 2018
Member of:AOS
Location: Australia, North Queensland
Posts: 5,214
Default

Thanks for providing that link Camille. I went to that link and uploaded an excel workbook attachment there - just for extra options.
Reply With Quote
  #9  
Old 06-22-2019, 01:49 AM
IngieBee IngieBee is offline
Senior Member
 

Join Date: May 2019
Zone: 9b
Location: San Fernando Valley, California
Posts: 121
Orchid record keeping
Default

I want to thank @MiniMoth for the link to Ricci's free software again. I downloaded it tonight and inserted all my plants, it's really fantastic. I just need to put in more details, but I have pictures and some links to info inserted already. This is going to be a life saver for me as I have such a poor memory and I'll be able to review what each plant needs here so much easier than my big book Thank you again! BTW, is there a save button? I am afraid to close the program, LOL
Reply With Quote
  #10  
Old 06-22-2019, 05:45 AM
MiniMoth MiniMoth is offline
Jr. Member
 

Join Date: May 2019
Posts: 29
Orchid record keeping Female
Default

Ricci's program is great indeed 4 plants later I still like it, and it's very quick to update.

You do "save" after each entry, and the program won't let you start editing another plant (or add another picture) before you save or cancel the latest changes. The green tick mark does the saving - if it's green, you forgot to confirm the last entry.

BTW, remember it does not copy pictures, it only saves the current path to the photo. If you move the picture to another folder, the program loses track of it. My way around it was to create a permanent folder for pictures used in the database (I placed it inside program folder and created a shortcut on the desktop). First manually copy the pictures to the folder, then assign them to plants in the database.
Reply With Quote
Post Thanks / Like - 1 Likes
Likes IngieBee liked this post
Reply

Bookmarks

Tags
database, keeping, marc, record, start


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sources of Orchid Seed s1214215 Propagation 8 05-13-2021 09:25 AM
Orchid record keeping ramp Beginner Discussion 5 01-07-2019 07:34 PM
Beginner Needs Help With Unknown Orchid Kearneyweard Beginner Discussion 12 06-17-2014 08:00 PM
The BEST Orchid Companion! epiphyte78 Off Topic - Totally 6 09-29-2013 06:04 PM
Orchid Record Keeping - Excel Template/s? Uechi Beginner Discussion 30 10-14-2009 09:23 AM

All times are GMT -4. The time now is 04:03 AM.

© 2007 OrchidBoard.com
Search Engine Optimisation provided by DragonByte SEO v2.0.37 (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.

Clubs vBulletin Plugins by Drive Thru Online, Inc.