County Coordinator's Helper

Preparing your queries for import into CCHelper

NOTE: This software and associated documentation are
Copyright © 1997-1998 Patricia A. Lindsay.
Except for the CCHelper Manual written by Carol A. Haagensen

Prepping your query files

You may want to go through the following process with one file and then import it (see "Getting Started") to see how your format will work before prepping all of your files.

Copy your query page file(s). Using a word processor or text editor, edit the copied file(s).
The desired format (called "freeform" in CCHelper) is detailed on the Freeform Format Requirements page. Review this page.
Review the following examples showing how to use find/replace commands to convert your text.
Make the changes to your copied file(s) and note the file name(s).
If you are having trouble understanding or producing the desired the format, you may want to start by just adding the ---- between each query and then try the import. You can use CCHelper to insert the tags a query at a time by using the mouse.

The following examples assume that you know how to use Find/Replace commands in a word or text processor to do mass changes on a text document. For Find/Replace to work, you need to have something unique that you can "find" and "replace" to the desired tag to fit the above requirements. If your query page format does not provide those unique values, you will have to add the tags manually.

Example #1

Query text before prep:
<IMG SRC="http://www.accnorwalk.com/~jkelble/queries/line2.gif" WIDTH=640 HEIGHT=27>
<DT>BIXBY, VANKLEECK, McFARLIN
<DD><IMG SRC="http://queries/rd_dot.gif" WIDTH=14 HEIGHT=14>
Researching George W. BIXBY ...<A HREF="MAILTO:GQPS83A@prodigy.com">SANDRA K
ADAMS</A> Mar 1 97

Find/Replace values:

FIND REPLACE Comments
<IMG ----- In this case part of the image is used to create the hyphen line.
 SURNAMES:
 OMIT: The OMIT: tag is used so that the image does not become part of the surnames.
HEIGHT=14> QRYTEXT:
 ... (null) Remove ... so that it does not become part of query text. OMIT: could be used here also.
</A> </A> DATE: Note that the </A> must remain so that the mailto: will be intact.

FIND	REPLACE	Comments
<P><IMG	-----	In this case part of the image is used to create the hyphen line.
<strong>	SURNAMES:
</strong>	OMIT:	The OMIT: tag is used so that the image does not become part of the surnames.
HEIGHT=14>	QRYTEXT:
<br>...	(null)	Remove <br>... so that it does not become part of query text. OMIT: could be used here also.
</A>	</A> DATE:	Note that the </A> must remain so that the mailto: will be intact.

Note that the EMAIL: and NAME: tags are not required because the name and e-mail address will be loaded from the 'mailto' tag.

After find/replace commands, ready for import:
----- SRC="http://www.accnorwalk.com/~jkelble/queries/line2.gif" WIDTH=640 HEIGHT=27>
<DT>SURNAMES: BIXBY, VANKLEECK, McFARLIN OMIT:
<DD><IMG SRC="http://queries/rd_dot.gif" WIDTH=14 QRYTEXT:
Researching George W. BIXBY <A HREF="MAILTO:GQPS83A@prodigy.com">SANDRA K
ADAMS </A> DATE:Mar 1 97

Example #2

Query text before prep:
<IMG SRC="http://www.webcom.com/schori/mystar.gif">Looking for info on SHREFFLER, Fred married Susan DEHOFF Stark Co 22 Oct 1868. At least one child Charles F. SHREFFLER. 5/30/96 (email) Nshref@aol.com</IMG>

Find/Replace values:

FIND REPLACE Comments
<IMG ----- Again part of the image is used to create the hyphen line.
'.gif"> QRYTEXT:
(email) EMAIL: This query page does not include the name, so only e-mail will be loaded.
5/ DATE: 5/ In this case, there is nothing unique before the date to identify it. This find/replace command would have to be altered for each month, or the DATE: could be keyed for each query.
</IMG> (null) Change </IMG> to nothing.

FIND	REPLACE	Comments
<P><IMG	-----	Again part of the image is used to create the hyphen line.
'.gif">	QRYTEXT:
(email)	EMAIL:	This query page does not include the name, so only e-mail will be loaded.
5/	DATE: 5/	In this case, there is nothing unique before the date to identify it. This find/replace command would have to be altered for each month, or the DATE: could be keyed for each query.
</P></IMG>	(null)	Change </P></IMG> to nothing.

Note that the EMAIL: and NAME: tags are not required because the name and e-mail address will be loaded from the 'mailto' tag.

After find/replace commands, ready for import:
----- SRC="http://www.webcom.com/schori/mystar QRYTEXT:Looking for info on SHREFFLER, Fred married Susan DEHOFF Stark Co 22 Oct 1868. At least one child Charles F. SHREFFLER. DATE: 5/30/96 EMAIL: Nshref@aol.com

Example #3

Query text before prep:
<a name="allread"></a>
ALLREAD 11-2-96 
Searching for all ALLREAD descendants of Darke County. Dates of birth,
death, and marriage appreciated. *Jean Allread<a
href="mailto:allread@pinehurst.net"> allread@pinehurst.net</a>

Find/Replace values:

FIND REPLACE Comments
<a name= ----- Uses the name anchor to create the hyphen line.
 SURNAMES: The bold tag in front of the surnames is used.
 DATE: The end bold tag after the surname works nicely to identify the date.
* NAME: The e-mail address will be extracted from the "mailto", but in this case the name is not avaliable in the "mailto", so the NAME: tag is used.
 (null) Change to nothing.
 QRYTEXT: Change the remaining

After find/replace commands, ready for import:
-----"allread"></a>
SURNAMES:ALLREAD DATE: 11-2-96 QRYTEXT:
Searching for all ALLREAD descendants of Darke County.
Dates of birth, death, and marriage appreciated. NAME: Jean Allread <a
href="mailto:allread@pinehurst.net"> allread@pinehurst.net</a>

FIND	REPLACE	Comments
<a name=	-----	Uses the name anchor to create the hyphen line.
<b>	SURNAMES:	The bold tag in front of the surnames is used.
</b>	DATE:	The end bold tag after the surname works nicely to identify the date.
*	NAME:	The e-mail address will be extracted from the "mailto", but in this case the name is not avaliable in the "mailto", so the NAME: tag is used.
<br><br>	(null)	Change <br><br> to nothing.
<br>	QRYTEXT:	Change the remaining <br>

Home      Table of Contents
Install Win 3.1      Install Win 95      Reference Manual      Getting Started
Upgrade       Support       FAQs      Surname Helper