JoomHelpDesk - Import, Export & Backup Guide

JoomHelpDesk provides tools for importing data from other helpdesk systems, exporting report data to CSV, backing up and restoring your helpdesk database, and running maintenance tasks. This guide covers each of these features so you can move data in and out of JoomHelpDesk with confidence.

---

Table of Contents

1. Overview
2. Importing Data
3. Exporting Reports to CSV
4. Backup & Restore
5. Maintenance Tools
6. Tips & Best Practices

---

1. Overview

JoomHelpDesk offers four data management capabilities:

Feature	Location	Purpose
Import	Administrator > Components > JoomHelpDesk > Import	Migrate data from another helpdesk system into JoomHelpDesk
CSV Export	Frontend > Admin Panel > Reports	Export any report as a CSV file for use in spreadsheets or external tools
Backup	Administrator > Components > JoomHelpDesk > Backup	Download a full backup of all JoomHelpDesk database tables
Restore	Administrator > Components > JoomHelpDesk > Backup	Upload a previously downloaded backup file to restore data
Maintenance	Administrator > Components > JoomHelpDesk > Maintenance	Repair asset records and permissions

---

2. Importing Data

Where to Find It

Go to Administrator > Components > JoomHelpDesk > Import.

Supported Import Sources

JoomHelpDesk can import data from the following helpdesk system:

• Huru Help Desk -- Migrates tickets, users, and related data from an existing Huru Help Desk installation into JoomHelpDesk.

How to Import

1. Navigate to Components > JoomHelpDesk > Import in the Joomla administrator panel
2. You will see a list of available import sources
3. Click the button for your source system (e.g., "Huru Help Desk")
4. The import process runs automatically and migrates data into the JoomHelpDesk tables

Important Warning

Importing data is a destructive operation. Clicking any import button will remove all existing JoomHelpDesk data before importing the new data. This includes all tickets, messages, custom field values, products, departments, statuses, and other helpdesk configuration.

Before importing:

• Make sure you have a backup of your current JoomHelpDesk data (see Backup & Restore)
• Verify that the source system's data is still in the database and accessible
• Plan to run the import during a maintenance window when no one is using the helpdesk

---

3. Exporting Reports to CSV

Where to Find It

Reports and CSV export are accessed from the frontend admin panel, not the Joomla backend. Navigate to the Reports section in your JoomHelpDesk admin support panel.

Available Reports

JoomHelpDesk ships with these built-in reports, each of which can be exported to CSV:

Report	Description
Active Users	Lists users who have submitted tickets in a date range, with ticket counts, message counts, and time taken
Daily Activity	Shows tickets opened, tickets closed, handler messages, user messages, and total messages per day/week/month/year
Daily Tickets	Shows tickets opened and closed per day/week/month/year
Handler Messages	Tracks handler and user message counts over time
Idle Tickets	Lists open tickets that have had no activity for a specified number of days
List Tickets	A detailed ticket listing with title, status, handler, product, department, category, priority, dates, and time tracking
List Tickets (Custom)	Same as List Tickets but includes custom field and per-user field values in the output
Open Tickets	Shows the number of open tickets per handler, including oldest open and oldest last-active dates

How to Export a Report to CSV

1. Go to the Reports section in the frontend admin panel
2. Click View Report on the report you want to run
3. Use the filter controls at the top of the report to set your date range, product, department, handler, user, ticket group, and grouping level (day/week/month/year) as needed
4. Once the report displays the data you want, click the As CSV button in the toolbar area
5. Your browser will download a CSV file named with the report title and current timestamp (e.g., Daily Activity 2026-02-03 14.30.00.csv)

CSV Separator Setting

The CSV file uses a configurable separator character. By default it uses a comma (,), but you can change it to a semicolon (;) for compatibility with European locale spreadsheet applications that treat commas as decimal separators.

System-wide default (applies to all users):

1. Go to Administrator > Components > JoomHelpDesk > Settings > General
2. Find the Reports Separator setting
3. Choose , (comma) or ; (semicolon)
4. Save

