v1.9.0

Spreadsheet Wrangler 1.9.0

New Features

Handbuilt Folder Support

• Added special handling for folders named "handbuilt" (case-insensitive)
• When a handbuilt folder contains exactly one spreadsheet, that spreadsheet is automatically combined with all other spreadsheet groups
• The handbuilt spreadsheet is always placed first in combinations to ensure its headers are used consistently
• This feature simplifies workflows where a master template needs to be combined with multiple spreadsheet groups

UI Improvements

• Added horizontal scrolling to both Backup Locations and Spreadsheet Folder Locations list views for better visibility of long paths
• Adjusted vertical sizing of list views:
  • Backup Locations list view shows 1-2 rows minimum before scrolling
  • Spreadsheet Folder Locations list view shows 3-4 rows minimum before scrolling
• Added tooltips to section headers ("Backup Locations" and "Spreadsheet Folder Locations") for improved usability
• Fixed tooltip behavior to consistently display instructions when hovering over list views

How It Works

1. The application detects if any selected folder is named "handbuilt" (case-insensitive)
2. If found, it checks if the handbuilt folder contains exactly one spreadsheet
3. If exactly one spreadsheet is found, it's combined with all other spreadsheet groups
4. The handbuilt spreadsheet's headers are used for all combinations
5. If the handbuilt folder contains multiple spreadsheets or doesn't exist, the standard grouping logic is used

Bug Fixes

• Fixed lint warnings related to PowerShell automatic variables
• Fixed visibility issues with the Backup Locations list view
• Improved tooltip behavior throughout the application

Installation

Download the latest release and run the PowerShell script. Requires PowerShell 5.1 or higher and the ImportExcel module (will be automatically installed if missing).

Requirements

• Windows with PowerShell 5.1+
• ImportExcel module (auto-installed if missing)

1.8.5

Spreadsheet Wrangler v1.8.5

This release introduces a new processing option, several UI/UX enhancements, and important bug fixes to improve stability and user experience.

✨ New Features

• Skip SKU Processing Option:
  • Added a new "Skip Sku Processing" checkbox in the options panel.
  • When checked, the main run process will bypass the SKU list processing step (Process-SKUList).
  • This option is now saved and loaded with configurations and reset with "New Configuration".

🚀 Improvements & Enhancements

• Configuration Management:
  • Assigned unique .Name properties to all option checkboxes for more robust and maintainable configuration saving and loading.
  • Improved Save-Configuration and Load-Configuration functions to primarily use these names, with fallback support for older, index-based configuration files.
• UI Enhancements:
  • Restored the "Option 12" placeholder checkbox to maintain UI layout consistency.
  • Swapped the "No Headers" and "Skip Sku Processing" options in the UI and underlying logic based on user feedback. The "No Headers" option is now located where "Skip Sku Processing" was, and vice-versa.
• Single Spreadsheet Mode Logic:
  • When "Single Spreadsheet" mode is activated, the "BLANK" option is now also disabled and unchecked (similar to "No Headers").
  • When "Single Spreadsheet" mode is deactivated, both "No Headers" and "BLANK" options are now correctly re-enabled, and their original tooltips are restored.
  • Removed the timestamp from the output filename when using "Single Spreadsheet" mode. The output file is now named OriginalFileName_Duplicated.xlsx instead of OriginalFileName_Duplicated_YYYYMMDDHHMMSS.xlsx.

🐛 Bug Fixes

• Critical Syntax Error: Resolved a PowerShell parser error (Unexpected token '}' in expression or statement) that occurred near line 1961. This error was caused by a misplaced code block related to the "New Configuration" menu item and prevented the script from launching.
• Configuration Reset: Ensured the "New Configuration" menu item correctly resets all relevant UI elements and script variables, including the new "Skip Sku Processing" checkbox and label paths.

📝 Notes

