Resolved Import into Subform - Multiple Subforms

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.

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,

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

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

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?

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

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

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.

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 have forwarded email to lg639@sas.rutgers.edu with patch file. Please check.

I was able to run the import, no errors, however the data is all blank on the site...

Here is the page on the site.
https://casite-1527915.cloudaccess.net/dimacsevents/event-details/workshop/dimacs-workshop-on-distributed-optimization--infor

Let me know what else you need.

I have attached the log, import file and a screen shot.

I was just 'updating' the records, so the import file is small, it did find the 'rows' since the record was updated, it is just blank data.

fyi the fields are -session- (not sessions), initially I had the wrong fields, and rocsvi said there was an error, I then fixed the field names, so I got closer.

Thanks,
Laura

the field names are:
sub-program-sessions
then the other fields are all sub-session-

I don't think the field names were a problem, because if it was I would have gotten an error.

Here is a dump of the rows that were imported, you can see the empty values... here.

Thanks,
Laura

Hi Laura,
Yes, I can confirm that the patch file does not import nested subform values as explained. After the patch was created the nested subform import feature has undergone significant changes, including the way these values are imported. The new import format is much more readable and no longer relies on separators. We are currently in the process of finishing these changes. Once the feature is complete, we will provide you with an updated patch file that supports the new import format.

Thank you. What is the anticipated date of this update?

Hi Laura,

We hope early next week to have it fully ready.

Have a good weekend.

Hi Laura,
Patch file for importing nested subforms in new format is ready and is attached here.

You can
1. Load the attached patch file
2. Update available fields in RO CSVI
3. Run import in the below CSV format. Fields in the new format follow name as parentsubform_childsubform_fieldname. Multiple values are separated by |.

Try import with below sample CSV format and let me know on how that goes.

alias,category_path,workshop-schedule_sub-program-date,workshop-schedule_sub-program-sessions_sub-session-start-time,workshop-schedule_sub-program-sessions_sub-session-end-time,workshop-schedule_sub-program-sessions_sub-session-title,workshop-schedule_sub-program-sessions_sub-session-speaker,workshop-schedule_sub-program-sessions_sub-session-details

dimacs-workshop-on-distributed-optimization-infor,events/workshop,2017-08-21,09:00:00|09:00:00|09:00:00,11:00:00|12:00:00|13:00:00,"Session W2, Chair: A. Sarwate|Session W1, Chair: W. Bajwa|Session T2, Chair U. Khan",A. Sarwate|W. Bajwa|U. Khan,Session1|Session2|Session3

Im getting very, very close. But it looks like the import is not 'matching' up the times properly...

I am ordering my subqueries by the start time, but I can tell with the 'break' entry it is not being included properly...

Can you see the error in the import file?

I had to create 10 different views in order to grab this information from the source database and 'flatten it' as needed.

I'm also including a dump of the actual records, maybe you will see what I'm missing.

SELECT bblockId, bblockParentBblockId, bblockStartDate, BblockStopDate,bblockTitle, bBlockdescription FROM `bblock` WHERE `bblockParentBblockId` = 221 order by bblockStartDate


Thanks,
Laura

Hi Laura,
I had a look at your import file and see there is data mismatch. As per your file "Welcome | How to Query Encrypted Data with Security against Persistent and Snapshot Adversaries | Secure Multiparty Computation at Google | Secure Multiparty Computation for Scientific Research | Block chains: Tutorial and Lessons from Implementation | Lunch" the sixth value is Lunch for workshop-schedule_sub-program-sessions_sub-session-title field and for workshop-schedule_sub-program-sessions_sub-session-speaker field sixth value is Elaine Shi - Cornell University in " | Seny Kamara - Brown University | Ben Kreuter - Google | Brett Hemenway - University of Pennsylvania | | Elaine Shi - Cornell University" . The count starts before | as there is empty value at the start for workshop-schedule_sub-program-sessions_sub-session-speaker field. That is the reason Elaine Shi - Cornell University value is assigned to Lunch. Please correct this and try the import.

I was able to get it to work!

However it seems that when some special characters are in my abstracts the system is importing them incorrectly.

I'm attaching a sample of just 2 entries that are gettign 'messed up', and I think it is because within the abstract there is a ^2)

The output you can see here:
https://casite-1527915.cloudaccess.net/dimacsevents/workshop-details/dimacs-workshop-on-algebraic-techniques-in-fine-gr
click on schedule, scroll to July 21, and you'll see that the talk abstract is put under the coffee & breakfast.

Here is the live site that I'm pulling from:
http://dimacs.rutgers.edu/events/details?eID=3355

See the title: Entrywise Approximate Linear System under July 20, that is where the absract should be.

When I send the data for just 2 entries to copilot it is finding that there are the right amount of content | | for each row.

Do I need to add some " around the content for each | ?

I re-ran the import for just these 2 events so we can narrow down a bit more.

Thanks,
Laura