Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0007129

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] 01. General setup

major

always

2009-01-26 11:21

2009-03-02 07:56

Reporter

villind

View Status

public

Assigned To

shuehner

Priority

high

Resolution

fixed

Fixed in Version

pi

Status

closed

Fix in branch

pi

Fixed in SCM revision

Projection

none

ETA

none

Target Version

OS

Any

Database

PostgreSQL

Java version

OS Version

Database version

8.3

Ant version

Product Version

2.40MP1

SCM revision

Review Assigned To

Web browser

Modules

Core

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0007129: Import accounts does not import element level on postgresql

Description

Element level information is not imported from the chart of accounts on initial client setup.

Steps To Reproduce

1. Create a new client with chart of accounts on postgresql
2. Go to database and see the elementlevel column (it contains an empty string)

Proposed Solution

See the attached patch

Tags

No tags attached.

initial-client-setup_elementlevel.diff [^] (1,136 bytes) 2009-01-26 11:21 [Show Content] [Hide Content]

Index: src/org/openbravo/erpCommon/ad_forms/InitialClientSetup_data.xsql
===================================================================
--- src/org/openbravo/erpCommon/ad_forms/InitialClientSetup_data.xsql	(revision 12195)
+++ src/org/openbravo/erpCommon/ad_forms/InitialClientSetup_data.xsql	(working copy)
@@ -506,7 +506,7 @@
         INSERT INTO C_ElementValue (C_ELEMENTVALUE_ID,C_ELEMENT_ID, AD_CLIENT_ID,AD_ORG_ID,ISACTIVE,CREATED,CREATEDBY,UPDATED,UPDATEDBY,
         VALUE,NAME,DESCRIPTION,ACCOUNTTYPE,ACCOUNTSIGN,ISDOCCONTROLLED,ISSUMMARY,VALIDFROM,VALIDTO,
         POSTACTUAL,POSTBUDGET,POSTENCUMBRANCE,POSTSTATISTICAL,ISBANKACCOUNT,C_BANKACCOUNT_ID,ISFOREIGNCURRENCY,C_CURRENCY_ID, ELEMENTLEVEL) 
-        VALUES (TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),'Y',now(),0,now(),0,?,?,?,?,?,?,?,NULL,NULL,'Y','Y','Y','Y', 'N',NULL, 'N',NULL,COALESCE(SUBSTR(?,0,1),'S'))
+        VALUES (TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),'Y',now(),0,now(),0,?,?,?,?,?,?,?,NULL,NULL,'Y','Y','Y','Y', 'N',NULL, 'N',NULL,COALESCE(SUBSTR(?,1,1),'S'))
       ]]>
     </Sql>
     <Parameter name="C_ElementValue_ID"/>

Relationships [ Relation Graph ] [ Dependency Graph ]

depends on	backport	0007270		closed	shuehner	Import accounts does not import element level on postgresql
related to	feature request	0007130		closed	shuehner	Invalid substr index in SQL query in used parse-method of FileImport_data.xsql
related to	defect	0007100		closed	dalsasua	While Importing Accounts Account type is coming as "Not found"
related to	defect	0007315		closed	dalsasua	Invalid substr index (=0) in SQL query.

Notes
(0012951) svnbot (reporter) 2009-01-30 19:56	Repository: openbravo Revision: 12578 Author: huehner Date: 2009-01-30 19:56:30 +0100 (Fri, 30 Jan 2009) Fixed 7129 Fixes: Import accounts does not import element level on postgresql by applying patch by villind. --- U trunk/src/org/openbravo/erpCommon/ad_forms/InitialClientSetup_data.xsql --- https://dev.openbravo.com/websvn/openbravo/?rev=12578&sc=1 [^]

(0014193) sureshbabu (reporter) 2009-03-02 07:56	Retested in context 79.125.56.185/openbravotrunk

Issue History
Date Modified	Username	Field	Change
2009-01-26 11:21	villind	New Issue
2009-01-26 11:21	villind	Assigned To	=> rafaroda
2009-01-26 11:21	villind	sf_bug_id	0 => 2537308
2009-01-26 11:21	villind	File Added: initial-client-setup_elementlevel.diff
2009-01-26 11:21	villind	Regression testing	=> No
2009-01-30 14:52	rafaroda	Assigned To	rafaroda => dalsasua
2009-01-30 14:52	rafaroda	Priority	normal => high
2009-01-30 14:52	rafaroda	Proposed Solution updated
2009-01-30 14:52	rafaroda	Status	new => scheduled
2009-01-30 14:52	rafaroda	fix_in_branch	=> trunk
2009-01-30 17:18	villind	Relationship added	related to 0007130
2009-01-30 17:54	psarobe	Relationship added	blocks 0007100
2009-01-30 17:58	rafaroda	Relationship replaced	related to 0007100
2009-01-30 19:52	shuehner	Assigned To	dalsasua => shuehner
2009-01-30 19:56	svnbot	Checkin
2009-01-30 19:56	svnbot	Note Added: 0012951
2009-01-30 19:56	svnbot	Status	scheduled => resolved
2009-01-30 19:56	svnbot	Resolution	open => fixed
2009-01-30 19:56	svnbot	svn_revision	=> 12578
2009-02-02 14:28	shuehner	Relationship added	related to 0007315
2009-03-02 07:56	sureshbabu	Status	resolved => closed
2009-03-02 07:56	sureshbabu	Note Added: 0014193
2009-03-02 07:56	sureshbabu	Fixed in Version	=> trunk

Copyright © 2000 - 2009 MantisBT Group