Aaron
Thanks for posting on this site, I appreciate it
So it seems to me that you are looking for a super script that would download all the data from each object in Salesforce and place it into the schema that you have built
// I am glad that you have been able to get it to work
Could a script like that be built, I think it could, but it would be a waste of time in my opinion
Not all the objects (and this is my opinion) need to be downloaded, only ones that you deem necessary and I guess you could say strategic.
Example: We replicate our Accounts, Users, Opportunities, Parts, Pricebook, etc....
Each object has it's own script that replicates and runs on CRON
But there is a function that could work to your advantage and I have not used them, the function is > getUpdated:
PHP Code:
public function getUpdated($type, $startDate, $endDate) {
$this->setHeaders("getUpdated");
$arg = new stdClass;
$arg->sObjectType = new SoapVar($type, XSD_STRING, 'string', 'http://www.w3.org/2001/XMLSchema');
$arg->startDate = $startDate;
$arg->endDate = $endDate;
return $this->sforce->getUpdated($arg)->result;
}
I have a meeting, I will reply more later
~Mike