Importing CVS Files

This is very useful script!

Many autoreponder services export with format like:

email,firstname,lastname,address,phone,notes,ip,time
[email protected],john,doe,,,
[email protected],Jane,Doe,,,

I have been unsuccessful in getting exports formatted like above to work. Is it safe to assume that one cannot use standard exports from services like Getresponse and Aweber?

The list sanitizer script will only work if your CVS is a list of mails only separated by a comma?

Thank you!

Hi
this may help you :
<?php

function findEmails($string){
$email_regular_expression="([-!#\$%&'*+./0-9=?A-Z^_`a-z{|}~])+@([-!#\$%&'*+/0-9=?A-Z^_`a-z{|}~]+\\.)+[a-zA-Z]{2,24}";
preg_match_all('/'.str_replace('/', '\\/', $email_regular_expression).'/', $string,$matches);
return $matches[0];
}

$string="email,firstname,lastname,address,phone,notes,ip,time
[email protected],john,doe,,,
[email protected],Jane,Doe,,,";
echo '<pre>';
print_r(findEmails($string));
/*result :
Array
(
[0] => [email protected]
[1] => [email protected]
)
*/
?>
so you may from there use the output of this function to fill the php mailinglist sanitizer method "EmailChecker::ARprocess"
as shown in the example file and all will be done

your complete script may be

<?php
require_once('EmailChecker.class.php');
function findEmails($string){
$email_regular_expression="([-!#\$%&'*+./0-9=?A-Z^_`a-z{|}~])+@([-!#\$%&'*+/0-9=?A-Z^_`a-z{|}~]+\\.)+[a-zA-Z]{2,24}";
preg_match_all('/'.str_replace('/', '\\/', $email_regular_expression).'/', $string,$matches);
return $matches[0];
}
$var=file_get_contents('yourfile.csv');//get the content from your file in any plain text format;
$emails=findEmails($var);//retrieve the emails
$x=new EmailChecker(); // create your checker object
$x->ARprocess($ar,time().'.csv'));//call the array sanitizer...sanitize and save to timestamp.csv(you can choose your own name provided that the file doesn't exist)
?>

$x->ARprocess($var,time().'.csv'));//call the array sanitizer...sanitize and save to timestamp.csv(you can choose your own name provided that the file doesn't exist)
?>
instead of
$x->ARprocess($ar,time().'.csv'));//call the array sanitizer...sanitize and save to timestamp.csv(you can choose your own name provided that the file doesn't exist)
?>

sorry but it is :

$x->ARprocess($emails,time().'.csv'));//call the array sanitizer...sanitize and save to timestamp.csv(you can choose your own name provided that the file doesn't exist)
?>

instead of

$x->ARprocess($var,time().'.csv'));//call the array sanitizer...sanitize and save to timestamp.csv(you can choose your own name provided that the file doesn't exist)
?>

Thank you for reply and mods. I will try them in the morning and let you know how it goes.

Appreciate your assistance sir.

Yes, your suggested mods work great! I thank you for help.

If I could make one suggestion: Build in ability to pause (sleep/unsleep) the script so larger files can be loaded. Currently the script will time out based on server settings.

Thank you again,

TW

Hi
Happy to help. For the timeout issue you can prepend to the code i gave here set_time_limit(0);