Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0007762 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 02. Master data management | major | always | 2009-02-23 15:17 | 2009-03-26 00:00 | |||
| Reporter | mirurita | View Status | public | |||||
| Assigned To | iperdomo | |||||||
| Priority | high | Resolution | no change required | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_11 | |||
| OS Version | rPath Linux | Database version | 8.3.5 | Ant version | 1.7.1 | |||
| Product Version | 2.40 | 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 | 0007762: Import Orders: Ordered date is not imported correctly | |||||||
| Description | When the imported order is inserted in I_Order table (ExternalSalesIOrderData class), dateordered field is formatted: to_date('23-03-2009 12:20:40', 'dd-MM-yyyy HH:mm:ss') Postgre can't distinguish between MM and mm so it takes the minutes like months. In this example the result will be: 2010-08-25 | |||||||
| Steps To Reproduce | Synchronize Orders between POS and ERP. Follow this tutorial: http://wiki.openbravo.com/wiki/Openbravo_POS_Integration#Openbravo_configuration [^] | |||||||
| Proposed Solution | Use other format to minutes. to_date('23-03-2009 12:20:40', 'dd-MM-yyyy HH:Mi:ss') | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0014028) rafaroda (developer) 2009-02-24 15:22 |
Mikel, Is there a way of reproducing this without using Openbravo POS? I'm afraid that not, but just to know. Thank you. |
|
(0014030) mirurita (developer) 2009-02-24 16:55 |
Hi, Sorry, but I don't think so, Openbravo POS is needed. Don't hesitate to ask me for any help. Regards. |
|
(0014927) iperdomo (reporter) 2009-03-25 09:21 |
All the date formatting is already handled |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-02-23 15:17 | mirurita | New Issue | |
| 2009-02-23 15:17 | mirurita | Assigned To | => rafaroda |
| 2009-02-24 09:54 | Dowid | Relationship added | related to 0007524 |
| 2009-02-24 15:22 | rafaroda | Note Added: 0014028 | |
| 2009-02-24 15:22 | rafaroda | Status | new => feedback |
| 2009-02-24 16:55 | mirurita | Note Added: 0014030 | |
| 2009-03-03 10:19 | rafaroda | Assigned To | rafaroda => pheenan |
| 2009-03-03 10:19 | rafaroda | Priority | normal => high |
| 2009-03-03 10:19 | rafaroda | Severity | minor => major |
| 2009-03-03 10:19 | rafaroda | Status | feedback => new |
| 2009-03-03 10:19 | rafaroda | Status | new => scheduled |
| 2009-03-03 10:19 | rafaroda | fix_in_branch | => trunk |
| 2009-03-24 11:40 | rafaroda | Assigned To | pheenan => iperdomo |
| 2009-03-25 09:21 | iperdomo | Regression testing | => No |
| 2009-03-25 09:21 | iperdomo | Status | scheduled => closed |
| 2009-03-25 09:21 | iperdomo | Note Added: 0014927 | |
| 2009-03-25 09:21 | iperdomo | Resolution | open => no change required |
| 2009-03-26 00:00 | anonymous | sf_bug_id | 0 => 2712897 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |