XML-port and language

Trixz
Trixz Member Posts: 21
When I do a xml-port and run an export the boolean field and option fields get the value yes/no or the text (caption) that the optionfield has.

But if I change the language to swedish, I get the swedish Ja/Nej and the caption in swedish. This is exelent when you want to read it, but nog good when you want to process the xml by code later.

Example would be when the swedish office wants to send a xml file to the german office, then you would have to handle the diffrent language.

Comments

  • ta5
    ta5 Member Posts: 1,164
    I guess you have to write some code to convert a boolean "false" to "No" and a true to Yes.
    Thomas
  • kriki
    kriki Member, Moderator Posts: 9,121
    ta5 wrote:
    I guess you have to write some code to convert a boolean "false" to "No" and a true to Yes.
    Thomas
    Or better :
    -a true/yes/ja to -1
    -a false/no/nej to 0
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • kine
    kine Member Posts: 12,562
    You need to set the format of the field to standard format 9. Why? See the on-line help for FORMAT function.
    Boolean Format Example
    <Text> 0 Yes/No
    <Text> 1 Yes/No
    <Number> 2 1/0
    XML format 9 true/false
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.