ADempiere 3.1.6 with PostgreSQL 8.4 and 9.1

When I was testing ADempiere 3.1.6 with PostgreSQL 9.1 I was found error when I was trying to attach file on customers/request. So I was trying to install ADempiere 3.1.6 with oracle 10.2.0.1 express and PostgreSQL 8.4, and theres no error when I was attach some file on services requests (pdf/xls/txt/png..). I was post questions on https://sourceforge.net/projects/adempiere/forums/forum/610548/topic/4896630/index/page/1


Fig above present how to import Adempiere_pg.dmp file from home../Adempiere/data/Adempiere_pg.dmp with all table, dates, views, functions on PostgreSQL 9.1


With PostgreSQL 9.1 should be set pga_hg.conf as above


Setting PostgreSQL 8.4 :pga_hg.conf file on /home/nadrog/PostgreSQL/8.4/data as root user


Fig set fileds for setup

Adempiere 3.1.6 Add Serbian in Login select list

Version ADempiere 3.1.6 (and older and some higher version of ADempiere ) dont have Serbian Language into Login form in select language. This is very simple to add new Language or change existing, or set default one of the prefer language. Theres path where is located java files which should be changed or added -- ../looks/src/org/compiere /plaf/PlafRes_sr.java ../looks/src/org/compiere/util/IniRes_sr.java ../looks/src/org/compiere/util/Language.java.
And for full transformation, should be add translation from : http://sourceforge.net/projects/lsr/ -- with adding Serbia_RS and set as main language.

New java file should be add :PlafRes_sr.java

private static final String AD_Language_sr_RS = "sr_RS" -- should be add into Language.java

AD_Language should be add into Language.java

compile all java files

Adempiere 3.6.0LTS COA import

First time, when I was trying to test Adempiere 3.55 version I was trying to import Serbian Chart of Account (COA -kontni plan republike srbije) but theres error becouse csv have , between columns, and Adempiere 3.6.0LTS have import form, so I m trying again import this csv file, looking at , (Separator character " , TAB ... between columns ) and creating new import format for i_account tables, older versions (353a and 354a was imported all with no problems). This functionality extends importing making it easily


Imported AccountingRS.csv will be imported after completed typed column names on display down field

Extend Assets

Assets have Assets groups as simple extends, could be possible adding new atributes, as characteristics, characteristic values, rates, other transactional values etc, this is simple way how can be extend assets from adempiere version 3.1.0. Whith newly version this can be easy (need creating classes from GenerateModel.java file Adempiere version 354a).
CREATE TABLE "XX_CHARACTERISTICS"
( "AD_CLIENT_ID" NUMBER(10,0) DEFAULT NULL,
"AD_ORG_ID" NUMBER(10,0),
"ISACTIVE" CHAR(1),
"CREATED" DATE,
"CREATEDBY" NUMBER(10,0),
"UPDATED" DATE,
"UPDATEDBY" NUMBER(10,0),
"A_ASSET_ID" NUMBER(10,0),
"XX_CHARACTERISTIC_ID" NUMBER(10,0) DEFAULT NULL,
"ASSETGROUP_ID" NUMBER(10,0) DEFAULT NULL,
"NAME" VARCHAR2(100),
"CREATED_BY" VARCHAR2(100),
"CREATED_DATE" DATE,
"UPDATED_BY" VARCHAR2(100),
"UPDATED_DATE" DATE,
CONSTRAINT "XX_CHARACTERISTIC_PK" PRIMARY KEY ("XX_CHARACTERISTIC_ID") ENABLE
)
/

Fig 1 Creating form from table


fig 2 Steps for calling and creating forms from tables


Fig 3 Functional Form for insert/update new created table characteristics

Adding new table in Adempiere 3.1.0

Customisation of Adempiere 3.1.0 is very easy, I was creating new table
CREATE TABLE "XX_MATERIAL"
( "AD_CLIENT_ID" NUMBER(10,0),
"AD_ORG_ID" NUMBER(10,0),
"ISACTIVE" CHAR(1),
"CREATED" DATE,
"CREATEDBY" NUMBER(10,0),
"UPDATED" DATE,
"UPDATEDBY" NUMBER(10,0),
"XX_MATERIAL_ID" NUMBER(10,0),
"MATNR" NUMBER(10,2),
"COLORNR" NUMBER(10,2),
"NAME" VARCHAR2(100),
"NAMESHORT" VARCHAR2(100),
CONSTRAINT "XX_MATERIAL_PK" PRIMARY KEY ("XX_MATERIAL_ID") ENABLE
)
/


CREATE OR REPLACE TRIGGER "BI_XX_MATERIAL"
before insert on "XX_MATERIAL"
for each row
begin
if :NEW."XX_MATERIAL_ID" is null then
select "XX_MATERIAL_SEQ".nextval into :NEW."XX_MATERIAL_ID" from dual;
end if;
end;

/
ALTER TRIGGER "BI_XX_MATERIAL" ENABLE
/
from examples on:
http://www.adempiere.com/index.php/NewWindow
and try to integrated this new table into Adempiere. This is one way, when Adempiere is install on computer, so can be customised by Administrator, other way is descibe on link above, change from trunk, from source code, include
1)Creating new table(s)
2)Dump new Adempiere.dmp database file with new creating tables
3)Creating Persistence objects with all new tables with GenerateModel.java code
4)building all code with new classes
This is 1 way, manualy customisation
Fig 1: Creating new window


Fig 1.1 Acces level and role, users who can modify data from new created table XX_MATERIAL


Fig 1.2 Fields from table XX_MATERIAL


Fig 2: MENU need call New Window created from XX_MATERIAL, I was placed into assets, could be in other hierarchy, assets can be extend and need change, in Republic of Serbia theres taxes and rates localy created, called STOPA AMORTIZACIJE, purchasing date of assets (DATUM NABAVKE OSNOVNOG SREDSTVA), other attribut rate2 called REVALORIZACIJA, account relation is good have 0230 values from accounts and 0239 as changed values, asset groups is determined by low as sub accounts, and other parameters can be changed or added. Fixed Asset Management can extend assets with this customised functionality, adding new tables and creating references (forein keys). This firs method discibe simlple modification of Adempiere 3.1.0 most complicated way is change into TRUNK of Adempiere 3.1.0 with GeneratedModel.java and practicaly reinstalation of all code.


Fig 3 : Table XX_MATERIAL have automaticaly created Persistence Objects (PO) and work fine

Fig 4: Invoices from Republic of Serbia have field called PIB, theres need add new field PIB varchar2(255) and again complete call NEW c_invoice table created New Window and New Form, on easy way with default lengh of db colum look like above picture