exporting password column to csv

Archived from the Xataface Users forum.

almatesic — Mon Jan 12, 2009 4:47 pm

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 — Mon Jan 12, 2009 6:18 pm

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