Tracking or Cataloging a Fig Collection

Author

Comment

CliffH

Registered:1463781646
Posts: 124

Posted 1464485958	Reply with quote #1

I am new to growing figs. But, I have to confess that I am a long time computer geek (professionally). I'm looking for the best way to track a collection of fig trees. Including dates, source, and source type (nursery tree, cuttings, etc). Those type of things. Along with some logging on the tree's growth. What does everyone use? Really looking for something (software) on the computer. I started creating a database myself. But I thought that I would ask before going to that trouble. PS - I still plan to post some pics of the unknown tree we got with the new house. But, been busy dealing with lots of rain, and a little flooding. So, no pics yet. Cliff H. __________________ Texas (N. Houston area) - zone 8b Wish List: Figo Preto, Col de Dame Blanca-Negra, Deanna, Strawberry Verte, Violette de Sollies, LSU Red (new)

Jamie0507

Registered:1435895205
Posts: 167

Posted 1464489628	Reply with quote #2

I just use google spreadsheet to keep track of everything.. I "borrowed" the template from Ross though so I can't take any credit for its creation lol! So far its been a huge help to me in keeping track of all the different varieties I'm growing along with all the other important info.. I have the link posted below if you'd like to check it out __________________ Jamie Zone 6A My List of Fig Varieties: https://docs.google.com/spreadsheets/d/13MXbhU3b-5Y4bkNSWHVikw6m-vovlHZcBjcsxMwQ7iY Wish list: Col. Littmans, Figoin, Black Tuscan.. And now for my "Hey..A girl has got to have dreams!" wishlist: Sangue Dolce, Montenegro, Rigato del Salento

CliffH

Registered:1463781646
Posts: 124

Posted 1464505871	Reply with quote #3

Thanks! That gives me several new ideas to add the database that I decided to go ahead and start. __________________ Texas (N. Houston area) - zone 8b Wish List: Figo Preto, Col de Dame Blanca-Negra, Deanna, Strawberry Verte, Violette de Sollies, LSU Red (new)

Jerry_M

Registered:1427223807
Posts: 344

Posted 1464531625	Reply with quote #4

Hi Cliff, welcome to the forum. I like to record in a spreadsheet cutting or plant, the year of acquisition, cost and ownership back to its origin. I keep an Evernote document entitled "Fig Notes" where I record information about figs in general. When a certain variety is referenced, I highlite and Bold the name to catch my attention when scrolling the document. __________________ Jerry Canyon Lake, TX 8b Wanted: Cajun Gold, Louisiana Honey, Schar Israel-114 grams

genecolin

Registered:1248866064
Posts: 1,542

Posted 1464547522 · Edited

Reply with quote #5

I use two different spreadsheets, one is a fig list and the other is a detail of each fig. Below are examples of the two. Sorry it doesn't show the gridlines but if you know spreadsheets the you know where they should be.

Fig list:

	Name	1 gallon	2 gallon	3 gallon	5 gallon	location

1	Cajun Gold (Lowes)	1
2	Negronne (rafed)
4	Nonnie's Green (king) (mimi boothy)	1		1
5	Ventura (steve miller)
7	Martin's UK (steve miller)			1
9	Atreano (very small cutting from Jazzbass) ricci fields			1
17	Mead UK (mike gorski)			1

Here is the second one I use for detail. Each tree has it's own sheet.

NAME

# 30-1 HOLLIER

DATE AQUIRED

EARLY AUGUST 2009

AQUIRED FROM

JAMES ROBIN

PRICE

$10.00

1 yr old tree

EYE

SKIN COLOR

FLESH COLOR

TASTE

LOCATION

IN GROUND

Tree

NOTES:

Tree was about 24" tall and looked very healthy.

Jan-10

up potted to 1 gallon pot

2/27/2010

bud opening

May-10

Having trouble with scale, treated and cleared up, Made 4 figs but they split.

__________________
From the bayou,
"gene"

zone 9
Houma, La.

rcantor

Registered:1309799312
Posts: 5,724

Posted 1464547728	Reply with quote #6

I use MS access When I get more than 10,000 figs I'll have to learn something else. Probably not until 2018, though. Welcome to the forum! __________________ Zone 6, MO Wish list: Galicia Negra, De La Reina - Pons, Genovese Nero - Rafed's, Sbayi, Souadi, Acciano, Any Rimada, Sodus Sicilian, any Bass, Pons or Axier fig, any great tasting fig.

