Fishbowl Report Tools

A general purpose tool to support Fishbowl Inventory database report and API development.

Downloads

2014-03-01 Latest w/ Dependencies

Usage

Simply download the zip, extract the EXE, and run the EXE to load Fishbowl Report Tools. Drag a Fishbowl Database (.FDB) to the application to begin using it.

Change Log

2014-03-01

• Added Database Tunnel
• Added API Scratchpad
• Added Export to XLSX Support
• Added Prompt for Database Credentials

2014-02-11 - Initial Public Release

• Database Statistics
• Tools
• Custom Fields
• SQL Scratchpad

Features

• Snapshot Database Statistics
  • Company Name
  • Fishbowl Database Version
  • Last Database Update Date
  • First Database Usage Date
  • Last Database Usage Date
  • Number of Sales Orders
  • Number of Purchase Orders
  • Number of Transfer Orders
  • Number of Receipts
  • Number of Shipments
  • Number of Parts
  • Number of Products
  • Number of Bill Of Materials
• Tools
  • Database
    • Reset Admin Password (resets to "admin")
    • Delete Userlog Table
  • Report
    • Base64 Embedding
    • iReport Parameter Tools (Pending)
• Custom Fields Listing
  • Lists Custom Fields
  • Generates SQL LEFT JOINs
• SQL Scratch Pad
  • Input any SQL and Execute [F9] to see results
  • Also accepts SQL UPDATE & DELETE
  • Export To XLSX (Excel 2010 XML)
  • Link to Fishbowl Data Dictionary
• Database Tunnel
  • Creates a Reverse SSH Tunnel to allow for remote troubleshooting
  • Asynchronous monitoring and logging of connection state
• API Scratchpad
  • Similar to the FishHook application, provides a way to test Fishbowl XML to a Fishbowl System
  • Login Panel
  • Logging and Performance Metrics

Screenshots

Loading A Database

Tools Tab

Custom Fields Tab

SQL Scratchpad

Download Sample Output

Database Tunnel

API Scratchpad

Where To Get Help

You can get help on the "Issues" page of this project's GitHub repository.

Disclaimer and Warning

You should really know what you are doing. This application can very well delete everything in your database if you tell it to do so. It may have a bug where it deletes everything. It may or may not catch your computer on fire. Using this application is at your own risk.

Motivations

This project was originally developed to speed the development of Fishbowl Inventory JasperReport (iReport) projects. Because of the initial need to develop on Windows platforms, C# .NET was used to create this application.

Dependencies

• Visual Studio 2012
• Firebird SQL ADO .NET
• EPPlus
• SharpSSH

Project License

This project is not released with any license. I may release a build with a FOSS license, later.

Library Licenses

See about page