Hi Tom,

You should still be able to add the reference, using Add Reference > Browse and add the DLL from the bin folder. I just tried this in a new 7.9 installation and that works.

However, the Target Framework for our package itself is 4.7.1. I just tested this, and adding the reference to a project which itself targets a lower framework like 4.6.1 means you cannot build after adding the reference and using it somewhere. Can you try changing the target framework of your project to 4.7.1 to see if it works in that case?

If that's not an option, I could actually just build our package with the target framework set to 4.6.1 instead. I have uploaded a PerplexDashboards.dll to our package page, which is v1.1.1 with Target Framework set to 4.6.1. Can you try that one as well?

-- Daniël

I rolled back to Umbraco 7.8.0, reference the solution to Target Framework 4.7.1, and upgraded to Umbraco 7.9.2. Then installed Perplex Dashboards Version 1.1.1.

This time I referred to PerplexDashboards.dll in the bin directory with browse. I didn't do that last time, since I assumed that all the references should be in the Reference Manager list, so I didn't known that you can browse other files (as in the bin directory) so this thread should probably not been labeled as bug, I think.

Now it just remains to find the correct codes and the locations of the code lines, for now I was listed member none under the Activity Log in the Member section.

MemberLogItem.Log(Members.GetCurrentMemberId(), MemberAuditAction.Login);

I got Members.GetByEmail(Members.CurrentUserName).Id to work instead of Members.GetCurrentMemberId().

Login in controller:

if (Members.Login(model.Username, model.Password))
{
    MemberLogItem.Log(Members.GetByEmail(Members.CurrentUserName).Id, MemberAuditAction.Login);
} 

Logout in controller:

public ActionResult Logout()
{
    MemberLogItem.Log(Members.GetByEmail(Members.CurrentUserName).Id, MemberAuditAction.Logout);
    Members.Logout();
    return Redirect("/");
}

If locked out:

if (Membership.GetUser(model.Username) != null && Membership.GetUser(model.Username).IsLockedOut)
{
    MemberLogItem.Log(Members.GetByEmail(Members.CurrentUserName).Id, MemberAuditAction.LockedOut);
    return RedirectToCurrentUmbracoPage();
}

If wrong username or password:

MemberLogItem.Log(Members.GetByEmail(Members.CurrentUserName).Id, MemberAuditAction.FailedLogin);

And the rest of MemberAuditAction somewhere in other controllers:

ForgotPasswordRequested = 3,
ForgotPasswordFinished = 4,
UpdateAccount = 5,
UpdatePassword = 6,
Activated = 8,
ActivatedByAdministrator = 9,
Register = 10

This worked the last time, but after a new installation, the application doesn't recognize me as a user until after logging in (none). Why?

Hi Tom,

This seems to be a regression in Umbraco 7.9. We simply store the data of an event that is fired by Umbraco, and I see in 7.9 the LoginSuccess event does not send the UserId correctly anymore for some reason, these screenshots are from 7.7 vs 7.9, where you can see the PerformingUser should be 0 but is set to -1. The Username property is empty in both cases, but that is fine when an ID is provided. Unfortunately I don't have much time currently so will look into this later.

• Daniël

I've deleted the package and the associated database tables, and installed the package again, but I have no lists of Locked and Unnaproved under Member, even though I know there are members with those statuses.

I find Hiker - PerplexDashboards - Locked Members ListView and Hiker - PerplexDashboards - Unapproved Members ListView below Available editors, but how should these be associated with the tabs?

Hi Tom,

This is a known issue, I have added it to the package page now as well. This will be fixed in a future version. For now, simply add a new datatype for each of those under Developer > Data Types (right click -> Create). Names do not matter. The package is looking for datatypes with the aliases but cannot find any. The aliases are

PerplexDashboards.MemberDashboard.UnapprovedMembersListView

and

PerplexDashboards.MemberDashboard.LockedMembersListView

Regards, Daniël

Yes, there it is, but it doesn't find locked and unapproved members, even though I know they exist, only "No members are locked" and "No members need approval" are written instead of the list that should display these member status in real time.

Note: I use SQL Compact Edition in this solution.

I just tested this in a 7.9.2 installation with a new member, and both lockout and unapproved status seem to work propertly with SQL CE. Are you 100% sure the member is locked out / unapproved? Could you perhaps test by creating a new member as well, cause I don't see anything that's wrong. If you get a console error, please also report it here.

I tried with a new member, with all 4 options (Approved, Locked - true/false), but no difference. Is there any database table I can check for double values, or do you have the SQL statements that will find them?

Seems we look directly in the cmsPropertyData table and use some unique id for this (I did not create this part of the code), I wonder if this still works if you have a custom member type. Anyway, source is here: https://github.com/PerplexInternetmarketing/PerplexDashboards/tree/master/PerplexDashboards

Unfortunately I cannot assist much more this week, will probably be sometime next week! I can always rewrite to use the MemberService, this raw SQL was probably done for performance reasons.

Thanks for the help anyway. Yes, I have a custom member in this case. I'll see if I find out something, but I'm waiting for you when you have time to go on. This package seems very promising, and I've also seen the link you posted http://downloads.perplex.eu/umbraco/gdpr/members.html, with tab "Members to be deleted", "You can not view this data, because you do not have the appropriate role to view sensitive data ", settings for "Delete member after period after inactivity", Insights etc.

Is this functionality you plan on next release?

Do you plan to build a function for exporting member data (according to GDPR)?

Hi Tom,

No, not at the moment. This also seems like something for Umbraco to add. We just visualize some data now :)

-- Daniël

I didn't notice it immediately after upgrading, but now there is a new selection at the top right corner, in the member section that exports memberdata to JSON format .

Hi Tom,

Just a heads-up, version 1.2 will use the MemberService now and should work with custom member types as well.

You should be able to just install it on top of the older one.

Version 1.1.1 doesn't seems to overwritten, so I uninstalled package version 1.1.1 and deleted the three database tables, but can't delete the four data types.

When I try to install version 1.2.0, version 1.1.1 showing up before installation.

How can I start from scratch by installing version 1.2.0?

What do you mean with "version 1.1.1 showing up before installation"? If you remove the package + DB tables, and double check that bin\PerplexDashboards.dll + AppPlugins\PerplexDashboards are gone, and you remove PerplexDashboardsMemberDashboard + PerplexDashboards_UserDashboard from config\Dashboard.config the package should be entirely gone. Also remove the item with name "perplexUmbracoUserLog" from the umbracoMigration table. Installing 1.2.0 from that point should work. I'll look into uninstall code that does this automatically at some later point in time :)

Now I checked all this, but my four Data Types are still giving me a databaseerror.

Can I manually delete these 4 records in table cmsDataType and table umbracoNode, or is there a better way to do this?

Is there more data to delete, like Lockout Emails text?

You cannot delete them from Developer > Datatypes (right-click a datatype, choose Delete) ?

Those are some funky errors, probably fixed after a restart of your site, and otherwise just reinstall everything (I assume this is not a production site?). I cannot reproduce those, I have no issues deleting the datatypes when uninstalling the package.

I also just released 1.2.1 with some small fixes related to database migrations.

These are the posts I'm tempted to delete since I test Perplex Security and GDPR Package on a page that is not in production, but it's an important copy that I would prefer not to roll back since several other changes have been made since the last copy.

table cmsDataType

table umbracoNode

By downloading local file, I installed version 1.2.1, and now it seems that everything is working properly. I will test out more with time, so thank you for the follow-up and help along the way.

I still have some errors with the database, but I've checked that the error was there before this package was installed, so that's another case.

is working on a reply...