[#77] exports has different column order every time

Bug Reports
,
1

Migrated from Redmine #77 | Author: Florian Sauter
Status: Closed | Priority: High, I’m very impatient | Created: 2017-12-15

Hi,

we often export the booking for some reporting.
Unfortunately every time the columns have a different order which makes it very difficult.

Please implement a fixed order for the columns

Thanks
Florian

2

Redmine Admin wrote:

please provide us your request and raw server responce

3

Florian Sauter wrote:

happens when exporting as excel from frontend and for additional attributes for the booking.
If you provide your email I can send over the exports, cant share them public

4

Redmine Admin wrote:

order depends on attributes in bookings. It can be different set of attributes per services and if there are no bookings with some attribute it will be skipped which affects order.

5

Florian Sauter wrote:

we have same fields but different order, see “Car Trim” vs “Evaluation Price”

6

Florian Sauter wrote:

Florian Sauter wrote:

we have same fields but different order, see “Car Trim” vs “Evaluation Price”

7

Redmine Admin wrote:

please attach here this files with removed client details and without sensitive data

8

Florian Sauter wrote:

Im trying but not working… just says !screen.png! not found all the time…

9

Florian Sauter wrote:

please provide an email I can send it to

10

Redmine Admin wrote:

Please put first 2 rows of file in text (csv) format here (do not attach any files)

11

Florian Sauter wrote:

Date Time Event Service provider Code Client name Client email Client phone client_address Is cancelled Comment Record date Created by admin Created by Number of changes Car Brand Car Model Car Year Car Mileage Car Trim Evaluation Price GoogleID Lead Source Source Reasons for Rejection Status Promotion code Discount (%) location

Date Time Event Service provider Code Client name Client email Client phone client_address Is cancelled Comment Record date Created by admin Created by Number of changes Car Brand Car Model Car Year Car Mileage Evaluation Price Car Trim Source GoogleID Lead Source Status Promotion code Discount (%) location

12

Redmine Admin wrote:

Please tell how did you get this exports with different order? – we need way to reproduce it step by step

13

Florian Sauter wrote:

both exports are from the “detailed report” list

14

Redmine Admin wrote:

it seems you exporting it from different accounts. But there are different order of fields in different accounts. E.g. order is not same in cars45 and vendetuauto

15

Florian Sauter wrote:

so whats your logic about sorting those fields?
Please don’t tell me it follows the sorting in the booking form…

16

Redmine Admin wrote:

it sorts is according to order of your intake forms

17

Florian Sauter wrote:

thx… so same topics as in my other issue… frontend & backend have strange dependencies…