[mapguide-users] SDF/Join Property Types Conversion

[Kenneth, GEOGRAF A/S]

I have not seen any way of specifying anything in the load procedures.

An annoying way to work around the type problem, would be to create a 
view that casts the doubles to strings.

There exists an SDF toolkit which can read the old SDF. I do not know of 
any automated conversions.
Since the previous SDF version is a proprietary format, the number of 
tools might be limited.
You can use Studio in an automated way, and that might tweak to what you 
want.

I assume that you SDF data originally comes from somewhere else.
It might prove easier to load data from the original source into SDF+.
A tool such as Fdo2Fdo might help you out there.

Regards, Kenneth, GEOGRAF A/S



Bob Cassarly skrev:
> I am using MG Studio Load Procedures to convert my old SDFs to SDF 3.
> When this conversion takes place the “Key” data type property is set to
> “string”, unfortunately the Oracle table field I am joining this to is a
> number (a double in MGOS).
>
> It appears that MGOS is much more finicky about the property type than
> MapGuide 6.5 is (the join works fine in MG 6.5).
>
> So I am wondering .. Are there any options that I might be missing to set
> the “Key” column Property Type when the file is converted or do I need to
> modify this programmatically (if that is even possible).
>
> I have successfully joined the SDF to a view which casts this number column
> as a string but I would definitely like to avoid doing this if at all
> possible.
>
> Also .. 
> 1. Before I dig any further is it possible to convert a old SDF to an SDF3
> without using a load procedure? 
> 2. I am using unmanaged SDF so I was wondering if is it possible to set the
> destination to a directory instead of the repository (it kind a stinks that
> you have to convert a file then download it to use the unmanaged SDF.  FYI:
> I definitely do not want to use Managed SDFs)
>
> Thanks,
> Bob
>