iEXExchanger 11.3 Update — PostgreSQL 18, system diagnostics and automation of request processing

iEXExchanger
iEXExchanger 11.3 Update — PostgreSQL 18, system diagnostics and automation of request processing

In version iEXExchanger 11.3, we focused on performance, reliability, and the ease of daily use with the exchanger.

The release includes support for PostgreSQL 18 and tools for data migration from MySQL, a new system diagnostics section, automatic ticket distribution among operators, and updated handling of currencies, networks, reserves, requisites, and notifications.

We have also sped up the exchange form and dashboard, strengthened account, order, and public API security, improved update installations, and fixed bugs that could affect administrators, operators, and clients.

Key release changes

  • PostgreSQL 18. New projects can start working with PostgreSQL 18 immediately. Existing projects have a separate data migration from MySQL with preliminary and final checks.
  • System diagnostics.A new section has appeared in the control panel that checks the main exchanger functions, displays detected issues, and helps identify what needs to be fixed.
  • Distribution of requests among operators. Added recommendation and automatic assignment modes considering availability, permissions, and current workload of employees.
  • Updated application processing.Improved the list of orders, automatic data refresh, chat, identity and account verification, payment details on request, payment terms, and archive.
  • Currencies, networks, and reserves.The currency archive is now combined with the general list, networks have been moved to a separate section, and reserve management along with transaction history has been completely updated.
  • Notifications and shortcodes.Notifications for currencies and directions are combined into one system. Shortcodes have their own section, multilingual support, search, and quick insertion in editors.
  • Security.Enhanced protection of login, sessions, requests, payment actions, files, administrative operations, and public API keys.

PostgreSQL 18 and data migration from MySQL

Support for PostgreSQL 18.iEXExchanger is adapted to work with PostgreSQL 18. The database structure, financial calculations, search, background processes, and large-scale data handling have been updated.

New settings. When setting up a new project, you can immediately use PostgreSQL 18. For servers running Debian with FASTPANEL, an installer is available that checks the environment, installs the necessary components, and provides database connection details.

Transfer from MySQL.A dedicated migration master has been added for existing projects. Before starting, it checks connections and source data, then creates the structure in PostgreSQL, transfers the information, and verifies the result.

Secure switching.iEXExchanger switches to PostgreSQL only after the transfer and all verifications are successfully completed. The original MySQL database is preserved and remains unchanged.

Backup and Recovery.Separate profiles can be created for primary and additional databases. The system checks the connection and file integrity, logs operations, and prevents data restoration to the wrong database.

Database audit.A separate tool has been added to check the PostgreSQL server, databases, tables, relations, indexes, sequences, statistics, and data completeness. The audit does not alter the database content.

Switching to PostgreSQL does not start automatically when installing version 11.3. Active projects can continue working with MySQL and perform the migration separately.

System Diagnostics

Comprehensive verification of the exchanger.A new section has appeared in the control panel where the administrator can manually start a diagnostic and detect issues before they affect clients.

The system checks:

  • exchange directions, rates, and their relevance;
  • export of rates and integration with BestChange;
  • calculator calculations, fees, and limits;
  • reserves and their change history;
  • user balances;
  • merchants for receiving and paying out funds;
  • processing applications;
  • security settings;
  • user agreements;
  • affiliate program and reward calculation rules.

Progress update.The diagnosis shows overall progress, the current step, and a detailed event log.

Issue report.After completion, a report is generated detailing problematic currencies, directions, wallets, and settings. Each note includes a description and a recommendation for correction.

Launch history.The results are saved in the dashboard. After resolving the issues, you can rerun the diagnostics and check the system status.

Distribution of requests among operators

Version 11.3 introduces a request allocation system among employees. By default, it is disabled and does not change the usual exchange workflow.

"Recommendation" Mode.The system assigns the request to a suitable operator, but it remains accessible to other staff members.

Automatic mode. The request is temporarily assigned to the selected operator. They can accept or reject it. If rejected or the waiting time expires, the system forwards the request to the next suitable staff member.

Load monitoring.When selecting an operator, their readiness to accept requests, access rights, restrictions, current workload, and pending offers are taken into account.

Individual capacity.Each operator can specify how many requests they are ready to handle simultaneously.

Pause and unavailability.If an employee becomes unavailable, unaccepted offers are released and returned to distribution.

