Split repeating fields into records during import

[laker_42]

I have a database that has one date field that is a repeating field. It is storing program info for those dates. I import this information into another database and use the option to split repeating fields into separate records. FMP 7 does not appear to be doing this correctly. According to the help file

"When you split repeating field data into separate records any non-repeating fields that you import are duplicated in each separate record. For example, if a record in the source file has values in three repetitions, splitting them into separate records imports three records, each identical except for the values in the repeating fields."

What it is doing for me is it splits out the repetitions into separate fields but it does not copy the non-repeating fields. All the other fields are blank. Has anyone run into this? Is it a bug in FMP 7? Any ideas would be appreciated.

Thanks!

John

[gymbomom]

I haven't but I'm experiencing the EXACT same thing. I was previously using FM in a Mac environment and figured it had something to do with copying the file over from the Mac and converting it.

I'm guessing that it is probably not the case.

Any info would be SOOOOO appreciated!

[laker_42]

I submitted this as a bug to FM but haven't heard anything yet. I may give tech support a call and see what they say in person. If I do, I will report back what I get from them.

John

[Sxeptomaniac]

I'm having this issue, too. I was checking their site, and supposedly it's fixed in 7.0v3, according to their fix list:

"1.8.2. Importing data from repeating fields using the option to split data in separate records works correctly. "

I'm using 7.0v3, and still having the problem, so it doesn't seem to be as fixed as they think.

[Ugo DI LUCA]

Yes,

I'm also waiting for a fix myself, as I'm stuck in the progress of a solution with a long 5 minutes loop rather than a 10 second one.