Per-user override (each support agent can set their own preference):

1. In the frontend admin panel, go to Settings (the agent's personal settings page)
2. Find the CSV Separator dropdown
3. Choose Default (uses the system setting), , (comma), or ; (semicolon)
4. Save

The per-user setting takes priority over the system default. This means each support agent can export CSVs in the format that works best with their local spreadsheet software without affecting anyone else.

CSV File Details

• The file is encoded in UTF-8 with BOM (byte order mark), which ensures proper character display when opening in Excel, Google Sheets, or LibreOffice Calc
• Date fields are formatted according to each report's column configuration (typically Y-m-d or localized date formats like M j, Y)
• Time tracking values are formatted as hours:minutes (e.g., 2:30 for 2 hours and 30 minutes)
• The first row contains column headers matching the report's field labels

Report Filters

Most reports support the following filters that you should set before exporting:

Filter	Description
Date Range	A from/to date picker. Defaults to the last 90 days for most reports
Product	Filter by a specific product or show all products
Department	Filter by a specific department or show all departments
Handler	Filter by a specific support agent, show all handlers, or show unassigned tickets
User	Filter by a specific customer, show all users, or show unregistered users only
Status	Filter by a specific ticket status, all open tickets, or all tickets
Ticket Group	Filter by a specific ticket group
Grouping	For time-series reports, group data by day, week, month, or year

The exported CSV contains only the data matching your active filters, so set the filters to match exactly what you need before clicking the export button.

Printing Reports

In addition to CSV export, each report offers print output in three formats:

• All Details -- Full report with headers and filters
• No Header -- Report data without the header section
• Table Only -- Just the data table, suitable for pasting into documents

Click the Print dropdown button on the report view to access these options. Each opens in a new browser tab formatted for printing.

Permissions

Reports are permission-controlled. A user must have the Reports permission to access the reports section, and individual reports can be restricted by name. If a user does not have permission to view any reports, they will see a message indicating they do not have access.

---

4. Backup & Restore

Where to Find It

Go to Administrator > Components > JoomHelpDesk > Backup.

What the Backup Includes

The backup captures all JoomHelpDesk database tables. This includes:

• Tickets and messages
• Products, departments, categories, statuses, and priorities
• Custom field definitions and stored values
• Per-user field values
• Knowledge base articles and categories
• FAQ entries and categories
• Announcements and glossary entries
• Email templates and configuration
• Support agent settings and assignments
• Ticket groups and group memberships
• Time tracking data
• Component settings
• All other JoomHelpDesk-specific data

The backup does not include:

• Joomla core user accounts (those are part of Joomla, not JoomHelpDesk)
• Uploaded file attachments on disk (only the database references are included)
• Joomla's own configuration or other component data

How to Create a Backup

1. Navigate to Components > JoomHelpDesk > Backup in the Joomla administrator panel
2. Click the Download Backup Now button
3. A serialized data file will be downloaded to your computer
4. Store this file in a safe location

How to Restore from a Backup

1. Navigate to Components > JoomHelpDesk > Backup in the Joomla administrator panel
2. In the Restore Database section, click the file upload field
3. Select your backup file
4. Click the Restore button
5. The system will process the backup and display a log of the restoration

Important Warnings

• Restoring will overwrite all existing JoomHelpDesk data. Any tickets, settings, or content created since the backup was taken will be lost.
• JoomHelpDesk can restore backups from JoomHelpDesk, JoomHelpDesk Testimonials Lite, and JoomHelpDesk FAQs Lite. This is useful when migrating from a lite product to the full version.
• After a restore, the system displays a detailed log showing what was processed. Review this log to confirm the restore completed successfully.
• Always create a fresh backup before performing a restore, so you can revert if something goes wrong.

---

5. Maintenance Tools

Where to Find It

Go to Administrator > Components > JoomHelpDesk > Maintenance.

Update Assets

The primary maintenance tool is Update Assets, which repairs the Joomla asset table entries for JoomHelpDesk. This tool:

1. Verifies the parent asset -- Checks that the com_joomhelpdesk entry exists in the Joomla #__assets table. If it is missing, the tool creates it automatically.

2. Creates or repairs child assets -- Ensures the following permission-controlled sections have proper asset records:

   • com_joomhelpdesk.faq -- FAQ section
   • com_joomhelpdesk.kb -- Knowledge Base section
   • com_joomhelpdesk.announce -- Announcements section
   • com_joomhelpdesk.glossary -- Glossary section
   • com_joomhelpdesk.support_user -- User support access
   • com_joomhelpdesk.support_admin -- Admin support access
   • com_joomhelpdesk.moderation -- Content moderation
   • com_joomhelpdesk.groups -- Groups management
   • com_joomhelpdesk.reports -- Reports access

3. Fixes parent-child relationships -- If any asset has an incorrect parent ID (which can happen after migrations or database issues), the tool corrects it.

4. Rebuilds the asset tree -- Recalculates the left/right nested set values (lft and rgt) that Joomla uses for efficient permission lookups.

5. Sets default permissions -- Configures baseline access rules:

   • Sets "View Content" to Public Allowed for the component
   • Sets "Can Open Support Ticket" to Public Allowed for the support user section
   • Sets "Can View Own Support Tickets" to Public Allowed for the support user section

When to Run Update Assets

Run this tool when you experience any of the following:

• Permission errors after installing or upgrading JoomHelpDesk
• Users cannot access sections they should have permission to view
• The Joomla permissions panel for JoomHelpDesk shows errors or missing entries
• After migrating JoomHelpDesk to a new server or restoring from a backup
• After a Joomla update that may have affected the asset table

The tool displays a detailed log of every action taken, so you can see exactly what was created, fixed, or left unchanged.

---

6. Tips & Best Practices

Before Any Data Operation

• Always create a backup before importing, restoring, or running maintenance. This gives you a rollback point if anything goes wrong.
• Schedule a maintenance window. Imports and restores affect live data. Notify your support team and consider temporarily disabling the helpdesk frontend.

Backup Strategy

• Back up regularly. Create a backup before any major changes: upgrades, configuration changes, or bulk data modifications.
• Store backups externally. Do not rely solely on copies stored on the same server. Download backups to a local machine or cloud storage.
• Test your backups. Periodically restore a backup on a staging/development site to confirm the backup file is valid and complete.
• Complement with full-site backups. The JoomHelpDesk backup covers only the component's database tables. Use Akeeba Backup or a similar tool for full site backups that include files and the complete database.

CSV Export Tips

• Set your filters before exporting. The CSV includes only the data matching your current filters. A CSV exported with a narrow date range will be much smaller and more focused than one covering all time.
• Use semicolon for European locales. If your spreadsheet application (typically Excel in European regional settings) uses commas as decimal separators, switch the CSV separator to semicolon in your agent settings.
• Open CSV files correctly in Excel. If double-clicking the CSV file shows garbled characters or columns merged together, use Excel's Data > From Text/CSV import wizard instead, and select UTF-8 encoding with the appropriate delimiter.
• Large exports. For very large date ranges or ticket volumes, the CSV export may take a moment. Let it complete before clicking again.

Import Considerations

• One-time operation. The import feature is designed for initial migration from another helpdesk system. It removes all existing data and replaces it with the imported data.
• Verify source data first. Ensure the source helpdesk's database tables are present and contain the data you expect before starting the import.
• Post-import review. After importing, review your tickets, products, departments, and other data to confirm everything migrated correctly. Check a few tickets in detail to verify messages and custom fields came through.

After Running Maintenance

• Clear Joomla's cache. After running Update Assets or any maintenance tool, clear the site cache via System > Clear Cache to ensure the updated permissions take effect immediately.
• Test permissions. After fixing assets, log in as different user types (admin, agent, customer) to verify they can access the sections they should.