Personal queue.The operator sees their availability, current workload, new offers, and team status. Assignment and decision history is saved for monitoring.

Manual assignment of requests and current employee permissions continue to function unchanged.

Applications and Operator Activity

Quick list of orders.The loading speed of lists, tabs, and counters has been improved even with large volumes of data. Performance has been enhanced for simultaneous processing of requests by multiple employees.

Automatic update.Status changes, counters, and assigned operators update automatically without manually refreshing the page. The system resumes updates after a temporary connection loss or when returning to the tab.

Initial tab.When opening the list, the first tab in the order set by the administrator is selected automatically. The settings now show which tab is used by default.

Identity and account verification.The tags "Identity Verification" and "Account Verification" are displayed separately from the main status and may appear simultaneously. From the application, you can view the owner's details, account number, photo, and verification history, then approve or reject the verification with a specified reason.

Additional photos of the card.If necessary, the administrator can allow the client to attach multiple photos along with the main one for verification. The system controls the number, format, size, and content of the files, and the operator sees all the images in a shared gallery.

Online chat in the application.Improved message loading and updating, assignment of responsible persons, priorities, statuses, internal notes, and read receipts. Resolved duplicates, freezes, and outdated conversation display. A separate dialogue list with current counters has been prepared for operators.

Order archive.The archive now features an adaptive list, record selection, and bulk restoration. On smaller screens, requests are displayed as cards.

Payment details on request and payment deadlines

Unified field system.Additional and informational details fields are combined into a single section. Previously created data is preserved.

Automatic values.You can insert Memo, recipient’s name from the merchant, bank name, internal application number, and public application number into the fields. If necessary, the operator can manually enter their own value.

Separate deadlines.The waiting time for details and the payment deadline are configured separately. You can set a general value or allow the operator to choose the time for a specific request.

Payment period starts.The timer can be started immediately after creating the request or only after the payment details are actually issued.

Time expired.If the waiting period for credentials expires, the request can automatically change to the "Time Expired" status. For a completed payment period, you can configure either a status change or keep the current status.

Operator's work.The remaining time is displayed in the request. The operator can provide details, add comments and additional fields, and replace previously submitted data within the allowed period.

Protection against repeated actions.The system prevents simultaneous duplicate issuance of details and does not allow the client to mark an expired request as paid.

Currencies, Networks, and Reserves

Unified list of currencies.The separate "Currency Archive" section has been removed. Active, disabled, and archived currencies are now listed together and can be filtered.

Mass actions.Currencies can be enabled, disabled, archived, and restored simultaneously. After restoration, the currency remains disabled so the administrator can review its settings before publishing.

Related directions.When a currency's status changes, the system properly updates the related directions. Archived currencies no longer appear in sections where they cannot be used.

Currency Networks.A dedicated section for networks has been added, featuring search, filters, and mobile-friendly design. You can create, edit, and delete networks, as well as select currencies, labels, and icons for them.

Transferring currencies between networks.The transfer window has been updated, with improved display of long names and added protection against conflicts during simultaneous editing.

Currency reserves.The section received a new responsive table, bulk locking, unlocking, and selective record deletion.

Reserve History.The history clearly shows the type of operation, direction, reason for change, and amounts before and after the operation. The section is optimized for a large number of records.

Change protection.If multiple administrators edit the same reserve simultaneously, the system prevents overwriting of the most up-to-date data.

Exchange directions, rates, and BestChange

Direction settings.Removed unnecessary and outdated fields from the form. Fixed the display of the direction status and saving the selected identity verification scenario.

Rates from formulas and files.Bulk record selection has been added. Selected rates can be enabled, disabled, deleted, and configured for decimal places all at once.

BestChange API.Improved adding multiple destinations at once. Long names and a large number of selected values are now correctly displayed in windows and lists.

Performance.Removed unnecessary checks and repeated database queries when loading rates.

Customer Notifications

Unified section.Notifications for currencies and directions are combined into a single system.

Where to display the notification.The message can be placed in the exchange form or on the payment page of the request.

Display format.Built-in notifications and pop-up windows are supported.

Publication terms.You can configure importance, duration, priority, separate colors for light and dark themes, and one-time display during the session.

Linking.A notification can be linked to a currency or direction and the exchange side can be selected — “Giving” or “Receiving”.

E-mail and Telegram

Reliable delivery.Duplicate sending of a single event has been fixed. If one channel is temporarily unavailable, other notifications continue to be sent.

