1 / 27

2011 Practice Management Annual Conference

2011 Practice Management Annual Conference. Creating, Editing and Managing Powerviews Ardavan Gurg, Pars Consulting Incorporated Robert Rice, 35-45 Consulting-Dallas. September 24, 2011. Agenda. Introduction Powerview Basics (BEGINNER) HTML Style Sheets (INTERMEDIATE)

matt
Download Presentation

2011 Practice Management Annual Conference

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. 2011 Practice Management Annual Conference Creating, Editing and Managing Powerviews Ardavan Gurg, Pars Consulting Incorporated Robert Rice, 35-45 Consulting-Dallas • September 24, 2011

  2. Agenda Introduction Powerview Basics (BEGINNER) HTML Style Sheets (INTERMEDIATE) Embedded SQL Reports (ADVANCED) Conclusion / Q&A Robert Rice Robert Rice Robert Rice Ardavan Gurg Robert & Ardavan

  3. Robert Rice • Has Consulted on Time Matters since 1996 • Has served 2 terms on the CIC Advisory Board • Owner of 35-45 Consulting-Dallas • Member of the 35-45 Consulting Group, LLC 35-45 offers a team of qualified consultants located in Texas, Oklahoma, New Jersey, Florida and New Mexico. We provide services nationally and internationally to Law Firms and legal professionals.

  4. Ardavan Gurg • Consulted on Time Matters for last 5 years • Covers Seattle/Portland area but services entire U.S. • Former Marketing Analyst at Merck & Co., Inc. • Involved at the design and deployment of first true Client Management System at Merck & Co., Inc. • Running for CIC Advisory Board

  5. Powerview Resource: Help File http://pm.lexisnexis.com/support/servicecenter/cic/servicerelease/?id=107&uid={529269e7-e78a-41ce-bd65-543c076cfac6} This help file covers many of the basics

  6. Powerview Basics Robert Rice

  7. Powerview Basics Overview • Powerviews are preview areas on the lists that allow you to see inside the record without having to open it • Powerviews can show data from the record itself and also from related records • Powerviews are written in HTML – the language of web pages • Powerviews can pull data from Time Matters records but also from external data sources (web, SQL Servers, other programs)

  8. Powerview Basics Parts • Two parts of the PowerView • HTML file • This is located under the designated Time Matters files directory, then under “Template/Powerview” and then under the folder for the corresponding list • Powerview Setup in Time Matters • This is set up either Program-Level or User-Level • The PV setup links the HTML file to the list settings

  9. Powerview Basics Basic HTML Primer • An HTML file is basically an ASCII text file written with certain codes • Most HTML have an opening token and a closing token • HTML files are broken into three major parts: • <html></html> begins and ends the whole file • <head></head> designates the header section • <body></body> designates the body of the file

  10. Powerview Basics Basic Time Matters HTML • Fields from the record are enclosed in “French Braces” and the core field name is used • Example: {MAT:MAT_REF} is the Matter reference • Related Records are embedded into a table. Rows of the table are repeated automatically for as many records as are related or until a certain specified count is reached • Example: • <table data="{RELATED:RECS=TODO;ORDER=DESCENDING;COUNT=0}">

  11. Powerview Basics EXAMPLE: Creating a ‘Matter – To Do’ list • Create a HTML file with any editor • Create it in the subfolder for the desired list in the Time Matters “files” folder • Add the HTML files to either Program-level or User-level Powerview settings

  12. HTML Style Sheets (Intermediate) Robert Rice

  13. HTML Style Sheets Styles in Powerviews • Styles are a way of reusing various settings in an HTML file; they are sometimes called ‘CSS’ (Cascading Style Sheets) • You can use styles to make VERY graphically impressive Powerviews with MINIMAL work! • Styles are either written directly into the HTML file or are written into another HTML file and referenced from the original HTML file • Styles are tied to various elements in the HTML file • <DIV> • Tables, table rows, or table cells

  14. HTML Style Sheets Styles • Add <STYLE> </STYLE> section in the <HEAD> of the HTML file • Some common styles are:

  15. HTML Style Sheets • Colors can be expressed as names or as hexadecimal values. Google “HTML colors” for a complete list HTML Colors

  16. HTML Style Sheets Example of Styles in Powerviews – To Do List View (Matter) • In this example we will be tying a style to a row of a table • Styles tied to table rows will start with ‘tr’ • The actual name of the style will come from the data of Time Matters. That is, we will name the style the result in the data that should cause the style to activate. The data cannot have spaces. • In this example we will use the “done” field; if the record is done the field is “Y” • tr.Y will be the style • tr.Y {color: #999999;text-decoration: line-through;}

  17. HTML Style Sheets Another Example of Styles – Docs received checklist • Set up a UDR as a “documents received checklist” • Each field is a document needed. The field is a required dropdown that has limited choices (e.g. Needed, Received, Not_Needed etc.) • An Auto-Entry form fills in all fields when created with “Needed” and the user fills in “Not_Needed” or “Received” • The Powerview shows each document with the status and color based on the status of that field • This creates a “Christmas Tree” dashboard that is only OK when the entire board is green

  18. Embedded SQL Reports (Advanced) Ardavan Gurg

  19. Embedded SQL Reports SQL Reporting Services Bible • Professional • Microsoft SQL Server 2008 • Reporting Services

  20. Embedded SQL Reports SQL Server Reporting Services • Free as part of SQL Server 2008 R2 Express • Low server overhead • Can access any part of TM, PCLaw or other SQL databases • Full SQL security features built in • Fast • Minimum user learning curve – access via an internal web address

  21. Embedded SQL Reports One Simple Command to Embed SQL reports: <iframe> • <iframe border="0" frameborder="0" name="Outline" src="http://ServerName/ReportServer/Pages/ReportViewer.aspx?%2fFolderName%2fReportName&amp;rs:Command=Render&amp;Paramater={ParamaterValue} " • style="width: 100%; float: center;" height="1200“ scrolling="no"> • </iframe>

  22. Embedded SQL Reports SQL Server Reporting Services • Examples: • Timeline of Events for a Matter • Elements of Outline for Outline records • Dashboards

  23. Embedded SQL Reports Timeline Powerview

  24. Embedded SQL Reports Outline Powerview

  25. Embedded SQL Reports Dashboard/Guage Example

  26. Conclusion Questions & Answers Ardavan Gurg & Robert Rice

  27. VOTE FOR ARDAVAN!

More Related