XML Export Question

[Dufek]

When exporting a field using a check box, if multiple values are selected, the export looks like this:

80 85

Where "80" and "85" are two different values. Does anyone know of a way by style sheet to seperate these values such as:

80

85

Or something similar? The program I am exporting to does not recognize the the data together on one line... Any ideas would be appreciated!

[comment]

Please do not double post:

http://www.fmforums.com/forum/showtopic.php?tid/193462/

[Dufek]

Well I posted this in another section and this section fits it better. I sure don't see any way to move the topic to another section, so that is why I reposted it.

[Lee Smith]

Use the Report Post button [color:blue]see attachment, and explain what you want done with the post. Or flag one of the Moderators (look for the Blue Names with the M in front), and write them a Private Topic. In the meantime, I will delete the other topic.

HTH

Lee

Edited March 3, 2008 by Guest

[comment]

I don't know how to do this with a style sheet, but it would be easy to fix in Filemaker, before exporting. Since repeating fields export exactly the way you show, you could add a repeating calculation field =

GetValue ( Extend ( Checkbox ) ; Get ( CalculationRepetitionNumber ) )

and export it instead of your Checkbox field.

[Dufek]

First, thank you to both for getting me straight on my "manners" for posting things here!... :

comment:

Very interesting. I didn't know a repeating field would export in that fashion.

My only question would be dealing with a variable number of necessary repeated fields. Sometimes 1, sometimes 6... for this field.

Would it be best to set the repetition number to say, 10, for example to ensure enough repeated fields get exported? Or is there a better way? The downside to setting it to 10 is if only 1 field is used/filled, 9 empty fields will go along with it...

[comment]

Yes, you need to define the field with the maximum repetitions expected - I'd say the same as the number of values in your value list.

There will be empty elements in the exported XML. I think they could be removed by a style sheet, if that's a problem. But if it is a problem, then perhaps you should drop this idea altogether and go back to your original question.