SceneFlix Data Handler

The SceneFlix Data Handler is a comprehensive suite of database management tools designed to help you maintain, organize, and extract data from your movie and TV show posts.

This powerful admin interface provides advanced functionality for managing your entertainment content database, ensuring data integrity, and facilitating content migration and analysis.

What is the Data Handler?

SceneFlix Data Handler

The Data Handler is a centralized control panel that manages the relationship between your WordPress posts and SceneFlix’s custom database tables.

It provides tools for extracting data, migrating content, synchronizing databases, and maintaining data consistency across your entertainment website.

Purchase SceneFlix Now

Accessing the Data Handler

To access the Data Handler features:

  1. Navigate to WordPress Admin – Log into your WordPress admin dashboard
  2. Find Data Handler Menu – Look for the “Data Handler” menu with a playlist video icon
  3. Select Tools – Choose from various data management tools available in the submenu

Data Handler Menu Structure

The Data Handler includes six main tools accessible through the admin menu:

1. Movie Extractor (Main Page)

Extract existing movie post data based on various criteria

2. Series Extractor

Extract existing TV show post data with flexible filtering options

3. Movie Data Submission

Migrate existing movie posts to SceneFlix database tables

4. Series Data Submission

Migrate existing TV show posts to SceneFlix database tables

5. Sync Database

Manually synchronize movie and series databases

6. Search Empty ID

Find posts with missing TMDB or IMDB identifiers

Database Tables Structure

Core Tables

SceneFlix uses three main custom database tables:

sceneflix_movies

  • id – Auto-incrementing primary key
  • title – Movie title
  • url – Post permalink
  • tmdb_id – TMDB identifier (unique)
  • imdb_id – IMDB identifier

sceneflix_series

  • id – Auto-incrementing primary key
  • title – TV show title
  • url – Post permalink
  • tmdb_id – TMDB identifier (unique)

sceneflix_status

  • id – Auto-incrementing primary key
  • tmdb_id – TMDB identifier (unique)
  • post_type – Content type (‘movie’ or ‘tv’)
  • post_status – Processing status (0=not processed, 1=success, 2=failed)

Movie Extractor

The Movie Extractor allows you to extract specific data from your existing movie posts with advanced filtering options.

Features

Post Status Filtering

  • Publish – Published posts
  • Pending – Posts awaiting review
  • Draft – Draft posts
  • Auto-draft – Automatically saved drafts
  • Future – Scheduled posts
  • Private – Private posts
  • Inherit – Posts with inherited status
  • Trash – Deleted posts

Data Extraction Options

  • Title – Movie titles
  • TMDB ID – TMDB identifiers
  • IMDB ID – IMDB identifiers
  • URL – Post permalinks

How to Use Movie Extractor

  1. Select Post Status – Choose which post status to filter by
  2. Choose Data Type – Select what data you want to extract
  3. Click Search – The system will process all matching posts
  4. Review Results – Data appears in a text area for easy copying
  5. Copy Data – Click the textarea to select all extracted data

Batch Processing

The Movie Extractor uses intelligent batch processing:

  • Processes 100 posts per batch
  • Automatically handles pagination
  • Shows loading spinner during processing
  • Combines all results in a single textarea

Series Extractor

The Series Extractor provides similar functionality for TV show posts with series-specific options.

Available Data Types

Title Extraction

  • _tmdb_tv_series_details_original_title – Original series titles

TMDB ID Extraction

  • _tmdb_tv_series_details_tmdb_id – TMDB identifiers

URL Extraction

  • url – Post permalinks

Series-Specific Features

  • TV Post Type – Specifically targets ‘tv’ post type
  • Series Metadata – Extracts series-specific custom fields
  • Batch Processing – Same efficient processing as movies

Movie Data Submission

The Movie Data Submission tool migrates existing movie posts to SceneFlix’s custom database tables.

Purpose

This tool is designed for:

  • Migration Scenarios – Moving from other movie plugins
  • Data Recovery – Rebuilding database tables
  • Manual Synchronization – Ensuring data consistency

Important Notes

  • Automatic Processing – SceneFlix normally handles this automatically
  • Duplicate Prevention – Prevents duplicate entries in database
  • Background Operation – Usually unnecessary for regular users

Migration Process

  1. Scans Published Posts – Finds all published movie posts
  2. Extracts Metadata – Gets title, URL, TMDB ID, IMDB ID
  3. Checks for Duplicates – Prevents duplicate TMDB IDs
  4. Inserts Data – Adds new entries to sceneflix_movies table
  5. Provides Feedback – Shows completion status

Series Data Submission

Similar to Movie Data Submission but for TV show content.

TV Show Migration Features

  • TV Post Type Processing – Specifically handles ‘tv’ posts
  • Series Metadata – Extracts series-specific information
  • Duplicate Prevention – Avoids duplicate TMDB IDs
  • Automatic Processing – Handles all published series posts

Data Migration Process

  1. Query TV Posts – Finds all published TV show posts
  2. Extract Information – Gets title, URL, TMDB ID
  3. Validate Data – Ensures required fields are present
  4. Check Duplicates – Prevents duplicate entries
  5. Database Insertion – Adds to sceneflix_series table

Sync Database

