From: lbergman Date: Fri, 30 Jun 2000 22:20:02 +0000 (+0000) Subject: Initial add of csv import file. No error checking present yet for some things but... X-Git-Url: https://vcs.fsf.org/?p=squirrelmail.git;a=commitdiff_plain;h=dd72f3055fec501889b24b58829912dc46a2b12e Initial add of csv import file. No error checking present yet for some things but it works. Thanks Pallo. git-svn-id: https://svn.code.sf.net/p/squirrelmail/code/trunk/squirrelmail@579 7612ce4b-ef26-0410-bec9-ea0150e637f0 --- diff --git a/src/addressbook_csvimport.php b/src/addressbook_csvimport.php new file mode 100644 index 00000000..e065ca10 --- /dev/null +++ b/src/addressbook_csvimport.php @@ -0,0 +1,395 @@ +"; + echo "\n"; + + /** + ** Script-wide vars. Used all over the place or something you might want to change later. + ** $example -->Sets how many rows of user data the script will use to play with before final write. + ** $abook ---->Setup the addressbook functions for Pallo's Addressbook. + **/ + $example = 6; + $abook = addressbook_init(true, true); + + /** See if the submit button has been clicked, if not, set up arrays with empty elements + ** To change the number of text boxes displayed in headers, add or delete ,"" 's + **/ + if(!$submit || $reset){ + $nickname = array("","",""); + $firstname = array("","",""); + $lastname = array("","",""); + $email = ""; + $label = array("","","","","","","","",""); + } + + if($flag <= 1) { // If first run of script, setup the filename to copy + $tempfilename = ($username . (time()+2592000)); + $nameholder = $tempfilename; + if(copy($smusercsv, "$data_dir$tempfilename")) { // Set up variable to use in printing status + $goodcopy = true; + } else { + $goodcopy = false; + } + } elseif($flag >= 2) { // If not use the name already set up + $tempfilename = $nameholder; + } + + // table with directions + if(!$finish) { + echo "

\n"; + echo "\n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " "; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " "; + echo " \n"; + echo " \n"; + echo " "; + echo " \n"; + echo " \n"; + echo " "; + echo " \n"; + echo "

", _("All the steps required to complete the process are listed below"), "

"; + echo _("You uploaded a file named: "); + echo "$smusercsv_name "; + echo "

"; + if(!$goodcopy && $flag == 0) { // print correct status of file copying + echo _("Failed to create working copy, Please try again."); + } else { + echo _("Created working copy, continuing with process..."); + } + echo "

", _("Displaying a small set of your data."), "

", _("Arrange your data to fit the 5 address book fields. "), _("Do this by inserting the data's field number under the field for which you wish it to be included into the address book. "), _("For example: fields 5, 6, and 7 need to go into the info field 5. "), _("The boxes under field 5 would contain 5, 6, and 7 in seperate boxes. "), "

", _("Submit Your reorganized data."), " ", "\n"; + echo " ", " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " ", _("Erase entries and re-enter field numbers."), " ", "\n"; + echo " \n"; + echo "

", _("View full set of imported records in thier new format."), " \n"; + echo " \n"; + echo " "; + echo "

", _("Omit individual records which are not to be included."), "\n"; + echo " ", _("To the left of each field below the \"Omit\" heading is a checkbox."), "\n"; + echo " ", _("Click this checkbox to omit individual records."), "\n"; + echo "

", _("Final approval. "); + echo " ", _("After reviewing the rearranged data for accuracy, click \"Finish\"."), " \n"; + echo " \n"; + echo "

\n"; + } else { + echo "

", _("Upload Completed!"), "

", _("Click on the link below to verify your work."), ""; + echo "

" . _("Addresses") . "\n"; + } + + /** + ** Use fgetcsv to make an array out of the uploaded file + ** Display a sample to see if the data looks good to the user. + **/ + + // open the correct filename to work with + if($flag <= 1) { // before submit + $fp = fopen("$data_dir$tempfilename", "r"); + } elseif($flag >= 2) { // after submit + $fp = fopen("$data_dir$nameholder", "r"); + } + + echo "\n"; // user's data table + + // This loop sets up a table of the data they uploaded to save time while the user rearranges it. + $row = 0; + do { + ($data = fgetcsv($fp, 4096)); + $cols = count($data); + $row++; + + if($flag == 0 && !$finish) { // Table header on initial import + echo "
\n"; + } elseif($flag == 2 && !$finish) { // Table header after field changes made + echo "
\n"; + } + + switch($flag) { // This switch sets up a method so that proper looping can be done for the table output + + case 0: + case 1: + case 2: // Should probably be header since thats really what they are, maybe later + + if(!$finish) { // Set up column headers unless we are finished + echo " \n"; // fill in above the omit field + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; // email isn't an array so no loop needed + echo " \n"; + echo " \n"; + + // print field numbers for importable fields + $fcols = $cols; + $i = 5; + for($cols > 4;$fcols > 5 ; --$fcols) { + echo " \n"; + $i++; + } + // give the imported columns a name so the user knows what they will be put into + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + + // print some instruction in the header above the fields that need to be combined into other fields + $fcols = $cols; + for($cols > 4;$fcols > 5 ; --$fcols) { + echo " \n"; + } + echo " "; + echo "
\n"; + } + + case 3: // user's table data + + if($row % 2 && !$finish) { // Set up the alternating colored rows + echo " \n"; + } elseif(!$finish){ + echo " \n"; + } + echo " \n"; + } elseif(!$finish) { // if empty, put space in cell keeping colors correct. + echo " \n"; + } else + $reorg = ""; + } + echo " \n"; + $flag = 3; + break; + } + // If finished, do the import. This uses Pallo's excellent class and object stuff + if($finish && !$sel[$row]) { + $r = $abook->add($addaddr,$abook->localbackend); + if(!r) { + print $this->error; + } + unset($addaddr); + } + // How far should we loop through the users' data. + if($row < $example && (!$all && !$finish)){ + $loop = true; + } elseif(!feof($fp) && ($all || $finish)) { + $loop = true; + } else { + $loop = false; + } + + } while($loop); + + echo "

