Voicemail log export β Localization
When you export voicemail logs from SmartBot, the downloaded file reflects your locale: column headers, status values, and date and time formats all render in the language and regional format configured for your user account. This article explains what changes with locale, how sheet naming works in XLSX exports, and how to export a localized voicemail log file.
Audience: Center managers and organization administrators who review voicemail activity and share exported reports with multilingual teams.
Before you begin
- You must have access to the callLogs panel in the SmartBot admin console.
- Your user account must have a locale configured. Column headers, status values, and date and time formats in the export reflect the locale of the account that initiates the export.
- Voice channel (IVR with missed-call handling) must be enabled for at least one center in your organization before call log data is available to export.
Note: Channel enablement is a center-level setting. If no center has the voice channel enabled, the call logs panel will contain no records to export.
Steps
Export a localized voicemail log
- Open the SmartBot admin console.
- In the left navigation, select callLogs.
- Apply any date range or center filters to narrow the records you want to export.
- Select the export option and choose either CSV or XLSX format.
- Save the file to your computer.
The downloaded file contains column headers and status values rendered in your user locale. Date, time, and duration values are formatted using locale-aware regional conventions rather than fixed English formats.
Understand what changes by locale
The following elements in the exported file are locale-aware:
| Export element | What changes |
|---|---|
| Column headers | Rendered in your user locale |
| Status values (for example, a completed voicemail) | Rendered in your user locale |
| Date values | Formatted using your locale's regional date convention |
| Time values | Formatted using your locale's regional time convention |
| Call duration values | Formatted using your locale's regional duration convention |
The following columns are present in every export, with headers rendered in your locale:
| Column (English reference) | Contents |
|---|---|
| Guest name | Name of the guest who left the voicemail |
| Phone number | Phone number associated with the call |
| Date | Date the voicemail was received, in your locale's date format |
| Time | Time the voicemail was received, in your locale's time format |
| Voicemail | Voicemail indicator or status |
| Call duration | Length of the call, in your locale's duration format |
| Transcript | Transcribed text of the voicemail |
Note: The column names in the file header row will differ from the English reference names above when your user locale is set to a non-English language. Use this table as a reference to identify each column in a localized export.
Understand XLSX sheet naming
When you export in XLSX format, the sheet tab inside the file takes its name from a locale-specific label. To comply with Excel's sheet-name limit, this label is automatically truncated to a maximum of 31 characters. If your locale produces a label shorter than 31 characters, no truncation occurs.
Note: The 31-character maximum is an Excel requirement that applies regardless of locale or language. Very long translated labels are truncated at the 31st character.
Worked example
Example: A center manager whose user account is configured for French (France) exports the voicemail log as XLSX for the past 30 days. When they open the file:
- The sheet tab reads the French-language label for "voicemail" (truncated to 31 characters if the label exceeds that limit).
- Column headers such as guest name, phone number, date, time, and call duration all appear in French.
- Status values appear in French.
- Dates appear in the DD/MM/YYYY convention standard for the France locale rather than the English MM/DD/YYYY format.
- Times appear in 24-hour format as is standard for that locale.
A colleague in the same organization whose account is configured for English (United States) exports the same date range and receives a file with English headers, English status values, and MM/DD/YYYY date formatting.
Tips
- If you share exports with colleagues who use different locales, include a cover note or use the English reference column names in this article to help them identify each column.
- If the sheet tab in an XLSX export appears cut off, this is expected behavior when your locale's label exceeds 31 characters. The data in the sheet is not affected.
- To ensure the export reflects the correct locale, verify your user account's locale setting before exporting. Exports are locale-matched to the account that initiates the download, not to the center being reported on.
- For large exports covering many centers or long date ranges, apply center and date range filters in the callLogs panel before exporting to keep file sizes manageable.
Troubleshooting
Column headers appear in English even though my account uses a different locale
Verify that your user account locale is fully saved and active. If you recently changed your locale, log out and log back in to the SmartBot admin console, then export again.
The XLSX sheet tab is cut off
This is expected when your locale's sheet-name label exceeds 31 characters. Excel enforces this limit. The data in the sheet is complete β only the tab label is truncated.
Date or time values do not match the format I expected for my locale
Confirm that your user account locale is set to the correct region, not the language. For example, English (United Kingdom) and English (United States) use different date conventions. Update your locale setting and export again.
The call logs panel shows no records to export
Voice channel enablement is configured per center. If no centers in your organization have the voice channel enabled, no call log records are generated. Contact your organization administrator to confirm which centers have voice enabled.