converting a db from fm5.5 to fm7. Content of container field lost

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

converting a db from fm5.5 to fm7. Content of container field lost

Claude Willemyns
Hi, experts,

I've converted a fm5.5 db to fm7.

DB was about 20mb with 1000 records.
There is 1 container field with a 1k picture in it in .bmp or .gif

After conversion, all the content of the container field is lost.

Hereunder, the conversion log, nothing strange.

********************************************************************************************
19/05/2005 15:59:10, 513_PMS_Codes Converted.fp7, 0, Conversion started.
19/05/2005 15:59:10, 513_PMS_Codes Converted.fp7, 0, Version: Pro 5.0 - 5.5.
19/05/2005 15:59:10, 513_PMS_Codes Converted.fp7, 0, 10 file
references were converted.
19/05/2005 15:59:10, 513_PMS_Codes Converted.fp7, 0, 7 relationships
were converted.
19/05/2005 15:59:10, 513_PMS_Codes Converted.fp7, 0, 15 calculations
were converted.
19/05/2005 15:59:14, 513_PMS_Codes Converted.fp7, 0, 1007 container
objects were converted.
19/05/2005 15:59:14, 513_PMS_Codes Converted.fp7, 0, 13 layout images
were converted.
19/05/2005 15:59:17, 513_PMS_Codes Converted.fp7, 0, 55 fields were converted.
19/05/2005 15:59:17, 513_PMS_Codes Converted.fp7, 0, 1012 records were
converted.
19/05/2005 15:59:17, 513_PMS_Codes Converted.fp7, 0, 7 indexes recreated.
19/05/2005 15:59:17, 513_PMS_Codes Converted.fp7, 0, Duplicate
privilege: <Unknown>.
19/05/2005 15:59:17, 513_PMS_Codes Converted.fp7, 0, Duplicate
privilege: <Unknown>.
19/05/2005 15:59:17, 513_PMS_Codes Converted.fp7, 0, Duplicate
privilege: <Unknown>.
19/05/2005 15:59:18, 513_PMS_Codes Converted.fp7, 0, Duplicate
privilege: <Unknown>.
19/05/2005 15:59:18, 513_PMS_Codes Converted.fp7, 0, Duplicate
privilege: <Unknown>.
19/05/2005 15:59:18, 513_PMS_Codes Converted.fp7, 0, 9 access
privileges were converted.
19/05/2005 15:59:18, 513_PMS_Codes Converted.fp7, 0, 2 value lists
were converted.
19/05/2005 16:00:28, 513_PMS_Codes Converted.fp7, 0, 16 layouts were converted.
19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, Converted
function Status ( CurrentGroups ) to Get ( PrivilegeSetName ) in: Naar
menu.
19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, Converted
function Status ( CurrentGroups ) to Get ( PrivilegeSetName ) in: Naar
menu.
19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, Converted
function Status ( CurrentGroups ) to Get ( PrivilegeSetName ) in: Naar
menu.
19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, Verify Windows
Print Setup settings: Lijst (staande).
19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, 44 scripts were converted.
19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, Deleting unneeded
file reference: Quote 2.
19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, Deleting unneeded
file reference: 500Artikelfiche.
19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, Deleting unneeded
file reference: CW_field_definitions.
19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, Deleting unneeded
file reference: 509_historiek_artikelfiche.
19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, Deleting unneeded
file reference: CW_model_historiek.
19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, Deleting unneeded
file reference: CW_model_historiek 2.
19/05/2005 16:00:39, 513_PMS_Codes Converted.fp7, 0, Conversion completed.
**********************************************************************************************

What can go wrong ?  Are those formats supported for conversion ?

Thanks, and have a nice day.

Claude.

--
To unsubscribe: send an email to <[hidden email]>
FMPexperts is hosted by Ironclad Networks <http://www.ironclad.net.au/>
Reply | Threaded
Open this post in threaded view
|

