Note: I've also posted the issue here:
https://drupal.stackexchange.com/questions/321395/uploading-webform-subm...
I'm on Drupal 10.4.1 and Webform 6.2.9 (all current versions.) I'm updating a dev site (of a live site) and would like to "sync" the webform submissions as closely as is practicable to the live site before making the dev site live.
I've watched the video (https://www.youtube.com/watch?v=AYGr4O-jZBo) and it seems very straightforward. I cull the export submissions that are already on the dev site, but when I import, I get the below, which is super-puzzling.
This is from Drupal 10 site to Drupal 10 site, so nothing exotic is happening here. I've tried both text-delimited and .csv export (converting to .csv before trying the import, of course) and it's the same result. I've checked the mapping (which you can only do with the text-delimited export) and it all seems fine.
The Math question is particularly odd. Any idea as to what's happening here? Thanks in advance.
Comment from Drupal Answers:
Hello! If you could share the form definition and some sample data, we'd be better equipped to help you with your question. –
mona lisa
Commented2 days ago
Thanks for the response! (I don't know why I didn't get an email notification of your response. I'm accustomed to reporting on Drupal.org; I suppose that here I need to check manually.) I don't know what you mean by form definition; I'm just exporting as described and converting in Mac Numbers if necessary. (The webform .csv export doesn't include UUID, for example.) I'd post the file here, but it contains submission name and email submission data. I'm happy to send it by email. Thank you!
---Submission import error----
Row #101: 25 values expected and only 8 found. Row #102: 25 values expected and only 1 found. Row #103: 25 values expected and only 5 found. Row #104: 25 values expected and only 1 found. Row #105: 25 values expected and only 3 found. Row #106: 25 values expected and only 1 found. Row #107: 25 values expected and only 2 found. Row #108: 25 values expected and only 1 found. Row #109: 25 values expected and only 2 found. Row #1: Math question field is required. Row #2: Math question field is required. Row #3: Math question field is required. Row #4: Math question field is required. Row #5: Math question field is required. Row #6: Math question field is required. Row #7: Math question field is required. Row #8: Math question field is required. Row #9: Math question field is required. Row #10: Math question field is required. Row #11: Math question field is required. Row #12: Math question field is required. Row #13: Math question field is required. Row #14: Math question field is required. Row #15: Math question field is required. Row #16: Math question field is required. Row #17: Math question field is required. Row #18: Math question field is required. Row #19: Math question field is required. Row #20: Math question field is required. Row #21: Math question field is required. Row #22: Math question field is required. Row #23: Math question field is required. Row #24: Math question field is required. Row #25: Math question field is required. Row #26: Math question field is required. Row #27: Math question field is required. Row #28: Math question field is required. Row #29: Math question field is required. Row #30: Math question field is required. Row #31: Math question field is required. Row #32: Math question field is required. Row #33: Math question field is required. Row #34: Math question field is required. Row #35: Math question field is required. Row #36: Math question field is required. Row #37: Math question field is required. Row #38: Math question field is required. Row #39: Math question field is required. Row #40: Math question field is required. Row #41: Math question field is required.