Posts Tagged

iDempiere

Migration from ADempiere 3.7 to iDempiere

Comments Off Adempiere ERP iDempiere migration Technical Uncategorized

A Story About Migration

We as a company were using Adempiere 3.7 and we were waiting for the release of 3.8 , we were waiting for the release from 5 years but Adempiere still had Adempiere 3.8 candidate version , which you can consider can not use in production version. Even the community was not active , there were differences between core members of Adempiere so there was a separate fork created. You can read the details here about how & why iDempiere was introduced. Result of this even community for Adempiere started drying up with less responses to the question in the forum. We decided we need to move ahead with the time and with the fast growth of iDempiere 1 to iDempiere 3.1 we were serious migrating from Adempiere 3.7 to iDempiere.

But here was the problem , iDempiere differenced themselves from Adempiere 3.6. So in the simple words iDempiere only provide migration scripts from Adempiere 3.6 to iDempiere. Adempiere 3.7 migration to iDempiere was technically no where provided & biggest problem was we were in oracle and wanted to install iDempiere with postgres ( Go open source ).

We had two options

    • In the first option
        • we can migrate Adempiere 3.7 oracle to Adempiere 3.7 postgres
        • Then Adempiere 3.7 postgres to Adempiere 3.6 ( any how ).
        • Now use the iDempiere migration scripts to migrate

      Surely not the best of the option , very time consuming and repetitive steps.

    • Second option was to directly take data from Adempiere 3.7 oracle and migrate to iDempiere .

I used the second option , We are now live with iDempiere 3.1 migrated from Adempiere 3.7.

Continuous automated migrations

I used Talend for the migration. I created automated jobs with the job flow. This process was/is completely automated.

I ran these migration on different dates for creating different UAT systems.

Things needs to be migrated

  • Customisations ( Window tab and fields )
  • Data ( All the transactional , master , log data )
  • Functionality
  • Reports

If you have any additional questions please free to contact me, drop a comment in the comment box.

Installing iDempiere within eclipse (Development setup)

Comments Off Development Eclipse Installation installation Uncategorized

This post will help you to install iDempiere development environment.

I have tested this installation for

  1. iDempiere 3.1 using this with java 7 update 80 and Eclipse version  Luna Service Release 2 (4.4.2)
  2. iDempiere 4.1 using java 8 update 112 and Eclipse Version: Neon.2 Release (4.6.2) on my MacBook.

Following are the instruction needs to be followed step by step. If java and Postgres is already installed then skip first two steps.

Install JDK

Database

Install PostgreSQL

Mercurial

For managing versions and source code control we need to install Mercurial . It is an open source application. Find the more info & simple useful tutorial. To download the mercurial use following link. It provides a graphical installer.

Clone iDempiere

Download iDempiere source tree

hg clone https://bitbucket.org/idempiere/idempiere idempiere

Eclipse

Download eclipse (I am using luna) . There are new versions of eclipse available to download. I have not tested with them.



    

  • https://eclipse.org/luna/
    • 

  • 

    Eclipse workspace setup - Select the iDempiere cloned directory as the workspace.
    

    • 

  • Install the eclipse buckminster

      

    • You need the Buckminster Plugin to assemble the iDempiere project. For this go to  (Menu in Eclipse: Help > Install New Software > Add)

        

      • Add name as buckminster
        • 

      • location – http://download.eclipse.org/tools/buckminster/updates-4.4
        • 

      

      • 

    • Now it will load all the available packages for the installation select only

        

      • Buckminster – Core
        • 

      • Buckminster – Maven support
        • 

      • Buckminster – PDE support
        • 

      

      • 

    

    • 

  • Install mercurial plugin


    • 



 


This is one part of development setup where we finished .


Now to get the iDempiere project into the eclipse.


    

  • Create a targetPlatform – Go to Eclipse –> Preferences –>Plug in Development—>targetPlatform

      

    • Click on add
      • 

    • Nothing: Start with an empty target definition press next
      • 

    • give target name I prefer giving iDempiere
      • 

    • add —> Directory —> Location —> click on variable select workspace_loc
      • 

    • then type targetPlatfrom so the location will look like ${workspace_loc}/targetPlatform .
      • 

    • set this as default
      • 

    

    • 

  • Click on File  —-> Import —-> Buckminster —-> Materialize from Buckminster MSPEC, CQUERY or BOM
    • 

  • Click on next and select mpsec from clone idempiere directory “org.adempiere.sdk-feature” folder
    • 

  • make sure that you have active internet connection through out this process.
    • 

  • now the magic will happen based on the machine
    • 



Click on Run Configurations


    

  • Select eclipse application
    • 

  • install.console.app click on run and install the application on console instructions are given here. This will create configuration file for server.
    • 

  • then run server.product.
    • 



I hope this tutorial will help you to install iDempiere development environment.

									

								

															

									

										

																						
											Why iDempiere
										

										
										
										

											
												
											
											
											
												Comments Off											
											
																									
															Functional iDempiere Uncategorized														
																								
																					
 
									

									
									
																					

													
														idempiere_home													
												

																				
									
									

										
 


iDempiere is best suitable ERP for small and medium businesses.


Following are the features why I think iDempiere is best.


    

  1. Active community support https://groups.google.com/forum/#!forum/idempiere
    2. 

  2. Technical upgrades are very frequent
    3. 

  3. Plugin architecture , we can plugins for our needs install and play instead of playing and changing or deploying the whole application. The second feature of iDempiere are the plug-ins to modify or extend the ERP, CRM and SCM functionality.
    4. 

  4. Available plugin library http://wiki.idempiere.org/en/Category:Available_Plugins
    5. 

  5. CHUCK: it make it easy to do my job… I do not find myself fighting the software
    6. 



Functional


Most of the customers I work with are between $X and $Y in yearly turnover and operate in distribution and manufacturing industries. iDempiere has the feature set to support this size organization well. 


    

  1.  iDempiere is an open source Enterprise Resource Planning (ERP) software. It has also customer relationship management (CRM) and supply chain management (SCM) functions. It is in contrast to proprietary or most other open source ERP solutions driven only by a community of supporters.
    2. 

  2. Manufacturing – Plugin available manufacturing plugin , Plugin is available here
    3. 

  3. Use friendly web UI.
    4. 

  4. iDempiere supports:

      

    1. Multiple tenants
      2. 

    2. Multiple organizations (branches, plants, etc.)
      3. 

    3. Multiple languages (29 localizations; mixed access in a single installation is possible)
      4. 

    4. Multiple currencies
      5. 

    5. Multiple accounting schemas
      6. 

    

    5. 



Cost


As an integrator, I do not like dealing with selling software. I know of no customers that like ‘paying’ for software. Because iDempiere is free and open source, I get to specialize in what I do best – help customize iDempiere for specific needs.