Is there a minimun size ? (Re: converting a db from fm5.5 to fm7. Content of container field lost )

Claude Willemyns
Good morning everyone.

In FM7, is there a minimum size for a picture in a container field ?
I have problems with one pixel sized .bmp, .gif and .jpeg when the
grafic option reduce/enlarge is activated. In that case , the picture
does not appear or has a gradation.

In first message, I speak over an unsuccesfull convertion of container
fields, but it seems that the content is well converted but is not
readible. When I try to edit the content of the field in FM7, the one
pixel opens in the ms Paint editor. So it is not lost but not visible.

Who knows more about those limitations ?

Thanks.
Claude.

2005/5/19, Claude Willemyns <[hidden email]>:

> Hi, experts,
>
> I've converted a fm5.5 db to fm7.
>
> DB was about 20mb with 1000 records.
> There is 1 container field with a 1k picture in it in .bmp or .gif
>
> After conversion, all the content of the container field is lost.
>
> Hereunder, the conversion log, nothing strange.
>
> ********************************************************************************************
> 19/05/2005 15:59:10, 513_PMS_Codes Converted.fp7, 0, Conversion started.
> 19/05/2005 15:59:10, 513_PMS_Codes Converted.fp7, 0, Version: Pro 5.0 - 5.5.
> 19/05/2005 15:59:10, 513_PMS_Codes Converted.fp7, 0, 10 file
> references were converted.
> 19/05/2005 15:59:10, 513_PMS_Codes Converted.fp7, 0, 7 relationships
> were converted.
> 19/05/2005 15:59:10, 513_PMS_Codes Converted.fp7, 0, 15 calculations
> were converted.
> 19/05/2005 15:59:14, 513_PMS_Codes Converted.fp7, 0, 1007 container
> objects were converted.
> 19/05/2005 15:59:14, 513_PMS_Codes Converted.fp7, 0, 13 layout images
> were converted.
> 19/05/2005 15:59:17, 513_PMS_Codes Converted.fp7, 0, 55 fields were converted.
> 19/05/2005 15:59:17, 513_PMS_Codes Converted.fp7, 0, 1012 records were
> converted.
> 19/05/2005 15:59:17, 513_PMS_Codes Converted.fp7, 0, 7 indexes recreated.
> 19/05/2005 15:59:17, 513_PMS_Codes Converted.fp7, 0, Duplicate
> privilege: <Unknown>.
> 19/05/2005 15:59:17, 513_PMS_Codes Converted.fp7, 0, Duplicate
> privilege: <Unknown>.
> 19/05/2005 15:59:17, 513_PMS_Codes Converted.fp7, 0, Duplicate
> privilege: <Unknown>.
> 19/05/2005 15:59:18, 513_PMS_Codes Converted.fp7, 0, Duplicate
> privilege: <Unknown>.
> 19/05/2005 15:59:18, 513_PMS_Codes Converted.fp7, 0, Duplicate
> privilege: <Unknown>.
> 19/05/2005 15:59:18, 513_PMS_Codes Converted.fp7, 0, 9 access
> privileges were converted.
> 19/05/2005 15:59:18, 513_PMS_Codes Converted.fp7, 0, 2 value lists
> were converted.
> 19/05/2005 16:00:28, 513_PMS_Codes Converted.fp7, 0, 16 layouts were converted.
> 19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, Converted
> function Status ( CurrentGroups ) to Get ( PrivilegeSetName ) in: Naar
> menu.
> 19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, Converted
> function Status ( CurrentGroups ) to Get ( PrivilegeSetName ) in: Naar
> menu.
> 19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, Converted
> function Status ( CurrentGroups ) to Get ( PrivilegeSetName ) in: Naar
> menu.
> 19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, Verify Windows
> Print Setup settings: Lijst (staande).
> 19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, 44 scripts were converted.
> 19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, Deleting unneeded
> file reference: Quote 2.
> 19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, Deleting unneeded
> file reference: 500Artikelfiche.
> 19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, Deleting unneeded
> file reference: CW_field_definitions.
> 19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, Deleting unneeded
> file reference: 509_historiek_artikelfiche.
> 19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, Deleting unneeded
> file reference: CW_model_historiek.
> 19/05/2005 16:00:31, 513_PMS_Codes Converted.fp7, 0, Deleting unneeded
> file reference: CW_model_historiek 2.
> 19/05/2005 16:00:39, 513_PMS_Codes Converted.fp7, 0, Conversion completed.
> **********************************************************************************************
>
> What can go wrong ?  Are those formats supported for conversion ?
>
> Thanks, and have a nice day.
>
> Claude.
>

