1) Tcl/Tk kanban with drag drop

At screenshot it is running macOS 26. It also works at Windows, Linux, BSD etc.

2) Go Fyne native GUI Kanban Board

A prototype Kanban board application native GUI with Go/Fyne/Excelize/SQLite. Saves boards, swimlanes, lists, and cards to a SQLite database. Exports board to Excel with Excelize.

Go/Fyne GUI has been simplified combined to small amount of buttons.

These are mostly related to making Excel XLSX export with attachment images.

TODO:

• Add export card to XLSX

3) Tcl/Tk GUI Kanban board

A prototype Kanban board application GUI with Tcl/Tk/SQLite. Clicking Export runs CLI executeable that uses Go based Excelize to export boardID based board from SQLite to XLSX.

TODO:

• Add export card to XLSX
• Simplify those too many Tcl/Tk buttons to be like Go/Fyne GUI small amount of buttons

TODO: Test attaching images at Excel XLSX Export

• Go Excelize: https://github.com/qax-os/excelize
• Node.js ExcelJS: https://github.com/exceljs/exceljs
• Tcl Excel: https://wiki.tcl-lang.org/page/Excel
• FreePascal FPSpreadsheet: https://wiki.freepascal.org/FPSpreadsheet

Features

• 📋 Multiple Boards: Create and manage multiple Kanban boards
• 🏊 Swimlanes: Organize your workflow with swimlanes
• 📝 Lists: Create lists within each swimlane (Todo, In Progress, Done, etc.)
• 🎫 Cards: Add, edit, and manage cards with titles and descriptions
• 💾 SQLite Storage: All data persists to wekan.db SQLite database
• 🎨 Clean GUI: Intuitive Tcl/Tk interface with color-coded elements
• 🖥️ Cross-platform Go GUI: Modern Fyne-based interface available
• 🖱️ Drag & Drop: Full drag and drop support for cards, lists, and swimlanes
• � File Attachments: Drag files onto cards to attach them
• �📦 Portable: Can be built as a standalone .kit file
• 📊 XLSX Export: Export boards to Excel files with image attachments using Go and Excelize

XLSX Export

The application supports exporting boards to XLSX format with image attachments.

Requirements for Export

• Go: Version 1.16 or higher (for building exporters)
• Excelize: Go library for Excel file manipulation

Building XLSX Exporters

Use the build script to create the exporters:

./build.sh

Select option 4 to build the Go binary (xlsx_exporter), or option 5 to build the embedded .so library.

Export Process

1. In the Kanban app, click the "Export" button next to a board in the sidebar
2. The app will attempt to use the embedded .so library first (if available)
3. If not, it falls back to the Go binary
4. The exported XLSX file will be saved in the project directory as board_<ID>_export.xlsx

The export includes:

• Board, swimlane, and list hierarchy
• Card titles, descriptions, and creation dates
• Image attachments embedded in the Excel file

Screenshot

The application provides:

• Sidebar with board navigation
• Swimlanes for organizing work horizontally
• Lists displayed in columns
• Cards with easy reordering via arrow controls (drag-and-drop style)
• Full CRUD operations for all entities

Requirements

Required

• Tcl/Tk: Version 8.5 or higher
• SQLite3: Tcl SQLite3 package

Optional (for building .kit files)

• sdx: Starkit Developer eXtension

Optional (for XLSX export)

• Go: Version 1.16 or higher
• Excelize: Go library (automatically downloaded during build)

Installation

macOS

• Install Tcl/Tk:

  brew install tcl-tk

• Install SQLite3 Tcl package (included with Homebrew Tcl/Tk)

Ubuntu/Debian

• Install Tcl/Tk and SQLite3 Tcl package:

  sudo apt-get install tcl tk libsqlite3-tcl

OpenBSD

• Install Tcl/Tk and SQLite3 Tcl package:

  su
  pkg_add tcl tk sqlite3-tcl
  /usr/local/bin/wish8.6 kanban.tcl

Other Systems

Download Tcl/Tk from https://www.tcl.tk/

Usage

Using the build script (Recommended)

Make the build script executable:

chmod +x build.sh

Run the build script:

./build.sh

You'll see a menu with options:

1. Check dependencies - Verify all requirements are installed
2. Build TclKit - Download latest TclKit and SDX for macOS
3. Build TclKit .kit file - Create standalone .kit executable
4. Build Go XLSX exporter (binary) - Compile Go binary for XLSX export
5. Build Go XLSX exporter as .so and embed in .kit - Build and embed .so library
6. Build executable (macOS app bundle) - Create standalone macOS app bundle
7. Run Kanban application - Launch the app directly
8. Run .kit file - Run the built .kit file
9. Clean build artifacts - Remove build files
10. Exit - Exit the script

