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

To Debug Adempiere Web UI or Server

1. Open Adempiere\jboss\bin\run.bat 2. There is a command "rem set JAVA_OPTS=-Xdebug -Xrunjdwp:transport=dt_socket,address=8787,server=y,suspend=y %JAVA_OPTS%" 3. delete "rem" from the code , So server will listen to the port 8787 4. open eclipse -> Debug Configuration -> Remote Java Application , Then, create a new configuraion, Give the configuration name : 'AdempiereWeb'(anything) Give the Project Name, Connection Type : Standard(Socket Attach) Host : localhost Port : 8787 5. Run Adempiere370\utils\RUN_Server2.bat It will start and waiting to the response from the port 8787. 6. Debug the 'AdempiereWeb' configuration 7 set the debug break points on the class, It will detect the break points ; DONE

Installing ADempiere 3.7.0 on Ubuntu 11.04

Installing ADempiere 3.7.0 on Ubuntu 11.04 This is a simple how to install ADempiere 3.7.0 on Ubuntu 11.04. There are alot of installation How-To's, the reason I believe this might be useful is that the new 3.7.0 has some little twist in the installation and lots of the installation manuals here in the wiki are outdated. I will keep it as simple as possible to allow anyone new to ADempiere and even to Ubuntu to be able to get ADempiere running. Contents   [ hide ] 1   OS Installation 2   ADempiere Pre-Installation Routine 3   PostgreSQL Installation 4   ADempiere Installation 5   ADempiere Start OS Installation Install Ubuntu 11.04 directly on a PC or as a VM. During the installation, set "adempiere" as the username, that will make things a bit easier later on ADempiere Pre-Installation Routine After the installation finishes, lets get going with downloading the needed files. Open a Terminal Screen and type the following: wget http:

GIT

1. Installing on Windows Installing Git on Windows is very easy. The msysGit project has one of the easier installation procedures. Simply download the installer exe file from the GitHub page, and run it: To download GIT click here After it’s installed, you have both a command-line version (including an SSH client that will come in handy later) and the standard GUI. The GuI version is more user friendly and easy to use but there are so many features missing in the GUI version. So it is more useful to use the command line version of GIT which is called GIT bash. Working with GIT The Three States Now, pay attention. This is the main thing to remember about Git if you want the rest of your learning process to go smoothly. Git has three main states that your files can reside in: committed, modified, and staged. Committed means that the data is safely stored in your local database. Modified means that you have changed the file but have not committed it to your database y

Installation of Adempiere ERP on Windows

              This installation instruction is intended for initial installations where the database, application server and client all run on the same machine. For more complex installations, see   Installation Steps . An installation can take as little as 15 or 20 minutes if you start with the required downloads and do everything correctly. Other alternatives you might want to investigate are the   Windows Installer   or VMWare/VirtualBox AVA packages. However, the following method will give you much more control over the installation including upgrades with the latest patches and scripts. Before you begin, download each of the following packages: §   Java SE Development Kit   - Get the latest from   http://java.sun.com/javase/downloads/index.jsp . You only need the   JDK   without JavaFX, EE or NetBeans bundles. §   Postgre SQL   - Get the latest Windows install from   http://www.postgresql.org/download/windows . §   ADempiere Latest Release   - Download the latest Ad