.
   
Clarion

Clarion is the programming language I am most familiar with, and I've been using it since 1989. Most of my work in Clarion is for roomMaster, a hotel software application I created in 1993. Other languages and technologies I am skilled in include XML, SQL, ASP, HTML and VisualBASIC. Here are a few things I've written which I share with the Clarion community.

  • iQ-XML
  • iQ-XML Primary Functions
  • iQ-XML Support and Consulting
  • iQ-Sync

iQ-XML
Written in Clarion by Robert Paresi

The easiest way to incorporate XML reading and writing in your Clarion application - with over 50 easy to use functions!

iQ-XML is a free tool for Clarion developers to add XML functionality to their applications with very little knowledge. It offers many features not found in Clarion's own XML functions. iQ-XML comes with both Parser and Writer functions. Generate an XML document from a Clarion Queue, Group structure, or using the API's. A novice user can read a complex XML document and fill a Clarion Queue easily. Navigate easily through the XML document, finding nodes and parsing only what you need.

  • Process XML files with CDATA and attributes.
  • Process XML files even with Binary fields (both parser and writer)
  • Easily fill queue contents with different field names including dimensional fields (parser and writer).
  • Easily debug your process with an included XML Debugger as well as debug the contents of your own queue.
  • Cascade field contents from one level in to another level during parsing.
  • Easily prime empty queue fields with values or skip added queue entries based on optional data requirements.
  • PDF and Online HTML documentation as well as example applications included.
  • Works easily with both Clarion Legacy and Clarion ABC - templates and hand-coding.
  • and so much more - and all this is totally FREE!

Great program! Thanks, this is just what I needed!! I had purchased "..." and spent over 30 hours trying to get it to write a queue to an XML file. I never did get it to work. I took iQ-XML and did it in less than 10 minutes!! - G.S.

"I really want to thank you for the fine work you've donated to the community with iQ-XML." - Jim

Clarion 7 Extra!

If you download iQ-XML for Clarion 7, the application IQRECENT.APP is placed in the IQXML Examples directory. This is a neat application which you can use so you can maintain/edit your Clarion 7 StartPage Recent items. It also comes with about five Clarion 7 UI Tweaks that will allow you to change the Clarion 7 menus to make things easier.

Fully Supported:

Download iQ-XML (Version 2.71 for Clarion 7.2 - August 31, 2010)

Download iQ-XML (Version 2.70 for Clarion 7.1 - May 22, 2010)

Download iQ-XML (Version 2.70 for Clarion 6.3.9053 to 6.3.9059 - May 22, 2010)


iQ-XML Versions (but No Longer Supported):

Download iQ-XML (Version 2.52 for Clarion 6.1.9034 - June 29, 2009)

Download iQ-XML (Version 1.07 for Clarion 5.5)

iQ-XML Functions

Parser Functions

  • Load/Parse XML from a file
  • Load/Parse XML from a string
  • Handle standard XML data, CDATA and Binary Encoding (Base 64)
  • Interactive XML Debugger Tool
  • Easily display the contents of a Clarion Queue with powerful options
  • Navigate through XML (ReadNext, ReadPrevious, ReadCurrent)
  • Easily find and navigate through the XML using FindNextNode, GotoTop, GotoChild, GotoParent, GotoSibling
  • Parse and entire XML document and place contents into a Clarion queue.
  • Pivot through different portions of the XML document and come right back using Save/Restore state.
  • Parse documents using Single or Double Quotes.
  • Advance parsing including Cascading Parent Data, setting field attributes and much more.

Writer Functions

  • Write/Create XML data to a file
  • Write/Create XML data to a string
  • Write standard XML data, CDATA and Binary Encoding (Base 64)
  • Add from a Clarion Group or Clarion Queue
  • Create Echo Tokens and GMT (Time Zone) adjustment fields

Additional Functions

  • Convert HTML to Plain Text (including tables)
  • Convert/Encode string text to XML data
  • Convert/Decode XML data to string text
  • Convert string text to HTML
  • Replace string text function
  • Display contents of a Clarion Queue on the fly in a single line. XML:DebugMyQueue(MyQueue,'Show me this!')

iQ-XML Support and Consulting

iQ-XML function library works with Clarion 6.1, 6.3 and 7.x -- it is currently being used by hundreds of people and in one instance, is used to process well over 1 million travel documents per month in a high volume environment.

The function library is free for anyone to use, provided it is not used to process OTA (Open Travel Alliance) documents.

Support for this product is only done through the Clarion NewsGroup: softvelocity.clarion.third_party

Contacting me for Support:

This product was written by Robert Paresi, as a free contribution to the Clarion community only.  Please use the newsgroups for general help.

A Charge for Support - Personal emails or requests for help will require a $75.00 (USD) charge per hour, for all cases and circumstances.  If the issue is determined to be a bug (a defect in the product within the parameters of what it is designed to do), the charge will then be refunded. If you would like me to help you develop a web-service or help with integrating XML into your Clarion 6.x or Clairon 7.x application, I can do that as well and usually charge on the project basis.

For help, I need your entire application and data files and a $75.00 deposit processed through PayPal.

Please download the latest version of iQ-XML before reporting any issue and please indicate both what version of iQ-XML and what version of Clarion you are using.  You can download it from www.paresi.net

Source Code:

Source code is not available for this product.

Suggestions:

If you have suggestions, please discuss them in the Clarion newsgroups or by email to the above address only.  If you would like to contribute changes to templates or help with working with other character sets, DTD, Schema Support, etc., please let me know.

I love this program ... use it 100 times a day.

This is a little utility which simply copies and synchronize files. Simply setup an unlimited number of copy projects, and then when you need to execute it, highlight the project and press Run.

In my environment, I have test (Alpha) servers, Q/A (Beta) servers and Production servers. As I modify the application, I have to promote the EXE's, DLL's, Help files, control files, and other files into each of these environments for a round of testing. Sometimes the users are in these directories, and iQ-Sync notifies me if the objects are in-use. I can say "wait until they become available" and iQ-Sync goes to sleep, waits for the lock to come undone and then copies the files in. I can walk over to production, ask everyone to exit out ... wait 10 seconds ... and tell them to go back in.

This little utility also synchronizes my Free Agent Seagate backup device, makes it simple to make a backup before I go home each night. I also have a project which copies the changed files back as a Restore project if I have used my FreeAgent backup device at home and make programming changes. I have another project which also copies all my APP's and DCT's to the file server each night under a different day of the week.

Creating projects is easy at Home and at Work. I simply create one project which goes TO the device, and then I create a duplicate of the project that copies from the device, simply pressing "Swap Source/Destination".

I literally uses this program all day long ... allowing me to easily create different environments of files, and I even have projects setup that copies the final builds in to a SetupBuilder build directory. You'll see that it is very fast.

This program will also optionally upload files to an FTP site.

It's totally free for anyone to use ... and I hope you find it as useful as I do. I decided to call it "iQ-Sync".

iQ-Sync 1.32- (September 1, 2010) Click here to download it!


  (c) 2009, Robert Paresi - All Rights Reserved