TMG-L Archives

Archiver > TMG > 2004-03 > 1078338975


From: "Jim Byram" <>
Subject: Re: [TMG] FTM Import and Footnotes
Date: Wed, 3 Mar 2004 13:36:19 -0500
References: <B1006464791@hdflem01.fl.hostdepot.net>


Greg,

Like I said yesterday... I take no issue with what you did in FTM. As long
as you're in FTM, the data works as you intended. The problem comes when you
want to transfer the data to another program.

As to expectations as to how that field might be used in FTM...
The screen is named 'Source-Citation'.
The field is named 'Footnote: (Printed format)'.
Help says: 'Footnote - Shows how this source-citation will appear when you
print it. You can change the footnote text by typing over the default
footnote text.'

That gives you some idea of what was intended for the use of this field but
doesn't restrict you as the user making other choices.

The choices as to what to do with this field are:
1) Leave it along. Accept the default footnote. I don't know if the default
footnote text is stored in the database or is generated on the fly (likely
the latter).
2) Make edits of the default text to modify the footnote used in reports.
3) Completely replace the text in the field with source citation text of
your choice.
4) Completely replace the text in the field with text of your choice that
has nothing to do with a source citation.

TMG obviously allows you to output both source citation text and memo text
(from any tag) as footnotes. These two types of outputs come from entirely
different data tables and data structures... one is source data and one is
tag data that has nothing to do with sources.

An import module that imported the footnote data would need to assume that a
database had made use of all four of the above Footnote field uses and to be
able to distinguish between them.

The current import imports source data (including the source, the citation
detail ('Page'), and the citation text). The page and citation text data are
imported to the TMG citation detail field. This has served the needs of the
vast majority of users who have imported FTM data into TMG. They got their
source data imported as it was entered into FTM. I don't recall if the
footnote issue has arisen before or not.

If the footnote text were imported, the import module would need to
distinguish between the four cases above. A user who used the footnote field
as in case 1 or case 2 wouldn't want the data imported because of the
unnecessary duplication of data after import in the TMG citation detail
field.

The next problem is how does the import module distinguish between case 2
and cases 3 & 4. A user would generally not want to import case 2 text but
would want to import case 3 & case 4 text.

The next case is how to distinguish between case 3 text (source text) and
case 4 text (text that has nothing to do with sources). If this were
possible, the case 3 text could go to the citation detail field. Where would
the case 4 text that has nothing to do with sources be imported to?

If (with 20-20 hindsight) these issues were understood when starting to use
FTM, the Source Citation could have been used in such a way that there would
have been no problem importing the data.
1) A dummy source could be created.
2) The text could go into the citation text field.
3) The footnote field could be edited to delete the dummy source.

This would let you have free (source or non-source) text printed in
footnotes. I understand your explanation for why you chose the Footnote
field rather than Citation text but it did have downstream consequences when
it came time to move your data out of FTM. I'm not pointing any fingers.
This happens to all of us even within TMG. You spend years entering data one
way and discover that you want it done another way. You then have to go
through your database and clean things up... sometimes a large undertaking.

Jim


This thread: