OK, I did an export of a Parent form with three subforms and have ended up with the following conclusions for coming up with an import file layout structure:
1. Import file for parent and subforms will be fixed NUMBER of fields. 2. Structure is Parent..Subform1 fields or blanks..Subform2 fields or blanks..Subform3 fields or blanks. 3. There will be a separate line for each individual record for all subforms. Count the total subrecords, and that is how many lines should exist.
Sample file layout for one Parent form with 4 subforms (SF1,SF2,SF3,SF4), three data fields(a,b,c) each:
Parent Fields,SF1a,SF1b,SF1c,,,,,,,,,, Parent Fields,,,,SF2a,SF2b,SF2c,,,,,,, Parent Fields,,,,,,,SF3a,SF3b,SF3c,,,, Parent Fields,,,,,,,,,,SF4a,SF4b,SF4c,
------------------------------------------------ Hope this helps someone else to create an import file that includes hierarchical subform records. And if this layout structure is not correct, Mark/Erika/Ray will correct me.
|