Newsletter Address Import
when I try to import even only one new address I obtain this SQL error message:
SQLSTATE: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`usr_magento`.`newsletter_subscriber`, CONSTRAINT `FK_NEWSLETTER_SUBSCRIBER_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE)
and, of course, the address has not been imported...
September 7, 2012
Absolutely brilliant. Working for me in 126.96.36.199
August 12, 2012
Not working for me.
July 9, 2012
Tried to install this extention, but no luck. When installing, everithing seems to be fine, but i can't find anywhere in backend the controller for this extention
June 9, 2012
Note: System-gt;Tools-gt;Compiler must be disabled while working with address-import
January 24, 2012
Work great on 1.6.2
To get the unsubscribe-link working make this modification. It will generates a random key when import the addresses.
Insert in the file app/code/local/D3/Newsladdressimport/controllers/Adminhtml/NewsladdressimportController.php
at around line 180
$id = '';
$par = array();
$char = array_merge(range('a','z'),range(0,9));
$charLen = count($char)-1;
$disc = mt_rand(0, $charLen);
$par[$i] = $char[$disc];
$id = $id.$char[$disc];
Insert the $id into the sql-statement:
$q = "INSERT INTO `newsletter_subscriber` ( `subscriber_id` , `store_id` , `change_status_at` , `customer_id` , `subscriber_email` , `subscriber_status` , `subscriber_confirm_code` )
VALUES ( NULL , '1', NOW( ) , '0', '".$value."', '1', '".$id."' );";
January 24, 2012
dont work on 188.8.131.52?!?
December 30, 2011
It indeed works likes a charm! Thanks a lot!
Just one question: now it adds the contacts to the the first store + storeview. Can I somehow add them a different store? This because I run a store for bbq products, with different butchers for different districts. If butcher 1 has a special and butcher 8 doesn't, then I don't want the customers of butcher 8 to get this newsletter.
July 7, 2011
Just tested it in 184.108.40.206 and it works like a charm. Thanks a lot!
For those of you who cannot download it through Magento Connect, in Magento Connect click on the Settings tab and select preferred state Beta (since this extension is in Beta state). You can switch back to Stable after downloading and installing.
July 1, 2011
Doesn't work on 1.4.2. I tried installing it using Magento Connect and I get the message "Ignoring installed package magento-community/NewsletterAddressImport
Nothing to install"
June 27, 2011