--
To unsubscribe: send an email to <[hidden email]>
FMPexperts is hosted by Ironclad Networks <http://www.ironclad.net.au/>
ink
Reply | Threaded
Open this post in threaded view
|

Re: converting a db from fm5.5 to fm7. Content of container field lost

ink
In reply to this post by Claude Willemyns
At 4:54 PM +0200 5/19/05, Claude Willemyns wrote:
>I've converted a fm5.5 db to fm7.
>
>DB was about 20mb with 1000 records.
>There is 1 container field with a 1k picture in it in .bmp or .gif
>
>After conversion, all the content of the container field is lost.
>
>Hereunder, the conversion log, nothing strange.

A "1K image" sounds more like a reference to the image, than an image
actually stored within the database. I don't think I have a single
image file of any format, no matter how small, that weighs in at 1KB.

If my suspicion is correct and only a reference to the images was
stored in the container, the images will show in the converted file
only if the path to the images is exactly the same as it was in the
.fp5 file.

Try this: Let's call your container field "imageContainer". Define an
"imagePath" calculation that has a *text* result with the simple
formula:
imageContainer

If a path is what's actually stored for the container, I believe the
path will show up using this method, and you will find out where FMP
is "looking" for the image itself.

Let us know if that helps,

kazar
--
Datatude(R) Ltd. consulting services
<http://www.datatude.net/>

--
To unsubscribe: send an email to <[hidden email]>
FMPexperts is hosted by Ironclad Networks <http://www.ironclad.net.au/>
ink
Reply | Threaded
Open this post in threaded view
|

Re: Is there a minimun size ? (Re: converting a db from fm5.5 to fm7. Content of container field lost )

ink
In reply to this post by Claude Willemyns
At 9:48 AM +0200 5/20/05, Claude Willemyns wrote:

>In FM7, is there a minimum size for a picture in a container field ?
>I have problems with one pixel sized .bmp, .gif and .jpeg when the
>grafic option reduce/enlarge is activated. In that case , the picture
>does not appear or has a gradation.
>
>In first message, I speak over an unsuccesfull convertion of container
>fields, but it seems that the content is well converted but is not
>readible. When I try to edit the content of the field in FM7, the one
>pixel opens in the ms Paint editor. So it is not lost but not visible.
>
>Who knows more about those limitations ?

Woops, and I just answered your previous message (usually it works
best to read posts in chronological order, but this time I'm wishing
I had been reading backwards!).

I have seen the color gradation problem you mention. I've never seen
public acknowledgement of this issue from FMI nor any posted fixes or
workarounds.

Sometimes I find if a Cut an image out of a container and Paste it
back in again, it helps. Sorry I have no better suggestions. It seems
to be a little buggie that is hard to pin down, happens some times on
some records in some files, and then not at other times on other
records in the same file!

Be sure you are updated to 7.0v3, but that is not necessarily a fix
for this particular problem.

kazar
--
Datatude(R) Ltd. consulting services
<http://www.datatude.net/>

--
To unsubscribe: send an email to <[hidden email]>
FMPexperts is hosted by Ironclad Networks <http://www.ironclad.net.au/>