Import from repeating fields to individual records in portal

[AlanP]

Got a real pickle here...

They were using FM5 before I came in and had test information (scores, dates, etc.) in repeating fields (score, date issued, date rcvd, etc. each was an individual repeating field).

We've since went to FM7 and I made this type of record keeping to a related portal (where each test is an individual record).

I'm having a hard time importing them. I tried splitting the records but that doesn't work and also tried creating fields in the main FM7 layout but that only imports the first repeating row.

Please any help would be appreciated!!!!

[mr_vodka]

Personally, whenever I have migrated a pre-fm7 solution with repeating fields over to FM7+, I would import the data with the option of 'splitting it into seperate records' into a dummy table. Then I would run a routine that would put the data into the tables that I wanted.

My 2 cents.

[comment]

See if this helps.

[AlanP]

cool thanks guys!