API tools faq
paste
Advertisement
Guest User

ecureuil-php-csv-vcf-2

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