Newsletter Import Subscribers Utility (NewsLetterImportUtil.aspx)

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
11/10/2012 12:07:22 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Newsletter Import Subscribers Utility (NewsLetterImportUtil.aspx)

You are right that there is a bug in the plain text email token replacement for unsubscribe, if the UserGuid is empty it should use SubscribeGuid as the Html email token replacement does. I just fixed in my copy so it will be fixed in the next release, but most people will subscribe to the html rather than plain text anyway and it is working correctly there. When importing users I would opt them into the html email not plain text since the html newsletter is a much better marketing mechanism than a plain text email.

A subscriber should not need a UserGuid to unsubscribe.

Best,

Joe

11/10/2012 12:10:31 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Newsletter Import Subscribers Utility (NewsLetterImportUtil.aspx)

"Will a subsequent site registration replace the GUID if there's something (non-zero GUID) already in the UserGuid column of dbo.mp_LetterSubscribe?"

I'm not sure without looking at the code but my guess is no, when associating an existing subscription with a new site registration an empty guid would be expected on the subscriber row.

Best,

Joe

11/10/2012 12:23:26 PM
Adobe Wan Kenobi
Gravatar
Total Posts 22
View Posts

Re: Newsletter Import Subscribers Utility (NewsLetterImportUtil.aspx)

Subsequent site registration will create a different GUID in the dbo.mp_Users table; however, the original GUID created with the SQL query above will still remain in the dbo.mp_LetterSubscribe table UNTIL the user unsubscribes. Follow-up subscription to the same newsletter again will implant a duplicate of the GUID from the dbo.mp_Users table.

There seems to be no issue with having the two GUIDs, as the one in dbo.mp_LetterSubscribe appears to be ONLY used to track unsubscribe actions.

Hope this helps everyone!

 

- /\dobe \/\/an

11/10/2012 12:42:07 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Newsletter Import Subscribers Utility (NewsLetterImportUtil.aspx)

As I said before the only purpose of UserGuid field is to relate to mp_Users ie site members, it is only supposed to be used for unsubscribe for site members and it is also used to pull the site members subscriptions into the user profile page.

For non site members the Guid field in mp_LetterSubscribe is supposed to be used for unsubscribe (not the UserGuid field which is expected to have empty guid). However there is a bug in the current release where the wrong field is used for the unsubscribe link for non site members who are subscribed to plain text email.

You must sign in to post in the forums. This thread is closed to new posts.