New year and new resolutions (Excel-like javabean for Oracle Forms)

24

Posted by Hafed | Posted in Forms, oracle, PJCs/Javabeans | Posted on 08-01-2010

Fortunately, 2009 is now gone. Really bad year as far as I am concerned. I lost my father in October after an illness. That does not justify the lack of posts or the updates on the various forms components I have here. The mood was not there unfortunately.

However, I did manage to squeeze out a nice Excel-like javabean that can be connected to Oracle data sources from Forms. While that works, I am totaly at a loss of what can be done with it since I am not really a spreadsheet expert.

So, if you have in mind some nice business scenarios for such a bean, please let me know. That would include for example one or more tables and simple usage scenario for a spreadsheet usage within Oracle Forms. Send them to info [at] degenio.com

The one I have done was just to import the data from the table and from there do some charting within the Excel bean. It would be interesting to get some financial usage scenarios.

FRITE- the rich text editor with Right-to-left languages

52

Posted by Hafed | Posted in PJCs/Javabeans | Posted on 27-03-2009

I have been working on adapting FRITE, the rich text editor to work with right to left languages such as Arabic and Hebrew and the results are here.

Arabic

FRITE Rich text editor in Arabic

Hebrew – Translation of “Here is how my Hebrew text should look like in FRITE” courtesy of

Frite- rich text editor in Hebrew

The only addition to the code was the following statement:

document.putProperty(“i18n”, Boolean.TRUE);

But I still need to validate the overall workflow with users that work with Arabic or Hebrew on a daily basis.

I guess the same applies for Persian, Urdu and other right to left languages.

Google static Map release 0.12

10

Posted by Hafed | Posted in PJCs/Javabeans | Posted on 12-03-2009

The 0.12 release is now available and can be downloaded from the sourceforge page.

I will be making a special page for this bean here on degenio.com. In the meantime, let me know of any special features you would like to see in this bean.

In version 0.13, I will be adding other languages and polylines.

If I have time, I will get Rhino to work with the gmap form module and from there use Google map with directions. So, within the form module, you should be able to get directions from point A to point B.

Special, special: Today, March Friday 13th (what a coincidence!) is the last day for the PJC competition. We have a heated race over there and it should be a very close call. If you did not vote, please go here and VOTE :)

Static google map- version 0.12

19

Posted by Hafed | Posted in oracle, PJCs/Javabeans | Posted on 09-03-2009

Here is an update to the static google map. I have added the following:

  • User can now enter address info using only latitude and longitude
  • User can zoom in and zoom out using a popup menu on the image itself
  • User can pan (vertical and horizontal) in either directions.
  • Some minor changes to the class structure. Now using Mercator projections for panning.

In order to better manage this project, I will upload everything on sourceforge this week.

Here is a screenshot:

Frite v0.11 available now for download

81

Posted by Hafed | Posted in oracle, PJCs/Javabeans | Posted on 25-02-2009

Good news. I finally managed to get Frite available for download from sourceforge.net. Please check the page I dedicated for Frite. All the information about Frite is there.

Here is the link.
http://www.degenio.com/frite
Please do not forget to make comments and advise of any bugs, suggestions, etc…
Thanks

Update: Please use the comments system here for any questions related to Frite (download, features, links etc.)

Frite- presentation on screentoaster

5

Posted by Hafed | Posted in oracle, PJCs/Javabeans | Posted on 23-02-2009

Here is the link on www.screentoaster.com presenting Frite.

The bean has been submitted to the java beans competition on the PJC depot. You can download from there or from sourceforge.net.

The link on sourceforge should be available tuesday feb 24, 2009.

Support for PDF and HTML output within FRITE

2

Posted by Hafed | Posted in Forms, oracle, PJCs/Javabeans | Posted on 19-02-2009

Frite is designed as an HTML editor for Oracle Forms and as such the content in the forms module when sent to report should also be available for output. The formats I had in mind are PDF and  HTML.

Those beta-testing Frite did not encounter problems with reports in HTML format. For example, links are clickable and all HTML content is rendered properly.

However, as far as PDF format is concerned, there are problems which I already illustrated in the developer’s guide. Those are due to limitation with Oracle reports. If you remember how reports processes items containing HTML content, you have to set the item property “HTML content” in the report itself. But this is not sufficient because reports does not take into account all of the HTML tags. Only a limited subset is rendered properly, for example bold, italic and underline.

So, how do you go about taking care of the other HTML tags?  Well, what I included in the example report is the procedure cleanHTML , it is one small example of how you would go about handling the HTML in the item.

if your format is PDF, then you would parse accordingly and then do the tags rendering conversion on the fly.

For the time being, that’s how I think I would do it but once Frite is made available to others, I will ask the community for ideas.

But definitely, I think we have a point there.

PJC/Javabeans competition

4

Posted by Hafed | Posted in oracle, PJCs/Javabeans | Posted on 11-02-2009

For those that are interested, Francois Degrelle is celebrating the three years anniversary of the PJC/Javabeans depot. Here is a link to the announcement.

There are already a number of submissions and it seems the winner will be hard to determine :) given the innovative ways those beans use Oracle Forms.

Google Static Map javabean with Forms 10g: new improvements

6

Posted by Hafed | Posted in Forms, oracle, PJCs/Javabeans | Posted on 11-02-2009

A number of users asked whether the bean can be improved in order to have the same feature as the full fledge google map.

The answer is Yes. I already tried the zoom and pan controls to the Google static map. However, my time now is being spent on completing the HTML rich text editor and I really can’t deliver the Google map bean without extensive testing.

This is the planned schedule for the coming days (note to myself :) of course):

  • Complete and release the HTML rich text editor. This one is in the hands of the beta-testers. It should be available very soon.
  • Translate the SMS article to English.
  • Test and release the Google static map with zoom and pan controls.

Forms HTML Editor- Update

15

Posted by Hafed | Posted in Forms, oracle, PJCs/Javabeans | Posted on 04-02-2009

I have completed the development and testing phases for the Oracle Forms HTML editor. Most of the features I mentioned before are now in the editor.

Based on some suggestions, the editor is now officially named FRITE  (pronounced like Freet).

Before I release it in the wild, I am looking for 5 or 10 beta-testers . You will get the JAR file, developer’s guide and user’s guide. You will receive the material Friday Feb 06, 09 and should send back your feedback by Monday Feb 09, 09 midnight EST.  I understand that most do not work week-ends but at least you’ll have monday to get FRITE through its paces.

Please send an email to info [at] degenio.com with your name and email address.

Thanks.

Update: Friday Feb 6,09. Beta-testing will start on Monday Feb 9,09.