Difference between revisions of "AdempiereWebsite/FAQ"
(→Technical Info) |
m (I just did some reformatting of the page to make it more readable) |
||
Line 4: | Line 4: | ||
== Basic Information == | == Basic Information == | ||
− | + | = Technical Info = | |
− | + | ==Creating Alert== | |
https://sourceforge.net/forum/message.php?msg_id=3938031 | https://sourceforge.net/forum/message.php?msg_id=3938031 | ||
Line 14: | Line 14: | ||
to give a couple of pointers for anyone else who is trying it. | 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 | + | *Emailing must be working. Navigate to General Rules→Client Rules→Client to review, setup and test. |
− | review, setup and test. | + | |
− | 1 | + | ===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) | |
− | is the component that will send emails the actual emails. | + | # 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 | + | # Save record |
− | ==Alert Rule Tab | + | ====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" | + | #*"C_ORDER_ID","DOCUMENTNO","DOCSTATUS","TOTALLINES","GRANDTOTAL" |
− | + | # In the sqlFrom field enter | |
− | C_ORDER | + | #*C_ORDER |
− | + | # In the sqlWhere field enter | |
− | ISACTIVE='Y' and ISSOTRX='Y' | + | #*ISACTIVE='Y' and ISSOTRX='Y' |
− | + | # Mark as Valid | |
− | Save record | + | # Save record |
− | ==Alert Recipient Tab | + | ====Alert Recipient Tab==== |
− | + | # Create a new record | |
− | + | # Select a User/Contact | |
− | Save record | + | # Save record |
+ | ====Testing the new Alert==== | ||
Start the Application Server if not yet started. | Start the Application Server if not yet started. | ||
Open compiereMonitor in a browser http://<your server>/compiereMonitor | Open compiereMonitor in a browser http://<your server>/compiereMonitor | ||
Navigate to the Alert processor that you assigned to your Alert. | Navigate to the Alert processor that you assigned to your Alert. | ||
− | Click on run now | + | Click on <u>''run now''</u> |
Navigate back to the Alert processor in the monitor and check the log. | Navigate back to the Alert processor in the monitor and check the log. | ||
Line 53: | Line 53: | ||
alert and alert rule as Valid again. | alert and alert rule as Valid again. | ||
− | Remember to restart the Application Server before you attempt to rerun | + | '''NOTE:''' Remember to restart the Application Server before you attempt to rerun the processor. |
− | the processor. | + | |
− | ====== | + | ---- |
− | + | ===Example 2=== | |
− | Send alert listing completed | + | Send an alert listing completed orders that are due for delivery within the next |
− | 7 days | + | 7 days. |
− | sqlWhere clause | + | Create the Alert as per Example 1 above but this time assign the ''sqlWhere clause'' on the '''Alert Tab''' as: |
− | ISACTIVE='Y' and ISSOTRX='Y' and DOCSTATUS='CO' and ISDELIVERED='N' and | + | *sqlWhere clause |
− | DATEPROMISED | + | *:ISACTIVE='Y' and ISSOTRX='Y' and DOCSTATUS='CO' and ISDELIVERED='N' and DATEPROMISED between sysdate and (sysdate +7) |
− | between sysdate and (sysdate +7) | + | |
== Support Options == | == Support Options == |
Revision as of 06:33, 1 October 2006
This page will have all the Frequently Asked Questions about ADempiere. The information [initially] will be divided into three sections, so please contribute accordingly:
Contents
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.
Pre-Requisites
- 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 run now
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)