• Internal refinements to SKU list processing (using hashtable lookups for TCGplayer ID matches, improved error handling) and the Start-SpreadsheetCombiningProcess function were made in earlier development cycles leading up to this version.
• The Select-FolderDialog and Create-Labels functions were also introduced in previous iterations.

---

Thank you for using Spreadsheet Wrangler! Please report any issues or suggest features on our GitHub page.

v1.8.4

Spreadsheet Wrangler v1.8.4

What's New

• Added Application Logo: Integrated a custom logo in the About dialog for better branding
• Improved About Dialog: Enhanced layout and spacing in the About section

Notes

This is a minor update focused on visual improvements. All existing functionality remains unchanged.

v1.8.3

Spreadsheet Wrangler v1.8.3

New Features

Auto-Update System

• Added "Check for Updates" option in the Help menu
• Automatic version comparison with GitHub releases
• Seamless download and installation of updates
• Display of release notes for new versions
• Relaunch app via the .vbs (if available) or via the .ps1

Enhanced User Interface

• Improved button states with visual feedback:
  • Blue: Ready to run
  • Yellow: Currently running
  • Green: Successfully completed
  • Red: Error encountered (for label creation)
• Comprehensive welcome screen with detailed instructions
• Complete documentation of all available options

Recent Files Feature

• New "Recent Files" menu for quick access to previously used configurations
• Persistent storage of recently used files between sessions
• Easy clearing of recent files history

Improvements

• More detailed startup messages with clear instructions
• Better organization of options in the welcome screen
• Enhanced tooltips and descriptions for all features
• More consistent and informative log messages

Bug Fixes

• Fixed issue with button states not resetting properly
• Improved error handling throughout the application
• Better handling of file paths in recent files list

Technical Improvements

• More robust configuration saving and loading
• Improved application settings management
• Better memory management for large spreadsheet operations

---

Installation

Download and run the SpreadsheetWrangler.ps1 script with PowerShell.

Requirements

• Windows with PowerShell 5.1 or later
• ImportExcel module (automatically installed if missing)

v1.7.0

Spreadsheet Wrangler v1.7.0

What's New

Enhanced Duplication Functionality

• Modified the "Duplicate Qty=2" option to dynamically duplicate rows based on the numeric value in the "Add to Quantity" field
• If the field contains a number (e.g., 7), the row will be duplicated (n-1) times to achieve a total of n rows

New Skip Combine Option

• Added a new "Skip Combine" checkbox option that allows users to bypass the spreadsheet combining process
• This option is positioned alongside the existing "Skip Backup" option for logical grouping

Improved Configuration Management

• Added support for saving and loading label folder and template locations in configuration files
• Label paths are now preserved between sessions when saving/loading configurations
• Includes Input Folder, Output Folder, Param Template, PRT Template, and Dymo Template paths

UI Improvements

• Reorganized option checkboxes for better usability
• Swapped positions of "Skip Combine" and "All Formats" options for more logical grouping

Bug Fixes

• Fixed issue where label paths weren't properly displayed when reopening the Create Labels dialog

Technical Details

• Enhanced XML configuration structure to include label-related settings
• Improved dialog handling for label path management

Requirements

• Windows with PowerShell 5.1 or later
• ImportExcel PowerShell module

v1.6.0

Spreadsheet Wrangler v1.6.0

New Features

Label Creation System

• Added a comprehensive label creation system accessible via the new "Labels" menu
• Create labels from Excel files with customizable templates
• Support for both standard printer labels (.tsk files) and Dymo labels (.dymo files)
• Automatically processes all GSxx.xlsx files in the selected input folder

Template System

• Added support for custom template files:
  • Param Template (.param) - For printer configuration settings
  • PRT Template (.prt) - For label layout with data markers
  • Dymo Template (.xml) - For Dymo label creation

User Experience Improvements

• Enhanced dialog with tooltips for all fields
• Auto-fill input folder with Final Output location when available
• Detailed progress logging during label creation process
• Proper handling of special characters in card names and other data

Bug Fixes

