best way to import numbers ( currency )

[Joost Miltenburg]

LS,

I am currency data from an xml file into a FileMaker file. I have never had any problems with this until now.

The general question is : how do I import number data into a FM database ? Specifically, how do I process the decimal data ? ( say 123.45 ? )

How does FileMaker store this internally ? I ask this because in when using system formatting[on] in Dutch regions one would use a comma as the decimal separator.

So, can I always supply a point (.) as the decimal separator or should I follow the system setting for the Machine ?

Usually I do something like this : <xsl:value-of select="translate((($amount * 100000000) div 100000000) , '.' , ',')"/>

Is this the way to go ?

Thanks in advance...

[comment]

Imported data needs to be in the same format used for data entry. If your file requires a comma as the decimal separator, then your stylesheet must do the appropriate transformation.

Unfortunately, there's no easy way for a stylesheet to determine what format is in use by the target file.

[beverly]

Right. localization can't be done with the xml import. push into a text field and parse (with FMP functions) from there.

[comment]

Right. localization can't be done with the xml import.

Well, it can - just not easily (you'd need to export something first). It's too bad FMI didn't give us the option to send a parameter to the stylesheet when calling the import/export.