Advanced - Seperate value.

[kpowning]

I'm trying to import a .csv file that has a column named:

COLOR-:-SIZE~QTY

An example listed under this column is:

Black -:- One Size ~ 1976;Black -:- XL ~ 1979;Red -:- One Size ~ 1991;Red -:- XL ~ 1991;White -:- XL ~ 1987;White -:- One Size ~ 0

Is there anyway to break this apart to insert this information into my database that has (color, size, qty) for each product? I hope this makes sense. PLEASE HELP...

[cahva]

You could just edit the csv and do some text replacing.
Just replace "-:-" and "~" to ";" and they will become separate columns in the csv file.

[kpowning]

Thanks but is there anyway of breaking down the one row that has:
Black -:- One Size ~ 1976;Black -:- XL ~ 1979;Red -:- One Size ~ 1991;Red -:- XL ~ 1991;White -:- XL ~ 1987;White -:- One Size ~ 0

And say for instance find all text before -:- and we know thats colors and save all the different colors to my database colors field for this product. Then we know between -:- and ~ is the sizes available for this color and save them into the sizes for the database and then after ~ is the QTY so will save all these for each color and size to the QTY in the database. I hope this makes sense.

[NogDog]

<?php
$text = "Black -:- One Size ~ 1976;Black -:- XL ~ 1979;Red -:- One Size ~ 1991;Red -:- XL ~ 1991;White -:- XL ~ 1987;White -:- One Size ~ 0";
$regexp = '#(?<=^|;)(\b.*\b)\s*-:-\s*(\b.*\b)\s*~\s*(\b.*\b)(?=;|$)#U';
preg_match_all($regexp, $text, $matches, PREG_SET_ORDER);
echo "<pre>".print_r($matches, 1)."</pre>";
?>

[kpowning]

Thanks NogDog it returns array () though.. Any Ideas?

[kpowning]

NEVERMIND - Never question a professional.. 🙂 sorry..

[kpowning]

Here is the script I have:

$host = "http://www.test.com/feed.csv";
$rowcount = 0;
$error = '';
$flag = 0;
$fp = fopen($host,"r") or die("can't open file");

while($csv_line = fgetcsv($fp,'1084')) { 
$do = array($csv_line);

// check structure of .csv file for matching layout
	if ($rowcount == 0){

	if (($do[0][0] == "ID") && 
   		($do[0][1] == "SKU") && 
   		($do[0][2] == "PRICE") && 
   		($do[0][3] == "SALE-PRICE") &&
   		($do[0][4] == "STOCK") &&
   		($do[0][5] == "WEIGHT") && 
   		($do[0][6] == "CATEGORIES") && 
   		($do[0][7] == "COLOR-:-SIZE~QTY") && 
   		($do[0][8] == "DESCRIPTION") && 
   		($do[0][9] == "THUMBNAIL") && 
   		($do[0][10] == "LARGE-IMAGE")){

		echo ".CSV STRUCTURE - PASSED...<br>"; 
		echo "---------------------------------<br>";

	} else {

		// email admin script error
		echo "Bad match!";
		die();

	}

}
#$numfields = count($csv_line);
#for($i=0; $i<$numfields; $i++)
#     {
#     echo $i.":".$csv_line[$i]."<br>";
#     }
if ($rowcount > 0){

$Productid=$csv_line[0];
$Productsku=$csv_line[1];
$Productprice=$csv_line[2];
$Productsaleprice=$csv_line[3];
$Productstock=$csv_line[4];
$Productweight=$csv_line[5];
$Productcategory=$csv_line[6];
$Productcolor=$csv_line[7];
$Productdescription=$csv_line[8];
$Productthumb=$csv_line[9];
$Productlimage=$csv_line[10];

// insert into database or edit variable here
$Productdescription = str_replace($Productsku." -", "", $Productdescription);

$regexp = '#(?<=^|;)(\b.*\b)\s*-:-\s*(\b.*\b)\s*~\s*(\b.*\b)(?=;|$)#U';
preg_match_all($regexp, $Productcolor, $matches, PREG_SET_ORDER);
echo "<pre>".print_r($matches, 1)."</pre>";

$colors = count($matches);
echo "Results: ".$colors;
for($i=0; $i<$colors; $i++){
	echo $i.":".$matches[$i][1]."<br>"; // HELP HERE TO GET INDIVIDUAL ITEMS FOR DATABASE INSERT
}

echo $Productid."&nbsp; ".$Productdescription."&nbsp; ".$matches[1]."<br>";

}

$rowcount++;

}
fclose($fp) or die("can't close file");

I need help now getting each individual array then to insert into the database. Please help once more. I marked where i need help in the script with (// help here)

[kpowning]

Damn - trying to break it down to read all colors for each product but we only want to enter it once in the database like "Red" then we need all the sizes then for this product that are unique and finally the 'qty'. PLEASE I DO appreciate it...

[kpowning]

ok I figured that out but now im stuck on one last thing...

sometimes i have noticed who ever is editing this .csv file they arent staying consistant

$text = "Black -:- One Size ~ 1976;Black -:- XL ~ 1979;";
// this is what we just worked with

// but in a couple lines of this they have
$text = "Black/Red -:- One Size ~ 1976;Black/Red -:- XL ~ 1979;";

So how did i keep black and red seperate but give them the same value that follows?

[kpowning]

Can anyone please help...