g-fmb-cli — Oracle Forms FMB CLI Tool

Convert, edit, validate, and compile Oracle Forms FMB files from the command line.

Installation

npm install -g g-fmb-cli

Requires Node.js 18+.

Commands

fmb convert <file>        # Convert FMB to JSON (or JSON to normalized JSON)
fmb export <file>         # Rebuild FMB from edited JSON
fmb validate <file>       # Validate module structure and PL/SQL
fmb compile <file>        # Compile FMB to FMX (requires Oracle Forms)
fmb serve                 # Start local companion server for web editor
fmb login                 # Authenticate with your G-FMB account
fmb logout                # Sign out
fmb status                # Show auth & license status
fmb config list           # Show all configuration
fmb config set <k> <v>    # Set a config value
fmb config get <k>        # Get a config value

Examples

# Convert a binary FMB to JSON
fmb convert myform.fmb

# Pipe JSON output to jq for inspection
fmb convert myform.fmb --stdout | jq '.Blocks[0].Items | length'

# Rebuild FMB from edited JSON
fmb export myform.fmb.json

# Validate PL/SQL structure
fmb validate myform.fmb.json

# Compile FMB to FMX
fmb compile myform.fmb

# Start local companion server on default port 6832
fmb serve

# Companion server on custom port
fmb serve --port 9000

Configuration

Configuration is stored in ~/.fmb/config.json.

| Key | Description | |-----|-------------| | apiUrl | G-FMB cloud API URL (default: https://www.g-fmb.com/api) | | fmbToolPath | Path to local FmbTool.exe for offline conversion | | oracleHome | Oracle Forms home directory (e.g. C:\Oracle\OraDev6i) | | language | UI language: tr, en, or de |

CI/CD Usage

The CLI is pipeline-friendly — all commands exit with proper codes and output can be piped:

# In a CI pipeline: convert and validate
fmb convert form.fmb -o form.json
fmb validate form.json || exit 1

# Extract all PL/SQL into SQL file
fmb convert form.fmb --stdout | jq -r '.ProgramUnits[].Code' > all_code.sql

Local Companion Server

The fmb serve command starts an HTTP server on localhost that the G-FMB web editor can connect to for:

• FMX Compilation — compile FMB files using your local Oracle Forms installation
• Local file access — compile files by path without uploading

The server is localhost-only and not exposed to the network.

Links

• Web Editor: www.g-fmb.com
• VS Code Extension: Marketplace
• GitHub: DMG-Soft/FMB_Studio

License

Proprietary — DMGSoft. All rights reserved.