Re: Creating Custom Reports
Jeremy Wadsack <[email protected]> Mon, 23 Nov 2009 11:42:20 -0800
| Newsgroups | gmane.comp.web.analog.general |
|---|---|
| Message-ID | <[email protected]> |
--===============0331614487== Content-Type: multipart/related; boundary=0016364eee8e13f82504790f0603 --0016364eee8e13f82504790f0603 Content-Type: multipart/alternative; boundary=0016364eee8e13f82204790f0602 --0016364eee8e13f82204790f0602 Content-Type: text/plain; charset=KOI8-R Content-Transfer-Encoding: quoted-printable Analog can't do it without running multiple times because of the points mentioned in that FAQ entry. When I've needed to do this in the past I've used Analog to generate to components and scripted it to generate the reports that I then pulled into Excel to build the pivot table. Basically, like you are suggesting. With some small script writing you could run Analog get just a user report, pars= e that for use names, then run Analog for each user's trafffic. You can choose OUTPUT COMPUTER <http://analog.cx/docs/compout.html> for something that well generate a CSV table that you can then work from. Note that this works best for a single report (like Request Report) -- otherwise you'll need to use some programming magic in your spreadsheet to find the end of one report and the beginning of another. -- Jeremy Wadsack 2009/11/23 David Paul <david.paul-NYnJyUtGVOFWk0Htik3J/[email protected]> > Is there a way to write/create custom reports for Analog, in order to > process data? > > > > For example, if I wanted a report that grouped by user, and for each user= , > which files were downloaded. > > > > I have read the docs/faq.html#faq128, that tells how you could run the > report for each user, but this is not a feasible solution for me. Becaus= e > of this, I'm wondering if anyone has attempted to create custom report > themselves. If so, do you have recommendations as to whether I should > create the report in Analog, or export the data to .csv file and make a > report in excel? > > > > Thanks. > > > > David Paul, Test Engineer > > Vertex Business Services > > > 1001 SW Disk Drive, Ste 100, Bend, Oregon, 97702 > > T: +1 541 389 0120 ext 1080 =81 www.vertexgroup.com/na > > > The information contained in this email is intended only for the > individual to whom it is addressed. It may contain privileged and/or > confidential information.If you have received this message in error pleas= e > notify the sender immediately and delete the message from your computer. = The > unauthorised use, disclosure, copying or alteration of this message is > forbidden. The sender will not be liable for direct, special, indirect or > consequential damage as a result of any virus being passed on, or arising > from alteration of the contents of this message by a third party. > www.vertexna.com > > +------------------------------------------------------------------------ > | TO UNSUBSCRIBE from this list: > | http://lists.meer.net/mailman/listinfo/analog-help > | > | Analog Documentation: http://analog.cx/docs/Readme.html > | List archives: http://www.analog.cx/docs/mailing.html#listarchives > | Usenet version: news://news.gmane.org/gmane.comp.web.analog.general > +------------------------------------------------------------------------ > > --0016364eee8e13f82204790f0602 Content-Type: text/html; charset=KOI8-R Content-Transfer-Encoding: quoted-printable Analog can't do it without running multiple times because of the points= mentioned in that FAQ entry.<br><br>When I've needed to do this in the= past I've used Analog to generate to components and scripted it to gen= erate the reports that I then pulled into Excel to build the pivot table. B= asically, like you are suggesting. With some small script writing you could= run Analog get just a user report, parse that for use names, then run Anal= og for each user's trafffic.<br> <br>You can choose <a href=3D"http://analog.cx/docs/compout.html">OUTPUT CO= MPUTER</a> for something that well generate a CSV table that you can then w= ork from. Note that this works best for a single report (like Request Repor= t) -- otherwise you'll need to use some programming magic in your sprea= dsheet to find the end of one report and the beginning of another. <br> <br>--<br clear=3D"all">Jeremy Wadsack<br> <br><br><div class=3D"gmail_quote">2009/11/23 David Paul <span dir=3D"ltr">= <<a href=3D"mailto:david.paul-NYnJyUtGVOFWk0Htik3J/[email protected]">david.paul-NYnJyUtGVOFWk0Htik3J/[email protected]</a>&= gt;</span><br><blockquote class=3D"gmail_quote" style=3D"border-left: 1px s= olid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <div link=3D"blue" vlink=3D"purple" lang=3D"EN-US"> <div> <p class=3D"MsoNormal"><font face=3D"Arial" size=3D"2"><span style=3D"font-= size: 10pt; font-family: Arial;">Is there a way to write/create custom repo= rts for Analog, in order to process data?</span></font></p> <p class=3D"MsoNormal"><font face=3D"Arial" size=3D"2"><span style=3D"font-= size: 10pt; font-family: Arial;"> </span></font></p> <p class=3D"MsoNormal"><font face=3D"Arial" size=3D"2"><span style=3D"font-= size: 10pt; font-family: Arial;">For example, if I wanted a report that gro= uped by user, and for each user, which files were downloaded.</span></font></p> <p class=3D"MsoNormal"><font face=3D"Arial" size=3D"2"><span style=3D"font-= size: 10pt; font-family: Arial;"> </span></font></p> <p class=3D"MsoNormal"><font face=3D"Arial" size=3D"2"><span style=3D"font-= size: 10pt; font-family: Arial;">I have read the docs/faq.html#faq128, that= tells how you could run the report for each user, but this is not a feasible solution for me. Because of this, I’m wondering if anyone has attempted to c= reate custom report themselves. If so, do you have recommendations as to wh= ether I should create the report in Analog, or export the data to .csv file and mak= e a report in excel?</span></font></p> <p class=3D"MsoNormal"><font face=3D"Arial" size=3D"2"><span style=3D"font-= size: 10pt; font-family: Arial;"> </span></font></p> <p class=3D"MsoNormal"><font face=3D"Arial" size=3D"2"><span style=3D"font-= size: 10pt; font-family: Arial;">Thanks.</span></font></p> <p class=3D"MsoNormal"><font face=3D"Arial" size=3D"2"><span style=3D"font-= size: 10pt; font-family: Arial;"> </span></font></p> <table style=3D"border-collapse: collapse;" border=3D"0" cellpadding=3D"0" = cellspacing=3D"0"> <tbody><tr> <td style=3D"padding: 0in; width: 351pt;" width=3D"468"> <p class=3D"MsoNormal"><font color=3D"black" face=3D"Verdana" size=3D"1">= <span style=3D"font-size: 9pt; font-family: Verdana; color: black;">David P= aul, Test Engineer</span></font><font color=3D"black" face=3D"Verdana" size=3D"1"><= span style=3D"font-size: 9pt; font-family: Verdana; color: black;" lang=3D"= EN-GB"></span></font></p> <p class=3D"MsoNormal"><font color=3D"black" face=3D"Verdana" size=3D"1">= <span style=3D"font-size: 9pt; font-family: Verdana; color: black;">Vertex = Business Services</span></font></p> <p class=3D"MsoNormal"><font face=3D"Verdana" size=3D"1"><span style=3D"f= ont-size: 9pt; font-family: Verdana;"><br> </span></font><font color=3D"#897766" face=3D"Verdana" size=3D"1"><span s= tyle=3D"font-size: 7pt; font-family: Verdana; color: rgb(137, 119, 102);">1= 001 SW Disk Drive, Ste 100</span></font><font color=3D"#897766" face=3D"Ver= dana" size=3D"1"><span style=3D"font-size: 7pt; font-family: Verdana; color= : rgb(137, 119, 102);">, Bend, Oregon, 97702</span></font><font color=3D"#8= 97766" face=3D"Verdana" size=3D"1"><span style=3D"font-size: 7pt; font-fami= ly: Verdana; color: rgb(137, 119, 102);"> </span></font></p> <p class=3D"MsoNormal"><font color=3D"#897766" face=3D"Verdana" size=3D"1= "><span style=3D"font-size: 7pt; font-family: Verdana; color: rgb(137, 119,= 102);" lang=3D"DE">T: +1 541 389 0120 ext 1080 </span></font><font color=3D"#897766" face=3D"Arial" size=3D"1">= <span style=3D"font-size: 7pt; font-family: Arial; color: rgb(137, 119, 102= );" lang=3D"DE">=81</span></font><font color=3D"#897766" face=3D"Verdana" s= ize=3D"1"><span style=3D"font-size: 7pt; font-family: Verdana; color: rgb(1= 37, 119, 102);" lang=3D"DE"> </span></font><font color=3D"#897766" face=3D"= Verdana" size=3D"1"><span style=3D"font-size: 7pt; font-family: Verdana; co= lor: rgb(137, 119, 102);"><a href=3D"http://www.vertexgroup.com/na" target= =3D"_blank"><span lang=3D"DE">www.vertexgroup.com/na</span></a></span></fon= t><font color=3D"#897766" face=3D"Verdana" size=3D"1"><span style=3D"font-s= ize: 7pt; font-family: Verdana; color: rgb(137, 119, 102);" lang=3D"DE"></s= pan></font></p> </td> <td style=3D"padding: 0in; width: 0.75in;" valign=3D"bottom" width=3D"72"= > <p class=3D"MsoNormal"><font face=3D"Times New Roman" size=3D"3"><span st= yle=3D"font-size: 12pt;"><img src=3D"cid:image001.jpg-ST5/[email protected]" bo= rder=3D"0" height=3D"67" width=3D"72"></span></font><span lang=3D"EN-GB"></= span></p> </td> </tr> </tbody></table> <p class=3D"MsoNormal"><font face=3D"Times New Roman" size=3D"3"><span styl= e=3D"font-size: 12pt;"> </span></font></p> </div> The information contained in this email is intended only for the individual= to whom it is addressed. It may contain privileged and/or confidential inf= ormation.If you have received this message in error please notify the sende= r immediately and delete the message from your computer. The unauthorised u= se, disclosure, copying or alteration of this message is forbidden. The sen= der will not be liable for direct, special, indirect or consequential damag= e as a result of any virus being passed on, or arising from alteration of t= he contents of this message by a third party. <a href=3D"http://www.vertexna.com" target=3D"_blank">www.vertexna.com</a> </div> <br>+----------------------------------------------------------------------= --<br> | TO UNSUBSCRIBE from this list:<br> | <a href=3D"http://lists.meer.net/mailman/listinfo/analog-hel= p" target=3D"_blank">http://lists.meer.net/mailman/listinfo/analog-help</a>= <br> |<br> | Analog Documentation: <a href=3D"http://analog.cx/docs/Readme.html"= target=3D"_blank">http://analog.cx/docs/Readme.html</a><br> | List archives: <a href=3D"http://www.analog.cx/docs/mailing.h= tml#listarchives" target=3D"_blank">http://www.analog.cx/docs/mailing.html#= listarchives</a><br> | Usenet version: news://<a href=3D"http://news.gmane.org/gmane.comp.= web.analog.general" target=3D"_blank">news.gmane.org/gmane.comp.web.analog.= general</a><br> +------------------------------------------------------------------------<b= r> <br></blockquote></div><br> --0016364eee8e13f82204790f0602-- --0016364eee8e13f82504790f0603 Content-Type: image/jpeg; name="image001.jpg" Content-Transfer-Encoding: base64 Content-ID: <image001.jpg-ST5/[email protected]> X-Attachment-Id: 0.0.1 /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAoHBwgHBgoICAgLCgoLDhgQDg0NDh0VFhEYIx8lJCIf IiEmKzcvJik0KSEiMEExNDk7Pj4+JS5ESUM8SDc9Pjv/2wBDAQoLCw4NDhwQEBw7KCIoOzs7Ozs7 Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozv/wAARCABDAEgDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2aiii gAooooAKKKTpQAVjatq+nTaVdRR3kTO0ZAUNyTWVP4sm1HxAllo+w2Fm+/ULxzhAo6qD/Xv9Ku3e m6NNoMt/ZW8ZV4TJFIM+nBrkxTqezfs7Ws73/Q3oqHMua5JoWq6fb6NbRTXcSOqnKs2COTRTNE0X TbrR7eea0R5HUlmJPPJorCh9a9lG3Lay79jSp7Hnd77+R0NFFFekcgUUUUAJ05NcdqmrSeLRqOh6 FM6GCLLXS/ckbODHnsD6+x7U/wASS6zrmoroGlo1vZuu65vs5BXuoI/l1P0rO8PahL4J1E+HtZjS O2mctbXirhWz/eP+cfSpbKSMHTyb9F8PX7xaJYWCmS+TdiS4YHnr1PTj+fFdL4fnvdb1KC7tF/s7 w7p4McETDHn8Fcn8/wAPrmtrxB4S0jXp4Ly8BRoSC7oceYn90+3v1qIuNRlhs7KOE2UfymBHKFAp G2TI7dMY/XJwrDvc6NVVVCqAAOwFFRWluLS1jtw7uEGNznJNFWQTUUUhIAyTgCgAJAGScAVw+r6x eeLL+TRNBm8qxi/4/b8HgDuFP+c/SrEviybU9fW30oxjS7Ft9/eSfcK85UH/ADn6Vn6lpkuhOPE3 hpRcabcoHurLHyMh5yB6fy+mRUt3KSKfha40fSfGVzHp+rCPTVh2MbiYATSeq9vXn/Gu81PTtL17 TQl6kdxbZDqytnp3BH5cVkWukeE/EOkx6qNJt1hdSxPl+WVx1zjFWIpYtTKWNtB5dpHhoJbeQAR7 VGNwB469OO34CBkTSXGsslpYfudOMPySx4+XGAMg+h7cHgHPBA37a2jtYvLjUDnJwMZJ6nHbmmWV jDYwCOJRuOC745kbux9zVmmhMKKKKYgrjvEl7c65fXvhWxka0uEtxKJCcCf1T2GD19j2qef4h6Ra alLZ3kN5bqjbRNJCQre+OuPwrG8Qaxpw8TaJ4h069hnjD/Z7jy25Cn1HXoW/KpbRSTMSwYX6roWq PFounaYnmXkIJWS4cHk+56f07V03h64vtZ1GHU4h/Zvh6wVo7aA8ecMbcn/P9a29c8IaVr93b3V3 GRJEw3FDjzV/ut7VX+0Nq839nWtoIra2dQ0b/KAAe49MdBwQQCM9law73C4e71S9WxsoPs1tbOPn BxtIHdcD6Y9CGBrftraO2QhANzcu2MbjjGf0pLOzhsbdYIRhVzyep5z/AFqeqJCiiimIKKKKAIri 2t7uMxXMEcyHqsihh+tcP4i8KaFb6pp3k6ckYnuUSQIzAMCeRjOKKKT2GjvFUKoUDAAwBSBFVmYK AW6kDrRRTEOooooAKKKKACiiigD/2Q== --0016364eee8e13f82504790f0603-- --===============0331614487== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline +------------------------------------------------------------------------ | TO UNSUBSCRIBE from this list: | http://lists.meer.net/mailman/listinfo/analog-help | | Analog Documentation: http://analog.cx/docs/Readme.html | List archives: http://www.analog.cx/docs/mailing.html#listarchives | Usenet version: news://news.gmane.org/gmane.comp.web.analog.general +------------------------------------------------------------------------ --===============0331614487==--