API tools faq
paste
Advertisement
Guest User

ecureuil-php-csv-vcf-1

a guest
Jan 11th, 2020
162
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 23.27 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.     $delimiter = $_POST['_delimiter'];
  99.    
  100.     if($_FILES)
  101.     {
  102.  
  103.         if(checkExtension($allowedExts)) // MMM
  104.         {
  105.             if(($_FILES["file"]["size"] < $maximumFileSizeInBytes))
  106.             {
  107.                 if ($_FILES["file"]["error"] > 0)
  108.                 {
  109.                     echo "Return Code: " . $_FILES["file"]["error"] . "<br>";
  110.                 }
  111.                 else
  112.                 {
  113.                     echo '<div id="uploadDetails">';
  114.                     echo "Name: ".$_FILES["file"]["name"]."<br>";
  115.                     echo "Type: " . $_FILES["file"]["type"] . "<br>";
  116.                     echo "Size: " . ($_FILES["file"]["size"] / 1024) . " kB<br>";
  117.                     echo "Temp file: ".$_FILES["file"]["tmp_name"] . "<br>";
  118. //                  echo "field selector:  ".$_POST['_delimiter']."   ZZZ<br>";
  119.                     echo "field selector:  '".$delimiter."'   ZZZ<br>";
  120.                     convert($_FILES["file"]["tmp_name"]);
  121.                     echo '</div>';
  122.                 }
  123.             }
  124.             else
  125.             {
  126.                 echo "File exceeds filezie limit of ".$maximumFileSizeInBytes."kByte.";
  127.             }
  128.         }
  129.         else
  130.         {
  131.             echo "File was not a allowed filetypes: ".$allowedExts_string;
  132.         }
  133.     }
  134. }
  135. else
  136. {
  137.  
  138.     echo '
  139.  
  140.             <form method="post" enctype="multipart/form-data">
  141.                 <label for="file">Please select your File.csv then hit convert:</label>
  142.                 <input type="file" name="file" id="file" style="width: 100%;">
  143.                 <br />
  144.                 field selector :
  145.                 <select name="_delimiter" >
  146.                     <option value=" "></option>
  147.                     <option value=",">Comma</option>
  148.                     <option value=";">Semicolon</option>
  149.                     <option value=" ">Tab</option>
  150.                 </select><br />
  151.                 <input type="submit" name="convert" value="convert" style="width: 100%;">
  152.             </form>
  153.             <p>the following fields in the *.csv will be converted:</p>
  154.             <div style="overflow:auto;white-space:nowrap;width:100%;" class="codecolorer-container bash default">
  155.                 <pre>
  156. First Name
  157. Last Name
  158. Display Name
  159. Nicknam
  160. E-mail Address
  161. E-mail 2 Address
  162. E-mail 3 Address
  163. Home Phone
  164. Business Phone
  165. Home Fax
  166. Business Fax
  167. Pager
  168. Mobile Phone
  169. Home Street
  170. Home Address 2
  171. Home City
  172. Home State
  173. Home Postal Code
  174. Home Country
  175. Business Address
  176. Business Address 2
  177. Business City
  178. Business State
  179. Business Postal Code
  180. Business Country
  181. Country Code
  182. Related name
  183. Job Title
  184. Department
  185. Organization
  186. Notes
  187. Birthday
  188. Anniversary
  189. Gender
  190. Web Page
  191. Web Page 2
  192. Categories
  193.             </pre>
  194.             </div>
  195.         </div>
  196.     ';
  197. }
  198.  
  199. // <script type="text/javascript">
  200. //function set_form_fields(elem)
  201. //{
  202. //  var delimiter =   elem.options[elem.selectedIndex].value;  
  203. // elem.form._delimiter;
  204. //}
  205. //</script>
  206.  
  207. // MMM verifie que le fichier envoye a l'une des extensions de $allowedExts
  208. function checkExtension(array $allowedExts)
  209. {
  210.     $upload_filename = $_FILES["file"]["name"];
  211.     $upload_filename_array = explode(".", $upload_filename);
  212.     $extension = strtolower(end($upload_filename_array));
  213.  
  214.     $key = array_search($extension, $allowedExts);
  215.     return $key !== false;
  216. }
  217.  
  218.  
  219. function convert($filename_csv)
  220. {
  221.     // $filename_csv = "export2016.06.24.csv";
  222.    
  223.     $lines_csv = file($filename_csv);
  224.    
  225.     $filename_extension = explode('.',$filename_csv);
  226.    
  227.     $filename_vcf = "./upload/".$_FILES["file"]["name"].".vcf";
  228.    
  229.     $file_vcf = fopen($filename_vcf, 'w') or die("can't open file");
  230.    
  231.     echo '<pre>generating vCard-Version: VERSION:2.1</pre>';
  232.    
  233.     // display name;phone0;phone1;phone2;phone3;phone4;phone5;phone6;phone7;phone8;phone9;phone10;phone11;phone12;phone13;phone14;phone15;phone16;phone17;phone18;phone19;
  234.     // 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;
  235.     // pobox0;street0;city0;region0;postcode0;country0;type0;pobox1;
  236.     // 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;
  237.    
  238.     // ==== fields to match ====
  239.     // display name
  240.     // street0 city0 region0 postcode0
  241.     // phone0 phone1 phone2 phone3
  242.     // email0
  243.     // organistion0
  244.  
  245.     // 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
  246.    
  247.     // get all possible fields in android-vcf
  248.     $length = count($lines_csv);
  249.     for($i = 0;$i < $length;$i++)
  250.     {
  251.         if($i == 0)
  252.         {
  253.             $keys_csv = $lines_csv[$i];
  254. //          $keys_csv = explode($delimiter,$keys_csv);
  255.             $keys_csv = explode($_POST['_delimiter'],$keys_csv);
  256. //          $keys_csv = explode(";",$keys_csv);
  257.         }
  258.         else
  259.         {
  260.             fwrite($file_vcf, "BEGIN:VCARD\n"); // what Version does this file have
  261.             fwrite($file_vcf, "VERSION:2.1\n"); // what Version does this file have
  262.    
  263.             $values_csv = $lines_csv[$i];
  264. //          $values_csv = explode($delimiter,$values_csv);
  265.             $values_csv = explode($_POST['_delimiter'],$values_csv);
  266. //          $values_csv = explode(";",$values_csv);
  267.    
  268.             $position1 = findPos("First Name", $keys_csv);
  269.             $position2 = findPos("Last Name", $keys_csv);
  270.             $position = $values_csv[$position1] . ";" . $values_csv[$position2]. ";;" ;
  271.             if ( ( $position ) !== ";;;")
  272.             {
  273.                 fwrite($file_vcf, "N:".$position."\n"); // N:Gump;Forrest;;Mr.
  274.             }          
  275.  
  276.             $position3 = findPos("Display Name", $keys_csv);
  277.             $position = $values_csv[$position3];
  278.             if ( !empty( $position ) )
  279.             {
  280.                 fwrite($file_vcf, "FN:".$position."\n"); // FN:Forrest Gump
  281.             }          
  282.            
  283.             $position3 = findPos("E-mail Address", $keys_csv);
  284.             $position = $values_csv[$position3];
  285.             if ( !empty( $position ) )
  286.             {
  287.                 fwrite($file_vcf, "EMAIL;TYPE=home:".$position."\n");
  288.             }
  289.  
  290.             $position3 = findPos("E-mail 2 Address", $keys_csv);
  291.             $position = $values_csv[$position3];
  292.             if ( !empty( $position ) )
  293.             {
  294.                 fwrite($file_vcf, "EMAIL;TYPE=work:".$position."\n");
  295.             }
  296.  
  297.             $position3 = findPos("E-mail 3 Address", $keys_csv);
  298.             $position = $values_csv[$position3];
  299.             if ( !empty( $position ) )
  300.             {
  301.                 fwrite($file_vcf, "EMAIL;TYPE=OTHER:".$position."\n");
  302.             }
  303.    
  304.             // ORG:Bubba Gump Shrimp Co.
  305.             // TITLE:Shrimp Man
  306.             // PHOTO;GIF:http://www.example.com/dir_photos/my_photo.gif
  307.            
  308.             // if phone1 differs from phone0
  309.             $position = findPos("Home Phone", $keys_csv);
  310.             $phone0 = $values_csv[$position];
  311.             if ( !empty( $phone0 ) )
  312.             {
  313.                 fwrite($file_vcf, "TEL;TYPE=home:".$phone0."\n"); // phone0
  314.             }          
  315.  
  316.             $position = findPos("Business Phone", $keys_csv);
  317.             $phone1 = $values_csv[$position];
  318.             if ( !empty( $phone1 ) )
  319.             {
  320.                 fwrite($file_vcf, "TEL;TYPE=work:".$phone1."\n"); // phone1
  321.             }
  322.  
  323.             $position = findPos("Home Fax", $keys_csv);
  324.             $phone2 = $values_csv[$position];
  325.             if ( !empty( $phone2 ) )
  326.             {
  327.                 fwrite($file_vcf, 'TEL;TYPE="fax,home":'.$phone2."\n"); // phone2
  328.             }
  329.             $position = findPos("Business Fax", $keys_csv);
  330.             $phone3 = $values_csv[$position];
  331.             if ( !empty( $phone3 ) )
  332.             {
  333.                 fwrite($file_vcf, 'TEL;TYPE="fax,work":'.$phone3."\n"); // phone2
  334.             }
  335.  
  336.             $position = findPos("Mobile Phone", $keys_csv);
  337.             $phone4 = $values_csv[$position];
  338.             if ( !empty( $phone4 ) )
  339.             {
  340.                 fwrite($file_vcf, "TEL;TYPE=cell:".$phone4."\n"); // phone3
  341.             }
  342.  
  343.             // ADR;HOME;PREF:;;100 Waters Edge;Baytown;LA;30314;United States of America
  344.             $street0 = $values_csv[findPos("Home Street", $keys_csv)];
  345.             $street1 = $values_csv[findPos("Home Address 2", $keys_csv)];
  346.             $city0 = $values_csv[findPos("Home City", $keys_csv)];
  347.             $region0 = $values_csv[findPos("Home State", $keys_csv)];
  348.             $postcode0 = $values_csv[findPos("Home Postal Code", $keys_csv)];
  349.             $country0 = $values_csv[findPos("Home Country", $keys_csv)];
  350.            
  351.             if ( ( !empty( $street0 ) ) || ( !empty( $street1 ) ) || ( !empty( $city0 ) ) || ( !empty( $region0 ) ) || ( !empty( $postcode0 ) ) || ( !empty( $country0 ) ) )
  352.             {          
  353.                 fwrite($file_vcf, "ADR;TYPE=home:".$street0.";".$street1.";".$city0.";".$region0.";".$postcode0.";".$country0."\n");
  354.             }
  355.    
  356.             // ADR;WORK;PREF:;;100 Waters Edge;Baytown;LA;30314;United States of America
  357.             $street0 = $values_csv[findPos("Business Address", $keys_csv)];
  358.             $street1 = $values_csv[findPos("Business Address 2", $keys_csv)];
  359.             $city0 = $values_csv[findPos("Business City", $keys_csv)];
  360.             $region0 = $values_csv[findPos("Business State", $keys_csv)];
  361.             $postcode0 = $values_csv[findPos("Business Postal Code", $keys_csv)];
  362.             $country0 = $values_csv[findPos("Business Country", $keys_csv)];
  363.  
  364.             if ( ( !empty( $street0 ) ) || ( !empty( $street1 ) ) || ( !empty( $city0 ) ) || ( !empty( $region0 ) ) || ( !empty( $postcode0 ) ) || ( !empty( $country0 ) ) )
  365.             {              
  366.                 fwrite($file_vcf, "ADR;TYPE=work:".$street0.";".$street1.";".$city0.";".$region0.";".$postcode0.";".$country0."\n");
  367.             }
  368.  
  369.             // LABEL;WORK;PREF;ENCODING=QUOTED-PRINTABLE;CHARSET=UTF-8:100 Waters Edge=0D==0 ABaytown\, LA 30314=0D=0AUnited States of America
  370.             // ADR;HOME:;;42 Plantation St.;Baytown;LA;30314;United States of America
  371.             // LABEL;HOME;ENCODING=QUOTED-PRINTABLE;CHARSET=UTF-8:42 Plantation St.=0D=0A=
  372.             // Baytown, LA 30314=0D=0AUnited States of America
  373.  
  374.             // Web page
  375.             $position = findPos("Web Page", $keys_csv);
  376.             if ( !empty( $values_csv[$position] ) )
  377.             {
  378.                 fwrite($file_vcf, "URL;VALUE=URI:".$values_csv[$position]."\n"); // email0 // EMAIL:
  379.             }
  380.  
  381.             // Web page
  382.             $position = findPos("Web Page 2", $keys_csv);
  383.             if ( !empty( $values_csv[$position] ) )
  384.             {
  385.                 fwrite($file_vcf, "URL;VALUE=URI:".$values_csv[$position]."\n"); // email1 // EMAIL:
  386.             }
  387.            
  388.             // NOTE
  389.             $position = findPos("Notes", $keys_csv);
  390.             if ( !empty( $values_csv[$position] ) )
  391.             {
  392.                 fwrite($file_vcf, "NOTE:".$values_csv[$position]."\n");
  393.             }
  394.  
  395.             // Birthday
  396.             $position = findPos("Birthday", $keys_csv);
  397.             if ( !empty( $values_csv[$position] ) )
  398.             {
  399.                 fwrite($file_vcf, "BDAY:".$values_csv[$position]."\n");
  400.             }
  401.  
  402.             // Categories
  403.             $position = findPos("Categories", $keys_csv);
  404.             if ( !empty( $values_csv[$position] ) )
  405.             {
  406.                 fwrite($file_vcf, "CATEGORIES :".$values_csv[$position]."\n"); // email0 // EMAIL:
  407.             }
  408.  
  409.             fwrite($file_vcf, "END:VCARD"."\n"); // END:VCARD
  410.         }
  411.     }
  412.    
  413.     fclose($file_vcf);
  414.  
  415.     // move_uploaded_file($_FILES["file"]["tmp_name"],"upload/".$_FILES["file"]["name"]);
  416.  
  417.     echo "<pre> ".$length." entries transformed</pre>";
  418.    
  419.     echo '<span style="color: green; font-weight: bold;">Please DOWNLOAD RESULT: <a href="'.$filename_vcf.'">'.$filename_vcf.'</a></span>'; // $_FILES["file"]["name"]
  420.  
  421.     echo '<h1><a href="index.php">Do it again</a></h1>';
  422.     // header("Content-type: text/plain");
  423.     // header('Content-Disposition: attachment; filename="'.$filename_vcf.'"');
  424.  
  425.     /*
  426.     echo '<h1>The result will selfdestruct in 60 seconds</h1>';
  427.     sleep(60);
  428.    
  429.     if(!unlink($filename_vcf))
  430.     {
  431.         echo ("Error deleting ".$filename_vcf);
  432.     }
  433.     else
  434.     {
  435.         echo ("Deleted ".$filename_vcf);
  436.     }
  437.     */
  438. }
  439.  
  440. /* determine position of a value in an number-indexed array */
  441. function findPos($value,$array)
  442. {
  443.     $result = null;
  444.     $length = count($array);
  445.     for($i=0;$i<$length;$i++)
  446.     {
  447.         if($array[$i] == $value)
  448.         {
  449.             $result = $i;
  450.             break;
  451.         }
  452.     }
  453.    
  454.     return $result;
  455. }
  456.  
  457. echo '
  458.         </div>
  459.         <div class="boxShadows" id="headline">';
  460.        
  461. if ($_POST['_delimiter'] == ';')
  462. {
  463.     echo '
  464.         <p>EXAMPLE INPUT with ";" : this goes in:</p>
  465.             <div style="overflow:auto;white-space:nowrap;width:100%;" class="codecolorer-container bash default">
  466.                 <pre>
  467. 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
  468. 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
  469. 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
  470. Aprenom3;Anom3;Aprenom3 Anom3;;;;;;;;;;+33 6 12 34 56 78;;;;;;;;;;;;;;;;;;;;;;;;test
  471. Aprenom5;Anom5;Aprenom5 Anom5;;;;;;+33 9 87 65 43 21;;;;;;;;;;;;;;;;;;;;;;;;;;;;test
  472. Aprenom4;Anom4;Aprenom4 Anom4;;;;;+33 1 23 45 67 89;+33 9 12 34 56 78;;;;+33 6 87 65 43 21;;;;;;;;;;;;;;;;;;;;;;;;test
  473. Aprenom7;Anom7;Aprenom7 Anom7;;;;;+33 1 23 45 67 89;;;;;;;;;;;;;;;;;;;;;;;;;;;;;test
  474. ;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
  475. ;;Aprenom6 Anom6;;;;;+33 1 23 45 67 89;;;;;;;;;;;;;;;;;;;;;;;;;;;;;test
  476.                 </pre>
  477.             </div>';
  478. }
  479. else  
  480.     if ($_POST['_delimiter'] == '\t')
  481.     {
  482.     echo '
  483.         <p>EXAMPLE INPUT with " " : this goes in:</p>
  484.             <div style="overflow:auto;white-space:nowrap;width:100%;" class="codecolorer-container bash default">      
  485. 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
  486. 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
  487. 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
  488. Aprenom3    Anom3   Aprenom3 Anom3                                      +33 6 12 34 56 78                                                                                               test
  489. Aprenom5    Anom5   Aprenom5 Anom5                      +33 9 87 65 43 21                                                                                                               test
  490. Aprenom4    Anom4   Aprenom4 Anom4                  +33 1 23 45 67 89   +33 9 12 34 56 78               +33 6 87 65 43 21                                                                                               test
  491. Aprenom7    Anom7   Aprenom7 Anom7                  +33 1 23 45 67 89                                                                                                                   test
  492.     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
  493.         Aprenom6 Anom6                  +33 1 23 45 67 89                                                                                                                   test
  494.                 </pre>
  495.             </div>';
  496.     }
  497.     else
  498.     {
  499.     echo '
  500.         <p>EXAMPLE INPUT with "," : this goes in:</p>
  501.             <div style="overflow:auto;white-space:nowrap;width:100%;" class="codecolorer-container bash default">
  502.                 <pre>
  503. 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
  504. 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
  505. 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
  506. Aprenom3,Anom3,Aprenom3 Anom3,,,,,,,,,,+33 6 12 34 56 78,,,,,,,,,,,,,,,,,,,,,,,,test
  507. Aprenom5,Anom5,Aprenom5 Anom5,,,,,,+33 9 87 65 43 21,,,,,,,,,,,,,,,,,,,,,,,,,,,,test
  508. Aprenom4,Anom4,Aprenom4 Anom4,,,,,+33 1 23 45 67 89,+33 9 12 34 56 78,,,,+33 6 87 65 43 21,,,,,,,,,,,,,,,,,,,,,,,,test
  509. Aprenom7,Anom7,Aprenom7 Anom7,,,,,+33 1 23 45 67 89,,,,,,,,,,,,,,,,,,,,,,,,,,,,,test
  510. ,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
  511. ,,Aprenom6 Anom6,,,,,+33 1 23 45 67 89,,,,,,,,,,,,,,,,,,,,,,,,,,,,,test
  512.                 </pre>
  513.             </div>';
  514.     }
  515.  
  516. echo '
  517.         </div>
  518.         <div class="boxShadows" id="headline">
  519.         <p>this comes out: (this is what android contact book understands)</p>
  520.             <div style="overflow:auto;white-space:nowrap;width:100%;" class="codecolorer-container bash default">
  521.                 <pre>
  522. BEGIN:VCARD
  523. VERSION:2.1
  524. N:Aprenom1 Anom1;;;
  525. FN:Aprenom1 Anom1
  526. EMAIL;TYPE=home:[email protected]
  527. EMAIL;TYPE=work:[email protected]
  528. TEL;TYPE=home:+33 1 23 45 67 89
  529. TEL;TYPE=work:+33 2 87 65 43 21
  530. TEL;TYPE="fax,home":+33 9 12 34 56 78
  531. TEL;TYPE="fax,work":+33 9 87 65 43 21
  532. TEL;TYPE=cell:+33 6 12 34 56 78
  533. ADR;TYPE=home:rue1;rue2;meylan;rhone alpes;38240;france
  534. ADR;TYPE=work:rue1T;rue2T;Grenoble;isere;38000;france
  535. NOTE:notes
  536. BDAY:1604-12-08 00:00:00
  537. END:VCARD
  538. BEGIN:VCARD
  539. VERSION:2.1
  540. N:Aprenom2;Anom2;;
  541. FN:Aprenom2 Anom2
  542. EMAIL;TYPE=home:[email protected]
  543. EMAIL;TYPE=work:[email protected]
  544. TEL;TYPE=home:+33 1 23 45 67 89
  545. TEL;TYPE=work:+33 9 12 34 76 78
  546. TEL;TYPE=cell:+33 6 56 78 12 34
  547. ADR;TYPE=home:rue D;rue D étendue;ville D;paca D;12345;france
  548. ADR;TYPE=work:rue T;rue T étendue;ville T;paca T;23456;france
  549. URL;VALUE=URI:www.xxx.com
  550. NOTE:note lig 1 note lig 2 note lig 3
  551. BDAY:2020-01-05 00:00:00
  552. END:VCARD
  553. BEGIN:VCARD
  554. VERSION:2.1
  555. N:Aprenom3;Anom3;;
  556. FN:Aprenom3 Anom3
  557. TEL;TYPE=cell:+33 6 12 34 56 78
  558. END:VCARD
  559. BEGIN:VCARD
  560. VERSION:2.1
  561. N:Aprenom5;Anom5;;
  562. FN:Aprenom5 Anom5
  563. TEL;TYPE=work:+33 9 87 65 43 21
  564. END:VCARD
  565. BEGIN:VCARD
  566. VERSION:2.1
  567. N:Aprenom4;Anom4;;
  568. FN:Aprenom4 Anom4
  569. TEL;TYPE=home:+33 1 23 45 67 89
  570. TEL;TYPE=work:+33 9 12 34 56 78
  571. TEL;TYPE=cell:+33 6 87 65 43 21
  572. END:VCARD
  573. BEGIN:VCARD
  574. VERSION:2.1
  575. N:Aprenom7;Anom7;;
  576. FN:Aprenom7 Anom7
  577. TEL;TYPE=home:+33 1 23 45 67 89
  578. END:VCARD
  579. BEGIN:VCARD
  580. VERSION:2.1
  581. N:;Aprenom Anom;;
  582. FN:Aprenom Anom
  583. EMAIL;TYPE=home:[email protected]
  584. EMAIL;TYPE=work:[email protected]
  585. EMAIL;TYPE=OTHER:[email protected]
  586. TEL;TYPE=home:+33 9 12 34 56 78
  587. TEL;TYPE=work:+33 9 87 65 43 21
  588. TEL;TYPE="fax,home":+33 8 12 34 56 78
  589. TEL;TYPE="fax,work":+33 8 87 65 43 21
  590. TEL;TYPE=cell:+33 6 12 56 34 78
  591. ADR;TYPE=home:rueD;;VILLED;;01234;
  592. ADR;TYPE=work:rueT;;VilleT;;34567;
  593. NOTE:notes en tout genre AAAAAA aaaaaa
  594. BDAY:2019-12-18 00:00:00
  595. END:VCARD
  596. BEGIN:VCARD
  597. VERSION:2.1
  598. FN:Aprenom6 Anom6
  599. TEL;TYPE=home:+33 1 23 45 67 89
  600. END:VCARD
  601.                 </pre>
  602.             </div>
  603.         </div>
  604.     </body>
  605. </html>
  606. ';
  607. ?>
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!