php script modification

obydesign · May 7, 2012, 11:36pm

I have a script that parses a csv file that i create and creates all possible combinations that i need to import to my online store. It works fine as it is but I’m trying to modify it to read and output the header row as is and also to create a new csv file with the generated results. I cant seem to figure out how to get it to read the header row once only and output it and then move on to the products as usual. Here is my script…

<?php $row = 1; if (($handle = fopen("test.csv", "r")) !== FALSE) { while (($data = fgetcsv($handle, 500000, ",")) !== FALSE) { $num = 1; $row++; for ($c=0; $c < $num; $c++) { echo "admin" . ",". "base" . "," .$data[2] . "-Small-Satin-No Frame" . ",". "25.00" . ",". "Image Options" . "," . "simple" . ",".$data[6] . "," . "0" . "," .$data[8] . "-Small-Satin-No Frame" ."," . $data[9] . "," .$data[10]. "," .$data[11]. "," . $data[12] . "," .$data[13]. "," .$data[14]. "," .$data[15]. "," .$data[16] . "," . "No Layout Updates" . "," . "Product Info Column" . "," . "No". "," .$data[20]. "," .$data[21]. "," . ".9" . "," . "Enabled". "," . "None". "," . "No". "," . "1". "," . "Yes". "," . "No". "," . "Small" . "," . "Satin" . "," . "No Frame" . "," .$data[32]. "," .$data[33]. "," .$data[34]. "," .$data[35]. "," .$data[36]. "," .$data[37]. "," .$data[38]. "," .$data[39]. "," .$data[40]. "," .$data[41]. "," .$data[42]. "," . "9999". "," . "0". "," . "1". "," . "0". "," . "0". "," . "1". "," . "1". "," . "1". "," . "0". "," . "1". "," . "1". "," .$data[54]. "," .$data[55]. "," . "1". "," . "0". "," . "1". "," . "0". "," . "1". "," . "0". "," . "1". "," . "0". "," .$data[64]. "-Small-Satin-No Frame" . "," . "0". "," . "simple" . "," .$data[67] . "," .$data[68]. "," .$data[69]. "," .$data[70]. "," .$data[71]. "," .$data[72]. "
\n"; } } fclose($handle); } ?>

obydesign · May 8, 2012, 6:01pm

ok, so i’ve figured out how to get it to bypass the header row, but I am still lost about the best way to have the script output the results to a csv file. Here’s my code so far…

[php]

<?php $row = 1; $first = true; if (($handle = fopen("test.csv", "r")) !== FALSE) { while (($data = fgetcsv($handle, 500000, ",")) !== FALSE) { $num = 1; $row++; for ($c=0; $c < 1; $c++) { echo $data[0] . "," . $data[1] . "," . $data[2] . "," . $data[3] . "," . $data[4] . "," . $data[5] . "," . $data[6] . "," . $data[7] . "," . $data[8] . "," . $data[9] . "," . $data[10] . "," . $data[11] . "," . $data[12] . "," . $data[13] . "," . $data[14] . "," . $data[15] . "," . $data[16] . "," . $data[17] . "," . $data[18] . "," . $data[19] . "," . $data[20] . "," . $data[21] . "," . $data[22] . "," . $data[23] . "," . $data[24] . "," . $data[25] . "," . $data[26] . "," . $data[27] . "," . $data[28] . "," . $data[29] . "," . $data[30] . "," . $data[31] . "," . $data[32] . "," . $data[33] . "," . $data[34] . "," . $data[35] . "," . $data[36] . "," . $data[37] . "," . $data[38] . "," . $data[39] . "," . $data[40] . "," . $data[41] . "," . $data[42] . "," . $data[43] . "," . $data[44] . "," . $data[45] . "," . $data[46] . "," . $data[47] . "," . $data[48] . "," . $data[49] . "," . $data[50] . "," . $data[51] . "," . $data[52] . "," . $data[53] . "," . $data[54] . "," . $data[55] . "," . $data[56] . "," . $data[57] . "," . $data[58] . "," . $data[59] . "," . $data[60] . "," . $data[61] . "," . $data[62] . "," . $data[63] . "," . $data[64] . "," . $data[65] . "," . $data[66] . "," . $data[67] . "," . $data[68] . "," . $data[69] . "," . $data[70] . "," . $data[71] . "," . $data[72] ."
\n"; if (($handle = fopen("test.csv", "r")) !== FALSE) { while (($data = fgetcsv($handle, 500000, ",")) !== FALSE) { if ($first) { $first = false; continue; } $num = 1; $row++; for ($c=0; $c < $num; $c++) { echo "admin" . ",". "base" . "," .$data[2] . "-Small-Satin-No Frame" . ",". "25.00" . ",". "Image Options" . "," . "simple" . ",".$data[6] . "," . "0" . "," .$data[8] . "-Small-Satin-No Frame" ."," . $data[9] . "," .$data[10]. "," .$data[11]. "," . $data[12] . "," .$data[13]. "," .$data[14]. "," .$data[15]. "," .$data[16] . "," . "No Layout Updates" . "," . "Product Info Column" . "," . "No". "," .$data[20]. "," .$data[21]. "," . ".9" . "," . "Enabled". "," . "None". "," . "No". "," . "1". "," . "Yes". "," . "No". "," . "Small" . "," . "Satin" . "," . "No Frame" . "," .$data[32]. "," .$data[33]. "," .$data[34]. "," .$data[35]. "," .$data[36]. "," .$data[37]. "," .$data[38]. "," .$data[39]. "," .$data[40]. "," .$data[41]. "," .$data[42]. "," . "9999". "," . "0". "," . "1". "," . "0". "," . "0". "," . "1". "," . "1". "," . "1". "," . "0". "," . "1". "," . "1". "," .$data[54]. "," .$data[55]. "," . "1". "," . "0". "," . "1". "," . "0". "," . "1". "," . "0". "," . "1". "," . "0". "," .$data[64]. "-Small-Satin-No Frame" . "," . "0". "," . "simple" . "," .$data[67] . "," .$data[68]. "," .$data[69]. "," .$data[70]. "," .$data[71]. "," .$data[72]. "
\n"; } } fclose($handle); } } } } ?>

[/php]

Thanks in advance!!