Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007129Openbravo ERP01. General setuppublic2009-01-26 11:212009-03-02 07:56
Reportervillind 
Assigned Toshuehner 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP1 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007129: Import accounts does not import element level on postgresql
DescriptionElement level information is not imported from the chart of accounts on initial client setup.

Steps To Reproduce1. 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 SolutionSee the attached patch
Additional Information
TagsNo tags attached.
Relationships
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. 
Attached Filesdiff initial-client-setup_elementlevel.diff (1,136) 2009-01-26 11:21
https://issues.openbravo.com/file_download.php?file_id=728&type=bug
Issue History
Date ModifiedUsernameFieldChange
2009-01-26 11:21villindNew Issue
2009-01-26 11:21villindAssigned To => rafaroda
2009-01-26 11:21villindsf_bug_id0 => 2537308
2009-01-26 11:21villindFile Added: initial-client-setup_elementlevel.diff
2009-01-26 11:21villindOBNetwork customer => No
2009-01-26 11:21villindRegression testing => No
2009-01-30 14:52rafarodaAssigned Torafaroda => dalsasua
2009-01-30 14:52rafarodaPrioritynormal => high
2009-01-30 14:52rafarodaProposed Solution updated
2009-01-30 14:52rafarodaStatusnew => scheduled
2009-01-30 14:52rafarodafix_in_branch => trunk
2009-01-30 17:18villindRelationship addedrelated to 0007130
2009-01-30 17:54psarobeRelationship addedblocks 0007100
2009-01-30 17:58rafarodaRelationship replacedrelated to 0007100
2009-01-30 19:52shuehnerAssigned Todalsasua => shuehner
2009-01-30 19:56svnbotCheckin
2009-01-30 19:56svnbotNote Added: 0012951
2009-01-30 19:56svnbotStatusscheduled => resolved
2009-01-30 19:56svnbotResolutionopen => fixed
2009-01-30 19:56svnbotsvn_revision => 12578
2009-02-02 14:28shuehnerRelationship addedrelated to 0007315
2009-03-02 07:56sureshbabuStatusresolved => closed
2009-03-02 07:56sureshbabuNote Added: 0014193
2009-03-02 07:56sureshbabuFixed in Version => trunk

Notes
(0012951)
svnbot   
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   
2009-03-02 07:56   
Retested in context 79.125.56.185/openbravotrunk