Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Maillist Report v1.0


Guest

Recommended Posts

Hi all,

 

I private messaged the author of this report, since he was active in another newsletter thread, but no response.

 

The purpose of this little report is to show you who has signed up for your newsletter.

 

However, when I go to Admin>Reports>Newsletter Sign Ups .... I get this error:

 

Fatal error: Call to undefined function: mirror_out() in /home/moonligh/public_html/catalog/boss/maillist_report.php on line 138

 

Here is my line 135-147 in that file. FYI- this file is unique to the contrib ... done no modifying to it.

 

?>  
<tr class="dataTableRow" onMouseOver="rowOverEffect(this)" onMouseOut="rowOutEffect(this)">
	<? /*  <td align="left" class="dataTableContent"><?php echo $rows; ?>.</td> */ ?>
			  <td class="dataTableContent"><?php mirror_out($firstname);?></td> 
		  <td class="dataTableContent"><?php mirror_out($lastname);?></td>
				<td class="dataTableContent"><?php  mirror_out($email); ?></td>  

  </tr>

	  <?php	   
  } else { }
 }		  
?>

 

Anyone have any idea? Line 138 is the one concerning "firstname".

Thanks in advance!

Link to comment
Share on other sites

I could really use some help with this please. I have no clue if anyone is signing up or not for the newsletter cause I can't view the list of signups.

Link to comment
Share on other sites

I have the same problem but I go to phpmyadmin and I look at the mailist table and there I can see who has signed up.

 

Vance

 

Also ----though the phpmyadmin method isn't the best way to see who has signed up, it works....you can pm me if you are unfamiliar with this, and need help.

Link to comment
Share on other sites

Vance,

 

I agree, using PHPMyAdmin is a clumsy way of seeing who's signed up, it's much better than flying blind.

 

Thank you very much for answering!

Link to comment
Share on other sites

  • 2 weeks later...

I have a new question.

 

If a customer creates an account and subscribes to the newsletter in their account, why isn't that information being passed to the maillist part of myphpadmin, like it does in the newsletter/maillist contribution?

 

I want to know how many people total are on my mailing list: those with established accounts and those who are just visitors. This way, I can see how fast my mailing list is growing.

 

And I never did find out how to fix the above error. The author of that portion of the contribution has never responded to my private message nor in any relevant threads. *shrugs*

Link to comment
Share on other sites

Vance,

 

I agree, using PHPMyAdmin is a clumsy way of seeing who's signed up, it's much better than flying blind.

 

Thank you very much for answering!

 

Hi everyone,

 

I also just installed this only to find the same problem as everyone. I really wanted this to work as you've all correctly pointed out that this feature is really important for keeping track of newsletters. After much "Googling" and searching for a function called mirror_out, I found the answer. In catalog/admin/maillist_report.php, immediately after:

 

<?php require(DIR_WS_INCLUDES . 'application_bottom.php');

 

 

add:

 

function mirror_out ($field) {

 

global $csv_accum;

 

echo $field;

 

$field = strip_tags($field);

 

$field = ereg_replace (",","",$field);

 

if ($csv_accum=='') $csv_accum=$field;

 

else

 

{if (strrpos($csv_accum,chr(10)) == (strlen($csv_accum)-1)) $csv_accum .= $field;

 

else $csv_accum .= "," . $field; };

 

return;

 

};

 

 

That's it!! :thumbsup:

Link to comment
Share on other sites

Noel,

 

Nope - added that and still have the exact same problem. Line 138

 

Any other ideas?

 

Hi Barbara,

 

As you mentioned, it works on a clean install of the file. Perhaps place the function somewhere else within the php file.

 

As requested, I have also added instructions on how to send newsletters to both those subscribed with an account and those with just a newsletter subscription. Its in the contributions section. That way you can keep your databases separate rather than try to merge it.

Besides, when the original newsletters are sent, the customer info gets thrown into a temporary table anyway. So it was simply a matter of adding the info from the newsletter table into that same table and sending the e-mail to everyone on that list :blush:

 

Noel

Link to comment
Share on other sites

  • 3 weeks later...

there is an update in the same contrib section that is a version 1.1 that fixes that problem.

I just did it myself.

 

i can copy and paste the code if you try the 1.1 contrib and it still doesnt work.

Link to comment
Share on other sites

  • 1 month later...

I'm looking at the Maillist Report v1.1 addon and with looking at my files, it looks like this has already been done, but my customer account's subscriptions and the catalog/newsletter.php subscriptions are not melding together ...

 

Not sure what's going on ... any suggestions?

Link to comment
Share on other sites

Ok,

 

So I decided to play with a fresh footprint of osC, and decide to start modifications with the mailing list... I came across this exact same problem, and someone has posted in the contrib a supposed 'fix'....

 

magnon's fix does not seem to work... has anyone gotten this fixed?

 

...

 

 

LOL, oh my, I think I found the error...

 

 

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
<?
function mirror_out ($field) {

global $csv_accum;

echo $field;

$field = strip_tags($field);

$field = ereg_replace (",","",$field);

if ($csv_accum=='') $csv_accum=$field;

 

Ensure that you have <? just after the application_bottom.php line...

 

I just about kicked my own a$$ when I saw that.. it works it works it works!!

 

Thomas Keats

Keats Enterprises

A signature is something that reflects its user. - The dictionary

 

The question is not, 'to code, or not to code'

the question is, 'if we do not code, are we really alive?'

-- anonymous

Link to comment
Share on other sites

  • 1 month later...
  • 4 weeks later...
Ensure that you have <? just after the application_bottom.php line...

 

Actually, I installed both maillist v4 and report v1.1 without a hitch (fortunate I guess). Tested fine too.

 

The above suggestion is not necessarily the correct one for everyone. So for everyone else thinking of installing and reading this, v1.1 is the one you should use.

Link to comment
Share on other sites

  • 4 weeks later...

Following issue happens to my site when subscribing/unsubscribing using the form provided in this contribution (Newsletter v4.0):

 

Since button 'CONTINUE' doesn't keeps the session, when subscribing/unsubscribing from the newsletter the result message is not provided in the relevant language you are working on (i got catalan, english and spanish).

 

So the point would be to change the current input button:

 

....

<input type=\"hidden\" name=\"check\" value=\"20\">
			  <br /><br />				  
			  ". tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE) ."
			  </form>";

 

to something using the tep_href_link for images to keep the session. Or at least something that keeps the session.

 

Has anybody faced this problem?

 

Any ideas/feedback would be highly appreciated.

Link to comment
Share on other sites

  • 4 weeks later...

Hi, this is a good addon.

 

However, there is just one slight minor issue.

 

Whenever someone goes to newsletter.php to subscribe for email, and when goto Admin => Tools -> Newsletter Manager -> Send mail to newsletter subscribers is perfectly good and ok. All the newsletter subscribers including those who created a new account and ticked subscribe for newsletter ALL can receive email. So there is no issue here.

 

But when u goto Admin => Tools -> Send Email -> Select Newsletter Subsribers, only the subcribers who created a new account can receive. Those who just subcribe to newsletter without creating a new account cannot receive email.

 

Any advice? I believe it could be just a simple mod. Please advice.

 

Many thks

Link to comment
Share on other sites

  • 6 months later...

Great contrib! This is a nice contrib to add a simple way to get people to return to your site.

 

For mailinglist:

Would it be possible to change it to an "opt in" function? As it is now, anyone who gets subscribe gets notified by this, and is supposed to click the link to unsubscribe.

 

I think it would be better if a confirmation email would be sent and the person who wants to subscribe click the link to confirm that he wants the subscription.

 

Is there a separate support thread for the mailinglist contrib?

 

For mail list report:

Mail list report is great as well, but needs more functionality. I dont have the competence to program it, but wuldn´t it be nice to be able to see new subscriptions per day, week, month, year, as well as to see the number of unsubscribes?

Link to comment
Share on other sites

  • 2 months later...
Following issue happens to my site when subscribing/unsubscribing using the form provided in this contribution (Newsletter v4.0):

 

Since button 'CONTINUE' doesn't keeps the session, when subscribing/unsubscribing from the newsletter the result message is not provided in the relevant language you are working on (i got catalan, english and spanish).

 

So the point would be to change the current input button:

 

....

<input type=\"hidden\" name=\"check\" value=\"20\">
			  <br /><br />				  
			  ". tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE) ."
			  </form>";

 

to something using the tep_href_link for images to keep the session. Or at least something that keeps the session.

 

Has anybody faced this problem?

 

Any ideas/feedback would be highly appreciated.

 

 

THis is such a great contrib but for a multilingual shop this is a big problem - can anybody shine a light on how to keep the session ?

 

Thanks a LOT in advance :rolleyes:

Link to comment
Share on other sites

  • 1 month later...

Hello,

 

Thanks for a wonderful module. I think I have added it without a hitch.

When I send a newsletter it sends it to people who have registered as a member of the site and to those who have just signed up for an email.

 

I added the report and it shows only those who have just signed up for a newsletter and not site membership with the news letter.

How can adjust the report so it will show all people who wish to receive the newsletter?

 

thanks

Link to comment
Share on other sites

  • 9 months later...

Hi. I have a problem with installation of newsletter/maillist email capture add on.

 

I get this error message:

 

1146 - Table 'olagiatospiti.maillist' doesn't exist

 

SELECT customers_firstname as 'fname', customers_lastname as 'lname', customers_email_address as 'emailaddy' FROM customers where customers_newsletter = '1' UNION select customers_firstname, customers_lastname, customers_email_address from maillist where customers_newsletter = '1' ORDER BY 3

 

I have installed Maillist Report v1.2. What is the problem? How am I going to create the maillist table? I cannot see any php file with instruction about that.

Link to comment
Share on other sites

  • 5 months later...
Hi. I have a problem with installation of newsletter/maillist email capture add on.

 

I get this error message:

 

1146 - Table 'olagiatospiti.maillist' doesn't exist

 

SELECT customers_firstname as 'fname', customers_lastname as 'lname', customers_email_address as 'emailaddy' FROM customers where customers_newsletter = '1' UNION select customers_firstname, customers_lastname, customers_email_address from maillist where customers_newsletter = '1' ORDER BY 3

 

I have installed Maillist Report v1.2. What is the problem? How am I going to create the maillist table? I cannot see any php file with instruction about that.

 

 

Two little hick-ups

In admin, while the submenu under REPORT, "Newsletter subscription" is there, clicking on it I get ...

1146 - Table 'wwwwems_demoplain.maillist' doesn't exist

 

SELECT customers_firstname as 'fname', customers_lastname as 'lname', customers_email_address as 'emailaddy' FROM customers where customers_newsletter = '1' UNION select customers_firstname, customers_lastname, customers_email_address from maillist where customers_newsletter = '1' ORDER BY 3

 

[TEP STOP]

Would anyone have an SQL file for a quick run, please?

 

and in on the shop front ... the newsletter subscription doesn't show at all... I added the box to the right column like this, at the very bottom ...

} else {

include(DIR_WS_BOXES . 'newsletterAJAX_box.php');

}

