User Export: Special Characters & Col Order

Hi all, I have two issues with the user export I’m hoping we can resolve without me having to write my own export code…

The first is special characters. My client has lots of members from abroad. The special characters display fine on the website (such as “163 Rue Héna”) but come out odd on the export CSV (such as “163 Rue Héna”). Is it possible to stop this happening??

The second is to do with the order of the columns on my spreadsheet. They aren’t in the same order as in the settings, they seem to be alphabetical, can I change these to be in the correct order? My client is tired of having to reorder the columns in excel each time they export.

Cheers :)

Zoe

The first is special characters. My client has lots of members from abroad. The special characters display fine on the website (such as “163 Rue Héna”) but come out odd on the export CSV (such as “163 Rue Héna”). Is it possible to stop this happening??

Are you choosing UTF-8 encoding when opening the file? See this setting too: [hilite path]Dashboard -› s2Member® -› Import/Export -› User/Member Exportation -> Add UTF-8 BOM (Byte Order Marker)[/hilite]

The second is to do with the order of the columns on my spreadsheet. They aren’t in the same order as in the settings, they seem to be alphabetical, can I change these to be in the correct order? My client is tired of having to reorder the columns in excel each time they export.

The current engine requires those columns to be in alphabetical order for now (we’ll change this in the future). See. http://www.s2member.com/kb/importing-updating-users/#custom-registration-profile-fields