AIM Institute Technology Blog

// we're assuming these 2 files are in the same directory, if not, change these paths
require_once 'PHPtoolkit.php';
require_once 'login_info.php';
// how many records do you want to get per search? Max is 999.
// Too few, and this scripts runs way too long. Too many,
// and you tax the netsuite server and could have timeouts.
$searchmax="500";
global $myNSclient;
$myNSclient->setSearchPreferences(false, $searchmax);
$customerSearchParam = new nsComplexObject('SearchStringField');
// here is where we cheat. Ideally, we could just use
// the 'getAll' function on the
// 'Customer' object, but Netsuite doesn't support that
// (see http://bit.ly/p0JKhl)
// Instead, we have to search for a 'catch-all' value
// to return all results
$customerSearchParam->setFields(array('searchValue' => '', 'operator' => 'contains'));
$customerSearchBasic = new nsComplexObject("CustomerSearchBasic");
$customerSearchBasic->setFields(array ('companyName'=> $customerSearchParam));

// Do the first search
$searchResponse = $myNSclient->search($customerSearchBasic);

if ($searchResponse->isSuccess)
{
 // how many records did we get back?
 $totalRecords = $searchResponse->totalRecords;
 foreach ( $searchResponse->recordList as $record )
 {
  $sugarid="";
  $internalId = $record->getField("internalId");
  $companyName = $record->getField("companyName");

  // you only have to do this part if you want to display a custom field
  // that you've created for the customer. The data returned from
  // the search above does not include custom fields, so if you
  // want to see them, you have to do another search, specifically
  // for this customer id, to get all the custom fields, and then
  // just display the one you want. This is expensive, because you
  // have to do a netsuite search for each company, but it's the
  // only way I know how to do it.
  // If you don't want to see custom fields, remove this part
  // and the script will run much faster. In this case, the
  // custom field I want to see is 'custentitysugar_org_id'
  $customerSearch = new nsRecordRef( array( "type" => "customer", "internalId" => $internalId));
  $getResponse = $myNSclient->get($customerSearch);

  foreach ( $getResponse->record->getField('customFieldList')->getField('customField') as $customField )
  {
   if ( $customField->getField('internalId') == "custentitysugar_org_id" )
   {
    $sugarid = $customField->getField('value');
   }
  }
  // output the value of the 3 fields we want to
  // see: Netsuite ID, Company name and Sugar ID
  echo "$internalId;$companyName;$sugarid\n";
 }
}

$searchId = $searchResponse->searchId;

$currentPage = $searchResponse->pageIndex;
$pageSize = $searchResponse->pageSize;

// how many more searches do we need to do in order to get all the results?
$number_of_searches = ceil ($totalRecords / $searchmax);
echo "DEBUG: Doing $number_of_searches searches\n";

// Now we do the same thing over again, getting chunks
// of companies 500 at a time. The only difference is that
// we're calling 'searchMorewithID' now instead of 'search'
for ($i = 2; $i <= $number_of_searches; $i++ )
{
 echo "DEBUG: Search $i\n";
 $searchResponse2 = $myNSclient->searchMorewithId($searchId,$i);
 if ($searchResponse2->isSuccess)
 {
  foreach ( $searchResponse2->recordList as $record )
  {
   $sugarid="";
   $internalId = $record->getField("internalId");
   $companyName = $record->getField("companyName");

   $customerSearch = new nsRecordRef( array( "type" => "customer", "internalId" => $internalId));
   $getResponse = $myNSclient->get($customerSearch);

   foreach ( $getResponse->record->getField('customFieldList')->getField('customField') as $customField )
   {
    if ( $customField->getField('internalId') == "custentitysugar_org_id" )
    {
     $sugarid = $customField->getField('value');
    }
   }

   echo "$internalId;$companyName;$sugarid\n";
  }
 }
}

Leave a Reply