Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0011793 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 02. Master data management | minor | always | 2009-12-15 18:58 | 2010-03-10 18:28 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | harikrishnan | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | 2.50MP14 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 4a410faff223 | ||||
| Projection | none | ETA | none | Target Version | 2.50MP12 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50MP9 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0011793: An error appears when a csv is imported in Import File Loader | |||||||
| Description | In 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 Reproduce | Go 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  ISSUE6862LoaderFormat.doc [^] (131,584 bytes) 2009-12-15 18:58 i_test.csv [^] (108 bytes) 2009-12-15 19:00 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0023169) psarobe (viewer) 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 (viewer) 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 (viewer) 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 (viewer) 2010-02-19 07:13 |
Tested & working fine. |
|
(0024663) hudsonbot (viewer) 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 [^] |
|
Notes |
|
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 18:58 | networkb | OBNetwork customer | => Yes |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |