Kit Priority Mail

Kit Priority Mail

Creating Html Reports With Virto Workflow Activities Kit For Sharepoint

Introduction

The necessity of data receiving from a certain list and generating a report often appears when sending e-mail alerts or creating a document. For instance, a user needs to display the list of his active tasks, administrator needs information about new users in the system, a client wants to see his active issues, etc. In other words, it’s highly important and effective to create a report based on data list.

Activities of business process automation are often implemented with Microsoft Office SharePoint Designer, which is easy to use and suitable for quick implementation. But unfortunately, generating reports is not available with Microsoft Office SharePoint Designer.

This article describes how to create a report with VirtoSoftware Workflow Activities Kit for SharePoint and prepare it for sending/processing.

Installation

Install and activate VirtoSoftware Workflow Activities Kit for SharePoint on your site.

Case Example

Then add fields.

ame Type Description IssueOwnerEmail Single line of text Responsible Person or Group Description Multiple lines of text Enhanced rich text (Rich text with pictures, tables, and hyperlinks) Priority Choice (menu to choose from) Choice:
Low
Normal
High
IssueStatus Choice (menu to choose from) Choice:
Active
Closed Resolution Multiple lines of text Enhanced rich text (Rich text with pictures, tables, and hyperlinks)

After completing that, add several issues to this list where Issues with different responsible users are contained and whether they are active or closed Issues.

Creating a Report

Let’s run Microsoft Office SharePoint Designer 2007, connect to the site and select File/New/Workflow in the menu. Then enter name “Create report for Responsible“ in the displayed window, and select list ”Company Issues” that was created before. Since we need to generate a report, both while creation and modification of a list, we should check all the boxes in “Select workflow start options for items in …” block.

After checking all the boxes, click Next to create activities.

To create a report, you only need to create one activity - “Generate report”. “Generate report” activity produces the report template parameters and parameters of collecting items from a list. The generated report is stored to a string variable. You can even describe the data source, filters and data sorting on the activity level. You should also describe the view structure of your report with the help of header, footer and list item templates.

Scheme of the report:
[Header]
[Row for List Item 1]
[Row for List Item 2]
…
[Row for List Item N]
[Footer]

Since “Generate report” activities work with rows, we can generate the report in any text format: simple text, XML, HTML, etc.

To add new activity, click Actions and select More Actions in the drop down. In the displayed window select Virto Actions category and select “Generate report” action. Then click “Add”.

You will see the new activity in the list as a result.

“Generate report” activity contains the following parameters:

Parameter Description this header Optional. The template for the heading section of the report. this row template Optional. The template for the report rows. Use string [%FieldName%] construction to resolve field value from current list item. FieldName can be field display name, field id (GUID) or field index (int). this footer Optional. The template for the footer section of the report all Optional. List item filter. The filter string supports View Name, View ID and CAML string (...). Empty filter returns all items.
Use … element to sort list items. current list Optional. Source list. Default value is current list.

We will leave Current list field without any modifications since we are going to select data from the current list. In your projects you can select any available list as a data source.

We should point CAML request instead of all. CAML request will select open Issues for a current responsible user and sort them by priority.

CAML request which selects all Issues sorted by priority for user ID #123 looks as follows.

We should insert the text highlighted with bold instead of “all” value. This means that we will not insert Query tags and replace user ID with Responsible value from the current row. Unfortunately, if we add direct link to the value of Responsible field, Workflow will replace it to the row of DOMAINuser type while implementation. To receive user’s ID we need to use one more activity from Virto Activities Kit – “Lookup site user property”. This activity stores the value of select user profile in the variable. Let’s add this activity before report generating.

Insert responsible variable to CAML request.

Instead of CAML request description, you can use Web interface to create new view, filter and sort required rows, and enter name or its ID in the activity.

For simplifying reasons, the report will not contain too much HTML. Use the following values instead of this header, this footer and this row template values.

this header Active issues:

Title
Priority
Created
Description

this row
[%Title%]
[%Priority%]
[%Created%]
[�scription%]

this footer

If we leave at least one of these values without any modifications, empty row will be used while report generating. The most significant in these rows is the fact that you can use both Workflow Lookup and links to field values in row template description. To do this you should use [%Field name%] constructions. They will be replaced with real values while report generating.

The description of “Generate report” activity parameters is completed. Now, while creating or modifying of a current Responsible in the Issue, the report will be generated.

So after completing all that, send this report by e-mail. In order to do this, let’s add Send Email activity after report creating. We can use standard activity or one of the Virto Activities Kit. In this case you will have an opportunity to attach files, add sender, or adjust SMTP server which you want to use for e-mail sending.

The full scheme of the business process looks as follows:

