function read_csv_files($type)
{
$ret = array();
foreach (glob(dirname(__FILE__) . "/isco*codes.csv") as $file) {
$match = array();
preg_match("{isco(\\d+)codes.csv}", $file, $match);
$code = $match[1];
$ret[$code] = parse_csv_file($file, $type);
}
return $ret;
}
function do_import()
{
$filename = $_FILES['file']['tmp_name'];
$address_fields = array('street1', 'street2', 'street3', 'town', 'county', 'postcode');
$req_address_fields = array('street1', 'town', 'county', 'postcode');
$db =& DB::Instance();
$flash = Flash::Instance();
$db->StartTrans();
$columnheadings = false;
if (isset($this->_data['contains_headings'])) {
$columnheadings = true;
} else {
if (count($this->_data['headings']) > 0) {
$columnheadings = $this->_data['headings'];
}
}
$data = parse_csv_file($filename, $columnheadings);
$co_loaded = false;
$errors = array();
$try_address = false;
if (in_array_all($req_address_fields, $columnheadings)) {
$try_address = true;
}
foreach ($data as $person_data) {
$company = DataObjectFactory::Factory('Company');
if (in_array('company', $columnheadings)) {
if (isset($this->_data['unique_companies'])) {
$co_loaded = $company->loadBy('name', $person_data['company']);
}
if ($co_loaded === false) {
$co_data = array('name' => $person_data['company']);
$company = DataObject::Factory($co_data, $errors, 'Company');
if ($company !== false) {
$company->save();
}
}
if ($company !== false) {
$person_data['company_id'] = $company->id;
}
}
parent::save('Person', $person_data);
if ($try_address && in_array_all($req_address_fields, array_keys($person_data))) {
$address_data = array();
foreach ($address_fields as $fieldname) {
if (isset($person_data[$fieldname])) {
$address_data[$fieldname] = $person_data[$fieldname];
}
}
$address_data['main'] = true;
$address_data['name'] = 'Main';
$address_data['person_id'] = $this->_data['id'];
$address_data['countrycode'] = 'GB';
$address = DataObject::Factory($address_data, $errors, 'Personaddress');
if ($address !== false) {
$address->save();
}
}
}
$success = $db->CompleteTrans();
if ($success) {
$flash->clearMessages();
$flash->addMessage(count($data) . ' contacts imported');
$this->import();
$this->setTemplateName('import');
} else {
$flash->addErrors($errors);
$this->import();
$this->setTemplateName('import');
}
}
$db_production_database = "test_mv2";
$link = mysql_connect($db_production_hostname, $db_production_username, $db_production_password) or die(mysql_error());
mysql_selectdb($db_production_database, $link);
/**************************************************************************************************/
$db_account_hostname = 'localhost';
//$db_account_hostname = '107.22.255.187';
$db_account_username = '******';
$db_account_password = '******';
$db_account_database = 'sticky_accounts';
$link2 = mysql_connect($db_account_hostname, $db_account_username, $db_account_password) or die(mysql_error());
mysql_selectdb($db_account_database, $link2);
/**************************************************************************************************/
$sampleUrls = $cache = $arrSql = array();
$filename = 'Threshold_price_catalog 11-5-14 csvREADY FOR IMPORT.csv';
echo "{$filename}\n";
$arrData = parse_csv_file($filename);
//print_r($arrData[0]); exit;
foreach ($arrData as $row) {
$description = '';
//$row['Description'];
$upc = '';
//$row['UPC'];
$brand = '';
//$row['Brand'];
$sku = '';
//$row['SKU'];
foreach ($row as $k => $v) {
$k = ucfirst($k);
//echo "$k=>$v\n";
if ($k == 'Final Desc') {
//Verbose_description
<?php
require_once $_SERVER['DOCUMENT_ROOT'] . "/faker/src/autoload.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/class.db_user.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/class.db_item.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/class.db_auction.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/class.db_country.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/class.db_auction_view.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/class.db_bid.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/class.db_auction_watch.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/class.db_feedback.php";
include $_SERVER['DOCUMENT_ROOT'] . "/config/env_variables.php";
set_time_limit(0);
$csvFile = $_SERVER['DOCUMENT_ROOT'] . "/scripts/db_seed/items.csv";
$itemData = parse_csv_file($csvFile);
//var_dump($itemData);
/*$a = DbAuction::find(195);
$a->setField("numBids", 100);
/*return;*/
$faker = Faker\Factory::create();
$reportFrequencies = $_env_reportFrequencies;
seedUsersItemsAndAuctions(1000, 20, 5);
//now get the userIds and auctions for next steps
$userIds = DbUser::listIds();
$auctions = DbAuction::withConditions()->getAsClasses();
seedAuctionBids();
//seedAuctionViews();
seedAuctionWatches();
$soldAuctions = getSoldAuctions($auctions);
seedFeedbacks($soldAuctions);
<?php
// This is just an example of reading server side data and sending it to the client.
// It reads a json formatted text file and outputs it.
$dataType = $_GET['data_type'];
//$string = file_get_contents('../data/' . $dataType . 'data.json');
//echo $string;
$file = '../data/test.csv';
// . $dataType . 'data.json';
$csv = file_get_contents($file);
$array = parse_csv_file($file);
$json = json_encode($array);
$returnArray = array_combine(array("c"), array($json));
$json2 = json_encode($returnArray);
print_r($json2);
function parse_csv_file($csvfile)
{
$csv = array();
$rowcount = 0;
if (($handle = fopen($csvfile, "r")) !== FALSE) {
$max_line_length = defined('MAX_LINE_LENGTH') ? MAX_LINE_LENGTH : 10000;
$header = fgetcsv($handle, $max_line_length);
$header_colcount = count($header);
while (($row = fgetcsv($handle, $max_line_length)) !== FALSE) {
$row_colcount = count($row);
if ($row_colcount == $header_colcount) {
$entry = array_combine($header, $row);
$csv[] = $entry;
} else {
error_log("csvreader: Invalid number of columns at line " . ($rowcount + 2) . " (row " . ($rowcount + 1) . "). Expected={$header_colcount} Got={$row_colcount}");
return null;
return $csv;
}
/************************* BEGIN *************************/
$req = $_REQUEST;
$currentDir = str_replace("\\", "/", __DIR__);
$rootDir = $currentDir . '/..';
$entries = scandir($rootDir . '/public/files');
$directories = array();
foreach ($entries as $entry) {
if ('..' == $entry || '.' == $entry) {
continue;
}
$directories[] = $entry;
}
$files = array();
foreach ($directories as $entry) {
$fileEntries = glob($rootDir . '/public/files/' . $entry . '/*.csv');
$files[] = $fileEntries[0];
}
//print_r($files);
$arrJson = array();
foreach ($files as $key => $entry) {
$res = parse_csv_file($entry);
$arrJson[$directories[$key]] = $res;
// print_r($res);
}
//print_r($arrJson);
$toJson = json_encode($arrJson);
echo $toJson;
//
//echo $toJson;
echo '<pre>';
print_r($contents);
echo '</pre>';
foreach ($contents as $file) {
if (substr($file, -4, 4) == '.csv') {
$arrayCsvFiles[] = $arrayCsvFilesClear[] = $file;
}
}
foreach ($arrayCsvFiles as $file) {
if (isset($result["{$file}"])) {
continue;
}
$localFileNeme = time() . rand(1, 1000);
$downloadFilePath = AF::path($localFileNeme, array('files', 'csv', 'rockets'), 'csv');
if ($sftp->get($dPath . '/' . $file, $downloadFilePath)) {
parse_csv_file($downloadFilePath);
$sql = "INSERT INTO `fulfillment_files` (`fulfillment_id`, `filename`, `time`) VALUES (?i, ?s, NOW())";
$msql->query($sql, $fulfillmentID, $file);
}
}
$sftp->_disconnect(0);
function parse_csv_file($downloadFilePath)
{
global $fulfillmentID, $msql;
$header = NULL;
$data = array();
if (($handle = fopen($downloadFilePath, 'r')) !== FALSE) {
while (($row = fgetcsv($handle, 1000, ',')) !== FALSE) {
if (!$header) {
$header = $row;
} else {
