Search found 5678 matches

by amosbatto
Fri Jan 19, 2018 8:22 pm
Forum: Using ProcessMaker 3
Topic: process reset itself
Replies: 19
Views: 336

Re: process reset itself

I wonder if the new blacklist code in executeQuery() is causing this problem. Try using this trigger code: $CASENO = mysql_real_escape_string(@@M01);$CTIC = mysql_real_escape_string(@@M02);$CDESC = mysql_real_escape_string(@@M03);$sql = "UPDATE PMT_CUSTOM...
by amosbatto
Fri Jan 19, 2018 8:08 pm
Forum: Using ProcessMaker 3
Topic: How to use the email end event with attachment
Replies: 1
Views: 13

Re: How to use the email end event with attachment

There is no way to do it with a Email End Event. Instead, you need to create a trigger that sends out the email using PMFSendMessage(). See the "Example Emailing Generated Output Document Files".
by amosbatto
Fri Jan 19, 2018 6:50 pm
Forum: Developing processes & programming
Topic: Case management process closing cases and starting the next sub-process
Replies: 3
Views: 35

Re: Case management process closing cases and starting the next sub-process

If I have this master process: [Task1] -> [Subprocess1] -> [Task2] If I cancel the master case when it is in Task1, then it never reaches Subprocess1 and the subprocess case never starts. If I cancel the master case when it is waiting for the Subprocess1 case to complete, then I need to cancel both ...
by amosbatto
Thu Jan 18, 2018 11:00 pm
Forum: Tips and Tricks
Topic: ProcessMaker 3 installation in Slackware
Replies: 0
Views: 27

ProcessMaker 3 installation in Slackware

Follow this tutorial to install ProcessMaker 3 in Slackware 14.2 and later. Slackware is a conservative community Linux distribution that aims for design, stability and simplicity. Before installing ProcessMaker, check the Installation Requirements to see whether your server meets the necessary hard...
by amosbatto
Thu Jan 18, 2018 8:54 pm
Forum: Installation & Configuration
Topic: SMTP Error: Could not connect to SMTP host
Replies: 10
Views: 83

Re: SMTP Error: Could not connect to SMTP host

weiminliou, I recommend that you sign up for a Free ProcessMaker Trial and see if you can connect to your Gmail account from the ProcessMaker servers. If you can connect, then you know it is a configuration problem on your server or network. If you can't connect, then you need to configure your Gmai...
by amosbatto
Thu Jan 18, 2018 8:44 pm
Forum: Using ProcessMaker 3
Topic: Microsoft FLow
Replies: 1
Views: 23

Re: Microsoft FLow

I don't know of any plans to add a connector to MS Flow. ProcessMaker Professional Services might be willing to develop it for you if you are willing to pay for it. If you want to write your own code, it doesn't look that hard to call MS Flow with a ProcessMaker trigger: https://flow.microsoft.com/e...
by amosbatto
Thu Jan 18, 2018 8:22 pm
Forum: Using ProcessMaker 3
Topic: One inbox - Multiple workspaces
Replies: 1
Views: 17

Re: One inbox - Multiple workspaces

No. You might be able to modify the source code of the Outlook plugin to access multiple workspaces. Officially I'm supposed to tell you that the code of the plugin is proprietary so you need to write to ProcessMaker Inc and ask for permission to modify the source code. The other option is to create...
by amosbatto
Thu Jan 18, 2018 7:32 pm
Forum: Installation & Configuration
Topic: Upgrading Processmaker v1.2-2467 to v3.2
Replies: 1
Views: 16

Re: Upgrading Processmaker v1.2-2467 to v3.2

In theory processes from version 1.2 should be able to run in version 3.2, but there is no guarantee. You will have to test your processes to see if they work. You can try to upgrade your existing installation to version 3.2, but there is no guarantee that it will work. Before you start read: http:/...
by amosbatto
Thu Jan 18, 2018 7:05 pm
Forum: Developing processes & programming
Topic: How can I assign one user to multiple departments?
Replies: 1
Views: 22

Re: How can I assign one user to multiple departments?

There is no way in PM for a user to be a member of more than one department. The workaround is to create a PM Table that contains the department information for the users. Then use executeQuery() in a trigger to look up that information and assign users to tasks using Value Based Assignment instead ...
by amosbatto
Thu Jan 18, 2018 6:12 pm
Forum: Developing processes & programming
Topic: Case management process closing cases and starting the next sub-process
Replies: 3
Views: 35

Re: Case management process closing cases and starting the next sub-process