"; + echo "", _("This table shows your data after uploading it."), ""; + echo "	"; + echo "", _("This table shows your data after you reorganized it."), ""; + echo "
", " ", "	", _("Field Number: "), "0", " \n"; // number the fields so they know what to put where + reset($nickname); + while(list($k,$v)=each($nickname)) { // print out the text boxes for this var + echo" \n"; + } + echo "	", _("Field Number: "), "1", " \n"; // number the fields so they know what to put where + reset($firstname); + while(list($k,$v)=each($firstname)) { // print out the text boxes for this var + echo" \n"; + } + echo "	", _("Field Number: "), "2", " \n"; // number the fields so they know what to put where + reset($lastname); + while(list($k,$v)=each($lastname)) { // print out the text boxes for this var + echo" \n"; + } + echo "	", _("Field Number: "), "3", " \n"; // number the fields so they know what to put where + echo " \n"; + echo "	", _("Field Number: "), "4", " \n"; // number the fields so they know what to put where + reset($label); + while(list($k,$v)=each($label)) { // print out the text boxes for this var + echo" \n"; + } + echo "	", _("Field Number: "), "$i", "
", _("Omit"), "	", _("Nickname:"), "	", _("First name:"), "	", _("Last name:"), "	", _("E-mail address:"), "	", _("Additional info:"), "	", _("Move to field"), " ", _("1-5 to include."), "
"; // Print the omit checkbox, to be checked before write + + for($c=0; $c<$cols; $c++) { // Spit out the table cells + // concatenate fields based on user input into text boxes. + if($submit) { + switch($c) { // This switch puts the correct data into the correct fields + case 0: // concactenate nickname field + + reset($nickname); + $j = 0; + while(list($k,$v)=each($nickname)) { + if($v != "" && $j == 0) { + $reorg = "$data[$v]"; // put data in without coma + } elseif($v != "") { + $reorg .= "; $data[$v]"; // put data in with coma + } else " "; // put in space to keep the row colors going + $j++; + } + $addaddr["nickname"] = $reorg; // assign value for writing + break; + + case 1: // concactenate firstname field + + reset($firstname); + $j = 0; + while(list($k,$v)=each($firstname)) { + if($v != "" && $j == 0) { + $reorg = "$data[$v]"; + } elseif($v != "") { + $reorg .= "; $data[$v]"; + } else " "; + $j++; + } + $addaddr["firstname"] = $reorg; + break; + + case 2: // concactenate lastname field + + reset($lastname); + $j = 0; + while(list($k,$v)=each($lastname)) { + if($v != "" && $j == 0) { + $reorg = "$data[$v]"; + } elseif($v != "") { + $reorg .= "; $data[$v]"; + } else " "; + $j++; + } + $addaddr["lastname"] = $reorg; + break; + + case 3: // should only have one field in $email + + $reorg = $data[$email]; + $addaddr["email"] = $reorg; + break; + + case 4: // concactenate label field + + reset($label); + $j = 0; + while(list($k,$v)=each($label)) { + if($v != "" && $j == 0) { + $reorg = "$data[$v]"; + } elseif($v != "") { + $reorg .= "; $data[$v]"; + } else " "; + $j++; + } + $addaddr["label"] = $reorg; + } + } else $reorg = $data[$c]; + + if($reorg != "" && !$finish) { // if not empty, put data in cell. + trim($reorg); + echo "	$reorg

"; + + fclose($fp); +// unset each element in the arrays. For some reason, this doesn't work when included in the same loop as the \n"; + } + reset($lastname); + while(list($k,$v)=each($lastname)){ + echo" \n"; + } + reset($firstname); + while(list($k,$v)=each($firstname)){ + echo" \n"; + } + reset($label); + while(list($k,$v)=each($label)){ + echo" \n"; + } + } + + // Clean up after ourselves. + if($finish) { + unlink ("$data_dir$tempfilename"); + } + +?> + + +