Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0011793
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 02. Master data managementminoralways2009-12-15 18:582010-03-10 18:28
ReporternetworkbView Statuspublic 
Assigned Toharikrishnan 
PriorityhighResolutionfixedFixed in Version2.50MP14
StatusclosedFix in branchFixed in SCM revision4a410faff223
ProjectionnoneETAnoneTarget Version2.50MP12
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP9SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0011793: An error appears when a csv is imported in Import File Loader

DescriptionIn Import file Loader, after defining a format (see attached file), the following error appears:

      
Error while inserting data
Line No. 1
Inserting data: AD_Client_ID = '614F52E89Dadfadffsdf62',AD_Org_ID = '84C10CDFB7D24D7E848BB2',Value = 'AA935084',Name = 'AA935084'
Error: ERROR: inserción o actualización en la tabla «i_product» viola la llave foránea «adclient_iproduct» Detail: La llave (ad_client_id)=(614F52E89Dadfadffsdf62) no está presente en la tabla «ad_client».

The problem is that AD_Client_ID is cut.
Steps To ReproduceGo to Master Data Management > Import Data > Import Loader Format.
Generate the same format as the document.
Go to Master Data Management > Import Data > Import File Loader.
Select the csv attached (Note: Client and Org, should be modified by yours), the format created, and process it.
TagsNo tags attached.
Attached Filesdoc file icon ISSUE6862LoaderFormat.doc [^] (131,584 bytes) 2009-12-15 18:58
csv file icon i_test.csv [^] (108 bytes) 2009-12-15 19:00

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0023169)
psarobe (manager)
2009-12-30 18:06

Please also see if it fails for the organization. It doesn't make sense to put the client but make sense to put the organization

Regards
(0023182)
rafaroda (developer)
2010-01-04 09:22

Changed its Priority to high.
(0024598)
hgbot (developer)
2010-02-18 13:51

Repository: erp/devel/pi
Changeset: 4a410faff223efb18a767a953a1d11b3366d402a
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Thu Feb 18 18:22:05 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/4a410faff223efb18a767a953a1d11b3366d402a [^]

Fixes Issue 11793: An error appears when a csv is imported in Import File Loader.

---
M src/org/openbravo/erpCommon/ad_forms/FileImport.java
M src/org/openbravo/erpCommon/ad_forms/FileImport_data.xsql
---
(0024621)
harikrishnan (reporter)
2010-02-19 06:05

Steps to test.
*Create a new organization and new client.Query the database to get the Client Id and Organization id
*Create the file format with the data that are included as screen shot in file ISSUE6862LoaderFormat.doc
*Download the CSV file from the issue, and copy the client id and organization id of yours in to the file.
*Now try to upload the file in Import File Loader(Master Data Management > Import Data > Import File Loader).Now the file will be uploaded.
*Since the CSV file has Header check the check box "Header first line".
(0024623)
arunkumar (reporter)
2010-02-19 07:13

Tested & working fine.
(0024663)
hudsonbot (developer)
2010-02-19 16:35

A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/4a410faff223 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/d22bdcc83354 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16481.obx [^]

- Issue History
Date Modified Username Field Change
2009-12-15 18:58 networkb New Issue
2009-12-15 18:58 networkb Assigned To => rafaroda
2009-12-15 18:58 networkb File Added: ISSUE6862LoaderFormat.doc
2009-12-15 19:00 networkb Target Version => 2.50MP12
2009-12-15 19:00 networkb File Added: i_test.csv
2009-12-30 18:06 psarobe Status new => scheduled
2009-12-30 18:06 psarobe Note Added: 0023169
2009-12-30 18:06 psarobe fix_in_branch => pi
2010-01-04 09:22 rafaroda Note Added: 0023182
2010-01-04 09:22 rafaroda Priority immediate => high
2010-01-04 09:22 rafaroda fix_in_branch pi =>
2010-02-16 16:56 rafaroda Assigned To rafaroda => harikrishnan
2010-02-18 13:51 hgbot Checkin
2010-02-18 13:51 hgbot Note Added: 0024598
2010-02-18 13:51 hgbot Status scheduled => resolved
2010-02-18 13:51 hgbot Resolution open => fixed
2010-02-18 13:51 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4a410faff223efb18a767a953a1d11b3366d402a [^]
2010-02-19 06:05 harikrishnan Note Added: 0024621
2010-02-19 07:13 arunkumar Note Added: 0024623
2010-02-19 07:13 arunkumar Status resolved => closed
2010-02-19 07:13 arunkumar Fixed in Version => 2.50MP13
2010-02-19 16:35 hudsonbot Checkin
2010-02-19 16:35 hudsonbot Note Added: 0024663
2010-02-20 00:00 anonymous sf_bug_id 0 =>
2010-03-08 16:04 jpabloae Fixed in Version 2.50MP13 => 2.50MP14
2010-03-10 18:28 anonymous sf_bug_id => 2967963


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker