TMG-L Archives

Archiver > TMG > 2004-05 > 1083446867


From: "Prof. G. L. Esterson" <>
Subject: Re: [TMG] "Conflicting Evidence..."
Date: Sat, 01 May 2004 23:27:47 +0200
In-Reply-To: <200404302053.i3UKrhfp031052@lists5.rootsweb.com>


Lee,

Thanks so much for your comments -- very useful. I respond below to some
of your comments separately.

At 02:53 PM 4/30/2004 -0600, you wrote:
>Prof. G. L. Esterson wrote:
>>Dear Myrnice
>>
>>At 06:22 PM 4/29/2004 -0600, you wrote to Ken :
>>
>>>I would try the import again if you have not made changes to your data. Use
>>>the simple wizard first and if you do not like the results, try the advanced
>>>wizard and make only the few changes that will cause your data to be as you
>>>like.
>>>
>>>If you need a roadmap of where your data will end up using the simple wizard
>>>download http://www.whollygenes.com/files/uft2tmg.pdf and all of the UFT
>>>data items will be mapped for you.
>>
>>I have been transferring my Roots 3 databases to TMG and the results seem
>>to be okay so far. However, I still have an uncomfortable feeling that I
>>may have missed something in setting the setup options of choice during
>>the imports.
>>
>>I wonder if there is somewhere a file for ROOTS 3 imports to TMG (I am
>>right now still using v4.0d), similar to the one above for UFT, which
>>would be of help to me during this process. I would much rather find my
>>mistakes at the beginning of this import process rather than later! TIA.
>
>No, there is not such a file. The provision in TMG v4.x and earlier for
>converting a Roots 3 database was one of the first such provision added to
>GenBridge. At the time, a number of beta testers had been former R/3 users
>and had no problems doing a conversion. This does not mean that every bit
>of data in our R/3 databases come into TMG in exactly the place we
>expected. Most of these situations occurred because the data had been
>entered in R'3 in places or in ways that were not necessarily intended by
>CommSoft.

Apparently, I had very little of this type of problem. For one of my data
bases moved to TMG v4.0d, I have found very few cases where the data fields
did not transfer very closely to TMG fields that I would have chosen
myself. It seems that GenBidge does a very good job of judging where to
put things.

>While to a large extent, the purpose of GenBridge is to move data from the
>fields in the files of one program to the corresponding fields of TMG, you
>have to realize that many of the fields in TMG do not have specific
>corresponding fields in other programs. That is, many fields in TMG may
>correspond to single field in another program. Thus the GenBridge
>conversion of your data many be placing some data into one field in TMG
>when your intention in entering the data in R/3 was in using the field for
>another purpose and R/3 allowed that because it didn't have a separate
>field for that purpose.

I did define some of my own fields in ROOTS 3 and even these, GenBridge
seemed to place rather well. My re-working these will apparently be
relatively painless.

>In any case, the data from your R/3 database will be in your TMG data set
>_somewhere_. You just have to find it. If you have trouble finding data
>in TMG that you had in R/3, let us know where it was in R/3 and we can
>suggest where to find it in TMG.

Thanks -- I will take advantage of this offer if needed.

>Having said this, let me also mention that you may want to do another
>import of your R/3 database using different import settings that more
>closely match how you used fields in R/3. In most cases, a change
>of import setting may make the differences.

Doesn't seem to be necessary at this point, for the options that I chose
while organizing the import to TMG.

Incidentally, for future imports of other data bases to TMG from R/3, is
there some way that I can automatically use the same set of these GenBridge
options as I did on the data base mentioned above? Will GenBridge, for
example, automatically assume the same set of options I used before, of
course, giving me the chance to change them? Or will I have to start from
scratch working out the options?

Thanks for your help.

Jerry Esterson, Ra'anana, Israel

This thread: