how to change column order generated...

User 506998 Photo


Registered User
164 posts

http://balletchildren.com/sched_reg/reg_form.php
About a third up from the bottom - the class fees and codes display wrong in the csv (excerpt)
- "fee_class_a,fee_class_b,class_code_a,class_code_b,fee_class_c,class_code_c," -
....which of course makes the columns out of order in the spreadsheet.
Any ideas of what's causing this or how to change it...?
Thanks
User 506998 Photo


Registered User
164 posts

Just to be clearer... So the order of columns generated by the csv are not corresponding to the order I have the form fields set up in Form Builder.
This is what it should be according to the visible layout of my form:
"class_code_a,fee_class_a,class_code_b,fee_class_b,class_code_c,fee_class_c,"
And this is what is generated:
"fee_class_a,fee_class_b,class_code_a,class_code_b,fee_class_c,class_code_c,"
User 187934 Photo


Senior Advisor
20,193 posts

By any chance are they in the order you added them to the form?
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 506998 Photo


Registered User
164 posts

I couldn't answer that - I know I duplicated fields and just edited parameters to create the addtional codes & fees. I added the Class Session (Spring, Summer, Fall) top field much later in the form's development and it appears first in the csv. Everything else is seems to be correct except those elements.
User 506998 Photo


Registered User
164 posts

Interestingly... in HTML (Dreamweaver) the form html lines up correctly. I do have this text box and radio field in that area that are conditional on the Class Session button at the top of the form. But like I say, the html shows everything in perfect order.
User 187934 Photo


Senior Advisor
20,193 posts

Have you given any thought to using the save to database option and then use php to create your own csv file?
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 506998 Photo


Registered User
164 posts

Yes I did. I've got other clients setup with mysql, but I was trying to keep this simple. I will probably link this form to a mysql database at least as a backup in case the csv gets corrupted - right now I've password protected that csv folder and provided a link for the accountant. The accountant for this biz is not a real CPA, but someone who is learning the basics and being taught QuickBooks, where selected columns of my form output will be imported (after conversion by another product). It's a bit convoluted, but QuickBooks seems to prefer direct linking to it's own family of ecommerce solutions. Anyhow... it will work fine if I can just reorder those 6 fields. Maybe you can answer this: can you tell me the identifier that is doing the ordering, so that if recreate those fields trying to force a correct ordering, I can just look at the html and see that the order is correct, without having to run the form online...? Thanks.
User 187934 Photo


Senior Advisor
20,193 posts

I would open a support topic and ask the Gurus. There's nothing in the csv generation scripts that the form builder uses that I saw that would control their order.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 506998 Photo


Registered User
164 posts

Thanks Eric. I'll do that if a rebuild of just those 6 elements in the order that I want doesn't solve the problem. I'll note all my current settings so I can make one element at a time with all it's code before I move to the next one.
User 187934 Photo


Senior Advisor
20,193 posts

I was looking at your source code to see if it could be the type of inputs you used. You appear to be using the same types in the same order.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.