Mis Match Data Into Database

[gaspower]

Hello,

I am having a issue with importing a csv file into the database with a php file on my site. The csv file consists of about 225 lines of ex. (111,111,111,111,111,111,111,111,17980) which is image coordinates and at the end product number. The issue is that if I upload the complete csv file through the php file, somewhere it will mis match coordinates and items will show up in the wrong searches. But if I make the csv smaller, approx, 25-30 lines, it uploads fine. Where can I look for this issue. Is there somewhere possibly in the code that identifies the size restraint of a file upload. I know it is not the server timing out, I upload much larger files for another part of the site. Just by chance I see this in the code, but not sure if it plays any part to my issue,

if (tep_not_null($action)) {
    switch ($action) {
      case 'bulk_insert':
                   $target = "temp/";
                   $target = $target . basename($_FILES['uploaded']['name']) ;
				   $file_name = basename($_FILES['uploaded']['name']);
                   $ok=1;
                   if(move_uploaded_file($_FILES['uploaded']['tmp_name'], $target))
                   {
					$messageStack->add("The file ".$file_name . " has been uploaded", 'error');
					$image_maps_id = $HTTP_GET_VARS['iID'];
					$handle = fopen($target,"r");
					$num =0;
					while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
/*
						$top_right_x = $data[0];
						if(!$top_right_x)
							break;
						$top_right_y = $data[1];
						$bottom_left_x = $data[2];
						$bottom_left_y = $data[3];
						$product_model = $data[4];

Thanks JR

[sneakyimp]

Chances are there is an error in your data file where a coordinate got left out or something. You didn't post all your code so I'm not sure if $num is being incremented with each loop, so I put in my own line counter var. I'm also guessing that you want 9 values in each line.

...try this:

$lineNum = 0;
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
  $lineNum++;
  if (sizeof($data) != 9) {
    die('LINE NUMBER ' . $lineNum . ' HAS ' . sizeof($data) . ' VALUES';
  }

// rest of your code here.

EDIT: It might also be that some line has more than 1000 characters so you could perhaps increase that value in your fgetscv call.

[gaspower]

Hello,

Thank you very much for the reply. I tried your suggestion, but it broke the file. I attached the code as an attachment. To long for the forums set configuration. You also mentioned that $handle set to 1000 may not be enough. Is that for one line, or total file size?

Thanks JR

[sneakyimp]

I'm not going to edit your code and send it back to you. You need to figure out how to do this yourself

If you read your code (which is also incomplete) you will see the line starting with "while (($data = ...."

You should recognize that line in my code too. See if you can figure it out.

[gaspower]

Hello,

Thank you. I do want to figure it out. I thought you wanted the code uploaded to view, sorry, my misunderstanding.

Thanks JR

[gaspower]

Hey sneakyimp,

Thanks for the bit of code. At first it broke, but I realized it was missing a ")".
What seems to work is,

$lineNum = 0;
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$lineNum++;
if (sizeof($data) != 9) {
die('LINE NUMBER ' . $lineNum . ' HAS ' . sizeof($data) . ' VALUES');
}

Thanks for your time,

JR