Rated 0 out of 5 by zuiko Magento 220.127.116.11
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
Rated 0 out of 5 by Rombertus Absolutely brilliant. Working for me in 18.104.22.168
August 12, 2012
Rated 0 out of 5 by marionnex Not working for me.
July 9, 2012
Rated 0 out of 5 by dachus87 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
Rated 0 out of 5 by Matthias Wach Note: System-gt;Tools-gt;Compiler must be disabled while working with address-import
January 24, 2012
Rated 0 out of 5 by Matthias Wach 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
Rated 0 out of 5 by webez dont work on 22.214.171.124?!?
December 30, 2011
Rated 0 out of 5 by SefBogaerts 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
Rated 0 out of 5 by twisteddiana Just tested it in 126.96.36.199 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
Rated 0 out of 5 by andrew1 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