jdsfrance

Registered:1376988473
Posts: 2,591

Posted 1464604067	Reply with quote #7

Hi, Pics are worth a thousand words. I take pics of my trees sort of every month, and have sort of a spreadsheet for the basic information ( name and source mainly). Photos all have a date stamp - so no need to worry about that information. __________________ ------------------------ Climate from -25°C to + 35°C Only cold hardy figtrees can make it here

genecolin

Registered:1248866064
Posts: 1,542

Posted 1464618578	Reply with quote #8

Here is a little better look at my detail sheet not only showing detail but also pictures. __________________ From the bayou, "gene" zone 9 Houma, La.

ross

Registered:1437442979
Posts: 375

Posted 1464629388	Reply with quote #9

The one Jamie shamelessly stole from me is in my signature :D __________________ Ross - Zone 6B/7A - Philadelphia My Cultivar List / Pictures! / My YouTube

Jamie0507

Registered:1435895205
Posts: 167

Posted 1464667533	Reply with quote #10

Gene I love how you put the pics in there too! Perhaps I may have to shamelessly "borrow" that idea as well! Lol __________________ Jamie Zone 6A My List of Fig Varieties: https://docs.google.com/spreadsheets/d/13MXbhU3b-5Y4bkNSWHVikw6m-vovlHZcBjcsxMwQ7iY Wish list: Col. Littmans, Figoin, Black Tuscan.. And now for my "Hey..A girl has got to have dreams!" wishlist: Sangue Dolce, Montenegro, Rigato del Salento

genecolin

Registered:1248866064
Posts: 1,542

Posted 1464748387	Reply with quote #11

Jamie, be as shameless as you want, I have no objection. Remember it's one fig per sheet. "gene" __________________ From the bayou, "gene" zone 9 Houma, La.

AltadenaMara

Registered:1422990132
Posts: 375

Posted 1464796616	Reply with quote #12

Is there any way a clickable list of fig varieties could be set up? You could click on a name and go to a detail sheet about that one variety. Back click and go back to the list? I haven't worked with data bases since Appleworks a long time ago and that was possible then. But I have Windows now and don't remember Excel being able to do that. I have a Word document with sometimes a half a page to a page of comments from people on the fig boards and Internet about a specific variety. Also pictures and links to the original posts. It's especially helpful when there is a lot of discussion as to which varieties are the same or nearly the same as others. But it's up to fifty-two pages now and I have to merge it with the thirteen pages of the new varieties I rooted this year. The whole document is getting too cumbersome to work with comfortably. __________________ Mara Southern California Zone 1990= 9b 2012= 10a 2020=?

don_sanders

Registered:1429304713
Posts: 219

Posted 1464825831 · Edited	Reply with quote #13

Here is how to create hyperlinks within Excel. http://www.colby.edu/acits/2010/03/29/link-worksheets/ Shamelessly copying your format might be easier with an existing copy of your populated spreadsheet, Gene. Maybe a good variety reference too. __________________ Don - Columbus, OH. Zone 5b/6a Wish list: Rafed/Adriano's Genovese Nero, Your favorite fig.

CliffH

Registered:1463781646
Posts: 124

Posted 1464835611	Reply with quote #14

Thanks everyone for the input and ideas! I have added several more data fields to the database that I started with. Fields that I had not thought of, and I am not sure I will use. But other people might (container info, etc). Hi Gene - I am "shamelessly ripping off a few of your ideas, and some of your data, if not the whole spreadsheet. Hope you don't mind. I would return the favor, by e-mailing your the Access database when I am finished. But it has been a long time since I did any DB work, and I am not having much time right now. So it may take a few weeks. Jerry - I would also be interest in your Evernote document. I use that app too. BTW, love your part of Texas. We have camped at the lake there frequently in the past, and plan to come back this summer. Mara - I had the thought about adding basic variety/cultivar data to the database itself couple of days ago, as well. I started working on collecting that data today. Cliff H. __________________ Texas (N. Houston area) - zone 8b Wish List: Figo Preto, Col de Dame Blanca-Negra, Deanna, Strawberry Verte, Violette de Sollies, LSU Red (new)

