Issue regarding Excel export
Permalink Browser Info Environment
Just purchased and installed this add-on yesterday. It's a nice update from the built-in forms block.
I have a form set up with multiple questions containing checkbox groups with 8 options. Site visitor should be able to select multiple checks within each question.
After submitting the form, the submitted data displays correctly in the dashboard and in the email.
The Excel export function isn't exporting the data in the proper location.
The generated table doesn't include the checkmark symbol (✔) at all. Instead, it contains only the VALUE of the first checked item in the list -- pushed to the last column of that question.
I actually would prefer the VALUE of the checked items to appear (like the dashboard view and the email view).
Any suggestions on how to get the results I want?
I have a form set up with multiple questions containing checkbox groups with 8 options. Site visitor should be able to select multiple checks within each question.
After submitting the form, the submitted data displays correctly in the dashboard and in the email.
The Excel export function isn't exporting the data in the proper location.
The generated table doesn't include the checkmark symbol (✔) at all. Instead, it contains only the VALUE of the first checked item in the list -- pushed to the last column of that question.
I actually would prefer the VALUE of the checked items to appear (like the dashboard view and the email view).
Any suggestions on how to get the results I want?
Type: | Discussion |
---|---|
Status: | New |
Thanks for the full explanation!
I'm thinking the issue is in the 'for' that starts around line 106... perhaps when the 'explode' function is creating the array, empty fields are messing things up?
I'm not that experienced in troubleshooting php code. Do you know of a programming environment that allows one to step thru code and view variables as values are assigned? I think it would help me troubleshoot this.
Sherm
I'm not that experienced in troubleshooting php code. Do you know of a programming environment that allows one to step thru code and view variables as values are assigned? I think it would help me troubleshoot this.
Sherm
*EDIT
This modification seems to have fixed the problem:
Line 127:
--
I'm seeing a very similar issue in the excel export with the checkbox field.
The checkbox field adds one column for each option. Instead of displaying a check mark, the last column in the list will instead display the numeric value of the last value checked.
For example: Checkbox with options of 1,2,3,4,5. If i were to check 1,2, and 3, the report would show a check for 1,2,3 and the number "3" in the 5 column. If i check 1,2,3,4,5, columns 1,2,3,4 would show a check, and column five would have a "5" in the column.
This modification seems to have fixed the problem:
Line 127:
--
I'm seeing a very similar issue in the excel export with the checkbox field.
The checkbox field adds one column for each option. Instead of displaying a check mark, the last column in the list will instead display the numeric value of the last value checked.
For example: Checkbox with options of 1,2,3,4,5. If i were to check 1,2, and 3, the report would show a check for 1,2,3 and the number "3" in the 5 column. If i check 1,2,3,4,5, columns 1,2,3,4 would show a check, and column five would have a "5" in the column.
Hi,
Could it be a problem of your Excel version? I use 2007 and have no problems with the exportation of the submissions.
Could it be a problem of your Excel version? I use 2007 and have no problems with the exportation of the submissions.
In the exported Excel, each checkbox answer has its own column, eight total for each question. The question is repeated in the export as its own column, spanning all 8 columns containing the answers. The only answer appearing in each question is the first checked answer, but it's appearing in the 8th column of answers, even if there's more than one question. Like this:
Hope this helps clarify what's happening. I've been looking at the 'excel' function that starts at line 19 in dashboard/reports/extended_form.php. Looks like the problem lies in the 'checkbox row' section starting at line 75, but I can't see what's wrong.
Looks like it's parsing the data collected in the form using 'explode()' function to separate data with '%%'. I'm thinking it's adding extra <td> cells because of a mistake in the function.
Any help would be greatly appreciated.