Kathryn -- That does help -- to edit information in the people form you must enter directly from the people form not from a link. Another thing that puzzles me. I want search all the people in a small township and keep a record of the census. In other words make a of the censuses for 1850, 1860 and 1870 for a group of families Can I do this in Clooz? Or more practical to make a separate database, putting only people I am sure are related in the base? Regards Patricia On Fri, 4 Aug 2000, Kathryn Skelton wrote: > You can add names to the list _after_ you begin entering e.g. census data. Enter the general census data, and click to link individuals. If the person you want to link is not on the list of persons when you get to the individuals screen, press the enter key (man w/dog, I think) and enter the data, then click to link. (Although you can enter a new person there, you CANNOT edit any information there. If you leave the person entry form with a mistake or without all the info you wanted to put in, you'll have to go back later and fix them by entering People directly.) > > Really - you don't have to have the person in the database before you have information to enter about them. And, although Liz gives plenty of space for all kinds of info on individuals I figure all the information is already in my genealogical data base; all I need in Clooz is enough identifying info to match them up with the entries in PAF or Family Tree Maker or whatever. For me, that is generally an identifying number and a birthdate (or some other date if I don't have that one). Why clutter up my harddrive with the same info entered into two different programs? >

Kathryn, You are so correct about that! Barbara -----Original Message----- From: Kathryn Skelton [mailto:[email protected]] Sent: Friday, August 04, 2000 7:58 AM To: [email protected] Subject: [Clooz] Re: Inputting names after starting links You can add names to the list _after_ you begin entering e.g. census data. Enter the general census data, and click to link individuals. If the person you want to link is not on the list of persons when you get to the individuals screen, press the enter key (man w/dog, I think) and enter the data, then click to link. (Although you can enter a new person there, you CANNOT edit any information there. If you leave the person entry form with a mistake or without all the info you wanted to put in, you'll have to go back later and fix them by entering People directly.) Really - you don't have to have the person in the database before you have information to enter about them. And, although Liz gives plenty of space for all kinds of info on individuals I figure all the information is already in my genealogical data base; all I need in Clooz is enough identifying info to match them up with the entries in PAF or Family Tree Maker or whatever. For me, that is generally an identifying number and a birthdate (or some other date if I don't have that one). Why clutter up my harddrive with the same info entered into two different programs?

You can add names to the list _after_ you begin entering e.g. census data. Enter the general census data, and click to link individuals. If the person you want to link is not on the list of persons when you get to the individuals screen, press the enter key (man w/dog, I think) and enter the data, then click to link. (Although you can enter a new person there, you CANNOT edit any information there. If you leave the person entry form with a mistake or without all the info you wanted to put in, you'll have to go back later and fix them by entering People directly.) Really - you don't have to have the person in the database before you have information to enter about them. And, although Liz gives plenty of space for all kinds of info on individuals I figure all the information is already in my genealogical data base; all I need in Clooz is enough identifying info to match them up with the entries in PAF or Family Tree Maker or whatever. For me, that is generally an identifying number and a birthdate (or some other date if I don't have that one). Why clutter up my harddrive with the same info entered into two different programs?

List Members I'm new to Clooz. Received and installed the Stand-Alone Version 1.21 last week; created a test database; imported some names from Family Origin 8.03 successfully; printed and read the manual over the weekend; and am now experimenting with data entry and reports so I can decide on a filing and numbering system. I have a file cabinet full of material so will proceed cautiously. I have questions the manual does not address: 1. It appears the Personal File # field will accept many more characters than will print on reports. What IS the maximum number of characters that will print on reports? Obviously, I don't want to exceed the printing limitation. 2. Why are there five Place Lists (Place 1, Place 2, etc) on the Edit Dropdown List? What is the significant of each one and shouldn't a person know this before entering places? 3. How do you make multiple selections before you preview or print a report? Reference the Manual, Part 4, Chapter 1, Page 68 "Select (such as Select Census). This option gives you a report for a selected document or person, such as the 1840 census from Detroit, MI, containing the Dohertys." To me, this means you can filter out all other censuses, all other cities, and all other surnames leaving you a report with ONLY the Dohertys located in Detroit, MI in the 1840 census. However, I have not figured out how to do this. I can only get all the Dohertys or all the censuses in Detroit or all the 1840 censuses. 4. Can you print a simple index that you can file in front of the 3-ring binders? At this point, all I see is a "full blown" report that has more data than one needs in an index and you cannot print it in record number order. Presently, I have three indexes in the front of my Marriage Binder - by date, by groom, and by bride. Without an index, it appears you need access to your computer and Clooz to find which "page in the binder" is Aunt Mary's marriage certificate. Or am I missing something? Sorry for the length of this but I do want to have a better understanding before I begin this monumental project. Ron Adams Neighbor to Historical Fort Atkinson that overlooks the Missouri River Valley from Nebraska.

What genealogy software are you exporting from? Barbara [email protected] -----Original Message----- From: Keith Swalley [mailto:[email protected]] Sent: Thursday, August 03, 2000 8:36 AM To: [email protected] Subject: [Clooz] Reformatting data export Before committing to buying Clooz, I downloaded the Clooz manual in an effort to get clues as to how the program functions. I have made several attempts to export my information to a Word document (successfully), and then to edit the resulting document to the standards (format) required by Clooz (unsuccessfully). 1. I cannot get Word to replace the tabs with commas (between fields). 2. I cannot get Word to remove spaces. 3. If there is a missing date, for example the birth date, but there is an additional date, such as marriage or death, the editing process will move it to the left, and, therefore it will be under that birth date heading. I am not willing to edit the information line by line for over 2000 individuals, and am not interested in entering the data person by person. Any ideas??............or.... if there is anyone who has successfully accomplished the editing of the export, who would be willing to do the edit (en mass) for me for a reasonable fee, I would be willing to go that route. Clooz seems like it could be very useful, but I have not found the database import process to be friendly.

Before committing to buying Clooz, I downloaded the Clooz manual in an effort to get clues as to how the program functions. I have made several attempts to export my information to a Word document (successfully), and then to edit the resulting document to the standards (format) required by Clooz (unsuccessfully). 1. I cannot get Word to replace the tabs with commas (between fields). 2. I cannot get Word to remove spaces. 3. If there is a missing date, for example the birth date, but there is an additional date, such as marriage or death, the editing process will move it to the left, and, therefore it will be under that birth date heading. I am not willing to edit the information line by line for over 2000 individuals, and am not interested in entering the data person by person. Any ideas??............or.... if there is anyone who has successfully accomplished the editing of the export, who would be willing to do the edit (en mass) for me for a reasonable fee, I would be willing to go that route. Clooz seems like it could be very useful, but I have not found the database import process to be friendly.

Patricia, Here it is! If I understand the question correctly,I believe you do, otherwise how would you be able to link an individual to the census within Clooz? There are instructions in the Clooz manual on how to import your data from various genealogy programs. I would be pleased to help you with this if you'd like. Regards, Barbara Canfield [email protected] -----Original Message----- From: Patricia Tidmarsh [mailto:[email protected]] Sent: Wednesday, August 02, 2000 5:48 PM To: Barbara Canfield Cc: [email protected] Subject: RE: [Clooz] data input Barbara could you post your answer to the list? I am having the exact same problem. Thanks. On Wed, 2 Aug 2000, Barbara Canfield wrote: > Ramona, > If I understand the question correctly,I believe you do, otherwise how would > you be able to link an individual to the census within Clooz? > There are instructions in the Clooz manual on how to import your data from > various genealogy programs. I would be pleased to help you with this if > you'd like. > Regards, > Barbara Canfield > [email protected] > > -----Original Message----- > From: Ramona Hamilton [mailto:[email protected]] > Sent: Wednesday, August 02, 2000 10:27 AM > To: [email protected] > Subject: [Clooz] data input > > > Is it necessary to create a list of people before you can put a person in a > census record? > > I entered the ID number, the state, and the county for a particular person > on the 1850 census. My first one. I could not move the cursor to the > white field below to enter a name- either with the mouse or by a tab. I > cannot solve this problem by reading the manual , nor by repeated effort. I > would appreciate help. Thank you. Ramona Hamilton > >

Barbara could you post your answer to the list? I am having the exact same problem. Thanks. On Wed, 2 Aug 2000, Barbara Canfield wrote: > Ramona, > If I understand the question correctly,I believe you do, otherwise how would > you be able to link an individual to the census within Clooz? > There are instructions in the Clooz manual on how to import your data from > various genealogy programs. I would be pleased to help you with this if > you'd like. > Regards, > Barbara Canfield > [email protected] > > -----Original Message----- > From: Ramona Hamilton [mailto:[email protected]] > Sent: Wednesday, August 02, 2000 10:27 AM > To: [email protected] > Subject: [Clooz] data input > > > Is it necessary to create a list of people before you can put a person in a > census record? > > I entered the ID number, the state, and the county for a particular person > on the 1850 census. My first one. I could not move the cursor to the > white field below to enter a name- either with the mouse or by a tab. I > cannot solve this problem by reading the manual , nor by repeated effort. I > would appreciate help. Thank you. Ramona Hamilton > >

I created a database in Clooz that I decided I don't want. I'm sure I saw this problem treated on this list some time ago but can't find it. Also can't find it in the manual. Can anyone tell me how to delete a database? Lee

Ramona, If I understand the question correctly,I believe you do, otherwise how would you be able to link an individual to the census within Clooz? There are instructions in the Clooz manual on how to import your data from various genealogy programs. I would be pleased to help you with this if you'd like. Regards, Barbara Canfield [email protected] -----Original Message----- From: Ramona Hamilton [mailto:[email protected]] Sent: Wednesday, August 02, 2000 10:27 AM To: [email protected] Subject: [Clooz] data input Is it necessary to create a list of people before you can put a person in a census record? I entered the ID number, the state, and the county for a particular person on the 1850 census. My first one. I could not move the cursor to the white field below to enter a name- either with the mouse or by a tab. I cannot solve this problem by reading the manual , nor by repeated effort. I would appreciate help. Thank you. Ramona Hamilton

Is it necessary to create a list of people before you can put a person in a census record? I entered the ID number, the state, and the county for a particular person on the 1850 census. My first one. I could not move the cursor to the white field below to enter a name- either with the mouse or by a tab. I cannot solve this problem by reading the manual , nor by repeated effort. I would appreciate help. Thank you. Ramona Hamilton

Karen Chappell wrote: "Please note: before you can enter census data, all the people in the census must already be entered in the people section of the database." Not true. You can add new people as you go. Simply click on "Censuses" in the Clooz Hub. Click on the button for the census you wish to add (e.g., U.S. 1910), fill out the top portion of the template that contains the information that is common to every person in the document: personal file #, roll #, SD, ED, geographic location, etc. Next, "link" the people to the document. Clicking on the link (chain) button at the bottom will give you the full list of who is already in the People database, BUT YOU CAN ALSO ADD NEW PEOPLE if they aren't in the database. Click on the New Person button (has a man with his dog on it). Fill in the Alternate ID (optional), Surname, Given Name and B/M/D data. If you want to add another new person at this point, you can by clicking on the right arrow button at the top of the window. Otherwise, exit the New Person window by clicking on the door button. After you have linked all the people contained in that census document, you can then fill in the! ir detail screens. Kathy Bovenschen <[email protected]> Cogito ergo spud (I think, therefore I yam)

Thanks so much Karen. Your detailed explanation is most appreciated. The link icon detail in particular eluded me. As you put it so well, many things that are automatic for an experienced person are mysterious mazes where I spend hours. One more thing, how do I edit a wrong date? I have been able to reneter the person but not remove the original? Most appreciative Patricia

Dear List, There was a request for a lesson on entering Census data. So I will attempt to accomplish that. Let me start by saying that Clooz was not meant to take the place of a standard genealogy program. The genealogy program is designed to keep track of all your relatives and to form pedigreees which accurately show the links between each generation. Clooz is a genealogical "filing system". You can enter all of your documents, census, deeds, vital records, etc. By looking at all these documents in a systematic manner, it is supposed to help you spot trends or "clues" that had previously gone unnoticed. Plus everything will be stored in the computer instead of on thousands of pieces of paper on top of your desk. Since the templates for all of the U.S, and England are in the program, it helps you figure out what is in those mysterious columns at the end of the census lines. I am new to using Clooz, so I don't know the answers to the advanced questions, such as the various ways to sort the documents. I also am stumped about where some of the data goes. For instance, when you enter census data, you may enter the value of real estate property. But when you view the census report, that information is not in the report. (Where does all the extra data go?) But, I am fairly experienced with computers so I may accidentally leave out a step that seems automatic to me but is not so apparent to the new user. Entering Census Data Double Click on the Clooz icon to open the program. Please note: before you can enter census data, all the people in the census must already be entered in the people section of the database. You can enter their names with a number and leave everything else blank if you have no other information. See yesterday's Clooz e-mail for instructions on this. Highlight the name of the database you want to enter the info into. If you have just one database, this will already be highlighted. Click on Select. This brings up the Clooz "Hub". Single click on "Censuses" This page is like a main menu for the census. The flags show which census templates are available for which countries. The U.S. is on top with a template for each year that the U.S. Federal Census was taken. There are also two Generic templates. One is the button that says "Head" and the other is the button that says "Every". I believe that the Head one is for census documents where just the head of the family is listed and then the approximate ages of the other members of the household. Note that the U.S templates include similar templates for 1790 through 1840 U.S. censuses. If you are entering U.S. Federal census, I would use the templates on the top line. The generic censuses were meant for state censuses or censuses for other countries besides the U.S, Canada, the U.K and green White and orange Irish flag next to the Irish census. I am entering a 1910 census, so I will click on 1910. The first thing the program wants is a personal file #, which is the equivalent of a document number. The manual gives a good talk on filing systems and different methods for numbering your documents. I use a system that starts with the two letter abbreviation for the state, then the first three letters of the surname and then the document number. Example, the first document for Illinois for the Fildes family would be ILFIL001. If you are expecting to have more than 999 documents for each category you would need to use a longer document number. Enter the personal file # that you have chosen. Start entering as much information as you can find on your copy of the census. When I started copying census records, I did not enter the roll number. But, if you want that information, you can go to the National Archives website to find it. The address is www.nara.gov . SD may be supervisor's district ( I am not sure) I don't have one on my copy, so I leave it blank . But ED is enumeration district. Unfortunately, on the census I am entering, I do not have the part that shows the ED so I leave that blank. P. S. You can use your enter key to proceed from one data entry box to the next. Enter the two digit abbreviaton for the state. The programmer has already entered all of the United States plus some British and Canadian states. For instance, if I just type in I, IA appears. I have two choices. I can type in IL for Illinois, or I can type "I", and click on the arrow. A menu pops up with about six entries of places that begin with I. I can then highlight IL and click. IL appears in the box. Hit enter to proceed. Note, you can also use the tab button to proceed in a forward direction. If you skipped a box and want to go back and fill it in, hit your left arrow key until you are in the box that you skipped. Next type in County, and township, if available, then City, also if available. For repository, I use the location that I viewed the census, in this case the Tampa Public Library. For me, this doesn't seem necessary, because that is where I always go. But if you use several different repositories, it could be very useful, if you want to go back and get a better copy of the document. For instance, if I wanted to go back and get a copy of the Enumeration District for this census. If this is a Family History Library Film, enter the film number in the last box. Next you have to "link" each member of the family. To do this click on the chain. A list will pop up of all the people you have entered. If you have a very long list you will need to search. I need to search for Henry Fitch. I click on the Surname heading at the top of the box. Then I click on the binoculars to search the surnames. You can also search by given name, ID number, and alternate ID number by clicking on those headings. After I click on the binoculars, a text box appears. I type in Fitch, Henry and then click on the down arrow. This brings me to the alphabetical place in my list where Fitch, Henry appears. In this case three Henry Fitches appear. I see from the census that this Henry was born about 1850. I have a Henry Fitch in my list that was born in 1850 so I highlight that name, then I click on the chain, of the five icons, the very center one. After that hit the exit arrow, which is the last icon in the row of five. I also want to enter Henry's wife, Phebe. I happen to know that Phebe's maiden name is Mann. So I search under Mann, Phoebe. I highlight Phebe, click on the chain, then click on the exit arrow. I should now have the two names in the box. The headings in the box are ID, Alt ID, Surname and Given Name. Then at the end of the row, you will see a box called details. This is where you will type in all your information. You have finally reached the spot where you will be entering actual census data!!! Again, you will enter as much information as you have on your copy of the census. Sheet - usually appears near the Enumeration District Date taken - enter the day, then you can click on the arrow and highlight the month. The year is fixed in this template for the 1910 census. Then there is a place to enter the street. I have had to tab to leave these first four boxes blank, but I can now enter House # and DW (Dwelling ") number. On closer inspection of the census copy, I see that there are three columns and the last two are filled in. So these numbers are actually the dwelling number and the family number. The dwelling number and family number will be different if there have been previous instances of two families living in the same dwelling. After Family #, there is a box for line #. If the line numbers are not visible, you can number them yourself in order to enter the line on that census page for each individual. In large cities, with apartments, you will probably have different house numbers and dwelling numbers when there are numerous apartments in the same building. Most of the data I have entered are in rural areas so sometimes only one column is filled in. Next enter the surname and given name. Enter these exactly as they appear on the census. After you have entered two or three censuses for the same person, you will see a trend regarding the spelling of their names. Some families never show a variation in the spelling. But, if you do see variations, you will probably go with the spelling that occurs most frequently. For instance, on this census, Phebe is spelled "Phebe". That could be the preference of the census taker or it could be the actual way that Phebe spells her name. After I enter two or three more censuses, and say a cemetery inscription, I will come to a conclusion about the normal way that she spelled her name. Enter the "relation" for Head of family, type 'Head", other choices wife, son, daughter, etc. Enter sex, color and age as they appear on the census. Next enter status: S for single M for married W for widowed D for divorced. This has been the most useful tool for me. I have one or two instances where a husband or wife drops out of the census. Before I got Clooz, I tried to guess, now I see that the census has W in that spot. So now I don't have to wonder if Mattie ran off and left Marvin Jubilee Chappell with two small children. It says W next to his name, so he has told the Census taker that he is a widower. If Marvin has told the truth I have narrowed down the years of Mattie's death. She died between the year of the birth of her last child and 1920 (the census where she is missing). Clooz, they stick out better when you enter the information in a uniform database. The 1910 census asks for years married. The next useful tool is # of children living, then # of children born (to this woman, presumably). I am not sure whether they were very vigilant about asking the husband this question. Phebe says 11 of her 12 children are living. After entering the info, I will try to determine which of her 12 children died before this census. In the box marked Birth, you enter the place where this individual was born, use the words that the census taker used, in this case, Illinois. In the United States census, you will usually either see a State or a country if the birth place is outside of the United States. Then you enter the father's birthplace and the mother's birthplace. Year of Immigration and year of naturalization don't apply, so I leave those blank. Enter trade Enter Industry The next place is E/W/OA. I don't have copies of these columns and at this moment I can't think of what that would stand for. Perhaps someone else knows. Out of Work - this is usually answered Y or N for Yes or No Then if out of work, enter # of weeks. Read Write School These are usually answered Y or N for Yes or No. For adults the first two questions are answered. For children, the census taker will enter Y or N. I believe the full question is, has the child attended school within the last four months? Next box O/R for owned or rented then M/F for mortgaged or owned free and clea Then F/H for Farm or House The last line asks for Farm # whether survivor of Union or Conferedate Army or Navy whether Blind, deaf or dumb then the remarks box. You should enter any information that you think will be useful in interpreting this data. To exit any screen, click on the button with the open door and the blue arrow. Follow this procedure for each individual in the census. for the next person, a query box will appear. " Do you want to fill the previous data?" If you enter yes, the boxes that are common to the whole family will automatically be filled in and you will have fewer boxes in which to enter info. After you have entered all the info, you can click on the icon at the top of the screen. It is a white piece of paper with a magnifying glass. This will show you a preview of the copy of the census data you just entered. I just answered my question of where does all the mysterious data go? It is on this preview report. I have been looking at a different report. Click on the x in the upper right hand corner to close the detail box for this individual. Click on the open door with the blue arrow in the upper right hand corner to close this census form. Click on the open door with the blue arrow in the lower right hand corner to close the main census menu. You will be back at the Clooz "hub". To view all the data for one individual: Click on people. Search for the desired individual as explained above, very early in this lesson. Highlight the desired individual. Click on the fourth button. You will then be given a choice. Preview person with all documents. or Preview person with primary documents only. I like the first version. When it opens, the top information is the information that you input when you entered people in your program. The bottom information is information that you entered with each document. Here is where you will be able to spot trends, migration patterns, name spelling variations. age consistency from census to census. etc. I have been looking at this report a lot and wondering why I didn't see the miscellaneous data. I need to view the other report for the miscellaneous data. Well, I know that I am very wordy when giving explanations, but hopefully, this step by step will be of assistance to some of the new users. Karen

I'm a new user of Clooz. I was able to import from my genealogy program, after I found and applied the patch. I have a few questiions for those of you that have more experience with the program: 1) When you print a person's information, is it too wide for the paper? Mine runs over by a tiny bit, causing a second sheet to print. I tried changing the page setup to give it a wider left and right margin, but it doesn't help - it gets set back to the original value. 2) I have sorted my documents as indicated in the manual. Is there any way to get the documents to be sorted when I look at them by person? It would sure be nice to have all of the same types of records together, or to have the documents in date order. 3) Has anyone found a way to get source records into the program? I would like to export them from my genealogy program, edit them, and get them into Clooz. I tried looking at the database through Access, but the data doesn't show up. Sure would be nice to be able to do this. Thanks, everyone, Virginia [email protected]

Trying to add census information from a CD. Do I have to enter the people first in the people form? Can I use the Clooz template to enter unrelated people and neighbors without giving them ID numbers etc. For my own ancestors its okay to have an ID (will use Anhetafel numbers) Thanks for any help. And do appreciate baby steps. Passing knowledge of excel and access but references to "key" are obscure for me in this context. REgards Patricia

Pat, Yes you will have to enter the people first. Some genealogy programs have a utility that allows them to download or export the list of all the people in your genealogy program. Then you would import them into Clooz. If you have not added people manually one by one or by importing from another program. Then the first step would be to add the people. If you have one census year in particular that you had planned to enter, start with that family. Double click on your Clooz icon to open the program. The first thing you should see is a box that says Select or create a database. I have already created a database so the Letters Fildes.mdb show up. That is the name of my database. You are not limited to one database, you can create several if you like. You could create one for people who are known relations. And one database for not-yet proven relatives. Either type in a name of a database or click on Select if the database you want to use is showing. That takes you to the Clooz 'hub'. Click on People. If you have already entered people, you will see a list of your people with data you entered. It not this will be blank. To start entering people, click on the man with the dog. If you are manually entering people, you will have to give each person a number. You said you wanted to use their Ahenfantel number. (not spelled right, I'm sure). Since I have loaded people from my genealogy program, it gives automatic numbers if I leave the alternated number blank. But I imagine that the program will not let you proceed without assigning each person a number. Enter everything that you already know about each person. For females, follow the genealogy practice of entering them as given name then maiden name. When you are entering the actual census data, you can enter the name as it appears on the census for married womene that would be with their married name. After you enter one person, click on the blue arrow at the center of the top of the screen. With this database, there is no save button, once you enter the info and exit or go on to the next screen, the information is saved. Use this procedure to enter all the people that you have. After you have gotten, this far maybe someone else will write the instructions for entering people in the Census document. I would recommend that anyone trying to use Clooz, go to the website and down load the manual. You will need to have Adobe Acrobat on your computer. But I believe the website even has a place to download Adobe Acrobat. If not, there are several places on the web where you can down load it. Good luck. Let us know how it is going. Karen -----Original Message----- From: Patricia Tidmarsh <[email protected]> To: [email protected] <[email protected]> Date: Tuesday, August 01, 2000 6:51 PM Subject: [Clooz] Where do I start? > >Trying to add census information from a CD. Do I have to enter the people >first in the people form? > >Can I use the Clooz template to enter unrelated people and neighbors >without giving them ID numbers etc. > >For my own ancestors its okay to have an ID (will use Anhetafel numbers) > >Thanks for any help. And do appreciate baby steps. Passing knowledge of >excel and access but references to "key" are obscure for me in this >context. > >REgards > >Patricia > > > >

Patricia, You're welcome. I figured since I had to go through those steps, someone else will have to, too, so I may as well document and share them. (I also have years of experience writing about technology for non-technology types, so sometimes I can't help myself.) <grin> -- Jillaine At 11:59 PM 07/31/2000 -0400, Patricia Tidmarsh wrote: >Jillaine-- > >Thanks for that very detailed information. I always need baby steps, >since one skipped step can mean hours of confusion. http://freepages.genealogy.rootsweb.com/~jillaine SCHMIDT; Baden, Germany; 1800-1850* BETZ; Feilbingert, Rheinpfalz, Germany; 1600-1850* BOHNENBERGER; Unterreichenbach, Germany; 1600-1900 DRESSEL; Feilbingert, Rheinpfalz, Germany; 1600-1850 ERHARDT; Unterreichenbach, Calw Wuerttemberg, Germany; 1700-1850* FASSNACHT; Altensteig, Wuerttemberg, Germany; 1600-1850* GENGENBACH; Unterreichenbach, Germany; 1600-1900 GLUNZ; Swaebisch Hall, Germany; 1750-1850* JAUCH; Baden, Germany; 1750-1850* LAEPPLE; Altensteig, Wurttemberg, Germany: 1700-1800 SEEGER: Rohrdorf, Donaukreis, Wurttemberg: 1600-1850 WAGNER; Feilbingert, Rheinpfalz, Germany; 1700-1850 * Also: Buffalo, New York, USA; 1847-present __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com

Jillaine-- Thanks for that very detailed information. I always need baby steps, since one skipped step can mean hours of confusion.

BRAVO! I have no doubt your patience and hard work will help many users of FTM and Clooz. I'm imagine Elizabeth (Clooz author) appreciates you're help also. Now I think I'll go try out your instructions and import some relatives. Jenny ----- Original Message ----- From: "Jillaine Smith" <[email protected]> To: <[email protected]> Sent: Monday, July 31, 2000 7:32 PM Subject: [Clooz] FTW, Word, Excel and Clooz 1.2 Okay, I *am* familiar with spreadsheets, databases, FTW, importing, exporting, writing users manuals, etc etc etc, so I'm going to document EXACTLY what I did so that others who are having the same problems I had won't; and if the software author wants to use my explanation in the next version of her manual, please do. The 1.2 manual says on page 29: "To import people from Family Treemaker 4.4 and above: 1. Create a custom report, select the required field names and make sure you use the proper date format." I'm using FTW 7.5. I know how to create a custom report. When I try to select the required field names (RECORD#, SURNAME, GIVEN NAME, BIRTHDATE, MARRIAGEDATE, DEATHDATE), I immediately run into problems: a. FTW's equivalent of Individual Record Number appears to be "Reference Number." When I first generated a custom report with that in the first column, the first column is empty. I.e., my FTW does not appear to be generating a reference number for each person's record. I discovered that I need to do make sure the FTW's preferences are set up to generate Reference numbers. To do this, go to FILE, PREFERENCES, REFERENCE NUMBERS. Click on Individual. I selected NUMBER ONLY. When the report regenerated itself, the numbers are now in the left-hand column, but some are 3-digit and some are 4-digit. I'm worried that this will create problems down the line in my cloozimp.txt. We'll see... b. FTW does not give you the option of listing the SURNAME and the GIVEN NAME separately. I can select LAST NAME and I can select LAST FIRST, showing up together. But I can't put each name in separate columns. I imagine this will wreak great havoc when I export to a file, and I will have to replace the comma between last and first with a tab. Bummer on FTW. NOTE: Another little idiosyncrasy I found is that Clooz doesn't import records that have ONLY a first name or ONLY a last name. Be sure your FTW file has no single-name entries. OR, make sure that there is a comma where the lack of name would be. (Personally I use "Unknown" in replace of the surname or given name when I don't know what it is.) c. Date format. For each of the three dates that Clooz wants (birth, marriage, death), the manual says to be sure to use the proper date format: dd Month yyyy. It's not immediately obvious where to change this in FTW, but I found it in FILE: PREFERENCES: DATES & MEASURES. Be sure you select an option that has NO COMMAS in the date format. This will REALLY mess things up later if you have commas in the date field. It's also important that when you are selecting a date in creating a Custom Report, if given the option be sure to SELECT "Show only preferred date". d. The Clooz manual says to go to EDIT, select COPY REPORT (into the clipboard), then open up Word or your wordprocessing program, and paste the clipboard into a [presumably new] file. I learned the hard way that you can't just use PASTE, you need to use PASTE SPECIAL. For some reason, if you use only PASTE, it doesn't put a tab between Reference# and Name. But if you select PASTE SPECIAL from the EDIT menu, then select UNFORMATTED TEXT, it comes out just fine. e. Before you deal with the "Lastname, Firstname" problem, you need to check all other columns for commas. This is very important. I recommend you SELECT ALL, pull up the RULER, then set tabs so that you can see your columns evenly spaced. Skipping, for now, the "Name" column, go through the other columns and get rid of any other commas that appear. Once you've done that you can do the next step. Then search for any ", Sr." or ", Jr." and replace them with " Sr." or " Jr." (i.e., replace that comma-space before Sr. or Jr. with just a space). f. Now we need to replace the comma between Lastname and Firsname with a Tab. Select REPLACE (CTRL-H) from the EDIT menu. In the "Find What" box, type ", " without the quotation marks. In other words, that's a comma followed by a SPACE. This SPACE after the comma is very important. In the "Replace With" box, type "^t" without the quotation marks. That's shift-6 followed by a lower case T. That code means "tab." So I'm replacing a comma followed by a space with a tab. f. Now, if I've done everything well, and if there are no other commas anywhere within the document, I should have one column for each of: Reference Number, Lastname, Firstname, Birthdate, MarriageDate, DeathDate. Some of the entries within those columns may be empty because I may not have a date for that particular item. One thing I'm worried about that the documentation doesn't address is when I have something like "Abt. 1848" or "Bet. 1847-1850". We'll see what happens to those. g. Now it's time to take all those tabs and turn them back into the commas that Clooz requires. Select REPLACE from the EDIT menu (or CTRL-H). In the "Find what" box, type: ^t In the "Replace with" box, type , This means that you're replacing a tab (^t) with a comma (,) h. Lastly, you need to change the words of the first line in the file. FTW exported them as: Reference number,Name,Birth date,Marriage date,Death date They need to read, without spaces between the commas: PersonID,Surname,Given,BirthYear,MarriageYear,DeathYear Notice that you're adding a new field name or column heading (Given). Also be sure that there are NO LINES above PersonID,Surname,Given,BirthYear,MarriageYear,DeathYear That line must be the very first line of text. Also make sure that no line begins with a comma. Each line MUST begin with a number. I ran into this problem because I did not select the "Show only preferred date" when generating my Custom Report in FTW. The good thing is, I didn't have to regenerate the report in FTW, and go through all those steps above again. I just deleted the lines in Word that started with commas, as this was the line that contained the second, alternate date I had for some FTW records. i. Once all this is done, select SAVE AS from the FILE menu. Go to the directory where Clooz is stored (it might be C:\Program Files\Clooz\). Select TEXT ONLY from the FILE TYPE window. Call the file cloozimp.txt. j. repeat "i" again, but call the file cloozimp2.txt. This is a backup file because as the manual says, once you import cloozimp.txt into Clooz, the cloozimp.txt file is deleted. Always good to have an extra one handy so you don't have to run through steps a-h again in case something goes wrong later! I did all these steps and finally had a successful import into Clooz! http://freepages.genealogy.rootsweb.com/~jillaine SCHMIDT; Baden, Germany; 1800-1850* BETZ; Feilbingert, Rheinpfalz, Germany; 1600-1850* BOHNENBERGER; Unterreichenbach, Germany; 1600-1900 DRESSEL; Feilbingert, Rheinpfalz, Germany; 1600-1850 ERHARDT; Unterreichenbach, Calw Wuerttemberg, Germany; 1700-1850* FASSNACHT; Altensteig, Wuerttemberg, Germany; 1600-1850* GENGENBACH; Unterreichenbach, Germany; 1600-1900 GLUNZ; Swaebisch Hall, Germany; 1750-1850* JAUCH; Baden, Germany; 1750-1850* LAEPPLE; Altensteig, Wurttemberg, Germany: 1700-1800 SEEGER: Rohrdorf, Donaukreis, Wurttemberg: 1600-1850 WAGNER; Feilbingert, Rheinpfalz, Germany; 1700-1850 * Also: Buffalo, New York, USA; 1847-present __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com