The Sync Database tool provides manual synchronization capabilities for maintaining data consistency.

Database Synchronization

Movies Database Sync

  • Updates sceneflix_movies table with latest post data
  • Ensures URLs and titles are current
  • Maintains data integrity

Series Database Sync

  • Updates sceneflix_series table with current information
  • Synchronizes TV show metadata
  • Ensures database consistency

When to Use Sync

  • Manual Synchronization – After bulk post modifications
  • Data Consistency – Ensuring tables match WordPress posts
  • Troubleshooting – Resolving data discrepancies
  • Migration Recovery – After importing content

Sync Process

  1. Select Content Type – Choose movies or series
  2. Click Sync Button – Initiate synchronization process
  3. Monitor Progress – Loading spinner shows operation status
  4. Review Results – Success/error messages confirm completion

Search Empty ID

The Search Empty ID tool helps identify posts with missing TMDB or IMDB identifiers.

Identification Features

  • Post Status Filtering – Search across all post statuses
  • ID Type Selection – Choose TMDB ID or IMDB ID
  • Direct Edit Links – Quick access to edit problematic posts
  • Comprehensive Results – Shows title and available ID information

Search Process

  1. Select Post Status – Choose which posts to examine
  2. Choose ID Type – Select TMDB ID or IMDB ID
  3. Run Search – System scans for empty fields
  4. Review Results – Numbered list with edit links
  5. Edit Posts – Click links to fix missing data

Results Display

  • Organized List – Numbered list of problematic posts
  • Edit Links – Direct links to WordPress post editor
  • Context Information – Shows available ID when one is missing
  • Batch Processing – Handles large datasets efficiently

Advanced Features

Batch Processing

  • Efficient Handling – Processes 100 posts per batch
  • Pagination Support – Automatically handles multiple pages
  • Memory Management – Prevents timeout issues
  • Progress Indication – Loading spinners show operation status

Data Validation

  • Duplicate Prevention – Avoids duplicate database entries
  • Data Integrity – Ensures required fields are present
  • Error Handling – Graceful handling of problematic data
  • Sanitization – Proper data sanitization and validation

User Experience

  • Loading Indicators – Clear progress feedback
  • Success Messages – Confirmation of completed operations
  • Error Messages – Clear error reporting
  • Intuitive Interface – User-friendly admin panels

Best Practices

When to Use Data Handler

  • Initial Setup – After installing SceneFlix on existing sites
  • Migration Projects – Moving from other movie/TV plugins
  • Data Cleanup – Identifying and fixing data issues
  • Troubleshooting – Resolving database inconsistencies

Maintenance Workflow

  • Regular Monitoring – Periodically check for empty IDs
  • Data Validation – Ensure all posts have required metadata
  • Sync Operations – Synchronize after bulk modifications
  • Backup First – Always backup before major operations

Performance Considerations

  • Batch Processing – Tools handle large datasets efficiently
  • Server Resources – Monitor server load during operations
  • Timing – Run intensive operations during low-traffic periods
  • Incremental Processing – Tools process data incrementally

Troubleshooting

Common Issues

  • Missing Data – Use Search Empty ID to identify problems
  • Sync Failures – Check for post types and metadata issues
  • Duplicate Entries – Tools prevent but may need manual cleanup
  • Permission Errors – Ensure proper admin permissions

Solutions

  • Database Issues – Use Sync Database to resolve consistency problems
  • Missing IDs – Use Search Empty ID to identify and fix
  • Migration Problems – Data Submission tools help with transitions
  • Performance Issues – Batch processing handles large datasets

Maintenance Tasks

  • Regular Scans – Use Search Empty ID monthly
  • Sync Operations – Synchronize after major changes
  • Data Validation – Ensure metadata completeness
  • Backup Procedures – Regular database backups

Integration with Other Features

Auto Post Compatibility

  • Status Tracking – Data Handler respects auto-post status
  • Database Consistency – Maintains sync with auto-posted content
  • Duplicate Prevention – Prevents conflicts with auto-posting

Manual Post Integration

  • Seamless Operation – Works with manually created posts
  • Data Extraction – Extracts data from all post sources
  • Migration Support – Handles mixed content creation methods

Data Export and Analysis

Export Capabilities

  • Bulk Data Export – Extract large datasets efficiently
  • Flexible Formats – Text-based output for easy processing
  • Selective Export – Choose specific data types
  • Status-Based Export – Filter by post status

Analysis Features

  • Data Completeness – Identify missing information
  • Content Audit – Review all entertainment content
  • Migration Planning – Understand existing data structure
  • Quality Control – Ensure data standards compliance

Conclusion

The SceneFlix Data Handler provides comprehensive database management capabilities for entertainment websites. Its tools enable efficient data extraction, migration, synchronization, and maintenance, ensuring your movie and TV show content remains organized and accessible.

Whether you’re migrating from another system, maintaining data integrity, or analyzing your content database, the Data Handler provides the tools needed for professional content management. Its batch processing capabilities, duplicate prevention, and user-friendly interface make it suitable for websites of all sizes.

Regular use of these tools helps maintain optimal database performance and ensures your entertainment content remains properly organized and accessible to both the SceneFlix WordPress theme and any future integrations.

Was this page helpful?
Yes No