Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0007583Openbravo ERP02. Master data managementpublic2009-02-16 17:412009-02-17 19:24
networkb 
pheenan 
immediatemajoralways
closedno change required 
5
2.35MP5 
2.40MP3 
Core
No
0007583: Import file loader does not take into account Field format sequence
If a new Import Loader Format is created and its lines are created randomly ( I mean, field format sequence is not 10,20,30...), when a csv file is imported using this file format, information is not well organized.

Import process in Import File Loader does not take into account the sequence created in Field Format tab. It takes into account the order which those lines were created (you can see it looking at ad_impformat_row table)
1 Generate a new Import Loader Format. Use I_Bpartner table, and Semicolon separator.
2 Define its line randomly. (See atached file in order to generate its lines).
Generate first line with sequence 110, 10, 30, etc.
3 Go to Import File loader form. Select the previous file format and use the attached csv.

If you look at i_bpartner table, you will see that information has not been stored in the correct field.
No tags attached.
blocks defect 0007581 closed pheenan Import file loader does not take into account Field format sequence 
Issue History
2009-02-16 18:23rafarodaTypedefect => backport
2009-02-16 18:23rafarodafix_in_branch => 2.40
2009-02-17 17:06svnbotCheckin
2009-02-17 17:06svnbotNote Added: 0013587
2009-02-17 17:06svnbotStatusscheduled => resolved
2009-02-17 17:06svnbotResolutionopen => fixed
2009-02-17 17:06svnbotsvn_revision => 13284
2009-02-17 19:24pheenanStatusresolved => new
2009-02-17 19:24pheenanResolutionfixed => open
2009-02-17 19:24pheenanStatusnew => closed
2009-02-17 19:24pheenanNote Added: 0013602
2009-02-17 19:24pheenanResolutionopen => no change required

Notes
(0013587)
svnbot   
2009-02-17 17:06   
Repository: openbravo
Revision: 13284
Author: pheenan
Date: 2009-02-17 17:06:39 +0100 (Tue, 17 Feb 2009)

Fixed 7583. Backport for issue 7581. Removing constant integer which caused the array iterator to go out of sequence.

---
U branches/r2.40/src/org/openbravo/erpCommon/ad_forms/FileImport.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=13284&sc=1 [^]
(0013602)
pheenan   
2009-02-17 19:24   
Updated OB Support with the actual issue. Have attached a correctly formatted import file which has been tested and imports correctly.