[Logo] LDAPSoft LDAP And Active Directory Tools Community Forums
  [Search] Search   [Register] Register /  [Login] Login 
 
LDAP csv export order of attributes  XML
Forum Index » General Discussion
Author Message
jimt32



Joined: 27/07/2013 13:29:31
Messages: 4
Offline

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
support



Joined: 27/06/2008 19:01:18
Messages: 123
Offline

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
jimt32



Joined: 27/07/2013 13:29:31
Messages: 4
Offline

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.
support



Joined: 27/06/2008 19:01:18
Messages: 123
Offline

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.

 
Forum Index » General Discussion
Go to:   
[Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
Powered by JForum 2.1.9 © JForum Team