1 / 47

What is ToolZ?

Simplified way to program custom reports. What is ToolZ?. Custom Reports: The Hard Way. What is ToolZ?. <? php checkUserPerms ();

austin-mercado
Download Presentation

What is ToolZ?

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Simplified way to program custom reports What is ToolZ?

  2. Custom Reports: The Hard Way What is ToolZ? <?php checkUserPerms(); $query = ‘SELECT SubdivName, AVG(Score) AS AVG_SCORE FROM Shops INNER JOIN Locs USING(LocID) INNER JOIN Subdivs ON Subdiv3id = SubdivID GROUP BY SubdivID, SubdivName’; $results = execute($query); foreach($results as $row) $output .= ‘<tr><td>’.$row[‘SUBDIVNAME’].’</td><td>’.$row[‘AVG_SCORE ’].’</td></tr>’; print ‘<table>’.$output.’</table>’; ?>

  3. Custom Reports: The Hard Way Know our database schema Access to our dev servers What is ToolZ? <?php checkUserPerms(); $query = ‘SELECT SubdivName, AVG(Score) AS AVG_SCORE FROM Shops INNER JOIN Locs USING(LocID) INNER JOIN Subdivs ON Subdiv3id = SubdivID GROUP BY SubdivID, SubdivName’; $results = execute($query); foreach($results as $row) $output .= ‘<tr><td>’.$row[‘SUBDIVNAME’].’</td><td>’.$row[‘AVG_SCORE ’].’</td></tr>’; print ‘<table>’.$output.’</table>’; ?> Know how to program Mistakes more likely Handle data access Access to our data

  4. Custom Reports: The ToolZ Way What is ToolZ? {|CROSSTAB|} <table> {|LOOP|REGIONS} <tr> <td>{REGIONS.NAME}</td> {|LOOP|REGIONS.MONTHS} <td>{AVG(MONTHS.SCORE)}</td> {/|LOOP|} </tr> {/|LOOP|} </table> {/|CROSSTAB|}

  5. Custom Reports: The ToolZ Way What is ToolZ? {|CROSSTAB|} <table> {|LOOP|REGIONS} <tr> <td>{REGIONS.NAME}</td> {|LOOP|REGIONS.MONTHS} <td>{AVG(MONTHS.SCORE)}</td> {/|LOOP|} </tr> {/|LOOP|} </table> {/|CROSSTAB|} <?php checkUserPerms(); $query = ‘SELECT AVG(SCORE) FROM…’; $results = execute($query); foreach($results as $row) $output .= ‘<tr><td>’.$row[‘SCORE’].’</td></tr>’; print ‘<table>’.$output.’</table>’; ?>

  6. No schema knowledge Done on prod servers Custom Reports: The ToolZ Way What is ToolZ? {|CROSSTAB|} <table> {|LOOP|REGIONS} <tr> <td>{REGIONS.NAME}</td> {|LOOP|REGIONS.MONTHS} <td>{AVG(MONTHS.SCORE)}</td> {/|LOOP|} </tr> {/|LOOP|} </table> {/|CROSSTAB|} Smaller chance of mistakes Know how to write HTML/ToolZ Data access automatic Limited and safe data access

  7. Allows non-SurfMerchants to “program” custom SASSIE reports What is ToolZ?

  8. More flexible than Reporterator or Dragon Why is ToolZ?

  9. Faster, simpler, and cheaper than SASSIE custom development Why is ToolZ? Easier to maintain and modify Decreases reliance on SurfMerchants for development

  10. Reports

  11. Shop Log with More Info

  12. Response Crosstab

  13. Cross Survey Comparison

  14. Trending with Change

  15. Outliers

  16. Individual Question Analysis

  17. Multichoice Summary

  18. Multi-Tiered Responses

  19. Multi-Tiered Responses

  20. Drillable graph

  21. Sectional/Question Scores

  22. Negative Narratives

  23. Fancy Infographic Type Thing

  24. Other uses for toolz

  25. Data for presentations, offline reports Data for Other Reports Note improved scores over time

  26. Quick answer to a client’s question Quick Queries

  27. Mockups and prototypes Rapid Prototyping It’s only a model

  28. changes

  29. ToolZ is missing a lot of important SASSIE data Data

  30. ToolZ is missing a lot of important SASSIE data Data • ToolZ feeds now include: • Report and Job Dates • All sectional scores • All response scores • All question types (except VZ, link, normative) • All location data • Managers • Custom Date Ranges • Waves • Job Status

  31. ToolZ data feeds take a very long time to run Data

  32. ToolZ data feeds take a very long time to run Data

  33. ToolZ data feeds take a very long time to run Data

  34. ToolZ graphs are very limited Graphs

  35. ToolZ graphs are very limited Graphs

  36. ToolZ reports don’t look nice Appearance

  37. ToolZ reports don’t look nice Appearance

  38. ToolZ can’t report on complex conditions Complexity

  39. ToolZ can’t report on complex conditions Complexity RuleZ can be used for simplifying

  40. ToolZ can’t report on complex conditions Complexity We have the ability to program custom groups and properties

  41. ToolZ reports can only be developed by a third-party developer Developers

  42. ToolZ reports can only be developed by a third-party developer Developers XTreamIT does still do ToolZ development Technical people at MSPs can be trained (11 people have been trained so far) SurfMerchants has several ToolZ developers

  43. http://toolzdocs.wordpress.com/ • See what’s new and what’s next: • http://toolzdocs.wordpress.com/change-log/ • http://toolzdocs.wordpress.com/annual-summary/2014-plans/ • Share your opinion: https://toolz.uservoice.com/ Learn More

  44. Future Development

  45. Future Development

More Related