finish transformation and added av category attribute to db, process"