Save this business process. Then go to your site, add a new Issue or close (edit) the existing one. The responsible user will receive an e-mail notification to his e-mail address with the list of active Issues.

Conclusion

With the help of Virto Software Workflow Activities Kit for SharePoint, we have found the solution for business tasks regarding HTML report generating based on SharePoint list data. Further versions may include table display improvement and adding HTML links on objects. This is helpful to navigate to objects from the e-mail message directly.

About the Author

VirtoSoftware designs and builds innovative web parts for Microsoft® SharePoint® 2007 and 2010. It's compiled using the best Ajax and Silverlight technologies. The very first Virto Web Part was released in April, 2009, and the current comprehensive lineup includes calendaring, alerting, collaboration, workflow and administration capabilities for SharePoint users.

House in the Mail $3.95 Writing in a scrapbook in 1927, a young girl tells the fascinating story of her family's mail-order house arriving from Sears, Roebuck. Moving out of the little house they share with their grandparents, Emily and her brother, Homer, have a lot of changes in store for them: an electric refrigerator, electric lights, a washing machine, a gas stove, and running water indoors. Luminous illustrations show, in great detail, the process of clearing the land, building a foundation, and creating a house from a kit. Hand-written captions from Emily give the illustrations a cozy, personal feel, showing the reader just how exciting a house in the mail can be.

Priority $3.95 Acclaimed as "a sensuous literary treat" by the Santa Fe New Mexican, Priority is a lovely and nuanced exploration of intellectual admiration that develops into consuming passion. It begins as a young woman, Delphine, writes a letter to Jean-Luc, a painter whose work has touched her. She is sure he will not read it -- but he does, and he answers. Over the next eighteen months, Delphihe's letters bare her soul layer by layer, making her ever more vulnerable to his teasing replies and long silences. Helplessly, Delphine finds herself falling in love with a man she knows only through what he reveals in his letters. Her fascination with him begins to overwhelm her, until she begins to long for a lover she has never seen. Finally, it seems, a meeting may no longer be postponed.

Wolf Mail $81.25 High Quality Content by WIKIPEDIA articles Wolf Mail (born March 29, 1972) is a Canadian bluesrock guitarist/singer and songwriter. Bluesrock is a hybrid musical genre combining bluesy improvisations over the 12bar blues and extended boogie jams with rock and roll styles. The core of the blues rock sound is created by the electric guitar, bass guitar and drum kit, with the electric guitar usually amplified through a tube guitar amplifier, giving it an overdriven character. Author: Surhone, Lambert M./ Timpledon, Miriam T./ Marseken, Susan F. Binding Type: Paperback Number of Pages: 122 Publication Date: 2010/08/01 Language: English Dimensions: 6.00 x 9.02 x 0.29 inches

Fellowes Custom Mail Keyboard Kit $13.99 0.25" Height x 8.50" Width x 4.25" Depth 1 2.08 oz 99680 Adhesive strips secure Keyguard in place Poly-film fits snugly to enable full use of every key Order form Instructions Keyboard-model listing Postage-paid envelope Protect your keyboard from dust and spills 24 hours a day with the Custom Keyguard Kit. Clear polyurethane cover resists abrasions, cracking and tearing while it saves your keyboard from spills, dust and grime. Cover is designed to fit precisely to your keyboard so you won't have to take the protective cover off to type. Kit includes order form, instructions, complete keyboard-model listing and postage-paid envelope to receive keyguard custom-made for your keyboard by mail within two to three weeks. Abrasion Resistant Clear Crack Resistant Custom Mail Keyboard Kit Dust Cover Dust Proof Fellowes Fellowes, Inc Keyboard Polyurethane Tear Resistant www.fellowes.com

Top Priority $6.49 Top Priority

Mail Mail Mail $10 Mail Mail Mail

Mail $12.49 Mail - Masterprint

Good Mail Day (Paperback) $27.68 “What is a good mail day?” A good mail day is a day when, instead of just bills, catalogs, and advertisements, your postal carrier delivers artful, beautiful, personal mail from friends and acquaintances all over the world. Mail art is a collaborative art form with a long and fascinating history populated by famous artists as well as everyday practitioners. The term “mail art” refers to pieces of art sent through the mail rather than displayed or sold in traditional venues. Mail artists often use inexpensive and recycled materials including postcards, collage, rubber stamps, and photocopied images. Mail art is a truly international activity and a fun way to connect with people in every corner of the globe. Readers will learn to create decorated and illustrated envelopes, faux postage and artistamps, find penpals, make a mail art kit, and much more!

