- Thu Jun 21, 2018 6:52 am
#814863
Hi,
Any one let me know, how to read excel file using ajax call in processmaker ..?
Any one let me know, how to read excel file using ajax call in processmaker ..?
Moderator: amosbatto
$fileVarName = "uploadExcelFile"; //set to the variable name of your MultipleFile field.
$caseId = @@APPLICATION;
//get last uploaded document to the MultipleFile field:
$sql = "SELECT * FROM APP_DOCUMENT
WHERE APP_UID='$caseId' AND APP_DOC_FIELDNAME='$fileVarName' AND
APP_DOC_STATUS='ACTIVE' ORDER BY APP_DOC_CREATE_DATE DESC";
$aFiles = executeQuery($sql);
@=excelContents = array();
if (!empty($aFiles)) {
$fileId = $aFiles[1]['APP_DOC_UID'];
$version = $aFiles[1]['DOC_VERSION'];
//add your code here to use PHPExcel to open the file and extract the information
//and save it to @=excelContents
}
Useful.. https://crbtech.in/online-dot-net-trainin[…]
I used your example as a base to fixup my flow and[…]
There is a third parameter in the sendMessage() fu[…]