What do you mean by "kicking off the next sub-process"? Starting a new subprocess case? Canceling the master case, but not canceling the subprocess case?
by amosbatto
Wed Jan 17, 2018 10:43 pm
Forum: Using ProcessMaker 3
Topic: Wait To Continue Event With Variable by Catching Events
Replies: 3
Views: 83

Re: Wait To Continue Event With Variable by Catching Events

If you have selected the time in a dropbox, then you can use PMPauseCase() in a trigger to pause the case. For example, if you have a dropdown associated the the variable "pauseTime" which has the following options: Value | Label ----------------------- | Don't pause case +15 days | 15 day...
by amosbatto
Wed Jan 17, 2018 10:14 pm
Forum: Using ProcessMaker 3
Topic: process reset itself
Replies: 19
Views: 336

Re: process reset itself

Also, in your workflow/engine/config/execute-query-blacklist.ini file, change the line from: queries = "INSERT|UPDATE|REPLACE|DELETE|TRUNCATE" To: queries = "INSERT|REPLACE|DELETE|TRUNCATE" See: http://wiki.processmaker.com/3.0/Consulting_the_ProcessMaker_databases#Protecting_PM_...
by amosbatto
Wed Jan 17, 2018 10:09 pm
Forum: Using ProcessMaker 3
Topic: process reset itself
Replies: 19
Views: 336

Re: process reset itself

Your log doesn't contain a "UPDATE PMT_CUSTOMER ..." query. It doesn't look like the query is executing. Do you see the query in your shared/sites/{workspace}/log/processmaker-{YYYY-MM-DD}.log file? In your env.ini file , add the following settings: debug = 1 debug_sql = 1 Turn on the Debu...
by amosbatto
Wed Jan 17, 2018 9:52 pm
Forum: Developing processes & programming
Topic: Excel DAYS360 calculations in PM
Replies: 2
Views: 28

Re: Excel DAYS360 calculations in PM

Here is an example in JavaScript: //calculate the difference in days based on a 360 day calendar:function calculateDays360(startDate, endDate) {  if (startDate == '' || endDate == '') {...
by amosbatto
Wed Jan 17, 2018 9:06 pm
Forum: Using ProcessMaker 3
Topic: getValue in checkgroup for more than one value
Replies: 15
Views: 185

Re: getValue in checkgroup for more than one value

The user needs to be the outer for loop, like this: function roundToFixed(_float, _digits) {   var rounder = Math.pow(10, _digits);   return (Math.round(_float * rounder) / rounder).toFixed(_digits);}$("#Button...
by amosbatto
Wed Jan 17, 2018 8:54 pm
Forum: Installation & Configuration
Topic: SMTP Error: Could not connect to SMTP host
Replies: 10
Views: 83

Re: SMTP Error: Could not connect to SMTP host

Nothing is blocking you, so TLS and port 587 should work. I don't know anything else to recommend, so you need to ask Google or in a forum for experts in email.
by amosbatto
Wed Jan 17, 2018 8:37 pm
Forum: Developing processes & programming
Topic: Reassigning a case when it is paused/transitioning
Replies: 1
Views: 23

Re: Reassigning a case when it is paused/transitioning

You can use this sample process to do reassignment:
viewtopic.php?f=41&t=713751&p=795562&hilit=reassignCase#p795562
I'm not sure how ProcessMaker's Cases::reassignCase() function handles paused cases, so you will have to try it and see what happens.
by amosbatto
Wed Jan 17, 2018 1:38 am
Forum: Installation & Configuration
Topic: SMTP Error: Could not connect to SMTP host
Replies: 10
Views: 83

Re: SMTP Error: Could not connect to SMTP host

What operating system is your PM server using? If you are using Linux, then you can enter this command to verify that nothing is blocking the connection: openssl s_client -starttls smtp -connect smtp.gmail.com:587 -crlf -ign_eof You should see output like the following: CONNECTED(00000003) depth=1 C...
by amosbatto
Wed Jan 17, 2018 1:23 am
Forum: Using ProcessMaker 3
Topic: process reset itself
Replies: 19
Views: 336

Re: process reset itself

I wonder if executeQuery() is truncating at 256 characters. You need to turn on MySQL query log and look at the SQL query in the log file to see if it is being cut short.
See: https://stackoverflow.com/questions/6479107/how-to-enable-mysql-query-log
by amosbatto
Wed Jan 17, 2018 1:04 am
Forum: Developing processes & programming
Topic: How to model a process with variable parallel tasks/sub-processes?
Replies: 3
Views: 42

Re: How to model a process with variable parallel tasks/sub-processes?

One doubt: All the Cases, for the Sub-process, must be launched simultaneously (asynchronously). On the design, we need to wait for the Sub-process task to finish before launching the next Case! Exactly. The example process map I gave you in the previous post can be used if you want to start a bunc...
by amosbatto
Tue Jan 16, 2018 10:13 pm
Forum: Using ProcessMaker 3
Topic: getValue in checkgroup for more than one value
Replies: 15
Views: 185

Re: getValue in checkgroup for more than one value

I see a couple problems with your code. Buttons don't have values and the setOnchange() method doesn't work with them. You need to use click() instead. Also you forgot to terminate your event handler code with ). If you have a fixed number of users and userX_sum fields, then you can do something lik...
by amosbatto
Tue Jan 16, 2018 9:41 pm
Forum: Using ProcessMaker 3
Topic: Prevent from duplicated posting
Replies: 11
Views: 87