• Fixed various syntax errors and improved error handling
• Ensured proper XML escaping for special characters in label data
• Improved temporary file cleanup

Technical Improvements

• Added support for both modern and legacy PowerShell versions
• Optimized file handling for large batches of labels
• Maintained backward compatibility with existing configurations

---

This release adds powerful label creation capabilities to Spreadsheet Wrangler, allowing users to generate both standard printer labels and Dymo labels from their spreadsheet data with customizable templates.

v1.5.1

Spreadsheet Wrangler v1.5.1

Performance & Reliability Update

This release significantly improves performance and reliability while removing legacy dependencies.

Major Improvements

• 🚀 Performance Boost: SKU list processing is now 4-5x faster through optimized data lookups
• 🔄 Removed Excel COM Dependencies: The application now exclusively uses the ImportExcel module for all spreadsheet operations
• 📊 Added GS_Missing Spreadsheet: Automatically collects and organizes all unmatched rows from combined spreadsheets
• 🔢 Natural Sorting: Spreadsheets are now processed in proper numerical order (1, 2, 3... instead of 1, 10, 11...)

Technical Enhancements

• Implemented hashtable-based lookups for SKU list data, dramatically reducing processing time
• Added robust error handling for spreadsheet exports with CSV fallback
• Improved data type consistency for more reliable matching between spreadsheets
• Enhanced logging for better visibility into the processing workflow

Notes

• No longer requires Excel to be installed on the system
• Maintains all existing functionality including special options (Duplicate Qty=2, Normalize Qty to 1, etc.)
• Compatible with existing configuration files

This update focuses on performance and reliability while maintaining the same user experience. The significant speed improvement for SKU list processing makes the application much more efficient for large datasets.

v1.4.1

Spreadsheet Wrangler (v1.4.1)

Changes

• Removed ExcelCOM from the codebase. Using exclusively ImportModule instead

v1.4.0

Spreadsheet Wrangler v1.4.0

New Features

SKU List Processing

• Added ability to match TCGplayer IDs from combined spreadsheets with TIDs in a SKU list CSV file
• New SKU List Location section in the UI for selecting the SKU list CSV file
• New Final Output Location section in the UI for specifying where to save processed GSxx files
• Automatically generates GSxx spreadsheets with matched data from the SKU list

UI Improvements

• Increased application height to better display multiple spreadsheet folder locations
• Added tooltips for new UI elements
• Added detailed logging for SKU list processing

Technical Improvements

• Robust CSV parsing to handle files with duplicate headers
• Flexible column name matching to accommodate variations in header formatting
• Improved error handling for price value parsing
• Added .backup folder to .gitignore

Bug Fixes

• Fixed handling of currency-formatted values in SKU list processing
• Improved barcode generation to correctly extract whole numbers from price values
• Enhanced CSV parsing to handle quoted values and special characters

How to Use the New Features

1. Select your spreadsheet folders and combined destination as before
2. Add a SKU list CSV file using the new "SKU List Location" section
3. Select a folder for the final output files using the "Final Output Location" section
4. Run the application to combine spreadsheets and process them against the SKU list
5. GSxx files will be created in the final output location with matched data

This release enhances the Spreadsheet Wrangler with powerful SKU list processing capabilities while maintaining all existing functionality.

v1.3.2

Spreadsheet Wrangler v1.3.2

Changes

• We are now forcing the use of ImportModule instead of ExcelCOM since it is waaay faster and all that is needed for the current state of this application. The ExcelCOM code is still there, just the check is changed to set the detection to false.

Bug Fixes

• Fixed tooltip initialization issue
• Improved error handling in spreadsheet combining process
• Fixed the Blank option to properly add BLANK in-between each spreadsheet that it combines
• Fixed the Reverse, Reverse option to properly reverse the data rows of the combined spreadsheet.
• Fixed the All Formats option to NOT duplicate data when all spreadsheets are the same format

Full Changelog: v1.2.0...v1.3.2