logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error

Options
Go to last post Go to first unread
ray22901031  
#1 Posted : Thursday, October 7, 2021 3:55:53 AM(UTC)
ray22901031

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 909

Thanks: 3 times
Was thanked: 15 time(s) in 15 post(s)
Dear support,

This is regarding the following post:
https://www.ablecommerce...-when-resetting-password

Our main objective is to go from "zz_anonymous_4691@domain.xyz" to "GuestUser-4691@myradiomall.com"

#1 Are we correct in assuming that the prefix "zz_anonymous_" originates in the file "CommerceBuilder.User", line 242?

#2. Are we correct in assuming that the suffix "domain.xyz" originates in the file "OrdersControllers.cs"?

#3. Obviously, the numerical number is the user ID auto-field, so this part works properly, by altering these two files I'm assuming we can achieve our result?

#4. We have tested that altering the name in the backend from "zz_anonymous_4691@domain.xyz" to "GuestUser-4691@myradiomall.com" does not seem to break anything.

Using user search with the advanced option to view anonymous user, still works correctly under "GuestUser-4691@myradiomall.com". So, we don't see a problem there. Are there any other areas in the backend which could be problematic?

Furthermore, we are deeply grateful that after moving to Full-Text Search that the Ablecommerce backend supports the use of wildcards. This is a great advantage for my people. In other words, if we wanted to see all anonymous users who have actually placed orders, we would query for "GuestUser*myradiomall.com", works great.

Many Thanks,
-Ray

PS: We are also discussing just adding a trigger to the users table that would take care of this automatically for us without having to touch any of the Ablecommerce code.

Edited by user Thursday, October 7, 2021 5:14:23 AM(UTC)  | Reason: Not specified

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.

ray22901031  
#2 Posted : Thursday, October 7, 2021 9:28:30 AM(UTC)
ray22901031

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 909

Thanks: 3 times
Was thanked: 15 time(s) in 15 post(s)
Dear Support,

We have successfully implemented a trigger on INSERT and UPDATE for the user table. This trigger will rename all "zz_anonymous_%@domain.xyz" users on the fly per current record only, based only on current user ID, to something that's a bit more acceptable.

Both the "UserName" and "LowerUserName" are being updated automatically. Just want to make sure that renaming these two field values automatically, behind the scenes, will not create any additional problems on the system.

Using a trigger let me bypass any code modifications in Ablecommerce.

If support can verify, it would be a highly appreciated.

Thanks,
-Ray

Edited by user Monday, October 11, 2021 7:40:07 AM(UTC)  | Reason: Not specified

Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.