Export fields order and visibility
Last Post 01-18-2012 04:56 AM by sentient. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
sentientUser is Offline
river guide
river guide
Posts:127
Avatar

--
01-14-2012 06:15 PM
    Can we change the order of the export fields? We want to export certain fields before others but it doesnt seem to take the order of the Profile Properties. We want a field to be before the Username one.

    Also ALL the property fields are being displayed, even the ones we have set NOT visible and/or only to Admin. How can we remove fields that are set to NOT visible in the Profile Properties section? We have MANY custom fields that are not needed for an export.

    Thanks,
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    01-16-2012 12:54 PM
    Hi. I don't believe at this time you can change the order of the custom fields but you should still be able to do this by not calling certain fields or specifically naming them when you are bringing it in.

    Instead of something like:
    Select * from your table

    You could name them and specifically put them in the order you want:
    Select [FirstName], [LastNAme], [Email] from YourTable

    etc.... Just remember to use [ ] if you have spaces or columns in your fields.

    Thanks,

    Chad
    sentientUser is Offline
    river guide
    river guide
    Posts:127
    Avatar

    --
    01-18-2012 04:56 AM
    Where is this query? This is the default user export and I cant see any place for a query. I have access to the database and stored procs if its in there. Just let me know and that would be great.


    ---
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi