Array
(
[] => 1
[RegId] => 31519946
[EventId] => 946203
[EventTitle] => xxxxx
[ClientEventId] =>
[GroupId] => 31519946
[StatusDescription] => Confirmed
[RegTypeDescription] => xxxxxxx
[first_Name] => xx
[last_Name] => xx
[FirstLastName] => xxxxx
[City] => London
[Country] => United Kingdom
[HomePhone] => 12123112312
[CellPhone] => 1212121212
[Email_Address] => [email protected]
[DateOfBirth] => 5-Mar-1980
[Gender] => M
[Nationality] => United Kingdom
[BibNumber] =>
[EmergencyContactName] => xxxxx
[EmergencyContactPhone] => 12123132
)
Array
(
[] => 2
[RegId] => 31520986
[EventId] => 946203
[EventTitle] => xxxxxxx
[ClientEventId] =>
[GroupId] => 31520986
[StatusDescription] => Confirmed
[RegTypeDescription] => xxxxxx
[first_Name] => xxxx
[last_Name] => xxxx
[FirstLastName] => xxxxxx
[City] => Smarden
[Country] => United Kingdom
[HomePhone] => 2324323323
[CellPhone] => 123232133
[Email_Address] => [email protected]
[DateOfBirth] => 20-Jul-1962
[Gender] => F
[Nationality] => United Kingdom
[BibNumber] =>
[EmergencyContactName] => xxxxx
[EmergencyContactPhone] => 23232323
)
<?php
$path = MODX_CORE_PATH . 'components/athletes/';
$result = $modx->addPackage('athletes',$path . 'model/','cr_');
if (! $result) {
echo 'failed to add package';
} else {
echo '<p>Connected to live DB!</p>';
}
function csvToArr($filepath)
{
$headings = array(); // Array of headings
$filedata = array(); // Data Array
// Get file handle
$handle = fopen($filepath, "r");
// Get field headings
$fileline = fgetcsv($handle, 5000, ",");
foreach( $fileline as $field ) { $headings[] = $field; }
// Get data
$line = 0;
while (($fileline = fgetcsv($handle, 5000, ",")) !== FALSE)
{
foreach( $headings as $k => $v )
{
// Store data against field headings
$filedata[$line][$v] = $fileline[$k];
}
// echo to see if I am getting the correct array (I am)
echo "<pre>";
print_r( $filedata[$line] );
echo "</pre>";
// Add to xpdo object and save
$addEntrant = $modx->newObject('runnerentrant');
$addEntrant->fromArray($filedata[$line]);
$addEntrant->save();
$line++;
}
return $filedata;
}
csvToArr("http://link.to.csv");
Fatal error: Call to a member function newObject() on a non-object in /home1/centuri8/public_html/centurionrunning/core/cache/includes/elements/modsnippet/133.include.cache.php on line 48
<?php
define('MODX_CORE_PATH', 'full/path/to/your/modx/core/');
define('MODX_CONFIG_KEY', 'config');
require_once MODX_CORE_PATH . 'model/modx/modx.class.php';
$modx= new modX();
$modx->initialize('mgr');
MODX Staff
<?php
function csvToArr($filepath)
{
global $modx;
$path = MODX_CORE_PATH . 'components/athletes/';
$result = $modx->addPackage('athletes',$path . 'model/','cr_');
$headings = array(); // Array of headings
$filedata = array(); // Data Array
if (! $result) {
echo '<p>failed to add package</p>';
} else {
echo '<p>Connected to live DB!</p>';
}
// Get file handle
$handle = fopen($filepath, "r");
// Get field headings
$fileline = fgetcsv($handle, 5000, ",");
foreach( $fileline as $field ) { $headings[] = $field; }
// Get data
$line = 0;
while (($fileline = fgetcsv($handle, 5000, ",")) !== FALSE)
{
foreach( $headings as $k => $v )
{
// Store data against field headings
$filedata[$line][$v] = $fileline[$k];
}
// print out results
echo "<pre>";
print_r( $filedata[$line] );
echo "</pre>";
echo "<br />RegId: " . $filedata[$line]['RegId'] . "<br />";
// get record that matches RegId already entered in the runnerEntrant table
$runnerEntrants = $modx->getCollection('RunnerEntrant',array(
'RegId' => $filedata[$line]['RegId'],
));
echo "<h1>runnerEntrants: count " . count($runnerEntrants) . "</h1><pre>";
print_r($runnerEntrants);
echo "</pre>";
if($enteredEntrants === null) {
echo "<br />INSERT<br />";
$addEntrant = $modx->newObject('RunnerEntrant');
$addEntrant->fromArray($filedata[$line]);
$addEntrant->save();
} else {
echo "<br />UPDATE<br />";
$addEntrant = $modx->newObject('RunnerEntrant');
$addEntrant->fromArray($filedata[$line]);
$addEntrant->set('AutoId' , $runnerEntrants->get('AutoId'));
$addEntrant->save();
}
$line++;
} //end while loop
}
csvToArr("www.xxxxx.com/xx.csv");
echo "UPDATE";
$addEntrant = $modx->newObject('RunnerEntrant');
<?php
function csvToArr($filepath)
{
global $modx;
$path = MODX_CORE_PATH . 'components/athletes/';
$result = $modx->addPackage('athletes',$path . 'model/','cr_');
$headings = array(); // Array of headings
$filedata = array(); // Data Array
if (! $result) {
echo '<p>failed to add package</p>';
} else {
echo '<p>Connected to live DB!</p>';
}
// Get file handle
$handle = fopen($filepath, "r");
// Get field headings
$fileline = fgetcsv($handle, 5000, ",");
foreach( $fileline as $field ) { $headings[] = $field; }
// Get data
$line = 0;
while (($fileline = fgetcsv($handle, 5000, ",")) !== FALSE)
{
foreach( $headings as $k => $v )
{
// Store data against field headings
$filedata[$line][$v] = ucwords(strtolower($fileline[$k]));
}
// print out results
/*
echo "<pre>";
print_r( $filedata[$line] );
echo "</pre>";
*/
$joggerId = $filedata[$line]['RegId'];
// echo "<br />RegId: " . $filedata[$line]['RegId'] . "<br /> JoggerId: " . $joggerId . "<br />";
// get record that matches RegId already entered in the runnerEntrant table
$jogger = $modx->getObject('RunnerEntrant',array('RegId' => $joggerId));
// echo "<h1>jogger: count " . count($jogger) . "</h1>";
if($jogger === null) {
echo "<p><strong>INSERT</strong><br />" . $filedata[$line]['FirstLastName'] . "</p>";
$addEntrant = $modx->newObject('RunnerEntrant');
$addEntrant->fromArray($filedata[$line]);
$addEntrant->save();
} else {
echo "<p><strong>UPDATE</strong><br />" . $filedata[$line]['FirstLastName'] . "</p>";
$updateEntrant = $modx->getObject('RunnerEntrant',array('RegId' => $joggerId));
$updateEntrant->fromArray($filedata[$line]);
$updateEntrant->save();
}
$line++;
} //end while loop
fclose($handle);
}
csvToArr("https://link.to.csv");