LDAP csv export order of attributes

I am running an export off ou ou=testresources with the following

returning attributes:

cn,wtnattrname,wtnattrlastname,wtnattrfirstname,wtnattremail,wtnattrrole,wtnattrportalrole

However, the csv file being generated does not have the columns in the same order. Is there a way to fix this?

Thanks

Are you generating this using sql? if not please try the sql statement and export.

SQL statement is like the following. In order to run the sql statement click on the SQL button on the toolbar, copy paste and modify and run the sql.

select cn,wtnattrname,wtnattrlastname,wtnattrfirstname,wtnattremail,wtnattrrole,wtnattrportalrole from ou=People,dc=test,dc=com

I was not running it using sql, I was using the export. However, I tried the SQL like you suggested and it still exported the fields out of order to the csv file.

We are unable to reproduce the issue in our environment.

We tried with the sql using different order and it maintained the order during the export.

select cn,sn, postalCode, postOfficeBox from ou=People,dc=test,dc=com

returned the results in correct order when run against the test server.