genecolin

Registered:1248866064
Posts: 1,542

Posted 1464875710	Reply with quote #15

Clift help yourself, I would also like to see your data base. Access is what we did our inventory with at work. "gene" __________________ From the bayou, "gene" zone 9 Houma, La.

BoyerHoldingsLLC

Registered:1463604948
Posts: 37

Posted 1464882022	Reply with quote #16

Hi Gene, Would you be able to share your template for those of us not good at excel? Craig __________________ Craig A. Boyer

rcantor

Registered:1309799312
Posts: 5,724

Posted 1464891512	Reply with quote #17

Access is a lot more flexible and organized than a spread sheet can be. It's easy to learn and totally worth it. Cliff, I'd love to see what you come up with. I had a lot of linked tables but I lost my whole DB in a computer crash - data and design. My back up S/W said every day that it was working but nothing had been recorded for 3 years. I'm slowly re-doing my inventory. __________________ Zone 6, MO Wish list: Galicia Negra, De La Reina - Pons, Genovese Nero - Rafed's, Sbayi, Souadi, Acciano, Any Rimada, Sodus Sicilian, any Bass, Pons or Axier fig, any great tasting fig.

CliffH

Registered:1463781646
Posts: 124

Posted 1464895788	Reply with quote #18

I gladly share the database when finished with a workable version. I will give it to a few people first just to test and get feedback. I don't plan to compile it, so you will need at least MS Access Run-time (2010, or newer) to use it. __________________ Texas (N. Houston area) - zone 8b Wish List: Figo Preto, Col de Dame Blanca-Negra, Deanna, Strawberry Verte, Violette de Sollies, LSU Red (new)

CliffH

Registered:1463781646
Posts: 124

Posted 1464896123	Reply with quote #19

rcantor - I sympathize on your data lose. A while back our main network storage hard drive died, with about 15 years worth of data and pictures on it. I freaked out. I worked for weeks getting the data back. I still loss a little of it. -chh __________________ Texas (N. Houston area) - zone 8b Wish List: Figo Preto, Col de Dame Blanca-Negra, Deanna, Strawberry Verte, Violette de Sollies, LSU Red (new)

genecolin

Registered:1248866064
Posts: 1,542

Posted 1464958169	Reply with quote #20

Don thanks for the instruction on applying hyperlinks. I have very little knowledge of spreadsheets but have found ways to make my life easier. I did as per the instructions and WoW, I now have it working great. I put the "fig list" as the first page and have link each item with it's detail page. That makes it much easier and faster than looking up a fig on my list page and then going to my detail sheets and thumbing through them to get to the right one. Thanks again. "gene" __________________ From the bayou, "gene" zone 9 Houma, La.

genecolin

Registered:1248866064
Posts: 1,542

Posted 1464963282	Reply with quote #21

Craig, I have sent you a Private Message. "gene" __________________ From the bayou, "gene" zone 9 Houma, La.

AltadenaMara

Registered:1422990132
Posts: 375

Posted 1464980684	Reply with quote #22

Quote: Originally Posted by don_sanders Here is how to create hyperlinks within Excel. http://www.colby.edu/acits/2010/03/29/link-worksheets/ Shamelessly copying your format might be easier with an existing copy of your populated spreadsheet, Gene. Maybe a good variety reference too. Don, that works great. Thanks so much. I can cut/paste -make a separate Word page for each variety, save it to the same folder as the Excel master and create a hyperlink from the master cell to the page. I just close the Word page when I want to go back to the Master List. Several people have created some nice Excel fig files, like the "figtastescale", so there's no need to re-invent the wheel. __________________ Mara Southern California Zone 1990= 9b 2012= 10a 2020=?

johnnyq627

Registered:1366344367
Posts: 710

Posted 1464981411	Reply with quote #23

I wish I had the patience to put together a webpage with a directory of my varieties and their corresponding youtube videos. For now, I create a google sheet at least: PA Figs Cultivars __________________ Nick- Youtube: PA Figs \| eBay: tdepoala Zone 6B/7A - Douglassville, PA Wish list - Galicia Negra, Paritjal Rimada, Black Ischia UCD

Previous Topic | Next Topic

Modal title

Insert Code

Please paste your code into the box below: