Most parts done

I’ve installed most parts of it done. (for the desktop that is)

What I still have to do:

  • Install and make the server working
  • Test it so that a web-server inside VBox should be accessed outside the chain, in the guest OS
  • If this is done, install the following:
    • Nexus Maven repository
    • PostgreSQL database
    • Adempiere Server
    • Apache Web server
    • Team City build server (or Hudson)
  • Make a backup of this installation so that when I screwed up later on, I can immediately put it up.

Server specs computer hardware

Here’s the desktop specs:

For buying:
Orient Transformer with 600W Yellow/Red/Gray        1,550.00

AMD Athlon II X3 400 3.0Ghz                            3,250.00

Emaxx AMD880HD3-Pro                                    2,700.00

4GB DDR3 1333 Emaxx (2-yr wty)                        2,100.00        8 GB
4GB DDR3 1333 Geil Single (2-yr wty)                2,350.00

HDD: (for data storage)
500GB Seagate 7200RPM 16MB (2-yr wty)                1,950.00
500GB Transcend Storejet with Anti-shock            3,650.00

Graphics: (for monitor)
Palit GF 9800GT 512MB 256Bit DDR3 Green Edition        3,600.00

A4Tech G7-630-5 2.4G Wireless Optical                  690.00

WiFi: (for internet access)
TP-Link TL-WN821N USB WiFi Adapter                    1,150.00        2 pcs

UPS: (for power outages; no server should be down)
1200VA Powergarde UPS with AVR                        3,400.00        1

Optical Drive: (for data backup and server installation)
Liteon ETAU108-32 8X External DVD-RW                2,150.00        1

Total:                                                31,240.00

Network cabling:
UTP Cable (per box)                                    1,250.00        1 box
RJ 45 Connector                                            3.00        20 pcs

Part II: Running Adempiere on IntelliJ IDEA

Part II: Running Adempiere on IntelliJ IDEA

This part is a continuation of the first part which is creating projects up to compiling Adempiere in IntelliJ IDEA.  Part 1: Adempiere on IDEA here. Running Adempiere is even easier that the previous part.

In the first part, we have built the Adempiere with the IntelliJ IDEA’s own build tool.  Now, we will build Adempiere to package and prepare it for running inside an Application Server.   We will use Glassfish as an Application Server.

The build.xml

The build.xml is an Ant build script necessary for preparing, compiling and packaging Adempiere.  Adempiere guys created it for this purpose.   I am writing an upgrade to the Ant build script to use a Maven build script for Adempiere.

The default target of build.xml (found in utils_dev\build.xml) is the complete target.  The complete target creates all jar, dependencies, and everything else.  End output is the installable Adempiere zip file.

  1. Click to open the Ant Build tool window in IntelliJ IDEA
  2. Click the “+” button to add the build.xml
  3. Find the utils_dev\build.xml
  4. Click OK to add.
  5. You will see an “adempiere” in the ant build tool window
  6. Open it and double click the “complete” target to execute.

Figure 9

The result of building should be like this and no error would occur.  If there is for example a delete error, just re-run the complete target.

Figure 10

Running Adempiere Setup

  1. Inside the trunk directory, double click on Adempiere subdirectory
  2. Click RUN_Setup.bat
  3. Once done, you can now double click on the RUN_Adempiere.bat


I have used for the layout and organization.

Part I: Adempiere in IntelliJ IDEA

Adempiere in IntelliJ IDEA

Part I: Creating Adempiere project in IntelliJ IDEA

I am an IntelliJ IDEA fanatic since its version 5.  It eases all my development efforts especially its shortcut keys in its Editor and the Code refactorings as well as Inspection tool which generally guides me to avoid things that I overlooked.  This is the part 1 and click here for the part 2: running adempiere in idea.

Pre requisites

You need to have the following running on your system no matter what OS you use:

  1. JDK 1.6 – You can download this from the Sun website.
  2. IntelliJ IDEA 9 Ultimate – You can download trial version of this from
  3. Subversion Client –

You need to do the following:

  1. Install IntelliJ IDEA 9, JDK 1.6 and the Subversion Client.
  2. Set JAVA_HOME environment variable to point to your JDK 1.6 installation directory.
    1. For Windows:
      1. i.      JAVA_HOME = C:\Program Files\Java\jdk1.6.0_16
      2. Set the PATH environment variable to have JAVA_HOME and Subversion installation directory exist
        1. For Windows:
          1. i.      PATH = %PATH%;%JAVA_HOME%\bin; C:\Program Files\Subversion\bin;

Getting the Adempiere Source from the Online repository (

Repository location:

  1. Open the IntelliJ IDEA
  2. Once open, Click the Version Control menu and navigate to checkout from version control.
  3. Click the Subversion
    1. Click the “+” symbol and add the repository above.  It will show you figure 1 below.

Figure 1

  1. Once the repository has been loaded, right click it and click on Checkout
  2. Now, select the directory upon which you want to store the Adempiere trunk source.
    1. i.      In my case it’s in C:\workspace\adempiere\trunk

Making an IntelliJ IDEA Project

Adempiere by default does not have an IntelliJ IDEA project setting.  It does have however, a .classpath and .project which makes it an Eclipse project and nbproject which makes it a Netbeans project.

  1. In the main display of IntelliJ IDEA, Click on Create New Project
  2. Once the New project dialog appears, click the Import project from external model (because we will base it on the already defined eclipse project) as shown below Figure 2.

Figure 2

  1. Click Next and Select “Eclipse”
  2. Now, select the trunk directory and check the “Link created IntelliJ IDEA modules to Eclipse project files”.  Do not change the default which is “Create module files near .classpath files” and “.idea (directory based)” project file format.  Image shown below Figure 3.

Figure 3

  1. Click Next
  2. Check the adempiereTrunk and Click the Finish button.
  3. If the Subversion asks you about adding the newly created files to the repository, click No.

Now as an end result, there will be one project module present “adempiereTrunk”.  When you view its module settings, all sources locate each directory.  We will call it the parent project.  We will proceed with the creation of the child projects.

Making the Child projects

Make the child modules in the adempiereTrunk parent folder by doing the following steps:

  1. Right click the adempiereTrunk in the Project tool window
  2. Click the New à Module

Figure 4

  1. In the New Module dialog box, select the Import module from external model
  2. Click Next and Select Eclipse as external model
  3. Click Next
  4. Find the module you want to import
  5. Check the Link created IntelliJ IDEA modules to Eclipse project files
  6. Check also the Create module files near .classpath files

Figure 5

  1. Click Next
  2. Select the Eclipse project you want to import as module
  3. Click Finish.

In the end, your Project tool window might look like the above image in Figure 4.

Import the modules in this order to minimize errors of dependency.  Although this should not be a problem since IntelliJ will still treat correct dependency even if you imported the dependent module ahead of the depended module:

  1. lib
  2. tools
  3. serverApps
  4. JasperReportTools
  5. Base
  6. Client
  7. Data
  8. JasperReports
  9. JasperReportsWebApp
  10. Db
  11. Extend
  12. Jboss
  13. serverRoot
  14. install
  15. sqlj
  16. webStore
  17. doc
  18. looks
  19. interfaces
  20. launch
  21. migration
  22. packages
  23. posterita
  24. utils
  25. utils_dev
  26. webCM
  27. zkwebui
  28. glassfishfacet
  29. jbossfacet

Once you’ve successfully imported all projects as a module in IntelliJ IDEA, you can now click the Rebuild Project under the Build menu.   If there are errors in JasperReportsWebApp, follow instructions below.

Resolving error in JasperReportsWebApp

  1. Right click the JasperReportsWebApp
  2. Click on the Module Settings
  3. Click the Dependencies tab
  4. Click Add à Module Dependencies
  5. Find and add the “base”, then click OK
  6. Click Add à Single Entry Module Library
  7. You will be asked for the Path of the jars, enter the tools\lib folder i.e. C:\workspace\adempiere\trunk\tools\lib\
  8. Select all the jars under the folder as shown below then click OK

Figure 6

  1. Once done, you will end up like this as shown below.  Click OK button when finished.

Figure 7

Compiling Adempiere in IntelliJ IDEA

All else successful in the above configuration, we can now compile Adempiere project.

  1. Click the Build menu
  2. Click Rebuild Project

This will show a successful compilation as shown below.  No errors would be found, only warnings.

Figure 8

If you wanted to go back to Eclipse as an IDE; it should have no problems since the classpath is already linked with both IDE’s.  In Eclipse, select all and then press F5 to refresh.  Click Clean and rebuild.  It should have nil errors.

Wishlist status

Great keyboard that I found.  Added to my wishlist.

  • Saitek Eclipse Illuminated keyboard – very cool keyboard.
  • Make a book in Photography (dedicated to my late grand father since he loves to travel and view scenery very much – although he doesn’t tell it when asked)
  • Learn Mixing and start DJ’ing
  • Behringer DDM4000 (bought 1 already, and ITS working!)
  • Allen and Heath – Xone 1D MIDI Controller – use to midi control Ableton and Traktor.  This mixer is way cool.  It has accurate controls with slight differential (about +/- 1) which is nothing compared with Behringer controls.  I can accurately control my Traktor and Ableton for this.  This also serve as a replacement for the BCD3000 that I want to buy.  I will still have to experiment on this and the midi mappings.
  • Akai MPK49 Keyboard MIDI Controller – Im thinking what’s the use of this? I might not buy it; although its very lucrative since the price is only 299USD!!! Normal price for it is 500-600USD.   For its price of 299, its a cheap buy.  Features include a drum machine, 8 faders, knobs and buttons, 49 keys including sharps.  Beats the hell out of Novation Remote SL 49.
  • Learn to construct, compose, and control myself – especially my single mindedness of thought.  This is the most important.
  • Fuck me! I need a constant reminder of what to do; what to focus on; and what to deliver and ultimately prove myself every now and then.

Goals (some other goals that I wish I could do – but not)

  • Program a stock trading simulation with customizable indicators
  • Program the inventory system based on Adempiere
  • Set my mind to spot a niche market and develop a business out of that
  • Beat my dad!!! Outwit, out smart, and out play in the life’s survival game.

Thats it for now.  I hope I could accomplish all that.

Updates for the t-shirt biz

We just bought a new Digital heat-press machine last Saturday.  We haven’t tested it yet since we still have a printer to buy.  So no t-shirt outputs yet.  We are working on it within the week and we hope to produce sample t-shirts.

The digital heat press machine transaction took about 5 hours since we opted that the merchant teaches us the basics and the fundamentals of t-shirt transfer business.  For reference, we will post the materials in the comment side.

Tasks delegation would be:  I will handle the marketing side.  Jeff will be the finance and Mike will be the operations.  Of course its not done without the output product – we will all be the production workhorse.

Using the Freemind tool, click here for Mike’s todo list.  Click here for mine.

We have updated / created the following for use:

On the side note:

My mixer just arrived last Oct. 17. I was really happy for it.  The transaction was very fast and I didn’t expect it to be – the last time I ordered from the net took more than 1 month to be delivered.  Now, the delivery works wonders – just 1 week.   I tested the Pioneer SE-DJ5000 headset for professional DJ and it wows me – until now I’m exited to test the mixer but I cant since its power input is at 120 volts.  As soon as I find an AVR power regulator, I will test it right away.  Cheers!

Opensource ERP to consider worthy

Here’s the list of Java-based Opensource ERP that I would like to consider in my upcoming retail biz that uses inventory (any suggestions are welcome):

My criteria would be:

  1. Readiness to use
  2. Has a huge client base
  3. Flexibility in development if I would like to extend
  4. Architecture or design of the tool, and
  5. Scalability and adaptability as your biz grows.


  • Adempiere – I dont know how it got me into this, but most likely this will be the one that I will use and extend if the functionality is insufficient.  For one, Adempiere is previously Compiere (the pioneer in open source ERP).  Having said that, it has all the functionality of Compiere, uses Application Dictionaries (model driven), uses business rule engine through callbacks (and one can plugin a bash code as a biz rule).  It also is UI agnostic – create additional customization and it will exist as both in Swing and DHTML (AJAX).  This model and flexibility suits me best.

Adempiere lacks a good website and organize documentation.  Its forums and source codes are quite messy and needs a divine intervention.  Resources are many and tend to spread out.  Has books develop for it.  Has a straight one month learning curve.  Posterita (POS) is integrated as much as its client POS.


  • Openbravo ERP – is an open source ERP solution designed specifically for the SME (small to midsize firm). Developed in a web based environment, it includes many robust functionalities which are considered part of the extended ERP: procurement and warehouse management, project and service management, production management, and financial management. Additionally, this same application seemlessly integrates the rest of the areas, starting with a management scope directly helping clients with its CRM (Customer Relationship Management) and BI (Business Intelligence).

In comparison with Adempiere, Openbravo has a very clean interface, organized workflows, and easily extensible.  But Adempiere is more complete and more business focus.  Also, although they claim that the POS is integrated in the Openbravo ERP, it relies on a third party application, and is not fully integrated.  The business intelligence and reporting tool is top of the class and exceeds any opensource ERP.  Has a huge user and client base.


  • Apache OfBiz – Apache OFBiz is a foundation and starting point for reliable, secure and scalable enterprise solutions. Use it out-of-the-box (OOTB) or customize to suite even your most challenging business needs. With OFBiz in place, you can get started right away and then grow your operations as your business grows, without the huge deployment and maintenance costs of traditional enterprise automation systems.

OFBiz is more leaning towards e-commerce, has a huge client base, and designed from the ground up to be customizable (but not easily for me).  They have a good and organized documentation, no restrictions of the license, and provides a good architecture for its development; but it lacks user friendliness and readiness to use; it is very huge and requires a massive amount of hardware resources.  Bottomline – OFBiz is a good ERP oriented towards big enterprises that is willing to implement its own IT.  In my case, I am a small one. =(

Here are others that I think did not pass worth considering:

  • JFire – is an opensource (LGPL) ERP Framework, build with technologies like J2EE 1.4, JDO 2.0 and Eclipse RCP 3.2. It is designed to be highly customizable and the core framework can also be used for other purposes then ERP.  However this lacks functionality and readiness of use.
  • JAllInOne – is an open source ERP/CRM java application having a Swing front-end. It is a Rich Internet Application so the front-end can remotely comunicate with the server-side layer of JAllInOne via HTTP protocol. Main features: Sales, Purchases, Warehouse, Bill of materials and production, Accounting, Agenda, CRM, Customers and contacts hierarchies, Callouts and appoinments management, Document management, Users and roles management, database schema management, grids and forms customization, reporting solution based on Jasper Report, reports customization.
  • EBI Neutrino – is a Framework for Enterprise Resource Planing (ERP) and Customer Relation Mangement(CRM) software solution that combines power of distribution, inventory, E-Commerce, accounting and workflow.
  • Wavelet EMP – is a web-based ERP built on J2EE framework that caters for the needs of franchises and chain stores. It includes CRM, Point of Sales, Inventory Management, Warehouse Management, System Administration, Accounting, Finance, Supply Chain, Distribution & Logistic, Trading modules, etc.
  • Opentaps – a fork of Apache OfBiz.

[not completed]