Import.php - Schedules Error

[CN@ndo]

Hello friends,

I have a problem to import my schedule.

I am importing only 200 at a time.

What the problem? because of the error?

[Jeff]

Your "Flight Time" in your .csv are all showing 1. You need to add the flight times together and place them in each cell. You can't have just one number in it. it needs to read something like this (in military time) Ex: 05:14 10:55

[CN@ndo]

Look at my routes,

I changed according bout what you said, plus the error continues.

I can not import.

[Jeff]

Right-click the "K" column so it hi-lights the whole column. Click "Format Cells".

"General" should be hi-lighted, click "Time"

Click 13:30 in the list.

Click OK.

You should now be able to insert time in those boxes.

[CN@ndo]

Jeff,

Thanks for the response

I have changed and the problem continues.

This is the error when importing:

The company's code is correct.

I exported the flights registered, when I import them the problem is the same.

The Import of PHPvms work or just for SQL?

Thank you for Help.

[Jeff]

can you zip your .csv and post it here so I can look at it? I think your problem resides in there.

[CN@ndo]

can you zip your .csv and post it here so I can look at it? I think your problem resides in there.

My Schedule here.

[Jeff]

I made the changes for you. You still have a lot of schedules that need to have their registration numbers added. You need to add those before you try uploading the .csv to your site.

http://www.virtualflightzone.net/files/rotas.zip

[CN@ndo]

I made the changes for you. You still have a lot of schedules that need to have their registration numbers added. You need to add those before you try uploading the .csv to your site.

http://www.virtualfl...files/rotas.zip

The error continues Jeff,

you can upload your file import.php

[Jeff]

What does line 90 say in /admin/modules/Import/Import.php

By the looks of it, you changed your Import.php file and it should actually be line 91 (which should say

set_time_limit(270);

)

[CN@ndo]

My Script

<?php
/**
* phpVMS - Virtual Airline Administration Software
* Copyright (c) 2008 Nabeel Shahzad
* For more information, visit www.phpvms.net
*	Forums: http://www.phpvms.net/forum
*	Documentation: http://www.phpvms.net/docs
*
* phpVMS is licenced under the following license:
*   Creative Commons Attribution Non-commercial Share Alike (by-nc-sa)
*   View license.txt in the root, or visit http://creativecommons.org/licenses/by-nc-sa/3.0/
*
* @author Nabeel Shahzad
* @copyright Copyright (c) 2008, Nabeel Shahzad
* @link http://www.phpvms.net
* @license http://creativecommons.org/licenses/by-nc-sa/3.0/
*/

