Csv file not not importing all records

PHP
1

hi

i used for importing records from xml files of different sizes, it worked fine.

but wen i used csv file importing, server is giving ‘internal serer error 500’.

One of my friend told me to keep sleep function to give chance to another processes/ threads.

Earlier code looks like this,

function myRecordHandler($record)
{
global $productRecord;

$productRecord = $record;

return 1;

}

I added some extra code to overcome 500 internal error, like this

function myRecordHandler($record)
{
global $productRecord;

 global $counter;
 
  $counter++;
  if (!($counter % 100))
  {
	
	flush(); 
	sleep(1);
  }


$productRecord = $record;

return 1;

}

:rofl:still it is showing internal errors…

please help…

Thanks in Advance,
Sunil.

2

I don’t see how your code is importing anything.

3

i just kept a part of the message…, because import coding is in multiple pages…

4

lets say like this,

<?php
set_time_limit(0);
require (“MagicParser.php”);
//database connection
$conn = mysql_connect(“localhost”, “user”, “pass”);
mysql_select_db(“database”, $conn);
$link = “./folder/product.csv”;
//variables
$jpg = “.jpg”;
//set delete me to only delete old stock
$sql = “UPDATE cubecart_inventory SET Delete_Me = ‘1’ WHERE Company_name = ‘company’”;
mysql_query($sql);
function myRecordHandler($record) {
global $jpg;
$sql = “SELECT productId FROM cubecart_inventory WHERE productCode = '”.mysql_escape_string($record[“midw_part_no”]).“'”;
$result = mysql_query($sql);
if (mysql_num_rows($result)) {
$sql = “UPDATE cubecart_inventory SET
stock_level = '”.mysql_escape_string($record[“stock”]).“',
Delete_Me = '”.mysql_escape_string(“0”).“’
WHERE productCode = '”.mysql_escape_string($record[“midw_part_no”]).“'”;
} else {
$sql = “INSERT INTO cubecart_inventory SET
Company_name = '”.mysql_escape_string(“company”).“',
productCode = '”.mysql_escape_string($record[“midw_part_no”]).“',
price = '”.mysql_escape_string($record[“cost”]).“',
stock_level = '”.mysql_escape_string($record[“stock”]).“',
name = '”.mysql_escape_string($record[“product_name”]).“',
prodWeight = '”.mysql_escape_string($record[“weight”]).“',
eanupcCode = '”.mysql_escape_string($record[“barcode”]).“',
image = '”.mysql_escape_string($record[“midw_part_no”]).“$jpg’,
description = '”.mysql_escape_string($record[“long_desc”]).“',
cat_id = '”.mysql_escape_string($record[“category”]).“',
Delete_Me = '”.mysql_escape_string(“0”)."’
";
}
mysql_query($sql);
}
MagicParser_parse($link, “myRecordHandler”, “csv|44|1|0”);
//delete products missing from feed
$sql = “DELETE FROM cubecart_inventory WHERE Delete_Me = '1’AND Company_name = ‘company’”;
mysql_query($sql);
mysql_close($conn);
?>