The OpenEdge Hive

Version 3 of the Progress Standard Libraries Project is available for download.

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

Here's a short list of some of the new updates -

1. Backup/Archive/Restore utilities.

2. Salesforce.com integration library.

3. Google API library.

... and many more

Planned updates -

1. 4GL Regex library.

2. Free lite version of the 4GL Query Optimizer.

3. Free lite version of the Word and Excel utilities.

What would you like to add ?

If you have any questions or requests please feel free to contact me.

Alon Blich

New Backup/Archive/Restore Utilities Added to the Progress Standard Libraries Project

Quick overview -

Backup utility -

The backup utility does a full backup and then 6 incremental backups every time it runs for every database.

There's an additional script to backup after images that can be set to run every 15/30 minutes. The backup and after image backup use .lk files and will not interfere with each other.

Archive utility -

I've uploaded version 9 r-code for the Word and Excel utilities.

Like almost everything else we do the utilities are compatible with version 9 or better and work on UNIX/Linux and Windows.

Please download the utilities and try the samples.

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

If you have any questions or requests please feel free to contact me.

Alon Blich
Email: alonblich@gmail.com
Phone: +972-54-2188086
Skype: alon.blich

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.

I am new to pdf include and new to OEhive. we have a custom module which attaches "invoices" in pdf format and sends it as an email. The problem that we are facing is that for some reason the size of the files increases to 2 - 6 MB even though based on the amount of information that is packaged the pdf file should be far smaller around 100k (as per the users ..).
has anyone faced this problem ..all helpful tips would be appreciated. (I am new to this functionality and am going through the code ...).
if more information is needed - please let me know.

Thanks in Advance !!

Accepted a position in March 2011 with PNY Technologies in Parsippany NJ, as Sr. Programmer/Analyst. We are installing the Epicor 9 MRP system, the business logic of which is written in Progress ABL.

I'm doing various enhancements to the Business Objects to customize the system for PNY's needs. We will eventually install e9 in our facilities in France and Taiwan.

The GUI is written in .Net and all ABL is run on appservers. We are actually using a SQL-Server database and Progress DataServer for MSSQL.

Dear All,

Please anybody tell me how to fix my corrupted Progress database.
I've tried to do :
- proutil "mydb" -C truncate bi -F
the error is 'stack buffer overflow'

Thank's

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.