Mayne Charleston Mail Post $144.99 The Charleston mail post will add curb appeal to any home. Design features include decorative molding details, inset panels, and arched mailbox arm support. Mayne plastic mail posts are made from high quality polyethylene plastic with built in UV inhibitors for long lasting protection from the elements. Available in White, Black, Granite and Clay. 8.5 Post W x 58 H Includes decorative post, mailbox support arm, hardware kit, and instructions 15-year manufacturer limited warranty Small mailbox recommended. Best suited for mailboxes weighing less than 7 lbs Note: 4x4 wood post, mailbox, and mailbox mounting hardware NOT included.

Mail-order Homes (Paperback) $20.47 At the turn of the last century, the American middle class was expanding rapidly as homesteaders moved west and as trains took travellers across the country, where they established themselves in the depot towns that erupted along train lines. With that growth came the demand for new homes, and from that demand grew a new industry: mail-order homes. Sold by such makers as Sears, Roebuck & Co., Aladdin, and Montgomery Wards, these kit homes were shipped by train, arriving in two boxcars, which then were off-loaded by the purchasers, usually with a team of horse and wagon. In the boxcars was absolutely everything needed to assemble a house, whether it be a vacation cottage, modest bungalow, or two-and-a-half storey home. Literally tens of thousands of these affordable homes were sold in the early 1900s, with most built between 1910-40. In Mail-Order Homes, historical architectural researcher Rebecca Hunter brings to life the history of these charming homes, many of which still stand in communities across the country. From the manufacturers of mail-order homes to the customers who bought and built them, and from the styles and designs to the boom and bust of the industry, Hunter explains the history of these forgotten homes. Filled with illustrations from mail-order home catalogs and contemporary photos, this book tells the story of a bygone era of residential architecture.

Fellowes Custom Mail Keyboard Kit 99680 Keyboard $21.99 Features: Protect your keyboard from dust and spills 24 hours a day with the Custom Keyguard Kit. Clear polyurethane cover resists abrasions, cracking and tearing while it saves your keyboard from spills, dust and grime. Cover is designed to fit precisely to your keyboard so you won't have to take the protective cover off to type. Kit includes order form, instructions, complete keyboard-model listing and postage-paid envelope to receive keyguard custom-made for your keyboard by mail within two to three weeks. Abrasion Resistant Tear Resistant Crack Resistant Dust Proof Package Contents: Order form Instructions Keyboard-model listing Postage-paid envelope Parts: 1 year limited Labor: 1 year limited

High Priority $39.99 David Wright High Priority - Giclee Print

Priority One Vitamin Calm Priority 90 cap $20.2 Priority One Vitamin Calm Priority 90 cap

Priority One Vitamin Caprylic-Priority 100 cap $19 Priority One Vitamin Caprylic-Priority 100 cap

Priority One Vitamin Priority Zyme 100 Tab $60 Priority One Vitamin Priority Zyme 100 Tab

Snail Mail Stickers by Bob's Your Uncle® $8.49 Give your office work or mail a funny look and feel with these Snail Mail Stickers by Bob's Your Uncle®. There are fifty stickers, ten each of five designs from ?For when it absolutely, positively doesn't matter when it gets there? to "Not Very urgent", "Not at all Fragile", "Extremely Low Priority", "Please do Not Rush", and "Really Not Important", these stickers are a great way to make your mail man laugh or just a joke around the office. Features: • Made of paper • Printed in USA • Fifty stickers, ten each of five designs • Eco-friendly • Color: Multi-coloredSize: Stickers are 2 1/4" x 1? each

69270 - Labelwriter, Dymo Dms Desktop Mail $267.93 electronic Label Maker Offers A Desktop Mailing Solution. To Print Precise Postage, The Dymo 5 Lb. Scale Instantly Delivers The Mail Piece Weight To The Stamps Software To Print Correct Usps-approved Postage In About One Second For First Class, Flat Rate Priority Mail, Postcards And International Mail. Just As Quickly It Prints Perfectly Formatted, Laser-quality Labels For Envelopes, Packages And More From Microsoft Word, Wordperfect, Outlook, Quickbooks And Other Software. [69270] UPC: 071701692702 UNSPC: 43212108 9.8L x 12.1W x 6.8H 6.25 LB 0.34 Cubes