Re: Prevent from duplicated posting

I was wondering whether I could use this workaround for "Action by Email"? What I mean is that after a user click a "Y" / "N" in the email, it will show a ABE page says "Thank you for your response!", but currently Processmaker use one template for all the AB...
by amosbatto
Tue Jan 16, 2018 12:09 am
Forum: Using ProcessMaker 3
Topic: getValue in checkgroup for more than one value
Replies: 15
Views: 185

Re: getValue in checkgroup for more than one value

Oh, I see the problem. Not all fields/controls in a Dynaform have getInfo(). Try this: var aFieldTypes = ["text", "textarea", "dropdown", "radio", "checkbox", "checkgroup", "suggest", "datetime"]; $('#btnReadOnly').find(...
by amosbatto
Tue Jan 16, 2018 12:01 am
Forum: Installation & Configuration
Topic: SMTP Error: Could not connect to SMTP host
Replies: 10
Views: 83

Re: SMTP Error: Could not connect to SMTP host

Try setting up Gmail 2-Step Verification as explained on the wiki. Is your email [email protected].com.tw a business account from Google? That is what we are using at ProcessMaker and it works. You should check that your firewall isn't blocking port 465. Do pings and the other tests listed on the wiki fro...
by amosbatto
Mon Jan 15, 2018 11:50 pm
Forum: Using ProcessMaker 3
Topic: Prevent from duplicated posting
Replies: 11
Views: 87

Re: Prevent from duplicated posting

I think this is a bug in processmaker, because you can get action of web entry form for example XXXPost.php and call it several times without any post or get data. Then you see that case number will increase. Thanks I agree. I filed an internal bug report about it: https://processmaker.atlassian.ne...
by amosbatto
Mon Jan 15, 2018 11:33 pm
Forum: Using ProcessMaker 3
Topic: Prevent from duplicated posting
Replies: 11
Views: 87

Re: Prevent from duplicated posting

I think that would be a good solution. Could you please provide more details regarding this solution? :shock: Create the file workflow/engine/methods/messages/messages_NewCase.php with the following content: <?phpif (!isset($_SESSION['WEB_ENTRY_MESSAGE'])) {    throw new Exception("Web entry messag...
by amosbatto
Mon Jan 15, 2018 10:31 pm
Forum: Using ProcessMaker 2
Topic: Unique key isuue
Replies: 1
Views: 21

Re: Unique key isuue

You can create a trigger that automatically generates the taskNumber. For example: $sql = "SELECT (COALESCE(MAX(TASK_NUMBER), 0) + 1) AS NEW_TASK_NUMBER FROM PMT_MY_TASKS";$aResult = executeQuery($sql);@%taskNumber = $aResult[1]['NEW_TASK_NUMBER'];  Set this trigger to execute when a new case i...
by amosbatto
Mon Jan 15, 2018 9:53 pm
Forum: Developing processes & programming
Topic: How to model a process with variable parallel tasks/sub-processes?
Replies: 3
Views: 42

Re: How to model a process with variable parallel tasks/sub-processes?

You can create a variable number of asynchronous subprocesses with a loop like this: VariableNumberOfSubprocesses.png A counter variable can be set which keeps track of how many times the process has passed through the loop which is checked by the conditions in the exclusive gateways. (Note that two...
by amosbatto
Mon Jan 15, 2018 9:15 pm
Forum: Installation & Configuration
Topic: SMTP Error: Could not connect to SMTP host
Replies: 10
Views: 83

Re: SMTP Error: Could not connect to SMTP host

Have you configured your Gmail account to Enable IMAP and use Access for Less Secure Apps?

These settings worked for me:
EmailConfigurationGmail.png
EmailConfigurationGmail.png (31.57 KiB) Viewed 78 times

Go to advanced search