- Wed Oct 26, 2016 10:28 am
#787168
When user want to input data from Dynaform, how to input this data into SQL database?
Attachments
(291.78 KiB) Downloaded 82 times
Moderator: amosbatto
amosbatto wrote:See: viewtopic.php?f=44&t=709602
Please don't post the same question twice.
rachmadiniutami wrote: ↑Sun Jul 21, 2019 11:47 pm I make a trigger to input from dynaform to PM Tables.In Debug Mode, do you see an "__ERROR__" variable?
at my community edition, it works perfectly.
but, when I import it to my enterprise edition, it did not work.
can anyone help? is any other permission I had to set? where can I found the error log? please help
rachmadiniutami wrote: ↑Fri Aug 02, 2019 12:13 am Thank You Amosbato.If it is a JavaScript problem, then activate your web browser's debugger (which is available by pressing F12 in most web browsers. See:
now I know that the problem is in Javascript, by enable debug mode.
rachmadiniutami wrote: ↑Tue Aug 06, 2019 4:12 am Now I am facing new problem.If you want to store an array in a hidden field, you need to convert it to a JSON string like this in JavaScript:
it seems like in version 3.3 enterprise, the hidden field can't hold array anymore.
bacause, when I chooce variable for hidden filed, it doesn't available
var a = ["some", "thing"];
var s = JSON.stringify(a);
$("#myHidden").setValue(s);
var a = JSON.parse( $("#myHidden").getValue() );
rachmadiniutami wrote: ↑Sun Aug 11, 2019 9:32 pm thank you @amosbatto, I finally show the data to Grid than panel.
and its good too.
but, thanks for the support.
Now I had new problem,
I need to send input docs as an attachment email which is send right after a case is submitted.
I follow the way in the link below, part "Send Input Docs File as email attachments", then run the cron job.
the cron message is sucessfull but no email receive in the email inbox.
what should I do?
forgot the link
https://wiki.processmaker.com/3.0/Input_Documents
PMFSendMessage($caseId, '[email protected]', $to, '', '',
'Invoices for case #'[email protected]@APP_NUMBER, 'invoiceTemplate.html', array(), $aAttached);
}
@=files = $aFiles;
@=attachments = $aAttached;
PMFSendMessage($caseId, '[email protected]', $to, '', '',
'Invoices for case #'[email protected]@APP_NUMBER, 'invoiceTemplate.html', array(), $aAttached);
}
rachmadiniutami wrote: ↑Mon Aug 12, 2019 10:21 pm How to execute the trigger without run a cron job?Start the case inside the ProcessMaker interface and execute the trigger inside the ProcessMaker interface, so you can check the debugger to see the value of your case variables. Sometimes triggers execute differently in the ProcessMaker interface than as a cron job.
$query = "SELECT APP_DOC_UID, DOC_VERSION FROM APP_DOCUMENT
WHERE APP_UID='$caseId' AND APP_DOC_FIELDNAME='inputDok' AND
APP_DOC_STATUS='ACTIVE' ORDER BY APP_DOC_INDEX";
Vvladimir wrote: ↑Mon Nov 21, 2016 4:11 pm If you are using an external database, you have to create a database connection to the database you are using and if you use a PM table to store the data, you do not need a database connection Box à Louer. Using the Dynaform, data will be inserted into the DB.Thank you very much for sharing all this information with us.
Vladimir Vargas
Quality Engineer
ProcessMaker
Hi guys. I am a newbie. I don't know how to upgrad[…]
HI Thanks so much! This is just what I need.