Skip to main content

Posts

Adding privilege for PostgreSQL to access the databases from any point in network

In my local network each machine may have PostgreSQL database. For accessing the PostgreSQL databases in one machine to any machine, we need to add some permissions to the PostgreSQL configuration file. For accessing PostgreSQL databases in Machine1 to Machine2, we need to change the file pg_hba.conf (C:\Program Files\PostgreSQL\9.2\data). The changes are the following : Add the line on IPv4 local connections : host    all             all             0.0.0.0/0 trust Hence the final code as : # IPv4 local connections: host    all             all             127.0.0.1/32            md5 host    all             all             0.0.0.0/0 trust The file pg_hba.conf has attached here. Just replace the file in the location  C:\Program Files\PostgreSQL\9.2\data. # PostgreSQL Client Authentication Configuration File # =================================================== # # Refer to the "Client Authentication" section in the PostgreSQL # documentation for

Sending SMS using java code and Clickatell API

ClickatellSMS .java /**  * For executing the code you may need the following requirements 1. Clickatell  * account : You may have a user name, password and an API id. 2. Need to import  * two external jar files i. smsj-20051126.jar (Source :  * https://sourceforge.net/projects/smsj/files/) ii. slf4j-simple-1.0-beta4.jar  * (Source :  * http://www.findjar.com/jar/org/slf4j/slf4j-simple/1.0-beta4/slf4j-simple  * -1.0-beta4.jar.html;jsessionid=74226B10CDFB28C183745181681836C7)  */ import java.io.IOException; import java.util.Properties; import org.marre.sms.SmsAddress; import org.marre.sms.SmsException; import org.marre.sms.SmsTextMessage; import org.marre.sms.transport.SmsTransport; import org.marre.sms.transport.SmsTransportManager; public class ClickatellSMS { /** * @param args */ public static void main(String[] args) { // The username, password and apiid is sent to the clickatell transport // in a Properties Properties props = new

How can I change appearance of ADempiere ERP webui login page?

In trunk/zkwebui/theme/default there are a couple of files: login-left.zul, vendor-logo.zul, version-info.zul etc. File version-info.zul contains the server info data. You can change these files so the login page appears as you please. In file vendor-logo.zul there is the possibility of customization to own logo, links etc. Configuring the files in trunk/zkwebui/theme/default enables you to change the appearance of the webui login page to your needs. A build is needed.

Message box in ADempiere ERP

ADempiere have its own standard in its pop up messages. Normally we can use JOptionPane provided by  java. But you need to compromise its look and feel in your application. The following are the commonly used pop up box menthods in ADempiere in different instances. 1. mTab.fireDataStatusEEvent("Already open access","message",true); Used in callouts. 2. log.saveError("Invalid Date", message); Used in model classes. 3. ADialog.error(m_WindowNo, this, "FillMandatory", sb.toString());             return false; Used in client classes. If it is used in the higher build priority classes, you may have build error. 4. throw new IllegalStateException("Could not create accrual entry"); Used to throw exceptions in your code.

Adempiere Schema Diagram

From the below mentioned link, you may get the entire table schema in adempiere. http://globalqss.com/idempiere/1.0c/schemaspy/MaterialManagement/relationships.html

Cleanup of Ant build scripts

ADempiere 370LTS contains the following Ant build scripts which are required to build the entire system: tools/build.xml base/build.xml extend/build.xml client/build.xml JasperReports/build.xml serverRoot/build.xml serverApps/build.xml webStore/build.xml webCM/build.xml sqlj/build.xml posterita/posterita/build.xml zkwebui/build.xml install/build.xml More details in the following link http://www.adempiere.com/FR3409987_Cleanup_of_Ant_build_scripts

To add a external jar to ADempiere ERP

1. Get the jar file 2. Edit the Adempiere370\tools\Build.xml 3. Copy the jar file to Adempiere370\tools\ 4. Add the code fragment in the xml file     both in CSTools and CCTools eg:     <!-- Joda                -->     <zipfileset src="lib/joda-time-2.3.jar">         <patternset refid="manifest.exclude" />     </zipfileset> 5. If we are using the jar objects in base, client or zkwebui, edit respective build.xml files