"ghost" Field To Be Discovered

[omegagoh]

Dear All,

I just tookover a system design in FM6 which I will need to convert to FM11. However, there is one file that trouble me (please refer to the file attached). There are many Calculation Fields (e.g. calP1, calP2 etc.) refer to the field, "Recovered" which is NOT defined. How can this happen (usually, FM will replace the field deleted as "field missing")?

And, I think it is the main reason that I can't convert it to FM11.

Thanks ahead for whoever solve the puzzle and share with me.

Regards,

Omega Goh

OPADRAW Clone.zip

[Keith LaMarre]

It appears that I am able to convert this to a FileMaker 7 file - but can't open it because I don't have the password.

[Raybaudi]

There are many Calculation Fields ...

Which is the original calculation for the field: visDelivery ?

[omegagoh]

Dear Keith,

The password is "admin". Please send the converted file to me. Thanks.

Regards,

Omega Goh

It appears that I am able to convert this to a FileMaker 7 file - but can't open it because I don't have the password.

[omegagoh]

Dear Daniele,

Thanks for looking into the file. The file wasn't created by me. However, if you view the fields by "creation order", visDelivery is the first field that refer to the ghost field, Recovered. I had no idea what was the original formula in visDelivery. What is most important to me now is to be able to convert it to run on FMP11 (and function as before, of course).

You help is most appreciated. Thanks again.

Regards,

Omega Goh

Which is the original calculation for the field: visDelivery ?

[comment]

The password is "admin".

Doesn't work for me.

[Raybaudi]

I had no idea what was the original formula in visDelivery.

If you can't see the original calculation in FM6, why do you ask to us ?

BTW: there is NO "Recovered" field, there is ONLY a parsing formula conversion error. And you had to know the password ( which isn't "admin" ) and the User

[omegagoh]

Dear Comment,

I created the clone in FMP6 with the password, "admin" and set the file to try default password, "admin".

Now that I managed to convert it to .fp7. It opens using account, "admin" with some unknown password. I had reset the password to "admin"

I am attaching 4 files (OPADRAW Clone.fp5, OPADRAW Clone.fp7, Convertion.log and ghost field in FM6.jpg ) for your investigation. The file, "ghost field in FM6.jpg" is a screen capture of the field definition in FMP6 and FMP8. Consider the field, visDelivery. In FM6, it refer to an mysterious field, Recovered which I can't find it. After converted to FM8, the mysterious field was commented.

FYI, the original file had about 85 layouts which I couldn't convert it. Whereas, the attached clone had only a few layouts (I deleted many layouts to simplified it) as I think the key problem is got to do with the mysterious field, Recovered.

Do update me if you discovered anything new. Thanks.

Regards,

Omega Goh

Doesn't work for me.

Dear Daniele,

Please refer to my reply to Comment, especially the screen capture of field definition for visDelivery.

Regards,

Omega Goh

If you can't see the original calculation in FM6, why do you ask to us ?

BTW: there is NO "Recovered" field, there is ONLY a parsing formula conversion error. And you had to know the password ( which isn't "admin" ) and the User

ghost field in FM6.zip

[comment]

My guess is that the .fp5 file has been recovered at some point and the conversion process was unable to salvage the original calculation formulae. Perhaps others with more experience recovering in pre-7 versions can confirm or refute this.

[omegagoh]

Hey! nobody is able to help?

[bruceR]

Help with what? The file is converted; it's damaged; you don't have the original information, and it appears to be poorly designed anyway. So what is it that you would like to do?

[omegagoh]

Dear Bruce,

The problem is the file function normally in .fp5 but not in .fp7!

This project that I will be taking involved 2 systems in FMP6. The first system have 48 FM6 files and the second has 31 FMP6 files. Trial convention of all files seem good except this one.

While this isolated component is by itself, it is deem important for the user in specifying their request visually. To re-build this file (original version has some 85 layouts) would mean a lot of time and cost as I have little knowledge of the industry that my client is in. It is difficult to justify the cost of re-building this file as compare to migrating the 2 systems. Furthermore, client may be suspicious of my ability, integrity and may result in losing the project.

Hence, it is important for me to be able to make it work in .fp7 with as little time as possible (I am not interest how bad the design was!).

Regards,

Omega Goh

Help with what? The file is converted; it's damaged; you don't have the original information, and it appears to be poorly designed anyway. So what is it that you would like to do?

[Raybaudi]

The problem is the file function normally in .fp5 ...

How can that work with so many calculation fields broken ?

Again, do you have a backup copy of that .fp5 file with the correct calculations ?

[omegagoh]

Dear Daniele,

It was very surprising to me too. I ran DDR in FMPD6 and use Analyzer 3.5 (from Waves in Motion / WorqSmart; much prior version of Inspector Pro 3, now from Beezwax)) to check for error, none of the calculation fields was flag as error. So, it is really very odd. Neither me nor the client has a prior version of the file. It was developed by an Indian FM develop who is no longer contactable. I think, at worst, I will try to explain to my client about the oddity of this file. Thanks anyway.

Regards,

Omega Goh

How can that work with so many calculation fields broken ?

Again, do you have a backup copy of that .fp5 file with the correct calculations ?