MyWraps creates a filtered and sorted list of Wraps as tables or charts. Administrators can print, recalculate, freeze, export, or delete wraps.
MyWraps displays field values in selected Wraps as charts or tables. Reports can be filtered, sorted, and ordered to give you exactly the information you require. Live links between MyWraps reports and Excel data are easy to create if you are more comfortable working in Excel.
Administrators can perform several administrative functions directly inside MyWraps:
MyWraps reports are limited to 500 wraps by default, to ensure a reasonable response from the server. This limit may be increased or removed with the MaxRows parameter in the link to the report. Read more at the bottom of this page.
Requesting a lot of data using many WrapLinks or WrapLinkAggregates, e.g. for a complex dashboard showing hundreds of entries, can be very time-consuming because of all the database operations required to provide the data one cell at a time. Using the MyWraps2 function, you can request a single data extract containing all the data you need by defining a single MyWraps link and having all the data returned with item separators in a single cell of the dashboard Wrap.
You can log each MyWraps request in the Audit Trail.
MyWraps is located on a separate tab on the start page of your Wrapsite.
This tab contains a list of your Wraps.
The Creator filter allows you to view only the Wraps that have been created by you.
The State filter lets you select only the wraps that are Live or Frozen, awaiting a signature or signed by you.
You can also filter the list by entering any part of the Wrap’s name in the text box and press Filter.
Click on the Wrap you want a report from.
MyWraps operates under the ExcelWraps permissions model.
Click on the Filter button in the toolbar to filter the wraps on Creator and State like in the list of Wraps. There is also an AutoNumber filter where you can explicitly select the First, Last, or LastFrozen auto number.
On top of each column is a text field where you can enter a filter for the column.
For text fields, you can enter any part of the value you wish to filter on and press Enter to hide the wraps that do not contain this value in the column. Example: if you enter “y” in the text field above the month column and press Enter, only the May wrap will appear. This is an example of the co (contains) operator, which is implied for string values if no explicit operator is used.
For numeric fields, you can enter any value that you wish to filter on and press Enter to hide the wraps that do not have this value in the column. Example: if you enter 2020 in the text field above the year column and press Enter, no wraps appear. This is an example of the eq (equal to) operator, which is implied for numeric and date values if no explicit operator is used.
The possible operators that you can use as column filters are:
For dates, the filter must be in ISO-standard yyyymmdd format , e.g. lt(20201225) means any date before Christmas Day 2020. DateTime filters must use a yyyymmddhhmmss format.
The buttons in the toolbar allow you to perform additional manipulations on the table:
For Wrapsite administrators, additional buttons appear that are described under Customized reports below.
The Action button in the MyWraps toolbar opens the Action dropdown menu that lets you perform actions on the selected wraps. Some of these actions only appear if you are a Wrapsite administrator. Some actions are deactivated until you select at least one wrap in the list.
1 This action is deactivated until you select at least one wrap in the list.
Navigating to MyWraps will present a list of the Wraps that are available to you.
Filter controls show you Wraps that are Mine (created by the logged-in user) or Any (created by anyone).
The state of a Wrap at any time is Live or Frozen. Some live Wraps will be AwaitingSignature (waiting for the logged-in user to sign the wrap) or SignedByMe (when the signature has already been made). The state Any lists all Wraps.
Once you’ve selected the wraps to include in the source data, you can use column filtering and sorting to manipulate the report.
All this is available to any user by clicking the Wrapsite menu option.
From a tabular data view simply click the Chart button to visualize the data. Charts have interactive pinch-zoom controls and each data point is clickable to open the Wrap data source. It’s an amazing feeling to have your data literally at your fingertips.
The appearance of the chart can be tailored using special options available to Wrapsite administrators.
A Wrapsite administrator with the AdminTenant role can create custom reports for users using a few additional buttons that appear in the toolbar:
Click on the Setup button to initiate the creation of a new report.
The entire report setup can be saved as a hyperlink. Many special characters are not allowed in links, or in our internal handling of links, including “#”, “(“, “)”, “~”, “?”, “/”, “&”, “+”, “=”, “.”, and “%”. If you use any of these characters in the wrong place, you will get a warning message.
On the Properties tab, you assign a Title to your report.
On the Columns tab, add all the columns you want to include in the report. Note that column names cannot contain the restricted characters listed above.
On the Appends tab, specify the Wraps you want to append.
A MyWraps report is always completely defined by its link. This makes it very easy to send a complete report to another ExcelWraps user with the required access – you just send the link. The report’s Setup described above is basically a wizard that helps you prepare the link for each report.
Once you’re happy with the report you have created, just copy the link. To send the report to another user, just paste the full link into a chat or an e-mail.
If the report is useful to other users of your Wrapsite, you may want to make it available to them when they log in. Doing this is very easy.
When you link to reports inside the Wrapsite, you only need the part of the link after “excelwraps.com”, i.e. starting with “MyWraps”. Copy only this part of the link, and we will then update the old link with the new parameters.
Navigate to the page on the Wrapsite where you want the link to appear.
Click the Edit button that corresponds to the section of the page that contains the report link.
Click on the button or text link that you want to modify, then on the “edit link” symbol that looks like a chain.
The field that contains the link is called URL. Select the entire URL field and press the Del and/or Backspace keys until you are sure it is completely empty, then paste the link beginning with “MyWraps” that you copied earlier into the URL field.
The Text to display will appear on the button if there is one, or as the anchor text for a standard text link. The button or anchor text should clearly indicate what the user can expect to see when they click on the link.
The Open link in field allows you to open the report in a new window, in case you want the old window to remain on the screen. Many users find it confusing to have more than one window open, in particular on phones, and prefer to use the Back button in their browser to return to previous locations. Please consult your local user interface guidelines if you are uncertain.
Press Save to update the link.
Locate the Publish Now button at the bottom of the web page editor and click on it to save the updated web page. The changes you made are usually immediately available to your users.
If you use advanced features in WrapCreator when designing wraps, MyWraps provides a couple of convenient shortcuts.
The Copy button on the toolbar opens a window with two useful resources for the developer.
If you intend to make a call to the MyWraps2 function, you need a MyWraps link. Composing this link may be time-consuming and prone to errors. To reduce time and effort, you can experiment with the filter settings in MyWraps until you see exactly the selection of wraps that you would like to have returned by your MyWraps2 function. After that, you click on the Copy button and two useful fields appear. The upper field is the complete MyWraps link that you should paste into your MyWraps2 function call to return the wraps which at that point in time fulfill your current filtering in MyWraps.
The lower field contains the delimited text string that the MyWraps2 function call would return if it was called with this link right now. Keep in mind that this data is the dynamic result of a database search and may be different when the MyWraps2 function call is actually performed – new wraps may appear that also match your filters, and currently included wraps may no longer fulfill the filtering criteria.
As you can see in the screenshot, the example string uses the default row separator, a vertical bar or “pipe” symbol, “|” (without the quotes), and the default column separator, a semicolon, “;” (without the quotes). If you have set your MyWraps2 function call to use other delimiters you will have to copy the example string into a text editor and use search-and-replace to use the separators expected by the wrap.
Any MyWraps report can be saved as a single link that can be stored as a browser bookmark, added as a hyperlink on a webpage, or added to the Wrapsite menu. Your Wrapsite includes a MyWrapsGenerator Wrap that can create the reports you need in the form of MyWraps links.
https://guide.live.excelwraps.com/MyWraps/WrapOne?Options.Creator=Any&Options.State=Live&Filter.yourname=Rachel
If we decompose a MyWraps link into its components, we find:
You can include other parameters in your link to further tailor the report.
This metadata can be requested from signature fields, e.g. Signature.sig-datetime
Requesting a lot of data using many WrapLinks or WrapLinkAggregates, e.g. for a complex dashboard showing hundreds of entries, can be very time-consuming because of all the database operations required to provide the data one cell at a time. Using the MyWraps2 function, you can request a single data extract containing all the data you need by defining a single MyWraps link and having all the data returned with item separators in a single cell of the dashboard Wrap.
Some users find it a powerful option to manipulate a MyWraps report as a spreadsheet in Excel.
The Download button in the toolbar allows you to export any MyWraps report as a CSV file that contains the bare numbers with no formatting, or as an HTML file that contains all the numbers and hyperlinks to take you back to the source information on your Wrapsite. Excel can open both filetypes as spreadsheets via File > Open.
Excel has an embedded browser that can read a MyWraps report and pull it through to Excel for additional calculations and charting. The connection is dynamic and a Refresh button immediately updates your Excel workbook with live information from the Wrapsite.
Wrapsite administrators can also export the data in the Wrapsite to an XML file on the Administration dashboard > ExcelWraps > Wrap instances page. This file contains the Wrap template and all its Wraps and can be imported to another Wrapsite. For more information, read the help page for the Wrap instances page.
The export file is in XML format (Extensible Markup Language) and can be read by Excel. The exported file is compressed in the ZIP format.
To ease you into learning how Excel manages XML data files we have prepared some workbooks that can read any XML exported from your ExcelWraps subdomain. Our WrapReader.xlsm workbook splits the data in the XML file into Excel filtered lists and pivot tables presented on separate tabs.
Signature data has a slightly different data structure but is similarly interrogated using our WrapReaderSig.xlsm workbook.
Note: both the above .xlsm files contain Excel macros written in Visual Basic. Excel considers downloaded files with macros to be potentially harmful. If you cannot open or use the macro-enabled files as expected you may need to change your Options > Trust Center settings for Excel so that Excel allows the embedded macros to run.
These tools can be used offline to generate both simple and complex reports and they can be completely customized using Excel’s native commands.
When you view a Wrap, you can save content from it as a spreadsheet in xlsx format using the Export to Excel widget.
The ExcelWraps Client Services team use powerful database reporting tools to make any report no matter how complex. These reports can be made available through your Wrapsite. Don’t hesitate to contact Client Services if you need our help.
With improper filtering, a MyWraps report can become very long. To ensure that you create manageable reports, a MyWraps report stops after 500 wraps by default.
When your report reaches the limit you will see the following warning at the top of the report
*** NOTE: MyWraps is capped at MaxRows = 500 ***
The wrap limit can be adjusted using the MaxRows option in the MyWraps link:
...&Options.MaxRows=100...
In the example above, the report will be limited to the first 100 wraps.
If you reach the row limit inadvertently, you need to reduce the number of rows through better filtering. The MaxRows limit applies to primary filters only. These are high-speed filters used in the database already when extracting the source data for the report. Primary filtering of wraps is based on four things:
Once the designated subset of wraps has been extracted, secondary filtering takes place on individual field values. This is done in memory on the server and is much slower than primary filtering. Secondary filtering is unaffected by the MaxRows setting.
MyWraps can handle an unlimited amount of rows. If you expect your report to include more than 500 wraps, just increase the MaxRows parameter in the link. If you need all available data to be included, MaxRows can be completely disabled by setting it to -1 or 0.
...&Options.MaxRows=0...
A word of caution: anyone can make mistakes. With MaxRows disabled, you have no protection if an adjusted filter suddenly requests a ridiculously long report, that takes ages to generate.
If your MyWraps report is intended to be used with the WrapStack widget to manipulate a bulk of wraps, we recommend that you adjust the MaxRows parameter quite precisely to your expectations, to avoid overloading the server and the database if an inadequate filter setting in MyWraps results in an enormous update job that you most certainly will want to undo later.
The pageSize setting defines the number of wraps that appear on each page of the report. It has a Wrapsite default setting, see below.
You can override the default value using the pageSize=n parameter in the MyWraps link. If n exceeds the maximum value set for the Wrapsite (see below), the maximum value is used instead of n.
The page setting requests a particular page in the report, e.g. page=2. You cannot specify a range or a list of pages, only a single, positive integer.
The first wrap on each page is (page-1)*pageSize+1, e.g. if page=2 and pageSize=10, the report will start with wrap (2-1)*10+1=11.
The pageSize setting has a Wrapsite default setting on the Administration dashboard > Settings page.
You can override the default value using the pageSize=n parameter in the MyWraps link. If n exceeds the maximum value set on the Administration dashboard > Settings page, the maximum value is used instead of n.
