|
|
| Line 1: |
Line 1: |
| − | This page will have all the Frequently Asked Questions about ADempiere. The information [initially] will be divided into three sections, so please contribute accordingly: | + | This page will have all the Frequently Asked Questions about ADempiere. |
| | | | |
| − | | + | '''Note: This page was moved to I moved the page to: [[HOWTOs_and_FAQs]]''' |
| − | == Basic Information ==
| + | |
| − | | + | |
| − | = Technical Info =
| + | |
| − | | + | |
| − | ==Creating Alert==
| + | |
| − | | + | |
| − | https://sourceforge.net/forum/message.php?msg_id=3938031
| + | |
| − | By: avdalen
| + | |
| − | | + | |
| − | I struggled with creating an Alert but now that I have it working, I would like
| + | |
| − | to give a couple of pointers for anyone else who is trying it.
| + | |
| − | | + | |
| − | <u>'''Pre-Requisites'''</u>
| + | |
| − | *Emailing must be working. Navigate to General Rules→Client Rules→Client to review, setup and test.
| + | |
| − | | + | |
| − | ===Example 1===
| + | |
| − | # Log in as an admin (or role with appropriate access)
| + | |
| − | # Navigate to Performance Analysis→Performance Measurement→Alert
| + | |
| − | # Create a new record, name it Orders (or anything you prefer)
| + | |
| − | # Select an existing alert processor or create a new one. This alert processor is the component that will send emails the actual emails.
| + | |
| − | # Enter subject and alert message
| + | |
| − | # Mark as Valid
| + | |
| − | # Save record
| + | |
| − | ====Alert Rule Tab====
| + | |
| − | # Create a new record, name it Orders Alert (or anything you prefer)
| + | |
| − | # In the sqlSelect field enter
| + | |
| − | #*"C_ORDER_ID","DOCUMENTNO","DOCSTATUS","TOTALLINES","GRANDTOTAL"
| + | |
| − | # In the sqlFrom field enter
| + | |
| − | #*C_ORDER
| + | |
| − | # In the sqlWhere field enter
| + | |
| − | #*ISACTIVE='Y' and ISSOTRX='Y'
| + | |
| − | # Mark as Valid
| + | |
| − | # Save record
| + | |
| − | ====Alert Recipient Tab====
| + | |
| − | # Create a new record
| + | |
| − | # Select a User/Contact
| + | |
| − | # Save record
| + | |
| − | | + | |
| − | ====Testing the new Alert====
| + | |
| − | Start the Application Server if not yet started.
| + | |
| − | | + | |
| − | Open compiereMonitor in a browser http://<your server>/compiereMonitor
| + | |
| − | Navigate to the Alert processor that you assigned to your Alert.
| + | |
| − | Click on <u>''run now''</u>
| + | |
| − | | + | |
| − | Navigate back to the Alert processor in the monitor and check the log.
| + | |
| − | | + | |
| − | If the alert failed, you would have to navigate back to the Alert window in
| + | |
| − | compiere. Once the necessary corrections have been made, you have to mark the
| + | |
| − | alert and alert rule as Valid again.
| + | |
| − | | + | |
| − | '''NOTE:''' Remember to restart the Application Server before you attempt to rerun the processor.
| + | |
| − | | + | |
| − | ----
| + | |
| − | ===Example 2===
| + | |
| − | | + | |
| − | Send an alert listing completed orders that are due for delivery within the next
| + | |
| − | 7 days.
| + | |
| − | | + | |
| − | Create the Alert as per Example 1 above but this time assign the ''sqlWhere clause'' on the '''Alert Tab''' as:
| + | |
| − | *sqlWhere clause
| + | |
| − | *:ISACTIVE='Y' and ISSOTRX='Y' and DOCSTATUS='CO' and ISDELIVERED='N' and DATEPROMISED between sysdate and (sysdate +7)
| + | |
| − | | + | |
| − | == Support Options ==
| + | |
This page will have all the Frequently Asked Questions about ADempiere.