Stitch-A-Photo Cross Stitch Mail-in Chart Kit $27.97 Created a customized charted graph of any photo with the Stitch-A-Photo chart. To receive your Stitch-A-Photo chart, simply mail your photo in the pre-addressed photo mailer enclosed in the kit. Stitch-A-Photo cross stitch kit lets you turn almost any color photograph into an easy-to-use chart suitable for either cross stitch or needlepointStitch a portrait of a loved one, a cherished pet, or the family home With this craft kit, photos can be changed into black and white tones or sepia tones Works with photos from 1x1-inch up to 8x10-inch Finished design size varies with stitch count of the fabric used10-count fits 11-inch x 14-inch photo14-count fits 8-inch x 10-inch photoIn approximately two weeks from the date your photo is received, your custom Stitch-A-Photo chart will be mailed to you, along with your original photo and easy instructionsIncludesOne (1) Stitch-A-Photo mailerMailing instructionsThe size of finished product will vary depending on the stitch count of fabric used-see packaging for conversion details.Needlework materials, fabric, and tools not included.

Mail Truck Wall Hanging Felt Applique Kit $65.47 Bucilla always has the highest quality, most brightly colored and creative designs for their fabulous Christmas Applique KitsFinished measurements: 22.5x15 inchesDesign: Christmas Mail TruckDesigner: Maria StanzianiIncludes:Stamped feltCotton flossMetallic threadsSequins and/or beadsneedles and trilingual instructions

My #1 Priority $8.99 My #1 Priority

Charleston Black Mail Post $170 -Decorative molding details. -Inset panels. -Arched mailbox arm support. -Made of polyethylene plastic with built in UV inhibitors for long lasting protection from the elements. -Includes decorative post, mailbox support arm, and hardware kit. -Recommended for mailboxes less than 7 lbs. -Please note that 4x4 wood post, mailbox, and mailbox mounting hardware is not included. -Optional no dig ground screw is available. Please see companioned items to order.

Charleston Clay Mail Post $170 -Decorative molding details. -Inset panels. -Arched mailbox arm support. -Made of polyethylene plastic with built in UV inhibitors for long lasting protection from the elements. -Includes decorative post, mailbox support arm, and hardware kit. -Recommended for mailboxes less than 7 lbs. -Please note that 4x4 wood post, mailbox, and mailbox mounting hardware is not included. -Optional no dig ground screw is available. Please see companioned items to order.

Charleston Granite Mail Post $170 -Decorative molding details. -Inset panels. -Arched mailbox arm support. -Made of polyethylene plastic with built in UV inhibitors for long lasting protection from the elements. -Includes decorative post, mailbox support arm, and hardware kit. -Recommended for mailboxes less than 7 lbs. -Please note that 4x4 wood post, mailbox, and mailbox mounting hardware is not included. -Optional no dig ground screw is available. Please see companioned items to order.

Charleston White Mail Post $170 -Decorative molding details. -Inset panels. -Arched mailbox arm support. -Made of polyethylene plastic with built in UV inhibitors for long lasting protection from the elements. -Includes decorative post, mailbox support arm, and hardware kit. -Recommended for mailboxes less than 7 lbs. -Please note that 4x4 wood post, mailbox, and mailbox mounting hardware is not included. -Optional no dig ground screw is available. Please see companioned items to order.

Priority Focus Areas Training Kit: Tools for Educating Your Staff with CDROM $258.7 No Synopsis Available

Newell Rubbermaid DYMO LabelWriter 450 Twin Turbo Mail Postage Printer $299.99 This Newell Rubbermaid 1757660 postage printer and USB scale let you calculate, purchase and print USPS-approved postage for First Class, Flat Rate Priority, Express, postcard and international mail based on weight to simplify your shipping process.

5 Office Depot Versandkartons 'Mail-Box Kit' sortiert $14.27 High Speed Verpackung.Die Postboxen in ansprechendem Design sind platzsparend vorgefaltet und lassen sich in Sekunden aufrichten und verschließen. MAIL-BOX® BASIC XS postalisch zugelassen als Maxibrief.

Priority Records $76.47 Please note that the content of this book primarily consists of articles available from Wikipedia or other free sources online. Priority Records is an American record label, owned and operated by EMI, which has made a name for itself dealing primarily in hip hop, pop and world. Priority has also provided distribution for other labels such as RapALot Records, Ruthless Records, Death Row Records, WuTang Records, Rawkus Records, No Limit Records, RocAFella Records Rhythm Safari and Tass Radio Records. The Los Angelesbased company (with no ties or relations to a previous Priority Records label that was a subsidiary of what was then CBS Records) was formed in 1985 by three former Ktel executives: Bryan Turner, Mark Cerami and Steve Drath. Initial funding was provided by Rtek, a company headed by former Ktel board members: Ray and Harold Kives, and their company took an initial 50 ownership in Priority. Priority bought out the Rtek interest in 1987. Author: Surhone, Lambert M./ Tennoe, Mariam T./ Henssonow, Susan F. Binding Type: Paperback Number of Pages: 96 Publication Date: 2011/03/31 Language: English Dimensions: 9.02 x 5.98 x 0.23 inches