Аккаунт в General iT
Войдите или создайте аккаунт для управления услугами в панели.
MODULE FOR 1C-BITRIX
esolutions.su
The module is designed for exporting and importing data to Excel formats. It allows creating pages with entity lists where the set of columns can be configured arbitrarily.
The module is designed for exporting and importing data to Excel formats. It allows creating pages with entity lists where the set of columns can be configured arbitrarily.
Currently, the following entities are supported for export and import:
- Users
- Orders
- User cart data
- Email templates
- Infoblock properties
- List-type property values
- Product discount coupons
- Cart rule coupons
- Warehouse accounting documents and their contents
- Infoblock property bindings to sections
- Order payments
- Shipments
- Warehouses
- Locations
- Cart rules
- Products (only fields from the Trade Catalog module)
- CRM deals
Additionally, any database table can be added to the list of entities available for export and import.
Export capabilities include:
- Export profiles with all settings saved
- Support for XLS, XLSX, and CSV formats
- Export of any fields from the database table of the selected entity
- Export of related entities (for example, user or order data when exporting a cart)
- Filtering of exported records by any field
- Sorting by most available fields
The module provides flexible data transformation capabilities for exporting composite fields. It supports exporting multiple sheets from a single file. Exported files can be automatically uploaded to an FTP server, Bitrix24, or Google Sheets.
Import features include import profiles that save all settings. Supported file formats are xls, xlsx, and csv. Fields are imported only from the field table of the selected entity; importing related entities is not supported. The module offers modes for creating, updating, and deleting records, with creation and update modes enabled by default. Users can select one or more fields to search for existing records to update them. The system supports importing composite fields from multiple columns, selecting specific rows for import, and processing multiple sheets within a single file.
For working with information blocks and high-load blocks, another solution is recommended.
General iT can handle the implementation of “Multi-functional Excel export/import”, from installation to configuration and compatibility checks.
UPDATE HISTORY
1) Transformation functionality has been improved.
2) User access rights separation has been improved.
The initial access level to the module has been changed.
1) A jQuery connection error has been fixed when overriding standard JS libraries in Bitrix.
2) Site encoding detection has been improved when errors occur in configuration files.
1) A jQuery connection error has been fixed.
2) Cron settings have been improved.
3) Errors in changing export profile parameters have been fixed.
Reading of xlsx files has been improved.
1) Cron settings have been improved.
2) Module operation errors on PHP 8.4 have been fixed.
3) RAM usage during export and import of large files has been optimized.
1) Cron settings have been improved.
2) The ability to load VAT rates when importing orders with a cart in a single file has been added.
1) Module security improvements have been made.
2) The ability to import cart rules along with their binding to user groups in a single file has been added.
Fixed an error when saving the property version during import of new properties when infoblock properties are stored in a separate table.
Enhanced import of orders and payments.
Fixed errors in module operation on the latest Bitrix core.
1) Fixed display errors of nested conditions in filter settings during export.
2) Added buttons for quick removal of fields in import settings.
3) Enhanced the ability to export images to Google Sheets.
4) Enhanced error display during PHP transformations.
5) Fixed errors in module operation that occurred in recent versions of the Bitrix core.
1) Added a new filter version on export pages.
2) Fixed an error exporting a file with multiple sheets.
1) Added the ability to delete a row from an export file using transformations.
2) Enhanced the transformation functionality.
3) Enhanced file transfer to Google Sheets.
4) Added a page for working with customer invoices.
1) Fixed an error when exporting user additional fields of type "link to highload block element".
2) Enhanced import of deals and leads.
3) Fixed import errors for additional user fields of type "list".
1) Fixed errors in the cron settings window.
2) Improved error output for exports and imports.
3) Enhanced export/import of delivery services.
1) Added display of created tasks in cron settings.
2) Implemented the ability to send the export file to an email address.
3) Added instructions for activating the module when working in demo mode.
4) Improved conversion of database table encoding to the required format during module installation.
1) Added support for working with multiple company fields in CRM.
2) Resolved all issues with the bitrix.xscan module.
3) Added the ability to filter using complex logic on the record list page.
4) Enhanced file upload from FTP servers.
5) Improved data transfer to Google Drive.
6) Fixed date display errors in filter settings during export.
1) Added the ability to export and import custom fields for leads, contacts, and companies from CRM.
2) Fixed the display of the horizontal scroll bar on step 2.
3) Added the ability to import custom fields for deals from CRM.
4) Fixed export errors when using older versions of the Bitrix core.
1) Added the ability to work with leads, contacts, and companies from CRM.
2) Added options for creating shipments and payments when creating an order.
3) Implemented support for order numbering settings when creating a new order.
4) Added the ability to search for products by properties when importing a cart into orders.
5) Improved search for elements of related entities by arbitrary fields during import.
Fixed an error reading xlsx files when the XMLReader extension is missing.
Fixed an error importing order properties on the new Bitrix core.
1) Improved export of multiple fields when grouping data by records of the main table.
2) Added the ability to send email notifications when creating orders and users.
3) Optimized reading of xlsx files.
4) Fixed an error reading xlsx on PHP 8.2.
1) Fixed an error loading user photos by link.
2) Added the ability to search for a related entity during import by fields from multiple tables at once in cases where the entity is linked to multiple tables.
1) Added the ability to use an xlsx file template for export.
2) Fixed an error when working with the products table in the latest version of the Bitrix core.
3) Fixed an error with the "Merge cells with main table fields" checkbox.
1) Added the ability to export/import the "Display in smart filter" field when working with infoblock properties.
2) Fixed an error in exporting locations.
1) Added the ability to specify a buyer profile when importing orders for automatic property substitution.
2) Added the "Estimated delivery cost" field when exporting shipments.
3) Added the "Number of elements with a value set for this property" field when exporting infoblock properties.
4) Improved export of values from related tables.
1) Added the ability to load buyer profiles with their properties using a single import profile.
2) Added the ability to export/import the "Show on element edit page" field for infoblock properties.
1) Enhanced export of infoblock element properties when properties are stored in a separate infoblock table.
2) Added the ability to export the location name for the Location property type when exporting orders.
3) Implemented the ability to filter orders by location name.
4) Enhanced import of links between tables via an arbitrary property of the related table.
1) Added the ability to export the Product Group from the trading catalog fields.
2) Enhanced import of orders together with products.
3) Enhanced the transformation functionality in export settings.
4) Fixed the initial set of fields during export to minimize the load.
1) When exporting products, a field "Total quantity in orders" has been added with the ability to specify the age of orders to be considered in this field.
2) In user export settings, the ability to export user order information has been added.
3) Implemented more convenient filtering by order statuses.
1) Added the ability to use the "User Registration Date" field when exporting entities linked to users.
2) Implemented conversion of the user registration date to the required format during user import.
3) Enhanced the use of fields from related entities in transformations during data export.
1) Fixed an error saving access rights to the module.
2) Fixed an error exporting related companies and contacts for deals in CRM.
3) Fixed errors exporting data to Google Sheets.
1) Added the ability to insert images into the exported file in xlsx format.
2) Fixed an error exporting orders.
1) Added the ability to export deals from CRM.
2) Implemented functionality for export/import to any database tables.
3) Added a checkbox to merge cells with fields from the main table.
4) Added the ability to disable unnecessary menu items.
5) Enhanced error output during the import process.
6) Fixed a number of errors under PHP 8.
7) Fixed errors reading files with merged cells.
1) Added the ability to export export files to Google Sheets.
2) Added the ability to export the date and time of the order translation to any specified status from the order change history.
3) Enhanced order property export.
4) Fixed errors in the date filter operation when running export via cron.
1) Added the ability to export export files to Bitrix24.
2) Added the ability to import links between entities by any field from the related table.
3) Implemented handling of the "Require password change on next login" field in the user list table.
4) Enhanced export of infoblock properties of type "Link to elements".
5) Added the ability to use infoblock element fields when exporting carts.
6) Added the ability to import carts and orders from a single file.
7) Implemented recalculation of the paid order amount when importing the payment status.
1) Enhanced cron settings.
2) Fixed display of infoblock element properties for the trading catalog table.
1) Added the ability to export/import delivery services.
2) Added the ability to work with meta tags of the concept.phoenix module.
3) Fixed a jQuery connection error.
4) Fixed an error deleting fields from the filter.
5) When exporting products, added the ability to export prices from the related table.
6) When exporting the cart, added the ability to export item properties from the related table.
7) For orders, added the ability to export the delivery service and payment method, and fixed an error updating the order status during import.
8) Improved the update of warehouse document statuses using import tools.
1) Fixed an error calculating the sum of purchase prices when exporting orders.
2) Improved the loading of the "Phone number for registration" field.
1) Added the ability to export/import buyer profiles.
2) Improved cron settings.
3) Added access right settings.
4) Fixed an error exporting properties.
5) Fixed an error calculating the sum of purchase prices for an order.
1) The mbstring parameter has been removed during cron configuration.
2) Added the ability to export/import internal accounts and payer types for users.
3) Enhanced export with the "Group data by main table records" checkbox.
4) Fixed errors in xlsx file export.
5) Added the ability to send emails when creating users during the import process.
6) Fixed errors in xls file import.
1) Enhanced import of property values of the "List" type.
2) Enhanced cron settings.
1) Added the ability to export/import shipments.
2) Enhanced import of mail events.
3) Fixed a jQuery connection error.
4) Added protection against duplicate cron jobs.
5) Added the ability to download the export file to an FTP server.
6) Fixed an error exporting additional options for infoblock properties.
7) Added extended filtering parameters by ID, as well as filtering by complex logic for other fields.
8) Enhanced the "Group data by main table records" option.
1) Added a button to configure export/import via cron.
2) Removed product property fields from product import.
3) On the orders import page, added the ability to load order properties and configure identification based on these properties.
4) Fixed filtering errors during export.
1) Improved error output during import.
2) Added the ability to export/import the "Phone number for registration" field for users.
3) Added the ability to load files from Google Drive.
1) Fixed an error when creating a product export profile.
2) Added the ability to export/import the "Show in smart filter" option in the properties list.
3) Improved the creation of orders, carts, and payments.
1) Added support for the sotbit.seometa module's SEO URLs.
2) Added files to run export/import via cron.
1) Fixed performance issues with the filter on entity list pages.
2) Improved export of infoblock element properties.
3) Added the ability to export/import additional options for infoblock properties.
4) Added the ability to export the total purchase price sum of all products in an order.
5) Fixed an infinite export error.
1) Added the ability to export properties in the product list in the cart.
2) Added export/import of locations and location groups.
3) Improved database encoding check during module installation.
1) Improved import of infoblock properties.
2) Added integration with the sotbit.seometa module.
3) Added the ability to import a user's password hash.
4) Fixed errors reading import files.
1) Added the ability to import users with group binding.
2) Added the ability to export/import questions and answers for the aelita.test module.
1) Improved export/import of property bindings to sections.
2) Added the ability to export/import warehouses.
3) Improved error output during import.
1) Added the ability to export user groups.
2) Added the ability to group by records of the main table.
Added the ability to export/import user fields.
1) Export/import of property bindings to sections, order payments, products (only fields from the product catalog module), and cart rules has been added.
2) Pages with entity lists have been added.
3) Data export errors have been fixed.
4) Date and time filtering error has been fixed.
5) Some calculated fields for export have been added.
USER EXPERIENCE
How does this solution work in a real project? Share your experience and help others choose.
There are no reviews of this solution on git.ru yet. Tell us what worked well and what could be improved.
Verified purchaseAdd a key if you wish. A verified review gets a badge, priority placement and more rating weight.
Open to every clientJust sign in to your account. A key is optional; all reviews are moderated.
YOUR PROJECT INFRASTRUCTURE
FROM THE SAME DEVELOPER
esolutions.su
The module is designed for importing products and sections from XML, YML, and JSON files. It supports loading any product fields and properties, as well as updating stock levels and prices. Product-to-section binding is supported, along with importing section structures from a file into an arbitrary site structure.
The module is designed for importing orders or user carts from Excel files. Note that the module imports only one order per file. This solution is optimized for processing large orders containing hundreds of items, eliminating the need to add products manually. Supported capabilities: - Import of files in XLS, XLSX, and CSV formats. - Identification of products or trade offers by any field.
MORE FOR YOUR WEBSITE
The module is designed for importing products and sections from XML, YML, and JSON files. It supports loading any product fields and properties, as well as updating stock levels and prices. Product-to-section binding is supported, along with importing section structures from a file into an arbitrary site structure.
This module automatically optimizes images and converts them to WebP or AVIF formats for browsers that support these standards. Processing is performed locally without relying on external services. This approach helps improve site performance and aligns with SEO best practices.
The CleanTalk anti-spam module provides multi-level website security without the need for CAPTCHA. The system automatically blocks bot registrations, spam comments in forums and blogs, and spam in Progressive Media tree comments. Protection extends to private user messages, product reviews in 1C-Bitrix modern online stores, order forms, and any custom forms.
BEFORE YOU ORDER