Recipient's language.Improved language selection for messages for clients, operators, and administrators.

Templates Telegram.A dedicated editor with preview, drafts, publishing, and change history has been added for them.

Template History.You can view and restore the previous version of the template.

Verification codes.Fixed issue with sending incorrect code000000. A unique six-digit code is generated with every confirmation, including when resent.

Request emails.Empty details and unfilled additional fields no longer create empty blocks in exchange creation and completion emails.

Shortcodes

Unified section.Shortcodes are divided into the "General" and "For Objects" tabs.

Linking to objects.The shortcode can be used in all supported templates or linked to a specific request, user, or exchange direction.

Types of values.Plain text, formatted text, and numbers are supported. The value can be entered manually or retrieved from the selected object's data.

Multilingual Support.The name, description, and value are customized separately for each language. Old single-language shortcodes will continue to work.

Insertion into editors.The "My Shortcodes" button lets you find the needed value, see an example, and insert the code at the current cursor position.

Management.Added preview, copy, enable, disable, edit, and secure delete features.

Affiliate Program and Payments

Individual percentage in the application.The operator can keep the standard affiliate program percentage or specify a separate value for a specific request.

Preliminary calculation.Before saving, the system displays the expected bonus and the data used to calculate it. To make changes, you must provide a reason, and the action is recorded in the history.

Bonus payout requests.The section features a new responsive interface, summary metrics, date grouping, payout cards, and a change log.

Processing payouts.You can confirm or reject the payout directly in the card. If declined, a reason must be provided.

Images and Media Library

Media Manager.A unified tool has been added for uploading, selecting, moving, and reusing images and other files.

Image processing.Updated file upload for identity verification, card photos, logos, banners, news, details, and other sections.

Secure exchange.The old file is replaced only after the new one is saved successfully. Existing public links to images will continue to work.

Admin Panel

Filter by operators.The selection of employees has been moved to the general filter system. You can select one or multiple operators and use the condition across all sections of the request list.

Global Search.Fixed quick commands, duplicate results, and an error on empty queries.

Navigation menu.Fixed an issue where hidden menu items would expand when navigating between sections.

Security

Password requirements.The same rules apply for registration, password recovery, and password change. The password must be at least 12 characters long and include uppercase and lowercase letters, numbers, and special characters.

Protection against guessing.The system responses no longer reveal whether the specified e-mail is registered. The possibility of blocking the administrator through excessive external login attempts has also been eliminated.

CAPTCHA.Verification is performed before authorization and blocks access if it is missing or incorrect.

Client and administrative sessions.Improved monitoring of IP address, device, and address group changes. After successful authorization, the session is securely refreshed.

Employee rights.Access to orders, analytics, files, pages, news, promo codes, bonuses, notifications, and system settings has been revised.

Critical operations.For the most critical actions, an additional confirmation by another administrator can be required.

Public links to requests.An outsider who receives the link will not be able to confirm payment, cancel the exchange, send a message, upload a document, verify payment details, or create a payment transaction. These actions are available only to the verified owner of the request.

Public API keys.Separate permissions, expiration dates, IP address and request frequency restrictions, daily and monthly usage monitoring, as well as secure key revocation and replacement have been added.

Payment redirects.The system checks redirect URLs to payment system websites. Fake, untrusted, and incorrect links are blocked.

Repeat transactions.Repeated notifications from the payment system no longer trigger duplicate processing of the same transaction.

Trusted sources.Browser requests, real-time connections, and visit statistics are accepted only from authorized sources, considering proxy servers, load balancers, and CDNs.

Confidential pages.Third-party analytics and action logging are disabled on login, recovery, confirmation, application, and payment pages.

Other fixes

Review publication.The switch state now matches the actual status of the feature on the site.

Additional fields.The "Remove spaces" setting defaults to "No." The selected content type is no longer reset and now correctly restricts allowed values.

Control panel address.The case of characters is preserved in the address. Service and prohibited values are still blocked.

Payment details.Improved validation of required fields and account number.

Calculation Accuracy.Enhanced storage of amounts and improved processing of fees, limits, profits, and partner commissions.

Parallel operations.Protection against repeated actions, conflicts during automatic payouts, and simultaneous data changes has been enhanced.

Version iEXExchanger 11.3 also includes additional internal optimizations, updated translations, and automated checks designed to enhance the platform's performance, security, and stability.