ReCsvEditor 0.95

This version of the ReCsvEditor includes:

1. Improved Macro (Scripting via languages that support JSR 233) support. Changes include:
   • Minor updates to Open File to improves looks and make better use of screen space.
   • Extra functions added to RecordEditorData variable.
   • Toolbar icon for Run Script Dialogue has been added
   • Basic text Editor added to Run Script Dialogue.
   • Documentation on Macro's added to How To documentation.
   • Example Documentation added

   If you are planning on writing Macro scripts you should also get ReCsvEditor_Macro_JavaDoc_0.95.7z. from the ReCsvEditor Site. It contains JavaDoc descriptions of the classes you will be using.

2. Also Included are 2 new Csv parsers that ensure the defined number of separator’s are included in Created / Changed lines.
3. New Text Editor View added.

Problem Reports / Change Requests

This is an open-source project, as such it needs community involvement. So if you find a problem or have suggestion please report the issue / suggestion.

Problem / Change / Feature requests are welcome can be made at any of:

• ReCsvEditor Discussions
• Sourceforge Feature Request
• Sourceforge Problem logging

Installing

Run the installer.

Upgrading

Run the installer

New Features

Script Changes

There have been a number of improvements to scripting:

1. Extra example scripts, you can run them via Utilities >>> Run Script >>> Examples you can view / edit / run them using Run Script dialogue Utilities >>> Script Test Panel.

   

2. There is a new Script Test Dialogue button on the Tab bar . You can use it to edit / run Macro scripts.

   

3. Documentation of scripting added to the How to Documentation

Text Editor View

A new Text editing view has been added to the ReCsvEditor. It is only available for Text files (not for binary files). To select the text view select View >>> Text View or View >>> Text View (Selected Records)

Once selected you can view / edit the file using a standard Text Editor.

You can also add a Child-Record Screen to display the current record in a table format.

New Csv Parser

This version of the ReCsvdEditor contains 2 new Csv parsers:

• Basic - Delimiter all fields - ensure there is a delimiter for every field (even when a field is not present)
• Basic - Delimiter all fields + 1 - ensure there is a delimiter for every field + an extra delimiter after the last field

Example of Basic - Delimiter all fields. If the Csv file is defined as having 4 fields but a line has 2 fields, it will be stored as:

1,2,,

Example of Basic - Delimiter all fields + 1. If the Csv file is defined as having 4 fields but a line has 2 fields, it will be stored as:

1,2,,,

Thanks

Creation of Software takes a lot of effort and I would like to thank the creators of the following open source packages (used by the ReCsvEditor):

• SableCC used by cb2xml (and this package) in the conversion of Cobol Copybooks.
• HSQLDB A SQL Database used as a backend DB for some versions.
• Velocity is used in several examples.
• Tablelayout Layout manager used by the ReCsvEditor
• jibx XML Bindings for storing Filter Details, Sort Details etc.
• jlibdiff Compare library used to compare files.
• rsyntaxtextarea Editor with syntax highlighting.

Changes

Release 0.95

• Added basic Script-Editor to the Script-Run dialog
• Extra Functions / Methods for use in Macro Scripts, More example scripts and Script-Documentation.
• Problem fix's and general cleanup.
• Updates to How to documentation for Scripts, Initial Screen size and Docking, Undocking, Child Screens.
• New Text Editor View.
• New positive binary types (Mainly for Cobol).
• Minor updates to Open File to improves looks and make better use of screen space.
• Added 2 new CsvParsers:
  • Basic - Delimiter all fields - ensure there is a delimiter for every field (even when a field is not present)
  • Basic - Delimiter all fields + 1 - ensure there is a delimiter for every field + an extra delimiter after the last field
• Increase space allocated to BigFile bat/sh scripts to 1.2GB on the assumption that most people have at least 2GB. This should allow editing of 3/4 GB files.

Release 0.90

• Related screens are now displayed as tabs on the one screen (default). There is still the option to display each view in its own screen.
• Different views can be docked / undocked with each other as needed.
• List screens can now have a Record Screen where the current record is displayed.
• Support for foreign languages via GetText po files / resource bundles produced via GetText. There are sample language files generated using Google Translate.
• Filter - added And / Or operators, also added Starts With operator.
• Enhanced HTML Export.
• Option to Open Exported file.
• Highlight changed fields on Compare screen.
• Updated Find function.
• Minor Gui changes.

Release 0.80.6

• New placement of files in the User Home directory (driven by Windows User Access Controls)
• New Program Startup (driven by Windows User Access Controls)
• Rewritten Save As/Export with a few more options. Changes incluse:
  • Separate Save As option
  • New Xslt export option.
  • New Script (Jython, JRuby, NetRexx etc) export option. It uses Java JSR 233 Script-Engine so any compatible languages should work.
  • When selecting a specific export option, only the relavent panel is displayed. There is an option to bring back the old look: Edit Options >>> Properties >>> Other Options Show all export panels).
  • Can now view / edit Csv, Xml and Fixed export files directly in the Editor.
• The File Copy and File Compare option's have moved from File to Utilities. This may change again in the final version.
• Delete key deletes selected records (There are options to control this in Edit Options >>> Properties >>> Other Options).
• Escape key will close most Utility Screens (work still needed, please report any I have missed) and the Single record Screens. The escape key will not close the main list screens !!!!.
• New option to control how the program starts (Edit Options >>> Looks >>> Screen Properties). Options include Maximised, Set Size or Last Size.
• Extended Record Selection, Record Selection can now been
  • done on multiple fields connected with And / Or boolean operators
  • >, < >= and <= operators
• Velocity included as standard (instead of being an option).
• Copybooks and sample files have moved from the install directory to the user directory (Windows UAC related).

Release 0.80.2

On the SaveAs/Export screen there is

• Option to edit the output file (only if the ReCsvEditor can work out the structure)
• Option to keep the screen open
• New Xsl transform option. You can use an external tool (e.g. saxon) but it must be allocated at ReCsvEditor Startup.
• Velocity / Xslt options now remember the extension last used with a particular Template

Release 0.80.1 Tree (including Xml)

• General Changes
  • New Tree Csv-Export
  • 2 Tree Variables (root & nodeList) provided to Velocity templates
  • 2 new Velocity Templates (zXmlStyleSheet1.vm & zXmlStyleSheet2.vm)