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?

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.

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

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

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.