Running directly

tclsh kanban.tcl
# or
./kanban.tcl

Go GUI Version

A modern GUI version built with Go and Fyne is also available:

./build.sh
# Select option 10: Build Go GUI executable
./kanban_go

The Go version provides a modern, native GUI experience while maintaining all the original functionality of the Tcl/Tk version, including full drag & drop support for cards, lists, and swimlanes.

Drag & Drop Features

The Go GUI includes comprehensive drag and drop functionality:

• Card Movement: Drag cards between lists within the same swimlane
• List Movement: Drag entire lists between swimlanes
• File Attachments: Drag files from your file manager onto cards to attach them
• Real-time Updates: All changes are immediately saved to the SQLite database

Create sample data (optional)

To populate the database with sample boards, swimlanes, lists, and cards:

./create_sample_data.tcl

This will create a "Sample Project" board with development and design teams, complete with sample cards.

Database Schema

The application uses SQLite with the following schema:

Tables

boards

• id: INTEGER PRIMARY KEY
• name: TEXT (board name)
• description: TEXT (board description)
• created_at: TIMESTAMP

swimlanes

• id: INTEGER PRIMARY KEY
• board_id: INTEGER (foreign key to boards)
• name: TEXT (swimlane name)
• position: INTEGER (display order)

lists

• id: INTEGER PRIMARY KEY
• swimlane_id: INTEGER (foreign key to swimlanes)
• name: TEXT (list name)
• position: INTEGER (display order)

cards

• id: INTEGER PRIMARY KEY
• list_id: INTEGER (foreign key to lists)
• title: TEXT (card title)
• description: TEXT (card details)
• position: INTEGER (display order)
• created_at: TIMESTAMP

How to Use

1. Create a Board: Click "New Board" in the File menu or sidebar
2. Add Swimlanes: Click "+ Add Swimlane" button
3. Create Lists: Click "+ List" button in a swimlane header
4. Add Cards: Click "+ Add Card" button in a list
5. Edit Cards: Click "Edit" button on any card
6. Delete Items: Click the "×" button on boards, swimlanes, lists, or cards

Reordering (Drag/Drop style)

You can quickly reorder items using arrow buttons:

• Swimlanes: use ▲ and ▼ in the swimlane header to move up/down
• Lists: use ◀ and ▶ in the list header to move left/right
• Cards: use ▲ and ▼ on each card to move up/down within a list

Note: Full mouse drag-and-drop is not implemented yet; these controls provide reliable, database-backed reordering.

Building Standalone Executable

To create a standalone .kit file:

1. Install sdx (if not already installed)
2. Run the build script:

   ./build.sh

3. Select option 2 (Build TclKit .kit file)
4. The kanban.kit file will be created and can be distributed

File Structure

TclTkKanban/
├── kanban.tcl          # Main application file
├── build.sh            # Build and run script
├── wekan.db            # SQLite database (created on first run)
├── README.md           # This file
└── kanban.vfs/         # VFS directory (created during build)

Features in Detail

Boards

• Create multiple boards for different projects
• Each board maintains its own swimlanes and cards
• Delete boards (cascades to all child elements)

Swimlanes

• Horizontal organization within boards
• Useful for team members, priorities, or workflow stages
• Position-based ordering

Lists

• Vertical columns within swimlanes
• Typically represent workflow stages (Todo, In Progress, Done)
• Scrollable card containers

Cards

• Rich content with title and description
• Click to view full details
• Edit or delete capabilities
• Position tracking for ordering

Data Persistence

All data is automatically saved to wekan.db using SQLite:

• No manual save required
• Data persists between sessions
• Database created automatically on first run
• Foreign key constraints ensure data integrity

Keyboard Navigation

• Tab: Navigate between fields in dialogs
• Enter: Submit forms (when focused)
• Mouse: Click and interact with all elements

Troubleshooting

"can't find package sqlite3"

Install the SQLite3 Tcl package:

• macOS: brew install tcl-tk
• Linux: apt-get install libsqlite3-tcl

"tclsh: command not found"

Install Tcl/Tk from your package manager or tcl.tk

Database locked error

Close any other applications that might be accessing wekan.db

Contributing

Feel free to contribute improvements:

1. Fork the repository
2. Make your changes
3. Test thoroughly
4. Submit a pull request

License

This project is open source and available under the MIT License.

Future Enhancements

Potential features for future versions:

• Mouse drag-and-drop for cards, lists, and swimlanes
• Card colors and labels
• Due dates and reminders
• Card attachments
• Search functionality
• Export/import capabilities
• Multi-user support
• Card history/activity log

Credits

Built with:

• Tcl/Tk - GUI framework
• SQLite3 - Database engine

---

Enjoy your Kanban workflow! 🚀