Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0007581 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 02. Master data management | major | always | 2009-02-16 17:41 | 2009-03-18 11:03 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | pheenan | |||||||
| Priority | immediate | Resolution | no change required | Fixed in Version | 2.50beta | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 13295 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.35MP5 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0007581: Import file loader does not take into account Field format sequence | |||||||
| Description | 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) | |||||||
| Steps To Reproduce | 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. | |||||||
| Tags | commsup_sprint6 | |||||||
| Attached Files |  2.jpg [^] (140,264 bytes) 2009-02-16 17:42
 mis_prov.csv [^] (299 bytes) 2009-02-17 16:45 mis_prov_corrected.csv [^] (275 bytes) 2009-02-17 19:21 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0013576) svnbot (reporter) 2009-02-17 16:21 |
Repository: openbravo Revision: 13279 Author: pheenan Date: 2009-02-17 16:21:17 +0100 (Tue, 17 Feb 2009) Fixed 7581. int field constant being used to alter the array iterator when it bears no impact on the count. Due to this fields were being skipped causing the values in the data rows to be assigned to the wrong fields. --- U trunk/src/org/openbravo/erpCommon/ad_forms/FileImport.java --- https://dev.openbravo.com/websvn/openbravo/?rev=13279&sc=1 [^] |
|
(0013577) pheenan (reporter) 2009-02-17 16:44 |
Reopening issue to change the test csv file which contains an error. |
|
(0013578) pheenan (reporter) 2009-02-17 16:46 |
Changing to resolved again after attaching a corrected csv test file |
|
(0013586) svnbot (reporter) 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 [^] |
|
(0013597) svnbot (reporter) 2009-02-17 19:20 |
Repository: openbravo Revision: 13295 Author: pheenan Date: 2009-02-17 19:20:33 +0100 (Tue, 17 Feb 2009) Rolling back changes made for issue 7581. This is not a real issue but a case of the documentation not clearly stating how to work with the import files and the file definitions. --- U trunk/src/org/openbravo/erpCommon/ad_forms/FileImport.java --- https://dev.openbravo.com/websvn/openbravo/?rev=13295&sc=1 [^] |
|
(0013598) pheenan (reporter) 2009-02-17 19:20 |
rolling back commit. Not actually an issue. |
|
(0013600) pheenan (reporter) 2009-02-17 19:23 |
This issue relates to the use of constant fields and their inclusion in the import file. Constant fields should not be included in the import file. Need to add this to the wiki documentation to make this point clearer. |
|
(0013601) pheenan (reporter) 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. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-02-16 17:41 | networkb | New Issue | |
| 2009-02-16 17:41 | networkb | Assigned To | => rafaroda |
| 2009-02-16 17:41 | networkb | File Added: mis_prov.csv | |
| 2009-02-16 17:41 | networkb | Regression testing | => No |
| 2009-02-16 17:42 | networkb | File Added: 2.jpg | |
| 2009-02-16 18:23 | rafaroda | Assigned To | rafaroda => pheenan |
| 2009-02-16 18:23 | rafaroda | Status | new => scheduled |
| 2009-02-16 18:23 | rafaroda | fix_in_branch | => trunk |
| 2009-02-17 09:43 | pheenan | Tag Attached: commsup_sprint6 | |
| 2009-02-17 16:21 | svnbot | Checkin | |
| 2009-02-17 16:21 | svnbot | Note Added: 0013576 | |
| 2009-02-17 16:21 | svnbot | Status | scheduled => resolved |
| 2009-02-17 16:21 | svnbot | Resolution | open => fixed |
| 2009-02-17 16:21 | svnbot | svn_revision | => 13279 |
| 2009-02-17 16:44 | pheenan | Status | resolved => new |
| 2009-02-17 16:44 | pheenan | Resolution | fixed => open |
| 2009-02-17 16:44 | pheenan | Note Added: 0013577 | |
| 2009-02-17 16:45 | pheenan | File Deleted: mis_prov.csv | |
| 2009-02-17 16:45 | pheenan | File Added: mis_prov.csv | |
| 2009-02-17 16:45 | pheenan | Status | new => scheduled |
| 2009-02-17 16:46 | pheenan | Status | scheduled => resolved |
| 2009-02-17 16:46 | pheenan | Resolution | open => fixed |
| 2009-02-17 16:46 | pheenan | Note Added: 0013578 | |
| 2009-02-17 17:06 | svnbot | Checkin | |
| 2009-02-17 17:06 | svnbot | Note Added: 0013586 | |
| 2009-02-17 17:06 | svnbot | svn_revision | 13279 => 13284 |
| 2009-02-17 19:20 | svnbot | Checkin | |
| 2009-02-17 19:20 | svnbot | Note Added: 0013597 | |
| 2009-02-17 19:20 | svnbot | svn_revision | 13284 => 13295 |
| 2009-02-17 19:20 | pheenan | Status | resolved => new |
| 2009-02-17 19:20 | pheenan | Resolution | fixed => open |
| 2009-02-17 19:20 | pheenan | Note Added: 0013598 | |
| 2009-02-17 19:21 | pheenan | File Added: mis_prov_corrected.csv | |
| 2009-02-17 19:23 | pheenan | Note Added: 0013600 | |
| 2009-02-17 19:24 | pheenan | Status | new => closed |
| 2009-02-17 19:24 | pheenan | Note Added: 0013601 | |
| 2009-02-17 19:24 | pheenan | Resolution | open => no change required |
| 2009-03-18 11:03 | anonymous | sf_bug_id | 0 => 2691397 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |