API tools faq
paste
Advertisement
Guest User

ecureuil-php-csv-vcf

a guest
Jan 11th, 2020
210
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 22.75 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. error_reporting(E_ALL & ~E_NOTICE); // report all errors except notices
  3. echo '
  4.     <!DOCTYPE html>
  5.     <html lang="en">
  6.     <head>
  7.     <meta charset="utf-8">
  8.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
  9.     <meta name="viewport" content="width=device-width, initial-scale=1">
  10.     <meta name="description" content="convert csv2vcf" />
  11.     <meta name="keywords" content="csv2vcf" />
  12.     <title>convert csv2vcf</title>
  13.     <!-- external styles -->
  14.     <link href="css/style.css" type="text/css" rel="stylesheet"/>
  15.     </head>
  16.         <body>     
  17.             <div class="boxShadows" id="headline">
  18.                 <h1>csv2vcf: convert *.csv to *.vcf</h1>
  19. ';
  20. /* === examples for different vCard Versions according to Wikpedia ===
  21. vCard 2.1
  22.  
  23. BEGIN:VCARD
  24. VERSION:2.1
  25. N:Gump;Forrest;;Mr.
  26. FN:Forrest Gump
  27. ORG:Bubba Gump Shrimp Co.
  28. TITLE:Shrimp Man
  29. PHOTO;GIF:http://www.example.com/dir_photos/my_photo.gif
  30. TEL;WORK;VOICE:(111) 555-1212
  31. TEL;HOME;VOICE:(404) 555-1212
  32. ADR;WORK;PREF:;;100 Waters Edge;Baytown;LA;30314;United States of America
  33. LABEL;WORK;PREF;ENCODING=QUOTED-PRINTABLE;CHARSET=UTF-8:100 Waters Edge=0D=
  34.  =0ABaytown\, LA 30314=0D=0AUnited States of America
  35. ADR;HOME:;;42 Plantation St.;Baytown;LA;30314;United States of America
  36. LABEL;HOME;ENCODING=QUOTED-PRINTABLE;CHARSET=UTF-8:42 Plantation St.=0D=0A=
  37.  Baytown, LA 30314=0D=0AUnited States of America
  38. EMAIL:[email protected]
  39. REV:20080424T195243Z
  40. END:VCARD
  41.  
  42. vCard 3.0
  43.  
  44. BEGIN:VCARD
  45. VERSION:3.0
  46. N:Gump;Forrest;;Mr.
  47. FN:Forrest Gump
  48. ORG:Bubba Gump Shrimp Co.
  49. TITLE:Shrimp Man
  50. PHOTO;VALUE=URI;TYPE=GIF:http://www.example.com/dir_photos/my_photo.gif
  51. TEL;TYPE=WORK,VOICE:(111) 555-1212
  52. TEL;TYPE=HOME,VOICE:(404) 555-1212
  53. ADR;TYPE=WORK,PREF:;;100 Waters Edge;Baytown;LA;30314;United States of Amer
  54.  ica
  55. LABEL;TYPE=WORK,PREF:100 Waters Edge\nBaytown\, LA 30314\nUnited States of
  56.  America
  57. ADR;TYPE=HOME:;;42 Plantation St.;Baytown;LA;30314;United States of America
  58. LABEL;TYPE=HOME:42 Plantation St.\nBaytown\, LA 30314\nUnited States of Ame
  59.  rica
  60. EMAIL:[email protected]
  61. REV:2008-04-24T19:52:43Z
  62. END:VCARD
  63.  
  64. vCard 4.0
  65.  
  66. BEGIN:VCARD
  67. VERSION:4.0
  68. N:Forrest;Gump;;Mr.;
  69. FN:Forrest Gump
  70. ORG:Bubba Gump Shrimp Co.
  71. TITLE:Shrimp Man
  72. PHOTO;MEDIATYPE=image/gif:http://www.example.com/dir_photos/my_photo.gif
  73. TEL;TYPE=work,voice;VALUE=uri:tel:+1-111-555-1212
  74. TEL;TYPE=home,voice;VALUE=uri:tel:+1-404-555-1212
  75. ADR;TYPE=work;LABEL="100 Waters Edge\nBaytown, LA 30314\nUnited States of A
  76.  merica";PREF=1:;;100 Waters Edge;Baytown;LA;30314;United States of America
  77. ADR;TYPE=home;LABEL="42 Plantation St.\nBaytown, LA 30314\nUnited States of
  78.  America":;;42 Plantation St.;Baytown;LA;30314;United States of America
  79. EMAIL:[email protected]
  80. REV:20080424T195243Z
  81. END:VCARD
  82.  
  83. <p>You can put as separator: ',' ';' or tab </p>
  84.  */
  85.  
  86. if(isset($_REQUEST["convert"])) // detect upload of file
  87. {
  88.     $allowedExts = array('csv','txt'); // MMM
  89.     $maximumFileSizeInKBytes = 4096;
  90.  
  91.     $allowedExts_string = "";
  92.     for($i=0;$i<count($allowedExts);$i++) {
  93.         $allowedExts_string .= "*.".$allowedExts[$i].", ";
  94.     }
  95.    
  96.     $maximumFileSizeInBytes = $maximumFileSizeInKBytes * 1024;
  97. //  $delimiter = $_POST['_delimiter'] == 'tab' ? "\t" : $_POST['_delimiter'];
  98.    
  99.     if($_FILES)
  100.     {
  101.  
  102.         if(checkExtension($allowedExts)) // MMM
  103.         {
  104.             if(($_FILES["file"]["size"] < $maximumFileSizeInBytes))
  105.             {
  106.                 if ($_FILES["file"]["error"] > 0)
  107.                 {
  108.                     echo "Return Code: " . $_FILES["file"]["error"] . "<br>";
  109.                 }
  110.                 else
  111.                 {
  112.                     echo '<div id="uploadDetails">';
  113.                     echo "Name: ".$_FILES["file"]["name"]."<br>";
  114.                     echo "Type: " . $_FILES["file"]["type"] . "<br>";
  115.                     echo "Size: " . ($_FILES["file"]["size"] / 1024) . " kB<br>";
  116.                     echo "Temp file: ".$_FILES["file"]["tmp_name"] . "<br>";
  117.                     echo "field selector:".$delimiter."ZZZ<br>";
  118.                     convert($_FILES["file"]["tmp_name"]);
  119.                     echo '</div>';
  120.                 }
  121.             }
  122.             else
  123.             {
  124.                 echo "File exceeds filezie limit of ".$maximumFileSizeInBytes."kByte.";
  125.             }
  126.         }
  127.         else
  128.         {
  129.             echo "File was not a allowed filetypes: ".$allowedExts_string;
  130.         }
  131.     }
  132. }
  133. else
  134. {
  135.  
  136.     echo '
  137.  
  138.             <form method="post" enctype="multipart/form-data">
  139.                 <label for="file">Please select your File.csv then hit convert:</label>
  140.                 <input type="file" name="file" id="file" style="width: 100%;">
  141.                 <br />
  142.                 field selector :
  143.                 <select name="$delimiter" onchange="set_form_fields(this)">
  144.                     <option value=",">Comma</option>
  145.                     <option value=";">Semicolon</option>
  146.                     <option value="\t">Tab</option>
  147.                 </select><br />
  148.                 <input type="submit" name="convert" value="convert" style="width: 100%;">
  149.             </form>
  150.             <p>the following fields in the *.csv will be converted:</p>
  151.             <div style="overflow:auto;white-space:nowrap;width:100%;" class="codecolorer-container bash default">
  152.                 <pre>
  153. First Name
  154. Last Name
  155. Display Name
  156. Nicknam
  157. E-mail Address
  158. E-mail 2 Address
  159. E-mail 3 Address
  160. Home Phone
  161. Business Phone
  162. Home Fax
  163. Business Fax
  164. Pager
  165. Mobile Phone
  166. Home Street
  167. Home Address 2
  168. Home City
  169. Home State
  170. Home Postal Code
  171. Home Country
  172. Business Address
  173. Business Address 2
  174. Business City
  175. Business State
  176. Business Postal Code
  177. Business Country
  178. Country Code
  179. Related name
  180. Job Title
  181. Department
  182. Organization
  183. Notes
  184. Birthday
  185. Anniversary
  186. Gender
  187. Web Page
  188. Web Page 2
  189. Categories
  190.             </pre>
  191.             </div>
  192.         </div>
  193.     ';
  194. }
  195.  
  196. // MMM verifie que le fichier envoye a l'une des extensions de $allowedExts
  197. function checkExtension(array $allowedExts)
  198. {
  199.     $upload_filename = $_FILES["file"]["name"];
  200.     $upload_filename_array = explode(".", $upload_filename);
  201.     $extension = strtolower(end($upload_filename_array));
  202.  
  203.     $key = array_search($extension, $allowedExts);
  204.     return $key !== false;
  205. }
  206.  
  207.  
  208. function convert($filename_csv)
  209. {
  210.     // $filename_csv = "export2016.06.24.csv";
  211.    
  212.     $lines_csv = file($filename_csv);
  213.    
  214.     $filename_extension = explode('.',$filename_csv);
  215.    
  216.     $filename_vcf = "./upload/".$_FILES["file"]["name"].".vcf";
  217.    
  218.     $file_vcf = fopen($filename_vcf, 'w') or die("can't open file");
  219.    
  220.     echo '<pre>generating vCard-Version: VERSION:2.1</pre>';
  221.    
  222.     // display name;phone0;phone1;phone2;phone3;phone4;phone5;phone6;phone7;phone8;phone9;phone10;phone11;phone12;phone13;phone14;phone15;phone16;phone17;phone18;phone19;
  223.     // email0;email_type0;email_label0;email1;email_type1;email_label1;email2;email_type2;email_label2;email3;email_type3;email_label3;email4;email_type4;email_label4;email5;email_type5;email_label5;email6;email_type6;email_label6;email7;email_type7;email_label7;email8;email_type8;email_label8;email9;email_type9;email_label9;email10;email_type10;email_label10;email11;email_type11;email_label11;email12;email_type12;email_label12;email13;email_type13;email_label13;
  224.     // pobox0;street0;city0;region0;postcode0;country0;type0;pobox1;
  225.     // street1;city1;region1;postcode1;country1;type1;pobox2;street2;city2;region2;postcode2;country2;type2;pobox3;street3;city3;region3;postcode3;country3;type3;pobox4;street4;city4;region4;postcode4;country4;type4;pobox5;street5;city5;region5;postcode5;country5;type5;pobox6;street6;city6;region6;postcode6;country6;type6;pobox7;street7;city7;region7;postcode7;country7;type7;pobox8;street8;city8;region8;postcode8;country8;type8;pobox9;street9;city9;region9;postcode9;country9;type9;pobox10;street10;city10;region10;postcode10;country10;type10;pobox11;street11;city11;region11;postcode11;country11;type11;pobox12;street12;city12;region12;postcode12;country12;type12;pobox13;street13;city13;region13;postcode13;country13;type13;organistion0;title0;organistion1;title1;organistion2;title2;organistion3;title3;
  226.    
  227.     // ==== fields to match ====
  228.     // display name
  229.     // street0 city0 region0 postcode0
  230.     // phone0 phone1 phone2 phone3
  231.     // email0
  232.     // organistion0
  233.  
  234.     // First Name;Last Name;Display Name;Nickname;E-mail Address;E-mail 2 Address;E-mail 3 Address;Home Phone;Business Phone;Home Fax;Business Fax;Pager;Mobile Phone;Home Street;Home Address 2;Home City;Home State;Home Postal Code;Home Country;Business Address;Business Address 2;Business City;Business State;Business Postal Code;Business Country;Country Code;Related name;Job Title;Department;Organization;Notes;Birthday;Anniversary;Gender;Web Page;Web Page 2;Categories
  235.    
  236.     // get all possible fields in android-vcf
  237.     $length = count($lines_csv);
  238.     for($i = 0;$i < $length;$i++)
  239.     {
  240.         if($i == 0)
  241.         {
  242.             $keys_csv = $lines_csv[$i];
  243.             $keys_csv = explode(";",$keys_csv);
  244.         }
  245.         else
  246.         {
  247.             fwrite($file_vcf, "BEGIN:VCARD\n"); // what Version does this file have
  248.             fwrite($file_vcf, "VERSION:2.1\n"); // what Version does this file have
  249.    
  250.             $values_csv = $lines_csv[$i];
  251.             $values_csv = explode(";",$values_csv);
  252.    
  253.             $position1 = findPos("First Name", $keys_csv);
  254.             $position2 = findPos("Last Name", $keys_csv);
  255.             $position = $values_csv[$position1] . ";" . $values_csv[$position2]. ";;" ;
  256.             if ( ( $position ) !== ";;;")
  257.             {
  258.                 fwrite($file_vcf, "N:".$position."\n"); // N:Gump;Forrest;;Mr.
  259.             }          
  260.  
  261.             $position3 = findPos("Display Name", $keys_csv);
  262.             $position = $values_csv[$position3];
  263.             if ( !empty( $position ) )
  264.             {
  265.                 fwrite($file_vcf, "FN:".$position."\n"); // FN:Forrest Gump
  266.             }          
  267.            
  268.             $position3 = findPos("E-mail Address", $keys_csv);
  269.             $position = $values_csv[$position3];
  270.             if ( !empty( $position ) )
  271.             {
  272.                 fwrite($file_vcf, "EMAIL;TYPE=home:".$position."\n");
  273.             }
  274.  
  275.             $position3 = findPos("E-mail 2 Address", $keys_csv);
  276.             $position = $values_csv[$position3];
  277.             if ( !empty( $position ) )
  278.             {
  279.                 fwrite($file_vcf, "EMAIL;TYPE=work:".$position."\n");
  280.             }
  281.  
  282.             $position3 = findPos("E-mail 3 Address", $keys_csv);
  283.             $position = $values_csv[$position3];
  284.             if ( !empty( $position ) )
  285.             {
  286.                 fwrite($file_vcf, "EMAIL;TYPE=OTHER:".$position."\n");
  287.             }
  288.    
  289.             // ORG:Bubba Gump Shrimp Co.
  290.             // TITLE:Shrimp Man
  291.             // PHOTO;GIF:http://www.example.com/dir_photos/my_photo.gif
  292.            
  293.             // if phone1 differs from phone0
  294.             $position = findPos("Home Phone", $keys_csv);
  295.             $phone0 = $values_csv[$position];
  296.             if ( !empty( $phone0 ) )
  297.             {
  298.                 fwrite($file_vcf, "TEL;TYPE=home:".$phone0."\n"); // phone0
  299.             }          
  300.  
  301.             $position = findPos("Business Phone", $keys_csv);
  302.             $phone1 = $values_csv[$position];
  303.             if ( !empty( $phone1 ) )
  304.             {
  305.                 fwrite($file_vcf, "TEL;TYPE=work:".$phone1."\n"); // phone1
  306.             }
  307.  
  308.             $position = findPos("Home Fax", $keys_csv);
  309.             $phone2 = $values_csv[$position];
  310.             if ( !empty( $phone2 ) )
  311.             {
  312.                 fwrite($file_vcf, 'TEL;TYPE="fax,home":'.$phone2."\n"); // phone2
  313.             }
  314.             $position = findPos("Business Fax", $keys_csv);
  315.             $phone3 = $values_csv[$position];
  316.             if ( !empty( $phone3 ) )
  317.             {
  318.                 fwrite($file_vcf, 'TEL;TYPE="fax,work":'.$phone3."\n"); // phone2
  319.             }
  320.  
  321.             $position = findPos("Mobile Phone", $keys_csv);
  322.             $phone4 = $values_csv[$position];
  323.             if ( !empty( $phone4 ) )
  324.             {
  325.                 fwrite($file_vcf, "TEL;TYPE=cell:".$phone4."\n"); // phone3
  326.             }
  327.  
  328.             // ADR;HOME;PREF:;;100 Waters Edge;Baytown;LA;30314;United States of America
  329.             $street0 = $values_csv[findPos("Home Street", $keys_csv)];
  330.             $street1 = $values_csv[findPos("Home Address 2", $keys_csv)];
  331.             $city0 = $values_csv[findPos("Home City", $keys_csv)];
  332.             $region0 = $values_csv[findPos("Home State", $keys_csv)];
  333.             $postcode0 = $values_csv[findPos("Home Postal Code", $keys_csv)];
  334.             $country0 = $values_csv[findPos("Home Country", $keys_csv)];
  335.            
  336.             if ( ( !empty( $street0 ) ) || ( !empty( $street1 ) ) || ( !empty( $city0 ) ) || ( !empty( $region0 ) ) || ( !empty( $postcode0 ) ) || ( !empty( $country0 ) ) )
  337.             {          
  338.                 fwrite($file_vcf, "ADR;TYPE=home:".$street0.";".$street1.";".$city0.";".$region0.";".$postcode0.";".$country0."\n");
  339.             }
  340.    
  341.             // ADR;WORK;PREF:;;100 Waters Edge;Baytown;LA;30314;United States of America
  342.             $street0 = $values_csv[findPos("Business Address", $keys_csv)];
  343.             $street1 = $values_csv[findPos("Business Address 2", $keys_csv)];
  344.             $city0 = $values_csv[findPos("Business City", $keys_csv)];
  345.             $region0 = $values_csv[findPos("Business State", $keys_csv)];
  346.             $postcode0 = $values_csv[findPos("Business Postal Code", $keys_csv)];
  347.             $country0 = $values_csv[findPos("Business Country", $keys_csv)];
  348.  
  349.             if ( ( !empty( $street0 ) ) || ( !empty( $street1 ) ) || ( !empty( $city0 ) ) || ( !empty( $region0 ) ) || ( !empty( $postcode0 ) ) || ( !empty( $country0 ) ) )
  350.             {              
  351.                 fwrite($file_vcf, "ADR;TYPE=work:".$street0.";".$street1.";".$city0.";".$region0.";".$postcode0.";".$country0."\n");
  352.             }
  353.  
  354.             // LABEL;WORK;PREF;ENCODING=QUOTED-PRINTABLE;CHARSET=UTF-8:100 Waters Edge=0D==0 ABaytown\, LA 30314=0D=0AUnited States of America
  355.             // ADR;HOME:;;42 Plantation St.;Baytown;LA;30314;United States of America
  356.             // LABEL;HOME;ENCODING=QUOTED-PRINTABLE;CHARSET=UTF-8:42 Plantation St.=0D=0A=
  357.             // Baytown, LA 30314=0D=0AUnited States of America
  358.  
  359.             // Web page
  360.             $position = findPos("Web Page", $keys_csv);
  361.             if ( !empty( $values_csv[$position] ) )
  362.             {
  363.                 fwrite($file_vcf, "URL;VALUE=URI:".$values_csv[$position]."\n"); // email0 // EMAIL:
  364.             }
  365.  
  366.             // Web page
  367.             $position = findPos("Web Page 2", $keys_csv);
  368.             if ( !empty( $values_csv[$position] ) )
  369.             {
  370.                 fwrite($file_vcf, "URL;VALUE=URI:".$values_csv[$position]."\n"); // email1 // EMAIL:
  371.             }
  372.            
  373.             // NOTE
  374.             $position = findPos("Notes", $keys_csv);
  375.             if ( !empty( $values_csv[$position] ) )
  376.             {
  377.                 fwrite($file_vcf, "NOTE:".$values_csv[$position]."\n");
  378.             }
  379.  
  380.             // Birthday
  381.             $position = findPos("Birthday", $keys_csv);
  382.             if ( !empty( $values_csv[$position] ) )
  383.             {
  384.                 fwrite($file_vcf, "BDAY:".$values_csv[$position]."\n");
  385.             }
  386.  
  387.             // Categories
  388.             $position = findPos("Categories", $keys_csv);
  389.             if ( !empty( $values_csv[$position] ) )
  390.             {
  391.                 fwrite($file_vcf, "CATEGORIES :".$values_csv[$position]."\n"); // email0 // EMAIL:
  392.             }
  393.  
  394.             fwrite($file_vcf, "END:VCARD"."\n"); // END:VCARD
  395.         }
  396.     }
  397.    
  398.     fclose($file_vcf);
  399.  
  400.     // move_uploaded_file($_FILES["file"]["tmp_name"],"upload/".$_FILES["file"]["name"]);
  401.  
  402.     echo "<pre> ".$length." entries transformed</pre>";
  403.    
  404.     echo '<span style="color: green; font-weight: bold;">Please DOWNLOAD RESULT: <a href="'.$filename_vcf.'">'.$filename_vcf.'</a></span>'; // $_FILES["file"]["name"]
  405.  
  406.     echo '<h1><a href="index.php">Do it again</a></h1>';
  407.     // header("Content-type: text/plain");
  408.     // header('Content-Disposition: attachment; filename="'.$filename_vcf.'"');
  409.  
  410.     /*
  411.     echo '<h1>The result will selfdestruct in 60 seconds</h1>';
  412.     sleep(60);
  413.    
  414.     if(!unlink($filename_vcf))
  415.     {
  416.         echo ("Error deleting ".$filename_vcf);
  417.     }
  418.     else
  419.     {
  420.         echo ("Deleted ".$filename_vcf);
  421.     }
  422.     */
  423. }
  424.  
  425. /* determine position of a value in an number-indexed array */
  426. function findPos($value,$array)
  427. {
  428.     $result = null;
  429.     $length = count($array);
  430.     for($i=0;$i<$length;$i++)
  431.     {
  432.         if($array[$i] == $value)
  433.         {
  434.             $result = $i;
  435.             break;
  436.         }
  437.     }
  438.    
  439.     return $result;
  440. }
  441.  
  442. echo '
  443.         </div>
  444.         <div class="boxShadows" id="headline">';
  445.        
  446. if ($_POST['_delimiter'] == ';')
  447. {
  448.     echo '
  449.         <p>EXAMPLE INPUT with ";" : this goes in:</p>
  450.             <div style="overflow:auto;white-space:nowrap;width:100%;" class="codecolorer-container bash default">
  451.                 <pre>
  452. First Name;Last Name;Display Name;Nickname;E-mail Address;E-mail 2 Address;E-mail 3 Address;Home Phone;Business Phone;Home Fax;Business Fax;Pager;Mobile Phone;Home Street;Home Address 2;Home City;Home State;Home Postal Code;Home Country;Business Address;Business Address 2;Business City;Business State;Business Postal Code;Business Country;Country Code;Related name;Job Title;Department;Organization;Notes;Birthday;Anniversary;Gender;Web Page;Web Page 2;Categories
  453. Aprenom1 Anom1;;Aprenom1 Anom1;;[email protected];[email protected];;+33 1 23 45 67 89;+33 2 87 65 43 21;+33 9 12 34 56 78;+33 9 87 65 43 21;;+33 6 12 34 56 78;rue1;rue2;meylan;rhone alpes;38240;france;rue1T;rue2T;Grenoble;isere;38000;france;;;;;;notes;1604-12-08 00:00:00;;;;;test
  454. Aprenom2;Anom2;Aprenom2 Anom2;;[email protected];[email protected];;+33 1 23 45 67 89;+33 9 12 34 76 78;;;;+33 6 56 78 12 34;rue D;rue D étendue;ville D;paca D;12345;france;rue T;rue T étendue;ville T;paca T;23456;france;;;;;;note lig 1 note lig 2 note lig 3;2020-01-05 00:00:00;;;www.xxx.com;;test
  455. Aprenom3;Anom3;Aprenom3 Anom3;;;;;;;;;;+33 6 12 34 56 78;;;;;;;;;;;;;;;;;;;;;;;;test
  456. Aprenom5;Anom5;Aprenom5 Anom5;;;;;;+33 9 87 65 43 21;;;;;;;;;;;;;;;;;;;;;;;;;;;;test
  457. Aprenom4;Anom4;Aprenom4 Anom4;;;;;+33 1 23 45 67 89;+33 9 12 34 56 78;;;;+33 6 87 65 43 21;;;;;;;;;;;;;;;;;;;;;;;;test
  458. Aprenom7;Anom7;Aprenom7 Anom7;;;;;+33 1 23 45 67 89;;;;;;;;;;;;;;;;;;;;;;;;;;;;;test
  459. ;Aprenom Anom;Aprenom Anom;;[email protected];[email protected];[email protected];+33 9 12 34 56 78;+33 9 87 65 43 21;+33 8 12 34 56 78;+33 8 87 65 43 21;;+33 6 12 56 34 78;rueD;;VILLED;;01234;;rueT;;VilleT;;34567;;;;;;;notes en tout genre AAAAAA aaaaaa;2019-12-18 00:00:00;;;;;test
  460. ;;Aprenom6 Anom6;;;;;+33 1 23 45 67 89;;;;;;;;;;;;;;;;;;;;;;;;;;;;;test
  461.                 </pre>
  462.             </div>';
  463. }
  464. else  
  465.     if ($_POST['_delimiter'] == '\t')
  466.     {
  467.     echo '
  468.         <p>EXAMPLE INPUT with " " : this goes in:</p>
  469.             <div style="overflow:auto;white-space:nowrap;width:100%;" class="codecolorer-container bash default">      
  470. First Name  Last Name   Display Name    Nickname    E-mail Address  E-mail 2 Address    E-mail 3 Address    Home Phone  Business Phone  Home Fax    Business Fax    Pager   Mobile Phone    Home Street Home Address 2  Home City   Home State  Home Postal Code    Home Country    Business Address    Business Address 2  Business City   Business State  Business Postal Code    Business Country    Country Code    Related name    Job Title   Department  Organization    Notes   Birthday    Anniversary Gender  Web Page    Web Page 2  Categories
  471. Aprenom1 Anom1      Aprenom1 Anom1      [email protected]  [email protected]       +33 1 23 45 67 89   +33 2 87 65 43 21   +33 9 12 34 56 78   +33 9 87 65 43 21       +33 6 12 34 56 78   rue1    rue2    meylan  rhone alpes 38240   france  rue1T   rue2T   Grenoble    isere   38000   france                      notes   1604-12-08 00:00:00                 test
  472. Aprenom2    Anom2   Aprenom2 Anom2      [email protected]  [email protected]     +33 1 23 45 67 89   +33 9 12 34 76 78               +33 6 56 78 12 34   rue D   rue D étendue  ville D paca D  12345   france  rue T   rue T étendue  ville T paca T  23456   france                      note lig 1 note lig 2 note lig 3    2020-01-05 00:00:00         www.xxx.com     test
  473. Aprenom3    Anom3   Aprenom3 Anom3                                      +33 6 12 34 56 78                                                                                               test
  474. Aprenom5    Anom5   Aprenom5 Anom5                      +33 9 87 65 43 21                                                                                                               test
  475. Aprenom4    Anom4   Aprenom4 Anom4                  +33 1 23 45 67 89   +33 9 12 34 56 78               +33 6 87 65 43 21                                                                                               test
  476. Aprenom7    Anom7   Aprenom7 Anom7                  +33 1 23 45 67 89                                                                                                                   test
  477.     Aprenom Anom    Aprenom Anom        [email protected]  [email protected]  [email protected]  +33 9 12 34 56 78   +33 9 87 65 43 21   +33 8 12 34 56 78   +33 8 87 65 43 21       +33 6 12 56 34 78   rueD        VILLED      01234       rueT        VilleT      34567                           notes en tout genre AAAAAA aaaaaa   2019-12-18 00:00:00                 test
  478.         Aprenom6 Anom6                  +33 1 23 45 67 89                                                                                                                   test
  479.                 </pre>
  480.             </div>';
  481.     }
  482.     else
  483.     {
  484.     echo '
  485.         <p>EXAMPLE INPUT with "," : this goes in:</p>
  486.             <div style="overflow:auto;white-space:nowrap;width:100%;" class="codecolorer-container bash default">
  487.                 <pre>
  488. First Name,Last Name,Display Name,Nickname,E-mail Address,E-mail 2 Address,E-mail 3 Address,Home Phone,Business Phone,Home Fax,Business Fax,Pager,Mobile Phone,Home Street,Home Address 2,Home City,Home State,Home Postal Code,Home Country,Business Address,Business Address 2,Business City,Business State,Business Postal Code,Business Country,Country Code,Related name,Job Title,Department,Organization,Notes,Birthday,Anniversary,Gender,Web Page,Web Page 2,Categories
  489. Aprenom1 Anom1,,Aprenom1 Anom1,,[email protected],[email protected],,+33 1 23 45 67 89,+33 2 87 65 43 21,+33 9 12 34 56 78,+33 9 87 65 43 21,,+33 6 12 34 56 78,rue1,rue2,meylan,rhone alpes,38240,france,rue1T,rue2T,Grenoble,isere,38000,france,,,,,,notes,1604-12-08 00:00:00,,,,,test
  490. Aprenom2,Anom2,Aprenom2 Anom2,,[email protected],[email protected],,+33 1 23 45 67 89,+33 9 12 34 76 78,,,,+33 6 56 78 12 34,rue D,rue D étendue,ville D,paca D,12345,france,rue T,rue T étendue,ville T,paca T,23456,france,,,,,,note lig 1 note lig 2 note lig 3,2020-01-05 00:00:00,,,www.xxx.com,,test
  491. Aprenom3,Anom3,Aprenom3 Anom3,,,,,,,,,,+33 6 12 34 56 78,,,,,,,,,,,,,,,,,,,,,,,,test
  492. Aprenom5,Anom5,Aprenom5 Anom5,,,,,,+33 9 87 65 43 21,,,,,,,,,,,,,,,,,,,,,,,,,,,,test
  493. Aprenom4,Anom4,Aprenom4 Anom4,,,,,+33 1 23 45 67 89,+33 9 12 34 56 78,,,,+33 6 87 65 43 21,,,,,,,,,,,,,,,,,,,,,,,,test
  494. Aprenom7,Anom7,Aprenom7 Anom7,,,,,+33 1 23 45 67 89,,,,,,,,,,,,,,,,,,,,,,,,,,,,,test
  495. ,Aprenom Anom,Aprenom Anom,,[email protected],[email protected],[email protected],+33 9 12 34 56 78,+33 9 87 65 43 21,+33 8 12 34 56 78,+33 8 87 65 43 21,,+33 6 12 56 34 78,rueD,,VILLED,,01234,,rueT,,VilleT,,34567,,,,,,,notes en tout genre AAAAAA aaaaaa,2019-12-18 00:00:00,,,,,test
  496. ,,Aprenom6 Anom6,,,,,+33 1 23 45 67 89,,,,,,,,,,,,,,,,,,,,,,,,,,,,,test
  497.                 </pre>
  498.             </div>';
  499.     }
  500.  
  501. echo '
  502.         </div>
  503.         <div class="boxShadows" id="headline">
  504.         <p>this comes out: (this is what android contact book understands)</p>
  505.             <div style="overflow:auto;white-space:nowrap;width:100%;" class="codecolorer-container bash default">
  506.                 <pre>
  507. BEGIN:VCARD
  508. VERSION:2.1
  509. N:Aprenom1 Anom1;;;
  510. FN:Aprenom1 Anom1
  511. EMAIL;TYPE=home:[email protected]
  512. EMAIL;TYPE=work:[email protected]
  513. TEL;TYPE=home:+33 1 23 45 67 89
  514. TEL;TYPE=work:+33 2 87 65 43 21
  515. TEL;TYPE="fax,home":+33 9 12 34 56 78
  516. TEL;TYPE="fax,work":+33 9 87 65 43 21
  517. TEL;TYPE=cell:+33 6 12 34 56 78
  518. ADR;TYPE=home:rue1;rue2;meylan;rhone alpes;38240;france
  519. ADR;TYPE=work:rue1T;rue2T;Grenoble;isere;38000;france
  520. NOTE:notes
  521. BDAY:1604-12-08 00:00:00
  522. END:VCARD
  523. BEGIN:VCARD
  524. VERSION:2.1
  525. N:Aprenom2;Anom2;;
  526. FN:Aprenom2 Anom2
  527. EMAIL;TYPE=home:[email protected]
  528. EMAIL;TYPE=work:[email protected]
  529. TEL;TYPE=home:+33 1 23 45 67 89
  530. TEL;TYPE=work:+33 9 12 34 76 78
  531. TEL;TYPE=cell:+33 6 56 78 12 34
  532. ADR;TYPE=home:rue D;rue D étendue;ville D;paca D;12345;france
  533. ADR;TYPE=work:rue T;rue T étendue;ville T;paca T;23456;france
  534. URL;VALUE=URI:www.xxx.com
  535. NOTE:note lig 1 note lig 2 note lig 3
  536. BDAY:2020-01-05 00:00:00
  537. END:VCARD
  538. BEGIN:VCARD
  539. VERSION:2.1
  540. N:Aprenom3;Anom3;;
  541. FN:Aprenom3 Anom3
  542. TEL;TYPE=cell:+33 6 12 34 56 78
  543. END:VCARD
  544. BEGIN:VCARD
  545. VERSION:2.1
  546. N:Aprenom5;Anom5;;
  547. FN:Aprenom5 Anom5
  548. TEL;TYPE=work:+33 9 87 65 43 21
  549. END:VCARD
  550. BEGIN:VCARD
  551. VERSION:2.1
  552. N:Aprenom4;Anom4;;
  553. FN:Aprenom4 Anom4
  554. TEL;TYPE=home:+33 1 23 45 67 89
  555. TEL;TYPE=work:+33 9 12 34 56 78
  556. TEL;TYPE=cell:+33 6 87 65 43 21
  557. END:VCARD
  558. BEGIN:VCARD
  559. VERSION:2.1
  560. N:Aprenom7;Anom7;;
  561. FN:Aprenom7 Anom7
  562. TEL;TYPE=home:+33 1 23 45 67 89
  563. END:VCARD
  564. BEGIN:VCARD
  565. VERSION:2.1
  566. N:;Aprenom Anom;;
  567. FN:Aprenom Anom
  568. EMAIL;TYPE=home:[email protected]
  569. EMAIL;TYPE=work:[email protected]
  570. EMAIL;TYPE=OTHER:[email protected]
  571. TEL;TYPE=home:+33 9 12 34 56 78
  572. TEL;TYPE=work:+33 9 87 65 43 21
  573. TEL;TYPE="fax,home":+33 8 12 34 56 78
  574. TEL;TYPE="fax,work":+33 8 87 65 43 21
  575. TEL;TYPE=cell:+33 6 12 56 34 78
  576. ADR;TYPE=home:rueD;;VILLED;;01234;
  577. ADR;TYPE=work:rueT;;VilleT;;34567;
  578. NOTE:notes en tout genre AAAAAA aaaaaa
  579. BDAY:2019-12-18 00:00:00
  580. END:VCARD
  581. BEGIN:VCARD
  582. VERSION:2.1
  583. FN:Aprenom6 Anom6
  584. TEL;TYPE=home:+33 1 23 45 67 89
  585. END:VCARD
  586.                 </pre>
  587.             </div>
  588.         </div>
  589.     </body>
  590. </html>
  591. ';
  592. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!