import data from repeating fields

[cmedata]

Hi,

I used to import data from repeating fields using FM6. It only imports data when the fields are not empty. Let's say RepeatingField(1) to RepeatingField(3) are not empty and RepeatingField(4) to RepeatingField(20) are empty. I will end up having 3 new records because I choose the "Splitting them into separate records" option. The problem is, in FM9, I end up having 20 records even though 17 of them are blank.

Am I missing something here?

Thank you for your help.

[comment]

This shouldn't be happening, so check your implementation. Also check you're patched up with the latest version update.

[Ugo DI LUCA]

Hi Michael,

Would you think there might related to any update ?

There used to be a bug with 7.v2 if I can remember, but then the splitted didn't occur at all.

I'd also suggest to look at the implementation, checking that these repetitions are really empty would be a start.

[comment]

There was an issue in version 7, where NON-REPEATING fields were empty on every record except the first one. But we are talking about version 9 now?

[Ugo DI LUCA]

Oh yes, right you are. That's exactly why the quickly create multiple records was not possible in between the 2 patches for 7.

[comment]

Actually, the issue still exists in 7.0v3, but there's a workaround: define a repeating calc for every non-repeating field = Extend ( field ), and import only from repeaters.

[cmedata]

Thank you all for your responses. But I checked everything and it is still acting like that. I am using FM9.0v3. More suggestions please!

Thanks

[comment]

Post a sample file that shows the problem?