jpatokal / openflights

Website for storing flight information, rendering paths on a zoomable world map and calculating statistics, with plenty of free airline, airport and route data.
http://openflights.org
GNU Affero General Public License v3.0
1.38k stars 389 forks source link

[Bug] Missing first 9 characters when importing from flightmemory [sf#138] #138

Open jpatokal opened 9 years ago

jpatokal commented 9 years ago

*Reported by anonymous on 2012-07-26 07:31 UTC** When I import my flights from Flight memory the first 9 characters of "comments" get missed.

Tmpfile phpCmeth4

jpatokal commented 9 years ago

Commented by nobody on 2012-07-26 07:31 UTC Flight memory Data. Attached file FlightMemory%20-%20FlightData.htm:

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<!-- saved from url=(0057)http://www.flightmemory.com/signin/?go=flugdaten;r=361486 -->
<html><head><meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"><meta http-equiv="content-language" content="en"><title>FlightMemory - FlightData</title><meta name="author" content="Heret Informatik Service - www.heret.de - www.flugstatistik.de"><link rel="stylesheet" type="text/css" href="./FlightMemory - FlightData_files/style.css" media="screen"></head><body><div class="wrap clearfix">  <div class="header"><a href="http://www.flightmemory.com/signin/?go=menu"><img src="./FlightMemory - FlightData_files/d.gif" alt="" width="205" height="123" border="0" align="left"></a><img src="./FlightMemory - FlightData_files/d.gif" alt="" width="250" height="78" border="0"><br><h2>Where in the world have you flown?<br>How long have you been in the air?<br>Create your own FlightMemory and see!</h2></div> 
  <div class="topnav" id="nav">  <ul>  <li><a href="http://www.flightmemory.com/signin/?go=menu">HOME</a></li>  
  <li><a href="http://www.flightmemory.com/signin/?go=flugdaten;r=65448" class="aktiv">FLIGHTDATA</a></li>  <li><a href="http://www.flightmemory.com/signin/?go=statistik;r=65448">STATISTICS</a></li><li><a href="http://www.flightmemory.com/signin/?go=poster">POSTER</a></li><li><a href="http://www.flightmemory.com/signin/?go=shop"><i>SHOP</i></a></li>  <li><a href="http://www.flightmemory.com/signin/?go=profil">PROFILE</a></li>  <li><a href="http://www.flightmemory.com/signin/?go=premium">PREMIUM</a></li><li><a href="http://www.flightmemory.com/signin/?go=community">COMMUNITY</a></li><li><a href="http://www.flightmemory.com/signin/?go=news">NEWS</a></li><li><a href="http://www.flightmemory.com/signin/?go=kontakt">CONTACT</a></li>  
<li><a href="http://www.flightmemory.com/signin/?go=invite">INVITE</a></li>  <li><a href="http://www.flightmemory.com/signin/?go=logout">LOGOUT</a></li>  </ul>  <ul><li><img src="./FlightMemory - FlightData_files/dummy.gif" width="48" height="1"></li>  <li><a href="http://www.flightmemory.com/signin/?go=flugdaten_neu;r=65448">New flight</a></li>  <li><a href="http://www.flightmemory.com/signin/?go=landeplatz;r=65448">Unique airports</a></li>  <li><a href="http://www.flightmemory.com/signin/?go=flugdaten_suche">Search in all flights</a></li>  
  <li><a href="http://www.flightmemory.com/signin/?go=import">Import your flights</a></li>  </ul>  </div><br><br><br><script src="./FlightMemory - FlightData_files/pubcode.min.js"></script><script type="text/javascript">document.write('<scr' + 'ipt type="text/javascript">(function () {try{VCM.media.render({sid:39794,media_type:5,version:"1.1"});} catch(e){document.write(\'<scr\' + \'ipt type="text/javascript" src="http://media.fastclick.net/w/get.media?sid=39794&tp=5&d=j&t=n&exc=1"></scr\' + \'ipt>\');}}());</scr' + 'ipt>');</script><script type="text/javascript">(function () {try{VCM.media.render({sid:39794,media_type:5,version:"1.1"});} catch(e){document.write('<scr' + 'ipt type="text/javascript" src="http://media.fastclick.net/w/get.media?sid=39794&tp=5&d=j&t=n&exc=1"></scr' + 'ipt>');}}());</script><div id="vcmad_75320"></div><script src="./FlightMemory - FlightData_files/get.media" type="text/javascript"></script><a href="http://media.fastclick.net/w/click.here?cid=319165&mid=724845&m=1&sid=39794&c=0&tp=5" target="_blank"><img src="./FlightMemory - FlightData_files/media724845.gif" border="0" width="728" height="90" alt="Click Here"></a>
<noscript>&lt;a href="http://media.fastclick.net/w/click.here?sid=39794&amp;m=1&amp;c=1" target="_blank"&gt;&lt;img src="http://media.fastclick.net/w/get.media?sid=39794&amp;tp=5&amp;d=s&amp;c=1&amp;vcm_acv=1.1" width=728 height=90 border=1&gt;&lt;/a&gt;</noscript><img src="./FlightMemory - FlightData_files/d.gif" width="1" height="6"><br><div class="container clearfix"><table width="100%" border="0" cellspacing="0" cellpadding="0"><tbody><tr><td><h3>FlightData</h3></td><td align="center"><table border="0" cellspacing="0" cellpadding="0"><tbody><tr><td>Sorting:&nbsp;</td><form action="" method="post"></form><td valign="top"><input type="hidden" name="go" value="flugdaten"><input type="hidden" name="dbpos" value="0"><select name="order_box"><option value="datum">last flight first</option><option value="datum">Departure</option><option value="ab_3letter">&nbsp; &nbsp;Airportcode</option><option value="ab_ort">&nbsp; &nbsp;Location (City)</option><option value="ab_land">&nbsp; &nbsp;Country</option><option value="ab_name">&nbsp; &nbsp;Name</option><option value="ab_zeit">&nbsp; &nbsp;Time</option><option value="datum">Arrival</option><option value="an_3letter">&nbsp; &nbsp;Airportcode</option><option value="an_ort">&nbsp; &nbsp;Location (City)</option><option value="an_land">&nbsp; &nbsp;Country</option><option value="an_name">&nbsp; &nbsp;Name</option><option value="an_zeit">&nbsp; &nbsp;Time</option><option>Miscellaneous</option><option value="entfernung">&nbsp; &nbsp;Distance</option><option value="dauer">&nbsp; &nbsp;Duration</option><option value="airline">&nbsp; &nbsp;Airline</option><option value="fnr">&nbsp; &nbsp;Flight number</option><option value="flugzeug">&nbsp; &nbsp;Airplane (type)</option><option value="lfkz">&nbsp; &nbsp;Registration</option><option value="sitzplatz">&nbsp; &nbsp;Seat</option><option value="sitztyp">&nbsp; &nbsp;Seat type</option><option value="klasse">&nbsp; &nbsp;Travel classes</option><option value="taufname">&nbsp; &nbsp;Airplane name</option></select><input type="submit" value="go"><input type="checkbox" name="absteigend" value="1">descending
</td></tr></tbody></table></td><form method="post"></form><td valign="top"><input type="hidden" name="go" value="flugdaten"><input type="hidden" name="order" value="">Page: <select name="dbpos" onchange="submit();"><option value="0" selected="">1</option></select></td><td align="right"><img src="./FlightMemory - FlightData_files/first2.gif" width="15" height="14" border="0"><img src="./FlightMemory - FlightData_files/previous2.gif" width="12" height="14" border="0">      &nbsp;

The file could not be attached: 'ascii' codec can't decode byte 0xdf in position 1683: ordinal not in range(128)

jpatokal commented 9 years ago

*Commented by anonymous on 2013-05-17 10:23 UTC** Same here, but keep up the great work!

jpatokal commented 9 years ago

*Commented by anonymous on 2013-11-07 17:53 UTC** I have the same problem. 1st nine characters missing.

reedy commented 1 year ago

I wonder if this is still an issue...