0008169: Manual import of uploaded accounts chart file fails

Description

when setting up client manually, any attempt to complete import for upploaded .csv file fails at the stage of running "Import Accounts" process.

Steps To Reproduce

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"

Proposed Solution

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(), ?,

Tags

250MP1

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0015725) hgbot (developer) 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 ---

Issue History
Date Modified	Username	Field	Change
2009-03-17 18:11	stalker	New Issue
2009-03-17 18:11	stalker	Assigned To	=> rafaroda
2009-03-23 12:59	psarobe	Assigned To	rafaroda => dalsasua
2009-03-23 12:59	psarobe	Severity	minor => major
2009-03-23 12:59	psarobe	Status	new => scheduled
2009-04-23 16:57	psarobe	Priority	normal => urgent
2009-04-23 16:57	psarobe	Tag Attached: 250MP1
2009-04-24 19:15	hgbot	Checkin
2009-04-24 19:15	hgbot	Note Added: 0015725
2009-04-24 19:15	hgbot	Status	scheduled => resolved
2009-04-24 19:15	hgbot	Resolution	open => fixed
2009-04-24 19:15	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/6aeb33b7de0ea13bb16405a8b8162e49e7b31c46 [^]
2009-05-04 19:11	psarobe	Regression testing	=> No
2009-05-04 19:11	psarobe	Status	resolved => closed
2009-05-05 00:00	anonymous	sf_bug_id	0 => 2786884