Newsletter-Only Subscriptions for v1.3x

There is a patch on my site for that:
http://www.notgoddess.com/scripts/newsletter-subscribe
(click on the 'known issues' link or scroll to the bottom of the page).

-Ng_

My compliments! This is a very nice addition to my storefront. And while I was indeed terrified installing it, (fearing the worst) once in place it not only operated beautifully but there were literally no other major modifications because of it. Very well thought out.

The only comment I have is that in IE the font is quite tiny. Not so small as to be unusable but smaller then I'd like. Is there a fix for this? I realize that there is a lot of info in a very tight space and it may be unavoidable.

Again, congratulations on a well-made and well-designed product. :thumbsup:

beadedlily:

The only comment I have is that in IE the font is quite tiny. Not so small as to be unusable but smaller then I'd like. Is there a fix for this? I realize that there is a lot of info in a very tight space and it may be unavoidable.

First, thank you. :)

The sidebox itself has no font styling-it is just following your stylesheet. The style that affects it is in your main stylesheet.css (line 51):```
h4, h5, h6, label, h4.optionName, legend, address, .sideBoxContent, .larger
{
font-size: 0.8em;
}

You could try adding an overriding style specifically for labels inside sideboxes:```
.sideBoxContent label { font-size:1em !important;}
```(you may have to play around with the actual size setting to get it right)


Also, since your sideboxes are so narrow, you may want to edit the sidebox template and adjust the width of the email input field.  It uses ```
style="width: ' . ($column_width-30) . 'px"
``` by default, but you might want to change that 30 to something smaller, like 10, or change that entire calculation to ```
style="width: 95%"

-Ng_

That did the trick - Keep up the good work!

Thank you so much for such a wonderful contribution.
I have noticed in the admin panel though, that upon initial subscription the status is set to N (newsletter only), rather than P (pending confirmation) - which is what I would expect it to be set as...

I haven't tried sending a test newsletter...so I'm not sure if this is an issue or not...

Thanks again for the wonderful module :D

woodlandsprite:

I have noticed in the admin panel though, that upon initial subscription the status is set to N (newsletter only), rather than P (pending confirmation) - which is what I would expect it to be set as...

Not likely an issue, more likely a typo. I'll look/correct it in the new release.
-Ng_

Does the newsletter only subscription works fine with V1.3.0.2 ??

There are changes on core files:
audience.php
function_email.php
account_edit/header_php.php

Thanks
ERIC

NotGoddess:

Not likely an issue, more likely a typo. I'll look/correct it in the new release.
-Ng_
oh excellent. Thanks :)

ericpeng:

Does the newsletter only subscription works fine with V1.3.0.2 ??

yes, so long as you do a file comparison you should be alright.

ericpeng:

Does the newsletter only subscription works fine with V1.3.0.2 ??
I took a look at the changes using WinMerge, and they are in different areas, so there are no direct conflicts but you will want to merge the differences. I'll make sure the new release incorporates the patches.

-Ng_

NotGoddess:

I took a look at the changes using WinMerge, and they are in different areas, so there are no direct conflicts but you will want to merge the differences. I'll make sure the new release incorporates the patches.

-Ng_

Hi,

Thansks for your response.
I guess you're one of the people that always reply and this contribution is really great.

Thank you so much
ERIC

1062 error ... again.
1062 Duplicate entry '0' for key 1
in:
[insert into myshop_subscribers (email_address, email_format, subscribed_date, confirmed) VALUES ([email protected]', 'HTML', now(), 'TDYzLj')]

I know it is not really a problem from this module...... i think i got this from a common problem from exporting and importing sql data from one to another mysql server..with diff. server versions ( mine was 5.X --> 4.X )

how can i solve this?

kookiewookie:

1062 error ... again.
1062 Duplicate entry '0' for key 1

This will fix that one table:```
ALTER TABLE subscribers CHANGE subscriber_id subscriber_id INT( 11 ) NOT NULL AUTO_INCREMENT

It meants the auto_increment attribute was dropped from the table. If you chose export compatibility 4.0 you likely dropped the auto_increment value on all your tables-or it does that in mine.  

I usually export as 5.0, then edit and change ENGINE to TYPE and edit out any 'charset' settings I might have (needless to say I export the structure and data separately or it takes forever to edit the structure file. :)

You'll want to check your other tables as well to see if any have the autoincrement value.  If you fix it piecemeal you may miss some.

-Ng_

many many thanks for the fix! and the advice........ i have been mixing up things with the export settings.... just forgot about the old way, with this new export functions, and indeed just remove the char SET en ENGINE= TYPE....

This export comp. function gave me headache thanks for reminding me on the better export method.

Question for those wanting to import emails:

Do any of you have records that are not broken by newlines e.g.:
email,format|email,format

vs

email,format
email,format

If so I need to take a slightly different tack in the import function.
It's set up to take any delimiter (comma, | \t etc) and allows you to specify where in the record to pull the address/format from (in case you have other fields in there), but right now breaks records by newlines.

Anyone needing something more flexible?

Get back to me.

Danke,

-Ng_

Hi notgoddess,

I installed your patch for the wide box in IE thanks it works perfect! I take this oppertunity to bow to the goddess, I don't know how you do all of this with all those kids and a full time job. When I can I will donate because I think your greater than sliced bread. Thanks again!

NotGoddess:

Oh, in case anyone is wondering, the wishlist so far is:
Fix the newsletter script itself (occassionally errors out sending large groups) or at least note what emails were sent so manual fixes can avoid duplication.

has there been any fixes for this issue. i tried to send newsletter to 6000+ emails and if failed in both time.

now, i created groups thru the query_builder, grouped those 6000emails into 200s... every 200 at once...but still not sure if that will work or not ...
what # of emails do you think this script can handle ??

I haven't had a chance to look too far into it yet, sorry.
Right now I can suggest that you check your time limits...do a php info for:

max_execution_time (usually 30)

max_input_time (usually -1)

and see if you can set the execution time higher either with a php.ini or htaccess (not sure if you can set them in htaccess). The script already sets the time limit (set_time_limit) to 600 seconds, which should be more than long enough (it's not enabled if you are in safe mode tho), so it's possible one of the other settings is affecting it.

-Ng_

Another option is to use the Cart to get the emails, but export them and mail the newsletter from a mailing list program, like GroupMail (recommended by DrByte).

There's an email exporter in the downloads area that I've tested with subscriptions and since it lets you choose what email group to export you can grab all subscribers & not just customers. (Since that works so easily I won't be adding an exporter to the subscription manager and reinvent the wheel-I'll just do the importer).

-Ng_

max_execution_time Local value:60 Master value: 30

to be honest, i dont know how to create a php.ini file for that... (using shared hosting) and neither with htaccess...
do u have any guide...

i will research about GroupMail, i was also thinking of phpmail ...

geeee, i reinstalled the subscribtion, and now i forgot how i fixed the sidebox width issue... which file was that...