Exporting and importing repeating fields

[agross]

I need to export a Filemaker Pro 5.5/6.0 database that contains several repeating fields, perform some text conversion and then reimport back into a Filemaker Pro 7 database. Exporting as an XML file seems to retain the repeating field data, but when I import the XML file back into Filemaker only the first occurrence is imported and the other repetitions ignored.

What am I doing wrong? Maybe there is an alternative solution to deal with repeating fields?

[Vaughan]

Almost all text conversions (except maybe that invloving some formatting) can be done within FMP using calculations -- specifically the Set Field step.

You could create a script that loops through all records, then loops through all repetitions applying the calculation.

[Søren Dyhr]

database that contains several repeating fields

Well since repeating fields hardly ought to contain data but instead should be used for utility purposes such as relational keys - Would I regard this as a marvelous opportunity to get the relations right once and for all!!

--sd

[JamesL]

This problem was discussed before.

It may be interesting to view the following thread

http://fmforums.com/forum/showtopic.php?tid/153786/post/153786/#153786

[agross]

Normally I would stay in FMPro to do text calculations, but because of Filemaker's patchy support for Unicode I am forced to export the data, convert from the "Central European" encoding to "utf-8" and then reimport into Filemaker. Unfortunately in this exporting and importing process I have been unable to find a way to deal with data stored in repeating fields - only the first occurence of the repeating field is transferred across.