if (($handle = fopen("bagdb.csv", "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $num = count($data); echo "<p> {$num} fields in line {$row}: <br /></p>\n"; $row++; // Skip blank rows if ($data[0] == '') { continue; } // Get title from CSV and Create Bag if ($row == 3) { $name = $data[0]; echo "Create Bag: " . $name . "<br/>"; $bagid = create_bag($name); if (!$bagid) { $bag = get_bag_by_name($name); $bagid = $bag['bagid']; } } // Skip Title Row if ($row < 4) { continue; } // Add Product to Bag (Create or Find Existing Product from inventory) import_bag_content($bagid, $data[0], $data[2], $data[3]); echo "Product: " . $data[0] . " | Quantity: " . $data[2] . " | Notes: " . $data[3] . "<br/>"; /* for ($c=0; $c < $num; $c++) { echo $data[$c] . "<br />\n"; }*/ }
include_once 'include/config.inc.php'; include_once 'library/mysql.lib.php'; include_once 'library/inventory.lib.php'; include_once 'library/bag.lib.php'; include_once 'library/util.lib.php'; sql_wrap(); global $bagid; // Create Bags for Family Size 1 through 10 $bag_names = array('1' => 'Family of One', '2' => 'Family of Two', '3' => 'Family of Three', '4' => 'Family of Four', '5' => 'Family of Five', '6' => 'Family of Six', '7' => 'Family of Seven', '8' => 'Family of Eight', '9' => 'Family of Nine', '10' => 'Family of Ten'); $bag_ids = array(); for ($i = 1; $i <= 10; $i++) { $bag_id = create_bag($bag_names[$i], 'none'); // Create bag if (!$bag_id) { // if bag alreadt exists get its bag_id $bag = get_bag_by_name($bag_names[$i]); $bag_id = $bag['bagid']; } $bag_ids[$i] = $bag_id; // Store bagids } // Read in Every row from Distribution.csv // Create Products in Inventory // Add their Quantity to Each Family Size Bag $row = 1; if (($handle = fopen("distribution.csv", "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $num = count($data); echo "<p> {$num} fields in line {$row}: <br /></p>\n"; $row++; // Skip title rows