File Naming Wizard

Follow the steps to generate your filename using the complete BISSELL product hierarchy.

💡 Tip: Press Enter after each selection to quickly move to the next step!

1
2
3
4
5
6
7
8

Step 1: OMG Job Number

Enter the OMG job number that will prefix your filename.

Press Enter ↵ This number will prefix your final filename

Step 2: Product Category

Select the main product category.

Press Enter ↵

Step 3: Product Type

Select the specific product type.

Step 4: GPD Number

Select the GPD product number.

Step 5: Product Name

Select the specific product name.

Press Enter ↵

Step 6: Asset Type A

Select the primary asset type.

Step 7: Asset Type B

Select the specific asset type.

Step 8: Final Details

Complete the remaining details for your asset.

Custom text descriptor (no underscores allowed). Will be moved to front of DAM filename.

🔍 Filename Decoder

Paste an existing filename to decode its components and see the folder structure.

Enter Filename to Decode

Help & How-To Guide

🎯 New Consolidated Structure

This tool now uses the complete BISSELL product hierarchy from the Excel structure:

  1. OMG Job Number: Prefixes production filename, moved to metadata for DAM
  2. Product Category: wet, dry, consumables, sanitaire, rug-doctor
  3. Product Type: canister, upright, stick, robot, etc.
  4. GPD Number: P#### product codes
  5. Product Name: crosswave, pet-hair-eraser, cleanview, etc.
  6. Asset Type A: digital, imagery, logo, parts
  7. Asset Type B: hero, lifestyle, banner, a-plus
  8. Color Profile & Colorway: rgb/cmyk + colorway (when applicable)
  9. Custom Descriptor: Optional free text (e.g., 250x250banner1, 300x300)

📝 Filename Formats

Production Format: [OMG-JOB-NUMBER]_[product-hierarchy]_[colorway]_[customDescriptor].ext

DAM Format: [customDescriptor]_[gpd-number]_[product-name]_[asset-types]_[colorway]_[omg-job-number].ext

Examples:

Production: 12345678_dry_robot_p2990_crosswave-robot_imagery_hero_NCW_250x250banner1.ext

DAM Renamed: 250x250banner1_p2990_crosswave-robot_imagery_hero.ext

Key Changes for DAM:

  • Custom descriptor moves to front
  • Job number, "dry", "robot" removed from filename
  • "NCW" colorway removed from filename
  • Removed data preserved in metadata

🏷️ Custom Descriptor Field

Purpose: Add custom text like "250x250banner1", "300x300", "EcomAsset1"

Rules: No underscores allowed - use other characters only

Behavior:

  • Appears at end of production filename
  • Moves to front of DAM filename
  • Visible in both versions (not removed)

Example: "250x250banner1" helps identify banner size/variant

🎨 Colorways & Folder Structure

Always Required: Must select a colorway for every asset

Available Options: Product-specific colorways or "NCW" (No Colorway)

Folder Behavior:

  • Real colorways create folders: /imagery/hero/rgb/mambo-red/
  • NCW does not create folder: /imagery/hero/rgb/

Filename Behavior:

  • Production filename always includes colorway
  • DAM filename excludes "NCW" but includes real colorways

🔧 Consumables Workflow

Consumables Only: When working with consumables, you have "Generic" options available.

GPD Numbers: For consumables, select "Generic / No Specific GPD" when working with broad asset categories.

Product Names: For consumables, select "Generic / No Specific Product" or choose from all available products.

Other Categories: All other product categories (dry, wet, sanitaire, etc.) follow strict hierarchy matching.

🔄 Cascading Selections

Each level filters the options for the next level based on the Excel structure relationships. This ensures all combinations are valid and follow the established hierarchy.

⌨️ Keyboard Navigation

Press Enter: After making any selection or entering text, press Enter to automatically move to the next step.

Faster Workflow: No need to click "Next" - just type or select and press Enter!

Smart Validation: Only advances if the current field has a valid value.

🔧 JSON Data Management

Dynamic Loading: This tool loads product data from bissell-product-data.json

Easy Updates: To add new products, update the Excel file and run the conversion script:

  1. Replace BISSELL_AEM Folder_Hierarchy6-30.xlsx with new version
  2. Run: python excel-to-json-converter.py
  3. Refresh this tool to see new products

No Code Changes: Product updates require no HTML modifications - just update the JSON file.

🔍 Using the Decoder

Purpose: Analyze existing filenames to understand their structure and folder paths.

How to Use:

  1. Click the "🔍 Decode Filename" tab
  2. Paste any filename (with or without extension)
  3. See the breakdown of components and folder structure

Supports:

  • Legacy filenames without custom descriptors
  • New filenames with custom descriptors at the end
  • NCW colorway handling (no folder created)
  • Automatic detection of custom descriptors vs colorways

Example Inputs:

12345678_dry_robot_p2990_crosswave-robot_imagery_hero_NCW_250x250banner1.ext

5791356_wet_wash_p3084_crosswave_imagery_hero_rgb_mambo-red.tif