недеља, 25. децембар 2011.
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
субота, 12. новембар 2011.
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
субота, 19. фебруар 2011.
Imported AccountingRS.csv will be imported after completed typed column names on display down field
недеља, 09. јануар 2011.
CREATE TABLE "XX_CHARACTERISTICS"
( "AD_CLIENT_ID" NUMBER(10,0) DEFAULT NULL,
"XX_CHARACTERISTIC_ID" NUMBER(10,0) DEFAULT NULL,
"ASSETGROUP_ID" NUMBER(10,0) DEFAULT NULL,
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
понедељак, 03. јануар 2011.
CREATE TABLE "XX_MATERIAL"
( "AD_CLIENT_ID" NUMBER(10,0),
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
if :NEW."XX_MATERIAL_ID" is null then
select "XX_MATERIAL_SEQ".nextval into :NEW."XX_MATERIAL_ID" from dual;
ALTER TRIGGER "BI_XX_MATERIAL" ENABLE
from examples on:
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