exporting password column to csv

[almatesic]

Currently I have the exporting feature working properly but when it exports the password column all the fields export blank. I am wondering why this is happening and how can i resolve this without changing the column name to not be password. Not that I know that solution will work anyway.

Happy New Year and looking forward to what this solution may be.

Thanks!

[shannah]

Xataface, as a security feature, never actually loads the values from any password columns into memory. They are a sort of "write only" field type. Xataface identifies fields named 'password' (or fields whose names contain the string 'password') as password fields.

This is a feature and not a bug.

Workarounds:

1. Use the __sql__ directive in the fields.ini file to introduce a grafted field copy of the password field.

2. use the beforeHandleRequest() method in the application delegate class to programmatically change the widget:type attribute of the password field for the export_csv function.

3. Use a MySQL view for exporting.

Whatever you do, you should be careful not to let people who shouldn't have access to the passwords see them.

-Steve