Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018889Openbravo ERPA. Platformpublic2011-10-26 19:562022-02-01 08:09
Reportermtaal 
Assigned ToTriage Platform Base 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusnewResolutionout of date 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018889: Add an excel mode to the XML webservices
DescriptionThe xml webservices can be used as a datasource in Excel, the xml should be simplified however, an example of a sales order xml:
<SalesOrder>
    <County>Holland</Country>
    <Amount>5</Amount>
</SalesOrder>
<SalesOrder>
    <County>Holland</Country>
    <Amount>10</Amount>
</SalesOrder>

In addition:
- what is the number format expected by excel (decimal dot without grouping probably).
>>> no grouping definitely. The "decimal separator" should be a user-specific thing--if not possible in the short term, it should at least be set as a client-wide preference? (comma vs. period). If not possible I would go for period, and then see if the people needing comma can override with Excel formatting. Thousands separator is not needed (just Excel column formatting)

- what is the date time format expected
>>> I think if you go for yyyy-mm-dd that is fine (can then change via Excel column formatting)

- does it make sense to also output the database id (technical but unique)?
>>> for the user, I think a practical alternative would be to take it a step further and provide the actual link, so the user can click on it and drill back into the application, for example ale beer. The syntax in Excel is =HYPERLINK("http://live.builds.openbravo.com/int-full-pgsql/?tabId=180&recordId=8A64B71A2B0B2946012B0BC4345000FB", [^] "Ale Beer"). For simplicity for now, I would just add a generic column called Link, and also put the string "Link" as the second parm in the hyperlink function. That way, no extra setup required to determine which field in an entity should be clickable. I would actually put "Link" as the first column in the result set, since I think it is great for demos--you can really only "drill back" like this with a web-based system and many users will be amazed. If I had this capability, I would demo it every week in the live demo! Though it is very simple, it is practical and useful for end users, and shows how the web can be easily integrated to desktop apps like Excel.
Steps To Reproduce.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-10-26 19:56mtaalNew Issue
2011-10-26 19:56mtaalAssigned To => mtaal
2011-10-26 19:56mtaalModules => Core
2011-10-27 20:35hgbotCheckin
2011-10-27 20:35hgbotNote Added: 0042179
2011-10-27 20:35hgbotStatusnew => resolved
2011-10-27 20:35hgbotResolutionopen => fixed
2011-10-27 20:35hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/bbf8582fbc5d8304c5dea6f2378c22ddfb5f2244 [^]
2011-10-27 20:35hgbotCheckin
2011-10-27 20:35hgbotNote Added: 0042181
2011-10-27 20:35hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/bbf8582fbc5d8304c5dea6f2378c22ddfb5f2244 [^] => http://code.openbravo.com/erp/devel/pi/rev/490e626bad9801d19cfacc2af82f31ccdedecdca [^]
2011-11-02 10:29mtaalNote Added: 0042434
2011-11-02 10:29mtaalStatusresolved => new
2011-11-02 10:29mtaalResolutionfixed => open
2011-11-02 10:29mtaalTarget Version3.0MP5 => 3.0MP6
2011-11-04 13:57hudsonbotCheckin
2011-11-04 13:57hudsonbotNote Added: 0042587
2011-11-04 13:57hudsonbotCheckin
2011-11-04 13:57hudsonbotNote Added: 0042589
2011-11-15 10:25iperdomoTarget Version3.0MP6 =>
2016-10-21 11:02mtaalStatusnew => closed
2016-10-21 11:02mtaalResolutionopen => out of date
2016-10-21 13:17mtaalTag Attached: MT_closed_out_of_date
2016-10-21 14:08mtaalAssigned Tomtaal => platform
2016-10-21 14:09mtaalStatusclosed => new
2016-10-21 14:10mtaalTag Detached: MT_closed_out_of_date
2022-02-01 08:09alostaleAssigned Toplatform => Triage Platform Base

Notes
(0042179)
hgbot   
2011-10-27 20:35   
Repository: erp/devel/pi
Changeset: bbf8582fbc5d8304c5dea6f2378c22ddfb5f2244
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Thu Oct 27 19:45:57 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/bbf8582fbc5d8304c5dea6f2378c22ddfb5f2244 [^]

Fixes issue 18889 Add an excel mode to the XML webservices

---
M src/org/openbravo/service/rest/DalWebService.java
A src/org/openbravo/dal/xml/EntityExcelXMLConverter.java
---
(0042181)
hgbot   
2011-10-27 20:35   
Repository: erp/devel/pi
Changeset: 490e626bad9801d19cfacc2af82f31ccdedecdca
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Thu Oct 27 20:34:21 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/490e626bad9801d19cfacc2af82f31ccdedecdca [^]

Fixes issue 18889: Add an excel mode to the XML webservices
Fixes issue 18913: New-in-grid + save fails in Sales Orde

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/JsonToDataConverter.java
M src/org/openbravo/service/rest/DalWebService.java
A src/org/openbravo/dal/xml/EntityExcelXMLConverter.java
---
(0042434)
mtaal   
2011-11-02 10:29   
Move to mp6 because the concept is not yet fully worked out (being hit by the IE 255 url limit)
(0042587)
hudsonbot   
2011-11-04 13:57   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/d10da320df2a [^]

Maturity status: Test
(0042589)
hudsonbot   
2011-11-04 13:57   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/d10da320df2a [^]

Maturity status: Test