Resolved Import into Subform - Multiple Subforms

Can you include the patch in this ticket? Or resend the email to: lg639@sas.rutgers.edu?

I don' t have the patch.

Thanks,
Laura

Hi Laura,

I thought in your most recent release you added that capability...

We are doing improvements to this feature so did not include it with RO CSVI 9.10.0 release. You need to install the patch file I sent in email in case you have updated to this version.

Attached is a sample where I entered the data manually, so you can see how it works.
I also attached the field listing which has the field id numbers so you can see it in the csv file.

Thank you for the screenshot. It helped to understand on the fields and based on that I have created a sample CSV with the data given. Please run import with this format and check.

title,catid,workshop-schedule

sample article,2,sub-program-date#2026-05-01|sub-program-sessions#{sub-sessions-start-time#10:00|sub-sessions-end-time#11:00|sub-sessions-title#Session 1|sub-sessions-speaker#mary|sub-sessions-details#alkj aslkj falwi ueflakjsdf laeis flasidjf~sub-sessions-start-time#11:00|sub-sessions-end-time#12:00|sub-sessions-title#Session 2|sub-sessions-speaker#Joe|sub-sessions-details#lakj alsj dflajs dflkjasdf laksjdf ladkjsf~sub-sessions-start-time#12:00|sub-sessions-end-time#13:00|sub-sessions-title#Session 3|sub-sessions-speaker#John|sub-sessions-details#alkj asdlfkj alsei ulaisjf laisje flj~sub-sessions-start-time#9:00|sub-sessions-end-time#10:00|sub-sessions-title#Session 1 day 2|sub-sessions-speaker#Cindy|sub-sessions-details#lakj laj sdlfkj alwsei flasidjf lasjdf}

sample article2,2,sub-program-date#2026-05-02|sub-program-sessions#{sub-sessions-start-time#10:00|sub-sessions-end-time#11:00|sub-sessions-title#Session 2 day 2|sub-sessions-speaker#Tom|abstract#lkj lajs dflkjas dfalskdjf alsdkjf}

Let me know on how it goes.

Attached is a sample where I entered the data manually, so you can see how it works.
I also attached the field listing which has the field id numbers so you can see it in the csv file.
thanks,
Laura

So we have 2 subforms nested within each other. I thought in your most recent release you added that capability...

Workshop Schedule includes
- workshop Day
- sessions subform

Sessions subform includes
- start time
- end time
- title
- speaker
- abstract

Hello Laura,
I am a little confused on how you have the subform setup. Date Field is the higher level subform field with start time, end time, title, speaker, abstract fields added to it. Is that right? Can you post screenshot on how these fields are setup?

Great, but where is the actual DATE in this example? 2026-05-01 and 2026-05-02?

That is the 'higher level form'...

Thanks,
Laura

HI Laura,

Subform 1: Date Field
---> subform 2: start time, end time, title, speaker, abstract

Considering all the subform 2 fields are added under subform 1 Date field you can use the below sample format to import subform data. Try and let me know on how that goes.

title,catid,Date field

sample article,2,start time#10:00|end time#11:00|title#Session 1|speaker#mary|abstract#alkj aslkj falwi ueflakjsdf laeis flasidjf~start time#11:00|end time#12:00|title#Session 2|speaker#Joe|abstract#lakj alsj dflajs dflkjasdf laksjdf ladkjsf~start time#12:00|end time#13:00|title#Session 3|speaker#John|abstract#alkj asdlfkj alsei ulaisjf laisje flj~start time#9:00|end time#10:00|title#Session 1 day 2|speaker#Cindy|abstract#lakj laj sdlfkj alwsei flasidjf lasjdf~start time#10:00|end time#11:00|title#Session 2 day 2|speaker#Tom|abstract#lkj lajs dflkjas dfalskdjf alsdkjf

Can you provide how i need to format my content so I can import data into multiple subforms?

Subform 1: Date Field
---> subform 2: start time, end time, title, speaker, abstract

For example:
2026-05-01, 10:00, 11:00, Session 1, mary, alkj aslkj falwi ueflakjsdf laeis flasidjf
2026-05-01, 11:00, 12:00, Session 2, Joe, lakj alsj dflajs dflkjasdf laksjdf ladkjsf
2026-05-01, 12:00, 13:00, Session 3, John, alkj asdlfkj alsei ulaisjf laisje flj
2026-05-01, 09:00, 10:00, Session 1 day 2, Cindy, lakj laj sdlfkj alwsei flasidjf lasjdf
2026-05-02, 10:00, 11:00, Session 2 day 2, Tom, lkj lajs dflkjas dfalskdjf alsdkjf

Thanks,
Laura

Hi Laura,
Multilevel subform import is something we don't have it yet in RO CSVI import. This feature is in our issue list and will let you know when patch is ready for testing.