Hi to all, i have a strange problem. i’ve created a script to export contacts from suite crm:
<?php
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
$destination_dir = "C:\\FTP\\DelBarba\\";
rename($destination_dir."dataOut\\Contatti.csv",$destination_dir."Old\\DataOut\\Contatti_".date("Y_m_d_H_i_s").".csv");
$oContact = BeanFactory::newBean('Contacts');
$oContacts = $oContact->get_full_list( );
$csv = '';
$first_row="Nome;Cognome;ID;Titolo;Funzione;Divisione;Nome azienda;Email;Non Primary E-mails;Cellulare;Telefono Ufficio;Telefono Abitazione;Altro Telefono;Fax;Indirizzo Primario, Via;Indirizzo Primario, Comune;Indirizzo Primario, Provincia;Indirizzo Primario, CAP;Indirizzo Primario, Nazione;Indirizzo Alternativo, Via;Indirizzo Alternativo, Comune;Indirizzo Alternativo, Provincia;Indirizzo Alternativo, CAP;Indirizzo Alternativo, Nazione;Descrizione;Data di nascita;Fonte del lead;ID Campagna;Non chiamare;Riferito a ID;Assistente;Telefono Assistente;Nome Utente Assegnato;Assegnato a Utente ID;Date Created;Data Modifica;Modificato da ID;Creato da ID;Deleted;Photo;ID Account Joomla;Account Disattivato;Tipo Utente Portale;Indirizzi;Geocode Stato;Latitudine;Longitudine;CardCode;".chr(10);
$csv .=$first_row;
$count=0;
foreach ($oContacts as $oCon) {
$csv .= $oCon->first_name .';';
$csv .= $oCon->last_name .';';
$csv .= $oCon->id_csv_c .';';
$csv .= $oCon->salutation .';';
$csv .= $oCon->funzione_c .';';
$csv .= $oCon->department .';';
$csv .= $oCon->nomeazienda_c .';';
$csv .= $oCon->email1 .';';
$csv .= $oCon->non_primary_email_c .';';
$csv .= $oCon->phone_mobile .';';
$csv .= $oCon->phone_work .';';
$csv .= $oCon->phone_home .';';
$csv .= $oCon->phone_other .';';
$csv .= $oCon->phone_fax .';';
$csv .= $oCon->primary_address_street .';';
$csv .= $oCon->primary_address_city .';';
$csv .= $oCon->primary_address_state .';';
$csv .= $oCon->primary_address_postalcode .';';
$csv .= $oCon->primary_address_country .';';
$csv .= $oCon->alt_address_street .';';
$csv .= $oCon->alt_address_city .';';
$csv .= $oCon->alt_address_state .';';
$csv .= $oCon->alt_address_postalcode .';';
$csv .= $oCon->alt_address_country .';';
$csv .= $oCon->description .';';
$csv .= $oCon->birthdate .';';
$csv .= $oCon->lead_source .';';
$csv .= $oCon->campaign_id .';';
$csv .= $oCon->do_not_call .';';
$csv .= $oCon->riferito_a_id_c .';';
$csv .= $oCon->assistant .';';
$csv .= $oCon->assistant_phone .';';
$csv .= $oCon->nome_utente_assegnato_c .';';
$csv .= $oCon->assigned_user_id .';';
$csv .= $oCon->date_entered .';';
$csv .= $oCon->date_modified .';';
$csv .= $oCon->modified_user_id .';';
$csv .= $oCon->created_by .';';
$csv .= $oCon->deleted .';';
$csv .= $oCon->photo .';';
$csv .= $oCon->joomla_account_id .';';
$csv .= $oCon->portal_account_disabled .';';
$csv .= $oCon->portal_user_type .';';
$csv .= $oCon->jjwg_maps_address_c .';';
$csv .= $oCon->jjwg_maps_geocode_status_c .';';
$csv .= $oCon->jjwg_maps_lat_c .';';
$csv .= $oCon->jjwg_maps_lng_c .';';
$csv .= $oCon->car_code_c .';'.chr(10);
}
$a = str_replace("'","'",($csv));
$csv =html_entity_decode($a);
file_put_contents($destination_dir."dataOut\\Contatti.csv", $csv);
echo "fatto";
I created my entrypoint and when i run from web the scrit, all works fine and smooty. But now i want to schedule this export, the server is Widows so i’ve the task skedule manager, and when i configured the script and tryed to launch, it give me a error. SO i’ve tryed to run from CMD and here the error:
So, why from browser it’s a valid entry point, but if i use the script doesn’t work at all?
I’m stuck in this like 3 hours, please help!!