CreArtiveNet - Easy Dotnetnuke

You are here :

May 24, 2013

Easy Graphs and Dashboards. Version 1.3.7

Full Demo Available on request.

EasyChart is a Dotnetnuke Module that allows you to add visualisation and charts to your data in a very easy way. We use Microsoft Chart control. See full list of features. By combining the panels layout, with the number of columns for your list of graphs and size of the graphs, you can create very professional dashboards.

Version 1.3.7

Fixed some issues. Additional error handling and auditing written to the event log. Added sample chart from SQL using a token.

Version 1.3.0

We have taken into account several comments and feedback. New features:

User can set the background colors as setting for the module instance.
Token have been added. User can defined the name of the token as parameter from the Querystring.

Tutorial with full details of the process. You can interact and create your own chart in the DEMO ... sorry, you are only allowed to add chart from static points.

Easy Users Export

Easy Users Export Module allows you to filter and export users and different fields from Membership and Profile so yo can open your file in Excel.

Only Administrators or Host cand search, export and download.
Compatible with 4.X, 5.X and 6.X.
You can filter filter in different ways. You can break into sets/pages if you have large number of users in you Dotnetnuke system.
You can select what fields to return, including fields from Profile.
You may be able to return password, depending how it was encrypted.
Sow data on screen or exported directly to be open in Excel.
Not Database alteration. It works using Dotnetnuke API.
Properties/Filelds extracted by reflection, to ensure compatibility in different versions of Dotnetnuke.
The purchased version is available as Enterprise, you can use it in your site and customers sites.

More Details

Easy Graph: Version 1.3 New Features.

Version 1.3. In step 3, you are able to use tokens in your query.

Test Token 1: Enter the name of your token to preview your graph. Take note of the Token in your query since you will need to use it in the settings for the module.

Test Token 2: Same with a second token.

Example of Query with Token:

select Categoryname, sum(productSales) as Total
from
[Sales by Category]
where categoryname = '[cat]'
group by Categoryname

Based on this query, the test token would be cat the brackets are added for you.

Test Value 1, 2: You can test your Token with a value.

Following our example of Query, you could test with a value for category name such as: Beverages which is a category name in Northwind Database.

If you do not use tokens, you can ignore this part.

If you use Tokens the preview will work correctly if token and token test value are entered correctly. The test value is used for preview and will be replaced by a querystring parameter. You configure this part in the settings of the module where the chart will be used.

If you use Predefined tokens, you do not need to do anything.

Version 1.3: You can change and Background Color and apply Tokens.

Color: Choose the two colors for your gradient. You can write Hex value or name of color. If you do not wish a gradient, make the two color the same.

Token 1 and 2: If you are using tokens, indicate the name of the Query String Parameter. In our example, the parameter would be cat. The value of the parameter would be used for more dynamic data based on different query string parameters OR predefined parameters.

Predefined Tokens:

Example: Sales per person logged in: the person could be a token through username or userid. For this case you would use a predefined token.

... where theuseridColumn = [EG_USERID]

The folowing tokens are predefined and applied/replaced automatically, so you do not need to input anything in settings neither in token test and value while testing:

[EG_USERID]
[EG_USERNAME]
[EG_PORTALID]

The last token can be useful due to graph definitions not being associated to a portalid.

Please register to access the forum.