The OpenEdge Hive

Just finished several big updates to the Word and Excel utilities.

Recent Word Updates -

- Added support for parts and sub parts using bookmarks (see the samples/src/word/sale_order.p sample).

- Added support for HTML and RTF values instead of plain text, numbers, dates etc. (see the samples/src/word/sale_order_html.p sample).

Recent Excel Updates -

- Added a meta table for setting field formats, styles, summaries etc. (see the samples/src/excel/create_template_ttmeta.p sample).

- with much improved calculated fields features.

http://www.oehive.org/project/libooxml

Recent Excel util updates -

- Added a template generator procedure (samples: samples/src/excel/create_template.p and create_template_dataset.p).

- Added support for datasets.

- Added automatic field mapping, if the Excel defined name is the same as the buffer field.

- Added borders, colors, fonts, formatting, alignment etc. styles settings (samples: samples/src/excel/set_styles.p).

Recent Word util updates -

- Added support and samples for pictures in the Word util.

Planned updates for the Word util -

I've seen companies translate their application for example from Dutch to French or English etc.

and even though machine translation isn't perfect it might help speed things along.

I've added a Google API library with Google Translate to the Standard Libraries project.

http://www.oehive.org/project/lib

Here's how it works -

/**
 * test-slibgoogle.p -
 *
 * (c) Copyright ABC Alon Blich Consulting Tech, Ltd.
 *
 *  This program is free software: you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
  

I've recently added a watchdog procedure to the Standard Libraries Project that exits safely after a specified period of inactivity.

Works on version 9 and upwards, GUI or Char, UNIX/Linux and Windows.

http://www.oehive.org/project/lib

If anyone needs something like this you may want to have a look at slib/watchdog.p.

To start the procedure -

run slib/watchdog.p persistent.

I've added some code parsing features to the Standard Libraries.

http://www.oehive.org/project/lib

Below is a sample for parsing queries -

/**
 * test-slibpro.p -
 *
 * (c) Copyright ABC Alon Blich Consulting Tech, Ltd.
 *
 *  This program is free software: you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation, either version 3 of the License, or
 *  (at your option) any later version.
 *
 *  This program is distributed in the hope that it will be useful,