?>

Link to comment
Share on other sites

Two little hick-ups

In admin, while the submenu under REPORT, "Newsletter subscription" is there, clicking on it I get ...

 

Would anyone have an SQL file for a quick run, please?

 

and in on the shop front ... the newsletter subscription doesn't show at all... I added the box to the right column like this, at the very bottom ...

 

OK ... :rolleyes: GOT EVERYTHING GOING AND SHOWING INCLUDING A NEW ERROR ...

When I Created my "maillist" table in MySql, apart from customers_firstname, scustomers_lastname and customers_email_address, I had to also create the customers_newsletter field to steer clear of any error message. Everything seems fine.

 

Now, when trying to subscribe, after pressing the send button, I get this error...

<br />

<b>Warning</b>: require(includes/languages/english/FILENAME_NEWSLETTER) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in <b>/home/wwwwems/public_html/demoplain/newsletterAJAX.php</b> on line <b>9</b><br />

<br />

<b>Warning</b>: require(includes/languages/english/FILENAME_NEWSLETTER) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in <b>/home/wwwwems/public_html/demoplain/newsletterAJAX.php</b> on line <b>9</b><br />

<br />

<b>Fatal error</b>: require() [<a href='function.require'>function.require</a>]: Failed opening required 'includes/languages/english/FILENAME_NEWSLETTER' (include_path='.:/usr/lib/php:/usr/local/lib/php') in <b>/home/wwwwems/public_html/demoplain/newsletterAJAX.php</b> on line <b>9</b><br />

 

Is this because of the field "customers_newsletter" in the maillist table (my 4th filed) ??? And if, why, if I delete this field, I then get an error in the admin section under reports/Newsletter Subscriptions ... ???

 

baffled ... <_< :(

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...