Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010437Openbravo ERP01. General setuppublic2009-06-15 12:172009-09-11 18:48
Reporternetworkb 
Assigned Toeduardo_Argal 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP8 
Target Version2.40MP9Fixed in Version2.40MP9 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010437: Error importing Chart of Account
DescriptionI receive and error message when importing the accounting file of a new client.
The error is the following : "javax.servlet.ServeltException:@CODE=0@ERROR:null value column "p_expense_acct" violates not null constraint.
I have found that this is because the blank spaces you leave, after writing a column, in the default_account column. I think the same problem will occur in all the columns of the importing chart of account file.
Steps To ReproduceGo to:

General Setup||Client||Initial Client Setup||Initial Client Setup -> create the client and import the accounting file. The file has to contain blank spaces after a word.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00094722.40MP9 closed eduardo_Argal Error importing Chart of Account 
Attached Filescsv accountTest.csv (379) 2009-08-31 12:53
https://issues.openbravo.com/file_download.php?file_id=1690&type=bug
Issue History
Date ModifiedUsernameFieldChange
2009-08-31 12:52rafarodaTypedefect => backport
2009-08-31 12:52rafarodafix_in_branch => 2.40
2009-08-31 12:53rafarodaFile Added: accountTest.csv
2009-08-31 13:01networkbTarget Version => 2.40MP9
2009-09-07 12:40hgbotCheckin
2009-09-07 12:40hgbotNote Added: 0019480
2009-09-07 12:40hgbotStatusscheduled => resolved
2009-09-07 12:40hgbotResolutionopen => fixed
2009-09-07 12:40hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/6dc5a2daa1f16b5456d4c4ffc1a4b8f53c9f4b45 [^]
2009-09-09 15:27hgbotCheckin
2009-09-09 15:27hgbotNote Added: 0019612
2009-09-09 15:27hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/6dc5a2daa1f16b5456d4c4ffc1a4b8f53c9f4b45 [^] => http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/6dc5a2daa1f16b5456d4c4ffc1a4b8f53c9f4b45 [^]
2009-09-11 18:48psarobeStatusresolved => closed
2009-09-11 18:48psarobeFixed in Version => 2.40MP9

Notes
(0019480)
hgbot   
2009-09-07 12:40   
Repository: erp/stable/2.40
Changeset: 6dc5a2daa1f16b5456d4c4ffc1a4b8f53c9f4b45
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Mon Sep 07 12:38:47 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/6dc5a2daa1f16b5456d4c4ffc1a4b8f53c9f4b45 [^]

Fixes bug 0010437: Error importing Chart of Account

---
M src/org/openbravo/erpCommon/ad_forms/FileImport.java
---
(0019612)
hgbot   
2009-09-09 15:27   
Repository: erp/stable/2.40_pageddatagrid
Changeset: 6dc5a2daa1f16b5456d4c4ffc1a4b8f53c9f4b45
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Mon Sep 07 12:38:47 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/6dc5a2daa1f16b5456d4c4ffc1a4b8f53c9f4b45 [^]

Fixes bug 0010437: Error importing Chart of Account

---
M src/org/openbravo/erpCommon/ad_forms/FileImport.java
---