Last week at SAP TechEd Bangalore, SAP made a great step forward for the embracement of the Open Source development: OPENUI5 was released; Andreas Kunz wrote a very detailed blog What is OpenUI5 / SAPUI5 ? some days ago.
So I decided to use these libraries in order to create an application that could show the power of OPENUI5 as an Open Source framework for enterprise-ready web applications. In my case I decided to create a very simple Phone Book that consumes data form a Google Drive Form.
Over the past few years we have experienced an innovation era in SAP. Mobile, Cloud and In-Memory are now the three foundations of enterprise computing and they are bringing a new life into the possibility to enrich and improve enterprise business.
Most of the people are talking about this innovation as a great step forward for the transformation of the “old style” SAP to a new one close to the current need of performing business quicker, anywhere and anytime, and they encourage customers to move into the innovation.
For valuable work on creation of sites you need a good comfortable editor necessarily. There are many requiring paid products for this purpose, but we would like to select free of charge very functional and at the same time of simple in the use editor – Codelobster PHP Edition .
Let us consider some important possibilities and advantages of this program:
HTML/CSS inspector on the type of Firebug, which allows easily to correlate the selected elements of page with a code and proper style.
Context help on all supported languages. By pressing F1 key the page with detailed description for current tag, attribute or function will be opened.
PHP debugger. PHP debugger allows to execute PHP scripts incrementally, watching the values of all variables in every line.
SQL manager allows to produce all necessary actions with a database – to add, delete, edit a structure and records in tables, to export data, execute SQL queries. Highlighting and autocompletion works for SQL files also.
Support of FTP allows to work straight with a remote server and to do all necessary changes with files;
The portable option allows to use editor without the preliminary installation.
Other useful utilities: pair highlighting, possibility of blocks selection, collapsing, tooltips, navigation on descriptions of functions and included files at withholding of the key of CTRL, viewing of structure of files and project, preview in a browser, book-marks, and all other standard possibilities for work with a code.
In July 2010, SAP Mentor Ivan Femia released the first version of the open source project abap2xlsx that allowed ABAP developers to generate professional spreadsheets from scratch with all the advanced features that stand alone Excel editors provide like: style and cell data formats, drawings support, conditional formatting, formulas, and so on.
This project has improved the user experience compared to excel generated using SAP standard components (such as ABAP ALV, WebDynpro ALV, System menu, etc.) and it has made ABAP developers more freedom adding, for example, the ability to generate an excel from non dialog processes and to include the generated excel as email attachment. At last but not least, this framework allows the use of spreadsheets in an interactive way, making possible to read them via ABAP for further processing.
Time after time, more and more SDN community members joined into the project and improved its functionalities. The abap2xlsx project reaches a large number of contributors, so today it is almost time for the new release that will include many new features such as the use of template files for charts, very hidden sheet, many bug fixes and so on. In this blog we will focus on one of the most important news: the ability to create custom charts from scratch!
Yes, that’s right: with just a few simple ABAP code lines, you can create business graphics within the excel file and send it, for example, to many iPhone/iPad via a push notification or via an html email (as weekly summary for example).
Another interesting way to use abapxlsx charts is to generate them using abap and then catch them as an image in order to show the chart in a WebDynpro or to send it directly to a mobile device! You believe that this is not possible? It is not easy, but you can do it following these steps:
Generate the excel file with the chart as you wish via ABAP using abap2xlsx
Add a simple macro to the excel via ABAP using abap2xlsx in order to enable the excel to export the chart in an image file like this:
Write a simple vbs file via ABAP in order to run the image generation like this:
Save the excel file and the vbs on the SAP NetWeaver Application Server filesystem via ABAP
* Opening the File
OPEN DATASET lv_filename FOR OUTPUT IN TEXT MODE
IF SY-SUBRC NE 0.
WRITE: ‘File cannot be opened. Reason:’, lv_msgtxt.
ENDIF.* Transferring Data
LOOP AT lt_table.
TRANSFER lt_table-line TO FILENAME.
ENDLOOP.* Closing the File
CLOSE DATASET lv_filename.
Run the saved VBScript file via ABAP
v_command = ‘cscript.exe test.vbs’.
CALL ‘SYSTEM’ ID ‘COMMAND’ FIELD v_command.
The chart image has been generated! Get it from the Application Server filesystem via ABAP and display or send it!