aus WOLutz, der freien Wissensdatenbank

OpenOffice.org Utilities; Free Software (GPL); hier gehts zur deutschsprachigen Beschreibung.

Inhaltsverzeichnis 1 Description 2 Download 3 Usage 4 Info

Description

The OOoMacroScanner is a utility to analyse office-documents. It analyses both ms-office- and OpenOffice.org-documents and might be used to support the planning-phase in a migration szenario for example within a migration from ms-office to OpenOffice.org (OOo). The OOoMacroScanner uses OOo to open the respective documents and collects information about contained basic-macros (VBA and StarBasic). The information is displayed in a calc-document that contains four spreadsheets. Each spreadsheet represents a different level of detail:

• Spreadsheet "Documents": contains information in the document-level
  • path and filename of the scanned documents,
  • number of all lines of macro-code,
  • md5 checksum of the documents which could be used to find duplicate files.
• Spreadsheet "Modules": contains Information about the basic-modules that are available in the documents:
  • path and filename of the scanned documents (that contain the basic-libraries),
  • names of the basic-libraries (that contain the modules),
  • names of the basic-modules,
  • number of lines of each module,
  • md5 checksum of each module to find duplicate modules.
• Spreadsheet "Functions": contains information about the sub-functions within the basic-modules:
  • path and filename of the scanned documents (that contain the basic-libraries),
  • names of the basic-libraries (that contain the modules),
  • names of the basic-modules (that contain the sub-functions),
  • function-signature of each sub-function,
  • number of lines of each sub-function,
  • md5 checksum of each sub-function to find duplicate functions.
• Spreadsheet "Code": contains the complete source-code of all basic modules:
  • md5 checksum (which is used as a index to resolve references from the "modules"-spreadsheet),
  • the number of lines of each module,
  • the number of references from the "modules"-spreadsheet,
  • the source-code of the basic-macros.

Download

Copyright (C) 2006 Christoph Lutz

The OOoMacroScanner is free software licensed under the terms of the GNU Public Licence (GPL).

Current Version 0.1:

• the executable Jar-File (executed with "java -jar OOoMacroScanner.jar") [OOoMacroScanner.jar]
• the eclipse-source-project [OOoMacroScanner_EclipseProject.zip]
• the java-sources [OOoMacroScanner.java]

Usage

The OOoMacroScanner requires an installed OpenOffice.org2 and a JRE1.5 and is executed using the following command:

java -jar OOoMacroScanner.jar <list of documents or directories>

The list of documents or directories is required to specify the documents to scan. Directories will always be traversed recursive and all contained documents will be scanned.

Info

If you have questions, please write an E-Mail to "info AT wolutz DOT de"