Troubleshooting Guide

Having trouble with DB Table? This guide covers the most common issues and their solutions. Most problems can be resolved quickly with these troubleshooting steps.

Upload Issues

File Upload Problems

"Please upload an Excel (.xlsx, .xls) or CSV file"

• Cause: Unsupported file format
• Solutions:
  • Check file extension - only .xlsx, .xls, and .csv are supported
  • Convert your file to a supported format
  • Ensure file isn't corrupted

"File size exceeds maximum limit"

• Cause: File is larger than 4MB
• Solutions:
  • Reduce file size by removing unnecessary data
  • Split large files into smaller chunks
  • Use CSV format instead of Excel (more efficient)
  • Remove images, charts, or complex formatting

"Failed to parse Excel file"

• Cause: File is corrupted, password-protected, or has unsupported features
• Solutions:
  • Remove password protection from the file
  • Try opening and re-saving the file in Excel
  • Export to CSV format and try uploading that
  • Check if file opens correctly in Excel

"Upload seems stuck or taking too long"

• Cause: Large file, slow connection, or browser issues
• Solutions:
  • Wait longer - files up to 4MB can take 10+ seconds
  • Check your internet connection
  • Try refreshing the page and uploading again
  • Close other browser tabs to free up memory

Data Display Issues

Column Type Problems

"Dates showing as numbers or text"

• Cause: Automatic type detection didn't recognize date format
• Solutions:
  • Use the AI Data Profiler for better detection
  • Manually change column type to "date"
  • Ensure dates in your file use consistent formatting
  • Check if dates are in a recognizable format (MM/DD/YYYY, etc.)

"Numbers showing as text"

• Cause: Numbers contain non-numeric characters or inconsistent formatting
• Solutions:
  • Remove currency symbols, commas, or spaces from numbers
  • Use AI profiler to suggest correct type
  • Manually override column type to "number"
  • Check for hidden characters in your data

"Currency not formatting correctly"

• Cause: Mixed currency symbols or inconsistent formatting
• Solutions:
  • Ensure all values in column use same currency symbol
  • Remove extra spaces around currency values
  • Use AI profiler for better detection
  • Manually set column type to "currency"

Table Display Issues

"Table not loading or showing blank"

• Cause: File still processing or browser compatibility issue
• Solutions:
  • Wait for processing to complete (check for loading indicators)
  • Refresh the page and try again
  • Try a different browser (Chrome recommended)
  • Check browser console for error messages

"Some columns are missing"

• Cause: Columns may be hidden or file parsing issue
• Solutions:
  • Check "Columns" dropdown to show hidden columns
  • Verify all columns exist in original file
  • Try re-uploading the file
  • Check if columns have headers in original file

"Data looks different from original file"

• Cause: Type detection applied formatting or encoding issues
• Solutions:
  • Toggle "Show Formatted" switch to see raw data
  • Check if original file has special formatting
  • Use AI profiler to improve type detection
  • Verify file encoding (should be UTF-8 for CSV)

Performance Issues

Slow Loading or Response

"Application is running slowly"

• Cause: Large file, limited browser memory, or too many browser tabs
• Solutions:
  • Close other browser tabs and applications
  • Use pagination instead of viewing all data at once
  • Hide unused columns to improve performance
  • Try using a different browser
  • Restart your browser

"Browser freezing or crashing"

• Cause: File too large for available memory
• Solutions:
  • Use smaller files (under 4MB recommended)
  • Close other applications to free memory
  • Try using Chrome for better performance
  • Split large files into smaller chunks

"Editing is slow or unresponsive"

• Cause: Large dataset or complex data types
• Solutions:
  • Filter data to show fewer rows
  • Disable editing when not needed
  • Save changes frequently
  • Use pagination to work with smaller data chunks

Editing Problems

Edit Mode Issues

"Can't edit cells"

• Cause: Edit mode not enabled or cell type restrictions
• Solutions:
  • Click "Enable Editing" button in toolbar
  • Check if you're trying to edit a read-only column
  • Ensure file upload completed successfully
  • Try refreshing the page

"Changes not saving"

• Cause: Validation errors or edit mode issues
• Solutions:
  • Check for red borders indicating validation errors
  • Fix any data type mismatches
  • Click "Save Changes" button when done editing
  • Ensure you're in edit mode

"Validation errors when editing"

• Cause: Data doesn't match expected column type
• Solutions:
  • Check column type indicator and enter appropriate data
  • For dates: use MM/DD/YYYY or similar format
  • For numbers: remove letters and special characters
  • For booleans: use Yes/No, True/False, or 1/0

AI Profiler Issues

AI Analysis Problems

"AI profiler not working"

• Cause: No internet connection or service temporarily unavailable
• Solutions:
  • Check your internet connection
  • Try again in a few minutes
  • Use manual column type overrides instead
  • Continue without AI analysis

"AI suggestions seem wrong"

• Cause: Complex or unusual data patterns
• Solutions:
  • Review suggestions before applying
  • Apply only relevant suggestions
  • Use manual type overrides for specific columns
  • AI works best with clean, consistent data

Export Issues

Download Problems

"Export button not working"

• Cause: File still processing or browser restrictions
• Solutions:
  • Wait for file processing to complete
  • Check if browser is blocking downloads
  • Try right-clicking export button and "Save link as"
  • Ensure you have write permissions to download folder

"Downloaded file is empty or corrupted"

• Cause: Export process interrupted or browser issue
• Solutions:
  • Try exporting again
  • Clear browser cache and cookies
  • Check if filters are hiding all data
  • Try using a different browser

Browser Compatibility

Supported Browsers

Recommended Browsers:

• Chrome (latest version) - Best performance
• Firefox (latest version) - Good compatibility
• Safari (latest version) - Works well on macOS
• Edge (latest version) - Good performance on Windows

Browser Requirements:

• JavaScript must be enabled
• Cookies must be allowed
• Local storage must be available
• Modern browser (released within last 2 years)

Browser-Specific Issues

Chrome Issues:

• Clear cache: Settings > Privacy > Clear browsing data
• Disable extensions that might interfere
• Check if hardware acceleration is enabled

Firefox Issues:

• Clear cache: Settings > Privacy & Security > Clear Data
• Disable strict tracking protection for the site
• Check if JavaScript is enabled

Safari Issues:

• Clear cache: Safari > Clear History
• Check Privacy settings aren't blocking functionality
• Ensure JavaScript is enabled

Getting Additional Help

Before Contacting Support

1. Try these basic steps:

   • Refresh the page
   • Clear browser cache
   • Try a different browser
   • Check internet connection

2. Gather information:

   • What browser and version you're using
   • File type and approximate size
   • Exact error message (if any)
   • Steps that led to the problem

3. Check this guide:

   • Review relevant sections above
   • Try suggested solutions
   • Note which solutions you've attempted

Self-Help Resources

• Documentation: Review other sections of this guide
• Browser Console: Check for error messages (F12 key)
• File Validation: Try opening your file in Excel or text editor
• Alternative Formats: Convert to CSV if having Excel issues

Common Quick Fixes

90% of issues can be resolved by:

1. Refreshing the page and trying again
2. Using Chrome browser for best compatibility
3. Reducing file size to under 4MB
4. Converting to CSV format for simpler files
5. Clearing browser cache and cookies

---

Still having trouble? Most issues are resolved by trying a different browser or reducing file size. For persistent problems, check the browser console (F12) for specific error messages that can help identify the issue.