Ordering of columns lost when exporting data

[Mark]

Hi Ben,

I have found the problem!! Allow me to explain with an example;

For one of my Form views (via the 'Views' tab > 'Fields' mini-tab) I have 5 visible fields displayed over two groups:


======= GROUP 1 =======

ORDER / FIELD NAME
------------------------
1 / Day
2 / Status
3 / Open Time
4 / Close Time

======= GROUP 2 =======

ORDER / FIELD NAME
------------------------
1 / Special Notes


When I export this to a printer friendly view via the Export Manager, they are displayed in the following order:

1. Day - [from group 1]
2. Special Notes - [from group 2]
3. Status - [from group 1]
4. Open Time - [from group 1]
5. Close Time - [from group 1]

This is because the Day field from GROUP 1 and the Special Notes field from GROUP 2 both have an order/sort ID of '1', and therefore they are paired together. The remaining fields from GROUP 1 are displayed after this.

Would it therefore be possible to modify the coding to take the Group order into consideration? Perhaps by prefixing it with hidden letters? e.g. For my example they would appear:


======= GROUP 1 =======

ORDER / FIELD NAME
------------------------
A1 / Day
A2 / Status
A3 / Open Time
A4 / Close Time

======= GROUP 2 =======

ORDER / FIELD NAME
------------------------
B1 / Special Notes


B1 would surely proceed A4 in this example? I'm sure there is technically a better way to resolve this but I lack advanced PHP skills!

Hope my explanation makes sense.

- Mark