The DCT2SQL template collection allows conversion of Clarion dictionaries to several SQL backend DDL creation scripts.

There are also several utility templates making the conversion from ISAM files to SQL files easier.

Since the last update there have been a couple of template additions, several template enhancements, and four utilities added.

Most notable is that the PostgreSQL template continues to be enhanced.

Support for this template can be found in the Forums.

If you want to create bar charts, pie charts, line charts or area charts as PDFs royalty free then this Dynamic Link Library (DLL) is for you.

The PDF Chart Creator DLL gives you full control over all aspects of the chart including page size, colors, axes, titles, labels, positioning, legends etc. All you have to do is supply the data and optionally change the default settings and the chart automatically adapts to fit the page based on your settings.

Because the charts are produced as PDF they are scalable and resolution independent so they can be viewed and zoomed without any "blockyness" or "jaggies" appearing. They also look great printed even at very high printer resolutions.

You may be surprised at how small the file size of each PDF Chart Creator document is (typically around 3Kb) – this is because the PDF Chart Creator DLL has been carefully written so that it optimizes the output to produce extremely small PDF file sizes.

Why not take a look at http://www.UtilityWarrior.com/PDF-Chart-Creator-Examples.htm which has an example of every chart type and style currently available.

Now supports the automatic calculation and display of various numerical analyses including "line of best fit" (which uses linear regression) and "moving average".

For full details and to download the DLL please visit http://www.UtilityWarrior.com/PDF-Chart-Creator-Dynamic-Link-Library.htm - this is free to download and try and no details are required in order to access the ZIP file.

Best regards,
The Utility Warrior Team

Provides the following date procedures:

dayOfWeek - day of the week for a given date.
daysInMonth - days in the month for a given date.
isEasterSunday - Easter Sunday is for a given date.
isLeapYear - is given year a leap year.
isMonthName - name (STRING) of a given month.
isWeekDayNumber - week/day number a given date falls on.
julianDayNum - Julian day number for a given date.

iQ-XML is a free tool for Clarion developers to add XML functionality to their applications with very little knowledge.

But, don't let the free price scare you. It offers many features not found in Clarion's own XML functions.

iQ-XML comes with both Parser and Writer functions. Quickly generate an XML document from a Clarion Queue, Group structure, or just using the API's.

A novice user can also read a complex XML document and fill a Clarion Queue. Navigate easily through-out the document, finding nodes and parsing only what you need.

For users who feel comfortable with Templates, there are also templates options available for all the API's. Both PDF, Online HTML documentation, as well as example applications are also included.

No (or very little) knowledge of XML needed

Process XML files with cdata and attributes

Easily fill queue contents with different field names

Easily handle dimensional queue fields (reading and writing)

Easily debug your process with an included XML debugger

Easily show and debug the contents of your own Clarion queue

Cascade field contents from one level in to another level

Easily prime empty queue fields with values

Easily skip added queue entries based on optional data

Easily fill queue fields contents based on multi-level field names from parent and grandparent.

and so much more - and all this is totally FREE!

Need help?
Help for iQ-XML is available on the Clarion newgroups (see the online help for more information) - Because this is not my 'job', it is difficult to support the product through private email. However, feel free to send me suggestions or ask for help if you have tried everything!

A Non-Disclosure Agreement (NDA) between two parties. Usefull in developing your own. Word Document. Please contact an attorney for any legal assistance.

Greetings -

Recently, our ISP upgraded to PHP5 and that caused the Web Links area not to function correctly. So it was taken off-line.

As of today, the Web Links area is back on-line and functional. If you discover any area that does not work properly, please let us know so we can correct the problem.

The Web Links area is one available to all for submiting your personal websites, Clarion product websites, data websites, information websites, and usefull utility websites.

Regards,
Webmaster

If you use Clarion and want to create PDFs from images royalty free then this DLL is for you.

The Image to PDF Dynamic Link Library (DLL) will convert one or more images (JPEG, TIFF, PNG, GIF, BMP, WMF, EMF, PCX and TGA) into a PDF document.

Supports multi-image TIFFs, animated GIFs, JPEG image re-compression (if required) and the ability to auto-rotate images so that they are all in portrait or landscape orientation.

You can add clickable image stamps (eg company logo to web site), passwords, bookmarks and can even create simple full screen PDF slideshows - plus all of the usual PDF options.

For full details and to download the DLL please visit www.UtilityWarrior.com/Image-to-PDF-Dynamic-Link-Library.htm - NB this is free to download and try and no details are required in order to access the ZIP file.

Best regards,
The Utility Warrior Team

Greetings -

Recently I have had several forum questions being asked in the Frequently Asked Question. These have been deleted.

The FAQ is so inviduals that have "Frequenly Asked Questions" with answers already can post these items. It was available anonymously so anyone can access this area and then post these items.

It is not a place for asking general questions that you need answers to. That is what the forums are for. And for that you need to register.

Since there seems to be some confusion about this. The FAQ area will now become a registered user area also.

If there are any questions about this, please take the time to register, and post it in the appropiate forum area.

Class Anatomy - An Utility which resides in your taskbar and allows you to view the Properties and Methods of Classes

Usage:

Extract the 2 files to a folder of your choice and start ca.exe. In your tray area a new icon is visible. (zoom glass). Right click on the new icon and choose 'New project'.

In the window now appearing type a label for your project. (for instance 'File manager class'). Next, select the inc and clw file for this class and press save. Select the location where you want to save the project file.

Again right click on the new icon and choose 'Open project'. Select the saved project. Class Anatomy will now scan the files. When it is done a popup with a summary will be shown.

From the tray icon you can now choose new options. If you open a project it will be added to the list of recently opened projects. The last 10 projects (while the project files exist) will be available from the tray icon.

You can choose 'Class Anatomy' from the tray icon to view the class content. Click on an item to expand it's information. Double click on a label to open the appropiate file. (If you have textpad or ultra edit the correct line nr. will be selected. you can configure this in the main window.)

Also you can choose data/method picker to open the on-top pick list. The 3 icons on this window are: Rollup/rolldown window, more transparant, less transparant. Select the wanted data from the dropdownlist and view the data below.

Double click on a lable/declaration to copy it to the clipboard.

Contains a number of useful templates among them a global template called LinePrint that bypassing Windows print engine and printing directly to the printer port or a File.

Greetings -

I have added a category to Web Links under Clarion called NetTalk Web Servers.

This will allow individuals to add their NetTalk web server sites under this category.

You can add Web Links anonymously. So you can add your own or others.

There are many additional categories, so you can submit Web Links to sites you have found usefull.

You can even add Web Links to you own web sites, products, and services.

Regards,
Roberto Artigas

Greetings -

The website has been updated to XOOPS version 2.0.13.2.

The "Site Hits" statistics module (upper left hand) has also been upgraded to version 0.60.

I am continued to be pleasently supprised by the ease of administration of this content management system.

Regards,
Roberto Artigas

A function on how to detect whether or not a user has used the keyboard/mouse.

NetHack.zip contains an application and executables to retrieve IP information. Please note that nc.exe will trigger a virus detection. Source is available on web, so you may want to compile your own rather than rely on nc.exe

This SQL standards paper proposes multisets as a new kind of collection type.

The download link has been fixed for this file.

RTFCreator is a new, simple, free tool that I have made available on Icetips. Right now it is distributed as a single EXE in a zip file and there is no help for it and no install.

Download, unzip into any directory and start using it. Apart from a simple RTF editor it only has 3 textboxes and 2 buttons, so I'm not sure what to put into help for it.

RTFCreator was created out of need. Need to fill in RTF fields that were for display purposes only. I got tired of creating the RTF in WordPad then copy/paste and create the Clarion string out of it.

Besides the RTF created by WordPad always had extra verbage that I didn't need and didn't want. Constructing simple RTF is a PITA and I figured I should be able to do something about it.

RTFCreator takes care of that by letting you create a RTF text and display it as formatted RTF, RTF code and Clarion ready RTF code. By Clarion ready RTF Code I mean that all the { have been doubled up to {{ etc. and it is ready to be pasted into a clarion string variable.

The simple RTF editor that comes with it allows you to save and open RTF files.

The zip file is about 1.6Mb download and the exe is compiled local in Clarion 6.3, so you can run this without problems no matter what version of Clarion you are working with.

Enjoy.

If you have any comments on improvements (apart from the obvious such as help and install please drop me an email.

Best regards,

Arnór Baldvinsson
Icetips Software
San Antonio, Texas, USA
www.icetips.com
arnor@icetips.com

The DCT2SQL template collection allows conversion of Clarion dictionaries to several SQL backend DDL creation scripts.

There are also several utility templates making the conversion from ISAM files to SQL files easier.

Bo Schmitz has added a couple of utility templates to make conversion of TPS to SQL a bit easier.

Support for this template can be found in the Forums.

Part 14 of ISO/IEC 9075 define ways in which Database Language SQL can be used in conjuction with SQL.

It's a lengthy (40 pages) analysis of ITSM and related IT governance concepts from a data architecture perspective. Included is a high level entity-relationship model, definitions, discussions of general data issues as pertinent to internal IT enablement, and some initial thoughts on data/process matrixing. Extensive coverage of the Configuration Item concept.

I hope that this is useful to ITSM practitioners!

Regards,
Charles T. Betz

This is in our Data Modeling related documents section which is restricted to registered users.

The producers of the CobiT (ITGI) and ITIL (OGC/ITSMF) standards have published an official mapping between CobiT and ITIL, which also references ISO 17799.

This document is in the Data Modeling document category which is restricted to registered users.