Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0003479Openbravo ERP03. Procurement managementpublic2008-04-04 12:492011-02-04 09:29
egoitz 
rmorley 
normalminoralways
acknowledgedopen 
5
 
 
Core
No
0003479: Import EDI file does not work
STEPS:

Master Data Managament>Import Data>Import EDI file


ENVIROMENT:
v2.35mp1


DESCRIPTION:

When you select a EDI file and click ok you get and error because the bug number 1934282. If you solve this bug
manually (adding a "," after the first TO_NUMBER(?), you don't get this error, but anything ocurrs.

I have seen in the EdiFileImport.java file in ad_forms folder (src/org/openbravo/erpCommong/) that the process does not allow to put all the file in one line separated by '. You have to put the content of the EDI file in diferentes lines For example:

UNH+1+ORDERS:D:96A:UN:EAN008
BGM+220+9
DTM+137:200801150600:203
NAD+BY+7701011000005::9
NAD+SN+7701011022540::9
NAD+SU+7702475000020::9
NAD+DP+7701011022540::9
NAD+IV+7701011000005::9
NAD+ITO+7701011013203::9
LIN+1++7702475386827:EN
QTY+21:3:NAR
PRI+AAB:4503
PAC+1++PQT
PCI+16+1:006:010:20080121:6800.00:::MEDIA NATURAL M
LIN+13++7702475427735:EN
QTY+21:6:NAR
PRI+AAA:8530
PAC+6++PQT
PCI+16+1:006:010:20080121:12900.00:::BODY L
UNS+S

With the file like the previous, something appears in the table I_ORDER but is not enough to create a c_oder.
Then when you click the import button on import orders windows an error ocurrs.


The EdiFileImport.java is not prepare to take all the information defined in the standard 96A:UN:EAN008.
It is prepare to take some information from the standard but not enought to create a order.



ReleaseCandidate
Issue History
2008-06-27 15:54pjuvaraTag Attached: ReleaseCandidate
2008-06-27 15:54pjuvaraStatusnew => acknowledged
2008-11-10 13:11cromeroAssigned Tocromero => pjuvara
2011-02-04 09:16jpabloaeAssigned Topjuvara => rmorley
2011-02-04 09:29egoitzNote Added: 0034051

Notes
(0007068)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:44)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1934296 [^]
(0003956)
cromero   
2008-04-24 17:32   
(edited on: 2008-06-12 09:26)
Logged In: YES
user_id=1500614
Originator: NO

This functionality should be reviewed and improved.
Now it is deprecated.
(0034051)
egoitz   
2011-02-04 09:29   
The EDI process was hidden on the application menu