class Import extends CodonModule
{
function HTMLHead()
{		
	switch($this->controller->function)
	{
		case '':
		default:
		case 'processimport':

			$this->set('sidebar', 'sidebar_import.tpl');

			break;
	}
}

public function index()
{
	$this->render('import_form.tpl');
}

public function export()
{
	$this->render('export_form.tpl');
}

public function processexport()
{
	$export='';
	$all_schedules = SchedulesData::GetSchedules('', false);

	if(!$all_schedules)
	{
		echo 'No schedules found!';
		return;
	}

	header('Content-Type: text/plain');
	header('Content-Disposition: attachment; filename="schedules.csv"');

	$fp = fopen('php://output', 'w');

	$line=file_get_contents(SITE_ROOT.'/admin/lib/template.csv');
	fputcsv($fp, explode(',', $line));

	foreach($all_schedules as $s)
	{
		$line ="{$s->code},{$s->flightnum},{$s->depicao},{$s->arricao},"
				."{$s->route},{$s->registration},{$s->flightlevel},{$s->distance},"
				."{$s->deptime}, {$s->arrtime}, {$s->flighttime}, {$s->notes}, "
				."{$s->price}, {$s->flighttype}, {$s->daysofweek}, {$s->enabled}";

		fputcsv($fp, explode(',', $line));
	}

	fclose($fp);
}

public function processimport()
{
	echo '<h3>Processing Import</h3>';

	if(!file_exists($_FILES['uploadedfile']['tmp_name']))
	{
		$this->set('message', 'File upload failed!');
		$this->render('core_error.tpl');
		return;
	}

	echo '<p><strong>DO NOT REFRESH OR STOP THIS PAGE</strong></p>';

	set_time_limit(270);
	$errs = array();
	$skip = false;

	$fp = fopen($_FILES['uploadedfile']['tmp_name'], 'r');

	if(isset($_POST['header'])) $skip = true;

	/* Delete all schedules before doing an import */
	if(isset($_POST['erase_routes']))
	{
		SchedulesData::deleteAllSchedules();
	}


	$added = 0;
	$updated = 0;
	$total = 0;
	echo '<div style="overflow: auto; height: 400px; border: 1px solid #666; margin-bottom: 20px; padding: 5px; padding-top: 0px; padding-bottom: 20px;">';

	while($fields = fgetcsv($fp, 1000, ','))
	{
		// Skip the first line
		if($skip == true)
		{
			$skip = false;
			continue;
		}

		// list fields:
		$code = $fields[0];
		$flightnum = $fields[1];
		$depicao = $fields[2];
		$arricao = $fields[3];
		$route = $fields[4];
		$aircraft = $fields[5];
		$flightlevel = $fields[6];
		$distance = $fields[7];
		$deptime = $fields[8];
		$arrtime = $fields[9];
		$flighttime = $fields[10];
		$notes = $fields[11];
		$price = $fields[12];
		$flighttype = $fields[13];
		$daysofweek = $fields[14];
		$enabled = $fields[15];

		if($code == '')
		{
			continue;
		}

		// Check the code:
		if(!OperationsData::GetAirlineByCode($code))
		{
			echo "Airline with code $code does not exist! Skipping...<br />";
			continue;
		}

		// Make sure airports exist:
		if(!($depapt = OperationsData::GetAirportInfo($depicao)))
		{
			$this->get_airport_info($depicao);
		}

		if(!($arrapt = OperationsData::GetAirportInfo($arricao)))
		{
			$this->get_airport_info($arricao);			
		}

		# Check the aircraft
		$aircraft = trim($aircraft);
		$ac_info = OperationsData::GetAircraftByReg($aircraft);

		# If the aircraft doesn't exist, skip it
		if(!$ac_info)
		{
			echo 'Aircraft "'.$aircraft.'" does not exist! Skipping<br />';
			continue;
		}
		$ac = $ac_info->id;

		if($flighttype == '')
		{
			$flighttype = 'P';
		}

		if($daysofweek == '')
			$daysofweek = '0123456';

		// Replace a 7 (Sunday) with 0 (since PHP thinks 0 is Sunday)
		$daysofweek = str_replace('7', '0', $daysofweek);

		# Check the distance

		if($distance == 0 || $distance == '')
		{
			$distance = OperationsData::getAirportDistance($depicao, $arricao);
		}

		$flighttype = strtoupper($flighttype);

		if($enabled == '0')
			$enabled = false;
		else
			$enabled = true;

		# This is our 'struct' we're passing into the schedule function
		#	to add or edit it

		$data = array(	'code'=>$code,
						'flightnum'=>$flightnum,
						'depicao'=>$depicao,
						'arricao'=>$arricao,
						'route'=>$route,
						'aircraft'=>$ac,
						'flightlevel'=>$flightlevel,
						'distance'=>$distance,
						'deptime'=>$deptime,
						'arrtime'=>$arrtime,
						'flighttime'=>$flighttime,
						'daysofweek'=>$daysofweek,
						'notes'=>$notes,
						'enabled'=>$enabled,
						'price'=>$price,
						'flighttype'=>$flighttype);

		# Check if the schedule exists:
		if(($schedinfo = SchedulesData::getScheduleByFlight($code, $flightnum)))
		{
			# Update the schedule instead
			$val = SchedulesData::updateScheduleFields($schedinfo->id, $data);
			$updated++;
		}
		else
		{
			# Add it
			$val = SchedulesData::addSchedule($data);
			$added++;
		}

		if($val === false)
		{
			if(DB::errno() == 1216)
			{
				echo "Error adding $code$flightnum: The airline code, airports, or aircraft does not exist";
			}
			else
			{
				$error = (DB::error() != '') ? DB::error() : 'Route already exists';
				echo "$code$flightnum was not added, reason: $error<br />";
			}

			echo '<br />';
		}
		else
		{
			$total++;
			echo "Imported {$code}{$flightnum} ({$depicao} to {$arricao})<br />";
		}
	}

	CentralData::send_schedules();

	echo "The import process is complete, added {$added} schedules, updated {$updated}, for a total of {$total}<br />";

	foreach($errs as $error)
	{
		echo '    '.$error.'<br />';
	}

	echo '</div>';
}

protected function get_airport_info($icao)
{
	echo "ICAO $icao not added... retriving information: <br />";						
	$aptinfo = OperationsData::RetrieveAirportInfo($icao);

	if($aptinfo === false)
	{
		echo 'Could not retrieve information for '.$icao.', add it manually <br />';
	}
	else
	{
		echo "Found: $icao - ".$aptinfo->name
			.' ('.$aptinfo->lat.','.$aptinfo->lng.'), airport added<br /><br />';

		return $aptinfo;
	}
}
}