Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0008169Openbravo ERP09. Financial managementpublic2009-03-17 18:112009-05-05 00:00
stalker 
dalsasua 
urgentmajoralways
closedfixed 
302.6.27-11-generic
2.50alpha-r11 
2.50MP1 
Core
No
0008169: Manual import of uploaded accounts chart file fails
when setting up client manually, any attempt to complete import for upploaded .csv file fails at the stage of running "Import Accounts" process.
1. under Openbravo login, run Initial Client Setup, marking option "Include accounting", but omitting actual chart file.

2. under Client's login, perform all due beforehand manual setup for organization:
Calendar, Account Tree, Accounting Schema (+ its elements)

3. Upload correct accounts chart file, then "Proceed"

4. under "Import Account" window, select valid account record and mark due "Accounting Element" selection. Then run "Import Accounts"
1. change variable type in C_VALIDCOMBINATION_GET.xml:

stalker@de:/home/user/r2.50alpha-r11/src-db/database/model/functions$ diff C_VALIDCOMBINATION_GET.xml.orig C_VALIDCOMBINATION_GET.xml
121c121
< v_CreatedBy NUMBER:=NULL;
---
> v_CreatedBy VARCHAR(32):=NULL;

2. change parameters sequience in ImportAccount_data.xsql

stalker@de:/home/user/r2.50alpha-r11/src/org/openbravo/erpCommon/ad_process$ diff ImportAccount_data.xsql.orig ImportAccount_data.xsql
417c417
< VALUES (GET_UUID(), ?, ?, ?, 'Y', now(), ?,
---
> VALUES (?, GET_UUID(), ?, ?, 'Y', now(), ?,


250MP1
Issue History
2009-03-17 18:11stalkerNew Issue
2009-03-17 18:11stalkerAssigned To => rafaroda
2009-03-23 12:59psarobeAssigned Torafaroda => dalsasua
2009-03-23 12:59psarobeSeverityminor => major
2009-03-23 12:59psarobeStatusnew => scheduled
2009-04-23 16:57psarobePrioritynormal => urgent
2009-04-23 16:57psarobeTag Attached: 250MP1
2009-04-24 19:15hgbotCheckin
2009-04-24 19:15hgbotNote Added: 0015725
2009-04-24 19:15hgbotStatusscheduled => resolved
2009-04-24 19:15hgbotResolutionopen => fixed
2009-04-24 19:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6aeb33b7de0ea13bb16405a8b8162e49e7b31c46 [^]
2009-05-04 19:11psarobeRegression testing => No
2009-05-04 19:11psarobeStatusresolved => closed
2009-05-05 00:00anonymoussf_bug_id0 => 2786884

Notes
(0015725)
hgbot   
2009-04-24 19:15   
Repository: erp/devel/pi
Changeset: 6aeb33b7de0ea13bb16405a8b8162e49e7b31c46
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Fri Apr 24 19:14:16 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6aeb33b7de0ea13bb16405a8b8162e49e7b31c46 [^]

Fixes bug 0008169: Manual import of uploaded accounts chart file fails

---
M src-db/database/model/functions/C_VALIDCOMBINATION_GET.xml
---