The csv2post_log table was added 4th March 2013 and replaces log files. The log table is a multi-purpose table with the different purposes sharing the same columns but for totally different reasons. The column named “type” must be used to group rows by the type value. The reason for the multi-purpose approach is to reduce the number of tables installed by CSV 2 POST and because each purpose in play could have its own table but would probably still require logging i.e. if an item such as a post was being flagged it would also be logged as having being flagged. Instead we can do a single INSERT query and in many cases use the data in a row as if it was one type or the other i.e. all flags could be treated as logs and listed on the interface along with rows with the “log” type.
Some of the columns used for logging allow us to trace users steps but they are also part of our user experience program. The data allows us to build statistics regarding what screens are visited and what panels are used.