Hello All,
I am trying to integrate web services with a process flow management application on the internet. We are trying to open an excel workbook on the server, populate it with the relevant information that our data captures have recorded, run a macro, and then return that data back to a form on the website.
We succeeded when trying to do test runs with one on one. Sending one Data Field and returning one Data Field.
However, we have now moved on to the second testing stage to try and get multiple fields populated in the workbook and return multiple fields back to the website. But now we get this error.
"Fatal error syntax error, unexpected '=': "
See my code below. Any help whatsoever in this would be appreciated greatly! 🙂
$drpbx_nation = array(1=>'South African',2=>'Non-South African');
$drpbx_bank = array(1=>'ABSA',2=>'FNB',3=>'Standard Bank',4=>'Capitec',5=>'Nedbank',6=>'Stop Order');
$drpbx_method = array(1=>'Email',2=>'Fax');
$drpbx_employer_size = array(1=>'Private < 20',2=>'Private > 50',3=>'Private 20 - 50',4=>'Government/Municipalities');
drpbx_length_of_service = array(1=>'0-3 Months',2=>'6 Months',3=>'1 Year',4=>'3 Years',5=>'5 Years',6=>'10 Years',
7=>'20 Years',8=>'45 Years');
$drpbx_freq = array(4=>'Monthly');
$drpbx_repeat = array('No','Yes');
$drpbx_reason = array(1=>'Housing',2=>'Business',3=>'Unsecured');
$server_address = "41.177.72.6";
$client = new SoapClient('http://'.$server_address.'/ExcelWebService/ExcelEndPoint.asmx?WSDL');
$params = array(
'command' =>
array(
'WorkbookPath' => 'c:\TrustedLocation\IzweV3.6.5.xlsm',
'SetNamedRanges' => array(
array('Name' => 'IdNumber','Value'=>@@UF_Info_txtbx_IDNumber),
array('Name' => 'Nation', Value=>$drpbx_nation[@@UF_Info_dropbx_Nationality]),
array('Name' => 'BankName', Value=>$drpbx_bank[@@UF_Info_dropbx_BankName]),
array('Name' => 'FirstName', Value=>@@UF_Info_txtbx_FirstName),
array('Name' => 'Surname', Value=>@@UF_Info_txtbx_LastName),
array('Name' => 'HTelephone', Value=>@@UF_Info_txtbx_HTelephone),
array('Name' => 'WTelephone', Value=>@@UF_Info_txtbx_WTelephone),
array('Name' => 'CTelephone', Value=>@@UF_Info_txtbx_CTelephone),
array('Name' => 'NOTele', Value=>@@UF_Info_txtbx_NumofTel),
array('Name' => 'EmailAddress', Value =>@@UF_Info_txtbx_Email),
array('Name' => 'FaxAddress', Value=>@@UF_Info_txtbx_Fax),
array('Name' => 'PrefMethod', Value >$drpbx_method[@@UF_Info_dropbx_ContactMethod]),
array('Name' => 'Boss', Value=>@@UF_Work_txtbx_Employer),
array('Name' => 'EmployerSize', Value=>$drpbx_employer_size[@@UF_Work_dropbx_Size]),
array('Name' => 'Months', Value =>$drpbx_lenght_of_service[@@UF_Work_dropbx_Service]),
array('Name' => 'MonthlyTime', Value=>$drpbx_freq[@@UF_Work_dropbx_Freq]),
array('Name' => 'IzweBranch', Value=>@@UF_Other_txtbx_BranchName),
array('Name' => 'RepeatIzwe', Value=>$drpbx_repeat[@@UF_Other_ynbx_Repeat]),
array('Name' => 'LoanReason', Value=>$drpbx_reason[@@UF_Other_dropbx_ReasonLoan]),
array('Name' => 'HearIzwe', Value=>@@UF_Other_txta_IzweAdd),
array('Name' => 'Collection', Value=>@@UF_Other_txtbx_ColMech),
array('Name' => 'SalesRepCode', Value=>@@UF_Other_txtbx_SalesRep),
array('Name' => 'GrossIncome', Value=>@@UF_Finance_txtbx_Gross_Income),
array('Name' => 'NetIncome', Value=>@@UF_Finance_txtbx_Net_Income),
array('Name' => 'Cheque', Value=>@@UF_Finance_txtbx_Bonus),
array('Name' => 'OverTime', Value=>@@UF_Finance_txtbx_Overtime),
array('Name' => 'Coms', Value=>@@UF_Finance_txtbx_Commision),
array('Name' => 'BankAccRepay', Value=>@@UF_Financial_txtbx_accrepay),
array('Name' => 'BankLoanRepay', Value=>@@UF_Financial_txtbx_loanrepay),
array('Name' => 'BankInsRepay', Value=>@@UF_Financial_txtbx_insurancerepay)
),
'Macro' => 'DataFill',
'GetNamedRanges' => array ('OfferYN','OfferResult','LoanInstalls','LoanTerm')
)
);
try {
$return_object = $client->InvokeExcel($params)->InvokeExcelResult;
$return_ranges = array();
@@UF_Offer_ynbx_result=$return_object->PairOfStringString->Value;
//echo "<pre>";
//print_r($return_object);
//echo "</pre>";
//$return_ranges[$return_object->PairOfStringString->Name] = $return_object->PairOfStringString->Value;
//print_r($return_ranges);
//@@UF_Offer_ynbx_result=$return_object->PairOfStringString[0]->Value;
//@@UF_Offer_txtbx_offeramount=$return_object->PairOfStringString[1]->Value;
//@@UF_Offer_txtbx_loaninstallment=$return_object->PairOfStringString[2]->Value;
//@@UF_Offer_txtbx_loanterm=$return_object->PairOfStringString[3]->Value;
} catch(SoapFault $exception) {
@@UF_Offer_txtbx_offeramount=$exception;
}
